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.

As opposed to Wishlist and Abandoned Cart, System Transactions do not require a Product Catalog.

Availability

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

Key-value

Key-value of this table is orderId-userId. 

Structure

Column name

Required

Comment

Type

userIdYES

Provide email value - it is changed to Engage contact ID.

Mapp Connect only: If the contact 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 1.number
purchaseSourceNOSource (campaign name, Facebook, etc.) of this order.

string

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

Further Information