I managed to get just short of 2,500 seller-fulfilled products listed on Amazon this week. I used three spreadsheets to accomplish the task: the pricing master spreadsheet (which works out VAT, Amazon fees and profit by markup); the upload master spreadsheet which uses a series of concats and vlookups to create descriptions and keywords; and the FBA Custom Inventory Uploader.

I managed to get just short of 2,500 seller-fulfilled products listed on Amazon this week. I used three spreadsheets to accomplish the task: the pricing master spreadsheet (which works out VAT, Amazon fees and profit by markup); the upload master spreadsheet which uses a series of concats and vlookups to create descriptions and keywords; and the FBA Custom Inventory Uploader.

It took me 4 iterations of the final spreadsheet to get everything correct. FIrst: Amazon was adding in stray columns at the end (check this if you get the duplicate column error). Then, I’d put some dimensions in with the unit of measurement. Then there were various issues pulling the images in, but I’m finally at the point where I have all the products from one particular supplier up on Amazon.

Selling on Amazon will be my second income stream this year in my quest for $100K. I’ve also managed to watch all the Hollyoaks episodes from start of January to end of June 2019… so it’s been quite a productive week in all!

Tags: