product index sort order problem

[pivey]

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

[gjh42]

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

Can you post a link?

[Ajeh]

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

[pivey]

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

[pivey]

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

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.

[Ajeh]

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

[pivey]

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

[imageriot]

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

[Ajeh]

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

[imageriot]

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