EZ Exporter: Shopify Product Fields Reference

You can also reference the Field IDs below in a Custom Field or Calculated Field by enclosing them in double curly braces (e.g. {{ updated_at }}).

Field ID Description
body_html Body HTML (type: text). The product description, complete with HTML formatting. To remove the HTML tags, use the formula strip_html_tags({{ body_html }}) in Calculated Fields.
created_at Created At (type: datetime).
custom_collections.handle Custom Collections - Handles (type: text).
custom_collections.id Custom Collections - IDs (type: text).
custom_collections.published_scope Custom collections - Published Scopes (type: text).
custom_collections.template_suffix Custom collections - Template Suffixes (type: text).
custom_collections.title Custom Collections - Titles (type: text).
handle Handle (type: text). A human-friendly unique string for the Product automatically generated from its title.
id Product ID (type: number). The unique numeric identifier for the product. Product IDs are unique across the entire Shopify system; no two products will have the same id, even if they are from different shops.
image.alt Image Alt (type: text).
image.height Image Height (type: text).
image.src Image URL (type: text). The image URL for the product.
image.width Image Width (type: text).
images.position Images Positions (type: text).
images.src Images URLs (type: text). A comma-separated list of all image URLs for the product.
options Options (type: text). Custom product property names like SizeColor, and Material. Products are based on permutations of these options. A product may have a maximum of 3 options.
options.name Options Names (type: text).
options.position Options Positions (type: text).
options.values Options Values (type: text).
product_type Product Type (type: text).
published_at Published At (type: datetime).
published_scope Published Scope (type: text). Indicates whether the product is published to the Point of Sale channel. Valid values:
  • web: The product is published to the Online Store channel but not published to the Point of Sale channel.
  • global: The product is published to both the Online Store channel and the Point of Sale channel.
smart_collections.handle Smart Collections - Handles (type: text).
smart_collections.id Smart Collections - IDs (type: text).
smart_collections.published_scope Smart Collections - Published Scopes (type: text).
smart_collections.template_suffix Smart Collections - Template Suffixes (type: text).
smart_collections.title Smart Collections - Titles (type: text).
status Status (type: text). The status of the product. Valid values:
  • active: The product is ready to sell and is available to customers on the online store, sales channels, and apps. By default, existing products are set to active.
  • archived: The product is no longer being sold and is not available to customers on sales channels and apps.
  • draft: The product is not ready to sell and is unavailable to customers on sales channels and apps. By default, duplicated and unarchived products are set to draft.
tags Tags (type: text).
template_suffix Template Suffix (type: text). The suffix of the liquid template being used. By default, the original template is called product.liquid, without any suffix. Any additional templates will be: product.suffix.liquid.
title Title (type: text).
updated_at Updated At (type: datetime).
variants.barcode Variant Barcode (type: text).
variants.compare_at_price Variant Compare At Price (type: number). The competitors price for the same item.
variants.created_at Variant Created At (type: datetime).
variants.fulfillment_service Variant Fulfillment Service (type: text).
variants.grams Variant Grams (type: number).
variants.id Variant ID (type: number).
variants.image_id Variant Image ID (type: text).
variants.image_src Variant Image URL (type: text). The image URL for this variant.
variants.inventory_item.cost Variant Inventory Item - Cost (type: number). The unit cost of the inventory item.
variants.inventory_item.country_code_of_origin Variant Inventory Item - Country Code of Origin (type: text). The two-digit code for the country where the inventory item was made.
variants.inventory_item.created_at Variant Inventory Item - Created At (type: datetime).
variants.inventory_item.harmonized_system_code Variant Inventory Item - Harmonized System Code (type: text). The general Harmonized System (HS) code for the inventory item. Used by border officers to classify this product.
variants.inventory_item.province_code_of_origin Variant Inventory Item - Province Code of Origin (type: text). The two-digit code for the province where the inventory item was made. Used only if the shipping provider for the inventory item is Canada Post.
variants.inventory_item.tracked Variant Inventory Item - Tracked (type: text). Whether the inventory item is tracked. If true, then inventory quantity changes are tracked by Shopify. Valid values are True or False.
variants.inventory_item.updated_at Variant Inventory Item - Updated At (type: datetime).
variants.inventory_item_id Variant Inventory Item ID (type: number).
variants.inventory_levels Variant Inventory Levels (type: text). The raw JSON data of this variant's inventory levels.
variants.inventory_levels.available Variant Inventory Levels - Available Quantities (type: text). The available quantities in all locations separated by a comma.
variants.inventory_levels.location_id Variant Inventory Levels - Location IDs (type: text). The list of location IDs separated by comma.
variants.inventory_levels.location_name Variant Inventory Levels - Location Names (type: text). The list of location names separated by comma.
variants.inventory_levels.updated_at Variant Inventory Levels - Updated Dates (type: text). The list of dates when the inventory level was last updated in each location separated by a comma.
variants.inventory_management Variant Inventory Management (type: text). Specifies whether or not Shopify tracks the number of items in stock for this product variant.
variants.inventory_policy Variant Inventory Policy (type: text). Specifies whether or not customers are allowed to place an order for a product variant when it's out of stock.
variants.inventory_quantity Variant Inventory Quantity (type: number).
variants.option1 Variant Option 1 (type: text).
variants.option2 Variant Option 2 (type: text).
variants.option3 Variant Option 3 (type: text).
variants.position Variant Position (type: text). The order of the product variant in the list of product variants. 1 is the first position. To reorder variants, update the product with the variants in the desired order.
variants.price Variant Price (type: number).
variants.requires_shipping Variant Requires Shipping (type: text).
variants.sku Variant SKU (type: text).
variants.taxable Variant Taxable (type: text). Whether a tax is charged when the product variant is sold. Valid values are True or False.
variants.title Variant Title (type: text).
variants.updated_at Variant Updated At (type: datetime).
variants.weight Variant Weight (type: number). The weight of the product variant in the unit system specified with weight_unit.
variants.weight_unit Variant Weight Unit (type: text). The unit system that the product variant's weight is measure in. The weight_unit can be either gkgoz, or lb.
vendor Vendor (type: text).

Related Articles:


App: EZ Exporter

Tags: shopify, field reference, shopify fields