I am working on a script that will import my particular database of products to a number of shopping cart solutions.

When importing my database to zencart I am filling the following tables with the appropriate data:

categories,
categories_descripton,
products,
products_description,
products_to_categories

I can see the products on the browse style pages, however when I click to goto a detail page I get a 404 page, and I am not sure of what I am missing in the database to fix it.

Any ideas?

the test website can be found
http://greendragonenterprises.net/gd1/