Odoo Help


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.


How to update supplier prices?

on 4/1/13, 5:07 AM 3,161 views

My supplier issued a new price-list for 2013. How can I best update the prices for this supplier? Do I have to do it product by product?

On 4/2/13, 6:26 AM

Well ton123 here my attempt to explain: 1.) Enable importing from csv in: Settings>General Settings>Allow users to import data from CSV files

To update existing products: 1.) Only the articles shown on your monitor will be exported. a)So, if you want to update the products of one supplier then filter by advanced filter "Suppliers name contains ..." b)If you want to update more products then shown on your monitor then "change how many products you show in each screen. It is located on the right corner of your screen." 2,) Select the products with an x and then from "more" select "export". 3.) Choose the fields to update. This might be only "sales description" and "sales price". An ID field is added automatically. Just export the two fields to a csv file. 4.) Open the csv file with your spreadsheet (I use Libreoffice Calc) and make the changes to the fields. Careful -> do not touch the entries in the first column "ID". (example, increase the sales prices by 10%). 5.) Save the changed data back to the csv file 6.) In openERP products choose "Import" (text besides "Create") 7.) Select the csv file, wait a little, then press "Validate" 8.) If no error, press "Import". OpenERP knows from the ID field which products need to be updated and it updates only the fields in the csv file. All other information remains unchanged.

To add additional products: 1.) Export a template from a similar product to a csv file (one product is enough). Make sure that you select all the fields which have a blue background (they are the minimum information required for new products) + whatever fields you want to fill in. 2.) Open the csv file with your spreadsheet. Leave all the field names, but remove the data in column 1 "ID". If there is no id then openERP knows that this is a new product and will issue an id automatically on import. 3.) Fill in all the other fields, especially the blue ones! 4.) Save as csv and import as described above. You will now find the new products in your list.

On 4/1/13, 5:13 AM

You can export your suppliers' products to an Excel file, update the spreadsheet then import it in OpenERP

I would like to know the detailed steps.

on 4/1/13, 6:28 AM

Thank you, that worked fine. But how do I re-import the updated .xls list?

on 4/1/13, 6:28 AM

This is where PDI(Kettle) integration comes in handy.

Ivica Dimitrijev
on 4/1/13, 6:49 AM

12907 to answer your question: First go Purchase - Products. In the list view to right select an advanced filter "supplier contains ....". This will display all products of this supplier. Then mark all products with x and on top under "More" you find the option "Export".

on 4/1/13, 6:59 AM

You must enable importing from csv in: Settings>General Settings>Allow users to import data from CSV files

Ivica Dimitrijev
on 4/1/13, 7:16 AM

Ok, import from csv is now a option. However I have to learn about the field values for import :-)

on 4/1/13, 9:29 AM

If you learned please post as a tutorial in an answert on this question.

on 4/2/13, 4:46 AM

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

1 follower(s)


Asked: 4/1/13, 5:07 AM
Seen: 3161 times
Last updated: 3/16/15, 8:10 AM