Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How can I limit sales to a short list of countries


posword

Recommended Posts

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

-------------------------------------------------------------------

Online since 1995! -- the home

of inspiration and motivation for generic New Testament Christians.

New books by Peter Wade now available from Amazon and others --

Our new book, Bunches of Blessings: Poems by Vivien Wade.

Link to comment
Share on other sites

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.

Community Bootstrap Edition, Edge

 

Avoid the most asked question. See How to Secure My Site and How do I...?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Community Bootstrap Edition, Edge

 

Avoid the most asked question. See How to Secure My Site and How do I...?

Link to comment
Share on other sites

  • 1 month later...

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?

I'm feeling lucky today......maybe someone will answer my post!

I do try and answer a simple post when I can just to give something back.

------------------------------------------------

PM me? - I'm not for hire

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...