This one has got me baffled!
We have a 'Title' field that contains a full sentence or two.
The Db is huge and I need to add a category field to each row. Instead of manually editing each row, I'd like to have the category field auto-populated by choosing a parent category according to keywords found in the the Title field.
Follow me? I'm confusing myself.
For Ex:
"Your Choice Of a Tungsten or Ceramic Ring with Shipping From Wedding Rings Forever"
Id like the script to pick up 'Shipping' and use that keyword to place this entry into the parent 'Shopping' category.
Further to that, is it possible to pick up the word 'Wedding' and 'Ring', and use those keywords to add even more details which can be searched later on via a category tree 'advanced search'.
This way the whole row would go under:
parent category - shopping
and then - wedding
- jewelery
Make sense? I'll need to play around with keywords to make sure things get sorted correctly, but the DB is far to large to do this manually.
Thanks. Hope someone can help
