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
05. Product model and migration

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
We're going to be jumping straight into products. So let's get our products table set up, have a look at what information we want to include in here and what information we don't want to include.
00:09
So let's go ahead and make a model out here called product and, of course, generate a migration alongside of that. So if we open up our create products table migration, let's fill this in with the information that we need.
00:21
So again, this is going to be pretty straightforward. We're going to have a string in here with the title. We're going to have a slug in here as well. So let's add slug.
00:29
And again, make sure that's constrained uniquely in the database. We're also going to include a description as well. I'll just add this as a string, but you
00:37
can add that as text if you need anything a little bit longer. And we're also going to make that nullable because a product might not have a description. Now let's talk about pricing.
00:46
We're going to cover pricing in detail later on in the course. But for pricing, we don't want to store this as a decimal or a float. We want to store this as an integer.
00:54
So for example, if something costs 1 pound, that's going to be 100 pence or cents, however you have them denominations. So let's go ahead and add in an integer for our price.
01:05
And then we're going to pull in a package later to deal with formatting these properly. The reason that integers are good for prices is they are much more precise.
01:15
If you start using floats and decimals, you will end up at some point with some really dodgy pricing. So we're going to also make this unsigned because we never want this to be negative.
01:25
What we're also going to allow for, and the only other thing we're going to allow for, is a date time, which tells us when a product is live. It's very likely that in some sort of admin panel,
01:35
you're going to want to modify a product before it goes live, add pictures, make sure it looks good. So let's add in a live column, which can also be nullable because, of course, if it is nullable, then it's not live.
01:48
And that is pretty much all we need for our product. So let's go and run phpArtisanMigrate. And let's check this out over in the database. There we go.
01:58
That is as simple as our products table gets. The complex part and the part where we start to dive into the different variations comes under the variation model, the variation table.
02:09
So I'm just going to add in one product here. Let's just call this example product for now and add in a example product string. And I'll just say this is an example product.
02:19
We're going to dive straight over to the product page in the next episode. And let's just add a price here of 50 in whatever currency you're working at.
02:28
And we'll also set live at to now. We'll deal with marking things live and not live a little bit later. So that is our first product in a really, really simple product
02:41
table, which is all we need. It's pretty much just the data to display this product to the user, which we're going to do in the next episode.
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!