Sort Order?

Tom · #1 01-27-2010, 06:07 AM

Hello,

Is there a way to create a "sort order" that would sort the products by the title? (Numeric first and the alphabetically)

Basically I have a list of courses being offered to my clients. I would like to order them by the date of the course. The dates are displayed in my title.

Here is my page:

http://www.negotiationexpertise.com/...=0&sort=normal

Thanks in advance

Qetzal · #2 01-27-2010, 10:34 AM

Quote:

Originally Posted by Tom

Hello,

Is there a way to create a "sort order" that would sort the products by the title? (Numeric first and the alphabetically)

Basically I have a list of courses being offered to my clients. I would like to order them by the date of the course. The dates are displayed in my title.

Here is my page:

http://www.negotiationexpertise.com/...=0&sort=normal

Thanks in advance

1. You can sort these products in any order you want in your Ecwid control panel. Just drag-n-drop your products to sort.

2. If you want to have a built-in "sort by name" option, please vote for this idea:
http://ideas.ecwid.com/forums/22031-...ical?ref=title

craig.cooper · #3 01-28-2010, 01:47 PM

Code:

//Will Sort alpahbetically by title, and hide the headings.
tableSort = function (page) {
      if ( $j(".ecwid-productBrowser-productsTable-table").length ) {        //Is table there?
        $j(".ecwid-productBrowser-productsTable-table colgroup").remove();

	if ( $j(".ecwid-productBrowser-productsTable-table thead").length ) {
                     $j('.ecwid-productBrowser-productsTable-table').trigger("update");
                     var sorting = [[1,0]];
		     $j("table").trigger("sorton",[sorting]);
		return true;
		} else {
      $j('.ecwid-productBrowser-productsTable-table').prepend("<thead style='display: none;'><tr><th>SKU</th><th>NAME</th><th>PRICE</th><th>BUY</th></tr></thead>")
      $j.tablesorter.addParser({
        id: 'productID',
        is: function(s) { 
            return false;
        }, 
        format: function(s) {
	    k = s.replace(/(<([^>]+)>)/ig,"");
	    return k;
        }, 
        type: 'text'
      });

      $j('.ecwid-productBrowser-productsTable-table').tablesorter({
            headers: {
                1: {
                    sorter:'productID',

                }
            },   sortList: [[1,0]]
        });
      return true;
      }
   } else return false;
}

addMod(tableSort, "category");

add this to your <head>

Code:

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js" type="text/javascript"></script> 
<script src="http://www.ciedesign.co.uk/temp/ecwidMods.js" type="text/javascript"></script> 

<script src="http://www.ciedesign.co.uk/temp/tablesorter/jquery.tablesorter.js" type="text/javascript"></script> 
<script src="http://www.ciedesign.co.uk/temp/tableSort.js" type="text/javascript"></script>

The bottom one can be modified and uploaded to your server if you want to modify it.

DEMO

Jackman Music Corporation · #4 07-14-2010, 09:59 PM

Craig,

Loved your sorting alphabetically demo. I've tried to implement it on my site, but am trying to figure out where each piece of code goes... Script code goes simply in the head. right?

But where/how do I use your other code?

Gary Williamson · #5 08-10-2010, 03:52 PM

Where do you go in the control panel for drag-n-drop sorting of the product order?

Qetzal · #6 08-10-2010, 04:30 PM

Quote:

Originally Posted by Gary Williamson

Where do you go in the control panel for drag-n-drop sorting of the product order?

You can sort them on the "Catalog → Categories" page. Click the necessary category and select the "Category Products" tab.

Gary Williamson · #7 08-10-2010, 04:34 PM

Okay, thanks. I guess I have to come up with some categories now.

Qetzal · #8 08-10-2010, 05:21 PM

Quote:

Originally Posted by Gary Williamson

Okay, thanks. I guess I have to come up with some categories now.

http://kb.ecwid.com/How-to-order-you...nIsortthemnbsp

Kellijean Press · #9 08-21-2010, 10:17 PM

Quote:

Originally Posted by qetzal

1. You can sort these products in any order you want in your Ecwid control panel. Just drag-n-drop your products to sort.
]

I appreciated seeing this suggestion - but I can't seem to find where to do this.

In my control panel, in the products tab, I see a table list of all of my products, but if I try to select an item - it only selects the text.

Where is this awesome sorting option? I would love to be able to sort my items.

thanks!

Qetzal · #10 08-23-2010, 12:05 PM

Quote:

Originally Posted by Kellijean Press

I appreciated seeing this suggestion - but I can't seem to find where to do this.

In my control panel, in the products tab, I see a table list of all of my products, but if I try to select an item - it only selects the text.

Where is this awesome sorting option? I would love to be able to sort my items.

thanks!

- Go to the Catalog → Categories.
- Click the necessary category.
- Go to the "Category products" tab.
- Drag and drop products to sort them.
- Save the changes.