If two items are exactly the same, we normally merge them. If they are alternatives they will have some difference(Price, Quality, Brand). There could be an additional field to indicate the parameter of difference.
These don’t seem to fit in your scope, but will be useful to us:
- Updating “BOM Stock report” to search and complete required qty by looking for alternatives in a parent warehouse.
- Selecting alternatives based on cost in Production Orders.