ProductCart Shopping Cart Software Forums : sort by sku https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 10 Apr 2026 18:44:49 +0000 Sat, 08 Mar 2014 23:06:25 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=5816 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[sort by sku : It worked!!! Thank you so much....]]> https://forum.productcart.com/sort-by-sku_topic5816_post21880.html#21880 Author: ym
Subject: 5816
Posted: 08-March-2014 at 11:06pm

It worked!!! Thank you so much.]]> Sat, 08 Mar 2014 23:06:25 +0000 https://forum.productcart.com/sort-by-sku_topic5816_post21880.html#21880 <![CDATA[sort by sku : Thanks for the clarification.This...]]> https://forum.productcart.com/sort-by-sku_topic5816_post21876.html#21876 Author: Guests
Subject: 5816
Posted: 07-March-2014 at 11:43pm

Thanks for the clarification.

This is easy to tweak.

In /pc/showfeatured.asp, find:
		Case "0": querySort = " ORDER BY pcprod_OrdInHome asc"
replace that with the following:
		'Modified to sort by date entered by default:
		'Case "0": querySort = " ORDER BY pcprod_OrdInHome asc"
		Case "0": querySort = " ORDER BY pcprod_OrdInHome ASC, products.pcprod_EnteredOn DESC"

Then find:
query="SELECT distinct products.idProduct, products.sku, products.description, products.price, products.listHidden, products.listPrice, products.serviceSpec, products.bToBPrice, products.smallImageUrl, products.noprices, products.stock, products.noStock, products.pcprod_HideBTOPrice, products.pcprod_OrdInHome, products.formQuantity, products.pcProd_BackOrder FROM products, categories_products, categories WHERE products.active=-1 AND products.showInHome=-1 AND products.configOnly=0 AND products.removed=0 " & queryNFS & " AND categories_products.idProduct=products.idProduct AND categories.idCategory=categories_products.idCategory AND categories.iBTOhide=0 " & query1 & querySort
Replace that with the following:
'Modified to include to include products.pcprod_EnteredOn:
'query="SELECT distinct products.idProduct, products.sku, products.description, products.price, products.listHidden, products.listPrice, products.serviceSpec, products.bToBPrice, products.smallImageUrl, products.noprices, products.stock, products.noStock, products.pcprod_HideBTOPrice, products.pcprod_OrdInHome, products.formQuantity, products.pcProd_BackOrder FROM products, categories_products, categories WHERE products.active=-1 AND products.showInHome=-1 AND products.configOnly=0 AND products.removed=0 " & queryNFS & " AND categories_products.idProduct=products.idProduct AND categories.idCategory=categories_products.idCategory AND categories.iBTOhide=0 " & query1 & querySort
query="SELECT distinct products.idProduct, products.sku, products.description, products.price, products.listHidden, products.listPrice, products.serviceSpec, products.bToBPrice, products.smallImageUrl, products.noprices, products.stock, products.noStock, products.pcprod_HideBTOPrice, products.pcprod_OrdInHome, products.formQuantity, products.pcProd_BackOrder, products.pcprod_EnteredOn FROM products, categories_products, categories WHERE products.active=-1 AND products.showInHome=-1 AND products.configOnly=0 AND products.removed=0 " & queryNFS & " AND categories_products.idProduct=products.idProduct AND categories.idCategory=categories_products.idCategory AND categories.iBTOhide=0 " & query1 & querySort

If you actually assign sort order values to your featured products in the Control Panel, those will trump with this query. If you don't, then everything will be ordered by the date added to the database.

You can therefore have the best of both by using the ordering option in the CP if you want to pop certain products to the top, else everything will be ordered by date entered from most recent to oldest.


]]> Fri, 07 Mar 2014 23:43:49 +0000 https://forum.productcart.com/sort-by-sku_topic5816_post21876.html#21876 <![CDATA[sort by sku : Thank you for the reply. I&#039;m...]]> https://forum.productcart.com/sort-by-sku_topic5816_post21874.html#21874 Author: ym
Subject: 5816
Posted: 07-March-2014 at 10:37pm

Thank you for the reply. I'm reffering to the featured products page. (showfeatured.asp)
And I meant "order by".
 
I'm adding new products frequently and when this page (showfeatured.asp) is loaded, I'd like to show new products first.
]]> Fri, 07 Mar 2014 22:37:05 +0000 https://forum.productcart.com/sort-by-sku_topic5816_post21874.html#21874 <![CDATA[sort by sku : Are you referring to this display...]]> https://forum.productcart.com/sort-by-sku_topic5816_post21872.html#21872 Author: Guests
Subject: 5816
Posted: 07-March-2014 at 9:33pm

Are you referring to this display on the home page, the featured products page, or both? And do you really mean "sort by" (a user interface option) or just "order by" (a database query option)?

Just looking for a some clarification to be able to assist you with what you really want here.
]]> Fri, 07 Mar 2014 21:33:25 +0000 https://forum.productcart.com/sort-by-sku_topic5816_post21872.html#21872 <![CDATA[sort by sku : I&#039;d like to display all...]]> https://forum.productcart.com/sort-by-sku_topic5816_post21870.html#21870 Author: ym
Subject: 5816
Posted: 07-March-2014 at 9:23am

I'd like to display all featured products by sku, newly added products first and older products in the last row. It looks like by default, it's opposite. Does anybody know the solutions? Thank you.]]> Fri, 07 Mar 2014 09:23:48 +0000 https://forum.productcart.com/sort-by-sku_topic5816_post21870.html#21870