Post by tsneade » Sun May 16, 2010 7:10 am

Hi All,

I am wondering were I can choose how many products on home page latest product area.

I am setting up the site and every product I load ends up on the home page latest products,
this is bad for the look of home page when you are trying to load up all the products in a specific catagory and they all end up in all boxes on home page..

there has to be a way to control this.

Help Please..
Thanks
Last edited by i2Paq on Sat Jul 31, 2010 5:27 pm, edited 1 time in total.
Reason: Topic moved

New member

Posts

Joined
Fri May 14, 2010 5:51 am

Post by babington » Sun May 16, 2010 7:19 am

I agree...

But also, is there a way of controlling the arrangement/order of latest products too?

I happened to enter a serious of products in the wrong order, and now they appear in the wrong order.

Newbie

Posts

Joined
Thu May 13, 2010 4:13 am

Post by buckmajor » Sat Jul 31, 2010 12:33 pm

I was trying to find out too, I guess this one hasn't been solved. Will post if I hear anything.

http://www.dmaireroa.com


New member

Posts

Joined
Tue May 04, 2010 11:29 am
Location - Brisbane

Post by mystifier » Sat Jul 31, 2010 9:50 pm

There are a few points here:

a) In Admin->Extensions->Modules, you can choose whatever modules you want to show in the Left, Right or Home (central) position. You can very easily turn off Latest Products and use Featured Products instead (which allows you to choose which products to display) if that suits better. There are also other alternatives available such as Bestsellers (ordered by number sold) or Special Offers.

b) In all modules, it is possible to set 'Limit' which is poorly named but sets the number of Products you want to display. If the module is to be shown in the home position, it is advisable to make this a multiple of 4 so that rows get fully populated.

c) The Latest Product module shows products ordered by Date_Added which I agree is the wrong field. In catalog/model/catalog/product.php there is a function called getLatestProducts. It is easy to change the field to date_available by changing it to 'ORDER BY p.date_available DESC' The module will still show latest products but you also have some control because Available Date is controlled in Admin. Another alternative would be to change it to date_modified which would move products to the top whenever they are changed.

Free v1.4.9 Extensions: Default Specials | Improved Search | Customer Activity Report | Customer Groups | Royal Mail With Handling | Improved Product Page | Random Products | Stock Report | All Products


User avatar
Active Member

Posts

Joined
Tue May 18, 2010 5:15 pm

Post by buckmajor » Sun Aug 01, 2010 9:58 am

Thanks mystifer,

I didn't know you could use the 'Featured' module, and rearrange the products, that helps a lot.

Too easy, case solved.

http://www.dmaireroa.com


New member

Posts

Joined
Tue May 04, 2010 11:29 am
Location - Brisbane

Post by Balbaroy » Tue Aug 10, 2010 1:46 am

I added this ORDER BY p.sort_order ASC to the getFeaturedProducts function in product.php so that it would list the items based on the sort_order you set when you add a product to your store. Basically if an item has a sort order value of 0 it will be first, 1 will be second etc.

Newbie

Posts

Joined
Tue Aug 03, 2010 12:24 am

Post by webmastah » Tue Sep 21, 2010 6:42 pm

I think this module should use the sort order set in the product options. Instead, it seems to me that it uses the product id in the DB to sort the products out. Yeah, I know you can use another module for your homepage, but it would be nice if you could also control the products order in this module.

Cheers everyone!

Image

Opencarter.com
OpenCart Templates


New member

Posts

Joined
Wed May 05, 2010 6:16 pm

Post by webmastah » Tue Sep 21, 2010 7:03 pm

My bad. Actually, it uses the name to sort the products. So it is very easy to change this by editing the controller file and setting order to pd.sort_order. Once done, it sorts the products out by the sort order set in the product page options.

Cheers!

Image

Opencarter.com
OpenCart Templates


New member

Posts

Joined
Wed May 05, 2010 6:16 pm

Post by Qphoria » Tue Sep 21, 2010 7:50 pm

It's called "Latest" products... so it uses the date added field since day 1

Now in 1.4.7 and later, there is a featured module that doesn't explicitly set an ORDER BY, but would be more suitable for this.

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by webmastah » Tue Sep 21, 2010 8:20 pm

Yes, I just suggested that in case someone wants to set this order in other modules. Anyway, I think it would be nice if you can use this setting (sort order) in all modules, except for those whose order are set in the module settings. In these cases, settings in modules would override default ones. Just my opinion, though.

By the way, I know it may sound a bit off topic, Q, but... how about removing OpenCart version in footer of admin area login page? I mean, I don't want anyone to know the exact version of my installation, just me. It's to great to have it in the footer when you are already logged in, but no before. As far as I can see, it sounds like a slight but somehow valuable small security enhance, don't you?

Cheers!!!

Image

Opencarter.com
OpenCart Templates


New member

Posts

Joined
Wed May 05, 2010 6:16 pm

Post by Qphoria » Tue Sep 21, 2010 10:05 pm

webmastah wrote:By the way, I know it may sound a bit off topic, Q, but... how about removing OpenCart version in footer of admin area login page? I mean, I don't want anyone to know the exact version of my installation, just me. It's to great to have it in the footer when you are already logged in, but no before. As far as I can see, it sounds like a slight but somehow valuable small security enhance, don't you?

Cheers!!!
Already requested

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by bakstreet » Fri Oct 15, 2010 3:39 am

In OC 1.4.7 how can you change the products displayed on in the Latest Products? I tried to to install the Featured but it would only let me set it to the left or right. The slider is displayed with featured products but it doesn't state that. I'd like to be able to control whats in the Latest products or swap it out with something I can control.

Tips?

Newbie

Posts

Joined
Fri Oct 15, 2010 2:03 am

Post by Qphoria » Fri Oct 15, 2010 3:41 am

You need 1.4.9.1 for that

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by bakstreet » Fri Oct 15, 2010 3:50 am

Can I upgrade? If so, could you walk me through how? I know absolutely nothing about almost all of this. If I can't go in and click a drop down menu I'm lost. What would I need to copy and where would I need to paste it?

Thanks!

Newbie

Posts

Joined
Fri Oct 15, 2010 2:03 am

Post by Purebeads » Sat Jan 01, 2011 8:38 pm

mystifier wrote:There are a few points here:

c) The Latest Product module shows products ordered by Date_Added which I agree is the wrong field. In catalog/model/catalog/product.php there is a function called getLatestProducts. It is easy to change the field to date_available by changing it to 'ORDER BY p.date_available DESC' The module will still show latest products but you also have some control because Available Date is controlled in Admin. Another alternative would be to change it to date_modified which would move products to the top whenever they are changed.
Mystifier, this didn't work for me. I found this:

"' ORDER BY p.date_added DESC LIMIT "

and changed it to this:

"' ORDER BY p.date_available DESC LIMIT "

and the products with the most recent Available dates are not showing at the top. Any idea what I did wrong?

I notice, incidentally, that there seems to be an opening single quote in that line, but not a closing single quote. Is that an error?

I'm using version 1.4.8b.

===========================

Never mind! It's working now. Curiously, when I had the Featured module was under the Latest module on the home page, the items in the Latest module would not order by Date Available. But when I disabled the Featured module, the items in the Latest module started to order themselves correctly.

Let me explain my problem: I am adding new items to the cart, but I am also transferring old items from an old shopping cart. Thus, I want the truly new items to appear on top. So what I am doing is this: All old items transferred from the old cart are getting an Available date of 2001/12/30, and all the new items are getting dates in 2011. This has solved a big problem for me.

Thanks, Mystifier!

Active Member

Posts

Joined
Fri Apr 30, 2010 12:07 pm

Post by bobsleighbob » Tue Jul 05, 2011 9:36 pm

I have changed the Latest Products on one site that I am working on, but on a second site I can't change anything on the Home section of the home page. It is displaying the 8 latest products, but I can't change the number of products shown, or change it to "Special Offers" or anything. No matter what I change in my admin it always displays the 8 latest products.

Is it possible that there is a permissions issue that is preventing me from changing this?
I am using the Vortex theme, and Opencart 1.4.9.4.

Any help would be appreciated.

Newbie

Posts

Joined
Thu May 26, 2011 7:10 pm

Post by Purebeads » Wed Jul 06, 2011 6:50 am

bobsleighbob wrote:I have changed the Latest Products on one site that I am working on, but on a second site I can't change anything on the Home section of the home page. It is displaying the 8 latest products, but I can't change the number of products shown, or change it to "Special Offers" or anything. No matter what I change in my admin it always displays the 8 latest products.

Is it possible that there is a permissions issue that is preventing me from changing this?
I am using the Vortex theme, and Opencart 1.4.9.4.

Any help would be appreciated.
So you're aware that Latest Products was turned into its own module? It was originally hard-coded.

So if you are aware of that, you're saying that you changed the settings of the Latest module and the settings didn't take?

Active Member

Posts

Joined
Fri Apr 30, 2010 12:07 pm

Post by solunltd » Wed Feb 15, 2012 2:58 am

I tried to change the order by date_modified in product.php as per given instruction but nothing happened. Can Anyone help?? I am using 1.5.1.3

Newbie

Posts

Joined
Wed Feb 15, 2012 2:57 am

Post by indoonone » Mon Mar 04, 2013 2:48 am

Im also trying to sort by date modified aka changing p.date_added to p.date_modified and nothing happens. Please Help!

Newbie

Posts

Joined
Wed Feb 27, 2013 8:19 pm
Who is online

Users browsing this forum: No registered users and 4 guests