Categories mapping script

Categories mapping I need the follow functions: Choose supplier from the mysql table suppliers - drop down menu Set all products from this supplier as inactive in Magento products table - optional checkbox Choose to read a XML, CSV file and to choose the category field Read from mysql category table (Magento) Mapping the category from the XML, CSV file with a category from the store category table For example: CATEGORY SRC CATEGORY DEST
 “Sport / Fitness / Jogging” -> “Beginning|Sport|Fitness” (separator is always |)
 6. It has to be sure that all categories from the source file (XML, CSV) are mapped. For example two windows with checkbox or color mark when the category is mapped. If you have any other suggestion please let me know to comment on them 7. Create a MySQL CASE construction as a text field which I will be able to copy to import program. CASE [CSV_COL(2)] WHEN “CATEGORY SRC1" THEN “CATEGORY DEST1" WHEN “CATEGORY SRC2" THEN “CATEGORY DEST1” ……….. END 8. Save mapping to config file for next use with same vendor. Because next time there will be new categories. Files are in cyrillic UTF 8 Example XML: [login to view URL] [login to view URL] [login to view URL] [login to view URL] Attached is Magento mysql with table suppliers. Thank you