Can specials be sorted?

[britneycook]

That worked BRILLIANTLY .. thank you sooooooo much for that!

Youre a magic legend!!!!

Also, you have:
sort_order

in the WHERE ... if this is from the table:
products

that should be:
p.products_sort_order

NOTE: the p is not really needed as it is unique but it helps with clarity ...

NOTE: If you added a new field to the table:
specials

for sort order, make sure that you spelled it correctly ...

[Ajeh]

Thanks for the update that this is now working ...

What that suppose to be the products_sort_order or a new sort field in the specials table?

[SoftCorpse]

Hi there, I would like to add a filter to the "new products" page to list by a specific model only, so basically what the filter "model" already does, but just to list a specific model type. Which files would I need to edit in order to achieve this?

Thanks for any help provided!

[Ajeh]

You can customize the file:
/includes/pages/products_new/header_php.php

and customize the $products_new_query_raw SELECT statement to include any filter that you are wanting ...

[SoftCorpse]

Thanks Ajeh!

So I'd want to then add another statement such as:

p.products_model=*product model inserted here*

Or what should add in there to include the specific model?

[Ajeh]

That should filter it for a particular model ... test it and see if that does what you are looking for ...

[SoftCorpse]

Okay, it accepts the code, however there is no extra menu item added, just the default ones are listed. Is there a file I should edit in order to add another menu item to the drop down?

[Ajeh]

You might try working your way through the template file tpl_products_new_default.php and see what all files are used for that page and for building the dropdown ...

It may take quite a bit of work to add on additional things, as the dropdown is shared by other files ...

What are you trying to add to the dropdown list?

[SoftCorpse]

Well currently the default drop down menu has a few ways to filter the new products, I would like to add a custom filter a customer can click to filter all products with a specific model number, so basically add an extra filter statement to list products such as this (if it could work like this):

p.products_model='MODEL-01'
and
p.products_model='MODEL-02'

and so forth.
I have a lot of products added with the same model number and want those to be filtered and listed without a customer having to go through pages and pages of new products which is not of interest for them. I want them to be able to click on the drop down and be able to list all products with a model number of "model-01 or model-02 or model-03" and not have all the models of all the new products be listed together if you understand what I mean.

[Ajeh]

Does the Model list need to be a dropdown or can it just be an input field for the customer to type in the model that they want to filter for?