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]

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

[OrderMetrics]

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

[ClementG]

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]

Thanks for the information.

[John__S]

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!

[Report-Pundit]

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