Pricing rules problem catalog Prestashop Version 1.6.1.0

[Raf-Corseboutique]

Since the update to Version 1.6.1.0 I had a list price rule. Example 3% discount for 3 items purchased; and promotions on items sheets. They do not work anymore or the price display, or when putting articles into the basket in the material even if I create a specific price.

I thought of an error in the database, I emptied the tables: ps_specific_price

ps_specific_price_priority ps_specific_price_rule ps_specific_price_rule_condition ps_specific_price_rule_condition_group

I recreated a new price rule and verified that it is properly registered in the database; but it is still not working.

If someone an idea to offer me that will help me a lot to me because it is impossible today to make a discount, promotion, balances ...

Thank you in advance.

 

www.corseboutique.fr

[Kakì]

hello and sorry, I have the same problem ...

you have solved?

[tita64]

Hello,
I resolved it by running:
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`);

However I think that the solution to this issue is already included in 1.6.1.1 version.

Please also view: http://forge.prestashop.com/browse/PSCSX-6430?filter=-2