Odoo Help


Importing CSVs as Warehouse Physical Inventory Entries

Adam Whistler
on 7/16/13, 6:03 AM 3,020 views

Hi there,

I've been trying to migrate my company's stock databases, which are currently held in MS Excel, into OpenERP 7. I have exported the data as a CSV from Excel, imported the file to OpenERP, and assigned fields to each column label. OpenERP validates the the CSV and imports it fine.

The problem is, it then creates a new inventory for each product (all with the same inventory reference), rather than creating one inventory containing all products in the CSV. Consequently I have several hundred physical inventory entries at the end of the process, and furthermore as OpenERP is seeing these as inventories not products I am not able to track stock levels or create re-order rules or anything of that ilk. Can anyone advise what I might be doing wrong? Any help would be greatly appreciated.

All the best,


Were you able to get this resolved? I am having the exact same problem.

Jim Biergans
on 8/15/13, 5:20 PM

see this: http://help.openerp.com/question/28203/importing-a-csv-to-physical-inventory-problem/?comment=28213#comment-28213

Jim Biergans
on 8/16/13, 2:40 PM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 7/16/13, 6:03 AM
Seen: 3020 times
Last updated: 3/16/15, 8:10 AM