How is the dead stock calculated in the app
Dead Stock refers to inventory items that have not been sold or used for a long period and are unlikely to be sold in the future. These items are essentially stagnant and can represent a financial burden for a company, as they tie up capital without generating any revenue.
SKU: Stock Keeping Unit, a unique identifier for your product variants.
Product published date: when the product has been published on Shopify.
Units sold: how many units sold of products in a certain period.
Stock on hand: the current stock levels of each product.
Last received date: the last time recieved inventory from suppliers.
Last received units: how many arrived units at the last time recieved inventory from suppliers.
Aged days: how many days since last received date.
This report is showing the inventory are in-stock but received more than 30 days (the aged days > 30). However, you can change the filter condition to get the products that were in-stock longer. e.g. 180 days.
Terms and formula
SKU: Stock Keeping Unit, a unique identifier for your product variants.
Product published date: when the product has been published on Shopify.
Units sold: how many units sold of products in a certain period.
Stock on hand: the current stock levels of each product.
Last received date: the last time recieved inventory from suppliers.
Last received units: how many arrived units at the last time recieved inventory from suppliers.
Aged days: how many days since last received date.
[To Day] - [Last Received Date]
Filters and conditions
This report is showing the inventory are in-stock but received more than 30 days (the aged days > 30). However, you can change the filter condition to get the products that were in-stock longer. e.g. 180 days.
Updated on: 18/08/2024
Thank you!