Part of the issue is that the customer isn’t charged for a product, they are charged for an order. So if a customer places an order with 3 products, it generally only has one transaction, with a single payout and a single transaction fee.
Topic summary
Main issue: a merchant wants a single, detailed transaction line that captures every aspect of a sale for accounting.
Requested fields include:
- Currency paid by the customer
- Date paid out by Shopify (payout date)
- Shopify charges/fees
- Product and quantity
Key context: a transaction in Shopify is tied to the order level, not individual products. One order with multiple products typically maps to a single transaction, one payout, and one transaction fee. This order-level model limits how “per-product” transaction details appear in default reports.
Solutions discussed: Shopify’s built-in reports have customization limits. A third-party reporting app (Report Pundit) was recommended as it can generate custom reports with the specified data.
Actions/decisions: the merchant will start Report Pundit’s free trial to verify access to the needed data and format.
Status: no native, all-in-one transaction line confirmed. The thread remains open pending the outcome of testing a third-party tool. Unanswered question: whether a consolidated line can fully reconcile order-level transactions with item-level detail in one row.