find out main country customers

[qwertyjjj]

Hi

I need to find out how many customers that have made an order come from certain countries.

I know that some choose incorrect countries in the drop down registration, so I would at least like to start with that.

Secondly, I could use geo ip stats as I have their IP addresses recorded.

Any ideas on what tables to look in and join?

[♥geoffreywalton]

You could try correcting the country in the db based on the town\city name.

 

Much simpler than cross checking IPs.

 

If it had the wrong country on the order how did they get the goods?

 

HTH

 

G