How to Create Shopify Customers from MySQL Database Using Pabbly Connect

Learn how to automate the creation of Shopify customers from a MySQL database using Pabbly Connect. Follow this detailed step-by-step tutorial. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To create Shopify customers from a MySQL database, you need to access Pabbly Connect. Start by visiting the Pabbly Connect homepage by typing ‘Pabbly.com/connect’ in your browser.

Once on the homepage, you will see options to either sign in or sign up for free. If you’re a new user, click on the ‘Sign Up for Free’ button to create an account. Existing users can directly click on ‘Sign In’. After signing in, you will be taken to your dashboard, where all your workflows can be managed.

2. Creating a Workflow in Pabbly Connect

In this section, you will create a new workflow in Pabbly Connect to automate the process of adding customers to Shopify. Click on the ‘Create Workflow’ option from your dashboard.

• Provide a name for your workflow, e.g., ‘Create Shopify Customer from MySQL’.
• Select a folder for organizing your workflow, such as ‘E-commerce Store’.
• Click on the ‘Create’ button to proceed.

After creating the workflow, you will see two main sections: Trigger and Action. The Trigger section is where you will set up MySQL, and the Action section will be used to connect to Shopify.

3. Setting Up the Trigger with MySQL

Now, let’s configure the Trigger in Pabbly Connect. Select MySQL as your Trigger application and choose the trigger event ‘New Row in Table’. This event will activate your workflow whenever a new row is added to your MySQL database.

To establish the connection, click on the ‘Connect’ button. You will have options to add a new connection or use an existing one. If creating a new connection, enter the required database details such as username, password, host name, and database name.

• Select the table where new leads will be recorded, e.g., ‘New Leads’.
• Set the unique column (e.g., email) for identifying new customers.
• Click ‘Save’ and then ‘Send Test Request’ to ensure the connection is successful.

This will allow Pabbly Connect to capture the latest data from your MySQL database, which will be used to create customers in Shopify.

4. Connecting Shopify in Pabbly Connect

Next, we will set up Shopify as the Action application in Pabbly Connect. Choose Shopify and select the action event ‘Create Customer’. Click on the ‘Connect’ button to establish the connection.

If you need to create a new connection, you must provide your Shopify store’s subdomain and access token. To find your subdomain, navigate to your Shopify account, and it is the part of your store URL before ‘myshopify.com’. For the access token, create a new app in Shopify and configure the necessary API scopes for customer management.

Go to Shopify settings, then ‘Apps and Sales Channels’ and create a new app. Select the necessary scopes for customer access and save your changes. Copy the access token and paste it into Pabbly Connect.

Once the connection is established, you can map the customer details from the MySQL response to the fields in Shopify.

5. Mapping Data to Create Customers in Shopify

In this final step, you will map the data from MySQL to create customers in Shopify using Pabbly Connect. Start by mapping the first name, last name, email address, and phone number from the MySQL response.

Ensure that you select the corresponding fields from the previous step to dynamically insert the data. This will allow the automation to replace the information with each new submission from the MySQL database.

Map the first name and last name fields from the MySQL response. Map the email and phone number fields as needed. Click ‘Save’ and then ‘Send Test Request’ to create the customer in Shopify.

Once this is complete, you can check your Shopify account to confirm that the new customer has been added successfully. This integration will automate the process of adding customers from your MySQL database to Shopify, streamlining your e-commerce operations.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to create Shopify customers automatically from a MySQL database. By following these steps, you can efficiently manage customer data and enhance your e-commerce store’s automation.