Shopify data reference

read
Last updated at:

You will learn

Learn what data syncs from Shopify to Klaviyo and where to view it. This includes both order data (such as Placed Order, Ordered Product, etc.) and customer data. If you have not already, read our guide on getting started with Shopify for step-by-step instructions on integrating, before continuing with this article.

Note that Shopify order data is only synced for profiles that have an email address; phone only profile activity is not currently synced to Klaviyo.

Table of contents

  1. How to view your data
  2. The Shopify metrics
  3. Synced customer data
  4. Frequency of the Shopify sync
  5. Verify your order data

How to view your data

Click the Analytics dropdown in the left-hand navigation sidebar and select Metrics. Here, you can view all of the metrics in your account. The metrics with a Shopify icon represent all of the metrics synced from your Shopify integration. You can filter this view to see only Shopify metrics by using the filter selector in the upper right-hand corner.
Metrics tab in Klaviyo filtered by Shopify showing list including Cancelled Order and Checkout Started

The Shopify metrics

Below is a list of all the metrics synced from Shopify and an explanation of the data included along with each metric. If you are interested in learning how to review the raw metric data that gets synced to Klaviyo, check out our guide.

Checkout Started

This event is tracked when a customer enters their contact and shipping information on the first page of the Shopify checkout process and clicks continue. The event that Klaviyo tracks includes all of the product information about the items in someone's cart including product names, images, and variant information so you can use this information in your abandoned cart emails.

This event syncs with a checkout URL property, which links back to each customer’s unique cart. If someone opens an abandoned cart email from a new device, this link will rebuild the person's cart when clicked through. You can filter and target Checkout Started events based on the following criteria:

  • $value
    The total value of the cart at time of started checkout. This may include any line prices, taxes, shipping costs, tips, and discounts.
  • Items
    The names of the products in someone's order, e.g., t-shirt or pants.
  • Collections
    The complete set of the collections of the products in someone's order, e.g., t-shirts, men's, pants and sale.
  • Item Count
    The count of line items in the order, e.g., 2. Note that this does not account for the quantity of items. Additionally, it is possible to add the same item to a cart multiple times and have it counted as multiple line items in Shopify; Klaviyo does not check for uniqueness or merge these for Item Count.
  • Discount Codes
    Any discount or coupon codes someone used towards the order, e.g., SPRING2015.
  • Total Discounts
    The total amount of any coupons or discounts if someone used  code, e.g., 10.00.

If there is billing address information available, we will also capture all relevant address details. If there is a referring site captured by Shopify, we will sync this as well.

Placed Order

This event is tracked when a customer completes the checkout process and creates an order in your Shopify store. The event Klaviyo tracks includes all of the product information about the items someone purchased including product names, images and variant information so you can use that information in purchase follow up emails. You can filter and target Placed Order events based on the following criteria:

  • $value
    The total value of the placed order, inclusive of shipping and any applied discounts
  • Items
    The names of the products in someone's order, e.g., t-shirt or pants.
  • Collections
    The complete set of the collections of the products in someone's order, e.g., t-shirts, mens, pants, and sale.
  • Item Count
    The count of line items in the order, e.g., 2. Note that this does not account for the quantity of items. Additionally, it is possible to add the same item to a cart multiple times and have it counted as multiple line items in Shopify; Klaviyo does not check for uniqueness or merge these for Item Count.
  • Discount Codes
    Any discount or coupon codes someone used towards the order, e.g., SPRING2015; while this isn't synced as a specific metric, there will be a Discount Codes property for each order that will allow you to see who purchased using particular codes.
  • Total Discounts
    The total amount of any coupons or discounts if someone used a code, e.g., 10.00.
  • Source Name
    POS, Mobile etc.

Revenue, or Placed Order value, is calculated as follows: (sub-total + shipping) - any discounts.

You may see that the Revenue value on your Klaviyo dashboard does not always match up with the revenue value you see in Shopify; this is because Shopify subtracts canceled and refunded orders from their revenue calculation, while Klaviyo does not.

Note that if you're looking to create a condition (like in a segment or flow) based on revenue for a customer over a certain period, you should use the Revenue metric and not the Placed Order metric. 
Segment definition in Klaviyo for what someone has done (or not done) has revenue is greater than 50 over all time

Placed Order and Ordered Product events are synced to Klaviyo seconds apart. For this reason, it is important to be consistent with the metric you use to trigger and filter your flows and segments. For example, if your flow is triggered by the Placed Order event and you add a filter to exclude anyone who Ordered Product since starting the flow, all recipients will be skipped because the two events are separate, but sync seconds apart. As a best practice, use the Placed Order event to trigger and filter flows and segments.

Ordered Product

This event is also tracked when a customer places an order, but a separate event is tracked for each item someone purchases. For example, if someone buys a t-shirt and a pair of pants, one Placed Order event will be tracked along with two Ordered Product events; one Placed Order event for the purchase as a whole, and then one Ordered Product event for the t-shirt and one Ordered Product event for the pants.

The events Klaviyo tracks includes detailed information about each product someone purchases. This is useful when creating behavioral segments based on product variant options and other detailed information that's not available in the Placed Order event. You can filter and target Ordered Product events based on the following criteria:

  • $value
    The total value of the item purchased; no shipping costs or discounts included.
  • Name
    The name or title of the ordered product in Shopify, e.g., t-shirt.
  • Variant Name
    The name or title of the product variant in Shopify, e.g., red, size medium t-shirt.
  • SKU
    The SKU of the product variant, e.g., REDMEDIUMTSHIRT.
  • ProductID
    The ID associated with the product in your store.
  • Quantity
    The total quantity ordered of the product.
  • Collections
    The complete set of collections or categories applied to the product, e.g., t-shirts, men's and sale.
  • Tags
    Any tags applied to the product in your store.
  • Variant Option: <OptionName>
    The name and value of any variant options for the variant ordered, e.g., Variant Option: Size would be Medium and Variant Option: Color would be Red.
  • Attribute: <AttributeName>
    The name and value of any product attributes for the product ordered, e.g., Attribute: Season would be Spring.

Fulfilled Order

This event is tracked when an order is marked as "fulfilled" in your Shopify store. Klaviyo will track a Fulfilled Order event specifically when we sync an order with a Fulfillment Status of "fulfilled."

The event Klaviyo tracks includes all product information regarding the items someone purchased including product names and images so you can use that information in purchase follow up emails. You can filter and target Fulfilled Order events based on the following criteria:

  • $value
    The total value of the fulfilled order.
  • Items
    The names of the products in someone's order, e.g., t-shirt or pants.
  • Collections
    The complete set of the collections of the products in someone's order, e.g., t-shirts, men's, pants, and sale.
  • Item Count
    The count of line items in the order, e.g., 2. Note that this does not account for the quantity of items. Additionally, it is possible to add the same item to a cart multiple times and have it counted as multiple line items in Shopify; Klaviyo does not check for uniqueness or merge these for Item Count.
  • Discount Codes
    Any discount or coupon codes someone used towards the order, e.g., SPRING2015.
  • Total Discounts
    The total amount of any coupons or discounts if someone used a code, e.g., 10.00.

Fulfilled Partial Order

This event is tracked when an order that has been placed is partially fulfilled. For example, if you opt to ship order items in multiple shipments and want to send transactional emails for each stage in the fulfillment of an order, Fulfilled Partial Order events can be leveraged such that customers are notified when their items will be delivered. View our guide for more information on setting up flows based on Fulfilled Partial Order events.

Cancelled Order

This event is tracked when a customer creates an order in your Shopify store but then cancels the order before fulfillment. The event Klaviyo tracks includes all of the product information about the items someone purchased including product names and images. You can filter and target Canceled Order events based on the following criteria:

  • $value
    The total value of the canceled order.
  • Items
    The names of the products in someone's order, e.g., t-shirt or pants.
  • Collections
    The complete set of the collections of the products in someone's order, e.g., t-shirts, men's, pants and sale.
  • Item Count
    The count of line items in the order, e.g., 2. Note that this does not account for the quantity of items. Additionally, it is possible to add the same item to a cart multiple times and have it counted as multiple line items in Shopify; Klaviyo does not check for uniqueness or merge these for Item Count.
  • Discount Codes
    Any discount or coupon codes someone used towards the order, e.g., SPRING2015.
  • Total Discounts
    The total amount of any coupons or discounts if someone used a code, e.g., 10.00.

Refunded Order

This event is tracked when a customer completes the checkout process in your Shopify store and a payment is made, but the customer requests the payment to be returned. Klaviyo only receives events from fully refunded orders (not partially refunded orders). The event Klaviyo tracks includes all of the product information about the items someone purchased including product names, images, and variant information. You can filter and target Refunded Order events based on the following criteria:

  • $value
    The total value of the refunded order.
  • Items
    The names of the products in someone's order, e.g., t-shirt or pants.
  • Collections
    The complete set of the collections of the products in someone's order, e.g., t-shirts, men's, pants and sale.
  • Item Count
    The count of line items in the order, e.g., 2. Note that this does not account for the quantity of items. Additionally, it is possible to add the same item to a cart multiple times and have it counted as multiple line items in Shopify; Klaviyo does not check for uniqueness or merge these for Item Count.
  • Discount Codes
    Any discount or coupon codes someone used towards the order, e.g., SPRING2015.
  • Total Discounts
    The total amount of any coupons or discounts if someone used a code, e.g., 10.00.

Abandoned Checkout

Shopify's Abandoned Checkout metric is different from its Checkout Started metric. Klaviyo's Abandoned Cart flow is triggered by the Checkout Started metric, while Shopify's Abandoned Cart flow is triggered by the Abandoned Cart metric.

When customers migrate from Shopify's Abandoned Cart flow to Klaviyo's Abandoned Cart flow, they are sometimes confused by the difference between the Checkout Started metric in Klaviyo and the Abandoned Cart metric in Shopify.

Abandoned Checkout occurs in Shopify when a customer leaves checkout after the first page without completing their purchase. When a potential customer provides their contact information and/or is logged into their Shopify account, and then continues to the next page of the checkout but doesn't complete the order, their cart is stored as an abandoned checkout. It is possible for an abandoned checkout to be recorded in Shopify even if there is no email address associated with it. 

While Shopify tracks Abandoned Checkout events, Klaviyo tracks Checkout Started events.  This is because Checkout Started necessarily captures an email address which Klaviyo uses for sending abandoned cart emails.

Remember that customers do not need to be subscribed to your newsletter list in order to trigger a Checkout Started event in Klaviyo.

Checkout Started vs Abandoned Checkout

Since Checkout Started events recorded in Klaviyo are different than Abandoned Checkout events in Shopify, comparing the two numbers can be misleading.

One crucial difference between these events is that customers who Abandon Checkout in Shopify may or may not submit or be associated with their email address. 

In contrast, a Checkout Started event in Klaviyo requires that a customer enter their contact information (which includes their email address,) submit the information, and then proceed to the second Shopify checkout screen. 

This is why you may see a larger number of Abandoned Checkouts in Shopify, and a fewer number of Checkout Started events in Klaviyo.

Do I need to disable the Abandoned Checkout notification in Shopify or will Klaviyo do this automatically? 

You will need to do this manually. To turn off Shopify’s Abandoned Cart Recovery head over to Settings > Checkout and then scroll down until you see Abandoned checkouts, under the Email Marketing section. You will need to uncheck the box that says "Automatically send abandoned checkout emails." 

Synced customer data

In addition to the metrics Klaviyo syncs from Shopify, Klaviyo will also create a unique profile for every customer that we sync. When we sync contact information, there are also certain custom properties that may get added to each Klaviyo Profile. You can use these properties in segments and in flows. Here are the properties that are automatically synced from Shopify:

  • Email, First and Last Name, City, State/Region, Zip Code, Country, Phone Number
    These built-in Klaviyo fields are automatically populated with all available data from Shopify.
  • Accepts Marketing
    Whether or not a customer has opted-in to receive marketing, e.g., True/False.
  • Shopify Tags
    Any custom tags assigned to that customer in Shopify, e.g., Wholesale or VIP.

Frequency of the Shopify sync

Metrics and profile properties from Shopify are synced in real-time. You should see event data appear in your Klaviyo account within a few seconds of when the event is tracked in your Shopify store.

Because we sync all metrics in real-time, any tags - such as Order Tags - that might be added to an order after it is processed will not sync into Klaviyo. Klaviyo does not re-sync metrics after the initial event takes place, so no tags or adjustments made to an order after-the-fact will be updated in Klaviyo.

Verify your order data

Klaviyo imports all of your Shopify data. To verify this, you can compare the number of orders on a particular day with what's in the Shopify interface and confirm they match.

  1. Select the Analytics dropdown, click Metrics, find the Placed Order metric, and click on it. This will take you to the metric's reporting page and show the last 30 days of data by default.
  2. Hover over yesterday's data point or look in the table of data below the chart to see how many orders you had yesterday.
  3. Compare that number to what's stored in Shopify and you should see them match exactly. If they don't, the most likely issue is your Klaviyo account's timezone doesn't match Shopify's timezone.
  4. To check or update your Klaviyo account's timezone, go to the Account Settings page (found by clicking your account name in the lower left, then clicking Settings) navigate to Contact Information > Organization and scroll down to Timezone.

Here is a chart in the Klaviyo Metrics tab showing the Placed Order metric. 

Chart in Klaviyo showing number of Shopify Placed Order events from 08/12/17 to 9/11/17

Additional resources

x
Was this article helpful?
324 out of 492 found this helpful