purchases

Each row represents a commerce purchase with amounts, tax, discounts, success/failure, user, and product context.

Full schema

View all columns and table relationships

Status group

No, this table does not include a statusgroup column.

Sample query

select
  t.analyticsversion,
  t.amountcharged,
  t.amountdiscounted,
  t.amountdisputed,
  t.amounttaxed
from purchases as t
limit 100