Thread: product placement change

I would like to change the order in which my product is placed on my site. On my set up screen for product i do not have a display order button. So there is no way to move a product to a higher spot on my page to be viewed.

To change the default sorting display of your products, you'll have to modify the aspdnsf_GetProducts stored proc. If you open that up, at the bottom of that procedure change Order BY pf.rownum to p.name if you want to sort it according to their names, or otherwise.

First. Where do i find: aspdnsf_GetProducts stored proc. I did not see it in the root or config files.... and Second: i would like to set my products arbitrally....

Product display order is set at the entity level, not the product level (since the entity is what displays the products within it) as explained in the manual. You can set that display order any way you like.

The aspdnsf_GetProducts stored procedure is in the database btw, you're not going to find that in a file.