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.

0

Import product quantity by internal reference Odoo8

By
Keywoker
on 12/1/14, 9:27 AM 2,341 views

I have a db with many products without their quantities. I need to import ones from csv, but I don't know how to do that by internal reference. It's important.

0
Jeff Beidler
On 12/1/14, 11:57 AM

Assuming you have your stock locations already set up in Odoo (do that first), export all the IDs for locations and product IDs.  They should look something like __export__.stock_location_123  and __export__.product_template_12345.  Next, go to Warehouse --> Inventory Adjustments and create a new record.  Export this record to get the ID, name, and inventoried location ID.  With this data in hand, you can start assembling your CSV file. 

You will need some way to link your Internal Reference field with the Odoo product ID.  We use FileMaker Pro, but I'm sure there are myriad ways of accomplishing this task.  If your stock is divided amongst multiple locations, you'll need to tie your exported IDs in as well.  Once you've got the different pieces tied together, save or export to CSV or Excel.  You should have your Internal Reference (for easy reference, you won't import this), the ID of the location containing X quantity of the product, the product ID (from Odoo), the quantity of the product in the location specified, and the Unit of Measure (must match Odoo!).  Next, edit this file in Excel or OpenOffice Calc.  Add a couple columns at the beginning, and on the first line only, add the exported Inventory Adjustment ID, the Inventory Adjustment name field, and the exported inventoried location ID.

Your column headings should be id, name, Inventoried Location / External ID, (Ref - Don't import), Inventories / Location / External ID, Inventories / Product / External ID, Inventories / Checked Quantity, and Inventories / Product Unit of Measure.  Now save the file in CSV format.

Go back to Odoo and try importing this CSV file in the Inventory Adjustments screen.  Hopefully, Odoo hasn't changed since I last did this!  Your results may vary.  Good luck!  :)

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

1 follower(s)

Stats

Asked: 12/1/14, 9:27 AM
Seen: 2341 times
Last updated: 5/2/15, 9:45 AM