Skip to content

NewSchedule your Black Friday sale: prices drop at the start and go back by themselves. See how

Bulkvane

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

ColumnNeededWhat to put
HandleYesThe product's handle.
Metafield: custom.material [single_line_text_field]ExamplePlain text.
Metafield: custom.care_instructions [list.single_line_text_field]ExampleA list: items separated by semicolons become a list.
Metafield: custom.waterproof [boolean]Exampletrue 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
Example rows. Replace them with your own before you import.

How to import it

  1. Change the headers to your own metafields: “Metafield: ” then namespace.key, then the type in square brackets.
  2. Fill in one row per product.
  3. In Bulkvane, open Import, add the file and choose Update only. Click Check file and every value is checked against its type.
  4. 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