You are right about configuration and store.

For some reason 222 was showing where United Kingdom had previously been showing. I fixed it and will try again. Hopefully that was the only problem apart from the SQL thing above.