How do I use CSV Import to update metafields? (BPE)

The metafields object allows you to store additional information for products, variants, collections, customers, orders, blogs, pages and your shop. You can output metafields on your storefront using Liquid.

Bulk Product Edit supports bulk adding/editing/deleting metafields related to products, variants, collections, customers, and orders. 

A metafield consists of a namespace, a key, a value, and a value type. Use the namespace to group different metafields together in a logical way.

How to update metafields through CSV import

1. Let the app know which column contains the values for the metafield you are going to update.

2. Let the app know the namespace and key of the metafield you are going edit.

For example:

namespace: custom

key: color

will be in this format:

3. By default, value type will be "Single Line Text", if you need to set value type to a different type such as "Integer" or "Multi Line Text", please select the required type from our metafield type dropdown menu

For example:

namespace: custom

key: color

type: Single Line Text

Supported value types are:

'multi_line_text_field', 'single_line_text_field', 'product_reference', 
 'variant_reference', 'collection_reference', 'page_reference', 'file_reference',
'url', 'number_integer', 'number_decimal', 'date', 'date_time', 'json',
 'boolean', 'color', 'weight', 'volume', 'dimension', 'rating', 'money'

You can also update metafields of supported list value types as listed below:

'list.collection_reference', 'list.color', 'list.date', 'list.date_time', 

'list.dimension', 'list.file_reference', 'list.number_integer', 'list.number_decimal', 

'list.page_reference', 'list.product_reference', 'list.rating', 

'list.single_line_text_field', 'list.url', 'list.variant_reference', 

'list.volume', 'list.weight'

You can learn more about value types here: Shopify Metafield Types

How to update list type metafields

For list type metafields, the value in the CSV must be in a JSON array. If the value is not in this format, the change will be rejected by Shopify. You can find a sample JSON array provided by Shopify in the screenshot below:

Please note that the square brackets [ ] and double quotes " " are a part of the JSON array, and must be included in the CSV value as well.

How to delete metafields through CSV import

If the value in the CSV column is "delete", the metafield will be deleted.