SIGforum.com    Main Page  Hop To Forum Categories  The Lounge    Interesting (and perhaps useful) Amazon order history spreadsheet
Page 1 2 
Go
New
Find
Notify
Tools
Reply
  
Interesting (and perhaps useful) Amazon order history spreadsheet Login/Join 
member
Picture of henryaz
posted
 
Mentioned in an article on Ars Technica, you can download a csv file (import to Excel or Numbers) of Amazon purchases over a date range. The history only goes back to 2006, but it is interesting to get the whole thing.
 
Log in, click on your account. IOW, don't just hover over it for the drop down list. Click it to get all of your account options. Go to "Ordering and Shopping Preferences"/"Download Order Reports". I set it to the whole (available) enchilada, which is 2006-01-01-->today, during which time I've spent more than I thought at Amazon. It lists each item, description, list price, purchase price, seller, payment method, and other less useful information. The total sort of amazed me at first, but on reflection of the time period covered, as well as some big ticket items I've bought, not so surprising.
 

This message has been edited. Last edited by: henryaz,
 
Posts: 10887 | Location: South Congress AZ | Registered: May 27, 2006Reply With QuoteReport This Post
Just for the
hell of it
Picture of comet24
posted Hide Post
I'm afraid to do this. Smile


_____________________________________

Because in the end, you won’t remember the time you spent working in the office or mowing your lawn. Climb that goddamn mountain. Jack Kerouac
 
Posts: 16477 | Registered: March 27, 2004Reply With QuoteReport This Post
Member
posted Hide Post
I'm definitely going to have to check that out. If nothing else, I can see where it would save me from having to check year-to-year history when I'm trying to remember from whom I may have purchased a particular item.

Thanks.


------------------------------------------------------------------------------------------------------------------------------------
"And it's time that particularly, some of our corporations learned, that when you get in bed with government, you're going to get more than a good night's sleep."
- Ronald Reagan
 
Posts: 5785 | Location: Pegram, TN | Registered: March 17, 2002Reply With QuoteReport This Post
thin skin can't win
Picture of Georgeair
posted Hide Post
Yeah, looking at that will best be done later. In private...



You only have integrity once. - imprezaguy02

 
Posts: 12852 | Location: Madison, MS | Registered: December 10, 2007Reply With QuoteReport This Post
Member
posted Hide Post
Damn... Another thing that has to be DELETED from the Cloud upon my death!!!! Can't have this info fall into the wrong hands.

Andrew



Duty is the sublimest word in the English Language - Gen Robert E Lee.
 
Posts: 868 | Registered: May 01, 2010Reply With QuoteReport This Post
Made from a
different mold
Picture of mutedblade
posted Hide Post
15K since 2011. Not too bad. I'd be curious to see the same results from my Costco account Eek


___________________________
No thanks, I've already got a penguin.
 
Posts: 2868 | Location: Lake Anna, VA | Registered: May 07, 2012Reply With QuoteReport This Post
Member
posted Hide Post
I got $10,200 since 2013 for 384 items. Jeez, they do add up and I am surprised at how much I've order. Prime makes it too easy.
 
Posts: 1089 | Location: Fort Worth, Texas | Registered: August 11, 2010Reply With QuoteReport This Post
goodheart
Picture of sjtill
posted Hide Post
I download this every year to document deductible items for our rental houses.


_________________________
“Remember, remember the fifth of November!"
 
Posts: 18556 | Location: One hop from Paradise | Registered: July 27, 2004Reply With QuoteReport This Post
Drill Here, Drill Now
Picture of tatortodd
posted Hide Post
Thanks for the tip. I've been an Amazon shopper for nearly 2 decades, but thanks to both Prime and Subscribe & Save 58.7% of my spending has occurred since June '16.

This is a great time to remind people to shop on Amazon Smile instead of regular Amazon. It only takes two steps to have 0.5% of your Amazon spending go to charity:
  • Sign up for a charity on Amazon Smile. There may be more, but I know of two Sigforumites with charities that are Amazon Smile listed - Hawktalk and AKSuperDually.
  • Shop at smile.amazon.com instead of amazon.com

    It doesn't cost you anything (Amazon gives to charity) and you could be helping your favorite cause just by doing something you would normally do.



    Ego is the anesthesia that deadens the pain of stupidity

    DISCLAIMER: These are the author's own personal views and do not represent the views of the author's employer.
  •  
    Posts: 23853 | Location: Northern Suburbs of Houston | Registered: November 14, 2005Reply With QuoteReport This Post
    Comic Relief
    Picture of Eponym
    posted Hide Post
    After approx 1 minute:
    "Your report will continue to process even if you leave this page. You will receive an email when your report is finished. Reports should finish in a few seconds for most users but if you have lots of orders or there are lots of requests it may take longer."

    After another 15+ minutes, still no email. What's that smell? It smells like fried electronics. I've ordered a lot of stuff.

    ETA: I restarted the report twice. All times the report status eventually shows "Failed".

    ETA2: I specified a smaller date range (2010 to present) and the report worked.
     
    Posts: 4827 | Location: Indianapolis, IN | Registered: September 28, 2005Reply With QuoteReport This Post
    Three Generations
    of Service
    Picture of PHPaul
    posted Hide Post
    Just north of $20K since 2006. I was a little overwhelmed until I realized that:

    A) That's about $1700 a year and;

    2) $4K of that was my generator.

    What I've saved with Prime shipping plus the time and gas I haven't spend wandering all over Eastern Maine looking for stuff makes it well worth it IMHO.

    EDIT: I told the wife about the download and had her venture a guess as to the total. Her first shot at it was $100K !!! (Wish I'd known that, I'd have a LOT more toys!)




    Be careful when following the masses. Sometimes the M is silent.
     
    Posts: 15609 | Location: Downeast Maine | Registered: March 10, 2010Reply With QuoteReport This Post
    Just for the
    hell of it
    Picture of comet24
    posted Hide Post
    quote:
    Originally posted by Eponym:
    After approx 1 minute:
    "Your report will continue to process even if you leave this page. You will receive an email when your report is finished. Reports should finish in a few seconds for most users but if you have lots of orders or there are lots of requests it may take longer."

    After another 15+ minutes, still no email. What's that smell? It smells like fried electronics. I've ordered a lot of stuff.

    ETA: I restarted the report twice. All times the report status eventually shows "Failed".

    ETA2: I specified a smaller date range (2010 to present) and the report worked.


    The same thing happened to me. Had to enter a smaller range to get it to work. Maybe I had too many orders.


    _____________________________________

    Because in the end, you won’t remember the time you spent working in the office or mowing your lawn. Climb that goddamn mountain. Jack Kerouac
     
    Posts: 16477 | Registered: March 27, 2004Reply With QuoteReport This Post
    Raised Hands Surround Us
    Three Nails To Protect Us
    Picture of Black92LX
    posted Hide Post
    I am not good with Excel.
    I downloaded it and see all the individual items.
    908 in all.
    But I am not seeing the grand total spent and don't really want to type in all 908 and add them together.

    How are you all determining the grand total spent?


    ————————————————
    The world's not perfect, but it's not that bad.
    If we got each other, and that's all we have.
    I will be your brother, and I'll hold your hand.
    You should know I'll be there for you!
     
    Posts: 25788 | Registered: September 06, 2003Reply With QuoteReport This Post
    member
    Picture of henryaz
    posted Hide Post
    quote:
    Originally posted by Black92LX:
    How are you all determining the grand total spent?

    This might also work in Excel, I don't know. In Numbers (Mac), highlight an entire column and down at the bottom in the status bar place, it shows the Sum, Average, Min, Max, and Count. You can also use this same feature by just highlighting any few cells with the same sort of data in them.
     
     
    Posts: 10887 | Location: South Congress AZ | Registered: May 27, 2006Reply With QuoteReport This Post
    Member
    Picture of jprebb
    posted Hide Post
    quote:
    Originally posted by Black92LX:
    How are you all determining the grand total spent?

    Column AD is the item total. One way of add everything in that column is to left the first item and drag all the way down to the last item then look at the bottom right of the excel window and it will display average, total
    count, and sum.

    JP
     
    Posts: 2096 | Location: Maryland | Registered: April 19, 2003Reply With QuoteReport This Post
    Member
    Picture of jprebb
    posted Hide Post
    BTW, I've spent almost 58K since 2008! Yikes! Although some of this was for work, but still.

    JP
     
    Posts: 2096 | Location: Maryland | Registered: April 19, 2003Reply With QuoteReport This Post
    Res ipsa loquitur
    Picture of BB61
    posted Hide Post
    Where is the grand total of $$$ spent? I ran the rpeort but didn’t get a running total just the cost for each item.


    __________________________

     
    Posts: 12642 | Registered: October 13, 2002Reply With QuoteReport This Post
    Staring back
    from the abyss
    Picture of Gustofer
    posted Hide Post
    quote:
    Originally posted by jprebb:
    BTW, I've spent almost 58K since 2008! Yikes! Although some of this was for work, but still.

    JP

    Beat me. I'm at 45K since '06.


    ________________________________________________________
    "Great danger lies in the notion that we can reason with evil." Doug Patton.
     
    Posts: 20865 | Location: Montana | Registered: November 01, 2010Reply With QuoteReport This Post
    Staring back
    from the abyss
    Picture of Gustofer
    posted Hide Post
    quote:
    Originally posted by BB61:
    Where is the grand total of $$$ spent? I ran the rpeort but didn’t get a running total just the cost for each item.

    In Excel, highlight the "P" column (just click on the P. Then go to the "formulas" tab and click on Autosum (Greek sigma). Your total will be at the bottom of the column.


    ________________________________________________________
    "Great danger lies in the notion that we can reason with evil." Doug Patton.
     
    Posts: 20865 | Location: Montana | Registered: November 01, 2010Reply With QuoteReport This Post
    goodheart
    Picture of sjtill
    posted Hide Post
    quote:
    Shop at smile.amazon.com instead of amazon.com


    My charity is FIRE, the Foundation for Individual Rights in Education. They promote free speech on campuses, a cause that should be near and dear to all of us.


    _________________________
    “Remember, remember the fifth of November!"
     
    Posts: 18556 | Location: One hop from Paradise | Registered: July 27, 2004Reply With QuoteReport This Post
      Powered by Social Strata Page 1 2  
     

    SIGforum.com    Main Page  Hop To Forum Categories  The Lounge    Interesting (and perhaps useful) Amazon order history spreadsheet

    © SIGforum 2024