Auto PO Replenishment – Retail Business Scenarios
Introduction
Auto PO Replenishment in iDempiere automatically monitors stock levels and generates Purchase Orders when inventory falls below configured thresholds. It is used across retail stores and distribution warehouses to maintain availability for fast-moving goods, groceries, seasonal items, and multi-category catalogs.
By combining Replenishment Rules, Product Purchasing, and Scheduler execution, it reduces manual procurement monitoring and keeps stock aligned with demand, directly impacting purchasing efficiency and inventory reporting.
Retail Scenarios
The following scenarios reflect common retail procurement situations supported by the standard Purchase Order functionality in iDempiere.
- Fast-Moving Product Replenishment
- Grocery and FMCG Shelf Replenishment
- Warehouse Stock Replenishment
- Seasonal Demand Replenishment
- Multi-Product Replenishment
- Vendor-Based Automated Procurement
Fast-Moving Product Replenishment
Overview
Used for high-velocity SKUs that need frequent reorder triggers to prevent shelf stockouts.
Key Setup / Inputs
| Field in iDempiere | Sample Value | Purpose |
| Replenish Type | Reorder below Minimum Level | Defines the reorder trigger logic |
| Minimum Level | 10 | Stock threshold that triggers replenishment |
| Maximum Level | 50 | Target stock quantity after replenishment |
| Scheduler | Daily Replenishment – 1 Hour | Frequency at which stock is evaluated |
Process Flow
- Set Replenish Type to Reorder below Minimum Level on the product’s Replenish tab.
- Enter Minimum Level and Maximum Level based on historical sales velocity.
- Confirm the Scheduler is running on a short interval suited to fast-moving stock.
System Behavior
- Checks Available Quantity against Minimum Level on every scheduler run.
- Generates a Drafted Purchase Order once stock falls below the threshold.
- Calculates order quantity as Maximum Level minus Available Quantity.
Retail Example
Aashirvaad Atta stock drops from 20 units to 5 units while Minimum Level is set to 10, triggering replenishment on the next scheduler run.
Outcome
- Fast-selling items are restocked before they go out of stock.
- Store staff no longer need to manually track high-velocity SKUs.
Grocery and FMCG Shelf Replenishment
Overview
Used to keep daily-use grocery and FMCG products continuously available on store shelves without manual checks.
Key Setup / Inputs
| Field in iDempiere | Sample Value | Purpose |
| Product Type | Item (Stocked, Purchased) | Confirms eligibility for replenishment |
| Replenish Type | Reorder below Minimum Level | Reorder logic applied per product |
| Source Warehouse | Blank | Ensures a Purchase Order is generated, not a transfer |
| Scheduler | Daily Replenishment | Process that evaluates all configured products |
Process Flow
- Enable the Stocked and Purchased flags on each grocery or FMCG product.
- Configure the Replenish tab for each product with Minimum and Maximum Level.
- Leave Source Warehouse blank so the rule generates Purchase Orders.
System Behavior
- Evaluates every configured product against its replenishment rule.
- Generates a Purchase Order line for each product that falls below its minimum.
- Leaves products above minimum level unaffected during the same run.
Retail Example
Daily sales reduce stock of cooking oil, rice, and packaged snacks below their configured minimum levels at a supermarket outlet.
Outcome
- Shelf availability is maintained for everyday essential items.
- Procurement effort is reduced across a large grocery product catalog.
Warehouse Stock Replenishment
Overview
Used by distribution warehouses to keep central stock sufficient to supply retail stores.
Key Setup / Inputs
| Field in iDempiere | Sample Value | Purpose |
| Warehouse | CDC Godown | Warehouse monitored for replenishment |
| Locator | Godown Locator | Inventory locator within the warehouse |
| Maximum Level | 500 | Target inventory level for the distribution warehouse |
| Scheduler | Daily Replenishment | Triggers evaluation of the warehouse rule |
Process Flow
- Configure the Replenish tab against the warehouse-level locator instead of the store locator.
- Set Minimum Level and Maximum Level to reflect distribution-scale stock targets.
- Confirm Source Warehouse is blank so replenishment generates a vendor Purchase Order.
System Behavior
- Monitors aggregate warehouse inventory against the configured thresholds.
- Calculates the procurement quantity needed to reach Maximum Level.
- Generates a Purchase Order to restore central warehouse stock.
Retail Example
A distribution warehouse stocking mobile phones, appliances, and packaged grocery items falls below its configured minimum during a high-demand week.
Outcome
- Central inventory stays sufficient to supply multiple retail stores.
- Store-level stockouts are reduced through proactive warehouse replenishment.
Seasonal Demand Replenishment
Overview
Used to raise stock targets temporarily ahead of festivals, holidays, or promotional periods.
Key Setup / Inputs
| Field in iDempiere | Sample Value | Purpose |
| Minimum Level | 50 (Seasonal) | Higher threshold for the promotional period |
| Maximum Level | 200 (Seasonal) | Higher target stock for peak demand |
| Replenish Type | Reorder below Minimum Level | Reorder logic remains unchanged |
| Scheduler | Daily Replenishment | Continues to evaluate stock during the season |
Process Flow
- Update Minimum Level and Maximum Level on the Replenish tab ahead of the season.
- Apply the revised levels to all products expected to see a demand spike.
- Revert the levels to standard values once the seasonal period ends.
System Behavior
- Evaluates stock against the temporarily raised thresholds.
- Generates larger Purchase Order quantities to meet the higher Maximum Level.
- Continues standard replenishment logic without requiring a different process.
Retail Example
Chocolate gift packs and beverages see a sales spike ahead of a festival, prompting an increase in configured stock levels.
Outcome
- Stores carry enough stock to meet peak seasonal demand.
- Promotional sales are not constrained by inventory shortages.
Multi-Product Replenishment
Overview
Used when several unrelated products require evaluation and replenishment within the same scheduler run.
Key Setup / Inputs
| Field in iDempiere | Sample Value | Purpose |
| Replenish Rule (Product A) | Configured per product | Independent reorder logic per SKU |
| Replenish Rule (Product B) | Configured per product | Independent reorder logic per SKU |
| Scheduler | Daily Replenishment | Single process evaluates all configured products |
Process Flow
- Configure a separate Replenish tab entry for each product requiring automation.
- Set Minimum and Maximum Level individually for each product.
- Allow the same scheduler run to evaluate all configured products together.
System Behavior
- Evaluates each product’s replenishment rule independently within one run.
- Calculates procurement quantity separately for every qualifying product.
- Generates individual Purchase Order lines for each product that qualifies.
Retail Example
Nike Shoes and Aashirvaad Atta both fall below their configured minimum levels during the same scheduler cycle.
Outcome
- Unrelated product categories are replenished together without separate processes.
- Procurement planning scales across a wide product catalog.
Vendor-Based Automated Procurement
Overview
Used to ensure replenishment Purchase Orders are generated with the correct preferred supplier automatically.
Key Setup / Inputs
| Field in iDempiere | Sample Value | Purpose |
| Business Partner | HAVELLS INDIA MART | Vendor used for replenishment procurement |
| Current Vendor | Enabled | Marks this vendor as default for the product |
| PO Price | 550 | Price applied on the auto-generated Purchase Order |
Process Flow
- Add the vendor on the product’s Purchasing tab with PO Price and UOM.
- Enable Current Vendor so the system uses this supplier by default.
- Configure the Replenish tab as usual to enable automatic evaluation.
System Behavior
- Pulls vendor and pricing details from the Purchasing tab during PO generation.
- Assigns the Current Vendor automatically without manual selection.
- Applies the configured PO Price to the generated Purchase Order line.
Retail Example
Aashirvaad Atta is configured with HAVELLS INDIA MART as the procurement vendor for replenishment.
Outcome
- Replenishment orders are placed with the correct supplier every time.
- Manual vendor selection is eliminated from the procurement cycle.