Bulk edit Shopify metafields

Metafields allow you to add and display custom information on your products, collections, customers, orders, and other parts of your store that aren’t available in the standard Shopify admin. That can help with both SEO and conversion rate improvements, as well as with internal operations.

Mixtable’s spreadsheet interface makes it trivial to manage metafields in your Shopify store. Mixtable allows you to edit both v1.0 and v2.0 metafields.

• Mixtable allows you to edit all of the v2.0 metafield data types.
• Mixtable also supports list-type metafields and reference metafields, and makes it easy to add or remove content from them.

How to expand user experience with metafields

Here’s a list of the metafields per object you can use with Shopify and edit with the Mixtable spreadsheet app:

• Products: Use Product metafields to store additional information about individual products, such as specifications, features, or care instructions. This can help you improve your SEO. 
• Variants: Use metafields for your product variants to store specific details for different variations of a product, e.g., size or color. Offering these details on your product pages in a more user-friendly and scalable way can help you improve your conversion rate. 
• Collections: Use Collection metafields to add custom information to product category pages, like banner images or specific descriptions. Making your collection grid stand out, e.g., by adding a video among the product listings, can be done with a metafield and can keep your users longer on your page and increase the chance of purchase.
• Customers: Use metafields to store extra customer data, such as preferences or loyalty status, which can improve your personalization flows.  
• Orders: Use metafields for orders to include additional details related to specific orders, like gift messages or special packaging instructions.  
• Draft Orders: Similar to order metafields, but for orders that haven’t been finalized.  
• Blogs: Blog metafields will allow you to add extra information to your blog section.
• Articles: Article metafields will allow you to include specific details for individual blog posts, for example, a Recommended products section.    
• Pages: With Page metafields, you can add custom data to your static web pages.  
• Shop: If you add a metafield to the shop object, you can have store-wide information that isn’t tied to a specific product, order, etc.

With the Mixtable Spreadsheet Editor interface, you can have any metafield in an Excel-like format and edit it individually or in bulk.

Add Shopify metafields to a spreadsheet

You can add metafields for different objects to your spreadsheet in Mixtable and edit them individually or in bulk. Then sync them back to Shopify with one click. Here’s how:

1. Set up a workbook in Mixtable and set up a worksheet to sync the data whose metafields you’ll be editing. In the examples below we are using a worksheet that syncs our store’s Products, and so we’ll be editing Product metafields

2. To load new Shopify data, start by selecting an empty column — any column with a non-green header (green headers mean the column is already linked to Shopify data). Then, click the ⚡️ button in the column header to open the selection window to choose the data you want to pull in.

   

3. In the window that opens, select the Metafield radio button option

4. You’ll see that you are now being prompted for information on the metafield that we’ll map into this column. Each metafield in Shopify has a Namespace, a Name, and a Type. You can enter this information manually or select the metafield you want to sync from the dropdown list that Mixtable shows you. This dropdown contains the metafields that you’ve defined in your Shopify Admin. After you’ve selected your metafields, click the Save button.

5. You’ll now see Mixtable set up this new column with a heading (which you are free to change), and populate all the cells with any pre-existing data for the metafield you just set up.

6. Now, modify any of the cells with the values you want. In this case, we are setting up Product metafields for our products.

7. When you are done, click on the Sync sheet to Shopify button, and Mixtable will sync the metafield information to Shopify. It may take a few seconds before you see the new information in your store.

Optional: Use the Product Metafields pre-built template

You can create a workbook from the Product Metafields template, which will load Product and Variant metafields in two separate worksheets:

Metafields with preset choices/list of values

Note: In Shopify, you can define a metafield to be limited to one or more values from a list of preset choices. These are single-line text metafields that either allow a single value or a list of values to be set, but these values have to be one of the defined preset choices.

When you map such a metafield to a column, Mixtable will auto-detect the possible preset choices and automatically add a dropdown to each cell in the column.

Clicking on the dropdown will open a menu showing the preset choice options. This makes it a breeze to set values for such a metafield, without having to remember all the preset options, saving you time and minimizing sync errors.

Product Reference metafields

The Product Reference metafield is a great way to upsell/cross-sell and ultimately increase the AOV (average order value) of your cart. An excellent example for product references is the “Complete the Look” or “Shop the Outfit” product sections, where you recommend other products that would go well with a specific product, for example, a matching handbag, shoes, and a necklace to a dress.

If you make use of the Product Reference metafield type, you can use Mixtable’s spreadsheet to set metafield values in a very user-friendly manner, very quickly.

• Start by mapping your metafield to a column, as normal.

• Mixtable will detect that you’ve mapped a Product Reference metafield and will add a 🔍 button to each cell in the column.

• Press the 🔍 button to open up the product selector window. Here you’ll be presented with a list of your store’s products, which you can filter by name, handle, or description.

• Select the product, or products if you are making a list of product references, and Mixtable will populate the cell for you with the object notation that Shopify wants for these metafields - gid://shopify/Product/PRODUCTID. In our example, you select the specific handbag, shoes, and necklace from a dropdown list to link them.

• As a result, once you add the metafield to a section on the product page template, on the storefront, your theme can then display a dedicated section on the dress’s page titled “Complete the Look” that shows product cards for the linked items, making it easy for the customer to add them to their cart.

Variant reference metafields

If you utilize the Variant Reference metafield type, you can use Mixtable’s spreadsheet to set metafield values in a user-friendly manner.

• Start by mapping your metafield to a column, as normal. Mixtable will detect that you’ve mapped a Variant Reference metafield and will add a 🔍 button to each cell in the column.
• Press the 🔍 button to open up the variant selector window.
• Here you’ll be presented with a list of your store’s variants, which you can sort by name if you wish.
• Select the variant and Mixtable will populate the cell for you with the object notation that Shopify wants for these metafields - gid://shopify/ProductVariant/VARIANTID

Page reference metafields

If you utilize the Page Reference metafield type, you can use Mixtable’s spreadsheet to set metafield values in a user-friendly manner.

• Start by mapping your metafield to a column, as normal. Mixtable will detect that you’ve mapped a Page Reference metafield and will add a 🔍 button to each cell in the column.
• Press the 🔍 button to open up the page selector window.
• Here you’ll be presented with a list of your store’s pages, which you can filter by name and handle.
• Select the page, or pages if you are making a list of page references, and Mixtable will populate the cell for you with the object notation that Shopify wants for these metafields - gid://shopify/OnlineStorePage/PAGEID

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.