Use case for Mixtable Spreadsheet Editor
Turn every metafield definition into a spreadsheet column. Update metafields across products, variants, customers, collections, orders, content, B2B, markets, and discounts, then review your changes and sync to Shopify.
Product Metafields - Acme Sync 6 changesPreview Trusted by thousands of Shopify stores
What you can do
Metafields hold the data that makes your store yours: materials, size charts, ingredients, care guides. Mixtable turns each definition into a column you can edit at scale in a connected spreadsheet.
Edit product and variant metafields beside core fields, including parent product metafields from variant rows, and add Net Sales or quantity sold with Mixtable Analytics Spreadsheet.
Update metafields on customers, collections, orders, pages, blog posts, blogs, companies, company locations, markets, and discounts.
Start from the Product Metafields template, which sets up product and variant metafield worksheets with your definitions already loaded as columns.
Add any defined metafield through custom field selection, and reload definitions when your store's metadata changes.
Use formulas, filters, copy and paste, find and replace, and CSV imports to fill gaps and standardize values.
Work with metaobject worksheets, metaobject reference fields, and product category metafields alongside regular metafields.
Coverage follows what Shopify exposes for each object type. Where a metafield is supported, it loads as a column you can edit, filter, and export.
In the spreadsheet
Metafield Audit - Materials Sync 4 changesPreview In the Shopify admin, metafields live at the bottom of each product page. With a spreadsheet they sit side by side for your whole catalog, so gaps and inconsistencies have nowhere to hide. Add Net Sales or quantity sold from Mixtable Analytics Spreadsheet when you want to prioritize the products that matter most.
Guide: Open your metafields Value Cleanup - custom.material Sync 4 changesPreview Inconsistent values break storefront filters and themes. Clean them in bulk: find and replace across the column, formulas for casing and trimming, or a CSV import keyed on SKU or handle to fill everything at once.
Guide: Clean up your metafields Customer Metafields Sync 4 changesPreview Metafields are not just for products. Load them for the Shopify objects your store uses, then manage them with the same spreadsheet tools.
Guide: Go beyond product data Metaobjects - Materials Sync 4 changesPreview Metaobjects hold structured content like designers, materials, or size guides. Load a metaobject definition into its own worksheet to edit entries in bulk, and manage metaobject reference fields right from your product rows.
Guide: Work with metaobjectsReview and sync
Every metafield edit, whether typed, formula-generated, or imported from CSV, stays a pending draft. The preview lists each pending value for your worksheet so nothing slips through.
| Row | Product | Field | Pending value |
|---|---|---|---|
| 2 | Classic Oxford Shirt | custom.material | Cotton=PROPER(TRIM(C2)) |
| 3 | Linen Trouser | custom.origin | Portugal |
| 4 | Merino Crew Sweater | custom.care | Hand wash only |
| 5 | Corduroy Cap | custom.material | Cotton corduroy |
| 6 | Wool Scarf | custom.fit | One size |
Compare
Metafields are powerful and painful to maintain. Here is how the workflows compare at scale.
| Metafield task | Mixtable | Shopify admin | CSV import and export | Other bulk-edit apps |
|---|---|---|---|---|
| Edit metafields across the catalog | One column per definition | Bulk editor, typed by hand | Cryptic CSV columns | Form-based |
| Variant and parent product metafields together | Yes | Separate screens | Product metafields only | Varies |
| Customer, order, and collection metafields | Yes | Scattered | Limited | Rarely |
| Fill values with formulas and CSV imports | Yes, with preview | No | Re-upload and hope | Limited |
| Filter products by metafield value | Conditional worksheets | Limited | Manual in Excel | Some |
| Export data with metafields | Excel or CSV | No | Yes, with setup | Varies |
| Review changes before they go live | Yes | Live when you click Save | No preview | Some |
Comparison reflects typical metafield editing workflows. Shopify features can change over time.
Getting started
Load your definitions, clean the data with spreadsheet tools, and sync with confidence.
Install the Mixtable Spreadsheet Editor from the Shopify App Store and open a spreadsheet.
Start from a metafields template or add defined metafields through custom field selection.
Use paste, fill down, formulas, find and replace, and CSV imports keyed by SKU or handle.
Check every pending metafield value in the sync preview before anything is sent.
Apply reviewed changes, and your storefront and integrations pick them up from Shopify.
Questions
Install the Mixtable Spreadsheet Editor, open a spreadsheet, and load your products with the metafield definitions you want as columns. Edit values like normal spreadsheet cells, in bulk, then review the pending changes and run Sync to Shopify.
Yes. Variant metafields load on variant rows, and you can also edit parent product metafields from the same worksheet, which keeps product-level and variant-level data in one place.
Yes. Products and orders can be exported together with their metafields to Excel or CSV, which is useful for audits, agencies, and feeding other systems.
Yes. Drag in a CSV, map its columns to metafield columns, and match rows by SKU, handle, or Shopify ID. Mixtable previews affected rows before anything is applied, and edits still wait for your sync.
Products, variants, customers, collections, orders, pages, blog posts, blogs, companies, company locations, markets, and discounts. Variant worksheets can also include parent product metafields. Product category metafields and metaobject reference fields are covered too.
Yes. Pick a metaobject definition and its entries load into a worksheet where you can edit fields in bulk. Metaobject reference fields on products are editable as well.
Yes. Metafields can be conditions for conditional worksheets, so you can build a live view like every product where custom.material is empty and fix exactly those rows.
No. Every change stays a highlighted draft until you review it and run Sync to Shopify, so a formula mishap never lands in your storefront unreviewed.
Keep going
Adjacent workflows and the help articles behind this page.
Open Mixtable for your store and give every metafield a clean, consistent value.
