You are here:  » Limit results to 1 offer / merchant


Limit results to 1 offer / merchant

Submitted by artemis75 on Sat, 2006-08-12 03:02 in

Hello, the script is working great, thank you guys!

I'm looking for a way to limit the search results in search.php to only one item found maximum per merchant.
(several merchants in my feed are selling the same object x 10 with differents accessories each time, and i only want to display their first offer (and cheaper).
I guess the work need to be made in the sql code in search php but i have no idea on what to do precisely...any clue ?
Thank you,
Charles

Submitted by support on Sat, 2006-08-12 09:19

Hi Charles,

I think this would be better handled during the import process; so that you are only importing 1 of each product type per merchant. Can you post some example product names and i'll see what kind of filtering may be possible to achieve this...

Cheers,
David.

Submitted by artemis75 on Sat, 2006-08-12 15:48

Hi David, thanks for your help!
Well the products names i use are electronics products names.

For "42PD7200" request (wich is a plasma screen model), i've got theses produts names results :

1) Plasma Screen\ (42 inches) \HD ready\ 42PD7200 + <b>free hdmi cable</b>
2) Plasma Screen\ (42 inches) \HD ready\ 42PD7200 + <b>somethingelse</b>
3) Plasma Screen\ (42 inches) \HD ready\ 42PD7200 + <b>somethingelse</b>

The beginning of the products names are the same until the "+" sign.

I'm trying to filter it with excel but it sounds quite complex ;-)

Best regards, and thank you again,

Charles