Import Shopify Metafields as json_string

Shopify import Metafields as json_string

To import the Metafields to Shopify as json_string type, import the Metafield column with the “[json_string]” suffix.

For example, your Metafield import column can be:

Metafield: custom.json [json_string]

Then you can use this field in your Shopify Liquid theme as the JSON object.

Read more about importing Metafields to Shopify using Excelify.

Product Variant Metafields

Shopify variant metafields

The same way as you have “Metafield:” columns, you now have the “Variant Metafield:” columns for Products where you can export and import variant metafields.

For example:

  • The variant metafield with name “buy_price” in the global namespace should be called “Variant Metafield: buy_price”.
  • The variant metafield with name “description” in the “details” namespace should be called “Variant Metafield: details.description”.

Note that exporting and importing Variant Metafields will significantly increase the time it takes to process the items because each variant metafield needs separate request to the Shopify API. Therefore, be mindful and export/import variant metafields only when you really need them.

To start using variant metafields, refresh the app page.

Metafields import

Speed: Metafields import speed doesn’t depend on Metafield count anymore. Even for 100 Metafields per item, it will import as quickly as with no Metafields.

Delete: You can delete Metafields for items just by clearing values in that Metafield column, and importing.

Set type: Metafield can have “string” or “integer” type, which is now auto-detected from Excel cell type, and set correctly when you do the import.

Read more: Metafields template documentation