Mail Order Manager & Dydacomp Sitelink Tech Support Forums: International Orders & 3-char State Field - Mail Order Manager & Dydacomp Sitelink Tech Support Forums

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

International Orders & 3-char State Field It's just not enough

#1 johnay

Advanced Member

Group: Members
Posts: 92
Joined: 07-September 05

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

GLOBAL MODERATOR

Group: Moderators
Posts: 241
Joined: 29-September 04
Gender:Male
Location:Canada
Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 06 February 2006 - 07:34 PM

johnay, on Feb 6 2006, 10:51 PM, said:

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

dnarciso@cvsinc.ca

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

GLOBAL MODERATOR

Group: Moderators
Posts: 241
Joined: 29-September 04
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.

#4 johnay

Advanced Member

Group: Members
Posts: 92
Joined: 07-September 05

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.