When building an online store and using programs such as Zen Cart, the number of products you carry can increase exponentially over time. Most of the time, things like price changes will be done on an individual product level or at most small groups. However, there may be times when you need to make a price change for all products in your store. For example, you may want to have a store-wide sale, or perhaps your suppliers go up ten percent and you need to reflect that price change in your store.

Making a mass price increase is not a default behavior in Zen Cart and generally must be done by accessing the database directly. To access the database you will need a tool such as the phpMyAdmin program that is found in your cPanel account. The following tutorial will demonstrate how to make a mass price increase or decrease for your Zen Cart store using phpMyAdmin.

Performing a bulk price increase in phpMyAdmin for Zen Cart.

  1. Log into your cPanel dashboard.
  2. Look for your phpMyadmin tool icon. This is located in the Databases category of the cPanel.
    click on phpmyadmin icon
  3. Once in the phpMyAdmin dashboard, look to the left hand panel and locate the database for your Zen Cart installation. Click on the database name to go to the next screen. In this example, you can see our particular database is named zenc860.
    click on database name
  4. This opens up the list of tables in the right hand panel for your ZenCart database. Above the list is a set of tabs. Click on the tab labeled SQL to enter the SQL query constructor.
    click on sql tab
  5. Now that you are in the SQL Query construction screen you will need to add the particular query to adjust the prices. The table you will be editing is the zen_products table. The exact column you will modify is the products_price column. Below are a few samples that show price increases and decreases done by either a specific amount or a percentage.

    Sample code to decrease all prices by twenty percent (20%).
    UPDATE zen_products SET products_price = products_price*.80

    Sample code to decrease all prices by 25 cents (.25).
    UPDATE zen_products SET products_price = products_price-.25

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

    Sample code to increase all prices by ten percent (10%)
    UPDATE zen_products SET products_price = products_price*1.10
  6. After entering the query code, click on the Go button in the lower right hand corner. This will activate the command and make the price change for all products in the table.
    enter query and click go
  7. If the query is successful, you will be presented with a success message at the top of the page. Your prices are now adjusted. We have a before and after shot below showing the effects of the sql query on our ipod product as we raised the price by ten percent.
    BeforeAfter
    ipod price before adjustment ipod price after 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?

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.

News / Announcements

WordPress wp-login.php brute force attack
Updated 2014-07-17 06:43 pm EST
Hits: 201703

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

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!