This is just raw ruby code for now, but will process a file manually if you wish it to.
To get the file:
- Log in to your seller central account
- Go to the all statements page. (This link will not work unless logged in to a seller central account)
- Select the Date Range report you want and click Download Flat File V2
- Open downloaded text file and save it as a CSV file.
The source file from Amazon starts as a .txt
file that is tab separated. I did attempt to work with that file, but was unable to make it work properly.
The methods are currently set up to be called manually on a file. Future adjustements could automate it all. File saving ouf output report is basic for now and saves it in whatever folder you're working in.