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.
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 adjust quantities up and down by amounts and percentages with the bulk number tools.
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, add variant Net Sales and quantity sold, then filter to the low-stock products where replenishment matters most.
Import counts from suppliers or your warehouse matched by SKU, and export inventory for audits and planning.
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.
After a stocktake, paste the real numbers. For receiving or shrinkage, adjust by a delta instead. The bulk number tools add, subtract, or scale a whole column with a preview of the first affected rows.
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.
Add Net Sales and quantity sold beside each variant, then filter the sheet to what needs attention: out-of-stock bestsellers, 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.
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.
Load these into an Inventory worksheet, keep helper columns like variance beside them, and export any view to Excel or CSV.
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 | One product at a time | 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 | Per product | Limited | Limited |
| Review changes before they go live | Yes | Applies immediately | No preview | Some |
Comparison reflects typical inventory workflows. Shopify features can change over time.
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.
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 review the pending changes and run Sync to Shopify.
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 apply relative adjustments for receiving and shrinkage, including bulk increases and decreases by 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.
No. Changes stay as highlighted drafts until you review them and run Sync to Shopify, which protects you from overselling due to a stray keystroke.
Open Mixtable for your store and keep every count, location, and cost accurate.
