How to Add Cancelled Shopify Order Details in PostgreSQL Using Pabbly Connect

Learn how to automate adding cancelled Shopify order details in PostgreSQL using Pabbly Connect. Step-by-step tutorial with detailed instructions. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Shopify to PostgreSQL Integration

To begin automating the process of adding cancelled Shopify order details in PostgreSQL, you first need to set up Pabbly Connect. This platform will facilitate the integration between your Shopify store and PostgreSQL database.

Start by signing up for a free account on Pabbly Connect. Once logged in, navigate to the dashboard and click on the ‘Create Workflow’ button. Name your workflow, for instance, ‘Shopify to PostgreSQL’, and select the appropriate folder for your automation.

2. Configuring the Trigger Step in Pabbly Connect

In this step, you will configure the trigger that will activate whenever an order is cancelled in Shopify. To do this, select Shopify as the application in the trigger window and choose the version two of Shopify.

• Choose ‘Order Cancelled’ as the trigger event.
• Copy the webhook URL generated by Pabbly Connect.
• Go to your Shopify account settings and navigate to Notifications.
• Create a new webhook and paste the copied URL.

After saving the webhook, Pabbly Connect will be ready to receive order cancellation details from your Shopify store. Test this setup by cancelling an order to ensure that the trigger works correctly.

3. Capturing Order Details from Shopify

Once the order is cancelled in Shopify, Pabbly Connect will capture the details of the cancelled order. This includes the total amount, customer name, email address, and product details.

To view the captured data, check the response in the Pabbly Connect workflow. You should see all relevant details, such as:

• Total price of the order.
• Customer’s address and contact information.
• Product name and quantity.

This data is crucial as it will be sent to your PostgreSQL database in the next steps. Ensure that all details are accurately captured to maintain data integrity.

4. Inserting Data into PostgreSQL Using Pabbly Connect

Now that you have the order details, it’s time to insert this data into your PostgreSQL database. In the action step of your Pabbly Connect workflow, select PostgreSQL as the application.

Choose the action event as ‘Insert Row’. Connect your PostgreSQL account by entering the required credentials. This includes the username, password, host name, and database name. Once connected, select the table where you want to insert the cancelled order details.

Map the order ID from Shopify to the corresponding field in PostgreSQL. Include customer details like name, email, and phone number. Add product details and cancellation reason.

After mapping all fields, click on ‘Save and Send Test Request’. This will send the data to PostgreSQL, confirming that your integration is working as intended.

5. Testing the Integration and Confirming Success

To ensure everything is functioning correctly, perform a test by cancelling another order in Shopify. Check your PostgreSQL database to confirm that the new record has been added with the correct details.

Once you refresh your PostgreSQL table, you should see the new cancelled order entry. This indicates that the automation between Shopify and PostgreSQL via Pabbly Connect is successful.

By following these steps, you can automate the process of adding cancelled Shopify order details into PostgreSQL efficiently. This integration allows for streamlined order management and improved data accuracy.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to automate the addition of cancelled Shopify order details into PostgreSQL. By following the outlined steps, you can enhance your e-commerce operations effectively.