Bulk edit Shopify inventory in Google Sheets
Export inventory quantities for every SKU and every location to a single spreadsheet, edit stock levels in bulk, and sync changes back to Shopify in one click.
Free plan available
Every inventory field, every location
Stop updating stock one product at a time. Export every SKU and location into one sheet and edit them all at once.
The units available for sale, per location
Total physical units in each warehouse or store
Units already reserved by open orders
Units on the way from a supplier or transfer
Buffer stock to avoid stockouts
Each location gets its own editable column in the sheet
Pick the Inventory Quantities template
Open eCommix and select "Products - Inventory Quantities" from the Update Products category. Hit Create and your entire inventory exports to Google Sheets in seconds - every SKU, every location, ready to edit.
Update inventory from Google Sheets
Choose which locations to include
eCommix detects every Shopify location automatically. In Manage Columns, tick which locations to add to your sheet - one column per location. Warehouse, retail store, 3PL, or fulfilment centre: they all appear as separate, editable columns side by side.
Update inventory from Google Sheets
Preview the column layout before exporting
The Format Data step shows a live preview of your sheet: Title, SKU, and one Inventory Available column per location. Reorder, rename, or hide columns without touching the export. When the layout looks right, export to Google Sheets.
Update inventory from Google Sheets
Edit quantities directly in the sheet
Your sheet lands with every variant as a row and every location as a column. Type new quantities, paste from a supplier file, or use Sheets formulas to adjust in bulk. Set a location to zero, top up a warehouse, or redistribute stock between sites - all in the same grid.
Update inventory from Google SheetsSync back to Shopify in three steps
Return to eCommix, hit Export to refresh the sheet with the latest data, make your changes, then hit Import. eCommix validates every row and pushes only the changed quantities to Shopify. No overwriting untouched SKUs, no surprises.
Update inventory from Google Sheets
Pair with the Inventory Forecast Planner
Once your quantities are clean, use the Inventory Forecast Planner template to predict when each SKU will run out based on sales velocity. The planner pulls On Hand, Available, Committed, and Incoming - giving you reorder signals before stockouts happen.
Update inventory from Google Sheets
When to bulk-edit inventory
Any time updating stock one product at a time in Shopify admin would take longer than it should.
Post-delivery stock update
A supplier delivers 500 units to your warehouse. Open the sheet, find the SKUs, type the new quantities, import. Done in under two minutes instead of clicking through Shopify admin one product at a time.
Multi-location rebalancing
One store is overstocked, another is running low. See every location side by side in the sheet, redistribute quantities across the columns, and sync in one import.
Seasonal inventory reset
Before peak season, adjust safety stock and available quantities across your whole catalog in bulk. Sheets formulas let you apply percentage increases to entire columns at once.
3PL or warehouse onboarding
Adding a new fulfilment centre? eCommix adds a new column for the location automatically. Seed the initial quantities in the sheet, import once, and you're live.
Stockout prevention
Filter for rows where Available drops below a threshold using Sheets conditional formatting. Fix the quantities, import, and pair with the Forecast Planner to set up reorder alerts.
Inventory audit reconciliation
After a physical count, paste the actual quantities into the sheet alongside the Shopify values. Use a formula to spot discrepancies, correct them, and import only the rows that changed.
Frequently asked questions
Can I update inventory for multiple locations at once?
Yes. eCommix creates one editable column per Shopify location. You can update quantities for every location in the same import - no need to run separate syncs per location.
Which inventory fields can I edit?
Available is editable (the quantity available for sale). On Hand, Committed, Incoming, Reserved, Damaged, Quality Control, and Safety Stock are also exported so you have the full picture, though only Available can be written back via the two-way sync.
Will importing overwrite stock I didn't change?
No. eCommix only writes back cells you actually edited. If you changed 10 SKUs out of 1,000 rows, only those 10 SKUs are updated in Shopify. The rest are untouched.
Can I filter the export to a specific location or product type?
Yes. When configuring the export you can filter by location, vendor, product type, collection, or any other criteria to keep the sheet focused on what you need.
What is the Inventory Forecast Planner?
It's a separate eCommix template that uses your sales history and current stock levels to predict when each SKU will run out and suggest reorder quantities. It works alongside the Inventory Quantities template - use one to manage stock, the other to plan ahead.
Is there a limit to how many SKUs I can update?
There's no hard limit. Large catalogs export with automatic pagination. You can also scope the sheet to a subset of your catalog using filters.
Stop updating stock one SKU at a time
Free plan available. Works with any Shopify store.
Update inventory from Google Sheets