Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Searching by productcode (sku) not so easy after upgrade???

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design
 
Thread Tools Search this Thread
  #1  
Old 02-04-2003, 10:46 PM
  wayne@industrialeye.com's Avatar 
wayne@industrialeye.com wayne@industrialeye.com is offline
 

Newbie
  
Join Date: Nov 2002
Location: los angeles, california
Posts: 5
 

Default Searching by productcode (sku) not so easy after upgrade???

ok so before i could do
$search_query = "($sql_tbl[products].product like '%$substring%' or $sql_tbl[products].descr like '%$substring%'or $sql_tbl[products].productcode like '%$substring%') and $sql_tbl[categories].category like '$search_category%' and $sql_tbl[products].forsale='Y' $price_condition ".$sort_by_price;

now if i attempt that it doesn't return any results using the sku #
(version 3.3.1) anyone sucessfully able to search by sku/productcode in this version (or others?)

thanks for your time, wayne
Reply With Quote
  #2  
Old 02-04-2003, 11:01 PM
  wayne@industrialeye.com's Avatar 
wayne@industrialeye.com wayne@industrialeye.com is offline
 

Newbie
  
Join Date: Nov 2002
Location: los angeles, california
Posts: 5
 

Default

fixxed it!
http://forum.x-cart.com/viewtopic.php?t=1261&highlight=productcode
worked totaly!
here's the answer
the new system for searching also does a seperate search to find the quantity of products taht match the search field, so when it does the search with out adding what is said in the above link in bold (on the big post with lots of code) it would find the matching products yet when the next search for quantity hit it wouldn't search by the productcode (again this is the key it's explained above the bold is all that matters in that code excerpt) thus getting 0 and returning a "no results" answer. hope this helps anyone whit problems! see ya!
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 01:43 PM.

   

 
X-Cart forums © 2001-2020