System Transactions
    • 1 Minute to read
    • Dark
      Light

    System Transactions

    • 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?