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.
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 and supported analytics, including parent product metafields from variant rows.
Update metafields on customers, collections, orders, pages, blog posts, blogs, companies, company locations, markets, and discounts.
Start from the Product Metafields and Product Variant Metafields templates, 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.
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 when you want to prioritize the products that matter most.
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.
Metafields are not just for products. Load them for the Shopify objects your store uses, then manage them with the same spreadsheet tools.
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.
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.
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.
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 | Per product, at page bottom | Cryptic CSV columns | Form-based |
| Variant and parent product metafields together | Yes | Separate screens | Separate files | 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 | Saves instantly | No preview | Some |
Comparison reflects typical metafield editing workflows. Shopify features can change over time.
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.
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.
Open Mixtable for your store and give every metafield a clean, consistent value.
