Okay I tried to update and redefine the products in their category list but it had no effect, so I went to the database and emptied the ps3_productcaterories table and then manually reentered the data and it works fine. The problem is, to define 5800 categories is probably a week's work doing it manually. I'm not sure why it doesn't work when I import the list as a csv. The products all show in in the correct categories but from the consumer side clicking on any category seems to freeze it for 5 minutes while it searches, then it turns up an empty field. I'm not so inclined to spend that amount of time entering these things one at a time, not if I can find another product that allows me to simply import the whole list. Any suggestions on what might be going wrong with the import of the productcategories would be appreciated.