The Shopify API makes it possible to export your inventory levels by SKU and location. You can then send requests to Shopify to adjust the inventory levels. This tutorial will show a spreadsheet that you can use, and explain how it works.
- Click here to access the template spreadsheet: Shopify Inventory Updater
- Install the SyncWith add-on when the template prompts you:
- The addon will automatically create two connections for you:
In order to access your product inventory data, you will need to grant SyncWith permission to communicate with Shopify.
- Click on the
Get Inventory Levelsconnection
- Click the
- You will be redirected to Shopify to finish authenticating.
- After authenticating, your account should appear. You may need to back out and click back in.
Get Inventory Levelsconnection uses Shopify’s GraphQL endpoint to report on your SKUs and inventory levels. You can read our Track your Shopify inventory by SKU tutorial to learn more.
Get Inventory Levelsspreadsheet should now show your product SKUs, with one row for each location and the SKU’s availability at that location:
New Availabilitycolumn, you can enter new values. If you leave the cell blank, or put the same value as the old value, it will not be updated. SKUs whose availabilty will be updated will turn yellow to signal that you have made a change:
At this point, your inventory levels have not yet been adjusted. Next, we’ll use a bit of Google Sheets wizardry, our cell references feature, and Shopify’s inventory_levels/set endpoint to do the updating.
- Switch to the
Pending Updatessheet. It should show a filtered list of your product SKUs — only the ones whose availability need to be updated based on your edits on the previous sheet:
- If the list looks good, refresh the
Adjust Inventory Levelsconnection.
On your first use of the spreadsheet, you’ll need to click into it and connect your Shopify account, then click
Adjust Inventory Levelsconnection will use our cell references feature to make 1 request per SKU to Shopify’s Admin API to update that SKU’s availability in the given location.