View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0006546||OXID eShop (all versions)||1.01. Products (product, categories, manufacturer, promotions etc.)||public||2016-11-23 12:03||2017-06-27 14:23|
|Product Version||4.10.2 / 5.3.2|
|Target Version||Fixed in Version|
|Summary||0006546: \oxArticleList::_getPriceSelect doesn't consider the multishop feature|
|Description||A product can have different prices in different shop/subshops in the Enterprise Edition. The original price is stored in the table oxarticles. But the individual prices of the subshops are saved in the table oxfield2shop. This table isn't considered when building the sql query which does the sorting for the category page.|
|Steps To Reproduce||Install the latest Enterprise Edition.|
1. Create 2 new shops, both inherting all articles from the shop with id 1.
2. Create a new category in each shop
3. Assign three articles to the new category (in each shop). Assign the same 3 articles to the new category in all the shops
4. Change the price of one item (in each shop) such that the sorting is different in the three shops. For example: Price of Article1 is the lowest in shop 1 and the highest in shop 2.
5. In frontend, goto the new category and sort by price. If it doesn't work on the first time, just change the value oxvarminprice to oxprice in the backend of the shop for each shop (master settings -> core settings -> settings -> products -> database fields product lists can be sorted after)
|Tags||Enterprise, Multi Shop, Sorting|
|PHP Version||Not defined|
|MySQL Version||Not defined|