Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.

Data Source with Transaction ID and Orders

Avatar

Level 2

Hi, I'm settting up a new data source with of type "Generic - Transaction ID". The transactions represent leads. We want to upload the offline orders from those leads.

In the Data Source Help, it says: "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."

It's not clear though how to handle the "Orders" column for an order with multiple products. If I'm supposed to have multiple rows per product with the same Transaction ID, what value am I supposed to use in the "Orders" column in those rows? If I set it to 1 in each row, then I get more than 1 orders in total. Any ideas?

0 Replies