I have a some produts that are in Multiple Categories from Multiple merchants.
EG.
PRODUCT,CAT,PRICE,MERCHANT
Produt1,Cat1,10,Mer1
Produt1,Cat1,20,Mer2
Produt1,Cat1,30,Mer3
Produt1,Cat2,100,Mer4
Produt1,Cat2,110,Mer5
Produt1,,1,Mer6
When you click on Cat1 it returns 10 as the lowest price.
When you click on Cat2 it returns 100 as the lowest price.
But when you go to the product page you see 1 as the lowst price. And that is Correct.
Is there any way to show the correct lowest price in ALL cats?
DAVE
Hi Dave,
I'm aware of this issue - unfortunately it's something that is very difficult to handle efficiently; as effectively it would involve re-querying the database for every result based on the product name - as the original query was based on the category - hense only the cheapest item in that category is discovered on search results, but the cheapest item with that name is displayed on the product page.
The best overall option, if it's practical; would be to use Category Mapping to merge Cat2 with Cat1, and then of course all products will be selected for the single category search and the 10 would be returned as the lowest price.
Cheers,
David.