Skip to Content

How to Import Stock in Odoo?

To import stock, you must first enable the “Track Inventory” feature when creating the product.

This feature allows Odoo to track stock movements.

Important: Make sure to activate this feature before any transactions are made for the product, because after a product has transactions, you cannot enable it anymore.

Steps to import stock:
  1. Go to Inventory > Products > Products
  2. Select the products you want to add stock for
  3. Export them

After exporting, add the stock quantity next to each product.

Importing the file back into Odoo:
  1. Go to Inventory > Operations > Physical Inventory 
  2. Click on the Gear Icon 
  3. Select Import Records
  4. Upload the file
  5. Select your Excel sheet
  6. Odoo will automatically match the fields – but make sure the column names in Excel match Odoo fields.
  7. Click Test to check if everything is OK
  8. Click Import


After the import is completed, click on Apply All to apply the changes.

       




Rating
0 0

There are no comments for now.

to be the first to leave a comment.