Odoo Help


Do you know how we can perform CSV import export for Product Categories in OpenErp 7 ?

Ray Carnes
on 2/6/13, 12:37 PM 9,199 views

Original question at:


Make sure your user has membership in 'Technical Features'. Refresh the browser if necessary. Warehouse --> Configuration --> Products --> Product Categories.

Ray Carnes
on 2/6/13, 12:37 PM

The comment by Ray Carnes should be an answer.

Ahmad Khayyat
on 2/13/13, 5:09 PM

see the following link.


Vincent Myo
on 6/11/13, 3:49 AM

michel Guénard

--michel Guénard--

| 5 5 8
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard
On 2/6/13, 4:34 PM

The context of this answer is "online OpenERP V7" and Windows First: select the list of products for which you need to change their Category (works for Category or POS Category); you do this selection using the search small window (right top of the screen), selection of the filter (standard or "advanced search); the click the boxes on the left of product title (you can select all at once with the upper box; here there is an hidden hint: by default the number of lines is set to 80; but if you let the mouse on the "1-80" you discover that you can select higher walues for the number of lines to select (80, 100, 200, 500, UNLIMITED);

Second step: once you have selected the products to export, go to the "More" menu on top of the window, where you find the export button. Select it!

Third step: select the fields from the left pane and add them to the right pane; you need at least to select the fields: Name and category. Then click on export on the left bottom of the window. This exports your selected data to a file (in a folder that appears to be your default folder for downloads); this file is a CSV format file.

Fourth: open the file (default name is "product.product.csv) with you spreadsheet program (openoffice calc or MS excel). You will be asked to select some attributes before the opening: select UTF-8 / , .

Fifth step: review the data, change the categories you need to change, save the file (always with the same attributes as above (UTF-8 / ,). Nota bene: to know which Category values to use, you do the same process of export/import, using the Category menu.

Sixth step: go back to OpenERP, select the import button, select your saved product.product.csv file. Press the Validate button (top right of the screen); ik every thing "seems valid" (green message), then import. If the validation step indicates error or missing columns or unknown values in your file, then Check the column headers, change either the column header OR the new values in your csv file, when you are prompted to do do it!!! This step may need some errors and essay trials.

Verify then that the products now have your new categories.

Re: your Second Step: There is no "Plus" menu at the top of my window.

on 3/21/13, 3:56 PM

I've edited the answer - should be 'MORE' menu.

Ray Carnes
on 4/5/13, 9:54 PM

In openerp 7 Export data most of the fields shows database keys (IDs) which are not useful for human analysis. please give me suggestion how to fix in openerp version 7.

on 8/20/13, 3:25 AM

From the "Export Type" dropdown, select "Export all data" and you will now see not just the database key fields, but all of the related fields including the human readable ones. If you are exporting for reporting purposes, you may want to look at http://help.openerp.com/question/27120/what-is-the-best-way-to-develop-reports-in-open-erp - you can use Google spreadsheets to pull data that is human readable.

Ray Carnes
on 8/20/13, 2:19 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

2 follower(s)


Asked: 2/6/13, 12:37 PM
Seen: 9199 times
Last updated: 3/16/15, 8:10 AM