Part 2: Stock (Inventory) Item Fields Explained

General Tab

Barcode

Barcode - MPLU (Multiple Price Look-Up)

Access:

•To add or edit barcodes, click the three-dot icon ( ) adjacent to the standard barcode field.

Benefits:

•Link multiple barcodes to a single primary inventory SKU.

•Enabling complex regional pricing matrix tiers or multi-pack options without inflating item codes.

View MPLU List:

•Go to: Stock Items > Item Lookup → Click MPLU Lookup button (Menu Bar)

See also: Adding Different Units

Item Name

Item Name: Maximum 255 characters.

The 'Item Name' corresponds to the Prestashop Name.

Column Copy: To mass-copy data layouts column-by-column between Item Names, Short Descriptions, and Long Descriptions, navigate to Stock Extended Lookup > Change Selected 2 tab

Short Description

Short Description: Extended descriptive boundary capped at a 500-character maximum, mirroring your online e-commerce brief outline.

Corresponds to the Prestashop Short description.

Status

Status (Web Behaviour)

Controls what customers see when ordering online.

Add stock statuses in the Stock Items > Stock Main Form > Status field.

Example of Statusses:

The Back Order Status will be used when you do not have stock and the Has Stock Checkbox is not checked and Allow Orders are selected on the Web Tag

On the Web tab you can tell Si how to handle Out of Stock Order Options

•Deny Orders

•Allow Orders

•Default in Prestashop Product Preferences.

The status field appears in the Stock Detail and Item Lookup forms.

Supplier

Supplier Has Stock

Supplier Has Stock

If you do not have stock, but the 'Has CheckBox' is checked, and Allow Orders is checked (Web tab) then the description of the Supplier Has Stock (Status) will be used in the web shop.

Bulk change it in the Extended Item Lookup form.

The supplier's inventory value can be retrieved either from their Web Service or via Excel, provided the supplier shares this data.

The supplier's stock on hand quantity will appear in the Main Stock Form, To access it, click the Other Suppliers button.

Ordering Info

Reorder Level

Reorder Level Configurations

Triggers reordering when stock reaches a defined level. Set in Stock Main Form.

It can be populated using three methods:

•1. Dynamic Sales Averaging: Set the Reorder Llevel to the Average Sales Values in the Purchase Planning form.

•Use the With Selected tool (bottom of the form) using the From / To fields.

•2. Bulk Adjustment: Bulk change the reorder level in the Extended Item Lookup form.

•3. Profile Defaults: Set baseline properties for new entries via Stock > Stock Options > New Item Defaults.

Additional Order Quantity

Extra quantity to order when reorder level is reached.

•Used in Purchase Planning Form.

•Bulk change in Extended Lookup form.

Minimum Order Quantity (MOQ)

Minimum supplier order requirement.

Don’t confuse this with buying units or the units in a pack. For example, if you buy 1 box of pens containing 50 pens and you sell per pen, then your minimum quantity is one box. If in doubt, leave the minimum quantity as one!

Reliability %

Indicates how accurate the system’s suggested order quantity is.

Suggested Order Quantity

Suggested Order Quantity

Calculated using:

•Min/Max levels

•Lead time

•Sales trends

Refer to Reliability % for accuracy.

Minimum Stock Level

Maximum Stock Level

Minimum Stock Level

The safety stock cushion required to cover supplier logistics delays before risking a complete out-of-stock event.

Suggested Minimum = (Predicted Next Month Sales / 30.5) x Supplier Lead Time (Days)

•Manually adjustable unless Use Suggested Min/Max is enabled in Stock Options.

Maximum Stock Level: The holding threshold calculated via statistical regression analysis to prevent warehouse overstocking.

Manually adjustable unless Use Suggested Min/Max is enabled in Stock Options.

Notes

These values are displayed in the Purchase planning form as Min Level / Suggested Min Level and Max Level / Suggested Max Level, as well as in the Inventory Statistics form. Bulk change the minimum / maximum levels in the Inventory Statistics form

You can change the above values manually in the Stock Main Form. To do this, go to Stock Options and deselect Use Suggested Min/Max Levels.

Growth %

Item Growth

Forecast of monthly sales increase/decrease.

Example:

•Growth = 8 → sales expected to increase by 8 units/month

This metric is used in Purchase Planning to optimize inventory management and ensure adequate stock levels.

Avg. Sales Qty.

Average Sales Quantity: Recalculated dynamically after every inventory movement transaction. The historical assessment timeframe window (e.g., 3-month rolling vs. 6-month) is declared inside your localized Stock Items > Stock Group panel.

Shown in Stock Main, Purchase Planning, and Stock Extended Item Lookup.

Stock On Hand (SOH).

Sometimes referred to as In-Stock.

Stock on Hand (SOH):Total items in the store. Not all may be available for sale due to reservations for job cards and sales orders.

The Available Quantity refers to the number of items that can be sold immediately.

On Order

Stock ordered but not yet received.

Reserved

Reserved Quantities - Summary

Reserved Quantities

Stock committed to:

•Sales Orders

•Job Cards

•Production

• BOM components

•Warehouse Transfers (depending on your settings)

Formula:

Reserved = Sales Order Allocated + Jobcards (if enabled) + Production Run + BOM Components (if enabled) + Warehouse Transfers (if enabled)

These values represent the global reserved quantity for an item.

How Items Become Reserved

1. Sales Orders

•Only allocated quantities on Sales Orders are counted as reserved.

2. Jobcards

•Jobcards (only if Jobcard Reserve Stock is enabled)

•Path: Workshop Options > Jobcard Reserve Stock

3. Manufacturing (BOM Components)

To reserve BOM components:

1. Go to Stock Items > Stock Options >Manufacturing tab

2. Enable Reserve BoM Components

When enabled:

•Adding a BOM item to a Sales Order reserves the component items if there are not enough manufactured items available.

•These reserved components will appear under Manufacture in the reserved breakdown (see image below).

4. Production Runs

•Production Run items will reserve individual components if Reserve BoM Components is enabled.

•Components from the Production Run display under the reserved breakdown.

5. Warehouse Transfers

Warehouse Transfer reservation is optional:

•If Stock Options > Warehouse Transfer > Reserve Stock is enabled:

•Saving a transfer will reserve the stock until it reaches the receiving warehouse.

Automatic Allocations

If you want the system to automatically allocate stock on Sales Orders:

1. Go to Stock Options > Allocation Tab

2. Enable Easy (Stock is not reserved)

Notes:

•Reserved quantities only display when Advanced allocation options are enabled.

•Easy mode does NOT reserve stock.

To view the breakdown:

•Click the question mark (?) to the right of the reserved field.

   This shows the exact source of all reserved quantities (Sales Orders, Jobcards, BOM, Production, Transfers). See image below

Uncommitted

Uncommitted Quantities = In Stock - Sales Orders - Job Cards

Shown in Extended Item Lookup & Purchase planning Form

Confirmed Demand

Confirmed Demand = Total item quantities on Sales Orders and Job Cards.

This is the quantity you need to fulfill all sales orders and job card requirements.

Available Quantity

Available Quantity = Stock On Hand - Reserved

Stock Shortfall

Shortfall = Confirmed Demand - (In Stock + On Order)

A positive quantity means that you can't fulfill your current orders.

Inventory Quantity to Order

Use either of these two, depending on your trust in the figures.

Sugested Order Qty: Levels SQty.NoR

(using your own values)

Method A: If: In-Stock - Sales Orders - Reorder Level ≤ 0,

Then: SQty.NoR = Reorder Level - In Stock - On Order + Confirmed Demand

Otherwise: SQty.NoR = Reorder Level - In Stock + Additional Order Quantity - On Order + Confirmed Demand

Suggested Order Qty:Regression SQty.R

(as predicted by SI+)

Method B: Predictive Regression Model (SQty.R)

Leverages built-in analytics to project purchasing volumes based on future sales forecasts.

Formula: SQty.R = Next Sales + Confirmed Demand - On Hand - On Order

User Query Fragment

Action Response Guidance

Why can't I edit the supplier price field?"

Check Security Controls: Edit Restricted Mode

"My stock is showing on hand but I can't sell it, why?"

Explain SOH (In-Stock) vs available counts