What I need is for someone top take an XML file with 70K+ Products and then take another excel sheet that has 4800 or so Category Structures. The xml file provides a field with a code that would correspond to categories file to merger together to show category name instead of ID as associated in xml file. This may need to be done twice a year or we need a tool developed in php / mysql to do this.
Attached files are examples of data. Products example has around 100 products or so. Cats_Subcats has 1000 or so to identify.
There may be up to 8 sub categories. I look for your judgement and pricing to get this done soon. Let me know your thoughts.