Adding weight and quantity to new product list

[lian8]

Would like to know how to add weight and quantity information to the "new product listing" page. At the moment, all it shows is the manufacturer and price.

[lian8]

I have customers that buy through the "what's new" feature. The feedback I've gotten from them is they would like more information on that list. So I would be very grateful if someone could show me how to add "quantity" and "weight" to the "products_new.php" page.

[Guest]

change the sql query in your catalog\products_new.php you will see a line like:

$products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price,........

 

just add the extra info columns you need.

 

$products_new_query_raw = "select p.products_id, p.products_quantity, p.products_weight, pd.products_name, p.products_image, p.products_price,........

 

then create a couple of extra html columns (or duplicate existing code) and use them. For the html to insert look near the line:

 

			<td valign="top" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_new['products_id']) . '"><b><u>' . $products_new['products_name'] . '</u></b></a><br>' . TEXT_DATE_ADDED . ' ' . tep_date_long($products_new['products_date_added']) . '<br>' . TEXT_MANUFACTURER . ' ' . $products_new['manufacturers_name'] . '<br><br>' . TEXT_PRICE . ' ' . $products_price; ?></td>

 

Just append the extra info after the products name for instance.