How to display modify "new product this month"

[deedeedum]

Right now, my site is really messed up because the "New Product This Month" is displaying three pictures in a row when it only fits two. Can someone tell me how to modify that?

 

If you can't, can you tell me how to get rid of the "New Product This Month" section on the category page?

[deedeedum]

Also, I got rid of the "New Product This Month" section from the front page, but I can't remember how I did it. Can someone tell me what file to modify? Thanks.

[deedeedum]

SOMEONE PLEASE HELP!!!! I have spent hours and hours looking and can't find it.

[Guest]

To get rid of the New products for xxxx completely in the category page (actually it's in index.php).

 

Open catalog/index.php.

 

On line 121 change

 

            <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td>

to

 

            <td><?php //include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td>

(note the // after <?php)

 

If you want to get rid of the one in your catalog's homepage as well do the same thing in line 313.

 

Have fun! :thumbsup:

[deedeedum]

Right now, my site is really messed up because the "New Product This Month" is displaying three pictures in a row when it only fits two.  Can someone tell me how to modify that?

<{POST_SNAPBACK}>

 

 

 

Does anyone know how to display two pictures instead of three (in one row)? Because right now, I increased the size of the pictures and three pictures WON'T fit in one row and it's messing up the whole picture.

 

I would much rather have "New Products This Month" than not have it.

 

Thanks.

[TCwho]

go in your admin panel>>configuration>>maximum values>> then look for 'categories to list per row'

[TCwho]

go in your admin panel>>configuration>>maximum values>> then look for 'categories to list per row'

<{POST_SNAPBACK}>

 

 

ooops sorry

 

I just realized this effects the number of categories it shows in a row....not the products

[Guest]

Use this code as you new catalog/includes/modules/new_products.php file.

 

<?php
/*
 $Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/
?>
<!-- new_products //-->
<?php
 $info_box_contents = array();
 $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')));

 new contentBoxHeading($info_box_contents);

 if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
   $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . "6");
 } else {
   $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit " . "6");
 }

 $row = 0;
 $col = 0;
 $info_box_contents = array();
 while ($new_products = tep_db_fetch_array($new_products_query)) {
   $new_products['products_name'] = tep_get_products_name($new_products['products_id']);
   $info_box_contents[$row][$col] = array('align' => 'center',
                                          'params' => 'class="smallText" width="33%" valign="top"',
                                          'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])));

   $col ++;
   if ($col > 2) {
     $col = 0;
     $row ++;
   }
 }

 new contentBox($info_box_contents);
?>
<!-- new_products_eof //-->

 

Tell me how get on.

[Guest]

Or you can run this code in on your database. You can use phpMyAdmin etc.

 

UPDATE configuration
SET configuration_value = 6
WHERE configuration_key = 'MAX_DISPLAY_NEW_PRODUCTS'

[Guest]

Sorry, my mistake. Those 2 codes above are 2 different solutions for 2 rows (not 2 columns as you wanted).

 

PLEASE IGNORE THE ABOVE. WAIT A WHILE AND I WILL WRITE YOU A NEW CODE.

[Guest]

HERE IS YOUR FINAL catalog/includes/modules/new_products.php file

 

<?php
/*
 $Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/
?>
<!-- new_products //-->
<?php
 /* ------------------------------------------------------ */
 $new_product_columns = 2; // Specify number of columns here.
 $new_product_rows = 2; // Specify number of rows here.
 /* ------------------------------------------------------ */
   
 $np_columns = $new_product_columns - 1;
 $np_rows = $new_product_columns * $new_product_rows;

 $info_box_contents = array();
 $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')));

 new contentBoxHeading($info_box_contents);

 if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
   $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit $np_rows");
 } else {
   $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit $np_rows");
 }

 $row = 0;
 $col = 0;
 $info_box_contents = array();
 while ($new_products = tep_db_fetch_array($new_products_query)) {
   $new_products['products_name'] = tep_get_products_name($new_products['products_id']);
   $info_box_contents[$row][$col] = array('align' => 'center',
                                          'params' => 'class="smallText" width="33%" valign="top"',
                                          'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])));

   $col ++;
   if ($col > $np_columns) {
     $col = 0;
     $row ++;
   }
 }

 new contentBox($info_box_contents);
?>
<!-- new_products_eof //-->

You can spicify the desired number of rows and columns in these lines (line 16 & 17).

 

  /* ------------------------------------------------------ */
 $new_product_columns = 2; // Specify number of columns here.
 $new_product_rows = 2; // Specify number of rows here.
 /* ------------------------------------------------------ */

 

Let me know how you get on! :thumbsup: