---
schema_version: "1"
id: 7bf1848b94b027a1924564dfa3b93cbd4cdbe6c40698b783b376ede59d3d738d
title: TLog FAQ
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/commerce/264-0-0/rt_adv_config_export_tlog_faq.md
canonical_url: https://help.salesforce.com/s/articleView?id=commerce.rt_adv_config_export_tlog_faq.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: b56bd4df1e622f24b6aed3523f687b523fefe4815841111cd8cfb2817d4f15ee
description: Find answers to frequently-asked questions about the Point of Sale TLog.
products:
  - Commerce
release: "264"
---
# TLog FAQ

Find answers to frequently-asked questions about the Point of Sale TLog.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
      <colgroup>
        <col>
        <col>
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d161469e34">Scenario</th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d161469e37">Solution</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">What data can be exported from Point of Sale?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">We can export order data, inventory events, and EJ events. Analytics data can be
            downloaded via CSV.</td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">How can order data be exported?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">Orders can be exported from PS via TLog files that are in XML form. Orders can also be
            exported as CSV, TSV however, XML TLog is the recommended format. We have OOTB connectors to
            SF OMS and Netsuite to push order data directly via API calls.</td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">What is the format of TLog?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">It is a NRF POSLog spec. Sample and details are available in <a href="https://help.salesforce.com/s/articleView?id=commerce.rt_adv_config_export_tlog.htm&amp;language=en_US" target="_blank">Transaction Log (TLog) Export</a>.</td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">What inventory events are supported?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">As store performs inventory operations i.e., cycle count, receiving, and transfers
            files can be exported out reflecting what happened in store.</td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">Can we get end of day inventory summary?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">Yes, an end of day inventory snapshot can be scheduled to send out all inventory
            positions from PS cloud.</td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">What about EJ data?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">EJ data can be scheduled for export once a day. This will generate a CSV file tha can
            be ingested on the customer's side.</td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">What about Recon data and order reports?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">All analytics data can be manually downloaded from respective screens on CMS.</td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">How long do we keep logs for debugging in production?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">Production logs are available for 28 days. These are server logs that should not to be
            confused with TLogs. TLogs are exported to FTP and merchants can either keep them there or
            delete them.</td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">What payment methods are displayed in the &lt;tender&gt; tag?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">Tenders allowed in Store Settings will display: Cash, CreditCard, Check, GiftCard,
            RewardCard, External, and Miscellaneous (***regardless of name specified, will export as
            Miscellaneous).</td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">How is &lt;transactionId&gt; defined?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">At the highest level, the "transactionId" serves as the unique identifier for the most
            recent activity associated with a specific order(s). This identifier is structured as
            "storeId-registerId-timestamp-transactionNumber-eventNumber". Example transactionID:
            0111-001-20250228115758-9-5.</td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">What is &lt;eventId&gt;?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">A unique ID to identify events per transaction. For example, sales transactions can
            have a number of events, including adding items, removing items, adding customers,
            introducing tender types, removing tender types, applying discounts, and submitting
            transaction. To ensure precise event execution, all requests from the POS app to the Backend
            must include a unique ID associated with the sale transaction.</td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">What is the relationship between &lt;retailpricemodifier&gt; and &lt;lineitem&gt;?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">This is one to many; line item can have multiple discounts.</td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">What does &lt;retailpricemodifier&gt; identify?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">
            <p>It identifies discounts as follows:</p>
            <p>Promotion = Promotion/coupon code</p>
            <p>PriceOverride = Item level discount</p>
            <p style="margin-bottom:0;">General Discount = Prorated transaction-level discount for this item</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">What is &lt;cartid&gt;?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">This can be ignored. This isn't typically used for any processing.</td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">What transaction statuses are available?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">
            <p>Retail_Auth: Sale</p>
            <p>Retail_Partially_Refunded: Partial return of order, updated order exchange with amount due
              to customer</p>
            <p>Retail_Returned: Full Return of order</p>
            <p style="margin-bottom:0;">Retail_Exchanged: Updated order even exchange, updated order exchange with amount due from
              customer</p>
          </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">Are Tax and VAT in TLog? </td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">Yes, all TLog files have full breakdown of Taxes and VAT at the item / order
            level.</td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">How do I find the order number? </td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">The order number can be found within the filename, specifically after the double
            underscores. For example, in this file,
            <em>SHOPNOW_US_20220729T055610__OPS-022-1-072920220003_1659074169659.xml</em>. The order
            number would be <strong>OPS-022-1-072920220003_1659074169659</strong>.
          </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">In the JSON file, how are subtotal, item total, and item price after discounts
            calculated? </td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">
            <ul>
              <li>The subtotal is calculated by multiplying the price by quantity (Subtotal = Price *
                Quantity).</li>

              <li>The item total is calculated by subtracting discounts from the subtotal and adding any
                taxes (Item Total = Subtotal - Discounts + Tax).</li>

              <li>The item price after the discount is calculated by subtracting discounts from the
                subtotal (Subtotal - Discounts). </li>

            </ul>
          </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">Which transaction scenarios will require more than one export file? </td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">
            <p>The following transaction scenarios will require more than one export file (New Sale and
              Return of Old Transaction):</p>
            <ul>
              <li>Even Exchange</li>

              <li>Exchange (customer pays)</li>

              <li>Exchange (customer gets refund)</li>

            </ul>
          </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">When we link a customer during the transaction we add their email ID in the TLogs. Is
            there a way to hide or remove customer details from TLogs as the customer details would be
            PII? As we store the TLogs on the Point of Sale and some of those TLogs have customer
            details, is Point of Sale still GDPR/CCPA compliant?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">If using an export, you can set field mappings and drop the fields with the customer
            data. Generally, consumer data that is part of a transaction is treated differently than
            general PII, since there is a reporting/regulatory need to maintain this data. </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e34 ">
            <p>The XML format includes the following fields. What are their equivalents in JSON?</p>
            <ul>
              <li>BusinessDayDate</li>

              <li>BeginDateTime</li>

              <li>EndDateTime</li>

            </ul>
          </td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d161469e37 ">
            <p>All dates listed below are in the GMT timezone.</p>
            <ul>
              <li><strong>BeginDateTime (XML)</strong>: This maps to the orderDate in the JSON order payload,
                indicating the exact date and time the sale order was created.</li>

              <li><strong>BusinessDayDate (XML)</strong>: This is the orderDate from the JSON order payload, but
                without the time component, specifying the exact date the order was placed.</li>

              <li><strong>EndDateTime (XML)</strong>: Initially, this is the same as orderDate. However, if there
                are any updates to the order (such as returns or exchanges), EndDateTime represents the
                last update time of the order.</li>

            </ul>
            <p style="margin-bottom:0;">These XML dates are derived from the orderDate and updateDate fields in the JSON order
              payload. The fields and their values in the POS Log XML are generated based on the JSON
              order payload, ensuring all necessary data for XML export is included in the JSON.</p>
          </td>

        </tr>
      </tbody>
    </table>

![Example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-commerce-retail-264-0-0-production-enus/17d647fb-8988-49fb-9add-c4f4cc79c9e4/images/icon_example.png)

Example Example files:

- [NRF-Retail-Spec&XSDs.zip](https://resources.docs.salesforce.com/rel1/doc/en-us/static/misc/POSNRFretailSpec.zip)
- [POSLog-SamplesWithComments.zip](https://resources.docs.salesforce.com/rel1/doc/en-us/static/misc/POSLogSamples.zip)