Hi,
Maybe I'm wrong, but it seems to me that there is a bug in SP [Nop_ShippingMethodLoadAll].
If shipping is enabled to several countries only, these countries are inserted in table:
[Nop_ShippingMethod_RestrictedCountries].
During checkout, I get the message that shipping isn't possible to the selected country because
the SP doesn't load a shipping method - please have a look at the following query:
SELECT sm.* FROM [Nop_ShippingMethod] sm
WHERE sm.ShippingMethodID NOT IN
(
SELECT smc.ShippingMethodID
FROM [Nop_ShippingMethod_RestrictedCountries] smc
WHERE
smc.CountryID = @FilterByCountryID AND
sm.ShippingMethodID = smc.ShippingMethodID
)
Shouldn't this 'NOT IN' be better an 'IN' to get the right result ?!?
(this problem exists up to current version 1.70 of NopCommerce)
Thanks !