{"id":399,"date":"2022-02-04T16:24:13","date_gmt":"2022-02-04T16:24:13","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/is270w22\/?page_id=399"},"modified":"2022-02-04T16:24:24","modified_gmt":"2022-02-04T16:24:24","slug":"download-your-amazon-order-history","status":"publish","type":"page","link":"https:\/\/miriamposner.com\/classes\/is270w22\/download-your-amazon-order-history\/","title":{"rendered":"Download your Amazon order history"},"content":{"rendered":"\n<p>Our second Python activity today will involve analyzing your Amazon spending habits (assuming you have an Amazon account; read on for what to do if you don&#8217;t). In order to do that, you&#8217;ll need to download your Amazon order history.<\/p>\n\n\n\n<p>If you&#8217;d prefer or if you don&#8217;t have an Amazon account, you can use <a href=\"https:\/\/www.dropbox.com\/s\/7s3iqx5iaqdtl7l\/amazon-orders.csv?dl=1\">this anonymized sample data<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"get-to-the-data-download-page\">Get to the data download page<\/h2>\n\n\n\n<p><a href=\"https:\/\/www.amazon.com\/gp\/b2b\/reports?ref_=ya_d_l_order_reports&amp;\" target=\"_blank\" rel=\"noreferrer noopener\">Click here<\/a>, if you&#8217;re logged in to Amazon, to get to the download page.<\/p>\n\n\n\n<p>If the link doesn&#8217;t work for some reason, do the following: <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Once logged into Amazon, click on <strong>Accounts &amp; Lists<\/strong> (at the top right of the Amazon page).<\/li><li>On the Accounts &amp; Lists page, find the <strong>Download Order Reports<\/strong> link. (It&#8217;s under the <strong>Ordering &amp; Shopping Preferences<\/strong> heading).<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"specify-the-report-type\">Specify the report type<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"586\" height=\"463\" src=\"http:\/\/miriamposner.com\/classes\/is270w22\/wp-content\/uploads\/sites\/19\/2022\/02\/Screen-Shot-2022-02-04-at-7.44.25-AM.png\" alt=\"\" class=\"wp-image-400\" srcset=\"https:\/\/miriamposner.com\/classes\/is270w22\/wp-content\/uploads\/sites\/19\/2022\/02\/Screen-Shot-2022-02-04-at-7.44.25-AM.png 586w, https:\/\/miriamposner.com\/classes\/is270w22\/wp-content\/uploads\/sites\/19\/2022\/02\/Screen-Shot-2022-02-04-at-7.44.25-AM-300x237.png 300w, https:\/\/miriamposner.com\/classes\/is270w22\/wp-content\/uploads\/sites\/19\/2022\/02\/Screen-Shot-2022-02-04-at-7.44.25-AM-147x116.png 147w\" sizes=\"auto, (max-width: 586px) 100vw, 586px\" \/><\/figure>\n\n\n\n<p>From the <strong>Report Type<\/strong> dropdown menu, choose <strong>Orders and shipments<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"choose-a-start-and-end-date\">Choose a start and end date<\/h2>\n\n\n\n<p>You can decide how long a period you want to analyze. Any length of time will work. The larger the timespan, the longer the report will take to download, but it shouldn&#8217;t be too long in any case.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"give-the-report-a-name-if-you-want\">Give the report a name if you want<\/h2>\n\n\n\n<p>This doesn&#8217;t really matter, but you can give it a descriptive name if you want, to make it easier to download again later.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"click-on-request-report\">Click on Request Report<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"463\" height=\"209\" src=\"http:\/\/miriamposner.com\/classes\/is270w22\/wp-content\/uploads\/sites\/19\/2022\/02\/Screen-Shot-2022-02-04-at-7.58.14-AM.png\" alt=\"\" class=\"wp-image-402\" srcset=\"https:\/\/miriamposner.com\/classes\/is270w22\/wp-content\/uploads\/sites\/19\/2022\/02\/Screen-Shot-2022-02-04-at-7.58.14-AM.png 463w, https:\/\/miriamposner.com\/classes\/is270w22\/wp-content\/uploads\/sites\/19\/2022\/02\/Screen-Shot-2022-02-04-at-7.58.14-AM-300x135.png 300w, https:\/\/miriamposner.com\/classes\/is270w22\/wp-content\/uploads\/sites\/19\/2022\/02\/Screen-Shot-2022-02-04-at-7.58.14-AM-228x103.png 228w\" sizes=\"auto, (max-width: 463px) 100vw, 463px\" \/><figcaption>Click on &#8220;Request report&#8221; after specifying the &#8220;Orders and shipments&#8221; report type and specifying the start and end dates.<\/figcaption><\/figure>\n\n\n\n<p>Your report will take a few seconds (maybe up to a minute?) to generate. Then it will download automatically.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"find-the-report-you-just-downloaded\">Find the report you just downloaded<\/h2>\n\n\n\n<p>Locate the CSV file you just downloaded. For example, it might be in your Downloads folder on your computer.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"change-the-name-of-the-report\">Change the name of the report<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/miriamposner.com\/classes\/is270w22\/wp-content\/uploads\/sites\/19\/2022\/02\/Screen-Shot-2022-02-04-at-7.55.17-AM.png\" alt=\"\" class=\"wp-image-401\" width=\"300\" height=\"200\"\/><figcaption>Rename the file you downloaded.<\/figcaption><\/figure>\n\n\n\n<p><strong>THIS IS IMPORTANT.<\/strong> If you don&#8217;t do this, the tutorial won&#8217;t work without modification.<\/p>\n\n\n\n<p>Right-click, or control-click, on the file you downloaded, and select <strong>Rename<\/strong> from the context menu. Then name the file<\/p>\n\n\n\n<p><code>amazon-orders.csv<\/code><\/p>\n\n\n\n<p>The name must be exactly the same as shown above! That includes the <strong>hyphen<\/strong>, the <strong>S <\/strong>at the end of &#8220;orders&#8221; and the <strong>.csv<\/strong> file extension.<\/p>\n\n\n\n<p>Now you&#8217;re done! Leave the file where it is; we&#8217;ll come back to it later.<\/p>\n\n\n\n<div class=\"wp-block-group has-yellow-background-color has-background\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h3 class=\"wp-block-heading\" id=\"checklist\">Checklist<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Did you download the <strong>Orders and Shipments<\/strong> report?<\/li><li>Is the file you downloaded named <code>amazon-orders.csv<\/code> ?<\/li><li>Do you remember where you saved the file?<\/li><\/ul>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Our second Python activity today will involve analyzing your Amazon spending habits (assuming you have an Amazon account; read on for what to do if you don&#8217;t). In order to&hellip; <a class=\"more-link\" href=\"https:\/\/miriamposner.com\/classes\/is270w22\/download-your-amazon-order-history\/\">Continue reading <span class=\"screen-reader-text\">Download your Amazon order history<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_eb_attr":"","footnotes":""},"class_list":["post-399","page","type-page","status-publish","hentry","entry"],"_links":{"self":[{"href":"https:\/\/miriamposner.com\/classes\/is270w22\/wp-json\/wp\/v2\/pages\/399","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/miriamposner.com\/classes\/is270w22\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/miriamposner.com\/classes\/is270w22\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/is270w22\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/is270w22\/wp-json\/wp\/v2\/comments?post=399"}],"version-history":[{"count":0,"href":"https:\/\/miriamposner.com\/classes\/is270w22\/wp-json\/wp\/v2\/pages\/399\/revisions"}],"wp:attachment":[{"href":"https:\/\/miriamposner.com\/classes\/is270w22\/wp-json\/wp\/v2\/media?parent=399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}