Report - Category Tree for Export to CSV and Modification

Hi Guys

Below is a query which may be of use to you as you make modifications to a category tree.

If you export this as a CSV you can make the modifications you need (add more subcategories and items) and reimport

Saves having to do lots of clicking especially when re-designing the Item levels.

SELECT cdef.CATEGORYNAME "Category",sdef.NAME "SubCategory",idef.NAME "Item", null "Changes to be Made", cdef.CATEGORYDESCRIPTION "Category Desrciption" FROM categorydefinition cdef LEFT JOIN subcategorydefinition sdef ON cdef.categoryid=sdef.categoryid LEFT JOIN itemdefinition idef ON sdef.subcategoryid=idef.subcategoryid WHERE cdef.ISDELETED='0' OR sdef.ISDELETED='0' OR idef.ISDELETED='0'

Hope it hepls

Andrei