Bug in StoredProcedure [Nop_ShippingMethodLoadAll]

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
Il y a 13 ans
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 !
Il y a 13 ans
You restrict countries on that page (not allow). So it works fine
Il y a 13 ans
OK, so that was a misunderstanding because
'restricted' translated to german also means 'limited to', so
I thought only these countries are possible for shipping to -
just the opposite.

I've been only wondering where these entries in this table
come from - maybe I've played around too much on the
administration page ;-)

Thank you for answering !
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.