View Issue Details

IDProjectCategoryView StatusLast Update
0007160OXID eShop (all versions)4.12. Subshop handlingpublic2024-07-10 14:49
Reportermatths Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionduplicate 
Product Version6.1.6 
Summary0007160: Articles inherited in a sub shop with an overwritten price are not sorted correctly by price
DescriptionWhen you have an OXID EE Installation with two subshops (malls) and the seconed subshop inherits the articles from the first, one can overwrite the price of the article in subshop 2. These prices are stored in the oxfield2shop table.
When an article that is in subshop 1 more expensive than another article gets cheaper in subshop 2, the category list sorted by price in subshop 2 is still sorting using the prices of subshop 1 and not 2.
Steps To Reproduce* setup OXID EE with at least two subshops
* subshop two needs to inherit articles from subshop one
* create a test category in subshop 2 and put inherited articles inside
* change the prices of some of those articles (for testing purpose make one expensive article cheap, and a cheap article expensive)
* open the category list view in the frontend
* sort category list view by price
* see that sorting is wrong and follows still the prices from subshop one
Additional InformationWhy is this important? Developers might customize more fields to overwrite values for inherited articles in different subshops and use sorting for that. So if you you would fix sorting for price, oxfield2shop is more usable for other use cases as well.
TagsSorting
Attached Files
oxfield2shop.JPG (134,058 bytes)   
oxfield2shop.JPG (134,058 bytes)   
after.JPG (160,031 bytes)   
after.JPG (160,031 bytes)   
before.JPG (152,915 bytes)   
before.JPG (152,915 bytes)   
change_price_in_subshop.JPG (215,602 bytes)   
change_price_in_subshop.JPG (215,602 bytes)   
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
Database VersionNot defined

Relationships

duplicate of 0006546 confirmedHR \oxArticleList::_getPriceSelect doesn't consider the multishop feature 

Activities

QA

2020-07-15 14:29

administrator   ~0013266

Dear matths,

thank you for reporting this issue.

I could reproduce the wrong sorting in OXID 6.2

Best regards

QA - SG -