Product Metafields Template

Using Shopify metafields to store custom data about products is easy with the Mixtable Product Metafields template.

Examining product metafields data in a spreadsheet format can uncover valuable insights to optimize your store’s organization, improve product relationships, and boost operational efficiency. Here are some use cases:

• Product catalog optimization: discover opportunities to streamline product organization and improve searchability.
• Data quality improvement: standardize product entries and maintain consistent reference structures.
• Product naming standardization: analyze product title and description patterns to ensure consistency across the catalog.

How to load the Product Metafields template?

• After installing the Mixtable Spreadsheet Editor app, click the Create a Workbook button.
• Select the Product Metafields pre-built template from the list that appears in the dialog.

What data is included in the Product Metafields template?

You have two worksheets in the Product Metafields template workbook: Product Metafields and Variant Metafields.

The Product Metafields worksheet contains the following default columns:

• Product Title
• SEO Page Title
• SEO Meta Description
• Single line text
• Single preset choice (Mixtable auto-detects the possible preset choices and automatically adds a dropdown to each cell in the column.)
• List of preset choices
• Product reference - list (Mixtable detects that you’ve mapped a Product Reference metafield and will add a 🔍 button to each cell in the column.)
• Variant reference - list
• Page reference - list
• Product reference
• Variant reference
• Page reference
• Production

The Variant Metafields worksheet contains the following default columns:

• Title
• Handle
• Option 1
• Option 2
• Option 3
• Material Source

Add related data for Metafields to your Shopify Orders

Connecting order details with Metafields information used to mean VLOOKUP formulas. Not anymore! Mixtable now puts this data directly within your reach. Here's how to do it:

If you have already created a Mixtable workbook with your Shopify Order information, you can quickly add related data to it.

Note: The worksheet needs to show order information, e.g., you can use the Orders and Order Items template workbook, or the Orders or Order line items worksheets.

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 Link button in the column header to open the selection window to choose the data you want to pull in.

• From the Shopify Sync Settings window, choose Related Data Fields.

• Then, choose Metafields from the drop-down list.
• Allow some time for the data to appear in the columns; you are ready!

Find more about Related Data Fields functionality here.

Analyze Metafield data with spreadsheet functions

Operating in the Mixtable Spreadsheet Editor app allows you to use any spreadsheet function to analyze and manage your data, such as:

• sort ascending or descending,
• find-replacе,
• filter,
• use formulas, e.g., for price changes, etc.

Frequently Asked Questions:

Q: Can I manage metafields with preset choices or references with a spreadsheet?

A: Yes, with the Product Metafield template, you can manage the metafields per product and product variant with the drop-down functionality embedded in each field.

• Follow the steps from the beginning of this page to load the Product Metafields template spreadsheet.
• Use the drop-down options from the Single Preset Choices column to change metafield settings.
• Use the Product, Variant, or Page Reference columns to change reference metafields.

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.