What Is the All Variants Metafields Report?
The All Variants Metafields report brings the extra details stored on your Shopify variants into one catalog view. Review product titles, variant titles and SKUs alongside each metafield’s namespace, key and value, including size measurements, color swatches, pack sizes or supplier codes when your store records them.
Use it to check details that change between sizes, colors or packs without opening each variant separately. The report pairs variant identifiers with individual metafield entries, so a variant with several metafields can appear more than once. It describes catalog data rather than sales over a selected period.
Report Overview
- Report type
- Product & Variants.
- Reporting basis
- Variant metafield data at report generation; not a sales history report.
- Data included
- Six fields covering variant identity and metafield namespace, key and value.
- Best use
- Reviewing variant details and preparing data for catalog work.
- Delivery
- Excel, CSV or PDF, with scheduled email delivery.
What Can You Learn from Variant Metafields?
1. Which recorded values need attention
Compare values for the same namespace and key across relevant variants. Empty or inconsistent entries can point to details that need review.
Example: For example, one size has a chest measurement recorded without a unit.
What you can do: Check the intended measurement and use a consistent format.
2. Whether supplier details are usable
Review supplier codes beside SKUs so you can prepare a reference for purchasing or supplier communication. This report does not create purchase orders.
Example: For example, two related pack variants have the same supplier code.
What you can do: Confirm whether the shared code is intentional before reusing it.
3. Which details need preparation for another system
Namespace and key help you select the exact variant data you want to reuse. A feed, label tool or marketplace may require different column names or value formats.
Example: For example, a destination expects a numeric pack count, but the value says “six units”.
What you can do: Prepare a separate file that matches the destination’s requirements.
What Should You Check First in This Report?
Start with identifiers and value coverage before sharing or reusing the export.
Variant identity. Check product title, variant title and SKU together; SKUs may be blank or duplicated.
Namespace and key. Use the pair to distinguish metafields with similar names.
Missing entries. Variants with no saved metafields still appear in the export. Compare them against the keys each variant needs before calling the check complete.
Value format. Review units, spelling and complex values such as references or lists before using them elsewhere.
When Should You Use This Report?
| When to Use It | How It Helps |
|---|---|
| Checking size measurements before a launch | Review the measurements recorded on each size variant. |
| Reviewing shade and finish details | Compare variant swatches or shade values for inconsistent entries. |
| Preparing supplier references | Pair supplier codes with product names, variant names and SKUs. |
| Checking pack information | Review saved pack counts or dimensions before preparing labels. |
| Preparing a variant data handoff | Select the namespaces, keys and values your catalog team needs. |
How to Create This Report in Data Export
Start with the premade report rather than adding each field yourself.
- Open Data Export and go to Prebuilt Reports.
- Find and open All Variants Metafields. Review the six columns listed above.
- Adjust the columns and available filters for the variant data you need. If you need a particular namespace or key, check the report’s filtering options.
- Save and generate the report. Review a sample against your catalog before sharing it.
- Choose the export format and, if needed, schedule email delivery daily, weekly or monthly to the relevant team.
Make the Most of This Report
Use these checks to keep the export useful for catalog reviews.
01 / COUNT VARIANTS
Count unique variants, not rows. Several metafield entries can belong to one variant; ask for a variant ID if identity is unclear.
02 / CHECK COVERAGE
Compare against required keys. Variants without metafields appear in the export too, so you can see where details are missing.
03 / PRESERVE VALUES
Open CSV files carefully in spreadsheets so leading zeros in SKUs or supplier codes are preserved. Keep an untouched original.
04 / SHARE SELECTIVELY
Send only the fields a recipient needs. Supplier codes and other internal variant details may not belong in every shared file.
Frequently Asked Questions
How are variant metafields different from product metafields?
Variant metafields describe an individual size, color or pack. Product metafields describe the product as a whole. This report focuses on variant metafields.
Will variants with no metafields appear in the export?
Yes. Variants without saved metafields still appear in the export, so you can see which variants are missing details across your whole catalog.
Can I export Shopify variant metafields to CSV or Excel?
Yes. You can export it as CSV, Excel or PDF. Review the exported value format before preparing files for another system.
Can I schedule this report for my catalog team?
Yes. You can schedule daily, weekly or monthly email delivery. Choose a frequency that fits how often your team changes variant details.
Does editing the exported file update Shopify?
Treat the export as a review file. Editing it does not itself update Shopify; any changes need a separate supported editing or import workflow.