Community Add-Ons

Small bug fix: now when you remove a product from the catalog it's removed from the cross sell database table.

Based on Fast Easy Cross-Sell v1.2
Full Add-on

- Fedon Dimopoulos

- modified to fit with osc 2.3.1
- clean-up in language file (remove of button definition)
- german translation
- admin: the product name is shown only once and according to the admins language

if product name is saved in more than one language all the rows were shown up on admin page.

one file admin/cross_sell.php modified (lines ## 258, 259)

Corrected and improved. Now you can not cross sell the same product itself and can not add a cross sell product twice. The number of displayed cross sell products now is configurable via configuration menu -> maximum values

Rather than having to do a file merge I've pulled out the bits to edit in each file.

I've not put in line numbers as my base store is so heavily modified it'd be a waste of time but a simple find/replace will pull up all the necessary bits to change.

Install File attached.

Esta es un Traduccion al español de la Instalación de esta contribución, tomando como base la de fecha 24 Jul 2006.

Esta es una Traducción y Guia de Instalacion para Fast_easy_cross_sell (Productos Relacionados)

Estas instrucciones estan basadas en la contribucion de Eagle1 del 24 Jul 2006
http://www.oscommerce.com/community/contributions,4408/category,all/search,related

------------------------------------------------------------------------
Paso 1 Hacer Respaldo de tu Tienda

------------------------------------------------------------------------
Paso 2 En tu panel de Control de Base de Datos deberas ejecutar la Consulta SQL del Archivo cross_sell.sql
que contiene:

DROP TABLE IF EXISTS `products_cross_sell`;
CREATE TABLE IF NOT EXISTS `products_cross_sell` (
`products_cross_sell_id` int(10) NOT NULL auto_increment,
`products_id` int(10) unsigned NOT NULL default '1',
`cross_sell_id` int(10) unsigned NOT NULL default '1',
`cross_sell_sort_order` int(10) unsigned NOT NULL default '1',
PRIMARY KEY (`products_cross_sell_id`)
) TYPE=MyISAM;


--------------------------------------------------------------------------
Paso 3 en admin/includes/database_tables.php al final antes del ?> agregar:

define('TABLE_PRODUCTS_CROSS_SELL','products_cross_sell');


--------------------------------------------------------------------------
Paso 4 en admin/includes/filenames.php al final antes del ?> agregar:

define('FILENAME_CROSS_SELL_PRODUCTS','cross_sell.php');


---------------------------------------------------------------------------
Paso 5 en admin/includes/boxes/catalog.php buscar:

'<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES . '</a><br>' .

y agregar:

//*** <Cross-Sell Mod>
'<a href="' . tep_href_link(FILENAME_CROSS_SELL_PRODUCTS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_CROSS_SELL_PRODUCTS . '</a><br>' .
//*** </Cross-Sell Mod>


----------------------------------------------------------------------------
Paso 6 en admin/includes/languages/espanol.php

agregar al final antes de ?>:
//*** <Cross-Sell Mod>
define('BOX_CATALOG_CROSS_SELL_PRODUCTS', 'Productos Relacionados');
//*** </Cross-Sell Mod>



------------------------------------------------------------------------------
Paso 7 Crear el Archivo cross_sell.php en admin/includes/languages/espanol/

con el siguiente contenido:

<?php
/* $Id: cross_sell.php,v 1.10 2003/07/06 20:33:01 dgw_ Exp $
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Copyright (c) 2002 osCommerce
Released under the GNU General Public License
*/
define('HEADING_TITLE', 'Administrador de Productos Relacionados');
define('TEXT_CROSS_SELL_SEARCH', 'Porfavor busca un Producto a Relacionar');
define('TABLE_HEADING_PRODUCT_MODEL', 'Modelo');
define('TABLE_HEADING_PRODUCT_NAME', 'Nombre');
define('TABLE_HEADING_CROSS_SELL_THIS', '¿Relacionarlos?');
define('FORM_PRODUCT_MODEL_SEARCH_LEGEND', 'Busca un Modelo');
define('FORM_PRODUCT_MODEL_SEARCH', 'Buscar');
define('FORM_ADD_CROSS_SELL', 'Agregar un Producto Relacionado para:');
define('FORM_ADD_CROSS_SELL_BUTTON', 'Agragar');
define('FORM_DELETE_CROSS_SELL_BUTTON', 'Borrar');
define('TEXT_CROSS_SELL_LINK', 'Crear otro Producto Relacionado');
define('ERROR_MODEL_NOT_FOUND', 'No se Puede encontrar el Modelo:');
?>


-------------------------------------------------------------------------------
Paso 8 Buscar en Catalog/product_info.php

<?php
if ((USE_CACHE == 'true') && empty($SID)) {
echo tep_cache_also_purchased(3600);
} else {
include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
}
}
?>


Remplazar por :


<?php
//*** <Cross-Sell Mod>
if ( (USE_CACHE == 'true') && !SID) {
echo tep_cache_cross_sell_products(3600);
echo '<br />';
//*** </Cross-Sell Mod>
echo tep_cache_also_purchased(3600);
} else {
//*** <Cross-Sell Mod>
include(DIR_WS_MODULES . FILENAME_CROSS_SELL_PRODUCTS);
echo '<br />';
include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
//*** </Cross-Sell Mod>
}
}
?>


-------------------------------------------------------------------------------
Paso 9 en Catalog/includes/database_tables.php agregar al final antes del ?>:

//*** <Cross-Sell Mod>
define('TABLE_PRODUCTS_CROSS_SELL', 'products_cross_sell');
//*** </Cross-Sell Mod>


-------------------------------------------------------------------------------

Paso 10 en Catalog/includes/filenames.php agregar al final antes del ?>:

//*** <Cross-Sell Mod>
define('FILENAME_CROSS_SELL_PRODUCTS', 'cross_sell_products.php');
//*** </Cross-Sell Mod>

-------------------------------------------------------------------------------
Paso 11 en Catalog/includes/functions/cache.php agregar al final antes del ?>:


//*** <Cross-Sell Mod>
function tep_cache_cross_sell_products($auto_expire = false, $refresh = false) {
global $HTTP_GET_VARS, $language, $languages_id;
if (($refresh == true) || !read_cache($cache_output, 'cross_sell_products-' . $language . '.cache' . $HTTP_GET_VARS['products_id'], $auto_expire)) {
ob_start();
include(DIR_WS_MODULES . FILENAME_CROSS_SELL_PRODUCTS);
$cache_output = ob_get_contents();
ob_end_clean();
write_cache($cache_output, 'cross_sell_products-' . $language . '.cache' . $HTTP_GET_VARS['products_id']);
}
return $cache_output;
}
//*** </Cross-Sell Mod>
?>


--------------------------------------------------------------------------------

Paso 12 en catalog/includes/languages/espanol/product_info.php agregar al final antes del ?>:

//*** <Cross-Sell Mod>
define('TEXT_CROSS_SELL_PRODUCTS', 'Productos Relacionados:');
//*** </Cross-Sell Mod>

--------------------------------------------------------------------------------
Paso 13 por ultimo agregar en catalog/includes/modules/ el archivo "cross_sell_products.php"

I had a request to add a screenshot of the admin side, so I've added two of them to the package. This is the full package plus screenshots. So you can peek before you buy! :)

Matt

Sorry, jumped the gun a bit. Had a little naming problem. This is the full, correct package.

This osCommerce contribution makes it fast and easy to display products related to the currently-displayed product.

Features include:

Administrator side:

Administrator can easily type in product model numbers to find the product for which you want cross sells, rather than browsing page by page through potentially hundreds or thousands of products

Administrator can easily and quickly add cross sell products to that product by typing their product model numbers

Administrator can immediately see which products are already cross sells for that product

Administrator can easily and quickly delete existing cross sells per product

Tool checks if cross sell products are active before letting Administrator add them

Tool loads and works quickly because only one database table is used, product images are not displayed, and only the searched-for product is shown at one time

Catalog side:

Cross sell products display immediately, unless site caching is turned on

If site caching is turned on, it caches the cross sell products per page to reduce overhead

Thanks go to other contributions, like the X-Sells Contribution, which this is partly based on, and for which I have expanded and hopefully made simpler and more efficient to use.

Matt