My Spreadsheet For Tracking Reseller Inventory & Creating SKU Numbers COMPLETE INVENTORY SYSTEM PT.1
HTML-код
- Опубликовано: 17 янв 2022
- In this tutorial I share how I create SKU numbers on Poshmark, Ebay, & Mercari, my inventory management system, the spreadsheet I use to track sales, and how I keep track of other data for my online reselling business. Part 2: • Reseller Inventory Sto...
📔 Trendy Fashion Styles With Keywords Ebook: bit.ly/fashionkeywords
💸 Get $10 off your first purchase on Poshmark using my invite code SANDRAS5THAV
I’d Love to work with you! Click here for coaching info: sandrathemomboss.com/coaching/
🎬 Video Time Stamps
This is how I keep track of my Inventory to resell (from start to finish)
00:57 First thing is first: sort and organize inventory
01:23 Optional step: document inventory into a spreadsheet
02:34 Take pictures, bag, & add SKU numbers to all items
07:27 List items and record SKU numbers on all platforms
10:27 This is when I document inventory + A walkthrough my spreadsheet
//LINKS & RESOURCES MENTIONED
Measurement Size Chart Templates: sandrathemomboss.com/shop
Simple Inventory System (Video): • How I Store & Organize...
How To Take GOOD Pictures (Video): • How To Take & Edit Pic...
List Perfectly Tutorial (Video): • How To Use List Perfec...
This Reseller Has A Free Spreadsheet (Video): • Our Reseller Spreadshe...
List Perfectly (Use Code THEMOMBOSS For 30% Off First Month ): bit.ly/listperfectly
Clear poly bags (small): amzn.to/3a7WNXr
Clear poly bags (medium): amzn.to/3p4y8LK
Clear poly bags (large): amzn.to/3evHdZ8
Large Brown Boxes: amzn.to/3fdKttG
Brown Packing paper: amzn.to/2V0TGfv
Blank labels: amzn.to/33x5SeR
// OTHER RESELLER TOOLS
Reseller Assistant (Posh Sharing Service): sandrathemomboss.com/RA
Get $10 Off your first Poshmark purchase using my invite code: SANDRAS5THAV
Sign up for Mercari and get up to $30. Here's my invitation link : merc.li/tUUtHShs
//SHIPPING SUPPLIES
Duck brand poly mailers: amzn.to/2I6ACZ9
Heavy duty packing tape (bulk): amzn.to/3mV1Voq
Thank you cards: amzn.to/2JZXDe5
Scale: amzn.to/3hT1xUV
//BUDGET FRIENDLY PHOTOGRAPHY EQUIPMENT
Steamer: amzn.to/313Qkdl
White cardboard poster: amzn.to/2PwZ4Tx
Yard stick: amzn.to/2TWzxpk
Fabric measuring tape: amzn.to/2TXJMdb
Lights: amzn.to/2ryFcaz
//CLEANING SUPPLIES FOR SHOES & GARMENTS
Doc Martin leather cleaner: amzn.to/32jKsy1
Goo Gone adhesive remover: amzn.to/2UbGN13
Suede cleaner: amzn.to/38gyQji
Scotty peeler: amzn.to/367CyJo
Grandma's spot remover: amzn.to/3k78l1L
Lint roller bulk pack: amzn.to/2Jwa6ZR
// RUclips GEAR
Canva Thumbnail Graphic Design Software: sandrathemomboss.com/Canvadesigns
Canon Camera: amzn.to/347k20D
Lights: amzn.to/2ryFcaz
Tube Buddy For More Views: www.tubebuddy.com/Sandrathemo...
Filmora ( Video Editing Software): bit.ly/FilmoraYTeditor
Screen Cast O Matic (Screen Recorder): bit.ly/YTscreencast
//SHOP
Poshmark closet ($10 Credit Code SANDRAS5THAV): :poshmark.com/closet/sandras5thav
Mercari Store: Check out what I'm selling on Mercari! www.mercari.com/u/379844626
Ebay: www.ebay.com/str/sandras5thav
//LET'S CONNECT
Coaching: sandrathemomboss.com/coaching/
Email: hey@sandrathemomboss.com
Instagram: / sandrathemo. .
Facebook: bit.ly/Sandrasfacebook
Pinterest: www.pinterest.com/sandrathemomboss
Disclaimer: I am a proud affiliate/sponsor of the products/services mentioned above. I will receive a commission when you purchase via my links. Purchasing through these links will not affect your check out process in any way, but it will support this channel and allow me to keep making valuable videos for you. Thank you for your trust and support! 
Хобби
Been looking all day for information to use, yours was the BEST.
Glad I could help!
Thank you so much for all your help and as for the spread sheet ginger Marvin her husband made one and shared it for free if anyone wants to get it again thank you again
Yay! Been waiting for this from our reselling Queen! 😃
Thanks Sandra your videos are easy to watch and informative!
I absolutely love the organization of categories by letters!
Thank you for creating these videos. You are so calm when explaining and full of knowledge. I do not miss any of them
Just came across with your video and I am so grateful for all the information you were willing to share with us. Life saver for me for sure. Thank you very much!
I love the last step..taking a photo of the item/sku/weight....greatness...thanks for that tip!
Awesome video! So easy to understand! Thank you!
This content is helpful especially to a beginner like me. I appreciate your information. I pick up some ideas for my closet.
Wow! So succinct and professional! Will definitely borrow some of these ideas! Thanks a bunch for being so thorough and helpful!
You are so inspiring and I have shared a few of your videos with my friends that are looking to make extra money. We all started stores thanks to you! I’ve sold 37 items! Thank you!
Wow great organization. Thank you for sharing
Very professional!
Hello I'm definitely learning a lot from you. I'm watching this video so I can learn more about the sku process. At first I didn't think I needed to start that right away, but as of today (I got more inventory...lots) I definitely need to implement some a sku system soon. I appreciate your videos. Thank you be well.
PS my name is Ruby Hugo is my husband. :)
Helpful video, thank you @SandraTheMomBoss
You're welcome!
Great video. If you still help with printing you can do "mail merge" with labels. If you have word is pretty easy. Or you can just do labels and type it and just print.
Just showing support this video was so helpful
I was waiting for this! I am super excited for the next part. I have been using a google doc since I started in September getting serious about re-sell and Its a little poopy but Its helping keep all my costs and flow in order. What I am struggling with is storage- I have a very small closet and small office for my business and I'm concerned I'll have to rent a storage unit if I want to hit 300 listings which is my milestone goal. But I had such a good thrift haul yesterday, I scored Salvadore Ferragamo calf boots- vintage ones. I don't know what to list them for but comparables showed 100 on posh mark and I got them for $4.99. I decided to take in your strategy and I wanted to make 4x my initial purchase cost as a challenge. It was an insanely good haul day and I've challenged myself to make 700 on the haul (COG: $110 roughly) so I hope I nail it. Keep up the awesome work :D
Great vid I'm having difficulty with accessing PT 2? The link is not connecting.....so glad I found u...i love your no nonsense content...yep
Hi, I’m trying to get back into reselling. Thank you so much for sharing all your tips. VERY helpful! One question I had and I couldn’t find is what are you doing for shipping? What do you use for shipping mailers, do you put the clear poly bags into poly mailers? How do you do your shipping labels? Print and tape?
Get a thermal printer for your labels!
Thanks for the video :)
Hey, I've been loving your videos, I have one question!? 😊❤️
So if your packages are prepackaged, then what do you do when a customer orders multiple items from your store? Do you go in and unpackage all of those packages to put them in one package, or do you just stack multiple packages in one big box?
Do you wash or disinfect your items? How do get rid of that dusty thrift store smells or that GW smells? Thank you
I'm curious if you have ever used an Excel spread sheet system. I would love know if you have why you chose not to use it?
I'm addicted to your videos! ; )
Hi Sandra, are you sharing your clothing measurement paper templates? If so, where can I find them? Thank you!
Hey Sandra I’m not sure if you saw. I left a reply to your response to my comment on this video. I am dying to know how you do it.. I have finished the SKU system but before I let more time pass by if it’s wrong. I am dying to know your answer.. Can you check it whenever you are able. I saw your consult sessions on your website and I think I am going to schedule one at the end of the month.. ❤❤❤
I would love your spreadsheet!
@@SandraTheMomBoss Thanks for the follow-up and bummer. I'll have to create my own:)
@@SandraTheMomBoss I asked Cher about this & she said they’re coming out with a newer version! I can’t wait 🤞
This video was the best I found and I just subscribed! I am doing my inventory system tonight and I am Wondering Do you still like the letter ledger with the numbers after using it for so long? I am leaning this way! So after using it do you think doing just numbers and mixing the categories would be better or do you still like it?
I still like using letters in combination with numbers for the sku#'s to keep items organized by categories. However, I have condensed it down a lot by combining like categories into one letter. For example, I used to have several letter for shoes. Now I only have 3- A for tall boots, B for short boots, D for all other shoes.
@@SandraTheMomBossHello!Thank you so much for responding.. Happy to share that I just finished implementing your system, it took about 5 days. So I now have all my SKUS, A ledger, and an inventory spreadsheet !!!! I am SOO Happpy! I can’t even express how thankful I am!! With that being said I just have one question. After I was all done entering everything (If Course After.. LOL) I realized I forgot to ask…. Do you have separate numerical sequences for each letter/category code or do you start you say @3000 items A1, B2, C3, etc….??? For example right now what I think is just going to get to be too much is starting over at 001 for each category code.. For example: WS-001, MS-001, WJ-001 and so on.. However after doing it this way I am really worried that with 25 different prefixes will become too time consuming m. I would have to check, what is the last number used when listing, for each and every category code. So what do you think is better or what would you recommend?
Very informative. I think you mentioned cross listing. Which web do you use for this? Thanks!
@@SandraTheMomBoss Thank you. I dont list often and only list on Mecari bc of all the work. Had no idea about cross listing before your video. So helpful!
Are your labels able to be printed with Avery. I just ordered some labels with 30 per sheet and saw another person who reviewed them say to use Avery 5160.
@@SandraTheMomBoss Avery has a program that you can download & it will automatically format your document based on the label you are using. It's super quick and easy!