Meeting Title: Inventory Data Model Review Sync Date: 2025-07-16 Meeting participants: Demilade Agboola, felipefaria
WEBVTT
1 00:06:45.420 ⇒ 00:06:46.880 felipefaria: Hey, de Milati!
2 00:06:47.400 ⇒ 00:06:50.240 felipefaria: Sorry for the the delay here.
3 00:06:51.005 ⇒ 00:06:53.290 Demilade Agboola: Hey, Blife, how are you? Hope you’re good?
4 00:06:53.900 ⇒ 00:06:55.240 felipefaria: I’m good. How are you?
5 00:06:55.470 ⇒ 00:06:58.610 Demilade Agboola: I’m doing very well. Give me one second.
6 00:07:00.020 ⇒ 00:07:04.409 Demilade Agboola: I have been able to make modifications to the model.
7 00:07:05.411 ⇒ 00:07:07.058 Demilade Agboola: So we now have
8 00:07:07.970 ⇒ 00:07:14.600 Demilade Agboola: give me one second, let me share my screen. So we now have the list of sub orders
9 00:07:14.710 ⇒ 00:07:18.250 Demilade Agboola: consoled and uncommitted in there, as well.
10 00:07:18.800 ⇒ 00:07:22.179 felipefaria: So we could run a couple of tests. Are there any like.
11 00:07:22.620 ⇒ 00:07:24.430 Demilade Agboola: Numbers you would like us to check.
12 00:07:27.570 ⇒ 00:07:28.910 Demilade Agboola: We can do so.
13 00:07:33.770 ⇒ 00:07:38.899 felipefaria: In, in this, in this table is, is still not.
14 00:07:39.750 ⇒ 00:07:43.359 Demilade Agboola: Like. I still don’t have access to it. Right?
15 00:07:43.760 ⇒ 00:07:47.699 Demilade Agboola: That would. That will depend on Emily making it available to you.
16 00:07:48.380 ⇒ 00:07:49.250 felipefaria: Okay.
17 00:07:49.350 ⇒ 00:07:52.129 felipefaria: But then, essentially, now, we can.
18 00:07:53.500 ⇒ 00:08:06.510 felipefaria: We can see by lot the suborders that like in their status, essentially, if they’re uncommitted, or if they’re cancelled and things like that, because, like the inventory number id here.
19 00:08:07.300 ⇒ 00:08:10.360 felipefaria: this is. This is the lot right.
20 00:08:10.780 ⇒ 00:08:12.579 Demilade Agboola: Yes, that’s by lot.
21 00:08:12.580 ⇒ 00:08:13.490 felipefaria: Okay?
22 00:08:20.910 ⇒ 00:08:25.330 felipefaria: so and then and where is the sub orders in that? In that table.
23 00:08:26.695 ⇒ 00:08:32.369 Demilade Agboola: Yeah. So you can see. So you can see the the list of uncommitted supporters or council supporters.
24 00:08:33.750 ⇒ 00:08:40.980 felipefaria: Oh, yeah, on my end is just showing everything. No. And so meaning that then there is no one committed or canceled in this list is that it.
25 00:08:41.210 ⇒ 00:08:45.110 Demilade Agboola: Oh, no, it’s the the like, the ones we’re looking at. Yes.
26 00:08:45.220 ⇒ 00:08:50.530 Demilade Agboola: but if you give us like a specific, or we can look at and try and get an idea of. If the numbers match.
27 00:08:52.030 ⇒ 00:08:52.750 felipefaria: Okay.
28 00:08:55.890 ⇒ 00:08:58.020 felipefaria: Let me see.
29 00:09:09.490 ⇒ 00:09:12.800 Demilade Agboola: It can literally just be the lot. Id. That also works too.
30 00:09:13.470 ⇒ 00:09:15.703 felipefaria: Yeah, I’m just pulling that
31 00:09:17.840 ⇒ 00:09:20.649 felipefaria: the document that we were working on yesterday.
32 00:09:21.560 ⇒ 00:09:26.990 felipefaria: Let’s well, and let’s just check this one. I just put like a random one in from
33 00:09:28.070 ⇒ 00:09:35.230 felipefaria: and from the the work session document, the one that we saw some.
34 00:09:36.180 ⇒ 00:09:50.950 felipefaria: some issues yesterday that we were talking about, right of, like the the lot, showing quantities of the original skew, plus whatever the skew was substituted with, whether it’s a redelivery or a forced upgrade.
35 00:09:53.160 ⇒ 00:10:11.639 felipefaria: so we can check on that. And I’m not sure if you guys had the time yesterday to to go over this and see like what was causing this inflated data in looker but this is kind of like one of the takeaways from yesterday, right? That we that we found that
36 00:10:12.300 ⇒ 00:10:15.950 felipefaria: the overall numbers were inflated there because they were counting.
37 00:10:16.620 ⇒ 00:10:20.309 felipefaria: and they were counting the the original order.
38 00:10:21.230 ⇒ 00:10:22.060 Demilade Agboola: Yeah.
39 00:10:23.510 ⇒ 00:10:27.540 felipefaria: Is okay. So this is right.
40 00:10:28.250 ⇒ 00:10:40.150 felipefaria: So what is it giving me? There, is it? Oh, okay, so this is just one is one role per lot. But then, is it supposed to give me the suborder? Id as well.
41 00:10:40.340 ⇒ 00:10:46.639 Demilade Agboola: Yes, I will. So so these are the uncommitted support ids that were fulfilled on this.
42 00:10:48.050 ⇒ 00:10:51.580 felipefaria: Okay of.
43 00:10:54.410 ⇒ 00:10:58.790 felipefaria: Give me one second. And can you actually copy and paste one of the orders.
44 00:10:59.190 ⇒ 00:11:00.000 Demilade Agboola: Okay. So they’re.
45 00:11:00.010 ⇒ 00:11:01.500 felipefaria: In the note.
46 00:11:02.900 ⇒ 00:11:03.780 Demilade Agboola: Okay.
47 00:11:07.410 ⇒ 00:11:08.509 felipefaria: Yeah, any of those.
48 00:11:11.130 ⇒ 00:11:12.340 Demilade Agboola: That just sounds it.
49 00:11:35.420 ⇒ 00:11:45.380 felipefaria: Okay. So this one is showing in dashes on hand, committed
50 00:11:45.830 ⇒ 00:11:51.970 felipefaria: the, and I just pulled the join the Liverpool. Hold on!
51 00:11:52.210 ⇒ 00:11:56.209 felipefaria: I put the 1st one, the 34, 7, 6, 1, 4, 0.
52 00:11:56.370 ⇒ 00:11:56.940 Demilade Agboola: Okay.
53 00:11:57.670 ⇒ 00:12:01.419 felipefaria: That one is showing as on hand committed on my end.
54 00:12:02.350 ⇒ 00:12:09.269 Demilade Agboola: So, and when it’s uncommitted we don’t want it to show as uncommitted.
55 00:12:13.920 ⇒ 00:12:17.339 felipefaria: So this is what Emily was saying yesterday. Right?
56 00:12:17.990 ⇒ 00:12:22.670 felipefaria: I think that then he should be at this distinction. Oh, well, I guess.
57 00:12:23.570 ⇒ 00:12:30.019 felipefaria: In this case it makes sense, because the order was already
58 00:12:30.520 ⇒ 00:12:39.060 felipefaria: shipped and delivered. Right? So so, yeah, like on him committed should show on the uncommitted. If
59 00:12:39.800 ⇒ 00:12:43.140 felipefaria: the delivery date is in the past.
60 00:12:44.790 ⇒ 00:12:49.509 felipefaria: because that means that something is off right, and that is.
61 00:12:50.560 ⇒ 00:12:57.990 felipefaria: and I don’t know exactly like how and how could that be that is on hand? Oh, well, actually on hand committed.
62 00:12:59.480 ⇒ 00:13:09.940 felipefaria: And we we wouldn’t wanna show the on order committed right? Like what what I’m talking about is the on order committed. But on hand committed is just like.
63 00:13:11.080 ⇒ 00:13:14.140 felipefaria: it means that everything is okay with the order. Right?
64 00:13:17.250 ⇒ 00:13:18.460 felipefaria: So
65 00:13:18.780 ⇒ 00:13:26.139 felipefaria: so yeah, like in this case here, like, I don’t see any issue the artist shows as committed is shipped, and it was delivered.
66 00:13:26.500 ⇒ 00:13:33.520 felipefaria: so I don’t know why it would, it would show up in this in this report. Now, if it’s on order committed.
67 00:13:34.360 ⇒ 00:13:41.599 felipefaria: and the delivery date is in the past, meaning that the product actually shipped. But it’s still
68 00:13:42.050 ⇒ 00:13:44.670 felipefaria: under this own order status.
69 00:13:44.770 ⇒ 00:13:50.789 felipefaria: Then I guess we can. And we can put it under the uncommitted. And we’re gonna have to figure out like.
70 00:13:51.240 ⇒ 00:13:57.649 felipefaria: why, that is right, like. The only reason why I would I would see a scenario like this
71 00:13:59.280 ⇒ 00:14:03.340 felipefaria: is if a Po wasn’t received for
72 00:14:04.620 ⇒ 00:14:15.890 felipefaria: any reason, and I would imagine, for example, the the farm direct orders it would all show under on order, like on order committed because we received the pos after
73 00:14:16.100 ⇒ 00:14:17.859 felipefaria: after the week is over.
74 00:14:19.296 ⇒ 00:14:26.320 felipefaria: And that’s that’s basically the only scenario that I could that I could see
75 00:14:27.160 ⇒ 00:14:33.279 felipefaria: something being on order committed and at the same time have been shipped.
76 00:14:33.510 ⇒ 00:14:40.390 felipefaria: I’m gonna take a look at the other orders as well. But yeah, that 1st one. I’m not entirely sure. Why, it’s showing under the UN committed.
77 00:14:41.790 ⇒ 00:14:48.810 Demilade Agboola: Yeah. But is the item id the same? Because that’s that’s usually why that’s my filter. For, like uncommitted.
78 00:14:49.990 ⇒ 00:15:03.940 felipefaria: Yeah, yeah, like I was looking at is the firecracker, and that we were looking at right? And and in that particular order, the 1st one it was for a subscription skew. The subscription skews crossed out, and they actually shipped the firecracker.
79 00:15:04.060 ⇒ 00:15:06.810 felipefaria: So it seems like that’s correct.
80 00:15:07.050 ⇒ 00:15:08.015 felipefaria: But
81 00:15:09.760 ⇒ 00:15:16.260 felipefaria: yeah, like, and that’s the same thing on the on the second one it shows on hand, committed, delivered, shipped on
82 00:15:16.470 ⇒ 00:15:19.880 felipefaria: like, delivered on 7 9. So last last week.
83 00:15:20.280 ⇒ 00:15:21.170 Demilade Agboola: Okay.
84 00:15:21.350 ⇒ 00:15:24.210 felipefaria: So I’m not sure what’s going on there, but.
85 00:15:34.830 ⇒ 00:15:38.370 Demilade Agboola: I think you’re muted not sure what happened.
86 00:15:49.120 ⇒ 00:15:51.049 Demilade Agboola: I don’t know if he’s talking, but he’s still muted.
87 00:16:22.950 ⇒ 00:16:26.529 Demilade Agboola: So if can you hear me.
88 00:16:29.380 ⇒ 00:16:30.370 felipefaria: Yes.
89 00:16:30.820 ⇒ 00:16:33.879 Demilade Agboola: Okay. So now you’re you’re you’re unmuted.
90 00:16:34.050 ⇒ 00:16:38.300 Demilade Agboola: So you were talking. And I just you just kind of cut off. And I noticed you were muted.
91 00:16:38.660 ⇒ 00:16:42.120 felipefaria: Oh, we’re can you hear me now?
92 00:16:42.120 ⇒ 00:16:43.070 Demilade Agboola: I can’t hear you now
93 00:16:46.790 ⇒ 00:16:58.069 Demilade Agboola: cause the criteria to to count things as uncommitted suborders is when the item id that shipped is not the same as the inventory. Item id on that lot.
94 00:16:59.030 ⇒ 00:17:03.790 Demilade Agboola: Then countless other idea associated with that. So we have to look into this.
95 00:17:05.021 ⇒ 00:17:07.729 Demilade Agboola: Figure out, let me give this a quick second.
96 00:17:08.900 ⇒ 00:17:12.170 Demilade Agboola: I’ll figure out why that is.
97 00:17:13.740 ⇒ 00:17:14.560 felipefaria: Well.
98 00:17:19.950 ⇒ 00:17:21.606 felipefaria: is there a way?
99 00:17:22.339 ⇒ 00:17:24.929 felipefaria: Because I think that those are
100 00:17:27.390 ⇒ 00:17:33.819 felipefaria: 2 slightly different things right like, and I’m gonna have to go back like for, like those 4 orders.
101 00:17:33.940 ⇒ 00:17:36.460 felipefaria: and see and see, because, like.
102 00:17:37.220 ⇒ 00:17:41.550 felipefaria: I’m looking at one here. And yes, there is a original skew
103 00:17:42.573 ⇒ 00:17:56.600 felipefaria: that was supposed to be shipped the Unicorn it it that one was crossed out, so the original ordered for the subscription was the Unicorn. We probably didn’t have any available, so they went ahead and they switch it to the firecracker.
104 00:17:57.140 ⇒ 00:18:01.029 felipefaria: But that what I did that I gave you
105 00:18:01.670 ⇒ 00:18:05.400 felipefaria: is for the firecracker, right? So
106 00:18:07.530 ⇒ 00:18:15.000 felipefaria: And in this instance the firecracker actually shipped, and is showing, as on hand, committed here.
107 00:18:15.350 ⇒ 00:18:16.140 Demilade Agboola: Okay.
108 00:18:17.180 ⇒ 00:18:24.020 felipefaria: So I don’t know if that’s the the main way that we wanna that we wanna describe
109 00:18:24.250 ⇒ 00:18:47.000 felipefaria: like uncommitted like, is there a way for you to pull in dash because each order has their status right? Like it. It will show under the order if it’s on hand committed. If it’s like no phone order committed? Or if it’s uncommitted like, and couldn’t we just pull that status and then just
110 00:18:48.180 ⇒ 00:18:53.670 felipefaria: put it under like and put it to in in on the report, and then just kind of like
111 00:18:55.760 ⇒ 00:19:05.619 felipefaria: one. Have a have a report that just shows like list of uncommitted orders, and then we can. We can pull by, like, you know, date range of like
112 00:19:06.300 ⇒ 00:19:09.617 felipefaria: adjustment date, or something like that.
113 00:19:10.641 ⇒ 00:19:17.159 Demilade Agboola: Well, that that’s fine. I think the the thing is, I will still need to go to that. So the reason why it’s saying, like 3, 4,
114 00:19:17.610 ⇒ 00:19:21.849 Demilade Agboola: 3, 4, 7, 1, 4, 0 is this, is, it identifies the item
115 00:19:22.070 ⇒ 00:19:28.859 Demilade Agboola: sold as 4 0 0 6. Meanwhile the item on the lot is 6 80,
116 00:19:29.920 ⇒ 00:19:36.820 Demilade Agboola: which is what the assumes the firecracker to be. So that’s why this is as a
117 00:19:39.850 ⇒ 00:19:41.370 Demilade Agboola: as an uncommitted.
118 00:19:46.770 ⇒ 00:19:52.690 felipefaria: Hmm, yeah. The 6 80 means uncommitted. Right?
119 00:19:53.090 ⇒ 00:19:56.859 Demilade Agboola: So the 6 80 means firecracker like that’s the inventory number Id.
120 00:19:57.210 ⇒ 00:20:02.449 Demilade Agboola: and then 4, 6 is the id number. For give me one second, let me try. See.
121 00:20:03.650 ⇒ 00:20:07.480 felipefaria: Yeah, for the other skews, like the classic subscription.
122 00:20:11.600 ⇒ 00:20:12.530 Demilade Agboola: Yeah.
123 00:20:13.030 ⇒ 00:20:24.919 felipefaria: Yeah. But in this case, like it shouldn’t really show there. Right? Because is it in uncommitted? We, we just wanna know, like an order that is uncommitted is just an order that
124 00:20:25.410 ⇒ 00:20:28.240 felipefaria: was ordered by that and by a customer.
125 00:20:28.520 ⇒ 00:20:31.770 felipefaria: But it didn’t claim inventory.
126 00:20:32.070 ⇒ 00:20:45.400 felipefaria: So so it didn’t. Really, we didn’t really allocate a unit of our inventory to that order. That order could have shipped or not. But it’s it’s not really being counted
127 00:20:45.670 ⇒ 00:20:52.280 felipefaria: on the inventory side, right like what is showing there is just like any order that
128 00:20:52.380 ⇒ 00:21:03.490 felipefaria: had any sort of modification to it. So in this case the original order was for the classic subscription. But we didn’t send the classic subscription. We ended up shipping the firecracker.
129 00:21:03.670 ⇒ 00:21:11.520 felipefaria: So if we’re looking at a lot for the firecracker that shouldn’t flag anything. Really.
130 00:21:13.030 ⇒ 00:21:14.970 felipefaria: In in the
131 00:21:15.120 ⇒ 00:21:23.110 felipefaria: and for the classic subscription, too. If we wanted to go to the classic subscription lot like, and I wouldn’t really.
132 00:21:24.300 ⇒ 00:21:28.040 felipefaria: up until now like this wouldn’t really be a flag
133 00:21:28.200 ⇒ 00:21:36.560 felipefaria: either. Right? Like. What happened is that throughout the week that order was claimed, and so they it was committed at some point.
134 00:21:37.090 ⇒ 00:21:43.239 felipefaria: but then it just became afs again, or you know it, just like
135 00:21:44.270 ⇒ 00:21:58.839 felipefaria: it just was put back into, or or it was like transferred into an adjustment because we don’t have the inventory available. So the team just said, Oh, like, I’m claiming this order. But we don’t have the inventory available. So
136 00:21:59.070 ⇒ 00:22:05.990 felipefaria: let’s just make an Ia to to prevent that that one unit from being
137 00:22:06.430 ⇒ 00:22:10.859 felipefaria: able to be sold again. It’s kind of odd, because it’s the classic subscription, which
138 00:22:12.440 ⇒ 00:22:23.190 felipefaria: is a skew that we shouldn’t be running out of. So I imagine that there might be something related to the subscription assigning that order incorrectly to the classic subscription.
139 00:22:23.540 ⇒ 00:22:30.950 felipefaria: and then the care team just saying, No, they like this customer. Instead of receiving the classic subscription, they should actually receive
140 00:22:31.360 ⇒ 00:22:38.000 felipefaria: another tier of subscription instead. Right? And so they remove the classic subscription, and they put the firecracker instead.
141 00:22:38.560 ⇒ 00:22:39.940 felipefaria: If that makes sense.
142 00:22:40.420 ⇒ 00:22:41.150 Demilade Agboola: Yeah.
143 00:22:42.060 ⇒ 00:22:58.699 Demilade Agboola: so it’s so basically this, the item id, like the item, the product itself is still the same product. It’s just a different type of delivery like it’s a different. Instead of you being classic, it’s a sub. Instead of being a classic subscription. It’s a different type of delivery. If that makes any sense.
144 00:22:59.044 ⇒ 00:23:15.569 felipefaria: It. It’s a different skew. Right? Like classic subscription is the name of a skew. And for us, and we have, like seasonal subscription and classic subscription, and imagine that that’s a bouquet like the classic subscription, is one bouquet, and the seasonal subscription is a different bouquet.
145 00:23:16.232 ⇒ 00:23:27.550 felipefaria: So and this is part of kind of like the subscription assortment, but they have several several skews that are offered for subscribed customers.
146 00:23:28.250 ⇒ 00:23:36.169 felipefaria: They have kind of like an automated way of like, you know, assigning which skew each of the subscribers are gonna receive
147 00:23:37.950 ⇒ 00:23:53.949 felipefaria: and and that’s my assumption here. But I believe that the system automatically subscribe this classic subscription skew to the customer, but didn’t care, went ahead, and then said, No, let’s send the firecracker to this customer instead.
148 00:23:54.390 ⇒ 00:23:59.380 felipefaria: So in my eyes, right like this is.
149 00:23:59.620 ⇒ 00:24:09.510 felipefaria: this is just another firecracker order that in the report should just be flagged as a subscription order.
150 00:24:09.620 ⇒ 00:24:16.579 felipefaria: And that’s and that’s it, like it shouldn’t really be on the uncommitted column.
151 00:24:16.830 ⇒ 00:24:19.929 Demilade Agboola: Okay, but it’s flagged as a give me one second.
152 00:24:21.280 ⇒ 00:24:27.790 Demilade Agboola: It is flagged, as, as I believe, an uncommitted subscription quantity. If I.
153 00:24:28.863 ⇒ 00:24:31.009 felipefaria: Well, actually, hold on!
154 00:24:31.450 ⇒ 00:24:33.460 Demilade Agboola: All committed quantity.
155 00:24:36.040 ⇒ 00:24:47.299 felipefaria: No? Oh, like, hold on! I see here that well, this is actually a redelivery of a subscription. So okay? And that makes sense, and they sent the classic subscription.
156 00:24:47.510 ⇒ 00:24:52.180 felipefaria: the customer complained, and then they they set up a redelivery
157 00:24:53.710 ⇒ 00:25:07.210 felipefaria: of that classic subscription as the firecracker. So and and so it shouldn’t show it as as a subscription in the reports to show as a redelivery. But on my end, like, and I’m in dash. Do you have access to dash.
158 00:25:07.440 ⇒ 00:25:08.539 Demilade Agboola: Yes, I do.
159 00:25:08.860 ⇒ 00:25:14.650 felipefaria: Yeah. And so if you go to that order right on the bottom, like you see the firecracker, and it shows on hand committed.
160 00:25:17.490 ⇒ 00:25:24.559 Demilade Agboola: It’s the so I have like different browsers. So it’s in the other browser that I use. Dash.
161 00:25:24.560 ⇒ 00:25:25.479 felipefaria: Yeah. No worries.
162 00:25:26.370 ⇒ 00:25:29.885 Demilade Agboola: Background and
163 00:26:00.710 ⇒ 00:26:04.079 Demilade Agboola: the orders I sent them in the chat.
164 00:26:19.590 ⇒ 00:26:21.940 Demilade Agboola: Interesting! I guess I don’t have permission.
165 00:26:21.940 ⇒ 00:26:25.070 felipefaria: Oh, no no! You just need to remove the dash. One.
166 00:26:25.070 ⇒ 00:26:27.420 Demilade Agboola: Okay, alright, gotcha gotcha.
167 00:26:32.490 ⇒ 00:26:35.230 Demilade Agboola: So I can’t do this of orders. I have to view.
168 00:26:35.230 ⇒ 00:26:38.370 felipefaria: Yeah, just the order. And then it will show that.
169 00:26:39.100 ⇒ 00:26:40.739 felipefaria: Yeah. So you see here on the bottom.
170 00:26:44.510 ⇒ 00:26:56.559 felipefaria: because we’re looking at that log. That is the firecracker lot. The firecracker is showing on hand committed like, and this is, and if you go to the top of the page, and you will see that this is a redelivery
171 00:26:56.660 ⇒ 00:27:01.559 felipefaria: like redelivery off this order here. Essentially.
172 00:27:03.260 ⇒ 00:27:06.040 felipefaria: this order was a classic subscription right?
173 00:27:06.775 ⇒ 00:27:18.419 felipefaria: Which shows on order committed. But that’s the classic subscription, and it kind of makes sense to show one order committed because, those pos.
174 00:27:19.520 ⇒ 00:27:30.379 felipefaria: Well, those pos are received after the fact. Like after the week is over this this was delivered on 6 27. So at this point they should really be
175 00:27:31.490 ⇒ 00:27:32.240 felipefaria: committed.
176 00:27:33.560 ⇒ 00:27:39.409 felipefaria: So I’m I’m gonna have to look in June that hold on.
177 00:27:39.900 ⇒ 00:27:40.300 Demilade Agboola: So.
178 00:27:40.500 ⇒ 00:27:47.090 felipefaria: For the for the example, that we were looking for the firecracker. Specifically, I don’t know why that order would be flagged.
179 00:27:48.960 ⇒ 00:27:50.750 Demilade Agboola: So I try. So I guess
180 00:27:53.740 ⇒ 00:27:58.600 Demilade Agboola: so it was flat, cause if we look at this.
181 00:28:00.270 ⇒ 00:28:01.199 felipefaria: So give me a second.
182 00:28:03.510 ⇒ 00:28:04.979 Demilade Agboola: So if we look at this.
183 00:28:05.810 ⇒ 00:28:16.189 Demilade Agboola: it shows that, for you know this order that we’re looking at a quantity of like
184 00:28:16.610 ⇒ 00:28:24.070 Demilade Agboola: one was sold interesting.
185 00:28:26.720 ⇒ 00:28:30.250 Demilade Agboola: So if country one was sold, there was the
186 00:28:30.820 ⇒ 00:28:33.700 Demilade Agboola: the desired item. Id was 4, 6,
187 00:28:34.320 ⇒ 00:28:36.719 Demilade Agboola: but what was actually delivered was 6, 80,
188 00:28:37.550 ⇒ 00:28:39.240 Demilade Agboola: and it was an eerie delivery.
189 00:28:42.070 ⇒ 00:28:43.020 felipefaria: Yeah.
190 00:28:44.110 ⇒ 00:28:51.460 Demilade Agboola: So I try to. So let me let me. Does this, should this appear instead, on this.
191 00:28:52.210 ⇒ 00:28:53.639 Demilade Agboola: how to how to explain this.
192 00:28:54.580 ⇒ 00:28:59.360 Demilade Agboola: so it should not. Should this, this should not appear on the firecracker lot.
193 00:28:59.360 ⇒ 00:29:14.419 felipefaria: Exactly. Yeah, it shouldn’t appear in the firecracker. It should like, because the the classic subscription one is showing us on order committed and it already shipped. Then it makes sense and showing to show on the list of uncommitted under
194 00:29:14.670 ⇒ 00:29:20.219 felipefaria: the 4 0 0 6 item, right.
195 00:29:20.220 ⇒ 00:29:22.059 Demilade Agboola: That makes that makes sense.
196 00:29:22.060 ⇒ 00:29:23.259 felipefaria: Yeah, but.
197 00:29:23.300 ⇒ 00:29:25.639 Demilade Agboola: It’s like an inverse right now, as
198 00:29:26.130 ⇒ 00:29:27.959 Demilade Agboola: like, I need to flip things around.
199 00:29:28.837 ⇒ 00:29:38.960 felipefaria: Yeah, yeah, if you wanna if you wanna do that, and then we can validate, and that it makes sense. But at the same time, like the way they have written now, like
200 00:29:39.590 ⇒ 00:29:43.370 felipefaria: well, I guess I saw like I don’t know why dash
201 00:29:44.190 ⇒ 00:29:51.659 felipefaria: is. This is displaying redeliveries different ways like it showed redelivery of that 1st order that we looked at
202 00:29:52.621 ⇒ 00:30:00.569 felipefaria: in in the way that we just saw right. But if we go to dash again, and we put the second order that we have there.
203 00:30:01.330 ⇒ 00:30:08.489 felipefaria: No, the no, the second order it’s is the same thing, but
204 00:30:08.620 ⇒ 00:30:11.770 felipefaria: it doesn’t show any skew crossed off
205 00:30:12.199 ⇒ 00:30:19.310 felipefaria: like on the and under the sub board. It just shows the double firecracker on our committed, but it is every delivery of
206 00:30:19.610 ⇒ 00:30:21.660 felipefaria: a different skew. Oh.
207 00:30:22.980 ⇒ 00:30:24.440 Demilade Agboola: Yeah. Teaser driver.
208 00:30:24.440 ⇒ 00:30:34.320 felipefaria: Yeah. And the and the other skew is also on order, like on hand committed.
209 00:30:34.550 ⇒ 00:30:35.980 felipefaria: So why.
210 00:30:39.610 ⇒ 00:30:40.869 Demilade Agboola: Why is it not crypto.
211 00:30:42.650 ⇒ 00:30:45.760 felipefaria: Yeah. Yeah. For the second order, which is the
212 00:30:46.100 ⇒ 00:30:48.190 felipefaria: the the one ending with 32.
213 00:30:48.890 ⇒ 00:30:53.340 Demilade Agboola: Yeah, I I just saw that. Actually, I also look at all the orders to get a feel.
214 00:30:54.130 ⇒ 00:30:57.099 Demilade Agboola: So this is not a redelivery.
215 00:30:57.880 ⇒ 00:30:58.739 felipefaria: Which one.
216 00:30:59.040 ⇒ 00:31:03.220 Demilade Agboola: It’s the it looks. This it shows.
217 00:31:03.470 ⇒ 00:31:14.169 felipefaria: Yeah, yeah, exactly. This is what I’m saying that in the dash is displaying redelivery in 2 different ways, right? Like some orders, is showing at the top of the page. But this one in particular is showing
218 00:31:14.310 ⇒ 00:31:17.829 felipefaria: there, and I haven’t seen it like this before.
219 00:31:18.480 ⇒ 00:31:19.670 Demilade Agboola: Interesting.
220 00:31:20.230 ⇒ 00:31:27.699 felipefaria: But it’s going to double the firecracker. So this is something, I think, for question for the Dev team really.
221 00:31:28.050 ⇒ 00:31:32.309 Demilade Agboola: I think this one is showing on the bottom, because it’s a redelivery of a redelivery.
222 00:31:34.120 ⇒ 00:31:36.210 felipefaria: Oh! Is every delivery of every delivery!
223 00:31:36.510 ⇒ 00:31:41.259 Demilade Agboola: It appears so, because this is the 3rd one. So this number.
224 00:31:42.000 ⇒ 00:31:42.710 felipefaria: Hello!
225 00:31:42.710 ⇒ 00:31:45.470 Demilade Agboola: The second order that we just looked at.
226 00:31:45.990 ⇒ 00:31:48.639 Demilade Agboola: That’s the redelivery dash id.
227 00:31:49.930 ⇒ 00:31:50.770 felipefaria: Yeah.
228 00:31:50.770 ⇒ 00:31:52.389 Demilade Agboola: Then this.
229 00:31:52.390 ⇒ 00:31:53.840 felipefaria: Oh, I see.
230 00:31:54.070 ⇒ 00:31:56.590 felipefaria: Maybe I’m I’m there. And then there’s a redelive.
231 00:31:56.590 ⇒ 00:32:06.140 Demilade Agboola: No, no, actually, no, no, it’s nice. This this order, the 3rd order, is actually what was being redelivered by this is the 1st order.
232 00:32:06.840 ⇒ 00:32:10.130 Demilade Agboola: the 3, 4, 7, 7, 3, 5, 0.
233 00:32:11.740 ⇒ 00:32:14.110 Demilade Agboola: Order that was placed, I guess.
234 00:32:14.400 ⇒ 00:32:20.709 Demilade Agboola: And then this 3, 4, 8, 0, 2, 3, which is this, is the redelivery of that order.
235 00:32:22.260 ⇒ 00:32:27.340 Demilade Agboola: Okay. So that’s the cause. I’m looking at the uncommitted. And I’m trying to figure out
236 00:32:28.210 ⇒ 00:32:30.870 Demilade Agboola: why the 3rd one is there.
237 00:32:31.850 ⇒ 00:32:35.710 Demilade Agboola: like the 3rd order, you know, essentially a list of 4 orders.
238 00:32:36.500 ⇒ 00:32:39.269 Demilade Agboola: So this is the 3rd one, and I’m wondering why it’s here.
239 00:32:43.140 ⇒ 00:32:44.209 felipefaria: Take a look, too.
240 00:32:45.740 ⇒ 00:32:47.200 Demilade Agboola: Nice tea.
241 00:33:15.320 ⇒ 00:33:16.460 felipefaria: 15.
242 00:33:22.580 ⇒ 00:33:23.250 felipefaria: Yeah.
243 00:33:36.690 ⇒ 00:33:44.460 felipefaria: yeah. But this is a good example to look at, because it’s the same skew shipped on both the the original and the redelivery.
244 00:33:44.620 ⇒ 00:33:46.950 Demilade Agboola: Yeah. And both of them are showing.
245 00:33:47.140 ⇒ 00:33:48.709 felipefaria: On hand, committed right.
246 00:33:49.100 ⇒ 00:33:49.720 Demilade Agboola: Yeah.
247 00:33:53.360 ⇒ 00:33:55.630 Demilade Agboola: Sorry. Should that be.
248 00:34:16.860 ⇒ 00:34:18.739 felipefaria: Are you guys meeting tomorrow as well.
249 00:34:19.190 ⇒ 00:34:20.829 Demilade Agboola: Yes, yes, we are.
250 00:34:21.130 ⇒ 00:34:27.982 felipefaria: Okay, yeah. Cause, Emily said. Tuesday and Wednesday, maybe I should join tomorrow as well.
251 00:34:29.250 ⇒ 00:34:34.030 felipefaria: just so we can and kind of go over this. But
252 00:34:35.710 ⇒ 00:34:40.590 felipefaria: yeah, we just need to to continue digging a little bit more into like
253 00:34:41.909 ⇒ 00:34:54.350 felipefaria: whether the the total quantity sold right, which includes the committed and the uncommitted. If that number is correct and not kind of double counting skews that are not under the
254 00:34:55.730 ⇒ 00:35:02.170 felipefaria: like a different skew that is, counting on the same kinda
255 00:35:03.790 ⇒ 00:35:08.230 felipefaria: line as as the firecracker, for example.
256 00:35:08.670 ⇒ 00:35:13.129 Demilade Agboola: Yeah, I’m guessing what’s going on here is
257 00:35:13.340 ⇒ 00:35:19.790 Demilade Agboola: the second item, which is 5, 8, 4, 1. i’m guessing. It’s this.
258 00:35:22.430 ⇒ 00:35:24.579 felipefaria: 5, 8, 4, 1.
259 00:35:24.990 ⇒ 00:35:27.949 felipefaria: Yeah, I’m not familiar with this item. Ids,
260 00:35:28.320 ⇒ 00:35:29.310 Demilade Agboola: Yup. Thank you.
261 00:35:30.100 ⇒ 00:35:31.469 felipefaria: Couldn’t find him.
262 00:35:31.550 ⇒ 00:35:32.420 Demilade Agboola: This.
263 00:35:33.210 ⇒ 00:35:35.940 felipefaria: Oh, potentially could be.
264 00:35:36.500 ⇒ 00:35:40.210 felipefaria: See if in dash it shows something
265 00:35:41.160 ⇒ 00:35:45.119 felipefaria: under the inventory page. Just so, I know what this item Ids are.
266 00:35:46.790 ⇒ 00:35:50.520 Demilade Agboola: I know we have a product page as well
267 00:35:51.270 ⇒ 00:35:53.390 Demilade Agboola: a product view of this thing.
268 00:35:53.990 ⇒ 00:35:54.930 Demilade Agboola: Second.
269 00:36:18.210 ⇒ 00:36:20.710 felipefaria: Yeah, I don’t see that item id anywhere.
270 00:36:26.980 ⇒ 00:36:29.889 felipefaria: Let me see if he’s under the actual net.
271 00:36:30.400 ⇒ 00:36:33.590 felipefaria: Netsuite page.
272 00:36:46.000 ⇒ 00:36:47.020 felipefaria: Nope.
273 00:36:52.625 ⇒ 00:37:01.489 felipefaria: this item Id is is like, maybe it’s from. I don’t know if it’s from shopify or something like, do you know where you pull this item? Id from?
274 00:37:01.660 ⇒ 00:37:06.899 Demilade Agboola: I’ve seen it. It’s the t look look at. I searched for it now it’s the T. It’s the.
275 00:37:07.190 ⇒ 00:37:15.660 felipefaria: Yeah. But where does it come from like this? Number 5, 8, 4, 1 like, is it from suite? Is it from.
276 00:37:15.870 ⇒ 00:37:16.609 Demilade Agboola: Next week.
277 00:37:16.850 ⇒ 00:37:19.070 Demilade Agboola: This part. Yeah.
278 00:37:22.180 ⇒ 00:37:34.780 Demilade Agboola: So I guess what I need to now do is ensure that I’m only looking at lotted items, because the issue now is, it’s counting, or I guess we we it’s counting the delivery of
279 00:37:36.760 ⇒ 00:37:42.709 Demilade Agboola: not just the bouquets, as it’s counting the fact that this was also delivered.
280 00:37:43.690 ⇒ 00:37:44.410 felipefaria: Yeah.
281 00:37:44.410 ⇒ 00:37:45.590 Demilade Agboola: It deleted.
282 00:37:45.590 ⇒ 00:38:07.520 felipefaria: Yeah, yeah, we need to. We we need to filter really to the skew level, right? Because the lot is associated to just one particular skew. Then we want to be looking at the data for that. One particular skew. And and the sub order itself could have multiple things on it. Right could have, like a bouquet, a vase, a a add on or multiple add ons.
283 00:38:07.880 ⇒ 00:38:19.180 felipefaria: But it doesn’t really matter if we are just looking at how many firecrackers we sold, we make sure that it’s not kind of double counting anything under the suborder.
284 00:38:19.540 ⇒ 00:38:21.480 felipefaria: Yeah, together.
285 00:38:21.780 ⇒ 00:38:27.260 Demilade Agboola: That’s fair, that’s fair. I will make that adjustment because I was wondering why it was counting this. Because I’m like this is a firecracker.
286 00:38:27.390 ⇒ 00:38:33.379 Demilade Agboola: But then it makes sense because it’s viewing this because I looked at the list of orders he was trying to petition.
287 00:38:33.660 ⇒ 00:38:35.270 Demilade Agboola: and I could see
288 00:38:36.750 ⇒ 00:38:42.510 Demilade Agboola: I could see that it. It was counting like the fact that there were other things on.
289 00:38:43.490 ⇒ 00:38:44.300 felipefaria: Yeah.
290 00:38:44.570 ⇒ 00:38:48.279 Demilade Agboola: As that, so I will make that I will make that change to it.
291 00:38:48.843 ⇒ 00:38:54.690 Demilade Agboola: So we would only filter out only for all changes like hard, hard goods won’t count as.
292 00:38:55.060 ⇒ 00:38:57.030 Demilade Agboola: but won’t count against this.
293 00:38:57.950 ⇒ 00:39:08.640 felipefaria: Yeah, yeah. Hard, hard goods, really like anything other than that particular skew, right? Like, if you could filter out to that particular skew, it would be the the best one, because
294 00:39:09.110 ⇒ 00:39:17.300 felipefaria: then it avoids us counting that kind of like original skew. If that skew was removed, kind of like what we saw with the classic subscription
295 00:39:17.440 ⇒ 00:39:22.099 felipefaria: being counted under under this lot. So it’s not only hard goods. It’s like
296 00:39:23.730 ⇒ 00:39:33.000 felipefaria: we don’t want anything else under the then that particular skew that is associated with the lot should be counted here.
297 00:39:33.610 ⇒ 00:39:36.939 Demilade Agboola: Okay, alright. Sounds good. I will make the modification
298 00:39:37.270 ⇒ 00:39:38.789 Demilade Agboola: over the course of the day.
299 00:39:39.160 ⇒ 00:39:45.080 felipefaria: Alright, yeah, and we can touch base tomorrow if you want to add me to the meeting. I’m not sure if I’m already added. But
300 00:39:45.578 ⇒ 00:39:48.920 Demilade Agboola: No, you’re not. I’ll do that right now, literally as we speak.
301 00:39:49.970 ⇒ 00:39:52.049 felipefaria: Okay, okay, yeah, because.
302 00:39:52.710 ⇒ 00:39:58.819 felipefaria: yeah, like, in, just to recap kind of like, the goal on my end really is to
303 00:39:58.960 ⇒ 00:40:06.599 felipefaria: have an understanding of everything that shipped for a particular skew for any given week. Right?
304 00:40:07.398 ⇒ 00:40:09.890 felipefaria: Whether it’s committed or uncommitted.
305 00:40:10.777 ⇒ 00:40:18.109 felipefaria: Then we need to be able to dig into the uncommitted, and understand why those orders are uncommitted.
306 00:40:18.110 ⇒ 00:40:22.070 Demilade Agboola: Alright. So so to be clear. And this would help me a lot right now
307 00:40:22.190 ⇒ 00:40:25.960 Demilade Agboola: you want to see. Do you want to see when it
308 00:40:26.460 ⇒ 00:40:31.120 Demilade Agboola: it was an uncommitted order to another order.
309 00:40:32.120 ⇒ 00:40:38.039 Demilade Agboola: Because right now, that’s what it’s showing. It’s showing that firecracker was not committed
310 00:40:38.170 ⇒ 00:40:44.459 Demilade Agboola: was an uncommitted order used to fulfill the classic farm sob. Do you want to see the other way around.
311 00:40:47.000 ⇒ 00:40:51.444 felipefaria: No, in that example of the classic one.
312 00:40:54.030 ⇒ 00:40:57.740 Demilade Agboola: There are like there was an order for something else.
313 00:40:58.030 ⇒ 00:41:03.479 Demilade Agboola: but right now it wasn’t met, but it was met using firecracker instead.
314 00:41:04.850 ⇒ 00:41:05.640 Demilade Agboola: But
315 00:41:07.040 ⇒ 00:41:12.020 Demilade Agboola: Do you want to see the areas in which firecracker was needed?
316 00:41:12.300 ⇒ 00:41:17.870 Demilade Agboola: The UN committed to represent where firecracker was needed? But something else was used to fulfill the firecracker order.
317 00:41:18.420 ⇒ 00:41:23.410 felipefaria: Yeah. I mean
318 00:41:23.750 ⇒ 00:41:30.490 felipefaria: it would. It would be good to have that information like, because in this ties to kinda
319 00:41:30.710 ⇒ 00:41:40.149 felipefaria: knowing which orders were forced upgrades. Which is something that in the in that I talked to Emily about right like. In this case
320 00:41:41.770 ⇒ 00:41:44.810 felipefaria: the firecracker seems to have been
321 00:41:45.850 ⇒ 00:41:53.659 felipefaria: a forced upgrade from the classic subscription. Right? So if you build a table of like forced upgrades by week.
322 00:41:53.910 ⇒ 00:41:57.989 felipefaria: then the firecracker would would show there.
323 00:41:59.520 ⇒ 00:42:02.729 felipefaria: Then I guess we can. We? We can see, like
324 00:42:03.970 ⇒ 00:42:20.490 felipefaria: the forced upgrades to and the forced upgrades from right. So we know, like which skews we had an issue with that caused it to be removed from the order, and which skew actually was used for the forced upgrade.
325 00:42:20.630 ⇒ 00:42:23.000 felipefaria: So it’d be good to have that information. But
326 00:42:26.600 ⇒ 00:42:29.012 felipefaria: honestly, I think that this is kind of like
327 00:42:29.840 ⇒ 00:42:36.980 felipefaria: like a step above kind of like just making sure that like, I think that is more important now to just
328 00:42:37.270 ⇒ 00:42:46.810 felipefaria: make sure that we have that number of total quantity shipped, correct showing committed.
329 00:42:46.950 ⇒ 00:42:55.630 felipefaria: plus any orders that are that are uncommitted, but that still shipped right like, and and so that number correct.
330 00:42:56.000 ⇒ 00:42:56.410 Demilade Agboola: Okay.
331 00:42:59.530 ⇒ 00:43:08.680 felipefaria: And and and then I think we can move forward, and from and from there essentially.
332 00:43:09.380 ⇒ 00:43:17.799 Demilade Agboola: Okay, alright. Sounds good. I I do have like a game plan on what to do for today, and just kind of fix certain things before tomorrow’s call.
333 00:43:19.390 ⇒ 00:43:20.245 felipefaria: Okay.
334 00:43:21.100 ⇒ 00:43:26.629 Demilade Agboola: Added that like uncommitted part, so that allowed us to debug and figure out things like what’s going on better.
335 00:43:27.020 ⇒ 00:43:28.700 felipefaria: Yeah, yeah.
336 00:43:28.940 ⇒ 00:43:31.750 Demilade Agboola: Oh, and and the other piece right? Because, like.
337 00:43:32.610 ⇒ 00:43:35.550 felipefaria: We need to solve for, like, why our orders
338 00:43:35.680 ⇒ 00:43:40.820 felipefaria: uncommitted? Why do we have orders uncommitted in the system that are being shipped.
339 00:43:41.030 ⇒ 00:43:55.619 felipefaria: and anything that is farm direct is understandable. So as long as we can filter the data and say, like no one committed except for orders out of Agrogana, which is the form, direct facility that we have like
340 00:43:55.800 ⇒ 00:44:04.280 felipefaria: you would, I think that the second most important step, after like knowing all the like total quantity shipped is just knowing
341 00:44:04.430 ⇒ 00:44:08.890 felipefaria: which orders or uncommitted in the system.
342 00:44:09.050 ⇒ 00:44:15.960 felipefaria: because that ties to what what Emily was talking about in terms of the shrinkage numbers
343 00:44:16.360 ⇒ 00:44:19.690 felipefaria: potentially accounting for some product that actually shipped.
344 00:44:19.990 ⇒ 00:44:28.689 felipefaria: And what I would want to do eventually is like on a weekly basis. See? Say, okay, from last week, this is the list of orders that are uncommitted in the system.
345 00:44:28.920 ⇒ 00:44:29.640 Demilade Agboola: Okay.
346 00:44:29.640 ⇒ 00:44:31.480 felipefaria: But actually shipped. So
347 00:44:31.520 ⇒ 00:44:48.329 felipefaria: scm, I would just communicate with scm, and they would have to make adjustments in the system and say, Okay, so we actually need to assign this order to a lot right? Because right now it’s not assigned to a lot it actually shipped. So let’s assign it to a lot.
348 00:44:48.330 ⇒ 00:45:07.769 felipefaria: If the lot is completely full, and it’s full because of an Ia that somebody made that is right now counted as shrinkage, we should reduce that adjustment of shrinkage. So we can add that order to the lot. Essentially so, everything kind of like, you know, like, it’s kind of like a reconciling exercise that happens.
349 00:45:07.880 ⇒ 00:45:16.509 felipefaria: But then ultimately we will want to get to the root cause of why that order is showing us and committed. So we have last instances of that
350 00:45:16.770 ⇒ 00:45:18.030 felipefaria: in the future.
351 00:45:18.440 ⇒ 00:45:19.030 Demilade Agboola: Okay.
352 00:45:19.890 ⇒ 00:45:23.980 felipefaria: Alright, but we can touch base tomorrow. I actually have to hop for
353 00:45:24.140 ⇒ 00:45:29.400 felipefaria: to prep for another meeting that I have at 1030. But I’ll talk to you tomorrow. Then.
354 00:45:29.580 ⇒ 00:45:30.879 Demilade Agboola: Alright! Thank you. Bye.
355 00:45:30.880 ⇒ 00:45:32.240 felipefaria: Alright! Have a good one. Bye, bye.