Hi all,

I've got a table with products / categories - the categories is what's giving me a head-ache.....

parent category
RED C/MER
RED C/SAUV
RED MERLOT
ROSE
ROSE P/NOIR
SPARK RED
SPARK SWEET
SPARK WHITE
WHITE BIANCO
WHITE BLEND
WHITE BOTRYT

No matter how I try to import these using the taxonomy feed importer - I cannot seem to get;
RED - with all the variations
ROSE - with all the variations
SPART ... etc etc etc....

the SQL I'm using is ; select parent, category from products group by parent, category

even with a 2-pass jobb - create the parents first, then map category to parents - nope - wont do it...

I must be missing something - but cannot see it....

I don't want to / cannot create the dictionary manually - I'm looking at in excess of 4000 products - about 180 parents / categories all up....

Does anyone have a documented way, step by step process to make this automated?

Regards,
Knut