Odoo Help

Welcome!

This community 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.

1

Importing CSVs as Warehouse Physical Inventory Entries

By
Adam Whistler
on 7/16/13, 6:03 AM 2,201 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,

Adam

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

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