How to Add Shopify Order Details in MySQL Database Using Pabbly Connect

Learn how to integrate Shopify with MySQL using Pabbly Connect to automatically add new order details to your database. Follow this step-by-step guide for seamless automation.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Shopify and MySQL Integration

To add Shopify order details in MySQL database, you need to set up Pabbly Connect first. Begin by signing into your Pabbly Connect account. If you don’t have an account, you can create one for free, which includes 100 tasks at no cost.

Once logged in, navigate to the ‘Pabbly Connect’ section on your dashboard. Click on the ‘Create Workflow’ button to initiate a new workflow. Name your workflow ‘Add Shopify order details in MySQL database’ to keep everything organized.

2. Triggering New Orders from Shopify

The next step involves setting up the trigger for your workflow. In Pabbly Connect, select Shopify as the trigger application. Choose the trigger event as ‘New Order’. This means that every time a new order is placed, the workflow will be activated.

After selecting the trigger event, you will receive a webhook URL. This URL is crucial as it connects your Shopify account with Pabbly Connect. Follow these steps to set up the webhook in Shopify:

• Go to Shopify settings and select Notifications.
• Click on ‘Create Webhook’.
• Set the event to ‘Order Creation’ and the format to JSON.
• Paste the webhook URL from Pabbly Connect and save.

Once saved, your Shopify account will now send order details to Pabbly Connect whenever a new order is made.

3. Placing a Dummy Order in Shopify

To test the integration, place a dummy order in your Shopify store. Select a product, fill in the necessary details, and proceed to payment. Use dummy payment details to complete the transaction. This action will trigger the webhook you set up earlier.

After placing the order, return to Pabbly Connect. You should see a response indicating that the new order details have been received. This response will include essential information such as product name, price, and customer details.

4. Inserting Order Details into MySQL Database

Now that the new order details are captured in Pabbly Connect, the next step is to insert these details into your MySQL database. For this, select MySQL as the action application in your workflow.

Choose the action event as ‘Insert Row’. This will allow you to add a new row in your connected MySQL database. Establish a connection between MySQL and Pabbly Connect by entering your database credentials, including username, password, host, and database name.

Once connected, select the appropriate table in your MySQL database where the order details will be stored. Map the fields such as full name, email, product name, price, and order date from the Shopify order response to the corresponding MySQL columns. Finally, click on ‘Save and Send Test Request’ to confirm the integration works correctly.

5. Verifying the Integration Success

After executing the test request, check your MySQL database to verify that the order details have been successfully inserted. You should see the new entry with all mapped fields filled accurately.

This successful integration means that every time a new order is placed in Shopify, Pabbly Connect will automatically capture the order details and insert them into your MySQL database. This automation saves time and ensures accurate record-keeping without manual entry.

Conclusion

This guide summarizes the key points and helps you understand the essential features and benefits of using this tool.

In conclusion, using Pabbly Connect to integrate Shopify with MySQL allows you to automate the process of adding new order details seamlessly. This tutorial has guided you through each step, ensuring a successful setup for your e-commerce operations.