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. [not using -1 formula, but by qty? as a lot of purchases are multiples]
You can use this template to create a Shopify to google sheet automation: https://zapier.com/webintent/create-zap?template=2758
@robschmidt - I have one similar set up currently. It pulls the SKU and quantity.
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:
In another sheet, I’m running an inventory
SKU123 ------ 50