> ## Knowledge Base Index > Fetch the complete knowledge base index at: https://help.refrens.com/sitemap.xml > Use this file to discover available pages before exploring further. > Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash). # How to Use the Unsold Inventory Report? Inventory that stays unsold for weeks or months locks up your cash and can eventually lead to losses. The **Unsold Inventory Report** helps you spot this stock, understand how much value is tied up in it, and take timely action before it becomes a bigger problem. With this report, you can: * Instantly spot items that have been sitting unsold for weeks or months. * Know exactly how much money is tied up in unsold stock. * See when an item was last sold to understand how long it has been sitting. * Identify which warehouse is holding the unsold stock. * Check unsold stock at the item or batch level. ![](https://storage.crisp.chat/users/helpdesk/website/-/a/b/8/8/ab884d8153100800/chatgpt-image-sep-24-2026-1226_11qoc66.png =747xauto) # Opening the Unsold Inventory Report To open the report: Go to **Products & Inventory** => **Unsold Inventory Report** ###### => Preparing the Report for First-Time If you're using the Unsold Inventory Report for the first time, you may see an activation card instead of the report. This appears for existing businesses that need to prepare their historical inventory data. ![](https://storage.crisp.chat/users/helpdesk/website/-/a/b/8/8/ab884d8153100800/image_1ct1wfu.png =679xauto) To prepare your report: 1. Open the Unsold Inventory Report. 2. Click **Open Report** on the activation card to start preparing your historical inventory data. 3. The button will change to **Preparing Report...** while the data is processed in the background. 4. Once the preparation is complete, you'll receive a notification with a link to open the report. After successful preparation, the activation card will no longer appear, and you can access the report directly. || Note: Newly created businesses don't need this activation step. Their stock movement data is maintained automatically, so the report opens directly. ![](https://storage.crisp.chat/users/helpdesk/website/-/a/b/8/8/ab884d8153100800/image_1q27t4u.png =736xauto) The report shows inventory that has remained unsold for at least the number of days you specify. # Filter the Report The report lets you choose how long an item can remain unsold and which warehouse you want to check. ![](https://storage.crisp.chat/users/helpdesk/website/-/a/b/8/8/ab884d8153100800/chatgpt-image-sep-24-2026-1240_t2mb5c.png =790xauto) ###### => Items Unsold Since: Every business has a different selling cycle. A bakery may expect its stock to move within a few days, while furniture or industrial businesses may expect inventory to sit for weeks or months. So, there is no single number of days that defines "unsold" for every business. Use **Items Unsold Since** to set the number of days that best matches your business. By default, it is set to **90 days**, but you can set it anywhere between **1 and 180 days**. ###### => Warehouse: The **Warehouse** filter is available when you track multiple warehouses. You can select a single or multiple warehouses. This is useful when you want to find out whether unsold stock is concentrated at a particular location. Once you've selected your filters, click **Apply**. # Understanding the Summary Cards Once you apply the filters, you'll see two summary cards at the top of the report. ![](https://storage.crisp.chat/users/helpdesk/website/-/a/b/8/8/ab884d8153100800/chatgpt-image-sep-24-2026-1247_17z2h9b.png =771xauto) ###### => Total Unsold SKUs Shows how many different SKUs currently have unsold stock matching your selected filters. This gives you a quick idea of the **scale of your unsold inventory**. ###### => Unsold Stock Value Shows the total value of the stock identified as unsold. This helps you understand **how much money is currently tied up in inventory that isn't moving**. | Tip: If the Unsold Stock Value is high, start by looking at the items with the highest stock value. These are the items where taking action can have the biggest impact on your inventory. ## # Understanding the Report Table The report table gives you an **item-wise breakdown** of your unsold inventory. ![](https://storage.crisp.chat/users/helpdesk/website/-/a/b/8/8/ab884d8153100800/chatgpt-image-sep-24-2026-1257_1ogk3cm.png =827xauto) The table includes: | Field | Description | | ---- | ---- | | **Item** | The inventory item that has remained unsold. | | **SKU** | The SKU of the item. | | **HSN** | HSN code, where applicable. | | **Warehouse** | The warehouse holding the stock, when warehouse management is enabled. | | **Batch Code** | The unique code assigned to the batch. | | **Batch Name** | The name assigned to the batch. | | **Days without Sales** | How many days it has been since the item's last stock-out. | | **Stock In Hand** | The quantity currently available. | | **Unit** | The unit used to track the item. | | **Avg. Buying Price** | The average buying price of the item. | | **Stock Value** | The approximate value of the stock currently sitting unsold. | | **Last Stock Out On** | When the item was last moved out of stock. | | **Last Stock Out Type** | The type of the last stock-out transaction. | | **Last Stock Out To** | Where or to whom the stock was last moved. | # Take Action from the Report You can take actions directly from an item in the report. Available actions include: **View Item:** Open the item's details and review its inventory information. **Adjust Stock:** Adjust the item's stock when required. ![](https://storage.crisp.chat/users/helpdesk/website/-/a/b/8/8/ab884d8153100800/image_4ds0uy.png =792xauto) # Download the Report Need to analyse the data outside Refrens or share it with your team? Click **Download CSV** at the top-right of the report. ![](https://storage.crisp.chat/users/helpdesk/website/-/a/b/8/8/ab884d8153100800/image_60b7fe.png =797xauto) You can use the downloaded report to: * Analyse unsold inventory. * Share the data with your warehouse team. * Identify high-value unsold stock. * Plan clearance or promotional campaigns. * Review warehouse-wise inventory. # Take Action on Unsold Inventory Once you've identified inventory that isn't moving, you can decide what to do with it. ###### => Run a Flash Sale Promote older inventory at a special price to encourage sales. You can also use previous customer information to reach out to customers who have purchased the item before. ###### => Write Off the Stock If the inventory is no longer useful or commercially viable, you can follow your business process to write it off. ###### => Return It to the Vendor If your vendor allows returns, identify eligible unsold stock and initiate the return process. The report helps you identify **what needs attention and where to start**. # Tips for Managing Unsold Inventory * **Set the right threshold** based on how quickly your products normally sell. * **Check the stock value** to identify where the most money is tied up. * **Look at Days without Sales** to find inventory that has been sitting the longest. * **Check warehouse-wise stock** to see where inventory is accumulating. * **Look at batches separately** when you have multiple batches of the same item. * **Check previous customers** before planning a flash sale or promotional campaign. * **Review the last stock-in and stock-out details** before deciding what to do with the inventory. * **Download the report** when you need to analyse or share the data with your team. If you still have questions, reach out to us at [__care@refrens.com__](mailto:care@refrens.com) or contact us through chat support for quicker assistance.