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.