Hi there!
So I just started implementing Odoo for my business, which is a millworks business. Currently, I am just milling trees to order, and want to set up my products so that the different dimensions can be selected as a variant.
For instance - I have a product as 'Cedar Timbers', and then all my variants (texture, width, thickness, etc) and then the Qty on the order would be how many feet in length. So the per unit price would be per foot of LENGTH, and the Qty = Length ordered (I have the minimum length in there as a check box variant, with no price attached, as it doesn't effect the per foot price).
So all my variants are calculated, and then multiplied by the per foot according to the quantity ordered.
Where I'm stuck is, I know I want to sell this particular material for say $7.50 a BOARD FOOT (to those not in the construction / lumber industry, 1 Board Foot = 1" x 12" x 12" of material), but can't figure out a simple way to translate that into my variants, that simply ADD the variant costs together, not multiply. I'm thinking there's a way to implement a formula here, but that's where I'm a little stuck. If there's a way that the product can calculate the board ft from the width and thickness (by multiplying) and producing the number of board ft, then multiples that number by the base sale price, then I'd be set!
I hope this makes sense. I'm trying to avoid creating a ton of fixed dimension variants with associated prices, because then when I need to increase or decrease my price, I have to change it on ALL the variants, instead of just changing the base price and be done with it.
Again, for all dimensions, it would be the same price per board foot (think as if the material were liquid), so I'm just trying to figure out how to configure my variants for consistency, so that no matter the dimensions ordered (strictly speaking width and thickness), it all calcs out to the same price on a board foot price.
Thanks for any insight or advice!