taxonomy with feeds import
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