Home Search Tags Members

Home » Kartris ASP.NET Ecommerce Software » Kartris technical issues » Search results issue and query

Search results issue and query

Posted By amscompanies Fri 13 Jan 2012
Add to Favorites0

Search results issue and query

Topic View Topic View Topic Options Topic Options
Author Message
amscompanies
Posted Fri 13 Jan 2012
Supreme Being

Supreme Being - (8,133 reputation)Supreme Being - (8,133 reputation)Supreme Being - (8,133 reputation)Supreme Being - (8,133 reputation)Supreme Being - (8,133 reputation)Supreme Being - (8,133 reputation)Supreme Being - (8,133 reputation)Supreme Being - (8,133 reputation)Supreme Being - (8,133 reputation)

Group: Awaiting Activation
Last Active: Wed 8 Feb 2012
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
Edited Fri 13 Jan 2012 by amscompanies
Post Information
saturation
Posted Fri 13 Jan 2012
Supreme Being

Supreme Being - (64,990 reputation)Supreme Being - (64,990 reputation)Supreme Being - (64,990 reputation)Supreme Being - (64,990 reputation)Supreme Being - (64,990 reputation)Supreme Being - (64,990 reputation)Supreme Being - (64,990 reputation)Supreme Being - (64,990 reputation)Supreme Being - (64,990 reputation)

Group: Forum Members
Last Active: Fri 30 Nov 2012
Posts: 108, Visits: 1,185
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.
Post Information
Mohammad
Posted Sun 15 Jan 2012
Kartris Expert

Kartris Expert - (78,939 reputation)Kartris Expert - (78,939 reputation)Kartris Expert - (78,939 reputation)Kartris Expert - (78,939 reputation)Kartris Expert - (78,939 reputation)Kartris Expert - (78,939 reputation)Kartris Expert - (78,939 reputation)Kartris Expert - (78,939 reputation)Kartris Expert - (78,939 reputation)

Group: Administrators
Last Active: Sun 27 Sep 2015
Posts: 115, Visits: 706
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.
Post Information

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top

Powered By InstantForum.NET 2012-1 © 2024
Execution: 0.031. 7 queries. Compression Enabled.