Setting Minimum Stock Levels for Consignment Products
The Minimum Stock (PAR) function allows suppliers to define the minimum quantity of each product that must be available at each Villa Market store.
This ensures proper stock planning, prevents Out of Stock (OOS) situations, and supports efficient replenishment operations.
🔹 1. Query Page (Main Page)
The main page of the Minimum Stock menu allows users to search existing PAR data, add new PAR entries, or import/update PAR information from Excel.
Fields & Functions
Field / Function
Description
Branch
Select the store/branch to view or assign minimum stock.
Supplier
Automatically displays the supplier name based on the login account.
Query
Retrieves existing Minimum Stock data based on the selected branch.
New
Create a new Minimum Stock record.
Input Form
Download the official Excel template for Minimum Stock input.
Import
Upload the completed template to update PAR values in bulk.
Export to XLSX / Export
Export existing Minimum Stock data for review or editing.
💡 Tip:
Use Input Form + Import for large-scale updates (hundreds of items) to save time.
🔹 2. Creating a New Minimum Stock Entry
When clicking New, the system will open the New Minimum Stock page to specify the PAR values for selected products.
Input Fields
Field
Description
Supplier
Automatically filled by the system.
Branch
Select the store/branch to assign the PAR.
Product
Search and select products to be added to the PAR list.
Add
Adds the selected product to the table below.
Product Table Details
Column
Description
No
Item number.
PrCode
Product code.
PrName
Product name.
Suggested Minimum Stock
System-recommended PAR based on average sales.
Minimum Stock
PAR value that users can edit manually.
Unit
Product unit (e.g., piece, pack, kg).
✔ You may freely adjust Minimum Stock according to branch demand and sales volume.
🔹 3. Two Ways to Set PAR
Method 1 — Using Input Form (Recommended for many items)
Click Input Form → download the Excel template.
Enter Minimum Stock values into the provided fields.
Return to the system → click Import.
Select the Excel file.
Click Confirm Import Stock Par to finalize the upload.
⚠ Only files downloaded from Input Form are accepted
(Any structural changes in the file will cause import failure.)
Method 2 — Manual Entry (Suitable for few items)
Click New.
Select Branch.
(Optional) Search for a product and click Add.
Adjust “Minimum Stock” values in the table.
Click Save to complete.
💡 Tip:
If you need to update PAR for many products, always use the Input Form + Import method for faster processing.
🔹 4. Important Notes
✔ Validate Before Saving
Ensure the correct Branch is selected.
All required fields must be completed (especially if using Excel import).
Product codes must exist in the system.
✔ Excel Must Meet System Requirements
Your import will fail if:
Product codes do not match system data.
Numbers contain special characters.
Required fields are left blank.
The Excel template format is altered.
🔹 5. Steps to Set Minimum Stock (Quick Guide)
Go to Input Consign → Minimum Stock
Click New
Select Branch
Add or import products
Edit Minimum Stock values
Click Save
OR (Bulk Update)
Click Input Form
Edit Excel file
Click Import
Upload and confirm
🔹 6. Feature Summary
Function
Benefit
Query
View existing Minimum Stock values.
New
Create or manually update PAR per branch.
Input Form / Import
Fast bulk update via Excel.
Export
Save current PAR data for offline review or adjustments.
📘 Summary
The Minimum Stock (PAR) menu allows suppliers to define minimum stock thresholds for each store.
This ensures stable product availability, minimum OOS issues, and smooth replenishment operations.
The system supports both manual entry and Excel import, making it flexible for small or large product lists.
By maintaining accurate PAR data, suppliers and Villa Market can manage consignment inventory efficiently across all branches.
