Amazon email for too many returns

[kennyc]

Hmmm, my memory must be better than I had thought....one return, one refund

and OMFG!!!! orders totalling - $16,122

[Atunah]

I have no clue what that means, sum what in what cell?

I guess I'll be sitting using a calculator some other day.

Now I am trying to dexypher what repasting values means. Oy.
There is a dollar sign with the amount so I assume that is right, but I can't figure out how to get a total of all the holy moly many orders.

No digital in this like Cin says, would be nice to have a easy total for ebooks also.

[twowheels]

Originally Posted by Cinisajoy

Oh wow. That doesn't count digital stuff.

Yeah, good point. My ebook purchases aren't included in those numbers.

[pidgeon92]

Originally Posted by twowheels

Yeah, good point. My ebook purchases aren't included in those numbers.

Yeah, I noticed that too. Maybe they're trying to keep me from having a heart attack.

[kennyc]

Originally Posted by twowheels

Yeah, good point. My ebook purchases aren't included in those numbers.

Are you Kidding, that probably doubles my total!

[Cinisajoy]

Originally Posted by Atunah

I have no clue what that means, sum what in what cell?

I guess I'll be sitting using a calculator some other day.

Now I am trying to dexypher what repasting values means. Oy.
There is a dollar sign with the amount so I assume that is right, but I can't figure out how to get a total of all the holy moly many orders.

No digital in this like Cin says, would be nice to have a easy total for ebooks also.

In a spreadsheet, those numbers are in cells.
SUM is the term to get the total. Then you put the number of the cells in parentheses. Example would be (G2:G25)
That should give you a total.
The column is a letter and the rows are numbers.
Better yet, find someone that loves spreadsheets. Want my daughter's email?

[twowheels]

Originally Posted by Atunah

I have no clue what that means, sum what in what cell?

I guess I'll be sitting using a calculator some other day.

Now I am trying to dexypher what repasting values means. Oy.
There is a dollar sign with the amount so I assume that is right, but I can't figure out how to get a total of all the holy moly many orders.

No digital in this like Cin says, would be nice to have a easy total for ebooks also.

OK, I figured out how to get it to import the csv file such that you can sum the data w/o having to re-paste.

When you open the .csv file it gives you an import dialog asking you a bunch of questions about how to import it, and gives you a preview of what the imported data will look like. In that Import dialog, do the following:

Change the Character Set to: Unicode (UTF-8)
In the fields preview, click on the Order ID column heading. Next, hold down the shift key, then hold down the right arrow until all Columns are selected except for order date. Change the Column Type combo-box from Standard to US-English. Now the imported data will be in a usable format. (You can also change some of the individual column types to "hide" if you don't want them imported as they're just extra noise).

Now, to make it easier to use, click in cell B2 to select it and then in the menu choose Window->Freeze, which will keep the headings and dates on the screen. Now you can go to the Item Total column and select the range of cells that you are interested in (click in the first one to select it, then scroll to the last one in the ranage you're interested in without clicking anywhere in the spreadsheet, hold shift, and then click in the ending cell)... now you'll see the Sum along the line at the bottom... it says Sum = XXXX

[twowheels]

Originally Posted by kennyc

Hmmm, my memory must be better than I had thought....one return, one refund

and OMFG!!!! orders totalling - $16,122

Whoa... you've got me beat... and I thought I spent a lot of money there. ;-)

[kennyc]

I'm using Excel, but I was able to highlight the subtotal cells and then choose 'AutoSum' from the menu.....I know nothing of spreadsheets, I hate spreadsheets...but it worked.

[Atunah]

Originally Posted by Cinisajoy

In a spreadsheet, those numbers are in cells.
SUM is the term to get the total. Then you put the number of the cells in parentheses. Example would be (G2:G25)
That should give you a total.
The column is a letter and the rows are numbers.
Better yet, find someone that loves spreadsheets. Want my daughter's email?

I put in =SUM(U2:U859) as the column I want is U. But it just says $0.00 no amount. Sigh.


eta: I just saw twowheels post. I might need some wine before I attempt that. And I have to read that a few times cause I have no clue as of yet what any of that means.

Only spreadsheets I ever use and do are the ones that have lines, I can spread a column width and type in stuff. That is about all I can do in there. Anything else is like chinese to me.

[Cinisajoy]

Originally Posted by Atunah

I put in =SUM(U2:U859) as the column I want is U. But it just says $0.00 no amount. Sigh.


eta: I just saw twowheels post. I might need some wine before I attempt that. And I have to read that a few times cause I have no clue as of yet what any of that means.

Only spreadsheets I ever use and do are the ones that have lines, I can spread a column width and type in stuff. That is about all I can do in there. Anything else is like chinese to me.

Try SUMu2:u859)
I forgot the = sign
Try this =SUM (U2:U859)
No spaces.

[Atunah]

Ok, with twowheels step by step I have a number. I now like to time travel back a few minutes to blissful unawareness

I can't eve n

And it doesn't even include the ebooks


Thank you so much twowheel for the instructions for a dummy like me.


Ok, I guess some of the ebook cost would be in the number as I always add giftcards to the account and now they just get put on automatically and all ebooks come out of that. So the number is a tad less scary. It does list the gift cards on the totals.

[twowheels]

Originally Posted by Atunah

Ok, with twowheels step by step I have a number. I now like to time travel back a few minutes to blissful unawareness

I can't eve n

And it doesn't even include the ebooks


Thank you so much twowheel for the instructions for a dummy like me.

And you should now be able to use Cinisajoy's instructions as well now that the dollar amounts are recognized as numbers...

Choose a starting point, note which cell it is... choose an ending point, note which cell it is... then in an empty cell type:

=SUM(<start>:<end>) (where <start> and <end> are replaced with a cell number, such as U17)

That'll give you the sum for that range.


You can also start typing the formula, so in an empty cell type:

=SUM(

... then select a range with the mouse... and then close the formula by typing the closing ) and pressing enter... that cell will now have the sum of the selected range.

[DiapDealer]

Man, you guys are brave! There is no way I want to look at that number.

[SteveEisenberg]

Originally Posted by BearMountainBooks

Amazon will NEVER disclose how much is too much because if it were to be public information, there are people who would keep it *right* under that number.

I agree with your basic idea.

But in addition to that, I think the guidelines would lead to bad publicity due to sheer complexity.

If I was making the cutoffs, one big goal would be to limit shipping costs. So if someone returned a very heavy, relatively low priced item, the weighting would be high:

http://www.amazon.co.uk/Wagg-Complet...words=dog+food

But if I returned an eBook five minutes after purchase, that might hardly count.

Something that has to be shipped, but is light, such as a computer chip, would count somewhere in the middle.

I'd also consider if shipping was free, if the item was returned with packaging intact, and whether the scenario required Amazon to pay return postage.

Then there's the return rate for the item purchased. If sized clothing has a very high return rate, and the customer only buys clothes, a higher return rate is going to be acceptable.

Then there's the question of whether the cutoff would be the same in every country. From a business standpoint, as a loyal Amazon middle manager, I'd be more strict if the shipping costs in that country are high. But if it ever got out, that, oh, say, Josieb1 got hit because of shopping while British, I don't think that would go over too well.

Originally Posted by Cinisajoy

Amazon and Walmart are not the only stores.

This sounds like the Walmart haters that shop at Walmart.

Vote with your wallets.

How about, my Walmart and Amazon, right or wrong, but if wrong to set them right?

Mine? Yep. My retirement kitty is to a large extent invested, by my employer, in the S&P 500. There probably aren't many companies discussed here (except publishers) where I don't have a share equivalent at this point.