X-Cart forums - HELP! SKU same as ProductID-wrong product comes up in search

X-Cart forums (https://forum.x-cart.com/index.php)

- Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)

- - HELP! SKU same as ProductID-wrong product comes up in search (https://forum.x-cart.com/showthread.php?t=14074)

HELP! SKU same as ProductID-wrong product comes up in search

Pardon me if this has been answered somewhere but I have been searching for hours!

A couple of our products have the same SKU as X-Cart's default Product ID. For example, the Motorola CLS 1410 is also known by it's model number which is 16142. If you put "16142" in the site search box, it brings up the Motorola Motorola CLS 1410, which is actually model # 16143. If you search for that model number (16143) you get "No matching products found" and my client is flipping out on me!

Is there a way to exclude X-Cart's default Product ID from the site search?

have a dig in include/search.php and look for productid

I don't have search.php in the "include" folder but I do have it in the "admin", "customer" and "provider" folders.

Which one of these do you suggest and what do I do once I find it?

: )

I found it on 2 lines:

80:

Code:

                $search_query_count = "select count(*) from $sql_tbl[pricing], $sql_tbl[categories], $sql_tbl[products] LEFT JOIN $sql_tbl[products_lng] ON $sql_tbl[products].productid=$sql_tbl[products_lng].productid where $sql_tbl[pricing].productid=$sql_tbl[products].productid and $sql_tbl[pricing].quantity=1 and $sql_tbl[products].categoryid=$sql_tbl[categories].categoryid $membership_condition and ($sql_tbl[pricing].membership='". $user_account['membership']."' or $sql_tbl[pricing].membership='') AND $category_condition and $sql_tbl[products].forsale='Y' and $sql_tbl[categories].avail='Y' $price_condition $substring_query group by $sql_tbl[products].productid";

and 86:

Code:

                $search_query_count = "select count(*) from $sql_tbl[products], $sql_tbl[pricing], $sql_tbl[categories] where $sql_tbl[pricing].productid=$sql_tbl[products].productid and $sql_tbl[pricing].quantity=1 and $sql_tbl[products].categoryid=$sql_tbl[categories].categoryid $membership_condition and ($sql_tbl[pricing].membership='".@$user_account['membership']."' or $sql_tbl[pricing].membership='') AND $category_condition and $sql_tbl[products].forsale='Y' and $sql_tbl[categories].avail='Y' $price_condition $substring_query group by $sql_tbl[products].productid";

Although I found it, I don't have the foggiest what to do with it...Shan, can you help?

: )