You are here:  » Product mapping search bar


Product mapping search bar

Submitted by Tobix on Mon, 2020-03-30 09:52 in

I am manually grouping the products so that I can manage the best images, descriptions, passwords, etc etc

I realized that on the admin page "Product Mapping" you would need a search bar in order to facilitate the search for the product you want to modify again. Do you think I have already uploaded 300 products ... and it gets complicated ... How can I solve it?

Submitted by support on Mon, 2020-03-30 11:16

Hi Tobix,

To add a search box to Product Mapping, edit admin/productsmap.php and look for the following code at line 62:

  $sql = "SELECT * FROM `".$config_databaseTablePrefix."productsmap` ORDER BY name";

...and REPLACE with:

  $q = (isset($_GET["q"])?$_GET["q"]:"");
  print "<h3>".translate("Search")."</h3>";
  widget_formBegin("GET");
  widget_textBox("Alternatives","q",TRUE,$q,"",3);
  widget_formButtons(array("Search"=>TRUE));
  widget_formEnd();
  if ($q)
  {
    $sql = "SELECT * FROM `".$config_databaseTablePrefix."productsmap` WHERE alternates LIKE '%".database_safe($q)."%' ORDER BY name";
  }
  else
  {
    $sql = "SELECT * FROM `".$config_databaseTablePrefix."productsmap` ORDER BY name";
  }

Hope this helps!

Cheers,
David.
--
PriceTapestry.com