Import Transactions from Amazon.Com Shopping Cart

We added a sample template for use with the Amazon.com shopping cart. Below is the structure of the transaction information. Usually you download it not as XML but as TXT.

<orderid>058-2758970-7873356</orderid>
  <orderitemid>5.27E+13</orderitemid>
  <purchasedate>2005-07-05T09:31:44-07:00</purchasedate>
  <paymentsdate>2005-07-05T09:31:54-07:00</paymentsdate>
  <buyeremail>raymond@email.com</buyeremail>
  <buyername>Raymond Doe</buyername>
  <buyerphonenumber />
  <sku>M17546BN</sku>
  <productname>A sample product</productname>
  <quantitypurchased>1</quantitypurchased>
  <itemprice>29</itemprice>
  <itemtax>0</itemtax>
  <shippingprice>4.99</shippingprice>
  <shippingtax>0</shippingtax>
  <giftwrapprice />
  <giftwraptax />
  <shipservicelevel>Standard</shipservicelevel>
  <recepientname>Raymond Doe1</recepientname>
  <shipaddress1>1802 South Street</shipaddress1>
  <shipaddress2 />
  <shipaddress3 />
  <shipcity>Newport Beach</shipcity>
  <shipstate>CA</shipstate>
  <shippostalcode>12345</shippostalcode>
  <shipcountry>US</shipcountry>
  <giftwraptype />
  <giftmessagetext />

The corresponding template is located in the Q-Import installation directory. The file is amazon.zip. When it is unzipped, it contains the template and a amazon sample record (Amazon_Shopping_Cart.txt).The template itself is named amazon.xslt. We implemented the following specifics:

  • The template first adds the customer and then attaches a sales receipt to that customer. If the customer is already defined in QuickBooks, we issue a warning and attach the sales receipt to that customer.
  • The SalesTaxCodeReference for the customer is 'Non'
  • As item 'Uncategorized Item' is used, because Amazon has an item description, but no item reference yet. We also used 'Uncategorized Item' for shipping expenses. So, please either make sure that you have added 'Uncategorized Item' to your QuickBooks item list or just change the template to the items you use.
  • The date format we use is 4.
 
 
 

Last modified: 12/31/2007