Solved

[Magento] Shipping setup help

Posted on 2011-09-28
4
400 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
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

How important is it to take extra precautions to protect your online business? These are some steps you can take to make sure you're free of any cyber crime.
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
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.

809 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