I need to add an attribute that allows multiple values - but not from a set of pre-selected values, not multiple select but multiple text fields.
One product, one or more values in the one field. These are for information/internal purposes so I cannot use something like "options" to store it.
This is to store the product rotations numbers from our warehouse, which can be several for some products. As we need to pass these on when sending the order to the warehouse, it would greatly simplify our lives to have them visible.
Product -> sku -> rotation #1 -> rotation #2 -> rotation #3
I had a look at some of the native warehouse/stock modules but none of them seem to support the sku/rotation/stock model that warehouses use, if their screenshots and manuals are to be believed. If one did it, that would be my first choice.
The only multiple value attributes of that kind I could find are the media attributes but these are complicated by all the file, format etc. concerns so it is hard to see the structure on how to reproduce this. I think it'd need to have a custom attribute type created, with its own tables etc.
I have considered storing it all as xml or csv in one field but then I have to add code to pack/unpack this and it makes the whole thing a lot more work, especially when rotations disappear after being sold.
Anyone done this before? I'm looking at doing it the most standard way possible so the risk of it affecting other extensions is minimised.
I'm not really looking at tracking the stock per rotation as this would make it a much bigger project than I want to tackle. I just want the information.