Meeting Title: Working session Date: 2025-06-12 Meeting participants: Demilade Agboola, Emily Giant
WEBVTT
1 00:00:42.820 ⇒ 00:00:44.070 Emily Giant: Morning.
2 00:00:44.350 ⇒ 00:00:45.620 Demilade Agboola: Hi, Emily!
3 00:00:46.010 ⇒ 00:00:47.180 Emily Giant: How are you?
4 00:00:47.180 ⇒ 00:00:48.570 Demilade Agboola: I’m pretty good. How are you?
5 00:00:49.190 ⇒ 00:00:58.032 Emily Giant: I’m good. I’m eating toast with nutella on it, and I feel like I have like chocolate all over my face like a 5 year old.
6 00:00:58.560 ⇒ 00:01:02.320 Demilade Agboola: Must be some good. Must be breakfast.
7 00:01:02.930 ⇒ 00:01:06.752 Emily Giant: I mean healthy. No good. Yes.
8 00:01:07.700 ⇒ 00:01:10.030 Emily Giant: But have you ever had nutella.
9 00:01:10.220 ⇒ 00:01:14.459 Demilade Agboola: Yeah, it’s a bit too sweet for me. But you know.
10 00:01:15.800 ⇒ 00:01:20.988 Emily Giant: Like not me, not me. It was made perfect.
11 00:01:21.460 ⇒ 00:01:26.120 Demilade Agboola: Like they’re like nutella like croissants here.
12 00:01:26.120 ⇒ 00:01:28.040 Emily Giant: Oh, my God!
13 00:01:29.343 ⇒ 00:01:32.649 Emily Giant: That would be like every day for me!
14 00:01:33.630 ⇒ 00:01:35.199 Demilade Agboola: Like literally does a
15 00:01:35.760 ⇒ 00:01:46.979 Demilade Agboola: pastries. Well, it’s a coffee shop, but they do pastries around the corner. It’s like a 3 min walk from my house. They they have, like Biscoff croissants.
16 00:01:46.980 ⇒ 00:01:53.048 Emily Giant: Oh, my God, it’s just. It’s just a lot of pizza. It’s just a lot of stuff there.
17 00:01:53.360 ⇒ 00:01:54.732 Emily Giant: Yeah, that’s nice.
18 00:01:55.370 ⇒ 00:02:09.310 Emily Giant: I I would go. Every morning when I lived in New York, I every morning would walk to a coffee shop like the amount of money I spent on, just like coffee and pastries was so absurd, and I didn’t spend a lot of money on like
19 00:02:09.729 ⇒ 00:02:16.490 Emily Giant: other meals like I cooked a lot like at home breakfast. No, it was like the pastries
20 00:02:17.240 ⇒ 00:02:36.729 Emily Giant: I found a bove that had like a 3, and nothing has ever been $3 in New York City. So I would go. That was like a good year of my life. I’ll get like addicted to a thing
21 00:02:36.850 ⇒ 00:02:43.949 Emily Giant: during breakfast, but that got me off the suite for a while, but now I’m back back on the suite.
22 00:02:45.010 ⇒ 00:02:46.000 Demilade Agboola: Fair enough.
23 00:02:46.520 ⇒ 00:02:50.850 Emily Giant: So, yeah, I know you had a session yesterday with, Yeah.
24 00:02:50.850 ⇒ 00:02:55.280 Demilade Agboola: Kyle, how did that go? Were you able to cover everything you needed to cover.
25 00:02:55.680 ⇒ 00:02:59.730 Emily Giant: Most of the stuff. Yes, we were doing a lot of like the deprecation work.
26 00:03:00.696 ⇒ 00:03:04.060 Emily Giant: Not actually doing it, but going through and saying like
27 00:03:04.220 ⇒ 00:03:13.300 Emily Giant: this, sync needs to be turned off, which I just finally got my final answer at 5 am. From one of the stakeholders about turning off a sync. But yeah, we got pretty
28 00:03:13.877 ⇒ 00:03:19.979 Emily Giant: we got a lot done. I still have a couple of lingering like looker dashboards that I have to go through.
29 00:03:20.230 ⇒ 00:03:30.720 Emily Giant: but for the most part we were pretty productive. I’m looking forward to like getting him more to like to the place where you are, where you can like. Help me, troubleshoot with some of the like.
30 00:03:30.940 ⇒ 00:03:38.690 Emily Giant: because that’s what’s taking all my time is things breaking and and like departments not being able to do their work in the meantime of us
31 00:03:39.240 ⇒ 00:03:51.069 Emily Giant: doing the larger work, and I feel like I’ve been taken so away from doing some of the things that would unblock y’all trying to like fix available for sale again or
32 00:03:51.230 ⇒ 00:03:53.539 Emily Giant: replacing products. Xf, so
33 00:03:53.650 ⇒ 00:04:05.969 Emily Giant: like the more people that can look at our models and be like. Nope, it’s right there, fix that, and that will get it all going again the better. But I think the models are actually like deprecated to the point of.
34 00:04:06.600 ⇒ 00:04:16.430 Emily Giant: There’s no longer little fixes. They’re just so broken that like it’s gotta be the big work. And I need to be better at like communicating to stakeholders
35 00:04:16.839 ⇒ 00:04:21.729 Emily Giant: to just change their plans like they can’t do the work they wanted to do right now, because
36 00:04:22.019 ⇒ 00:04:26.040 Emily Giant: it’s just not ready, and it’s not possible.
37 00:04:26.260 ⇒ 00:04:26.790 Emily Giant: So.
38 00:04:26.790 ⇒ 00:04:27.340 Demilade Agboola: Yeah.
39 00:04:27.540 ⇒ 00:04:30.730 Emily Giant: Yeah, but it was good. We
40 00:04:30.980 ⇒ 00:04:34.390 Emily Giant: I still need to finish going through the Dbt models and like
41 00:04:35.890 ⇒ 00:04:39.580 Emily Giant: rating them. I’m about halfway done with that. But,
42 00:04:40.890 ⇒ 00:04:52.469 Emily Giant: If I can clear the 2 things that are like in front of that, I don’t think there’s any issue getting them done by Friday. Like, I’m not worried about any of our tickets getting done at this point, but that does depend on
43 00:04:52.740 ⇒ 00:04:55.720 Emily Giant: today. I wanted to go over
44 00:04:56.040 ⇒ 00:05:12.220 Emily Giant: available for sale with you some of the like work that I’ve been doing since we were like on that initial task a couple of months ago. I’ve found more ways that it is inaccurate. And it’s not our model. It’s netsuite, but
45 00:05:12.370 ⇒ 00:05:15.600 Emily Giant: because of the tables we have in place. There are like
46 00:05:16.650 ⇒ 00:05:25.860 Emily Giant: ways to logically make it more accurate than like the netsuite timing of updating those tables. So one second, let me.
47 00:05:28.460 ⇒ 00:05:37.900 Emily Giant: I’m going to share this share my screen and share the spreadsheet.
48 00:05:42.190 ⇒ 00:05:48.990 Emily Giant: I do much prefer zoom screen sharing. I feel like it’s way better than Google meets.
49 00:05:50.107 ⇒ 00:05:59.650 Demilade Agboola: Yeah, I I like zoom for us is like a lifesaver, especially, cause we have like. We have like zoom transcripts. And then.
50 00:05:59.650 ⇒ 00:06:00.380 Emily Giant: Oh, yeah.
51 00:06:00.540 ⇒ 00:06:02.489 Demilade Agboola: That allows us especially like
52 00:06:03.120 ⇒ 00:06:23.930 Demilade Agboola: I know. For instance, it would have been really helpful, for, like some of the things when we’re handling inventory stuff meetings, and just be like, oh, cause this was the exact thing that was said, or this is the exact logic. So that is quite helpful. And in house we have, like a like a meeting, summarize that thing.
53 00:06:24.220 ⇒ 00:06:26.120 Demilade Agboola: So he summarizes every meeting.
54 00:06:26.120 ⇒ 00:06:31.910 Emily Giant: Oh, that’s awesome. It’s it’s kind of janky, I think, like
55 00:06:32.160 ⇒ 00:06:38.770 Emily Giant: it’s got some features. But like even the screen sharing to me is really like this
56 00:06:39.430 ⇒ 00:06:45.169 Emily Giant: you can never see very well. You always have to like Zoom in so much to like.
57 00:06:45.450 ⇒ 00:06:49.160 Emily Giant: Okay, I sent the spreadsheet, and then where’s mode.
58 00:06:50.740 ⇒ 00:06:58.950 Emily Giant: So I had chatted with you a little bit about how available for sale kept going into the negatives.
59 00:06:59.890 ⇒ 00:07:03.159 Emily Giant: and I was so I just pulled.
60 00:07:03.600 ⇒ 00:07:05.959 Emily Giant: Let me run it again fresh.
61 00:07:07.440 ⇒ 00:07:08.740 Emily Giant: I pulled it.
62 00:07:09.880 ⇒ 00:07:17.289 Emily Giant: for, like any orders that were still showing negative available for sale with the what’s available for sale column here?
63 00:07:17.610 ⇒ 00:07:18.919 Emily Giant: Oh, where’d it go?
64 00:07:19.110 ⇒ 00:07:22.180 Emily Giant: This is what’s like, live in production.
65 00:07:23.600 ⇒ 00:07:24.400 Demilade Agboola: Okay.
66 00:07:24.540 ⇒ 00:07:30.750 Emily Giant: Right here, and then the new available for sale is what I’ve been working on to try and correct for some of the
67 00:07:31.170 ⇒ 00:07:36.733 Emily Giant: instances where, like the Netsuite tables haven’t updated
68 00:07:37.850 ⇒ 00:07:42.340 Emily Giant: or whatever the teams haven’t like
69 00:07:42.950 ⇒ 00:07:48.500 Emily Giant: adjusted out units that don’t exist. So this top line isn’t really a thing.
70 00:07:49.396 ⇒ 00:07:54.370 Emily Giant: I let me put this in the spreadsheet because it’s a little easier to look at when it’s in the spreadsheet.
71 00:07:59.520 ⇒ 00:08:01.220 Emily Giant: So okay.
72 00:08:01.440 ⇒ 00:08:10.500 Emily Giant: these are all of the like, the different things that you and I worked on putting together to give the like big picture inventory stuff. So I went over here.
73 00:08:11.070 ⇒ 00:08:15.959 Emily Giant: take you down there to the available for sale and new available for sale.
74 00:08:16.770 ⇒ 00:08:20.370 Emily Giant: All right. So currently.
75 00:08:20.990 ⇒ 00:08:28.110 Emily Giant: the live production available for sales is negative 19. This is negative one. Probably neither of them are true.
76 00:08:29.220 ⇒ 00:08:40.620 Emily Giant: But what I’m seeing a lot of is that either quantity received. Good.
77 00:08:41.720 ⇒ 00:08:51.810 Emily Giant: It’s a combination of quantity on hand committed, and quantity Presale committed. If one
78 00:08:51.930 ⇒ 00:09:10.224 Emily Giant: isn’t successfully adjusted to 0 with that like automated soligo flow that Alex has in place then available for sale. How it’s written in Dbt. Is that it adds them together, and so it will like double the amount of committed inventory.
79 00:09:11.020 ⇒ 00:09:14.490 Emily Giant: in certain instances. Now we know that, like the Hub and spoke.
80 00:09:14.640 ⇒ 00:09:30.230 Emily Giant: Let’s see if I can find an instance of that to show you, because it probably all caught up overnight. But it’s during the day that when the Fcs are receiving that that soligo flow like runs too slowly and winds up
81 00:09:30.470 ⇒ 00:09:38.409 Emily Giant: duplicating the numbers. Where is, I’ll show you in Dbt, so if you go to the inventory lot table
82 00:09:38.570 ⇒ 00:09:44.040 Emily Giant: in Dbt to that calculation for available for sale like it’s really simple.
83 00:09:45.051 ⇒ 00:09:50.670 Emily Giant: It’s like quantity on hand, plus quantity on order.
84 00:09:50.800 ⇒ 00:09:58.479 Emily Giant: and then subtract out the commitments. So the presale commitments and the on hand commitments plus buffer plus Qa.
85 00:09:59.300 ⇒ 00:10:06.350 Emily Giant: But like there are so many instances where the presale just isn’t
86 00:10:06.510 ⇒ 00:10:18.309 Emily Giant: properly set to 0, and it’s duplicated that, like every every time that happens, I’m getting tons of the errors that you put in place, which are great. By the way.
87 00:10:18.810 ⇒ 00:10:19.890 Emily Giant: here we go.
88 00:10:22.140 ⇒ 00:10:30.540 Emily Giant: So yeah, this is. I tweaked it a little bit I can revert it to if you want to see exactly what it was. Would that be helpful to like? Put it back to
89 00:10:31.580 ⇒ 00:10:34.790 Emily Giant: how it was? Oopsies, how it is in production.
90 00:10:36.930 ⇒ 00:10:39.990 Demilade Agboola: Isn’t this the one right underneath, like the
91 00:10:40.300 ⇒ 00:10:41.999 Demilade Agboola: that’s what is in production, right?
92 00:10:42.300 ⇒ 00:10:47.209 Emily Giant: This one. I I tweaked it a little bit, just to try and like
93 00:10:47.850 ⇒ 00:11:00.619 Emily Giant: avoid the duplication situation with the on order and presale commitments. So I said, like instead of at all times, quantity on order, plus quantity on hand.
94 00:11:01.070 ⇒ 00:11:11.113 Emily Giant: I just did. If it’s been received, or if it has not been received, then use the old calculation, but if it has been received, then
95 00:11:12.190 ⇒ 00:11:17.100 Emily Giant: oh, yeah, if it has been received, then just use the quantity
96 00:11:17.320 ⇒ 00:11:23.829 Emily Giant: that was received and is good. But that’s not going to work because things go out the door.
97 00:11:24.240 ⇒ 00:11:32.210 Emily Giant: So like at some point, there’s gonna be like 5,000 that were
98 00:11:33.980 ⇒ 00:11:48.909 Emily Giant: sent in boxes already. And it’s gonna be like 5,000 minus, like the 2 that are on hand committed, and that’s gonna say available for sale is way more so like, that’s a non starter, unless you’re just always subtracting the entire amount
99 00:11:49.150 ⇒ 00:11:50.860 Emily Giant: of inventory that’s sold.
100 00:11:51.970 ⇒ 00:11:57.840 Emily Giant: So this still needs to be like. Well, what I could say is, quantity received is greater than 0,
101 00:11:58.040 ⇒ 00:12:07.419 Emily Giant: then quantity on hand, minus quantity on hand committed, and take the whole Presale situation out of it.
102 00:12:08.510 ⇒ 00:12:14.760 Emily Giant: But I don’t know if that’s gonna mess up like, if
103 00:12:15.700 ⇒ 00:12:19.850 Emily Giant: they’re receiving multiple boxes for one shipment
104 00:12:21.110 ⇒ 00:12:26.460 Emily Giant: But there is an indicator in one of the tables that’s like is a split shipment. So maybe, instead of
105 00:12:27.090 ⇒ 00:12:37.999 Emily Giant: worrying all the time that, like a fringe, situation is going to happen in this calculation. I could just say, like, if split shipment is true, then use this, otherwise
106 00:12:38.400 ⇒ 00:12:41.409 Emily Giant: it would be more along the lines of.
107 00:12:42.680 ⇒ 00:12:43.670 Demilade Agboola: Look.
108 00:12:45.220 ⇒ 00:12:46.430 Emily Giant: Quantity.
109 00:12:46.820 ⇒ 00:12:47.630 Demilade Agboola: What?
110 00:12:48.770 ⇒ 00:12:49.929 Emily Giant: On hand.
111 00:12:51.250 ⇒ 00:12:53.920 Emily Giant: Oh, wait! Well, no, that was fine.
112 00:12:54.350 ⇒ 00:12:55.220 Emily Giant: It’s this.
113 00:13:03.460 ⇒ 00:13:05.090 Emily Giant: and this could go away.
114 00:13:05.810 ⇒ 00:13:09.119 Demilade Agboola: So when quantity receives good. 9 0, what is the quantity on hand.
115 00:13:09.810 ⇒ 00:13:14.820 Emily Giant: Quantity on hand is any units in the building, although, yeah.
116 00:13:15.020 ⇒ 00:13:18.980 Emily Giant: this is also going to mess it up this Qa thing. And
117 00:13:19.840 ⇒ 00:13:24.499 Emily Giant: so this is what I’ve been like trying to work in to the new available for sale.
118 00:13:25.120 ⇒ 00:13:31.770 Emily Giant: That excuse me in the instance that the quantity received
119 00:13:32.280 ⇒ 00:13:35.049 Emily Giant: has Qa. Or does not have Qa.
120 00:13:35.220 ⇒ 00:13:42.030 Emily Giant: Then like use the old calculation, but if it does have qa, then
121 00:13:46.040 ⇒ 00:13:50.409 Demilade Agboola: But does the quantity on hand received for Qa. Does? That account is available for sale, though.
122 00:13:51.620 ⇒ 00:13:54.239 Emily Giant: It so it will cut into on hand.
123 00:13:54.792 ⇒ 00:14:00.120 Emily Giant: This is one of the things in the spreadsheet that I was like what is going on here. So let me find
124 00:14:02.950 ⇒ 00:14:04.900 Emily Giant: we’re not available for sale.
125 00:14:05.600 ⇒ 00:14:06.760 Emily Giant: And
126 00:14:37.410 ⇒ 00:14:39.509 Emily Giant: so here’s a good example.
127 00:14:42.220 ⇒ 00:14:50.750 Emily Giant: We received some Qa. So the amount received Qa. Which is 27,
128 00:14:52.740 ⇒ 00:14:55.910 Emily Giant: it will still show in the on hand.
129 00:14:58.620 ⇒ 00:15:02.810 Emily Giant: unless it’s like, yeah. So it’s still showing the full amount
130 00:15:03.080 ⇒ 00:15:08.270 Emily Giant: in quantity on hand. And that’s what’s used in the Afs calculation.
131 00:15:08.840 ⇒ 00:15:09.940 Emily Giant: So.
132 00:15:10.490 ⇒ 00:15:14.979 Demilade Agboola: So beyond 48. But what would you see? Those 27.
133 00:15:16.010 ⇒ 00:15:19.239 Emily Giant: It should be 48, minus 27 for on hand.
134 00:15:19.630 ⇒ 00:15:24.070 Emily Giant: because there were 27 units that couldn’t be used. It should only be 21.
135 00:15:25.140 ⇒ 00:15:31.170 Demilade Agboola: Okay, Gotcha. So the Qa was 27, the 21 wants.
136 00:15:32.270 ⇒ 00:15:33.260 Emily Giant: Yeah.
137 00:15:35.140 ⇒ 00:15:36.750 Demilade Agboola: But what was committed, though.
138 00:15:37.640 ⇒ 00:15:38.980 Emily Giant: Committed
139 00:15:41.190 ⇒ 00:15:51.010 Emily Giant: on him is committed is 13, so one way or the other should not be in the negative. Right? Like there’s 20. Well, wait 22.
140 00:15:52.230 ⇒ 00:15:52.970 Demilade Agboola: What’s it?
141 00:15:53.410 ⇒ 00:15:56.330 Emily Giant: So the on hand is 13.
142 00:15:56.330 ⇒ 00:16:00.359 Demilade Agboola: A minute out of the out of 21.
143 00:16:00.510 ⇒ 00:16:01.430 Emily Giant: Yes.
144 00:16:01.430 ⇒ 00:16:06.169 Demilade Agboola: And then quantity sold. How many were sold?
145 00:16:07.310 ⇒ 00:16:10.799 Emily Giant: 22. So it actually is oversold by one.
146 00:16:12.210 ⇒ 00:16:17.799 Demilade Agboola: Okay, so Afs, technically is, 0 is technically is negative. One.
147 00:16:17.800 ⇒ 00:16:19.416 Emily Giant: It should be negative one
148 00:16:20.230 ⇒ 00:16:22.790 Emily Giant: which is correct in the new available for sale.
149 00:16:26.130 ⇒ 00:16:27.070 Demilade Agboola: Gotcha.
150 00:16:27.350 ⇒ 00:16:28.000 Emily Giant: Yeah.
151 00:16:28.630 ⇒ 00:16:35.360 Demilade Agboola: But for the ones where it is. Negative, 19 like, why? Why was it negative? 19 before.
152 00:16:37.820 ⇒ 00:16:39.560 Emily Giant: Negative. 19.
153 00:16:41.550 ⇒ 00:16:49.250 Emily Giant: So it’s on hand, plus on order.
154 00:16:49.760 ⇒ 00:17:01.060 Emily Giant: So on hand shows 48, none should be on order minus commitments.
155 00:17:02.610 ⇒ 00:17:06.660 Emily Giant: So sorry I’m chewing.
156 00:17:09.230 ⇒ 00:17:11.159 Emily Giant: So where are our commitments?
157 00:17:23.099 ⇒ 00:17:24.569 Emily Giant: 13.
158 00:17:27.380 ⇒ 00:17:29.690 Emily Giant: So plus buffer?
159 00:17:30.320 ⇒ 00:17:32.950 Emily Giant: Yeah, I don’t understand that negative 19 at all.
160 00:17:36.530 ⇒ 00:17:37.690 Demilade Agboola: All right, perfect.
161 00:17:37.690 ⇒ 00:17:42.759 Demilade Agboola: So a couple of things it does appear that ifs can actually be negative.
162 00:17:47.210 ⇒ 00:17:48.530 Demilade Agboola: but it it.
163 00:17:48.530 ⇒ 00:17:49.750 Emily Giant: Should not be.
164 00:17:49.750 ⇒ 00:17:50.500 Demilade Agboola: Hello!
165 00:17:52.090 ⇒ 00:17:59.470 Emily Giant: It shouldn’t be, but it can in some instances be legitimately oversold, but it usually is like by one.
166 00:18:00.390 ⇒ 00:18:01.200 Demilade Agboola: All right.
167 00:18:02.000 ⇒ 00:18:07.819 Demilade Agboola: So for the new Fs, this this one, we’re getting negative. 2, 41. Can we look into that? Let’s see.
168 00:18:09.710 ⇒ 00:18:13.640 Emily Giant: Okay, so you get 2, 41.
169 00:18:15.290 ⇒ 00:18:17.640 Emily Giant: It looks like we sold 285.
170 00:18:19.950 ⇒ 00:18:23.549 Emily Giant: Oh, wait 289. That’s just the non subscriptions.
171 00:18:24.080 ⇒ 00:18:27.000 Emily Giant: Okay, so we start at the beginning.
172 00:18:28.470 ⇒ 00:18:34.040 Emily Giant: It looks like we received 297, only 48 of them were sellable
173 00:18:34.890 ⇒ 00:18:38.040 Emily Giant: 249 of them were no good.
174 00:18:43.640 ⇒ 00:18:50.440 Emily Giant: so that sounds like, but it shouldn’t stay like that like the team would have had to move those off of
175 00:18:50.680 ⇒ 00:18:58.069 Emily Giant: that lot and put them onto a new one like they didn’t just cancel 241 orders. So I don’t understand like.
176 00:18:59.720 ⇒ 00:19:02.179 Emily Giant: Why, those units are just sitting there still.
177 00:19:02.430 ⇒ 00:19:03.090 Demilade Agboola: Alright, so.
178 00:19:04.050 ⇒ 00:19:04.620 Emily Giant: Go ahead!
179 00:19:05.300 ⇒ 00:19:13.490 Demilade Agboola: If right now, or in that moment where Dbt runs and everything, it’s negative. 2, 42, 41, or whatever.
180 00:19:14.030 ⇒ 00:19:15.610 Demilade Agboola: Gonna move another lot.
181 00:19:16.380 ⇒ 00:19:20.800 Demilade Agboola: My, my thing is, are we trying to over engineer? What
182 00:19:23.290 ⇒ 00:19:26.259 Demilade Agboola: like data points us to a problem or to.
183 00:19:26.260 ⇒ 00:19:26.650 Emily Giant: Right.
184 00:19:26.650 ⇒ 00:19:33.789 Demilade Agboola: This is nice happening. Are we trying to not have those situations up here is kind of what I’m trying to say or trying.
185 00:19:33.790 ⇒ 00:19:42.389 Emily Giant: Absolutely not. We are definitely not trying to do that. I’m just trying to get like the accurate to as close to the truth as possible, and
186 00:19:43.080 ⇒ 00:19:45.430 Emily Giant: I think that the new available for sale
187 00:19:45.830 ⇒ 00:19:58.159 Emily Giant: is closer to the truth than the old available for sale, which is definitely showing like incorrect information, not because of a problem, but because of like the logic.
188 00:19:58.550 ⇒ 00:20:09.440 Emily Giant: because of like netsuite not updating in enough time for it to like accurately portray available for sale.
189 00:20:10.580 ⇒ 00:20:18.520 Emily Giant: But the but the oversell does happen, and we do not want to obscure oversell when it’s true.
190 00:20:19.890 ⇒ 00:20:24.350 Emily Giant: But like what’s in production. Now
191 00:20:24.470 ⇒ 00:20:35.409 Emily Giant: say this like negative 12. Just isn’t true. It’s see why quantity received.
192 00:20:35.780 ⇒ 00:20:47.660 Emily Giant: Good. It’s that it’s counting 18 units that are not for sale somewhere. It shouldn’t be.
193 00:20:50.550 ⇒ 00:20:54.389 Emily Giant: or subtracting 18 units that aren’t for sale somewhere that shouldn’t be
194 00:20:54.630 ⇒ 00:20:59.230 Emily Giant: but one way or the other. It’s not a correct calculation.
195 00:20:59.898 ⇒ 00:21:02.850 Emily Giant: Let me look at the spreadsheet. It’s easier.
196 00:21:07.070 ⇒ 00:21:12.669 Emily Giant: So, for example, it’s this, also this, like sellable quantity received.
197 00:21:13.100 ⇒ 00:21:18.049 Emily Giant: This is the number that’s used in sell-through. And this is way off
198 00:21:18.780 ⇒ 00:21:29.589 Emily Giant: like this isn’t the sellable quantity received at all. The sellable quantity received is what’s ever in this received good column, and it’s never negative. It’s either 0 or positive.
199 00:21:29.930 ⇒ 00:21:35.500 Emily Giant: And that’s what I was talking about on the call the other day when you and I were like, let’s tweak the logic so that
200 00:21:36.445 ⇒ 00:21:40.449 Emily Giant: in the event that sellable quantity received goes negative.
201 00:21:41.920 ⇒ 00:21:44.070 Emily Giant: It will defer to this.
202 00:21:47.320 ⇒ 00:21:53.340 Demilade Agboola: But if that place you don’t want to use that, you just want to go directly to this.
203 00:21:54.910 ⇒ 00:22:00.619 Emily Giant: So my, the reason I wouldn’t do that
204 00:22:01.320 ⇒ 00:22:10.600 Emily Giant: like outright is because sometimes there are inventory adjustments that happen after a lot is received like
205 00:22:10.880 ⇒ 00:22:25.369 Emily Giant: a bunch of roses will die overnight, and then they have to trash them after they’ve been received. So then this 24 isn’t necessarily true. I mean it was at the moment. But then that isn’t the sellable quantity received.
206 00:22:25.760 ⇒ 00:22:31.079 Emily Giant: It’s less so. We want to get as close to the truth as possible, which is how
207 00:22:31.190 ⇒ 00:22:33.120 Emily Giant: it’s engineered right now.
208 00:22:34.930 ⇒ 00:22:39.389 Emily Giant: Which is the the sale? Quantity.
209 00:22:39.620 ⇒ 00:22:48.380 Emily Giant: Wait, that’s quantity sorry. Sorry the available for sale, plus the quantity sold, plus care buffer.
210 00:22:48.920 ⇒ 00:22:54.960 Emily Giant: and that should always it should never be negative.
211 00:22:56.200 ⇒ 00:23:00.570 Emily Giant: It’s just going negative when the available for sale when it’s oversold.
212 00:23:02.410 ⇒ 00:23:04.509 Emily Giant: But still it doesn’t make sense
213 00:23:04.640 ⇒ 00:23:07.620 Emily Giant: for that metric to ever go negative.
214 00:23:08.210 ⇒ 00:23:09.250 Demilade Agboola: Yeah.
215 00:23:14.230 ⇒ 00:23:19.720 Emily Giant: That’s the one we should put the test on like did sellable quantity received go into the negatives because.
216 00:23:24.860 ⇒ 00:23:31.510 Demilade Agboola: Yeah, I mean, they’re available for sale, plus the quantity sold plus the quantity care buffer.
217 00:23:33.910 ⇒ 00:23:40.240 Demilade Agboola: unconsecured buffer. Here is the quantity receives. Qa.
218 00:23:40.910 ⇒ 00:23:58.129 Emily Giant: No, that it’s a quantity that’s set aside as inventory for problem orders that if we have to like, send a bouquet to a customer again, because the 1st one arrived. Crappy. Then that’s the inventory that revenue doesn’t want to use in their calculations.
219 00:23:58.628 ⇒ 00:24:01.960 Emily Giant: Because they’re not making any money off of them. We’re sending them for free.
220 00:24:04.240 ⇒ 00:24:05.210 Demilade Agboola: Gotcha.
221 00:24:28.050 ⇒ 00:24:32.341 Emily Giant: It seems like it shouldn’t be this hard to know how many items you have for sale. Right?
222 00:24:32.860 ⇒ 00:24:33.350 Emily Giant: Wow!
223 00:24:33.350 ⇒ 00:24:36.560 Demilade Agboola: She’d be like. Do we have it, or do we not have it.
224 00:24:36.560 ⇒ 00:24:37.380 Emily Giant: Right.
225 00:24:37.890 ⇒ 00:24:38.440 Demilade Agboola: This? Has.
226 00:24:38.440 ⇒ 00:24:47.470 Emily Giant: This conversation is like so absurd that we even have to figure out like, how can we make our system tell us what we have for sale
227 00:24:48.260 ⇒ 00:24:59.169 Emily Giant: like, how are we operating them a lot? I don’t understand some days how this business still runs. You can strike that from the transcript in zoom, please. That was off the record.
228 00:24:59.290 ⇒ 00:25:00.480 Emily Giant: Thank you.
229 00:25:09.700 ⇒ 00:25:11.020 Demilade Agboola: Let’s see.
230 00:25:20.440 ⇒ 00:25:21.500 Emily Giant: This again.
231 00:25:31.400 ⇒ 00:25:34.150 Emily Giant: Yeah, it should, all right. So
232 00:25:34.790 ⇒ 00:25:37.910 Emily Giant: I don’t want to interrupt your train of thought. If you’re thinking right now.
233 00:25:38.270 ⇒ 00:25:43.499 Emily Giant: I mean, I know you’re always thinking, but I do think there’s like
234 00:25:44.180 ⇒ 00:25:47.670 Emily Giant: a necessity of working in this
235 00:25:48.440 ⇒ 00:25:57.579 Emily Giant: differentiation between when a lot is received with Qa. Versus when it’s not, doesn’t have any Qa.
236 00:25:58.850 ⇒ 00:26:05.370 Emily Giant: Like. What I have in the new one for sale is that if there’s no Qa. Use the old calculation.
237 00:26:06.430 ⇒ 00:26:12.780 Emily Giant: and then it looks like I stopped like mid thought. If it there is Qa.
238 00:26:13.670 ⇒ 00:26:22.580 Emily Giant: then use the total quantity received good, minus the total quantity sold instead of the sum of the parts.
239 00:26:25.270 ⇒ 00:26:28.509 Emily Giant: but that the I’ll write a note in here.
240 00:26:30.590 ⇒ 00:26:40.460 Emily Giant: Well, not take adjustments that happen amongst the lot.
241 00:26:41.090 ⇒ 00:26:44.800 Emily Giant: This received into account.
242 00:27:11.610 ⇒ 00:27:20.230 Demilade Agboola: You know what might be helpful is creating?
243 00:27:20.550 ⇒ 00:27:22.212 Demilade Agboola: I don’t know if we should do
244 00:27:25.300 ⇒ 00:27:28.250 Demilade Agboola: like a mirror board or something, but it’s flow
245 00:27:28.780 ⇒ 00:27:33.520 Demilade Agboola: and all the potential ways, like things can. Things can happen.
246 00:27:35.760 ⇒ 00:27:39.460 Demilade Agboola: So I think right now, what’s what’s making it tricky is that
247 00:27:39.780 ⇒ 00:27:49.629 Demilade Agboola: we’re trying to like code out possible scenarios right right here right now, I think, being able to take a step back and going okay, we can receive a lot.
248 00:27:49.800 ⇒ 00:27:59.269 Demilade Agboola: And just maybe like sketching like a flow. It doesn’t have to be fancy, high fidelity, and just like low Fi
249 00:28:00.320 ⇒ 00:28:05.242 Demilade Agboola: receive a lot a lot. It’s possible that what we receive
250 00:28:08.810 ⇒ 00:28:16.140 Demilade Agboola: it gets tossed out. Therefore we need to do this. What happens? We need to do this like we just put out the different like, maybe 4 or 5.
251 00:28:16.140 ⇒ 00:28:19.394 Emily Giant: Yeah, I dig that. I like that.
252 00:28:19.860 ⇒ 00:28:21.229 Demilade Agboola: Once we do that.
253 00:28:21.380 ⇒ 00:28:39.319 Demilade Agboola: yeah. Allows us to be able to see number one. If we’re like overlooking a scenario like on paper like, actually what happens when this happens when we not covered every single scenario. So that’s 1, 2 is allows us to now create the rules for each of those scenarios, and see which rules can be lumped together.
254 00:28:39.980 ⇒ 00:28:43.129 Demilade Agboola: It makes it easier for us to just even
255 00:28:43.410 ⇒ 00:28:48.840 Demilade Agboola: have certain conversations, or like even bring someone like Kai on board and be like, hey, this has.
256 00:28:49.380 ⇒ 00:28:55.670 Demilade Agboola: this is the spread like this is the flow of how flowers can come in and go out.
257 00:28:55.970 ⇒ 00:29:02.569 Demilade Agboola: And these are the different ways in which we we’ve made logic to account for each of those different scenarios.
258 00:29:04.810 ⇒ 00:29:09.709 Emily Giant: Yeah, I’m gonna create a ticket for that. And I’ll work on that today. Cause I agree with you like.
259 00:29:10.500 ⇒ 00:29:21.340 Emily Giant: I had to stop working yesterday because I was like, Oh, my God! Every time I do one scenario I need to think about another, and I got so like wrapped up in all of the different
260 00:29:21.930 ⇒ 00:29:25.440 Emily Giant: options that I was like we’re done. I’m gonna go paint.
261 00:29:25.760 ⇒ 00:29:34.059 Demilade Agboola: Yeah, I think I think so. Ultimately, code is just an expression of blank thought processes. And to like
262 00:29:34.380 ⇒ 00:29:55.559 Demilade Agboola: that. And so if we’re if the jump every single time is to go straight into the code and the code process, it can be overwhelming, because there’s so many things you need to. But like once you know what the end goal is once you’re aware of, like every single scenario that can exist, which I mean obviously is impossible, because there was like edge cases. But once we get like
263 00:29:56.820 ⇒ 00:30:03.220 Demilade Agboola: 90%, 95% of scenarios locked down, I’m like, okay, so we know what happens.
264 00:30:04.595 ⇒ 00:30:09.170 Demilade Agboola: Once, once, like we’re sending flowers to
265 00:30:09.280 ⇒ 00:30:38.990 Demilade Agboola: a hub or semi flowers to. You know this book. Once it gets there, it can either be this. It can either be that it can either be this, it can either be that. So once you have all the states and situations, and we look at it. And like, actually, you know, maybe we’re overlooking this scenario. We’re overlooking that scenario. Once we now get to that stage where we’re fully confident of what happens, then we can start to add a lot of things like, Oh, when this happens, this is how Netsuite represents it. When that happens, how Netsuite represents it, and then.
266 00:30:38.990 ⇒ 00:30:39.530 Emily Giant: Yeah.
267 00:30:39.530 ⇒ 00:30:43.159 Demilade Agboola: When we write the code, for it’s it’s very. It’s just much easier to
268 00:30:43.760 ⇒ 00:31:00.509 Demilade Agboola: to know and also to debug, because once something else happens, we can go. Okay. So what is a pattern to it? Or is this situation that we’ve looked at? So maybe our logic, or how we wanted to address. It wasn’t actually the best. So we know what we’re changing about that logic.
269 00:31:01.930 ⇒ 00:31:11.220 Emily Giant: Yeah, that’s a great idea. All right. Let’s see if I’m writing this great. There are many situations that affect what is available for sale, and because the current logic overlooks many of them, it’s important to visualize
270 00:31:11.380 ⇒ 00:31:12.830 Emily Giant: the scenarios.
271 00:31:15.280 ⇒ 00:31:16.950 Demilade Agboola: Different scenarios that can occur.
272 00:31:18.320 ⇒ 00:31:29.120 Emily Giant: Can occur, and how Netsuite represents those scenarios.
273 00:31:29.860 ⇒ 00:31:30.420 Demilade Agboola: Bye.
274 00:31:33.490 ⇒ 00:31:38.900 Emily Giant: So map, I’ll do it in like, what’s that program
275 00:31:39.080 ⇒ 00:31:42.670 Emily Giant: that’s really easy to use. We used it for the retro the other day.
276 00:31:45.340 ⇒ 00:31:46.030 Emily Giant: Yeah.
277 00:31:47.350 ⇒ 00:31:49.169 Demilade Agboola: Or is it free jam? I’m not sure.
278 00:31:49.820 ⇒ 00:31:52.470 Emily Giant: One of those. The word fig was in it.
279 00:31:53.900 ⇒ 00:31:54.720 Demilade Agboola: Click.
280 00:31:55.510 ⇒ 00:31:56.460 Emily Giant: Ma.
281 00:31:59.470 ⇒ 00:32:04.470 Demilade Agboola: But yeah, once we once we’re able to, just you could literally be with like sticky notes.
282 00:32:05.130 ⇒ 00:32:09.570 Emily Giant: Yeah, that’s what I was thinking, just like, slap it together.
283 00:32:10.250 ⇒ 00:32:18.360 Demilade Agboola: Yeah, there’s just like, once we were able to say, Oh, okay, these are the 1020. Whatever possible scenarios that, like
284 00:32:21.750 ⇒ 00:32:25.410 Demilade Agboola: flowers could come in and be treated or handled.
285 00:32:26.338 ⇒ 00:32:33.129 Demilade Agboola: It allows us to be able to then like easily, more easily, figure that thing out. It has handled those scenarios.
286 00:32:34.060 ⇒ 00:32:35.980 Emily Giant: Yeah, that’s a great idea.
287 00:32:35.980 ⇒ 00:32:39.300 Demilade Agboola: But sometimes I’ll be honest with you. Sometimes I get lost. I’m just here like.
288 00:32:39.780 ⇒ 00:32:40.280 Emily Giant: And.
289 00:32:40.280 ⇒ 00:32:50.565 Demilade Agboola: Actually going on here. Cause I think that’s the that’s the that’s the the thing where once you on paper, you see that. Okay, what’s happening here is that
290 00:32:51.110 ⇒ 00:32:53.970 Demilade Agboola: this comes in, but he gets tossed out.
291 00:32:54.470 ⇒ 00:33:18.510 Demilade Agboola: and because it gets tossed out it affects our quantity for sale because of this, or it gets sent out a lot or like, once you start to like, just put that like, okay, you can come in, get sent to another lot you can come in. This can happen. They can come in. That can happen once we start putting those numbers like that, like scenarios down allows us to go. Okay. So when it gets sent to another lot, this is what we need to do
292 00:33:18.620 ⇒ 00:33:27.980 Demilade Agboola: when when it’s disposed of. This is what we need to do when there are no Qas amongst this. Sometimes everything is available for sale or like it’s
293 00:33:28.840 ⇒ 00:33:34.160 Demilade Agboola: like, because that’s like, actually work through those scenarios.
294 00:33:35.520 ⇒ 00:33:55.749 Emily Giant: Yeah, I totally. I think it’s a fabulous idea. I will work on that today. Also, it sounds kind of fun. It’s different than staring at Dvt for 10 h straight. Okay, I will work on that today. I’ll probably need to pull Perry and she’ll have fun doing that, too.
295 00:33:55.970 ⇒ 00:33:57.170 Demilade Agboola: Okay. Sounds good.
296 00:33:57.320 ⇒ 00:33:59.590 Emily Giant: The other. Oh, sorry! Go ahead!
297 00:33:59.590 ⇒ 00:34:04.299 Demilade Agboola: I’ll just point out the reconciliations are approved that pr.
298 00:34:04.480 ⇒ 00:34:05.270 Emily Giant: Nice.
299 00:34:05.730 ⇒ 00:34:07.210 Demilade Agboola: That’s also.
300 00:34:07.210 ⇒ 00:34:13.010 Emily Giant: Okay, this is working through
301 00:34:16.310 ⇒ 00:34:18.009 Emily Giant: a FS.
302 00:34:19.310 ⇒ 00:34:22.690 Emily Giant: Affecting scenarios.
303 00:34:29.780 ⇒ 00:34:35.960 Emily Giant: Okay, so my other branch and the one that, like, I’m
304 00:34:36.960 ⇒ 00:34:42.960 Emily Giant: thirsty to get out this week, but like it is not a small endeavor.
305 00:34:44.150 ⇒ 00:34:47.010 Emily Giant: Is the products. Xf replacement.
306 00:34:48.780 ⇒ 00:34:52.210 Emily Giant: We chatted very briefly about this the other day.
307 00:34:52.880 ⇒ 00:34:55.250 Emily Giant: but I’m trying to still like.
308 00:34:56.010 ⇒ 00:34:58.920 Demilade Agboola: They’re both group.
309 00:35:00.270 ⇒ 00:35:01.909 Emily Giant: I figured that out.
310 00:35:02.040 ⇒ 00:35:10.329 Emily Giant: It’s very like. So what I’m gonna do in the future I met with our head of Ecom and was like, show me everything you know about
311 00:35:10.720 ⇒ 00:35:24.714 Emily Giant: product profiles. Yada Yada. In the future. She’s just gonna add the piece product to the upload, because it’s all just like a Csv upload, and it can be as easy as that. So like going forward. That is what she’s gonna do.
312 00:35:25.040 ⇒ 00:35:46.969 Demilade Agboola: Very, very random. I was going to point this out and be part of my recommendations just generally to the urban sense team is, data should not be an afterthought. It feels very much like this as an afterthought in the like, the flow process of how things are going. And it’s like, we just make these moves. And oh, whatever happens to the data happens, I feel like
313 00:35:48.290 ⇒ 00:35:51.559 Demilade Agboola: there needs to be. Hey, we are changing systems.
314 00:35:51.670 ⇒ 00:36:02.589 Demilade Agboola: This is a sample of the this is a test sample of the altitude of this new system. How that work in like building that like there needs to be an integral.
315 00:36:03.030 ⇒ 00:36:12.040 Demilade Agboola: They need to be like data is integral, like, it’s not just an afterthought. And every system they are using or changing or making modifications of will produce data.
316 00:36:12.700 ⇒ 00:36:25.360 Demilade Agboola: So every everyone needs to be in lockstep. It’s not just about hey, opportunity providers, because it’s cheaper, cool. All software team figure out how to integrate. That’s cool. But like, okay, how does the data team also integrate that? Because.
317 00:36:26.340 ⇒ 00:36:33.000 Demilade Agboola: yes, there will be like cascading effects. And I don’t think that’s like considered very often.
318 00:36:33.370 ⇒ 00:36:51.229 Emily Giant: Yeah, not at all. It was not considered at all. That’s why Steven left. He was like one of my best friends at the company, the the old director of Bi. He was great. You really liked him, although he was messy, which you can see in the DVD. Was real messy, but that’s why he left. He was like, I’ll never be able to clean this up.
319 00:36:51.450 ⇒ 00:37:04.700 Emily Giant: We switched to shopify without any notice. He was given like a week to do what I’m still trying to do now, and because it was such an afterthought. So I think that’s something that like that meeting that we have with the analysts
320 00:37:04.860 ⇒ 00:37:12.040 Emily Giant: that we need to like, drive that into every team members head that like we can’t just switch
321 00:37:12.260 ⇒ 00:37:14.299 Emily Giant: softwares and expect
322 00:37:14.450 ⇒ 00:37:22.429 Emily Giant: one person to like be able to keep the boat afloat, like everything that we’re working on is a result of what you’re saying
323 00:37:22.920 ⇒ 00:37:25.860 Emily Giant: that we switched and we didn’t take
324 00:37:26.950 ⇒ 00:37:46.000 Emily Giant: data into consideration. And a lot of times like, I blame vendors because they’ll say like, Well, you don’t need that like. We have all of these great built in reports that you can use, but you know those reports are never good, like they’re never what you need. The out of the box one. So I completely agree with you. You are preaching
325 00:37:46.190 ⇒ 00:37:49.180 Emily Giant: to the choir. I’m just so like
326 00:37:49.960 ⇒ 00:38:04.640 Emily Giant: fried all the time because of how much work I’m doing that I feel like I need someone else to yell at them. I don’t have. I don’t have the bandwidth to be like a prophet for good data, because I’m so in the weeds trying to like
327 00:38:04.860 ⇒ 00:38:11.470 Emily Giant: duct tape Noah’s ark together. So it doesn’t sink that hurts.
328 00:38:12.060 ⇒ 00:38:38.869 Emily Giant: It’s so much. But like I completely agree that all of this is an afterthought, all of the uploads. I’m sure you’ve seen a lot of the Csvs. It’s like, what are we doing here? It’s like a bunch of kids gave like a project to someone they were like, here, fix it and make it usable. And I feel like every time I upload something from a team. I spend half a day like making titles that adhere to our
329 00:38:38.980 ⇒ 00:38:46.560 Emily Giant: like halfway thought through naming conventions. So that’s like, when I
330 00:38:46.880 ⇒ 00:38:59.640 Emily Giant: I essentially was like, we need to hire consultants, or we need to shutter, because, like, we’re in such a bad spot with our data that like without y’all, I don’t know how.
331 00:39:00.040 ⇒ 00:39:04.129 Emily Giant: I don’t know how this could continue for much longer with us, knowing what’s going on.
332 00:39:05.000 ⇒ 00:39:09.420 Emily Giant: Strike that from the record, too. I don’t want that in the zoom notes. Please take that away.
333 00:39:10.430 ⇒ 00:39:11.656 Demilade Agboola: It’s fine.
334 00:39:13.330 ⇒ 00:39:19.230 Demilade Agboola: But yeah, I I agree. I think the the processes are just a bit like strange, and I don’t think
335 00:39:20.710 ⇒ 00:39:25.039 Demilade Agboola: iterating so quickly without having your data team along is is helpful.
336 00:39:25.600 ⇒ 00:39:32.390 Emily Giant: Yeah, it’s really, really, it’s detrimental like to me personally, too, because
337 00:39:32.500 ⇒ 00:39:40.110 Emily Giant: the pressure that comes on me for like fixing something that like unequivocally was not caused by my decisions
338 00:39:40.360 ⇒ 00:39:44.279 Emily Giant: like this. It’s just not fair.
339 00:39:45.483 ⇒ 00:39:49.350 Emily Giant: Okay. So 1st and foremost, how
340 00:39:49.490 ⇒ 00:39:53.300 Emily Giant: should I build the product stuff
341 00:39:53.580 ⇒ 00:39:58.829 Emily Giant: into the mart model, or should I not worry about it until we’re on that step of the
342 00:39:59.280 ⇒ 00:40:04.720 Emily Giant: engagement with Brainforge like, I just don’t want to make it messier than it needs to be.
343 00:40:05.080 ⇒ 00:40:07.479 Demilade Agboola: Yeah, I think, for now we should just keep it this way.
344 00:40:07.480 ⇒ 00:40:07.830 Emily Giant: Okay.
345 00:40:07.830 ⇒ 00:40:08.830 Demilade Agboola: Bottom.
346 00:40:09.360 ⇒ 00:40:27.659 Demilade Agboola: because that would require me having to dive into like the products models and trying to see if it’s a 1 to one mapping, if it’s not a 1 to one mapping, what does that mean? How do we put it in the inventory so that it’s it can get messy, real quick, and so.
347 00:40:28.400 ⇒ 00:40:31.909 Emily Giant: I was feeling that. But I am trying to
348 00:40:33.020 ⇒ 00:40:43.920 Emily Giant: per our combo a couple weeks ago. I’m not using any models anymore that exist. I’m just making new versions of them and putting them into the folders, so that like
349 00:40:44.090 ⇒ 00:40:55.370 Emily Giant: at at least like, if there are net new things that you don’t have to worry that they’re like floating around in some other folder. They should all be right there. In the new model structure.
350 00:40:55.790 ⇒ 00:41:05.239 Emily Giant: So products. Xf, so essentially, I need to plug in the new table to products. Xf.
351 00:41:07.880 ⇒ 00:41:10.050 Emily Giant: and I think that I’m there.
352 00:41:12.330 ⇒ 00:41:17.599 Emily Giant: Outside of some of these like cost upload sheets.
353 00:41:20.700 ⇒ 00:41:22.889 Emily Giant: Okay, product success. And then I’m at.
354 00:41:31.510 ⇒ 00:41:35.550 Emily Giant: It’s 1 of these, anyway, this is the old products. Xf.
355 00:41:37.498 ⇒ 00:41:43.091 Emily Giant: it’s a legacy file which I made a new copy of
356 00:41:44.470 ⇒ 00:41:50.320 Emily Giant: and then basically, like the core product attributes.
357 00:41:52.840 ⇒ 00:42:02.120 Emily Giant: So my my version of it with the shopify data is.
358 00:42:02.970 ⇒ 00:42:12.090 Emily Giant: it’s not one to one because we’re gonna need to use these again for like a the future.
359 00:42:12.260 ⇒ 00:42:18.250 Emily Giant: But essentially, I have a union version of
360 00:42:19.920 ⇒ 00:42:23.849 Emily Giant: like what product Xf was, and I’m I’m unsure
361 00:42:25.100 ⇒ 00:42:28.059 Emily Giant: of how to test it. I just it.
362 00:42:34.590 ⇒ 00:42:35.229 Demilade Agboola: Yeah, yeah.
363 00:42:35.230 ⇒ 00:42:41.610 Emily Giant: I’m just afraid it’s just not gonna work until we knock this whole building down. But I know that’s not productive to say
364 00:42:43.480 ⇒ 00:42:44.980 Demilade Agboola: But basically.
365 00:42:45.210 ⇒ 00:42:54.860 Emily Giant: Dim product union is, for all intents and purposes the same thing as products. Xf.
366 00:42:56.710 ⇒ 00:42:57.779 Emily Giant: And then
367 00:43:01.310 ⇒ 00:43:04.650 Emily Giant: this would be the 1st place that I need to plug it in.
368 00:43:08.500 ⇒ 00:43:14.600 Emily Giant: Should I just say like F it, and like, put the reference here, or
369 00:43:14.770 ⇒ 00:43:22.059 Emily Giant: like, what’s the best thing to do in this scenario, where I’m just like completely blasting out an old
370 00:43:22.620 ⇒ 00:43:23.920 Emily Giant: core model.
371 00:43:25.900 ⇒ 00:43:29.470 Demilade Agboola: Oh, I think you need to check that. The the models match
372 00:43:30.540 ⇒ 00:43:37.790 Demilade Agboola: like we don’t have any disparities, because and the names are the same, because if you just pour, put in a new model
373 00:43:38.730 ⇒ 00:43:45.999 Demilade Agboola: and names don’t match, it will break down. It will break the downstream dependencies, and you would have a lot of issues with your models.
374 00:43:47.370 ⇒ 00:43:48.270 Emily Giant: Okay?
375 00:43:49.490 ⇒ 00:43:54.330 Emily Giant: So I guess I would just run products Xf, and then run
376 00:43:55.840 ⇒ 00:43:59.840 Emily Giant: product union, make sure that all the columns are exactly the same.
377 00:44:03.629 ⇒ 00:44:08.390 Demilade Agboola: Effectively. Yes, I think it’ll be important to
378 00:44:09.350 ⇒ 00:44:13.910 Demilade Agboola: just be sure that the entrepreneurs are fine, and that we can
379 00:44:14.504 ⇒ 00:44:18.196 Demilade Agboola: figure out what is broken or what has changed so that we can.
380 00:44:18.600 ⇒ 00:44:20.390 Demilade Agboola: you know, work our way around it.
381 00:44:22.590 ⇒ 00:44:31.900 Demilade Agboola: And also, like the obviously the same data quality is is the same like, you know, same number of rows. Settings. Queues are not missing that sort of stuff.
382 00:44:32.420 ⇒ 00:44:34.370 Emily Giant: Yeah, that’s
383 00:44:37.940 ⇒ 00:44:42.119 Emily Giant: a thing for sure. Okay? Products. Xf, and then
384 00:44:49.850 ⇒ 00:44:52.250 Emily Giant: what’s this called dim product genius?
385 00:44:56.120 ⇒ 00:45:03.959 Emily Giant: And then should I rename this? The Dim Product Union. I read an article on like what should be dimension. There’s no logic in this.
386 00:45:04.130 ⇒ 00:45:10.500 Emily Giant: It’s just like a table full of.
387 00:45:11.340 ⇒ 00:45:14.970 Emily Giant: It’s just a Union table, so I don’t know.
388 00:45:14.970 ⇒ 00:45:18.460 Demilade Agboola: Means the product is the product information, isn’t it?
389 00:45:18.800 ⇒ 00:45:19.370 Emily Giant: Yeah.
390 00:45:19.870 ⇒ 00:45:24.479 Demilade Agboola: And it’s the product information that will get joined to like the orders. Information.
391 00:45:25.600 ⇒ 00:45:27.450 Demilade Agboola: Yeah. So it’s, it’s a dimension.
392 00:45:28.540 ⇒ 00:45:30.869 Emily Giant: So that’s the correct categorization.
393 00:45:31.650 ⇒ 00:45:33.814 Emily Giant: Okay? Good alright.
394 00:45:36.371 ⇒ 00:45:40.310 Emily Giant: God! I know that we can change the naming conventions later. But I like
395 00:45:43.370 ⇒ 00:45:51.420 Emily Giant: hate the old naming conventions. You can tell that, like all of our data was made really, really quickly, or all the tables, because they’re like
396 00:45:52.260 ⇒ 00:46:04.729 Emily Giant: constantly trying to adhere like Booleans to like a 0 or one system. And it’s just because in the past that’s how it was done, not because that’s how it should be done. There’s just so many things like that that
397 00:46:05.260 ⇒ 00:46:07.660 Emily Giant: need to be cleaned up.
398 00:46:09.360 ⇒ 00:46:12.210 Emily Giant: This is products. Xf.
399 00:46:26.430 ⇒ 00:46:31.440 Emily Giant: so this is a sample of that and then dim
400 00:46:44.570 ⇒ 00:46:46.880 Emily Giant: them. Product union.
401 00:47:34.010 ⇒ 00:47:38.980 Emily Giant: All right. So would a good move be to like, transpose like.
402 00:47:40.160 ⇒ 00:47:46.120 Emily Giant: if products Xf titles are here and then dem union.
403 00:47:46.810 ⇒ 00:47:47.700 Emily Giant: Okay?
404 00:48:04.050 ⇒ 00:48:06.239 Emily Giant: Oh, that that sure didn’t work, did it?
405 00:48:08.830 ⇒ 00:48:10.505 Emily Giant: What did I just do?
406 00:48:12.340 ⇒ 00:48:13.260 Emily Giant: Oh, wait!
407 00:48:19.840 ⇒ 00:48:25.830 Emily Giant: Pose this through this there. Okay.
408 00:48:34.780 ⇒ 00:48:37.850 Emily Giant: so these are our 2 tables.
409 00:48:39.680 ⇒ 00:48:40.550 Demilade Agboola: Yeah.
410 00:48:47.250 ⇒ 00:48:50.940 Emily Giant: Okay, table source. All right. So what I would do is go through.
411 00:48:52.270 ⇒ 00:48:59.157 Emily Giant: Make sure that they like this obviously has, like more columns from the get. So that’s not encouraging.
412 00:49:02.300 ⇒ 00:49:06.679 Emily Giant: just make sure that these match, title, etc.
413 00:49:06.890 ⇒ 00:49:11.670 Emily Giant: Gosh, okay. So in your opinion, would it be better
414 00:49:12.380 ⇒ 00:49:19.629 Emily Giant: to leave the table that we intend to use in the future and make a new one that’s like
415 00:49:20.100 ⇒ 00:49:25.450 Emily Giant: disposable or like, stand in products. Xf.
416 00:49:25.980 ⇒ 00:49:32.470 Emily Giant: and then leave this one untouched, so that I’m cause this one is better. It’s
417 00:49:32.590 ⇒ 00:49:37.189 Emily Giant: cleaner, better version of products. Xf. But it isn’t going to be able to be just slotted in.
418 00:49:42.600 ⇒ 00:49:48.700 Demilade Agboola: I mean, it will be important to see like products, access, lineage way. It’s being used.
419 00:49:49.742 ⇒ 00:50:00.470 Demilade Agboola: So we can list that out and just kind of have an idea of what dependencies it needs to provide. So in terms of what names certain columns need to have the data, he also needs to have
420 00:50:00.570 ⇒ 00:50:02.680 Demilade Agboola: things of that nature.
421 00:50:03.510 ⇒ 00:50:06.900 Emily Giant: It’s in like every single downstream
422 00:50:07.800 ⇒ 00:50:11.009 Emily Giant: model, it’s using everything that we use.
423 00:50:14.120 ⇒ 00:50:17.809 Emily Giant: So you, you’re saying, do the lineage
424 00:50:21.140 ⇒ 00:50:24.200 Emily Giant: products except.
425 00:50:24.200 ⇒ 00:50:32.169 Demilade Agboola: If you go to Dbt, and just kind of click on it, you can see the lineage. But also there might be possibilities being used outside Dbt. And looker.
426 00:50:32.520 ⇒ 00:50:35.780 Emily Giant: Yeah, it’s used constantly in Looker.
427 00:50:35.780 ⇒ 00:50:39.131 Demilade Agboola: That’s also another thing to think about.
428 00:50:45.390 ⇒ 00:50:46.170 Emily Giant: Yeah, come on.
429 00:50:48.350 ⇒ 00:50:49.240 Emily Giant: Okay.
430 00:50:55.210 ⇒ 00:50:56.130 Emily Giant: yeah.
431 00:50:56.630 ⇒ 00:50:58.159 Emily Giant: All right. So
432 00:51:03.150 ⇒ 00:51:11.450 Emily Giant: knowing that it’s used like, okay, these are all deprecated. So I don’t care about those. I care about oms, items, Oms.
433 00:51:11.730 ⇒ 00:51:16.340 Emily Giant: transaction component speeder. Which, like, what does that even mean?
434 00:51:16.530 ⇒ 00:51:18.919 Emily Giant: Is this some kind of naming convention?
435 00:51:19.080 ⇒ 00:51:21.429 Emily Giant: Because that title makes me nervous.
436 00:51:23.820 ⇒ 00:51:30.939 Demilade Agboola: I have no idea to be honest. I like I haven’t worked with that, so I’m not sure what it was. What it’s trying to convey.
437 00:51:31.860 ⇒ 00:51:36.460 Emily Giant: Me neither component base kits. Kits.
438 00:51:37.893 ⇒ 00:51:39.220 Emily Giant: Yeah. Okay.
439 00:51:40.990 ⇒ 00:51:44.253 Emily Giant: So can you say again what I’m supposed to do
440 00:51:45.060 ⇒ 00:51:47.290 Emily Giant: or what you would recommend doing rather.
441 00:51:47.826 ⇒ 00:51:54.639 Demilade Agboola: So for this I think it would just be important to find out, like as many dependencies as you can figure out like
442 00:51:55.816 ⇒ 00:51:59.780 Demilade Agboola: these are the downstream, the models downstream of products. Xf,
443 00:52:02.390 ⇒ 00:52:05.680 Demilade Agboola: and then so that allows us to know the like.
444 00:52:06.510 ⇒ 00:52:12.835 Demilade Agboola: the damage radius. Basically, if we just switched out also,
445 00:52:14.390 ⇒ 00:52:18.770 Demilade Agboola: figure out so like going to those different like dependencies and
446 00:52:19.460 ⇒ 00:52:23.339 Demilade Agboola: replacing it with this new logic. But we also need to look at the
447 00:52:23.750 ⇒ 00:52:30.470 Demilade Agboola: lift required to do that, because we also need to know, like what column names, for instance, what data types are required.
448 00:52:30.570 ⇒ 00:52:32.580 Demilade Agboola: And once we have that
449 00:52:33.050 ⇒ 00:52:37.960 Demilade Agboola: we can then start the process to deprecate and then switch it with the new one.
450 00:52:38.670 ⇒ 00:52:39.330 Emily Giant: Okay?
451 00:52:42.810 ⇒ 00:52:47.000 Emily Giant: It’s right field types aligned.
452 00:52:52.450 ⇒ 00:52:53.290 Emily Giant: Okay?
453 00:52:55.630 ⇒ 00:52:56.830 Emily Giant: So
454 00:52:58.640 ⇒ 00:53:09.760 Emily Giant: just for visibility, these are the most broken of all the models. Because of the migration. It’s not
455 00:53:10.500 ⇒ 00:53:29.049 Emily Giant: the logic it used to work when we switched. That’s when we no longer had a table with clean component level data. It was mixing in orders with the kits and the component skews all got mixed together. So this
456 00:53:29.320 ⇒ 00:53:38.990 Emily Giant: section that we’re updating products. Xf is the problem like this is the volcano.
457 00:53:38.990 ⇒ 00:53:43.250 Demilade Agboola: Is it possible, is it possible that a good product Xf table will
458 00:53:43.530 ⇒ 00:53:46.280 Demilade Agboola: possibly deprecate some of these tables as well.
459 00:53:46.680 ⇒ 00:53:50.899 Emily Giant: Yeah, yeah, it will help a lot.
460 00:53:51.540 ⇒ 00:53:52.170 Demilade Agboola: Yeah. So
461 00:53:52.290 ⇒ 00:53:56.570 Demilade Agboola: I think one of the part of reasons why, like even we build out some of these things is
462 00:53:57.345 ⇒ 00:54:00.809 Demilade Agboola: I think, being able to just know.
463 00:54:01.210 ⇒ 00:54:05.410 Demilade Agboola: like, have intuitive models is is very important.
464 00:54:05.850 ⇒ 00:54:17.259 Demilade Agboola: because that, like you shouldn’t be asking questions about inventory transaction component speed, or what that means it should just be intuitive like. And I think there’s a lack of intuitive building with
465 00:54:18.060 ⇒ 00:54:22.330 Demilade Agboola: like what whatever the hell is going on? So.
466 00:54:22.330 ⇒ 00:54:22.950 Emily Giant: Okay.
467 00:54:23.320 ⇒ 00:54:25.910 Demilade Agboola: Yeah, like, honestly, it’s just really bad modeling.
468 00:54:26.080 ⇒ 00:54:27.100 Emily Giant: What is this?
469 00:54:27.380 ⇒ 00:54:28.630 Demilade Agboola: So just being able to.
470 00:54:28.630 ⇒ 00:54:30.109 Emily Giant: Yeah. Sorry. Go ahead.
471 00:54:30.110 ⇒ 00:54:32.249 Demilade Agboola: Just been able to like, define
472 00:54:32.900 ⇒ 00:54:57.219 Demilade Agboola: things from the base up where we’re like, okay, so this is what this means. This is where all our refunds are happening. This is where all the products that you know information is, this is where only certain types of products are put together. Like it allows for better understanding of like what is going on. This is where our adjustments are, and because we know where adjustments are, we can easily like trace the path
473 00:54:57.370 ⇒ 00:55:15.490 Demilade Agboola: from adjustments to like our inventory or from our adjustments to so like, it’s very clear what’s going on. I think, right now, there’s just so much going on, and there’s so many like random tables where, like a bunch of random aggregations are going on, and unless you were the one who built it. You probably have no idea what that means or what’s going on.
474 00:55:15.750 ⇒ 00:55:19.470 Emily Giant: Yeah, yeah, I agree. It’s a 7 headed dragon.
475 00:55:19.610 ⇒ 00:55:23.299 Emily Giant: Alright. So I will. I’ll make a ticket.
476 00:55:23.480 ⇒ 00:55:25.869 Demilade Agboola: So that y’all know what I’m up to.
477 00:55:26.180 ⇒ 00:55:29.980 Emily Giant: About mapping products. Xf lineage.
478 00:55:31.340 ⇒ 00:55:33.899 Emily Giant: I might even already have one, but.
479 00:55:34.010 ⇒ 00:55:39.519 Demilade Agboola: I think we would also need to like figure out like the
480 00:55:40.000 ⇒ 00:55:45.010 Demilade Agboola: because I mean, obviously, the focus now is at least my focus. Now is inventory.
481 00:55:45.780 ⇒ 00:55:49.919 Demilade Agboola: For how long we’ll we’ll see. We’ll see.
482 00:55:50.760 ⇒ 00:56:02.750 Emily Giant: Yeah, this is just like a p 1 ticket, because products no longer have like names and looker. And that’s why I need to swap it out as soon as possible, because nobody even knows like what’s selling if it’s a new skew.
483 00:56:03.410 ⇒ 00:56:04.170 Demilade Agboola: Oh, okay.
484 00:56:05.274 ⇒ 00:56:09.570 Emily Giant: So the work is mostly done. It’s just not
485 00:56:10.050 ⇒ 00:56:17.680 Emily Giant: the work that needs to be done to make it perfect. So it’s like intermediate duct tape work.
486 00:56:18.550 ⇒ 00:56:19.279 Demilade Agboola: Fair enough.
487 00:56:19.280 ⇒ 00:56:22.700 Emily Giant: I might as well do the work while doing this
488 00:56:23.020 ⇒ 00:56:30.769 Emily Giant: to set us up for the moment when we’re working on component data and products. Xf, so at least like, get us into a
489 00:56:30.990 ⇒ 00:56:45.680 Emily Giant: decent place for like future work. All right. So this is actually in progress. So products Xf lineage mapping.
490 00:56:57.270 ⇒ 00:57:05.480 Emily Giant: I never did figure out the tag thing. By the way, I figured out the like parent child skew connection. But
491 00:57:05.860 ⇒ 00:57:13.140 Emily Giant: I think that you’re right, that because it wasn’t like a typical Json structure.
492 00:57:13.310 ⇒ 00:57:21.780 Emily Giant: I couldn’t even use rejects or rejects. However, you say it to extract anything from that. So like, I’m not sure if it’s
493 00:57:22.210 ⇒ 00:57:28.560 Emily Giant: our version of redshift, or if it’s that mode, can’t do it. And I need a different SQL. Runner.
494 00:57:29.990 ⇒ 00:57:34.424 Demilade Agboola: Oh, no, it’s definitely not a mode team mode is just like an intermediary.
495 00:57:34.990 ⇒ 00:57:43.780 Demilade Agboola: Ultimately, I think that is the the that that column isn’t reject. Isn’t sorry, isn’t Json.
496 00:57:44.230 ⇒ 00:57:44.880 Emily Giant: And.
497 00:57:45.296 ⇒ 00:57:47.379 Demilade Agboola: Texts like a regular text.
498 00:57:47.380 ⇒ 00:57:51.410 Demilade Agboola: Yeah, but it’s just it’s it’s weird. It’s
499 00:57:52.440 ⇒ 00:58:00.440 Demilade Agboola: I don’t know. I think it will probably come from the source, or like, we might need to like trace what’s going on upstream of it.
500 00:58:00.904 ⇒ 00:58:07.919 Demilade Agboola: But yeah, it should be a Json, a regular Json, because if it’s a Json it would literally just be much, much easier.
501 00:58:08.940 ⇒ 00:58:09.740 Emily Giant: Yeah.
502 00:58:10.898 ⇒ 00:58:19.271 Emily Giant: Is there a way that I could? It’s in Hevo, and I can manipulate how things are ingested in hevo a little bit
503 00:58:22.090 ⇒ 00:58:23.790 Emily Giant: Are you familiar with Hevo?
504 00:58:24.660 ⇒ 00:58:26.319 Emily Giant: It’s pretty bad.
505 00:58:26.550 ⇒ 00:58:34.940 Emily Giant: It’s pretty bad, but I do think that I could maybe change the type.
506 00:58:40.530 ⇒ 00:58:41.970 Emily Giant: It’s this
507 00:58:47.290 ⇒ 00:58:55.110 Emily Giant: I can do like transformations in Hevo and that it’s in this products table.
508 00:58:58.070 ⇒ 00:58:58.800 Emily Giant: Like
509 00:59:02.200 ⇒ 00:59:04.429 Emily Giant: you can edit the mapping.
510 00:59:05.110 ⇒ 00:59:06.510 Emily Giant: It’s product tags.
511 00:59:06.510 ⇒ 00:59:08.759 Demilade Agboola: Yes, far. It’s right there.
512 00:59:09.200 ⇒ 00:59:13.185 Emily Giant: Yeah, this is also the old table. This is the one that I
513 00:59:14.170 ⇒ 00:59:17.290 Emily Giant: that stopped working entirely, and I should just turn it off.
514 00:59:17.520 ⇒ 00:59:18.420 Demilade Agboola: Okay.
515 00:59:22.650 ⇒ 00:59:24.740 Emily Giant: Tags. Jason, yeah.
516 00:59:32.060 ⇒ 00:59:36.229 Demilade Agboola: But before the 1st one that showed was tags was voucher, not Jason.
517 00:59:36.520 ⇒ 00:59:42.439 Emily Giant: Yeah. And then that table is what shopify stopped supporting.
518 00:59:42.670 ⇒ 00:59:45.360 Emily Giant: And so I have to swap this one in.
519 00:59:45.670 ⇒ 00:59:47.539 Emily Giant: And they changed it.
520 00:59:48.090 ⇒ 00:59:49.100 Demilade Agboola: Oh, okay.
521 00:59:51.510 ⇒ 00:59:58.880 Emily Giant: And like these, Json fields are actually in the curly brackets.
522 00:59:59.210 ⇒ 01:00:01.620 Emily Giant: They’re like correctly structured.
523 01:00:01.760 ⇒ 01:00:05.179 Emily Giant: And then this one, just like randomly, isn’t.
524 01:00:08.824 ⇒ 01:00:10.949 Demilade Agboola: That’s weird. That’s very, very weird.
525 01:00:11.271 ⇒ 01:00:21.868 Emily Giant: I hate it all right. I gotta go. I have a 10 o’clock meeting, but I’ll see you at 1030. I’m making the ticket for products Xf, the lineage mapping and
526 01:00:23.140 ⇒ 01:00:32.109 Emily Giant: I mean, realistically, I’m not going to finish that today, but I probably will send through the Pr tonight if I’m able to get through it.
527 01:00:32.810 ⇒ 01:00:34.039 Demilade Agboola: Okay. Sounds good.
528 01:00:34.260 ⇒ 01:00:36.369 Emily Giant: Alright. Thank you. Talk to you soon.