How to Add BigCommerce Order Details in MS Excel Using Pabbly Connect

Learn how to automate the addition of BigCommerce order details in MS Excel using Pabbly Connect. Step-by-step guide for seamless integration. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

Accessing Pabbly Connect for BigCommerce and MS Excel Integration

To automate the addition of BigCommerce order details into MS Excel, you first need to access Pabbly Connect. This powerful integration platform enables seamless connections between various applications without needing coding skills.

Visit the Pabbly Connect homepage by entering the URL in your browser. Here, you can either sign in if you are an existing user or sign up for free if you are new. New users receive 100 free tasks every month to explore the platform.

Creating a New Workflow in Pabbly Connect

After signing in to Pabbly Connect, navigate to the dashboard where you can manage your workflows. To create a new workflow, click on the ‘Create Workflow’ button, and a dialog box will appear.

Provide a name for the workflow, such as ‘Add BigCommerce Order Details to MS Excel for Multiple Products,’ and select a folder to save it. This will help you organize your workflows effectively. Once done, click ‘Create’ to proceed.

Setting Up Trigger and Action with BigCommerce and MS Excel

In your newly created workflow, you need to set up a trigger and an action. For this integration, select BigCommerce as the trigger application and choose ‘New Order Created’ as the trigger event. This event will initiate the workflow whenever a new order is placed. using Pabbly Connect

• Select ‘BigCommerce’ as the trigger application.
• Choose the trigger event ‘New Order Created’.
• Click ‘Connect’ to establish a connection with your BigCommerce account.

Next, you will need to enter your BigCommerce API details including client ID, access token, and store hash key. These details can be found in your BigCommerce account settings under API accounts. After entering these details, click ‘Save’ to establish the connection.

Testing the Integration with a New Order

Once the connection is established, it’s time to test the integration. Place a test order in your BigCommerce store to generate a new order. This will help verify that the workflow is functioning correctly within Pabbly Connect.

After placing the order, return to Pabbly Connect and click on ‘Save and Send Test Request’. This action will fetch the order details from BigCommerce, allowing you to see if the data is correctly captured.

Adding Order Details to MS Excel

After successfully retrieving the order details, the next step is to add them to MS Excel. Select Microsoft Excel as your action application and choose the action event ‘Add Row to Worksheet’. This will allow you to automatically add the new order details into your Excel sheet. using Pabbly Connect

• Choose ‘Microsoft Excel’ as the action application.
• Select ‘Add Row to Worksheet’ as the action event.
• Map the retrieved order details to the corresponding fields in your Excel sheet.

Finally, click on ‘Save and Send Test Request’ to add the order details to your Excel sheet. You should see the newly added row with all the relevant order information, confirming that the integration is working as expected.

Conclusion

In this tutorial, we explored how to automate the addition of BigCommerce order details in MS Excel using Pabbly Connect. By following these steps, you can efficiently manage your order data without manual entry, ensuring accuracy and saving time.