Sign up to access "Build an E-Commerce Platform" right now.

What we attach it to and then as we go through the course we can start to look at our stock levels perhaps showing them inside of these drop-downs whether we have low stock and of course We're also going to want to disable these if they're out of stock because we don't want users to be able to select them So let's close everything off just so we can sort of start fresh with stock and we'll go ahead and create out a model which is

Going to represent the stock we have so let's say model stock and create a migration So let's open up the create stocks table could rename that if you wanted to What do we attach stock to well we know it's going to be a variation, so let's say foreign ID Variation ID and we'll go ahead and constrain that as well in there now

The only other thing that we want in here is the amount so let's create an integer With the amount now Let's go ahead and migrate this and we'll just fill in some records here and speak about how this is going to work We did speak about this in the introduction, but it'd be good to go over it

So over in stocks, let's add some stock to our size 8 in black So that's the parent ID of one I'm gonna add 10 in here and we'll fill in the created and updated update and that's it We now have 10 Nike Air Force Ones in black in size 8 in stock

What we're not going to do with this is when someone checks out reduce this number it doesn't make sense because then it doesn't give us a ledger of how many stocks have been added and Then how many have been removed? Ideally what we want is the sort of running list of the stock that we've added and the stock that's been taken away

This isn't by any means an advanced way of stock keeping but it works a lot better than having a single Value that you decrement and increment and then you can't keep track of what's going on So effectively what's going to happen is when someone checks out and buys two pairs We're gonna add a minus two value in here

So when we total up the amount of stock we have for a specific variant, this of course will now be eight so now that we've done that let's just finish up with the Relationships and then as we get through and start to calculate stock we can make use of them So over in the variation model, let's go ahead and create out a relationship in here and we're just going to call that stocks

So let's say return this has many and We'll just pass our stock Model into there. So that is now our stock Just as an example, let's take a really really quick example

Look at this and go over to our product drop-down blade file now eventually in here We're gonna say things like low stock when we get to implement their methods But for now, let's just take a really quick look at how we might calculate the stock that we have for a particular variation so what we're gonna do is say variation and

Stocks, I'm gonna sum up The total amount of stock let's go over give that a refresh and you can see here for black We've got zero that kind of makes sense because we don't have any stock levels for that And then for each of these we should actually see

The yeah, so I've used total that's amount We should see 10 now what's gonna happen is if we have another record in here and someone checks out with two

When that sums it up We're gonna end up with eight so bit confusing that we've got size eight and eight in stock But you know what that means? So now that we've got stock working we can go ahead and implement some other

Methods that are gonna allow us to check if it's out of stock if it's low in stock and we'll also talk about the overall stock for a particular variation For example, if eight and nine are both out of stock We shouldn't be able to select black because that doesn't have any stock in it

You can change it up to not do that But that's what we're gonna do just to make it a little bit more thorough So to finish off let's get rid of this and we can move over to changing around these drop downs based on stock levels Thank you for watching!