Originally Posted by HitokiriShadow
I like to keep track of what I was charged for each BD I import, so I was annoyed at this situation in part because it was going to screw up tracking that. Thankfully, Amazon changes the information in your order details, so you can go back and see what the actual lowest price was for each item rather than just being informed of a lump sum refund (which is what I initially thought is all I had to go on). Which is nice if you are trying to keep track of the price you paid for each item like I am. Though the fluctuating exchange rates screw up tracking the exact US$ amount I paid for each.
Yeah, it's still pretty difficult. Too much tweaking needs to be done. I track three prices:
1) Yen, which gets screwy with the constantly shifting prices and any item cancellations (which affect S&H per item)
2) Dollars, initially calculated off #3 but later adjusted as best I can based on what actually charges to my credit card. Of course in multi-item shipments this gets complicated and I need to go calculate what item was what percentage of the yen price, then apply that to the dollar price and... well, meh.
3) Dollars, at today's exchange rate. I have a cell where I can just plop in the current rate and it'll calculate what the items would have cost if it shipped right now. Of course this is based on #1 which is tough to be exact with.
In the end I'm sure I always wind up off a little but probably doesn't add up to much either way so far. But as long as I can get close with #2 based on actual CC charges (made easier if items ship one at a time), the total spent should be pretty accurate.
What I should do is make another column and separate S&H cost in yen from item cost in yen. It'd be easier to modify. But I already have like 20 columns in my spreadsheet...