View Issue Details

IDProjectCategoryView StatusLast Update
0006449OXID eShop (all versions)1.02. Price calculations (discounts, coupons, additional costs etc.)public2016-11-16 17:22
Reporterpreethi 
PrioritynormalSeverityminorReproducibilityalways
Status acknowledgedResolutionreopened 
Product Version 
Target VersionFixed in Version 
Summary0006449: The discount "Current Bargain" from the demodata does not work
DescriptionA new discount created with the same settings function properly.
TagsNo tags attached.
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
MySQL VersionNot defined

Activities

preethi

2016-07-13 14:22

developer   ~0011692

The below insert statement is from the demodata.sql:

INSERT INTO `oxobject2discount` (`OXID`, `OXDISCOUNTID`, `OXOBJECTID`, `OXTYPE`) VALUES
('4e542e4e8f60a0562.61817542', '4e542e4e8dd127836.00288451', '1771', 'oxarticles'),
('79042e787b414fae9.16540313', '4e542e4e8dd127836.00288451', '85b42c94a32b3fdd2.66642220', 'oxarticles'),
('0a842e4fd23a60e04.47404876', '4e542e4e8dd127836.00288451', '1431', 'oxarticles'),
('79042e787aea9e9d9.36926408', '4e542e4e8dd127836.00288451', 'd8842e3cbf9290351.59301740', 'oxarticles');

The 4 "objectid"s ('1771', '85b42c94a32b3fdd2.66642220', '1431', 'd8842e3cbf9290351.59301740') are not valid. No records with these "oxid"s are available in the table "oxarticles".

juergen_busch

2016-07-13 14:23

developer   ~0011693

Small correction: discount doesn't work, after you removed the category and the products assigned to it. Discount isn't valid for all products than.

preethi

2016-07-13 14:30

developer   ~0011695

I believe, discounts that have no articles or categories assigned, are valid for all articles.

juergen_busch

2016-07-13 14:33

developer   ~0011696

Last edited: 2016-07-13 14:34

View 3 revisions

Yes, but it isn't valid for all products because of the wrong OXIDs. Discount is still assigned to (no-existing) products and therefore not shown in basket.

preethi

2016-07-20 17:32

developer   ~0011710

You got it right. But for record type "oxcountry", the OXDISCOUNTIDs are wrong. The following pull-request should rectify the problem:

https://github.com/OXID-eSales/oxideshop_ce/pull/435/files