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
 VP-ASP 7.0 Questions
 List of products with quantity discounts		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

eadato
Starting Member

4 Posts
Posted - December 16 2013 :  14:01:40  Show Profile  Visit eadato's Homepage  Reply with Quote
I want to offer my customers a list of the products that have a volume (or quantity) discount.

Basically have shopdisplayproducts.asp show only the items that appear on the quantitydiscounts table in the database, and which have a catalogid field

Has anyone done this?

diegomilito
VP-CART Expert

Argentina
779 Posts
Posted - January 03 2014 :  02:31:31  Show Profile  Reply with Quote
i dont know exactly what are u asking, any better clues ?
diego.
Go to Top of Page

serjtankian
VP-CART Super User

Armenia
378 Posts
Posted - January 03 2014 :  07:45:35  Show Profile  Visit serjtankian's Homepage  Reply with Quote
do you mean shopdisplayproducts.asp will only show discounted product only ?






*serj*
Go to Top of Page

carfin
VP-CART Expert

United Kingdom
948 Posts
Posted - January 06 2014 :  07:34:06  Show Profile  Reply with Quote
Hi,

you can achieve this easily by creating a new file called QtyDiscDisplay.asp and then adding a link to this file on your site. I''ve tested this on our site and it works perfectly

Create the new file containing the following code:

<%option explicit%>
<!#include file="shop$db.asp">
<%
sql="quantitydiscounts.catalogId FROM quantitydiscounts WHERE quantitydiscounts.catalogId<>0"
debugwrite sql
setsess "sql", sql
response.redirect "shopdisplayproducts.asp?search=yes"
%>

Save the file and upload to your server.
Add a link to this file either manually or through your page/menu manager

Regards,

Carrol
www.deanston-electrical.co.uk

Just noticed that the post is not displaying the "SELECT" text at the start of the sql statement.
Edited by - carfin on January 06 2014 07:39:09
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
  • Your Cart Is Empty