I'm trying to transfer products from a completely custom built store to the Zen Cart database. There are 500 products, so I try to map them to the correct categories. I successfully transfer all 500 items and I populate the products, products_description, and products_to_categories tables. The admin home page statistics show 490 active products and 10 deactivated products -- so far so good.

Here is the problem. I go to the store and I see a category that says it has 191 products. I go to the category and it tells me at the bottom of the page that there are only 94 products. Same thing with other categories. Some say they have 6 products, for example, but when you go to the category it says, "There are no products to list in this category."

I make sure the master_categories_id field in the products table matches the categories_id field in the products_to_categories table. I make sure the category with that categories_id exists and the parent_id matches with an existing category if applicable.

Why don't the items show up in the store? Some do, and some don't. Is there another related table to look at?