Free CSV template
Shopify metafields CSV template
One column per metafield, one row per product. The header says the namespace, key and type, so each value can be checked before it's saved.
Download the CSV template
Free, no sign-up. Opens in Excel, Numbers and Google Sheets.
The columns
| Column | Needed | What to put |
|---|---|---|
| Handle | Yes | The product's handle. |
| Metafield: custom.material [single_line_text_field] | Example | Plain text. |
| Metafield: custom.care_instructions [list.single_line_text_field] | Example | A list: items separated by semicolons become a list. |
| Metafield: custom.waterproof [boolean] | Example | true or false. yes/no and 1/0 work too. |
What's in the file
Handle,Metafield: custom.material [single_line_text_field],Metafield: custom.care_instructions [list.single_line_text_field],Metafield: custom.waterproof [boolean] classic-tee,Organic cotton,Wash cold; Line dry,false rain-jacket,Recycled nylon,Wash cold; Do not iron,true
How to import it
- Change the headers to your own metafields: “Metafield: ” then namespace.key, then the type in square brackets.
- Fill in one row per product.
- In Bulkvane, open Import, add the file and choose Update only. Click Check file and every value is checked against its type.
- Apply. Undo this import puts the old values back for 30 days.
Tips
- Variant metafields use “Variant Metafield: namespace.key [type]” columns, with values on each variant's row.
- Dimension, weight, volume, money and rating values are JSON, for example {"value": 74, "unit": "cm"}.
- Shopify's header style, “Material (product.metafields.custom.material)”, works too; the type then comes from your metafield definition.
Step by step: How to bulk edit Shopify metafields. Every column is in the column reference.
Questions
Do I need a metafield definition first?
Not with Bulkvane's header style, which carries the type. A definition is what shows the field in Shopify admin, so it's worth creating one. Bulkvane can create definitions in bulk too.
How do I clear a metafield?
Leave its cells empty and import in Replace mode. In Update only, empty cells leave values alone.
Preview every change.Undo any import for 30 days.
Install free