Ecommerce transaction tracking events - where are they stored?


#1

As add_to_cart data stored in add_to_cart table, where is addTrans,addItem and trackTrans event data stored?


#2

@Dev, they are loaded into events table - columns ti_... and tr_....


#3

yeah, i got that in events table but is there any specific tables to capture transaction related data? Do we have to create any custom unstuctured event using self-describing json and table?


#4

@Dev, I don’t follow you. The data in those columns are transaction related data. You use addTrans() to create a transaction object and addItem() to add items to the transaction. The data for two of those end up in ti_ and tr_ columns. You can link them together by means of orderId which is the same for the transaction and the items added to that transaction (tr_orderid and ti_orderid): https://github.com/snowplow/snowplow/wiki/2-Specific-event-tracking-with-the-Javascript-tracker#33-ecommerce-tracking