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

Can you mass upload products?

By
Qitele International, Inc.
on 1/20/14, 11:20 AM 3,228 views

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

0

Gustavo

--Gustavo--
950
| 2 1 4
Buenos Aires, Argentina
--Gustavo--

Python developer, big fan of sailing

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
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
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.

0
Timo Talvitie
On 1/20/14, 4:14 PM

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.

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

0 follower(s)

Stats

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