BigCommerce data reference

You will learn

Learn what data is synced to Klaviyo when you integrate with your BigCommerce store, such as order and customer data, and how to access it in Klaviyo.

Metrics synced from BigCommerce

After you've integrated with BigCommerce, click the Analytics dropdown in Klaviyo and select Metrics to see all of the metrics in your account. Here, you can filter by BigCommerce to see which metrics are synced from the integration.

Started Checkout

The event Klaviyo tracks includes all of the product information about the items in someone's cart including product names, images and category information so you can use that information in your Abandoned Cart emails.

• $value
  The total value of the cart at time of checkout
• Discounted
  Whether BigCommerce reports a discount amount greater than 0 (true/false)
• Item Categories
  The complete set of the categories of the products in someone's cart, e.g., t-shirts, mens, pants and sale
• Item Count
  The number of items in the cart, e.g., 2
• Items
  The names of the products in someone's cart, e.g., t-shirt or pants
• Coupons
  (optional array)
• Channel ID
  The ID of the channel for the checkout

Placed Order

This event is tracked when a customer completes the checkout process and creates an order in your BigCommerce store.

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

• $value
  The order total reported by BigCommerce, including tax
• Discounted
  Whether BigCommerce reports a discount amount greater than 0 (true/false)
• Item Categories
  The complete set of the categories of the products in someone's cart, e.g., t-shirts, mens, pants and sale
• Item Count
  The number of items in the order, e.g., 2
• Items
  The names of the products in someone's order, e.g., t-shirt or pants
• Coupons
  (optional array)
• Channel ID
  The ID of the channel for the order

Revenue, or Placed Order value, uses the order total reported by BigCommerce, including tax and shipping and after discounts.

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

Ordered Product

This event is tracked when a customer places an order. For whole-number quantities, a separate event is tracked for each unit purchased. For example, if someone buys a t-shirt and a pair of pants, 1 Placed Order event is tracked and 2 Ordered Product events: 1 for the t-shirt and 1 for the pants. Klaviyo tracks up to 100 Ordered Product events per line item.

The event Klaviyo tracks includes detailed information about each product someone purchases. This is useful when creating behavioral segments based on product variation 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:

• Name
  The name or title of the product in BigCommerce, e.g., t-shirt
• $value
  The value of the purchased unit, including tax and after discounts. For fractional quantities, this is the total value of the line item.
• SKU
  The SKU of the product variation e.g., REDMEDIUMTSHIRT
• Categories
  The complete set of the categories of the product, e.g., t-shirts, mens and sale
• Product Price
  The price of the product
• Product Cost
  The cost of the product
• Price
  The total for this product line in the order, excluding tax
• Discounted
  Whether a discount was applied to the product line (true/false)
• ProductID
  The ID of the ordered product
• Quantity
  1 for each event when the ordered quantity is a whole number. For a fractional quantity, 1 event contains that quantity.
• Option (Optional)
  Custom product attributes
• Channel ID
  The ID of the channel for the order

Fulfilled Order

This event is tracked when an order's status updates to either Shipped or Completed.

The Fulfilled Order event Klaviyo tracks includes all of the product information about the items someone purchased including product names, images and variation information 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 order total reported by BigCommerce, including tax
• Discounted
  Whether BigCommerce reports a discount amount greater than 0 (true/false)
• Item Categories
  The complete set of the categories of the products in someone's cart, e.g., t-shirts, mens, pants and sale
• Item Count
  The number of items in the order, e.g., 2
• Items
  The names of the products in someone's order, e.g., t-shirt or pants
• Coupons
  (optional array)
• Channel ID
  The ID of the channel for the order

Cancelled Order

This event is tracked when an order's status is Cancelled. The event Klaviyo tracks includes all of the product information about the items someone purchased including product names, images and variation information so you can use that information in purchase follow up emails. You can filter and target Cancelled Order events based on the following criteria:

• $value
  The order total reported by BigCommerce, including tax
• Discounted
  Whether BigCommerce reports a discount amount greater than 0 (true/false)
• Item Categories
  The complete set of the categories of the products in someone's cart, e.g., t-shirts, mens, pants and sale
• Item Count
  The number of items in the order, e.g., 2
• Items
  The names of the products in someone's order, e.g., t-shirt or pants
• Coupons
  (optional array)
• Channel ID
  The ID of the channel for the order

Refunded Order

This event is tracked when an order's status is Refunded or Partially Refunded. The product details describe the whole order, including items that may not have been refunded. You can filter and target Refunded Order events based on the following criteria:

• $value
  The refunded amount reported by BigCommerce. If no nonzero refunded amount is supplied, the event uses the order total including tax.
• Items
  The names of the products in someone's order, e.g., t-shirt or pants
• Item Categories
  The complete set of categories of the products in the order
• Item Count
  The number of items in the order, e.g., 2
• Item Brands
  The brands of the products in the order
• Discounted
  Whether BigCommerce reports a discount amount greater than 0 (true/false)
• Status
  The status of the order, e.g., Refunded
• Channel ID
  The ID of the channel for the order

Customer data synced from BigCommerce

In addition to the metrics Klaviyo syncs from BigCommerce, there are also custom properties that are added to each Klaviyo profile. You can use these properties in segments and in flows. Here are the properties that are automatically synced from BigCommerce:

• Email, First Name, Last Name, City, Phone Number
  These built-in Klaviyo fields are automatically synced with the integration.

• External ID
  Klaviyo also syncs customers' external IDs. This means that if a customer creates an account with your BigCommerce store, we will sync this ID along with their email address. If the same customer then goes on to change the email address associated with the account, we will map the new address to their external ID and update the email address associated with their profile.
• BigCommerce Origin Channel
  The channel ID recorded as the customer's origin in BigCommerce, when available.
• BigCommerce Channels
  The channel IDs associated with the BigCommerce customer account, when available.

If a customer does not create an account, no external ID will be created, and we will use their email address to map all data. If a customer does not create an account at first, but later creates one with the same email address, an external ID will be added to their profile.

You may have additional custom properties associated with your BigCommerce profiles. These two custom properties can also be synced to Klaviyo:

• BigCommerce: Customer Group
  Customer Groups allow you to organize your customers, give them discounts, and restrict access to specific products or categories.
• BigCommerce Store Credit

Open the Details tab of a Klaviyo profile to find the Custom properties section:

Frequency of the BigCommerce sync

BigCommerce sends new and updated order, cart, customer, and catalog data to Klaviyo in real time. Klaviyo also checks for order updates every 10 minutes, customer updates hourly, and catalog updates every 2 hours.

How to verify your synced order data

When you first integrate, Klaviyo imports historical order, customer, and catalog data going back up to 10 years. Wait for the initial sync to finish before comparing daily order counts in Klaviyo and BigCommerce. Ongoing updates follow the schedule described above.

1. In Klaviyo, navigate to Analytics > Metrics. Select BigCommerce in the Integration filter.
2. Click Placed Order to open the metric chart, which shows the last 30 days by default. Set View by to Daily and Measurement to Total.
3. Mouse over yesterday's data point or look in the table below the chart to see yesterday's order count. Compare it with BigCommerce orders for the same day, using the same time zone and accounting for the order statuses excluded from Placed Order, as described above.
4. If the counts differ, check that the initial sync has finished and that both reports use matching order statuses and time zones. To check your Klaviyo time zone, open Settings > General > Account and find Time zone. If you change it, click Save.

Additional resources