![]() ![]() If you want to know how many orders you have placed, sans returns and refunds for damaged shipments and such, you can also subtract the same value (number of lines minus one) found in the “Refunds” spreadsheet from your total orders. If your spreadsheet is 1,295 lines, for example, you have played 1,294 orders on Amazon. The number of Amazon orders you have placed on Amazon is the total number of lines in the “Items” spreadsheet minus one (because one row of the spreadsheet is the headers at the top). RELATED: How to See the First Amazon Purchase You Ever Made How Many Amazon Orders Have I Placed? In my case, it’s the textbook I mentioned at the start of the article. The top entry should be the earliest purchase. Or, in the Items spreadsheet, you can sort column A, “Order Date” using the A-Z sort function. You can look in the regular Orders page on your Amazon account to see the first thing you ever purchased on Amazon. What Was the First Thing I Purchased on Amazon? In the following instructions, we’ll be referencing the column letter and title with confidence it will look the same for you, but please adjust the instructions to reflect any changes to the column arrangement. The formatting of these Amazon purchase history spreadsheets has stayed very consistent over time, with reports we’ve pulled at points over the years using the same formatting conventions. With the “Items” spreadsheet and the “Refunds” spreadsheet loaded, here are some interesting questions you can answer about your Amazon purchase history and how to answer them. ![]() ![]() You can use Microsoft Excel, Google Sheets, OpenOffice Calc, or Apple Numbers, or any other spreadsheet application that supports CSV Once you have the CSV files, it’s merely a matter of opening them in your preferred spreadsheet application and using some basic spreadsheet functions like summing and sorting to pull out the data you want. How to Analyze Your Amazon Purchase History “Ya’ll aren’t gonna believe how much I’ve spent on LEGO Star Wars.” Andrey_Popov/ You’ll receive two reports, but it’s just simple spreadsheet data you can merge together. So instead of requesting an Items report that spans to the present, pick a spot in the middle and break it up like to and then to the present. If that happens, we recommend splitting up your purchase history dates. In some cases, you may even end up with a failed report request. If you have an Amazon account with lengthy purchase history, be forewarned that you may have to wait anywhere from minutes to hours for the request to complete. Second, you need to request additional reports for report type “Refunds”-you can skip requesting the “Returns” report type because Returns data only shows items physically returned to Amazon, doesn’t include the monetary amount, and doesn’t include data on items for which you received a refund but didn’t return an item (such as getting a refund for a damaged or lost shipment).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |