# Multiple products and vendors, yet 1 single order. How to send a unified order via email?
**URL:** https://community.glideapps.com/t/multiple-products-and-vendors-yet-1-single-order-how-to-send-a-unified-order-via-email/6255
**Category:** Ask for Help
**Created:** [April 1, 2020, 6:24pm UTC](https://community.glideapps.com/t/multiple-products-and-vendors-yet-1-single-order-how-to-send-a-unified-order-via-email/6255 "2020-04-01T18:24:24Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Domen\_Kert](https://community.glideapps.com/u/Domen_Kert)
#### Post date: [April 1, 2020, 6:24pm UTC](https://community.glideapps.com/t/multiple-products-and-vendors-yet-1-single-order-how-to-send-a-unified-order-via-email/6255/1 "2020-04-01T18:24:24Z")
Hey all!
I’m working on [lokalnahrana.org](http://lokalnahrana.org), an app that lets people easily find local food producers all over Slovenia ([localfood.glideapp.io](http://localfood.glideapp.io) is the stripped down English version, which was recently featured).
What I’m currently tackling and need your help with is this:
So far people can find the food they want and order it either via phone or email. Or click to the online store of the producer (1 out of 300…).
Now I connected Stripe and made it possible to buy via the app. This creates a problem. People will add several products, and quite possibly from different producers. That’s fine. What I cannot get around is how do I automate the email/notification part.
I created a separate sheet, which copies the “App:Sales” sheet, but adds crucial info like email of the producer and telephone number.
**How do I make it so, that the order of 1 person (say 10 items, from 3 producers), is bulked together into 3 separate orders (in the message, that is) and sent to 3 different producers?**
I know there must be some sort of google sheets magic. Someone suggested using Rollup on Airtable… there’s also a rollup function within Glideapps, but no idea how to use it.
Any thoughts? 😃
@Tim_Sullivan?
@Jeff_Hager?
@George_B?
@Drearystate?
---
### Author:  [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)
#### Post date: [April 1, 2020, 8:14pm UTC](https://community.glideapps.com/t/multiple-products-and-vendors-yet-1-single-order-how-to-send-a-unified-order-via-email/6255/2 "2020-04-01T20:14:00Z")
I saw a post yesterday about overcoming push notifications. Take a look at that. The process described there may be of some assistance. I personally have no experience with what you’re trying to accomplish, but this may help.
> [@Free push notifications Workaround](https://community.glideapps.com/t/free-push-notifications-solved/6183):
>
> I have a solution for PUSH NOTIFICATIONS. It works with IOS and ANDROID. It is quick and has ZERO cost to everyone. You can do this in your google sheet or a separate sheet that is linked to your original (I used 4 linked sheets, I’ll explain later). 1st you setup on your sheet a variable or value you are wanting to trigger the notification. This data will need a VLOOKUP formula to link to the person you want notified’s phone number and phone carrier, so when the vlaue on the sheet is found usin…
---
### Author:  [@Domen\_Kert](https://community.glideapps.com/u/Domen_Kert)
#### Post date: [April 1, 2020, 8:21pm UTC](https://community.glideapps.com/t/multiple-products-and-vendors-yet-1-single-order-how-to-send-a-unified-order-via-email/6255/3 "2020-04-01T20:21:42Z")
Hey Tim, thanks for chipping in. I read that and I’m not sure it helps. Or at least, I am not proficient enough to know whether or not it _could_ help.
What I want is to lump together a buyer’s order (which is made into separate rows in App:Sales, 1 for each different), into one entire order, and then send that to the seller.
Makes sense?
---
### Author:  [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)
#### Post date: [April 1, 2020, 8:28pm UTC](https://community.glideapps.com/t/multiple-products-and-vendors-yet-1-single-order-how-to-send-a-unified-order-via-email/6255/4 "2020-04-01T20:28:50Z")
Yeah it makes sense, but again, I have no experience with this (yet).
I guess my thought is if you have the order broken out into 2 or 3 rows, the script could send those 2 or 3 rows to the appropriate vendor(s), then flag the rows so they don’t get sent again.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 5, 2020, 6:28pm UTC](https://community.glideapps.com/t/multiple-products-and-vendors-yet-1-single-order-how-to-send-a-unified-order-via-email/6255/5 "2020-04-05T18:28:08Z")
I don’t know how easy it would be to create only three separate emails, but I imagine you would use some sort of vlookup in the sheet to link the SKU back to the owner of the item. Then send out your emails with a script or zapier to the respective item owner.
---
### Author:  [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)
#### Post date: [May 15, 2020, 7:51pm UTC](https://community.glideapps.com/t/multiple-products-and-vendors-yet-1-single-order-how-to-send-a-unified-order-via-email/6255/6 "2020-05-15T19:51:05Z")
1. C elects 9 items. 3 from S1, 3 from S2, and 3 from S3 = 9 items but 3 separate stores/sellers. Correct?
2. Each item purchased is recorded on the orders received sheet in rows, correct?
3. You want to bulk together the items (as in all 9 items in one email and send email to 3 sellers) or separate the items by seller and send three separate emails?
4. Stripe is not making any distinction between sellers; it’s simply recoding the transaction as for 9 items and asking C to pay. Correct ?
5. Your task is to separate the items by sellers and send email to each seller asking to dispatch order. Correct?
I have deliberately changed the order of q 3 and 5 to understand something. Might sound confusing, but pls answer Q in the order set if you could.
Tx.