Get Excelify now
Get Excelify now

Import, Export and Update Shopify Shop Metafields in bulk

Import Export update edit create delete shopify shop store metafields in bul kexcel csv|1. Excelify create new export excel csv products shop collections orders customers|2. export import update shopify shop store metafields excel csv bulk|3. export import update shopify shop store metafields excel csv bulk|4. export import update shopify shop store metafields excel csv bulk|5. export import update shopify shop store metafields excel csv bulk|edit shopify shop metafields import update create delete in bulk excel csv

With the Excelify you now can also import, export and update your Shopify Store Metafields.

These are Metafields that are attached to your Shop itself. To read about Metafields attached to Products, or other items, please see this tutorial.

Export Shop Metafields

1. In Excelify app create new export

When you have entered the Excelify app, you can locate the “Export” section with “New Export” button, where you can create new export.

1. Excelify create new export excel csv products shop collections orders customers

2. Select Shop checkbox and Metafields sub-checkbox

Once new export is created a new window will open with a lot of checkboxes.

Here you can select what you wish to export, in our case select checkbox “Shop” and sub-checkbox “Metafields“.

No need to include the “Other Details” checkbox – those are the shop attributes like Email, Domain, Owner, etc. – those columns can be only exported, so you don’t need them to update your Shop Metafields.

2. export import update shopify shop store metafields excel csv bulk

3. Start the export

Once checkboxes are selected you can click on the “Export” button to start the export.

3. export import update shopify shop store metafields excel csv bulk

4. Download exported file

Once the export is finished you can click on the “Download Exported File” button to download the file.

4. export import update shopify shop store metafields excel csv bulk

Open the file to check your Shop Metafields!

5. export import update shopify shop store metafields excel csv bulk

Import and Update Shop Metafields

You can also import to create and update your Shopify Store Metafields in bulk!

edit shopify shop metafields import update create delete in bulk excel csv

Update Shop Metafields

  1. Follow section “Export Shop Metafields” to export your Shop Metafields.
  2. Edit your Metafields in the exported file.
  3. Delete (remove) those Metafield columns you do not wish to update to speed up the import.
  4. Save and import this file to update the Metafields.

Add additional Shop Metafields

  1. Follow the section “Export Shop Metafields” to export your Shop Metafields.
  2. In the exported file add the new Metafield columns that follow template – “Metafield: namespace.key [string]”, in example, “Metafield: excelify.my-metafield [string]”
    You can find a detailed explanation on how to construct Metafields with namespace, key and field type in this Metafields tutorial.
  3. Fill the values for your new Metafields in row 2.
  4. Save and import the file to create your Shop Metafields.

Delete Shop Metafields

  1. Follow section “Export Shop Metafields” to export your Shop Metafields.
  2. In the exported file – keep the columns, but clear the values in row 2 for the Metafields that you wish to delete.
  3. Save and import the file. The app will delete Metafields that have no values.

Good to know!

  • If you do not wish to change or delete some Metafields, just remove them from the import file entirely (remove the whole column with the column heading). Then Excelify app will keep this Store Metafield unchanged. That way – if you want to change one Metafield, you can have just this one column.
  • You can also import, export and update Metafields for Products, Customers, Collections, Orders and other items.
  • You can Delete, Create and Update different Metafields with the same import.
  • Check out our detailed tutorial about managing Metafields.
  • You can find more detailed information about displaying Metafields in Shopify tutorial about Metafield object –  https://help.shopify.com/en/themes/liquid/objects/metafield.
  • Excelify app documentation about Metafield columns is here: metafields documentation.
  • Have any questions or features you would like to see? Contact us now!