Kryptronic Software Support Forum

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.

#1 05-12-2015 11:37:40

netcoservices
Member
Registered: 04-17-2008
Posts: 91

Product Sort Order

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

 

#2 05-12-2015 12:04:54

tguswell
Member
From: Plymouth, Devon
Registered: 07-31-2010
Posts: 128
Website

Re: Product Sort Order

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

 

#3 05-12-2015 12:06:34

zanart
Member
From: bedford
Registered: 04-02-2008
Posts: 1716

Re: Product Sort Order

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.


Rob

Offline

 

#4 05-12-2015 12:43:12

netcoservices
Member
Registered: 04-17-2008
Posts: 91

Re: Product Sort Order

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

 

#5 05-12-2015 12:46:28

zanart
Member
From: bedford
Registered: 04-02-2008
Posts: 1716

Re: Product Sort Order

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.


Rob

Offline

 

#6 05-12-2015 13:15:12

netcoservices
Member
Registered: 04-17-2008
Posts: 91

Re: Product Sort Order

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

 

#7 05-13-2015 04:31:42

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19871
Website

Re: Product Sort Order

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.


Nick Hendler

Offline

 

#8 07-12-2015 16:00:15

btwebmedia
Member
Registered: 08-25-2010
Posts: 150

Re: Product Sort Order

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

 

#9 07-14-2015 07:31:22

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19871
Website

Re: Product Sort Order

Turn on the debugger and look for the SQL call in the ECOM_Prod::prodlist section.  What is the SQL it's executing?  Sort order?


Nick Hendler

Offline

 

Board footer