Fields Reference · Shopify

Shopify Fields List

155 fields · 0 dimensions · 0 metrics · 7 groups

Data Studio

Google Sheets

BigQuery

View Shopify connector →

155 of 155

Field name	Label	Category	Description
`date`	Date	Time	Date.
`date_time`	Date and Time	Time	The date and time of the order.
`day_of_week`	Day of week (Mon – Sun)	Time	Day of week (Mon – Sun).
`hour`	Hour	Time	Hour.
`month`	Month	Time	Month.
`month_day`	Month Day	Time	Month Day of the creation of the order.
`quarter`	Quarter	Time	Quarter.
`week`	Week	Time	Week.
`year`	Year	Time	Year.
`year_month`	Month and year	Time	Month and year.
`year_quarter`	Quarter and year	Time	Quarter and year.
`year_week`	Week and year	Time	Week and year.
`average_order_value`	Average order value	Orders	The average value of a staff’s sales.
`customers`	Total Customers	Orders	Count of customers
`discount_code`	Discount Code	Orders	Discount code provided by the customer.
`financial_status`	Financial Status	Orders	Financial status of the order that can be shown to the merchant. This field does not capture all the possible details of an order’s financial state and should only be used for display summary purposes.
`fulfillment_status`	Fulfillment Status	Orders	Fulfillment status for the order that can be shown to the merchant. This field does not capture all the possible details of an order’s fulfillment state. It should only be used for display summary purposes.
`landing_page_url`	Landing Page URL	Orders	URL of the first page the customer landed on for the session before an order is made.
`order_canceled_date`	Order Canceled Date	Orders	The date when the order was canceled in format. This fields returns null if the order wasn’t canceled.
`order_channel`	Channel	Orders	Name of the channel that this sub channel belongs to.
`order_channel_app_name`	Channel app name	Orders	Name of the channel app.
`order_closed_date`	Order Closed Date	Orders	Date time when the order closed. If the order is not closed, then this field returns null.
`order_creation_date`	Order Creation Date	Orders	The date the order was created.
`order_current_total_weight`	Order Current Total Weight	Orders	The total weight of the order after returns, in grams.
`order_id`	Order ID	Orders	Globally unique identifier of an order
`order_is_closed`	Order Is Closed	Orders	Whether the order is closed.
`order_is_confirmed`	Order Is Confirmed	Orders	Whether inventory has been reserved for the order
`order_is_edited`	Order Is Edited	Orders	Whether the order has had any edits applied.
`order_is_fully_paid`	Order is Fully Paid	Orders	Whether the order has been paid in full.
`order_is_refundable`	Order is Refundable	Orders	Whether the order can be refunded.
`order_is_test`	Is Test	Orders	Whether the order is a test order.
`order_name`	Order Name	Orders	Unique identifier for the order that appears on the order. For example, #1000 or _Store1001. This value is not unique across multiple stores.
`order_note`	Order Note	Orders	Contents of the note associated with the order.
`order_payment_gateway_names`	Order Payment Gateway Names	Orders	A list of the names of all payment gateways used for the order.
`order_processed_date`	Order Processed Date	Orders	The date when the order was processed.
`order_requires_shipping`	Order Requires Shipping	Orders	Whether any line item on the order requires physical shipping.
`order_risk_level`	Order Risk Level	Orders	The likelihood that an order is fraudulent. Valid values are HIGH, LOW and MEDIUM.
`order_tags`	Order Tags	Orders	A comma separated list of tags associated with the order.
`order_taxes_estimated`	Order Taxes Estimated	Orders	Whether taxes on the order are estimated. Many factors can change between the time a customer places an order and the time the order is shipped, which could affect the calculation of taxes. This field returns false when taxes on the order are finalized and aren’t subject to any changes.
`order_total_weight`	Order Total Weight	Orders	The total weight of the order before returns, in grams.
`order_updated_date`	Order Updated Date	Orders	The date the order was last updated.
`orders`	Orders	Orders	Count of the orders.
`physical_location_name`	Physical Location Name	Orders	The name of the physical location.
`referral_code`	Referral Code	Orders	Marketing referral code from the link that the customer clicked to visit the store. Supports the following URL attributes: ref, source, or r. For example, if the URL is myshopifystore.com/products/slide?ref=j2tj1tn2, then this value is j2tj1tn2.
`referrer_url`	Referrer URL	Orders	Webpage where the customer clicked a link that sent them to the online store. For example, https://randomblog.com/page1 or android-app://com.google.android.gm.
`sale_action_type`	Sale action type	Orders	The type of order action that the sale represents.
`sale_agreement_reason`	Sale agreement reason	Orders	The reason the agreement was created.
`sale_line_type`	Sale line type	Orders	The line type assocated with the sale.
`sale_quantity`	Number Of Sold Items	Orders	The number of units either ordered or intended to be returned.
`shipping_address_1`	Shipping Address 1	Orders	The first line of the address. Typically the street address or PO Box number.
`shipping_address_2`	Shipping Address 2	Orders	The second line of the address. Typically the number of the apartment, suite, or unit.
`shipping_city`	Shipping City	Orders	The name of the city, district, village, or town.
`shipping_coordinates`	Shipping Coordinates	Orders	The latitude and longitude coordinates of the customer address.
`shipping_country`	Shipping Country	Orders	The name of the country.
`shipping_country_code`	Shipping Country Code	Orders	The two-letter code for the country of the address. For example, US.
`shipping_country_icon`	Shipping Country Icon	Orders	Country icon.
`shipping_country_icon_url`	Shipping Country Icon Url	Orders	Country icon url.
`shipping_latitude`	Shipping Latitude	Orders	The latitude coordinate of the customer address.
`shipping_longitude`	Shipping Longitude	Orders	The longitude coordinate of the customer address.
`shipping_province`	Shipping Province	Orders	The region of the address, such as the province, state, or district.
`shipping_province_code`	Shipping Province Code	Orders	The two-letter code for the region. For example, ON.
`shipping_title`	Shipping title	Orders	The title of the shipping line.
`shipping_zip_code`	Shipping ZIP Code	Orders	The zip or postal code of the address.
`utm_campaign`	UTM Campaign	Orders	The name of a marketing campaign.
`utm_content`	UTM Content	Orders	Identifies specific content in a marketing campaign. Used to differentiate between similar content or links in a marketing campaign to determine which is the most effective.
`utm_medium`	UTM Medium	Orders	The medium of a marketing campaign, such as a banner or email newsletter.
`utm_source`	UTM Source	Orders	Source from which the customer visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown.
`utm_source_description`	UTM Source Description	Orders	Describes the source explicitly.
`utm_source_type`	UTM Source Type	Orders	Describes the source explicitly for first or last session.
`utm_term`	UTM Term	Orders	Paid search terms used by a marketing campaign.
`average_orders_per_customer`	Average Orders per Customer	Customer	Average number of orders per customer.
`cogs_minus_returns`	COGS (Minus Refunds)	Customer	COGS minus refunds.
`cost_per_order`	Cost Per Order	Customer	Cost per order.
`customer_accepts_marketing`	Customer Accepts Marketing	Customer	Whether the customer agreed to receive marketing materials.
`customer_creation_date`	Customer Creation Date	Customer	The date when the customer was added to the store.
`customer_display_name`	Customer Display Name	Customer	The full name of the customer, based on the values for first_name and last_name. If the first_name and last_name are not available, then this falls back to the customer’s email address, and if that is not available, the customer’s phone number.
`customer_email`	Customer Email	Customer	The customer’s email address.
`customer_first_name`	Customer First Name	Customer	The customer’s first name.
`customer_id`	Customer ID	Customer	Globally unique identifier for the customer.
`customer_image`	Customer Image	Customer	The image associated with the customer.
`customer_image_url`	Customer Image URL	Customer	The image associated with the customer.
`customer_last_name`	Customer Last Name	Customer	The customer’s last name.
`customer_last_order_date`	Customer Last Order Date	Customer	The customer’s last order creation date.
`customer_lifetime_duration`	Customer Lifetime Duration	Customer	The amount of time since the customer was first added to the store. Example: ‘about 12 years’.
`customer_orders_count`	Customer Orders Count	Customer	The number of orders that the customer has made at the store in their lifetime.
`customer_phone`	Customer Phone	Customer	The customer’s phone number.
`customer_state`	Customer State	Customer	The state of the customer’s account with the shop.
`customer_tags`	Customer Tags	Customer	A comma separated list of tags that have been added to the customer.
`customer_tax_exempt`	Customer Tax Exempt	Customer	Whether the customer is exempt from being charged taxes on their orders.
`customer_total_spent`	Customer Total Spent	Customer	The total amount that the customer has spent on orders in their lifetime.
`customer_type`	Customer Type	Customer	Whether the customer is placing their first order (First-time) or is a returning customer (Returning).
`customer_verified_email`	Customer Verified Email	Customer	Whether the customer has verified their email address. Defaults to true if the customer is created through the Shopify admin or API.
`gross_profit`	Gross Profit	Customer	Gross profit.
`new_customers`	New Customers	Customer	Count of customers placing their first order (First-time).
`new_customers_aov`	New Customers AOV	Customer	Average order value of customers placing their first order (First-time).
`new_customers_cost_of_goods_sold`	New Customers COGS	Customer	Cost of goods sold of customers placing their first order (First-time).
`new_customers_gross_sales`	New Customers Gross Sales	Customer	Gross sales of customers placing their first order (First-time).
`new_customers_gross_sales_percent`	New Customers Gross Sales %	Customer	Gross sales of customers placing their first order (First-time) over total gross sales.
`new_customers_net_sales`	New Customers Net Sales	Customer	Net sales of customers placing their first order (First-time).
`new_customers_net_sales_percent`	New Customers Net Sales %	Customer	Net sales of customers placing their first order (First-time) over total gross sales.
`new_customers_orders`	New Customer Orders	Customer	Count of orders from customers placing their first order (First-time).
`new_customers_ratio`	New Customers %	Customer	Ratio of new customers to total customers.
`new_customers_total_sales`	New Customers Total Sales	Customer	Total sales of customers placing their first order (First-time).
`new_customers_total_sales_percent`	New Customers Total Sales %	Customer	Total sales of customers placing their first order (First-time) over total sales.
`purchase_frequency`	Purchase Frequency	Customer	Purchase frequency.
`returning_customers`	Repeat Customers	Customer	Count of returning customers.
`returning_customers_aov`	Repeat Customers AOV	Customer	Average order value of returning customers.
`returning_customers_cost_of_goods_sold`	Repeat Customers COGS	Customer	Cost of goods sold of returning customers.
`returning_customers_gross_profit`	Repeat Customers Gross Profit	Customer	Gross profit of returning customers.
`returning_customers_gross_sales`	Repeat Customers Gross Sales	Customer	Gross sales of returning customers.
`returning_customers_gross_sales_percent`	Repeat Customers Gross Sales %	Customer	Gross sales of returning customers over total gross sales.
`returning_customers_net_sales`	Repeat Customers Net Sales	Customer	Net sales of returning customers.
`returning_customers_net_sales_percent`	Repeat Customers Net Sales %	Customer	Net sales of returning customers over total net sales.
`returning_customers_orders`	Repeat Customer Orders	Customer	Count of orders from returning customers.
`returning_customers_ratio`	Repeat Customers %	Customer	Ratio of returning customers to total customers.
`returning_customers_total_sales`	Repeat Customers Total Sales	Customer	Total sales of returning customers.
`returning_customers_total_sales_percent`	Repeat Customers Total Sales %	Customer	Total sales of returning customers over total sales.
`zero_dollar_orders`	0$ Orders	Customer	Count of orders with a zero dollar value.
`product_creation_date`	Product Creation Date	Product	The date when the product was created.
`product_description`	Product Description	Product	A stripped description of the product, single line with HTML tags removed.
`product_id`	Product ID	Product	Globally unique identifier of the product.
`product_image`	Product Image	Product	The Image object associated to the line item’s variant.
`product_image_url`	Product Image Url	Product	The Image object associated to the line item’s variant.
`product_price_range`	Product Price Range	Product	The price range of the product with prices formatted as decimals.
`product_seo_description`	Product SEO description	Product	SEO Description.
`product_seo_title`	Product SEO title	Product	SEO Title.
`product_status`	Product Status	Product	The product status. This controls visibility across all channels.
`product_tags`	Product Tags	Product	A comma separated list of tags associated with the product.
`product_title`	Product Title	Product	Title of the product.
`product_type`	Product Type	Product	The product type specified by the merchant.
`product_vendor`	Product Vendor	Product	Name of the vendor who made the variant.
`sku`	SKU	Product	Variant SKU number.
`variant_creation_date`	Variant creation date	Product	The date and time when the variant was created.
`variant_id`	Variant ID	Product	A globally-unique identifier of the product variant.
`variant_image`	Variant image	Product	The featured image for the variant.
`variant_image_url`	Variant image URL	Product	The featured image for the variant.
`variant_inventory_policy`	Variant inventory policy	Product	Whether customers are allowed to place an order for the product variant when it’s out of stock.
`variant_inventory_quantity`	Inventory Quantity	Product	The quantity of inventory in stock.
`variant_price`	Variant Price	Product	The price of the product variant in the default shop currency.
`variant_tax_code`	Variant Tax Code	Product	The tax code for the product variant.
`variant_title`	Variant Title	Product	Name of the variant.
`variant_unit_cost`	Unit Cost	Product	Unit cost associated with the inventory item. Note: the user must have ‘View product costs’ permission granted in order to access this field once product granular permissions are enabled.
`variant_unit_cost_currency_code`	Unit Cost Currency Code	Product	Unit cost currency code associated with the inventory item. Note: the user must have ‘View product costs’ permission granted in order to access this field once product granular permissions are enabled.
`cost_of_good_solds`	COGS	Sales	Cost of good solds. Equates to product unit cost x quantity.
`discounts_order`	Discounts	Sales	The sum of all applied discounts on this line item.
`gross_sales_order`	Gross Sales	Sales	Equates to product price x quantity (before taxes, shipping, discounts, and returns) for a collection of sales. Canceled, pending, and unpaid orders are included. Test and deleted orders are not included.
`net_sales_order`	Net Sales	Sales	Equates to gross sales – discounts – returns.
`returns_order`	Returns	Sales	The total amount refunded for each line item.
`shipping_order`	Shipping	Sales	The total amount charged for shipping the order.
`tax_order`	Tax	Sales	The total of all taxes applied to the order at the time it was created.
`total_sales_order`	Total Sales	Sales	Equates to gross sales – discounts – returns + taxes + shipping charges.
`unknown_fees`	Unknown Fees	Sales	An unknown sale line. Represents new types that may be added in future versions.
`shop_id`	Shop ID	Shop Info	ID of the shop.
`shop_name`	Shop Name	Shop Info	Name of the shop.
`line_item_id`	Line Item ID	Line Item	Unique identifier of the line item