Skip to Content
This question has been flagged
variantpricelistVariants
4 Replies
7903 Views
Avatar
Amir

We have several thousand products and each one may have up to 100 variants. Tryng to see if we can migrate to Odoo.

Each variant in our system has a unique SKU. It has a price, cost, barcode etc. In Odoo I see variants are setup differently and I am trying to see if we can adapt to it. 


The issue is that Odoo wants variant price to be a set based on Product's price, like +$5 for one variant and $0 for another. This is very odd when it comes to something like a tire that has different prices for different sizes. Prices fluctuate and we need to be able to update them.

I tried using Pricelists and it seems to partially solve the problem. On the product template we still have a price for the Product and variants.

Is there a way to be able to set the "Sales Price" for each variant directly and not based on the product price ?




Avatar
Discard
Ibrahim Boudmir

Hi, It's very simple to do in Odoo.

In Odoo, you have a product A which price is 10$.
If A has Variants, A1, A2, A3... and A2 is more expensive than the others, you can add the extra price for this particular variant.

so if A2 is 5$ more expensive, you only have to put 5$ in extra price. And the total price for A2 is 15$.

Amir
Author

Yes that's my understanding of how Odoo is setup. Thx for the confirmation. But in reality, we don't have prices set like that. And none of our suppliers provide prices to us like that. Variant A1, A2, A3,... each have a price completely independent. A product price doesn't mean anything in this case.

We have thousands of produces and tens of suppliers that provide us price updates base by SKU regularly (typically in CSV files with SKU, cost, sale price columns). We can't calculate each variant price /cost by substracting it from a product price. We don't even know what to set the product price at.

One silly workaround could be setting the product price to zero and variant prices be a fixed addition to that but that doesn't seem to be the right way. I am surprised Odoo doesn't have a way around this.

Using PriceLists is the only way I have found that we can keep track of , and update price of each SKU (that could be a variant of a product or a product with no variant).

Is there really no other way to set a price for a variant in Odoo ?!!! We can't be the only company having this issue or there is something we are missing here:)

Avatar
Amir
Author Best Answer

Putting this out there for others that might have the same question: 

Use Price List and ignore Product and variant prices. 

We found Odoo's product and variant price did not work for us as an online retailor. But we managed to achieve what we needed using Price Lists. You can create a price list and set any price you wish for a given variant regardless of the product's price. In our case all products are shown as $1 but in the price lists correct prices are set.

Products with no variants:
In Odoo each product has at least one variant. Odoo does not show this, but in the background there is always one variant set for a product which holds the SKU, Barcode, prices, etc. This can be set in the Price List as well.

Avatar
Discard
Avatar
Mateusz Zbrożek
Best Answer

Odoo I beg, please repair this issue

Avatar
Discard
Amir
Author

Matt, Pricelist works very well. If a product or variant has a pricelist, Odoo uses it on the Sales orders, if not it looks at the "Sale Price" field on the products or product variants.

All our pricelists records have "Apply to" set to "Product" and Product, Variant fields are provided for each record. This way all our items have a price. We have multiple pricelists for each item.

I think the "Sale Price" field on the products (and variants) was put there as a quick and simple way to set prices for those who do not want to dig into pricelists.

Mateusz Zbrożek

Pricelists work. Yep. But that's not the core. The thing is that we can not change the Sales Price of each individual variant of the product in inventory. The only way to do it is by using a tool not designed, and not meant for this purpose - pricelist. It's so irritating and basic I start to regret switch to odoo.

JH

I have the same problem.

Amir
Author

Matt,

Odoo is designed to take a simple price field for product and for variants BUT if pricelist is available, then it takes over and those fields are ignored. The intention must have been to give users who just need one price field a simple way to get what they need and for more sophisticated scenarios , the pricelists are used. I get it that the approach with variant price being added to product price is a bit ridiculous. It may be useful for some but not all users.

However, pricelist takes care of that. You CAN set the exact price per variant in the price lists (You can even have multiple pricelist records per variant if you want):

Select a product or Product Variant
Click on PriceList smart button then New
Select Apply To > "Product"
If product has any variant, you will see a new field "Variant" appear with default value "All Variants", change that to have your "Fixed price" apply to that variant only.

You can easily export the right columns, set prices, and import it back for mass updates. For new records, export a list of product variants first to get their external IDs , then make a new file to import into pricelist (with the ID of a pre-existing pricelist) and the prices you want, to set per variant prices. This will create a new record in price list for each variant.

JH

Amir,

In short.

Odoo cannot show the Product variant price list in the Ecommerce.
So we cannot use Price list.

Avatar
Sebastian Gomez
Best Answer

I am exactly on the same boat, quite surprised about this (we are halfway through the implementation). I thought about setting the price to 1 and then using the price list but it seems so silly to have to do that as the price everywhere will be 1 (unless on a quote, invoice etc).

Avatar
Discard
Avatar
Growth Stack Support
Best Answer

goto inventory > open the product > Attributes & Variants > add attribute (eg size) > Value > configure > click on the price and edit. 


Please note: you are to add an extra price that will be added to or discounted from the main product price. 


Main product : $60

Variant extra price: $3

Variant product price is now: $63


You might need Odoo partner assistance to import that large number of products with variants.

Avatar
Discard
Related Posts Replies Views Activity
Importing Variants and Price List
ecommerce pricelist Variants
Avatar
Avatar
1
May 25
2117
Add variant price to multiple quantities also on pricelists
variant ecommerce pricelist
Avatar
0
Feb 25
1855
V14 Help E-commerce do not Apply Pricelist on a product varient?
variant ecommerce pricelist
Avatar
Avatar
2
Jun 22
1975
How can i show the variant prices of a product in the shop list on the website shop using price list and NOT product template price?
variant ecommerce pricelist website
Avatar
Avatar
Avatar
Avatar
Avatar
7
Oct 24
4657
Making an product into a variant of its own listing?
product variant v14 Variants
Avatar
0
Jul 24
1658