Tag 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: http://addons.oscommerce.com/info/4829 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 […]

Category search box anywhere in osCommerce

There are two different types of search boxes to choose from, either a standard search box or an advanced search box with category selection. Each type uses advanced search and each has three options to choose from, a search box with a standard submit button, your site’s default search image button, or no button. Code is provided for each type of search box and each option. A picture of each search box is also included with the code snippet. Installation […]

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 […]

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 […]

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.

Decrease Page Load time in OSCommerce

Decrease Page Load time in OSCommerce

Cut Initial Page Loading times approx. 35% in OSCommerce 2.3 and OSC to CSS by letting Google host Jquery. Measured with Page Speed, a new, unmodified install of OSCommerce 2.3 on a typical DSL connection had initial page loading times of about 8.5 to 9.0 seconds. By doing nothing more than replacing the references to the main Jquery Libraries with Google API references, 3.5 seconds were whacked off the initial page load time, resulting in 5 to 5.5 second initial […]