How to import QOH in odoo 8

Question

I want to update my stock in odoo either with its odoo interface or using backend (postgres query).

I have the value of my stock in the csv file.

Finally, I want to update the quantity in my hand in bulk.

Answer 1

Finally, he decided, just follow the step

Step 1;

1 → select the product in the storage module (will open in the form of a list).

2 → select the product you want to update.

3 → click on the larger button and export the column

i-> product name and any other if you need.

you have a file called product.temlate.csv .

4 → Add a qty column and enter the quantity of the product.

Step - 2;

1 → select the inventory setting in the storage module.

2 → , if you already have any created inventory, then go to point 3, if then do not create inventory and feel the detail. and select all product options in Inventory of -:

3 → now click on the inventory setup again and select the inventory.

4 → click on and export the next column

Commodity / Location

Stock / Product

Invevtories / product Unit of Measure.

Now you have another file called stock.inventory.csv

Step -3 →

1 -> now add two columns to stock.inventory.csv

The first is the name , and the second is line_ids / product_qty .

and delete the id column.

2 → delete the value of the line_ids / product_id / id column of the stock.inventory.csv file.

now copy the id column values ​​from product.template.csv and paste into line_ids / product_id / id > stock.inventory.csv column .

3 → copy the qty column values ​​from product.template.csv and paste in the stock.inventory.csv column in line_ids / product_qty .

4 → enter any value in the name column for reference.

Step - 4 -

make sure your file looks like this: -

Click the following link to see the file.

This is an example of successfully imported data.

http://bit.ly/odoocsv

AFTER IMPORTING DO NOT FORGET TO START AN INVENTORY

Answer 2

You can fill the stock using physical inventory, it is available at

Warehouse -> inventory Control -> Inventory Adjustment 

You can import your csv into a single and fill out the physical inventory.

 stock.inventory stock.inventory.line 

These are the models that you should use to update your inventory (inventory loss in stock).

Answer 3

Another easy option for updating any odoo fields with frontend in bulk is to install the MassEdit add-on from: https://github.com/OCA/server-tools/tree/8.0/mass_editing

tested on odoo v8 and works great