Skip to main content
Question

How to update inventory quantity in Google Sheets for Shopify sales?


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] 
 

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

robschmidt
Forum|alt.badge.img+9
  • Zapier Expert
  • 617 replies
  • July 26, 2021

Hi @TTT 

You can use this template to create a Shopify to google sheet automation: https://zapier.com/webintent/create-zap?template=2758


  • Author
  • New
  • 1 reply
  • July 26, 2021

Thank you @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:
SKU: SKU123,SKU124,SKU126
QTY: 1,3,1

In another sheet, I’m running an inventory 
SKU----------- QTY
SKU123  ------ 50
SKU124---------100
SKU125---------5