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)?

Highlighted
New Member
2 0 0

Hello,

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

0 Likes
Highlighted
Tourist
22 0 2

Hey,

Check out https://apps.shopify.com/order-metrics-profit-analytics

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

No more spreadsheets.

-Hank

Our software helps you lower shipping costs and improve your gross profit margin.
1 Like
Highlighted
Shopify Partner
660 0 119

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 clement@betterreports.co if that seems interesting to you.

Best,

Clement

1 Like
Highlighted
Tourist
59 0 1

Thanks for the information.

Siravi Stainless Steel Kitchen
0 Likes
Highlighted
Tourist
78 0 3

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.

Thanks!

Data Export is rated by Shopify Sellers as the best and cost-effective reporting application on Shopify.
1 Like
Highlighted
Excursionist
76 0 5

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.

Thanks,
John 

Report Pundit - Instant reports and custom dashboards
0 Likes