Product Listing Sorter Drop-Down [Support Thread]

This mod REPLACES the stock alphasorter drop-down in the product listing (as referenced/enabled in Admin->Configuration->Product Listing->Include Product Listing Alpha Sorter Dropdown) with a configurable list of sorting options.
This is NOT a filter: all the products are displayed in the chosen order.

This is a development of the Product Filter Module and has been uploaded as a new mod, since it "sorts", not "filters".

Now available
http://www.zen-cart.com/downloads.php?do=file&id=1612

Does this filter by price too?

James

...a configurable list of sorting options.
yes, that's included in the mod as-is, but the point is you can easily add/remove whatever options you deem necessary.

Great Mod!!

How to set a default sort order like "Newest" for all categories and subcategories?

Cheers!

I too have the same problem. Please indicate what line to modify in order to have the DEFAULT SORT ORDER be for Newest Items Descending.

I already have it set under Admin -> Configuration -> Product Listing -> Display Product Listing Default Sort Order -> 20a

However, your code (under index_filters/default_filter) isn't clear on what to change in order to sort by NEWEST ITEMS ADDED.

Since it doesn't look like this module is supported by the creator (judging by the lack of response in this thread from the last poster), I have uninstalled the module. If you have the time to address this issue, I would be more than happy to reinstate this module on our website to test it out for you.

I have done a 1.3 version of this which is completely different from the existing version 1.2.

1. A new configurable sorting drop-down leaving the current available drop-downs (Manufacturer filter and Alpha-Sort filter) and column-heading sorting functionality intact so you can use all three drop-downs at the same time.
2. Use of the column-heading sorting functionality resets the new sorter drop-down.
3. The filtered and sorted listing order is retained when entering a product info page and returning to the listing.
4. The filtered and sorted listing order is used when using the product info page prev/next navigation.

As its been quite difficult :wacko: to get working I'd like some help to test it as much as possible before uploading it, so please pm me with your email address to get a copy.

thanks
Steve

I have installed the Product Listing Sorter module. Is there a way to copy this alpha sorter to the All Products page?

Is there a way to copy this alpha sorter to the All Products page
There already is a sorter there, better to modify that one.

Ok, my version 2.0 is now available in the plugins
http://www.zen-cart.com/downloads.php?do=file&id=1612

its a very different animal than the previous attempts (ie it works...), it adds a new drop-down instead of replacing whats already there. If you want to see it working, select a bike type on my site motorvista dot es / tienda

I have recently uploaded this plugin on 3 of my 5 zencart based eshops.

All 3 of them are being constantly injected with trojan viruses since then. Not sure how it´s possible, but I didn´t make any other changes to the sites and as I said, those that have not been upgraded with this mod are clear. I´m using v1.1

All 3 of them are being constantly injected with trojan viruses since then.
How are these viruses being detected on your remote sites?

They are detected by my antivirus (this is what you were asking, right?)

"my antivirus"
This is unclear.
I mean which antivirus software flags the trojan and where do you see the warning:

• when you access the sites through a browser (which browser)?
• some sort of notification from your hosting service?
• on your local development server?
  Details....screenshots....etc.

Trojans are detected by my antivirus (Eset), I see this when accessing sites through all browsers

multiple files are affected (index.html, various php files, etc, files that are not linked only to this plugin) and malicious code is inserted into it. I manually clean each and every file, so I´m very sure it´s there.

I don´t have crystal clear proof this is happening because of this plugin, but:
1.) I didn´t make any changes in last year except of this one
2.) Those sites that are nut upgraded with this plugin are still clear

So I assume, there has to be a link between these.

So I assume, there has to be a link between these.
Logical...but I can't see how...so more info needed..

So, ESET flags a trojan and then you examine the page on the hosting server and find a load of extra code in it which you clean out and ESET is then happy?
What version of Zen Carts are you using on these sites?

and a link to an infected site by private message please.

I´m using both 1.38 and 1.50 versions, will PM you url of sites

Hello, thank you for this mod, however I cannot seem to get it going, I have installed all the files, but get the following error if I select one of the menu items in the dropdown except -Reset- which works fine:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by p.products_sort_order, pd.products_name limit 0, 15' at line 18
in:
[SELECT DISTINCT p.products_model, p.products_image, p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status, p.master_categories_id FROM (products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c ) LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ((pd.products_name LIKE '%speed%' OR p.products_model LIKE '%speed%' OR m.manufacturers_name LIKE '%speed%' OR (mtpd.metatags_keywords LIKE '%speed%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%speed%' AND mtpd.metatags_description !='')) )) order by m.manufacturers_name order by p.products_sort_order, pd.products_name limit 0, 15]

What and which file should I edit to change it to the correct syntax?

I assume you are using the current v2.0?

order by m.manufacturers_name order by p.products_sort_order, pd.products_name limit 0, 15]
The problem is there are two order clauses.

This is on the product listing?

What do you have defined here?
\includes\languages\english\extra_definitions\product_listing_sorter_en.php

define('PRODUCT_LISTING_SORTER_LIST', '
      Name (asc)d.products_name;
      Name (desc)d.products_name DESC;
      Model (asc).products_model;
      Model (desc).products_model DESC;
      Price (low to high).products_price_sorter;
      Price (high to low).products_price_sorter DESC;
      Manufacturer:m.manufacturers_name;
      Newest.products_date_added DESC;
      Most Popular: p.products_ordered DESC
      ');

Yes, version 2.0, there is no file called product_listing_sorter_en.php only one named product_listing_sorter.php and it is the default one from the zipped package.

define('PRODUCT_LISTING_SORTER_LIST', '
Name (asc):pd.products_name;
Name (desc):pd.products_name DESC;
Model (asc):p.products_model;
Model (desc):p.products_model DESC;
Price (low to high):p.products_price_sorter;
Price (high to low):p.products_price_sorter DESC;
Manufacturer:m.manufacturers_name;
Newest:p.products_date_added DESC;
Most Popular: p.products_ordered DESC
');