Advanced inventory management and warehousing in the various versions of PrestaShop

By default, even when advanced inventory management is activated in PrestaShop, products remain in manual management. It is therefore necessary to activate advanced inventory management on a product-by-product basis:

If you use Merlin, fortunately you can do this in a single operation for all products or a group of products, simply display the column, select the products and click in one of the checkboxes:

The guy who programmed advanced inventory management in PrestaShop 1.5, then 1.6, must have thought that the more complicated it was, the more professional it would look. Still, in addition to having to activate the advanced stock management mode globally, then product by product, the calculation of available quantities is still done manually. To switch to automatic mode, which takes into account the stocks defined in the warehouses, a third option must also be ticked, and this for each product, one by one:

Still using Merlin if you have more than 30 products, to check this option en masse:

After activating all this, there are still two steps left before you can actually define the quantities in the warehouses. First of all, you need to create the warehouses themselves, obviously, but you also need to open each product sheet and then:

1. Go to the "Warehouses" tab of the product sheet.
2. Associate the product with each of the warehouses in which it is stored. In addition, if the product has variations, this must be done for each of them (fortunately, there's a button allowing you to do this en masse for all variations of the same product, one warehouse at a time.
3. Accessorily, you can also define a location for each line:

1. Select all products or just the product group to be associated with a warehouse.
2. Simply click one of the boxes in the "Stored in warehouse name" column.
3. You can define a common location for all selected products (or do it later, product by product or en masse with MagicEdit).
4. Cherry on the cake, you can in the same operation, also associate all declinations, and this in all stores if you're mulitboutique.

This is the number of copies of the same product or variation actually present in the warehouse. This is typically the result of a count after an inventory.

This is the number of copies available for orders, i.e. those not already sold or reserved for other uses (exhibitions,direct sales,...).

Quantity of products ordered from suppliers and not yet received. This is the restocking in progress.

Sum of usable quantities in all warehouses minus the sum of quantities ordered and not yet shipped to your customers.

Result of the sum of physical quantities in all warehouses, plus the sum of expected quantities, minus the sum of customer orders not yet shipped.

Operation that consists in decreasing or increasing stock, or moving stock from one warehouse to another. A sale generates a negative stock movement, a restocking and a return of goods generate a positive stock movement.

How to perform warehouse stock movement on multiple products at once with Merlin:

1. Select products.
2. Right-click in one of the three columns for physical, usable or expected quantity.
3. Click on the "Inventory movement in all selected lines" menu.
4. Fill in the form and click on the add, decrease or transfer button. For more details, see the video below or the dedicated tutorial.

Weighted Average Unit Cost (purchase price) of a product or declination in a WA-type (or CUMP-type) warehouse. When making product resortimens (supplier orders), the purchase price of the same product can vary. To find out the value of the stock, we need to take into account the quantities purchased and the purchase price for each restocking
This is what the CUMP allows us to do, which is, to simplify, the average of the different purchase prices, but taking into account the quantities purchased.

Only available in Merlin, for CUMP warehouses only. Indeed dasn this type of warehouse, all copies of the same item are considered to have the same value, the CUMP, even if in reality they have been purchased at a price that may vary.

In a CUMP warehouse, all copies of the same item are considered to have the same value, the CUMP, even if in reality they have been purchased at a price that may vary.

Available only in Merlin, for CUMP warehouses only.

In a FIFO (First In First Out) or LIFO (Last In First Out) warehouse, each item in the stock has as its value, its initial purchase price. When an item is sold, the overall value of the stock is decremented by the value of a product, either the oldest purchased (FIFO), or the most recently put into stock (LIFO).

FIFO and LIFO warehouses therefore offer more precise stock value management, but are far more complex, and Sitolog advises against choosing them. On this subject, note that Merlin does not manage stock decreases or stock transfers for this type of warehouse.

Pecuniary value of physical stock in all warehouses. The value of each item is calculated according to the calculation method defined for each warehouse type (FIFO, LIFO, CUM).
In manual inventory management mode, valuation is simply equal to the purchase price multiplied by the quantity available for sale.