The “Product” menu has two different reports available for export to CSV or Excel files, the "Dead Stock" report and the "Stock Movements" report. As with most pages in Stockpit, filtering and views function can also be applied to both reports.
Dead Stock
Dead Stock, or dead inventory, can also be referred to as Obsolete Inventory, it is defined as stock quantities currently unsold at this time or during a time period.
Depending on the type of product you are selling, this may be stock that is difficult to sell or obsolete versions of other products.
Often, a large amount of dead stock will negatively affect your business and your bottom line.
In Stockpit you can track dead stock per product and location using the latest date when the product was sold. For this to function, there is a “mandatory filter”. The “Last sold date older than” filter must be used to restrict the information in a time from older than 30 days, 90 days, 180 days or 360 days.
Let’s say that last year, you had purchased 100 units of Product A planning to sell that from your default location over the year. The dead stock report based on “superior to 30 days” report indicates that the last sale was 6 months ago, and since then, you had a dead stock of 20 units.
Stock movements
The "Stock movements" report is a simplified version of the Inventory Logs. This feature is specifically focused on the products and their activity rather than the logs which track the stock levels.
This simplified version will state the creation date, product, context, location, on hand stock and the movements that took place.
The movements are colour coded: green for additions to stock (entries via adjustments, purchases, and movements) and red for deduction (removals via adjustment, sales, shipping orders, and movements).