When working with e-commerce programs like osCommerce, there are times when you may want or need to increase your prices. This is fine if you are working with a limited number of products, but if you have thousands of products, this can be very time consuming and tedious. By default there is no setting to add a specific dollar or percentage to all products at once. This article will demonstrate how to add a price increase (or decrease) to all products at once in your osCommerce program by using the phpMyAdmin tool within cPanel.

Performing a bulk price change in phpMyAdmin for osCommerce.

  1. Log into your cPanel dashboard.
  2. Locate your phpMyadmin tool icon, located in the Databases category.
    phpmyadmin icon
  3. Once in the phpMyAdmin dashboard, look to the left hand panel and locate the database for your osCommerce installation. Click on the database name to go to the next screen. In our example, the database is named oscom73.
    click database name
  4. This opens up the list of tables in the right hand panel. Click on the SQL tab found across the top of the table list.
    click on SQL tab
  5. You are now on the SQL Query construction screen. From here you will want to create the query that will add the price increase. Below are a couple of code samples for adding a constant amount or increasing the prices by a percentage.

    Sample code to increase all prices by fifteen cents (.15).
    UPDATE products SET products_price = products_price+0.15

    Sample code to increase all prices by ten percent (10%)
    UPDATE products SET products_price = products_price*1.10

    Sample code to decrease all prices by ten percent (10%)
    UPDATE products SET products_price = products_price*.90
  6. Once you have entered the query code, click on the Go button in the lower right hand corner. This will send the command to the database to increase the prices. Our example query will increase the prices of our products by 10%.
    4-enter-query
  7. After the query runs, you will see a success message at the top telling how many rows it changed. In our small database, it changed the prices for 28 products. Below is a before and after example of some prices using this method.
    Before After
    before price increase after price increase
Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Like this Article?
2014-01-13 2:53 pm
somehow my comment went to wrong post... it should be related to this post: Bulk price changes.
The question was if its possible to apply this command to certain items, or certain categories and not to all of the products. If it is possible, it would be great if you could point out how.

thanks again
marcelo
n/a Points
2014-04-11 11:49 am

Needing a tool to change the prices by specific dollars instead of a percentage of a product line.

n/a Points
2014-04-11 11:51 am

somehow my comment went to wrong post too... it should be related to this post: Bulk price changes.

I need change prices for each individual item to a specific dollar amount.  Not by a %.

Staff
15,484 Points
2014-04-11 2:14 pm
Hello Sheri,

Step 5 in the tutorial above shows how to make a price change using a direct price. If you want an add-on, you may to checkout Easy Populate and Products Attribute add-on. I hope this helps to provide the answer you seek.

Please let us know if you have any further questions.

regards,
Arnel c.

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

4 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!