Fields listing for Shopify

The inventory product quantity.

The date and time (ISO 8601 format) when the product was created.

The unique product Id.

The first image of the product

The product price.

The date and time (ISO 8601 format) when the product was published. Can be set to null to unpublish the product from the Online Store channel.

The status of the product.

A string of comma-separated tags that are used for filtering and search. A product can have up to 250 tags. Each tag can have up to 255 characters.

The name of the product.

A categorization for the product used for filtering and searching products.

The date and time (ISO 8601 format) when the product was last modified. A product's updated_at value can change for different reasons. For example, if an order is placed for a product that has inventory tracking set up, then the inventory adjustment is counted as an update.

The product SKU.

The name of the product's vendor.

The product ID variant.

The name of the product variant.

Average Total Sales

The street address of the billing address.

An optional additional field for the street address of the billing address.

The city, town, or village of the billing address.

: The name of the country of the billing address.

The phone number at the billing address.

The name of the region (for example, province, state, or prefecture) of the billing address.

The postal code (for example, zip, postcode, or Eircode) of the billing address.

The name of the app that created the order, if the order was created by an app.

The cost of goods sold for the order in the shop currency. This is the sum of all inventory unit costs for the line items in the order.

The customer's city.

The customer's country.

The customer's country code.

The customer's email.

The customer's email.

The customer's first name.

A unique identifier for the customer.

The customer's last name.

The total order by the customer.

Whether the customer is returning or not.

The customer's total spend.

Year, month, and day.

Day of the year

Week of the year

The total discounts applied to the price of the order in the shop currency.

The total duties applied to the order in the shop currency.

The status of payments associated with the order. Possible values include: pending, authorized, partially_paid, paid, partially_refunded, refunded, voided.

The sum of all line item prices in the shop currency.

Hour of the day

The cost of the inventory unit in the shop currency.

Whether or not the line item is a gift card.

The URL of the page where the buyer landed when they entered the shop.

The total discounts applied to the price of the order in the shop currency.

The sum of all line item prices in the shop currency.

Get the line item id.

The price of the order in the shop currency after discounts but before shipping, duties, taxes, and tips.

The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive.

The sum of all the taxes applied to the order in the shop currency. Must be positive.

Source from which the customer visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown.

Type of marketing tactic.

Month and day

Month of the year

Get the original shopify domain.

Get the number of items

The date and time when the order was canceled. Returns null if the order isn't canceled.

The date and time (ISO 8601 format) when the order was closed. Returns null if the order isn't closed.

Whether inventory has been reserved for the order.

The autogenerated date and time (ISO 8601 format) when the order was created in Shopify. The value for this property cannot be changed.

The three-letter code (ISO 4217 format) for the shop currency.

The discount code use at the order level.

The customer's email address.

The order's status in terms of fulfilled line items.

The unique order Id.

The financial status of the order equals to paid.

Get the number of items

The URL for the page where the buyer landed when they entered the shop.

The fulfillment location used.

The order name, generated by combining the order_number property with the order prefix and suffix that are set in the merchant's general settings. This is different from the id property, which is the ID of the order used by the API. This field can also be set by the API to be any string value.

An optional note that a shop owner can attach to the order.

The website where the customer clicked a link to the shop.

Some special shipping instruction provided.

Tags attached to the order, formatted as a string of comma-separated values. Tags are additional short descriptors, commonly used for filtering and searching. Each individual tag is limited to 40 characters in length.

Quarter of the year

The total amount refunded for the order.

Fee captured as part of a return

The sales channel through which the order was placed, such as Online Store, POS, or Facebook.

The street address of the shipping address.

An optional additional field for the street address of the shipping address.

The city, town, or village of the shipping address.

: The name of the country of the shipping address.

The shipping method used for the order.

The phone number at the shipping address.

The name of the region (for example, province, state, or prefecture) of the shipping address.

The postal code (for example, zip, postcode, or Eircode) of the shipping address.

The source of the checkout.

Get the Store Id.

Get the Store Name.

The price of the order in the shop currency after discounts but before shipping, duties, taxes, and tips.

Total New Customer

Total Returning Customer

The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive.

The total shipping price of the order in the shop currency. Must be positive.

The sum of all the taxes applied to the order in the shop currency. Must be positive.

A/B testing and content-targeted ads to differentiate ads or links that point to the same URL.

The ad medium, such as email or cost-per-click (cpc).

The name that you give a promotion or campaign to identify it.

Identifies a search engine, a newsletter name, or other source.

The keywords associated with an ad.

Week of the year

Week of the year

Year such as 2017.

Year and month.

Year, month, day, and hour.

Year and quarter.

Year and week.