What are Item Parameters?

The Item Parameters page in OrderGrid allows users to view and modify item-related parameters used in calculating recommendations for purchase orders (POs). These parameters ensure that POs are aligned with warehouse and client-specific needs.

To access the Item Parameters page, navigate to

☰ > Replenishment > Item Parameters

Navigating the Item Parameters Page

View and Adjust the Items Parameter Table

The Item Parameters table displays item-specific parameters and details for each Item. You can adjust what columns are displayed by clicking the (column adjustment) button on the top right corner Item Parameters screen and selecting or deselecting the needed item parameters.

You can also use the search bar or filters to find items by SKU, name, or category.

How Item Parameters are created?

Item parameters are automatically populated when forecast files or strategies modules are activated.
Users can also upload any item into the Item Parameters grid regardless of its inclusion in forecast files or strategies.

Item Parameters and Their Purpose

This table covers all item parameters with descriptions to help you understand their purpose in managing inventory and purchase order recommendations.

Parameter	Purpose/Definition
Item Name/Sku Number	The item name and the unique identifier assigned by the vendor for the product.
Category	Product category within the inventory (e.g., bakery, beverages).
Order Category	A category used for processing orders, separate from inventory categorization.
Supplier Code	Unique identifier for the supplier, often used during integration with Partner Portal. In integrations with Partner Portal, this parameter is retrieved from the supplier’s catalogue reference during actualization.
Location (Warehouse)	Identifier for the storage location where the item is stored. This is the warehouse ID. Example, 101.
Cut-off Time	Deadline (in UTC) for same-day order processing. Orders placed after this time are scheduled for the next day.
Lead Time	Number of days required between placing an order and receiving the items. *Example:* Lead Time 3 days. If an order is placed on Monday, the expected delivery date would be Thursday. In integrations with Partner Portal, this parameter is retrieved from the supplier’s catalogue reference during actualization.
Stop Ship	Minimum number of days before product expiry to ensure it’s not shipped if too close to expiration.
Days Forward	Number of additional days included in the purchase order quantity calculation beyond the standard lead time. *Example:* If Days Forward = 2 and Lead Time = 3, the system calculates for 5 days’ demand.
Order Window	Coverage duration (in days) for a single order cycle. ⚠️ Note: When Order Window is enabled, the Day forward option will be hidden, and only the Order Window will be displayed.
Min Level	Minimum desired inventory level for the item. When the inventory falls below this level, the system generates a replenishment recommendation.
Order Days	Days of the week when suppliers accept orders. Must be entered as comma-separated integers (e.g., 1 for Monday, 7 for Sunday). *Example:* Order Days 1,2,3,4,5.
Delivery Days	Days of the week when suppliers deliver orders. Must be entered as comma-separated integers. *Example:* If Delivery Days are 2,5 (Tuesday and Friday), and today is Monday, the next delivery day would be Tuesday.
Case Size	Default quantity for purchase orders(base UOM).
Maximum Physical Space Adjustment	Limits the number of items stored in the warehouse based on available capacity. *Example:* If Max Physical Space = 15 and the current stock is 10, the system recommends a maximum of 5 items.
Target Level	Desired inventory level, calculated as: Demand + Safety Stock + Min Level. If the Maximum Physical Space is less than this calculation, the system uses the Maximum Physical Space as the target level.
Target Source	Source for replenishment (e.g., Store, Warehouse, or Both).
Strategy	Indicates whether the items are assigned to a Min-Max or Demand-Driven Replenishment strategy.
Prep Time	Moves the demand date forward or backward by the number of days you enter. • Positive value → brings demand forward, allowing you to receive stock earlier. • Negative value → pushes demand back, allowing you* to receive stock later — helpful for late-night deliveries that actually cover the following day.*

Set Item Parameters

Item parameters can be set in two places:

Parameter Location	Purpose	Impact on Replenishment
Inventory > Items	Used for general stock tracking and inventory organization.	These parameters are not actively used for replenishment calculations unless synced. To make sure this works as intended, Verify that the Item's supplier(partner) has the “Integrated” toggle enabled. Navigate to Parters > Partner List > Partner > check if the toggle is ON.
Replenishment > Item Parameters	Critical for replenishment strategies and PO recommendations.	The Replenishment engine actively considers these parameters when calculating stock levels and ordering needs.

Using the Item Parameters Page

Edit Item Parameters

You can update item parameters in three ways, depending on how many changes you need to make.

Edit a Single Item:
1. Locate the desired item in the grid.
2. Click the three dots at the end of the row.
3. Update the fields in the popup form and save changes.
Bulk Update:
If you need to update multiple item parameters at once, you have three options:
1. Change Multiple Items
  1. Select the checkboxes for the items you want to modify.
  2. Click the Change Multiple Items button.
  3. Update the parameters in the popup form and click Save.
2. Change All Items:
  1. Click the Change All Items button to modify the parameters for all items in the grid.
  2. Use the popup form to update fields such as lead time, cutoff time, and more.
  3. Click Save to apply changes.
3. Update via CSV file upload:
  1. Export Item Parameters:
    Click the Export button to download item parameters.
    Open the file in a spreadsheet tool and make the necessary changes.
  2. Import Updated Item Parameters:
    Click the Import button and upload the updated XLSX file.
    Ensure your file format matches system requirements.
    Click Import to update the data.

Use this preformatted Item Parameter file, remove current data, and replace it with your own. Once completed, click the Import button and upload the file as a .csv. Ensure that all mandatory fields are populated, and the file format adheres to the template provided above.

⚠️ Important Notes:

File Validations:
- Ensure all mandatory fields are completed when importing parameter data.
- Improper formats will result in upload errors. If errors occur, check the file format and ensure mandatory fields are correctly filled.
Impact on Recommendations from Changes in the Item Parameters:
- Adjustments to item parameters directly influence replenishment recommendations.
- Example: Increasing Stop Ship days will reduce the recommended order quantity.

Clear All Item Parameters

Click Clear All Items to remove all data from the grid.
Confirm the action to delete all parameters and reset the page.

Template for Importing Item Parameters

SKU Number	Warehouse	Category	Cutoff Time	Lead Time	Stop Ship	Order Days	Delivery Days	Min Level	Case Size	Max Physical Space	Target Source
ZGF12	902	Food	16:00	3	1	Mo,We	Tu,Th	10	5	100

ItemParametersTemplate - Items.csv

Item Parameters