Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help to change prices all at once?


hokage

Recommended Posts

If you are using Easy Populate, then just use Excel to change the prices and upload the changes. If you are not, the only other way I know of is to issue an update command via SQL.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

A basic update command would be

update products SET products_price="XX";

where XX is the price. If you want to do only specific categories, then you would need something more involved to compare the produtcs_to_categories table. But you really should install Easy Populate. You might say this will be the last time you have to do this, but it may not be. Then you will have to come up with new code to make your next change. EP makes all of this possible with just a few clicks.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...