- 1 Minute to read
- Print
- DarkLight
System Transactions
- 1 Minute to read
- Print
- DarkLight
General Information
The System Transactions feature enables the storage of transactional data, such as order details, within a customer’s contact profile. This stored data can be used to create advanced user segments and automations based on purchase history.
Availability
By default, all customers have access to the Transactional Related Data Table.
Key-Value Structure
The key-value pair for this table is orderId-userId
.
Key Differences from Wishlists and Abandoned Carts
Unlike Wishlists or Abandoned Carts, System Transactions do not require a product catalog.
Structure of System Transactions Table
Column name | Required | Comment | Type |
---|---|---|---|
userId | YES | Use the customer's email address.
| String |
orderId | YES | The unique identifier of the order. | String |
timestamp | YES | The timestamp of the order. | DateTime |
storeId | NO | For multi-shop scenarios. | String |
currency | NO | Defaults to the currency set in the Transactional RD unless provided. | String |
productSKU | YES | Product identifier (SKU). | String |
productName | YES | The name of the product. | String |
productPrice | YES | The product price (raw number, no spaces or currency). | Number |
productQuantity | YES | Quantity of the product in this order. | Number |
returnedQuantity | NO | Defaults to 0. Used for return transactions. | Number |
imageURL | NO | Link to the product image. | String |
productURL | NO | Link to the product page. | String |
category | NO | Product category. | String |
brand | NO | Brand of the product. | String |
variant | NO | Product variant (color, material, etc.) if not included in SKU. | String |
discountValue | NO | Value of the discount (per order, not per item). | Number |
discountPercentage | NO | The discount percentage (per order, not per item) ranging from 0 to 1. | Number |
purchaseSource | NO | The source of the purchase (e.g., campaign name, Facebook, etc.). | String |
custom_column | NO | To add custom data, edit the table structure to add new fields. | - |
JSON Example
[
{
"email":"test@test.com",
"orderId":"123424"
"timestamp":"2019-03-07T14:50:39.983+01:00",
"productSKU":"XXXXXXXXX",
"productName":"Nike Shoes",
"productPrice": 132.99,
"productQuantity": 3,
"returnQuantity" : 0,
"imageURL":"westwing.com/nike/img/png",
"productURL": "westwing.com/nike/124125",
"category": "Shoes",
"brand": "Nike" ,
"variant": "Green",
"storeId":"2342342334",
"currency":"PLN",
"discountValue": 10,
"discountPercent": 0.05,
"purchaseSource": "online"
"customDetail1":"xxx",
}
]