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

adderfaust
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
OrderMetrics
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.
ClementG
Shopify Partner
659 0 128

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

Siravi_Kitchen
Tourist
59 0 1

Thanks for the information.

Siravi Stainless Steel Kitchen
0 Likes
John__S
Excursionist
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.

Thanks!

Data Export is rated by Shopify Sellers as the best and cost-effective reporting application on Shopify.
john_rp
Excursionist
98 0 9

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