---
title: "eCommerce: System Transactions"
slug: "ecommerce-system-transactions"
updated: 2026-01-26T16:16:39Z
published: 2026-01-26T16:16:39Z
canonical: "docs.mapp.com/ecommerce-system-transactions"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.mapp.com/llms.txt
> Use this file to discover all available pages before exploring further.

# eCommerce: System Transactions

## Overview

The System Transactions section provides access to imported transactional data used in eCommerce scenarios. It allows users to search transaction records, manually import data, define a default currency, and review the underlying transaction data structure. This data is typically used to track purchases and enhance eCommerce features.

---

## Navigation Path

*Administration > eCommerce > System Transactions*

![](https://cdn.document360.io/554b9b98-6720-4d8b-9919-c7b203d72648/Images/Documentation/image-JBKSEHAH.png)

---

## Data

### Settings

| **Setting** | Description |
| --- | --- |
| **Default Currency** | Defines the currency applied to transaction data. The selected currency is saved and used as the default for relevant numeric values where no currency is explicitly provided. |

---

### Actions

| **Action** | Description |
| --- | --- |
| **Search** | Looks up system transactions using a key prefix to filter the displayed records. |
| **Import data** | Manually imports transaction data into the System Transactions dataset. |

---

## Structure

The Structure tab displays the System Transactions data structure, including available fields and their properties.

| **Column Heading** | **Type** | **Required** | Description |
| --- | --- | --- | --- |
| `orderId` | String | Yes | Identifier of the order associated with the transaction. |
| `timestamp` | Date | Yes | Date and time when the transaction occurred. |
| `productSKU` | String | Yes | Stock keeping unit of the purchased product. |
| `productName` | String | Yes | Name of the purchased product. |
| `productPrice` | Number | Yes | Product price at the time of purchase. |
| `productQuantity` | Number | Yes | Number of units purchased. |
| `returnedQuantity` | Number | No | Number of units returned. Default value is “0”. |
| `imageURL` | String | No | URL of the product image. |
| `productURL` | String | No | URL of the product detail page. |
| `category` | String | No | Product category assigned to the item. |
| `brand` | String | No | Brand associated with the product. |
| `variant` | String | No | Product variant information. |
| `storeId` | String | No | Identifier of the store where the transaction occurred. |
| `currency` | String | No | Currency code used for the transaction values. |
| `discountValue` | Number | No | Absolute discount value applied to the product. |
| `purchaseSource` | String | No | Source of the purchase. |
| `discountPercentage` | Number | No | A percentage-based discount applied to the product. |

---

### Key Column and Key-Value Structure

System Transactions use a key-value structure to uniquely identify each transaction record.

The key is a combination of:

- `orderId`
- `contactId` (internal contact identifier)

This combination forms the key-value pair `orderId-userId`.

The resulting value is displayed as the **Key Column** in the transaction table. The `userId` or internal `contactId` is not shown separately in the table and cannot be edited or configured.

The **Key Column** is not part of the System Transactions data structure and does not appear in the structure table. It is used internally to identify transaction records and to enable searching transactions using a key prefix.