[Contribution] Cross Sell (X-Sell) Admin

mbttechnology · February 21, 2003

Need some help I got the admin section working but when I look in the catalog area nothing shows up. Thanks for any help that can be provided

gdfwilliams · February 21, 2003

Imporvements to the admin layout for X-Sell:

Just replace your admin/xsell_products.php with this.

Per usual, BACKUP!

<?php

/*

 $Id$



 osCommerce, Open Source E-Commerce Solutions

 http://www.oscommerce.com



 Copyright (c) 2002 osCommerce



 Released under the GNU General Public License



 cross.sale.php created By Isaac Mualem im@imwebdesigning.com



 Modified by Andrew Edmond (osc@aravia.com)

 Sept 16th, 2002

*/



 require('includes/application_top.php');



 require(DIR_WS_CLASSES . 'currencies.php');

 $currencies = new currencies();



?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<title><? echo TITLE; ?></title>



<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">

<script language="JavaScript1.2">



function cOn(td)

{

 if(document.getElementById||(document.all && !(document.getElementById)))

 {

   td.style.backgroundColor="#CCCCCC";

 } 

}



function cOnA(td)

{

 if(document.getElementById||(document.all && !(document.getElementById)))

 {

   td.style.backgroundColor="#CCFFFF";

 }

}



function cOut(td)

{

 if(document.getElementById||(document.all && !(document.getElementById)))

 {

   td.style.backgroundColor="DFE4F4";

 }

}

</script>

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">

<!-- header //-->

<? include(DIR_WS_INCLUDES . 'header.php');  ?>

<!-- header_eof //-->





<table border="0" width="100%" cellspacing="2" cellpadding="2">

 <tr>

   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

   </table></td>

<!-- body_text //-->

   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

     <tr>

       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">

         <tr>

           <td class="pageHeading"><?php echo "Cross-Sell (X-Sell) Admin"; ?></td>

           <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

         </tr>

       </table></td>

    </tr>

  

<!-- body_text //-->

   <td width="100%" valign="top"> 

     <!-- Start of cross sale //-->



     <table width="100%" border="0" cellpadding="0"  cellspacing="0">

       <tr><td align=center>

       <?php

/* general_db_conct($query) function */

/* calling the function:  list ($test_a, $test_b) = general_db_conct($query); */

function general_db_conct($query_1)

{

  $result_1 = tep_db_query($query_1);

    $num_of_rows = mysql_num_rows($result_1);

  for ($i=0;$i<$num_of_rows;$i++)

  {

    $fields = mysql_fetch_row($result_1);

    $a_to_pass[$i]= $fields[$y=0];

    $b_to_pass[$i]= $fields[++$y];

        $c_to_pass[$i]= $fields[++$y];

    $d_to_pass[$i]= $fields[++$y];

    $e_to_pass[$i]= $fields[++$y];

    $f_to_pass[$i]= $fields[++$y];

    $g_to_pass[$i]= $fields[++$y];

    $h_to_pass[$i]= $fields[++$y];

    $i_to_pass[$i]= $fields[++$y];

    $j_to_pass[$i]= $fields[++$y];

    $k_to_pass[$i]= $fields[++$y];

    $l_to_pass[$i]= $fields[++$y];

    $m_to_pass[$i]= $fields[++$y];

    $n_to_pass[$i]= $fields[++$y];

    $o_to_pass[$i]= $fields[++$y];

  }

return array($a_to_pass,$b_to_pass,$c_to_pass,$d_to_pass,$e_to_pass,$f_to_pass,$g_to_pass
,$h_to_pass,$i_to_pass,$j_to_pass,$k_to_pass,$l_to_pass,$m_to_pass,$n_to_pass,$o_
to_pass);

}//end of function	



       // first major piece of the program

       // we have no instructions, so just dump a full list of products and their status for cross selling	



if (!$add_related_product_ID )

{

       $query = "select a.products_id, b.products_name, b.products_description, " .

                "a.products_quantity, a.products_model, a.products_image, " .

                "b.products_url, a.products_price from products a, products_description b where b.products_id = a.products_id order by b.products_name";

list ($PRODUCTS_id, $PRODUCTS_name, $PRODUCTS_description  , $PRODUCTS_quantity  , $PRODUCTS_model  , $PRODUCTS_image  , $PRODUCTS_url  , $PRODUCTS_price  ) = general_db_conct($query);

?>

   

           <table border="0" cellspacing="1" cellpadding="2" bgcolor="#999999">

             <tr class="dataTableHeadingRow"> 

               <td class="dataTableHeadingContent" nowrap>ID</td>

               <td class="dataTableHeadingContent">Product Name</td>

               <td class="dataTableHeadingContent" nowrap>Cross Items</td>

               <td class="dataTableHeadingContent" colspan=3 nowrap>Cross Sell Actions</td>

             </tr>

              <?php 

     $num_of_products = sizeof($PRODUCTS_id);

   for ($i=0; $i < $num_of_products; $i++)

  	 {

  	 /* now we will query the DB for existing related items */

$query = "select b.products_name, a.xsell_id from " . TABLE_PRODUCTS_XSELL . " a, products_description b WHERE b.products_id = a.xsell_id and a.products_id ='".$PRODUCTS_id[$i]."' ORDER BY sort_order";

  	 list ($Related_items, $xsell_ids) = general_db_conct($query);

  	 

  	 echo "<tr onMouseOver="cOn(this);" onMouseOut="cOut(this);" bgcolor='#DFE4F4'>";

  	 echo "<td class="dataTableContent" valign="top"> ".$PRODUCTS_id[$i]." </td>n";

  	 echo "<td class="dataTableContent" valign="top"> ".$PRODUCTS_name[$i]." </td>n";

  	 if ($Related_items)

  	 {

        echo "<td  class="dataTableContent"><ol>";

      foreach ($Related_items as $display)

    	 echo '<li>'. $display .' ';

     echo"</ol></td>n";

     }

  	 else

     echo "<td class="dataTableContent">--</td>n";

  	 echo '<td class="dataTableContent"  valign="top"> <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'add_related_product_ID=' . $PRODUCTS_id[$i], 'NONSSL') . '">Add</a> </td><td class="dataTableContent" valign="top"> <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'add_related_product_ID=' . $PRODUCTS_id[$i], 'NONSSL') . '">Remove</a> </td>';

      	 

  	 if (count($Related_items)>1)

  	 {

      echo '<td class="dataTableContent" valign="top"> <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'sort=1&add_related_product_ID=' . $PRODUCTS_id[$i], 'NONSSL') . '">Sort</a> </td>';

  	 } else {

     echo "<td class="dataTableContent" valign=top align=center>--</td>";

     }

  	 echo "</tr>n";

  	 unset($Related_items);

  	 }

   ?>

   

           </table> 

           <?

	 }	// the end of -> if (!$add_related_product_ID)

	 

if ($_POST && !$sort)

{

    if ($_POST[run_update]==true)

  {

    $query ="DELETE FROM " . TABLE_PRODUCTS_XSELL . " WHERE products_id = '".$_POST[add_related_product_ID]."'";

    if (!tep_db_query($query))

 exit('could not delete');

  }

  if ($_POST[xsell_id])

 foreach ($_POST[xsell_id] as $temp)

    {

    $query = "INSERT INTO " . TABLE_PRODUCTS_XSELL . " VALUES ('',$_POST[add_related_product_ID],$temp,1)";

    if (!tep_db_query($query))

 exit('could not insert to DB');

  }

  echo '<a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL') . '">Click Here to add a new cross sale</a><br>' . "n";

  if ($_POST[xsell_id])

 echo '<a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'sort=1&add_related_product_ID=' . $_POST[add_related_product_ID], 'NONSSL') . '">Click here to sort (top to bottom) the added cross sale</a>' . "n";

}

 

       if ($add_related_product_ID && ! $_POST && !$sort)	

{	?>	

   <table border="0" cellpadding="2" cellspacing="1" bgcolor="#999999">

             <form action="<?php tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL'); ?>" method="post">

               <tr class="dataTableHeadingRow"> 

<?php



       $query = "select a.products_id, b.products_name, b.products_description, " .

                "a.products_quantity, a.products_model, a.products_image, " .

                "b.products_url, a.products_price from products a, products_description b where b.products_id = a.products_id and a.products_id = '".$add_related_product_ID."'";

	 list ($PRODUCTS_id, $PRODUCTS_name, $PRODUCTS_description  , $PRODUCTS_quantity  , $PRODUCTS_model  , $PRODUCTS_image  , $PRODUCTS_url  , $PRODUCTS_price  ) = general_db_conct($query); 

?>



                 <td class="dataTableHeadingContent"> </td>

                 <td class="dataTableHeadingContent" nowrap>Item #</td>

                 <td class="dataTableHeadingContent">Item Name</td>

                 <td class="dataTableHeadingContent">$Price</td>

               </tr>



               <? 



       $query = "select a.products_id, b.products_name, b.products_description, " .

                "a.products_quantity, a.products_model, a.products_image, " .

                "b.products_url, a.products_price from products a, products_description b where b.products_id = a.products_id and a.products_id != '".$add_related_product_ID."' order by b.products_name";



	 list ($PRODUCTS_id, $PRODUCTS_name, $PRODUCTS_description  , $PRODUCTS_quantity  , $PRODUCTS_model  , $PRODUCTS_image  , $PRODUCTS_url  , $PRODUCTS_price  ) = general_db_conct($query); 

   $num_of_products = sizeof($PRODUCTS_id);

   $query = "select * from " . TABLE_PRODUCTS_XSELL . " WHERE products_id = '".$add_related_product_ID."'";

     list ($ID_PR, $PRODUCTS_id_PR, $xsell_id_PR) = general_db_conct($query); 

  	 for ($i=0; $i < $num_of_products; $i++)

  	 {

  	 ?><tr bgcolor='#DFE4F4'>

     <td class="dataTableContent">

  	 

  	 <input <?php /* this is to see it it is in the DB */

     $run_update=false; // set to false to insert new entry in the DB

     if ($xsell_id_PR) foreach ($xsell_id_PR as $compare_checked)if ($PRODUCTS_id[$i]===$compare_checked) {echo "checked"; $run_update=true;} ?> size="20"  size="20"  name="xsell_id[]" type="checkbox" value="<?php echo $PRODUCTS_id[$i]; ?>"></td>

  	 

  	 <? echo "<td  class="dataTableContent" align=center>".$PRODUCTS_id[$i]."</td>n"

     ."<td class="dataTableContent">".$PRODUCTS_name[$i]."</td>n"

     ."<td class="dataTableContent">".$currencies->display_price($PRODUCTS_price[$i], tep_get_tax_rate($product_info_values['products_tax_class_id']))."</td></tr>n";

  	 }?>

  	 <tr> 

                 <td colspan="4">

     

      <input type="hidden" name="run_update" value="<?php if ($run_update==true) echo "true"; else echo "false" ?>">

     <input type="hidden" name="add_related_product_ID" value="<?php echo $add_related_product_ID; ?>">

                   <input type="submit" name="Submit" value="Submit"></td>

               </tr>

             </form>

           </table>	

 <? } 



       // sort routines

if ($sort==1)

{ 

//	first lets take care of the DB update.

    $run_once=0;

  if ($_POST)

 foreach ($_POST as $key_a => $value_a)

  {

 tep_db_connect();

 $query = "UPDATE " . TABLE_PRODUCTS_XSELL . " SET sort_order = '".$value_a."' WHERE xsell_id= '$key_a' ";

 //$query ="DELETE FROM " . TABLE_PRODUCTS_XSELL . " WHERE products_id = '".$key_a."'";

 if ($value_a != 'Update')

	 if (!tep_db_query($query))

   exit('could not UPDATE DB');

	 else 

   if ($run_once==0)

   {

  	 echo '<b>The Database was updated <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL') . '">Click here to back to the main page</a></b><br>' . "n";

  	 $run_once++;

   }

   

}// end of foreach.

?>

<form method="post" action="<?php tep_href_link(FILENAME_XSELL_PRODUCTS, 'sort=1&add_related_product_ID=' . $add_related_product_ID, 'NONSSL'); ?>">

             <table cellpadding="2" cellspacing="1" bgcolor=999999 border="0">

               <tr class="dataTableHeadingRow"> 

                 <td class="dataTableHeadingContent" width="75">Product ID</td>

                 <td class="dataTableHeadingContent">Name</td>

                 <td class="dataTableHeadingContent" width="150">Price</td>

                 <td class="dataTableHeadingContent" width="150">Order (1=Top)</td>

               </tr>

   <? 

   $query = "select * from " . TABLE_PRODUCTS_XSELL . " WHERE products_id = '".$add_related_product_ID."'";

   list ($ID_PR, $PRODUCTS_id_PR, $xsell_id_PR, $order_PR) = general_db_conct($query); 

   $ordering_size =sizeof($ID_PR);

   for ($i=0;$i<$ordering_size;$i++) 

  	 {



       $query = "select a.products_id, b.products_name, b.products_description, " .

                "a.products_quantity, a.products_model, a.products_image, " .

                "b.products_url, a.products_price from products a, products_description b where b.products_id = a.products_id and a.products_id = ".$xsell_id_PR[$i]."";



  	 list ($PRODUCTS_id, $PRODUCTS_name, $PRODUCTS_description  , $PRODUCTS_quantity  , $PRODUCTS_model  , $PRODUCTS_image  , $PRODUCTS_url  , $PRODUCTS_price  ) = general_db_conct($query); 

 

  	 ?>

  	 <tr class="dataTableContentRow" bgcolor='#DFE4F4'> 

      <td class="dataTableContent"><?php echo $PRODUCTS_id[0]; ?></td>

      <td class="dataTableContent"><?php echo $PRODUCTS_name[0]; ?></td>

      <td class="dataTableContent"><?php echo $currencies->display_price($PRODUCTS_price[0], tep_get_tax_rate($product_info_values['products_tax_class_id'])); ?></td>

      <td class="dataTableContent"><select name="<?php echo $PRODUCTS_id[0]; ?>">

       <? for ($y=1;$y<=$ordering_size;$y++)

         {

       echo "<option value="$y"";

      	 if (!(strcmp($y, "$order_PR[$i]"))) {echo "SELECTED";}

      	 echo ">$y</option>";

       }

       ?>

     </select></td>

  	 </tr>

  	 <? } // the end of foreach	?>

               <tr> 

                 <td colspan="4" bgcolor='#DFE4F4'><input name="runing_update" type="submit" id="runing_update" value="Update"></td>

               </tr>

             </table>

           </form>

	 

	 <?php }?>

 

 

         </td>

       </tr>	

</table>

<!-- End of cross sale //-->

</td>

<!-- products_attributes_eof //-->

</tr></table>

<!-- body_text_eof //-->

<!-- footer //-->

<? include(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

<br>

</body>

</html>

<? include(DIR_WS_INCLUDES . 'application_bottom.php');?>

Please test and let me know if I can make any additional improvements.

Thanks,

Greg

mbttechnology · February 21, 2003

I think what you have done looks great. The problem I am having is that in the admin section I can cross ref the products but nothing shows up on the catalog page.

Thanks

Lee

Waza04 · February 21, 2003

Works brilliant and better!

Thanks

gdfwilliams · February 21, 2003

Lee -

You're calling the X-Sell include from catalog/product_info.php, right?

mbttechnology · February 21, 2003

yes i am. I installed the Cross-Sell (XSell) Module according to the directions

Thanks

mbttechnology · February 21, 2003

yes i am. I installed the Cross-Sell (XSell) Module according to the directions

Thanks

dreamscape · February 21, 2003

and i went to your example site and didn't notice a differnce with the items that were using cross-sell.. is there somewhere I could see exactly what this looks like? :D

I have installed it on my site and my site is onlne. you can see it on this page (scroll down to the "related products")... I've modified mine though, so this is NOT what it looks like stock:

http://www.allthingsnewage.com/product_inf...products_id=130

February 24, 2003

I set up a demo cat with the cross sell (xsell) mod and the admin.

It is at http://www.prosynergysales.com/democat/default.php

the admin is at

http://www.prosynergysales.com/democat/admin

I will leave it up for a few weeks then I will zip the cat and the admin sides together and release for everyone's ease.

I tend to get busy a lot this time of year with school and what now so I will not be prompt about returning e-mails and PMs just so you know.

Michael D. · February 28, 2003

Hi ,

I got a Problem with the admin...

The Admin shows all Products twice , once for german and once for english... (same Product ID)

if I add one ... it also shows two entries for each Product ID under "cross items"

... is that for a reason?

Michael D. · February 28, 2003

Ok here is the fix if anyone with the same problem...

I dont know if its good... but its working :wink:

Try it by just replacing the old xsell_products.php

Dont forget to BACKUP! Have fun.

<?php 

/* 

 $Id$ 



 osCommerce, Open Source E-Commerce Solutions 

 http://www.oscommerce.com 



 Copyright (c) 2002 osCommerce 



 Released under the GNU General Public License 



 cross.sale.php created By Isaac Mualem im@imwebdesigning.com 



 Modified by Andrew Edmond (osc@aravia.com) 

 Sept 16th, 2002 



 add: Multi Languages Fix, 02/28/2003

         (mail@michaelding.net)

*/ 



 require('includes/application_top.php'); 



 require(DIR_WS_CLASSES . 'currencies.php'); 

 $currencies = new currencies(); 





?> 

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> 

<html <?php echo HTML_PARAMS; ?>> 

<head> 

<title><? echo TITLE; ?></title> 



<link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> 

<script language="JavaScript1.2"> 



function cOn(td) 

{ 

 if(document.getElementById||(document.all && !(document.getElementById))) 

 { 

   td.style.backgroundColor="#CCCCCC"; 

 } 

} 



function cOnA(td) 

{ 

 if(document.getElementById||(document.all && !(document.getElementById))) 

 { 

   td.style.backgroundColor="#CCFFFF"; 

 } 

} 



function cOut(td) 

{ 

 if(document.getElementById||(document.all && !(document.getElementById))) 

 { 

   td.style.backgroundColor="DFE4F4"; 

 } 

} 

</script> 

</head> 

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> 

<!-- header //--> 

<? include(DIR_WS_INCLUDES . 'header.php');  ?> 

<!-- header_eof //--> 





<table border="0" width="100%" cellspacing="2" cellpadding="2"> 

 <tr> 

   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> 

<!-- left_navigation //--> 

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> 

<!-- left_navigation_eof //--> 

   </table></td> 

<!-- body_text //--> 

   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> 

     <tr> 

       <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> 

         <tr> 

           <td class="pageHeading"><?php echo "Cross-Sell (X-Sell) Admin"; ?></td> 

           <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> 

         </tr> 

       </table></td> 

    </tr> 

   

<!-- body_text //--> 

   <td width="100%" valign="top"> 

     <!-- Start of cross sale //--> 



     <table width="100%" border="0" cellpadding="0"  cellspacing="0"> 

       <tr><td align=center> 

       <?php 

  /* general_db_conct($query) function */ 

  /* calling the function:  list ($test_a, $test_b) = general_db_conct($query); */ 

  function general_db_conct($query_1) 

  { 

    $result_1 = tep_db_query($query_1); 

      $num_of_rows = mysql_num_rows($result_1); 

    for ($i=0;$i<$num_of_rows;$i++) 

    { 

      $fields = mysql_fetch_row($result_1); 

      $a_to_pass[$i]= $fields[$y=0]; 

      $b_to_pass[$i]= $fields[++$y]; 

          $c_to_pass[$i]= $fields[++$y]; 

      $d_to_pass[$i]= $fields[++$y]; 

      $e_to_pass[$i]= $fields[++$y]; 

      $f_to_pass[$i]= $fields[++$y]; 

      $g_to_pass[$i]= $fields[++$y]; 

      $h_to_pass[$i]= $fields[++$y]; 

      $i_to_pass[$i]= $fields[++$y]; 

      $j_to_pass[$i]= $fields[++$y]; 

      $k_to_pass[$i]= $fields[++$y]; 

      $l_to_pass[$i]= $fields[++$y]; 

      $m_to_pass[$i]= $fields[++$y]; 

      $n_to_pass[$i]= $fields[++$y]; 

      $o_to_pass[$i]= $fields[++$y]; 

    } 

  return array($a_to_pass,$b_to_pass,$c_to_pass,$d_to_pass,$e_to_pass,$f_to_pass,$g_to_pass
,$h_to_pass,$i_to_pass,$j_to_pass,$k_to_pass,$l_to_pass,$m_to_pass,$n_to_pass,$o_
to_pass); 

  }//end of function    



       // first major piece of the program 

       // we have no instructions, so just dump a full list of products and their status for cross selling    



  if (!$add_related_product_ID ) 

  { 

      /* Multiple Language fix --- mail@michaelding.net */

 

$query =   "SELECT

               b.language_id,a.products_id, b.products_name, b.products_description,a.products_quantity, a.products_model, a.products_image,b.products_url, a.products_price 

               FROM

               products a,products_description b WHERE b.products_id = a.products_id AND b.language_id = 1

               ORDER BY a.products_id;";

   

 



   list ($LANGUAGE_id,$PRODUCTS_id, $PRODUCTS_name, $PRODUCTS_description  , $PRODUCTS_quantity  , $PRODUCTS_model  , $PRODUCTS_image  , $PRODUCTS_url  , $PRODUCTS_price  ) = general_db_conct($query); 

  

  ?> 

            

           <table border="0" cellspacing="1" cellpadding="2" bgcolor="#999999"> 

             <tr class="dataTableHeadingRow"> 

               <td class="dataTableHeadingContent" nowrap>ID</td> 

               <td class="dataTableHeadingContent">Product Name</td> 

               <td class="dataTableHeadingContent" nowrap>Cross Items</td> 

               <td class="dataTableHeadingContent" colspan=3 nowrap>Cross Sell Actions</td> 

             </tr> 

              <?php 

           $num_of_products = sizeof($PRODUCTS_id); 

           for ($i=0; $i < $num_of_products; $i++) 

              { 

              /* now we will query the DB for existing related items */ 

$query = "select b.language_id, b.products_name, a.xsell_id from " . TABLE_PRODUCTS_XSELL . " a, products_description b WHERE b.products_id = a.xsell_id and b.language_id = 1 and a.products_id ='".$PRODUCTS_id[$i]."' ORDER BY sort_order"; 

              list ($Language_id, $Related_items, $xsell_ids) = general_db_conct($query); 

               

              echo "<tr onMouseOver="cOn(this);" onMouseOut="cOut(this);" bgcolor='#DFE4F4'>"; 

              echo "<td class="dataTableContent" valign="top"> ".$PRODUCTS_id[$i]." </td>n"; 

              echo "<td class="dataTableContent" valign="top"> ".$PRODUCTS_name[$i]." </td>n"; 

              if ($Related_items) 

              { 

                  echo "<td  class="dataTableContent"><ol>"; 

                foreach ($Related_items as $display) 

                 echo '<li>'. $display .' '; 

                 echo"</ol></td>n"; 

                 } 

              else 

                 echo "<td class="dataTableContent">--</td>n"; 

              echo '<td class="dataTableContent"  valign="top"> <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'add_related_product_ID=' . $PRODUCTS_id[$i], 'NONSSL') . '">Add</a> </td><td class="dataTableContent" valign="top"> <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'add_related_product_ID=' . $PRODUCTS_id[$i], 'NONSSL') . '">Remove</a> </td>'; 

                           

              if (count($Related_items)>1) 

              { 

                echo '<td class="dataTableContent" valign="top"> <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'sort=1&add_related_product_ID=' . $PRODUCTS_id[$i], 'NONSSL') . '">Sort</a> </td>'; 

              } else { 

                 echo "<td class="dataTableContent" valign=top align=center>--</td>"; 

                 } 

              echo "</tr>n"; 

              unset($Related_items); 

              } 

           ?> 

            

           </table> 

           <? 

        }   // the end of -> if (!$add_related_product_ID) 

         

  if ($_POST && !$sort) 

  { 

      if ($_POST[run_update]==true) 

    { 

      $query ="DELETE FROM " . TABLE_PRODUCTS_XSELL . " WHERE products_id = '".$_POST[add_related_product_ID]."'"; 

      if (!tep_db_query($query)) 

     exit('could not delete'); 

    } 

    if ($_POST[xsell_id]) 

     foreach ($_POST[xsell_id] as $temp) 

      { 

      $query = "INSERT INTO " . TABLE_PRODUCTS_XSELL . " VALUES ('',$_POST[add_related_product_ID],$temp,1)"; 

      if (!tep_db_query($query)) 

     exit('could not insert to DB'); 

    } 

    echo '<a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL') . '">Click Here to add a new cross sale</a><br>' . "n"; 

    if ($_POST[xsell_id]) 

     echo '<a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, 'sort=1&add_related_product_ID=' . $_POST[add_related_product_ID], 'NONSSL') . '">Click here to sort (top to bottom) the added cross sale</a>' . "n"; 

  } 

      

       if ($add_related_product_ID && ! $_POST && !$sort)    

  {   ?>    

    <table border="0" cellpadding="2" cellspacing="1" bgcolor="#999999"> 

             <form action="<?php tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL'); ?>" method="post"> 

               <tr class="dataTableHeadingRow"> 

<?php 



       $query = "select b.language_id, a.products_id, b.products_name, b.products_description, " . 

                "a.products_quantity, a.products_model, a.products_image, " . 

                "b.products_url, a.products_price from products a, products_description b where b.products_id = a.products_id and b.language_id = 1 and a.products_id = '".$add_related_product_ID."'"; 

        list ($language_id, $PRODUCTS_id, $PRODUCTS_name, $PRODUCTS_description  , $PRODUCTS_quantity  , $PRODUCTS_model  , $PRODUCTS_image  , $PRODUCTS_url  , $PRODUCTS_price  ) = general_db_conct($query); 

?> 



                 <td class="dataTableHeadingContent"> </td> 

                 <td class="dataTableHeadingContent" nowrap>Item #</td> 

                 <td class="dataTableHeadingContent">Item Name</td> 

                 <td class="dataTableHeadingContent">$Price</td> 

               </tr> 

   

               <? 



       $query = "select b.language_id, a.products_id, b.products_name, b.products_description, " . 

                "a.products_quantity, a.products_model, a.products_image, " . 

                "b.products_url, a.products_price from products a, products_description b where b.products_id = a.products_id and  b.language_id = 1 and a.products_id != '".$add_related_product_ID."' order by b.products_name"; 



        list ($language_id, $PRODUCTS_id, $PRODUCTS_name, $PRODUCTS_description  , $PRODUCTS_quantity  , $PRODUCTS_model  , $PRODUCTS_image  , $PRODUCTS_url  , $PRODUCTS_price  ) = general_db_conct($query); 

         $num_of_products = sizeof($PRODUCTS_id); 

           $query = "select * from " . TABLE_PRODUCTS_XSELL . " WHERE products_id = '".$add_related_product_ID."'"; 

                 list ($ID_PR, $PRODUCTS_id_PR, $xsell_id_PR) = general_db_conct($query); 

              for ($i=0; $i < $num_of_products; $i++) 

              { 

              ?><tr bgcolor='#DFE4F4'> 

                 <td class="dataTableContent"> 

               

              <input <?php /* this is to see it it is in the DB */ 

                 $run_update=false; // set to false to insert new entry in the DB 

                 if ($xsell_id_PR) foreach ($xsell_id_PR as $compare_checked)if ($PRODUCTS_id[$i]===$compare_checked) {echo "checked"; $run_update=true;} ?> size="20"  size="20"  name="xsell_id[]" type="checkbox" value="<?php echo $PRODUCTS_id[$i]; ?>"></td> 

               

              <? echo "<td  class="dataTableContent" align=center>".$PRODUCTS_id[$i]."</td>n" 

                 ."<td class="dataTableContent">".$PRODUCTS_name[$i]."</td>n" 

                 ."<td class="dataTableContent">".$currencies->display_price($PRODUCTS_price[$i], tep_get_tax_rate($product_info_values['products_tax_class_id']))."</td></tr>n"; 

              }?> 

              <tr> 

                 <td colspan="4"> 

             

              <input type="hidden" name="run_update" value="<?php if ($run_update==true) echo "true"; else echo "false" ?>"> 

             <input type="hidden" name="add_related_product_ID" value="<?php echo $add_related_product_ID; ?>"> 

                   <input type="submit" name="Submit" value="Submit"></td> 

               </tr> 

             </form> 

           </table>    

     <? } 



       // sort routines 

  if ($sort==1) 

  { 

  //   first lets take care of the DB update. 

      $run_once=0; 

    if ($_POST) 

     foreach ($_POST as $key_a => $value_a) 

    { 

     tep_db_connect(); 

     $query = "UPDATE " . TABLE_PRODUCTS_XSELL . " SET sort_order = '".$value_a."' WHERE xsell_id= '$key_a' "; 

     //$query ="DELETE FROM " . TABLE_PRODUCTS_XSELL . " WHERE products_id = '".$key_a."'"; 

     if ($value_a != 'Update') 

        if (!tep_db_query($query)) 

           exit('could not UPDATE DB'); 

        else 

           if ($run_once==0) 

           { 

              echo '<b>The Database was updated <a href="' . tep_href_link(FILENAME_XSELL_PRODUCTS, '', 'NONSSL') . '">Click here to back to the main page</a></b><br>' . "n"; 

              $run_once++; 

           } 

            

  }// end of foreach. 

  ?> 

  <form method="post" action="<?php tep_href_link(FILENAME_XSELL_PRODUCTS, 'sort=1&add_related_product_ID=' . $add_related_product_ID, 'NONSSL'); ?>"> 

             <table cellpadding="2" cellspacing="1" bgcolor=999999 border="0"> 

               <tr class="dataTableHeadingRow"> 

                 <td class="dataTableHeadingContent" width="75">Product ID</td> 

                 <td class="dataTableHeadingContent">Name</td> 

                 <td class="dataTableHeadingContent" width="150">Price</td> 

                 <td class="dataTableHeadingContent" width="150">Order (1=Top)</td> 

               </tr> 

           <? 

           $query = "select * from " . TABLE_PRODUCTS_XSELL . " WHERE products_id = '".$add_related_product_ID."'"; 

           list ($ID_PR, $PRODUCTS_id_PR, $xsell_id_PR, $order_PR) = general_db_conct($query); 

           $ordering_size =sizeof($ID_PR); 

           for ($i=0;$i<$ordering_size;$i++) 

              { 



       $query = "select b.language_id, a.products_id, b.products_name, b.products_description, " . 

                "a.products_quantity, a.products_model, a.products_image, " . 

                "b.products_url, a.products_price from products a, products_description b where b.products_id = a.products_id and b.language_id = 1 and a.products_id = ".$xsell_id_PR[$i].""; 



              list ($language_id, $PRODUCTS_id, $PRODUCTS_name, $PRODUCTS_description  , $PRODUCTS_quantity  , $PRODUCTS_model  , $PRODUCTS_image  , $PRODUCTS_url  , $PRODUCTS_price  ) = general_db_conct($query); 

      

              ?> 

              <tr class="dataTableContentRow" bgcolor='#DFE4F4'> 

                <td class="dataTableContent"><?php echo $PRODUCTS_id[0]; ?></td> 

                <td class="dataTableContent"><?php echo $PRODUCTS_name[0]; ?></td> 

                <td class="dataTableContent"><?php echo $currencies->display_price($PRODUCTS_price[0], tep_get_tax_rate($product_info_values['products_tax_class_id'])); ?></td> 

                <td class="dataTableContent"><select name="<?php echo $PRODUCTS_id[0]; ?>"> 

                   <? for ($y=1;$y<=$ordering_size;$y++) 

                         { 

                       echo "<option value="$y""; 

                          if (!(strcmp($y, "$order_PR[$i]"))) {echo "SELECTED";} 

                          echo ">$y</option>"; 

                       } 

                       ?> 

                 </select></td> 

              </tr> 

              <? } // the end of foreach   ?> 

               <tr> 

                 <td colspan="4" bgcolor='#DFE4F4'><input name="runing_update" type="submit" id="runing_update" value="Update"></td> 

               </tr> 

             </table> 

           </form> 

         

        <?php }?> 

      

      

         </td> 

       </tr>    

  </table> 

  <!-- End of cross sale //--> 

  </td> 

<!-- products_attributes_eof //--> 

</tr></table> 

<!-- body_text_eof //--> 

<!-- footer //--> 

<? include(DIR_WS_INCLUDES . 'footer.php'); ?> 

<!-- footer_eof //--> 

<br> 

</body> 

</html> 

<? include(DIR_WS_INCLUDES . 'application_bottom.php');?>

gdfwilliams · February 28, 2003

well done, michael.

could you add your improvements to the contribution?

Also, any thoughts on a quick an easy way to add the option to "X-Sell All"? If you're associating 3 products, rather than having to define products for each, it would be cool to have the option (a checkbox down by the submit button) to set the associations for all three files with one submit.

See what I'm saying?

- Greg

Michael D. · March 1, 2003

well I think its actually not comfortable enough for a contribution update ...

Took only a minute...

Ill have a closer look on that someday.

features I am missing:

search for product or cross-product

order products by ...

multiple submit

Any other wishes/suggestions?

Salvo · March 1, 2003

I don't know why, but it doesn't work for me....

I tried everything... but it doesn't store information...

Salvo

PS: I have to do it manually :-(

Salvo · March 5, 2003

can anyone help with this code?

I have installed the above and give me this error

1136 - Column count doesn't match value count at row 1

INSERT INTO products_xsell VALUES ('',304,182,1)

Any help is apprecited

Salvo

March 11, 2003

will this cross sell to a catogory or do i have to set all products

as the options on the site need to cross sell with diferent catogories ie a fireplace surround would then require a backpanel and hearth etc etc

and there are 9 diffirent catogories under the marble section with in this

still going to add it anyway but just wanted to ask

http://www.designfireplaces.co.uk/catalog/default.php

March 27, 2003

can anyone help with this code?

I have installed the above and give me this error

1136 - Column count doesn't match value count at row 1

INSERT INTO products_xsell VALUES ('',304,182,1)

Any help is apprecited

Salvo

salvo,

you need to make sure that the ID field in products_xsell is the first field. i am not sure why but that is the only way i could get it to work.

dmGremlin · March 30, 2003

I'm not sure if someone has already posted a fix for this somewhere else, but for those of you who have noticed that if one of the products to be 'cross sold' is a special (and you are using the 'buy now' feature), the special price is not displayed - only the original price. Here is the fix:

in 'includes/modules/xsell_products.php' (which would have been renamed from xsell_products.php_buynow) find the line:

$xsell['products_name'] = tep_get_products_name($xsell['products_id']);

and underneath, insert:

$xsell['specials_new_products_price'] = tep_get_products_special_price($xsell['products_id']);



if ($xsell['specials_new_products_price']) {

     $xsell_price =  '<s>' . $currencies->display_price($xsell['products_price'], tep_get_tax_rate($xsell['products_tax_class_id'])) . '</s><br>';

     $xsell_price .= '<span class="productSpecialPrice">' . $currencies->display_price($xsell['specials_new_products_price'], tep_get_tax_rate($xsell['products_tax_class_id'])) . '</span>';

   } else {

     $xsell_price =  $currencies->display_price($xsell['products_price'], tep_get_tax_rate($xsell['products_tax_class_id']));

   }

then, find the line

$currencies->display_price($xsell['products_price'], tep_get_tax_rate($xsell['products_tax_class_id']))

and replace with:

$xsell_price

This is a very nice and in my opinion necessary contribution. It would be nice if the original cross sell was packaged with the admin for it. Happy coding everyone!

8)

-D. M.

dmGremlin · March 30, 2003

hmm... part of that might have been slightly confusing. The second part - the line that needed to be replaced,

$currencies->display_price($xsell['products_price'], tep_get_tax_rate($xsell['products_tax_class_id']))

is inside of the the 'text' => ' ' part of the array a few lines down from the the other blurb of code. Don't replace this line in any part of the code that you would be inserting. I hope that makes more sense.

8)

-D. M.

Salvo · March 30, 2003

I have made and tried a few things but still doesn't work,

I would appreciate if someone posted a full working

xsell_products.php

I have a download of Nov 2002...

Thanks

Salvo

April 1, 2003

Now easier to download

I zipped both parts into one contribution.

It is here

http://www.oscommerce.com/community/contributions,334

I added the multi-language support changes as well as the specials fix.

timlitw · April 1, 2003

I tried unziping it with winzip and with unzip on my linux host.

April 2, 2003

Fixed the problem

Salvo · April 2, 2003

Hi all

I have been trying to download the 04/01/2003 - Cross-Sell Complete v1.1 with no success...

Any idea why?

Thanks

Salvo

timlitw · April 3, 2003

now getting a file not found error whne clicking the download

[Contribution] Cross Sell (X-Sell) Admin

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

RusNN

Backcountry_Surfer

altoid

Posted Images

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation