EZ Exporter: Shopify Product Fields Reference

You can 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.
category.full_name Category Full Name (type: text). The full name of the taxonomy category. For example, Animals & Pet Supplies > Pet Supplies > Dog Supplies > Dog Beds.
category.name Category Name (type: text). The name of the taxonomy category. For example, Dog Beds.
created_at Created At (type: datetime).
custom_collections.handle Custom Collections - Handles (type: text).
custom_collections.id Custom Collections - IDs (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. You can use the Custom Fields section to generate the product URL and variant URL based on this field. Please click here for details.
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 first 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. To export them in separate columns, please click here to see our guide.
options Options (type: text). Custom product property names like Size, Color, 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). The date and time when the product was published to the online store.
published_scope Published Scope (type: text). Whether the product is published to the Point of Sale channel. Valid values:
  • web: The product is not published to the Point of Sale channel.
  • global: The product is published to the Point of Sale channel.
smart_collections.handle Smart Collections - Handles (type: text).
smart_collections.id Smart Collections - IDs (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 Product 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.id Variant ID (type: number).
variants.image_src Variant Image URL (type: text). The image URL assigned to the 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. Includes location names and quantities for different inventory states. Please click here for info on how to extract inventory quantity by location.
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.total_available Variant Inventory Levels - Total Available (type: number). The inventory that a merchant can sell. Available inventory isn’t committed to any orders and isn’t part of incoming transfers.
variants.inventory_levels.total_committed Variant Inventory Levels - Total Committed (type: number). The number of units that are part of a placed order but aren't fulfilled. When a draft order is created, the inventory isn't committed until the draft order is completed and an order is created.
variants.inventory_levels.total_incoming Variant Inventory Levels - Total Incoming (type: number). The inventory that’s on its way to a merchant's location. For example, the inventory might be in an incoming shipment. Incoming inventory isn’t available to sell until it has been received and its state has been changed to available.
variants.inventory_levels.total_on_hand Variant Inventory Levels - Total On Hand (type: number). The total number of units that are physically at a location. The on_hand state equals the sum of inventory quantities that are in the available, committed, reserved, damaged, safety_stock, and quality_control states.
variants.inventory_levels.total_unavailable Variant Inventory Levels - Total Unavailable (type: number). The sum of inventory quantities that are in the reserved, damaged, safety_stock, and quality_control states.
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_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). The total sellable quantity of the variant.
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 g, kg, oz, or lb.
vendor Vendor (type: text).

Related Articles:

App: EZ Exporter

Tags: shopify, field reference, shopify fields