Jump to content


Photo

International Orders & 3-char State Field


  • Please log in to reply
3 replies to this topic

#1 johnay

johnay

    Advanced Member

  • Members
  • PipPipPip
  • 92 posts

Posted 06 February 2006 - 06:51 PM

We've been gearing up to import orders into MOM, and in anticipation I recently limited the State fields on our online order form to three characters.

Unfortunately the UK doesn't seem to use such abbreviations, and we have too many UK customers for MOM to be worth dumping them.

Has anyone used MOM to handle orders from the UK?

Thanks for any insight!
JA

#2 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 06 February 2006 - 07:34 PM

We've been gearing up to import orders into MOM, and in anticipation I recently limited the State fields on our online order form to three characters.

Unfortunately the UK doesn't seem to use such abbreviations, and we have too many UK customers for MOM to be worth dumping them.

Has anyone used MOM to handle orders from the UK?

Thanks for any insight!
JA

View Post


Hey,

Good point! You should never have to consider losing a customer demographic because MOM can't handle importing their address requirements.

Have you considered mapping the online codes to a table with your codes that work in MOM. It is a messy fix but that is exactly what I had to do with Canada Post and MOM.


Best,

David

Future SAGE ACCPAC user... we're movin' on up!
David Narciso
Ecommerce Operations Manager CVS Inc

[email protected]

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.

#3 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 07 February 2006 - 04:13 AM

Doh! For a second there I couldn't see my reply post...
I was worried that the I got censored for mentioning another system.
David Narciso
Ecommerce Operations Manager CVS Inc

[email protected]

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.

#4 johnay

johnay

    Advanced Member

  • Members
  • PipPipPip
  • 92 posts

Posted 07 February 2006 - 06:03 AM

Thanks David.

I had put in the three-character limit to reduce the likelihood of typos & wierd spelling & abbreviation variations, but I suppose I could just process out most of those, dropping periods & spaces & the like, and maybe build an alias file for the rest as they come up. We'll be switching to a dropdown list for the country anyway, so that should at least narrow the possibilities.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users