View Issue Details

IDProjectCategoryView StatusLast Update
0006546OXID eShop (all versions)1.01. Products (product, categories, manufacturer, promotions etc.)public2024-07-10 14:49
Reportermichael_keiluweit Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status confirmedResolutionopen 
Product Version4.10.2 / 5.3.2 
Summary0006546: \oxArticleList::_getPriceSelect doesn't consider the multishop feature
DescriptionA 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 ReproduceInstall 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)
TagsEnterprise, Internationalization Rework, Multi Shop, Sorting
Attached Files
shop1.png (217,521 bytes)   
shop1.png (217,521 bytes)   
shop2.png (206,130 bytes)   
shop2.png (206,130 bytes)   
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
Database VersionNot defined

Relationships

has duplicate 0007160 closedSvenBrunk Articles inherited in a sub shop with an overwritten price are not sorted correctly by price 

Activities