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)
The warehouses management screen is available from menu
Embedded ERP > Inventory Management > Warehouses.
From there, you get the possibility to create, delete or modify any warehouse.
Be careful to never delete your default warehouse (the one with the ID 1), as it will cause serious problems inside ERP.
If you click on any warehouse row in the grid, or click on the
Add new warehouse button located at the top-right corner of the grid, the warehouse edition screen will be displayed.
Here is a description of each tab available from this edition screen.
|Name||Name of your carehouse, displayed in ERP grids and screens.|
|Contact||Contact name in the warehouse.|
|Email address to contact.|
|Status||Enabled / Disbaled. If the warehouse is disabled, it is hidden from ERP screens and grids.|
|Fulfillment method||Defines the warehouse type. More informations below.|
|Primary||Define a warehouse as “default target one” for all incoming stock movements made by third party extensions.|
|Display on front||If enabled, the warehouse available quantity will be displayed on the website frontend, at product view level (global setting must also be enabled from
|Use for supply needs||Consider this warehouse for the Supply Needs calculation.|
|Notes||Extra notes about this warehouse.|
|Open hours||Warehouse working hours.|
|Address fields||These fields will be used to display warehosue address on front end if Display on front option is enabled.|
The fulfillment method will define in which screen the ordered products associated to the warehouse will be displayed and managed.
- Warehouses with Shipping fulfillment method will be managable through ERP Order preparation screen.
- Warehouses with Drophip fulfillment method will be managable through Drop Shipping orders screen, if DropShip extension is installed.
You have to keep at least one warehouse with a “Shipping” fulfillment method to be able to process orders through ERP order preparation screen.
|Skus in stock||Count of products currently affected to this warehouse, being in stock.|
|Total products||Sum of all products physical qty affected to this warehouse. For example, if product A has 5 on hand qty, and product B has 3 on hand qty, this field will display 8.|
|Total value||Total cost of all products currently affected to this warehouse (for each product :
In the case where the full ERP package is installed and a product is associated to multiple suppliers, the cost used to calculate “Total value” field is the one from the supplier with setting “Primary” set to “Yes”.
The Total products value is the sum of physical quantity of each product in the warehouse.
For example if your warehouse contains 2 products, product A with 5 physical qty and product B with 3 physical qty, the Total products value will be equal to 5 + 3 = 8.
This tab summarizes stock levels of all products associated to the warehouse.
In order to understand how are working stock levels, please take a look at the Concepts section.
You can export this grid into a CSV file, using the
Export button available above the grid.
Orders to ship¶
This grid displays order items to be shipped from this warehouse.
Once an order is shipped, order items will be removed from this grid.
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
When importing csv file make sure that the encoding type is in UTF-8.
Only SKU(s) already associated to the current warehouse are importable.
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 (mandatory or use barcode instead)
- barcode (mandatory or use sku instead)
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
This will process the import and display a message saying how many stock level have been correctly updated, and how many were not updated.
If the file is not well formatted, it will display an error message to let you know what’s wrong with the current file.
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
- 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)
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.