How can I limit sales to a short list of countries

[posword]

How can I limit sales to a specified list of countries?

 

I would be preferable to ask the customer on registering or log-in to what country the products are to be shipped, and deny registration if the country is not on the list.

 

Alternatively, it could be done at checkout, rejecting orders unless the country is on the list.

 

The only entry I could find in the forum was from 2003 where a user had run a mysql script, but this only deleted sales after the fact.

 

Any ideas on how to do it, or contributions that might help?

 

Thanks,

Peter

[♥mdtaylorlrim]

You could go to http://www.blockacountry.com/ and use that to completely block all access, but it would likely be a mighty load on the server. If you use a hosting company I don't think it would make much difference.

 

I'd actually be interested in others solutions to this as well.

[Guest]

You could remove ALL countries except those you wish to sell to from the database to the customer can not create an account. OR use .htaccess to allow only IP's from the countries you want to sell from.

 

I recently did a site for which only Canadian and US IP's were allowed, this was just under 1300 IP's and it doesn't seem to put too large of a strain on the server.

 

 

 

Chris

[knifeman]

Chris, is your solution the same as what mdtaylorlrim suggests at block a country?

 

Tim.

 

 

BTW: I use a mod called region based rates for shipping. If your country is not set up as a shipping zone, then you loop through checkout. Admittedly, customers can register, add to cart and probably be mad at checkout, but we only ship to US, Canada, and UK.

All others must call for rates and prepay.

 

 

 

I recently did a site for which only Canadian and US IP's were allowed, this was just under 1300 IP's and it doesn't seem to put too large of a strain on the server.

 

 

 

Chris

[Guest]

Tim,

 

Yes, my suggestion is similar to Marks.

 

 

 

 

Chris

[midpen]

I found a huge long list if I want to block IPs from one country.

 

How and where I load this list to?

 

Thanks.

[♥mdtaylorlrim]

I found a huge long list if I want to block IPs from one country.

 

How and where I load this list to?

 

Thanks.

If you are on a hosting plan you will have to use an .htaccess file.

[midpen]

If you are on a hosting plan you will have to use an .htaccess file.

 

put the huge list in .htaccess file? is that ok?

 

Thanks

[♥mdtaylorlrim]

put the huge list in .htaccess file? is that ok?

 

Thanks

It's not ideal because the file will be read each time you get a hit. It would be better if it were in the server config file, that way it is read into memory and not for each hit... but yeah. That long list in that file. Use the right format... Order access,deny deny from..... etc.

[tigergirl]

I installed Active Countries a long time ago but the mod writer has disappeared off the face of the earth and no-one is supporting the topic. I also want to combine it with One Page Checkout/ Purchase Without Account (not installed them yet) as well as Sam's Anti Hacker Account Mods. It's all a little daunting as 2 of these mods aren't supported and I really don't know where to start as they're going to need tweaking to work together me thinks.....

 

Isn't there anythng else out there? Surely there must be loads who don't want to sell to everywhere?

[markg-uk]

The way I did it was to use the visible countries contribution. This lets you lock down the allowed countries visible when customers sign up for an account.

 

I don't use One Page Checkout/ Purchase Without Account, so have no idea how easily they would coexist or if signifcant work would be needed.