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.
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 beside variant analytics such as Net Sales, quantity sold, Gross Profit, Gross Margin, refunds, and returns.
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.
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.
Your variant fields load as columns, with supported sales, margin, refund, and return analytics available 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.
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.
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.
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.
Load these into a variants worksheet, with parent product fields alongside. Templates like Products with variants and Product Variant Metafields set the columns up for you.
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 | One at a time | No | Some |
| Review changes before they go live | Yes | Saves instantly | No preview | Some |
Comparison reflects typical variant editing workflows. Shopify features can change over time.
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 Products with variants 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.
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.
Open Mixtable for your store and manage every variant field in bulk, without CSV juggling.
