Discount for Recommended/Cross Sell Products

[tino.schlegel]

To get this done, you need the Cross Sell addon and the Better Together addon

I want to offer a discount for recommended products that are linked with the Advanced cross sell addon. The Better Together Addon can do this but the discounts have to be hard coded in the Setup function in .../includes/modules/order_total/ot_better_together.php.

To discount all cross referenced products, add the following SQL query to the setup function

 function setup() {
  global $db;
  $bt_query = $db->Execute("select distinct products_id, xsell_id from " . TABLE_PRODUCTS_XSELL ); 
  while (!$bt_query->EOF) {	$this->add_prod_to_prod($bt_query->fields['products_id'], $bt_query->fields['xsell_id'], "%", 15);
  $bt_query->MoveNext();
	}
}

This is for 15% discount of the cheaper of the two items. Change discount to % and $ amount that you like.

I add a text to in /includes/templates/YOUR_TEMPLATE/templates/tpl_modules_xsell_products.php to promote the discount.

In addition I dont send customers to the shopping cart after they have added a product so that they have the chance to go to the recommended product directly.
Setting in Configuration > My Store > Display Cart After Adding Product = false

Hope this will boost sales.

You can visit my website to see how it looks like.