Use case for Mixtable Spreadsheet Editor
Manage Shopify inventory with a spreadsheet: see quantities for every variant and location in one sheet, set exact counts or adjust up and down, and enable tracking in bulk. Review everything, then sync to Shopify.
Inventory - All Locations Sync 4 changesPreview Trusted by thousands of Shopify stores
What you can do
Mixtable loads quantities by variant and location into a connected sheet. Count, correct, and plan the way you would in Excel, then sync reviewed changes back to Shopify.
See every variant's stock across all your Shopify locations, one column per location, one row per variant.
Type exact counts after a stocktake, or enter +12 or -3 in an Inventory Adjustment column for receiving and shrinkage. Shopify applies it to the current stock, so sales in between aren't overwritten.
Turn on inventory tracking for many products at once, and activate inventory at the locations that should stock them.
Update SKUs, barcodes, and cost per item alongside quantities, with related product fields where supported.
Start from the Inventory template, then add Net Sales, quantity sold, and inventory metrics like Days of Stock Left and Dead Stock Units with Mixtable Analytics Spreadsheet, calculated from your store's day-by-day stock history. Filter to the variants that need restocking or clearing out.
Import counts from suppliers or your warehouse matched by SKU, and export inventory for audits and planning.
Load these into an Inventory worksheet, keep helper columns like variance beside them, and export any view to Excel or CSV.
In the spreadsheet
Receiving - PO #218 Sync 4 changesPreview Each location is a column, each variant a row. Move stock understanding from six admin screens to one view, and edit any quantity directly where you see it.
Guide: See all locations at once Stocktake - June Sync 3 changesPreview After a stocktake, paste the real numbers. For receiving or shrinkage, add an Inventory Adjustment column and type +12 or -3: when you sync, Shopify adds or subtracts that amount from the current stock, so sales that happen in between aren't overwritten. To change a whole column at once, the bulk number tools add, subtract, or scale it with a preview of the first affected rows.
Guide: Fix your counts Tracking Audit Sync 2 changesPreview Untracked products quietly oversell. Turn tracking on for whole ranges, activate inventory at the right locations, and correct SKUs, barcodes, and cost per item while you are in there.
Guide: Turn tracking on properly Low Stock - Qty under 10 Add Net Sales, quantity sold, and inventory metrics like Days of Stock Left and Dead Stock Units beside each variant, then filter the sheet to what needs attention: bestsellers about to run out, stock that isn't moving, a single vendor, or one location. Import supplier counts matched by SKU with a preview, and export the whole picture to Excel or CSV for planning.
Guide: Build your restock listReview and sync
Stock numbers are operational: a wrong sync means overselling or dead stock. Every count, adjustment, tracking change, and item edit waits in the preview until you confirm it.
| Row | Product Variant | Field | Pending value |
|---|---|---|---|
| 2 | Oxford - M / White | Warehouse qty | 148 |
| 3 | Tee - M / Black | Warehouse qty | 236 |
| 4 | Ribbed Beanie | Tracking | Tracked |
| 5 | Canvas Tote | Cost per item | $12.00 |
| 6 | Trouser - 32 / Sand | Retail store qty | 12=C9+D9 |
Compare
Whether you run one location or six, here is how inventory updates compare across tools.
| Inventory task | Mixtable | Shopify admin | CSV import and export | Other bulk-edit apps |
|---|---|---|---|---|
| See all locations in one view | One column per location | Per location toggle | One file per export | Varies |
| Set exact quantities in bulk | Yes, paste or type | Small batches | In Excel, then re-upload | Form-based |
| Adjust up and down by amount or percent | Yes, with preview | Manual per item | Manual math in Excel | Sometimes |
| Enable tracking for many products | Yes | In the bulk editor | Partial | Rarely |
| Import counts from suppliers by SKU | Matched and previewed | Rigid CSV format | That is the workflow | Varies |
| Cost per item and item fields | Yes | In the bulk editor | Limited | Limited |
| Review changes before they go live | Yes | Confirmation when you save | No preview | Some |
Comparison reflects typical inventory workflows. Shopify features can change over time.
Getting started
Connect your store, load the Inventory template, and make the numbers match reality.
Install the Mixtable Spreadsheet Editor from the Shopify App Store and open an inventory spreadsheet.
Use the Inventory template to pull variants, locations, and quantities into a sheet.
Paste stocktake results, adjust for receiving, and fix tracking and item fields.
Every quantity and setting change is listed before anything reaches your store.
Apply the reviewed updates and your locations reflect the new counts.
Questions
Open the Inventory template in Mixtable, and your variants load with a quantity column for each location. Type or paste new counts, or adjust them up and down, then preview the pending changes and click Sync.
Yes. Every location becomes its own column, so you can see and edit warehouse, retail, and 3PL stock side by side instead of switching locations in the admin.
Load the tracking field as a column and turn it on for every row that needs it. You can also activate inventory at supported locations in the same pass, then sync the reviewed changes.
Yes. Drag in a CSV from your supplier or warehouse system, map the columns, and match rows by SKU or another key. Mixtable previews affected rows and flags duplicates before anything is applied.
Yes, both work. Set exact counts after a stocktake, or use an Inventory Adjustment column for receiving and shrinkage. The bulk number tools can also raise or lower a whole column by an amount or percentage.
Yes. Inventory item fields like SKU, barcode, and cost per item load beside quantities, so you can fix stock and item data in one reviewed sync.
Yes. Export the full spreadsheet to Excel or the current worksheet to CSV, which makes audits, supplier updates, and planning spreadsheets straightforward.
Yes, with Mixtable Analytics Spreadsheet. Add inventory analytics columns such as Days of Stock Left, Days Out of Stock, In-Stock Rate, Estimated Lost Sales, Sell-Through Rate, Dead Stock Units, and Closing Stock to the variant worksheet the Inventory template builds. Mixtable calculates them from your store's day-by-day inventory history, so you can filter to variants that are about to run out or stock that isn't selling. Our Analyze Shopify inventory page covers this in depth.
No. Changes stay as highlighted drafts until you preview them and click Sync, which protects you from overselling due to a stray keystroke.
Keep going
Adjacent workflows and the help articles behind this page.
Open Mixtable for your store and keep every count, location, and cost accurate.
