Meeting Title: Inventory and Orders Sync Date: 2025-07-01 Meeting participants: Demilade Agboola, Emily Giant
WEBVTT
1 00:01:12.530 ⇒ 00:01:13.490 Emily Giant: Hey!
2 00:01:16.020 ⇒ 00:01:17.390 Demilade Agboola: Hi, Emily, how are you?
3 00:01:17.950 ⇒ 00:01:20.490 Emily Giant: Good. I don’t know what’s going on with my camera. Hold on
4 00:01:22.190 ⇒ 00:01:27.409 Emily Giant: good! I got some much needed days off, so done
5 00:01:27.550 ⇒ 00:01:34.869 Emily Giant: got poison ivy got on steroids. So now I’m real productive. How are you doing.
6 00:01:35.855 ⇒ 00:01:40.890 Demilade Agboola: I’m doing all right. I was a bit under the weather yesterday, but I’m I’m much better today.
7 00:01:41.490 ⇒ 00:01:44.960 Emily Giant: I’m sorry, just like regular summer cold.
8 00:01:45.230 ⇒ 00:01:53.832 Demilade Agboola: Funny enough. No, it was nausea and a headache, so like I was trying to look at my screen. And I’m like, this can’t work this definitely.
9 00:01:54.340 ⇒ 00:01:54.890 Demilade Agboola: So.
10 00:01:54.890 ⇒ 00:01:56.290 Emily Giant: You just gotta call it.
11 00:01:57.140 ⇒ 00:01:57.990 Demilade Agboola: Yeah.
12 00:01:57.990 ⇒ 00:02:02.780 Emily Giant: Yeah, I I hate that when I like, don’t have a planned day off. And I’m like this.
13 00:02:03.000 ⇒ 00:02:10.619 Emily Giant: this is not gonna work. So might as well well, that’s kind of good, I mean. At least we were off on the same days somewhat
14 00:02:10.759 ⇒ 00:02:14.287 Emily Giant: so that I wasn’t being a blocker to you.
15 00:02:14.640 ⇒ 00:02:17.350 Demilade Agboola: Oh, no, that’s that’s fine. It’s fine, like.
16 00:02:17.880 ⇒ 00:02:22.750 Demilade Agboola: I mean, obviously. I wish I wasn’t ill, but like it sometimes it just is what it is, you know.
17 00:02:23.510 ⇒ 00:02:24.200 Emily Giant: Yeah.
18 00:02:24.660 ⇒ 00:02:31.810 Emily Giant: tis true. See if you can see my poison ivy at all like I just do you ever have you ever had poison? Ivy.
19 00:02:31.810 ⇒ 00:02:32.150 Demilade Agboola: No.
20 00:02:32.660 ⇒ 00:02:40.879 Emily Giant: Oh, it’s so annoying! It’s so annoying like it can be fine during the day. But as soon as you lay down to sleep you’re like
21 00:02:40.970 ⇒ 00:03:05.489 Emily Giant: it just itches like crazy, and you can’t sleep. So I I get it every year because I’m really allergic to it, even though I like wear long sleeves and gardening gloves, and like I cover everything. It does not matter like if I look at it, I get it so I’m on steroids to just like knock it out, because all the other years I tried to let it go away on its own with like not scratching it, and it will last for 2 months, and I’m just like covered. So if I.
22 00:03:05.940 ⇒ 00:03:09.849 Demilade Agboola: I think, like any ointments that help not like, make you itch.
23 00:03:11.398 ⇒ 00:03:12.970 Emily Giant: where is it.
24 00:03:14.500 ⇒ 00:03:15.390 Demilade Agboola: Oh, okay.
25 00:03:16.230 ⇒ 00:03:30.319 Emily Giant: Hydrocortisone. You can put it on. It will help for like 2 h, but when you fall asleep I’ll take like 2 benadryl to knock me out, because that usually makes me sleep, and after 1 h I’ll wake up. It just doesn’t matter. There’s nothing I could do about it, so
26 00:03:30.430 ⇒ 00:03:47.600 Emily Giant: the steroids will help me not be dumb. So I’m like trying to even out my lack of sleep with like artificial strength and wellness from medicine. But it’s never. It’s never a fun time. I just needed to weed my yard so bad. And now I’m like
27 00:03:48.200 ⇒ 00:04:12.610 Emily Giant: not supposed to go outside during the day. But anyway, I’m looking through my messages from being off for 2 days, and there’s like a good mix of like, thank you for fixing liquor, and I’m like I didn’t do that. And other ones that are like orders are still showing $0 for 300 orders, which was what was on my agenda today, but I wanted to do whatever you need first, st to make sure that you’re in a good spot for inventory.
28 00:04:13.130 ⇒ 00:04:16.269 Emily Giant: since that’s where we’re at this week.
29 00:04:16.540 ⇒ 00:04:22.999 Emily Giant: But after that, maybe take a look at that. This report that Perry sent me. I’ll throw it in the chat.
30 00:04:24.920 ⇒ 00:04:28.730 Emily Giant: because I really I think it’s just like a refresh issue.
31 00:04:29.330 ⇒ 00:04:31.860 Emily Giant: or maybe not because I thought I fixed.
32 00:04:32.090 ⇒ 00:04:39.100 Emily Giant: I thought you fixed that. And then I I did went back and like Reran a refresh, and it still didn’t fix it so it might be something else.
33 00:04:39.100 ⇒ 00:04:46.079 Demilade Agboola: Yeah. So I was going to ask you, I was. I didn’t want to message you while you were out of office about it. I was gonna ask you if
34 00:04:46.765 ⇒ 00:04:51.550 Demilade Agboola: every order has to have a subscription id associated with it.
35 00:04:52.990 ⇒ 00:05:03.280 Emily Giant: No, no! Oh, well, every subscription order is supposed to. But there was a period of time where it was broken during the migration, where several 100
36 00:05:03.600 ⇒ 00:05:06.209 Emily Giant: were sent that never
37 00:05:06.360 ⇒ 00:05:11.659 Emily Giant: got the subscription Id and Alex was gonna backfill it. But I think what I need to do
38 00:05:12.050 ⇒ 00:05:13.419 Emily Giant: is for those
39 00:05:14.058 ⇒ 00:05:24.740 Emily Giant: just like make a seed file that has the fill in ids, or something like that, because I can’t figure out a way to get those to correctly backfill.
40 00:05:25.335 ⇒ 00:05:26.930 Demilade Agboola: The reason why I ask that.
41 00:05:26.930 ⇒ 00:05:27.490 Emily Giant: Thank you.
42 00:05:28.250 ⇒ 00:05:36.750 Demilade Agboola: It appears like the the pardon
43 00:05:38.160 ⇒ 00:05:41.859 Demilade Agboola: cause I I was looking at some of the orders, and the app is like the
44 00:05:44.540 ⇒ 00:05:49.330 Demilade Agboola: the orders. Information is coming from subscription to loop excess.
45 00:05:49.750 ⇒ 00:05:50.370 Emily Giant: Yeah.
46 00:05:52.789 ⇒ 00:05:53.439 Demilade Agboola: Alright.
47 00:05:53.840 ⇒ 00:05:57.000 Demilade Agboola: So I was wondering, because we’re joining in back to
48 00:05:58.280 ⇒ 00:06:03.130 Demilade Agboola: we’re joining back on the user id on the subscription id to subscription number.
49 00:06:04.620 ⇒ 00:06:08.710 Demilade Agboola: Like, if it doesn’t have cause like what the problem is, it’s actually just going null.
50 00:06:09.130 ⇒ 00:06:14.030 Demilade Agboola: So I compiled it. That’s why I say, that’s why I was thinking like a refresh will not work, because I’m using.
51 00:06:14.030 ⇒ 00:06:14.600 Emily Giant: Hmm.
52 00:06:14.600 ⇒ 00:06:16.790 Demilade Agboola: Tyling it and running it as like sequel.
53 00:06:16.790 ⇒ 00:06:18.530 Emily Giant: Yeah, yeah.
54 00:06:18.530 ⇒ 00:06:23.700 Demilade Agboola: My refresh issue, and we’re having the same like, it’s just coming out as no. So that means.
55 00:06:23.700 ⇒ 00:06:26.680 Emily Giant: Okay, then it then it’s not a refresh.
56 00:06:26.680 ⇒ 00:06:28.499 Demilade Agboola: A logic issue somewhere.
57 00:06:28.500 ⇒ 00:06:29.200 Emily Giant: Yep.
58 00:06:29.200 ⇒ 00:06:33.309 Demilade Agboola: So that’s why I was asking about. That’s wanted to ask you about the subscription like.
59 00:06:33.560 ⇒ 00:06:41.199 Demilade Agboola: because if the subscription Id, if the subscription Id is null, and he does the join. Then when he tries to get like revenue and stuff, it will just be.
60 00:06:41.660 ⇒ 00:06:47.700 Emily Giant: No, okay. So the item total is where that’s happening. And it’s saying, like.
61 00:06:48.260 ⇒ 00:06:50.050 Demilade Agboola: No revenue. No, I don’t.
62 00:06:50.050 ⇒ 00:06:53.969 Emily Giant: Oh, it’s coalescing! I got you! That’s what it’s doing.
63 00:06:53.970 ⇒ 00:06:54.480 Demilade Agboola: Yeah.
64 00:06:54.480 ⇒ 00:07:01.160 Emily Giant: You know, pulling null, it’s like coalescing and getting a 0. So it’s pulling the 0 because 0 is the value. Is that what you’re saying?
65 00:07:01.370 ⇒ 00:07:04.910 Demilade Agboola: Yeah. So I’m saying, like, higher up in the models where it gets
66 00:07:05.150 ⇒ 00:07:09.231 Demilade Agboola: so that start to trans translate downwards to all the
67 00:07:09.850 ⇒ 00:07:15.510 Demilade Agboola: the downstream models. And obviously, if something hits Looker, it’s just going to turn that null value to 0.
68 00:07:15.790 ⇒ 00:07:16.500 Emily Giant: Right.
69 00:07:16.770 ⇒ 00:07:21.620 Demilade Agboola: But the idea is we need to figure out where cause like, I said, the the idea.
70 00:07:21.864 ⇒ 00:07:26.020 Emily Giant: Know exactly where it is, so I’m pretty sure I know exactly where it’s in Oms suborders.
71 00:07:26.390 ⇒ 00:07:31.649 Emily Giant: because I had to mess. I messed with that logic last week and changed it back to a previous version.
72 00:07:32.650 ⇒ 00:07:40.250 Emily Giant: And if this is a new problem that they’re seeing it was, it’s in Oms suborders, and it’s called item total.
73 00:07:40.950 ⇒ 00:07:43.870 Emily Giant: I’ll show you if you don’t already have it pulled up here.
74 00:07:45.040 ⇒ 00:07:48.203 Demilade Agboola: Yeah. So I got into like one of my sub borders. And I was trying to like
75 00:07:48.930 ⇒ 00:07:52.644 Demilade Agboola: after that point, just like, okay, let me reach out literally had the draft.
76 00:07:52.910 ⇒ 00:08:05.590 Emily Giant: It’s better to just. It’s 1 of those things where you could spend an entire day tracking it down, or just I can tell you where every single revenue calculation is in this like with my eyes closed. Where is screen share? Here we go.
77 00:08:06.720 ⇒ 00:08:16.552 Emily Giant: So I think you’re right. It’s funny that you say that, because, like, I literally changed it last week back to what I thought was like a more secure version of
78 00:08:17.090 ⇒ 00:08:32.710 Emily Giant: having it not do that? And I think it actually made it worse, and I tested it, and it seemed fine in my instance. But again, I have that thing where, when I test my local, it doesn’t always translate right away. So I have to compile now like, I’ve learned my lesson that I can’t use
79 00:08:33.130 ⇒ 00:08:37.669 Emily Giant: a reference anymore. I have to compile, but it gets very annoying.
80 00:08:38.150 ⇒ 00:08:45.090 Emily Giant: The more downstream I get because we don’t always have like a table setup.
81 00:08:45.370 ⇒ 00:08:48.169 Emily Giant: Okay? So in oms suborders.
82 00:08:52.540 ⇒ 00:09:02.289 Emily Giant: that is, downstream of loop oms, redeliveries, oms sub orders, oms orders, which is where the subscription id comes from. Well, technically it comes from
83 00:09:03.150 ⇒ 00:09:04.890 Emily Giant: the loop one.
84 00:09:05.300 ⇒ 00:09:07.595 Emily Giant: But alright.
85 00:09:12.310 ⇒ 00:09:14.559 Emily Giant: but I think it’s the coalesce business
86 00:09:15.130 ⇒ 00:09:19.570 Emily Giant: that it sounds like. That must be what’s happening, because it’s like a null. If.
87 00:09:20.920 ⇒ 00:09:30.049 Demilade Agboola: Yeah. But yes, my, my point is, if it’s bringing in a null value, like if the join doesn’t work properly, it’s going to just be null value right? There.
88 00:09:30.420 ⇒ 00:09:31.300 Emily Giant: Yeah.
89 00:09:31.300 ⇒ 00:09:35.100 Demilade Agboola: Need to be sure that what we’re bringing in I mean.
90 00:09:36.480 ⇒ 00:09:41.640 Emily Giant: It’s this line 4, 22, through 4, 36.
91 00:09:41.640 ⇒ 00:09:48.589 Demilade Agboola: Exactly, but like everything that the every value we’re calculating is is a function of the subscription.
92 00:09:50.100 ⇒ 00:09:51.829 Emily Giant: Oh, that’s not supposed to be the case.
93 00:09:52.080 ⇒ 00:09:56.539 Demilade Agboola: Let me see. So what do you call us? This divided by this? On this?
94 00:09:57.090 ⇒ 00:10:00.850 Demilade Agboola: So case one is greater than not in here.
95 00:10:05.270 ⇒ 00:10:09.960 Demilade Agboola: Then T. Center point s else orders.
96 00:10:11.330 ⇒ 00:10:12.730 Demilade Agboola: So let me.
97 00:10:16.700 ⇒ 00:10:20.640 Demilade Agboola: I close my stuff for the weekend.
98 00:10:20.950 ⇒ 00:10:24.910 Demilade Agboola: But oof let me open my redshift.
99 00:10:25.630 ⇒ 00:10:26.170 Emily Giant: Okay.
100 00:10:27.310 ⇒ 00:10:29.320 Demilade Agboola: I was doing some stuff there.
101 00:11:14.360 ⇒ 00:11:16.879 Demilade Agboola: Okay, to right shift now.
102 00:11:37.860 ⇒ 00:11:40.999 Demilade Agboola: So I just kept going upstream trying not finding my queries.
103 00:11:41.300 ⇒ 00:11:46.720 Demilade Agboola: Kind of went upstream, and then.
104 00:11:47.400 ⇒ 00:11:48.230 Emily Giant: Nice.
105 00:11:48.490 ⇒ 00:11:50.700 Emily Giant: Let me pull up Perry’s report here.
106 00:11:51.420 ⇒ 00:11:53.330 Demilade Agboola: Yes, fine!
107 00:13:02.610 ⇒ 00:13:05.277 Emily Giant: Oh, this. But that was just in the last week. Okay.
108 00:13:26.460 ⇒ 00:13:28.280 Emily Giant: have you watched squid game?
109 00:13:29.430 ⇒ 00:13:31.340 Demilade Agboola: Oh, no! Heard about it.
110 00:13:31.740 ⇒ 00:13:34.559 Emily Giant: Super violent. So if you’re not into like.
111 00:13:34.770 ⇒ 00:13:44.250 Emily Giant: if you don’t like extreme violence, then skip it. But they came out the last season like yesterday, and.
112 00:13:44.530 ⇒ 00:13:47.780 Demilade Agboola: I think it will say that it’s it’s trash, basically.
113 00:13:47.780 ⇒ 00:13:54.478 Emily Giant: Yeah. Oh, yeah. Oh, yeah. But it’s also like the best kind of trash.
114 00:13:55.950 ⇒ 00:14:01.509 Demilade Agboola: No like that. This this particular season wasn’t like it wasn’t the best like season. One.
115 00:14:02.780 ⇒ 00:14:07.399 Emily Giant: Yeah, there, there are moments where, like, they’re running around
116 00:14:07.720 ⇒ 00:14:14.870 Emily Giant: from people who are like trying to kill them. And they’re just like having casual conversations about their past, and it’s like, What what are we doing?
117 00:14:15.220 ⇒ 00:14:21.270 Emily Giant: Alright. So this says it didn’t load any results. Oh, that’s because that’s the order. Id. Sorry.
118 00:14:23.140 ⇒ 00:14:24.460 Emily Giant: That’ll do it
119 00:14:54.350 ⇒ 00:15:01.080 Emily Giant: all right. So this is the 1st revenue. Calculation and item, quantity and order subtotal is what’s used
120 00:15:01.400 ⇒ 00:15:02.820 Emily Giant: like downstream.
121 00:15:04.850 ⇒ 00:15:06.619 Emily Giant: So probably should have just put that
122 00:15:22.940 ⇒ 00:15:26.100 Emily Giant: it is a redelivery. So this should be $0.
123 00:15:27.680 ⇒ 00:15:32.129 Emily Giant: Are these all the race? Okay, that’s interesting.
124 00:15:33.380 ⇒ 00:15:34.780 Demilade Agboola: Are they already delivered.
125 00:15:35.490 ⇒ 00:15:37.090 Emily Giant: They might be hold on.
126 00:15:38.810 ⇒ 00:15:54.224 Emily Giant: in which case this is working well, but they should automatically be marked as not revenue generating. And so somewhere else. That’s not right, and 300 is like my benchmark for every week. Of how many redeliveries are.
127 00:15:55.240 ⇒ 00:15:56.740 Emily Giant: usually sent.
128 00:15:57.340 ⇒ 00:15:58.090 Demilade Agboola: Hold on!
129 00:15:59.410 ⇒ 00:16:05.430 Emily Giant: So what I’m gonna do is say redelivery of
130 00:16:27.190 ⇒ 00:16:29.710 Emily Giant: also, let’s see if I can say
131 00:16:31.310 ⇒ 00:16:35.240 Emily Giant: all right. So it’s like, not all of them are. Some of them are.
132 00:16:35.550 ⇒ 00:16:37.490 Emily Giant: Some of them are just null.
133 00:16:41.020 ⇒ 00:16:41.690 Demilade Agboola: And.
134 00:16:57.190 ⇒ 00:16:58.720 Emily Giant: Why are there 2 of these
135 00:16:59.120 ⇒ 00:17:04.470 Emily Giant: in base sales data and in supplementary? Oh, whatever
136 00:17:05.700 ⇒ 00:17:08.590 Emily Giant: that shouldn’t be there, that doesn’t even make sense
137 00:17:09.420 ⇒ 00:17:11.489 Emily Giant: for there to be another filter for this.
138 00:17:25.550 ⇒ 00:17:33.020 Emily Giant: Okay, so it looks like the revenue recognized. Filter is not working. That’s something I see right off the bat like
139 00:17:35.910 ⇒ 00:17:43.839 Emily Giant: there shouldn’t ever be unless it’s showing the revenue from the original order.
140 00:17:44.180 ⇒ 00:17:44.850 Demilade Agboola: Yeah.
141 00:17:45.180 ⇒ 00:17:49.490 Emily Giant: Which isn’t the case. We can see that like it’s $0. But
142 00:17:50.490 ⇒ 00:17:58.789 Emily Giant: I guess if it’s saying revenue recognized $0, that’s not the worst thing that could happen. It just shouldn’t. It? Shouldn’t come up in this report at all.
143 00:18:00.900 ⇒ 00:18:01.670 Emily Giant: See?
144 00:18:10.680 ⇒ 00:18:11.440 Emily Giant: Alright!
145 00:18:12.040 ⇒ 00:18:18.409 Emily Giant: So this looks. Why this pulled so many more. Why.
146 00:18:19.510 ⇒ 00:18:22.839 Emily Giant: just pulled like 3,000 rows of $0.
147 00:18:23.800 ⇒ 00:18:24.680 Demilade Agboola: Webinar.
148 00:18:31.750 ⇒ 00:18:35.640 Emily Giant: Oh, never mind, these aren’t all $0. There’s plenty that have.
149 00:18:36.280 ⇒ 00:18:37.260 Demilade Agboola: Yeah. Vice.
150 00:18:37.260 ⇒ 00:18:39.596 Emily Giant: Not 0. Yeah. Okay,
151 00:18:43.420 ⇒ 00:18:46.879 Emily Giant: So that’s 1 thing that could be messed up.
152 00:18:47.910 ⇒ 00:18:57.945 Emily Giant: Let me pull these from staging orders, because that’s where the like default.
153 00:19:02.260 ⇒ 00:19:06.750 Emily Giant: The value should come if they’re not subscriptions.
154 00:19:08.210 ⇒ 00:19:09.060 Demilade Agboola: In.
155 00:19:10.060 ⇒ 00:19:11.910 Emily Giant: Oh, yeah, it.
156 00:20:05.290 ⇒ 00:20:06.110 Emily Giant: Okay.
157 00:20:07.790 ⇒ 00:20:13.250 Emily Giant: So there’s 18 orders here, and they’re all in. They’re all present in
158 00:20:16.530 ⇒ 00:20:23.189 Emily Giant: the 1st upstream, or what I would call, like the closest to the source.
159 00:20:27.540 ⇒ 00:20:29.749 Emily Giant: and some of their order. Totals are 0.
160 00:20:30.600 ⇒ 00:20:33.429 Demilade Agboola: Can we look and just confirm that they are 3? 0 from the.
161 00:20:33.560 ⇒ 00:20:35.500 Emily Giant: Yeah, from, dash.
162 00:20:40.810 ⇒ 00:20:42.930 Demilade Agboola: Once you just copy the order id.
163 00:20:43.390 ⇒ 00:20:47.387 Emily Giant: Yeah, I was gonna copy it into a spreadsheet. So that if we get rid of that, then.
164 00:20:53.930 ⇒ 00:20:56.260 Emily Giant: okay, yeah. Ash.
165 00:20:57.570 ⇒ 00:20:59.830 Emily Giant: Oh, that did not copy what I wanted it to
166 00:21:07.450 ⇒ 00:21:10.220 Emily Giant: want to find one where it’s like showing 0.
167 00:21:18.520 ⇒ 00:21:20.399 Emily Giant: Wait, what is this about?
168 00:21:21.880 ⇒ 00:21:27.660 Emily Giant: Okay, this is something weird like this undefined subscription thing.
169 00:21:30.090 ⇒ 00:21:35.660 Emily Giant: I feel like, that’s a new hmm
170 00:21:36.300 ⇒ 00:21:38.880 Emily Giant: that hasn’t been filled in previously.
171 00:21:45.350 ⇒ 00:21:46.290 Emily Giant: Okay, here.
172 00:21:53.200 ⇒ 00:21:56.730 Emily Giant: Okay, so lots of these are redeliveries that would make sense all of these.
173 00:21:57.620 ⇒ 00:22:01.189 Emily Giant: Okay, this one does not look like a redelivery. So it’s a good one to check.
174 00:22:01.580 ⇒ 00:22:05.490 Emily Giant: I should have to find where the order Id is now row 10,
175 00:22:13.550 ⇒ 00:22:17.060 Emily Giant: but it is a subscription that’s okay.
176 00:22:34.900 ⇒ 00:22:36.639 Emily Giant: Subtotal is 60,
177 00:22:41.250 ⇒ 00:22:45.390 Emily Giant: and then it says, refunds 60. So it was completely refunded.
178 00:22:49.420 ⇒ 00:22:51.140 Demilade Agboola: To sales.
179 00:22:55.770 ⇒ 00:23:00.229 Emily Giant: So I I’m not sure like if they want.
180 00:23:01.840 ⇒ 00:23:06.250 Emily Giant: I would think that revenue would want to count the order.
181 00:23:07.020 ⇒ 00:23:11.839 Emily Giant: you know, have been refunded in the top line. That’s not the bottom line.
182 00:23:13.650 ⇒ 00:23:16.690 Demilade Agboola: So how do? How? How are refunds currently handled.
183 00:23:17.230 ⇒ 00:23:20.340 Emily Giant: So they’re in on us suborders.
184 00:23:43.760 ⇒ 00:23:48.640 Emily Giant: I don’t even. I know that there’s like a sub query in here somewhere
185 00:23:50.100 ⇒ 00:23:58.709 Emily Giant: that handles refunds. But I so refund total but there’s no like subtracting out refunds from the
186 00:23:58.870 ⇒ 00:24:01.880 Emily Giant: top line that I know of like.
187 00:24:07.330 ⇒ 00:24:09.140 Emily Giant: So it’s refund total.
188 00:24:09.360 ⇒ 00:24:12.170 Emily Giant: But there’s a whole like legacy and
189 00:24:19.130 ⇒ 00:24:21.170 Emily Giant: based transactions.
190 00:24:24.600 ⇒ 00:24:31.979 Emily Giant: redeliveries, cost credits, legacy refunds, and then
191 00:24:32.460 ⇒ 00:24:36.259 Emily Giant: refunds. So it’s in Oms refunds. But like there isn’t any
192 00:24:36.630 ⇒ 00:24:44.650 Emily Giant: logic that should be subtracting that, as far as I know, from the top line sales.
193 00:24:45.070 ⇒ 00:24:51.210 Emily Giant: or else that would be part of the suborder total, an order total.
194 00:24:51.550 ⇒ 00:24:58.499 Emily Giant: But the suborder is like our subtotals right here. And that should match what we’re seeing.
195 00:25:06.430 ⇒ 00:25:08.459 Emily Giant: Yeah, these all say, 0.
196 00:25:11.450 ⇒ 00:25:12.960 Emily Giant: Oh, no, that doesn’t.
197 00:25:13.360 ⇒ 00:25:16.140 Emily Giant: Okay. So payment summary, subtotal.
198 00:25:19.860 ⇒ 00:25:30.630 Emily Giant: And then there’s like all these different versions of subtotal okay, there.
199 00:25:33.340 ⇒ 00:25:38.520 Emily Giant: So yeah, it says, 60 in the most upstream model, which is correct.
200 00:25:40.580 ⇒ 00:25:45.650 Demilade Agboola: So it says, 60 in staging orders.
201 00:25:47.650 ⇒ 00:25:51.050 Demilade Agboola: And then, when it gets to subscriptions.
202 00:25:55.850 ⇒ 00:25:56.860 Emily Giant: So.
203 00:25:57.320 ⇒ 00:25:57.860 Demilade Agboola: Let me see.
204 00:25:57.860 ⇒ 00:26:03.970 Emily Giant: When it gets to Om oms suborders like the next downstream model, it’s than 0.
205 00:26:04.450 ⇒ 00:26:08.830 Demilade Agboola: Yeah, but like almost supporters, is getting it from subscriptions. Right?
206 00:26:09.881 ⇒ 00:26:12.760 Emily Giant: Only if it’s a subscription, this isn’t.
207 00:26:13.620 ⇒ 00:26:19.400 Emily Giant: is it? Wait! Yes, it is. You’re right. Yes, so it’s getting it from subscriptions.
208 00:26:21.380 ⇒ 00:26:25.710 Emily Giant: So I would run that in the loop thing.
209 00:27:15.850 ⇒ 00:27:22.220 Emily Giant: Think it’s order. Id. I don’t totally remember what it’s called in loop, except Nope.
210 00:27:48.870 ⇒ 00:27:53.300 Emily Giant: Is there sub order id in here. This model is really screwy with how it’s named.
211 00:27:57.960 ⇒ 00:27:59.439 Emily Giant: and just pull this.
212 00:28:00.330 ⇒ 00:28:02.540 Demilade Agboola: Think a subscription number or something.
213 00:28:02.540 ⇒ 00:28:05.500 Emily Giant: Yeah, it’s something like that. Okay, let me try that.
214 00:28:44.760 ⇒ 00:28:46.080 Emily Giant: Pull this up.
215 00:29:16.210 ⇒ 00:29:17.899 Emily Giant: Try subscription. Id
216 00:29:29.700 ⇒ 00:29:33.650 Emily Giant: gay, that’s weird.
217 00:29:34.390 ⇒ 00:29:34.965 Demilade Agboola: Alright.
218 00:29:37.910 ⇒ 00:29:40.390 Demilade Agboola: Is it? Switch on Id, or switch on number, though.
219 00:29:40.800 ⇒ 00:29:45.170 Emily Giant: Let me. I’m gonna preview this and just see like what it looks like. Cause.
220 00:29:46.670 ⇒ 00:29:48.689 Demilade Agboola: I think it’s a different number.
221 00:29:49.540 ⇒ 00:29:50.520 Emily Giant: Okay.
222 00:29:54.560 ⇒ 00:29:56.230 Demilade Agboola: Yeah, I think it’s subscription number
223 00:29:56.550 ⇒ 00:29:59.530 Demilade Agboola: why, 6 0, 3 is subscription number.
224 00:30:08.500 ⇒ 00:30:12.290 Emily Giant: Am I formatting it wrong? Or something doesn’t seem like
225 00:30:14.480 ⇒ 00:30:16.439 Emily Giant: it looks like it should be.
226 00:30:16.800 ⇒ 00:30:23.959 Emily Giant: Oh, I got it. I think it’s subscription id, and there’s no like tag of one at the end of it.
227 00:30:30.580 ⇒ 00:30:31.480 Emily Giant: Okay.
228 00:30:34.740 ⇒ 00:30:36.150 Emily Giant: so
229 00:30:43.800 ⇒ 00:30:47.180 Emily Giant: item, total 60, like, it’s all correct here.
230 00:30:52.170 ⇒ 00:31:01.929 Demilade Agboola: Okay, so it appears to be Oms. So borders where things start to get Wonky, which is.
231 00:31:03.030 ⇒ 00:31:07.280 Demilade Agboola: I was saying about the join among my supporters on all my supporters.
232 00:31:09.380 ⇒ 00:31:11.339 Emily Giant: That makes sense.
233 00:31:11.820 ⇒ 00:31:16.870 Emily Giant: Well, for one thing.
234 00:31:17.472 ⇒ 00:31:18.980 Emily Giant: It looks like
235 00:31:19.360 ⇒ 00:31:27.960 Emily Giant: it’s not joining, because this is order Id, and I think in Lms suborders. It’s joining on id
236 00:31:28.632 ⇒ 00:31:30.810 Emily Giant: which is a totally different number.
237 00:31:32.120 ⇒ 00:31:33.700 Emily Giant: Let me double check that.
238 00:31:45.990 ⇒ 00:31:46.680 Emily Giant: Okay.
239 00:31:54.570 ⇒ 00:31:58.320 Emily Giant: okay, so it’s joining subscription id on subscription number that should work.
240 00:32:01.400 ⇒ 00:32:03.609 Demilade Agboola: Alright, so can we compile this code
241 00:32:04.705 ⇒ 00:32:13.469 Demilade Agboola: like, give the final answer, based off like that order number, and like just filter to where the order. Numbers, of course, is.
242 00:32:34.210 ⇒ 00:32:38.550 Emily Giant: Don’t need this legacy part, I mean, I guess we can leave it.
243 00:33:08.770 ⇒ 00:33:12.040 Emily Giant: It might be taking forever because of this legacy stuff.
244 00:33:12.340 ⇒ 00:33:12.940 Demilade Agboola: Yeah.
245 00:34:08.000 ⇒ 00:34:10.742 Emily Giant: Oh, it’s really thinking about it
246 00:34:32.570 ⇒ 00:34:33.830 Emily Giant: while that’s running
247 00:34:51.230 ⇒ 00:34:52.389 Emily Giant: no results.
248 00:35:00.680 ⇒ 00:35:01.480 Emily Giant: Hmm.
249 00:35:08.570 ⇒ 00:35:10.860 Emily Giant: But it does have results in this.
250 00:35:11.830 ⇒ 00:35:18.930 Demilade Agboola: I think you might, so can we just have the full query like, without like filtering or anything? Let’s just like it might take a while, but that’s fine.
251 00:35:19.990 ⇒ 00:35:21.489 Emily Giant: Here. You want me to send this to you.
252 00:35:22.330 ⇒ 00:35:23.130 Demilade Agboola: Sure.
253 00:35:29.360 ⇒ 00:35:32.289 Demilade Agboola: No. Could you send the order number? I can? I can compile it.
254 00:35:32.830 ⇒ 00:35:33.730 Emily Giant: Okay.
255 00:35:33.970 ⇒ 00:35:34.820 Demilade Agboola: Remember using.
256 00:35:43.230 ⇒ 00:35:43.920 Demilade Agboola: and
257 00:35:54.180 ⇒ 00:35:54.980 Demilade Agboola: and then.
258 00:36:03.380 ⇒ 00:36:04.820 Emily Giant: Oh, this was canceled!
259 00:36:08.140 ⇒ 00:36:10.540 Emily Giant: Oh, well, that makes sense.
260 00:36:11.240 ⇒ 00:36:17.569 Emily Giant: She doesn’t have a any filter for canceled orders on this.
261 00:36:19.820 ⇒ 00:36:20.700 Demilade Agboola: Oh, okay.
262 00:36:22.330 ⇒ 00:36:24.840 Emily Giant: Let me try that, because that could be a big.
263 00:37:11.900 ⇒ 00:37:16.129 Emily Giant: These are very strange totals also. But whatever?
264 00:37:18.200 ⇒ 00:37:21.560 Emily Giant: Okay? So where it says, 0,
265 00:37:24.650 ⇒ 00:37:27.260 Emily Giant: okay, these are redeliveries that makes sense.
266 00:37:29.330 ⇒ 00:37:33.940 Emily Giant: It’s b 2. B makes sense makes sense.
267 00:37:37.420 ⇒ 00:37:38.090 Demilade Agboola: Great.
268 00:37:39.170 ⇒ 00:37:41.280 Demilade Agboola: So the order number you sent to me.
269 00:37:41.500 ⇒ 00:37:42.120 Emily Giant: Hmm.
270 00:37:42.760 ⇒ 00:37:47.660 Demilade Agboola: When I run against the item total when I run against Oms for borders is 60.
271 00:37:48.880 ⇒ 00:37:51.259 Emily Giant: Yes, and then it was canceled.
272 00:37:51.760 ⇒ 00:37:52.200 Demilade Agboola: Okay.
273 00:37:52.200 ⇒ 00:37:53.570 Emily Giant: Stream.
274 00:37:55.300 ⇒ 00:38:00.199 Emily Giant: It is going to 0 out that revenue
275 00:38:01.020 ⇒ 00:38:12.850 Emily Giant: where I don’t remember. But at some point there’s like another filter of revenue, if canceled, is 0,
276 00:38:13.020 ⇒ 00:38:24.589 Emily Giant: and that’s probably in like Oms items Xf or order, level or order level calculations. Something like that.
277 00:38:27.430 ⇒ 00:38:34.089 Emily Giant: So that was not the best example. I didn’t realize it was so is redelivery is
278 00:38:55.870 ⇒ 00:38:58.889 Emily Giant: so okay, I’m running the new
279 00:38:59.350 ⇒ 00:39:03.060 Emily Giant: like trying to filter out the ones that should actually be 0.
280 00:39:03.920 ⇒ 00:39:06.500 Emily Giant: All right. These b 2 b ones don’t. Really.
281 00:39:07.360 ⇒ 00:39:12.120 Emily Giant: they’re a different set of logic. So maybe
282 00:39:13.600 ⇒ 00:39:17.829 Emily Giant: this isn’t apparently a non-subscription. Non redelivery.
283 00:39:18.530 ⇒ 00:39:19.930 Emily Giant: That is 0.
284 00:39:25.990 ⇒ 00:39:30.910 Emily Giant: Alright, let me send you this order number. This is a less screwy order.
285 00:39:31.550 ⇒ 00:39:32.010 Demilade Agboola: Okay.
286 00:39:34.740 ⇒ 00:39:39.460 Demilade Agboola: alright, we. We have so many minutes left in this call. So I I would like us to talk about like inventory favorites.
287 00:39:39.460 ⇒ 00:39:41.610 Emily Giant: Okay, yeah, yeah, let’s let’s move on.
288 00:39:42.060 ⇒ 00:39:46.289 Demilade Agboola: Yeah, cause I just wanted to be. You can still send the order number so I can keep an eye on it.
289 00:39:46.290 ⇒ 00:39:48.938 Emily Giant: Yeah. And I’ll work on this today, too.
290 00:39:50.030 ⇒ 00:39:57.920 Emily Giant: but I, okay. So the places just to wrap this, I’m gonna check the join with subscriptions. Seems like it might be an issue.
291 00:40:03.690 ⇒ 00:40:11.980 Emily Giant: it seems to not be filtering out non-revenue, generating orders in the reports like it used to
292 00:40:12.360 ⇒ 00:40:15.589 Emily Giant: in looker. So that’s more of a looker layer issue.
293 00:40:16.400 ⇒ 00:40:17.230 Demilade Agboola: Okay.
294 00:40:20.820 ⇒ 00:40:22.330 Emily Giant: And then
295 00:40:22.780 ⇒ 00:40:34.618 Emily Giant: I think the last one, the last order number I sent you. That’s like Tbd. I don’t know what’s going on with that one. So if I check into, I’ll check into those 3 this morning and
296 00:40:35.270 ⇒ 00:40:39.029 Emily Giant: let you know what I find, so you can keep working on inventory stuff.
297 00:40:40.620 ⇒ 00:40:41.769 Demilade Agboola: Oh, okay.
298 00:40:42.880 ⇒ 00:40:43.760 Emily Giant: All right.
299 00:40:43.920 ⇒ 00:40:47.550 Emily Giant: Let me stop if I can figure out how to stop sharing the screen.
300 00:40:49.480 ⇒ 00:40:52.430 Emily Giant: Oh, there we go, all right.
301 00:40:52.680 ⇒ 00:40:54.160 Emily Giant: It’s inventory.
302 00:40:55.450 ⇒ 00:40:56.300 Demilade Agboola: Alright!
303 00:40:56.500 ⇒ 00:40:57.159 Emily Giant: Can I help.
304 00:40:59.204 ⇒ 00:41:00.660 Demilade Agboola: So for the Felipe.
305 00:41:04.170 ⇒ 00:41:08.190 Demilade Agboola: So for Philippines, like mapping.
306 00:41:09.638 ⇒ 00:41:16.539 Demilade Agboola: So basically, we want to go to legacy. Go to what’s it called?
307 00:41:16.760 ⇒ 00:41:25.909 Demilade Agboola: I’ll go to the legacy. I want to go to the the transaction like the polytonic data, and be able to map everything to the same types. Basically
308 00:41:26.500 ⇒ 00:41:32.920 Demilade Agboola: pardon, once that mapping is done, it should happen in in.
309 00:41:34.540 ⇒ 00:41:39.529 Demilade Agboola: Give me one second, it should happen in in.
310 00:41:53.840 ⇒ 00:41:58.470 Demilade Agboola: So what’s what? What’s in shopify adjustments? Is this a different thing, though.
311 00:42:01.210 ⇒ 00:42:08.690 Emily Giant: Yes. So where all of this is built out is in
312 00:42:10.050 ⇒ 00:42:14.670 Emily Giant: it starts in int inventory reconciliations.
313 00:42:17.560 ⇒ 00:42:26.149 Emily Giant: It’s so in like inventory lot details and inventory reconciliations is like the the new polytomic.
314 00:42:26.410 ⇒ 00:42:28.639 Emily Giant: and then it goes to
315 00:42:31.370 ⇒ 00:42:37.979 Emily Giant: the aggregated adjustment types which will go to the netsuite lot table.
316 00:42:38.400 ⇒ 00:42:38.830 Demilade Agboola: Okay.
317 00:42:39.060 ⇒ 00:43:02.580 Emily Giant: And then there should be like another addition to the inventory adjustments table. But that isn’t as crucial having it. Added to that mart inventory lot table is what they’re really looking for, 1st and foremost. But that’s the flow right? There is all polytomic. What I need to figure out is what kind of information polytomic was actually able to like
318 00:43:02.950 ⇒ 00:43:14.979 Emily Giant: backfill from the past? Because when I run a query against like min date, it says 2019. So in my head. I’m like, what if we don’t have to use these legacy adjustments at all?
319 00:43:15.160 ⇒ 00:43:15.580 Demilade Agboola: Yeah.
320 00:43:15.580 ⇒ 00:43:24.790 Emily Giant: We can just use the polyatomic data. If that’s sufficient, the legacy stuff is in int salesforce
321 00:43:25.270 ⇒ 00:43:27.289 Emily Giant: something or other. Let me see.
322 00:43:29.340 ⇒ 00:43:36.089 Emily Giant: And it’s just like a bunch of unused columns that are still implanted downstream. But
323 00:43:36.210 ⇒ 00:43:45.389 Emily Giant: don’t need to be present anymore. It’s called int sales int salesforce inventory adjustments.
324 00:43:48.860 ⇒ 00:43:51.010 Demilade Agboola: So we have the adjustment type just there.
325 00:43:55.600 ⇒ 00:43:56.950 Emily Giant: We have, what sorry.
326 00:43:56.950 ⇒ 00:43:58.950 Demilade Agboola: Participant type. That’s just there.
327 00:44:05.160 ⇒ 00:44:06.939 Emily Giant: I don’t. I don’t understand. Sorry.
328 00:44:06.940 ⇒ 00:44:09.740 Demilade Agboola: Like we have the adjustment type. There.
329 00:44:09.740 ⇒ 00:44:10.830 Emily Giant: Yes.
330 00:44:12.430 ⇒ 00:44:15.040 Demilade Agboola: Yeah, it’s written out. They’re not like.
331 00:44:15.560 ⇒ 00:44:22.909 Emily Giant: I just created this like 2 weeks ago, to get it partially aligned to the updated adjustments.
332 00:44:23.270 ⇒ 00:44:24.070 Demilade Agboola: Margaret.
333 00:44:24.220 ⇒ 00:44:25.150 Emily Giant: But
334 00:44:28.390 ⇒ 00:44:32.219 Emily Giant: it’s not. Yeah. It’s not quite right.
335 00:44:35.170 ⇒ 00:44:38.740 Emily Giant: Redelivery subscription sale like there’s.
336 00:44:38.740 ⇒ 00:44:45.790 Demilade Agboola: I think my question is so once we do apply to legacy and reply to the polyatomic.
337 00:44:45.920 ⇒ 00:44:49.149 Demilade Agboola: Where does everything come together like? Where do they merge?
338 00:44:49.860 ⇒ 00:44:51.029 Demilade Agboola: People don’t need because they.
339 00:44:51.030 ⇒ 00:44:51.540 Emily Giant: Right now.
340 00:44:51.740 ⇒ 00:44:53.180 Demilade Agboola: Yeah, right now. They don’t seem to.
341 00:44:53.180 ⇒ 00:44:57.239 Emily Giant: Right now in inventory adjustments. It’s just called inventory adjustments.
342 00:44:58.930 ⇒ 00:45:01.400 Demilade Agboola: Okay, let me look at that
343 00:45:06.460 ⇒ 00:45:07.340 Demilade Agboola: all right.
344 00:45:07.480 ⇒ 00:45:15.919 Demilade Agboola: But shop. But you’re using shopify. There’s nothing form. There’s nothing from polytonic. So it’s basically in shopify inventory.
345 00:45:15.920 ⇒ 00:45:19.280 Emily Giant: Is, you’re totally right, that’s all. Polyatomic data.
346 00:45:20.859 ⇒ 00:45:35.690 Emily Giant: It’s called salesforce versus shopify is, those are all temporary models from when everything broke 2 weeks ago. Just to like signify where they split off in the history of our like
347 00:45:35.990 ⇒ 00:45:51.030 Emily Giant: sales systems. So the salesforce ones are any adjustments that were made while we were web hosted on shop on salesforce, and then the shopify ones were adjustments made. Once we had migrated to shopify. But it’s all polytomic data. I’m
348 00:45:51.390 ⇒ 00:45:53.490 Emily Giant: unless I’m filling it in with like
349 00:45:54.160 ⇒ 00:46:03.090 Emily Giant: redelivery info. The same way I did in the polyatomic adjustments table. But that is based on
350 00:46:03.370 ⇒ 00:46:05.240 Emily Giant: polyatomic adjustment data.
351 00:46:05.240 ⇒ 00:46:07.639 Demilade Agboola: Oh, really, okay, interesting.
352 00:46:15.520 ⇒ 00:46:21.279 Emily Giant: Yeah, cause it. It’s coming from mark inventory adjustments and inventory number.
353 00:46:22.840 ⇒ 00:46:25.190 Demilade Agboola: Oh, and
354 00:46:49.980 ⇒ 00:46:51.809 Demilade Agboola: there you go! There you go!
355 00:46:53.180 ⇒ 00:46:56.200 Emily Giant: So yeah, they come together in inventory adjustments.
356 00:46:58.100 ⇒ 00:47:07.810 Emily Giant: and it’s just a union. But like I wouldn’t necessarily
357 00:47:08.510 ⇒ 00:47:16.449 Emily Giant: use that as any kind of template for the information that we need, because the organization doesn’t use like half of what’s in that model.
358 00:47:18.820 ⇒ 00:47:20.470 Demilade Agboola: How far? What’s in what’s model.
359 00:47:20.892 ⇒ 00:47:27.659 Emily Giant: So in inventory adjustments there are fields called. Let me pull this up real quick.
360 00:47:31.910 ⇒ 00:47:33.819 Emily Giant: Like a checkout number.
361 00:47:34.140 ⇒ 00:47:41.809 Emily Giant: Netsuite inventory adjustment. Id for count for stock, non-existing netsuite lot id like. All of these are not
362 00:47:42.320 ⇒ 00:47:46.610 Emily Giant: fields that we rely on anymore. And I can’t remember a time when we did.
363 00:47:48.400 ⇒ 00:47:48.790 Demilade Agboola: Okay.
364 00:47:49.510 ⇒ 00:47:59.899 Emily Giant: I don’t even know what like half of them are meant to be, and they come from the hevos or that old source so
365 00:48:01.810 ⇒ 00:48:06.289 Emily Giant: as we like create the the net new stuff it.
366 00:48:07.550 ⇒ 00:48:15.249 Emily Giant: It’s more aligned to like the mark table that we built and just creating new columns for the adjustment types that aren’t sales
367 00:48:15.775 ⇒ 00:48:19.680 Emily Giant: versus like trying to pull in this like 4 stock 4 count
368 00:48:20.330 ⇒ 00:48:23.470 Emily Giant: type information that isn’t really used anymore.
369 00:48:25.150 ⇒ 00:48:26.590 Demilade Agboola: Oh, okay, all right.
370 00:48:29.374 ⇒ 00:48:36.470 Demilade Agboola: So what I’m thinking now is end inventory consolation. What happens if I just take the data from
371 00:48:38.930 ⇒ 00:48:41.200 Demilade Agboola: if I try and get the inventory number
372 00:48:42.700 ⇒ 00:48:47.679 Demilade Agboola: there, and the adjustment types from there and then create like a union.
373 00:48:48.170 ⇒ 00:48:51.230 Demilade Agboola: But we also then applied the logic to it.
374 00:48:54.320 ⇒ 00:49:09.119 Emily Giant: Yeah, I mean, that should work. So what I have built out in that branch that I sent the the one that’s named the ticket number. The int aggregate adjustments is essentially like the base, the base of that. So
375 00:49:09.570 ⇒ 00:49:30.770 Emily Giant: anything. What what needs to be done is like filling it in with legacy where polytomic hasn’t already supplied that information. And that’s what I wasn’t able to check on Thursday like, did polytomic actually cover everything we needed historically, because we don’t need to go back before 2,019 like that is plenty of information.
376 00:49:31.010 ⇒ 00:49:34.640 Emily Giant: So if they were able to like
377 00:49:34.900 ⇒ 00:49:39.589 Emily Giant: upload all of that when we started with them. Then there’s no need
378 00:49:39.770 ⇒ 00:49:45.840 Emily Giant: to join these old tables outside of that one like chunk of legacy orders
379 00:49:46.200 ⇒ 00:49:50.940 Emily Giant: in the salesforce model. That’s like a static upload.
380 00:49:53.160 ⇒ 00:49:57.100 Demilade Agboola: Gotcha. Let me see, just trying to figure that out.
381 00:49:58.500 ⇒ 00:49:59.650 Demilade Agboola: No.
382 00:50:03.080 ⇒ 00:50:07.190 Emily Giant: Yeah, there’s this like Chunk, where
383 00:50:13.080 ⇒ 00:50:15.099 Emily Giant: trying to find, like the lines
384 00:50:17.760 ⇒ 00:50:39.490 Emily Giant: where, like, the only information that was missing. Yeah, it’s called legacy sub order base, because it’s just a block in that in salesforce where it looks like the system just didn’t pull in the order ids correctly. So they used some kind of backfill right there to fill in that information. But those are all so old, too, that it’s like.
385 00:50:41.200 ⇒ 00:50:43.679 Emily Giant: do we need it? I doubt it.
386 00:50:45.500 ⇒ 00:50:46.186 Emily Giant: But maybe.
387 00:50:53.240 ⇒ 00:50:58.460 Demilade Agboola: So the the minimum adjustment type updated at in staging infantry
388 00:50:58.820 ⇒ 00:51:01.359 Demilade Agboola: adjustment is 2021, though.
389 00:51:03.220 ⇒ 00:51:04.950 Emily Giant: That’s what you pulled as the.
390 00:51:05.320 ⇒ 00:51:06.480 Demilade Agboola: The minimum.
391 00:51:07.560 ⇒ 00:51:08.980 Emily Giant: Interesting.
392 00:51:09.280 ⇒ 00:51:12.050 Emily Giant: Okay, where? I wonder where I was pulling it from?
393 00:51:12.330 ⇒ 00:51:14.990 Emily Giant: It was one of the polyatomic tables.
394 00:51:16.630 ⇒ 00:51:20.530 Emily Giant: but I have it written in notes somewhere 2021
395 00:51:21.745 ⇒ 00:51:26.229 Emily Giant: I suppose we should backfill it with the legacy stuff. But again, like.
396 00:51:27.830 ⇒ 00:51:36.690 Emily Giant: I wouldn’t worry about anything but what is in the new version in the like into aggregate adjustment types.
397 00:51:37.190 ⇒ 00:51:42.079 Emily Giant: Can you even see that in your well, I guess if you get on my branch you can see it. But
398 00:51:45.640 ⇒ 00:51:51.420 Emily Giant: but what it is is just like the broken out adjustment types. And then it needs whatever
399 00:51:51.540 ⇒ 00:51:56.129 Emily Giant: doesn’t exist in here to be filled in from salesforce
400 00:51:56.340 ⇒ 00:52:00.859 Emily Giant: in this categorization, because this is what Felipe and the team wanted.
401 00:52:01.910 ⇒ 00:52:04.420 Demilade Agboola: Where did you? Where did you put the model?
402 00:52:04.990 ⇒ 00:52:05.729 Demilade Agboola: And you.
403 00:52:05.730 ⇒ 00:52:06.810 Emily Giant: It is.
404 00:52:07.680 ⇒ 00:52:09.970 Emily Giant: Do you need the branch name, or the.
405 00:52:10.301 ⇒ 00:52:12.290 Demilade Agboola: Right now, just one join away.
406 00:52:12.550 ⇒ 00:52:16.519 Emily Giant: Okay, it’s called int ag adjustment types.
407 00:52:19.700 ⇒ 00:52:24.429 Emily Giant: And at the top of it it says, like group lot adjustments. And it’s for sales, redeliveries
408 00:52:24.660 ⇒ 00:52:32.200 Emily Giant: and subscriptions so like that that grouping is meant to be like orders that were sent to customers.
409 00:52:32.540 ⇒ 00:52:37.349 Emily Giant: and then in reconciliation adjustments. Those are the other adjustment types.
410 00:52:38.320 ⇒ 00:52:39.120 Demilade Agboola: Okay.
411 00:52:42.320 ⇒ 00:52:45.879 Emily Giant: But those are currently only accounting for polyatomic data.
412 00:52:46.420 ⇒ 00:52:48.609 Demilade Agboola: Yeah, I can see that there’s no.
413 00:52:52.960 ⇒ 00:52:55.297 Emily Giant: And then one other thing that has to
414 00:52:56.340 ⇒ 00:53:05.738 Emily Giant: go down is that buffers used to be an adjustment type, but, as you know very well. They changed to like a different table.
415 00:53:06.650 ⇒ 00:53:16.700 Emily Giant: in the recent history of us, like reworking netsuite. So somewhere in that aligning historical data.
416 00:53:16.860 ⇒ 00:53:19.249 Emily Giant: the adjustment type. Buffer
417 00:53:19.590 ⇒ 00:53:26.160 Emily Giant: has to then like, turn into what we now have as buffer. But they can’t. They come from different tables.
418 00:53:27.080 ⇒ 00:53:29.620 Emily Giant: But I guess that doesn’t matter that much.
419 00:53:30.610 ⇒ 00:53:39.470 Emily Giant: It’s gonna come from like 3 different tables. There’ll be like a point in time up to 2023 where you’re going to want to pull it from like legacy adjustments.
420 00:53:39.990 ⇒ 00:53:43.500 Emily Giant: and then thank you. And then
421 00:53:43.770 ⇒ 00:53:49.249 Emily Giant: for the 2 years between that and shopify
422 00:53:49.965 ⇒ 00:53:56.870 Emily Giant: it’s going to come directly from the adjustments table. So like the
423 00:53:58.200 ⇒ 00:54:04.639 Emily Giant: the polyatomic data should have that. But there will be a buffer type adjustment that’s gonna go away
424 00:54:05.360 ⇒ 00:54:14.540 Emily Giant: and then turn into what we built as the buffer table. So that’s kind of a complicated piece. I can write that somewhere, too, because that’s kind of
425 00:54:15.280 ⇒ 00:54:16.610 Emily Giant: specific.
426 00:54:17.850 ⇒ 00:54:23.009 Demilade Agboola: Okay. Quick question, though. Is there any reason why we’re getting?
427 00:54:30.150 ⇒ 00:54:42.010 Demilade Agboola: Why? Why are we going to the mark model to get like the inventory Id. As well as the information for that rather than enriching the March model with the adjustment type that we need.
428 00:54:43.270 ⇒ 00:54:44.090 Emily Giant: When.
429 00:54:45.455 ⇒ 00:54:46.410 Demilade Agboola: Why?
430 00:54:46.860 ⇒ 00:54:47.380 Emily Giant: Why?
431 00:54:48.172 ⇒ 00:54:50.550 Demilade Agboola: The mark, model.
432 00:54:52.230 ⇒ 00:54:54.600 Demilade Agboola: And we are trying to
433 00:54:55.230 ⇒ 00:55:03.149 Demilade Agboola: get like the adjustment types like the spoilage quantity. All of that stuff. What I’m saying is like, well, what I’m wondering is like, why are we not adding
434 00:55:03.550 ⇒ 00:55:06.770 Demilade Agboola: the logic of the adjustment types
435 00:55:06.960 ⇒ 00:55:13.000 Demilade Agboola: to the mart model or creating a math model where we have?
436 00:55:14.780 ⇒ 00:55:17.810 Demilade Agboola: How do I put it? Where we have the numbers? We need
437 00:55:19.120 ⇒ 00:55:30.120 Demilade Agboola: the new logic of like quantity sold sales, sale, quantity. I feel like the the going from a mass model back to an intermediate model.
438 00:55:30.130 ⇒ 00:55:30.620 Emily Giant: I’m good.
439 00:55:31.710 ⇒ 00:55:35.939 Emily Giant: Yeah, I agree. It’s it’s it’s a
440 00:55:36.770 ⇒ 00:55:49.210 Emily Giant: we. It’s wrong, it’s it’s put together. Wrong it to answer your question. And it should not go from a model to another intermediate. The reason is
441 00:55:49.810 ⇒ 00:55:53.740 Emily Giant: it I did it for expediency, because
442 00:55:54.120 ⇒ 00:56:01.270 Emily Giant: all of the information I needed was the rows of the mart model that I use to aggregate everything which is
443 00:56:01.410 ⇒ 00:56:12.250 Emily Giant: the other mart model. It’s just like the aggregated version of inventory adjustments. Xf, I have
444 00:56:14.110 ⇒ 00:56:21.920 Emily Giant: the reason that we do it that way is just for the users, like many users, want to see
445 00:56:23.810 ⇒ 00:56:33.219 Emily Giant: the like individual items on a suborder which could include hard goods. It could include other items that are not part of that lot.
446 00:56:33.600 ⇒ 00:56:38.990 Emily Giant: and the mart model is more for
447 00:56:39.230 ⇒ 00:56:46.650 Emily Giant: in like the actual balance of inventory and making decisions on available for sale. And what to do
448 00:56:46.930 ⇒ 00:56:52.460 Emily Giant: with the on hand inventory, somewhat agnostic of the suborder. Id
449 00:56:54.090 ⇒ 00:57:08.540 Emily Giant: Does that make sense? It’s like answering different questions. One is more like, what was fulfilled
450 00:57:09.080 ⇒ 00:57:15.369 Emily Giant: order by order, and the others like, what do we have left
451 00:57:16.190 ⇒ 00:57:24.060 Emily Giant: in specific facilities, you could absolutely make them all one mar model. But I worry about like
452 00:57:25.720 ⇒ 00:57:32.730 Emily Giant: the ability to aggregate in looker the way that users want to when
453 00:57:33.720 ⇒ 00:57:43.399 Emily Giant: when you have those 2 different levels of detail going on like, I’ve had a lot of issues with fan out when
454 00:57:43.800 ⇒ 00:57:50.950 Emily Giant: people try to like, look at sales by lot with the inventory transactions, data.
455 00:57:51.270 ⇒ 00:57:59.489 Emily Giant: it will say, like for every item in the order, it will multiply the the number. I just can’t get it to like normalize very well
456 00:57:59.850 ⇒ 00:58:04.180 Emily Giant: and like why I split it out like that for now. But I’m totally down to like
457 00:58:05.050 ⇒ 00:58:08.239 Emily Giant: refactor refactor, that entirely.
458 00:58:09.820 ⇒ 00:58:14.650 Demilade Agboola: Okay, don’t change it.
459 00:58:14.770 ⇒ 00:58:17.749 Demilade Agboola: But also it appears that even in inventory
460 00:58:18.020 ⇒ 00:58:23.309 Demilade Agboola: inventory reconciliations there is some like logic being done here as well.
461 00:58:25.000 ⇒ 00:58:29.360 Emily Giant: Yeah. In the 1st in inventory reconciliations.
462 00:58:32.590 ⇒ 00:58:33.800 Emily Giant: Let me check it out.
463 00:58:33.930 ⇒ 00:58:35.760 Emily Giant: Yeah, okay, so.
464 00:58:36.390 ⇒ 00:58:37.110 Demilade Agboola: No, of that.
465 00:58:37.110 ⇒ 00:58:43.000 Emily Giant: Oh, shoot! I have to hop. I have my my 10 o’clock call. I have more time today, though, if you wanna
466 00:58:43.852 ⇒ 00:58:47.410 Emily Giant: re-sync after the stand up.
467 00:58:48.090 ⇒ 00:58:48.960 Demilade Agboola: Sure. That’s fine.
468 00:58:49.210 ⇒ 00:58:50.990 Emily Giant: Okay, let me see if I actually I have.
469 00:58:52.850 ⇒ 00:58:53.740 Demilade Agboola: But
470 00:58:54.060 ⇒ 00:58:58.760 Demilade Agboola: oh, it could! It could be later in the afternoon, so at least I have something to like. Turn around.
471 00:58:59.880 ⇒ 00:59:08.110 Emily Giant: Yeah, okay, I have an interview at noon and 3. But I don’t have anything after the stand up.
472 00:59:09.830 ⇒ 00:59:13.260 Emily Giant: So I’ll just yeah. We can just reconvene here.
473 00:59:13.480 ⇒ 00:59:15.870 Emily Giant: If that you said that does work for you
474 00:59:16.200 ⇒ 00:59:18.050 Emily Giant: to just stay on the stand up.
475 00:59:18.380 ⇒ 00:59:22.699 Demilade Agboola: Alright. Sounds good. Well, not not right after stand up, probably in the afternoon.
476 00:59:22.840 ⇒ 00:59:23.460 Emily Giant: Okay.
477 00:59:24.060 ⇒ 00:59:25.280 Demilade Agboola: That that works for me.
478 00:59:25.600 ⇒ 00:59:26.310 Emily Giant: When.
479 00:59:26.700 ⇒ 00:59:31.699 Demilade Agboola: Who is like one Pm. Et or 2 Pm. Et.
480 00:59:32.550 ⇒ 00:59:34.039 Emily Giant: Yeah, that works.
481 00:59:34.160 ⇒ 00:59:34.880 Demilade Agboola: Sounds good.
482 00:59:34.900 ⇒ 00:59:36.559 Emily Giant: Alright cool. See you later.