Watch Step By Step Video Tutorial Below






1. Accessing Pabbly Connect for Shopify Order Sync

To create a Shopify Order Sync System, start by accessing Pabbly Connect. This platform is essential for integrating your Shopify store with Google Sheets to automate order processing.

Visit pabbly.com/connect and click on “Sign Up Free” to create an account. Once registered, log in to access the dashboard, where you can initiate your workflow for syncing orders.


2. Creating a Workflow in Pabbly Connect

In your Pabbly Connect dashboard, click on “Create Workflow” to start setting up your integration. This is where you will define how Shopify interacts with Google Sheets.

  • Click on “Add Trigger”.
  • Select “Shopify V2” as your application.
  • Choose the event “New Order”.

After selecting the trigger, click on “Connect” to generate a webhook URL. Copy this URL as you will need it for your Shopify settings.


3. Setting Up the Shopify Webhook

Now, navigate to your Shopify store. In the left sidebar, go to “Settings” and then select “Notifications”. Here, you will configure the webhook to connect with Pabbly Connect.

  • Click on “Create Webhook”.
  • Select “Order Creation” as the event.
  • Set the format to JSON and paste the webhook URL from Pabbly Connect.

Save your settings. This establishes a connection between Shopify and Pabbly Connect, allowing order data to be sent directly to your workflow.


4. Testing the Integration

To ensure your integration works correctly, make a test purchase on your Shopify store. Once the transaction is completed, Pabbly Connect should capture the order details automatically.

Check your Pabbly Connect workflow to see if the data has been received. If successful, you will see the order details displayed in the interface, confirming that the integration is functioning as intended.


5. Adding Order Data to Google Sheets

Next, you need to add the order details to Google Sheets. In your Pabbly Connect workflow, click on “Add Action” and select “Google Sheets” as the application.

Choose the event “Add New Row” and connect your Google account. After granting permissions, specify the spreadsheet and worksheet where you want the order data to be stored.

  • Map the order details from Shopify to corresponding columns in Google Sheets.
  • Ensure to include fields like Order Number, Customer Name, Email, and Total Amount.

After mapping the data, save your workflow. Now, every time an order is placed, the details will be automatically added to your Google Sheets.


Conclusion

In this tutorial, you learned how to build a Shopify Order Sync System using Pabbly Connect. By following these steps, you can automate the order processing and ensure all details are logged in real-time.