merchants

Submitted by searley on Sun, 2006-04-09 06:56 in Price Tapestry

I have a couple of merchants that i would rather not show on the merchant index, is there any way to exclude these??

Think the easiest way to do

Submitted by support on Sun, 2006-04-09 08:08

I think the easiest way to do this would be to hack the SQL in merchants.php.

The current query is this:

$sql = "SELECT * FROM `".$config_databaseTablePrefix."feeds` ORDER BY merchant";

If you change that to something like:

$sql = "SELECT * FROM `".$config_databaseTablePrefix."feeds` WHERE merchant NOT IN ('Merchant A','Merchant B') ORDER BY merchant";

That should exclude Merchant A, Merchant B etc. from the list.

Hi David I would like to

Submitted by richard on Mon, 2008-12-01 11:53

Hi David

I would like to exclude one merchant from the search results. How would you go about that?

Many thanks

Hi Richard, If you mean the

Submitted by support on Mon, 2008-12-01 14:31

Hi Richard,

If you mean the merchant index just use the second example above with the sole merchant you wish to exclude in the IN list...

Cheers,
David.

Hi David Thanks for quick

Submitted by richard on Mon, 2008-12-01 15:58

Hi David

Thanks for quick response.

Sorry, I meant excluding from the search results generated by search.php

Hi Richard, Should be easily

Submitted by support on Mon, 2008-12-01 16:33

Hi Richard,

Should be easily do-able subject to performance. If you could email me your search.php i'll patch it up for you, and then you can edit my code to exclude the merchant(s) not required...

Cheers,
David.

Hi David Many thanks, it

Submitted by richard on Mon, 2008-12-01 20:36

Hi David

Many thanks, it worked a treat.

I am now reverse engineering your mods so I can learn again from you :)

This script is so ..... flexible

Thanks again

Regards

Richard