icyhot Posted April 2, 2012 Share Posted April 2, 2012 I have many item with same pricing and these products change the price with the same value at the same time. Does anyone know how to do this so I can save my time editing every single items. Please help! Link to comment Share on other sites More sharing options...
MEG Venture Posted April 2, 2012 Share Posted April 2, 2012 You can change the price of the selected items by using SQL commands on your database. I guess this would be the fastest solution. Link to comment Share on other sites More sharing options...
icyhot Posted April 3, 2012 Author Share Posted April 3, 2012 You can change the price of the selected items by using SQL commands on your database. I guess this would be the fastest solution. Hey Caglar, Thank you very much for your help! Could you explain a bit more about it though? Can that be done in the back office? or do I have to do it on my hosting c-panel? I look forward to hear more from you. Thanks. Link to comment Share on other sites More sharing options...
MEG Venture Posted April 3, 2012 Share Posted April 3, 2012 (edited) Hi You can do this by using cpanel and probably through phpmyadmin if you don't use a third party program like navicat to manage your database. It should be a simple Find and Replace command. You have to apply this using SQL command tab (you will see this tab on the upper line of phpmyadmin when you select your prestashop database from the left menu). This command may change according to the version of your Mysql database but it will look like something below: UPDATE `ps_product` SET `price`=replace(price, '66.053500', '76.053500') The above code searches ps_product table, through price column and changes all values of "66.053500" to "76.053500" Hope this helps. P.S. That code works for me with MySql version 5.0.92 Don't forget to take a backup of your database before playing with sql commmands. Edited April 3, 2012 by Caglar (see edit history) 1 Link to comment Share on other sites More sharing options...
OC2PS Posted April 3, 2012 Share Posted April 3, 2012 No idea. Caglar's idea would work, but only for a limited variety of prices...not for situations where, for example, you want to change prices of 100 different products with 100 different prices (unless there is a uniform % price change)...I mean you could write a query even in that case, but it won't be that much less tedious than manually changing prices in the backend for each product. I, for one, could certainly use a Batch Quick Edit sort of function in the Admin panel. Link to comment Share on other sites More sharing options...
OC2PS Posted April 3, 2012 Share Posted April 3, 2012 http://forge.prestashop.com/browse/PSFV-783 Link to comment Share on other sites More sharing options...
Carolina Custom Designs Posted April 3, 2012 Share Posted April 3, 2012 I have seen a couple of modules that will do this. You might want to search the addons store. Marty Shue Link to comment Share on other sites More sharing options...
MEG Venture Posted May 21, 2012 Share Posted May 21, 2012 In addition, A simpler and cheaper module is Batch (Mass) Update - Product Available here: http://addons.prestashop.com/en/administration-tools/5118-Batch-Mass-Update---Product.html Link to comment Share on other sites More sharing options...
tomerg3 Posted May 21, 2012 Share Posted May 21, 2012 If you want to import price with discounts / groups etc... check out http://www.presto-changeo.com/en/import-export-modules/84-product-prices-import.html Link to comment Share on other sites More sharing options...
Recommended Posts