Bulk Modify Zencart product price, original prices, specials, product attributes

 Bulk modification Zencart Commodity price is nothing more than the following: one on the original base on the volume of a certain proportion of the original price of the batch into a new price for the first case, many people on the net have given the solution:

Bulk modification of Zencart commodity prices there are only a few cases: On the original basis on the volume of a certain proportion of the two will be the original price for a new price for the first case, many people on the internet has given a solution: the use of SQL statement batch modification: Login MySQL backstage, find products This table, click on the top of the SQL, write the statement to do To perform a replacement price of a equal to another price B, you can enter the following statement: Update products set products_price=288 where Products_price=199;update specials set specials_new_products_price=188 where specials_new_products_price=166; If the price of all products above the site increased by 10 yuan, then you can enter the following statement: Update Products Set Products_price=products_price+10;update Specials set Specials_new_products_price=specials_new_ products_price+10; To increase the price of all products by 10%, enter: Update Products Set Products_price=products_price*1.1;update Specials set Specials_new_products_price=specials_new_ products_price*1.1; Finally, don't forget to click "GO" to execute it! Here's a workaround for the second scenario: Update Products Set Products_price=replace (Products_price, ' 20.8800 ', ' 16.8800 '); Update specials Set Specials_new_ Products_price=replace (Specials_new_products_price, ' 20.8800 ', ' 16.8800 '); The meaning of this statement is to change 20.88 to 16.88 statements, the other steps ibid. Bulk modification of product property prices: Update products_attributes set options_values_price=options_values_price*1.1;update products_attributes set Options_ values_price=99 where options_values_price=88; Enterprise Templates Web site

Bulk Modify Zencart product price, original prices, specials, product attributes