# How to create a price list
**URL:** https://discuss.tryton.org/t/how-to-create-a-price-list/672
**Category:** User
**Created:** [August 24, 2018, 12:03pm UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672 "2018-08-24T12:03:01Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Vincenzo](https://discuss.tryton.org/u/Vincenzo)
#### Post date: [August 24, 2018, 12:03pm UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/1 "2018-08-24T12:03:01Z")
Hello everyone, I’m starting to use Tryton and I have a question to ask.
If I create a product that I buy from different suppliers and I sell to different customers, how can I associate the purchase price for each supplier and the sales price for each customer?
The prices of the various suppliers will be different for the same product.
The sales prices of the product will be different (different trade agreements).
---
### Author:  [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [August 24, 2018, 12:27pm UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/2 "2018-08-24T12:27:42Z")
> [@Vincenzo](#):
>
> f I create a product that I buy from different suppliers and I sell to different customers, how can I associate the purchase price for each supplier
After marking a product as purchasable you will see that a new _Suppliers_ tab on the product form. In this tab you can indicate each supplier that you can buy the product from. On each supplier there is a price list, which is used to indicate the price of the product depending on the purchased quantity.
> [@Vincenzo](#):
>
> and the sales price for each customer?
Using the sale\_price\_list module you can create diferent price list for each product. Each price list can be used to specify a fixed price for each product or compute one using a formula based on the product _List Price_ (i.e: A price list to apply a 10% discount to all products)
> [@Vincenzo](#):
>
> The prices of the various suppliers will be different for the same product.
> The sales prices of the product will be different (different trade agreements)
When creating a sale or a purchases document you can specify the unit price of this product for the current transaction. By default Tryton will use the defined price list (customer and suppliers) to propose a price, but you can manually modify it to specify a different one for the current agreement.
---
### Author:  [@Vincenzo](https://discuss.tryton.org/u/Vincenzo)
#### Post date: [September 8, 2018, 11:40am UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/3 "2018-09-08T11:40:24Z")
Hello everyone,
thanks for the answers!
I have installed the price list module, but I have a problem: how do I create a price list for a customer?
How can I associate a product’s personalized price with a specific customer?
What should I enter in the name field in prile list?
In the lines I will insert the products with the prices, but the customer where I indicate it?
how can I associate the list price to the customer ???
---
### Author:  [@albert](https://discuss.tryton.org/u/albert)
#### Post date: [September 8, 2018, 10:15pm UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/4 "2018-09-08T22:15:14Z")
> [@Vincenzo](#):
>
> I have installed the price list module, but I have a problem: how do I create a price list for a customer?
You can use the product\_price\_list and sale\_price\_list modules.
> [@Vincenzo](#):
>
> How can I associate a product’s personalized price with a specific customer?
> What should I enter in the name field in prile list?
> In the lines I will insert the products with the prices, but the customer where I indicate it?
> how can I associate the list price to the customer ???
The sale\_price\_list module allows you to create a price list and link it to a specific customer in the party’s form. That will be the price list used by default for that customer in the sale.
---
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [September 9, 2018, 7:47am UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/5 "2018-09-09T07:47:53Z")
> [@Vincenzo](#):
>
> How can I associate a product’s personalized price with a specific customer?
You must create a specific price list and link it to the party form as “Sale Price List”.
On the price list, you must create a line that match the specific product.
> [@Vincenzo](#):
>
> What should I enter in the name field in prile list?
What ever you want. It is a free text field to allow the user to recognize the price list among the others.
---
### Author:  [@Vincenzo](https://discuss.tryton.org/u/Vincenzo)
#### Post date: [September 9, 2018, 10:35am UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/6 "2018-09-09T10:35:11Z")
Good morning,
I installed the product\_price\_list and sale\_price\_list modules.
I created the price list (in product-\> price lists).
In the Sales section I did not understand how to connect to the customer the price list created …
On which item I click to connect the customer to the price list?
I want to create many price lists (in product-\> price Lists) and associate them with customers.
---
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [September 9, 2018, 11:19am UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/7 "2018-09-09T11:19:49Z")
> [@Vincenzo](#):
>
> In the Sales section I did not understand how to connect to the customer the price list created …
> On which item I click to connect the customer to the price list?
As said previously, the price list is linked to a party on the party form.
---
### Author:  [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [July 6, 2021, 4:28am UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/8 "2021-07-06T04:28:29Z")
Sorry, I need to jump in here.
I installed `sale_price_list`, and now can create price lists at `Menu>"Articles"`. In price lists created there, I can see a field “formula”, which works. But where would I insert fixed prices - just numbers?
Cheers, Wolf
---
### Author:  [@oscarQ](https://discuss.tryton.org/u/oscarQ)
#### Post date: [July 6, 2021, 6:07am UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/9 "2021-07-06T06:07:15Z")
AFAIK you also have to use the formula field.
---
### Author:  [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [July 6, 2021, 6:51am UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/10 "2021-07-06T06:51:35Z")
Thank you for your point. I tried to just type in a number, as well as in x.yy format. But it seems not to work for me. What could be wrong?
---
### Author:  [@oscarQ](https://discuss.tryton.org/u/oscarQ)
#### Post date: [July 6, 2021, 7:47am UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/11 "2021-07-06T07:47:38Z")
I made a test in the tryton demo website and it seems to work for me:
Which Tryton version are you using?
Are you getting any error?
---
### Author:  [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [July 6, 2021, 7:49am UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/12 "2021-07-06T07:49:59Z")
v 6.0 - no errors. ):
---
### Author:  [@oscarQ](https://discuss.tryton.org/u/oscarQ)
#### Post date: [July 6, 2021, 7:57am UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/13 "2021-07-06T07:57:48Z")
So what’s the problem? The sale is not filling in the price specified in the formula?
---
### Author:  [@jeromarquez](https://discuss.tryton.org/u/jeromarquez)
#### Post date: [July 6, 2021, 9:47am UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/14 "2021-07-06T09:47:23Z")
I do it by this way:
`unit_price*0+15.56`
It works perfect. But probably there is a better way.
Cheers!
---
### Author:  [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [July 6, 2021, 5:15pm UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/15 "2021-07-06T17:15:19Z")
> [@oscarQ](#):
>
> So what’s the problem?
Strange enough, now it works nicely. I re-created article categories and the price list in question, now I can type just a number, and it appears as such in a sale; when the “tax included” box is checked, even VAT is discounted.
When I review this discussion, it looks as if quite some people (me being the leading fool) did not get the idea that the “formula” box may hold just numbers as well. Dear developers - would it be such a big deal to name this field “price or formula” or "“price / formula”?? - You would expect a price field in a price list, wouldn’t you?
Cheers,
Wolf
---
### Author:  [@jeromarquez](https://discuss.tryton.org/u/jeromarquez)
#### Post date: [July 7, 2021, 4:13pm UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/16 "2021-07-07T16:13:00Z")
Another good improvement that we made and it’s very useful for us is to use Templates. By default you can filter just by categories or variant. We usually name prices at template level. I think this could be very useful for many companies and I understand as a standard function.
---
### Author:  [@Cristinacds1](https://discuss.tryton.org/u/Cristinacds1)
#### Post date: [July 19, 2022, 10:08pm UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/17 "2022-07-19T22:08:24Z")
Hello, best regards
Reading a little this old debate I still have the doubt of how to assign a list of specific prices to a third party, since where it indicates the value of the product is not editable, I would appreciate your help, thanks
---
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [July 19, 2022, 10:29pm UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/18 "2022-07-19T22:29:16Z")
Price lists are based on formula so you do not edit any price but a formula.
Also it seems you have non-standard module because there are no such price compute field in standard (because it makes no sense most of the time).
---
### Author:  [@jeromarquez](https://discuss.tryton.org/u/jeromarquez)
#### Post date: [July 28, 2022, 7:01am UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/19 "2022-07-28T07:01:23Z")
For us it makes sense and we do it by computing unit\_price\*0+45 for example. We use very often this way of naming prices.
Secondly, @ced what do you think about this functionality?
> [@jeromarquez](#):
>
> use Templates
We found it very useful and I don’t see why this is not a standard functionality.
Cheers!
---
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [July 28, 2022, 7:48am UTC](https://discuss.tryton.org/t/how-to-create-a-price-list/672/20 "2022-07-28T07:48:41Z")
Why not adding template as criteria but then it should be mutually exclusive with the product. Maybe we could use a Reference field and adapt the matching.
[Next page](https://discuss.tryton.org/t/how-to-create-a-price-list/672.md?page=2)