Hello, we’re encountering a design problem of or NOP DB and have a relative urgent question.
The context:
Most of our products have several variants like 300mg, 600mg and some have no variant. The products are mostly pills or liquids.
We are in the migration process towards NOP and imported already a few thousand products into the new database structure. Currently we are using attribute combinations to distinguish the different variants of each product.
The problem:
Now were adding features like order processing which needs us to relate each product-variant to one supplier (or more) and also to different stock levels etc. The current solution by using attribute combinations does not support all these product based relations and therefore requires some extension.
The question:
Can we continue with our current approach to use attribute combinations to distinguish product variants or should we change to use the product group feature and each single product is its own variant?
Thank you very much for your help or advise.