Products Dont Appear In Categories

[Guest Savior]

I just made a csv script and it worked. The site will list them all in the right category but when you go to the categories they belong in. You will only see one product, however on the featured products it will show u there are alot more assigned to that category. Help me!

Also the site tells me

Products: 264

Categories: 20

Prices: US Dollars

All the products are assigned to /Outdoor Living on the admin screens and from the mysql db. The category even says they are all in there on the admin side but it wont show anymore but 1 on the customer side.

Site: http://www.yourdealcenter.net/

Problem Solved:

after I imported the items into the db I didnt run the following sql cmd

TRUNCATE TABLE CubeCart_cats_idx;

INSERT INTO CubeCart_cats_idx (productid, cat_id) SELECT productid, cat_id FROM CubeCart_inventory;