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.
I will need results in Excel Format. Because of 65k or so excel limit. May need broken up into two.
Unless someone wants to quote building a php system on my server to develop a tool to do as needed.
I am attaching a file so that you can see the end result of whats needed.