BigCommerce to Monday.com create item then subitem to it

[ec_206]

Your Task History ID

IjU3NjYwNTZiMDYzMDA0MzU1MjZlNTUzMDUxMzUi_pc

We've successfully created an item with values based on new order from BigCommerce, however need to also create a subitem to parent item just created with other values from the same BigCommerce order. I created another action under the "Create Item" (screenshot), but am having to select the "Parent Item" manually. I don't think this is the way to do it. I also don't see the Subitem columns to map additional values from the order. Any help would be great.

Here's what we'd like:
1. Create Item (Parent)
2. Add values from the order (Billing Name, Quantity, Number of items, Order date, Shipping Method)
3. Create Subitem under newly created parent
4 Add additional values from the order (Product name, Quantity, Width/Height etc.)

 

[Preeti Paryani]

Hello @ec_206,

Thanks for sharing the details.

You can dynamically map the ID of the newly created parent item by enabling the Map toggle beside the Parent Item ID field, this will allow you to use the ID from the previous Create Item step instead of selecting it manually. Please refer to the attached screenshot for better clarity.

Regarding the columns for the subitems, could you please confirm if those are custom columns? This will help us guide you better on how to map additional values from the order into the subitem.

 

[ec_206]

Thanks you @Preeti Paryani I will check with my client on those columns. I believe they are custom though.

 

[ec_206]

Hi @Preeti Paryani I confirmed these are custom columns. We'd need to add data to these from the BigCommerce order. Please let me know what our options are to accomplish this.

 

[ArshilAhmad]

Pabbly

connect.pabbly.com

Is your issue related to custom fields not appearing in the 'Create Subitem' action step?

 

[ec_206]

Hi @ArshilAhmad, correct!

 

[Preeti Paryani]

Hello @ec_206,

We have escalated this concern to our technical team to update the action. Kindly allow us some time, and we will get back to you as soon as we receive any updates.

 

[ec_206]

Thank you so much @Preeti Paryani we really appreciate it!

 

[Preeti Paryani]

Hello @ec_206,

Thank you for your kind words.

Just a quick update — we haven’t received any response from our team yet, but we’ve followed up with them again. We’ll be sure to let you know as soon as we hear back.

 

[ec_206]

Thank you for the update @Preeti Paryani

 

[Preeti Paryani]

Hello @ec_206,

Thank you for your patience.

We’re glad to inform you that our team has made some updates to the Create Sub Item action—custom columns are now available under this step. After mapping the Parent ID from the Create Item step, if you don’t see the custom columns immediately, please click the Refresh button once to load them properly.

Feel free to let us know if you face any issues—we’re here to help!

 

[ec_206]

This is great news @Preeti Paryani I will test this out. Thank you!

 

[Preeti Paryani]

Hello @ec_206,

Sure, please take your time and let us know if the action works fine for you.

 

[ec_206]

Hi @Preeti Paryani I see the new subitem fields and updated the flow. When I run Save & Send Test Request the response is received, but the subitem isn't being added under the parent item in Monday. I did another test order in BigCommerce and the Item (parent) is being created, but still no subitem. Can you take a look.

 

[Preeti Paryani]

Hello @ec_206,

Could you please confirm the types of custom columns you're using for the subitem creation? For example, let us know whether they are text, numbers, status, dropdowns, etc

 

[ec_206]

Hi @Preeti Paryani we just reached out to our client and asked for the information. I will let you know as soon as we hear back from them.

 

[ec_206]

Hi @Preeti Paryani here are the Subitem column types:

Status

• Product
• Shape
• Laminate
• Material
• Profile
• Proof Request

Number

• Quantity
• Kisscut

Text

• Size

 

[Preeti Paryani]

Hello @ec_206,

Thank you for sharing the details. I have forwarded them to the relevant team. As soon as I receive an update from their end regarding the issue, I will promptly update you.

Thanks for your patience.

 

[ec_206]

Thanks again @Preeti Paryani, appreciate the help! I think we're getting close.

 

[Resham]

Hope you're doing well.

We are now supporting all the available custom fields as outlined in the API documentation. Kindly review and let us know if there’s anything else we can assist you with.

Looking forward to your response.