Hello,
I would like to create something for Products that would be similar to Attributes but it would allow numerical values (or even free text) and if possible, with Unit of Measure. The idea is I would like to be able to have a table like this for each Product:
| Name | Value | UoM |
| Electrical power | 13,2 | kW |
| Electrical connection | 220 | V |
| Water connection | 0,5 | in |
The values in the first column should be centrally managed, they would have UoM (third column) assigned (or even better Category of UoM). The second column (value) would be arbitrary - any value user choses only limited by type (int, float, text).
The idea is that we have many different types of Products in our catalogue and we need to keep different sets of attributes for them. The number of Products is currently 260 000 and will be growing. So I do not see a very good design in creating every possible attribute and just hide them with individual Product Categories.
In the end we would like to publish these to website and allow searching according to them ;-)
Can anyone help with design or give pointer to some module that would be doing something like this?
Pedro,
this is almost exactly what I am looking for! The idea in the description matches my usecase. The minor thing is no UoM (not that important) and being 12.0 version only (I will attempt to port it ot 13.0). Many, many thanx for pointing me this direction!