Happy summer! Wow, is it 100 degrees where you live? We’ve had a toasty summer but today Mother Nature took pity on us and sent over all the clouds and it is a nice break. I hope you’re enjoying summer and drinking lemonade.
It’s really important to keep your inventory organized, especially when your shop gets a little bigger, and it will grow faster than you think. The best way to handle this is by keeping a meticulous spreadsheet. Luckily there are many available out there, and you don’t have to be an Excel wizard to set it up.
If you would like a pretty spreadsheet that’s fairly turnkey, you can buy one from Etsy. Just go on and search “eBay spreadsheet” and it will pull up a bunch from $1 to $39. They have plain ones, colorful ones, and spreadsheets that will track your inventory across several different platforms. This is a pretty cheap and easy way to go. Make sure you get the correct document for your country! I saw several for the UK and I’m not sure what the difference is, but that might add some layers of frustration if you get the wrong one.
I experimented with requesting one from ChatGPT and it gave me a pretty good one, although it didn’t set up all the calculations and formulas, so I would only recommend this if you’re pretty proficient in Excel and can set up all the calculations and formulas yourself. Go into ChatGPT (chatgpt.com) and type something like, “Please create an eBay reseller spreadsheet for me.” It will give you a spreadsheet and then ask if you’d like it in an Excel file or a shareable Google file. I asked for an Excel file. Please note that to get this, you will have to log into ChatGPT, but it’s free to set up an account, so this would be a good option if you’re willing to put some work into the spreadsheet. I felt like it gave me way too much information and I kept deleting columns that I didn’t think I’d need. In the end, this didn’t work out well for me because I’m not that good in Excel and frankly didn’t want to put that much work into setting it up.
What I ended up doing was going to YouTube and searching for a free spreadsheet. Search something like, “set up ebay reseller spreadsheet,” and it will give you many videos which include a spreadsheet download in their comments section. This was free and easy and I just deleted the columns I didn’t need.
Then keep it updated religiously! After I sell something, I turn that line a different color so I can immediately see that it’s gone, and I add actual numbers.
I have to admit that I wanted to share my spreadsheet here, but I still don’t have it exactly how I like it, and a few of my formulas are messed up. Hopefully I can correct that and then update this soon with a copy.
Have a great day! Take a few minutes to go outside and get some sunshine and Vitamin D!