Products Have Disappeared

**Dick Sycamore** · 28 Sep 2007, 08:59 PM

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.

**Kim** · 28 Sep 2007, 09:05 PM

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

**Dick Sycamore** · 28 Sep 2007, 09:08 PM

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

**Dick Sycamore** · 30 Sep 2007, 06:05 AM

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.

**Dick Sycamore** · 21 Oct 2007, 05:05 AM

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.

**Ajeh** · 21 Oct 2007, 05:45 AM

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

**Dick Sycamore** · 23 Oct 2007, 04:36 AM

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

**Ajeh** · 23 Oct 2007, 04:41 AM

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

**Ajeh** · 23 Oct 2007, 04:50 AM

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?