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

Forum|Forum|8 years ago
August 14, 2017
4 replies
10928 views

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

Analytics

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

S

stella_anton

Level 2

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.