How to Import Odoo Inventory?

Odoo

5 MIN READ

May 20, 2021

Inventory can be defined as the products/stocks owned by a business meant for resale. Inventory management involves a systematic approach to the acquisition, storage, and subsequent sale of inventories that can be both raw material or finished goods. The key idea behind inventory management is to keep the right amount of stock in the right quantity, at the right location, at the right time, and for the right price. Furthermore, inventory management aids in the integration of the whole enterprise as well as provides automation for regular manual activities. Updating the quantity of items in inventory requires a lot of time and effort. However, with Odoo advanced stock inventory import, it takes only a few steps. You can import Odoo inventory of different products using a single CSV/XLS file.

When you use the inventory module for Odoo, you can simply put basic headers in the file with relevant details under the headers. The system automatically updates the inventory of the listed products as soon as the file gets validated in Odoo. The sum total of the in-hand old quantity along with the product quantity specified in the file is the new quantity of a modified product.

Remarkable Point:

One should utilize the same header title for the CSV/XLS file as mentioned below in order to export the corresponding fields.

To import location of warehouse:

For Location ID, use location_id
For Location External ID, use location_external_id
For Location Name, use location_name

To import products:

For Product ID, use product_id
For Product Barcode, use product_barcode
For Product Internal Reference, use product_code
For Product External ID, use product_external_id

To import lot numbers

For Lot/Serial Number External ID, utilize lot_external_id
For Lot/Serial Number ID, utilize lot_id
For Lot/Serial Number Name, utilize lot_name

Key features:

The module assists in updating the product stock utilizing a CSV/XLS file.
The Odoo admin simply requires importing the new product quantities with a relevant CSV/XLS file.
The Odoo user requires to insert the header titles below within the file. The information gets added to the Odoo when the file is uploaded in Odoo.
Each product quantity mentioned in the CSV/XLS file gets added to the current on-hand quantity for that product in Odoo. As a result, the new stock is equal to the sum total of the two values.

Product Data Import:

Here is how the product master is imported to the Odoo ERP:

Make an XLS/CSV sheet with the product data or you can simply export it from any existing system.
Navigate to the PRODUCT tree view in the Odoo ERP
Click on the Import button & validate whether or not the import file is valid by clicking on “Import”
Click on the Import Button again if everything is valid and the product data will be imported successfully!

Product Qty On Hand / Stock Quantity Import:
If you have a specified stock quantity, you have to follow the procedure mentioned below:

First, you should prepare an XLS/CSV sheet that includes the product, location ids, quantities, etc.
After that, navigate to the inventory adjustments tree view, present in the Odoo ERP.Inventory Menu > Operations >Inventory Adjustments
Click on the Import button & validate the import file by clicking on the “Import”
After validation, click on the Import Button again and the inventory adjustments data will be imported successfully.

Note: It will be produced within the draft stage. You need to click on the “Start Inventory” button. You should validate it after thorough cross-checking.

Wrapping Up:

Odoo provides a highly adaptable, efficient, and freely accessible odoo inventory app for inventory management processes. As a result, Odoo Inventory Management software facilitates a multi-tasking environment that not only handles inventory but also maintains manufacturing department functionalities. To learn more about it and other Odoo Inventory features, feel free to contact our experts.