Increase Sales Prices in Bulk?

[choiceblades]

I want to know if it is possible to change all pricing by a set figure or more importantly a percentage figure. I have asked this question before and no one in this forum seems to want to answer this for me. All of my pricing is off by 30%. I dread going in and changing them one at a time. Any help would be greatly appreciated.

Thank you,

Donnie Pedlar

http://www.choiceblades.net

[ldavies83]

I want to know if it is possible to change all pricing by a set figure or more importantly a percentage figure.  I have asked this question before and no one in this forum seems to want to answer this for me.  All of my pricing is off by 30%.  I dread going in and changing them one at a time.  Any help would be greatly appreciated.

Thank you,

Donnie Pedlar

http://www.choiceblades.net

<{POST_SNAPBACK}>

If you have Easypopulate installed, you could export to CSV, import into your spreadsheet, create a new field which references the price and adds 30%, delete the previous price field and rename the new one to "Price" then reimport your data into easypopulate, that would do it. Hope this makes sence! I do it all the time on my stores.

[eTiMaGo]

I want to know if it is possible to change all pricing by a set figure or more importantly a percentage figure.  I have asked this question before and no one in this forum seems to want to answer this for me.  All of my pricing is off by 30%.  I dread going in and changing them one at a time.  Any help would be greatly appreciated.

Thank you,

Donnie Pedlar

http://www.choiceblades.net

<{POST_SNAPBACK}>

Or you could use PHPmyadmin or any other tool to manipulate your database, and enter a SQL query such as "UPDATE products SET products_price = products_price*1.30" which I believe will have the effect of adding 30% to ALL prices in your shop.

 

SQL = powerful :lol: :thumbsup: