X-Cart forums

[fearthespear]

I only ship to USA but I can have people register from all over the world (in hopes of they have someone to ship to in the USA). How can I make sure that their shipping address is a U.S. address?

I do not want to have to refund people just because they think that my box allows you to select any country therefore I will ship anywhere. Can someone help please.

[Xcart-Man]

LOOK at the orders...u know, to SEE if the address is in the USA. Make sure you have 'only ship to US" so everybody can see it. Decline all non-US orders.

[shan]

I would remove all countries apart from usa and make a point of stating that you only ship within the us and that if anyone wants to buy anything and they dont live in the us then they should get in touch with you

[Mad]

Or you could prefill the "Country" field in the order/registration form, and then grey it out, so that US is fedault and that it cannot be changed.

Then also state somewhere on the site that you only accept orders from the US.

[fearthespear]

Thanks for your input everyone. however I like Shan's idea the best. shan, how can I delete all these other countries except for USA?

[shan]

you can run this sql statement in phpmyadmin

DELETE FROM xcart_countries WHERE "code" != "us";

or if you empty the whole countries table then just run this statement to just add US

INSERT INTO xcart_countries VALUES ('United States','US','English','iso-8859-1','Y','N','');

Be careful and backup the db first

[Cameron]

Maybe it's a SQL version thing, but that first string deleted all my countries, and the second wouldn't add US. I did it manually and the string that PHP myAdmin returned that was performed was:

INSERT INTO `xcart_countries` ( `country` , `code` , `language` , `charset` )
VALUES (
'United States', 'US', 'English', 'iso-8859-1'
);

Hope that helps somebody else out there.