I sell custom furniture (ie: Doors) and have several different options such as where holes are drilled, which finish, size, design, materials, whether they are pre-hung, how many panels, impact rating, fire rating, sound transmission, resistance to head loss, application, etc.

I have several tens of thousands of combinations and Odoo is hardcoded to limit the number of variants per product to 1,000.

I tried using Product Variants but can't get there, is this the best way?

Setting the Variants Creation Mode to Never doesn't allow me to define incompatible combinations, and I need our sales team to know this so they don't sell something we can't make.

I also tried adding several lines on the Sales Order to represent the product and the attributes (custom options) but when the Purchase Order is created, the lines do not respect the order so it is no longer clear which custom option belongs to which product.