Anyway that you could do a batch export as an Excel file so that this database would be easier to work with? I'm also having lots of problems with this. Actually the exact same problem with the Products showing up in my store!
I was also wondering if there would be any issues with me replacing the ProductID if I'm doing a batch upload? I essentially want to make the Product ID to be the Item # in my catalog. I'll match this with my category tables as well.