The site I’m working on currently uses category hierarchy but unfortunately, some merchants data is lacking enough granularity in their category field to allow me to accurately map products to categories. I’m already extracting some keywords into newly created dB fields which I then append to the category field using a ‘text after filter’. This works ok but I would like to extend the category hierarchy further. I could handle this in the way I do now but I’m going to end up with loads of extra fields in my dB just to hold the keywords and also a whole set of ‘text after filters’ to append the data.
I wondered if you could suggest if there are any existing filters which would allow me to ‘scan and set’ using regular expression but then append the matches to another field (without deleting the existing content of that field)? I searched the forum but couldn’t spot anything.
Thanks in advance.