---
schema_version: "1"
id: 89a75692124015230be913580fda604a61809c040ce739b5ef02b0459bd01b4f
title: TLog Export FAQs
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_export_faq.md
canonical_url: https://help.salesforce.com/s/articleView?id=commerce.rt_adv_config_export_tlog_export_faq.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 22654a47c37f149f5e6de75410a37b3371f4e1df25652a2884bc8addd9afe7a0
description: Find answers to frequently-asked questions about the Point of Sale TLog export.
products:
  - Commerce
release: "264"
---
# TLog Export FAQs

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

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
      <colgroup>
        <col>
        <col>
        <col>
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d70789e36">Scenario</th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d70789e39">Solution</th>
          <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d70789e42">Help link</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e36 ">What is the XML schema of this export?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">Refer to<strong> Retail Transaction Interface </strong>in the help link.</td>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 ">See the OMG <a href="https://www.omg.org/retail/schema.htm" target="_blank">ARTS XML Schemas</a> documentation.</td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e36 ">What will be the file name format of the export?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">
            <p>It can be configured, below is the standard format:</p>
            <p>RetailCloudOrders%1$tY%1$tm%1$tdT%1$tH%1$tM%1$tS_</p>
            <p style="margin-bottom:0;">Example: RetailCloudOrders20210301T122608__FR00000001.xml</p>
          </td>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 "> </td>

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

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">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>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 "> </td>

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

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">
            <ul>
              <li>RETAIL_AUTH - Checkout</li>

              <li>RETAIL_EXCHANGED - It is for transactions that exchanges all items.</li>

              <li>RETAIL_FAILED - This will come into the picture if in the future we decide to send the
                failed transaction down to you.</li>

              <li>RETAIL_PARTIALLY_EXCHANGED - It is for exchanges where the customer is not getting a
                refund. E.g., even exchange or an uneven exchange where the customer pays.</li>

              <li>RETAIL_PARTIALLY_REFUNDED - It is for transactions that returns or exchanges partial
                items with a refund to the customer.</li>

              <li>RETAIL_PENDING - The sale transaction is awaiting payment confirmation. E.g., Remote Pay
                By Link</li>

              <li>RETAIL_RETURNED - It is for transaction that returns or exchanges all items with a
                refund to the customer.</li>

              <li>RETAIL_SALE - Checkout, please consider both this and RETAIL_AUTH as a sale at your
                end.</li>

              <li>RETURNED_WITHOUT_RECEIPT - This is for items returned without a receipt. </li>

            </ul>
          </td>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 "> </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e36 ">How are exchanges handled?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">If you are exchanging an item and getting a new one of the same or different value then
            you will get two POS logs. One for the old order showing the item was returned/exchanged with
            <strong>IsExchange</strong> set as true and another POS log for the new order indicating the new item
            was purchased. Exchange at our end affects two transactions. One existing order and a new
            order are placed for the new items.
          </td>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 "> </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e36 ">Will return tenders always be listed as separate line items over sale tender?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">Yes, returns tenders are listed explicitly even if the return was sent back to original
            sale tender.</td>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 "> </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e36 ">How will Order Export (i.e., what files will be created) work for an in-store
            transaction consisting of both sale and return? The return could be partial or full.</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">
            <ul>
              <li>In-Store Transaction - you will get one POS log generated</li>

              <li>Return Full or Partial - you will get another POS log generated which will still have
                the sale information but will have return information added to the POS log</li>

              <li>Each time there is a return - you will get a POS log file.</li>

              <li>Even if you miss the original sale transaction POS log or if there is a return in quick
                succession immediately after sale - POS log file has a complete picture to create the sale
                order and also process the return part of it.</li>

            </ul>
          </td>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 "> </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e36 ">What is the purpose of the Sequence Number field under the transaction node?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">
            <p>&lt;SequenceNumber </p>
            <p style="margin-bottom:0;">xmlns:ns2="http://www.nrf-arts.org/IXRetail/namespace/" xmlns=""&gt;1&lt;/SequenceNumber&gt; is
              not useful as such. It is just the sequence in which added elements to the xml.</p>
          </td>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 "> </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e36 ">The Receipt Datetime field, under transaction node, has type code "RefundExpiry". Does
            it mean the date indicates the end date of the return period of the order?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">Yes</td>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 "> </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e36 ">Does the sequence number field in a node indicate that the node can appear multiple
            times?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">No</td>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 "> </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e36 ">
            <p style="margin-bottom:0;">How to differentiate between Transaction Level and Item Level Discounts?</p>
          </td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">
            <p>You should be able to differentiate based on below:</p>
            <ul>
              <li>&lt;RetailPriceModifier MethodCode="Promotion"&gt; - Promotion/Coupon code</li>

              <li>&lt;RetailPriceModifier MethodCode="PriceOverride"&gt; - Item Level</li>

              <li>&lt;RetailPriceModifier MethodCode="GeneralDiscount"&gt; - Prorated Transaction Level Disc
                for this item</li>

            </ul>
          </td>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 "> </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e36 ">Do you support Post Void? If yes, then will you be sending us those transactions in the
            Order Export feed?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">No, we do not support Void - only Returns &amp; Exchanges. </td>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 "> </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e36 ">How to uniquely identify a transaction? I will need to identify duplicate transactions.
            Order # will not work as Refunds won't have new order #s. I see a TransactionID attribute at
            CustomerOrderTransaction node. Can that be used for this purpose?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">Yes, transaction ID can be used for the most part. For exchanges, same transaction ID
            is used/sent in TLog for order # from which item was returned and same transaction ID is
            used/sent in the new TLog for new order # that was placed for the items that were purchased
            in exchange.</td>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 "> </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e36 ">How to distinguish transactions/POS log of different countries?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">We can have your order # prefixed with a country code (i.e., instead of order # string
            with PS, we can have them start with DE, FR, GB, etc.) For example, PS00000001 can be changed
            to FR00000001.</td>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 "> </td>

        </tr>
        <tr class="">
          <td data-label="Scenario" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e36 ">Is there a detailed Field Spec/Explanation of data in various XML tags?</td>

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">Please refer to the link as it containssample XML files. Start with basic sale file
            Checkout-RetailCloudOrders... file for explanation of all major fields and then navigate to
            more complex flows which start with file name Checkout-Promotion, PriceOverride, etc.</td>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 "><a href="https://resources.docs.salesforce.com/rel1/doc/en-us/static/misc/POSLog-SamplesWithComments.zip" target="_blank">POSLog-SamplesWithComments.zip</a>
          </td>

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

          <td data-label="Solution" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e39 ">
            <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>

          <td data-label="Help link" class="slds-cell-wrap" style="vertical-align:top;" headers="d70789e42 "> </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:

- [CheckoutOrder.xml](https://resources.docs.salesforce.com/rel1/doc/en-us/static/misc/CheckoutOrder.xml)
- [CheckoutPromotion.xml](https://resources.docs.salesforce.com/rel1/doc/en-us/static/misc/CheckoutPromotion.xml)
- [ExchangeChargeMore.xml](https://resources.docs.salesforce.com/rel1/doc/en-us/static/misc/ExchangeChargeMore.xml)
- [ExchangeEven.xmll](https://resources.docs.salesforce.com/rel1/doc/en-us/static/misc/ExchangeEven.xml)
- [ExchangeRefundDue.xml](https://resources.docs.salesforce.com/rel1/doc/en-us/static/misc/ExchangeRefundDue.xml)
- [FullReturn.xml](https://resources.docs.salesforce.com/rel1/doc/en-us/static/misc/FullReturn.xml)
- [PartialReturn.xml](https://resources.docs.salesforce.com/rel1/doc/en-us/static/misc/PartialReturn.xml)
- [PriceOverride.xml](https://resources.docs.salesforce.com/rel1/doc/en-us/static/misc/PriceOverride.xml)
- [TransactionDiscount.xml](https://resources.docs.salesforce.com/rel1/doc/en-us/static/misc/TransactionDiscount.xml)