Odoo Help


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.


How to import hundreds of product categories without ids?

Sean Samborski
on 11/15/13, 11:57 PM 1,601 views

So I have hundreds of product categories, hundreds of suppliers, and so on. I have thousands of products to import and have no way of knowing how to do this. It appears as though OpenERP wants only ids, never names. This would be an impossible task to somehow (I wouldn't even know where to begin) figure out all the ids for each supplier, category, etc.

I have tried categ_id/string as the value and when importing I've tried anything on Categories and Suppliers. For example, importing the supplier column and trying Supplier/Company returns "No matching record found in field Supplier" etc. I must be missing something as importing should be this difficult to figure out.

Thanks for any advice.

I'm in the same boat - did you get this figured out and if so, how?

Nick Davies
on 11/21/13, 10:18 AM

I haven't made it back around, but I'm no closer now than before. It's frustrating and there isn't much documentation on the matter.

Elephante, Sean Samborski
on 12/17/13, 1:35 AM

Fabien Pinckaers (fp)

--Fabien Pinckaers (fp)--
| 6 8 8
fsdsdfsdf, Belgium
--Fabien Pinckaers (fp)--

Odoo Founder & CEO

Fabien Pinckaers (fp)
On 11/16/13, 3:06 AM

The import tool support string or IDs. It's more reliable to use ID if you can, but if you can not you can use strings. To import with string, just set "categ_id", instead of "categ_id/..."

It's not that I don't want to use IDs, I would if I could, but it's impossible to get all the relationships between-> Name -> product.product_category_17. That's what my export prints out when I do a test and there's no way I can know what id is what for the suppliers and the categories.

Elephante, Sean Samborski
on 11/16/13, 11:44 AM

I also don't know what you mean by use just categ_id...I have only three options to choose from when trying an import (Category, Category/External ID, and one more but it says ID). I've tried all three and none work with a string.

Elephante, Sean Samborski
on 11/16/13, 11:47 AM

The Categories and Suppliers have to be imported first, before products - have you done that?

Bista Solutions US, Ray Carnes
on 11/17/13, 10:48 PM

These are already created and available when editing or adding new products.

Elephante, Sean Samborski
on 11/19/13, 7:50 PM

OK. Create one record manually, via the UI, and then export it. You will see from the CSV what format the data needs to be in and how you can set categories.

Bista Solutions US, Ray Carnes
on 11/20/13, 11:55 AM

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

3 follower(s)


Asked: 11/15/13, 11:57 PM
Seen: 1601 times
Last updated: 3/16/15, 8:10 AM