I own a garden center, and am having trouble representing our inventory within Odoo.

Plants generally come in sizes as measured by their container. For example, in the USA, large plants come in 1 gallon, 3 gallon, and 10 gallon containers.  (There are many different sizes, but I'm just using three for this example.)  The price goes up for each size (bigger is more expensive) but not in the same amount for each plant type.

There are TONS of different types of plants.  Japanese Maples are very popular, as are Oak Leaf Hydrangeas.  The prices for these two plants are different, but both come in the 1, 3, and 10 gallon sizes.

We also have different vendors for these plants.  Some vendors charge more for the same plant, which means we need to charge more.  Sometimes, we have two of the same type and size plant, but since they are from two different vendors, they have different prices.

To summarize, I can't use Odoo Product Variants to determine an exact "markup" because it varies tremendously across different products.  Furthermore, I have a second variant, the vendor, which also changes the price.

My first question: Is it possible to have Vendor as a Product Variant without duplicating all of my Vendors as variants?  I'd like to avoid typing things in twice.

My second question: In the above example, I would place a price on the exact combination of Vendor and Size from the Inventory app.  However, what happens when prices change, as they always do?  Is there a history of price changes?

My third question: does anyone have any advice or suggestions on how to tackle this problem?  Are there any plugins or extensions that would help?  (Note: I'm an enterprise subscriber, but I would be able to run the software myself if needed.)

Thank you for any and all input.