Does Shopify Show a Sale Line Cost of Goods for Orders Anywhere?

AppOut-Kevin
New Member
5 0 0

I have been trying to find an answer to this, but is there anywhere that the sale line item COGS is stored for a given order?  Here is an example of the scenario I am looking at.  Let's say I buy an item for $50 wholesale and sell it for $100 on order #1.  I reorder the item from my vendor, but the wholesale cost is now $70 and I decide not to increase my retail cost.  I update the item cost on the product page in Shopify and then sell it on order #2, still for $100.  Are the $50 and $70 costs stored anywhere in the information for orders #1 and #2 so that a profitability report would show $80 in profit on $200 in sales or will the COGS be calculated using the current $70 cost and the report would show only $60 in profit on $200 in sales, which is obviously incorrect?  

0 Likes
Nick_Marketing
Shopify Partner
266 49 66

You can pull somewhat similar information from the Shopify report.  Go to /admin ---> Analytics ---> Report  ---> Finances Summary.

But most likely you will need an external app.

- I help businesses with eCommerce and Marketing Technology integrations.
- For consulting work inquiries, please send me a Private Message.
- Presently working in Toronto, CANADA.
0 Likes
CloudlabSam
Explorer
76 3 6

The short answer is no. The long answer can be found in this blog post - https://www.cloudlab.com/post/data-you-can-t-get-from-shopify-volume-1. See the section on profit reports. If you're interested in trying out our app - you can install it here. Thanks!

0 Likes
Report-Pundit
Excursionist
145 0 11

Hi @AppOut-Kevin ,

I am John from Report Pundit, a reporting and analytics app with more than 500 five-star reviews.

Report Pundit can capture the wholesale cost of $50 and show $50 as profit, and when the cost is updated to $70  it can show $30 as profit on the sales value.

We have created business-specific custom reports to more than 10k Shopify merchants

Our team of experts can set up the report for you.

Contact at support@reportpundit.com or our live chat support team for a report set up

Thanks,
John

Report Pundit - Instant reports and custom dashboards
0 Likes
Ofer_BeProfit
Shopify Partner
52 0 3

Hi @AppOut-Kevin - the BeProfit Profit Tracker app is exactly what you're looking for.

You'll get a dashboard that lets you track and analyze all of your profits and expenses including COGS, marketing costs, shipping, and more (you can manually enter expenses as well). As your question specified, BeProfit also provides detailed reports which you can export, and even lets you create your very own custom reports that focus on exactly the data you want to analyze.

The app is very quick to set up and integrates seamlessly with your marketing platforms and even Shopify Shipping so that you can track your profits and expenses with precision.

Plus if you need any help navigating the app or have any questions, our support team is happy to provide you with hands-on assistance!

You can use BeProfit to:

  • Create and export custom reports
  • Track your profit history over time
  • Get intuitive visuals and graphs
  • Freely edit your store's data
  • Understand complex business metrics
  • Connect metrics once with smart integrations
  • Spot what factors need improvement to increase profits
  • Make data-driven decisions to optimize your store

Try BeProfit and let us know if you find it helpful. Plus, if you have any suggestions on how we can improve the app, we're always happy to get feedback! Good luck

0 Likes