As add_to_cart data stored in add_to_cart table, where is addTrans,addItem and trackTrans event data stored?
@Dev, they are loaded into events
table - columns ti_...
and tr_...
.
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?
@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