Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


Forgot your Password?
 All Forums
 VPCart Forum
 Customization
 Shop Search tweak		  New Topic  Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

surplus
Starting Member

Canada
16 Posts
Posted - October 27 2023 :  15:41:05  Show Profile  Visit surplus's Homepage  Reply with Quote
Hello,

We would like the search results on our VPASP cart to show by default only products with a lowprice > .01

I know this can be manually set on the shopsearch page --- https://www.fcsurplus.ca/shopping/shopsearch.asp

But we would like to always exclude products in the search result that have a price of zero.
So I added this to shopsearch.asp

if lowprice =0 then
lowprice = .01
end if

The interesting thing is that the result should be correct if you click the url below ---
https://www.fcsurplus.ca/shopping/shopdisplayproducts.asp?Search=Yes&sppp=&Keyword=boots&lowprice=0.01&allwords=boots&exact=&searchfields=

But it does not work if the search is done from the cart.
It appears that the cart somehow does the search first and then generates the results page and then posts the url address onto the browser.

Has anyone had any experience with the VPASP product search system?

Thanks,
Bob
Edited by - surplus on October 28 2023 21:20:35

diegomilito
VP-CART Expert

Argentina
779 Posts
Posted - October 30 2023 :  05:19:18  Show Profile  Reply with Quote
it''s been a while since I last checked the forum. are you v8 user or v9 user?? i need to remember first.
when you say:it does not work if the search is done from the cart. do you mean if we search from the top right of your site??

diego
Go to Top of Page

surplus
Starting Member

Canada
16 Posts
Posted - October 30 2023 :  14:55:15  Show Profile  Visit surplus's Homepage  Reply with Quote
HI Diego,

We are using VPASP version 8.0
If we use shopsearch and input a minimum price of .01 on this page --- https://www.fcsurplus.ca/shopping/shopsearch.asp

We get this result --- https://www.fcsurplus.ca/shopping/shopdisplayproducts.asp?Search=Yes&sppp=&Keyword=boots&lowprice=.01&allwords=boots&exact=&searchfields=cname,%20cdescription,%20ccode,%20keywords,%20POTHER4

If we use the search box on the top of the page we get this result --- https://www.fcsurplus.ca/shopping/shopdisplayproducts.asp?Search=Yes&sppp=&Keyword=boots&lowprice=0.01&allwords=boots&exact=&searchfields=

Our goal is to simply not show searched products with a price below .01 as those products are discontinued.

If this is going to be a big project we will certainly pay VPCART for the programming work.

Thanks,
Bob


Go to Top of Page

diegomilito
VP-CART Expert

Argentina
779 Posts
Posted - October 31 2023 :  04:47:14  Show Profile  Reply with Quote
Bob, to make sure I''ve got it right, are you telling me that the search result from https://www.fcsurplus.ca/shopping/shopsearch.asp is correct, and the search result from the top right search box returning wrong result?

diego
Go to Top of Page

surplus
Starting Member

Canada
16 Posts
Posted - October 31 2023 :  19:01:38  Show Profile  Visit surplus's Homepage  Reply with Quote
Hi Diego,

The best way to explain is for you to try it yourself.
If you go to our site https://www.fcsurplus.ca/ and enter BOOTS into the search box that is on the main page and press enter, you will see a page displaying many types of boots.
Some pages have no prices and we would like to hide them from customers as they are discontinued.

If you go to this page https://www.fcsurplus.ca/shopping/shopsearch.asp
and search for BOOTS with a low price of .01 you will see the result that we would like customers to see.

I hoped that this would be simple but there seems to be many individual programs involved in generating a search result.

We keep the discontinued products on our site to retain our connection with search engines.

Thanks,
Bob
Go to Top of Page

diegomilito
VP-CART Expert

Argentina
779 Posts
Posted - November 01 2023 :  04:57:06  Show Profile  Reply with Quote
Bob, now I totally get it. I''m playing around with the v8 code to see if I can send you a way to do it.

diego
Go to Top of Page

diegomilito
VP-CART Expert

Argentina
779 Posts
Posted - November 01 2023 :  06:07:42  Show Profile  Reply with Quote
ok i tried an experiment and seems to work for me.

shopdisplayproducts_subs.asp:
sql = "* from products where CatalogId=" & CatalogId
you may just update to below:
sql = "select * from products where CatalogId=" & CatalogId & " AND cprice > 0.01"

diego
Go to Top of Page

surplus
Starting Member

Canada
16 Posts
Posted - November 01 2023 :  11:36:57  Show Profile  Visit surplus's Homepage  Reply with Quote
Hi Diego,

I added your suggested change to shopdisplayproducts.asp

sql = "* from products where CatalogId=" & CatalogId & " AND cprice > 0.01"

and this error message was generated at the bottom of the display products page --
ADODB.Field error ''800a0bcd''
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/shopping/shop$db.asp, line 2207

So I commented the line out.

Bob
Go to Top of Page

diegomilito
VP-CART Expert

Argentina
779 Posts
Posted - November 02 2023 :  03:14:06  Show Profile  Reply with Quote
Bob,,I refer to file shopdisplayproducts_subs.asp, not shopdisplayproducts.asp.
please check again. i dont get the error with the fix i sent you.

diego.
Go to Top of Page

surplus
Starting Member

Canada
16 Posts
Posted - November 02 2023 :  10:21:25  Show Profile  Visit surplus's Homepage  Reply with Quote
Hi Diego,

I really appreciate that you have tried to help us but there is no shopdisplayproducts_subs.asp program in our version of VPASP. I believe we have version 8.0. I will try to setup a support request with VPASP.

Thanks,
Bob
Go to Top of Page
   Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00
  • Your Cart Is Empty