Forum Moderators: open
The issue is that if we import an ipod nano from your <category> which is gadgets , and our site contains the category mp3 players.
Any know of a good solution to allow us to match categories so that we can match merchants category to our category?
if (category is 'portable music devices'){
mycategory = 'mp3 players'
}
or perhaps you may need tables full of these rules
if (category in array('portable music devices','mp3','music players','ipods',...)){
mycategory = 'mp3 players'
}
If there is no obvious category mapping, then your job gets tougher. You've got an item, presumably with a title - like "ipod nano" - and you need to categorize it yourself.
I'd be inclined to write a script that checks an item's similarity to other items that already exist, based on the item's name and words in the description, then figure out the most likely category by looking at its nearest neighbours.
the technique is called "data clustering" and it's not for the faint of heart
[en.wikipedia.org...]
Another alternative is to do it manually, which may be easier (depends how many items we're talking about)