Hi there,
v4 has some nice features and some not-finished business. Why would x-men include search by SKU/product code in advanced search when this is one of the main search fields people are looking for rpoducts in a lot of industries (auto, computers and etc? Here is the simple mod to search by sku from the main search box:
search.php
change:
Code:
if (empty($data["by_title"]) && empty($data["by_shortdescr"]) && empty($data["by_fulldescr"]) && empty($data["extra_fields"])) {
to
Code:
if (empty($data["by_title"]) && empty($data["by_shortdescr"]) && empty($data["by_fulldescr"]) && empty($data["by_productcode"]) && empty($data["extra_fields"])) {
after
Code:
if (!empty($data["by_fulldescr"]))
$condition[] = "$sql_tbl[products].fulldescr LIKE '%".$data["substring"]."%'";
add
Code:
if (!empty($data["by_productcode"]))
$condition[] = "$sql_tbl[products].productcode LIKE '%".$data["substring"]."%'";
skin1/customer/search.tpl
after
Code:
<INPUT type="hidden" name="posted_data[by_fulldescr]" value="Y">
add
Code:
<INPUT type="hidden" name="posted_data[by_productcode]" value="Y">
skin1/customer/main/search_result.tpl
after
Code:
<TD width="5"><INPUT type="checkbox" name="posted_data[by_fulldescr]"{if $search_prefilled eq "" or $search_prefilled.by_fulldescr} checked{/if}></TD><TD nowrap>{$lng.lbl_det_description}</TD>
add
Code:
<TD width="5"><INPUT type="checkbox" name="posted_data[by_productcode]"{if $search_prefilled eq "" or $search_prefilled.by_productcode} checked{/if}></TD><TD nowrap>{$lng.lbl_sku}</TD>
Enjoy
