Community Add-Ons

Version 4.0 takes this contribution to a new level. This version incorporates the functionality of version 3.3 with several requests for control in the Admin, making this the most user friendly release to date.

There are too many changes to list them all here, (they are listed in the support thread,) but some of the highlights include:
- 'Reciprocate' feature. Allows you to relate products both ways with one operation.
- CONSTANT definitions to easily change text displayed along with data fields, like Price and Quantity.
- Options to control the display in the Admin
- Code is now in a separate module file, called with an include statement from products_info.php
- An alternate module file which supports Graphical Borders 2.1 is included.

There are separate instructions for both new install and upgrade, and a User's Guide that explains the functions and options, and how to use them. And a special utility handles all the database changes at the click of a button.

In addition, for the two weeks prior to release, this version has been subjected to the scrutiny of several beta testers with varying levels of osCommerce experience. Their bug reports and comments have been invaluable.

Support for Optional Related Products, Version 4.0 is available on the Forum here:
http://forums.oscommerce.com/index.php?showtopic=251243

This version adds a fix to a long-running complaint that "Update" doesn't work.

No other functionality has been changed.

This is the complete package.

This is just the current (and correct) related_product.sql file. The complete package, with screenshots, is in the system and waiting for approval.

In the meantime, if you want to install the latest iteration of version 3.3, replace the included sql file with this one, and you shouldn't have any trouble with the install.

This version of the contribution is being discussed on the forum at: http://forums.oscommerce.com/index.php?showtopic=217953.

Made some corrections to related_products.sql.
- Two statements had an extra comma at the end.
- Two statements had my configuration_group_id instead of last_insert_id()

Use this version instead of 3.3

This is a complete package based on Version 3.2. This version adds the following options:

1) Display items in multiple rows. Helpful if many items are associated with a product.
Set in Admin Configuration. Default is 'False'.
2) User defined maximum items displayed per row. Set in Admin Configuration. Default is 3.
3) Set a maximum number of items to be displayed. Set in Admin Configuration. Default is 0.
(Setting of '0' for unlimited items.)
4) Randomize sort order. Set in Admin Configuration. Default is 'False'.

This contribution would not be possible if not for the work of others before me.

And, of course, don't forget to Back Up!

All credits goes to all the previous contributors.

I added all the updates included known to this date except the 3 updates from Tyniuz.
His updates, from 3, 11 november and 10 december 2005, I could not get to work with MS2.

Also I added the list of files that need to be changed and included the Dutch language.

This is a full package.

I just made a simple READ ME file with instalation instructions. There are no already filled files for a clean instalation.

This is the same pack as: 9 Jul 2005

But in that pack there is no description how to install this greate contribution. Now it has.

P.S: The fixes after "9 Jul 2005" are NOT included in THIS pack.

All credits goes to daniel b

There is missing file. Put in to admin/includes/classes

Only admin side update for better navigation for big amount of products. Working on snapshot and 2.2ms2. Just one file. Please use update before for full version.

Only admin side update for better navigation for big amount of products. Working on 20050630 snapshot.

thanks genius8237 for the fix, unfortunatly for me. because I am using the STOCK formatting, the fix would cause my right column to drop near the footer.

moved the last "}" to go after the last echo for the contrib.


NOT FULL PACKAGE

After i installed the contib, it would display every product even though it had no related products. Simple change in product_info.php.

NOT FULL PACKAGE, FIX ONLY!

fix clean installation, now the contribution is working.

install full module and place following code in product_info.php

<?php
// DANIEL: begin - show related products
$attributes = "select pop_products_id_slave, products_name, products_price, products_tax_class_id, products_image from " . TABLE_PRODUCTS_OPTIONS_PRODUCTS . ", " . TABLE_PRODUCTS_DESCRIPTION . " pa, ". TABLE_PRODUCTS . " pb WHERE pop_products_id_slave = pa.products_id and pa.products_id=pb.products_id and language_id = '" . (int)$languages_id . "' and pop_products_id_master = '".$HTTP_GET_VARS['products_id']."' and products_status=1 order by pop_order_id, pop_id";
$attribute_query = tep_db_query($attributes);

echo '<tr><td><table class="productlisting" border="0" cellspacing="0" cellpadding="2" width="100%">';
echo '<tr><td align="center" class="productListing-heading" > '.TEXT_RELATED_PRODUCTS.' </td></tr><tr><td align="center" class="productListing-data">';
echo '<table border="0" cellspacing="0" cellpadding="2" width="100%" align="center"><Tr>';
if (mysql_num_rows($attribute_query)>0) {
while ($attributes_values = tep_db_fetch_array($attribute_query)) {
$products_name_slave = ($attributes_values['products_name']);
$products_id_slave = ($attributes_values['pop_products_id_slave']);
if ($new_price = tep_get_products_special_price($products_id_slave)) {
$products_price_slave = $currencies->display_price($new_price, tep_get_tax_rate($attributes_values['products_tax_class_id']));
} else {
$products_price_slave = $currencies->display_price($attributes_values['products_price'], tep_get_tax_rate($attributes_values['products_tax_class_id']));
}

// show thumb image if Enabled
echo '<td class="productListing-data" align="center">';
if (MODULE_RELATED_PRODUCTS_SHOW_THUMBS!='False') {
echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_id_slave) . '">' . tep_image(DIR_WS_IMAGES . $attributes_values['products_image'], $attributes_values['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"').'</a>';
}
echo '<Br> <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_id_slave) . '">'.$products_name_slave.'<Br>@ '.$products_price_slave.'</a>';
}
echo '</td>';
}
echo '</tr></table></td></tr></table></td></tr>';
//DANIEL: end
?>

attachment is just product_info.php file.. install package first

change: thumbnails images for related products added
change: access button directly from Admin/catalog/Categories for
better administration
change: small improvements & enhancements to code & layout and content
Enjoy!-)

change: listbox to view related items to particular product
change: inherit 'related products' from another product
bugfix: incorrect product price when special

Enjoy!-)
http://digitalcamerasales.com.au

Manage relationships between your products to help customers find related products. Quick install, easy to use, helpful to your customers. This is something you must have!-)

ENjOY!-)

daniel b
http://gandvimaging.com.au