Community Add-Ons

Some minor changes

The previous versions had a bug. They were working, but when you were clicking to sort the products by short description you were getting an error by mysql because the creator didn't thought that the short desc will be clickable to sort the products.. So i made the correction..

Find this :
case 'PRODUCT_LIST_INFO':
$listing_sql .= "pd.products_info ". ($sort_order == 'd' ? 'desc' : '');
break;

Replace with this :
case 'PRODUCT_LIST_INFO':
$listing_sql .= " order by pd.products_info " . ($sort_order == 'd' ? 'desc' : '');
break;

This is a full package, i included also the short desc for shopping cart and for specials.php

Thank you all! :)

Finally i did myself.. I think it can be better, but anyway it works.. You can see it in action here : https://www.turbosim.gr/oscommerce/specials.php

It adds the short description in the specials.php

Hi, i am not a developer, it is just s small change to shopping_cart.php to add the short description..

PS: If anybody can add the short description in specials.php it would be great. Thank you guys!:)

Eingedeutschte Installationsanleitung mit eindeutigerer Anweisung.

Without spelling mistake on the word "always"
:-)

In the precedent version, on the produtc_info.php page, the short description field is'nt call from the data base, so, the field content is'nt display in product-info.php.

####[ ALAWAYS IN ]##################################################################

products_info.php

####[ FIND ]#########################################################

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");



####[ REPLACE WITH ]##########################################################

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, pd.products_info, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

#####END Le Monolecte####

##############################################################################

Missing column heading on category listings

in includes/languages/english/index.php

add

define('TABLE_HEADING_INFO', 'Short Description');

The short description won't show in products_info.php

There is an entry missing


at products_info.php
***Search for (I have it on Line 72):

$product_info_query = tep_db_query("select p.products_id, pd.products_name,


***Add After:
pd.products_info,

I made the suggested changes and it worked great but I did have to make some additional changes that were missed:
-Brief Description was not listed on Product_Info.php
-The column heading in Advanced_Search.php, read TABLE_HEADER_INFO.
-The Text_Area for Brief Desciption in the Admins Categories.php was way to big, 15 rows, I reduced it to two.

This module will add a short description of the product when listing products.

It is not based on the product description field of the products_description table.
This module makes an extra field!!

It is compatible with OSC2.2MS2.

UPDATE categories.php

This module will add a short description of the product when listing products.

It is not based on the product description field of the products_description table.
This module makes an extra field!!

It is compatible with OSC2.2MS2.