Hello, Are you available for a chat? I just went through your shared website design and Sql database design.
I am a full-stack developer with over 8 years of experience in WordPress and WooCommerce web development, HTML, CSS, MySql, and PHP, as well as front-end frameworks such as Bootstrap.
I can redesign your existing WordPress website with WooCommerce integration according to the specifications provided in the images, including a single-page layout with menu items directing to anchor points, an animated image as the banner element, 9 questions sequentially with a "next" button, and images, text, or sliding scales; design inspiration provided (Wizarding World Registration); and users required to sign in/register, final page to collect user addresses and payment information, users providing star ratings with personalized welcome text; and generating a custom QR code leading to the user's rating page with pre-filled order number, including an animated banner and QR code, design the database to accommodate future API integrations for warehouse/shipping purposes, Backend functionality to manually assign sample_order_id to a new product_id, Pop-up window for visitors outside the shipping region, prompting email/name collection, and hosting services provided by GoDaddy as per your needs.
TRY ME once, and you will definitely come back with a new project.
Best Regards.
Shivah Webtech..!!