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

Avatar

Avatar
Level 1
alexw14008173
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
alexw14008173
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
alexw14008173
Level 1

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

Avatar

Avatar
Validate 1
Level 1
stella_anton
Level 1

Likes

2 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
stella_anton
Level 1

Likes

2 likes

Total Posts

4 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
stella_anton
Level 1

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.

Avatar

Avatar
Applaud 5
Level 1
Giadascript
Level 1

Likes

0 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Applaud 5
View profile

Avatar
Applaud 5
Level 1
Giadascript
Level 1

Likes

0 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Applaud 5
View profile
Giadascript
Level 1

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

Avatar

Avatar
Validate 1
Level 1
M_Schoenmakers
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
M_Schoenmakers
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
View profile
M_Schoenmakers
Level 1

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?

Avatar

Avatar
Validate 1
Level 1
ercany
Level 1

Likes

0 likes

Total Posts

7 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
ercany
Level 1

Likes

0 likes

Total Posts

7 posts

Correct reply

1 solution
Top badges earned
Validate 1
Affirm 1
View profile
ercany
Level 1

22-05-2018

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

Thanks!

Avatar

Avatar
Give Back
Level 1
sungheey4410275
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Shape 1
View profile

Avatar
Give Back
Level 1
sungheey4410275
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Shape 1
View profile
sungheey4410275
Level 1

08-07-2018

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

Thanks!