Posted on 5 Comments

Stock at sales value in WooCommerce

Why is stock valuation important?

Most of WooCommerce stores use WooCommerce inventory management to track the stock of the products. Having an accurate valuation of inventory is important because the reported amount of inventory will affect the cost of goods sold, gross profit, and net income on the income statement, and the amount of current assets, working capital, total assets, and store owner’s equity reported on the balance sheet.

Stock at sales value

This is our new report which lists each product which has inventory management enabled and provides:

  • reported stock status
  • stock quantity
  • price
  • on-sale price
  • cost – element added by WooReports at Product level
  • period in which on-sale price is active, if any
  • the inventory value at sales (or retail) price (price * quantity)
  • the inventory value at on-sales price ( on-sale price * quantity)
  • today’s inventory value, which considers either price or on-sale price * quantity, if today is a day within the on-sale period
  • inventory value at cost, cost * quantity

35
38

Stock at sales value analytical

Presents the totals in a grid, line and column charts, for all stored totals data. Retained totals over

  • the inventory value at sales (or retail) price (price * quantity)
  • the inventory value at on-sales price ( on-sale price * quantity)
  • inventory value on the report date, which considers either price or on-sale price * quantity, if the report date was a day within the on-sale period
  • inventory value at cost, cost * quantity

36

Settings page

Optionally, configure the reports to store the totals on reports access, at end of week or end of month.
37

Demo

Our demo platform is updated and you can see both reports related to stock value. Access demo at this link.

Feedback

Commenting is turned on, so feel free to share your feedback, ideas and needs below!

Lucian Capdefier

Analytics Evangelist / WooReports Author at WooReports
I have more than twelve years of experience in successful business and technical consulting, system design, development, implementation, training and support of mission critical systems, leveraging data integration, data management, analytics and information optimization to provide business advantage.

Latest posts by Lucian Capdefier (see all)

Share now and help us in making WooReports popular
Share on Facebook
Facebook
Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin
Posted on 5 Comments

5 thoughts on “Stock at sales value in WooCommerce

  1. Update 1.2.1

    Stock value report contains products in stock evaluated at cost; cost element added at product level.
    Integration with WooCommerce Cost of Goods also – in case you are using this plugin, cost element at product level retains the value.

  2. Hi, I’ve bought your plugin because I need to get stock value. That was the only reason of the purchase. But all my products have variants and I can’t see anything but columns of zeros in the report. Very sad. Could you please help me?
    Thank you

    1. Dear Pietro,

      Thank you for raising the issue. We will investigate this and come back with a fix.

      1. Product variations included in Stock Value report.
        Product variations do not yet still manage cost value, therefore the stock cost value is reported zero. This feature will be enabled soon.

        Please update the plugin.

        Happy reporting!
        WooReports Team

    2. Product variations included in Stock Value report.
      Product variations do not yet still manage cost value, therefore the stock cost value is reported zero. This feature will be enabled soon.

      Please update the plugin.

      Happy reporting!
      WooReports Team

Leave a Reply

Your email address will not be published. Required fields are marked *