View Issue Details

IDProjectCategoryView StatusLast Update
0006166OXID eShop (all versions)1.01. Products (product, categories, manufacturer, promotions etc.)public2025-07-23 10:40
ReporterBergfreunde Assigned To 
PrioritylowSeveritytrivialReproducibilityalways
Status resolvedResolutionno change required 
Product Version4.7.4 / 5.0.4 revision 57063 
Summary0006166: Calculation SubShopVarMinPrice should go to its correct view instead of the core table
DescriptionHi together,

the function _getSubShopVarMinPrice() calculates the minprice for the current subshop. Therefor it should ask its own view instead of the core table because it might be that one or more variants aren't available in all subshops.

IS:
INNER JOIN ' . $this->getViewName(true) . '

SHOULD BE:
INNER JOIN ' . $this->getViewName() . '

As it joins the table oxfield2shop it shouldnt lead to a problem as long as there are no entries in that table for the current shop. But still should be changed for correct handling.
TagsNo tags attached.
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
Database VersionNot defined

Activities

SvenBrunk

2025-07-23 10:40

administrator   ~0018102

The true parameter does exactly that: It removes the use of the language-specific views and falls back to the core tables, while using the shop id in the join. So it should do exactly what you want. Removing the true parameter would give you the language-specific view which would be correct for the actual use in the frontend as the PAngV would require you to show only the prices actually visible to the customer. But that is not the scope of this method.