You are here:  » Remove individual merchants from Merchant List


Remove individual merchants from Merchant List

Submitted by Retro135 on Thu, 2016-12-29 19:38 in

I have some merchants whose terms require not listing their name even in a display URL. Is there any way to remove specific merchants from displaying in /shops/merchant/?

Submitted by support on Sat, 2016-12-31 12:51

Sure - in merchants.php, look for the SELECT SQL construction at line 6:

  $sql = "SELECT DISTINCT(merchant) FROM `".$config_databaseTablePrefix."products` ORDER BY merchant";

...and here you can add a NOT IN clause to exclude merchants that you do not wish to index; for example:

  $sql = "SELECT DISTINCT(merchant) FROM `".$config_databaseTablePrefix."products` WHERE merchant NOT IN ('Merchant 1','Merchant 2','Merchant 3') ORDER BY merchant";

In this case, 'Merchant 1','Merchant 2' and 'Merchant 3' would then be excluded from the index.

Hope this helps!

Cheers,
David.
--
PriceTapestry.com

Submitted by Retro135 on Mon, 2017-01-09 15:58

Works a charm, thank you!