Removed product, but still remains in the

[Zuncan]

Hi!

 

Have a little issue. I just removed a product from my store. It was one of my topsellers. Problem is that the customer still can access the product from the top sellers box and even put it in the cart. How can I completly remove the product from my store?

 

/ Zuncan

[boxtel]

Hi!

 

Have a little issue. I just removed a product from my store. It was one of my topsellers. Problem is that the customer still can access the product from the top sellers box and even put it in the cart. How can I completly remove the product from my store?

 

/ Zuncan

<{POST_SNAPBACK}>

 

then you must have an altered bestsellers box because the default one checks for the products_status being 1

[Zuncan]

Yeah it has been modified.. as the rest of my entire store..

 

Here is the code for best_sellers.php. Can you see anything that is wrong?

 

 if (isset($current_category_id) && ($current_category_id > 0)) {
   $best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . $current_category_id . "' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
 } else {
   $best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
 }

 if (tep_db_num_rows($best_sellers_query) >= MIN_DISPLAY_BESTSELLERS) {
?>
<tr>
 <td> 
   <table width="135" border="0" cellspacing="0" cellpadding="0" class="CategoriesBoxContents">
     <tr>
       <td>          <table width=100% border=0 cellpadding=0 cellspacing=0 class="CategoriesBoxContents">
           <tr> 
             <td width="100%"><img src="images/boxes/table_best_sellers.gif"></td>
           </tr>
           <tr> 
             <td>

<table width=100% border=0 cellpadding=0 cellspacing=0>
<TR>
<TD WIDTH="1" bgcolor="#F8C6E0"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#EDBED6"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#E8B8D0"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#DFAEC7"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#B33E79"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#D7CED2"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#E4DEE1"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#F6EFF3"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="*">

               <?php
   $rows = 0;
   $bestsellers_list = '<table border="0" width="100%" cellspacing="1" cellpadding="0">';
   while ($best_sellers = tep_db_fetch_array($best_sellers_query)) {
     $rows++;
     $bestsellers_list .= '<tr><td valign="top" class="CategoriesBoxContents">' . tep_row_number_format($rows) . '.</td><td class="CategoriesBoxContents"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . $best_sellers['products_name'] . '</a></td></tr>';
   }
   $bestsellers_list .= '</table>';

   $info_box_contents = array();
   $info_box_contents[] = array('text' => $bestsellers_list);

new CategoriesBox($info_box_contents);
?>

</TD>
<TD WIDTH="1" bgcolor="#EAC4D7"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#C66F9B"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#FFE5F3"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#FFE4F2"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#FFDDEE"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
</TR> 
</TABLE>
<TABLE width=100% border=0 cellpadding=0 cellspacing=0>
<TR>
<td width="135"><img src="images/underbox.gif"></td>
</tr>
</TABLE>


             </td>
           </tr>
         </table>
       </td>
     </tr>
   </table>
   
 </td>
</tr>
<?php
 }
?>

[♥Monika in Germany]

Hi!

 

Have a little issue. I just removed a product from my store. It was one of my topsellers. Problem is that the customer still can access the product from the top sellers box and even put it in the cart. How can I completly remove the product from my store?

 

/ Zuncan

<{POST_SNAPBACK}>

how did you remove it? did you check your database if status was 0 instead of 1?

[boxtel]

Yeah it has been modified.. as the rest of my entire store..

 

Here is the code for best_sellers.php. Can you see anything that is wrong?

 

 if (isset($current_category_id) && ($current_category_id > 0)) {
? ?$best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . $current_category_id . "' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
?} else {
? ?$best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
?}

?if (tep_db_num_rows($best_sellers_query) >= MIN_DISPLAY_BESTSELLERS) {
?>
<tr>
?<td> 
? ?<table width="135" border="0" cellspacing="0" cellpadding="0" class="CategoriesBoxContents">
? ? ?<tr>
? ? ? ?<td> ? ? ? ? ?<table width=100% border=0 cellpadding=0 cellspacing=0 class="CategoriesBoxContents">
? ? ? ? ? ?<tr> 
? ? ? ? ? ? ?<td width="100%"><img src="images/boxes/table_best_sellers.gif"></td>
? ? ? ? ? ?</tr>
? ? ? ? ? ?<tr> 
? ? ? ? ? ? ?<td>

<table width=100% border=0 cellpadding=0 cellspacing=0>
<TR>
<TD WIDTH="1" bgcolor="#F8C6E0"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#EDBED6"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#E8B8D0"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#DFAEC7"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#B33E79"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#D7CED2"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#E4DEE1"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#F6EFF3"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="*">

? ? ? ? ? ? ? ?<?php
? ?$rows = 0;
? ?$bestsellers_list = '<table border="0" width="100%" cellspacing="1" cellpadding="0">';
? ?while ($best_sellers = tep_db_fetch_array($best_sellers_query)) {
? ? ?$rows++;
? ? ?$bestsellers_list .= '<tr><td valign="top" class="CategoriesBoxContents">' . tep_row_number_format($rows) . '.</td><td class="CategoriesBoxContents"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . $best_sellers['products_name'] . '</a></td></tr>';
? ?}
? ?$bestsellers_list .= '</table>';

? ?$info_box_contents = array();
? ?$info_box_contents[] = array('text' => $bestsellers_list);

new CategoriesBox($info_box_contents);
?>

</TD>
<TD WIDTH="1" bgcolor="#EAC4D7"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#C66F9B"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#FFE5F3"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#FFE4F2"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
<TD WIDTH="1" bgcolor="#FFDDEE"><img src="images/pixel_trans.gif" vspace="0" hspace="0" height="1" width="1"></TD>
</TR> 
</TABLE>
<TABLE width=100% border=0 cellpadding=0 cellspacing=0>
<TR>
<td width="135"><img src="images/underbox.gif"></td>
</tr>
</TABLE>
? ? ? ? ? ? ?</td>
? ? ? ? ? ?</tr>
? ? ? ? ?</table>
? ? ? ?</td>
? ? ?</tr>
? ?</table>
? ?
?</td>
</tr>
<?php
?}
?>

<{POST_SNAPBACK}>

 

no, either you removed the product in a funny way or you are still looking at the cache file.