Change Track Quantity field in Shopify through Google Sheet Trigger

Question

I receive stock reports in spreadsheet format from different suppliers once or twice a week. The spreadsheet contains three columns: SKU #, Product Name and Quantity. I will convert the spreadsheet to Google Sheet and place it in My Drive. I would like Zapier to:

examine the spreadsheet starting from row 2,
match the SKU # in Shopify and turn on Track Quantity,
set Quantity available to -1.

My question is how to make this process into a loop until it reaches the last row of the list on the spreadsheet. The bottom line is to make the product not available in Shopify when it is out of stock on the report. If you have done this process successfully, please share. I appreciate your time and talent.

Danvers · Answer

Hi @LadyBee!You’ll definitely need to use the Shopify action Update Inventory Quantity, as you can use that to reduce the number of items that you have of a particular product in your inventory.The tricky part here will be the trigger for the Zap. Are you able to add the information from the Supplier’s spreadsheets into a new Google Sheet? If so, you could use the New Spreadsheet row trigger and the Zap would go through each row of the sheet and update the quantity in Shopify accordingly. Do you think that would work in this instance?

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded