VP-Cart Shopping Cart

Welcome, Guest ( Customer Panel | Login )

All Forums

VPCart Forum

General help me questions

Price Range

New Topic

Reply to Topic

Printer Friendly

Author

Topic

vaheh
VP-CART New User

USA
115 Posts

Posted - May 09 2013 : 18:23:35

Hi,

I am using price range shipping method and facing a problem.

xshippingcalc = pricerange

It is setuped in a way to:

If cart total 0- 100 show UPS Ground and charge 10 for US
And
If cart total 100-2500 FREE shipping via FedEx Ground for free

If my cart total is 50 which is less than 100 still is showing both option to the customer.

I want the customer only be able to choose the shipping method based on his cart total.

I am using VP 7 with regular multipage checkout.

Please help me.
Thanks

diegomilito
VP-CART Expert

Argentina
779 Posts

Posted - May 09 2013 : 22:32:48

my questions, are u using UPS realtime and fedex realtime . OR are you setting up UPS Ground as STATIC ship method and FedEx Ground static ship method ??

if you use all realtime for both,i dont think it is an easy setup using common configuration, but more to the custom code.
Diego.

vaheh
VP-CART New User

USA
115 Posts

Posted - May 10 2013 : 11:07:07

Hi Diego,

Non of them are real time. All are static.

Thanks,
Vaheh

vaheh
VP-CART New User

USA
115 Posts

Posted - May 17 2013 : 20:16:46

Hi Diego,

I have did the following mod and looks it is working. I am posting it here so maybe someone else has the same problem or you can check to see if it is correct or not.

Around line:
218 at shopshippingcalc.asp I have changed the original one:

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
else
CloseRecordSet rsship

SQL = SQL & " order by shipmethod"

set rsship = Server.createobject ("ADODB.Recordset")
rsship.open SQL, dbc, adOpenForwardOnly, adLockReadOnly, adCmdText
end if

xxxxxxxxxxx TO: xxxxxxxxxxxx

else
CloseRecordSet rsship

SQL = SQL & " and shipcost1 < " & cdbl(GetSess("orderproducttotal")) & " and shipcost2 > " & cdbl(GetSess("orderproducttotal"))
SQL = SQL & " order by shipmethod"
''response.Write(SQL)

set rsship = Server.createobject ("ADODB.Recordset")
rsship.open SQL, dbc, adOpenForwardOnly, adLockReadOnly, adCmdText
end if

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I don''t know the way that I did is correct or not or there is any other more proper way to do it but look likes it is working.

Thanks,
Vaheh

diegomilito
VP-CART Expert

Argentina
779 Posts

Posted - May 29 2013 : 05:18:15

your code seems to be fine from my view. good job for you vaheh.
Diego.

Topic