Bizzare Caterories / Sidebox Problem

[Dayo]

I just activated my categories sidebox and noticed that it is only showing 37 items instead of 166.

My items are organised in this way

Main category

Sub Cats A, B, C, D

Sub Cats A & B have items in them

Sub Cats C & D have two further sub cats each ... C1, C2, D1 & D2 with items in them.

Now I notice that the categories box is only showing that I have items in A & B and if I try to navigate to C1, C2, D1 or D2, I get a message saying there are no items to list there.

The items are however in the products table and the products to categories table has a full complement of items.

I can add items in C1, C2, D1 or D2 to the cart and chackout if I navigate to them directly using the product id but if I go to the index page and look for these items and click, I get a page not found error.

Also, C1, C2, D1 & D2 turns up empty in the admin.

Can anyone point me to what is likely messed up?

Thanks

[Ajeh]

I got lost at the stop sign ...

Have you an URL that we could perhaps peek at to see what is up here?

[Dayo]

Hi




Thanks for the response.

Sent you the url.

All waht the long winded explanation meant to say was that in the categories sidebox in the catalogue and the attributes controller in admin, items in subcats nested more than two layers from the main categories do not appear even though they are in the catalogue.

The sidebox shows 37 items but if you click on all items, you will find there are 166.

[Ajeh]

Do you import your products?

Do you have Products and Categories mixed inside the same Category?

Do you use Linked Products?

[Dayo]

Do you import your products?

I use the gallery 2 bridge I have been working on here:

Do you have Products and Categories mixed inside the same Category?

No. Just one category and one or two layers of subcats with the images in those

Do you use Linked Products?

Not sure what those are but some images appear in more than one album in G2. I.E. linked in G2.

My items aren't really for sale and I only just reinstalled ZC to work further on the G2 bridge and the moneybookers module for others that might need these (you might have read my rants against you senior folk here lol).

I haven't had the sidebox up for several versions of the bridge although I know it worked fine before. I guess I'll have to iteratively install versons of the bridge to see where it broke.

When I manually look in the products to categories table, I can see all the items are properly mapped to categories.

If I knew what file controls the display, I could avoid the pain.

[Ajeh]

Things just don't make sense on the data ...

Check the number of records in:
products
products_description
products_to_categories

If you do not use Linked Products, then these should match ...

Also check that these two tables have the same number of records:
categories
categories_descripton

[Dayo]

products table = 166 records
products_description = 166 records
products_to_categories = 166 records

If you do not use Linked Products, then these should match ...

Also check that these two tables have the same number of records:
categories = 16 records
categories_descripton = 16 records

So everything looks as it should.

However, when I look at the contents of products_to_categories, I notice that the category ids entered are different for most products from the actual ids in the categories table.

This has to do with the G2 Bridge (I forgot the link before: http://gallery.menalto.com/node/69302)

Thanks for helping me track the issue down.

[Ajeh]

That is what I am seeing that the categories_id do not match so I am not sure what your code is doing on this as I do not use it ...

[Dayo]

That is what I am seeing that the categories_id do not match so I am not sure what your code is doing on this as I do not use it ...

Thanks. Now that I know where the issue has come from, I can tackle it.

Cheers!

[Dayo]

Solved.

This was a G2 to ZC Bridge specific issue and an update of the bridge will be posted on the G2 site presently.