X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)
-   -   Shipping location dilemma (https://forum.x-cart.com/showthread.php?t=3758)

fearthespear 07-27-2003 08:45 AM

Shipping location dilemma
 
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 07-27-2003 09:59 AM

you can always...
 
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 07-27-2003 10:15 AM

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 07-27-2003 12:23 PM

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 07-27-2003 05:43 PM

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 07-28-2003 04:38 AM

you can run this sql statement in phpmyadmin

Code:

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

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

Code:

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

Be careful and backup the db first

Cameron 11-02-2003 01:48 PM

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:
Quote:

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

Hope that helps somebody else out there. :)


All times are GMT -8. The time now is 01:12 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.