Payouts by Item (Product_Title)

[chetnet]

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

[Report-Pundit]

@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.

[chetnet]

Thanks RP!  Can you handle mixed order, with multiple items?

[Report-Pundit]

@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.

[chetnet]

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

[Report-Pundit]

@chetnet, Yes, it can be done.

[BetterReports-C]

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. 

[chetnet]

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!