Week 1 Progress Report: Dropship Week, Amazon FBA and Excel

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!

A CRM for Freelance Work

I started freelancing seriously at the end of 2019. I have about five clients already, but the work isn’t regular and I’ve already finished most of their projects for them. Reaching out to multiple clients has left me with a lot of names to remember and a lot of projects to keep track of, so I’ve set up a CRM system.

I’m using Dolibarr 10.0.5 which I installed through the Softalicious Installer. So far it’s helping me keep track of my prospects and exisiting client, and remindng me when to chase up on leads. I looked at a number of paid and free solutions before deciding on this one, a close contender was Flowlu, however I am not currently earning enough from my freelance work to justify it at this point.

I am still getting used to Dolibarr but so far it’s proved perfect for what I needed it to do. It also has billing and financial tracking capabilities – I use alternative solutions for this at the moment, but will see how easy these are to integrate later in the year.