SiteCatalyst transactionID Data Transfer Source
we are struggling to make import orders unique using transactionID Data Source template .
In fact, this template does not consider the "purchaseID" column, and it does not parse this variable if we force it into the template. For now, we are setting one line for each product purchased by the same "transaction customer" , with additional fields below:
Evar date 22; transactionID
06/06/2015 evar_value category product_name 1 1 123456
06/06/2015 evar_value category2 product_name2 1 2 123456
........................... ...................
This example will place 2 orders for customer "123456" even if it is the same, including 3 units (quantity) of 2 products. Thus, we were expecting only 1 order for this client. We assumed that the transactionID might be a unique key that acts as a purchase ID, but it doesn't.
We then tried to put all the products on one line by removing the Category columns and using the "s.products" format as shown below:
06/06/2015 evar_value category; product_name, category2; product_name2 1 2 123456
The Quantity field now gets 2 units. With this template, we were closer to the goal, because the Order was correctly recognized as unique. The problem here is with Products, because the DataSource always seems to expect one of them to be the first. In this example, in addition to "product_name" and "product_name2", " Unspecified " will be sent .
To summarize: how can Traits be recognized as unique when imported via the transaction ID, but regardless of the template (default or default)?
source to share