Price in EUR is correct
Price rule for GBP is in place
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
if you set it to all countries and currency only it seems to work.
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/