Say you own a bus Shopify store selling 10-50 orders per day for around $500 a pop. You acquire a lot of fees, and in the process have to issue invoices, and deal with accounting.
In Shopify you get paid as a merchant, using Shopify, and so all your money is coming from orders. How do you use the API to find out which orders contributed to a Shopify Payment payout from Shopify?
It seems that there is no easy way to go hey, these orders belong to this payout. End of story. Can anyone point out how to best tie orders to payouts? Is it via data embedded in the order transactions concerning payments? The Shopify Payments API has almost no useful report data, so I assume one has to work from orders and transactions to payouts?
Gah, it looks like GraphQL is useless for this, one has to sink back down to RestAPI levels, and in there, under Payouts, one finds transactions, which have orders and payouts linked with ID.. OK. so that settles that.
Apparently, all the Apps dealing with accounting at this level are complete horse doodoo. I will have to investigate for myself.
Hi @HunkyBill ,
Kritesh here from Better Reports support team.
I believe our app Better Reports may be able to help. We have a built-in report that shows all the transactions that comprise a Shopify payout by order. This report also lists the fees separately so you can compare the net amount to the money you see in the bank.
We can also show other properties like order tags, the customer's name, orders billing country/city etc. to customize this report for you.
In addition to building custom reports to meet your specific needs, you'll have access to 60+ built-in reports that cover many common use cases for merchants and our reports can be scheduled to send to your email or Google Drive at set frequencies.
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.
Um. No. I do not need your App at all. Actually, the solution was quite simple. Just ask Shopify for permission on the right scope key, and all Payout information becomes available, nicely tied to orders. So a couple of lines of code and it's clear. But thanks anyway. Good luck with your App!