Carousel display order?

I was wondering how is the display order of the carousel determined?
For the life of me, I cannot seem to get it down.

At fist look it seemed to go by reverse last updated but I then I found it's not.

Can you point me to the right direction? I need to have them in specific order.

Have you solved it?
I'm still facing it in 1.5.1.2.. The only thing I got is that when you just click on modify and save without making actual changes, the order changes with no reason, and looks like a random order change!

I found out how it works by observation for when showing 2 out of 3 images total, hopefully you can take my findings as a base and expand it to match your case.

It goes like this: [ C , A ] B
A: oldest, C: newest

Still no one figured it out how to sort the manufacturers in carousel mod?

Here is an easy fix to sort the banners alphabetically or numerically.

This mod will sort the banners alphabetically by title. If you add a sort number to the beginning of each title, such as (01) Item One, (02) Item Two, (03) Item Three, ...., (10) Item Ten, (11) Item Eleven, they stay in order. Remember to include leading zeros if you go above 9 items so that 1 & 10 (11, 12, 13...) , 2 & 20 (21, 22, 23...) don't group.

At the end of the query string in model/design/banner, Find: Change to: Note: all banners will now sort alphabetically by title with this mod. Additionally, any prefix given to the title will be shown in the ALT tag of the image.

The correct better solution to your problem would be to add an "ORDER" column to the DB_BANNER_IMAGE_DESCRIPTION table and mod the query to sort by bid.order rather than bid.title. You could go one step further and mod the admin/controller files to allow management of the ORDER in the banner design page.

spires: works like a charm! thanks :-)

How would you modify the above code to order alphabetically regardless of case? For instance, in the carousel in the following site: <http://ereadersupplystore.com/>, iPad appears last, since the 'i' is lowercase. I'd prefer to keep the 'i' lowercase, since most people are used to seeing it that way for Apple products.

Banners Plus will also let you set the order.

Hey Spires, I really appreciate your fix for this problem. I unfortunately am not very good with code. I downloaded the banner.php file and searched for the string . "'"); and several results came up. Could you tell me which line or which string I need to add the . "' ORDER BY bid.title ASC"); to? Thank you.


RE:

Here is an easy fix to sort the banners alphabetically or numerically.

This mod will sort the banners alphabetically by title. If you add a sort number to the beginning of each title, such as (01) Item One, (02) Item Two, (03) Item Three, ...., (10) Item Ten, (11) Item Eleven, they stay in order. Remember to include leading zeros if you go above 9 items so that 1 & 10 (11, 12, 13...) , 2 & 20 (21, 22, 23...) don't group.

At the end of the query string in model/design/banner, Find:
CODE: SELECT ALL
. "'");

Change to:
CODE: SELECT ALL
. "' ORDER BY bid.title ASC");

Note: all banners will now sort alphabetically by title with this mod. Additionally, any prefix given to the title will be shown in the ALT tag of the image.

The correct better solution to your problem would be to add an "ORDER" column to the DB_BANNER_IMAGE_DESCRIPTION table and mod the query to sort by bid.order rather than bid.title. You could go one step further and mod the admin/controller files to allow management of the ORDER in the banner design page

the "banner.php" file he means, is the "catalog/model/design/banner.php"... not the "admin/model/design/banner.php"

rakoom2002 wrote:Hey Spires, I really appreciate your fix for this problem. I unfortunately am not very good with code. I downloaded the banner.php file and searched for the string . "'"); and several results came up. Could you tell me which line or which string I need to add the . "' ORDER BY bid.title ASC"); to? Thank you.


RE:

Here is an easy fix to sort the banners alphabetically or numerically.

This mod will sort the banners alphabetically by title. If you add a sort number to the beginning of each title, such as (01) Item One, (02) Item Two, (03) Item Three, ...., (10) Item Ten, (11) Item Eleven, they stay in order. Remember to include leading zeros if you go above 9 items so that 1 & 10 (11, 12, 13...) , 2 & 20 (21, 22, 23...) don't group.

At the end of the query string in model/design/banner, Find:
CODE: SELECT ALL
. "'");

Change to:
CODE: SELECT ALL
. "' ORDER BY bid.title ASC");

Note: all banners will now sort alphabetically by title with this mod. Additionally, any prefix given to the title will be shown in the ALT tag of the image.

The correct better solution to your problem would be to add an "ORDER" column to the DB_BANNER_IMAGE_DESCRIPTION table and mod the query to sort by bid.order rather than bid.title. You could go one step further and mod the admin/controller files to allow management of the ORDER in the banner design page