Web development

From the SQL query editor, you will need to enter the code to make the price change. Below are a few sample codes to demonstrate increasing and decreasing prices by both specific amounts and percentages. 

 

Sample code to increase all prices by twenty percent (20%).

UPDATE ps_product_shop SET price = price*1.20

UPDATE ps_product SET price = price*1.20

 

Sample code to decrease all prices by 15 cents (.25).

UPDATE ps_product_shop SET price = price-.15

UPDATE ps_product SET price = price-.15

 

Sample code to increase all prices by fifty cents (.15).

UPDATE ps_product_shop SET price = price+0.50

UPDATE ps_product SET price = price+0.50

 

Sample code to decrease all prices by ten percent (10%)

UPDATE ps_product_shop SET price = price / 1.1

UPDATE ps_product SET price = price / 1.1

Wednesday, 19 July 2017 14:55

Module layout in the AT E-news joomla template

Written by

Module layout in the AT E-news joomla template

Page 6 of 6