Skip to Content
Menu
This question has been flagged
3 Replies
5843 Views

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

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$.

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

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
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
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
1
May 25
847
0
Feb 25
915
2
Jun 22
1444
7
Oct 24
3143
0
Jul 24
990