Odoo Help

0

Can you mass upload products?

By
Qitele International, Inc.
on 1/20/14, 11:20 AM 4,847 views

I need to know how to mass upload products to OpenERP?

1
Marco
On 1/20/14, 3:55 PM

Mariusz Mizgier is correct, however you WILL find a lot of problems trying to get it to work, at least that is what happened to me and here are some information that could prove useful to you.

First, in order to be able to export/import we have to go to Settings->Configuration->General settings. check the box that corresponds to "Allow users to import data from CSV files"

click apply and then go to any products view and change the ordering to list, for some reason kanban and form do not have import/export as an option.

now you should see "import" right beside the create button, but let us leave that for later. you can now check the box for a product or multiple products and then the buttons "print, attachment, and more" will appear click on "more" and then export.

under export type it should be already be set on import compatible type but if it is not just set it correctly and then check "only export selection" now you just have to select the fields that you need to upload en masse. but make not of the ordering of fields because the names of the fields you are selecting WILL be different from the headers that will appear in your spreadsheet. and that can get quite confusing if you need a lot of fields. Also your first field will always be ID, be sure to leave that empty when you are importing so ERP will assign IDs to your items instead of using your items to overwrite your fields on existing items, it happened to me on my test platform :P

When you have all your products ready to import you can click on import of course, but when you choose your file to improt be sure to click "file format options" if the encoding is UTF-8 change it to latin1 so it can accept a wider variety of characters like the degree symbol and the like.

it is pretty simple once you get the hang of it.

0

If you already have the products in some kind of structured, machine-readable format, it is probably faster to write a python script that goes through the product list and adds all the product info to the product.template and product.product models. This would save you the time of manually typing each of the items into the csv file.

0
Gustavo
On 1/20/14, 5:03 PM

I agree with Timo, you might need to import your products with a Python script. It is not a big deal, in the following post there is an example of importing products in a csv files via xml-rpc

http://erpmoldeo.wordpress.com/2011/05/10/importing-products-with-web-services-in-openerp/

hope this helps,

Hi Gustavo, Thanks for the link. Have you had any luck importing products into the 8.0 branch with this script?

Luke Branch
on 7/11/14, 2:35 AM
0
Mariusz Mizgier
On 1/20/14, 3:05 PM

The easiest way to approach that is to create a single product on your own and export it with all fields, which are important to your company. After that you can populate this csv/xls file with real data and you are set to import it.

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.

Register

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

0 follower(s)

Stats

Asked: 1/20/14, 11:20 AM
Seen: 4847 times
Last updated: 3/16/15, 8:10 AM