Best prices for each merchant...

Submitted by dculpepper on Tue, 2009-01-20 19:27 in Price Tapestry

I would like to create a page for each merchant that lists which products the merchant has the best price on... sort of a merchant specific search result with only that merchants best prices. Any idea how I would do that?

Thanks,

David

Hi David, Nice idea - and

Submitted by support on Tue, 2009-01-20 19:33

Hi David,

Nice idea - and should be relatively straight forward but the best implementation depends on a couple of things - could you let me know how many products (in total) you have, and how many products on average each merchant carries? (they may be similar numbers of course)

Cheers,
David.

Hello David, Thanks for the

Submitted by dculpepper on Tue, 2009-01-20 19:50

Hello David,

Thanks for the quick reply! I deal with a pretty small set of products. Let's see... 2526 total products and an average of 950 products per merchant. Some merchants carry as few as 300 and others more than 1300.

Thanks,

David

Thanks - with those numbers

Submitted by support on Tue, 2009-01-20 19:59

Thanks - with those numbers I don't think it's practical to make it a live query (based on the existing database schema) so a new field would probably be required within the products table (a "cheapest" flag) which is set by a batch process that you would run after every import.

It's not too complicated - but bear with me and i'll try and look work this through tomorrow for you...

Cheers,
David.

I did not think about doing

Submitted by dculpepper on Thu, 2009-01-29 20:59

I did not think about doing it that way. Maybe I will try to work my way through it.

Thanks,

David