Latest / Drop Ship Lifestyle Podcast / How To Manage Inventory In Your Shopify Store
Transcript
- 0:00What's up, everybody? Anton, curly here and welcome
- 0:02back to the e-commerce lifestyle podcast.
- 0:04If you are a newer listener, know that this show comes out,
- 0:07two times a week, we have brand new episodes every single Monday
- 0:10and Thursday and they are all designed to help e-commerce
- 0:13store owners to increase their revenue, automate their
- 0:16operations and become the authority in their Niche.
- 0:19Now today's episode should definitely help with freeing up
- 0:23your time so that you can focus on the stuff that at least I
- 0:27know I love the marketing side of things, the growth Side of
- 0:30things. Specifically what we're going to
- 0:31be talking about is how to manage inventory in your
- 0:34Shopify. Drop Shipping Store.
- 0:36So this episode is really for everybody out there that is
- 0:39currently up and running and they're doing what most people
- 0:42do. When they first get started
- 0:44which is they upload a bunch of products to their store and they
- 0:47do not track inventory. Now I'll say before, I even get
- 0:50into the two different methods I want to share for tracking is
- 0:54that for most people that is totally fine because what some
- 0:57people do and I think this is a mistake.
- 1:00Is they get the ball rolling? They build their store.
- 1:02And then from they won. They want all of their inventory
- 1:05levels for every product they sell to be perfect down to the
- 1:09exact number from day one. When again, that's just going to
- 1:13add this workload, this extra stress, this extra work that
- 1:16isn't necessary. The reason why it typically
- 1:19isn't necessary is because let's say you follow what I teach over
- 1:23at Dropship lifestyle.com. And you work with 20 different
- 1:26brands on your store, you sell for 20 different companies and
- 1:29I'd say on average, those 20 companies have 50 different SKU
- 1:33numbers each. So you sell 1,000 products on
- 1:35your store, most likely, 800 to 900 of those products will
- 1:41always be in stock and even if they're not in stock, they're
- 1:44not going to be products that you sell regularly.
- 1:46So, it's not something that you need to focus on thinking.
- 1:49I have a thousand products. I better make sure everything is
- 1:51perfect every single day because again, it's more often than not
- 1:55never going to become an issue. Now, when inventory can become
- 1:59an issue, Is when your best selling products run into stock
- 2:03issues. So you probably know the 80/20
- 2:06rule. I talk about it all the time and
- 2:08what I believe when it comes to applying this to inventory, is
- 2:11that 80% of your sales will come from the top 20% of your
- 2:16products. So if you have 1,000 skews on
- 2:20your store, most likely, you'll sell the same 200 of them over
- 2:23and over and over. And, you know what?
- 2:25We can even take this a step further and you can 80/20 that
- 2:28200 best-selling products. It's and most likely most of
- 2:31your sales are going to come from 40 of those 200, right?
- 2:34Again, 80/20 principle in action.
- 2:37So, what I do for, again, the vast majority of my stores is I
- 2:41focus on inventory levels for, in that scenario, it would be
- 2:46the top 40 products. The ones that we sell day in day
- 2:49out, the ones that just kind of rise to the top and become the
- 2:53money makers over time. Now, I'm not going to get into
- 2:56how we actually know what's in stock if you're a member of my
- 2:59coaching program. No this I guess I'll do a quick
- 3:01overview but certain suppliers will have a members area.
- 3:04We can log into that shows inventory levels.
- 3:07Some of them will send out csvs or Excel sheets every week.
- 3:10Some of them will share access to a Google sheet that shows
- 3:13real-time inventory. So there's different ways.
- 3:15But again, that's what will actively monitor if our best
- 3:18selling products ever run into inventory issues.
- 3:21Because I'll just say this to before I even get it, and it
- 3:23might sound like I'm giving a lot of reasons not to follow
- 3:26what I'm about to say in terms of how to manage the inventory
- 3:29and actually keep it up to date. But again, that's because most
- 3:32people probably don't have to do this.
- 3:34If you need to and we'll talk about who needs to, you know,
- 3:36don't don't worry about it. But basically what might happen
- 3:40is let's just say, again, those 40 products that are your best
- 3:42sellers, may be out of those 40 products.
- 3:45Your suppliers know. Hey, these are the best sellers,
- 3:47we're going to keep them in stock and maybe you run into an
- 3:50inventory issue, a few times a year, right?
- 3:51Maybe a little more often during covid and delayed shipments and
- 3:55whatnot. But again, most of the time, if
- 3:57you do Drop Shipping the right way, you're not going to have
- 3:59these issues. Is.
- 4:00Okay with that being said, what if you do, what if you have one
- 4:03supplier with your best selling products, and you start to see,
- 4:06whoa, these things are very low on stock and they're not going
- 4:09to be back for, I don't know, call it six to eight weeks,
- 4:12right? They're not going to be back for
- 4:13a while. Well, then it would probably be
- 4:14a good idea to update inventory on your store.
- 4:17Now, there's a couple reasons for this.
- 4:19One of them is that it's going to add this urgency right, the
- 4:22scarcity because when people are on your product page and there
- 4:26on one of your best-selling products and they see, oh
- 4:28there's only six units. Left in stock.
- 4:30Well, they're going to be more likely to purchase sooner rather
- 4:33than later because they will want one of those six riiight.
- 4:35So that's a reason you would want to do it.
- 4:38Another reason you would want to do it.
- 4:39Let's just say a product is backordered and it's not coming
- 4:41back for again. Eight weeks.
- 4:44Maybe you don't want to actually be selling those things and
- 4:46there's different thought processes on whether you want to
- 4:49accept those sales or whether you don't.
- 4:50But let's just say you don't want to, then you would want to
- 4:53have the inventory, go to zero on your store, and you would set
- 4:56it in the back end of Shopify, so that people can no longer
- 4:59order those products. You would also at that point
- 5:01want to do things like stop running ads, those products but
- 5:03just know there's again. Different thought processes for
- 5:06what you want to do with products that are actually out
- 5:08of inventory. With that being said, if you
- 5:11want to keep track of it, right? If you're one of those people
- 5:13that just wants to say, you know what, for my best-selling
- 5:16products I want real-time, or as close to real time inventory as
- 5:19possible on my store. What can I do?
- 5:21Anton, okay, I'll give you two methods.
- 5:23One free and one paid. So we'll start with the free
- 5:26method now, this one just involves going into Shopify.
- 5:29By clicking on the products tab. In the left navigation, going to
- 5:33the product page, clicking edit, and then for each individual
- 5:36product, there's an option to click track inventory.
- 5:40When you do that, you literally type in how many units you have
- 5:43or how many units your supplier has now.
- 5:45This works for that manual process, when you're only
- 5:48dealing with a small number of products that you're tracking
- 5:52inventory for. Now again, it works, but here's
- 5:55something that you should keep in mind if you're using this.
- 5:58I guess you can call it native. Sure, of Shopify.
- 6:01If the supplier sends out an inventory, tracking sheet, let's
- 6:04say on a Monday, and you see, there's six units left in stock
- 6:08for SKU number 1, 2 3, and you put six units left in stock on
- 6:11your store. Well, what if competitor ABC
- 6:15sells five of them in the next two hours, right?
- 6:18Then there's one left and you don't know until that next
- 6:20inventory report comes out. So there are, you know, pros and
- 6:23cons of this a pro is that it's more accurate, but if you use
- 6:27this method, it's never going to be foolproof.
- 6:29It's not Going to be 100% accurate.
- 6:31And the other issue with this, let's just say there are six
- 6:34left, right? You go ahead into the backend of
- 6:36Shopify for that product page, you put that their 600 left in
- 6:39stock in the quantity and then you sell six.
- 6:42Well, what's going to happen once those six are sold?
- 6:44Well, first of all, it's going to go to zero and then based on
- 6:47how you set it inside of Shopify, either customers will
- 6:50no longer be able to order that product or they will be able to
- 6:53order it but the inventory is going to show is - on your
- 6:56store. Okay?
- 6:57Now if you set it so that people Can no longer order the
- 7:01products. You better pay attention to when
- 7:04the product comes back in stock. Because I've seen people make
- 7:07this mistake where they set inventory, when they first build
- 7:09their stores, and let's just say they put, there's 12 units of a
- 7:12product available. Then you know, a few months goes
- 7:15by, they sell the 12, then they stop getting sales know like
- 7:17what happened that, you know, I don't get this.
- 7:19Like, why is this product not selling?
- 7:20Then they realize that. Oh, it's because I said an
- 7:23inventory and the inventory ran out.
- 7:25So, if you are going to track inventory, and you're going to
- 7:28use this first method, this, Us free method again.
- 7:31It is extremely important. That not only do you track it on
- 7:34the way down but that you replenish it when it's available
- 7:37again. So you don't run into a
- 7:38situation where you're not getting sales because you're not
- 7:41letting people buy from you, okay?
- 7:42So, very, very important if you want to use this method, I'm not
- 7:45saying you shouldn't use it. I'm just saying if you do, make
- 7:48sure you're paying attention to inventory and it is being
- 7:51updated, whether it's you updating it yourself or somebody
- 7:54on your team. Okay?
- 7:55Now, we'll go into the second method that you can use to
- 7:57manage inventory, on your Shopify store.
- 7:59Where's now this one, we use only in very rare situations on
- 8:04a store that might sell for 300 Brands.
- 8:07And that might sell 20,000 different skus.
- 8:10Where there's more of a possibility or more of a
- 8:13likelihood of inventory issues happening, because there's just
- 8:16so much more inventory. And when you work with 300
- 8:19suppliers, instead of 20, it can be really hard to keep an eye on
- 8:23what that best-selling 20% of products is.
- 8:26So with this method we use and I'd recommend you use use in-app
- 8:30in the Shopify app store that's called stock sink.
- 8:33Okay, stock sink and this app, there is a free plan.
- 8:37Most likely you'd be using the one that cost five dollars a
- 8:40month or $10 a month. What's cool about this app is
- 8:43that it can connect with your suppliers inventory and you can
- 8:47set a schedule for how often it should update on your store.
- 8:51Now, there's pros and cons here, right?
- 8:53The pros are that when you set this up correctly, and your
- 8:56suppliers update their inventory, sheet, it can We pull
- 9:00that information in and update your store.
- 9:03So the example I gave in the free method in method 1 method
- 9:051. If you put there were six units
- 9:07left of stock for, you know, whatever product ABC and then
- 9:11your competitor sold five of them, you wouldn't know, there
- 9:14was one left until you got the next inventory report.
- 9:17Now, if you use stock sink, and it's hooked up correctly to your
- 9:20suppliers inventory, then when those five are sold, the
- 9:23supplier would updated on their tracking side stock sink, would
- 9:26push that update through to your store, then your store would
- 9:29also show Oh, there's only one left so it could be this more of
- 9:32a real time. It's never 100% real time.
- 9:34But closer to real time active inventory monitoring.
- 9:37Now what that probably sounds great.
- 9:39Right, Robin Thicke? Okay, that's easy, that's the
- 9:40solution. Why shouldn't I just sign up?
- 9:42No matter how many suppliers I have?
- 9:44Well, the thing is, this is going to require you working
- 9:47with your suppliers to make sure you have access to their data in
- 9:51terms of inventory, in a way that you can match with the
- 9:54stock sync app, you can think of this in a similar way as to when
- 9:58you first got approved with Here's and wanted to upload
- 10:01their products to your store. You need it to get a product
- 10:04list from them. Maybe an Excel sheet, maybe a
- 10:06CSV but even if they sent you a CSV with all their products, you
- 10:10still need to modify it to get it to meet Shopify standard so
- 10:13that you can upload it to Shopify.
- 10:15It's going to be similar with stocks Inc.
- 10:16Based on how the supplier has inventory data available.
- 10:20You need to basically plug that in to stock sink and based on
- 10:23what your supplier gives you is going to determine how much work
- 10:26is involved to turn it from what they have into.
- 10:29What you can give stock sink. So there is work involved,
- 10:32setting this up and just like anything else.
- 10:34This could be a situation where supplier possibly is in updating
- 10:37their inventory correctly. And then that would push to your
- 10:40store automatically because it, that's how it works.
- 10:42It does what your suppliers inventory tracking says?
- 10:45So it's still is worth it. If you have one of these massive
- 10:49called a mega store, let's say you sell chandeliers.
- 10:52And again, you have three hundred Brands.
- 10:53You sell for an inventory, is just constantly like being sold
- 10:57through an updated. Then maybe you do want to do
- 10:59this. Just know there is work
- 11:01involved. Getting it set up and then once
- 11:03it's set up, there's work involved to make sure everything
- 11:05is working correctly and again, you don't run into a situation
- 11:08where inventory just goes to 0 and it never gets updated.
- 11:11Now it should write if your supplier updates, their
- 11:14inventory, sheets correctly, and if your settings and stocks
- 11:17think are correct, then it should do what it's supposed to
- 11:19do. But if there's human error at
- 11:21any point of the process, then the automations that it does
- 11:24just will push through bed data. So got to make sure it's set up
- 11:28correctly. But if You're in a situation
- 11:30where you feel totally overwhelmed with tracking
- 11:33inventory. Not because of an irrational
- 11:35fear, but because you're having issues, and it's just too much
- 11:38to do manually, then I would highly encourage you to check
- 11:40out that app stock sink. So those are the two methods
- 11:43guys. Both free and paid again for a
- 11:45lot of people. You don't even need to use
- 11:47either of them. But if you're one of the people
- 11:49out there that does deal with inventory issues, that's looking
- 11:52for a solution, I hope this episode will help you out and
- 11:56cause you less headaches in the future.
- 11:58So as always guys, I hope you got value.
- 11:59If you did, be sure to leave a review over on Apple podcasts, I
- 12:03really appreciate that and I read all of them and if you're
- 12:05not subscribed to the podcast yet just search for e-commerce
- 12:08Lifestyle on. Whatever podcast player you use
- 12:11click subscribe and you'll get notified every Monday and
- 12:14Thursday when new episodes go live.
- 12:16So thank you, I appreciate you and I'll talk to you next one.