Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Increase Sales Prices in Bulk?


choiceblades

Recommended Posts

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

Link to comment
Share on other sites

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

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.

Contribs Written: Nochex APC Payment Module, Cheque Payment Module

Contribs Updated: Information Pages Unlimited, Latest News V1

You've gotta be Quick on the Draw in this game!

Link to comment
Share on other sites

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

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:

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...