Stock (Inventory) Item Fields Explained

General Tab

Status

Reflects stock availability in PrestaShop (e.g., Supplier No Stock, End of Life, In Store, etc.).

Barcode

Supports multiple barcodes per item (max 25 characters). Click the three-dot icon ( ) to add barcodes.

For a consolidated list of MPLU barcodes go to Stock Items > item Lookup and click on the MPLU Lookup button on the Menu Bar.

See also: Adding Different Units on how to add different units.

Item Name

Maximum 255 characters.

The 'Item Name' corresponds to the Prestashop Name.

Supports column copy between the item name, short description and long description. Go to: Stock Extended Lookup >Change Selected 2 tab.

Short Description

Maximum 500 characters.

Short Description corresponds to the Prestashop Short description.

Supplier

Supplier Has Stock

Supplier Has Stock

If you do not have stock, but the 'Has CheckBox' is checked, then the description of the Supplier Has Stock 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

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

Options for managing the reorder level:

1. Average Sales Values: Set the reorder level to the average sales values in the Purchase Planning form.

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

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

3. Default Value for New Items: Set a default value for new items in the Stock > Stock Options > New Item Defaults form.

Additional Order Quantity

Quantity to order when reorder level is reached.

This figure will be shown in the Purchase Planning Form. It is configured in the Stock Main Form > General Tab.

You can bulk change the quantity in the Extended Lookup form.

Minimum Order Quantity (MOQ)

Minimum quantity as specified by the distributor. 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 %

Accuracy of the suggested re-order quantity is.

Suggested Order Quantity

Predicted order quantity based on max/min levels, lead time, and days until month-end.

See the reliability % (row above) for the accuracy of the prediction.

Minimum Stock Level

Maximum Stock Level

Minimum Level: You will run out of stock if your stock goes below this level.

Calculated as predicted next month’s sales ÷ 30.5 × supplier lead time.

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

Maximum Level: Predicted max sales per month via regression analysis. Manually adjustable unless Use Suggested Min/Max is enabled.

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:

Item Growth forecasts the average monthly increase or decrease in sales for each item. For example, a growth value of 8 indicates that the item's sales are expected to increase by 8 units per month.

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

Avg. Sales Qty.

Average Sales Quantity:

Recalculated per stock movement. Set months for calculation in Stock Items > Stock Group. Available 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

Items ordered but not yet received.

Reserved

Reserved item quantities are the allocated quantities on Sales Orders (only quantities allocated) and Jobcards.

•Automatic Allocations: If you need allocations to be done automatically, you can set this in the Stock Options > Allocation Tab. Check the Easy (Stock is not reserved) checkbox. Reserved quantities will only show if the advanced options are selected.

•Job Cards: If you don't want the program to reserve items from job cards, uncheck the Jobcard Reserve Stock checkbox on the Workshop Options form.

To reserve items for a customer, you can add them to a Sales Order or a Job Card.

Uncommitted

Uncommitted Quantities = In Stock - Sales Orders - Job Cards

Displayed 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

Quantity available to sell.

Is the Stock On Hand - Reserved

Stock Shortfall

Is 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)

If the In-Stock - Sales Orders - Reorder Level is less than or equal to 0, then the quantity will be calculated as follows:

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

Otherwise, the calculation will be as follows:

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

Suggested Order Qty:Regression

SQty.R

(as predicted by SI+)

Quantity to order using linear regression techniques.

Suggestion Regression (SQty.R) = Next Sales + Confirmed Demand - On Hand - On Order