-
-
Notifications
You must be signed in to change notification settings - Fork 34
Closed
Description
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:
- 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).
- 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.
- 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"
cwmoriarty and RickTorresJrivy and smenzer
Metadata
Metadata
Assignees
Labels
No labels