Based on your requirement I will definitely Fix the Referral link issue that you facing and connect all pages to DB.
Please connect with me via chat and provide some information..
I am proficient in (Designing & Development). My strongly grip CMS development (WordPress, Shopify, Big Commerce, Wix, Webley, Magneto, Squarespace, Joomla etc.). and further, My having commands on PHP(Laraval), Node JS, Next JS, JavaScript, Angular, Html CSS, UI | UX design, front and backend development | SEO standards etc.
Thanks