5. Warehouses Management

You can create warehouses for every product container, relevant cases are :

  • A building
  • A shop
  • A supplier
  • A shelf in the warehouse that contains defective products
  • For products reserved (for instance for a show room, or for internal usage)

Warehouses Settings

The warehouses management screen is available from menu Embedded ERP > Warehouses.

From there, you get the possibility to create/delete/modify any warehouse.

Note

Be careful to never delete your default warehouse (the one with the ID 1), as it can cause serious problems inside ERP.

Here is a description of each tab available when you edit a warehouse selecting it from the warehouses grid.

General

  • Primary : Define a warehouse as “default target one” for all incoming stock movements made by third party extensions
  • Display on front : If enabled, this warehouse available quantity will be displayed on the website frontend, at product view level (feature should also be enabled from Stores > Configuration > BoostMyShop > Inventory Management > Frontend)
  • Open hours : Displayed on the website frontend
  • Address : Displayed on the website frontend

Products

This tab summarizes the stock levels for products in the warehouse (please read the concept entry in this documentation to understand the different stock levels).

Note

you can export this list to a csv file, using the “Export” button above the grid.

Orders to ship

This grid displays order items to be shipped from this warehouse. Once an order is shipped, order items are removed from this grid.

Import

This feature should be used to update stock levels of warehouse products.

Expected file format and file specifications are described in the Import tab.

As a reminder, here are important points :

  • File extension : CSV / TXT
  • Separator : Semi-colon (;)
  • Mandatory column : sku

Warning

Please use column names as described in the Import tab, using only lowercase letters.

As a reminder, usable column names in the import file are :

  • sku
  • qty
  • shelf_location
  • warning_stock_level
  • use_config_warning_stock_level
  • ideal_stock_level
  • use_config_ideal_stock_level

Note

Only SKU(s) already associated to the current warehouse are importable.

That means you cannot associate new products to this warehouse using this import, but only change stock level of already existing ones.

If you try to import a SKU not already associated to the warehouse, the import will not process this row but will still process other ones.

CSV file example

sku;qty;shelf_location;
24-MB01;1;A1
24-MB02;10;D4

Once your file is correctly formatted, simply select it with the Choisir un fichier button, then click on Save Warehouse.

This will process the import and display a message saying how many stock level have been correctly updated, and how many were not updated.

Note

If the file is not well formatted, it will display an error message to let you know what’s wrong with the current file.

Warehouses Routing

These screen is used to configure the system and decide how the warehouses are used.

There are 2 important roles for a warehouse :

  • Stocks in the warehouse are available for sales on the website, and are used to calculate the sellable quantity
  • Warehouse is used to dispatch order item

Both roles are configurable at the website level (store and store view levels are NOT available).

If you want to use a warehouse stock levels to sell on a website, you must enable the “Use for sales” option for the website / warehouse. Then, the quantity available for sales on the website will be the sum of the quantity available in the warehouses having “use for sales” enabled.

To select the warehouse to dispatch an order item, the configuration is a bit more complex: you must first enable the option” Use for shipments” for warehouses that can dispatch, and then configure the method and the priority :

  • Warehouse with stock, order by priority : in that case, the system browse the warehouses having the “Use for shipments” option enabled, sorted by priority (1 => 9999). Then, it will use the first warehouse that has enough available stock to dispatch the order item
  • Always priority one : in that case, order items are always assigned to the warehouse having the “Use for shipments” option enabled AND a priority of 1.

Here is an example of warehouses configuration. In that example, we do have 2 websites :

  • Main website is your online website.
  • Paris shop is a store, on the “Champs Elysees” in Paris
_images/warehouse_routing.jpg
  • For the main website, the quantity sellable is the SUM of quantity available in warehouse default, drop ship and paris shop
  • For the Paris shop website, the quantity sellable is ONLY the quantity available in the paris shop website

When an order is placed on the “Paris shop” website, it is only dispatched from the “Paris shop” warehouse (it is the only one that has the “Use for sales” option enabled, and it is priority 1

When an order is placed on the main website, the systems checks if there are stocks in the default warehouse, if so it associated the default warehouse to the order item. If there is no stock in the default warehouse, then it checks the drop ship warehouse. If there is no stock at all, then the warehouse with the priority 1 will be used (default in that case)

Note

an order placed on the main website will NEVER be dispatched from the paris shop, even if we use that warehouse to calculate the sellable quantity. If the product is only available in the paris shop, you will have to transfer the stock to the default warehouse to dispatch the order.