Post by jewelenterprises » Tue Jul 29, 2008 9:27 pm

Hi all

I have installed open cart on my website and was wondering whether I might be able to increase the number of products displaying as 'latest products'.

My site is an electronics sweepstakes site designed to only have a limited number of items.  At the moment I only have seven items so I was wondering if I could get all seven items to show on the front page rather than just six items.

You can view my cart at http://www.free-electronics-source.com/shoppingcart

And please, if I need to edit template files please supply the path to the file because it's VERY confusing in there. LOL


Posts

Joined
Tue Jul 29, 2008 11:26 am
Location - Melbourne, Australia

Post by bruce » Tue Jul 29, 2008 10:59 pm

Hi,

Have a look in catalog\controller\home.php and you will see something like

Code: Select all

		$results = $database->getRows("select * from product p left join product_description pd on (p.product_id = pd.product_id) left join image i on (p.image_id = i.image_id) where p.status = '1' and pd.language_id = '" . (int)$language->getId() . "' and p.date_available < now() and p.status = '1' order by p.date_added limit 6");
change the limit 6 to limit 7 or just remove "limit 6" altogether to get all your products on the page

and it it is not in the 0.7.8 version, change "order by p.date_added" to "order by p.date_added desc" to truly show "latest products"

Active Member

Posts

Joined
Wed Dec 12, 2007 2:26 pm

Post by jewelenterprises » Tue Jul 29, 2008 11:26 pm

Bruce you're a champ... big thumbs up to you :)  All fixed now. 


Posts

Joined
Tue Jul 29, 2008 11:26 am
Location - Melbourne, Australia
Who is online

Users browsing this forum: No registered users and 3 guests