This tutorial shows importing a CSV file into Google Sheets on Debian Linux 8.0, but the steps should be fairly similar on any operating system into any spreadsheet


Below is a small example of the sort of output our exports will provide. The Amazon API does not display contact information until the order is beyond Pending. If one order contains multiple items, a full row will be displayed per item.
order-id,order-item-id,asin,order-status,purchase-date,last-update-date,payments-date,buyer-email,buyer-name,buyer-phone-number,seller-sku,product-name,quantity-purchased,quantity-shipped,item-price,item-price-currency,item-tax,item-tax-currency,shipping-price,shipping-price-currency,shipping-tax,shipping-tax-currency,ship-service-level,ship-name,ship-address-1,ship-address-2,ship-address-3,ship-city,ship-state,ship-postal-code,ship-country,ship-phone-number,is-prime
111-4362111-7839111,11189801004111,B00I7V9AAA,Shipped,2015-09-01T14:11:25Z,2015-09-04T05:00:15Z,,zzzvs1mzktrzzzz@marketplace.amazon.co.uk,Denta Pen,01635 550999,TAB10KGVAR,WATER SOFTENER SALT TABLETS 10KG 2 packs large saving,1,1,15.00,GBP,0.00,GBP,0.00,GBP,0.00,GBP,Std UK Dom,Team,"C/o   Pen Den","The Pen, Street",,NEWBURY,Berks,RG,GB,01111 550999,false
111-5111111-9405111,11148644444111,B00J5PHAAA,Shipped,2015-09-01T23:04:05Z,2015-09-04T05:03:31Z,,zzz5cgjx2jfzzzz@marketplace.amazon.co.uk,H BROWN,02081237999,HYD25TABx2,2 X 25KG Hydrosoft Tablets,1,1,26.44,GBP,0.00,GBP,0.00,GBP,0.00,GBP,Std UK Dom,Tyler,Road,,,Richmond,Surrey,TWEH,GB,02111237111,false
111-1612111-5829111,11182146780111,B008JY9AAA,Shipped,2015-09-02T06:59:14Z,2015-09-04T05:16:47Z,,zzz57xdp1vczzzz@marketplace.amazon.co.uk,Giles,07799400999,HYD25TAB,"Hydrosoft Salt Tablets, 25 Kg",1,1,14.38,GBP,0.00,GBP,0.00,GBP,0.00,GBP,Std UK Dom,P,Oakridge,Street,,upper basildon,,R8NT,GB,07111400111,false
111-9025111-4252111,11161995009111,B008JY9AAA,Shipped,2015-09-02T08:21:08Z,2015-09-04T05:16:47Z,,zzznzy3hz97zzzz@marketplace.amazon.co.uk,Annette,07958647999,HYD25TAB,"Hydrosoft Salt Tablets, 25 Kg",1,1,14.38,GBP,0.00,GBP,0.00,GBP,0.00,GBP,Std UK Dom,Annette,House,"Halstead Road, Aldham",,COLCHESTER,Essex,COP,GB,07111647111,false
111-2483111-7225111,11183372110111,B008JY9AAA,Shipped,2015-09-02T08:33:10Z,2015-09-04T05:16:46Z,,zzzn52ws2j5zzzz@marketplace.amazon.co.uk,Mark,07977257999,HYD25TAB,"Hydrosoft Salt Tablets, 25 Kg",2,2,28.76,GBP,0.00,GBP,0.00,GBP,0.00,GBP,Std UK Dom,Mark,Road,,,LONDON,,SE,GB,07111257111,false
111-6443111-9948111,11100074384111,B00K243AAA,Shipped,2015-09-02T08:54:48Z,2015-09-04T05:16:47Z,,zzz5f3n4zvczzzz@marketplace.amazon.co.uk,Mrs Mary,07981691999,BLK8HARVx6,"Harvey's Salt Blocks - 6 Pack, 12 Blocks",1,1,34.30,GBP,0.00,GBP,0.00,GBP,0.00,GBP,Std UK Dom,Brian,Tootswood,,,BROMLEY,Kent,BR2,GB,07111691111,false
        

Open your spreadsheet application and select File > Import ...


Select to upload a file.


Browse to and select the file on your computer.


Choose to create a new spreadsheet and designate comma as the field delimiter.


Once the file is uploaded/processed, open it


Enable auto-filtering to begin searching, sorting, filtering your order history!



support@sellertools.co
+1 (706) 622-8846

© 2015-2018 The Moore Collective, LLC