Squarespace activities and attributes
This page lists all default Squarespace activities that are added to your Ortto account after integrating Ortto with Squarespace when adding Squarespace as a data source.
Order created, Order refunded, Order status changed, Checkout started, Checkout abandoned
Order and checkout activities are generated by Squarespace when an order is created or checkout has started. This allows you to view the order and checkout details in Ortto, including the associated store, order items, and totals.
| Attribute | Field type | Description |
|---|---|---|
Data source |
Text |
The name of the Squarespace data source. |
Website Title |
Text |
The Squarespace website title. |
Order ID |
Text |
A unique order identifier. |
Order Number |
Text |
A unique, sequential number for the order. |
Order Channel |
Text |
Where the order originated, e.g. "web" or "pos". |
Order Customer Email |
Text |
The customer’s email address entered at checkout or provided for an order |
Order Fulfillment Status |
Text |
The current fulfillment status of the order, e.g. "Pending", "Fulfilled" or "Canceled". |
Order Channel Name |
Text |
The name of a third-party sales channel |
Order External Order Reference |
Text |
An order reference identifier used the third-party sales channel |
Order Price Tax Interpretation |
Text |
An identifier that the line item unit price paid is inclusive or exclusive of tax. |
Order Create On |
Time and date |
The date and time in ISO 8601 UTC format when the order was placed through the third-party sales channel. |
Order Modified On |
Time and date |
The date and time in ISO 8601 UTC format when the order was last modified. |
Order Fulfilled On |
Time and date |
The date and time in ISO 8601 UTC format when the order was fulfilled. |
Order Subtotal |
Currency |
The order subtotal amount. |
Order Shipping Total |
Currency |
The shipping cost amount applied to the order. |
Order Discount Total |
Currency |
The discount amount applied to the order. |
Order Tax Total |
Currency |
The amount of tax applied to the order. |
Order Refunded Total |
Currency |
The amount refunded on the order. |
Order Grand Total |
Currency |
The total cost of the order. |
Order Currency |
Text |
The ISO 4217 currency code for the order. |
Shipping Address |
Text |
The customer’s shipping address entered at checkout or provided for an order. |
Billing Address |
Text |
The customer’s billing address |
Order Line Items Count |
Number |
The count of line items in the order. |
Order Line Items |
Object |
An array of purchased line items. Describes what product variant was purchased, how many of that item were purchased, and additional details. |
Order Shipping Lines |
Object |
An array of shipping line items. Describes the shipping options chosen at checkout. |
Order Discount Lines |
Object |
An array of discount line items. Describes the promotions redeemed checkout. |
Order Form Submission |
Object |
An array of form data submitted via a product’s custom form prior to being added to the cart. |
Order Fulfillments |
Object |
An array of shipping fulfillments. Describes shipment information for the order. |
Amount |
Currency |
The value of the order in the relevant currency. |
Added to cart, Back in stock, Waiting on stock, Viewed product
These activities are generated by Squarespace when a contact adds an item their cart, indicates their wish to be notified when a product is restocked, or views a product. This allows you to view the order details in Ortto, including the associated store, product, SKU, price and quantity.
| By default, Waiting on stock activity data is retained for 90 days. By enabling data retention for the Squarespace 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 |
|---|---|---|
Data source |
Text |
The name of the Squarespace data source. |
Website Title |
Text |
The Squarespace website title. |
Product ID |
Text |
A unique product identifier. |
Product Variant ID |
Text |
A unique product variant identifier. |
Product Title |
Text |
The product’s title. |
Product Variant Title |
TextThe product variant’s title. |
Product Currency |
Text |
The currency the product is sold in, in ISO 4217 format. |
Product Description |
Text |
The long-form product description. |
Product Image URL |
Text |
The link for the image associated wit the product. |
Product URL |
Url |
The link for the product. |
Product SKU |
Text |
A merchant-defined code that identifies the product variant. |
Product Inventory Quantity |
Number |
Current amount in stock, or the last known stock amount prior to becoming unlimited. |
Modified On |
Time and date |
The date and time in ISO 8601 UTC format when the product was last modified. |
Price |
Currency |
The price of the product in ISO 4217 format. |
Quantity added |
Donation created
Donation created is generated by Squarespace when a contact creates a donation. This allows you to view the donation details in Ortto, including the associated store and amount.
| Attribute | Field type | Description |
|---|---|---|
Data source |
Text |
The name of the Squarespace data source. |
Website Title |
Text |
The Squarespace website title. |
Transaction ID |
Text |
A unique transaction identifier. |
Transaction Paid On |
Time and date |
The date and time in ISO 8601 UTC format when payment was made. |
Transaction Amount |
Currency |
The order or donation amount covered by the payment. |
Transaction Customer Email |
Text |
The customer or donor email address. |
Amount |
Currency |
The order or donation amount. |