5 replies to this topic

[Terry Mitchell]

Hi All

I`m running a heavily modded V 2.2 RC2, I`m a week away from going live and suddenly all new products only show up Admin side, this still hapens even after placing in categories. Even when I run a search the newly added products don`t show.

Does anybody have any ideas or suggestions as to where I should be looking?? I tried replacing Categories.php and I`m quite sure the problem does not lie there.

Please help - Getting desperate here!

Many thanks

Terry

[mdtaylorlrim]

Do you have access to phpMyAdmin?

If so, pick a product that cannot be found in the catalog, but can be found in the admin.

Locate the product in the products table. Look at the column products_id and note the value.
Locate the value from above in the products_to_categories table in the products_id column. Note the value in the categories_id column
Locate the value above for the categories_id in the categories table and again in the categories_description table both in the categories_id column.

Also, follow the chain of nested categories in the categories table. Be sure that every category that has a parent_id not equal to 0, that the parent category actually exists.


Somewhere along that line if the chain of values is broken, then it may not show in the catalog.

[Terry Mitchell]

mdtaylorlrim, on 01 February 2010 - 05:41 PM, said:

Do you have access to phpMyAdmin?

If so, pick a product that cannot be found in the catalog, but can be found in the admin.

Locate the product in the products table. Look at the column products_id and note the value.
Locate the value from above in the products_to_categories table in the products_id column. Note the value in the categories_id column
Locate the value above for the categories_id in the categories table and again in the categories_description table both in the categories_id column.

Also, follow the chain of nested categories in the categories table. Be sure that every category that has a parent_id not equal to 0, that the parent category actually exists.


Somewhere along that line if the chain of values is broken, then it may not show in the catalog.

Thanks so much for the quick reply!!

I followed your steps to the lettter, the products all were correctly assigned to a category BUT all of the parent_id`s were 0. Is that the problem?? If so, how could this have happened and is there any way of rectifying it??

Thanks again so much for your time.

Best

Terry

[Terry Mitchell]

Terry Mitchell, on 01 February 2010 - 06:04 PM, said:

Thanks so much for the quick reply!!

I followed your steps to the lettter, the products all were correctly assigned to a category BUT all of the parent_id`s were 0. Is that the problem?? If so, how could this have happened and is there any way of rectifying it??

Thanks again so much for your time.

Best

Terry

Also, I just checked the database on an older not as heavily modded version of the site which does not have this problem, and the category parent_id`s are identical....Now I`m really confused!  

[Terry Mitchell]

mdtaylorlrim, on 01 February 2010 - 05:41 PM, said:

Do you have access to phpMyAdmin?

If so, pick a product that cannot be found in the catalog, but can be found in the admin.

Locate the product in the products table. Look at the column products_id and note the value.
Locate the value from above in the products_to_categories table in the products_id column. Note the value in the categories_id column
Locate the value above for the categories_id in the categories table and again in the categories_description table both in the categories_id column.

Also, follow the chain of nested categories in the categories table. Be sure that every category that has a parent_id not equal to 0, that the parent category actually exists.


Somewhere along that line if the chain of values is broken, then it may not show in the catalog.

Ok, I`m understanding a little better now - A parent_id of 0 means its not a nested category, so that means that this is not the problem as none of the categories I`m placing the product in are nested. Please let me know if you have any other ideas.

Thanks again.

Terry

[Terry Mitchell]

Ok, this is making me crazy now. I checked, all of the new products have the correct Category and Parent ID`s....How can they NOT be showing up Catalog side??   All of the older content shows up fine.   

Please, if anybody has ANY suggestions please let me know.

Thanks in advance

Terry