Skip to Content
This question has been flagged
salespriceadjust
3 Replies
11887 Views
Avatar
klaas vortex

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 ;-)

Avatar
Discard
Avatar
patrick
Best Answer

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.

Avatar
Discard
klaas vortex
Author

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 ?

patrick

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.

Avatar
Priyesh Solanki (pso)
Best Answer

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

Avatar
Discard
Avatar
klaas vortex
Author Best Answer

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

Avatar
Discard
Related Posts Replies Views Activity
El IVA en cotizaciones
sales vat price
Avatar
0
May 24
1558
Pricelist
sales price pricelist
Avatar
Avatar
2
May 19
3642
Not allowing sales employees to change prices
sales group price
Avatar
Avatar
1
Mar 15
6289
Restrict cost price information
sales procurement price
Avatar
Avatar
1
Mar 15
7893
Automatic product list_price based on pricelist
sales sale price pricelist
Avatar
Avatar
Avatar
Avatar
Avatar
4
Oct 22
6212