Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

bestselling products with special price


jjanguda

Recommended Posts

I just installed bestselling Product Page contribution and have a question..

 

I also want to display a speical price on the bestselling_product.php page.

 

Some of my special products are displayed on the bestselling product page, but

 

the problem is.. it shows the product's regular price. I tried to modify includes/boxes/bestselling.php

 

file but it didn't work... Can you tell me with this? Here's the code you wrote..

 

This is includes/boxes/bestselling.php file..

<?php
/*
 $Id: bestselling.php
by Mikey J:  [email protected]      http://www.getmemusic.com
osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com
 Copyright (c) 2003 osCommerce
 Released under the GNU General Public License*/
if (isset($current_category_id) && ($current_category_id > 0)) {
   
$best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name, p.products_image,  pd.products_description,  p.products_tax_class_id, p.products_price  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 = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . (int)$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, p.products_image, pd.products_description,  p.products_tax_class_id, p.products_price  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 = '" . (int)$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) {
?>

<!-- best_sellers //-->

         <tr>

           <td>

<?php
   $info_box_contents = array();
   $info_box_contents[] = array('text' => BOX_HEADING_BESTSELLING_PRODUCTS);


   new infoBoxHeading($info_box_contents, false, false);

   $rows = 0;

   $bestsellers_list = '<table border="0" width="100%"  cellspacing="0" cellpadding="1">';

   while ($best_sellers = tep_db_fetch_array($best_sellers_query)) {

     $rows++;

     $bestsellers_list .= '<tr><td class="infoBoxContents" valign="top">' . tep_row_number_format($rows) . '.
</td><td class="infoBoxContents" valign="top" align="center">
<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $best_sellers['products_image'], $best_sellers['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT,' class="shadow1" ') . '</a><br><br>
</td><td class="infoBoxContents" valign="top" align="left">
<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . $best_sellers['products_name'] . '</a><BR><BR>  
<a title="more info" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . 'more info</a>  |  
<a title="buy now" href="' . tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $best_sellers['products_id']) . '">' . 'buy now</a><br><br>
</td><td class="infoBoxContents" valign="top" align="right">'
. $currencies->display_price($best_sellers['products_price'], tep_get_tax_rate($best_sellers['products_tax_class_id'])) . 
'</td></tr>';
 
  }
   $bestsellers_list .= '</table>';


   $info_box_contents = array();

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


   new infoBox($info_box_contents);
?>

         </td>
</TR>
<!-- best_sellers_eof //-->

<?php
 }
?>

 

 

 

i'll appreciate for any help..

 

Thanks~~

Link to comment
Share on other sites

I just installed bestselling Product Page contribution and have a question..

 

I also want to display a speical price on the bestselling_product.php page.

 

Some of my special products are displayed on the bestselling product page, but

 

the problem is.. it shows the product's regular price. I tried to modify includes/boxes/bestselling.php

 

file but it didn't work... Can you tell me with this? Here's the code you wrote..

 

This is includes/boxes/bestselling.php file..

<?php
/*
?$Id: bestselling.php
by Mikey J: [email protected] ? ? ?http://www.getmemusic.com
osCommerce, Open Source E-Commerce Solutions
?http://www.oscommerce.com
?Copyright (c) 2003 osCommerce
?Released under the GNU General Public License*/
if (isset($current_category_id) && ($current_category_id > 0)) {
? ?
$best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name, p.products_image, ?pd.products_description, ?p.products_tax_class_id, p.products_price ?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 = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . (int)$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, p.products_image, pd.products_description, ?p.products_tax_class_id, p.products_price ?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 = '" . (int)$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) {
?>

<!-- best_sellers //-->

? ? ? ? ?<tr>

? ? ? ? ? ?<td>

<?php
? ?$info_box_contents = array();
? ?$info_box_contents[] = array('text' => BOX_HEADING_BESTSELLING_PRODUCTS);
? ?new infoBoxHeading($info_box_contents, false, false);

? ?$rows = 0;

? ?$bestsellers_list = '<table border="0" width="100%" ?cellspacing="0" cellpadding="1">';

? ?while ($best_sellers = tep_db_fetch_array($best_sellers_query)) {

? ? ?$rows++;

? ? ?$bestsellers_list .= '<tr><td class="infoBoxContents" valign="top">' . tep_row_number_format($rows) . '.
</td><td class="infoBoxContents" valign="top" align="center">
<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $best_sellers['products_image'], $best_sellers['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT,' class="shadow1" ') . '</a><br><br>
</td><td class="infoBoxContents" valign="top" align="left">
<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . $best_sellers['products_name'] . '</a><BR><BR> ?
<a title="more info" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . 'more info</a>  |  
<a title="buy now" href="' . tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $best_sellers['products_id']) . '">' . 'buy now</a><br><br>
</td><td class="infoBoxContents" valign="top" align="right">'
. $currencies->display_price($best_sellers['products_price'], tep_get_tax_rate($best_sellers['products_tax_class_id'])) . 
'</td></tr>';
?
? }
? ?$bestsellers_list .= '</table>';
? ?$info_box_contents = array();

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

? ? ? ? ?</td>
</TR>
<!-- best_sellers_eof //-->

<?php
?}
?>

i'll appreciate for any help..

 

Thanks~~

log into admin click catalog click specials in left side panel and select the item you wont to put on special insert reducd price for that special and that all :thumbsup:

( WARNING )

I think I know what Im talking about.

BACK UP BACK UP BACK UP BACK UP

Link to comment
Share on other sites

thanks for your comment, WiseWombat. But I think you misunderstood my point. Of course I want to use speical infobox along with the bestselling product page. As you could see from the code that I added, special price codes are missed.. (The source code has only a regular price..not special price...) So, what I'd like to know is how to add spcecial price on the code.. because sometimes speical products happen to be a bestselling product... Then.. customers should see both regular/special price on the same screen...

 

Can anyone help me further on this issue?

 

I'll appreciate for any help.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...