View Issue Details

IDProjectCategoryView StatusLast Update
0005889OXID eShop (all versions)1.02. Price calculations (discounts, coupons, additional costs etc.)public2023-12-06 15:17
Reportermartinwegele Assigned To 
Status acknowledgedResolutionopen 
Product Version4.8.7 / 5.1.7 
Summary0005889: Discount is applied to a scaled price product although price does not match
DescriptionIf a discount is applied to a product with scale prices or a category containing such products the discount is applied although the total price is below the purchase price that was defined for the discount.
It seems that the discount is applied because instead of the scaled price the regular price (oxarticles.oxprice) is used internally for the purchase price calculation. The prices and sums displayed in the basket are correct.
Steps To Reproduce1. Create a discount in the admin panel
2. for purchase price enter From: 300 and leave To: as it is
3. enter e.g. 10 % as a discount (works also for itm discounts, effect is worse if you enter 10 abs)
4. In the products tab assign a product or category
5. Select the tab stock for this product or one of the products of this category in Administer products
6. Enter a scale price for 5 to 100 items of 2.9
7. Put 99 items of that product into the cart.
The discount will be applied although the total sum is below the defined threshold of 300.
TagsCalculations, Category, Discount, Price Calculation, Product domain and basket rewrite, Scale Price
Attached Files
bug_discount.png (57,593 bytes)   
bug_discount.png (57,593 bytes)   
discount_config.png (26,542 bytes)   
discount_config.png (26,542 bytes)   
PHP VersionNot defined
Database VersionNot defined


related to 0006494 closedSvenBrunk Coupons with assigned categories doesn't work correct 



2017-08-01 15:42

developer   ~0012200

Last edited: 2017-08-01 15:43

That the discount is wrong calculated depends on the assignment of the discount. Without Discount assigment (global) it seems to be correct.

Another test:
- New Discount
  - Purchase Price (€) 250-99999
  - itm: some article
    - Amount: 1
- Product (some article like 1208)
  - Price (€): 17.8
  - Stock > Scale Prices: 7-99 Price %-Discount 20
- put article in basked
  - by amount of 15 no discount item is added as it is below 250 with scale price

When discount is assigned to the article or the category of the article, the scale price is ignored and item is first time added at amount of 15 not 18.