Use case for Mixtable Spreadsheet Editor
Add variants to existing products, update SKUs, prices, and option values, and fix variant data across your whole catalog with a spreadsheet. Every change stays a draft until you review it and sync to Shopify.
Variants - Acme Apparel Sync 4 changesPreview Trusted by thousands of Shopify stores
What you can do
Mixtable loads every variant as a row, with the option values, SKUs, prices, and inventory fields beside it. Edit like you would in Excel or Google Sheets, then sync reviewed changes to Shopify.
Add new variants to existing Shopify products, or create new products with a full set of variants, straight from spreadsheet rows.
Edit option values, SKUs, prices, and inventory fields. With Mixtable Analytics Spreadsheet, add variant analytics such as Net Sales, quantity sold, Gross Profit, Gross Margin, refunds, and returns beside them.
Add or rename product options like Size and Color, and clean up option values across your whole catalog in one pass.
See and edit parent product fields like title, vendor, status, and tags right from the variant rows they belong to.
Import variant updates from a CSV and match rows by SKU, handle, Shopify ID, or option values, with a preview before anything changes.
Set variant images as part of your edits, and bulk delete the variants you no longer need after a clear confirmation dialog.
Load these into a variants worksheet, with parent product fields alongside. Templates like Full Product Info and Product Metafields set the columns up for you.
In the spreadsheet
New Size Run - FW26 Sync 4 changesPreview Adding a new size or color across a hundred products is painful in the admin. With a spreadsheet, you can paste rows or import a CSV: new rows become new variants, and existing rows update in place.
Guide: Add variants in bulk SKU Cleanup - All Variants Sync 4 changesPreview Your variant fields load as columns, and Mixtable Analytics Spreadsheet can add supported sales, margin, refund, and return analytics beside them. Build SKUs from option values with a formula, paste barcodes from a supplier file, or bulk update weights and tax settings without opening a single product page.
Guide: Clean up variant data Option Cleanup - Colors Sync 4 changesPreview Options drive how variants appear on your storefront. Rename Navy to Midnight Navy everywhere, fix inconsistent size labels, or add a new option name, then let Shopify pick up the reviewed changes.
Guide: Tidy your options supplier-prices.csv - Import preview Sync 5 changesPreview Got updates in a CSV from a supplier or your ERP? Drag it in, map the columns, and choose the matching key: SKU, handle, Shopify ID, or option values. Mixtable previews affected rows and warns about duplicate matches before anything is applied.
Guide: Import a variant CSVReview and sync
New variants, changed SKUs, price updates, and option renames all wait as drafts. Open the preview for your worksheet, check each pending value, fix anything that looks off, then run Sync to Shopify.
| Row | Product Variant | Field | Pending value |
|---|---|---|---|
| 2 | (new product variant) | SKU | OX-XXL-WHT |
| 3 | Oxford - M / White | SKU | OX-M-WHT="OX-"&C12&"-"&D12 |
| 4 | Merino Crew - L / Navy | Option value | Midnight Navy |
| 5 | Trouser - 32 / Sand | Price | $124.00 |
| 6 | Tee - M / Black | Weight | 0.25 kg |
Compare
Variant work is where bulk editing gets messy. Here is how the usual approaches stack up.
| Variant task | Mixtable | Shopify admin | CSV import and export | Other bulk-edit apps |
|---|---|---|---|---|
| Add variants to many products at once | Yes, paste new rows | Product by product | Fragile column mapping | Sometimes |
| Edit SKUs, barcodes, and prices in bulk | Yes, with a sheet | Limited bulk editor | In Excel, then re-upload | Form-based |
| Rename option values across the catalog | Find and replace | Per product | Error-prone | Rarely |
| Build SKUs with formulas | Excel-style formulas | No | In Excel, then re-upload | No |
| Import updates matched by SKU | Yes, with preview | No | Overwrites without preview | Varies |
| Bulk delete variants | Yes | Per product | No | Some |
| Review changes before they go live | Yes | Live when you click Save | No preview | Some |
Comparison reflects typical variant editing workflows. Shopify features can change over time.
Getting started
No CSV gymnastics required. Connect your store and edit variants like any other spreadsheet.
Install the Mixtable Spreadsheet Editor from the Shopify App Store and open a variants spreadsheet.
Use the Full Product Info template or pick the exact variant fields you need.
Add rows for new variants, update SKUs and options, and import CSV updates by key.
New variants and edits stay highlighted drafts until you confirm them.
Push reviewed variant changes to your store in one move.
Questions
Open a Products with variants worksheet in Mixtable, add a row under the product, and fill in the option values plus any fields like SKU or price. Paste to repeat it across as many products as you need, then review and sync to create the variants in Shopify.
Yes. SKUs and barcodes are columns, so you can paste supplier data, build values with formulas, or fix patterns with find and replace across thousands of variants, then sync the reviewed changes.
Option names and option values load into your worksheet as columns. Rename values across every product with find and replace, or add option names where products need them, then review and run Sync to Shopify.
Yes. Add the product's rows with each variant's option values, SKUs, and prices, and Mixtable creates the product with its full variant set when you sync.
Yes. Drag in a CSV, map its columns to worksheet columns, and match rows by SKU, handle, Shopify ID, or option values. You get a preview of affected rows, and duplicate matches are flagged before anything is applied.
Yes. Variant worksheets can include parent product fields like title, vendor, status, and tags, so you can fix product-level data while you work through variants, without switching worksheets.
Yes, you can assign variant images as a supporting workflow alongside the rest of your variant edits. Image changes are reviewed and synced like any other pending change.
Keep going
Related workflows and the help articles behind this page.
Open Mixtable for your store and manage every variant field in bulk, without CSV juggling.
