As you may have noticed, I’ve been working on a solution to the loss of Amazon order import. I’ve finally reached a point where I would like to have a few people look at it before I publish it to the Google Marketplace. It’s a bit more comprehensive than what we had before.
If you’re interested in trying it out, PM me. Until it’s in the Google marketplace, the install is the same - copy/pasting scripts into your sheet.
New process:
- Select a zip file to import
- Deselect any order types you don’t want (physical orders, digital, returns, or Whole Foods)
- Specify a time interval (we will ignore duplicates, but you might not want transactions that predate tiller)
- Pick a category for your offset transactions (normally Amazon or Transfer)
- Make sure your payment types in Amazon are mapped to the correct Tiller credit card account. The old tool had you fill in the account info by hand after the import.
Other details:
- If Amazon changes their file format, you probably will be able to get it working again by changing the column header mapping
- Refunds can now be mapped to the correct account since they are imported at the same time as the purchases
- I added the Whole Foods item exclusion feature because I was surprised to see every pack of gum I bought appear as a separate line item in my imports last year. If you like that level of detail, great, but at least you can opt out of it.
- The description starts with AMZ, which is a bit shorter than before, and allows you to see more of the actual item.
- Duplicate detection is backwardly compatible with the old tool.
- You can “undo” your import by just deleting the filtered rows visible after the import is complete
I’ve tested it up to 7500 imported transactions, it should scale to about 21,000 before timeouts or other issues might happen. If anyone has anything over 15,000 transactions, let me know.
