Hi everyone I’m an online reseller on eBay and Etsy and if you’ve stopped by then WELCOME TO SPARROWS END!!
I put out weekly charity shop hauls and monthly sales reports so if you enjoy any of my videos then please hit the like button and make sure to subscribe and click the notification bell.
Here’s my Haul Playlist
Here’s my Sales Report Playlist
Here’s the Sparrows End Vlog playlist
If you want to follow more of my entrepreneurial antics then go and follow me on Instagram and Twitter
Affiliate Links to Items I Use to Run my Online Business:
De-bobbler/Fabric Shaver https://amzn.to/2BdCjQw
50 SMALL clear polythene bags 10x12 for shorts, skirts, tops: https://amzn.to/2K95RlN
50 MEDIUM clear polythene bags 12x15 for jumpers, dresses, trousers: https://amzn.to/2K2JBdn
50 LARGE clear polythene bags 14x17 for blazers, jackets, coats: https://amzn.to/2lmkvIt
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
#eBayreseller #sparrowsendhaulvideo #onlineentrepreneur
Sparrows End That stuff is amazing. The guys in “Schu” in Oxford street taught me that trick after I moaned about grubby converse. Its also great for removing paint off clothes, although you need to be patient and try a good few times.
Hello Your blog is really great the advise you are giving is so helpful I have only started selling properly for four months as well. I find relisting every 10 days on eBay does keep my site active and I have more sales but I wish eBay could do a 20 day listing as 30 day is just a big gap. You are doing amazing.
Hi Mel, you’re making me blush again lol 😆 you got some lovely stuff there and well done on picking up some shoes I use toothbrush and soapy water first then I use cleaning wipes and then last resort on tough stains is sticky stuff remover it usually does the trick you’ve got to buy what you like I think I have all the cameras still not listed as I’m not interested in them it’s bad I know 😬
love your videos :) i've been spending a few hours giving reselling a go on and off the past three months, not made much at all but trying to do things much more seriously this month, your tips are really useful :)
Thanks Claire! Glad you enjoy the videos. I really priced things picking up when I got to about 100 buy it now listings and tried to list at least one thing everyday. The summer has been rough for everyone though so don’t give up and also there’s no rush, build it up bit at a time. Let me know how you’re getting on in the future x
Great haul Mel. I've spent the last 2 evenings binge watching your vids. You are so easy to watch and great behind the camera. I'm just starting out part time ebaying. I'm learning so much from you. Thank you x
Awww 😊😊😊 Thank you! Glad you’ve found my channel and glad you’re enjoying it. Be careful with some of the earlier finds, most are okay and I do try to highlight where I’ve made a mistake, but my sourcing is a lot better in the more recent ones. I’m still very new to it and I’m learning so much myself! I hope I’m showing people that actually it doesn’t really matter if you make a mistake, you just go right back out there and try and find something better. Good luck with your reselling and be sure to leave me another comment letting me know how you’re getting on!!
I love your videos! I always get excited when I get the notification for a new video. I'm not sure how to clean leather unless those leather sofa wipes are any good? But I always get soles sparkling by using magic erasers.... Poundland sell their own version of them which would be a bit cheaper. And if the treads are hard to get too, I use Cif and a nail brush, goodluck x
As everyone saying, the photo on the tray is in Newquay. The house itself is a holiday let, so could be quite popular, even if vintage. As for cleaning leather shoes, you could try 'saddle soap' I've used it to clean a leather handbag. You can find it on amazon.
Goodness, I really need to look into that tray in more detail. A holiday let... so it must be a well known spot. And actually saddle soap makes perfect sense for leather shoes. Thanks for the helpful info and tips and thanks for watching the video 🙂
DM E Oh my goodness!! Really?! That’s brilliant- I’ll be able to use that in the key words and description. I’m wondering if there’s a way I could take the picture out and clean it up a little....? I will have to investigate tomorrow. Thanks SO much for leaving a comment 😊
😂😂😂 That was one of my first thoughts for cleaning them - not sure what that says about us both though 😱😂😂 Thanks for continuing to watch my videos - you’ve been right there since the beginning and I appreciate the support xx
Yes, Cif was mentioned over on Instagram too so I might have to get some. It’s slightly abrasive isn’t it, so I can see why it might be good for cleaning rubber-soles shoes. Thanks so much for the advice!! Hope you enjoyed the video 😊
That’s interesting as someone also suggested handcream - Same principle I suppose... This could be a really cheap solution and well worth a try. Thanks so much for watching my video and making the effort to comment - I really appreciate it! 😊
I finally ordered some magic sponges so will try those out next week and I’m going to buy a pack of toothbrushes from Poundland as loads of people have recommended using one!! Thanks for watching, commenting and leaving me some handy tips 😊
Hi Mel, I love those knitting bags, they remind me of my mum. Everything vintage reminds me of my parents, which is why I love it. Regarding shoes, I have been known to put trainers/ pumps in the wash with biological powder! This may be wrong but if they are not too bad and the soles just need cleaning I use a toothbrush and washing up liquid. Again I don’t know that this is the best method! The pillow cases are gorgeous. Also, I wouldn’t be without baby wipes, as they don’t wet items too much.
I am so sorry to sell them, but then I have a habit of wanting to keep things I buy! The one with the wooden handles has stolen my heart but as it’s the best one I think I’ll have to sell it 😕. I washed some Converse recently on a 30degree wash and they came out really well. Def need to try the toothbrush idea on the soles. Thanks for watching and supporting my channel 😊 Hope you’re enjoying the videos 😊
Great haul again. You really have picked up some lovely pieces. I struggle to stick to the "can I make £10 on this?" strategy. I am working on it though. You are doing amazing! Look forward to the next haul video xx
I keep trying to remind myself of the effort it takes with clothing for the return. Sometimes I have had to wash them, iron them or steam them, then the photographs (I definately need to up my photography game). When all is said and done £10 is really the minimum I guess to make it worth the effort! Looking forward to the next haul video and no worries with the supporting you. You are putting out really interesting content and it is lovely to watch your reselling journey xxx
Thank you so much Lisa!! Sometimes I feel like I’m doing okay and other times I feel like I’m REALLY not 😂 I have to say the £10 profit strategy is definitely improving my sourcing- I’m leaving weaker items behind and really trying to only pick up things where I am pretty confident of getting a tenner for my efforts. I already have the next haul video ready so hopefully next Friday for that one. Thanks so much for all your support for my channel - I really appreciate it xxx
Lovely haul there - glad you're learning so much! I love that too about reselling... you never stop learning. Great re starting up your etsy shop- I need to do the same as like you I am severely attracted to vintage stuff!
I’m trying to absorb as much as possible and try as many different things as possible! I’m creating my own crash course in reselling 😱 I couldn’t believe I got such an out of the blue Etsy sale and I really believe the market there will be more geared up for vintage items, plus the fees are half that of eBay’s 😁 Will cross-lost though, at least to start with...
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.