Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 441
  • Last Modified:

[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.
0
Eddie Shipman
Asked:
Eddie Shipman
  • 2
  • 2
1 Solution
 
miked2004Commented:
What you need to do is correct the addresses and set them to Mexico and on USA. then you can limit shipping options by country.

Other wise you will have a hell of a time doing what you want.

Quick question. IF a new customer from Mexico registers and sets up there address as Mexico do you change that and set it as USA?
0
 
Eddie ShipmanAll-around developerAuthor Commented:
We don't allow them to setup accounts on the Magento side. All users are created dynamically from our own account creation process and, for some legacy reasons, they do not request country and the addresses are not in Mexico format.

Any way to modify those people's country easily using SQL?
0
 
miked2004Commented:
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.
0
 
Eddie ShipmanAll-around developerAuthor Commented:
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.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now