Hi,
With the help of our web developer JOHNNY FUSION www.johnnyfusion.ca I would like to develop an import tool for AMAZON orders.
Does anyone have the order file specs for an Amazon order?
Cheers,
David
Amazon Order Import Specs
Started by Videoflicks2004, Dec 31 2004 07:22 AM
2 replies to this topic
#1
Videoflicks2004
-
- Moderators
-
- 241 posts
GLOBAL MODERATOR
- Gender:Male
- Location:Canada
- Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.
Posted 31 December 2004 - 07:22 AM
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.
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.
#2
Posted 01 January 2005 - 10:05 AM
Hi,
With the help of our web developer JOHNNY FUSION www.johnnyfusion.ca I would like to develop an import tool for AMAZON orders.
Does anyone have the order file specs for an Amazon order?
Cheers,
David
I (most likely me) will be doing just that after we finish (to some acceptable degree) a new site. I have written some basic logic, but it isn't even close yet. If you don't get anything else in the meantime, I will be in touch about this ~1 month estimated.
#3
rrinker
-
- Members
-
- 14 posts
Member
- Location:Reading, PA
Posted 06 January 2005 - 12:41 PM
We have built an application in VB.NET that translates the Amazon files into MOM orders for one of our clients. They have some odd naming conventions for size/color designations (our client), so there is a lot of crazy code to handle some of this that would not work for someone with a more organized SKU number system.
The biggets problem encountered so far is the Amazon is HORRIBLE at enforcing what common sense tells you are absolute MUSTS for commerce - they do NOT verify state entries, or zip codes. I see this all the time in the downloads, direct from Amazon. No consistency in state naming, missing ZIP codes, etc. I've been able to code around most of it, but it's still possible to get a state name that I haven't handled, resulting in a failure when MOM tries to import the resulting file, thus requiring someone to manually enter the order. It mostly works, but if Amazon could be a little more consistent (how about a simple 2-letter abbreviation dropdown on their order forms????? Or FULL state name, ANYTHING but free-form text entry by the customer!).
--Randy
The biggets problem encountered so far is the Amazon is HORRIBLE at enforcing what common sense tells you are absolute MUSTS for commerce - they do NOT verify state entries, or zip codes. I see this all the time in the downloads, direct from Amazon. No consistency in state naming, missing ZIP codes, etc. I've been able to code around most of it, but it's still possible to get a state name that I haven't handled, resulting in a failure when MOM tries to import the resulting file, thus requiring someone to manually enter the order. It mostly works, but if Amazon could be a little more consistent (how about a simple 2-letter abbreviation dropdown on their order forms????? Or FULL state name, ANYTHING but free-form text entry by the customer!).
--Randy
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
