About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Split Line Items in Shopify Order by Vendor

  • 13 May 2021
  • 5 replies
  • 410 views
M
Userlevel 2

Hello, I created a zap to send an email to our suppliers from a Shopify order, but if there are multiple vendors in one order it sends an email with all the products to all vendors in that order. I would like to be able to split the email into multiple emails, with each vendor only getting the line item in an email that is relevant to them. Or at least not display the irrelevant items to vendors who don’t need the data for items they don't dropship as to not confuse them with more products than they need to fulfill.

This is the code that splits the line items so it is easier to read, and the previous step is a filter that reads the vendor and only continues to the email relevant to that vendor. 

If anyone has any ideas of how to send an email to each vendor with only the line item relevant to that vendor from one order please let me know! 

Thanks

-Mike

icon

Best answer by GetUWired 13 May 2021, 22:40

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

GetUWired
Userlevel 7
Badge +12

Hi @Mikemo77 

I think you could remove your filter and handle the mapping in the code step. Do you know which line item would go to which vendor? Just by filtering off sku or name? If so, you can manipulate your code step to create associations for each vendor. 

Then for your output, you would output an array of objects. Each object would relate to a different vendor. Zapier will handle it as a loop and send an email for each object returned in the array. 

M
Userlevel 2

Thanks for the reply! I can add an input data that pulls the line item vendor from the Shopify order data, and that would be who it needs to be sent to. I only have limited experience with writing code so I’m not quite sure how I would create an output array that would separate into different emails for each vendor. Right now I have a zap for each individual vendor with a filter before the code that only continues if “line item vendor contains” “vendor name” then sends that entire order to each vendor in that order. So one order fires multiple zaps but they all contain the same info and go to different places. 

Here is an example of another orders output with 2 items, but these 2 have the same vendor. If these were 2 different vendors how would I send one line item to one email and one email to the other?

GetUWired
Userlevel 7
Badge +12

Hi @Mikemo77 

If you’d like to hire us to write that out for you and consolidate everything into 1 zap. Feel free to shoot me a direct message. 

Otherwise, to only send and email with line items related to the vendor would just take a quick modification to your code.

Add vendors into your inputData then In your qtys.forEach(qty) loop. you will just need to add an if statement that checks to see if the vendor is the vendor of interest.

The output of which will just be the line items that had the vendor matching the if statement

 

M
Userlevel 2

Hey @GetUWired , 

I think I got it to work with the information you provided, I really appreciate it! If I run into any problems I’d be happy to hire you in the future. Ill let you know. 

Thanks

-Mike

GetUWired
Userlevel 7
Badge +12

Love It!

Glad you got it working!

Terms & Conditions