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

[alexw14008173]

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

# Order Status template file (user)
#	Products	Revenue	Units	Orders	Purchase ID
Date	Product	Price	Quantity	Orders	transactionID
08/10/2017/18/00/00	product-name-1	400	1	1	123456
08/10/2017/18/00/00	product-name-2	600	2	1	123456

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

[stella_anton]

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.

[M_Schoenmakers]

Have you tried adding an additional column that holds the same value as the transaction id and use unique instances metric on that one?

[Giadascript]

Hi Alex,

I've solved point #1 adding the column "currency code" but I'm still struggling with point #1. Did you find any solution?

Thanks,

Giada

[ercany]

alexw14008173 I have the exact same problem as #1. Were you able to solve that?

Thanks!

[sungheey4410275]

alexw14008173Here is one more, I have the exact same issue as #1. any idea?

Thanks!