Product Variants

Discover how to efficiently manage and analyze variants from your Shopify store. Learn to use the Product Variants dataset to generate detailed lists of items that meet your specific criteria.

Export Results

Variants are combinations of option values for a product, such as size or color. For example, suppose that you sell T-shirts with two options: size and color. The size option has three values: small, medium, and large. The color option has two values: blue and green. One specific variant from these options is a small, blue T-shirt.

By utilizing the Product Variants dataset, you can access comprehensive information about these items as well as details regarding the product.


Product Filters

If necessary, you have the option to restrict the number of returned items by applying filters to the export. The following fields are available for this purpose:

  • Product Type (Product): The product type specified by the merchant.

  • Title (Product): The title of the product.

  • Vendor (Product): The name of the product's vendor.

  • Status (Product): active, archived, draft.

  • Tag (Product): Tag associated with the product.

  • Created At (Product): The date and time when the product was created.

  • Updated At (Product): The date and time when the product was last modified.


Product Metafields

Metafields can be utilized to tailor the functionality and look of your Shopify store by enabling you to store specific information that is not typically recorded in the Shopify admin. These metafields can serve for internal tracking or to showcase specialized details on your online store in various formats.

To export metafields for products, simply input the metafield namespace and key values:

You can get these values from the Product metafield definitions page in your Shopify Admin:

For the given example, you would need to input these namespaces and keys, along with a descriptive header name to locate it in the sheet:


Variant Metafields

To export metafields for variants, simply input the metafield namespace and key values:

You can get these values from the Variant metafield definitions page in your Shopify Admin:

For the given example, you would need to input these namespaces and keys, along with a descriptive header name to locate it in the sheet:

Last updated