Solved

[Magento] Shipping setup help

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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Mod_Rewrite, htaccess, opencart 4 103
Wordpress & Ecommerce - what's best plugin 4 68
mysql_connect issue on xampp and opencart 3 106
What does Survey Monkey cost? 7 150
E-commerce is quite a gambling world, and you should never entrust your business to a lucky chance. In order to outrun your competitors in a race to attract as many customers as possible, you need to have a well thought-out strategy under your belt.…
Read about how to choose the best possible content marketing agency to suit your needs. Content marketing has become an integral part of running a successful tech business, so it is wise to be informed.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

820 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