We are looking for a WordPress developer to help us build a registration process for our website and connect it to our MySQL database. The registration process should include sign-in, email verification, and user details such as website name, Amazon affiliate tags, and billing information. The user should be able to choose a package with pricing options and pay (or choose the free package) through paddle.com. Upon completion of the registration process, the user should receive a token for use with our Gizzmo plugins. Additionally, the registration process needs to be connected to our MySQL database to store user information and website settings.
Build a registration process from sign-in to payment and token generation.
Implement email verification using Klaviyo or Mailchimp integration.
Develop a "My Account" page for users to manage their information and settings.
Connect the registration process to our MySQL database and store user information and website settings.
Ensure the registration process is responsive and mobile-friendly.
When the user enters the Gizzmo website, they will click on the "Sign-In" button to initiate the registration process. This will open a pop-up window where they will be prompted to enter their email, name, and create a password for simple registration. The user can also create a new account by connecting with their Google account.
After the user submits their registration information, they will receive an email from Gizzmo with a verification link. The email verification process will be implemented using Klaviyo or Mailchimp integration. Once the user clicks on the verification link, they will be redirected to the "My Account" page.
"My Account" Page:
The "My Account" page is where the user will provide additional details about themselves, such as website name, Amazon affiliate tags, and billing information. The user should be able to edit this information at any time.
The user will have the option to choose a package with different pricing options. The pricing model will be available on the homepage, and a pricing option should be added to the settings as well. The package selection should be saved once the user confirms their choice.
If the user chooses a paid package, they will be redirected to a checkout page, where they can pay using paddle.com. Once the payment is complete, the user will be returned to the site with their chosen package updated.
After the user completes the registration process, they will receive a token that they can use with Gizzmo plugins. The token should be generated by code.
MySQL Database Connection:
The registration process needs to be connected to the MySQL database to store user information and website settings. To connect to the Gizzmo MySQL database, the following steps should be followed:
Create a new table "wp_accounts" to store the user's name, email, password, and status (active or inactive).
Create a new table "wp_websites" to store the website's domain, package, token (generated by code), and status (active or inactive).
Create a new table "wp_accounts_websites" to store the relationship between the user and the website (one account can have multiple websites).
Create a new table "wp_websites_affiliate_tags" to store the website's affiliate tags (a website can have multiple affiliate tags), default (true or false), and status (active or inactive).
Create a new table "wp_websites_settings" to store the website's settings
Posted On: April 30, 2023 05:46 UTC
Category: Full Stack Development
Skills:MySQL, API Integration, WordPress
click to apply
WordPress customization – Upwork