Meeting Title: Inventory Data QA and Planning Date: 2025-07-14 Meeting participants: Demilade Agboola, Emily Giant, felipefaria
WEBVTT
1 00:02:57.680 ⇒ 00:03:02.460 Emily Giant: Gee! Many Christmas. Sorry about that. I don’t know what the deal is with my computer.
2 00:03:03.770 ⇒ 00:03:06.429 Demilade Agboola: Alvin seems to be fun of these working sessions.
3 00:03:07.050 ⇒ 00:03:09.115 Emily Giant: Yeah, it’s like, I’m not ready.
4 00:03:10.120 ⇒ 00:03:11.500 Emily Giant: I can’t do this.
5 00:03:12.110 ⇒ 00:03:21.280 Emily Giant: It it’s not just that. It like loses Internet like my fellow, the thing in the corner that usually tells me how much time I have left on the meeting it just
6 00:03:21.820 ⇒ 00:03:25.220 Emily Giant: like every time I click on it I get the wheel of death.
7 00:03:25.450 ⇒ 00:03:31.290 Emily Giant: and that’s usually how I log into the meetings. Anyhow, I’m here. How how was your weekend.
8 00:03:32.580 ⇒ 00:03:37.539 Demilade Agboola: It was pretty good. I had tennis classes, cartoon classes.
9 00:03:38.060 ⇒ 00:03:40.619 Demilade Agboola: and then I went for a tennis seat around as well.
10 00:03:40.870 ⇒ 00:03:44.289 Demilade Agboola: But I have coaching classes again yesterday. So it was.
11 00:03:44.420 ⇒ 00:03:45.590 Demilade Agboola: It was decent.
12 00:03:46.470 ⇒ 00:03:52.370 Emily Giant: What were the classes tennis classes? Cartoons like, go right? Yeah.
13 00:03:53.080 ⇒ 00:03:54.359 Emily Giant: How are they going.
14 00:03:54.970 ⇒ 00:04:01.810 Demilade Agboola: That’s pretty. Okay. Still need to work on my footwork. It’s not. It’s not the best, but it’s getting much better.
15 00:04:03.140 ⇒ 00:04:13.100 Emily Giant: Hey? If if you’re like working on footwork, you’re already 10 steps ahead of where I ever was when I was just hitting with my hand like a volleyball. Sounds pretty good.
16 00:04:14.241 ⇒ 00:04:19.579 Demilade Agboola: Yeah, I mean, I I played with some people on Saturday as well.
17 00:04:19.860 ⇒ 00:04:22.889 Demilade Agboola: and I was like, Well, I can see why
18 00:04:23.530 ⇒ 00:04:34.193 Demilade Agboola: I shouldn’t be too hard on myself, like sometimes people don’t even move for the ball. That’s the one that I was. Actually, I was actually quite confused about like the ball is right there. Why are you standing? Move.
19 00:04:34.460 ⇒ 00:04:49.299 Emily Giant: It’s just like some people like that was volleyball, too. I I played on a team in college. It was just like a Rec. Team, but I would get so mad at people because they it was like this cartoon Daria in the United States, like
20 00:04:49.410 ⇒ 00:05:15.020 Emily Giant: at the beginning of the show, like the the opening credits. She’d be playing volleyball in gym class, and just like hold an arm out while it went past her, and I swear that some people and athletics. They’re just like minimum effort. That’s just I will break my leg trying to get to a tennis ball or a volleyball. It doesn’t matter what age doesn’t matter. Like. If I’m playing on a beach for fun, I will hurt myself to get
21 00:05:15.380 ⇒ 00:05:20.990 Emily Giant: the ball over the net. But some people don’t have that inside them so.
22 00:05:22.360 ⇒ 00:05:22.960 Emily Giant: And I think.
23 00:05:22.960 ⇒ 00:05:23.460 Demilade Agboola: Fair enough.
24 00:05:23.460 ⇒ 00:05:26.479 Emily Giant: Playing soccer like you’re just used to.
25 00:05:26.780 ⇒ 00:05:40.950 Emily Giant: you know, trying but I you’re inspiring me. I want to learn to play tennis. It just seems like fun. But we’re thinking about putting a. We have a really big driveway since we live in the country.
26 00:05:41.300 ⇒ 00:05:42.010 Demilade Agboola: Oh, that’s.
27 00:05:42.010 ⇒ 00:05:45.000 Emily Giant: Place to put in a pickleball court. If you just do like.
28 00:05:45.000 ⇒ 00:05:45.670 Demilade Agboola: Yes.
29 00:05:45.670 ⇒ 00:05:46.960 Emily Giant: Yeah, blacktop.
30 00:05:47.250 ⇒ 00:05:53.086 Emily Giant: So we’re trying to find someone who has like extra blacktop because we’re cheap and don’t want to pay for all of that.
31 00:05:53.340 ⇒ 00:05:54.010 Demilade Agboola: Anyway.
32 00:05:54.430 ⇒ 00:06:00.660 Emily Giant: But then we can like play some pickleball, move our butts, not just doing manual labor.
33 00:06:01.670 ⇒ 00:06:03.300 Demilade Agboola: Sounds like a good idea.
34 00:06:03.440 ⇒ 00:06:04.110 Emily Giant: No.
35 00:06:04.250 ⇒ 00:06:19.780 Emily Giant: Did you check out the Pr. I sent through on Friday? I still couldn’t get the final model. I deleted it and made a new one, and it ran, and then, after running it once, it had the same issues as before, where it just would like
36 00:06:20.280 ⇒ 00:06:23.280 Emily Giant: spin and spin and never complete the build.
37 00:06:24.070 ⇒ 00:06:27.080 Demilade Agboola: Do you have it set to incremental runs.
38 00:06:29.010 ⇒ 00:06:30.260 Emily Giant: Set to what?
39 00:06:32.750 ⇒ 00:06:34.120 Demilade Agboola: Incremental runs.
40 00:06:35.370 ⇒ 00:06:42.050 Emily Giant: I think so. Let me pull it up. I haven’t looked at it since since Friday night.
41 00:06:48.780 ⇒ 00:06:55.749 Emily Giant: I feel like I I didn’t because I was, gonna have you? When you looked at the Pr you were, gonna add in.
42 00:06:55.750 ⇒ 00:06:56.100 Demilade Agboola: So.
43 00:06:56.100 ⇒ 00:06:56.600 Emily Giant: Correct.
44 00:06:56.600 ⇒ 00:07:03.209 Demilade Agboola: Yeah, no, I’m asking, because, like, if you run initially should run subsequently, if it was just because it’s basically the same run.
45 00:07:03.590 ⇒ 00:07:08.699 Emily Giant: Yeah, you’re not supposed to be in here, Kitty.
46 00:07:08.900 ⇒ 00:07:11.440 Emily Giant: The the barn cat is in the house again.
47 00:07:13.200 ⇒ 00:07:15.180 Emily Giant: No, it’s not incremental.
48 00:07:15.620 ⇒ 00:07:16.360 Demilade Agboola: Okay.
49 00:07:18.210 ⇒ 00:07:22.110 Emily Giant: Here share screen.
50 00:07:30.740 ⇒ 00:07:35.189 Emily Giant: Yeah. So if I put these in order.
51 00:07:37.190 ⇒ 00:07:39.189 Emily Giant: these are the new hard, good ones.
52 00:07:39.390 ⇒ 00:07:42.549 Emily Giant: and these seem to be running fine
53 00:07:43.000 ⇒ 00:07:52.278 Emily Giant: and I just commented out the incremental strategy, for now, until you’re able to look at it like what I wasn’t sure about was obviously the from
54 00:07:53.840 ⇒ 00:07:56.119 Emily Giant: because this combines like.
55 00:07:57.120 ⇒ 00:07:59.940 Emily Giant: Now you want to compare it to
56 00:08:00.210 ⇒ 00:08:04.800 Emily Giant: like an upstream model correct like in this? 9,
57 00:08:06.000 ⇒ 00:08:07.949 Emily Giant: you want to be like the most.
58 00:08:08.810 ⇒ 00:08:14.329 Emily Giant: It’s not the model that you’ve built. That’s the this in the ginger.
59 00:08:14.600 ⇒ 00:08:19.430 Emily Giant: But this would be transaction line or transaction, like a field from that right.
60 00:08:20.110 ⇒ 00:08:27.310 Demilade Agboola: Idb. Yes, or but I would. Some people use the incremental. Sometimes they use it as a
61 00:08:29.130 ⇒ 00:08:31.396 Demilade Agboola: how do I? How do I explain it?
62 00:08:33.990 ⇒ 00:08:47.430 Demilade Agboola: well, yes, let’s just let’s just work with that aspect that way. First, st so far. Yeah. So you you you can use an upstream model and use it to filter against an upstream model. You only ensure that you’re getting the latest values so that the
63 00:08:47.630 ⇒ 00:08:53.190 Demilade Agboola: like, whatever you’re doing, the will be like, not as
64 00:08:53.430 ⇒ 00:08:56.310 Demilade Agboola: resource, heavy, because instead of trying to do
65 00:08:56.570 ⇒ 00:09:01.999 Demilade Agboola: something for like 2 million rows, you’d maybe doing for 20,000 rows, you know, so that will make it easier.
66 00:09:03.010 ⇒ 00:09:08.669 Emily Giant: So is there a world that when whatever you’re about to describe, where you’re comparing it.
67 00:09:08.890 ⇒ 00:09:14.470 Emily Giant: comparing it to itself, you’re like, select everything from this model and compare it
68 00:09:14.770 ⇒ 00:09:22.950 Emily Giant: to this model, or does that just not make sense like, I know this is pulling everything in the model that I’m in
69 00:09:23.590 ⇒ 00:09:28.330 Emily Giant: right like this. But this part like, does it matter?
70 00:09:29.540 ⇒ 00:09:39.389 Emily Giant: The thing is, there are like 2 incremental upstream models, 3 that are used in this, these 2 primary.
71 00:09:40.020 ⇒ 00:09:44.538 Emily Giant: I I suppose I’d use transaction line. But is there
72 00:09:45.200 ⇒ 00:09:47.659 Emily Giant: any kind of risk with not taking
73 00:09:48.980 ⇒ 00:09:52.679 Emily Giant: the other incremental model that’s upstream into consideration?
74 00:09:54.400 ⇒ 00:10:18.750 Demilade Agboola: So what I would advise, and what I would end up doing here is, if I was going to do this, I would actually make each of these models that are heavy like transaction and transaction line, which are very heavy models, because a lot of transactions that happen every day to only restrict it to the last, maybe 7 days or so of data, because we don’t want we don’t want it to run every single day
75 00:10:19.300 ⇒ 00:10:23.699 Demilade Agboola: calculating everything from all of time up until that point every single day.
76 00:10:25.100 ⇒ 00:10:31.469 Emily Giant: That makes sense. So I would do actually an incremental for both of them. At the top of this.
77 00:10:32.200 ⇒ 00:10:35.499 Demilade Agboola: Yes, you could also. You could also add it directly into the.
78 00:10:35.700 ⇒ 00:10:36.989 Emily Giant: Into the where.
79 00:10:37.580 ⇒ 00:10:37.975 Demilade Agboola: Yeah.
80 00:10:39.010 ⇒ 00:10:39.430 Emily Giant: Okay.
81 00:10:39.430 ⇒ 00:10:42.689 Demilade Agboola: You do. You do have to be careful with that, because you
82 00:10:43.210 ⇒ 00:10:44.510 Demilade Agboola: and if you go back up
83 00:10:45.260 ⇒ 00:10:50.080 Demilade Agboola: to the very top the first, st so you can see that the where clause is inserted in there,
84 00:10:51.720 ⇒ 00:10:55.440 Demilade Agboola: what i’ll be doing now or what i’ll be looking to do is
85 00:10:55.960 ⇒ 00:11:00.660 Demilade Agboola: since you already have, like your number 9, like your line line done like.
86 00:11:00.970 ⇒ 00:11:08.129 Demilade Agboola: Select all from blah blah line. 10 down below will be where blah blah blah blah is
87 00:11:08.860 ⇒ 00:11:20.939 Demilade Agboola: like if I if I’m using the if I’m using logic that already exists as an incremental thing, then incremental block will come in, and instead of putting, where line is this? I’ll do, and.
88 00:11:21.550 ⇒ 00:11:22.970 Emily Giant: Do it with the and okay, that makes sense.
89 00:11:22.970 ⇒ 00:11:28.159 Demilade Agboola: Because when it’s so, that way on incremental run, it would join perfectly
90 00:11:28.270 ⇒ 00:11:33.090 Demilade Agboola: to do where clause and the conditional already stated as an additional clause.
91 00:11:33.950 ⇒ 00:11:39.300 Emily Giant: That makes sense. So just to like, say back what you said to me, to make sure I get it.
92 00:11:39.710 ⇒ 00:11:46.139 Emily Giant: instead of having this where like, if I had other conditions, it would be like where blah blah
93 00:11:46.390 ⇒ 00:11:48.176 Emily Giant: is null.
94 00:11:49.070 ⇒ 00:11:49.690 Demilade Agboola: Yeah.
95 00:11:49.690 ⇒ 00:11:54.440 Emily Giant: The, and so that, like for the incremental, the, it was wrapped
96 00:11:54.690 ⇒ 00:12:00.050 Emily Giant: in the incremental strategy. But just as the and because otherwise, if you did the where it would.
97 00:12:00.050 ⇒ 00:12:01.499 Demilade Agboola: So where’s a break?
98 00:12:01.800 ⇒ 00:12:06.670 Emily Giant: Yeah, it would break. Okay, that makes perfect sense to me. So
99 00:12:06.980 ⇒ 00:12:14.300 Emily Giant: this is gonna be staging transaction line. I’m just gonna add a note, add incremental
100 00:12:14.660 ⇒ 00:12:19.690 Emily Giant: to transaction and trans action line.
101 00:12:22.870 ⇒ 00:12:25.889 Demilade Agboola: Maybe even adjustments. But don’t do volume of adjustments.
102 00:12:26.180 ⇒ 00:12:32.550 Demilade Agboola: The only because the only time it really makes sense is, if you’re doing like tables, where
103 00:12:32.940 ⇒ 00:12:39.099 Demilade Agboola: number one has a large volume, and number 2 like it continuously. Things keep coming every day, so.
104 00:12:39.360 ⇒ 00:12:40.679 Emily Giant: These are tiny.
105 00:12:41.700 ⇒ 00:12:43.890 Demilade Agboola: There. It looks kind of static.
106 00:12:43.990 ⇒ 00:12:49.919 Emily Giant: So there’s no no adjustment. Oh, wait! There’s this one, too.
107 00:12:50.030 ⇒ 00:12:51.820 Emily Giant: Not a large table, though.
108 00:12:52.880 ⇒ 00:12:54.039 Demilade Agboola: And that’s your fault.
109 00:12:54.040 ⇒ 00:12:59.700 Emily Giant: Individual sub orders. So I think just transaction and transaction line are probably sufficient.
110 00:13:00.540 ⇒ 00:13:01.920 Demilade Agboola: Okay, that’s fine.
111 00:13:02.380 ⇒ 00:13:03.590 Emily Giant: This one
112 00:13:06.390 ⇒ 00:13:08.430 Demilade Agboola: And also we have.
113 00:13:09.610 ⇒ 00:13:15.899 Demilade Agboola: And in we we wanted the marker for canceled orders in inventory reconciliation. Right.
114 00:13:17.642 ⇒ 00:13:19.580 Emily Giant: Is that where I added it?
115 00:13:20.230 ⇒ 00:13:25.310 Emily Giant: I know you were adding it to the ones that are already live. I feel like I added it in
116 00:13:25.420 ⇒ 00:13:28.879 Emily Giant: ag adjustments, but I can definitely add it in.
117 00:13:34.070 ⇒ 00:13:34.980 Emily Giant: oops.
118 00:13:38.230 ⇒ 00:13:39.410 Emily Giant: Wait a minute.
119 00:13:47.610 ⇒ 00:13:49.584 Demilade Agboola: I may have just not.
120 00:13:49.980 ⇒ 00:13:52.400 Demilade Agboola: No, that’s fine. I’ll I’ll so this.
121 00:13:52.790 ⇒ 00:14:02.820 Demilade Agboola: So there it is. I’ll add it to language. I found.
122 00:14:02.820 ⇒ 00:14:07.300 Emily Giant: Yeah, it would make sense to add it here. Add, is canceled.
123 00:14:29.770 ⇒ 00:14:35.220 Emily Giant: Yeah, I think I wound up like I had it in at 1 point and then stripped this way down
124 00:14:37.360 ⇒ 00:14:39.280 Emily Giant: because it was just getting
125 00:14:39.660 ⇒ 00:14:44.979 Emily Giant: too big for what it was supposed to be, and wound up, adding instead
126 00:14:46.620 ⇒ 00:14:48.349 Emily Giant: to the mart model, and I
127 00:14:48.710 ⇒ 00:14:53.600 Emily Giant: kind of screwed the pooch with not adding it back at
128 00:14:53.750 ⇒ 00:14:56.270 Emily Giant: once. I had stripped it down and built it back up.
129 00:14:57.610 ⇒ 00:14:58.955 Emily Giant: Let’s see if this runs today.
130 00:15:01.380 ⇒ 00:15:07.470 Emily Giant: It is so odd to me that it doesn’t run because there’s hardly anything happening here.
131 00:15:07.830 ⇒ 00:15:17.369 Emily Giant: It’s just adding the like. The item, information and location information to the table and the upstream models
132 00:15:17.730 ⇒ 00:15:20.390 Emily Giant: take 10 seconds to run.
133 00:15:24.500 ⇒ 00:15:25.429 Demilade Agboola: Oh, okay.
134 00:15:25.930 ⇒ 00:15:27.863 Emily Giant: It was just so odd.
135 00:15:33.740 ⇒ 00:15:49.309 Emily Giant: So I guess at the end of the day I wasn’t able to do a lot of Qa. On the new model because I couldn’t get it to run. But I was able to do Qa on these 2 the upstream models, where I mean, there’s no logic that happens in the Mart model.
136 00:15:50.040 ⇒ 00:15:55.650 Emily Giant: unless the join is just so wrong that it’s making it go in circles. But I don’t think that’s the case.
137 00:15:56.840 ⇒ 00:16:10.749 Emily Giant: I did change some names. So when you look at the Pr I wanted to review it with you because it’s gonna look bigger than it actually is, there’s really only like 3 models that were touched. But in the Pr there’s gonna look.
138 00:16:10.900 ⇒ 00:16:19.909 Emily Giant: it’s gonna look like a lot. But it was just a name change to start like aligning it to the conventions we were using, or that you were using with the new Oms models.
139 00:16:20.770 ⇒ 00:16:21.349 Emily Giant: Andrew.
140 00:16:22.510 ⇒ 00:16:33.819 Emily Giant: So I was like. Okay, I know I’m not supposed to do this, but the deed is done, and if I review it with demalade, then I can talk him through that like nothing changed on this outside of the name.
141 00:16:37.890 ⇒ 00:16:38.810 Emily Giant: Let’s see.
142 00:16:42.670 ⇒ 00:16:43.316 Emily Giant: All right.
143 00:16:45.290 ⇒ 00:16:50.810 Emily Giant: Some checks were not successful. Let’s see about that. Maybe it will tell us why, that model doesn’t run
144 00:16:56.200 ⇒ 00:16:58.060 Emily Giant: 7 errors.
145 00:17:05.270 ⇒ 00:17:09.460 Emily Giant: Oh, this is in inventory adjustments that
146 00:17:24.109 ⇒ 00:17:29.139 Emily Giant: huh? Okay? So the errors that I got when it was running the the Pr. Check
147 00:17:29.440 ⇒ 00:17:33.520 Emily Giant: is not null. Inventory adjustments, time.
148 00:17:36.250 ⇒ 00:17:37.200 Demilade Agboola: I’m going to do it.
149 00:17:37.200 ⇒ 00:17:40.589 Emily Giant: It’s in the adjustments, not the models that.
150 00:17:40.860 ⇒ 00:17:44.020 Demilade Agboola: Yeah, I do know there was a test on that thing.
151 00:17:44.880 ⇒ 00:17:49.080 Demilade Agboola: There’s also no operating, no adjustments to liver Id.
152 00:17:49.380 ⇒ 00:17:52.560 Demilade Agboola: And there are a lot of times. That is there any reason why there there will be?
153 00:17:52.950 ⇒ 00:17:55.759 Demilade Agboola: I just went through? No, I just went through ids.
154 00:17:56.665 ⇒ 00:17:59.220 Emily Giant: No, that’s like a deprecated model.
155 00:17:59.693 ⇒ 00:18:09.989 Emily Giant: Or that portion of it. We don’t even use anymore. That was when we used inventory deliveries instead of the model called inventory deliveries, instead of the polytomic models
156 00:18:10.240 ⇒ 00:18:13.840 Emily Giant: to to do inventory adjustments.
157 00:18:14.450 ⇒ 00:18:20.250 Emily Giant: But I’m wondering why, because we haven’t been getting these errors and these rerun several times a day.
158 00:18:21.135 ⇒ 00:18:24.000 Emily Giant: I I don’t understand, really, why
159 00:18:24.780 ⇒ 00:18:32.200 Emily Giant: those would be popping up, because those are only like relevant for pre-migration adjustments.
160 00:18:38.850 ⇒ 00:18:40.220 Demilade Agboola: And.
161 00:18:41.060 ⇒ 00:18:47.240 Emily Giant: Same with like this. This is pre-migration, and it failed on a lot of them.
162 00:18:47.610 ⇒ 00:18:48.770 Demilade Agboola: Yeah. So
163 00:18:49.170 ⇒ 00:18:53.899 Demilade Agboola: I think what we need to do is we need to look 1st to look into that table just generally
164 00:18:54.835 ⇒ 00:18:57.330 Demilade Agboola: figure out what’s going on there.
165 00:18:59.150 ⇒ 00:19:02.459 Demilade Agboola: We used to do, ready for anything, though, in this Pr.
166 00:19:02.730 ⇒ 00:19:08.870 Emily Giant: No, Nope, not we don’t use it for anything.
167 00:19:09.030 ⇒ 00:19:11.320 Emily Giant: Period like since.
168 00:19:14.090 ⇒ 00:19:15.970 Demilade Agboola: So when is the test on it? Though.
169 00:19:16.600 ⇒ 00:19:23.219 Emily Giant: Because of the historical stuff. But we don’t use it for anything current like active.
170 00:19:23.942 ⇒ 00:19:24.730 Demilade Agboola: I’m saying is.
171 00:19:24.730 ⇒ 00:19:25.570 Emily Giant: Sympathetic.
172 00:19:25.930 ⇒ 00:19:30.389 Demilade Agboola: See what I’m saying is, we should not be in a situation where, like this data.
173 00:19:30.530 ⇒ 00:19:32.750 Demilade Agboola: like unimportant data, failure.
174 00:19:33.170 ⇒ 00:19:35.090 Emily Giant: Causes things to fail.
175 00:19:35.980 ⇒ 00:19:40.630 Demilade Agboola: Like. If we should see a test we should be able to go. This is troublesome or this is worrisome.
176 00:19:40.820 ⇒ 00:19:42.659 Demilade Agboola: That’s what makes it test defective.
177 00:19:44.040 ⇒ 00:19:45.480 Demilade Agboola: So, if it’s.
178 00:19:47.530 ⇒ 00:19:47.890 Emily Giant: Look. I.
179 00:19:47.890 ⇒ 00:19:48.369 Demilade Agboola: I don’t know.
180 00:19:48.370 ⇒ 00:19:56.099 Emily Giant: But like this test wasn’t failing on Friday. So even though it is historical data like.
181 00:19:57.080 ⇒ 00:20:02.249 Emily Giant: I don’t understand why a million rows suddenly
182 00:20:02.710 ⇒ 00:20:13.590 Emily Giant: or 126,000. That’s very different than a million. Started failing like. I think once we clear that up, we’ll be able to get rid of the test, but it is weird that, like
183 00:20:14.030 ⇒ 00:20:17.350 Emily Giant: none of these were failing before.
184 00:20:21.240 ⇒ 00:20:22.710 Demilade Agboola: Anyways, let’s see.
185 00:20:23.580 ⇒ 00:20:24.270 Emily Giant: Yeah.
186 00:20:26.490 ⇒ 00:20:36.002 Emily Giant: Also, this one is never going to go away, and I don’t know what we should do about it. It’s been the same 4 for the combination of columns in the
187 00:20:36.500 ⇒ 00:20:38.720 Emily Giant: the lot table.
188 00:20:39.810 ⇒ 00:20:52.350 Emily Giant: It’s been 4 that have failed for the last 2 months. Are we able to like, remove those 4 from being considered in the test because they’re just like input errors from users that
189 00:20:52.730 ⇒ 00:20:56.449 Emily Giant: we can’t really do anything about it.
190 00:20:58.110 ⇒ 00:21:00.220 Demilade Agboola: So there would always be failures. Basically.
191 00:21:00.950 ⇒ 00:21:03.849 Emily Giant: Just on those 4. If it’s ever more than 4,
192 00:21:03.950 ⇒ 00:21:09.930 Emily Giant: then we should know. But it has been, for since mother’s day, the same 4 that have failed.
193 00:21:10.430 ⇒ 00:21:13.779 Demilade Agboola: Okay, so you just you can. Yeah, you can exclude that from test.
194 00:21:14.160 ⇒ 00:21:14.810 Emily Giant: Okay.
195 00:21:15.380 ⇒ 00:21:21.189 Demilade Agboola: So we can have a test working session where we just like clean up the tests that we have.
196 00:21:21.820 ⇒ 00:21:23.010 Emily Giant: That’s a good call.
197 00:21:23.500 ⇒ 00:21:31.245 Emily Giant: Alright. So, anyway. None of the models that failed are
198 00:21:32.630 ⇒ 00:21:35.400 Emily Giant: the ones that were touched during this.
199 00:21:37.290 ⇒ 00:21:39.659 Emily Giant: So where is it?
200 00:21:47.470 ⇒ 00:21:49.620 Emily Giant: Just want to see the actual
201 00:21:51.980 ⇒ 00:21:54.429 Emily Giant: differential? Oh, here we go. Files changed.
202 00:21:55.410 ⇒ 00:22:07.400 Emily Giant: So it says 25, but really only 3 changed. What I did was because I was getting
203 00:22:09.980 ⇒ 00:22:15.040 Emily Giant: I thought it was confusing. This used to be called dimensions inventory adjustments.
204 00:22:15.620 ⇒ 00:22:20.950 Emily Giant: but because we now have, like a hard, good table and
205 00:22:21.520 ⇒ 00:22:34.269 Emily Giant: like a live product table, I changed it to and reconciliation tables, which are all inventory adjustments. I changed it to sub order adjustments, because that’s the only thing that’s really in that dimension table is
206 00:22:34.660 ⇒ 00:22:44.570 Emily Giant: the fields having to do with sub orders. So it’s like the redelivery subscription regular sale.
207 00:22:44.950 ⇒ 00:22:54.799 Emily Giant: And then that was in several downstream models. So I just had to change that reference. And that’s why it looks like so many things change. But you can see like
208 00:22:55.140 ⇒ 00:22:59.079 Emily Giant: down here, it’s like nothing actually changed. It was a folder name in one.
209 00:22:59.260 ⇒ 00:23:03.130 Emily Giant: and then in the rest, it’s just the reference.
210 00:23:08.120 ⇒ 00:23:11.750 Emily Giant: So anytime it was inventory adjustments. I just swapped out that name.
211 00:23:13.100 ⇒ 00:23:19.680 Demilade Agboola: Okay, is there a reason why you change it to the supporter cause? I know there’s inventory adjustments. Union.
212 00:23:19.800 ⇒ 00:23:22.720 Demilade Agboola: Does that no longer exist? Or did you just.
213 00:23:24.410 ⇒ 00:23:33.840 Emily Giant: I changed just the name of it. It was confusing, because reconciliations are a kind of suborder adjustment.
214 00:23:34.190 ⇒ 00:23:44.869 Emily Giant: And then there were that then the sale, or like orders that were delivered, are another kind of adjustment, and that model encapsulates
215 00:23:45.120 ⇒ 00:24:13.640 Emily Giant: orders that are delivered, whether that be a redelivery subscription or sale. All of them are sub order, adjustments, and all of the reconciliations are reconciliations, and I kept opening that one to find the reconciliations, and was like this is a bad name, because what this is is sub orders, that’s all that’s in that model. And so like going forward like for other people working on it.
216 00:24:13.910 ⇒ 00:24:17.260 Emily Giant: I feel like it’s way more accurate
217 00:24:17.670 ⇒ 00:24:22.900 Emily Giant: to call it like suborder adjustments. Then in your does that make sense.
218 00:24:22.900 ⇒ 00:24:26.979 Demilade Agboola: Fair enough, fair enough, because it’s the suborders, with lots and without lots.
219 00:24:28.180 ⇒ 00:24:34.690 Demilade Agboola: Yeah, that’s fine. Not that. And actually, that’s why I’m I’m adding the canceled orders right away.
220 00:24:34.990 ⇒ 00:24:38.607 Emily Giant: Yeah, that’s per perfect place to add it.
221 00:24:39.860 ⇒ 00:24:44.250 Emily Giant: yeah. And those other adjustments don’t have a cancellation.
222 00:24:44.740 ⇒ 00:24:49.109 Emily Giant: There’s no canceling them, because they’re not orders. They’re reconciliations.
223 00:24:49.320 ⇒ 00:24:59.251 Emily Giant: So that’s why I changed that. I was like, if before this is out there in the world, I just want to make this easier for everyone to find what they’re looking for. And then I changed
224 00:25:00.280 ⇒ 00:25:01.770 Emily Giant: the name of the folder.
225 00:25:02.110 ⇒ 00:25:05.630 Emily Giant: It was called, like I think it was called, like
226 00:25:06.920 ⇒ 00:25:11.079 Emily Giant: something else level. But it didn’t. It was like inventory adjustment level.
227 00:25:11.400 ⇒ 00:25:16.419 Emily Giant: But really these are all sub order, id level like that is the row.
228 00:25:18.320 ⇒ 00:25:23.730 Emily Giant: And then this one is the inventory number id level. Oh, no, I didn’t change this one. I think I changed this.
229 00:25:23.930 ⇒ 00:25:32.769 Emily Giant: It said some like lot balance or something like that. But really it’s these are all categorized by inventory number. These are all categorized by sub order. Id.
230 00:25:33.470 ⇒ 00:25:41.120 Emily Giant: And it made it so much easier to find what I was looking for, given those times.
231 00:25:41.440 ⇒ 00:25:47.529 Emily Giant: because otherwise I was just like clicking around trying to figure out if it was like the aggregate version or
232 00:25:48.260 ⇒ 00:25:51.400 Emily Giant: the suborder id version.
233 00:25:52.650 ⇒ 00:25:58.470 Demilade Agboola: Okay? I mean, I’m definitely for clever naming. I think one of the event like I said earlier, one of the advantages of
234 00:25:58.590 ⇒ 00:26:04.080 Demilade Agboola: like how we’ve named things and put things is that it’s much easier to find stuff which is
235 00:26:04.370 ⇒ 00:26:07.529 Demilade Agboola: very, very useful to to like.
236 00:26:07.880 ⇒ 00:26:09.849 Demilade Agboola: Have your infrastructure clear.
237 00:26:10.380 ⇒ 00:26:13.819 Emily Giant: Yeah, like, I don’t have any issues. I just was wondering why you renamed it.
238 00:26:14.510 ⇒ 00:26:16.030 Emily Giant: Oh, no, I I
239 00:26:16.250 ⇒ 00:26:23.330 Emily Giant: want to be asked, because I don’t want to do anything that makes things more confusing. I just want to make things less confusing
240 00:26:23.640 ⇒ 00:26:29.609 Emily Giant: and prior to committing it. I want I want to be asked.
241 00:26:30.450 ⇒ 00:26:36.740 Emily Giant: So let’s see, as far as this goes. Is it still running? Yeah.
242 00:26:39.310 ⇒ 00:26:41.229 Emily Giant: I don’t know. It’s so odd.
243 00:26:48.620 ⇒ 00:26:50.400 Demilade Agboola: Can you? Can you click into it?
244 00:26:52.220 ⇒ 00:26:54.620 Demilade Agboola: Let me see, gotcha.
245 00:27:25.270 ⇒ 00:27:25.860 Emily Giant: Odd
246 00:27:52.640 ⇒ 00:28:00.029 Emily Giant: this wouldn’t. No, because I use. I use this upstream also to check for uniqueness and reconciliation. So
247 00:28:00.610 ⇒ 00:28:06.810 Emily Giant: I didn’t know if, like Dbt utils is just on the Fritz.
248 00:28:08.230 ⇒ 00:28:13.509 Emily Giant: I I don’t know what to do, because I something is in here that’s causing this.
249 00:28:14.710 ⇒ 00:28:17.199 Emily Giant: It’s probably one of the joins.
250 00:28:25.748 ⇒ 00:28:27.821 Demilade Agboola: Realize agreement was off.
251 00:28:28.940 ⇒ 00:28:37.060 Demilade Agboola: Can you try running the regular master inventory and see if that that also takes as long cause? If it’s modeled the same way should be.
252 00:28:40.490 ⇒ 00:28:41.240 Emily Giant: Yes.
253 00:29:15.130 ⇒ 00:29:18.899 Emily Giant: no, it’s nearly done.
254 00:29:22.150 ⇒ 00:29:33.119 Demilade Agboola: Okay, so and let’s see, cause I’m still trying to.
255 00:29:33.220 ⇒ 00:29:34.570 Demilade Agboola: And second.
256 00:29:38.330 ⇒ 00:29:39.729 Emily Giant: Oh, sorry! What was that?
257 00:29:40.920 ⇒ 00:29:46.369 Demilade Agboola: I’m trying to figure out. Okay, so can you put them side by side? Is there a possible way you could do.
258 00:29:46.370 ⇒ 00:29:46.980 Emily Giant: Yeah.
259 00:30:16.910 ⇒ 00:30:20.420 Demilade Agboola: I’m trying to look at, especially the joins.
260 00:30:22.700 ⇒ 00:30:24.150 Demilade Agboola: Let’s see.
261 00:30:27.330 ⇒ 00:30:32.629 Demilade Agboola: And it’s cause. Are we doing dealing with the larger table as well? That’s also another possibility.
262 00:30:34.720 ⇒ 00:30:35.500 Demilade Agboola: Tab.
263 00:30:52.720 ⇒ 00:30:56.830 Emily Giant: All right. Well, these are all joined, and these are left joined. But that shouldn’t matter, because
264 00:30:57.100 ⇒ 00:31:05.040 Emily Giant: every adjustment should absolutely have an item Id and a location.
265 00:31:06.030 ⇒ 00:31:09.050 Emily Giant: So that seems like the correct strategy. There.
266 00:31:10.010 ⇒ 00:31:12.309 Demilade Agboola: Yeah, possibly should reduce the count.
267 00:31:12.650 ⇒ 00:31:13.330 Emily Giant: Hmm.
268 00:31:13.810 ⇒ 00:31:18.429 Demilade Agboola: But plus it should reduce the contact for making it, even if it was the wrong strategy
269 00:31:18.630 ⇒ 00:31:21.439 Demilade Agboola: that would make it go longer.
270 00:31:21.850 ⇒ 00:31:22.656 Emily Giant: Yeah, true.
271 00:31:51.750 ⇒ 00:31:55.110 Emily Giant: mom, I’ll say, one thing that annoys me is that
272 00:31:55.520 ⇒ 00:32:01.906 Emily Giant: sometimes it says, ask, sometimes it doesn’t. And I don’t like that. I’m just gonna do that.
273 00:32:04.310 ⇒ 00:32:09.989 Demilade Agboola: Yeah. So I mean, big as present, because I think it’s just
274 00:32:11.150 ⇒ 00:32:15.210 Demilade Agboola: like, if I’m gonna use it. I just like the clarity it brings.
275 00:32:16.110 ⇒ 00:32:18.260 Emily Giant: It does bring clarity. It’s true.
276 00:32:18.700 ⇒ 00:32:22.979 Demilade Agboola: You know, like, obviously I’m not. I know how to read it without it, but.
277 00:32:24.840 ⇒ 00:32:26.460 Emily Giant: We can add it back.
278 00:32:27.300 ⇒ 00:32:29.029 Demilade Agboola: Oh, no, no, it’s fine! You can remove it.
279 00:32:31.140 ⇒ 00:32:33.950 Emily Giant: I. This seems like it should take
280 00:32:34.720 ⇒ 00:32:39.520 Emily Giant: just so much longer than than this. This is very simple.
281 00:32:40.650 ⇒ 00:32:43.259 Demilade Agboola: Alright can you compile it and run it
282 00:32:44.050 ⇒ 00:32:48.099 Demilade Agboola: like, but not on the have you released it, though.
283 00:33:05.580 ⇒ 00:33:07.460 Emily Giant: Get out of this full screen business.
284 00:33:17.050 ⇒ 00:33:18.060 Emily Giant: Gosh.
285 00:33:21.730 ⇒ 00:33:24.230 Emily Giant: sorry my computer is like not there we go.
286 00:34:09.389 ⇒ 00:34:12.260 Emily Giant: No, it ran really fast.
287 00:34:15.600 ⇒ 00:34:22.179 Demilade Agboola: I don’t know. Seems like something is weird with Dvt. It might just be tweaking.
288 00:34:25.179 ⇒ 00:34:26.989 Emily Giant: I think it is.
289 00:34:28.107 ⇒ 00:34:34.620 Emily Giant: Is it just like the name of this? I know. That sounds so dumb. But like
290 00:34:35.429 ⇒ 00:34:38.870 Emily Giant: I don’t have any issues with any other model but that one.
291 00:34:39.870 ⇒ 00:34:41.149 Demilade Agboola: Think. Let’s the top again.
292 00:34:43.469 ⇒ 00:34:45.650 Demilade Agboola: Thanks. Nice, nice
293 00:34:49.790 ⇒ 00:34:51.279 Demilade Agboola: appointment time.
294 00:34:51.900 ⇒ 00:34:53.389 Demilade Agboola: There’s 1 dates
295 00:34:57.350 ⇒ 00:34:59.590 Demilade Agboola: and branch tasks.
296 00:35:02.150 ⇒ 00:35:04.099 Demilade Agboola: So it’s going to add center.
297 00:35:06.750 ⇒ 00:35:11.729 Emily Giant: Like it looks fine. I can’t. I can’t see any reason why this should take a long time to run. Yeah.
298 00:35:11.730 ⇒ 00:35:20.369 Emily Giant: it’s so simple like. The fact that it compiles and runs makes me feel like it’s
299 00:35:21.180 ⇒ 00:35:22.790 Emily Giant: probably okay.
300 00:35:23.040 ⇒ 00:35:23.900 Demilade Agboola: And.
301 00:35:25.660 ⇒ 00:35:39.170 Emily Giant: So I think, just looking through the incremental strategy and making sure that that’s working in the int
302 00:35:39.530 ⇒ 00:35:42.149 Emily Giant: inventory reconciliation. Hard goods.
303 00:35:42.710 ⇒ 00:35:45.643 Emily Giant: It’s like the one thing it definitely needs
304 00:35:46.300 ⇒ 00:35:54.949 Emily Giant: before committing it. But I definitely want to like move on to the step of adding all this stuff to looker and helping build the dashboard. So
305 00:35:56.810 ⇒ 00:36:04.499 Demilade Agboola: Alright. I’ll look at the I’ll look at the Pr. I just I think that’s the only thing left.
306 00:36:04.860 ⇒ 00:36:09.580 Demilade Agboola: Yeah, I also want to push the council thing today, so I’ll send the Pr. Very soon.
307 00:36:09.890 ⇒ 00:36:10.670 Emily Giant: Nice.
308 00:36:10.970 ⇒ 00:36:14.370 Emily Giant: Yeah, honestly, like, you can just commit that
309 00:36:16.400 ⇒ 00:36:19.330 Emily Giant: if you want to deploy the Pr, I have full faith
310 00:36:19.630 ⇒ 00:36:23.499 Emily Giant: that adding, that is not gonna cause any issues.
311 00:36:24.540 ⇒ 00:36:34.949 Demilade Agboola: That’s fine. I mean, usually when I deploy stuff I try to keep an eye on like the runs for like the 1st hour or 2 after, which is kind of why they want us to deploy on Friday, because
312 00:36:35.830 ⇒ 00:36:38.300 Demilade Agboola: you don’t want to break things when no one is around.
313 00:36:38.680 ⇒ 00:36:40.280 Emily Giant: Yeah, that makes sense.
314 00:36:41.352 ⇒ 00:36:42.017 Emily Giant: How about.
315 00:36:42.350 ⇒ 00:36:44.249 Demilade Agboola: Have that issue on another project.
316 00:36:45.146 ⇒ 00:36:57.370 Emily Giant: I used to like when I started doing this. I used to do it on purpose on Friday, so that nobody would see if I messed something up really badly, but it meant I was still working which was
317 00:36:57.890 ⇒ 00:36:59.960 Emily Giant: became not fun.
318 00:36:59.960 ⇒ 00:37:00.810 Demilade Agboola: Yes.
319 00:37:01.444 ⇒ 00:37:01.910 Emily Giant: Yeah.
320 00:37:02.320 ⇒ 00:37:04.280 Emily Giant: Oh, Felipe.
321 00:37:06.930 ⇒ 00:37:08.409 felipefaria: Hey? Guys, good morning.
322 00:37:08.630 ⇒ 00:37:10.240 Emily Giant: Hi! How are you?
323 00:37:10.620 ⇒ 00:37:11.870 felipefaria: Good! How are you?
324 00:37:12.110 ⇒ 00:37:12.940 Emily Giant: Good, did you ever?
325 00:37:12.940 ⇒ 00:37:13.350 Emily Giant: Well.
326 00:37:14.520 ⇒ 00:37:29.079 felipefaria: Sorry for the for the delay. Here I was finishing up a different task. I didn’t see the the invite come through, but I’ll I’ll just make a cause. I don’t know why I’m not receiving the the invites in advance, but I’ll I’ll just make a
327 00:37:29.810 ⇒ 00:37:38.220 felipefaria: placeholder on my calendar just to have it there just in case. But I’ll need the link still to join the meeting. But at least that way I
328 00:37:38.430 ⇒ 00:37:39.190 felipefaria: I don’t.
329 00:37:39.190 ⇒ 00:37:47.620 Demilade Agboola: So so to be honest, that that’s actually the that’s on me, because I’m the one that has the meeting block. And I sent the invites out.
330 00:37:47.910 ⇒ 00:37:52.530 Demilade Agboola: but I’m never always aware which ones we will need you on.
331 00:37:52.730 ⇒ 00:37:54.460 Demilade Agboola: so I kind of send it like.
332 00:37:54.970 ⇒ 00:37:56.580 felipefaria: Okay, like, that’s me. Okay.
333 00:37:56.580 ⇒ 00:37:56.990 Demilade Agboola: Yeah, yeah.
334 00:37:56.990 ⇒ 00:38:01.590 felipefaria: No worries, and I’ll just put a a placeholder, and then I’ll just be on the lookout moving forward. Essentially.
335 00:38:02.640 ⇒ 00:38:04.720 felipefaria: it’s fine.
336 00:38:05.000 ⇒ 00:38:18.140 Emily Giant: Definitely Tuesday and Wednesday this week since. So demalade and I, you actually joined it like the absolute, perfect time we were just wrapping up what we were talking about with Hardgoods. We were having like a technical problem with Dbt, so that would have been
337 00:38:18.430 ⇒ 00:38:33.830 Emily Giant: not at all associated with like doing Qa with you. So good timing. But we’re in a spot, I think, where we’re just gonna be doing Qa, and like building out a dashboards in Looker So
338 00:38:34.450 ⇒ 00:38:43.150 Emily Giant: Tuesday and Wednesday, I would think, would be days for Felipe to join, and then, I think hopefully, we’ll be just done with inventory by Thursday
339 00:38:43.710 ⇒ 00:38:44.350 Emily Giant: and.
340 00:38:44.350 ⇒ 00:38:45.090 Demilade Agboola: Yes.
341 00:38:45.090 ⇒ 00:38:47.789 Emily Giant: This will be like out there in the world for use.
342 00:38:47.930 ⇒ 00:38:52.519 Emily Giant: and we can like go over it with the stakeholders on Thursday at the meeting, and
343 00:38:53.320 ⇒ 00:38:56.090 Emily Giant: I’m hoping that that’s our last like
344 00:38:56.800 ⇒ 00:39:00.560 Emily Giant: making any large changes with these tables.
345 00:39:03.040 ⇒ 00:39:04.050 Demilade Agboola: Fingers crossed.
346 00:39:04.840 ⇒ 00:39:11.270 Emily Giant: Yeah, Demo A is adding the cancellation flag today, which should be
347 00:39:11.900 ⇒ 00:39:21.049 Emily Giant: that should fix all of the discrepancies we were seeing between orders on lots like that. Those inflated numbers.
348 00:39:21.830 ⇒ 00:39:22.250 felipefaria: Yeah.
349 00:39:22.550 ⇒ 00:39:26.990 Emily Giant: The other like large discrepancies.
350 00:39:27.250 ⇒ 00:39:36.979 Emily Giant: I’m pretty sure it’s between like the committed and uncommitted, and we can start like quantifying that and doing some Qa. On that this week, and that should give you your mother’s day numbers.
351 00:39:37.554 ⇒ 00:39:40.700 Emily Giant: What we’re looking at here. Can you see my screen.
352 00:39:41.150 ⇒ 00:39:41.900 felipefaria: Yeah.
353 00:39:41.900 ⇒ 00:40:11.469 Emily Giant: Okay, we’re looking at the hard, good tables. So we were just we were doing some like technical tweaking, because Dbt is like one of the models I need to use to build out the looker dashboards is just like giving me the spinning wheel of death, and we don’t know why, because it’s like, not a complicated model at all. But I think it’s just a Dbt problem, because when we put it into like a SQL runner, it all works, but this is also done. I do want to do some more. Qa.
354 00:40:13.270 ⇒ 00:40:14.439 felipefaria: And this is.
355 00:40:15.201 ⇒ 00:40:19.540 felipefaria: And do I have access already to this table? Or no.
356 00:40:19.540 ⇒ 00:40:21.720 felipefaria: Oh, okay.
357 00:40:21.720 ⇒ 00:40:23.391 felipefaria: Hope you guys doing the Qa
358 00:40:24.470 ⇒ 00:40:52.520 Emily Giant: So this is okay. The way we have it built out after our like conversations last week is that this table, whether the lot whether the hard goods are lotted or not lotted. They’re all in the same table, so sometimes they’ll have a netsuite lot Id. Sometimes they won’t. But how like the level of like uniqueness, because you want every row to be like unique in a table is going to be on the location
359 00:40:52.570 ⇒ 00:41:04.979 Emily Giant: and like the skew, and if it has an item, or if it has a lot, id, it will use that. But the way we’re thinking of it is that every location should have a unique count of their hard goods like.
360 00:41:05.700 ⇒ 00:41:10.049 Emily Giant: So the one thing that I did need to add that made this take like a day longer was
361 00:41:10.604 ⇒ 00:41:30.060 Emily Giant: I realized you’re always going to want to query by dates, and if you don’t like, throw a date in there it’s going to give you every sale and every reconciliation on the glass vase for all of time. So now it’s just by, and this is one of the one of the questions I needed you for. So
362 00:41:30.340 ⇒ 00:41:38.119 Emily Giant: right now, adjustment date is for whether it’s a sale or spoilage, I mean
363 00:41:38.810 ⇒ 00:41:43.159 Emily Giant: vases don’t spoil. But anyway, whatever the adjustment type is
364 00:41:43.430 ⇒ 00:41:49.930 Emily Giant: the adjustment data I’m using is when the adjustment was created. And I didn’t know if that’s actually what you wanted
365 00:41:50.200 ⇒ 00:41:51.880 Emily Giant: for sales.
366 00:41:52.470 ⇒ 00:42:02.150 felipefaria: Yeah for sales. Not really right? Because this is like, if a customer places an order like 2 weeks before the actual product ships out.
367 00:42:03.138 ⇒ 00:42:11.969 felipefaria: That’s not necessarily a measure that I wanna look. I think it just muddies a little bit of data on on my side ideally.
368 00:42:12.150 ⇒ 00:42:18.279 felipefaria: And I look at sales in terms of fulfillment, like when the when the product actually shipped
369 00:42:19.077 ⇒ 00:42:25.540 felipefaria: and if we have to separate kind of like, have one database or one table that have all the adjustments except
370 00:42:26.010 ⇒ 00:42:30.129 felipefaria: for adjustments where the product actually ships out right? So
371 00:42:30.798 ⇒ 00:42:35.100 felipefaria: and we can have those 2 separated, but because
372 00:42:35.430 ⇒ 00:42:39.030 felipefaria: and I don’t know if you can put like, you know, one table that has
373 00:42:39.230 ⇒ 00:42:48.529 felipefaria: sales going by fulfillment date. But then all the other adjustments going by adjustment date, because we don’t have a fulfillment date for like a spoilage adjustment, right? Or for
374 00:42:48.880 ⇒ 00:42:53.479 felipefaria: a shrinkage adjustment. So so I don’t know how you reconcile those 2 things.
375 00:42:54.410 ⇒ 00:43:03.859 Emily Giant: Okay. Demoda, do you think I would just add that to this table because it’s not hard for me to pull fulfillment date and put it in here. But it’s definitely gonna be
376 00:43:05.100 ⇒ 00:43:07.059 Emily Giant: a different thing.
377 00:43:08.930 ⇒ 00:43:12.529 Demilade Agboola: A question is, do hard goods have fulfillment, dates.
378 00:43:13.500 ⇒ 00:43:22.350 Emily Giant: They do, but it’s the difference between like sales have fulfillment dates. But every other adjustment type doesn’t.
379 00:43:23.360 ⇒ 00:43:25.609 Emily Giant: So it would be like.
380 00:43:27.310 ⇒ 00:43:40.879 Emily Giant: and it wouldn’t be hard to tweak that, because it’s really like 2 tables coming together that we stack on top of each other, whether it’s a sale or an adjustment. So like this is just reconciliation. So in this table.
381 00:43:41.110 ⇒ 00:43:50.929 Emily Giant: it’s fine to use created at, because that’s really the only relevant date, because this is just like marketing spoilage shrinkage which marketing does work. By the way, I saw.
382 00:43:50.930 ⇒ 00:43:52.989 felipefaria: Yeah. Marketing would be fulfillment. Right?
383 00:43:53.170 ⇒ 00:43:54.120 Emily Giant: Potentially.
384 00:43:54.880 ⇒ 00:43:57.179 Emily Giant: That’s true.
385 00:43:58.080 ⇒ 00:43:58.870 felipefaria: So
386 00:44:02.480 ⇒ 00:44:05.088 felipefaria: we have a oh, sorry.
387 00:44:05.610 ⇒ 00:44:08.080 felipefaria: I’m muting myself.
388 00:44:08.970 ⇒ 00:44:09.910 felipefaria: No, go for it.
389 00:44:10.010 ⇒ 00:44:17.229 felipefaria: Finish your time. No. No. I was just gonna say, yeah, ideally, we would have things separated for
390 00:44:17.380 ⇒ 00:44:25.123 felipefaria: adjustments for products that ships out. So it would be like sales. Redelivery subscription marketing
391 00:44:25.920 ⇒ 00:44:33.179 felipefaria: stuff like this. And then and I sent an email a message to Jesse, just to clarify on kind of like those.
392 00:44:33.720 ⇒ 00:44:50.880 felipefaria: It’s not simple orders. But we do. Qc sense like just to check the quality of the product. I think that we would also wanna then incorporate, I just wanna make sure how which adjustment type is used. But then in in all of those that actually ships out of the facility right? It would be one thing.
393 00:44:51.000 ⇒ 00:45:01.629 felipefaria: and then everything else which is essentially adjustments, either spoiling product or removing product from inventory for any other reason other than shipping.
394 00:45:02.615 ⇒ 00:45:08.009 felipefaria: It would be on another table, right? Which would which we could call like
395 00:45:08.830 ⇒ 00:45:13.904 felipefaria: adjustments like inventory adjustments in terms of
396 00:45:16.260 ⇒ 00:45:24.900 felipefaria: I don’t know how we want to call it exactly could be like Ias, or or stuff like that. But yeah, like.
397 00:45:25.260 ⇒ 00:45:27.240 felipefaria: if there is a way to
398 00:45:27.860 ⇒ 00:45:32.260 felipefaria: use the filters and potentially have everything combined, that’s fine.
399 00:45:32.590 ⇒ 00:45:38.400 felipefaria: But I don’t know if it’s gonna complicate a little bit, just the utilization of the reports. So
400 00:45:40.240 ⇒ 00:45:47.819 felipefaria: it’s just a note. Because in the past I used to, I used to use different reports, for like sales versus
401 00:45:48.290 ⇒ 00:45:52.379 felipefaria: adjustments, right? Even though in the adjustments
402 00:45:52.570 ⇒ 00:46:02.680 felipefaria: section there was a line item for sales. If I wanted to see the sales, too. I never. I never use the sales for that. I only use. I only use that table for
403 00:46:03.000 ⇒ 00:46:09.279 felipefaria: shrinkage and spoilage data. So on my end. This is kinda
404 00:46:10.630 ⇒ 00:46:17.710 felipefaria: it’s fine and maybe preferable to have it separated into 2 tables like I described. But
405 00:46:18.120 ⇒ 00:46:24.919 felipefaria: obviously, if there’s complexities and stuff we can work, we can work with you guys on terms of the best way to do it.
406 00:46:26.578 ⇒ 00:46:31.949 Emily Giant: The way it’s built now is those are separated. If I show you the like, the lineage.
407 00:46:34.320 ⇒ 00:46:48.000 Emily Giant: you can almost like tell what’s happening by name. So it goes like, these are the reconciliation. So any like non suborder adjustments. And then, if I go to like what would be live in looker. It combines
408 00:46:48.730 ⇒ 00:46:56.309 Emily Giant: the sale adjustments and the hard, good adjustments. Right here. It’s when you like, aggregate all the different adjustment types. So.
409 00:46:56.310 ⇒ 00:46:56.890 felipefaria: Yeah.
410 00:46:57.080 ⇒ 00:46:58.969 Emily Giant: Yeah, I think.
411 00:46:59.800 ⇒ 00:47:11.010 Emily Giant: And Demo Lati, let me know what you think. I, my feeling is to change the adjustment date
412 00:47:11.150 ⇒ 00:47:17.279 Emily Giant: in the suborder model to be the fulfillment date instead of the creation date.
413 00:47:17.630 ⇒ 00:47:21.450 Emily Giant: or just add it and call it like purchase, date
414 00:47:21.870 ⇒ 00:47:31.205 Emily Giant: and adjustment. Date and adjustment. Date means the day it was cleared from the facility for sub orders, because
415 00:47:32.540 ⇒ 00:47:37.700 Emily Giant: this model, the created at that’s what it means.
416 00:47:39.080 ⇒ 00:47:45.569 Emily Giant: The date that a reconciliation is created is the date that it is cleared out of the facility.
417 00:47:46.170 ⇒ 00:47:51.059 Emily Giant: And yeah, and with sales created. That means the day the purchase was made.
418 00:47:52.470 ⇒ 00:47:57.770 Demilade Agboola: Well do we have access to both informations in this? So we can just we just add it here.
419 00:47:58.412 ⇒ 00:48:08.599 Demilade Agboola: So now we’ll be able to have like different filters in the dashboard when you want to like. Look at it from the purchase date, or you want to look at it from the adjustment date.
420 00:48:09.050 ⇒ 00:48:23.369 Emily Giant: Okay? And then I’ll write at in the looker description, so that when like, I know, sleep is gonna know. But for other users, when they like hover over adjustment date, it will say the date. The inventory was cleared from the building
421 00:48:24.090 ⇒ 00:48:25.670 Emily Giant: for the sales.
422 00:48:27.750 ⇒ 00:48:36.919 Emily Giant: That isn’t so, Demo lade. Should I add it to the Pr. Or should I create a new Pr.
423 00:48:38.575 ⇒ 00:48:41.139 Demilade Agboola: I mean, you can. Obviously the pr, that’s fine.
424 00:48:41.460 ⇒ 00:48:42.030 Emily Giant: Okay.
425 00:48:43.575 ⇒ 00:48:47.009 Demilade Agboola: I did have one question for Felipe. If I could quickly share my screen.
426 00:48:47.670 ⇒ 00:48:49.760 Emily Giant: Oh, yeah, let me stop sharing.
427 00:48:55.240 ⇒ 00:48:57.629 Demilade Agboola: So when we’re looking at canceled orders.
428 00:48:57.880 ⇒ 00:49:01.410 Demilade Agboola: we want to look at it in terms of
429 00:49:01.890 ⇒ 00:49:13.850 Demilade Agboola: the quantity sold so like we would have quantity sold, but the same way we have, like committed non-committed, but we have constant quantity sold, then break it down into like canceled quantity sold, or like
430 00:49:14.230 ⇒ 00:49:18.929 Demilade Agboola: canceled subscription quantity like, how do we want to split it?
431 00:49:23.420 ⇒ 00:49:25.649 felipefaria: And I don’t know if we need to to have
432 00:49:26.260 ⇒ 00:49:36.409 felipefaria: well, I mean, it would be good to have the measure of like how many orders were canceled, but honestly like in the past. I haven’t looked at that
433 00:49:37.670 ⇒ 00:49:47.579 felipefaria: and I would just think that whatever order that is canceled should either way it should show under the uncommitted right, because.
434 00:49:48.030 ⇒ 00:49:53.810 felipefaria: and once an order is canceled, the inventory should be back as Afs, essentially.
435 00:49:53.810 ⇒ 00:49:54.330 Demilade Agboola: Okay.
436 00:49:54.820 ⇒ 00:49:58.170 felipefaria: So ideally like
437 00:49:58.510 ⇒ 00:50:09.599 felipefaria: if we can keep both right like, and and have a way to see how many orders were canceled for any given week, I guess, and that’s a good a good thing to to have visibility into it.
438 00:50:09.890 ⇒ 00:50:26.250 felipefaria: But if I’m simply looking at like you know how many orders were committed and shipped versus how many orders were like not committed. And I would wanna make sure that the canceled orders are under the uncommitted
439 00:50:27.200 ⇒ 00:50:28.950 felipefaria: bucket. Essentially.
440 00:50:29.740 ⇒ 00:50:31.059 Demilade Agboola: Okay, alright.
441 00:50:31.500 ⇒ 00:50:32.210 Demilade Agboola: But
442 00:50:32.670 ⇒ 00:50:43.120 Demilade Agboola: so effectively, I will just create a separate version. So instead of like unlimited, it would have like canceled, and then would have the canceled numbers as well.
443 00:50:43.430 ⇒ 00:50:45.550 Demilade Agboola: The different like categories.
444 00:50:47.290 ⇒ 00:50:48.090 felipefaria: Okay.
445 00:50:48.280 ⇒ 00:50:48.640 Demilade Agboola: Anytime.
446 00:50:49.283 ⇒ 00:50:50.570 felipefaria: Yeah, okay.
447 00:50:51.140 ⇒ 00:50:57.330 Demilade Agboola: There, that’s that was basically it. This, I should be able to push this out
448 00:50:58.550 ⇒ 00:51:07.899 Demilade Agboola: in like the next like couple of hours. I do have a bunch of meetings so that might delay me, but or the next couple of hours I should push this out, and then Emily can make it available
449 00:51:08.300 ⇒ 00:51:09.460 Demilade Agboola: in looker.
450 00:51:10.800 ⇒ 00:51:14.301 felipefaria: And quick question in, are you guys the ones
451 00:51:14.810 ⇒ 00:51:21.679 felipefaria: doing those little signs in dash? Kind of like for for subscriptions through delivery? Is that a dev thing.
452 00:51:22.610 ⇒ 00:51:28.539 Emily Giant: Yes, cause I was gonna ask like if if there’s a way to also put a sign there for like.
453 00:51:29.440 ⇒ 00:51:32.223 felipefaria: Canceled orders, but also
454 00:51:33.360 ⇒ 00:51:42.600 felipefaria: the marketing orders right? Like the the marketing artist, I think, is the one that we we still don’t have it. And I’m just thinking, because I feel like
455 00:51:42.980 ⇒ 00:51:49.190 felipefaria: we are. We are moving more towards corporate
456 00:51:49.300 ⇒ 00:51:56.580 felipefaria: orders, in a sense, trying to get more corporate orders. So the number of corporate corporate and marketing orders
457 00:51:57.120 ⇒ 00:52:07.059 felipefaria: we’ll probably just go up. So we want more and more visibility into that. And this is why I’m starting to kinda emphasize a little bit more the fact that we wanna have the
458 00:52:07.340 ⇒ 00:52:09.270 felipefaria: visibility into like
459 00:52:09.730 ⇒ 00:52:28.270 felipefaria: marketing and corporate orders siloed as well. Just so we? We add this into our reports as well. I’ll probably just create a column in my in my recaps, because before, like, I only had sales redelivery and subscription. But I also wanna put a column of like marketing and corporate essentially.
460 00:52:29.126 ⇒ 00:52:51.720 Emily Giant: That’s a good call. I was after our convos last week. I was looking into like whether those adjustment types were coming through in the data, and they are. So that’s good news. But what I’m not sure of is if there isn’t always like a an associated sub order, adjustment, and that marketing.
461 00:52:52.280 ⇒ 00:53:00.689 Emily Giant: it looks to me like marketing is the act of like setting the units aside. Not necessarily.
462 00:53:03.700 ⇒ 00:53:04.120 felipefaria: Ready!
463 00:53:04.170 ⇒ 00:53:18.120 Emily Giant: Not like deterministic of this is the order adjustment. So what I still need to figure out is like, if for every marketing adjustment there is an associated sub order, and that they balance each other out, cause I think they do
464 00:53:19.420 ⇒ 00:53:20.700 Emily Giant: But I haven’t.
465 00:53:20.700 ⇒ 00:53:21.250 felipefaria: Sure.
466 00:53:21.250 ⇒ 00:53:23.090 Emily Giant: Yet it’s
467 00:53:25.300 ⇒ 00:53:27.669 Emily Giant: It’s kind of the same issue as like
468 00:53:28.060 ⇒ 00:53:34.099 Emily Giant: what I was saying about shrinkage. And when we’re calculating shrinkage
469 00:53:34.540 ⇒ 00:53:38.729 Emily Giant: like 90% of the time. There’s actually an associated suborder
470 00:53:38.870 ⇒ 00:53:50.600 Emily Giant: and not 90 70% of the time. There’s actually an associated suborder that would balance it out. But I don’t want to not represent that suborder
471 00:53:51.068 ⇒ 00:53:52.659 Emily Giant: because it’s not the truth.
472 00:53:52.890 ⇒ 00:53:57.050 Emily Giant: but it is being counted as shrinkage. If it doesn’t have a commitment.
473 00:53:57.700 ⇒ 00:54:04.690 felipefaria: Yeah, yeah, but it it’s counted as shrinkage. If it doesn’t have a commitment.
474 00:54:05.100 ⇒ 00:54:10.912 Emily Giant: It’s counted as either shrink. What what I’ve observed is either shrinkage or
475 00:54:11.870 ⇒ 00:54:20.569 Emily Giant: What’s the one that’s like inventory discrepancy. There’s 1 that like mismatch inventory mismatch.
476 00:54:20.570 ⇒ 00:54:22.509 felipefaria: Oh, yeah, like system mismatch.
477 00:54:22.670 ⇒ 00:54:34.040 Emily Giant: System mismatch. A time that has an associated order, or, like the number of uncommitted orders, equals the number of system mismatch so
478 00:54:34.190 ⇒ 00:54:48.279 Emily Giant: like, whereas when I worked in retail, if I was doing my shrinkage, Kpi, but we’d actually made money and sold those shirts, I don’t really want to represent that as shrinkage. So
479 00:54:49.000 ⇒ 00:55:00.089 Emily Giant: we’re like building out here as like the uncommitted versus committed, because those numbers should always be considered next to each other as like the true
480 00:55:00.520 ⇒ 00:55:03.130 Emily Giant: sales, and like what?
481 00:55:03.640 ⇒ 00:55:08.389 Emily Giant: Even if it’s uncommitted if it got delivered? That is a sale that made revenue.
482 00:55:08.730 ⇒ 00:55:09.270 felipefaria: Yeah.
483 00:55:09.270 ⇒ 00:55:14.740 Emily Giant: Shouldn’t be considered shrinkage and spoilage. So like what Demo Lot is built here is like.
484 00:55:14.850 ⇒ 00:55:21.510 Emily Giant: what? What do we think because of the system. And what is true and the uncommitted
485 00:55:21.970 ⇒ 00:55:25.099 Emily Giant: is actually the true number of sales
486 00:55:25.500 ⇒ 00:55:33.420 Emily Giant: or units sent out the door. So I don’t know if that’s gonna probably have us redo your Kpi dashboards quite a bit.
487 00:55:33.560 ⇒ 00:55:37.349 Emily Giant: And historically, too. I would think you’d probably want to redo
488 00:55:37.810 ⇒ 00:55:46.089 Emily Giant: all those numbers for shrinkage, since so many, especially over the holidays, were actual orders that made revenue, and were sent out. The door.
489 00:55:46.320 ⇒ 00:55:49.849 felipefaria: Yeah, yeah, in my, in.
490 00:55:50.220 ⇒ 00:55:58.969 felipefaria: are they being double counted potentially like in the like? Are they showing up as sales and as shrinkage? Or they’re
491 00:55:59.300 ⇒ 00:56:00.580 felipefaria: yeah, okay.
492 00:56:00.940 ⇒ 00:56:02.280 Emily Giant: So it’s almost like
493 00:56:02.410 ⇒ 00:56:06.389 Emily Giant: I don’t know if I would call it double counting. I would call it like canceling each other out.
494 00:56:06.390 ⇒ 00:56:14.520 felipefaria: Yeah, yeah, either. Or right, like, it’s showing it’s showing up in 2 in 2 different like measures or buckets. Essentially.
495 00:56:16.236 ⇒ 00:56:21.010 felipefaria: Yeah, yeah, I’ll definitely like on a everyday basis
496 00:56:22.100 ⇒ 00:56:25.269 felipefaria: whatever discrepancy is not enough to
497 00:56:25.530 ⇒ 00:56:36.060 felipefaria: to really raise a flag except for like one or 2 skews. But the variances are not that large. But yeah, for for Mother’s Day and Valentine’s Day, it’s always been the case that
498 00:56:37.390 ⇒ 00:56:48.429 felipefaria: the numbers get super wonky and and so, yeah, like, once we have the new imagine in place, I’ll have to re-pool all the data and and see if it makes if it makes more sense.
499 00:56:48.730 ⇒ 00:56:52.700 Emily Giant: Yeah, hopefully, it’s just for like those 2 weeks, only because it
500 00:56:52.700 ⇒ 00:56:56.880 Emily Giant: see a lot of discrepancies in regular time.
501 00:56:56.990 ⇒ 00:57:09.830 Emily Giant: The other thing I know, we still need to like tweak. Probably a little bit is available for sale, and we don’t have any time left today. But, like Damalade, would you agree that in the next 2 days with Felipe we should pull up that chart, and like.
502 00:57:09.990 ⇒ 00:57:13.669 Emily Giant: make sure that available for sale looks the way they want it to?
503 00:57:16.360 ⇒ 00:57:19.759 Emily Giant: Or do you think that we’ve like internally kind of figured that out.
504 00:57:20.360 ⇒ 00:57:25.110 Demilade Agboola: Yeah, we can also look, we could look at it for so another thing will be also like quantity used.
505 00:57:25.390 ⇒ 00:57:25.930 Emily Giant: Yeah.
506 00:57:25.930 ⇒ 00:57:30.150 Demilade Agboola: Because quantity used is currently using, like the total like sale
507 00:57:30.550 ⇒ 00:57:33.219 Demilade Agboola: values which will be committed and uncommitted.
508 00:57:33.780 ⇒ 00:57:46.129 Demilade Agboola: I don’t know if that’s exactly how you want to represent it. So just like those like final aggregate numbers, we might just need to look at them. And just be sure that, like, we’re getting exactly how we want the business to sit.
509 00:57:46.930 ⇒ 00:57:47.360 Emily Giant: Yeah.
510 00:57:47.360 ⇒ 00:57:48.040 felipefaria: Fantastic.
511 00:57:48.260 ⇒ 00:57:55.260 felipefaria: Yeah, we can. And and we can discuss. But I would imagine that we would want both of them. Right quantity use should be every single
512 00:57:55.550 ⇒ 00:57:57.860 felipefaria: unit of inventory that was
513 00:57:58.340 ⇒ 00:58:07.550 felipefaria: you that essentially was used for something right like it was either sold or reconciled out of the system, like anything that is not still Afs.
514 00:58:08.090 ⇒ 00:58:13.059 felipefaria: and rolling over into a following week should be inventory used
515 00:58:13.580 ⇒ 00:58:19.652 felipefaria: then, Emily like, and this might be a good thing like in going back to the adjustment things.
516 00:58:20.320 ⇒ 00:58:22.070 felipefaria: It’s a good
517 00:58:24.360 ⇒ 00:58:30.810 felipefaria: well, actually, no, no! And I’ll take that back. Let and let me think a little bit more, and then I’ll get back to you on this one and just show.
518 00:58:30.810 ⇒ 00:58:31.220 Emily Giant: Oh!
519 00:58:31.220 ⇒ 00:58:33.800 felipefaria: And not confuse things too much.
520 00:58:34.370 ⇒ 00:58:38.720 Emily Giant: Hopefully. Tomorrow we can work a little on Looker, too, so that you’re not like looking at
521 00:58:38.940 ⇒ 00:58:41.400 Emily Giant: these tables written out in
522 00:58:42.100 ⇒ 00:58:52.890 Emily Giant: code. It’s not as easy to Qa. So all right, know about a hop for our next meeting. But I think we know. Okay, tomorrow and Wednesday
523 00:58:53.350 ⇒ 00:58:55.990 Emily Giant: we’ll knock out those last pieces.
524 00:58:57.570 ⇒ 00:58:58.310 Demilade Agboola: Sounds good.
525 00:58:58.720 ⇒ 00:58:59.380 Emily Giant: Alright!
526 00:58:59.770 ⇒ 00:59:02.210 Emily Giant: Alright, bye, bye-bye.