Hi all. I’m new to all this.
We run a production business - and make around 50 different units.
We communicate via slack and sell on shopify.
I’m looking for a way to connect my production output, to my inventory (sheets)
And then when shopify makes sales, it alters the inventory (sheets) accordingly. rnot using -1 formula, but by qty? as a lot of purchases are multiples]
Hi
You can use this template to create a Shopify to google sheet automation: https://zapier.com/webintent/create-zap?template=2758
Thank you
My challenge is getting this to then update my inventory quantity in the google sheet.
Sometimes the products are purchased in multiple, so the order is output:
SKU: SKU123,SKU124,SKU126
QTY: 1,3,1
In another sheet, I’m running an inventory
SKU----------- QTY
SKU123 ------ 50
SKU124---------100
SKU125---------5
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.