Jump to content

Specific price is not vissible in Front Office after update from 1.6.0.9 to 1.6.014


tapukatata

Recommended Posts

I update my prestashop from 1.6.0.9 to 1.6.014 but when I add new specific price it's not visible in product page. 

 

After the update, when trying to add a specific price had the following error:
 

Unknown column 'reduction_tax' in 'field list'

INSERT INTO `ps_specific_price` (`id_shop_group`, `id_shop`, `id_cart`, `id_product`, `id_product_attribute`, `id_currency`, `id_specific_price_rule`, `id_country`, `id_group`, `id_customer`, `price`, `from_quantity`, `reduction`, `reduction_tax`, `reduction_type`, `from`, `to`) VALUES ('0', '0', '0', '691', '0', '0', '0', '0', '0', '0', '-1', '1', '2', '1', 'amount', '0000-00-00 00:00:00', '0000-00-00 00:00:00')

 

After that in SQL I added that code:
 

ALTER TABLE `ps_specific_price` ADD `reduction_tax` ENUM('amount','percentage') NOT NULL AFTER `reduction`;
ALTER TABLE `ps_specific_price_rule` ADD `reduction_tax` ENUM('amount','percentage') NOT NULL AFTER `reduction`;
 
Now I am able to add specific price but when I open the product page I can not see reduction percent and reduction amount. I can see them but only till product page is loading. Here is example: http://iskambg.com/avto-aksesoari/6-ochila-za-shofirane-noshtem-denem.html
Edited by tapukatata (see edit history)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...