I have asked support about this several times and just get a "you can't do that".
Shopify is lacking a very simple, and to me, common sense report. I need to know, on each payout, how much of the payout, after fees, is for what product. I need to track, my net profit for each product in my store. Currently there is no way to do that. From an accounting standpoint, I need to credit $x.xx net profit to product A, $Y.yy net profit to product B, etc.
I don't understand how anyone wouldn't want this?
Does anyone know any way to do this?
Shopify doesn't provide this report because this is not the way that payouts and fees work, from a data perspective. Take an example of a single order for $55 made up as follows:
Product A - $30
Product B - $20
Customer Shipping Paid - $5
You then have the following that affects your profit:
COGS Product A - $17
COGS Product B - $8
Shipping paid by merchant - $4.50
Transaction Fees - $.47
So you order profit would be $55 - $17 - $8 - $4.50 - $.47 = $25.03
Your product profit is as follows:
Product A = $30 - $17 = $13
Product B = $20 - $8 = $12
There is no way to assign transaction fees and shipping profit/loss to an individual product, because these are calculated and assigned at the order level.
Claudia here from Better Reports.
Have you been able to find a solution for this report? If not, I would recommend our app Better Reports for this.
The limitations to creating this type of report are based on how the data is structured in Shopify. We can create a sales report with payout fee overriding these limitations with a few assumptions such as one transaction per order, assuming Shopify payments is the primary gateway, etc.
In addition to this, Better Reports has more than 60 built-in reports available out of the box that cover many common use cases for merchants. You can schedule reports to run at set frequencies to your email or Google Drive or export the reports in CSV, Excel or PDF format.
I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.
What do you think?
On our Shopify Expert Marketplace, you can find many trusted third party developers and fr...By Arno Nov 27, 2023
You've downloaded the Search & Discovery app from the Shopify App store, and as you're ...By Skye Nov 8, 2023