We need a tool to map the categories our supplier uses to those of our own. Using this tool, I would be able to map similar categories and then create a CSV file that contains the Item ID's and the Category ID's for importation to our CMS. The logic assumed is that items are members of categories.
Ideally he tool will be able to represent the hierarchical nature of the categories and be easy to work with. Please see the attached files, which should give all the data necessary.
At some later point we may want to include another supppliers categories as a further part of the job.