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

[tated]

I've tried the above fix to includes/modules/featured_products.php and had no luck. Featured listing display order is set to 8 = sort order, and products are assigned sort numbers.

The listing order is affected in the product listing of the admin interface, but not on the featured products page of the site.

Ideas?

[Techiant]

I cannot get the Featured Product box in the center to display ordered.

If the sorting you referring to is in the main page for example that the above wouldn't work alone.

We dealt with this issue by modifying MySQL query in: /includes/modules/your_template/featured_products.php

Line 29
Change this:

and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";

to this:

and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' ORDER BY products_sort_order ASC";

Note: with the above code the admin will lose control over sorting featured products, but you've probably guessed that.

Moderator, sorry for reviving the old post. The solution above may help somebody else with this issue.

[hoodone]

It does'ny look like there was a clear fix for the original question. I went through all the steps even sort by product after changing the PHP like the original poster stated on 09 AUG 07 and that didn't work either. Is there a way to just fix the code so ZenCart makes it work the way it supposed to inn the first place, through ADMIN->CONFIG->FEATUREDLISTING->DISPLAYPRODUCTDISPLAY ? (

[srellarweb]

Techiant's post worked for me and it allowed the admin to change the sort order!