Recently I opened up a new online store. Entire database (with 800+ products) and oscommerce installation was copied over to the new server.
Everything works great, except there seems to be a problem with displaying newly added products in all of the categories.
Existing products show up in the store, however, if I add a new product into existing or new category through the admin section and activate it, they do not show up in the store's front end (even if cache is off).
Here are few scenarios:
If new product(s) added into existing category, it would not show up. If 1 product added in a new category, it will show the product directly, if I add one more product to that categry, oscommerce will display "There are no products to list in this category." I hope that makes sense.
I've spend many long hours trying to figure out the problem to no avail.
Now, I'm looking for someone with extensive experience in OsCommerce 2.2MS2 who can figure this out quickly and efficiently. I'm hoping it's an easy fix.