Transactional Related Data table is a predefined Related Data Set for storing order (transactional) data under the contact profile. Saved data allows you to create advanced user segments and automations based on their purchase history.

Availability

By default, all customers can use Transactional Related Data table. 

Key-value

Key-value of this table is orderId-userId. 

Location

Administration > E-commerce > System Transactions

Column name

Required

Comment

Type

userIdYESUser email is changed to user ID, if the user is not in the system, they will be added string
orderIdYESID of this order number
timestampYESTimestampdatetime
storeIdNOFor multi-shop purposesstring
currencyNOThe default currency is set in Transactional RD, if not provided, the default is assigned.string
productSKUYESProduct identifier.string
productPriceYESProduct price without currency, spaces etc., just a raw number.number
productQuantityYESQuantity of this product in this order.number
returnQuantityNODefault 0, for return calls product.Quantity=0 and return value with the number of returned items.number
imageURLNOLink (URL) to the product image.string
productURLNOLink (URL) to the product page.string
categoryNOCategory of this product.string
brandNOBrand of this product.string
variantNOUse this field if the product SKU does not provide a variant (such as colour or material) or size.string
discountValueNOValue (without currency) of discount per order (not per item).number
discountPercentNOThe percentage value of discount per order (not per item) - value from 0 to 1number
purchaseSourceNOSource (campaign name, Facebook, etc.) of this order.

string

custom_columnNOTo add a custom column, edit the table structure and add a new field.-
[
  {
    "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",       
  }
]
XML