How to Add BigCommerce Order Details in Airtable Using Pabbly Connect

Learn how to integrate BigCommerce with Airtable using Pabbly Connect to automatically add order details for multiple products. Follow this step-by-step tutorial. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To integrate BigCommerce with Airtable, we will use Pabbly Connect. Start by visiting the Pabbly Connect website where you can either sign up for a free account or log in if you already have one.

Once logged in, navigate to the Pabbly Connect dashboard. Here, you can create a new workflow that will automate the process of adding order details from BigCommerce into Airtable.

2. Creating a New Workflow in Pabbly Connect

In the Pabbly Connect dashboard, click on the ‘Create Workflow’ button. You will be prompted to name your workflow. For this integration, name it something descriptive like ‘Add BigCommerce Order Details to Airtable’. using Pabbly Connect

• Select BigCommerce as the trigger application.
• Choose ‘New Order Created’ as the trigger event.
• Connect your BigCommerce account to Pabbly Connect by entering your API credentials.

After saving your trigger setup, Pabbly Connect will wait for a new order event from BigCommerce to proceed with the workflow.

3. Setting Up BigCommerce Trigger in Pabbly Connect

To set up the BigCommerce trigger, you need to connect your BigCommerce account to Pabbly Connect. This involves entering your Client ID, Access Token, and Store Hash Key from BigCommerce.

Once connected, perform a test by creating a new order in your BigCommerce store. This action will send the order details back to Pabbly Connect, allowing you to proceed with the next steps in your workflow.

4. Action Steps to Retrieve Order Details

After successfully receiving the order details, the next step is to retrieve the order and product details. For this, add a new action step in Pabbly Connect and select BigCommerce again.

• Choose ‘Get Order by ID’ as the action event.
• Map the Order ID received from the trigger to fetch detailed order information.
• Save the action and test it to ensure that order details are retrieved correctly.

This step is crucial as it allows you to gather all necessary information about the order, including customer details and product specifics.

5. Finalizing Integration with Airtable

Now that you have the order details, the final step is to send this data to Airtable. In Pabbly Connect, add a new action step and select Airtable as the application.

Choose ‘Create Record’ as the action event. You will need to connect your Airtable account by providing the API token and selecting the base and table where you want the order details to be stored.

Map the fields from the previous steps, such as customer name, order ID, product name, quantity, and total amount. Finally, test the action to ensure that the order details are correctly added to your Airtable database.

Conclusion

Using Pabbly Connect, you can seamlessly integrate BigCommerce with Airtable to automate the addition of order details for multiple products. This integration enhances efficiency and ensures accurate record-keeping for your business.