help importing hierarchical SQL database?

[p962ac1]

Does anyone know the way to export products from an sql database including choices for each size and colour hierarchically? Any help would be greatly appreciated! Many Thanks

[advwebsys]

realistically, this would require a custom piece of code to read through the database and generate a hierarchical import file.

not for the faint of heart

[Jan]

I've done this several times now and I've used views to extract the various bits of didn't types of info required and then used a union query to combine the results.

Regards,