The last script (mass upload in osCommerce) works fine but there is an issue with it.
When new categories and subcategories are created it creates a new path to the category. ie., the orginal path to the backpacks category in the catalog is ?cpath=523, when the catalog update is done it becomes ?cpath=768. This prevents direct linking to categories and also stops search engine listings and backlinks.
Is there a way to correct this?
Once this is resolved we should be able to move on to some other projects.