Inventory Updater Tool for Shopify
🔧 Quick Info: Bulk-update your Shopify stock levels and inventory tracking from a spreadsheet, matched by SKU.
What it does
The Inventory Updater lets you set stock quantities — and turn inventory tracking on or off — for your Shopify product variants in bulk by uploading a single file.
You choose a location, then upload a spreadsheet with one row per variant identified by its SKU. The tool finds the matching variant in your store and sets the available quantity at the location you picked. If you include a tracking column, it can also enable or disable Shopify’s inventory tracking for each variant.
When to use it
- You did a stock count and need to push the new numbers into Shopify quickly.
- You manage stock in a spreadsheet or another system and want to sync quantities to a specific location.
- You need to turn inventory tracking on or off for many variants at once.
Before you start
- Your Shopify store must be connected to your account.
- Have a CSV or Excel file ready with a header row (the first row holds your column names).
- Your file must include a SKU column, and a Stock column is also required to update quantities.
- The SKUs in your file must match the SKUs on your Shopify product variants. Anything that doesn’t match is reported back to you and skipped.
- Know which location the stock numbers apply to — you’ll select it during the upload.
Step-by-step
1 Open the Inventory Updater tool for your connected Shopify store.
2 On the Upload Inventory step, choose the location the stock levels apply to (required).
3 Make sure your file’s first row contains a SKU column and a Stock column, then upload your CSV or Excel file.
4 Once the file is read, the Match your file’s columns screen appears. Match your file’s columns to these fields:
- Map your SKU column to SKU (required).
- Map your quantity column to Inventory Stock Level.
- Optionally map a column to Inventory Tracking to turn tracking on or off.
5 Continue to the email delivery step and choose whether you’d like a completion notice by email — delivery is off by default, and your own email is prefilled if you turn it on.
6 Submit. The update runs in the background as a job, so you can leave the page. When it finishes, you’ll get an email letting you know the inventory import has completed (if you turned email delivery on).
File / field reference
Your file needs a header row. Map these fields during the upload step:
| Column | Required? | Notes |
|---|---|---|
| SKU | Yes | Identifies which product variant to update. Must match a variant SKU in your Shopify store. Matching is not case-sensitive. |
| Inventory Stock Level | Required to update quantity | The available quantity to set at the chosen location. Must be a number. |
| Inventory Tracking | No | Turns Shopify inventory tracking on or off for the variant. See accepted values below. |
Accepted Inventory Tracking values:
- Turn tracking on:
true,1,yes, oryep - Turn tracking off:
false,0,no,not, ornope
Notes on behavior:
- Stock is only applied when the value is a number and tracking is enabled for that variant. If a variant isn’t tracked and you don’t ask to enable tracking, its quantity is left alone.
- The quantity is set as the available amount at the location you selected (recorded in Shopify as a “correction”).
Troubleshooting / FAQ
A SKU “was not found in Shopify Store.”
The SKU in your file doesn’t match any variant in your store. Check for typos, extra spaces, or leading zeros, and confirm the variant exists in Shopify.
The quantity didn’t change.
Stock updates require a numeric value in the Stock column, and the variant must have inventory tracking enabled. If the variant isn’t tracked, include a tracking column with an “on” value (such as yes or true) so tracking is turned on and the quantity can be set.
I need to pick a location.
The location is required. Select the location your stock numbers apply to before uploading.
Where do my results go?
The job runs in the background and emails you when it’s done (if you set email delivery to “Yes”). Any rows that couldn’t be updated are reported so you can correct and re-upload them.