Eddie Shipman
asked on
[Magento] Shipping setup help
In our database, our Mexico customers are being configured with State as MX and Country as US. This is due to a legacy data issue and I don’t want to get into that.
How can I setup USPS and UPS shipping to NOT be offered to our Mexico customers and Flat Rate shipping to be offered instead?
Here is an example of two addresses in the shipping address dropdown for one of our Mexico Customers:
Ing. Gustavo Campoy Carrillo, Boulevard Petrocel Km 2 Col. Puerto Indu, Altamira, Tam., 89603, United States
Gustavo Campoy Carrillo, Zafiro 134 Col. Colinas del Sol, Tampico, Tam., 89369, United States
How could I modify all the Mexico addresses to have Mexico as country, too, as well as set the state?
Would USPS and UPS work with just zip and city for Mexico shipping?
Edit: Actually I cannot find any customers with MX as the state, all Mexico customers have blank state and US as country.
How can I setup USPS and UPS shipping to NOT be offered to our Mexico customers and Flat Rate shipping to be offered instead?
Here is an example of two addresses in the shipping address dropdown for one of our Mexico Customers:
Ing. Gustavo Campoy Carrillo, Boulevard Petrocel Km 2 Col. Puerto Indu, Altamira, Tam., 89603, United States
Gustavo Campoy Carrillo, Zafiro 134 Col. Colinas del Sol, Tampico, Tam., 89369, United States
How could I modify all the Mexico addresses to have Mexico as country, too, as well as set the state?
Would USPS and UPS work with just zip and city for Mexico shipping?
Edit: Actually I cannot find any customers with MX as the state, all Mexico customers have blank state and US as country.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Not really, the customer address data is stored using EAV structure so it is not all in one table. It would be easier to do it with php in a controller action.
ASKER
Yeah, I think this database was complex for complex's sake. They had their head up their a$$es for sure on this one.
I have never seen a DB so complicated to understand in my 20+ years of programming.
I have never seen a DB so complicated to understand in my 20+ years of programming.
ASKER
Any way to modify those people's country easily using SQL?