Amazon, I dare you!

[DawnM]

Did you know you can find out how much you have spent on Amazon for as long as you  have had an account?

 

It will tell you how much you have ever spent on the site.

 

I can't believe I did it, HOLY COW!     :ohmy:  :ohmy:  :ohmy:  :ohmy:

 

Now, we get all sorts of things, car tires, food, Christmas gifts, books, all homeschool materials, and more.....

 

BUT.....seeing that huge number!!!!!  I could have gotten a decent car!

 

http://www.businessinsider.com/how-to-see-how-much-youve-spent-on-amazon-in-your-lifetime-2016-2

Edited December 29, 2017 by DawnM

[Meriwether]

I don't think I'd want to know.

[SparklyUnicorn]

Yeah I'm not going to look at that.

 

:leaving:

[JIN MOUSA]

I'm not sure I want to know how much damage I've done.

 

Between their purchase of Whole Foods and rumored interest in Target, DH and I have joked that we might as well just go ahead and make them an authorized party on our bank account.

[ILiveInFlipFlops]

WOW  :huh:  I don't think I'm going to tell DH about this.

[Guest]

Almost every Christmas gift for 5 kids for 5 years, all our regular household items for 3 years, some furniture, etc., I’m sure it is a big number.

[plansrme]

I've always said that if anyone ever steals my credit card number and only uses it on Amazon, I will never know.  Seriously--you could go on forever, and I would never know to report you.  I've actually tried hard this Christmas to diversify my spending, but I didn't do a great job.  That would be a great New Year's resolution for me--spend elsewhere!

[Wheres Toto]

Where can you find this information that I probably don't want to know?

 

[Arcadia]

I have an Amazon account since the early 90s when I was an undergrad but I think I average a handful of small value purchases a year because the big ticket purchases are on my husband’s account.

[prairiewindmomma]

And if I were to tally the amount that I've saved by ordering on amazon......probably equally a high number.  For the very vast majority of items I've purchased, I would've spent more buying them from a big box store...if I could find the item at all.  

 

ETA: real life example from this week....I take a curcumin supplement for my joints. The chain health food store in my area is one of the few places I can find it locally.  I headed there to find bulk spices, and decided to reprice my supplements. One bottle of the supplement was $39.  I came home, ordered online with free next day service, and got it for $17 a bottle from amazon.  

Edited December 29, 2017 by kbeal

[JudoMom]

I almost did it, but chickened out.

Mine only goes back to 2006, but I've ordered since 2002. 

[JIN MOUSA]

I could see the good ol' days, when I only ordered books from Amazon.

[DawnM]

Where can you find this information that I probably don't want to know?

 

There is a link in my OP, but basically

 

Amazon.com

Your Account

 

Find the section:  Ordering and Shopping Preferences

click "Download Order Reports"

 

You can specify the amount of time to report.  Mine was 11 years.  

[Lady Florida.]

Oh dear. I'm not ready to find out.

[Elizabeth86]

Oh heck no. I do not want to know.

[Night Elf]

I'm clueless. It would only let me go back to 2006 but I've been buying since 1998. Plus it generated an Excel sheet and I don't have Excel so I couldn't use any of its features. I could see how much each line was but didn't see a running total. Where do you see that, or do I have to use Excel features to add a column? 

[Wheres Toto]

There is a link in my OP, but basically

 

Amazon.com

Your Account

 

Find the section:  Ordering and Shopping Preferences

click "Download Order Reports"

 

You can specify the amount of time to report.  Mine was 11 years.  

 

D'oh, I didn't even notice that.  

 

Interestingly, it wasn't where the article said and my screens didn't look like that.  

 

It actually wasn't as bad as I thought considering it's been 5 years.

[eternalsummer]

Well, we use it for the business too, so I expected it to be a lot worse than it was (although we've only had this one since the start of the year - in previous years we shared one with my mom, and I can't access it anymore as we switched).  Only $5k for the year, and that includes shipping supplies and ink and printers and etc. - not bad!

 

Now, if there were a way to total my grocery receipts for the last 5 years, I'm sure I would be depressed.  I could have bought a house with what we spend in groceries over the course of a few years.  (a small house)

 

 

[gardenmom5]

I really don't want to know - most of dudeling's (and my) sups, xmas, birthdays, etc. etc.

I do monthly reconciliations and have to go back through every purchase every month to track it.

I got the amazon card so I could get 5% back . . . .

[Joules]

Dh and I are out at a restaurant drinking margaritas, which is an excellent time to take a look. Unfortunately it only goes back to 2006. The number wasn’t the six figures that dh predicted, but with those other years....

 

The first thing I bought from amazon was Our Babies, Ourselves by Meredith Small in April 1998. Ds was 6 months old.

 

ETA: The most recent thing I bought was the textbook for his sophomore university English class. Amazon has brought me almost full circle!

Edited December 29, 2017 by Joules

[EMS83]

Mean averages: $114/month and $25/item  3% of the orders were over $100.  13% under $5.  Ok I'll stop.   :lol:

[gardenmom5]

There is a link in my OP, but basically

 

Amazon.com

Your Account

 

Find the section:  Ordering and Shopping Preferences

click "Download Order Reports"

 

You can specify the amount of time to report.  Mine was 11 years.  

 

that might make doing reconciliations easier . . . and faster.

[Joules]

I'm clueless. It would only let me go back to 2006 but I've been buying since 1998. Plus it generated an Excel sheet and I don't have Excel so I couldn't use any of its features. I could see how much each line was but didn't see a running total. Where do you see that, or do I have to use Excel features to add a column?

You have to use a spreadsheet to sum the column. We were able to do it in Numbers on the iPad.

[DawnM]

Well, we use it for the business too, so I expected it to be a lot worse than it was (although we've only had this one since the start of the year - in previous years we shared one with my mom, and I can't access it anymore as we switched).  Only $5k for the year, and that includes shipping supplies and ink and printers and etc. - not bad!

 

Now, if there were a way to total my grocery receipts for the last 5 years, I'm sure I would be depressed.  I could have bought a house with what we spend in groceries over the course of a few years.  (a small house)

 

True that!

[EMS83]

I'm clueless. It would only let me go back to 2006 but I've been buying since 1998. Plus it generated an Excel sheet and I don't have Excel so I couldn't use any of its features. I could see how much each line was but didn't see a running total. Where do you see that, or do I have to use Excel features to add a column? 

 

I just totaled the item total column.  Shipping isn't factored in, either.  Just price and tax.

[Night Elf]

Why will it only let me go back to 2006? I've spent a lot of money more than double the price of my car but it would be even higher if it would let me go back to 1998.

[unsinkable]

The way I read your thread title, I thought Amazon had done something wrong and you were daring THEM not to fix it .

 

And I thought, "Uh-oh, Amazon. Dawn is MAD. Watch out!"

 

:lol:

[Seasider]

Yeah I think that's a figure that could go along with others like Lifetime Library Fines and What It Cost To Color My Hair For Four Decades. All clearly go on the Things Best To Remain Oblivious To list.

[EMS83]

I could barely use the internet in 1998... :o

[Corraleno]

Dh and I are out at a restaurant drinking margaritas, which is an excellent time to take a look. Unfortunately it only goes back to 2006. The number wasn’t the six figures that dh predicted, but with those other years....

 

The first thing I bought from amazon was Our Babies, Ourselves by Meredith Small in April 1998. Ds was 6 months old.

 

ETA: The most recent thing I bought was the textbook for his sophomore university English class. Amazon has brought me almost full circle!

Same here! I'm sure if the report included the years 1998-2005, my total would have been 6 figures. My very first Amazon order was for two Miss Spider board books and a Miss Spider puppet. This year's purchases included ACT and CLEP prep books, and assorted dress shirts and ties in "Extra Tall." <snif>

[Corraleno]

It wouldn’t let me total it on the iPhone, since it was apparently a text column in Numbers. How did you get around that?

Highlight the column of numbers, then go under Format > Cells and switch it from Text to Currency. Then it should sum the column.

[Night Elf]

One of the books in my very first order was Natural Childbirth the Bradley Way. DH and I took a Bradley class that month and dd was born the next month. Now she's in her 2nd year at college. I'd love to know what I've spent since then. I told DH what I've spent since 2006 and he said we should have purchased stock in Amazon. :)

[nixpix5]

Oh wow I am too scared to look. I did have an Amazon associate tell me I had bought over 2300 items. So just making a blanket assumption that each item was about $10 caused me pause and knowing full well most of my purchases were more than that through the years....eek!

[scholastica]

One of the books in my very first order was Natural Childbirth the Bradley Way. DH and I took a Bradley class that month and dd was born the next month. Now she's in her 2nd year at college. I'd love to know what I've spent since then. I told DH what I've spent since 2006 and he said we should have purchased stock in Amazon. :)

 

We did. I am so glad dh saw that one coming!! :thumbup1:

[RootAnn]

Tried this. Didn't work for me.

Highlight the column of numbers, then go under Format > Cells and switch it from Text to Currency. Then it should sum the column.

 

If you go under "Your Orders", you can see what you ordered by year (back to 1998).

First book I bought was a gift for my little brother, "Mars and Venus [go?] on a Date"

It didn't help him - he still married the loser. She divorced him. He's got three kids with someone else now.

[Corraleno]

I've purchased 4,169 items from Amazon since 2006; probably over 5000 if it went back to 1998.

 

The weirdest thing I ever ordered from them was an 8' javelin, which was packaged in a 9' long PVC pipe (and caused all kinds of crazy shipping problems).  

[Annie G]

Holy cow. The raw number is staggering. I'm going to have to do some analysis to see who is ordering what since our kids use our Prime account. This is a good time to see this number- I'm working on our 2018 budget. And as I typed that, Dh just said it's a bad time for me to learn this number since he knows I'm working on the budget. g

 

Guess who the spender is in our house...

[DawnM]

I’m actually surprised it is as low as it is - but I try hard to not use amazon if I can help it. I’m at just under 13k for 661 items since ‘06 :o

 

Mine is pretty much double on both of your numbers.  GAH!

[Jenny in Florida]

I took the dare, but it was pretty anticlimactic. My total since 2006 is just over $3,300.

[elegantlion]

$16k since 2006. Some of the recent numbers are off as my mom orders from my account. That was around 1100 orders. The first orders they have were homeschooling books  :crying: where does the time go. 

[cjzimmer1]

Is this only for Prime Members?  Because I can't find anything where it will let me download anything.  Actually when I clock the orders page, all I get is a list of my orders.  Wondering if it's because I don't have Prime or if I just need to keep looking for it.

[melmichigan]

$17,783.51 in ten years.  :svengo:Interesting enough I'm at exactly 1,000 purchases.

 

(If you click on the cell just below the last number in the column, and click formula across the top, and then auto sum, it will do the work for you.  If you only see your orders listed you need to go back to account and pick from that screen.)

 

Edited December 30, 2017 by melmichigan

[Carrie12345]

I did it, and I actually expected my total to be higher.  Then I realized mine only went back to 2011, not 2006.  :scared:

[jewellsmommy]

Over $19,000 since 2006. But, this doesn't include anything digital. My first orders were homeschool books as I was preparing for dd's kindergarten year. Apparently I bought SOTW a year later!

[Excelsior! Academy]

I did it and  :svengo:

[melmichigan]

Over $19,000 since 2006. But, this doesn't include anything digital. 

Thanks for the reminder. LOL!  I have 1,600 books in my digital library.  I don't want to add that up.

[Joules]

It wouldn’t let me total it on the iPhone, since it was apparently a text column in Numbers. How did you get around that?

You probably figured it out by now,but you select the data and click the paintbrush to change the format.

[Night Elf]

Is this only for Prime Members?  Because I can't find anything where it will let me download anything.  Actually when I clock the orders page, all I get is a list of my orders.  Wondering if it's because I don't have Prime or if I just need to keep looking for it.

 

On the home page, look where it says Hello (your name) and Accounts and Lists just below that. Hover over that. Click on the first link inside the drop down page which should say 'your account'. Then scroll down and look on the left for a box titled Ordering and Shopping Preferences. Inside that box says 'download order reports'. Then you'll see the screen that lets you put in the dates you want to generate on the report. 

 

Mine opened in Excel which I don't have but I just clicked on the column that said purchases and on the bottom in tiny letters/numbers it gives you "Average", "Count", and "Sum".

[PrincessMommy]

I almost did it, but chickened out.

 

Mine only goes back to 2006, but I've ordered since 2002. 

 

 

yeah, i don't think I want to know that either... mine goes back to 1998.  

[creekland]

I suspect with it being a download that it will use way too much data for our limited plan, esp since two of our boys are also using our plan while here.

 

That said, ours won't be super high.  I'm not a big Amazon fan using it mainly to buy textbooks for the lads.  That number itself might be high, I suppose, but it will be lower than if I had them buy their books at the college bookstore.

 

Occasionally we need Amazon to get lawnmower parts, but that's not terribly often.

 

I've never understood why folks pay for Prime.  ;)  (Different strokes for different folks - not being judgmental!  We don't do membership stores like BJs either.  It's just not "us.")