product index sort order problem

I can't figure this out.
Product index sort order "price descending" is not working properly.
I am using a custom template.
In admin, the "Display Product Listing Default Sort Order" is left blank

Where did you get the template? Some makers coughTMcough mangle standard Zen Cart functions...

Can you post a link?

Check that your field for products_price_sorter is filled in ...

If you import data or change it in any manner other than the Zen Cart Admin core files, there is a good chance this field, which is used for the sorting, is not being updated correctly ...

Oh, sorry.... i did not receive an email to you response
Thanks Ajeh, will check this out as it really seems that only that kind of products are not sortetd.
Will let you know

Of course this did the trick....
Thank you Ajeh :cool:

I have defined the v_products_price_sorter in my products import .txt and did an update to the database as those fields where empty.

Note: there is an updater in the Tools ... Store Manager ... that will update the products_price_sorter based on the master_categories_id ...

Providing that field is filled in this is a quick way to set the products_price_sorter ...

If you do not have the master_categories_id and do not use Linked Products then there is also an updater for the master_categories_id that you can run first ...

Of course there is ...I forgot it with all that stuff & tools in the admin.
Thank you

Ive tried running the updater in store manager on a zencart with 20,000 products and every time I get error 500.

This is probably related to a timeout issue as 20,000 products is a lot to update ...

You can try upping this time by editing the file:
/admin/store_manager.php

and changing the time from:

  zen_set_time_limit(600);

to something like:

  zen_set_time_limit(1800);

This is the number of seconds on the timeout ... see if that helps you ...

I can't find zen_set_time_limit in admin/store_manager.php is it inside one of that pages include files perhaps?

What version of Zen Cart are you running?

What is the ID of the store_manager.php on your server?

Thanks for your replies Ajeh,

I'm running zen cart version 1.3.7

Im not sure what you mean about the ID of store_manager.php, where would I find that?

I have just looked at the file store_manager.php locally taken straight from the installation folder (zen-cart-v1.3.7-full-fileset-12302006) and I can't find 'zen_set_time_limit' in that file either.

Attached is the code for store_manager.php I hope this helps

oops ... guess we are adding that in the upcoming v1.3.8 ...

Change the code to read:

  zen_set_time_limit(600);
  switch($action) {

Try that first, then increase the 600 ... again this is seconds

Thanks!

I'll see if that does the trick.

Rory

Im still getting an error 500 even after using the zen_set_limit, I went as high as 2600 but still no joy.

What should be in the SQL field for this, does it duplicate the products_price field, if so I will do it manually

No it calculates based on master_categories_id the lowest Price that a Product can be and places that in the products_price_sorter field ...

Check that all of your indexes are part of your database tables compared to a clean install ...

Missing or conflicting indexes will really slow down the process ...