Home Page Latest Products order

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

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.

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

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.

Thanks mystifer,

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

Too easy, case solved.

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.

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!

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!

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.

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!!!

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

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?

You need 1.4.9.1 for that

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!

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!

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.

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?

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

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