categories and products not showing while importing

We are trying out the free version and are importing 5 data products to our database using navicat(database management & design tool). We have all products, categories and product categories imported correct.  When we go to the admin panel we can see products and categories are there but they are not showing up on the "test store front" side. My client is looking for a new script because comersus is not discontinued and I told her your script looks pretty good. We didn't have this problem with navicat and comersus. I see that there is a way to import csv but we prefer to use navicat.

Thanks for your Help