Shipping Rate problem

I seem to be having a problem with Shipping rates. I only have 2 options - Customer Pickup & Second Class. The rates are set by weight - up to 0.1kg = 0.46, up to 0.5kg = 0.50, up to 1kg = £1.00 etc, and shipping is only available for the UK, all the rest have been disabled. However when testing the Shipping dropdown shows the following:

"Customer pickup"

"Second Class ex Tax: £12.77 Inc Tax: £12.77"

When you click on the Second Class option the wording does change to "Second class", but then will calculate a seemingly arbitrary rate (£0.39 etc)

I have altered the [spKartrisShippingMethods_Get] stored procedure as found in another post on this site regarding a shipping bug but this hasn't seemed to work. Is there something else I have missed?

(Unfortunately I am on version 1.2 which was installed as an app by my ISP so I have little control over upgrading to 1.3)

Any help or suggestions grateful received

Asjeff

Author	Message
asjeff	Posted Sun 26 Jun 2011
Supreme Being Group: Forum Members Last Active: Thu 30 Jun 2011 Posts: 3, Visits: 547 2,141	I seem to be having a problem with Shipping rates. I only have 2 options - Customer Pickup & Second Class. The rates are set by weight - up to 0.1kg = 0.46, up to 0.5kg = 0.50, up to 1kg = £1.00 etc, and shipping is only available for the UK, all the rest have been disabled. However when testing the Shipping dropdown shows the following: "Customer pickup" "Second Class ex Tax: £12.77 Inc Tax: £12.77" When you click on the Second Class option the wording does change to "Second class", but then will calculate a seemingly arbitrary rate (£0.39 etc) I have altered the [spKartrisShippingMethods_Get] stored procedure as found in another post on this site regarding a shipping bug but this hasn't seemed to work. Is there something else I have missed? (Unfortunately I am on version 1.2 which was installed as an app by my ISP so I have little control over upgrading to 1.3) Any help or suggestions grateful received Asjeff Tags shipping rates
	REPLY QUOTE LIKE 343
Mohammad	Posted Sun 26 Jun 2011
Kartris Expert Group: Administrators Last Active: Sun 27 Sep 2015 Posts: 115, Visits: 706 80,913	Hi, Where did you run the Alter statement ? Did you use the db admin in the backend ? if so, please try to run it on the db directly and see if that fixed.
	REPLY QUOTE LIKE 342
asjeff	Posted Sun 26 Jun 2011
Supreme Being Group: Forum Members Last Active: Thu 30 Jun 2011 Posts: 3, Visits: 547 2,141	Thanks Mohammad I did run it on the DB directly (didn't actually realise you could do it through the backend). However on checking the logs I notice that I have the following entry: ----------------------------------------------------------------------------- >> 26/06/2011 17:01:07 >> 94.175.5.205 >> DESCRIPTION: BasketBLL.CalculateShipping Error - DestinationID: 0 ShippingID: 1 Does this give you any clues as to what I am doing wrong? Cheers Adam
	REPLY QUOTE LIKE 374
Mohammad	Posted Mon 27 Jun 2011
Kartris Expert Group: Administrators Last Active: Sun 27 Sep 2015 Posts: 115, Visits: 706 80,913	Hi Adam, I recommend you to have 1.3x as 1.2 has some issues with shipping and 1.3x has alot more features than 1.2 If you have FTP and db connection details which are enough to do the upgrade, if you decided to do the upgrade make sure to keep a backup of everything (files and db) before doing any step, and to use the latest data tool version, anyway if you want i can help you doing that, just let me know. Edited Tue 28 Jun 2011 by Mohammad
	REPLY QUOTE LIKE 338
asjeff	Posted Mon 27 Jun 2011
Supreme Being Group: Forum Members Last Active: Thu 30 Jun 2011 Posts: 3, Visits: 547 2,141	OK, will do. Thanks very much - but there's a very good chance I'll be pestering you for some more help later. regards Asjeff
	REPLY QUOTE LIKE 352

Shipping Rate problem

Shipping Rate problem

Similar Topics

Reading This Topic