eBay Reseller UK | Sales Report #9 | Jan 2019 | Make Money Online | Sparrows End
I put out weekly videos about forging a life that’s creative, sustainable and fun, so if you enjoy any of my videos then please hit the like button and make sure to subscribe and click the notification bell.
Get Your Free eBay Profit Calculator Spreadsheet HERE https://sparrowsend.com/yours-for-free/
Check out my website www.sparrowsend.com
My second channel about crochet and knitting https://www.youtube.com/channel/UCSqY5ReqFpVHjmOwIEwhQNw/
If you want to follow more of my entrepreneurial antics then go and follow me on Instagram
Affiliate Links to Items I Use to Run my Online Reselling Business
De-bobbler/Fabric Shaver https://amzn.to/2BdCjQw
Mykal Sticky Stuff Remover 250ml https://amzn.to/2vMTfbC
Magic Sponges for cleaning shoes https://amzn.to/2ODH4oE
Kiwi Trainer Whitener https://amzn.to/2MS9KcR
50 SMALL clear polythene bags 10x12 for SHORTS, SKIRTS, TOPS: https://amzn.to/2K95RlN
50 MEDIUM clear polythene bags 12x15 for JUMPERS, LONG DRESSES, TROUSERS: https://amzn.to/2K2JBdn
50 LARGE clear polythene bags 14x17 for BLAZERS, JACKETS, COATS: https://amzn.to/2lmkvIt
Recycled Brown Packing tape https://amzn.to/2UVEuwL
100 watt Daylight Lightbulb https://amzn.to/2W4PhXu
Affiliate Links to Items I Use to Run my Youtube Channel
Desktop tripod https://amzn.to/2UWIvRA
Mic for iphone https://amzn.to/2Vg8HMk
Phone Stand for Overhead shots https://amzn.to/2VJ4ZKg
Phone I use to record video https://amzn.to/2UUd3DM
Last week’s video got lost in my misuse of an editing app and impatient actions which meant all of my editing disappeared 🤦🏻♀️ I sulked and couldn’t face re-editing the flipping thing so I made a new video (this one instead) and will re-edit the habits and hack video for next week!! Thanks for bearing with me and my regular F-ups 🙈😉
Yes, but for me I have to find a good balance. I don’t need to grow it much more as it’s just a small, part time business. I think £100-150 on stock is really the maximum I should be spending per month. Thanks for watching and taking the time to comment 🙂
Don't be so hard on yourself, you are learning and growing and improving, & remember your numbers included a lot of items you were clearing out for low values... also making mistakes is a natural and necessary part of what we do, (I should know!!!)
It's so nice to see experienced resellers being so supporting of those of us just starting out. I think youtube is important because it feels a bit like having supportive colleagues. Makes a difference when working from home and /or going it alone.
Yes, that’s what I do too. I had something sell yesterday for a price higher than I ever had it up for on BIN! Doesn’t happen often but for a sought after piece it’s still possible to make some money 🙂
Hello, I have been inspired by your videos to start reselling and got a few bargains in the charity shops yesterday. I have a current eBay account should I continue to use that one or set up a new one? Be interested to know how you started it please? Also how much stock do I buy?! Many thanks Helen 😊
Oh how lovely, I hope you enjoy it! You have a £1000 trading personal allowance in the U.K. so you can just use your regular account until you hit 1k profit in any financial year 🙂
Thanks for watching and taking the time to comment
Congratulate yourself on reinvesting in your business Mel . You're not spending it on takeaways etc ! People often fail because they don't put enough back into the business, but you are spending wisely. That £300 could be £3,000 to 6,000 increased turnover. I wouldn't look at the average profit per item , it can be disheartening and you know the turnover is going in the right direction. I think you're doing outstanding work 👍❤️
I was having a bit of a downer about it but logically I know you’re right! Def not spending it on takeaways - can’t afford many of those at the moment unless I take money out of the savings pot! Must get that stock listed though 😂 Thanks so much for your kind and supportive words my lovely Sue xx
You have done remarkably well for what is generally considered “the worst eBay month of the year”. January is a beast just to get sales, let alone profitable ones...so consider your January sales a success! Lovely video, as always.
The beast of January!! I suppose it wasn’t so bad, especially as I haven’t been working particularly hard at eBay recently 😬 and the new stock will contribute to profits further down the line! Thanks so much for watching and taking the time to comment 🙂
Hi Mel.... Thanks for sharing but also thanks for your honesty, We're all human and hey lesson learnt. Looking forward to seeing you reach your £800 goal until then keep up the fab work and videos. Iain 😎
Thanks Iain 🙂 It’s fine I suppose, just annoyed that I got over confident towards the end of the month. I’m sure it will work out in the end and I’ll benefit from the stock spend but wish I’d held off for about 3 days then it could have come out of Feb’s money 😂 I don’t even think twice about the honesty - I think the videos wouldn’t be as useful if I tried to fudge how well I was doing! Thanks for watching as always 🙂
Even better if I hadn’t spent that last £75 on stock 😂😂😂 but I appreciate the sentiment! I suppose it’s not so bad as it was on good items that will pay me back further down the line 🤞🏻🤞🏻🤞🏻 Thanks for watching and for taking the time to comment 🙂
You can’t look at this as a fail Mel - you’re re-investing in your business! I’m doing the same and showing hardly any profit this last month or two - but I’m hoping the stock I’ve bought will improve my store massively in time. 😀
Yes, I really need to shift my mindset on this one I think. I just hate the fact that I got really arrogant at the end of the month and decided I could spend whatever I wanted because the sales were coming in 🙈🙈🙈 Hopefully that stock will add huge value to my shop and all will be well!!🤞🏻 Thanks for watching my video and taking the time to comment 🙂
Thanks for taking the time to comment Jessica. Yes, I really enjoyed January’s consistency as hardly a day went by without a sale for once and that in itself gave me a real boost. Feb started strong then turned to utter rubbish and is now having a last minute surge so I’m hoping for a good few days to finish. It still won’t be as good as Jan though! I hope your Feb sales pick up!!
Thank you 😊 I’m just kicking myself for spending that last minute £75 on stock! Hopefully it will right itself in future months but I really, REALLY wanted to hit £600!! Feb is looking unlikely too, so I am pinning my hopes on March 😂🤞🏻🤞🏻🤞🏻
Doing cash basis accounting I think helps you not to get hung up on how much individual items cost. Oh by the way yet to find any experienced reseller who has never sold an item at a loss. It's about looking at the bigger picture
It’s been fascinating from the moment I started running cash basis. I mean it’s similar to running a household budget and is so simple to do in that sense. Looking at the individual profits and homing in on the detail has taught me so much and has influenced my sourcing positively and now cash basis has started to correct my overspending on stock and helped me see patterns in my selling and in my spending. I’m really pleased to be taking both things into account moving forward, though I know I will still be making endless mistakes as ever 😂😂😂 Thanks so much for watching the vid and leaving a comment x
This article has been motivated by a response I gave to a problem raised on an Oracle developer forum. Our requirement is to produce a report that details customer spending for each month of the year. Our database only records actual spend, so for any given month, data for dormant or idle customers will have to be generated.
First, well create a mock CUSTOMER_ORDERS table with sparse data to represent customer spending. To keep the example simple, well denormalise the customer name onto the orders table.
a sparse report.
With our customer orders data as sparse as it is, a monthly report for purchases by customer would look as follows.
adding the missing months.
We can see from the data that we are missing most months of the year for our two customers. Remember that our requirement is to show a report for every month in 2004 for every customer. First we will build a "time dimension" set (using subquery factoring) and outer join it to our orders table.
We can see that this hasnt quite worked. We have the zero sums and the year-months, but we are missing customer names. This is because we outer joined to CUSTOMER_ORDERS on the year-months, so any customer columns would show as NULL for deficient rows. Until PARTITION OUTER JOIN appeared in Oracle 10g, we couldnt "invent" data easily , though the next section shows that it is possible in prior versions.
data-densification without partition outer join.