Data Sources | Community
Skip to main content
setaylor
October 16, 2015
Solved

Data Sources

  • October 16, 2015
  • 6 replies
  • 3396 views

I am using Data Sources to add order information. When I use the “Orders” column for line items in that order, it adds the orders as total.

 

Example:

OrderID: #1234567890

#1234567890 Product1: (Order = 1)

#1234567890 Product2: (Order = 1)

#1234567890 Product3: (Order = 1)

 

Total orders for that one OrderID is now 3, when it needs to be 1.

How do I update the template to correct this so it does not total like this, and marks the OrderID as 1 order instead of counting all of its line items?

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

If you're tying multiple products to the same order, you'll want to use full processing data sources and use the products column as laid out on this page here:

https://marketing.adobe.com/resources/help/en_US/sc/datasources/datasrc_full_processing.html

6 replies

TanmayMathur
Adobe Employee
Adobe Employee
October 16, 2015

Hi,

I can't say for sure but maybe the problem lies in the mapping of the metrics. You may want to revisit that an check. Let us know if you find anything. 

Thanks!

TM

Gigazelle
Adobe Employee
GigazelleAdobe EmployeeAccepted solution
Adobe Employee
October 16, 2015

If you're tying multiple products to the same order, you'll want to use full processing data sources and use the products column as laid out on this page here:

https://marketing.adobe.com/resources/help/en_US/sc/datasources/datasrc_full_processing.html

setaylor
setaylorAuthor
October 16, 2015

Ok, then how do you attribute ORDER to all line items in a single order, so it does not increment to the actual OrderID?

If you use a 0, this does not work.

TanmayMathur
Adobe Employee
Adobe Employee
October 16, 2015

Hi,

Could you provide Data Sources file having the columns (after obfuscating confidential data) and what type of data source have you implemented ?

Regards,

TM

setaylor
setaylorAuthor
October 16, 2015

I am using: Generic Data Source (Transaction ID) template file

I have attached an add and subtract example. The Data Sources - Add works great, except that it counts the OrderID line items into the OrderID.

When trying to use the subtract, or a negative value, nothing happens, but all uploads are successful.

ercany
May 23, 2018

I doubt that this can be an accepted answer. Full Processing doesn't allow merging Visitor IDs. Quote: "... even if the visitor ID in uploaded data matches data collected using JavaScript or other AppMeasurement library, the visitor profiles are not connected from an eVar allocation perspective."

In most cases this is a showstopper, since data sources are used to upload additional data. For a data source with Transaction ID, there is no way to avoid duplicate orders if an order contains multiple products?

If yes, following statement from the Data Source Help is actually false: "Product information (from s.products) is not contained in the visitor profile "snapshot," so you must upload any associated product data in the data source file along with the transaction ID. Note that you can specify only one product per row, so you might need to upload multiple rows with the same transaction ID to include all products."