Warehouse statistics - overview of your warehouse

What are warehouse statistics?

A well-functioning warehouse is essential for a healthy e-commerce business. Too much inventory ties up capital and increases the risk of obsolete goods. Too little stock means lost sales and frustrated customers. Inventory statistics in Shoporama give you a complete overview so you can act proactively.

You can find the page under Statistics → Stock in admin. The page is divided into an overview map at the top and three tabs below: Dead stock, Reorder and Stock turnover.

Important: Many of the calculations on this page require your products to have a cost price registered. Without a cost price, inventory value and capital tied up cannot be calculated correctly. You can enter the cost price for each product under the Purchase price field in the product editor.

The overview map - four key figures

At the top of the page you'll find four maps that give you a quick overview of your stock status:

• Total inventory value - the total cost value of all products in stock. Also shows the total number of products with inventory.
• Dead stock 90+ days - the total capital tied up in products that have not been sold for more than 90 days and the number of these products.
• Soon to sell out - number of products that are expected to run out within 14 days based on the current sales pace.
• Out of stock - number of products that currently have an inventory of zero.

Tab: Dead stock.

Dead stock are items that have been unsold for more than 90 days. They take up storage space, tie up capital and risk losing value over time.

For each product is shown:

• Product name and item number - with a direct link to the product edit.
• Inventory - the current number of units in stock.
• Cost price - the purchase price per unit.
• Capital tied up - stock multiplied by cost price. Amounts of 1,000 kr. or more are highlighted in red.
• Days since last sale - colored badges: grey for 90+ days, yellow for 180+ days, red for 365+ days. Products that have never been sold get a red badge.

What should you do? Consider whether the products can be put on sale, bundled with other items, returned to the supplier or written off. The older the dead stock is, the more important it is to act.

Tab: Reorder.

The reorder tab helps you keep track of which products are running low. Products are sorted by "days to sell out" with the most critical at the top.

For each product is shown:

• Inventory - the current number of units.
• Sold in the last 90 days - the number of units sold in the period.
• Daily average - the average daily consumption.
• Days to sell out - estimated number of days until stock is empty. Less than 7 days is shown in red, less than 14 days in yellow, and over 14 days in green.
• Supplier - so you quickly know who to contact.

The formula behind "days to out of stock" is: inventory divided by daily average sales (based on the last 90 days). Products with no sales in the period are not included in the list.

You can export the list as CSV via the Export to order button. The file is ready to send directly to your supplier.

Tip: Look at this tab weekly and compare "days to out of stock" with your supplier's delivery time. Order in good time - not when the stock is already empty.

The tab: Inventory turnover

Inventory turnover measures how quickly you turn over your inventory - how many times a year you "sell your entire inventory". A high turnover rate means that money is working fast. A low rate means that capital is tied up in slow-selling items.

The tab shows turnover broken down into two levels: per supplier and per brand. For each is shown:

• Inventory value - the current cost value of the inventory.
• Cost of goods sold (COGS) - the cost price of the items you have sold in the last 12 months.
• Turnover rate - cost of goods sold divided by inventory value, annualized. Green at 6x or above, red at below 2x.
• DSI (Days Sales of Inventory ) - the number of days it takes to sell your inventory. Calculated as 365 divided by the turnover rate. Red if over 180 days.

Example: A turnover rate of 4 and a DSI of 91 days means that your inventory is sold on average four times a year. For most e-commerce stores, 6-12 is a good target.

Practical tips for better inventory management

• Keep cost price up to date. Many calculations rely on the purchase price being correctly recorded.
• Put dead stock on offer. If a product hasn't sold for 180+ days, it's better to sell at a reduced price than to leave it unsold.
• Use the reorder list proactively. Compare "days to sell out" with the delivery time from your supplier.
• Focus on suppliers with low turnover rates. If the DSI is over 180 days, consider reducing the assortment.
• Check the site regularly. A weekly review of the reorder tab and a monthly review of dead stock will yield the best results.

CSV export

You can export data as CSV files: the dead stock list with stock, cost price and capital tied up, or the reorder list with sales pace - ready to use as a purchasing basis.

If you have any questions about stock statistics, please contact us at support@shoporama.dk.