Hello all,
I am trying to achieve the following - lets say I have a Sales Order.
Sales Order contains 5 products, from 3 vendors.
Product 1 - Vendor A
Product 2 - Vendor A
Product 3 - Vendor B
Product 4 - Vendor C
Product 5 - Vendor C
What I want is the following - one Zap started via a webhook which creates total of 3 Purchase Orders
PO 1 - Vendor A
Product 1
Product 2
PO 2 - Vendor B
Product 3
PO 3 - Vendor C
Product 4
Product 5
The problem is that
- I need to loop the vendors in the product line items in the SO, but only take unique values
- Then for each value I need to loop through the line items but pick only the ones that are related to a vendor
I tried the AI in Zapier, but he was working for over two hours back and forth and he did not provide any results.
Any advice or ideas are most appreciated and welcome.
Thank you
