That's exactly what I did. I see both rows and I deleted the failing one.
Thanks for your quick response!
I'm getting the following error in my log:
Error while running the 'FoxNetSoft Pagespeed' schedule task. Schedule task (FoxNetSoft.Plugin.Misc.Pagespeed.PictureOptimizerTask, FoxNetSoft.Plugin.Misc.Pagespeed) cannot by instantiated
Any guidance on how to address this?
Support wrote:
Spent way too much time banging my head against the wall only to figure out the NOPMSSQLPROVIDER plugin was the source of my pain.
Checking the "Use optimization for PriceCalculationService" setting breaks discounts by Manufacturer. Whenever a discount is applied in the cart and that feature is enabled, it doesn't recognize products that have been discounted by manufacturer. When I uncheck that feature everything works as expected.
However, if I have two discounts set up - one by manufacturer and one by product, and a product overlaps in both, the Product table sets the HasDiscountsApplied flag and then, and only then, does the Manufacturer discount get applied.
nopCommerce doesn't check the HasDiscountsApplied flag in the Product table when calculating discounts by Manufacturer.