This episode is for members only

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

Get started
Already a member? Sign in to continue
Playing
58. Reducing stock after ordering

Episodes

0%
Your progress
  • Total: 8h 42m
  • Played: 0m
  • Remaining: 8h 42m
Join or sign in to track your progress
01. Introduction and demo
9m 42s
0%
02. Installing Laravel, Breeze and Livewire
4m 47s
0%
03. Creating categories
9m 4s
0%
04. Recursively displaying categories
8m 21s
0%
05. Product model and migration
2m 50s
0%
06. Showing a product
7m 50s
0%
07. Product variation setup
10m 26s
0%
08. Creating the product selector
10m 34s
0%
09. Loading child variation dropdowns
4m 28s
0%
10. Faking adding the final variation
9m 33s
0%
11. Setting up product stock
4m 34s
0%
12. Calculating variation stock levels
9m 1s
0%
13. Adding product images with MediaLibrary
8m 50s
0%
14. Creating the product gallery
7m 28s
0%
15. Providing a fallback image
2m 56s
0%
16. Adding media to product variations
3m 37s
0%
17. Creating the cart model
3m 37s
0%
18. Registering the cart service
6m 34s
0%
19. Creating a cart session
11m 4s
0%
20. Showing the cart in the navigation
9m 19s
0%
21. Caching the cart instance
3m 2s
0%
22. Adding items to the cart
14m 1s
0%
23. Creating the notification component
8m 5s
0%
24. Showing the user's cart
6m 50s
0%
25. Outputting cart items
4m 50s
0%
26. Showing variation specifics
8m 8s
0%
27. Updating item quantity
8m 2s
0%
28. Removing an item from the cart
6m 1s
0%
29. Calculating the cart summary
8m 7s
0%
30. Showing the category products page
5m 1s
0%
31. Indexing products in Meilisearch
8m 32s
0%
32. Hooking up products to categories
4m 15s
0%
33. Building the product browser
13m 32s
0%
34. Showing child categories
1m 51s
0%
35. Indexing product variations for filtering
8m
0%
36. Outputting variations for filtering
12m 52s
0%
37. Hooking up product filters with Livewire
7m 48s
0%
38. Filtering products
12m 24s
0%
39. Filtering by price
9m 50s
0%
40. Adding global navigation search
7m 50s
0%
41. Handling products that are not live
3m 22s
0%
42. Price range category fix
1m 18s
0%
43. Scaffolding the checkout page
8m 6s
0%
44. Listing shipping options
9m 3s
0%
45. Calculating the cart totals
2m 52s
0%
46. Validating the account form
9m 10s
0%
47. Validating the shipping form
5m 47s
0%
48. Saving the shipping address
8m 4s
0%
49. Selecting a saved shipping address
6m 39s
0%
50. Fix shipping address error for non authenticated users
1m 7s
0%
51. Redirecting if the cart is empty
2m 42s
0%
52. Checking for quantity changes
7m 11s
0%
53. Syncing if quantities have changed
11m 59s
0%
54. Flashing a message when quantities have changed
5m 48s
0%
55. Setting up for orders
5m 17s
0%
56. Creating an order
13m 24s
0%
57. Attaching variations to order
6m 13s
0%
58. Reducing stock after ordering
2m 56s
0%
59. Meilisearch filter query fix
1m 33s
0%
60. Showing the order confirmation page
7m 39s
0%
61. Attaching orders for registering guest users
5m 17s
0%
62. Scaffolding the orders page
5m 30s
0%
63. Filling in order variation details
5m 24s
0%
64. Returning the order status
4m 39s
0%
65. Detecting order status changes
10m 49s
0%
66. Sending the order status change email
5m 12s
0%
67. Sending an order confirmation email
2m 47s
0%
68. Handling deleted cart records
4m 44s
0%
69. Transferring the guest cart
2m 44s
0%
70. Creating a presenter for the order status
4m 31s
0%
71. Setting up Stripe
3m 43s
0%
72. Creating and updating a PaymentIntent
16m 21s
0%
73. The Stripe card form
3m 35s
0%
74. Validating before payment
5m 34s
0%
75. Submitting a payment
6m 40s
0%
76. Checking for a successful payment
5m 47s
0%
77. Handling Stripe client errors
3m 11s
0%
78. Entangling Stripe customer data
2m 18s
0%

Transcript

00:00
Okay, so after we've created the order and we have attached the variations,
00:05
we of course need to reduce the stock. So we're going to do this in a slightly inefficient way by going ahead and iterating through all of the contents, which means if we had 10 items now can't, we're going to go ahead and form 10 queries.
00:19
We'll clear this up a little bit later, but let's get this done for now. Once we've iterated through them for each of the variations, which we get into this closure here,
00:29
we are going to go ahead and access the stocks, and we're going to create a record, and remember this is going to be a negative record. So all we need to do for this is in the amount,
00:40
just subtract from zero. So we're just going to grab from that pivot table, the quantity, and that's pretty much it. So let's go ahead and try this out.
00:52
We just come over here. Remember, we're not clearing our car out just at the moment, so we've got all of these products still in here. Let's go and choose an address.
01:01
We'll keep an eye on our stocks table as well. So let's open this up and just keep that open. Let's click confirm order, and yeah, we need to add the fillable property to stock.
01:12
Let's head over to the model here, and let's jump down and of course, go ahead and add in that fillable column, and that's going to be amount.
01:22
Let's head back over, try that again, and make sure we choose an address. There we go. If we head over to our stocks table now,
01:32
we have a minus two and a minus five in there because of course, we chose two and five as our quantities. So the last thing we want to do is just clear out all of the items from the car.
01:44
So let's go ahead and say, we're going to call this remove all, or you could just call it clear. Let's go over to our car model,
01:52
and let's implement that remove all method, and all we're going to do here is access the car instance, go ahead and grab the variations relationship, and when we call detach on this relationship
02:08
without passing anything through, it's just going to remove all of these for us. So eventually now we're going to get to the point where these are removed from our car,
02:18
and of course, we're not going to see it up in the navigation. So if we go over to the database, let's clear out these negative stocks once again.
02:26
Let's clear this order out, or all of these orders, we can actually truncate this table, and let's try this from scratch. So let's choose an address,
02:37
let's go ahead and confirm this order and pay, and when we give this a refresh, we're actually redirected back to the car page because of middleware that we added earlier.
02:47
But of course, if we head over to the database, that order's been created, the variations have been attached, and then stocks have been reduced.
78 episodes8 hrs 42 mins

Overview

Build a robust e-commerce platform with a Laravel and Livewire. Features products with unlimited and flexible variations, a product browser with filters and price range slider, global product search, guest checkout, shipping and payment implementation, order status tracking and more.

Alex Garrett-Smith
Alex Garrett-Smith
Hey, I'm the founder of Codecourse!

Episode discussion

No comments, yet. Be the first!