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 ?
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$.
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:)
Perhaps, this module - https://apps.odoo.com/apps/modules/18.0/variant_price_system - will be helpful