Solved

[Magento] Shipping setup help

Posted on 2011-09-28
4
412 Views
Last Modified: 2013-11-18
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
Comment
Question by:EddieShipman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
miked2004 earned 500 total points
ID: 36814965
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
 
LVL 26

Author Comment

by:EddieShipman
ID: 36816305
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
 
LVL 12

Expert Comment

by:miked2004
ID: 36816780
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
 
LVL 26

Author Comment

by:EddieShipman
ID: 36818060
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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Often people are aiming at development of perfect Magento websites. Though, it is easier said than done. You know what’s much easier? To ruin everything. It can be done in seconds. Many of us experimented with design, tried to change some values dir…
Every business owner understands the significance of online customer reviews and the impact it can have on sales and revenues. With technology advancing at such a rapid pace, getting online reviews has never been easier, especially when many regions…
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question