Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello, 

I would just like to be able to split the product quantities in Woocommerce "Line Items Quantity: 2,1" into 2 different columns in Monday : 

 

 

And that it also works when I only have one product (because the last solution I tried duplicated the quantity of one product ordered to the other product even if there was only one product ordered)

I've been reading all the threads that are similar to my problem for 2 days now and have tried many different methods but nothing has happened. I am starting to despair...

Thank you for your help! :)

Hi @Jungle Feed 

You can use a formatter step to split text at the comma into separate fields: https://zapier.com/help/create/format/get-started-with-formatter 

Hello @GetUWired , 

Thank you for your quick answer. As I said in my message, I have already tried this solution: the problem is that it only works when I receive an order with 2 different products... 

 

The problem is that it only works when I receive an order with 2 different products... Indeed, when the order contains only one product reference, the quantity ordered of this product is duplicated in the 2 columns (whereas I should have either an empty field or the number 0 in the column that represents the product not ordered) 

 

Thank you in advance for your help 

you should an option to split into individual fields which would result in fields like output item 1, output item 2, etc.. you would then map these fields as opposed to output item 1 & output item last. 

Hello @GetUWired , 

I have tried your solution but I can't get it to work... Could you please tell me more about the procedure? 

Thanks a lot! 

Example with 2 inputs 

Output with just 1 item as an input. Notice the item 2 field is not present 

 

Terms & Conditions