Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 Customization
 Sort product display by price etc
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Neilt
Starting Member

44 Posts

Posted - April 10 2007 :  06:47:11  Show Profile  Reply with Quote
I'm using v6.5. Within the admin pages there is the facility to click on a column header to sort the products by price, description etc. (shopa_editdisplay.asp)

Is anyone aware of how to implement this into the shop? i.e. on shopdisplayproducts.asp?

I'm aware of xsortproducts and xproductfiltering but this doesn't provide the solution I need i.e. I want people to be able to click on the column headers to sort by that heading.

Many thanks.

Steve2507
VP-CART Expert

590 Posts

Posted - April 10 2007 :  07:01:35  Show Profile  Reply with Quote
I think this is what you are after.

If you put this code in the shopdisplayproducts.asp file, a user can click on the link and the products will display in price order.

<a href="shopfiltering.asp?sortfield=cprice&sortupdown=ASC">Ascending</a> | 
<a href="shopfiltering.asp?sortfield=cprice&sortupdown=DESC">Descending</a>


Steve
www.temptationsdirect.co.uk

Edited by - Steve2507 on April 10 2007 07:02:07
Go to Top of Page

Neilt
Starting Member

44 Posts

Posted - April 10 2007 :  09:49:09  Show Profile  Reply with Quote
Many thanks for the quick reply Steve. This does work for me thank you.

To be honest, I would still ideally prefer the same facility as exists within the admin pages. i.e. click on the column header to sort by that header. So if anyone has a solution that would still be of interest.

Best regards.

Neil
Go to Top of Page

Steve2507
VP-CART Expert

590 Posts

Posted - April 10 2007 :  14:41:02  Show Profile  Reply with Quote
No problem.

I've put the code at the top and at the bottom of the page.


Steve
www.temptationsdirect.co.uk
Go to Top of Page

dgardner35
Starting Member

19 Posts

Posted - November 07 2007 :  16:23:32  Show Profile  Reply with Quote
Hey Steve,
Could you share with me the code from the orderby... down to the page 1 of ... excluding the image in the middle.

Basically I need the I would like to add Sort by: a-z I Brand , etc.
then add the Next Page button then the page count [ 1,2,3...]

Also could you tell me which page within vpasp I add it to. I would like to add at top and bottom.

Thank you,
Donnie
www.performancefuel.com/shop

Edited by - dgardner35 on November 07 2007 16:28:42
Go to Top of Page

chrisredco
VP-CART Super User

282 Posts

Posted - May 06 2011 :  11:21:07  Show Profile  Visit chrisredco's Homepage  Reply with Quote
Steve,

Might you be able to list here or message me the code you used for the ORDER BY menu at the top and bottom of your products pages? I need something exactly like this.

Thanks,
Chris

Redco Audio
www.redco.com
Go to Top of Page

Steve2507
VP-CART Expert

590 Posts

Posted - May 08 2011 :  03:32:55  Show Profile  Reply with Quote
The order by is one of the byz plug ins (116 I think).


Steve
Sex toys from a UK sex shop including vibrators and dildos.
Go to Top of Page

devshb
Senior Member

United Kingdom
1904 Posts

Posted - May 09 2011 :  06:14:30  Show Profile  Visit devshb's Homepage  Reply with Quote
BYZ116 does indeed have configurable order-by options (where you specify the poplist description, the argument code, and the corresponding order-by sql clause for each option in a config file), and also has configurable dynamic filters and various other options (like being able to switch between page-number-links and a view-all link), and various other things, and it's the thing that drive's steve's paging/sorting stuff.

Enhanced Paging/Searching for VPASP - BYZ116:
http://www.bigyellowkey.com/mysoftware_product_details.asp?prdid=317

demo:
http://www.bigyellowzone.com/dev/vpasp70accesswithaddons/products.asp?keyword=of
that demo has dynamic filters configured and applied on the left panel (ie you get "narrow-down" links appearing on the left panel when you've done a search)

It's quite a big addon to install, but can do pretty much any kind of search/ordering/filtering, and the way it displays each "chunk" (page number links, sorting poplist etc) is quite easily tweaked. If you run into problems installing it, we can install it for you (if you bought some development points), but bear in mind that it's actually quicker/easier for us to install it ourselves from scratch rather than finishing/correcting an install that's already been partially completed by the site-owner.

Simon Barnaby
Developer
[email protected]
www.BigYellowZone.com
www.BigYellowKey.com
Follow us on Twitter: http://twitter.com/bigyellowzone
Web Design, Online Marketing and VPASP addons
Go to Top of Page

borisvel
Starting Member

Slovenia
47 Posts

Posted - March 13 2012 :  07:35:09  Show Profile  Visit borisvel's Homepage  Reply with Quote
quote:
Originally posted by Steve2507

I think this is what you are after.

If you put this code in the shopdisplayproducts.asp file, a user can click on the link and the products will display in price order.

<a href="shopfiltering.asp?sortfield=cprice&sortupdown=ASC">Ascending</a> | 
<a href="shopfiltering.asp?sortfield=cprice&sortupdown=DESC">Descending</a>


Steve
www.temptationsdirect.co.uk



Hi,

this code isn't OK, i get error

Technical Information (for support personnel)

Error Type:
Microsoft VBScript runtime (0x800A0005)
Invalid procedure call or argument: 'left'
/shopfiltering.asp, line 61


Browser Type:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Trident/5.0; SLCC1; .NET CLR 2.0.50727; InfoPath.1; .NET4.0C; .NET CLR 3.0.30729; .NET CLR 3.5.30729)

Page:
GET /shopfiltering.asp

Kind regards, Boris

www.finechance.com www.personaliziranadarila.si www.lingerie.si
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00