Mogi Beth, you ROCK ❤ Awesome video as always.. Just purchased. I also wanted to share something terrific news. After watching your last video when you sold a Gucci dress for a $1000. I got up that day and when shopping at my local consignment store and purchase a Chanel's crossbody for $25 and it sold yesterday on poshmark for $1000. I was so excited because you motivate me to keep shopping and working on my business 😊 " If you walk in joy, happiness is close behind". ~Regards, Kymberly
What a thrill. I do that too. Watch youtube or insta and go out shopping., went to a Burlington hadnt stepped in one in 20 years. Found revolve brands. Wow, just wow.
Wow that is amazing!! What platform did you sell the dress on? I have 2 armani womens suits and i wouldve sent it to thredup before and now idk.. what to do.
I’m glad you’re charging for your spreadsheet. I can only imagine how much time and effort you put into the content and resources you provide us free of charge. Looking forward to see how much your website progresses in the future.
Wow, thank you SO much. I just wrote this morning that I needed to figure out what data points I need to take my business to the next level. You're amazing!
My shoe system is actually a great space saver. I buy those extra large bins with the pull handles on one side & wheels on the other (the ones used for storing large x-mas items). I put multiple pairs of shoes in extra large reusable zip bags. Bags & bins have corresponding numbers. The bins then go on the very bottom of my shelving units. It takes more time when shipping but saving space is a huge issue for me as my workspace is very tiny & it still allows for vertical storage.
I haven’t even watched this yet, won’t have time until I put my daughter down for a nap, but I just wanted to stop in and say how excited I was when this video popped up from my subscription with this title! I have been hungry for more details on your inventory system, as I’m just about to start my own! As I have grown my closet quickly in the last couple of months, things are starting to get out of hand, haha! Thank you in advance for the amazing info as always, I can’t wait to watch! You’re a rockstar, Love everything you do!!!!!
@@MogiBeth Watched it a few hours ago and literally setting up my new laptop now to go buy your inventory spreadsheet!!! Thank you for making this new start to my small business such a breeze! You’ve already given me so much knowledge and confidence, I’m so grateful to you! ❤️
My system is similar but the main difference is I use small binder clips instead of tape to attach my description and location numbers to the package. I use my binder clips over and over. They can be attached to boxes or bags and avoids the messy tape experience.
Hey, Can I purchase her spreadsheet from you - I can PayPal or cashapp you. Mogi beth has the best spreadsheet but unfortunately she no longer sells it. So now I'm currently looking for another outlet, if ur interested let me know.
WOOHOO!!!! I can't even wait to learn it ALL from you, Morgan!! I've been waiting for this since I found you. I cannot wait to get this product and then ALL the courses!! I can't tell you how excited I am. You are amazing and I can't tell you how grateful I am for you and your business!
Omg, YAYY!! Thank you SO much! That means so much to me!! 💚 Please be sure to reach out if you have any questions or run into any issues! I hope this brings as much value to your business as it does mine!
Can't wait for the courses, Morgan! I feel like I owe so much to you; if it weren't for your videos and guidance, I don't think I would be in this career I love so much now. Very excited to get my spreadsheet going.
I think i need this to move forward with reselling and scaling, of all the resellers I watch on you tube I have learned the most from you and Nicole State you both bring give so much information to other resellers its truly amazing thank you
I just started watching you last month, started my closet and I can’t Thank-you enough for all the information you share and how much I have learned from you!!!☺️ Seriously life saver! I went from knowing nothing to being able to find the diamonds in the ruff. Oh also you explaining what a piece is, has helped me learn styles and you name it!! Your amazing and Thank-you Thank-you!! Sincerely little small town Canadian girl!❤️
When you were talking about misplacing an item it reminded me of when I worked on a car lot. During season if we lost a key we would have to dig through bins of keys to find it so frustrating
I'm very new to reselling and your videos have been super helpful. They're setting up a great foundation for me; I just purchased your spreadsheet and I am entirely way too excited to add the items I've purchased so far! Thank you for sharing your endless knowledge!
I don't know if anyone's commented this yet already, I haven't had the chance to scan through all the comments but a good way to minimize tape use is that blue tack stuff. I forget what it's definitely called, but it's like that blue stuff that's reusable, it just takes a little dot to stick paper onto walls and things like that
I was using a spreadsheet from another company and feeling it was lackluster... so happy to see this. I like the bells and whistles it offers with little work on our side. I just purchased it a little while ago and waiting for my kiddos to go down to bed so I can watch the Tutorial and start transferring things over. Fortunately, I only have about 70 items listed right now so better to do it now than when I'm bigger. Thank you!
Wow I will purchase it for sure and will follow your course :D !! As a flight attendant on furlough I have increase my sales and activities on Poshmark. You are an inspiration, and even in Canada we listen to you ! 💕
Thanks so much for this spreadsheet. I'm so excited. I've almost have all my numbers updated for 2020 and inventory added in. I'm now getting ready to see how I might want to customize it. One tip I wanted to pass along for potential future version - although maybe there is a reason it wasn't included in this one since it was clearly thoughtfully made - if there is a cell in a formula that you don't want to change when you copy/paste it - then add dollars signs so A3 would be $A$3. This is relevant to the stats page when adding new platforms. Anyhow, thanks again.
Lol no reason! I just never had to do that since this is like our 4th iteration of our spreadsheet so that part was already "made" for us and we don't add platforms anymore. But yes the $ is extremely helpful! Glad you are finding the spreadsheet to be useful! -Matt
For flats and more flat shoes that can go into a mailer you could put them in those usps tyvex polymailers and stand them up in a box to save space. Then you could either reuse the mailers for the next pair of shoes, or just mail them in the mailer.
Hi! This is so fantastic - thank you so much for sharing all this info. I went ahead and purchased the spreadsheet. I just wanted to point out that in CANADA, the Poshmark fees and structure are a little different. The fee is $3.95 for anything under $20 and 20% +GST/HST/QST on anything over $20. Just an FYI for anyone using this in Canada, you need to make some adjustments :)
Writing down all my purchases, listings, dates and solds in a notebook is getting OLD...def will check this out, thank you for putting it all together....you’re like my VA by creating the spreadsheet lol
Thank you for sharing such great information. I'm looking for new ways to maximize my storage space. Can you share how you set up your shipping station? How do you store all the packing materials and boxes. Always such a challenge for me. Thanks again, loved the video!
Thank you! Yesss, well I am lucky because I have a packaging table that make storing boxes, kraft paper, polybags, etc really easy! I have a similar one linked in my Amazon wish list, but they're pretty expensive. My mom bought the one I have ages ago and gave it to me when she moved. But before that, I purchased a shelving unit and organized all the packaging materials and set it next to a table so I could easy pull from the shelf while I packaged, but still had a clear table to work with. I hope that helps!!
Great video! Do you think a barcode method would be beneficial to include in the spreadsheet and in the inventory label system to quickly scan a item when it sells locating it on the spreadsheet? I’m thinking once an item sells and is updated on the spreadsheet that barcode could be removed on the spreadsheet and reused on the next item brought into inventory. Interested in hearing your feedback on this. I am a fairly new reseller and value your expertise. Thanks!
I’m inspired! Our systems aren’t that different but mine definitely needs to be cleaned up a bit. Giving my storage unit an overhaul at the end of the year!
Hi Mogi beth! I have been one of the people that has been waiting on this video from you so I was happy to see that you uploaded it. Thank you so much! I also just wanted to give you a heads up that your Amazon link for your wish list is not clickable. I did want to take a look at that I’ll try to plug it in to Safari instead.
I can’t believe I missed this one. You answered a bunch of questions I have been pondering. Although I have sold on eBay previously, I want to be thoughtful about what I buy and sell. I started buying items found by Brickseek, toys, comforters, sheets and others. I decided that they didn’t fit my vision so I dropped that. Plus Brickseek is a bit of a scam. I an a little anxious about Poshmark because of the 20% and shipping. Now that I have my second COVID dose I can can start thrifting. I need a spread sheet. I dint want to make one. Thank again for all this helpful information.
I like your inventory system for shoes 👍🏽 I’m also documenting my journey reselling shoes and like how you use those shelves. I totally agree, storing inventory system vertically is key. Thank you for all of this helpful information.
You're my inspiration for wanting to start my own reselling business! I have been slacking off lately though. Unfortunately I currently live with my boyfriend and his parents (space is extremely limited) so my reselling inventory is an hour away (it's at my storage building at my parent's) My boyfriend and I are trying to save up for a house, when I get wifi I'll be able to fully commit to selling online as well as working full time until I am comfortable enough to go full-time/overtime with my home reselling business. I hope that one day I'll be able to tell you I have a six figure business as well 💖
Just bought the spreadsheet, thank you Beth and Matt for putting your work out there. Glad I could support with the purchase. Hope you guys have a great holiday and that 2021 can treat us all at least a little better.
Hey, Can I purchase her spreadsheet from you - I can PayPal or cashapp you. Mogi beth has the best spreadsheet but unfortunately she no longer sells it. So now I'm currently looking for another outlet, if ur interested let me know.
How do you record earnings/margins in a bundle? I offer discounts on bundled items and I hate when my numbers get thrown off by dividing the earning evenly across all of the items.
Hi Faith! Matt here, so if you could provide me more info if I am wrong that would be helpful. But I assume what you are referring to by throwing off your numbers when you equally attribute earnings in a bundle, is that your margins look funky because not all items in your mind are equal. This is especially true when the COGS are different as well. For example, if I sold a bundle of two items for $100, $50 a piece might appear off to my mental accounting, especially if one item is way more valuable and expensive than the other. In my opinion, I wouldn't worry about it too much because when I am going over my numbers in the aggregate, it doesn't quite matter what value I attribute to each individual item. For example, what if instead of a bundle, you sold one item for $100? Whether it is one or two or ten items, as long as you calculate (Price sold - fees - COGS)/(Price sold) you will get your Gross Profit Margin. Another way to think about this is when I go over my Monthly sales report and calculate my Average Profit Margin. It doesn't matter what each individual sale was, because in the end I am totaling them all up in order to get my AVERAGE Gross Profit Margin (Total Monthly Sales - Total Poshmark Fees - Total COGS)/Total Monthly Sales Hope this helps and please let me know if I missed the mark lol!
Question for you: When you copy an inventory item that has sold from the inventory tab to a month tab, do you do anything to that inventory item still listed in the inventory tab? It seems like that list could get really long, making it hard to quickly find items if sold items are not marked there somehow. Would you recommend removing it from that tab, since it is now listed in the monthly sold tab? Or marking it sold by shading out the cells?
Is this spreadsheet still available for purchase? I wasn’t able to find it on your website, but it’s something that I’m really interested in using for my reselling business.
Thanks a million. I was very hesitant to launch my online platform as I'm computer illiterate and this is perfect for my needs. Undoubtedly, I will purchase the spreadsheets. ❤ Merry Christmas and Happy New Year Beth. Kisses for the Baby.
Yes, me too really trying to find a way to get this spreadsheet, but i am not getting much response, whisk is a bummer!! I want to inventory my thins, but maybe need to find another spreadsheet!
I love the idea of packaging the shoes up so they are ready to ship when processing them BUT My biggest drawback is what about when people bundle items?! Would you just put the shoebox inside of bigger box with everything else or unpack the prepackaged shoes? Also speaking of shoes, You said in one of your videos that when you lived in Wichita you really relied on shoes to carry your business. So I have been trying to buy more shoes since then and it has been super beneficial! But shortly after hearing you say that I spent a weekend in Wichita and was able to hit several different Goodwills and was able to find SO many shoes!!! So thanks :)
Hi there! Love your channel so much! You have helped me so much with staying organized and answering specifics in these videos! I was wondering where I can find your spreadsheet because I would really love to purchase it to help track my profits and grow my business!
Hey, Can I purchase her spreadsheet from you - I can PayPal or cashapp you. Mogi beth has the best spreadsheet but unfortunately she no longer sells it. So now I'm currently looking for another outlet, if ur interested let me know.
I love spreadsheets 🤤 but I don’t ever want that much inventory lol. This is definitely more of a “hobby that pays” than it is a business for me. Nevertheless, I’m fascinated by people who do this full time and forever grateful for what you share on your channel!
Hi Mogi Beth do you still have spreadsheet for reselling to buy and study. Thank you love your videos.🙂 I went to website but can"t find were I can buy spreadsheet. Thank You
hi - I have questions about the spreadsheet. I've purchased and am using it, but eBay is still complicated. Because sometimes there's a listing fee, and sometimes there's not... and shipping is often less than what the buyer paid for shipping by a dollar or two. I've been copy/pasting the Net earnings from my eBay sales report, but then it doesn't subtract my COG. How do you all handle that?
Love your spreadsheet! One question, say I'm at the thrift store and I see an item and I im aiming for a 60% profit margin how to i calculate what i need to sell the item for in order to get to my goal profit margin?
Hey! Matt here, a simple calculation you can do in the store is take the COGS and multiply it by 5! That will get you your 60% profit margin. For example if I spend $10 on a pair of jeans, I would need a sales price of $50 for (50 - 20% poshmark fee - $10 COGS) / 50 = (50 - 10 - 10) / 50 = (30) / 50 = 60% Hope that helps!
Another amazing video Mogi! Thanks so much for sharing some amazing ideas! Have you tried using push pins to tack the inventory tags to the shoe boxes instead? Less tape! :)
Thank you so much!! Ohhh, I really hadn't thought of that! I will definitely have to experiment with it because the tape really bothers me! Thanks for the suggestion! 💚
i also pre-package my shoes, and do the same with coats and bulky items like chunky sweaters. :) i was looking to purchase your spreadsheet, but i can't seem to find it available on the link and am only seeing the BOLO list.
Before I started this inventory system, I had this same worry as well. But often, if it's a bundle for just two things, I can fit the other item in the shoe box. So I just have to quickly open it up and then re-tape. But if it's a bundle of 2+, I will usually move everything to a larger box and then just save old shoe box to inventory another pair of shoes. But I would say that it's usually more convenient than it is inconvenient!
Hey there! I just recently revisited your RUclips video on tracking your inventory. I had watched it last year but my number 1 goal is to be more organized with my reselling business this year. I couldn't find the spreadsheet for purchase on your website. Will you be releasing a new version this year? ...and if you plan on making a new RUclips video on this content (or getting tax ready) can you please include how you take into account your rollover inventory from the prior year. I just got finished making an inventory count from leftover 2021 merchandise, I just don't know what to do with that number and how to factor it into my costs. Thanks... and congratulations again on the pregnancy!! 💗
Hi Mogi. I went on your website to purchase your reseller spreadsheet but I was unable to find it. I am most interested as I am trying to get my ish together this year😂
Would you mind sharing any shelving units that work for your bins? I’ve purchased and returned 2, after assembling 🙄. Just not having luck finding sturdy ones that fit. Thank you!
Hi there, this seems like a pretty awesome spreadsheet, however, I felt like I didn’t get enough details as to what it offers. Is there anyway you can do a video showing more? (Obviously not given away everything, but just a little more of a walk through). Also, you mentioned you buy larger boxes for boots. Just wanted to share a little tip. I use the free USPS board game box to ship long/tall boots. I shipped out a pair of riding boots recently and my customer left me a comment in her love note that she appreciated the packaging and care put into sending her boots.
I've been looking everywhere for your spreadsheet and haven't had any luck. It looks like just what I been with all the formulas included. What am I doing wrong? Thanks, J
It's a really nice spreadsheet but I wish there was an option to enter how much of each item we have. Currently I'm having to make multiple lines to show I have multiple quantity. This just isn't practical because sometimes I have a large quantity of the same item. For example, in the inventory tab you should be able to enter how much of each item you have and when you mark it as sold, you can select the amount that sold also.
Hi Mogi, thank you so much for all the tips and tricks! I love your inventory system -- it seems simple and efficient. I'd like to start something similar. I do have a couple questions though. How do you handle items that you have multiple quantity of? Do you give them each their own individual SKU even though they're the exact same item? Or do you give them all the same SKU, and just label multiple bags with that SKU? Also how do you rotate through the numbers? Do you put SKUs right back into rotation as soon as something sells, or do you wait until you get through Z99 and then start over with available ones? Thanks again!! ❤❤❤
Hey Mogi! So frustrating with the lack of data coming from Poshmark. I love diving into the data! I was using a spreadsheet for the longest time, and ended up creating a web app (Thrifters Scorecard) to help give me that data. I think your spreadsheet is still going to be a very helpful guide. Also, storing shoes is my biggest battle! Can't wait until I have more storage space, and I'm definitely going to use this pre-box method. Thanks for sharing! :))
Mogi Beth, you ROCK ❤
Awesome video as always..
Just purchased. I also wanted to share something terrific news. After watching your last video when you sold a Gucci dress for a $1000. I got up that day and when shopping at my local consignment store and purchase a Chanel's crossbody for $25 and it sold yesterday on poshmark for $1000. I was so excited because you motivate me to keep shopping and working on my business 😊
" If you walk in joy, happiness is close behind".
~Regards, Kymberly
OMG!!!! CONGRATULATIONS!!! That's AMAZING!! Dang! Goes to show you never know what you could find if you expand your mind to what is possible!
Omg congrats!!!! I can imagine the high you must have been on with that find haha. That's one hell of a profit margin!
What a thrill. I do that too. Watch youtube or insta and go out shopping., went to a Burlington hadnt stepped in one in 20 years. Found revolve brands. Wow, just wow.
Ok that is amazing. I found a Gucci purse at the goodwill bins but it had a busted zipper
Wow that is amazing!! What platform did you sell the dress on? I have 2 armani womens suits and i wouldve sent it to thredup before and now idk.. what to do.
I’m glad you’re charging for your spreadsheet. I can only imagine how much time and effort you put into the content and resources you provide us free of charge. Looking forward to see how much your website progresses in the future.
Thank you so much Jane!! That means a lot! 💚
Hi! Am I still able to purchase your spreadsheet? I looked on your website but couldn't find it! Thank you so much!!
Wow, thank you SO much. I just wrote this morning that I needed to figure out what data points I need to take my business to the next level. You're amazing!
My shoe system is actually a great space saver. I buy those extra large bins with the pull handles on one side & wheels on the other (the ones used for storing large x-mas items). I put multiple pairs of shoes in extra large reusable zip bags. Bags & bins have corresponding numbers. The bins then go on the very bottom of my shelving units. It takes more time when shipping but saving space is a huge issue for me as my workspace is very tiny & it still allows for vertical storage.
I haven’t even watched this yet, won’t have time until I put my daughter down for a nap, but I just wanted to stop in and say how excited I was when this video popped up from my subscription with this title! I have been hungry for more details on your inventory system, as I’m just about to start my own! As I have grown my closet quickly in the last couple of months, things are starting to get out of hand, haha! Thank you in advance for the amazing info as always, I can’t wait to watch!
You’re a rockstar,
Love everything you do!!!!!
YAYYY!! This comment made my day! Thank you so much Bridget! I hope you find this to be helpful!
@@MogiBeth Watched it a few hours ago and literally setting up my new laptop now to go buy your inventory spreadsheet!!! Thank you for making this new start to my small business such a breeze! You’ve already given me so much knowledge and confidence,
I’m so grateful to you! ❤️
This is just a hobby for me but I still learned a lot from you.
My system is similar but the main difference is I use small binder clips instead of tape to attach my description and location numbers to the package. I use my binder clips over and over. They can be attached to boxes or bags and avoids the messy tape experience.
This spreadsheet is EXCELLENT. An incredible value for $25, including a series of clear video tutorials. Highly recommend!
Where did you find it? I can't find it...
Hey, Can I purchase her spreadsheet from you - I can PayPal or cashapp you. Mogi beth has the best spreadsheet but unfortunately she no longer sells it. So now I'm currently looking for another outlet, if ur interested let me know.
Purchasing your spreadsheet is the best thing I have done. It made my life so much easier. Thank you!
WOOHOO!!!! I can't even wait to learn it ALL from you, Morgan!! I've been waiting for this since I found you. I cannot wait to get this product and then ALL the courses!! I can't tell you how excited I am. You are amazing and I can't tell you how grateful I am for you and your business!
Oh, and I just bought the spreadsheet! This is going to be so useful for my business. Thank you.
Omg, YAYY!! Thank you SO much! That means so much to me!! 💚 Please be sure to reach out if you have any questions or run into any issues! I hope this brings as much value to your business as it does mine!
Can't wait for the courses, Morgan! I feel like I owe so much to you; if it weren't for your videos and guidance, I don't think I would be in this career I love so much now. Very excited to get my spreadsheet going.
I think i need this to move forward with reselling and scaling, of all the resellers I watch on you tube I have learned the most from you and Nicole State you both bring give so much information to other resellers its truly amazing thank you
Just bought it. So excited. I am a new reseller (only 4 weeks). Hope this will help me.
I just started watching you last month, started my closet and I can’t Thank-you enough for all the information you share and how much I have learned from you!!!☺️ Seriously life saver! I went from knowing nothing to being able to find the diamonds in the ruff. Oh also you explaining what a piece is, has helped me learn styles and you name it!! Your amazing and Thank-you Thank-you!!
Sincerely little small town Canadian girl!❤️
I love the way you physically store items. I need to work on mine desperately!
I know this is an old video, but the spreadsheet is no longer available under resources. Is there somewhere else I can pay for it?
Where can I purchase this spreadsheet? I went on your website under “resources” & could not find it.
Thanks !
so nice to hear that you reuse the ziploc bags :)
Save the earth everyone
Is your spreadsheet still available? I'm having trouble finding it but I love how you have this set up!
When you were talking about misplacing an item it reminded me of when I worked on a car lot. During season if we lost a key we would have to dig through bins of keys to find it so frustrating
LOL omg bins of keys!? That's brutal!
@@MogiBeth it was awful. What’s worse is the owner of the car standing behind you 😂 so glad I don’t work there anymore
I'm very new to reselling and your videos have been super helpful. They're setting up a great foundation for me; I just purchased your spreadsheet and I am entirely way too excited to add the items I've purchased so far! Thank you for sharing your endless knowledge!
I love the spreadsheet is Google Sheets! Moving to your shoe inventory starting this weekend!
WOW... will be purchasing your spreadsheet!
I don't know if anyone's commented this yet already, I haven't had the chance to scan through all the comments but a good way to minimize tape use is that blue tack stuff. I forget what it's definitely called, but it's like that blue stuff that's reusable, it just takes a little dot to stick paper onto walls and things like that
I was using a spreadsheet from another company and feeling it was lackluster... so happy to see this. I like the bells and whistles it offers with little work on our side. I just purchased it a little while ago and waiting for my kiddos to go down to bed so I can watch the Tutorial and start transferring things over. Fortunately, I only have about 70 items listed right now so better to do it now than when I'm bigger. Thank you!
Wow I will purchase it for sure and will follow your course :D !! As a flight attendant on furlough I have increase my sales and activities on Poshmark. You are an inspiration, and even in Canada we listen to you ! 💕
Fantastic video. Great job. Buying the spread sheet. I am so excited to get started.
It’s never too late! Work hard, believe in what you do and enjoy what you do.. people will see that. Don’t stress you’ll get there 💕
Thanks so much for this spreadsheet. I'm so excited. I've almost have all my numbers updated for 2020 and inventory added in. I'm now getting ready to see how I might want to customize it. One tip I wanted to pass along for potential future version - although maybe there is a reason it wasn't included in this one since it was clearly thoughtfully made - if there is a cell in a formula that you don't want to change when you copy/paste it - then add dollars signs so A3 would be $A$3. This is relevant to the stats page when adding new platforms. Anyhow, thanks again.
Lol no reason! I just never had to do that since this is like our 4th iteration of our spreadsheet so that part was already "made" for us and we don't add platforms anymore.
But yes the $ is extremely helpful!
Glad you are finding the spreadsheet to be useful!
-Matt
For flats and more flat shoes that can go into a mailer you could put them in those usps tyvex polymailers and stand them up in a box to save space. Then you could either reuse the mailers for the next pair of shoes, or just mail them in the mailer.
Hi! This is so fantastic - thank you so much for sharing all this info. I went ahead and purchased the spreadsheet. I just wanted to point out that in CANADA, the Poshmark fees and structure are a little different. The fee is $3.95 for anything under $20 and 20% +GST/HST/QST on anything over $20. Just an FYI for anyone using this in Canada, you need to make some adjustments :)
That is so helpful! Thanks for letting me know, I'll make a video about changing the formula for Canadians.
Matt
@@MogiBeth Amazing, thanks! The formula for adding the GST on the Poshmark fee is hurting my brain to figure out :)
I was waiting for this! You are awesome!
Yay! Thank you!! I hope it is helpful in your reselling business!! 💚
Writing down all my purchases, listings, dates and solds in a notebook is getting OLD...def will check this out, thank you for putting it all together....you’re like my VA by creating the spreadsheet lol
Yessss! It was such a game changer when I started tracking everything digitally!!
Thank you for sharing such great information. I'm looking for new ways to maximize my storage space. Can you share how you set up your shipping station? How do you store all the packing materials and boxes. Always such a challenge for me. Thanks again, loved the video!
Thank you! Yesss, well I am lucky because I have a packaging table that make storing boxes, kraft paper, polybags, etc really easy! I have a similar one linked in my Amazon wish list, but they're pretty expensive. My mom bought the one I have ages ago and gave it to me when she moved. But before that, I purchased a shelving unit and organized all the packaging materials and set it next to a table so I could easy pull from the shelf while I packaged, but still had a clear table to work with. I hope that helps!!
thrilled about this, I lack all this knowledge. yippety yay,
Great video! Do you think a barcode method would be beneficial to include in the spreadsheet and in the inventory label system to quickly scan a item when it sells locating it on the spreadsheet? I’m thinking once an item sells and is updated on the spreadsheet that barcode could be removed on the spreadsheet and reused on the next item brought into inventory. Interested in hearing your feedback on this. I am a fairly new reseller and value your expertise. Thanks!
This is exactly how I picture my system. I will definitely be saving for it!
I’m inspired! Our systems aren’t that different but mine definitely needs to be cleaned up a bit. Giving my storage unit an overhaul at the end of the year!
Hi Mogi beth! I have been one of the people that has been waiting on this video from you so I was happy to see that you uploaded it. Thank you so much! I also just wanted to give you a heads up that your Amazon link for your wish list is not clickable. I did want to take a look at that I’ll try to plug it in to Safari instead.
Hi Mogi! How do I purchase the spreadsheet? Your website says it is out of stock. Thanks!
Awesome video! Is the spreadsheet still available? I couldn’t find it on your website..
Thank goodness, I will be buying this!
Great video Mogi! Thank you. Is the spreadsheet still available?
Your organization is GOALS!!! 🤯 The shoe storage is so smart!
Thank you so much for great videos & information! I have found that USPS Priority Wreath Boxes are great for sending boots!
Great video! Especially for a newbie like myself!
SO happy to hear that!! Thank you!
I can’t believe I missed this one. You answered a bunch of questions I have been pondering. Although I have sold on eBay previously, I want to be thoughtful about what I buy and sell. I started buying items found by Brickseek, toys, comforters, sheets and others. I decided that they didn’t fit my vision so I dropped that. Plus Brickseek is a bit of a scam. I an a little anxious about Poshmark because of the 20% and shipping. Now that I have my second COVID dose I can can start thrifting. I need a spread sheet. I dint want to make one. Thank again for all this helpful information.
I like your inventory system for shoes 👍🏽 I’m also documenting my journey reselling shoes and like how you use those shelves. I totally agree, storing inventory system vertically is key. Thank you for all of this helpful information.
You're my inspiration for wanting to start my own reselling business! I have been slacking off lately though. Unfortunately I currently live with my boyfriend and his parents (space is extremely limited) so my reselling inventory is an hour away (it's at my storage building at my parent's)
My boyfriend and I are trying to save up for a house, when I get wifi I'll be able to fully commit to selling online as well as working full time until I am comfortable enough to go full-time/overtime with my home reselling business. I hope that one day I'll be able to tell you I have a six figure business as well 💖
OMG Mogi and Matt! Thank you so very much!
Just bought the spreadsheet, thank you Beth and Matt for putting your work out there. Glad I could support with the purchase. Hope you guys have a great holiday and that 2021 can treat us all at least a little better.
Hey, Can I purchase her spreadsheet from you - I can PayPal or cashapp you. Mogi beth has the best spreadsheet but unfortunately she no longer sells it. So now I'm currently looking for another outlet, if ur interested let me know.
How do you record earnings/margins in a bundle? I offer discounts on bundled items and I hate when my numbers get thrown off by dividing the earning evenly across all of the items.
Hi Faith! Matt here, so if you could provide me more info if I am wrong that would be helpful. But I assume what you are referring to by throwing off your numbers when you equally attribute earnings in a bundle, is that your margins look funky because not all items in your mind are equal. This is especially true when the COGS are different as well. For example, if I sold a bundle of two items for $100, $50 a piece might appear off to my mental accounting, especially if one item is way more valuable and expensive than the other.
In my opinion, I wouldn't worry about it too much because when I am going over my numbers in the aggregate, it doesn't quite matter what value I attribute to each individual item. For example, what if instead of a bundle, you sold one item for $100? Whether it is one or two or ten items, as long as you calculate (Price sold - fees - COGS)/(Price sold) you will get your Gross Profit Margin. Another way to think about this is when I go over my Monthly sales report and calculate my Average Profit Margin. It doesn't matter what each individual sale was, because in the end I am totaling them all up in order to get my AVERAGE Gross Profit Margin
(Total Monthly Sales - Total Poshmark Fees - Total COGS)/Total Monthly Sales
Hope this helps and please let me know if I missed the mark lol!
Question for you: When you copy an inventory item that has sold from the inventory tab to a month tab, do you do anything to that inventory item still listed in the inventory tab? It seems like that list could get really long, making it hard to quickly find items if sold items are not marked there somehow. Would you recommend removing it from that tab, since it is now listed in the monthly sold tab? Or marking it sold by shading out the cells?
Is this spreadsheet still available for purchase? I wasn’t able to find it on your website, but it’s something that I’m really interested in using for my reselling business.
Thanks a million. I was very hesitant to launch my online platform as I'm computer illiterate and this is perfect for my needs. Undoubtedly, I will purchase the spreadsheets. ❤ Merry Christmas and Happy New Year Beth. Kisses for the Baby.
Just bought it 💕 thanks Mogi
Thank you so much!! I hope it proves to be valuable in your business!
Just purchased the spreadsheet. Absolutely love it! So easy to use. Thank you!!!
Where did you find it? I went to the link and it's not there?
What do you do if your shoes sell in a bundle??
Yes, me too really trying to find a way to get this spreadsheet, but i am not getting much response, whisk is a bummer!! I want to inventory my thins, but maybe need to find another spreadsheet!
Your videos are SO helpful. Thank you SO Much.
Is your spreadsheet still available? If so, can additional columns be added for things like brand name, gender, purchase date, etc?
I love the idea of packaging the shoes up so they are ready to ship when processing them BUT My biggest drawback is what about when people bundle items?! Would you just put the shoebox inside of bigger box with everything else or unpack the prepackaged shoes?
Also speaking of shoes, You said in one of your videos that when you lived in Wichita you really relied on shoes to carry your business. So I have been trying to buy more shoes since then and it has been super beneficial! But shortly after hearing you say that I spent a weekend in Wichita and was able to hit several different Goodwills and was able to find SO many shoes!!! So thanks :)
Hi there! Love your channel so much! You have helped me so much with staying organized and answering specifics in these videos! I was wondering where I can find your spreadsheet because I would really love to purchase it to help track my profits and grow my business!
Purchasing now. I’ve tried to create different ones on Excel and it’s been a nightmare this is exactly what I need.🙂 Thanks Matt and Mogi
Yayyy!! SO happy to hear that! I hope it helps you as much as it helps me in my business!
Hey, Can I purchase her spreadsheet from you - I can PayPal or cashapp you. Mogi beth has the best spreadsheet but unfortunately she no longer sells it. So now I'm currently looking for another outlet, if ur interested let me know.
Can I have the access to this spreadsheet from my iPhone?
I love spreadsheets 🤤 but I don’t ever want that much inventory lol. This is definitely more of a “hobby that pays” than it is a business for me. Nevertheless, I’m fascinated by people who do this full time and forever grateful for what you share on your channel!
Time is money and the amount of time and aggravation it would be for me to do this worksheet on my own, makes the $25 a steal!!!!!
Aw thank you! That means so much 💚🤗
Hi Mogi Beth do you still have spreadsheet for reselling to buy and study. Thank you love your videos.🙂
I went to website but can"t find were I can buy spreadsheet. Thank You
Hi Mogi are you no longer selling inventory spreadsheet?😊
Love love love your content!! :)
hi - I have questions about the spreadsheet. I've purchased and am using it, but eBay is still complicated. Because sometimes there's a listing fee, and sometimes there's not... and shipping is often less than what the buyer paid for shipping by a dollar or two. I've been copy/pasting the Net earnings from my eBay sales report, but then it doesn't subtract my COG. How do you all handle that?
Love your spreadsheet! One question, say I'm at the thrift store and I see an item and I im aiming for a 60% profit margin how to i calculate what i need to sell the item for in order to get to my goal profit margin?
Hey! Matt here, a simple calculation you can do in the store is take the COGS and multiply it by 5! That will get you your 60% profit margin.
For example if I spend $10 on a pair of jeans, I would need a sales price of $50 for
(50 - 20% poshmark fee - $10 COGS) / 50
= (50 - 10 - 10) / 50
= (30) / 50
= 60%
Hope that helps!
I don't seem to be able to purchase your spreadsheet. Is it still for sale? I don't see a buy button anywhere.
I was about to buy a course from someone else but glad I didn't. I would def be interested in your course.
i loved these tips! I went to your amazon wish list and didn’t see the box or laminator.
Another amazing video Mogi! Thanks so much for sharing some amazing ideas!
Have you tried using push pins to tack the inventory tags to the shoe boxes instead? Less tape! :)
Thank you so much!! Ohhh, I really hadn't thought of that! I will definitely have to experiment with it because the tape really bothers me! Thanks for the suggestion! 💚
Thank you so very much! I’m just getting started so this will help a lot!!👏
Yay!! I am so happy to hear that! I think the earlier you can integrate good business practices, the better!
@@MogiBeth I agree ☝️
Love your videos and am learning tons from you. I'd like to purchase your inventory tracking spreadsheet. Is it still available? Fingers crossed.
Omg I NEED these courses
Thank you Ari!!! heart heart smiley emoji thumbs up!
Is this spreadsheet still available. I can’t find it. Thanks
Excellent video!
I know this is an older video but I'm interested in reselling part time next year. Can you do a video on taxes?
i also pre-package my shoes, and do the same with coats and bulky items like chunky sweaters. :) i was looking to purchase your spreadsheet, but i can't seem to find it available on the link and am only seeing the BOLO list.
What do you do when you get a bundle with shoes?
I was wondering this as well!
Before I started this inventory system, I had this same worry as well. But often, if it's a bundle for just two things, I can fit the other item in the shoe box. So I just have to quickly open it up and then re-tape. But if it's a bundle of 2+, I will usually move everything to a larger box and then just save old shoe box to inventory another pair of shoes. But I would say that it's usually more convenient than it is inconvenient!
Hey there! I just recently revisited your RUclips video on tracking your inventory. I had watched it last year but my number 1 goal is to be more organized with my reselling business this year. I couldn't find the spreadsheet for purchase on your website. Will you be releasing a new version this year? ...and if you plan on making a new RUclips video on this content (or getting tax ready) can you please include how you take into account your rollover inventory from the prior year. I just got finished making an inventory count from leftover 2021 merchandise, I just don't know what to do with that number and how to factor it into my costs. Thanks... and congratulations again on the pregnancy!! 💗
Hi Mogi, where can I buy this spreadsheet? Thanks
What are some great tips for finding stock photos?!
Hi Mogi. I went on your website to purchase your reseller spreadsheet but I was unable to find it. I am most interested as I am trying to get my ish together this year😂
Would you mind sharing any shelving units that work for your bins? I’ve purchased and returned 2, after assembling 🙄. Just not having luck finding sturdy ones that fit. Thank you!
Could you tell me the size of the bins you use and where you purchase them at? Thank you so much!
Thanks purchase the spreadsheet thank you for thinking about others
Hi there, this seems like a pretty awesome spreadsheet, however, I felt like I didn’t get enough details as to what it offers.
Is there anyway you can do a video showing more? (Obviously not given away everything, but just a little more of a walk through).
Also, you mentioned you buy larger boxes for boots. Just wanted to share a little tip.
I use the free USPS board game box to ship long/tall boots. I shipped out a pair of riding boots recently and my customer left me a comment in her love note that she appreciated the packaging and care put into sending her boots.
I've been looking everywhere for your spreadsheet and haven't had any luck. It looks like just what I been with all the formulas included. What am I doing wrong? Thanks, J
Great video. Not seeing the Spreadsheet on your website?
Such a helpful video! Does anyone know if that spreadsheet is still available? I can't find it on her site.
Unfortunately we no longer sell them!
Just wandering... my reselling business is more than clothing lots of household items as well will your spreadsheet work for me as well?
It's a really nice spreadsheet but I wish there was an option to enter how much of each item we have. Currently I'm having to make multiple lines to show I have multiple quantity. This just isn't practical because sometimes I have a large quantity of the same item. For example, in the inventory tab you should be able to enter how much of each item you have and when you mark it as sold, you can select the amount that sold also.
Hi Mogi, thank you so much for all the tips and tricks! I love your inventory system -- it seems simple and efficient. I'd like to start something similar. I do have a couple questions though.
How do you handle items that you have multiple quantity of? Do you give them each their own individual SKU even though they're the exact same item? Or do you give them all the same SKU, and just label multiple bags with that SKU?
Also how do you rotate through the numbers? Do you put SKUs right back into rotation as soon as something sells, or do you wait until you get through Z99 and then start over with available ones?
Thanks again!! ❤❤❤
Do you have a link to the poly bags on Amazon? Great videos ... they have been very helpful!
Hey Mogi! So frustrating with the lack of data coming from Poshmark. I love diving into the data! I was using a spreadsheet for the longest time, and ended up creating a web app (Thrifters Scorecard) to help give me that data. I think your spreadsheet is still going to be a very helpful guide. Also, storing shoes is my biggest battle! Can't wait until I have more storage space, and I'm definitely going to use this pre-box method. Thanks for sharing! :))