[notgrass]

I have a series of products that I want to be available for sale in a hidden category, but I don't want them to show up in the Products Map.

In this file:

modules/Products_Map/func.php

at line 153 in the function pmap_get_products($symb), I made this change:

$query = " AND $sql_tbl[products].product REGEXP '^[{$symb}]' AND INSTR($sql_tbl[products].productcode,'clearance') = 0";

In the product code / SKU field for each product that I want to hide, I put the word clearance. You could use another series of letters or numbers. This code-- AND INSTR($sql_tbl[products].productcode,'clearance') = 0 -- checks to see if the string clearance shows up in the productcode field of each product. If it does, that product is excluded from the list.