Prestashop 1.6.1.0 Specific Price Rule Not Working

Price in EUR is correct
d0e8427ea65945363c94537ea89a1714

Price rule for GBP is in place
9f50471dc23da36c4d4a72fb0002258e

But in front-end on product page its showing a converted rate from EUR to GBP!


“After upgrading to 1.6.1.0 specific prices have disappeared from FO and BO.”
https://forge.prestashop.com/browse/PSCSX-6430

ALTER IGNORE TABLE ps_specific_price ADD UNIQUE KEY id_product_2 (id_cart, id_product,id_shop,id_shop_group,id_currency,id_country,id_group,id_customer,id_product_attribute,from_quantity,id_specific_price_rule,from,to);


1-click upgrade
af2c518a7b7d9963b683ed7de6c4fe31

if you set it to all countries and currency only it seems to work.
39204c8e373e0e3bb59a20abf4758386

ie – im changing united kingdom to any country for each specific price rule.

UPDATE implasky_pres803.ps_specific_price SET id_country = ‘0’ WHERE ps_specific_price.id_country = 17;

This seemed to work.

Refs:
https://www.prestashop.com/forums/topic/480794-specific-price-rules-currency-problem/
https://www.prestashop.com/forums/topic/467748-solved-specific-price-error-after-update-from-1609-to-1611/

Sam Deering is a web developer from England (currently living in Australia). In his spare time he enjoys coding, playing chess, reading and investing.

Leave a Reply

Your email address will not be published. Required fields are marked *