{"id":567,"date":"2013-02-11T20:50:36","date_gmt":"2013-02-12T01:50:36","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2013\/02\/11\/bulk-price-change\/"},"modified":"2021-08-16T23:21:36","modified_gmt":"2021-08-17T03:21:36","slug":"bulk-price-change","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/","title":{"rendered":"How to perform a bulk price change for all products in OSCommerce"},"content":{"rendered":"

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

Performing a bulk price change in phpMyAdmin for osCommerce.<\/h2>\n
    \n
  1. Log into your cPanel<\/a> dashboard.<\/li>\n
  2. Locate your phpMyadmin<\/strong> tool icon, located in the Databases<\/em> category.
    \n    \"phpmyadmin<\/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 osCommerce installation. Click on the database name to go to the next screen. In our example, the database is named oscom73.
    \n<\/em>    \"click<\/a>\n
    <\/div>\n<\/li>\n
  4. This opens up the list of tables in the right hand panel. Click on the SQL<\/strong> tab found across the top of the table list.
    \n    \"click<\/a>\n
    <\/div>\n<\/li>\n
  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<\/code>
    \nSample code to increase all prices by a fixed price(.15)\n

    UPDATE products SET products_price = products_price*1.10<\/code>
    \nSample code to decrease all prices by ten percent (10%)<\/p>\n

    UPDATE products SET products_price = products_price*.90<\/code><\/p><\/li>\n

  6. Once you have entered the query code, click on the Go<\/strong> 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%.
    \n    \"4-enter-query\"<\/a>\n
    <\/div>\n<\/li>\n
  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.
    \n\n\n\n\n
    Before<\/th>\nAfter<\/th>\n<\/tr>\n
    \"before<\/a>\n
    <\/div>\n<\/td>\n
    		\"after<\/a>\n
    <\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    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 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":[31],"tags":[],"class_list":["post-567","post","type-post","status-publish","format-standard","hentry","category-oscommerce"],"acf":[],"yoast_head":"\nHow to perform a bulk price change for all products in OSCommerce | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"Looking for a fast way to increase all your prices by a set amount? This article will show you how to do so in phpMyAdmin\" \/>\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\/edu\/oscommerce\/bulk-price-change\/\" \/>\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 bulk price change for all products in OSCommerce | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"Looking for a fast way to increase all your prices by a set amount? This article will show you how to do so in phpMyAdmin\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/\" \/>\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-12T01:50:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-17T03:21:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/oscommerce_bulk-price-increase_01-phpmyadmin.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\/edu\/oscommerce\/bulk-price-change\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/\"},\"author\":{\"name\":\"Scott Mitchell\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\"},\"headline\":\"How to perform a bulk price change for all products in OSCommerce\",\"datePublished\":\"2013-02-12T01:50:36+00:00\",\"dateModified\":\"2021-08-17T03:21:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/\"},\"wordCount\":349,\"commentCount\":7,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/oscommerce_bulk-price-increase_01-phpmyadmin.png\",\"articleSection\":[\"OsCommerce\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/\",\"name\":\"How to perform a bulk price change for all products in OSCommerce | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/oscommerce_bulk-price-increase_01-phpmyadmin.png\",\"datePublished\":\"2013-02-12T01:50:36+00:00\",\"dateModified\":\"2021-08-17T03:21:36+00:00\",\"description\":\"Looking for a fast way to increase all your prices by a set amount? This article will show you how to do so in phpMyAdmin\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/oscommerce_bulk-price-increase_01-phpmyadmin.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/oscommerce_bulk-price-increase_01-phpmyadmin.png\",\"width\":1131,\"height\":197,\"caption\":\"phpmyadmin icon\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to perform a bulk price change for all products in OSCommerce\"}]},{\"@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 bulk price change for all products in OSCommerce | InMotion Hosting","description":"Looking for a fast way to increase all your prices by a set amount? This article will show you how to do so in phpMyAdmin","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\/edu\/oscommerce\/bulk-price-change\/","og_locale":"en_US","og_type":"article","og_title":"How to perform a bulk price change for all products in OSCommerce | InMotion Hosting","og_description":"Looking for a fast way to increase all your prices by a set amount? This article will show you how to do so in phpMyAdmin","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2013-02-12T01:50:36+00:00","article_modified_time":"2021-08-17T03:21:36+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/oscommerce_bulk-price-increase_01-phpmyadmin.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\/edu\/oscommerce\/bulk-price-change\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/"},"author":{"name":"Scott Mitchell","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed"},"headline":"How to perform a bulk price change for all products in OSCommerce","datePublished":"2013-02-12T01:50:36+00:00","dateModified":"2021-08-17T03:21:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/"},"wordCount":349,"commentCount":7,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/oscommerce_bulk-price-increase_01-phpmyadmin.png","articleSection":["OsCommerce"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/","name":"How to perform a bulk price change for all products in OSCommerce | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/oscommerce_bulk-price-increase_01-phpmyadmin.png","datePublished":"2013-02-12T01:50:36+00:00","dateModified":"2021-08-17T03:21:36+00:00","description":"Looking for a fast way to increase all your prices by a set amount? This article will show you how to do so in phpMyAdmin","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/oscommerce_bulk-price-increase_01-phpmyadmin.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/oscommerce_bulk-price-increase_01-phpmyadmin.png","width":1131,"height":197,"caption":"phpmyadmin icon"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/bulk-price-change\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to perform a bulk price change for all products in OSCommerce"}]},{"@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":{"id":31,"name":"OsCommerce","slug":"oscommerce","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/567","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=567"}],"version-history":[{"count":4,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/567\/revisions"}],"predecessor-version":[{"id":84966,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/567\/revisions\/84966"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}