You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
I have a customer who wants all of her products to display alphabetically i.e. A - Z. Currently they appear to be sorted randomly. She has over 1400 products, so I'm looking for an easy way to change the sort order.
Any help will be greatly appreciated.
Offline
The Product Sort Order is determined by a numerical value located within System Dashboard > Store > Catalog > Products. My site uses the price to create the sort order (I update the site manually in the evening via a csv file and have the sortorder equal to the price * 100 ie 17.99 would be 1799).
I cannot think of an easy way of doing this with your store except exporting the products file as a csv, sorting it into alphabetical order, altering the sortorder to 1, 2, 3 etc and uploading the csv file back into the system.
Terry
Caracamp
Offline
The default sort order is set in each product via the Product Sort Order field in the Product tab. This is a numeric field.
You could download the ecom_prod database to excel, sort the name column alphabetically and the change the Product Sort field from 1 to however many products you have.
Offline
Thanks for your responses. I downloaded the products into a CSV file and updated the product sort order. However, they still aren't displaying correctly.
Example - Alligator Pendant 14k is Product Sort Order number 13. Shells: Clam & Triton Shell Earrings 14k is 1170. However, Shell Earrings is displayed before the Alligator Pendant.
But, I can easily sort the products in the "All Products" category to sort by name alphabetically. So I guess a better question is "can I change the default way products are sorted?"
Offline
the default sort order is defined in ECOM_prod.php very close to the top.
You can change the sortorder there.
If you testing, you will need to clear your cache and probably cookies before reloading the site. You may find the default sort order is correct after a full refresh.
Offline
I changed the ECOM_Prod.php from: if ($this->globals('ecom.prod_suppress_sort')) {$sortinfo = 'DEFAULT';} to this: if ($this->globals('ecom.prod_suppress_sort')) {$sortinfo = 'NAMEUP';} but it didn't change the default order after clearing my cache and cookies. So I'll assume I changed it incorrectly.
Any suggestions?
Offline
You changed it properly. Do a search, and in the results click DEFAULT as your sort option. Then you'll be good to go. Your sort option is tied to your session, which still came back at you when you logged into your account.
Offline
Any other suggestions for this fix. I've modified the Ecom_prod file correctly. Also I did a cache and cookie flush, but no results. Thanks for any other suggestions.
Offline