HomeHome Product Discus... Product Discus...SmithCartSmithCartsort order of productssort order of products
Previous
 
Next
New Post
10/1/2011 11:05 PM
 
niels huve
No Ranking

Joined: 5/31/2011
Posts: 19

HI Kevin,

 

You have given the following answer a while ago to a question how to sort products alphabetically:

Hi Renee,

So just to clarify, you would like the default sort order for your products to be alphabetical correct?

If so, you can use SQL to modify the Stored Procedure "Smith_ListproductByFilter" to filter the products alphabetically by default.

Can you explan how I should do this? I have never worked with stored procedures before and to be honest I have no idea what it means.

Is there an easier way to do this?

 
 
New Post
10/3/2011 9:36 AM
 
Greg Baughman
6th Level Poster


Joined: 5/28/2010
Posts: 471
There's not an EASIER way to do it... although there are OTHER ways to do it.

Certainly the easiest way is with SSMS (SQL Server Management Studio). Find the Stored Producedure "Smith_ListProductByFilter", right click on it, and select "MODIFY".

If you need exact syntax, let me know.
 
New Post
10/3/2011 3:22 PM
 
niels huve
No Ranking

Joined: 5/31/2011
Posts: 19

Hi Greg

Thank you for your response, I appreciate it.

You would expect that there was some kind of sort function within the actual cart but apparently there is not.

Anyways, I guess I will have to work out this stored procedure thing and yes I would really appreciate if you could give me the exact syntax and also where I can find these stored procedures. I am obviously not a developer and havent had much experience with these things.

Again, thanks a lot.

 

Cheers
 
New Post
10/3/2011 4:28 PM
 
Scott Kelly
1st Level Poster


Joined: 3/11/2010
Posts: 1979
Hi Niels,
The default sort order of products when the catalog first loads is the "Sort Order" field that you configure in the product setup screen so you can set the sort order field to be alphabetical or configure it for any default sort order you like.

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
10/3/2011 6:34 PM
 
niels huve
No Ranking

Joined: 5/31/2011
Posts: 19

Thanks for that!

I missed that field when uploading the products. Although it is a bit of a pain to do this for every product it will be fine going forward.

 
 
New Post
10/4/2011 5:31 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Niels,

Glad to hear that this will be the solution for you.

Thanks,
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartsort order of productssort order of products




Questions? Contact us for answers!

Contact Us!