Meeting Title: Brainforge Schedule Update Working Session Date: 2025-08-12 Meeting participants: Demilade Agboola, Emily Giant
WEBVTT
1 00:03:17.110 ⇒ 00:03:19.250 Emily Giant: Alright, I have my coffee.
2 00:03:23.450 ⇒ 00:03:24.469 Demilade Agboola: Hi, Emily.
3 00:03:24.950 ⇒ 00:03:27.370 Emily Giant: Hi! Did you get your coffee?
4 00:03:27.550 ⇒ 00:03:29.300 Demilade Agboola: The water’s boiling.
5 00:03:29.540 ⇒ 00:03:30.220 Demilade Agboola: Yep.
6 00:03:31.220 ⇒ 00:03:32.930 Demilade Agboola: It’ll be, he’ll be ready in a minute.
7 00:03:33.710 ⇒ 00:03:41.010 Emily Giant: Okay, well, I will always accept, a break when it has to do with coffee. It’s important.
8 00:03:41.440 ⇒ 00:03:42.650 Demilade Agboola: Yeah, …
9 00:03:43.950 ⇒ 00:03:47.869 Demilade Agboola: Who needs a water break? Who needs a water break when you can get a coffee break, you know?
10 00:03:47.870 ⇒ 00:03:50.010 Emily Giant: Exactly. Weak people.
11 00:03:51.100 ⇒ 00:04:01.280 Emily Giant: Oh, man. I was hoping you could help me out with something really, like, administrivia, real quick. …
12 00:04:01.930 ⇒ 00:04:03.370 Emily Giant: Zach wanted me to…
13 00:04:03.800 ⇒ 00:04:16.599 Emily Giant: update this, like, schedule that we use internally and share with our teams, with, like, the Brainforge timing. Let me pull it up real quick. And I’m like, I don’t know, Zach, like, I kind of know, but…
14 00:04:17.060 ⇒ 00:04:28.310 Emily Giant: It’s less, defined than Than what I understand, because things take longer than… or shorter.
15 00:04:28.620 ⇒ 00:04:32.559 Emily Giant: Alright, so this is a calendar,
16 00:04:32.910 ⇒ 00:04:39.029 Emily Giant: on FigJam. So, we’re trying to map out through December.
17 00:04:39.590 ⇒ 00:04:52.789 Emily Giant: I think the contract technically ends November 30th, so we’re just trying to map it out to here, and I don’t know what comes after the revenue mart, and I don’t also know if this is an appropriate amount of weeks.
18 00:04:52.990 ⇒ 00:04:56.110 Emily Giant: to schedule for the revenue mart. I feel like it might…
19 00:04:57.370 ⇒ 00:05:01.169 Emily Giant: So, right now it’s scheduled for, I think every one of these is a week.
20 00:05:02.480 ⇒ 00:05:03.400 Emily Giant: Let’s see….
21 00:05:04.620 ⇒ 00:05:07.390 Demilade Agboola: Okay. September, yeah.
22 00:05:08.680 ⇒ 00:05:15.239 Emily Giant: But what do we have slated for after the revenue mart? Do you know if it’s, …
23 00:05:16.200 ⇒ 00:05:33.460 Emily Giant: So what’s happening is, like, we’ve lumped in a lot of the marketing stuff in the TBD with revenue, and so I’m kind of thinking that, like, we need to extend revenue in timing and then do finance after that, because finance, like, even though they didn’t have a lot of, like.
24 00:05:34.540 ⇒ 00:05:45.410 Emily Giant: asks, I think it’s because they don’t know what they don’t know, and all they know is how to work in Google Sheets right now. So even though we had marketing slated for after
25 00:05:45.590 ⇒ 00:05:47.479 Emily Giant: I don’t really think we need…
26 00:05:47.840 ⇒ 00:05:51.969 Emily Giant: I would rather get revenue perfect.
27 00:05:52.250 ⇒ 00:05:54.720 Emily Giant: And not do customer service, because, like.
28 00:05:54.980 ⇒ 00:06:11.910 Emily Giant: I came from the world of customer service data, so I… I know how to do that, and it’s not, like, revenue impacting, and it’s not, like, hugely business impacting, but, like, the other things are, and I’d rather do 3 marts, and have them perfect than 5, and have them, like.
29 00:06:12.080 ⇒ 00:06:13.429 Emily Giant: Not quite done.
30 00:06:15.250 ⇒ 00:06:29.009 Demilade Agboola: Fair enough. I think it will be a function of prioritization, and I also think that, like, things like, as we’ve seen with inventory, and as we’re working with revenue, things… scope creep does occur.
31 00:06:29.900 ⇒ 00:06:31.270 Emily Giant: Totally.
32 00:06:31.270 ⇒ 00:06:38.319 Demilade Agboola: even if we do say, like, revenue will be, say, end of September or whatever, odds are there will still be…
33 00:06:38.550 ⇒ 00:06:54.070 Demilade Agboola: like, feedback from the team, or, like, you know, Perry or Dean or so on, just going, hey, can we get, like, more of this data? Or now that we’ve seen the data that’s available, I think it’ll be more useful if I had it in this form, or, you know.
34 00:06:54.070 ⇒ 00:06:55.150 Emily Giant: Yeah, yeah.
35 00:06:55.370 ⇒ 00:06:58.029 Demilade Agboola: So those kind of things will happen, and…
36 00:06:58.260 ⇒ 00:07:10.869 Demilade Agboola: That would definitely take a chunk of time that we might not necessarily always foresee. Also, yeah, I think if you feel like marketing might not be as high of the priority.
37 00:07:11.090 ⇒ 00:07:15.240 Demilade Agboola: After that, and you’d like us to put finance next?
38 00:07:15.240 ⇒ 00:07:16.050 Emily Giant: Yeah.
39 00:07:16.540 ⇒ 00:07:19.500 Demilade Agboola: We could always, have that as a discussion.
40 00:07:19.630 ⇒ 00:07:21.080 Demilade Agboola: And then…
41 00:07:24.150 ⇒ 00:07:39.379 Demilade Agboola: And then just kind of, like, get that to happen. So my role is more of, like, technical lead, so my role is just to ensure that everything does happen, and you guys get the data you want. In terms of, like, scoping and, like, prioritization, that would be more of AMBA.
42 00:07:39.590 ⇒ 00:07:50.089 Demilade Agboola: And just her trying to ensure that she gets everybody’s perspective and, like, what she believes would be the best for Urban STEMs going forward.
43 00:07:50.640 ⇒ 00:07:52.660 Emily Giant: Okay, that makes sense. I think, like.
44 00:07:52.920 ⇒ 00:08:08.499 Emily Giant: another thing I could do here is add notes, saying, like, revenue, at first we’re gonna focus on building the, like, SNFP models, and, like, this first chunk will be Perry, and then after that’s gonna be, like, the subscription focus, because we need to wait until we have
45 00:08:08.500 ⇒ 00:08:15.760 Emily Giant: the Loop integration to build out subscriptions, and we need to wait until we have the Northbeam integration to build out those, and, like.
46 00:08:15.980 ⇒ 00:08:22.210 Emily Giant: Without those, there’s only… I mean, there’s nothing we can do. So…
47 00:08:22.730 ⇒ 00:08:41.299 Emily Giant: I guess I’ll just add in some detail here about, like, what’s happening these first four weeks, and extend it from there and say, okay, like, planned loop integration that’s gonna need to happen here, build out the models, like, I don’t think once we have those integrations that it’s gonna take long. I think, like, they’re pretty straightforward.
48 00:08:41.669 ⇒ 00:08:44.079 Emily Giant: Unlike how Perry and Dean
49 00:08:44.250 ⇒ 00:08:54.360 Emily Giant: capable, deal with, like, bundle revenue. That’s gonna be… like, overhauling that stuff with Shopify tables is what’s gonna be…
50 00:08:55.020 ⇒ 00:08:57.420 Emily Giant: more time-consuming.
51 00:08:58.020 ⇒ 00:09:01.550 Emily Giant: But, okay, I’ll talk to Amber about it, too, at our next, like.
52 00:09:01.850 ⇒ 00:09:06.570 Emily Giant: stand up, maybe tomorrow, and then I’ll just send Zach notes for now on this, and be like.
53 00:09:06.910 ⇒ 00:09:10.619 Emily Giant: this is what we’re thinking. Let me know if that makes sense, in terms of, like.
54 00:09:10.990 ⇒ 00:09:16.750 Emily Giant: He uses this to, like, talk to the stakeholders and, like, let them know,
55 00:09:16.980 ⇒ 00:09:17.879 Demilade Agboola: On the horizon?
56 00:09:17.880 ⇒ 00:09:18.670 Emily Giant: Yeah.
57 00:09:19.580 ⇒ 00:09:29.260 Demilade Agboola: Also, quick, I was gonna ask, so for the revenue marts, I’m currently, like, looking at building them based off the OMS data.
58 00:09:29.360 ⇒ 00:09:32.190 Demilade Agboola: Because OMS data goes further back.
59 00:09:32.620 ⇒ 00:09:34.120 Emily Giant: Yeah, that’s true.
60 00:09:34.120 ⇒ 00:09:38.410 Demilade Agboola: But… I know you’ve mentioned, like, Shopify data being, like.
61 00:09:38.790 ⇒ 00:09:39.490 Emily Giant: Well…
62 00:09:39.610 ⇒ 00:09:47.910 Emily Giant: It goes further back, but then it deprecates, because it doesn’t function the way we want it to, or the way it used to, starting on…
63 00:09:48.020 ⇒ 00:10:03.929 Emily Giant: like, migration day. So it’s fine to use those, like, historically, but, it’s that whole, like, components XF thing that, like, doesn’t seem to have a solve that I understand. And maybe you can figure out the solve, but…
64 00:10:04.390 ⇒ 00:10:06.520 Emily Giant: Let me show in dbt what I mean.
65 00:10:06.730 ⇒ 00:10:07.500 Demilade Agboola: Okay.
66 00:10:07.750 ⇒ 00:10:15.390 Emily Giant: And then I have the… I think it’s in the Brainforge document, but… Hmm.
67 00:10:17.250 ⇒ 00:10:24.879 Emily Giant: I’m finally starting to feel better, like, today. I thought I felt better last Friday, but then in hindsight, I felt like crap still.
68 00:10:24.890 ⇒ 00:10:31.499 Demilade Agboola: Yeah, that’s why I said, like, if you… if you didn’t want the working session, we could always move to Monday.
69 00:10:32.240 ⇒ 00:10:37.690 Emily Giant: Yeah, I was trying… like, I wanted to get PK in there, too. He’s so excited to, like.
70 00:10:37.970 ⇒ 00:10:44.990 Emily Giant: start doing stuff that I’m like, alright, let’s just get this going. That’s the old one, where’s the new one?
71 00:10:46.680 ⇒ 00:10:50.540 Emily Giant: But… You use me.
72 00:10:54.350 ⇒ 00:10:57.230 Demilade Agboola: Give me one second, trying to get the coffee.
73 00:10:57.230 ⇒ 00:11:00.480 Emily Giant: Go for it. Take whatever time you need. It’s important.
74 00:11:01.320 ⇒ 00:11:01.990 Emily Giant: There you go.
75 00:12:52.110 ⇒ 00:12:52.880 Demilade Agboola: I’m back.
76 00:12:53.610 ⇒ 00:12:57.210 Emily Giant: Hello, okay, so… …
77 00:12:57.470 ⇒ 00:13:13.640 Emily Giant: The thing that I’m not sure is, like, currently compatible with, OMS line items, there are a couple things. One is that it keeps generating this, like, bizarre, unique SKU for things whenever people buy, like, a vase with
78 00:13:13.870 ⇒ 00:13:16.840 Emily Giant: A… but with a, …
79 00:13:17.500 ⇒ 00:13:26.960 Emily Giant: bouquet that isn’t, like, a pre-merchandised bundle. It’s calling it, like, a unique bundle, or something like that, and generating a weird string of
80 00:13:27.610 ⇒ 00:13:39.129 Emily Giant: characters, but the main thing is, it’s this care actions orders thing. So whenever, like, there’s a forced upgrade on a kit, the way that,
81 00:13:39.410 ⇒ 00:13:43.380 Emily Giant: split line items used to work. It would, like.
82 00:13:43.490 ⇒ 00:13:52.850 Emily Giant: appropriately remove that item from the kit, and now it doesn’t seem to. It’s like… how…
83 00:13:53.910 ⇒ 00:14:01.169 Emily Giant: One of the, … it’s better to show. But, like, okay, so I wrote out an example here.
84 00:14:01.170 ⇒ 00:14:04.259 Demilade Agboola: I believe there was a flag, but it doesn’t have the flag at all.
85 00:14:05.570 ⇒ 00:14:06.900 Emily Giant: Sorry, you cut off a little.
86 00:14:07.040 ⇒ 00:14:12.310 Demilade Agboola: I said, if I remember correctly, I believe there was a flag, but it doesn’t update that flag anymore.
87 00:14:12.310 ⇒ 00:14:14.389 Emily Giant: Yeah, exactly.
88 00:14:14.530 ⇒ 00:14:19.499 Emily Giant: Like, it… So, if I go to dbt, it’s…
89 00:14:20.250 ⇒ 00:14:24.230 Emily Giant: Sorry. Not where I want to be.
90 00:14:37.360 ⇒ 00:14:40.650 Emily Giant: I’m gonna switch branches, because this one doesn’t look anything like this.
91 00:14:41.130 ⇒ 00:14:42.380 Emily Giant: Anything?
92 00:15:06.540 ⇒ 00:15:07.870 Emily Giant: It’s this one.
93 00:15:10.440 ⇒ 00:15:14.320 Emily Giant: So this is the model that is supposed to, …
94 00:15:14.430 ⇒ 00:15:23.890 Emily Giant: identify deleted products. And, the way that the table deprecated, it’s like it does…
95 00:15:23.990 ⇒ 00:15:29.219 Emily Giant: not any longer do that. … It might be worth…
96 00:15:30.760 ⇒ 00:15:38.640 Emily Giant: Pulling it to validate, because this was, like, an issue we were having probably 3 months ago, and there’s been so much work done since then that…
97 00:15:39.090 ⇒ 00:15:42.489 Emily Giant: I’ve not done anything specifically to target this, but I feel like
98 00:15:42.590 ⇒ 00:15:48.120 Emily Giant: we’ve overhauled half of the DAG already, so… …
99 00:15:49.140 ⇒ 00:15:55.019 Emily Giant: This was the one in particular, though, that I was wondering if there’s a Shopify table that would be more accurate.
100 00:15:55.530 ⇒ 00:16:03.380 Emily Giant: Okay, so… we’ve basically staging split line items, staging line items. So, the way I understand it is, like.
101 00:16:03.870 ⇒ 00:16:07.080 Emily Giant: Staging split line items, if I pull that order number.
102 00:16:11.580 ⇒ 00:16:15.560 Emily Giant: Oh, this was an example from Perry, just calling out, like, the issues.
103 00:16:23.670 ⇒ 00:16:26.330 Emily Giant: So if we go to mode…
104 00:17:08.980 ⇒ 00:17:15.260 Emily Giant: Okay, so this is the one that’s gonna give the… Kitted ID…
105 00:17:16.880 ⇒ 00:17:23.440 Emily Giant: Okay, so that’s giving the kid an ID, staging split line items, so… That means…
106 00:17:29.150 ⇒ 00:17:39.989 Emily Giant: Staging split line items, what’s the other one? Staging line items. Which, to me, doesn’t make any sense, because I would think staging split line items would be the split line items, not…
107 00:17:40.260 ⇒ 00:17:44.139 Emily Giant: the kit, right? Like, that’s a bad name for it.
108 00:17:45.390 ⇒ 00:17:52.709 Emily Giant: And Steve’s line items seems like it should be… it’s… they should be the opposite. And I want to say, at one point, they were.
109 00:17:53.690 ⇒ 00:17:58.899 Demilade Agboola: Oh, really? Well, like, we need to pull a historical order number to prove that out.
110 00:17:58.900 ⇒ 00:18:06.460 Emily Giant: But it’s like they switched. Okay. So staging line items is all of the various pieces of the kit, which we can see…
111 00:18:07.140 ⇒ 00:18:18.109 Emily Giant: Here, that there’s, like, multiple… main products? Like, one… To 3 different main products.
112 00:18:18.310 ⇒ 00:18:23.979 Emily Giant: So, off the bat, that doesn’t make sense. It means that, like, some of them were probably deleted or forced upgraded.
113 00:18:24.640 ⇒ 00:18:26.439 Emily Giant: Okay, so has been deleted.
114 00:18:26.630 ⇒ 00:18:29.169 Emily Giant: This one’s been deleted, and this one’s been deleted.
115 00:18:30.090 ⇒ 00:18:31.030 Demilade Agboola: Oh, okay.
116 00:18:31.270 ⇒ 00:18:35.540 Emily Giant: Okay, so if we go down the next node…
117 00:18:36.210 ⇒ 00:18:39.700 Emily Giant: to this, line item is strikethrough.
118 00:18:41.720 ⇒ 00:18:54.780 Emily Giant: So, it’s saying, select everything from staging split line items, strikethrough as… okay, so that makes sense, that’s definitely the right reference. Add strikethrough as select everything from the base, which is staging split line items.
119 00:18:55.580 ⇒ 00:19:02.520 Emily Giant: And cola, strikethrough dot has been deleted, but that doesn’t make any sense, right? Because there’s no… it’s joining…
120 00:19:03.070 ⇒ 00:19:04.740 Emily Giant: Using ID.
121 00:19:05.530 ⇒ 00:19:08.519 Emily Giant: But there’s no, like, common products between them.
122 00:19:08.780 ⇒ 00:19:15.689 Emily Giant: So, like, if you’re saying… With base, select everything from staging split line items, so that’s the kit SKU.
123 00:19:16.300 ⇒ 00:19:21.520 Emily Giant: And then you’re adding a strikethrough, In staging line items.
124 00:19:22.010 ⇒ 00:19:23.410 Emily Giant: Okay, fine.
125 00:19:23.790 ⇒ 00:19:27.310 Emily Giant: and then add strikethrough S, select everything from the base.
126 00:19:27.690 ⇒ 00:19:30.619 Emily Giant: And then strikethrough dot has been deleted.
127 00:19:31.540 ⇒ 00:19:40.040 Emily Giant: it’s… I… I mean, maybe down the line, that’s gonna rectify itself somehow, but, like… Let’s just pull it.
128 00:19:40.380 ⇒ 00:19:41.979 Emily Giant: See what that looks like.
129 00:19:42.420 ⇒ 00:19:47.559 Emily Giant: Because it’s not going to show anything from the kit having gotten deleted, because there’s no common SKU.
130 00:19:48.980 ⇒ 00:19:50.920 Emily Giant: Okay, from int.
131 00:20:28.660 ⇒ 00:20:30.689 Emily Giant: Right, so this is what it returns.
132 00:20:30.800 ⇒ 00:20:37.370 Emily Giant: is… just the… Kit line with nothing that’s been deleted.
133 00:20:41.690 ⇒ 00:20:44.890 Demilade Agboola: So, the idea is it should give you what has been deleted, right?
134 00:20:44.890 ⇒ 00:20:45.900 Emily Giant: Right.
135 00:20:47.660 ⇒ 00:20:49.590 Demilade Agboola: But it’s doing literally the opposite.
136 00:20:49.790 ⇒ 00:20:50.890 Emily Giant: Yes.
137 00:20:54.890 ⇒ 00:20:56.810 Demilade Agboola: How’s that for grid design?
138 00:20:56.810 ⇒ 00:20:59.649 Emily Giant: It’s good, it’s good stuff!
139 00:21:01.370 ⇒ 00:21:03.310 Emily Giant: Literally the opposite.
140 00:21:04.410 ⇒ 00:21:06.799 Demilade Agboola: Let me take a look at it.
141 00:21:12.270 ⇒ 00:21:17.289 Emily Giant: I did not do this. I just want you to know that I did not do this.
142 00:21:18.390 ⇒ 00:21:30.249 Emily Giant: But I want to pull… let me see while you’re looking at it, if I can pull, from prior to the migration, to see if it did work at that point, because I feel like I have done that before, and it did used to work.
143 00:21:30.910 ⇒ 00:21:31.790 Demilade Agboola: Okay.
144 00:21:32.740 ⇒ 00:21:34.320 Emily Giant: How does one do this?
145 00:21:35.050 ⇒ 00:21:36.670 Emily Giant: How’s that for great design?
146 00:21:38.730 ⇒ 00:21:40.879 Demilade Agboola: That would be a great shirt, like a t-shirt.
147 00:21:40.880 ⇒ 00:21:41.930 Emily Giant: Yep.
148 00:21:55.140 ⇒ 00:21:59.680 Emily Giant: I’m just running, like, building a quick looker report to pull examples here.
149 00:23:29.620 ⇒ 00:23:33.419 Emily Giant: It blocks you… I’m gonna go….
150 00:23:33.860 ⇒ 00:23:37.450 Demilade Agboola: Hi, can you send these 3, like, can you just copy these 3 queries?
151 00:23:37.670 ⇒ 00:23:38.360 Emily Giant: Yes.
152 00:23:38.770 ⇒ 00:23:39.830 Demilade Agboola: Good shot.
153 00:25:06.790 ⇒ 00:25:11.939 Emily Giant: Well, there’s no way there’s only 3 results, but that’s okay. We can use this.
154 00:25:41.630 ⇒ 00:25:45.489 Emily Giant: Okay, so HEVO split line items. Back in the day.
155 00:25:45.650 ⇒ 00:25:50.830 Emily Giant: shows the kit SKU, and then the gift SKU as well.
156 00:25:54.080 ⇒ 00:25:57.099 Demilade Agboola: When you say back in the day, is this all pre-migration?
157 00:25:57.100 ⇒ 00:26:00.679 Emily Giant: Yes, so I set the filter for, …
158 00:26:00.850 ⇒ 00:26:04.400 Emily Giant: Anytime, like, within the year before…
159 00:26:04.580 ⇒ 00:26:15.849 Emily Giant: the migration. So what’s interesting is it’s showing the product SKU of the Virgo with the K instead of, like, the unique bouquet SKU, and then it’s showing the gift that’s with it.
160 00:26:17.670 ⇒ 00:26:20.139 Emily Giant: Which did not happen, …
161 00:26:21.260 ⇒ 00:26:31.590 Emily Giant: well, last time it was just the kit SKU without the contents of it. So this one, the split line items, what we saw last time was every…
162 00:26:32.060 ⇒ 00:26:34.030 Emily Giant: like, piece SKU.
163 00:26:34.600 ⇒ 00:26:36.579 Emily Giant: Okay, so we’re still seeing that.
164 00:26:46.990 ⇒ 00:26:49.159 Emily Giant: And then this one has been deleted.
165 00:26:50.180 ⇒ 00:26:54.159 Emily Giant: So the spice got deleted. And then everything else in here…
166 00:26:57.690 ⇒ 00:27:00.239 Emily Giant: Did get… sent.
167 00:27:03.360 ⇒ 00:27:05.210 Emily Giant: Which one is the space?
168 00:27:08.240 ⇒ 00:27:25.390 Emily Giant: So, interesting to note is the price of the one that got deleted is now zero, and then the cost of the spice got moved to the bouquet that was actually sent, which does not happen anymore either. Let’s see what it looks like in the strikethrough…
169 00:27:37.460 ⇒ 00:27:40.570 Emily Giant: So this isn’t right either, to be fair, like…
170 00:27:40.740 ⇒ 00:27:42.399 Emily Giant: This is not what got sent.
171 00:27:46.420 ⇒ 00:27:59.070 Emily Giant: So I’m not totally sure what the deal is here, like, or if it ever rectifies downstream. If so, it would be in either, like, the components XF, or in, …
172 00:28:01.880 ⇒ 00:28:05.110 Emily Giant: Who would think OMS suborders?
173 00:28:05.700 ⇒ 00:28:07.030 Emily Giant: What’s this?
174 00:28:12.650 ⇒ 00:28:16.249 Emily Giant: Alright, so if I go one downstream DIM line item union…
175 00:28:42.090 ⇒ 00:28:43.010 Emily Giant: Alright.
176 00:28:48.180 ⇒ 00:28:50.930 Emily Giant: So, with the line item union, you get…
177 00:28:52.740 ⇒ 00:28:55.810 Emily Giant: Now, is this correct or incorrect?
178 00:28:55.950 ⇒ 00:29:01.529 Emily Giant: Okay, this is interesting. You get the kit at SKU, and then all the components of the kit.
179 00:29:02.220 ⇒ 00:29:05.279 Emily Giant: Correctly, because the spice is not in here.
180 00:29:07.730 ⇒ 00:29:08.570 Demilade Agboola: Oh, okay.
181 00:29:12.920 ⇒ 00:29:16.799 Emily Giant: Let me see what that’s like with our new example.
182 00:29:41.590 ⇒ 00:29:44.679 Emily Giant: Okay, so the strikethrough item…
183 00:29:45.040 ⇒ 00:29:49.900 Emily Giant: It’s still coming through here, is it marked as deleted? Okay, so that’s marked as deleted.
184 00:29:51.180 ⇒ 00:29:52.010 Demilade Agboola: It’s true.
185 00:29:52.500 ⇒ 00:29:57.179 Demilade Agboola: Yeah, so the idea is, it should come through, but we should know it to be deleted.
186 00:30:00.000 ⇒ 00:30:04.879 Emily Giant: But also, where are the other components of this kit? Like, where’s the vase?
187 00:30:06.300 ⇒ 00:30:09.009 Emily Giant: They’re, like, the components aren’t there.
188 00:30:10.070 ⇒ 00:30:18.590 Demilade Agboola: What are those, SKUs pointing to, though? Like, the D0244 and K1011?
189 00:30:18.770 ⇒ 00:30:21.880 Emily Giant: So that’s the kit SKU called the Snow Day.
190 00:30:21.880 ⇒ 00:30:22.380 Demilade Agboola: Alright, bro.
191 00:30:22.380 ⇒ 00:30:31.810 Emily Giant: This is called… and these were force upgrades, so then… one of these Is the bouquet.
192 00:30:33.510 ⇒ 00:30:38.549 Emily Giant: And then… which one was deleted? So the top one was deleted. So the Magic Maker is what got sent.
193 00:30:38.820 ⇒ 00:30:46.130 Emily Giant: And then this is shipping. But, like, a kit isn’t just, like, a bouquet, so something’s already missing from this.
194 00:30:46.790 ⇒ 00:30:48.160 Demilade Agboola: But the… the….
195 00:30:48.160 ⇒ 00:30:48.800 Emily Giant: Yay.
196 00:30:49.050 ⇒ 00:30:52.419 Demilade Agboola: freeze, or the… It’s chocolate or something.
197 00:30:52.420 ⇒ 00:30:57.390 Emily Giant: Yep, okay, we know that that model’s weird. Hold on…
198 00:31:02.940 ⇒ 00:31:07.210 Emily Giant: Yeah, so we’re not seeing the vase in it.
199 00:31:11.790 ⇒ 00:31:14.909 Emily Giant: Yeah, that just didn’t carry through at all, it looks like.
200 00:31:16.040 ⇒ 00:31:24.320 Emily Giant: And… That got successfully deleted. Double to Copenhagen.
201 00:31:27.320 ⇒ 00:31:29.349 Emily Giant: And the snow day bouquet.
202 00:31:29.830 ⇒ 00:31:31.960 Emily Giant: got successfully deleted.
203 00:31:32.280 ⇒ 00:31:38.610 Emily Giant: But, when that kit, the FLRL-K carries through, that’s implying
204 00:31:38.950 ⇒ 00:31:43.560 Emily Giant: That the snow date was sent, because that is what is included in that kit.
205 00:31:43.740 ⇒ 00:31:48.210 Emily Giant: You know what I mean? So, like… It doesn’t quite make sense.
206 00:31:52.720 ⇒ 00:31:57.030 Emily Giant: So even though it’s showing, yes, it’s deleted, one thing down the line…
207 00:31:57.420 ⇒ 00:31:59.570 Emily Giant: It’s saying that it was not deleted.
208 00:32:02.840 ⇒ 00:32:10.459 Demilade Agboola: So… Has been dated is 1 for the table above, but the table below, it’s not.
209 00:32:11.580 ⇒ 00:32:22.279 Emily Giant: So, this is, I think, where some of the problem comes through, and I think we probably need to run it in OMS CompXF base to see, like, once the components are added back.
210 00:32:23.100 ⇒ 00:32:37.840 Emily Giant: if this is correctly identifying that the snow day bouquet was removed, but right now, because this is a different SKU than FLRL-B10115, it’s acting like
211 00:32:38.660 ⇒ 00:32:41.920 Emily Giant: The bouquet from this kit was still sent.
212 00:32:42.090 ⇒ 00:32:51.749 Emily Giant: But really, it was only the vase that was sent, but the vase is actually the only component of this kit that was sent, and it’s saying it was worth $100.
213 00:32:54.800 ⇒ 00:33:00.639 Demilade Agboola: But is it the vase, does the vase have its own, like… product SKU, and….
214 00:33:00.640 ⇒ 00:33:01.170 Emily Giant: Yes.
215 00:33:01.280 ⇒ 00:33:02.260 Demilade Agboola: It does.
216 00:33:02.510 ⇒ 00:33:12.189 Emily Giant: And in this model, I guess it’s not showing the component SKU, so that would probably come in in, like, LMS CompXF base.
217 00:33:14.970 ⇒ 00:33:18.599 Emily Giant: Oh, summer days! Okay, so also there’s a…
218 00:33:18.710 ⇒ 00:33:23.530 Emily Giant: there’s a piece of OMS suborders called, like, Line Item Split.
219 00:33:25.250 ⇒ 00:33:30.859 Emily Giant: Yep, so this is where it, like, divides the order into its pieces.
220 00:33:31.360 ⇒ 00:33:32.060 Demilade Agboola: Oh, okay.
221 00:33:33.090 ⇒ 00:33:35.579 Emily Giant: So this is where it would, like, assign
222 00:33:35.690 ⇒ 00:33:46.640 Emily Giant: for the sub-order table, where it would assign, revenue to those things. But right now, it’s gonna assign $100 of revenue to that vase, if I understand what I’m…
223 00:33:47.040 ⇒ 00:33:51.800 Emily Giant: looking at. Here, let me… Just run this chunk of it.
224 00:33:57.990 ⇒ 00:34:03.360 Emily Giant: So this is… Union, this is on a suborders.
225 00:34:14.080 ⇒ 00:34:15.569 Emily Giant: That opposites.
226 00:34:53.060 ⇒ 00:34:53.800 Emily Giant: Sorry.
227 00:36:11.690 ⇒ 00:36:13.690 Emily Giant: It’s taking its time.
228 00:36:14.140 ⇒ 00:36:14.830 Demilade Agboola: Yeah.
229 00:36:28.810 ⇒ 00:36:30.520 Emily Giant: Okay…
230 00:36:39.590 ⇒ 00:36:42.119 Emily Giant: Alright, not terribly helpful. …
231 00:36:44.090 ⇒ 00:36:55.049 Emily Giant: But I also hate that, and think that that would really screw up, downstream revenue calculations, since it’s never 100%, whatever. …
232 00:36:55.680 ⇒ 00:36:56.700 Emily Giant: No, no, no.
233 00:36:57.150 ⇒ 00:36:58.130 Emily Giant: Here we go.
234 00:36:58.650 ⇒ 00:37:02.560 Emily Giant: Now, this one is where we might see…
235 00:37:03.060 ⇒ 00:37:07.479 Emily Giant: This is where I would expect it to completely rectify if it were ever going to.
236 00:37:09.160 ⇒ 00:37:10.240 Emily Giant: So…
237 00:37:18.070 ⇒ 00:37:23.380 Emily Giant: Because after that, I don’t even think there’s any really, like, Omos.
238 00:37:26.740 ⇒ 00:37:29.329 Emily Giant: comp. What’s that called? Almost comp base?
239 00:37:31.180 ⇒ 00:37:33.669 Emily Giant: OMS CompEXF base.
240 00:37:34.320 ⇒ 00:37:37.800 Emily Giant: There’s really no, like, transformations on these after this.
241 00:37:38.280 ⇒ 00:37:39.180 Demilade Agboola: Okay.
242 00:37:51.020 ⇒ 00:37:55.370 Demilade Agboola: I mean, this is helpful, because I’m about to start working on, like, this whole split item….
243 00:37:57.140 ⇒ 00:37:58.500 Demilade Agboola: Portion of it, so….
244 00:38:00.330 ⇒ 00:38:02.300 Emily Giant: It’s… it’s… okay.
245 00:38:04.680 ⇒ 00:38:07.320 Emily Giant: So this is where it is wrong.
246 00:38:07.730 ⇒ 00:38:12.400 Emily Giant: Right here. It didn’t… unless it says that it’s deleted.
247 00:38:27.910 ⇒ 00:38:31.899 Emily Giant: Alright, so there’s gonna be a couple things that are not right about this.
248 00:38:32.210 ⇒ 00:38:33.970 Emily Giant: The first is that
249 00:38:34.410 ⇒ 00:38:44.489 Emily Giant: $0 revenue. Well, this is actually a question for Carrie, for Perry. We know that only this
250 00:38:44.910 ⇒ 00:38:48.539 Emily Giant: SKU, and this… so the parent SKU is the kit.
251 00:38:49.090 ⇒ 00:38:51.559 Emily Giant: But there was an at- this was the forced upgrade.
252 00:38:51.860 ⇒ 00:38:56.489 Demilade Agboola: Okay. We know that this was sent, we know that this was sent. This was deleted.
253 00:38:56.800 ⇒ 00:38:59.689 Demilade Agboola: And I do not see an indicator anywhere.
254 00:38:59.810 ⇒ 00:39:08.780 Emily Giant: that it was deleted in this model, so… So, first of all, like, Where’s the peace revenue?
255 00:39:09.500 ⇒ 00:39:14.229 Emily Giant: parent revenue, whatever. This does… doesn’t have any
256 00:39:15.240 ⇒ 00:39:20.180 Emily Giant: Like, technically, it doesn’t have any revenue associated with it, but…
257 00:39:21.450 ⇒ 00:39:32.119 Emily Giant: so this is where I get confused about what revenue wants. Like, how do they want to see this? Do they want to see the money that should have been allocated to the SKU that was upgraded?
258 00:39:32.250 ⇒ 00:39:36.819 Emily Giant: allocated To the new one, and this one’s set to zero?
259 00:39:37.110 ⇒ 00:39:42.059 Emily Giant: Or do they want this to show, like, actually, this was not what produced the revenue?
260 00:39:42.330 ⇒ 00:39:46.629 Emily Giant: It was this, but this was sent. For $0 revenue.
261 00:39:47.010 ⇒ 00:39:54.110 Emily Giant: Because that, in my mind, is what’s true. Like, this is what made the person buy the kit. This is what…
262 00:39:54.390 ⇒ 00:39:56.509 Emily Giant: But I don’t know if that’s what they want to see.
263 00:39:57.070 ⇒ 00:40:01.319 Demilade Agboola: But I think they could also have different purposes, in the sense that
264 00:40:01.490 ⇒ 00:40:14.009 Demilade Agboola: You could have both, and then being able to see, like, unrealized revenue, for instance. So, like, how much more money did we have to spend, or how much less money did we spend by replacing these things?
265 00:40:14.350 ⇒ 00:40:14.770 Emily Giant: Yes.
266 00:40:14.880 ⇒ 00:40:32.739 Demilade Agboola: both would be helpful, but being able to flag both, like, the actual order versus what was the shipped order, like, those two things would be very important. So it’s important, like, for instance, you know that the initial order was, say, 50 item.
267 00:40:34.740 ⇒ 00:40:42.900 Demilade Agboola: Or it was initially an 100 item.
268 00:40:43.050 ⇒ 00:40:47.519 Demilade Agboola: I’m pretty sure Revenue would want to keep track of these disparities both ways.
269 00:40:47.720 ⇒ 00:40:58.519 Emily Giant: Yeah, totally. That sounds like a real value add, being able to analyze that. However, this shouldn’t be here.
270 00:40:58.740 ⇒ 00:41:01.800 Emily Giant: It should say it’s deleted somewhere, and it just doesn’t.
271 00:41:02.510 ⇒ 00:41:03.180 Demilade Agboola: Yep.
272 00:41:03.610 ⇒ 00:41:07.440 Demilade Agboola: Okay, so it shouldn’t be in this model, but it should exist, basically.
273 00:41:07.870 ⇒ 00:41:14.359 Emily Giant: Yes. Or it can exist in this model, it just needs to say that it was deleted.
274 00:41:14.360 ⇒ 00:41:16.009 Demilade Agboola: Okay, fair, fair, fair.
275 00:41:17.400 ⇒ 00:41:21.569 Emily Giant: And what’s wild is it actually does say that in…
276 00:41:23.100 ⇒ 00:41:29.230 Emily Giant: it does say that in this, right? That that particular FLRLB.
277 00:41:31.760 ⇒ 00:41:33.579 Emily Giant: Oh yeah, it’s not even in there.
278 00:41:38.820 ⇒ 00:41:46.810 Emily Giant: So, yeah, something is… it’s exactly what you said before of, like, so… it really showed everything that…
279 00:41:47.010 ⇒ 00:41:49.639 Emily Giant: Showed the opposite of….
280 00:41:50.340 ⇒ 00:41:56.860 Demilade Agboola: Alright, so for this drive-through, the problem is the base should be the line items, not displayed line items.
281 00:41:58.410 ⇒ 00:41:59.710 Emily Giant: I think so.
282 00:41:59.970 ⇒ 00:42:05.360 Demilade Agboola: Yeah, so, like, if you look at the logic, The base is the…
283 00:42:06.020 ⇒ 00:42:08.420 Demilade Agboola: The one that only has one row.
284 00:42:08.550 ⇒ 00:42:14.129 Demilade Agboola: Rather than… So only one row pops up at the end of the join, the left join.
285 00:42:16.430 ⇒ 00:42:18.030 Emily Giant: I’m looking at the wrong one.
286 00:42:18.280 ⇒ 00:42:18.900 Demilade Agboola: Yep.
287 00:42:23.080 ⇒ 00:42:26.330 Emily Giant: Yeah, this should be staging split line items.
288 00:42:27.440 ⇒ 00:42:28.230 Emily Giant: And….
289 00:42:28.600 ⇒ 00:42:32.189 Demilade Agboola: No, it actually, you know, splits only has one girl.
290 00:42:32.830 ⇒ 00:42:38.120 Emily Giant: That’s right. Sorry, it’s so… Yes. Reverse in my brain.
291 00:42:40.370 ⇒ 00:42:41.350 Emily Giant: Okay.
292 00:42:47.910 ⇒ 00:42:50.310 Emily Giant: Left joins drive-through using ID.
293 00:42:53.000 ⇒ 00:42:54.600 Emily Giant: So if we…
294 00:42:55.610 ⇒ 00:43:02.640 Emily Giant: So my concern is that it truly did switch, so if we… if we need to time box this with historical after we…
295 00:43:03.010 ⇒ 00:43:05.480 Emily Giant: Prove that it actually did change.
296 00:43:06.040 ⇒ 00:43:09.740 Emily Giant: how the data… output looks.
297 00:43:10.870 ⇒ 00:43:12.280 Emily Giant: After the migration.
298 00:43:12.750 ⇒ 00:43:13.460 Emily Giant: Okay.
299 00:43:15.820 ⇒ 00:43:26.250 Emily Giant: Mmm, excuse me. Alright, so we base as… We’re saying strikethrough should be… Still that, right?
300 00:43:26.970 ⇒ 00:43:27.750 Demilade Agboola: Yeah.
301 00:43:28.560 ⇒ 00:43:32.459 Demilade Agboola: But… Yeah, so I’m….
302 00:43:32.460 ⇒ 00:43:34.679 Emily Giant: So is it the base should be….
303 00:43:35.550 ⇒ 00:43:36.650 Demilade Agboola: staging….
304 00:43:39.300 ⇒ 00:43:40.060 Emily Giant: No.
305 00:43:40.600 ⇒ 00:43:42.890 Demilade Agboola: Yeah, so the base should be staging.
306 00:43:43.820 ⇒ 00:43:47.369 Demilade Agboola: Or, like… sorry, what am I saying, staging? It should be the….
307 00:43:47.630 ⇒ 00:43:48.970 Emily Giant: staging line items.
308 00:43:48.970 ⇒ 00:43:55.539 Demilade Agboola: Yeah, or in this case, if… so I was doing a left join, it would probably be…
309 00:43:58.090 ⇒ 00:44:01.200 Demilade Agboola: Yeah, so the base should be… you don’t know what’s that bind.
310 00:44:04.490 ⇒ 00:44:06.059 Demilade Agboola: Gotcha. ….
311 00:44:06.060 ⇒ 00:44:14.029 Emily Giant: Well, this is, like, a totally unnecessary CTE, isn’t it? Like, why do people do that? Like, just select everything without doing anything.
312 00:44:14.570 ⇒ 00:44:27.720 Demilade Agboola: Yeah, I’m not the biggest fan, and I think it’s specifically more annoying when it’s not like you need to reduce the number of columns you’re calling, or literally specify the columns that you’re calling. It just feels very…
313 00:44:28.440 ⇒ 00:44:29.999 Demilade Agboola: Like, what are we doing?
314 00:44:30.200 ⇒ 00:44:31.310 Emily Giant: flabby.
315 00:44:31.590 ⇒ 00:44:32.400 Demilade Agboola: Yeah.
316 00:44:32.610 ⇒ 00:44:34.420 Demilade Agboola: Not the biggest fan, not the biggest fan.
317 00:44:34.420 ⇒ 00:44:41.150 Emily Giant: Me neither. I always thought maybe there was something I didn’t understand, but then I was like, I don’t think so. I think it’s a…
318 00:44:41.350 ⇒ 00:44:43.430 Emily Giant: Lazy.
319 00:44:44.270 ⇒ 00:44:47.460 Demilade Agboola: Yeah, it’s… it’s… it’s quite something.
320 00:44:49.030 ⇒ 00:44:54.170 Emily Giant: So, with Stripe Through Ask Select, I’m just gonna combine these.
321 00:44:54.560 ⇒ 00:45:03.910 Emily Giant: So the ID… Should be from staging… line items.
322 00:45:09.390 ⇒ 00:45:11.280 Emily Giant: has been deleted.
323 00:45:12.460 ⇒ 00:45:15.479 Emily Giant: It’s from also staging line items.
324 00:45:19.310 ⇒ 00:45:20.150 Demilade Agboola: ….
325 00:45:20.640 ⇒ 00:45:22.160 Emily Giant: What is ID?
326 00:45:22.430 ⇒ 00:45:24.169 Emily Giant: Is that suborder ID?
327 00:45:27.030 ⇒ 00:45:28.050 Emily Giant: Hold on.
328 00:45:35.670 ⇒ 00:45:41.150 Demilade Agboola: Also, yeah, I was curious why you didn’t just, like, why it’s not joined using the order ID.
329 00:45:43.300 ⇒ 00:45:46.289 Emily Giant: Yeah, that’s what’s weird to me. It’s like…
330 00:45:47.000 ⇒ 00:45:51.900 Emily Giant: Oh, maybe suborder ID. When there’s multiple suborders, they need to split it that way.
331 00:45:51.900 ⇒ 00:45:52.960 Demilade Agboola: I, I gave….
332 00:45:52.960 ⇒ 00:45:55.420 Emily Giant: The ID is suborder ID, I just don’t know.
333 00:45:55.920 ⇒ 00:45:59.830 Demilade Agboola: Yeah, so ID is a combo of the suborder ID and the product SKU.
334 00:46:00.100 ⇒ 00:46:01.490 Emily Giant: Oh, okay.
335 00:46:04.030 ⇒ 00:46:07.699 Demilade Agboola: Because I’m looking at you right now, and that’s the only… that’s how the numbers enter.
336 00:46:08.880 ⇒ 00:46:09.400 Demilade Agboola: Public.
337 00:46:11.510 ⇒ 00:46:13.440 Emily Giant: Correct you are.
338 00:46:18.490 ⇒ 00:46:20.080 Emily Giant: Yep, yep, yep, okay.
339 00:46:23.810 ⇒ 00:46:27.350 Emily Giant: What is it partitioned by? The order?
340 00:46:29.820 ⇒ 00:46:40.009 Emily Giant: Oh, no, I got you. Okay, sorry. So, this is staging line items dot has been deleted over partition by ID. Good, good, good. And then…
341 00:46:41.250 ⇒ 00:46:47.449 Emily Giant: From staging line items… Those are not gonna be in common, though. This is what I’m saying, like…
342 00:46:49.940 ⇒ 00:46:54.620 Emily Giant: how are these joining in any way? With kits. I don’t get it.
343 00:46:55.920 ⇒ 00:47:00.189 Emily Giant: Because the FLRLK is not present.
344 00:47:00.320 ⇒ 00:47:03.040 Emily Giant: So, like, how would these join on ID?
345 00:47:18.330 ⇒ 00:47:20.709 Demilade Agboola: Sorry, I didn’t get the question, I was… a message just came in.
346 00:47:20.980 ⇒ 00:47:30.920 Emily Giant: No worries, … I do not understand how using ID to join makes sense, and I’m willing to…
347 00:47:31.070 ⇒ 00:47:36.010 Emily Giant: Except that I’m wrong here. But, if we’re left joining by ID,
348 00:47:36.390 ⇒ 00:47:39.140 Emily Giant: There’s no… there’s no common ID.
349 00:47:39.670 ⇒ 00:47:40.610 Emily Giant: Like, I don’t….
350 00:47:43.050 ⇒ 00:47:43.540 Demilade Agboola: Aww.
351 00:47:43.540 ⇒ 00:47:50.950 Emily Giant: Is that intentional? Like, they don’t want… they don’t want to obscure anything, and they want to maintain the FLRLK,
352 00:47:51.150 ⇒ 00:47:58.170 Emily Giant: even… so what I… let me show you, unless you already, like, are picking up what I’m putting down, but…
353 00:47:58.530 ⇒ 00:48:05.749 Emily Giant: we’re joining by ID. We know what the ID looks like in staging split line items. It’s the suborder plus the piece product SKU.
354 00:48:05.880 ⇒ 00:48:07.260 Emily Giant: But in this
355 00:48:10.600 ⇒ 00:48:12.449 Emily Giant: Okay, that’s the old example.
356 00:48:14.120 ⇒ 00:48:15.329 Emily Giant: So that doesn’t count.
357 00:48:22.600 ⇒ 00:48:24.839 Emily Giant: So in our modern-day example.
358 00:48:30.250 ⇒ 00:48:35.899 Emily Giant: This ID is not going to ever appear in that other table, so what are we joining?
359 00:48:36.460 ⇒ 00:48:38.730 Emily Giant: We’re just making sure all of it’s there?
360 00:48:41.170 ⇒ 00:48:47.109 Demilade Agboola: … Wait, it never appears in the other table?
361 00:48:47.320 ⇒ 00:48:50.029 Emily Giant: So, if the two ones we’re working with.
362 00:48:50.070 ⇒ 00:48:51.050 Demilade Agboola: Yeah, yeah.
363 00:48:51.050 ⇒ 00:48:51.980 Emily Giant: TID.
364 00:48:53.330 ⇒ 00:48:59.700 Demilade Agboola: Oh yeah, so basically it’s just the… it’s just the kit number, and then the other one is, like, the individual, like.
365 00:48:59.930 ⇒ 00:49:01.510 Demilade Agboola: combinations, basically.
366 00:49:02.190 ⇒ 00:49:04.539 Emily Giant: So that kit number never appears.
367 00:49:05.280 ⇒ 00:49:08.379 Emily Giant: is an ID. And that might be intentional.
368 00:49:08.600 ⇒ 00:49:11.340 Emily Giant: So that everything is maintained.
369 00:49:11.770 ⇒ 00:49:20.350 Emily Giant: But for me, without a parent SKU that is always appended to those kits, this is not gonna work.
370 00:49:20.350 ⇒ 00:49:23.149 Demilade Agboola: Oh, yeah, yeah, I get what you mean. No, yeah, no, I get what you’re talking about.
371 00:49:23.150 ⇒ 00:49:23.910 Emily Giant: Okay.
372 00:49:24.530 ⇒ 00:49:26.589 Demilade Agboola: I’m picking it up. …
373 00:49:26.700 ⇒ 00:49:33.210 Demilade Agboola: Yeah, it’s definitely not gonna work. It’s… it’s not… doesn’t have the right level to join.
374 00:49:33.380 ⇒ 00:49:34.330 Emily Giant: Right.
375 00:49:34.530 ⇒ 00:49:36.050 Demilade Agboola: ….
376 00:49:41.780 ⇒ 00:49:48.490 Emily Giant: And that’s where I thought maybe… so there is some… in OMS… …
377 00:49:48.790 ⇒ 00:49:56.320 Emily Giant: Only because, like, when I disappeared for 2 weeks fixing stuff, it was all this kind of stuff. It was the OMS…
378 00:49:56.510 ⇒ 00:49:58.869 Emily Giant: Comp base.
379 00:50:00.000 ⇒ 00:50:04.419 Emily Giant: So what I was hoping out of the Shopify tables is that they have a better…
380 00:50:04.790 ⇒ 00:50:12.530 Emily Giant: output of the components of kits and how they’re related to each other. So that, like, that table never outputs
381 00:50:13.080 ⇒ 00:50:19.760 Emily Giant: only a parent ID of the SKU, but it will always have, like, both…
382 00:50:19.890 ⇒ 00:50:36.120 Emily Giant: like, there would be, in front of this, like, parent SKU, FLRLK, FLRLK, and then when this doesn’t fit in there… but they just need to exist in the same table at some point earlier than when they do, or there’s no way to show that there’s a strikethrough.
383 00:50:38.170 ⇒ 00:50:38.870 Demilade Agboola: Yeah.
384 00:50:39.360 ⇒ 00:50:40.410 Demilade Agboola: Because they’re….
385 00:50:40.530 ⇒ 00:50:41.190 Emily Giant: Yeah.
386 00:50:41.500 ⇒ 00:50:46.910 Demilade Agboola: The join won’t happen, and if the join doesn’t happen, you can’t transfer the has-been-deleted information.
387 00:50:47.080 ⇒ 00:50:51.430 Emily Giant: Yeah, exactly. So this one does have a lot of that, like.
388 00:50:51.960 ⇒ 00:50:54.760 Emily Giant: Logic in it that you think would…
389 00:50:55.340 ⇒ 00:50:58.840 Emily Giant: successfully pair parent and piece SKUs.
390 00:50:58.970 ⇒ 00:51:05.960 Emily Giant: And then the work that I need to deploy is all, like, changing over… …
391 00:51:06.480 ⇒ 00:51:19.679 Emily Giant: the SKU tables to, polyatomic, so that, like, they’re way more reliable, having peace and parent relationships, but it’s still, like, not one-to-one. And…
392 00:51:19.840 ⇒ 00:51:27.060 Emily Giant: It’s better, but it’s gonna break again at some point. Where’s that OMS comp base? I’m gonna look at this table again.
393 00:51:29.290 ⇒ 00:51:33.270 Demilade Agboola: So it does seem like the problem is that we don’t have the appropriate keys needed.
394 00:51:33.700 ⇒ 00:51:34.720 Emily Giant: Yeah, correct.
395 00:51:35.000 ⇒ 00:51:37.709 Emily Giant: Like, it’s just a… it’s dead in the water.
396 00:51:41.330 ⇒ 00:51:43.599 Emily Giant: Yeah, there’s no way to ever…
397 00:51:43.770 ⇒ 00:51:46.360 Emily Giant: Parse out that this was deleted.
398 00:51:47.240 ⇒ 00:51:50.010 Emily Giant: Because this and this never have a relationship.
399 00:51:50.060 ⇒ 00:51:51.900 Demilade Agboola: In any of those stream tables.
400 00:51:55.350 ⇒ 00:52:01.149 Emily Giant: But where is that? I just want to see, in my Looker report… okay, I was like, if I X’d out of that…
401 00:52:02.460 ⇒ 00:52:05.250 Emily Giant: If that was true, historically.
402 00:52:06.380 ⇒ 00:52:08.340 Emily Giant: Because I truly don’t think it was.
403 00:52:16.320 ⇒ 00:52:18.450 Emily Giant: What? Oh, sorry.
404 00:52:33.460 ⇒ 00:52:36.100 Emily Giant: No, I think our revenue’s just been fucked forever.
405 00:52:39.350 ⇒ 00:52:40.130 Demilade Agboola: Yay.
406 00:52:40.130 ⇒ 00:52:41.710 Emily Giant: The exact same problem.
407 00:52:45.710 ⇒ 00:52:47.759 Demilade Agboola: It doesn’t seem like it’s been in a good place.
408 00:52:49.990 ⇒ 00:52:51.170 Demilade Agboola: In quite some time.
409 00:52:51.410 ⇒ 00:52:58.160 Emily Giant: At least we don’t have to worry about, disrupting historical data.
410 00:52:58.330 ⇒ 00:53:00.040 Emily Giant: It’s already disrupted.
411 00:53:00.940 ⇒ 00:53:03.050 Emily Giant: There’s nothing to maintain here.
412 00:53:05.450 ⇒ 00:53:10.830 Emily Giant: What? This is such garbage! I’m so mad.
413 00:53:12.990 ⇒ 00:53:15.380 Emily Giant: Ugh… okay.
414 00:53:19.590 ⇒ 00:53:26.279 Emily Giant: Yep, nothing to see here, folks. Just always… our revenue’s always been misrepresented. No problemo.
415 00:53:27.930 ⇒ 00:53:29.730 Emily Giant: It’s insane.
416 00:53:35.830 ⇒ 00:53:42.819 Emily Giant: I want to see what this actually looks like in Dash, though. So, 77 plus 85 plus 28.
417 00:53:45.730 ⇒ 00:53:47.059 Emily Giant: And we know.
418 00:53:48.080 ⇒ 00:53:52.629 Emily Giant: that… This never got sent, so…
419 00:53:54.190 ⇒ 00:53:57.050 Emily Giant: how are we functioning? How are we functioning?
420 00:54:02.880 ⇒ 00:54:05.119 Emily Giant: Yeah, okay, so…
421 00:54:08.810 ⇒ 00:54:12.250 Emily Giant: They paid a hundred and… $50?
422 00:54:14.190 ⇒ 00:54:18.550 Emily Giant: And we’re saying that they… Scent.
423 00:54:22.870 ⇒ 00:54:25.099 Emily Giant: Not that far off, it’s only a couple of…
424 00:54:27.800 ⇒ 00:54:29.599 Emily Giant: It’s only a little bit more than that.
425 00:54:32.700 ⇒ 00:54:40.330 Emily Giant: 140… 160-something. It’s… yeah, it’s not good.
426 00:54:44.130 ⇒ 00:54:48.600 Emily Giant: Anyway… You see, you see my dilemma.
427 00:54:48.990 ⇒ 00:54:52.170 Demilade Agboola: Yes, it’s quite… it’s quite hard to tag.
428 00:54:52.770 ⇒ 00:54:56.700 Demilade Agboola: All the information back together, and then go, hey, this is our revenue.
429 00:54:56.700 ⇒ 00:55:08.170 Emily Giant: Yeah. So that’s why I’m wondering, like, since this table is not useful from the get-go, like, is there something in Shopify products that more consistently ties
430 00:55:08.290 ⇒ 00:55:13.889 Emily Giant: the kitty… SKU to the components of the kitted skew in one table.
431 00:55:13.890 ⇒ 00:55:18.560 Demilade Agboola: Okay, yeah, I’ll dig into that, basically. I think that’s what I should focus on.
432 00:55:18.560 ⇒ 00:55:19.849 Emily Giant: Yeah, I agree.
433 00:55:20.450 ⇒ 00:55:25.310 Emily Giant: And then if not, like, what can we do in Hivo? Because we do have
434 00:55:25.480 ⇒ 00:55:31.180 Emily Giant: we can change what comes out in the HEVO tables, but it’s not fun, and…
435 00:55:31.300 ⇒ 00:55:35.030 Emily Giant: we’ll have to manage it from that point forward, but…
436 00:55:35.880 ⇒ 00:55:45.030 Emily Giant: And, like, is this something for Polytomic, if Shopify doesn’t output something? Because we need this information, or revenue will never be correct.
437 00:55:45.030 ⇒ 00:55:50.639 Demilade Agboola: Yeah. Also, I think it also could also be a function of what goes in.
438 00:55:51.240 ⇒ 00:55:51.800 Emily Giant: Hmm.
439 00:55:52.320 ⇒ 00:55:55.800 Demilade Agboola: How maybe you tag things in the different systems?
440 00:55:55.930 ⇒ 00:56:01.140 Demilade Agboola: would also influence that. So we’ll basically just go through, I’ll do an investigation, like, I’ll tell,
441 00:56:01.920 ⇒ 00:56:10.899 Demilade Agboola: I’ll tell Amber to create a spike ticket, so I can just quickly go through, come to some understanding of that, and then we can try to…
442 00:56:12.210 ⇒ 00:56:16.460 Demilade Agboola: See how that will, play out in everything else.
443 00:56:16.900 ⇒ 00:56:23.300 Emily Giant: Yep, I think there is a spike ticket that’s currently assigned to me, but I will switch it to you, because I think you’re gonna need…
444 00:56:24.640 ⇒ 00:56:31.210 Emily Giant: To, like, it’s a good thing for you as, like, the lead developer on this to, like, grasp, and then delegate from there.
445 00:56:31.210 ⇒ 00:56:31.560 Demilade Agboola: But this is….
446 00:56:31.720 ⇒ 00:56:34.960 Emily Giant: Actually, what… This ticket is.
447 00:56:35.180 ⇒ 00:56:36.660 Demilade Agboola: Oh, okay, fair enough, fair enough.
448 00:56:37.560 ⇒ 00:56:40.310 Emily Giant: Well, is it… Mmm….
449 00:56:42.710 ⇒ 00:56:56.630 Demilade Agboola: Because this is more of, like, this feels like Shopify back to NetSuite. Yeah. We’re just talking, like, Shopify in general, like, are we able to find ways to be able to keep track of everything that’s happening in Shopify at one?
450 00:56:57.380 ⇒ 00:57:06.150 Emily Giant: Yeah, so, okay, then Amber does need to create a new ticket. Also, this is done. It only ever quantifies the piece SKU. So, I’m gonna close this.
451 00:57:08.220 ⇒ 00:57:15.780 Emily Giant: Alright, cool. Alright, well, let me know if you have any other questions. If I have time today, I’ll do some digging also.
452 00:57:16.030 ⇒ 00:57:17.390 Demilade Agboola: Okay, sounds good.
453 00:57:17.390 ⇒ 00:57:23.040 Emily Giant: Alright, cool. I hope that was helpful, and, enjoy your coffee.
454 00:57:23.430 ⇒ 00:57:24.880 Demilade Agboola: Alright, will do.
455 00:57:26.310 ⇒ 00:57:27.070 Demilade Agboola: That’s a gooda.
456 00:57:27.340 ⇒ 00:57:27.910 Emily Giant: Bye.