How to Log Customer Orders from BigCommerce to Airtable Using Pabbly Connect

Learn how to log customer orders from BigCommerce to Airtable for inventory management using Pabbly Connect. Follow this detailed step-by-step tutorial. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To log customer orders from BigCommerce to Airtable, we will use Pabbly Connect. Begin by visiting the Pabbly Connect landing page by entering ‘Pabbly.com/connect’ in your browser.

On the Pabbly Connect page, you will see options to sign in or sign up for free. If you’re new, click on the ‘Sign up for free’ button to create an account. Existing users should click ‘Sign in’ to access their accounts.

2. Creating a New Workflow in Pabbly Connect

Once logged into Pabbly Connect, click on the ‘Create Workflow’ button. You will be prompted to choose a workflow builder. Select the ‘New Workflow Builder’ for a modern interface.

• Click on ‘Create Workflow’.
• Enter a workflow name, e.g., ‘Customer Orders from BigCommerce to Airtable’.
• Select a folder to save your workflow.

After naming your workflow, click on the ‘Create’ button. This action opens the workflow window, where you will define the trigger and action for your integration.

3. Setting Up the Trigger for BigCommerce

In this step, we will set BigCommerce as the trigger application in Pabbly Connect. Click on the ‘Add Trigger’ button and search for BigCommerce.

Select the trigger event as ‘New Order Created’ and click ‘Connect’. You will need to add a new connection by entering your store’s hash key, client ID, and access token obtained from your BigCommerce account.

• Go to your BigCommerce account settings.
• Create a new API account to get your credentials.
• Copy the store hash key from the API path.

Once you have entered all the credentials, click on ‘Save and Send Test Request’. This will initiate the connection and wait for a web response.

4. Getting Customer Details from BigCommerce

After setting up the trigger, the next step is to retrieve customer details using the order ID captured from the trigger. In Pabbly Connect, click on ‘Add Action Step’ and select BigCommerce again.

Choose the action event as ‘Get Order by ID’ and connect using your existing connection. Instead of entering the order ID manually, use the mapping feature to dynamically insert the order ID from the previous step.

Map the order ID from the trigger response. Click ‘Save and Send Test Request’ to retrieve customer details. Verify that all relevant customer information is displayed.

With the customer details available, we can now proceed to log this information into Airtable.

5. Logging Customer Orders to Airtable

To log customer orders into Airtable, click on ‘Add Action Step’ and select Airtable as the action application. Choose the action event as ‘Create Record’ and connect to your Airtable account. using Pabbly Connect

Grant the necessary permissions and select the base and table where you want to log the data. Use the mapping feature to map customer details such as first name, last name, email, and address into the corresponding fields in Airtable.

Map all relevant customer fields from the previous step. Click on ‘Save and Send Test Request’ to confirm the integration. Check your Airtable database to ensure the information is logged correctly.

With this setup, every new order from BigCommerce will automatically populate the details in Airtable, streamlining your inventory management process.

Conclusion

In this tutorial, we demonstrated how to log customer orders from BigCommerce to Airtable using Pabbly Connect. This integration allows for efficient inventory management and real-time updates. By following the steps outlined, you can automate your workflow and enhance your business operations.