Hi David
I am using price tapestry also for fashion feeds. The problem with fashion feeds is that they often use the same title for different products: for example 94 different bikinis have all only the title bikini. As they all have the same title, they are filtered out. I guess I have to live with that. What bothers me though is that the "Featured Products" and the search results show a picture and a description that does not match the minimum price and therefore missleading and confusing visitors (it even confused myself).
I know why this happens (it takes the first picture and the first description matching the title and then looking for the minimum price for the title), but I don't know how to change it so that it first looks for the minimum price for the title and then using the picture and description matching this minimum price.
Is there a way (I know there always is) to match the picture and the description with the minimum price?
Cheers, IG
Hi IG,
I am looking into it; unfortunately due to the way that summary queries work under MySQL it's not possible to specify which of the result group you wish to provide the non summary fields from.
Could you let me know what version of MySQL you are running (you can use this script) as there are some features available since 4.1.1 that might make this easier.
Otherwise, I think it would be possible to write some custom code to do it for the featured products (i'll help with that); however it is going to be less practical for the search results because of the potential number of queries that are required.
The other tricky part of course; is what happens if there are 2 results both with the same lowest price? Would the image from either of those results be acceptable?
Cheers!
David.
Hi David,
Thanks a lot for your continuous and great support.
Having read your reply, I took some time to figure out how I should proceed. I think I found quite an elegant way to avoid confusing my visitor by adding the actual price of the featured product and in the search results I added a link to the shown products. If you would like to have a look, here you go: Preisvergleich
Cheers, Ivo
Is there anybody who can point me in the right direction? If I could not make myself clear or if I am asking for the impossible, please also let me know.
Cheers, IG