Multiple products and vendors, yet 1 single order. How to send a unified order via email?

[Domen_Kert]

Hey all!

I’m working on lokalnahrana.org, an app that lets people easily find local food producers all over Slovenia (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?

[Tim_Sullivan]

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 solved

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…

[Domen_Kert]

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?

[Tim_Sullivan]

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.

[Jeff_Hager]

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.

[Wiz.Wazeer]

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.