Develop a Filter and output XML/CSV product feeds on specific categories and keywords

Project Description:

Want a script to be used to filter different product feeds from affiliates (csv and/or xml) because most of them are poorly categorized before output. Thus, we need to open the feed, mark which products belonging to specific categories and keywords and output the new feed.

This is what we need:

1. Script OR application (must be mac based) to import xml > show > filter > keep or delete nodes > export xml again with new info.

2. The app/script must be able to list/read current nodes (could be products, categories/keywords) of our choosing.

3. The app/script must thereafter allow us to rename/delete/mark to keep nodes of our choosing.

4. The app/script must then allow it to be exported (utf-8) with the new construction.

Skills required are MySQL, PHP, Web Scraping, Software Architecture, XML