Fix metafield errors before Shopify rejects your CSV
Drop in your product CSV: every metafield column is checked against Shopify's import rules, and you get a fixed file.
- Rules from Shopify's CSV help page
- Read by this browser tab only: the CSV is never sent to a server
- First 50 rows free, no sign-up
1. Choose your product CSV
The file you would import in Shopify (Products > Import). It is read on this page and never uploaded.
No file chosen yet.
2. Add your metafield definitions optional
Without them the page checks the column headers and variant columns. Add them to check every value too: one per line, namespace.key and its type as Shopify shows it (Settings > Custom data), for example custom.sizes List of integers.
Already paid? Open the full check in this browser
Result
| Row | Column | Problem | Value | Suggested fix |
|---|
Check the whole file and get it fixed
- Every row checked, not only the first 50
- A fixed CSV, ready to import: only fixes that need no guessing (1,5 → 1.5, Yes → true, headers in Shopify's format)
- The full report as a CSV, one line per problem
- One payment, no subscription, no account
- Pay once in Paddle's secure checkout (it emails your receipt)
- This page checks every row at once
- Download the fixed CSV and the report, then import it in Shopify
No account to create. See what you get on the sample: fixed CSV · report
US$12 one time
US$7.20 with the founding offer until 30 November, applied at checkout.
Secure checkout by Paddle. Prices exclude tax; Paddle adds any applicable tax. Full refund within 14 days if it did not help.
What it checks
- Header format. Shopify reads metafield columns written as
Name (product.metafields.namespace.key). Headers in other apps' formats, such asMetafield: custom.material [single_line_text_field], are flagged and rewritten in the fixed CSV. - Variant metafields. They are not supported in the product CSV; Shopify points to the variant bulk editor.
- Values. Whole and decimal numbers (a point, not a comma), true/false, dates as YYYY-MM-DD, colours like
#ff00cc, URLs with http(s), money like5.99 CAD, dimension, volume and weight with a unit. - Lists. Items separated by a semicolon and a space.
- Product references. A handle that is not in your file is flagged: if the product is not in your store yet, Shopify stops with "Value must be a valid product reference". Import in two stages.
The fixed CSV only applies fixes that need no guessing (for example 1,5 to 1.5, Yes to true). Anything else is listed for you to correct. Rules from Shopify's help pages: using CSV files, common import issues.