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

Learn how to integrate WooCommerce with MySQL using Pabbly Connect for automated order details management. Step-by-step tutorial included. Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for WooCommerce Integration

To begin integrating WooCommerce with MySQL, you need to access Pabbly Connect. This integration platform allows you to automate workflows without coding skills. Simply sign in if you are an existing user or create a new account, which only takes a couple of minutes.

Once you’re logged in, you will find yourself on the dashboard. On the right side, click on the ‘Create Workflow’ button. You can name your workflow, for example, ‘Add WooCommerce Order Details in MySQL Database,’ and then click on ‘Create’ to proceed to the next step.

2. Setting Up the Trigger Event in Pabbly Connect

After creating your workflow in Pabbly Connect, the next step is to set up a trigger event. In this case, we will select WooCommerce as the trigger application. Click on the WooCommerce icon and choose the trigger event as ‘New Order Created.’

• Select WooCommerce as the trigger application.
• Choose ‘New Order Created’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.

This webhook URL will act as a bridge between WooCommerce and Pabbly Connect. After copying the URL, proceed to your WordPress dashboard to set up the webhook in WooCommerce settings.

3. Configuring WooCommerce Webhook for Integration

To configure the webhook in WooCommerce, navigate to the WooCommerce settings in your WordPress dashboard. Under the ‘Advanced’ tab, find the ‘Webhooks’ option to add a new webhook. Name it something recognizable, like ‘MySQL Webhook,’ and set the status to active.

• Set the topic to ‘Order Created.’
• Paste the copied webhook URL into the Delivery URL field.
• Select the latest API version, which is V3.

Once you have filled in these details, click on ‘Save Webhook.’ This action will allow WooCommerce to send order details to Pabbly Connect whenever a new order is created.

4. Mapping Order Details to MySQL Database

With the webhook set up, return to Pabbly Connect and click on ‘Recapture Webhook Response.’ This will enable the platform to listen for incoming data from WooCommerce. To test the setup, place a test order in WooCommerce.

After placing the order, you will see the captured response in Pabbly Connect. Next, choose MySQL as the action application and set the action event to ‘Insert Row.’ You will need to connect your MySQL database by entering the required details like database username, password, host, database name, and port.

5. Finalizing Integration and Testing the Workflow

Once the connection to MySQL is established, you will need to map the order details received from WooCommerce to the corresponding fields in your MySQL table. Ensure you select the correct table, such as ‘WooCommerce Orders,’ and map the fields like full name, email, product name, price, and date.

After mapping the fields, click on ‘Save and Send Test Request.’ If everything is set up correctly, you should see a success message indicating that the order details have been successfully added to your MySQL database. You can verify this by checking the MySQL table for the new entry.

Every time a new order is placed in WooCommerce, Pabbly Connect will automatically add the order details to your MySQL database, streamlining your order management process.

Conclusion

Integrating WooCommerce with MySQL using Pabbly Connect allows for seamless automation of order details management. This tutorial covered the exact steps to set up the integration effectively.