Kryptronic Software Support Forum

Tom Slick · 12-10-2009 12:42:06

Is there any way to sort a-z the product related categories for the relationships? I'm sure it's sorted some way, but it makes it hard to find different ones when they are not in alphabetical order.

Thanks,
Tom

webmaster · 12-14-2009 10:01:39

They're sorted according to their 'sortorder' field. To get them to go alphabetically, adjust the sort order numeric for the products so they match the alphabetic order.

Tom Slick · 12-14-2009 17:42:20

Thanks Nick, although it's not exactly what I was hoping for. Can I go into the backend database and get it ti sort differently?

webmaster · 12-15-2009 09:54:11

Go to System > Database > Raw Database Admin, and choose to 'Maintain' the 'ecom_cat' table.

Click 'Modify Table: Modify the defintion for this database table.' For 'Order By Columns', change:

splashdisp DESC, sortorder ASC

To:

name ASC, sortorder ASC

Tom Slick · 12-15-2009 13:38:39

That's the one I was looking for! Worked perfect.

Thanks Nick.

ZipSkins · 04-28-2010 05:20:24

I have also tried Nick's instruction at #4, but it is not having any effect. The sorting appears to be random, as it is also not following the 'sortorder' field.

Does anyone have any suggestions as to what might be going wrong?

Thanks in advance.

Nigel

Dave · 04-28-2010 05:28:02

What Nick posted in number 4 will sort things by name alphabetically first and by sort order second. If you want them purely alphabetically remove the ,sortorder ASC from what he posted. I assure you they aren't being displayed randomly

ZipSkins · 04-28-2010 05:46:04

Thanks Dave, but I had tried that and it didn't make any difference - they still appear in what looks (on the face of it!) to be a random order! It's not following the sortorder field, and it's not the ID, so I'm perplexed...

Nigel

ZipSkins · 04-29-2010 03:48:30

The odd thing is that in some cases, the sub-categories do appear sorted in the specified order (i.e. according to sortorder ASC) - but not all!

Is there perhaps a 'default' setting that is applied in a program file?

Nigel

Last edited by ZipSkins (04-29-2010 03:51:24)

davidwanderson · 04-29-2010 15:42:59

Hello - can anyone tell me how to sort products in alpa order as the default - so they're in alpha order when the page loads?

ZipSkins · 04-30-2010 02:56:48

David,

Theoretically, the advice at post #4, and then at #7, should work - it would appear that in the case of the original poster, it worked satisfactorily. I would therefore suggest that you try those suggestions. Unfortunately, on the site I am working on, it does not work - and that is what I am looking for a solution for!

Nigel

Graham · 05-03-2010 07:16:16

AHA! I think I've just cracked it...

I have 389 products in my catalogue and I've just noticed that the SORTORDER field counts from 1 to 100, but then it goes *back* to 1 again! Consequently product 101 gets listed as product 1 and is sorted before product 2 etc.

I've just used Excel to renumber the column from 1-389 and used Raw Database Admin/ Modify to set ecom_prod to sort on sortorder ASC and it seems to be working properly :-)

It looks like there's a problem with the Europacart7 Importer routine which appears to assume you're not going to have more than 100 products.

ZipSkins · 05-03-2010 08:21:43

As I understand it, the values in the sortorder field could occur multiple times within the catalogue, as the products would be sorted within their categories. Thus 10 products in category A could have sortorder values from 0 to 9; and 10 products in category B could also have sortorder values from 0 to 9. Of course, you would have to be careful of instances where products are in more than one category - this is the case in the example I have mentioned above. Sorting alphabetically by name should resolve that issue, but for some reason it is still not working.

Nigel

ZipSkins · 05-03-2010 12:18:22

I have now found a solution to part of the problem.

The ordering of sub-categories within their respective parent categories (in the menus) is determined by the order in which the sub categories appear in the xcat field of the parent category. Ordering the content of the xcat field does not appear to have an effect on the ordering of the list on the parent category page, but at least the menus look right now.

Nigel

davidwanderson · 09-01-2010 15:17:23

Greetings. After following all the steps (4, 7) I still do not have an alpha sort by product display name.

I would like the default display setting to be ASC by product display name.

Any ideas? (V7).

Kryptronic Software Support Forum

#1 12-10-2009 12:42:06

Sorting product related categories

#2 12-14-2009 10:01:39

Re: Sorting product related categories

#3 12-14-2009 17:42:20

Re: Sorting product related categories

#4 12-15-2009 09:54:11

Re: Sorting product related categories

#5 12-15-2009 13:38:39

Re: Sorting product related categories

#6 04-28-2010 05:20:24

Re: Sorting product related categories

#7 04-28-2010 05:28:02

Re: Sorting product related categories

#8 04-28-2010 05:46:04

Re: Sorting product related categories

#9 04-29-2010 03:48:30

Re: Sorting product related categories

#10 04-29-2010 15:42:59

Re: Sorting product related categories

#11 04-30-2010 02:56:48

Re: Sorting product related categories

#12 05-03-2010 07:16:16

Re: Sorting product related categories

#13 05-03-2010 08:21:43

Re: Sorting product related categories

#14 05-03-2010 12:18:22

Re: Sorting product related categories

#15 09-01-2010 15:17:23

Re: Sorting product related categories

Board footer