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.
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.
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.