As you build your store using Zen Cart, your total number of products will. In the beginning you can make price changes to all your products easily. As the number of products grows, however, making a price update across all products will be extremely tedious and take a long time.

Making a price adjustment for all your products at once must be done by accessing the database directly. You will need to access the database using a tool like phpMyAdmin, which is found in your cPanel dasbhboard. Follow the instructions below as we demonstrate how to make a mass price increase or decrease for your Zen Cart store using phpMyAdmin.

How to perform a bulk price update for Zen Cart using phpMyAdmin.

  1. Log into your cPanel dashboard.
  2. Next, find your Databases category and click on the phpMyAdmin tool icon.
    click phpmyadmin icon
  3. This leads to the the phpMyAdmin dashboard. From here, locate the database for your Zen Cart installation from the left sidebar. Clicking on the database name will connect the phpMyAdmin to that database so you can work with the tables. In our example, the database name is zenc593.
    select datacase from list
  4. After clicking on the database name, the right hand panel displays the list of tables for your ZenCart database. Look above the list and you will see a set of tabs. From here, click on the tab labeled SQL.
    click on SQL tab
  5. This leads you to the SQL Query constructor. Here is where you will create the SQL query to make the price adjustments. The table and column you will be editing is the zen_products and products_price, respectively. Listed below are a few samples that show price increases and decreases done by either a specific amount or a percentage.

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

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

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

    Sample code to decrease all prices by ten percent (10%)
    UPDATE zen_products SET products_price = products_price*.90
  6. Once you enter the query code, click on the Go button in the lower right hand corner to activate the command and make the price change for the products.
    enter query and click go button
  7. Once the change is sucessful, you will be presented with a success message at the top of the page. This means prices are now adjusted as desired. As you can see below, we have a before and after shot below showing the effects of the sql query. In our case, we decreased the price by 10%.
     prices before adjustment  prices adter the adjustment


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

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

Did you find this article helpful?

Post a Comment

Email Address:
Phone Number:

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

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!
Need More Help?

Help Center Search

Current Customers

Email: Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

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

Not a Customer?

Get web hosting from a company that is here to help.