Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

increase all prices by a percentage or set figure?


godin5150

Recommended Posts

I'm just wondering if anyone knows of a way to increase the price of multiple items by a percentage or set figure? I have a store database with about 400 items that need an upadate on pricing. I am hoping there might be a way to do this all at once without having to update each product individually.

 

 

 

Thanks,

 

Chad

Link to comment
Share on other sites

I'm just wondering if anyone knows of a way to increase the price of multiple items by a percentage or set figure?  I have a store database with about 400 items that need an upadate on pricing. I am hoping there might be a way to do this all at once without having to update each product individually.

Thanks,

 

Chad

There are a couple of contributions like this one and this one and this one or perhaps this one.

 

HTH

Link to comment
Share on other sites

I'm just wondering if anyone knows of a way to increase the price of multiple items by a percentage or set figure?  I have a store database with about 400 items that need an upadate on pricing. I am hoping there might be a way to do this all at once without having to update each product individually.

Thanks,

 

Chad

 

Change them with a SQL statement. To increase all prices by 10%, the syntax (using phpMyAdmin) is UPDATE 'products' SET 'products_price' = 'products_price' *1.1;

 

You can change individual prices by adding WHERE 'product_id' = NNN.

 

 

 

HTH

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...