Import products into odoo (openerp)

openerp openerp-7 odoo openerp-8
joelschmid picture joelschmid · Jul 12, 2014 · Viewed 9.5k times · Source

I would like to import some products into odoo/openerp for the point of sale module. Howewer I have a category called "Chalet" which is not found during import. Where can I find the external id of the product category?

This is the .csv which I would like to import:

    External ID,Name,Internal Reference,Category/External ID,Can be Expensed,Can be Purchased,Can be Sold,Sale Price,Cost,Supply Method,Product Type,Procurement Method
    AR1,Arni ,AR1,Chalet,TRUE,TRUE,TRUE,0,0,Buy,Service,Make to Stock
    AU9,Ausbi 1 ,AU9,Chalet,TRUE,TRUE,TRUE,0,0,Buy,Service,Make to Stock

This is the error message I get: enter image description here

Answer

Mariusz Mizgier picture Mariusz Mizgier · Jul 13, 2014

Easier way would be to go to product categories, look for the id of the category Chalet (open form with it and in address you will see id=X), then replace in your csv Chalet with this id and when importing don't go with external id but with database id for category. Most likely what happened here is that you have never exported category 'Chalet' so the external id is not known - another approach would be exporting category, checking external id and putting it instead of name.

Related questions

how to display openerp error message

In my student module I inherited res.partner. And I want to restrict to modify name in partner view if partner is a student. here is my cord. from openerp.osv import osv, fields class res_partner(osv.Model): _inherit = …

Read More
How to check if one2many field is empty in openerp xml views

I'm trying to make some field invisible if another field ( which is one2many ) has no value ( is empty). I'm trying something like <field name="reference" invisible="{'line_ids', '=', False}"/> Also tried <field name="reference" …

Read More
How to use related fields (fields.related) in odoo-8?

I am trying to retrieve comment field(customer internal notes) from res_partner to account invoice module.Right now I just want to print it later I will include it in xml code. I tried in three ways like this, 1)…

Read More