<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic how to make order unique when multiple products were purchased in one transaction id in Adobe Analytics Discussions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/how-to-make-order-unique-when-multiple-products-were-purchased/m-p/291451#M1927</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I'd like to upload transaction id data source, please see the following data source:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="width: 808px;"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD class="xl63" height="20" width="349"&gt;# Order Status template file (user)&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl63" height="20"&gt;#&lt;/TD&gt;&lt;TD class="xl63"&gt;Products&lt;/TD&gt;&lt;TD class="xl63"&gt;Revenue&lt;/TD&gt;&lt;TD class="xl63"&gt;Units&lt;/TD&gt;&lt;TD class="xl63"&gt;Orders&lt;/TD&gt;&lt;TD class="xl63"&gt;Purchase ID&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl63" height="20"&gt;Date&lt;/TD&gt;&lt;TD class="xl63"&gt;Product&lt;/TD&gt;&lt;TD class="xl63"&gt;Price&lt;/TD&gt;&lt;TD class="xl63"&gt;Quantity&lt;/TD&gt;&lt;TD class="xl63"&gt;Orders&lt;/TD&gt;&lt;TD class="xl63"&gt;transactionID&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl63" height="20"&gt;08/10/2017/18/00/00&lt;/TD&gt;&lt;TD class="xl63"&gt;product-name-1&lt;/TD&gt;&lt;TD class="xl63"&gt;400&lt;/TD&gt;&lt;TD class="xl63"&gt;1&lt;/TD&gt;&lt;TD class="xl63"&gt;1&lt;/TD&gt;&lt;TD class="xl63"&gt;123456&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl63" height="20"&gt;08/10/2017/18/00/00&lt;/TD&gt;&lt;TD class="xl63"&gt;product-name-2&lt;/TD&gt;&lt;TD class="xl63"&gt;600&lt;/TD&gt;&lt;TD class="xl63"&gt;2&lt;/TD&gt;&lt;TD class="xl63"&gt;1&lt;/TD&gt;&lt;TD class="xl63"&gt;123456&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;the two products were purchased in one same transaction, but when I upload it, the total order number is 2.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;so my questions are:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1) how to make order unique when multiple products were purchased in one transaction id?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;2) in the target report suite, the default&lt;/P&gt;&lt;P&gt;currency code is US Dollar, but the price in the sample is Chinese Yuan(CNY), &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; how can I make revenue metric in omniture shows 1000, not 6700(1000*6.7 exchange rate) ?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Alex&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 14 Aug 2017 06:13:03 GMT</pubDate>
    <dc:creator>alexw14008173</dc:creator>
    <dc:date>2017-08-14T06:13:03Z</dc:date>
    <item>
      <title>how to make order unique when multiple products were purchased in one transaction id</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/how-to-make-order-unique-when-multiple-products-were-purchased/m-p/291451#M1927</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I'd like to upload transaction id data source, please see the following data source:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/P&gt;&lt;TABLE border="0" cellpadding="0" cellspacing="0" style="width: 808px;"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD class="xl63" height="20" width="349"&gt;# Order Status template file (user)&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl63" height="20"&gt;#&lt;/TD&gt;&lt;TD class="xl63"&gt;Products&lt;/TD&gt;&lt;TD class="xl63"&gt;Revenue&lt;/TD&gt;&lt;TD class="xl63"&gt;Units&lt;/TD&gt;&lt;TD class="xl63"&gt;Orders&lt;/TD&gt;&lt;TD class="xl63"&gt;Purchase ID&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl63" height="20"&gt;Date&lt;/TD&gt;&lt;TD class="xl63"&gt;Product&lt;/TD&gt;&lt;TD class="xl63"&gt;Price&lt;/TD&gt;&lt;TD class="xl63"&gt;Quantity&lt;/TD&gt;&lt;TD class="xl63"&gt;Orders&lt;/TD&gt;&lt;TD class="xl63"&gt;transactionID&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl63" height="20"&gt;08/10/2017/18/00/00&lt;/TD&gt;&lt;TD class="xl63"&gt;product-name-1&lt;/TD&gt;&lt;TD class="xl63"&gt;400&lt;/TD&gt;&lt;TD class="xl63"&gt;1&lt;/TD&gt;&lt;TD class="xl63"&gt;1&lt;/TD&gt;&lt;TD class="xl63"&gt;123456&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD class="xl63" height="20"&gt;08/10/2017/18/00/00&lt;/TD&gt;&lt;TD class="xl63"&gt;product-name-2&lt;/TD&gt;&lt;TD class="xl63"&gt;600&lt;/TD&gt;&lt;TD class="xl63"&gt;2&lt;/TD&gt;&lt;TD class="xl63"&gt;1&lt;/TD&gt;&lt;TD class="xl63"&gt;123456&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;the two products were purchased in one same transaction, but when I upload it, the total order number is 2.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;so my questions are:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1) how to make order unique when multiple products were purchased in one transaction id?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;2) in the target report suite, the default&lt;/P&gt;&lt;P&gt;currency code is US Dollar, but the price in the sample is Chinese Yuan(CNY), &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; how can I make revenue metric in omniture shows 1000, not 6700(1000*6.7 exchange rate) ?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Alex&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 14 Aug 2017 06:13:03 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/how-to-make-order-unique-when-multiple-products-were-purchased/m-p/291451#M1927</guid>
      <dc:creator>alexw14008173</dc:creator>
      <dc:date>2017-08-14T06:13:03Z</dc:date>
    </item>
    <item>
      <title>Re: how to make order unique when multiple products were purchased in one transaction id</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/how-to-make-order-unique-when-multiple-products-were-purchased/m-p/291452#M1928</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi, just an occurance, but how about removing the Orders Column? The Purchase ID is the key, so the number of Orders is equal to the unique Purchase IDs.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 14 Aug 2017 12:42:59 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/how-to-make-order-unique-when-multiple-products-were-purchased/m-p/291452#M1928</guid>
      <dc:creator>stella_anton</dc:creator>
      <dc:date>2017-08-14T12:42:59Z</dc:date>
    </item>
    <item>
      <title>Re: how to make order unique when multiple products were purchased in one transaction id</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/how-to-make-order-unique-when-multiple-products-were-purchased/m-p/291453#M1929</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Alex, &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I've solved point #1 adding the column "currency code" but I'm still struggling with point #1. Did you find any solution?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Giada&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 30 Nov 2017 16:02:21 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/how-to-make-order-unique-when-multiple-products-were-purchased/m-p/291453#M1929</guid>
      <dc:creator>Giadascript</dc:creator>
      <dc:date>2017-11-30T16:02:21Z</dc:date>
    </item>
    <item>
      <title>Re: how to make order unique when multiple products were purchased in one transaction id</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/how-to-make-order-unique-when-multiple-products-were-purchased/m-p/291454#M1930</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Have you tried adding an additional column that holds the same value as the transaction id and use unique instances metric on that one?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 23 Apr 2018 09:30:51 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/how-to-make-order-unique-when-multiple-products-were-purchased/m-p/291454#M1930</guid>
      <dc:creator>M_Schoenmakers</dc:creator>
      <dc:date>2018-04-23T09:30:51Z</dc:date>
    </item>
    <item>
      <title>Re: how to make order unique when multiple products were purchased in one transaction id</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/how-to-make-order-unique-when-multiple-products-were-purchased/m-p/291455#M1931</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;A href="https://experienceleaguecommunities.adobe.com/people/alexw14008173"&gt;alexw14008173&lt;/A&gt; I have the exact same problem as #1. Were you able to solve that?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 22 May 2018 09:36:29 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/how-to-make-order-unique-when-multiple-products-were-purchased/m-p/291455#M1931</guid>
      <dc:creator>ercany</dc:creator>
      <dc:date>2018-05-22T09:36:29Z</dc:date>
    </item>
    <item>
      <title>Re: how to make order unique when multiple products were purchased in one transaction id</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/how-to-make-order-unique-when-multiple-products-were-purchased/m-p/291456#M1932</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN style="color: #333333; font-family: adobe-clean, 'Helvetica Neue', Arial, sans-serif; font-size: 16px;"&gt;&lt;A _jive_internal="true" data-containerid="-1" data-containertype="-1" data-objectid="10370890" data-objecttype="3" href="https://forums.adobe.com/people/alexw14008173" style="font-size: 16px; font-family: adobe-clean, 'Helvetica Neue', Arial, sans-serif; color: #3a91d7;"&gt;alexw14008173&lt;/A&gt;&lt;SPAN style="color: #333333; font-family: adobe-clean, 'Helvetica Neue', Arial, sans-serif; font-size: 16px;"&gt;Here is one more, I have the exact same issue as #1. any idea?&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #333333; font-family: adobe-clean, 'Helvetica Neue', Arial, sans-serif; font-size: 16px;"&gt;Thanks!&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 09 Jul 2018 05:42:10 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/how-to-make-order-unique-when-multiple-products-were-purchased/m-p/291456#M1932</guid>
      <dc:creator>sungheey4410275</dc:creator>
      <dc:date>2018-07-09T05:42:10Z</dc:date>
    </item>
  </channel>
</rss>

