Import of Stock

October 23, 2023


The import of stock quantities is ideal to use when you need to take into account many products at once. 
In order to import Erply system stock quantities, you must first arrange the data for the system and save the table in a CSV or XLSX file. In the import module it is possible to add / update / supplement both standard products and matrix products. In the case of imports of stocks, the quantities of products shall be added to those already in force.

To import stock quantities, go to PIM → Import Products.
Click Update Products.
Upload the correct file from your computer, activate the File has headers button, if your does, and click Create.
In the Type line it is possible to choose whether these are standard or matrix products.
Under Configuration you can select the product code or ID, according to which updates will be made. Don't forget to select the correct warehouse to import stock quantities to.

The next step is mapping. There are three mandatory fields that must be filled in order to import stock quantities: Product code/UPC/EAN code; Inventory Registration Quantity; Inventory Registration Price. Everything else is optional. 
Be sure to link the columns you want to add to the data. If the system does not bind automatically, the box is Not Mapped. In that case, you need to click on the box and select the correct ID. 
Example: The attribute of the “CODE” line is “Product Code”. Inventory registration quantity corresponds to Product inventory registration quantity, etc.
If you do not mark the Product inventory registration Price column then the stock levels will be taken with a 0 price.

If the required information is selected, click Apply and validate configuration.
After validating, the Confirm and start import button will turn green and you can confirm your import.

With confirmation, a inventory registration is automatically created, which can be seen in Inventory → Inventory Registration.
At the opening of the inventory registration , it can be seen that 10 products with the code “3” have now been registered and the import of stock quantities was successful.