Highlighted

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

Avatar

Avatar

alexw14008173

Avatar

alexw14008173

alexw14008173

13-08-2017

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

Replies

Highlighted

Avatar

Avatar

stella_anton

Avatar

stella_anton

stella_anton

14-08-2017

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.

Highlighted

Avatar

Avatar

Giadascript

Avatar

Giadascript

Giadascript

30-11-2017

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

Highlighted

Avatar

Avatar

M_Schoenmakers

Avatar

M_Schoenmakers

M_Schoenmakers

23-04-2018

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

Highlighted

Avatar

Avatar

ercany

Avatar

ercany

ercany

22-05-2018

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

Thanks!

Highlighted

Avatar

Avatar

sungheey4410275

Avatar

sungheey4410275

sungheey4410275

08-07-2018

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

Thanks!