This article details the dataset structure that Alight Analytics considers standard for the Order Transaction dataset from Shopify. There is a 1 day lag with a 30 day span that will be run daily. Please note that it may take up to a few days for transactions to be populated in this dataset.
This dataset can be automatically activated without a ticket through Dataset Activation.
|Report Date||Date||The date the transaction was created.|
|Created At||Datetime||The date and time the transaction was created.|
|Order ID||Datetime||The ID for the order that the transaction is associated with|
|Transaction ID||Timestamp||The ID for the transaction|
|Amount||Timestamp||The amount of money included in the transaction|
The transaction's type. Valid values:
|Gateway||Number||The name of the gateway the transaction was issued through|
|Status||Number||The status of the transaction. Valid values:
|Message||Number||A string generated by the payment provider with additional information about why the transaction succeeded or failed|
|Source Name||Number||The origin of the transaction. This is set by Shopify and can't be overridden. Example values:
|Currency||Number||The three-letter code for the currency used for the payment|
|Insert Date||Timestamp||ChannelMix Field: when the row was inserted into the dataset|
|ChannelMix Profile||Dimension||ChannelMix Field: the ChannelMix Profile associated to the data|