Some Manufacturers in Advanced Search not showing

Some of the manufacturers are not showing in Advanced Search.

The pull down list doesn't seem to be populated with all my manufacturers. The sidebox seems to work just fine.

I've tried switching over to classic and it still doesn't work.. so it doesn't seem to be a template problem. This cart is fairly well hacked so it's possible I might have munged something up.. but I was just wondering if anyone had an idea.

Page is at: http://buydentalequipment.com/advanced_search

Thanks for you time and consideration,
Anthony

Ok.. I peeked in the code and sussed this out.

Turns out my problem was inventory. The SQL statement in zen_get_manufacturers specifically looks for quantity > 0

We don't use inventory on our cart. So our items were being ignored.

This simple SQL statement fixed the problem:
UPDATE cart1_products SET products_quantity = 1 WHERE products_quantity = 0;

Still left to question is why the sidebox didn't show the same problem. I would suspect it does something a little different. Maybe not using zen_get_manufacturers or perhaps ignoring the inventory check by default.

Hopefully this all helps someone else.

I just noticed the same error on my site this fixed it though cheers

you'd think if stock control is off then they'd all be set to 1 really ?