Skip to content

Adapt tool to use Amazon's "Request My Data" export #151

@jprouty

Description

@jprouty

Moving info from the original sunset tracking issue.

Bad news first: It's not a plug and play export (ie, this export does not contain 3 files called orders.csv, items.csv, refunds.csv).

Good news: The export has a LOT of additional detail, which should make some things easier (like detecting gift card use and digital content e.g. music and video purchases). Unfortunately, there are some downsides I've found so far:

  1. No category information per item. The b2b export (Order History Reports) included a UNSPSC per item, which I then manually translated into the basic Mint categories based on the UNSPSC spec and my intuition. You can see that mapping here. Without this information, itemization is still possible (which is useful) but automatically selecting categories becomes more tricky (they might need to be scraped).
  2. Only item information is given. No notion of an orders are available. Specifically, I'm looking for the item groupings that make up an amazon "transaction", similar to this page.
  3. Returns are more detailed (yay!) but are missing what item (and it's description) was returned from the order. Additionally, it also doesn't have any category information.

Please chime in if anyone else finds some of this missing information! It's worth noting I only exported "Your Orders". I am now trying "Request all your data"

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions