Importing products from another database. 404 errors

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/

there is already an addon out there called Easy Populate which is used to import data into your shop and database.

Its easier than writing your own script as its already done

the script I am developing is one which is much more complicated, designed to crawl my vendors sites then transfer the products to my sites automatically. My script seems to be putting in all the data I need, I am not sure why the 404 errors...

I figured out the problem, it was because the product_type was equal to zero, change it to 1

Thanks for the update on what fixed your imported products ...

NOTE: you need to make sure that you have a master_categories_id on your Products and that you have the products_price_sorter ...

IF you do NOT use Linked Products, you can quickly fix this in the Tools ... Store Manager ... by clicking, in this order:

Reset ALL Products Master Categories ID
to be used for Linked Products and Pricing:

Update ALL Products Price Sorter
to be able to sort by displayed prices: Update