V. Advanced Stock Management
Using this application, allows sellers (managers) to distinguish their real reserves from available ones. This feature is compatible with the multi-store function and helps:
- manage inventory and supervise your real stocks - their numbers; values;
- manage inventory for delivery;
- keep the history of the inventory’s movement (Stock Movement);
- manage the simplified version of warehouse etc.
You can have one or more warehouses at your store. To add warehouses to Store Manager, go to Stock section, choose 'Warehouses' option and press the appropriate button in the toolbar:
In the form below type basic information about warehouse: its name, reference, location, address details, currency (UAH, euro, dollar).
When the necessary data is successfully specified, be sure to click the 'OK' button.
Once the warehouse is created, you can fill it with the appropriate products.
Go to Product Page and choose products, which are available in stock. From the lower menu select ‘Warehouses’ field and assign these products to the necessary ones.
If the products have its own attributes, such as color, size etc, you can assign separately for each color and size value to the certain warehouse.
Press ‘Apply Changes’ button to save your actions.
Section ‘Stock Management’ makes possible to set required number of units in stocks. In order to perform this, find necessary one from the product list and double clicking on it,
open “Edit Stock Management” form.
Specify quantity, which will be added to the selected product in stock; choose warehouses, where this quantity will be available, type a price for a
new product’s batch and select label by which these changes are identified:
- as demand growth (increase),
- for adjusting of inventories (regulation following an inventory of stock);
- as they (stocks) become available (supply order).
If the number of products in stock is more than zero, you can use the arrows in the top menu, - to add a number of products in stock,
- to reduce the existing number of goods in stock.
If you have to subtract the amount of a particular product, select the appropriate arrow in the menu. Clicking reduction mode, you will get such window:
Enter the value of quantity reduction for this product; select warehouse, in which the number of product is decreased; choose label of the proposed three options:
- as decreasing demand;
- for regulating warehouse stocks (regulation following an inventory of stock);
- as customer order.
Press ‘OK’ button.
'Transfer ' option calls the form, by filling which you can send certain units of products from one warehouse to another one :
Hit the triangle buttons opposite each active field to select the necessary details from the drop-down list, specify the units number you want to be transferred, check the appropriate checkboxes to set product available for sale for outgoing and incoming warehouses.
Do not forget to indicate the source and destination warehouses before pressing 'OK' button.
Take into account the 'Usable for Sale' field - it means the specified amount of item will be available for ordering and will influence on the total number of product at the store.
If you leave this box unchecked - current units can not be used for purchasing and do not affect the general product's quantity (will be perceived as a reserve ).
Movement of goods in warehouses - increasing or decreasing quantity, date of changes, a price for each delivered units (or dropped out units) and so on - all is reflected in ‘Stock Movement’ section.
If the recent changes are not reflected in this section - click ‘refresh’ button to update the ‘Stock Movement’ table.
The filter allows view the movement of product stock at one particular warehouse or at all warehouses at once. To filter out goods you just need to select the appropriate filter parameter from the drop-down.
To assign products to the appropriate warehouse move to the lower menu in Products page where you can find the necessary position.
On the right pane in the 'Assign' column check the warehouse you want the product to be associated with and do not forget to press 'Apply Changes' button to save your assignment.
To link the quantity of product with the stock in warehouses to which it has been assigned choose the Quantities tab from the lower menu and check the field below:
Thereby, the base number of the product will be directly depending on its quantity in the certain stocks (warehouses) .
If you make the product(s) belongs to the appropriate warehouse its quantity will be automatically related to the Store Management and became 'Out of Stock'.
For example, the product 'Printed Dress' in the test store has the 17 units available at the current time.
Once the changes are done in the Quantity tab in the lower grid - named, assign item position to the corresponding warehouse- save them by pressing the option in the toolbar.
As we can see, the quantity of the current product has been automatically updated to zero.
This doesn't mean the product is not available and to make it in stock again necessary to prescribe the quantity within the warehouse(s) which the item belongs to.
Please note, the physical availability of the product cannot be added to the warehouse stock of such item and will be skipped, only the number of products in the warehouse is taken into account.
The second one condition which can be checked allows to take into account the physical quantity of product specified manually .
For example, let's take the product named 'Vintage Wedding Dress' with the advanced stock management enabled and the first variant checked (see an illustration above) .
In the stock management section specify the quantity you want to add to each warehouse. We have two warehouses created - Warehouse-top and Reservation.
Use the 'increase' option to indicate the number of units in the selected stock and press 'OK' button to update:
Perform the same for the second warehouse - specify the quantity which will be available to purchase :
Now you get the following results on both warehouses positions:
Once, the current product is selected during ordering in POS section of Store Manager, choose the appropriate variant according to the warehouse availability:
The quantity of product will be taken from the usable amount, available in the warehouse, which has been chosen.
Please note, the quantity of product after ordering in the Advanced Stock Management will be changed only if the order status is Delivered or Shipped .
If you want to export warehouse quantity of products among the other data to a file choose the appropriate fields and drop it from the let to the right on the fields selection step of export:
You can use the appropriate Group of the Fields which is available in the upper option to facilitate the process:
The fields will be automatically transferred to the right side:
Take a note:
'Warehouse Location' field is available, starting from the last program's update (ver. 2.44.0.:1971) among the other fields related to the Warehouse information and can be linked on the Assignment step of the export process.
Link the fields in your database with the corresponding columns from a file which relate to the warehouses on the Assignment step of import :
There is the one more important field relates to update warehouse quantity during importing - on the Import Options step - 'Increment existing warehouse stock by quantity specified in the import file' - that means if the number of products does not directly depend on the actual (physical) number at the store (field not checked) -
Then you can make the increasing availability of the product in storage at the amount specified in the file.
If you have any questions or need any assistance to perform such operation properly - contact us and we will gladly assist you.
Check the following guides on Advanced Stock Management functionality to better understand how it works :