Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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.
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.product models. This would save you the time of manually typing each of the items into the csv file.
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
hope this helps,
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 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
|Asked: 1/20/14, 11:20 AM|
|Seen: 3478 times|
|Last updated: 3/16/15, 8:10 AM|