I am new to Odoo and, in fact, am just a couple days into my Trial of Odoo 11, so please excuse me if I use wrong terminology or the like.
The Issue:
We need to be able to set up a very large list of products and their variants, and then set their prices as determined by the Market Value, which is a combination of attribute values, not the individual values. Maybe a simple example will illustrate my request.
Example:
If we have one product, three variants and multiple values. We need to be able to select only the variants and values that correspond to that item and in variant combinations that make sense. Then, we need to be able to set the price like so -- on the Internal Reference (or barcode) not the color OR size:
Product: T-shirt
Variations: Size, Color, Cut
Attribute Values: Color: Black, Color: Red, Color:White, Color: Orange, Size: Large, Size: Medium, Size: Small, Cut: Fit, Cut: Trim, Cut: Full
This product only comes in Red or White and in Large and Medium. We need to set up just those four Product Variants, then we need to price them each individually like this:
| Internal Reference | Color | Size | Price |
| Tshirt-w-l | White | Large | $5 |
Tshirt-w-m | White | Medium | $6.50 |
Tshirt-r-l | Red | Large | $6.00 |
Tshirt-r-m | Red | Medium | $5.50 |
Current State:
I have imported our 818 products and a list of all of the possible variants and values to Odoo. Setting up the Product Variants is a one-time thing, but since we will need to be able to update the market prices on a regular basis, the price update needs to be repeatable.
Question(s):
How do we import a list of our 11,000+ product variations? Once we have all of the Product Variations set up, how do we set the price on each individually?
