Mike,

I had the following questions about where you get your values from in the final CSV documents:

1.  In the Amazon Order File, there is the purchase-date and the payments-date column.  Which one should go into the order CSV's "Date" column?

2.  I noticed that the Amazon Order file has ship-address-1, ship-address-2 and ship-address-3, while Everest only has Ship Address 1 and Ship Address 2.  I was going to make the ship-address-1 field populate Everest's "Ship Address 1" column and combine ship-address-2 and ship-address-3 to populate Everest's "Ship Address 2" column.  Is this okay?

3.  I remember your "Ship Country" column in the Orders CSV file had some discrepancies between Amazon and Everest.  For example, in Amazon the US is called "US" and in Everest it is called "US United States."  Am I remembering this correctly?  If so, I can make it so that you can specify what amazon country value maps to what everest value.

4.  I also remember that the Ship Postal Code column had some special logic.  Did it have shortened zip codes that are only 5 digits long?  Did it extend the zip code from amazon?  What was it exactly?

5.  In the Order Items CSV fle, how do you get the Product ID?  Do you derive it from the sku amazon field?  Is there some kind of table that would map SKU numbers to Product IDs?

Let me know what the answers are to these questions.

Thanks,

-Other Mike