Products Have Disappeared

Hello-

My store has been running fine for a long time. I got a report from a customer just now that she was trying to order something and it wouldn't process so I went to test the site and it no longer lists any products unless they are a "featured product." It shows that there are products in the categories but when you go to that category, there is nothing in it.

http://tradingpost.racineraiders.com

Any thought on what might've caused this. I haven't done anything that would cause it to change.

Thanks.

What are you settings under Admin> Configuration> Stock? Do the items in questions have zero stock levels?

No, they all have stock...I already checked that. Here are the settings for it though:

Title Value Action
Check stock level true
Subtract stock true
Allow Checkout true
Mark product out of stock ***
Stock Re-order level 5
Products status in Catalog when out of stock should be set to 0
Show Sold Out Image in place of Add to Cart 1
Product Quantity Decimals 0
Show Shopping Cart - Delete Checkboxes or Delete Button 3
Show Shopping Cart - Update Cart Button Location 3
Show New Products on empty Shopping Cart Page 1
Show Featured Products on empty Shopping Cart Page 2
Show Special Products on empty Shopping Cart Page 3
Show Upcoming Products on empty Shopping Cart Page 4

I was wondering if anyone has any other ideas on this matter. I'd really like to try and figure this out by the end of the night Sunday as our playoffs start this week and our traffic will greatly increase. Thanks.

I'm still trying to solve this issue and have had no luck. Does anyone have any out-of-the-box thoughts on this one? I would greatly appreciate it.

Check the products table in your database and make sure all products have a master_categories_id in them ...

I had someone look into this and it looks fine to them. Is there any setting in the admin that might create this issue?

What are the products_status settings on these Products where only if a Featured Product can they be seen?

Check products_id
10
14
15
21
29
23
24

Are these in the products_to_categories table?

How many times?

Are these in 1 or more than one Category?

Do you have an Category that holds both Categories and Products?

What version of Zen Cart are you running?

Clean install or an Upgrade?

How did you install?

How did you upgrade?

Where do I find that?

Using phpMyAdmin you want to look at the database and browse the products table and products_to_categories table and categories table to see the various fields to see if anything looks odd about those products_id and/or the categories_id that they are in ...

What version of Zen Cart are you running? 1.3

Clean install or an Upgrade? Clean Install on Lunarpages

How did you install? - through LunarPages Fantastico

How did you upgrade? - No upgrade yet because I have major issues every time I try to upgrade.

This store has been running flawlessly for about 1-1/2 years and this problem just seemed to pop-up.

You have one of the buggiest versions of Zen Cart ...

The current v1.3.7.1 would fix this and 2 zillion other issues that I am seeing ...
http://www.zen-cart.com/forum/showthread.php?t=69769

I'll give it another try with the upgrade but it's been unsuccessful every time I've tried...It's created more problems then what I have unfortunately.

Do a search on:
/new_shop

and use the Advanced Search so you can find things over the last year or so ...

There are numerous threads from simple to more robust to click for click more or less on how to do upgrades and not run into the nightmare ...

1 Download the Current version of Zen Cart from the Download link at the top of your page ... don't use something else to upgrade you ...

2 Never upgrade a live site always upgrade a working site ...

3 practice doing the upgrade until you can do it right each time in your sleep ...

4 test test test ...