There isn't actually any defined sequence of products within a category; other than of course the query return order selected by MySQL for a search of "category:Some Category:". This means that it would take several queries to find the product in the result set (you couldn't simply select all products in the category to look for it) and then link the ones either side.
It could be done, but I would not recommend trying to do this because of the performance implications.
Hi,
There isn't actually any defined sequence of products within a category; other than of course the query return order selected by MySQL for a search of "category:Some Category:". This means that it would take several queries to find the product in the result set (you couldn't simply select all products in the category to look for it) and then link the ones either side.
It could be done, but I would not recommend trying to do this because of the performance implications.
Cheers,
David.