Currently dropshipping via Oberlo, how do I generate a report that shows daily Cost Per Sale/COGS (total $ that I spent to buy products on aliexpress)?

New Member
3 0 0


Started a few weeks and now getting constant sales. Trying to create a spreadsheet to track my numbers and I cant seem to figure out a way to generate a report that shows the total amount of money that I spent to buy the products on aliexpress, unless I do it manaully.

Also, how do I generate a report that shows the total revenue on shopify?

So basically I need a report that shows daily total shopify revenue via stripe, shopify revenue via paypal, COGS (and maybe daily shopify fees charged)...

Thanks in advance

Replies 5 (5)
22 0 2


Check out

It integrates with AliExpress and automatically tracks all of the costs you mention 🙂

No more spreadsheets.


Our software helps you lower shipping costs and improve your gross profit margin.
Shopify Partner
660 0 148

Hi there,

You may also want to check out our app Better Reports.

There are a ton of built-in reports and you can easily build custom ones to break down your sales as you see fit.

It can also show your COGS, profit and revenue per payment gateway.

Feel free to reach out to me directly at if that seems interesting to you.



66 0 1

Thanks for the information.

Siravi Stainless Steel Kitchen
Shopify Partner
78 0 5

Hello - I'm John from Data Export.

We can create the report in the format you mentioned. It will include the COGS, sales by gateway, refunds and Shopify fees.

You can analyze your business metrics using our custom Dashboard.

Please contact me if you have any questions.


Data Export is rated by Shopify Sellers as the best and cost-effective reporting application on Shopify.
251 6 18

Hi @adderfaust,

Report Pundit can fetch the report that you outlined. It can split the revenue from Stripe and PayPal. You can also get the payment payment gateway fee and the daily COGS. 

Not only does it report gross profit margin, you can connect Facebook or Google Ads account to get daily ad spend. This report can show the daily net profit of the store.


Report Pundit - Instant reports and custom dashboards