How to change MAX_DISPLAY_NEW_PRODUCTS

[pafranklin]

Hi there,

 

Currently I have the following code for my products_new.php

  $products_new_query_raw = "select p.products_id, pd.products_name, pd.short_desc, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name";
 $products_new_split = new splitPageResults($products_new_query_raw, MAX_DISPLAY_PRODUCTS_NEW);

 

For some reason, when I add new products they are now not showing and I am wondering if this could be to do with the MAX_DISPLAY_NEW_PRODUCTS entry?

 

Please would someone tell me where the MAX limit may be changed and where I can find what this Maximum is?

 

Many thanks.

 

Paul

[Jack_mcs]

See admin->Configuration->Maximum Values.

 

Jack

[pafranklin]

See admin->Configuration->Maximum Values.

 

Jack

 

Many thanks for the reply. I have changed this but it only changes the number of new products shown per page?

 

I thought that somewhere I needed to change the "MAX_PRODUCTS"?

 

Paul

[markg-uk]

Its the correct place to look for that setting - BUT - it doesn't sound like that is your problem. As soon as you add a new product, that will be the first entry in the new products area.

 

Sounds like your new products aren't displaying - could be due to a few things (i.e. not enabled, no stock and you only show in stock products)