Shopify activities and attributes

Overview

This page lists all default Shopify activities that are added to your Ortto account after integrating Ortto with Shopify when adding Shopify as a data source.

Accessing Shopify activities

Navigate to CDP > Activities > All > Shopify.

Abandoned checkout

The abandoned checkout activity is generated by Ortto based on a customer starting a checkout and not completing an order after 90 minutes. They may still complete an order after 90 minutes so it is important to use this activity in conjunction with the Place order activity to determine if a recent checkout is still in an abandoned state.

Attribute	Field type	Description
Abandoned checkout URL	URL	This is the URL to resume the abandoned checkout.
Line item names	List (array of items)	This is a list of items in the cart by name.
Shipping price	Currency	This is the cost of shipping.
Total weight	Number	This is the total weight of all items combined.
Subtotal price	Currency	The price of the order in the shop currency after discounts but before shipping, taxes, and tips.
Total line item price	Currency	The price of all of the line item prices added together.
Item count	Number	The total number of items.
Discount codes	List (array of items)	A list of discount codes applied to the cart.
Total discount	Currency	The total discount applied.
Currency	Text	The currency used.
Source	Text	The source of the order e.g. Web, POS, iPhone, and Android.
Referring site	URL	This is the URL of the referrer that brought the customer to your store. e.g. `https://www.google.com/search?q=great+products`
Collections	List (array of items)	This is a list of the collections relevant to items in the cart.
Tags	List (array of items)	This is a list of all the tags related to items in your cart.
Total price	Currency	This is the total price of the abandoned order.
Total tax	Currency	This is the total tax of the abandoned order.
Total tip	Currency	This is the total tip of the abandoned order.
Note	Text	This is the note (if any) associated with the order.
Country	Geo	The country of the customer who started the checkout.
Region	Geo	The region of the customer who started the checkout.
City	Geo	The city of the customer who started the checkout.

Abandoned cart

The abandoned cart activity is generated by Ortto based on a customer having added to cart without checkout started having occurred after 90 minutes. The customer does not need to have visited the cart page, the Abandoned cart will trigger when a user adds a product to the cart and ends their session without checking out. They may still complete an order after 90 minutes so it is important to use this activity in conjunction with the Placed order activity to determine if a recent cart is still in an abandoned state.

Attribute	Field type	Description
Line item names	List (array of items)	This is a list of items in the cart by name.
Total price	Currency	This is the total price of the abandoned cart.
Item count	Number	The total number of items.
Collections	List (array of items)	This is a list of the collections relevant to items in the cart.
Tags	List (array of items)	This is a list of all the tags related to items in your cart.
Country	Geo	The country of the customer who abandoned the cart.
Region	Geo	The region of the customer who abandoned the cart.
City	Geo	The city of the customer who abandoned the cart.

Added product to cart

The Shopify added to cart activity is generated by Ortto when a customer adds products and navigates to their cart.

Attribute	Field type	Description
Title	Text	The title of the product.
Variant title	Text	The variant title.
Inventory quantity	Number	The inventory quantity of the products added to the cart.
Weight	Number	The weight of the items added to the cart.
SKU	Text	The product SKU.
Device	Text	The device used by the customer. e.g. Desktop.
Vendor	Text	The vendor of the product.
Collections	List (array of items)	Collections that the product belongs to.
Tags	List (array of items)	Tags related to the item.
Price	Currency	The price of the item added to cart.
Currency	Text	The currency used.
Product URL	Link	The URL of the item added to the cart.
Country	Geo	The country of the customer who added the product to the cart.
Region	Geo	The region of the customer who added the product to the cart.
City	Geo	The city of the customer who added the product to the cart.

Back in stock

The back in stock activity is generated by Ortto when a customer has requested to be notified when a certain item is back in stock.

Attribute	Field type	Description
Title	Text	The title of the product that is back in stock.
Inventory quantity	Number	The inventory quantity of the product back in stock.
Variant title	Text	The title of the variant if applicable.
SKU	Text	The SKU of the product.
Vendor	Text	The vendor of the product.
Collections	List (array of items)	Collections that the product belongs to.
Tags	List (array of items)	Tags related to the item.
Weight	Number	The weight of the item back in stock.
Price	Currency	The price of the item back in stock.
Currency	Text	The currency used.
Product URL	Text	The URL of the item.
Country	Geo	The country of the customer.
Region	Geo	The region of the customer.
City	Geo	The city of the customer.

Checkout started

This activity occurs when the checkout process begins and the user is identified.

Attribute	Field type	Description
Line item names	List (array of items)	This is a list of items in the cart by name.
Shipping price	Currency	This is the cost of shipping.
Total weight	Number	This is the total weight of all items combined.
Subtotal price	Currency	The price of the order in the shop currency after discounts but before shipping, taxes, and tips.
Total line item price	Currency	The price of all of the line item prices added together.
Item count	Number	The total number of items.
Discount codes	List (array of items)	A list of discount codes applied to the cart.
Total discount	Currency	The total discount applied.
Total tax	Currency	This is the total tax of the checkout.
Total tip	Currency	This is the total tip of the checkout.
Currency	Text	The currency used.
Source	Text	The source of the order e.g. Web, POS, iPhone, and Android.
Referring site	URL	This is the URL of the referrer that brought the customer to your store. e.g. `https://www.google.com/search?q=great+products`
Collections	List (array of items)	This is a list of the collections relevant to items in the cart.
Tags	List (array of items)	This is a list of all the tags related to items in your cart.
Total price	Currency	This is the total price of the abandoned order.
Note	Text	This is the note (if any) associated with the checkout.
Country	Geo	The country of the customer.
Region	Geo	The region of the customer.
City	Geo	The city of the customer.

Placed order, Order canceled, Order fulfilled, Order refunded

These activities are generated as the order status progresses between statuses. The order status URL gives the customer updates about the order and is generated by Shopify.

Attribute	Field type	Description
Order status URL	URL	This is the URL the customer can visit to check the status of their order.
Line item names	List (array of items)	This is a list of items in the cart by name.
Shipping price	Currency	This is the cost of shipping.
Total weight	Number	This is the total weight of all items combined.
Subtotal price	Currency	The price of the order in the shop currency after discounts but before shipping, taxes, and tips.
Total line item price	Currency	The price of all of the line item prices added together.
Item count	Number	The total number of items.
Discount codes	List (array of items)	A list of discount codes applied to the cart.
Total discount	Currency	The total discount applied.
Currency	Text	The currency used. E.g. USD
Source	Text	The source of the order e.g. Web, POS, iPhone, and Android.
Collections	List (array of items)	This is a list of the collections relevant to items in the cart.
Tags	List (array of items)	This is a list of all the tags related to items in your cart.
Total price	Currency	This is the total price of the order.
Total tax	Currency	This is the total tax of the order.
Total tip	Currency	This is the total tip of the order.
Referring site	Text	This is the URL of the referrer that brought the customer to your store. e.g. https://www.google.com/search?q=great+products
Note	Text	This is the note (if any) associated with the order.
Shipment status	Text	The status of the shipment.
Tracking company	Text	The name of the tracking company.
Tracking number	Text	The tracking number associated with the order.
Tracking numbers	List (array of items)	The tracking numbers (if more than one) associated with the order.
Tracking URL	Link	The URL of the tracking service.
Country	Geo	The country of the customer.
Region	Geo	The region of the customer.
City	Geo	The city of the customer.

Updated order

This activity occurs when an order is updated in Shopify.

Attribute	Field type	Description
Order status URL	URL	This is the URL the customer can visit to check the status of their order.
Order ID	Link	The ID of the order.
Line item names	List (array of items)	This is a list of items in the cart by name.
Shipping price	Currency	This is the cost of shipping.
Total weight	Number	This is the total weight of all items combined.
Subtotal price	Currency	The price of the order in the shop currency after discounts but before shipping, taxes, and tips.
Total line item price	Currency	The price of all of the line item prices added together.
Item count	Number	The total number of items.
Discount codes	List (array of items)	A list of discount codes applied to the cart.
Total discount	Currency	The total discount applied.
Currency	Text	The currency used. E.g. USD
Source	Text	The source of the order e.g. Web, POS, iPhone, and Android.
Collections	List (array of items)	This is a list of the collections relevant to items in the cart.
Tags	List (array of items)	This is a list of all the tags related to items in your cart.
Total price	Currency	This is the total price of the order.
Total tax	Currency	This is the total tax of the order.
Total tip	Currency	This is the total tip of the order.
Referring site	Text	This is the URL of the referrer that brought the customer to your store. e.g. https://www.google.com/search?q=great+products
Note	Text	This is the note (if any) associated with the order.
Shipment status	Text	The status of the shipment.
Tracking company	Text	The name of the tracking company.
Tracking number	Text	The tracking number associated with the order.
Tracking numbers	List (array of items)	The tracking numbers (if more than one) associated with the order.
Tracking URL	Link	The URL of the tracking service.
Country	Geo	The country of the customer.
Region	Geo	The region of the customer.
City	Geo	The city of the customer.

Price dropped

This activity occurs when a customer has either viewed a product, added to cart or started checkout without a purchase being made in the past 30 days.

Attribute	Field type	Description
Title	Text	The title of the product.
Inventory quantity	Number	The inventory quantity of the product back in stock.
Variant title	Text	The title of the variant selected if applicable.
SKU	Text	The product SKU.
Vendor	Text	The product vendor.
Collections	List (array of items)	This is a list of the collections relevant to items in the cart.
Tags	List (array of items)	This is a list of all the tags related to items in your cart.
Weight	Number	This is the total weight of all items combined.
Currency	Text	The currency used.
Price	Currency	This is the total price of the item.
Product URL	Link	The URL of the item.
Country	Geo	The country of the customer.
Region	Geo	The region of the customer.
City	Geo	The city of the customer.

Ordered product

Each product in an order generates an Ordered product activity. This allows you to visualize and filter based on individual products purchased.

Attribute	Field type	Description
Quantity	Number	The amount of the product ordered.
Weight	Number	The weight of the total quantity of the order.
Title	Text	The title of the product.
Variant title	Text	The title of the variant selected if applicable.
SKU	Text	The product SKU.
Vendor	Text	The product vendor.
Price	Currency	The price of an individual product ordered. Does not take into account quantity.
Collections	List (array of items)	A list of the collections the product belongs to.
Tags	List (array of items)	The tags related to the product.
Currency	Text	The currency used.
Product URL	Link	The URL of the item.
Country	Geo	The country of the customer.
Region	Geo	The region of the customer.
City	Geo	The city of the customer.

Viewed product

The viewed product activity is generated by Ortto when a known user views a product in your Shopify store. This activity is reliant on Capture.js being installed correctly.

Attribute	Field type	Description
Title	Text	The title of the product.
Inventory quantity	Number	The inventory quantity of the product back in stock.
Variant title	Text	The title of the variant selected if applicable.
SKU	Text	The product SKU.
Device	Text	The device used by the customer. e.g. Desktop.
Vendor	Text	The product vendor.
Collections	List (array of items)	A list of the collections the product belongs to.
Tags	List (array of items)	The tags related to the product.
Price	Currency	The price of an individual product ordered. Does not take into account quantity.
Weight	Number	The weight of the item.
Currency	Text	The currency used.
Country	Geo	The country of the customer.
Region	Geo	The region of the customer.
City	Geo	The city of the customer.

Waiting on stock

The waiting on stock activity is generated by Ortto when a user requests to be notified when an item is back in stock. This activity requires Capture.js to be installed (be default it happens automatically) on your Shopify store and you to have switched on the "Waiting on stock" widget.

NOTE: By default, Waiting on stock activity data is retained for 90 days. By enabling data retention for the Shopify data source, you can extend the retention period for Waiting on stock. This will enable you to access a longer period of data to trigger a Back in stock notification for customers (such as via a journey or SMS campaign).

Attribute	Field type	Description
Title	Text	The title of the product.
Variant title	Text	The title of the variant selected if applicable.
SKU	Text	The product SKU.
Device	Text	The device used by the customer. e.g. Desktop, Mobile.
Vendor	Text	The product vendor.
Price	Currency	The price of an individual product ordered. Does not take into account quantity.
Collections	List (array of items)	A list of the collections the product belongs to.
Tags	List (array of items)	The tags related to the product.
Inventory quantity	Number	The inventory quantity of the item waiting on stock.
Weight	Number	The weight of the item waiting on stock.
Currency	Text	The currency used.
Product URL	Link	The URL of the item waiting on stock.
Country	Geo	The country of the customer.
Region	Geo	The region of the customer.
City	Geo	The city of the customer.

Created customer

This activity occurs when a new customer is created in Shopify.

Attribute	Field type	Description
Customer ID	Number	The ID of the customer.
Email	Email	The email of the customer.
Phone	Text	The phone number of the customer.
First name	Text	The customer's first name.
Last name	Text	The customer's last name.
State	Text	The state of the customer (Enabled, Disabled, etc).
Note	Long text	This is the note (if any) associated with the customer.
Orders count	Number	The number of orders associated with the customer.
Last Order ID	Number	The ID of the last order.
Last order name	Text	The name of the last order.
Total spent	Currency	The cumulative amount of money a customer has spent on purchases from the store.
Accepts email marketing	Boolean	This field indicates whether a customer has opted in to receive promotional emails from the store.
Accepts SMS marketing	Boolean	This field indicates whether a customer has opted in to receive promotional SMSs from the store.
Tags	List (array of items)	This is a list of all the tags associated with the customer.
Default address	Long text	The customer's default address.
Created at	Time and date	The date and time when a customer’s account was first created in the store.
Updated at	Time and date	The date and time when a customer’s account was last updated in the store.
Country	Geo	The country of the customer.
Region	Geo	The region of the customer.
City	Geo	The city of the customer.

Updated customer

This activity occurs when a customer is updated in Shopify.

Attribute	Field type	Description
Customer ID	Number	The ID of the customer.
Email	Email	The email of the customer.
Phone	Text	The phone number of the customer.
First name	Text	The customer's first name.
Last name	Text	The customer's last name.
State	Text	The state of the customer (Enabled, Disabled, etc).
Note	Long text	This is the note (if any) associated with the customer.
Orders count	Number	The number of orders associated with the customer.
Last Order ID	Number	The ID of the last order.
Last order name	Text	The name of the last order.
Total spent	Currency	The cumulative amount of money a customer has spent on purchases from the store.
Accepts email marketing	Boolean	This field indicates whether a customer has opted in to receive promotional emails from the store.
Accepts SMS marketing	Boolean	This field indicates whether a customer has opted in to receive promotional SMSs from the store.
Tags	List (array of items)	This is a list of all the tags associated with the customer.
Default address	Long text	The customer's default address.
Created at	Time and date	The date and time when a customer’s account was first created in the store.
Updated at	Time and date	The date and time when a customer’s account was last updated in the store.
Country	Geo	The country of the customer.
Region	Geo	The region of the customer.
City	Geo	The city of the customer.

Created draft order

This activity occurs when a new draft order is created in Shopify.

Attribute	Field type	Description
Currency	Text	The currency used.
Collections	List (array of items)	This is a list of the collections relevant to items in draft order.
Item count	Number	The total number of items.
Line item names	List (array of items)	This is a list of items in the order.
Total line item price	Currency	The price of all of the line item prices added together.
Tags	List (array of items)	This is a list of all the tags related to items in the order.
Created at	Time and date	The date and time when the order was first created in the store.
Updated at	Time and date	The date and time when the order was last updated in the store.
Completed at	Time and date	The date and time when the order was marked as completed.
Invoice sent at	Time and date	The date and time when the invoice was sent.
Invoice URL	Link	The URL of the invoice associated with the order.
Total price	Currency	This is the total price of the draft order.
Subtotal price	Currency	The price of the order in the shop currency after discounts but before shipping, taxes, and tips.
Shipping price	Currency	This is the cost of shipping.
Total discount	Currency	The total discount applied.
Total tax	Currency	This is the total tax of the order.
Country	Geo	The country of the customer.
Region	Geo	The region of the customer.
City	Geo	The city of the customer.

Updated draft order

This activity occurs when a draft order is updated in Shopify.

Attribute	Field type	Description
Currency	Text	The currency used.
Collections	List (array of items)	This is a list of the collections relevant to items in draft order.
Item count	Number	The total number of items.
Line item names	List (array of items)	This is a list of items in the order.
Total line item price	Currency	The price of all of the line item prices added together.
Tags	List (array of items)	This is a list of all the tags related to items in the order.
Created at	Time and date	The date and time when the order was first created in the store.
Updated at	Time and date	The date and time when the order was last updated in the store.
Completed at	Time and date	The date and time when the order was marked as completed.
Invoice sent at	Time and date	The date and time when the invoice was sent.
Invoice URL	Link	The URL of the invoice associated with the order.
Total price	Currency	This is the total price of the draft order.
Subtotal price	Currency	The price of the order in the shop currency after discounts but before shipping, taxes, and tips.
Shipping price	Currency	This is the cost of shipping.
Total discount	Currency	The total discount applied.
Total tax	Currency	This is the total tax of the order.
Country	Geo	The country of the customer.
Region	Geo	The region of the customer.
City	Geo	The city of the customer.