Post by kevgais » 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

Newbie

Posts

Joined
Wed Oct 27, 2010 6:33 pm

Post by labeshops » Sat Jun 29, 2013 2:45 am

Not sure on 1.4.9 but in 1.5x it's the manufacturer pages, so check catalog/model/catalog/manufacturer.php

Running Opencart v3.0.3.9 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.


User avatar
Expert Member

Posts

Joined
Thu Aug 04, 2011 4:41 am
Location - Florida, USA
Who is online

Users browsing this forum: Bing [Bot] and 114 guests