Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 4 of 4

Thread: Invalid state/province for UK orders

  1. 02-16-2010, 02:27 PM #1
    allstar is offline Member
    Join Date
    Apr 2009
    Posts
    90

    Default Invalid state/province for UK orders

    I am using fixed prices for shipping. When a customer from UK placed an order, he would get the following message:

    "You have selected an invalid state/province and country shipping address combination, or no shipping methods were found for your shipping address destination. Please contact us for assistance!"

    Stepping through the code, when getting shipping method list (GetShippingMethodList()), the boolean values for ShippingMethodToStateMapIsEmpty and ShippingMethodToCountryMapIsEmpty would equal false. Any ideas why this would happen? Are the tables, ShippingMethodToStateMapIsEmpty and ShippingMethodToCountryMapIsEmpty, suppose to be empty? Do I need to do something else to handle international orders?

    What tables are the following used for: ShippingMethodToStateMapIsEmpty, ShippingMethodToCountryMapIsEmpty, ShippingMethodToZoneMapIsEmpty?
    Last edited by allstar; 02-16-2010 at 03:08 PM.
    ...AllStar
  2. 02-16-2010, 03:08 PM #2
    allstar is offline Member
    Join Date
    Apr 2009
    Posts
    90

    Default

    There is a problem with the query when using fixed price. The example below is a UK order (case Shipping.ShippingCalculationEnum.UseFixedPrice):

    select * from ShippingMethod with (NOLOCK) where IsRTShipping=0 and ShippingMethodID
    in (select ShippingMethodID from ShippingMethodToStateMap with (NOLOCK) where StateID=0) and ShippingMethodID
    in (select ShippingMethodID from ShippingMethodToCountryMap with (NOLOCK) where CountryID=80)
    order by Displayorder

    It requires ShippingMethodID to be in ShippingMethodToStateMap and ShippingMethodToCountryMap. The problem here is that ShippingMethodToStateMap will not have a shipping method id since there is no state. It should be an "OR" when checking for shipping method id in both sql statements. Is this a BUG?
    Last edited by allstar; 02-16-2010 at 03:11 PM.
    ...AllStar
  3. 02-16-2010, 09:55 PM #3
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Please send into support. thanks
  4. 02-17-2010, 11:07 AM #4
    allstar is offline Member
    Join Date
    Apr 2009
    Posts
    90

    Default

    Support did confirm that this is a known bug. If anyone is having this issue, please contact them directly. This is related to international shipping when using fixed prices.
    ...AllStar