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

      System Transactions

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

      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.

      Mapp Connect only: If the contact is not in the system, they will be added.

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

      Was this article helpful?
      Related articles
      What's Next