Child pages
  • Advanced Stock Management

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Version 1.5 of PrestaShop features a new stock management menu: more than just merely listing how much of a specific product you have currently available, this menu enables you to list warehouses and get a proper view of your stock, its movement, your coverage, your stock orders, etc.

Not all merchants will have a need for this feature. It is therefore optional, and the available quantity management tool from 1.4 is still available, and has been rethought.

You can enable the advanced management menu by going to the "Products" preferences page, at the bottom of which is the "Products stock" section. Select "Yes" for the "Enable advanced stock management
Yes" option.

General concepts

In order to avoid confusion with the stock management feature from version 1.4 and see the possibilities offered by the advanced management feature of v1.5, you should picture two distinct concepts: product quantity available for sale, and physical products.

...

There is no obligation to use the new stock management feature, just as there is no obligation to use the "quantity available for sale" management feature.

To activate both the both "quantity available for sale" management feature and the stock management feature, go to the "Products" preference page, scroll down to the "Products stock" section, and choose "Yes" for the two stock management options. You have to first enable basic stock management in order to enable advanced stock management.

...

If you would rather not use the new advanced stock management feature from PrestaShop 1.5, and simply are satisfied with the way PrestaShop 1.4 handles product quantity management, you just have to activate enable the old-style stock management manager, and not the advanced stock management feature: go to the "Products" preference page, scroll down to the "Products stock" section, and choose "Yes" for the "Enable stock management" option, leaving the "Enable advanced stock management" option set to "No".

...

Once you start creating a new warehouse, you must at least fill in the following fields:

...

Once the warehouse has been created, you are taken back to the list of warehouses. Click the "View" icon on the right of its row to access a bird's eye view of its information, including the references of all the products stored in it, the sum of all the available quantities, a global accounting valuation, details of the stored products, and the history of the stock movements for that warehouse.

It Each warehouse page also contains two links at the bottom:

  • Click here if you want details on products in this warehouse. Takes you to the warehouse's "Instant Stock Status" page.
  • Click here if you want details on what happened in this warehouse. Takes you to the warehouse's "Stock Movement" page.

...

To add more stock to a product, use the "Add stock" action (up arrow) for said product or product combination. A new page opens, containing a form where the most important information is displayed in order to help you identify a product with certainty (reference, EAN13 and UPC code, and name). This information cannot be changed from this form, therefore it is grayed out.

...

When you want to remove a certain quantity of product stock, you must use the "Remove stock" action (down arrow, available only when there already are products in stock). A new page opens, containing a form where the most important information is displayed in order to help you identify a product with certainty (reference, EAN13 and UPC code, and name). This information cannot be changed from this form, therefore it is grayed out.

...

The stock transfer enables you to transfer stock from one warehouse to another, or from one status to another (usable in store / reserved) within a single warehouse. Click on the "Transfer stock" action (sideways arrows, available only when there already are products in stock). A new page opens, containing a form where the most important information is displayed in order to help you identify a product with certainty (reference, EAN13 and UPC code, and name). This information cannot be changed from this form, therefore it is grayed out.

...

  • Quantity to transfer. This must be a positive number.
  • Source Warehouse. The warehouse from which you want to transfer some products, or where you want to change the status of some of the stock.
  • Usable for sale in source warehouse?. Whether the quantity to remove from the "source" warehouse should be from the "usable for sale" stock or the "reserved" stock.
  • Destination Warehouse. The warehouse from to which you want to transfer some products. If you simply want to change the status of some of the stock from your source warehouse, make sure to select the same warehouse in this form.
  • Usable for sale in destination warehouse?. Whether the quantity to add to the "destination" warehouse is usable for sale or reserved. This is also the option to use when you simply want to change the status of some of the stock in the source warehouse:
    • If you do not want to change status while moving warehouses: make sure both "Use for sale?" option are set alivealike.
    • If you do want to change status, whether within the same warehouse or while moving warehouses: make sure both "Use for sale?" option are set differently.

...

  • Set the unique reference number. This is an administrative number; do not put any seemingly unique number.
  • Select the supplier. If the supplier you want is not in the drop-down list, you must create it in the "Suppliers" page, under the "Catalog" menu.
  • Select the warehouse which will take delivery of the order. You must have created at least one warehouse.
  • Select the currency in which the order will be formalized. If needed, you can create or import a currency using, respectively, the "Currencies" or "Localization" page under the "Localization" menu.
  • Select the language in which the order will be formalized. If needed, you can create or import a currency language using, respectively, the "Languages" or "Localization" page under the "Localization" menu.
  • If needed, set the global discount on the order (in percentage). You can just leave it at "0" if you do not have a discount on this order.
  • If needed, set the physical quantity of a product below which all the products have to be restocked, and are therefore to be added to the order automatically. Each pre-added product will be ordered with a quantity equal to the entered quantity, minus the already available quantity.
  • Set the planned delivery date.

...

Once your order reaches the "Pending receipt" status, a new action is available. Using a the "truck" icon, the "Update ongoing receipt of products" action enables you to register the reception of products for a given order.

The form that opens after clicking that action enables you to see how many items were expected, and to indicate the quantity of product delivered for each product. Click the "Update select" button to mark the selected products as received with the number of items you indicated in the "Quantity received today?" field. The checkbox on the left of the each row must be checked for PrestaShop to take that line into account.
This step can be done as many times as necessary, and it is possible to receive and incorporate more stock than planned.
If you receive less stock than expected, the order's status changes automatically to "Order received in part".

...

Tip

AVCO = (QS * previous AVCO + QA * UP ) / QS + QA)
Unless QS is negative or null, in which case AVCO = UP.

...

At the Y date, we calculated the AVCO according to the number of products added in the stock their unit prices. Therefore, all products in stock now have a reassigned unit value, according to which depends on the new AVCO.

Beyond these three calculation methods, it would be great to provide an open system, enabling the addition of other, more country-specific valuation methods, through modules for instance.