Hi all, thanks in advance for any tips or clues I can use to solve this problem.
So, I'm nearing the end of my first zen cart shop (1 month development), now it's on a windows server, and one of the client's requirements is to be able to sort via non-standard fields, ie. these fields don't exist in the product table.
The site is
Basically - I'm running a 3 product-per-column display, and have static links above the products that allow the user to sort by:
name (asc)
price low to high
price high to low
best seller *
new *
sale *
So, the first 3 fields are super easy (sort=2a,2d etc), but the last 3 are NOT. I know that "new" is in the products table, since there is a field for when it was entered, but since it's not part of the product list ordering in the admin, well, I'm screwed.
Also I need to check and cross refernce the sale tables and products ordrered tables to fetch the ID's of the products that are best sellers in this category.
I've read through this thread http://www.zen-cart.com/forum/showth...ng+sort&page=4 and others, and have not found anyone with the same exact problem and solution.
I'm pretty good at php, but not too familiar in changing around ZC's core php files to get the output (array of products in the proper order) that I need.
So, what're my options, and what files (class files too?) do I need to change? THANKS IN ADVANCE TO THIS WONDERFUL COMMUNITY!
Bookmarks