@randy / @heather - any chance of a help/tutorial video on Amazon CSV Line Item Import tool?
I have seen the wiki article on this topic - its just that I have so many of Amazon line items that I am just a little concerned if I will mess up - seeing it visually along side reading the content would just be a bit more reassuring.
Thank you,
-Avi
We donât have a demo (yet). Sorry, @wizavi.
The addon doesnât do anything destructive with your data, it just adds new rows. You should be able to easily remove the new rows with a filter then a delete operation if you arenât happy with the changes.
Randy
Hereâs some tricks I used early on when I felt just like you do⌠omg, my transactions will be all screwed up!
I always made a copy of my Tiller Sheet just in case and thenâŚ
First, I categorized my Amazon buys with a category of âAmazonâ. Then, once I get the CSV, I make these selections:
Then, when I hit the button, the result is my transaction sheet with ONLY the new adds showing.
Then, I color fill the lines.
And fill in my categories.
Next, I turn off the filter to get to my full translations.
And now I can easily spot the changes that the importer made.
Early on, when I screwed stuff up, it was really easy just to go in and delete or fix the added (colored) lines.
I was so hesitant and afraid of screwing stuff up in the beginning. But, now, I no longer even color the lines. I, too, support Amazon fully with nearly every one of my nickels 
so the importer is probably one of the most important parts of Tiller for me.
If you break your sheet, go back to the one you saved and try again. I have a folder called Tiller Backups. Itâs a safety net that has saved me from my own experimentation many times.
I like your colored rows approach. Makes filtering really visual and dependable.
Great process and writeup, @susandennis. Thanks for sharing!
Thanks @susandennis for the suggested best practice very helpful.
@randy - with Filter purchases after import setting set I clicked âAdd to transactions sheetâ button and following Susanâs suggestion, I added the color and started adding categories to transactions - as I have a lot of small transactions (~500) or so - it was taking a very long time to cross check some of the items with Amazon order history to remind myself what the item was eventually I was tired half way in and went to bed - hoping to complete the work today.
did some this morning additions of categories this morning and donât know what happened - just now when I about to start, saw a dialog saying âUnable to load fileâ and lost the preview state - not sure if there is some state that I lost?
The categorization I have been doing so far still seems to be there.
If you just lost access to the filtering, you can recreate that easily. Just setup a new filter that filters on the word âamazonâ in the Metadata column. If you have lots of new Amazon transactions and want to show just the latest tranche, also filter on Date Added. Make sense?
I donât know whether itâs because I live in Canada as opposed to US but I cannot find any place on amazon.ca where I can download my transactions for it or whatever my Amazon purchases. I read somewhere that thatâs only available for sellers on Amazon.does ayone know if that is correct? I would appreciate any information you have because like many I have multiple purchases that would make my life easier to categorize this way.
Yet another snub of Canada. First the Blue Jays, now you. Itâs called the Order History Report and while it does look like something similar is available for Amazon sellers in Canada, I found a couple of mentions that itâs not yet a feature for regular Amazon buyers. Sorry. On the up side, you guys are healthier!
Thanks Susan thatâs pretty much what I was coming to the conclusion
