Community mailing list archives

Re: Multiple prices for a given product

Gustavo Orrillo
- 12/22/2014 06:01:49
Luis, quoting your e-mail

"I have been searching for solution where multiple prices are stored for a given product. Imagine something like 9 different unit prices depending on quantity (by tiers)"

- product.pricelists, you should use pricelists in your sale order.

"and supplier."

If I were you, I would extend the product.product model and add a column referencing the product.supplierinfo model.

"THe example would be that Widget1 costs 1,50 per unit for up to 1000, 1,35 for quantities between 1001 and 5000  and 1, 28 above that .
The situation is that I would have to quote all three at the same time to our customers (with the corresponding margins, of course)"

This is what I would do. I would create a product.supplierinfo tree view and extend the product.supplierinfo model to accomodate the extra price/margin information. I would add search columns to the tree view in order to make it easier for the user to filter the information they need. Then I would add a wizard so the user can select products/suppliers, and add them to a sale.order via the wizard

Hope this information helps,


On Mon, Dec 22, 2014 at 7:04 AM, Quentin THEURET <> wrote:
On 22/12/2014 10:42, Jordi Ballester Alomar wrote:
> Look at the product form view, tab 'Procurement'. You canset up supplier
> pricing based on quantity scales.

+1. For purchase side, you can use the tab 'Procurement' on the product 
form and define a pricelist based on these prices for the supplier (or 
for all suppliers).

For sale side, you can use pricelists to define different prices for a 
same product based on quantities and/or customer.



TeMPO Consulting
20, Avenue de la paix
67000 Strasbourg
Tel : 33 (0)3 88 56 82 18
Fax : 33 (0)9 70 63 35 46

Post to: