Featured Product Sort Order!?!?!?

[flipjargendy]

I've set each products sort order. I've looked for every setting I can to change how the products are ordered. I cannot get the Featured Product box in the center to display ordered.

In admin>config>display products display it is set to 8 to use the product sort order. I've even tried setting it to other numbers. THe products still list randomly.

I see no reason why this is not working. I am trying to finish this website for a client. This is my first time using Zen Cart. Sorry if this is something obvious.

[GoodBuyGail]

Hi,
simply do the following

change in
/includes/modules/featured_products.php

$featured_products = $db-> ExecuteRandomMulti($featured_products_query, MAX_DISPLAY_SEARCH_RESULTS_FEATURED ); 

to

$featured_products = $db->Execute( $featured_products_query, MAX_DISPLAY_SEARCH_RESULTS_FEATURED); 

and

    $featured_products->MoveNextRandom(); 

to

    $featured_products->MoveNext(); 

[flipjargendy]

I knew that had to do with it! I tried removing it and it wouldn't load the page.

Thank you so much!! THAT DID IT!!!!!

[devon789456316541560]

i changed the two lines of code... it seems to sorting the products by there ID#. is there a way so that i can get zen cart to display the featured items so that i can control the order in which the items are displayed. possibly by the end date????

[flipjargendy]

i changed the two lines of code... it seems to sorting the products by there ID#. is there a way so that i can get zen cart to display the featured items so that i can control the order in which the items are displayed. possibly by the end date????

If you make the changes that are stated above you can sort the items by "Sort Order". If you go to Catalog>Categories/Products you can edit each product from there. Just click the edit button for each one and look for a field called "Sort Order".

1 will appear first and 2 next.... so on.

[devon789456316541560]

Thank You

Wont this also change the order of the products when being displayed on the products page????