Simply, I want a report of Payouts by Item. There doesn’t appear to be a way to do this in Shopify Reports. I tried to write something in ShopifySql but it appears you can’t join Sales and Payouts tables. Is that true? Any other thoughts?
Thanks!
Chet
Topic summary
A user seeks a report showing payouts broken down by individual product (SKU level), which Shopify’s native reporting doesn’t support. The core issue is that Shopify’s data structure doesn’t allow joining Sales and Payouts tables directly.
Technical Challenge:
- Payouts typically cover multiple orders
- Payments apply to entire orders, not specific line items
- Complications arise with partial payments, mixed payment methods, refunds, and gateway fees
- No direct data linking which portion of a payment corresponds to which product
Proposed Solutions:
- Report Pundit offers custom fields that calculate individual payouts per SKU, including transaction types and final deposited amounts
- Can handle mixed orders with multiple line items
- Supports time-based aggregation (monthly totals per item)
- Better Reports explains that estimates are possible with simplifying assumptions (single transaction per order, one primary gateway)
Outcome:
The original poster found a temporary workaround but shows interest in Report Pundit’s solution, which appears capable of delivering the requested monthly payout totals by product. Screenshots demonstrate the app’s payout breakdown functionality.
@chetnet ,
Yes, you’re right — Shopify doesn’t let you combine Sales and Payouts in the same report. To see them together, you’ll need to use a third-party app. You can try Report Pundit — it shows detailed data, including line items, which helps you understand sales and payouts for each product more clearly.
Please find the payout details screenshot for your reference.
Hi @chetnet
Claudia here from Better Reports!
The reason this isn’t a built-in option is due to how the data is structured between the Payout and Order Lines tables.
Here’s a quick explanation:
- A payout usually covers multiple orders processed via Shopify Payments.
- Even if we assume a payout relates to just one order, payments don’t always match individual products.
- For example, partial payments are common, but the data cannot specify which part of the payment goes to which product within the order or which portion of the product.
Let’s say:
-
An order totals $110, with Product A = $60, Product B = $40, and Shipping = $10.
-
The customer pays $25 via PayPal, $20 via gift card, and $65 via Shopify Payments.
The challenge:
-
The data does not tell us if the $65 was for Product A, B, or split between them.
-
Payments are applied to the entire order, not specific products, making it hard to precisely link payouts to individual products.
-
This gets even more complex when you factor in returns, discounts, and gateway fees.
That said, if you’re okay with some simplifying assumptions:
-
One transaction per order.
-
Ignoring partial refunds.
-
Assuming Shopify Payments is the main gateway.
Then, we can estimate gateway fees at the product level quite closely — which I believe is what you’re after.
Thanks RP! Can you handle mixed order, with multiple items?
Thanks BP-C! Much appreciate the thorough explanation, and makes perfect sense. Having said that, we can’t get away from multi-item orders. I found a workaround I’m using in meantime since this isn’t that critical for us. Thanks again!
@chetnet , Yes, we can handle mixed orders with multiple line items. At Report Pundit, we’ve designed a custom field to show the calculation of individual payouts for each SKU in an order. This includes all transaction types, the parent amount, and the final amount deposited into your bank account.
I’ve attached a screenshot for your reference. It includes one sample order and product to illustrate the report.
Hope this answers your question.
Thanks. That is promising for sure. So does that mean we could get a single payout total on a monthly basis (or whatever time dimension) on per item basis?
Thx,
Chet
@chetnet , Yes, it can be done.