Contents x
      System Transactions
      • 1 Minute to read
      • Print
      • Dark
        Light
      Contents

      System Transactions

      • 1 Minute to read
      • Print
      • Dark
        Light
      Article Summary

      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 Wishlists and Abandoned Carts, System Transactions do not require a Product Catalog.

      Availability

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

      Key-value

      Key-value of this table is orderId-userId. 

      Structure

      Column name

      Required

      Comment

      Type

      userId

      YES

      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

      orderId

      YES

      ID of this order 

      string

      timestamp

      YES

      Timestamp

      datetime

      storeId

      NO

      For multi-shop purposes

      string

      currency

      NO

      The default currency is set in Transactional RD, if not provided, the default is assigned.

      string

      productSKU

      YES

      Product identifier.

      string

      productName

      YES

      Name of the product

      string

      productPrice

      YES

      Product price without currency, spaces etc., just a raw number.

      number

      productQuantity

      YES

      Quantity of this product in this order.

      number

      returnedQuantity

      NO

      Default 0, for return calls product. Quantity=0 and return value with the number of returned items.

      number

      imageURL

      NO

      Link (URL) to the product image.

      string

      productURL

      NO

      Link (URL) to the product page.

      string

      category

      NO

      Category of this product.

      string

      brand

      NO

      Brand of this product.

      string

      variant

      NO

      Use this field if the product SKU does not provide a variant (such as colour or material) or size.

      string

      discountValue

      NO

      Value (without currency) of discount per order(not per item).

      number

      discountPercentage

      NO

      The percentage value of discount per order (not per item) - value from 0 to 1.

      number

      purchaseSource

      NO

      Source (campaign name, Facebook, etc.) of this order.

      string

      custom_column

      NO

      To 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",       
  }
]

      Related Topics

      Injection of Transactional Data into Mapp Engage
      Email Template
      Whiteboard Event: Transaction Registered

      Was this article helpful?
      What's Next