{"id":569,"date":"2013-02-12T17:50:05","date_gmt":"2013-02-12T17:50:05","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2013\/02\/12\/mass-price-adjustment\/"},"modified":"2021-08-16T23:21:35","modified_gmt":"2021-08-17T03:21:35","slug":"mass-price-adjustment","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/","title":{"rendered":"How to perform a mass price increase for all products in Zen Cart."},"content":{"rendered":"

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.<\/p>\n

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.<\/p>\n

Performing a bulk price increase in phpMyAdmin for Zen Cart.<\/h2>\n
    \n
  1. Log into your cPanel<\/a> dashboard.<\/li>\n
  2. Look for your phpMyAdmin<\/strong> tool icon. This is located in the Databases<\/em> category of the cPanel.
    \n    \"click<\/a>\n
    <\/div>\n<\/li>\n
  3. Once in the phpMyAdmin<\/em> 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<\/em>.
    \n    \"click<\/a>\n
    <\/div>\n<\/li>\n
  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<\/strong> to enter the SQL query constructor.
    \n    \"click<\/a>\n
    <\/div>\n<\/li>\n
  5. Now that you are in the SQL Query<\/em> construction screen you will need to add the particular query to adjust the prices. The table you will be editing is the zen_products<\/em> table. The exact column you will modify is the products_price<\/em> 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<\/code>
    \nSample code to decrease all prices by 25 cents (.25).\n

    UPDATE zen_products SET products_price = products_price-.25<\/code>
    \nSample code to increase all prices by fifteen cents (.15).<\/p>\n

    UPDATE zen_products SET products_price = products_price+0.15<\/code>
    \nSample code to increase all prices by ten percent (10%)<\/p>\n

    UPDATE zen_products SET products_price = products_price*1.10<\/code><\/p><\/li>\n

  6. After entering the query code, click on the Go<\/strong> button in the lower right hand corner. This will activate the command and make the price change for all products in the table.
    \n    \"enter<\/a>\n
    <\/div>\n<\/li>\n
  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.
    \n\n\n\n\n
    Before<\/th>\nAfter<\/th>\n<\/tr>\n
    \"ipod<\/a>\n
    <\/div>\n<\/td>\n
    		\"ipod<\/a>\n
    <\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    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 Read More ><\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4288],"tags":[],"class_list":["post-569","post","type-post","status-publish","format-standard","hentry","category-website"],"acf":[],"yoast_head":"\nHow to perform a mass price increase for all products in Zen Cart. | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"Want to make a mass price adjustment to all products in your Zen Cart store? Learn how to do it with SQL in the phpMyAdmin tool in your cpanel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to perform a mass price increase for all products in Zen Cart. | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"Want to make a mass price adjustment to all products in your Zen Cart store? Learn how to do it with SQL in the phpMyAdmin tool in your cpanel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-12T17:50:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-17T03:21:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_cPanel_phpMyAdminIcon_highlight.png\" \/>\n<meta name=\"author\" content=\"Scott Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Scott Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/\"},\"author\":{\"name\":\"Scott Mitchell\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\"},\"headline\":\"How to perform a mass price increase for all products in Zen Cart.\",\"datePublished\":\"2013-02-12T17:50:05+00:00\",\"dateModified\":\"2021-08-17T03:21:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/\"},\"wordCount\":464,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_cPanel_phpMyAdminIcon_highlight.png\",\"articleSection\":[\"Website\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/\",\"name\":\"How to perform a mass price increase for all products in Zen Cart. | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_cPanel_phpMyAdminIcon_highlight.png\",\"datePublished\":\"2013-02-12T17:50:05+00:00\",\"dateModified\":\"2021-08-17T03:21:35+00:00\",\"description\":\"Want to make a mass price adjustment to all products in your Zen Cart store? Learn how to do it with SQL in the phpMyAdmin tool in your cpanel.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_cPanel_phpMyAdminIcon_highlight.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_cPanel_phpMyAdminIcon_highlight.png\",\"width\":830,\"height\":431,\"caption\":\"click on phpmyadmin icon\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to perform a mass price increase for all products in Zen Cart.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support & Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\",\"name\":\"Scott Mitchell\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to perform a mass price increase for all products in Zen Cart. | InMotion Hosting","description":"Want to make a mass price adjustment to all products in your Zen Cart store? Learn how to do it with SQL in the phpMyAdmin tool in your cpanel.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/","og_locale":"en_US","og_type":"article","og_title":"How to perform a mass price increase for all products in Zen Cart. | InMotion Hosting","og_description":"Want to make a mass price adjustment to all products in your Zen Cart store? Learn how to do it with SQL in the phpMyAdmin tool in your cpanel.","og_url":"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2013-02-12T17:50:05+00:00","article_modified_time":"2021-08-17T03:21:35+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_cPanel_phpMyAdminIcon_highlight.png","type":"","width":"","height":""}],"author":"Scott Mitchell","twitter_card":"summary_large_image","twitter_creator":"@InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Scott Mitchell","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/"},"author":{"name":"Scott Mitchell","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed"},"headline":"How to perform a mass price increase for all products in Zen Cart.","datePublished":"2013-02-12T17:50:05+00:00","dateModified":"2021-08-17T03:21:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/"},"wordCount":464,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_cPanel_phpMyAdminIcon_highlight.png","articleSection":["Website"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/","url":"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/","name":"How to perform a mass price increase for all products in Zen Cart. | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_cPanel_phpMyAdminIcon_highlight.png","datePublished":"2013-02-12T17:50:05+00:00","dateModified":"2021-08-17T03:21:35+00:00","description":"Want to make a mass price adjustment to all products in your Zen Cart store? Learn how to do it with SQL in the phpMyAdmin tool in your cpanel.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_cPanel_phpMyAdminIcon_highlight.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_cPanel_phpMyAdminIcon_highlight.png","width":830,"height":431,"caption":"click on phpmyadmin icon"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/mass-price-adjustment\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to perform a mass price increase for all products in Zen Cart."}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support & Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed","name":"Scott Mitchell","url":"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=569"}],"version-history":[{"count":4,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/569\/revisions"}],"predecessor-version":[{"id":84962,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/569\/revisions\/84962"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}