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

sale price list increase / decrease all products

By
klaas vortex
on 4/3/13, 5:14 AM 2,520 views

Is it possible to increase (or decrease) the sale price on all products ?

Or better within a catagory (like all products) So with this option I would like to increase all sales prices with +- 1,5% and round to 1.00 Euro's. It would be handy if percentage and rounding is selectable ;-)

1

patrick

--patrick--
1958
| 5 4 7
Baarn, Netherlands
--patrick--
patrick
On 4/3/13, 9:41 AM

Given your question and your remark that you do not want to use pricelists, the following options are available:

  1. Manually update all records
  2. Use a script to update the products, with the given rules about increase and rounding.
  3. Create a new table, store the price and date in it, and use this to get the price of the product. This also requires you to modify product.product, in order to get the price from the new table instead of the product itself.

Option 3 is the best solution if you want to keep a history, but also needs the most mdifications.

about option 2, a script, is this something which has to be done ''within'' openerp ? [like a change in the python source]. Or can you run scripts for the client side ?

klaas vortex
on 4/3/13, 1:09 PM

You can run scripts from outside of openERP. You use the XMLRPC connection to do the things you want. You can even script the pressing of buttons, by calling the correct methods. At the moment I am in the process of importing orders into openERP, and also validating the sale and even creating the needed invoice.

patrick
on 4/8/13, 12:47 PM
0

Priyesh Solanki (pso)

--Priyesh Solanki (pso)--
Tiny ERP Pvt Ltd
http://www.odoo.com
1100
| 2 2 4
--Priyesh Solanki (pso)--
Priyesh Solanki (pso)
On 4/3/13, 5:23 AM

You can configure Pricelist --> Pricelist Versions --> Pricelist Items for this. Select the category and configure rounding, margins, etc. as per your need with Based on as Public Price.

Thanks, Priyesh Solanki

0
klaas vortex
On 4/3/13, 5:29 AM

Thanks Priyesh,

But this is not the right solution. Our company (like others) work with a gross sales prices. Pricelist are discounted from the [product]-[sale price]. So I realy need to update the [sale price] in the [product view]

best regards Andre

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: 4/3/13, 5:14 AM
Seen: 2520 times
Last updated: 3/16/15, 8:10 AM