Editing Shopify Metafield Lists

In April 2022, Shopify added metafield lists. You can use metafield lists to add product details, connect and recommend products or create more powerful search facets.

In order to follow along, you should have:

• The Bulk Product Editor app installed
• Have a metafield list defined 

If you do not have an existing metafield list, you can create metafields lists using single line text or product reference types in your admin settings.

Note: If you have added new metafield definitions to your Shopify store, you will need to refresh the metafield definitions in the Bulk Product Editor app. 

To load the most recent definitions from Shopify:

1. Open the Bulk Product Editor app
2. Go to Settings -> Shopify Data in the left menu
3. Click on the refresh icon next to Metafields

Using the In-App Editor to edit metafield lists

In this example, we will set the metafield list to new values.

1. Open the Bulk Product Editor app
2. Search for the products that you would like to edit
3. Select Edit Products

4. Field to Edit: name of the metafield list. In this case, "Countries of Origin"

5. How to Edit: Set to new value

6. Set the list to the new values, e.g., United States, Canada, Australia

7. Select Run Edit

Once the edit is complete, you will see these values listed on the Shopify admin's product page.

Using a Spreadsheet to edit metafield lists

1. Open up the Bulk Product Editor app 
2. Select Spreadsheet Edit near the top of the left hand side of the screen. 
3. Select Click to Upload Spreadsheet. You will then see a file selection screen.

4. Select the Excel or CSV spreadsheet to upload. The app will process the file and see which products each row matches with.

Once the file has been processed, you'll see the data from your spreadsheet on the screen: 

5. In the List column, choose the metafield list name

6. Select Run Edit

The Bulk Product Editor will set the metafield list to the values displayed in the list column.

For the spreadsheet edits, all the values for the list need to be in a single column. There are four ways to separate the items within the column:

• JSON Format: ["United States", "Canada", "Australia"]
• Comma-separated: United States,Canada,Australia
• Pipe-separated: United States|Canada|Australia
• Separated with a new line: each item is on a separate line within the same cell

The spreadsheet below shows the different ways that you can list values in a spreadsheet: