need to edit brand/manufacturer results page
Posted: Sat Jun 29, 2013 1:26 am
Hi guys,
OC 1.4.9.3
When I do a brand search the result I get are false, I've narrowed it down to the face that if a product has no stock it's giving false results. I'm pretty sure I know what SQL to add to fix the problem but I've no idea what file to edit.
Where do I edit the brands results page? I think I just need to add a WHERE p.status = '1' AND p.quantity > '0'
Cheers
Kev
OC 1.4.9.3
When I do a brand search the result I get are false, I've narrowed it down to the face that if a product has no stock it's giving false results. I'm pretty sure I know what SQL to add to fix the problem but I've no idea what file to edit.
Where do I edit the brands results page? I think I just need to add a WHERE p.status = '1' AND p.quantity > '0'
Cheers
Kev