Avatar

Level 1

I'd like to upload transaction id data source, please see the following data source:

      

# Order Status template file (user)
#ProductsRevenueUnitsOrdersPurchase ID
DateProductPriceQuantityOrderstransactionID
08/10/2017/18/00/00product-name-140011123456
08/10/2017/18/00/00product-name-260021123456

the two products were purchased in one same transaction, but when I upload it, the total order number is 2.

so my questions are:

1) how to make order unique when multiple products were purchased in one transaction id?

2) in the target report suite, the default

currency code is US Dollar, but the price in the sample is Chinese Yuan(CNY),

    how can I make revenue metric in omniture shows 1000, not 6700(1000*6.7 exchange rate) ?

Thanks,

Alex