|
|
|
|
Group: Awaiting Activation
Last Login: 08 February 2012 23:04
Posts: 11,
Visits: 1,149
|
When I do a search for something I KNOW is on my store, it returns the result but states:
Your search for 'arsenal' produced 0 match(es) How can I get the results to ONLY display items that have a quantity greater than 0
Tags:
Edited: 13 January 2012 15:01 by
amscompanies
|
|
|
|
|
Group: Forum Members
Last Login: 2 days ago @ 00:31
Posts: 103,
Visits: 1,129
|
I can't say for sure, but I'm guessing you'll need to find the code that evaluates the search results and puts an if statement in there telling it to only return if it's greater than 0.
|
|
|
|
|
Group: Administrators
Last Login: 2 days ago @ 02:22
Posts: 113,
Visits: 654
|
You need to modify the search stored procedure in order to do that. Quantities are linked to versions not directly to products, so if you have multiple versions product that could slow down your search - anyway, you need to make sure that the products returned are exist in the result of the below query: "SELECT DISTINCT V_ProductID FROM tblKartrisVersions WHERE V_Quantity > 0" A better solution is to set all the out of stock products as "Not Live" and automatically they will appear in the search results.
|