With the number of the final row, such as J40 Scroll to the bottom and combine column J "Refund Amount" with column K "Refund Tax Amount" using the function Because the refund report provides the purchase price refund and tax refund in separate columns, we need to combine them. Now, repeat the process by creating a SUM function on the "Refunds" report.
The resulting value is the sum of the column and represents the total amount of money you have paid Amazon. Is the value of the last data row, such as AD1209 Scroll to the bottom of the column and create a simple sum function in your spreadsheet application like =SUM(AD2:ADX) Other columns in the spreadsheet, such as column M "Purchase Price Per Unit," show the pre-tax price, and column L, "List Price Per Unit," shows the list price, not the actual price. To get an accurate look at how much you have spent on Amazon over the years, we need to use the SUM function to add up two values: how much you've paid out to Amazon and how much they've refunded you.įirst, in the "Items" spreadsheet, you need to locate column AD, "Item Total." This column indicates what you actually paid with the tax included. 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). 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? If you've ever wondered how much you've spent in total on Amazon, what your most expensive purchase was, how much you spend every year in your flurry of last-minute Amazon-centered Christmas shopping, or anything else that can be quantified and sorted about your Amazon spending habits, you can dig in and find out. We've looked at how to check your first Amazon purchase-my first Amazon purchase, a textbook, was pretty boring-and today, we're going to dig even deeper into your Amazon purchase history to help solve all sorts of curiosities. Related: How to See the First Amazon Purchase You Ever Madeįor the rest of us, though, it's largely a matter of curiosity. In fact, the tools we will use in the how-to portion of the article are intended for business use, but we're borrowing them to root around in our purchase histories. Why Check Your Amazon Purchase History?įor some folks, carefully tracking purchases is part of their business operations. If you're curious exactly how much money you've ever spent on your Amazon account, there's a way to check the total. Most of us have spent quite a bit of money on Amazon over the years, especially during the pandemic. How to See Your Amazon Purchase Totals and More.Why Check Your Amazon Purchase History?.26, 2018: Added information about disabling shipping notifications. According to Amazon, either option excludes a purchase from being considered in your recommendations.
For any product you don't want Amazon using for its recommendations, click the box for Don't use for recommendations or This was a gift. From Amazon's home page, click Browsing History under the search box and then click Improve Your Recommendations on the line just below Browsing History near the top of the page. To remove a product from recommendation consideration, you will need to access your Amazon account from the web (I can't find a way to do this on the mobile app). Using my 10-year-old son as an example, I don't want him to stumble across Nerf gun recommendations when he's going to unwrap a giant Nerf gun on Christmas morning. Kill recommendationsĭeleting and disabling your browsing history isn't enough to protect against spoiling a holiday surprise, because Amazon offers recommendations based on the categories you've been browsing. You can also delete and disable your browsing history from the Amazon mobile app by going to Your Account > Browsing history > Manage.