Import / Export metafields, upload data through CSV

I know this is an old thread but I can not find anything from Shopify or in the community stating you can import metafields however Google Gemini stated it could be done and I was able to do so by following the instructions below. (note if you already have a CSV file to import you can skip exporting it from shopify and just add the metafields you want to import into your CSV file).

To import metafields into Shopify, you need to export your existing metafield data into a CSV file, then use the Shopify admin’s product import feature to upload that CSV, ensuring the columns are correctly mapped to the relevant metafield namespaces and keys within the file; this can be done directly in the Shopify admin or through a third-party app that facilitates bulk metafield management.

Key steps:

  • Create metafields:
    In your Shopify admin, go to Settings > Custom data > Products > Metafields to define the necessary metafields with their corresponding namespaces and keys.

  • Export metafields:

    • Navigate to Products in your Shopify admin.

    • Select Export and choose the option to include metafields in the CSV file.

    • Download the exported CSV file.

  • Edit CSV file:

    • Open the downloaded CSV file in a spreadsheet program.

    • Ensure the column headers match the format: “Metafield Name (product.metafields..)”.

    • Update the values in the relevant columns to match your desired metafield data.

  • Import CSV file:

    • Go back to Products in your Shopify admin.

    • Select Import.

    • Choose the edited CSV file and click Upload.

    • Review the mapping between the CSV columns and Shopify fields to ensure accurate import.