Solved

[Magento] Shipping setup help

Posted on 2011-09-28
4
383 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
  • 2
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
miked2004 earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…
SSL stands for “Secure Sockets Layer” and an SSL certificate is a critical component to keeping your website safe, secured, and compliant. Any ecommerce website must have an SSL certificate to ensure the safe handling of sensitive information like…
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 video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now