An advanced inventory feature helps you future product stock levels so you can identify which products are fast-moving, average-moving, or slow-moving. Fast-moving products must be carefully managed; Managing these levels is crucial to ensuring operational continuity and maintaning customer trust.
DealPOS help you manage inventory levels through the Inventory - Days Of Menu. Please refer to the instructions below.
I. Inventory Days Of from Products
Step 1. Go to Products, click on Variant
Step 2. Choose tab Days Of, Inventory days of previewed
Table Description
Property | Description |
Outlet | Displays the name of the outlet where the product stock is available. |
Available | Displays the current available stock quantity of the product at the outlet. |
14 Days Sales | Displays the total quantity of the product sold over the last 14 days. |
Qty/Day | Displays the average daily sales quantity over the last 14 days. |
Days Of | Displays the estimated number of days the current stock can cover based on the average daily sales quantity. |
Formula
Qty / Day = Total sales over the last 14 days ÷ 14 days.
Days Of = Available ÷ Qty / Day.
II. Days Of Dashboard View
The Inventory Days Of section provides two visualization options to help users analyze inventory conditions. The Pie Chart shows the proportion of SKUs in each inventory category, while the Bar Chart provides a breakdown of these categories by product, making it easier to identify which products have critical or excessive stock levels.
1. Pie View
Displays the percentage and distribution of SKUs across the Negative, Critical, Optimal, and Overstock categories, helping users identify the overall inventory condition.
Category | Description |
Negative (< 0 days) | Products with negative inventory days of, indicating that stock coverage is below zero based on the sales rate. |
Critical (1–14 days) | Products with an estimated stock coverage of 1–14 days, indicating that stock may need to be replenished soon. |
Optimal (14–60 days) | Products with an estimated stock coverage of 14–60 days, indicating a generally healthy stock level. |
Overstock (> 60 days) | Products with an estimated stock coverage of more than 60 days, indicating that stock may exceed expected demand. |
2. Chart View
Displays the number of SKUs by inventory category for each product, allowing users to compare stock conditions and identify products that may require attention.
III. Days Of Inventory For All Products
1. Days Of Report
The Days Of report provides an overview of product stock coverage based on current available stock and average daily sales. It helps users identify how long their current stock is expected to last and assess whether stock replenishment may be needed.
Property | Description |
Product | Displays the product name. |
Code | Displays the product code. |
Available | Displays the current available stock quantity. |
Sold/Day | Displays the average daily sales quantity. |
Days Of | Displays the estimated number of days the current stock will last based on the average daily sales. |
Risk | Indicates the stock condition based on the estimated Days Of value, categorized as Negative, Critical, Optimal, or Overstock. |
2. Advanced Days Of Report
Click on Advanced Days Of button
Adjust Column to View (Optional):
Report Previewed
The Advanced Days Of report provides a more detailed view of inventory coverage by including replenishment lead time, stock transfers, and additional sales and profit information. Users can also customize the displayed columns to focus on the inventory data relevant to their needs.
Property | Description |
Product | Displays the product name. |
Code | Displays the product code. |
Available | Displays the current available stock quantity. |
Sold/Day | Displays the average daily sales quantity. |
Days Of | Displays the estimated number of days the current stock will last based on the average daily sales. |
Risk | Indicates the inventory status based on Days Of, categorized as Critical, Optimal, or Overstock. |
Displays the number of days required for stock replenishment. | |
Effective Days | Displays the remaining stock coverage after accounting for Lead Time. Calculated as Days Of − Lead Time. |
T. In | Displays the incoming stock quantity from Transfer Orders sent by other outlets. |
T. Out | Displays the outgoing stock quantity from Transfer Orders sent to other outlets. |
Qty Sold | Displays the total units sold before the most recent purchase. |
Month Sales | Displays the average monthly sales quantity, calculated by dividing the total units sold over the last 90 days by 30. |
Daily Profit | Displays the average daily profit, calculated by dividing the total profit over the last 90 days by 30. |
Related Articles
If you want to know more details about your product's movement log. Please refer to the article below:
Tracking Product Inventory Movements Using the Inventory Log (Stock Card)If you want to bulk input in the Buy menu. Please refer to the article below:
Bulk Input Product when Purchasing OrderIf you want to ajudst your product's inventory/stock you can use the Adjustment menu, to learn more details about Adjustment. Please refer to the article below:
Adjustment
DealPOS is an online point-of-sale (POS) application specifically designed for retail businesses in categories like Fashion, Minimarkets, Electronics, Fresh Food, and Building Material Stores.
With DealPOS, you can manage both online and offline store inventory in real-time on a single platform. You can also sell through omnichannel (offline and online) as DealPOS integrates with marketplaces (Shopee, Tokopedia, TikTok Shop, Lazada) and instant web stores (Shopify and WooCommerce).
For more detailed financial book-keeping, Books App is available as a separate accounting application. In addition, stock counting becomes easier with the DealPOS Scanner App, which supports barcode scanning features.