Workflow not capturing new response - BigCommerce New Order

[ec_206]

Your Workflow URL

https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTZiMDYzMDA0MzU1MjZlNTUzMDUxMzUi_pc

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

For some reason our BigCommerce > Monday.com automation isn't receiving new order response from BigCommerce when re-capturing on the first step. The automation itself is running as order data is flowing into Monday.com. I've submitted several test orders and it's stuck on G.

 

[Preeti Paryani]

Hello @ec_206,

Could you please attempt to set up a new workflow to capture the orders from BigCommerce? If the order is successfully captured, you can copy and paste the subsequent steps from your current workflow, ensuring that you save them in the correct sequence.

P.S. Please create the workflow from scratch instead of cloning it.

 

[ec_206]

Thanks @Preeti Paryani. Will do!

 

[ec_206]

Hi @Preeti Paryani that worked. However, when I ran a test order from BigCommerce, it seems that both the old automation and new one are both running as two Items were created in Monday.com. I have the old automation disabled (attachment) so not sure what is causing this unless the steps are tied together when I copied them from the original workflow to the new one? I don't see a way to delete the old automation.

 

[Preeti Paryani]

Hello @ec_206,

Upon checking the workflow history, it appears that two BigCommerce orders — Order #137 and Order #138 — were processed successfully. A Monday.com item and subitem were created for each of them as expected. There doesn’t seem to be any duplicate creation in the workflow history.

 

[ec_206]

Thanks @Preeti Paryani. We were testing this same workflow from our agency account. I deleted it and only one item is added now.

The issue now is the Subitem isn't being created. I re-captured the webhook again and went through and tested each step in the entire workflow. All lookup tables return success and no errors when I save/test the final Add SubItem action.

Pabbly

connect.pabbly.com

 

[Preeti Paryani]

Hello @ec_206,

Thank you for clarifying the issue.

Upon checking, it appears that the error is occurring under the “Create Subitem” action. As shown in the attached image, certain fields are marked as required at the application level, but no data has been mapped to them.

As a result, the action failed and returned an error. Please review the error details under the response section (Res 3) to identify which specific field(s) need to be filled in to resolve the issue.

 

[ec_206]

Thanks @Preeti Paryani after research it was the second lookup table (label > value) that I made a mistake on. Also fixed an issue with the last lookup table I found in the task history. Just ran a test order and everything worked fine.

My next question is how to handle orders with multiple products (create multiple subitems)? I watched some Pabbly training videos and it looks like data transformer and line itemizer might work for this?

 

[Preeti Paryani]

Hello @ec_206,

Could you please elaborate on your use case? For multi-item orders, how exactly should the data be transferred to Monday.com?

 

[ec_206]

Hi @Preeti Paryani. If an order has multiple products (product A, product B), how would we create a subitem for each one?

 

[ArshilAhmad]

For this use case you need to add the 'BigCommerce: Get Product by Order Id' action step after the 'Monday.com: Create Item' action step.

Display 'Simple Response' and capture the response in form of a JSON.

Then add an Iterator and a JSON Extractor to your workflow, and in the following steps, map the values from the Iterator and the JSON Extractor.

Please check out this reference workflow we have set up on your behalf. You can make similar changes in your original workflow.

Pabbly

connect.pabbly.com

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[ec_206]

Thanks so much @ArshilAhmad. I will test this out!

 

[Preeti Paryani]

Let us know how it goes.