How to Use Pabbly Connect to Add Cancelled Shopify Order Details to MySQL Database

Learn how to automate adding cancelled Shopify order details to your MySQL database using Pabbly Connect. Step-by-step tutorial included. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Introduction to Pabbly Connect for Shopify and MySQL Integration

In this tutorial, we will learn how to use Pabbly Connect to automate the process of adding cancelled Shopify order details to a MySQL database. Whenever an order is cancelled in Shopify, the details will be automatically recorded in your MySQL database. This integration streamlines your workflow and enhances data management.

To get started, you need to have a Pabbly Connect account. If you don’t have one, you can sign up for free. Once your account is set up, you can create a new automation workflow that connects Shopify with MySQL through Pabbly Connect.

2. Setting Up Your Workflow in Pabbly Connect

After logging into your Pabbly Connect account, navigate to your dashboard and click on the ‘Create Workflow’ button. Name your workflow, for example, ‘Shopify to MySQL’ and select the appropriate folder. This workflow will manage the automation process.

Once the workflow is created, you will see two windows: the trigger and action windows. The trigger window captures events from Shopify, while the action window sends data to MySQL. Here are the steps to set up the trigger:

• Search for the app ‘Shopify’ and select it.
• Choose the trigger event as ‘Order Cancelled’.
• Copy the provided webhook URL from Pabbly Connect.

After setting up the trigger, you need to configure your Shopify store to send cancellation data to Pabbly Connect. This is done by creating a webhook in your Shopify settings.

3. Configuring Shopify Webhook for Order Cancellation

To connect your Shopify store with Pabbly Connect, go to your Shopify admin panel, click on ‘Settings’, then ‘Notifications’. Scroll down to the webhooks section and click ‘Create Webhook’.

In the webhook creation window, select the following options:

• Event: ‘Order Cancelled’
• Format: JSON
• API Version: Latest

Paste the webhook URL you copied from Pabbly Connect into the URL field and click ‘Save’. This action will establish a connection between Shopify and Pabbly Connect, enabling it to receive cancellation data.

4. Sending Cancelled Order Details to MySQL

Now that your Shopify store is connected with Pabbly Connect, it’s time to send the cancelled order details to your MySQL database. In the action window of your workflow, search for ‘MySQL’ and select it.

Select the action event as ‘Insert Row’ and click on ‘Connect’. You will need to provide your MySQL database credentials, including:

Database Username Database Password Host Database Name Port

Once you enter these details, click on ‘Save’. After successful connection, select the correct table from your MySQL database where you want to insert the cancelled order details.

5. Mapping Cancelled Order Data to MySQL Fields

With your MySQL connection established, it’s time to map the data received from Shopify to the respective fields in your MySQL table. In the action window, you will see all columns from your selected table.

Map the cancelled order details from Shopify to the corresponding fields in your MySQL table, such as:

Order ID Customer Name Customer Email Total Amount

After mapping all necessary fields, click on ‘Save and Send Test Request’. Upon successful execution, you will see that the cancelled order details have been added to your MySQL database as a new record. This confirms that your Pabbly Connect automation is functioning correctly.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the addition of cancelled Shopify order details into a MySQL database. This integration simplifies data management and enhances operational efficiency. By following these steps, you can easily set up a similar automation for your needs.