Dropship week | Excel-mania

trophy stock

This week I will mainly focus on getting my dropshipping goods uploaded to Amazon and Ebay. I’ve always had the option of dropshipping, but never felt disciplined enough to check the orders every day and forward them to my suppliers. Now, however, I am ready to take on this challenge: it will cut the amount of stock I have to keep at home, and allow me to provide a better range of goods.

The first step involves downloading the supplier’s spreadsheet. Then, I work out which goods will make me at least $7.50 per sale – after tax, after shipping, after Amazon or Ebay commission and after processing fees. I’ll do this by creating a series of calculations in Excel. Once I’ve decided which items are viable for dropshipping I need to transfer these to the Product Upload template from Amazon, with descriptions and bullet points. Finally I will transfer the spreadsheet to an Ebay uploader.

I had toyed with the idea of setting up a Magento website with M2E pro, but the amount of time it would take me to do that would be more than if I just created the spreadsheet directly. I will set up an online store away from Amazon and Ebay soon, but it isn’t my priority.

Following that, I need to start getting the stock I still have in my house out to the FBA warehouse. It’s going to be a long job, which may take me most of January, but I know I’ll be relieved to have my house back again.