Category Archives: Oscommerce

Rename Product Image in SQL Query Oscommerce


How to Rename Product Image in SQL Query in osCommerce. In Oscommerce it is simple to rename the product image in sql query. IN the below is the simple script to sove this require(‘includes/application_top.php’);  $products_query = tep_db_query(“select * from products”);  while ($products_values = tep_db_fetch_array($products_query)) {   $products_id = $products_values[‘products_id’]; $products_image = $products_values[‘products_image’]; $image = $products_image.’.jpg’; //echo $image; //echo $products_id; //echo $products_image; $sql = “update products set products_image = ‘” .$image .”‘ where products_id = ‘” . (int)$products_id . “‘”; $update_query […]

Manual Order Maker tep_get_address_format_id error fix

when I choose create order -> I can select a customer (or create a new one..) but when I hit the save button I get the following error message: Fatal error: Call to undefined function tep_get_address_format_id() in /xxx/xxx/xxxxx/catalog/admin/create_order_process.php on line 42 Here is line 42 of my create_order_process.php: $format_id = tep_get_address_format_id($country_id); Contribution link: Here is fix solution: Change this line: tep_get_address_format_id($country_id); To this: $format_id = “1”; /////////////////////// To complete this fix you would need to copy the function “tep_get_address_format_id” […]

Order Editor tep_add_base_ref AJAX ERROR FIX – osCommerce


Fatal error: Call to undefined function tep_add_base_ref() in /home/XXXX/public_html/XXXX/admin/edit_orders_ajax.php on line 1149 For those who have this problem:add below code to admin/include/function/general.php before closing tag ?> function tep_add_base_ref($string) { $i = 0; $output = ”; $n=strlen($string); for ($i=0; $i<$n; $i++) { $char = substr($string, $i, 1); $char5 = substr($string, $i, 5); if ($char5 == ‘src=”‘ ) {$output .= ‘src=”‘ . HTTP_SERVER; $i = $i+4;} else { $output .= $char; } } return $output; } /////////////////////////////////////////// You are done! Thank you […]

Gift Voucher in osCommerce


Hello I am going to tell you how to use Gift Voucher in osCommerce. First install Credit Class & Gift Voucher module. Creating a gift voucher for a customer to buy is the same as creating a new product with the exception that the gift vouchers model number must start with the word GIFT in upper case. It can be GIFT_25, GIFT_50, GIFT_100 or GIFT25, GIFT50, GIFT100 or whatever you would like to use. Gift certificate images have been provide […]

How to add a new Page to Oscommerce 2.3

In this Article I help you to create a new page in oscommerce 2.3.1, oscommerce 2.3.2, oscommerce 2.3.3 . Its very easy to create a new page in oscommerce 2.3. In below we discuss how create new page. 1. catalog/includes/modules/boxes/bm_information.php Copy the line – ‘<a href="’ . tep_href_link(FILENAME_PRIVACY) . ‘">’ . MODULE_BOXES_INFORMATION_BOX_PRIVACY . ‘</a><br />’ . Insert and change the words privacy to your text Save edited bm_information.php . catalog/includes/languages/english/modules/boxes/bm_information.php Copy the line – define(‘MODULE_BOXES_INFORMATION_BOX_PRIVACY’, ‘Privacy Notice’); Insert and change […]

Best Practice For ECommerce Websites

The web design industry has witnessed so many changes and advancements. Undoubtedly, these changes have been positive, in most cases, and they have made the web experience much easier and convenient. Now, getting to the main point, we all know that almost all businesses are offering services to buy/sell products online. This whole selling and buying procedure is commonly referred as eCommerce. Now, if you plan to have an eCommerce website, you should do a good research on it because […]

Lightbox for Product Listings

Add a JQuery Lightbox to the OSCommerce OSC to CSSv2 product listings. Products listing: Demo New Products listing: Demo Add a extra field the products table in the database. ALTER TABLE `products` ADD `products_image_large` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `products_image_list` Make two sets of all your product images. One set should be about 100px by 100px, and another set about 300px by 300px. You probably already have a set of small images in […]

Add Google Analytics to Oscommerce Store

I just saw an other forum post in the osCommerce forum, asking how to add google analytics to a osCommerce store. Adding google analytics to your osCommerce store became in version 2.3.1 a very easy process. There are no files to edit or any code to add to anywhere. All you have to do is to install the module in your administration panel. Let’s take things from the beginning and step by step, there are actually just to steps to […]

SEO Friendly Titles on Product and Index Pages


Here is a simple one step method to add SEO Friendly titles to the product pages, category listing and the main page of OSCommerce. use for OSCommerce versions: 2.2rc2a and 2.3 To have the product name as the title on the product page, open product_info.php. Between the head tags find: <title><?php echo TITLE; ?></title> change to: <title><?php echo $product_info[‘products_name’]; ?></title> That’s it. Demo To add the category name to the category listings on index.php (main page): Open index.php find: } […]

Increase OSCommerce Performance


Dramatically Increase OSCommerce Performance with ‘Pagespeed’ on Firefox. Recommended in Google’s Webmaster Tools, Pagespeed will quickly and easily analyze your site’s performance. More importantly, this analysis will also give you the exact reasons why your site performs as it does, list out the specific steps you can do to improve it AND gives you the tools to do it plus the links to understand what you are doing.