Meeting Title: Forced Upgrade Data Debugging Session Date: 2025-08-05 Meeting participants: Demilade Agboola, Emily Giant
WEBVTT
1 00:02:45.160 ⇒ 00:02:46.290 Emily Giant: Hello!
2 00:02:48.370 ⇒ 00:02:49.449 Demilade Agboola: I am Lee.
3 00:02:50.460 ⇒ 00:02:51.789 Emily Giant: Are you feeling better?
4 00:02:52.270 ⇒ 00:03:02.700 Demilade Agboola: Yeah. I literally have no idea what happened yesterday. I went swimming in the morning, or from my swimming class in the morning. Then, when I got back
5 00:03:02.970 ⇒ 00:03:05.050 Demilade Agboola: throughout the day, I was just nauseous.
6 00:03:05.800 ⇒ 00:03:06.390 Demilade Agboola: I’ll send it.
7 00:03:06.390 ⇒ 00:03:07.240 Emily Giant: Man.
8 00:03:07.380 ⇒ 00:03:17.189 Demilade Agboola: My coach about it, and he was saying that sometimes people when they like get pool water in them, they get very like nauseous.
9 00:03:17.310 ⇒ 00:03:18.180 Demilade Agboola: It says.
10 00:03:18.180 ⇒ 00:03:19.809 Emily Giant: That makes sense. I mean.
11 00:03:19.950 ⇒ 00:03:29.990 Emily Giant: if you’re getting chlorine in your system, that would probably make you feel pretty bad. But even like sometimes when I. This is more like bodies of water, but.
12 00:03:30.215 ⇒ 00:03:30.440 Demilade Agboola: Bye.
13 00:03:30.440 ⇒ 00:03:41.759 Emily Giant: Sometimes when I’m in a body of water for an extended period of time, I’ll get really nauseated just because of like the waves. I get like vertigo, and it can make me feel pretty nauseous.
14 00:03:42.040 ⇒ 00:03:43.420 Demilade Agboola: That’s fair. That’s fair.
15 00:03:43.420 ⇒ 00:03:45.630 Emily Giant: Yeah. How’s the swimming going?
16 00:03:48.320 ⇒ 00:03:55.259 Demilade Agboola: it’s better. I I was able to. I had like, I mean, with my flotation device. I’m not drowning. That’s fine.
17 00:03:55.260 ⇒ 00:03:55.780 Emily Giant: Yeah.
18 00:03:57.244 ⇒ 00:04:02.630 Demilade Agboola: I was able to swim like today. I was able to swim about half the length of the pool in one. Go.
19 00:04:04.352 ⇒ 00:04:05.859 Demilade Agboola: So that’s progress.
20 00:04:05.860 ⇒ 00:04:06.420 Emily Giant: Yeah.
21 00:04:06.420 ⇒ 00:04:10.799 Demilade Agboola: Yeah. But obviously it was still with the partition device. But it’s still something cause like literally.
22 00:04:10.800 ⇒ 00:04:11.460 Emily Giant: Yeah.
23 00:04:11.640 ⇒ 00:04:13.510 Demilade Agboola: And that’s just my 3rd class. So.
24 00:04:13.980 ⇒ 00:04:32.790 Emily Giant: Yeah. Oh, you’ll get there. You’re so athletic, too, that like once you get that you won’t like. Have the cardio element working against you since you played soccer, like, I think if you were not in like cardiovascular shape it would be super hard, because swimming like takes it out of you. But I yeah.
25 00:04:33.360 ⇒ 00:04:40.120 Demilade Agboola: It’s just hard to keep kicking. To be honest, I’m just like, is this what everyone’s do? Who lied? I said.
26 00:04:40.485 ⇒ 00:04:50.349 Emily Giant: Is this what everyone’s doing? Yeah, no, I’m not a good swimmer at all. I wind up, using my arms way too much. And exhausting myself.
27 00:04:50.600 ⇒ 00:04:54.239 Demilade Agboola: Yeah, it’s it’s it’s quite something. I’m just.
28 00:04:54.240 ⇒ 00:04:54.750 Emily Giant: Hey?
29 00:04:55.540 ⇒ 00:05:07.595 Emily Giant: It is you’re inspiring me. I feel like I should take swim classes. I I’m with friends in the mountains, and we’re all working like we’re all on calls right now. But
30 00:05:08.320 ⇒ 00:05:22.639 Emily Giant: they they’re sailors, and I’m like I would love to sail, but I’m afraid I’m gonna fall off that boat and sink. I don’t know what I would do to save myself, so I’m inspired.
31 00:05:22.820 ⇒ 00:05:25.089 Demilade Agboola: I think we should learn swimming first, st at least.
32 00:05:25.090 ⇒ 00:05:26.150 Emily Giant: Yeah, yeah.
33 00:05:26.150 ⇒ 00:05:34.149 Demilade Agboola: Even if you can’t swim. I know I do know that, like the idea, if you fall in like an ocean and stuff is that you’re supposed to stay afloat.
34 00:05:34.460 ⇒ 00:05:35.200 Emily Giant: Yes.
35 00:05:35.650 ⇒ 00:05:38.050 Demilade Agboola: Blue in, because it’s quite big, and all of that.
36 00:05:38.420 ⇒ 00:05:45.580 Emily Giant: Yeah, like, you can actually lay there probably for hours until you get eaten by a shark. So yeah.
37 00:05:45.580 ⇒ 00:05:58.850 Demilade Agboola: Which is another. I probably need to stay afloat. You need to do like some certain motion that, like my coach was doing. And I’m like. So you mean you can’t just like lay there and stay afloat. He’s like well, not really, unless you lie on your back.
38 00:05:59.500 ⇒ 00:06:04.960 Emily Giant: Yep, you can lie on your back, and like they taught us this a little bit when I learned diving scuba diving.
39 00:06:05.100 ⇒ 00:06:22.929 Emily Giant: But I. It’s always several years in between when I go so like I have to relearn every time. It’s like pressing a reset button every time I go diving, so if I did it more consistently that I would probably remember how to float. I mean that you have a thing that you can inflate, but
40 00:06:23.130 ⇒ 00:06:26.629 Emily Giant: but still and that you’re still doing tennis.
41 00:06:27.430 ⇒ 00:06:43.444 Demilade Agboola: Oh, yeah, I played like for 2 h on Saturday. I’m looking for a hitting partner on Facebook. But for some reason no one’s replying my post. I don’t know why. But I will say I still have coach. I stopped my coaching.
42 00:06:44.160 ⇒ 00:06:46.790 Demilade Agboola: I was just showing my coach on Saturday.
43 00:06:47.890 ⇒ 00:06:52.179 Demilade Agboola: I will give you my feedback from my games. I played on Saturday.
44 00:06:52.480 ⇒ 00:06:55.679 Demilade Agboola: and what I struggled with, what went well.
45 00:06:57.610 ⇒ 00:07:00.150 Demilade Agboola: and then we will take it from there
46 00:07:01.290 ⇒ 00:07:04.399 Demilade Agboola: and use it to, and then use it to improve.
47 00:07:04.520 ⇒ 00:07:09.909 Demilade Agboola: So I literally just watch, like I record myself while playing. Then I watch the videos. And I’m like, Oof, that was terrible
48 00:07:11.520 ⇒ 00:07:12.210 Demilade Agboola: terrible.
49 00:07:12.730 ⇒ 00:07:19.960 Emily Giant: Well, it’s so easy to like. Look at yourself from afar and be like, why did I do that? But when you’re doing it, it feels so good
50 00:07:20.070 ⇒ 00:07:26.780 Emily Giant: like I. I can imagine watching myself play tennis, and I always feel like I’m
51 00:07:26.900 ⇒ 00:07:32.829 Emily Giant: Serena Williams, and then, like I scale back. And I’m like, you are so bad at this. What’s happening?
52 00:07:33.370 ⇒ 00:07:34.850 Emily Giant: Oh, no, yeah.
53 00:07:35.050 ⇒ 00:07:39.960 Demilade Agboola: In the moment I actually get really hard on myself, like sometimes I I’m watching the video. And I’m just there like.
54 00:07:40.130 ⇒ 00:07:45.101 Demilade Agboola: just like, what was that like? You can literally see me in the video. Go! What the hell was that.
55 00:07:45.630 ⇒ 00:07:59.699 Emily Giant: Just getting so mad at yourself. That’s hilarious. I wish I if I lived nearby, I would totally play with you, although I have a feeling that you have advanced beyond my skill level at this point. But I do love playing tennis.
56 00:07:59.980 ⇒ 00:08:03.610 Demilade Agboola: Oh, no, I’m just like well, this is literally my
57 00:08:03.790 ⇒ 00:08:07.600 Demilade Agboola: 1st month clean like I’m not bad. And obviously
58 00:08:08.250 ⇒ 00:08:11.859 Demilade Agboola: I put my sister when I was in Luxembourg over the like, over the troop.
59 00:08:12.920 ⇒ 00:08:14.569 Demilade Agboola: And the clay cuts was really nice.
60 00:08:15.784 ⇒ 00:08:16.510 Demilade Agboola: But
61 00:08:17.000 ⇒ 00:08:23.299 Demilade Agboola: and obviously my sister, okay, not obviously. But my sister isn’t the most athletic person she never really like, liked or did a lot.
62 00:08:24.170 ⇒ 00:08:28.600 Demilade Agboola: Right now I am. In the other hand, I did a little bit more than her not.
63 00:08:28.600 ⇒ 00:08:29.070 Emily Giant: Yeah.
64 00:08:29.390 ⇒ 00:08:35.860 Demilade Agboola: But like I did a bit more so she’s been playing longer than I have, but
65 00:08:36.159 ⇒ 00:08:39.669 Demilade Agboola: I have like I was able to like win cause I was able.
66 00:08:39.679 ⇒ 00:08:40.279 Emily Giant: Hmm.
67 00:08:40.280 ⇒ 00:08:42.549 Demilade Agboola: I just have a little bit more in terms of.
68 00:08:42.559 ⇒ 00:08:43.089 Emily Giant: Yeah.
69 00:08:44.200 ⇒ 00:08:45.805 Demilade Agboola: Relative to her
70 00:08:47.640 ⇒ 00:08:50.270 Emily Giant: A little lesson goes a long way, like just
71 00:08:50.440 ⇒ 00:08:59.259 Emily Giant: some instruction goes a very long way, especially with tennis. There’s so much like nuance of like how to use your wrist
72 00:08:59.400 ⇒ 00:09:00.180 Emily Giant: that
73 00:09:00.450 ⇒ 00:09:11.980 Emily Giant: like in arms, like I I told you I just hit it like a volleyball with my hand every time, so if I can figure out the depth of like where the ball is, I’m okay. But, oh, my God! Have you ever played pickleball.
74 00:09:12.580 ⇒ 00:09:15.120 Demilade Agboola: No, I’ve seen videos. I’ve not played.
75 00:09:15.430 ⇒ 00:09:24.880 Emily Giant: Oh, people in the Us. Are obsessed with it. It’s because we’re not athletic enough to play tennis, and we want to do something. But
76 00:09:25.070 ⇒ 00:09:47.990 Emily Giant: it’s pretty fun, because you don’t have to have like that very high skill level. You can just kind of like jump in and play and not be terrible but I really want to pay as part of my driveway to make a pickleball court, so that I can like at least be kind of good, because I don’t like being bad at stuff. It’s not fun. I’ll do it. But like I’d rather be just kind of good, so that I’m not like
77 00:09:48.130 ⇒ 00:09:51.960 Emily Giant: pissed at myself the whole time, like you are with yourself playing tennis.
78 00:09:52.560 ⇒ 00:09:57.040 Demilade Agboola: Oh, well, to be fair, I’m pissed at myself all the time. It does. It’s not just a 10. It’s the.
79 00:09:57.776 ⇒ 00:10:00.719 Emily Giant: No, don’t say that.
80 00:10:00.720 ⇒ 00:10:04.700 Demilade Agboola: Kind of how I I improve. I’m like my harshest critic.
81 00:10:05.320 ⇒ 00:10:06.150 Emily Giant: Yeah.
82 00:10:06.150 ⇒ 00:10:11.050 Demilade Agboola: I’m literally the customer’s just like no, this I I need to. I need to make this work.
83 00:10:11.270 ⇒ 00:10:14.729 Demilade Agboola: How could I make such a mistake like I’m just constantly like on top like that.
84 00:10:14.730 ⇒ 00:10:15.320 Emily Giant: Yeah.
85 00:10:15.320 ⇒ 00:10:18.139 Demilade Agboola: Always the best thing, you know, but.
86 00:10:18.140 ⇒ 00:10:18.580 Emily Giant: Oh, yeah.
87 00:10:18.580 ⇒ 00:10:20.279 Demilade Agboola: We make you work, we make you work.
88 00:10:21.000 ⇒ 00:10:21.500 Emily Giant: Yeah.
89 00:10:21.500 ⇒ 00:10:30.942 Emily Giant: yeah, I’m I’m I can definitely empathize with that. You’re probably a little harder on yourself than I am on myself. But but I definitely know the feeling.
90 00:10:31.470 ⇒ 00:10:36.010 Emily Giant: so I’ve been speaking of working and being hard on myself, I’ve
91 00:10:37.010 ⇒ 00:10:42.409 Emily Giant: been working on just aligning some of the legacy stuff to
92 00:10:43.520 ⇒ 00:10:52.390 Emily Giant: to the updated inventory mark, and I’m almost there. It’s in a pretty good spot. I’ll probably deploy it today. But I I wanted to see like.
93 00:10:53.568 ⇒ 00:10:55.410 Emily Giant: I wanna make sure that
94 00:10:55.830 ⇒ 00:11:05.340 Emily Giant: when you’re working, or have you had a chance to look at the forced upgrade the new custom column, because I was thinking we could do that this morning
95 00:11:05.710 ⇒ 00:11:13.229 Emily Giant: unless you had something else that you wanted to go after, and just like knock that one out, because I think it’s just literally adding a column
96 00:11:13.420 ⇒ 00:11:14.890 Emily Giant: to those models.
97 00:11:15.883 ⇒ 00:11:20.269 Demilade Agboola: Yeah, we could do that. We could knock it out of the park today.
98 00:11:20.270 ⇒ 00:11:32.630 Emily Giant: We could, we could knock it out of the park and that way, like, because the changes so many of the changes that I’m gonna commit later
99 00:11:33.390 ⇒ 00:11:39.400 Emily Giant: could potentially affect those models that I don’t want you to waste your time like
100 00:11:39.880 ⇒ 00:11:47.379 Emily Giant: doing any of the renaming or stuff like that when I’m afraid, like, I’ll deploy this, and it will
101 00:11:47.810 ⇒ 00:11:53.350 Emily Giant: definitely touch the models that you’d be fixing. So if we did this together.
102 00:11:53.620 ⇒ 00:11:56.959 Emily Giant: then we could just avoid some of that like duplicate work.
103 00:11:58.050 ⇒ 00:11:59.540 Demilade Agboola: Sounds good.
104 00:12:00.050 ⇒ 00:12:03.599 Emily Giant: Okay, do you want to share screen? Or do you want me to share screen.
105 00:12:06.320 ⇒ 00:12:10.370 Demilade Agboola: You could. Okay, you could share screen. Let’s start with that. And I could just show you.
106 00:12:10.370 ⇒ 00:12:11.040 Emily Giant: Okay.
107 00:12:19.010 ⇒ 00:12:35.390 Emily Giant: I wish my camera was better, because there is the cutest dog that is laying like a human being on this like this bed like his head was on the pillow, sprawled like a human. And I would show you. But my camera is.
108 00:12:36.060 ⇒ 00:12:40.349 Emily Giant: it’s terrible on my computer. I so I have it off.
109 00:12:40.640 ⇒ 00:12:45.139 Emily Giant: Next time I go on a trip and I’m still working. I need to bring my camera with me.
110 00:12:45.967 ⇒ 00:12:49.789 Emily Giant: Okay. So I’m gonna create a new branch
111 00:12:58.230 ⇒ 00:13:01.490 Emily Giant: and oh, forced upgrade.
112 00:13:09.560 ⇒ 00:13:10.300 Emily Giant: Okay?
113 00:13:12.820 ⇒ 00:13:22.239 Emily Giant: So I believe that it’s in transaction and transaction line the 2 new. I’m gonna look at Alex’s ticket.
114 00:13:35.700 ⇒ 00:13:40.470 Emily Giant: What is that ticket called? Also? It’s filtered for me, and I think it’s on yours.
115 00:13:43.413 ⇒ 00:13:45.479 Demilade Agboola: The one for me is.
116 00:13:49.010 ⇒ 00:13:50.669 Demilade Agboola: yeah, that one.
117 00:13:50.670 ⇒ 00:13:51.320 Emily Giant: There you go.
118 00:13:52.020 ⇒ 00:13:57.599 Emily Giant: Okay. So this one is, oh, that’s for subscriptions that’s cool. And then
119 00:13:58.390 ⇒ 00:14:06.649 Emily Giant: redelivery and force upgrade. Oh, wow! Okay, so these are all going to be like native in netsuite.
120 00:14:06.650 ⇒ 00:14:07.280 Demilade Agboola: Yeah.
121 00:14:08.060 ⇒ 00:14:14.659 Emily Giant: Instead of well, I I feel like I’d like to keep the ones we have.
122 00:14:14.760 ⇒ 00:14:30.320 Emily Giant: and just make sure that these work correctly, because Netsuite is shitty, and I feel like half of the fields that Dev thinks work don’t like. The is closed, is supposed to indicate that the order was cancelled. And it is.
123 00:14:31.940 ⇒ 00:14:37.360 Emily Giant: it indicates that maybe 10% of the time. So let’s
124 00:14:37.600 ⇒ 00:14:40.449 Emily Giant: make sure it’s working in the data.
125 00:14:53.580 ⇒ 00:14:54.290 Emily Giant: Bye.
126 00:14:58.350 ⇒ 00:15:01.020 Emily Giant: Oh, I think I need to pull up the raw, raw table. Hold on!
127 00:15:06.890 ⇒ 00:15:09.919 Emily Giant: Can’t remember what those tables are called polytomic.
128 00:15:10.890 ⇒ 00:15:15.330 Demilade Agboola: Oh, yeah, netsuite underscore Polycom.
129 00:15:15.330 ⇒ 00:15:15.980 Emily Giant: Hang on
130 00:15:26.360 ⇒ 00:15:29.474 Emily Giant: which one was it Costco? Or separate?
131 00:15:30.040 ⇒ 00:15:33.880 Emily Giant: That’s the most important one. So that’s probably 1st upgrade
132 00:15:53.980 ⇒ 00:15:59.309 Emily Giant: alright. So if we add this, and then can validate that it works correctly. We can
133 00:16:03.720 ⇒ 00:16:07.180 Emily Giant: We can unhide the things in the inventory. Mart.
134 00:16:07.380 ⇒ 00:16:12.880 Emily Giant: The the other thing I wanted to check with you was that like where we’re at, with
135 00:16:14.070 ⇒ 00:16:15.729 Emily Giant: having only, like
136 00:16:16.160 ⇒ 00:16:22.360 Emily Giant: the inventory balance and the inventory adjustments in one mark model instead of 2, and making sure that those numbers like
137 00:16:22.630 ⇒ 00:16:26.619 Emily Giant: roll up correctly. If we’re to remove like
138 00:16:27.050 ⇒ 00:16:33.020 Emily Giant: or point man, dang it, it doesn’t look like this is pulling anything.
139 00:16:33.420 ⇒ 00:16:34.480 Demilade Agboola: Yeah.
140 00:16:37.860 ⇒ 00:16:42.320 Emily Giant: And I mean there’s just no way that there aren’t any forced upgrades.
141 00:16:43.130 ⇒ 00:16:45.170 Emily Giant: It happens every single day.
142 00:16:46.880 ⇒ 00:16:48.430 Emily Giant: Let me try the other ones.
143 00:17:11.980 ⇒ 00:17:12.759 Emily Giant: You did
144 00:17:49.230 ⇒ 00:17:56.999 Emily Giant: alright. Well, that’s pulling. I’m gonna try and find a forced upgrade from yesterday.
145 00:17:57.810 ⇒ 00:17:58.660 Demilade Agboola: Okay.
146 00:17:59.720 ⇒ 00:18:01.700 Emily Giant: Don’t understand.
147 00:19:06.790 ⇒ 00:19:08.180 Emily Giant: Okay, so this one works.
148 00:19:12.590 ⇒ 00:19:17.449 Demilade Agboola: So the transaction. But how do we know the support? Id. Though, that it falls on a.
149 00:19:18.791 ⇒ 00:19:26.360 Emily Giant: We’re gonna have to join it. We can use the master order number here. Let’s do best body
150 00:19:28.440 ⇒ 00:19:30.450 Emily Giant: master order id.
151 00:19:31.430 ⇒ 00:19:43.959 Emily Giant: Sometimes in like the trash that is in my brain from working on these models like the names like this that I remember. I’m like, what else could be in my brain if it wasn’t storing
152 00:19:44.350 ⇒ 00:19:57.610 Emily Giant: like nonsense strings of letters, probably more nonsense. So I guess it’s a fine occupant. But okay, oh.
153 00:20:04.780 ⇒ 00:20:08.399 Emily Giant: this should be a forced upgrade. Let’s double check in dash.
154 00:20:19.440 ⇒ 00:20:22.370 Emily Giant: Yep, okay, so this is definitely, 1st upgrade.
155 00:20:24.090 ⇒ 00:20:28.340 Emily Giant: Put this as a note, and we can see what’s up with it in transaction line.
156 00:20:28.440 ⇒ 00:20:29.280 Emily Giant: Oh, okay.
157 00:20:29.280 ⇒ 00:20:31.080 Demilade Agboola: My, my question is like, Do we know the
158 00:20:31.430 ⇒ 00:20:35.330 Demilade Agboola: exact order? Id. That was 1st upgrade or 1st upgraded.
159 00:20:37.500 ⇒ 00:20:41.579 Emily Giant: Yes, like you mean in the in the table.
160 00:20:41.580 ⇒ 00:20:42.510 Demilade Agboola: Yeah, and the table.
161 00:20:43.130 ⇒ 00:20:52.069 Emily Giant: Yeah. So this this one is allegedly in the transaction line table, which has the suborder id as a column.
162 00:20:55.860 ⇒ 00:20:58.050 Emily Giant: If I just select everything from.
163 00:21:28.430 ⇒ 00:21:30.776 Emily Giant: Do you want to see something funny while this is running?
164 00:21:31.513 ⇒ 00:21:37.390 Emily Giant: We have a we have a customer photos channel. And one of them really made me laugh today. Hold on.
165 00:21:39.930 ⇒ 00:21:40.700 Emily Giant: anyway.
166 00:21:40.990 ⇒ 00:21:41.760 Emily Giant: Alright!
167 00:21:47.050 ⇒ 00:21:48.230 Emily Giant: Who’s this?
168 00:21:48.610 ⇒ 00:21:57.789 Emily Giant: These are 2 different packages, but their customer feedback with these 2 different deliveries of dead flowers as well. I guess you can’t say you’re not consistent.
169 00:22:00.630 ⇒ 00:22:09.000 Emily Giant: Oh, man makes me happy. I mean not happy that we’re sending dead flowers. But I love when people are like Snarky without being terrible.
170 00:22:09.000 ⇒ 00:22:17.020 Demilade Agboola: Yeah, I’m actually curious as to what the odds are that they would get the same like, like, I understand that sometimes you might get their flowers, but like.
171 00:22:17.690 ⇒ 00:22:20.020 Demilade Agboola: Person gets in dead flowers twice.
172 00:22:20.880 ⇒ 00:22:31.020 Emily Giant: It’s so unfortunate. It’s terrible like, what are the odds? We send thousands of that bouquet every week, and they wound up with 2 different like.
173 00:22:31.170 ⇒ 00:22:33.570 Emily Giant: completely dead bouquets.
174 00:22:35.710 ⇒ 00:22:39.809 Emily Giant: Okay, so yeah, there’s a suborder id.
175 00:22:42.390 ⇒ 00:22:49.809 Emily Giant: and then it should have. Then, like a Tf, I’m guessing I’ll have to look it up in netsuite to see if
176 00:22:50.080 ⇒ 00:22:56.550 Emily Giant: it successfully tagged it in netsuite, because this is obviously coming from the sales order record.
177 00:22:57.140 ⇒ 00:22:59.319 Emily Giant: But where is okay? Let’s just do.
178 00:22:59.810 ⇒ 00:23:00.699 Emily Giant: I had it.
179 00:23:01.550 ⇒ 00:23:02.420 Emily Giant: Costco.
180 00:23:20.020 ⇒ 00:23:25.850 Emily Giant: Okay? So yeah, that’s something’s up. And I need to tell Alex that that’s not working
181 00:23:26.508 ⇒ 00:23:31.260 Emily Giant: and let me check netsuite, because it might be a polyatomic thing.
182 00:23:31.849 ⇒ 00:23:34.719 Emily Giant: But I don’t know why it would be, since
183 00:23:35.680 ⇒ 00:23:43.335 Emily Giant: the other 2 new fields are working, and it, or at least the redelivery one, as we know, but
184 00:23:51.700 ⇒ 00:23:53.160 Emily Giant: also at Costco on.
185 00:24:02.660 ⇒ 00:24:03.850 Emily Giant: Do everything.
186 00:24:04.660 ⇒ 00:24:11.789 Emily Giant: Alright. So yeah, you wouldn’t be able to complete that ticket, as is because it’s not working.
187 00:24:13.010 ⇒ 00:24:15.559 Demilade Agboola: Yeah. Cause. If the if you can’t find the
188 00:24:15.700 ⇒ 00:24:19.720 Demilade Agboola: if you can find a suborder Id, it’s hard to join it back to the.
189 00:24:20.260 ⇒ 00:24:24.820 Emily Giant: Yeah. Well, the suborder Id is there. It’s there’s no indicator.
190 00:24:24.820 ⇒ 00:24:25.480 Demilade Agboola: Yeah, that’s right.
191 00:24:25.940 ⇒ 00:24:32.580 Emily Giant: Yeah, if it’s blank and not working at all. Yeah, so
192 00:24:32.720 ⇒ 00:24:34.739 Emily Giant: essentially like, let me add it.
193 00:24:36.170 ⇒ 00:24:40.080 Emily Giant: I’ll go ahead and add it to the raw table, just so that, like when it
194 00:24:40.630 ⇒ 00:24:42.989 Emily Giant: does work, it’s there.
195 00:24:43.470 ⇒ 00:24:50.689 Demilade Agboola: Okay. But you can also, just you want to push right now. So that way, when I want.
196 00:24:50.690 ⇒ 00:24:52.020 Emily Giant: Yeah, that’s true.
197 00:24:52.020 ⇒ 00:24:55.760 Demilade Agboola: Doesn’t like. It’s already in master, and I work on that instead.
198 00:24:57.000 ⇒ 00:25:02.130 Emily Giant: That makes sense. Okay? So it’s going to be in transaction line.
199 00:25:09.600 ⇒ 00:25:17.199 Emily Giant: Alright. So this transaction and transaction line where we’re gonna add these. And as of now, I do think they’re listed out. So yeah.
200 00:25:17.460 ⇒ 00:25:21.820 Emily Giant: okay, that’s gonna be it cus body
201 00:25:37.210 ⇒ 00:25:40.929 Emily Giant: And I haven’t tested the subscription one yet.
202 00:25:57.120 ⇒ 00:26:06.919 Emily Giant: And these are both incremental. So we’ll have to do a full refresh of production all right. Well, network.
203 00:26:29.530 ⇒ 00:26:32.400 Emily Giant: And then, while it’s doing that, I’ll add transaction line.
204 00:27:08.540 ⇒ 00:27:12.489 Emily Giant: Worst upgrade of skew. I wonder if it’s even supposed to be
205 00:27:12.770 ⇒ 00:27:17.200 Emily Giant: in that column? I want to find the sales order Id, so that we can look at the record in Netsuite.
206 00:27:21.960 ⇒ 00:27:23.843 Emily Giant: I can’t remember what the
207 00:27:25.380 ⇒ 00:27:28.409 Emily Giant: what the field is called something sales order, but.
208 00:27:31.400 ⇒ 00:27:32.190 Demilade Agboola: Recruitment.
209 00:27:39.300 ⇒ 00:27:42.600 Emily Giant: And it’s probably a native field. So it’s probably at the end.
210 00:28:02.730 ⇒ 00:28:05.209 Emily Giant: Oh, it might be in the transaction table.
211 00:28:05.680 ⇒ 00:28:07.260 Emily Giant: It’s probably what’s going on.
212 00:28:37.920 ⇒ 00:28:38.700 Emily Giant: Oh.
213 00:29:14.650 ⇒ 00:29:18.270 Emily Giant: okay, annoying.
214 00:29:51.500 ⇒ 00:29:56.281 Emily Giant: Alright! Maybe I’ll have better luck finding it in my actual like models where it
215 00:30:01.940 ⇒ 00:30:04.430 Emily Giant: where it’s renamed more sensibly.
216 00:30:25.100 ⇒ 00:30:26.789 Emily Giant: I don’t think it’s in this one
217 00:30:46.790 ⇒ 00:30:49.150 Emily Giant: sales already. Okay, it’s in transaction.
218 00:30:49.340 ⇒ 00:30:50.040 Emily Giant: Alright.
219 00:31:05.840 ⇒ 00:31:08.030 Emily Giant: Oh, that’s not gonna work model.
220 00:31:33.223 ⇒ 00:31:40.479 Emily Giant: I bet that’s a newish order, and that is an old ass branch. Let me try production here.
221 00:31:40.900 ⇒ 00:31:43.290 Emily Giant: I’m guessing. That’s just a refresh thing.
222 00:31:56.960 ⇒ 00:31:57.780 Emily Giant: Okay.
223 00:32:11.580 ⇒ 00:32:13.520 Emily Giant: yeah. It’s it’s blank.
224 00:32:18.390 ⇒ 00:32:21.769 Demilade Agboola: Well, it’s if it’s blank here.
225 00:32:22.050 ⇒ 00:32:22.679 Emily Giant: Yeah.
226 00:32:23.710 ⇒ 00:32:24.610 Demilade Agboola: Interesting.
227 00:32:25.400 ⇒ 00:32:29.040 Emily Giant: Yeah, if it’s blank here, that means it is not working. As Alex expected.
228 00:32:29.170 ⇒ 00:32:34.080 Emily Giant: I’m looking at the right record. Yeah, just make sure.
229 00:32:35.090 ⇒ 00:32:41.100 Emily Giant: Yeah, yeah, okay, I’ll flag Alex and use that link.
230 00:32:43.620 ⇒ 00:32:45.099 Emily Giant: Let me see history.
231 00:33:04.360 ⇒ 00:33:05.610 Emily Giant: Yeah, it’s not working
232 00:33:41.650 ⇒ 00:33:47.052 Emily Giant: well. I’m glad we did this together so that you didn’t spin your wheels trying to figure out what the heck
233 00:33:47.978 ⇒ 00:33:51.050 Demilade Agboola: How does it show up in Looker.
234 00:33:52.240 ⇒ 00:33:53.230 Emily Giant: Let’s see.
235 00:33:53.400 ⇒ 00:33:57.210 Emily Giant: So it’s that’s it’s sales data and not inventory data.
236 00:33:58.130 ⇒ 00:33:58.860 Emily Giant: So.
237 00:33:59.050 ⇒ 00:34:03.010 Demilade Agboola: So the sales does have the 1st upgrade information.
238 00:34:03.590 ⇒ 00:34:04.230 Emily Giant: Yep.
239 00:34:05.200 ⇒ 00:34:07.869 Demilade Agboola: And sales data is basically like Yms data, right?
240 00:34:08.350 ⇒ 00:34:09.310 Emily Giant: Exactly.
241 00:34:09.780 ⇒ 00:34:11.600 Demilade Agboola: So why don’t we just use sales data.
242 00:34:12.000 ⇒ 00:34:21.810 Emily Giant: I think we should. It’s I wanted to use netsuite data, because currently the sales data won’t have a record of the previous
243 00:34:22.030 ⇒ 00:34:23.000 Emily Giant: item.
244 00:34:23.239 ⇒ 00:34:44.269 Emily Giant: So you never, like you kind of lose the visibility in the current state of what they had ordered, where the goal with netsuite was that you could see the movement between lots and the movement of inventory. So I would like him to get this to work, not just for us, but also for the stakeholders, because in the event that they don’t have the information they need, I need them to be able to go to Netsuite
245 00:34:44.310 ⇒ 00:34:54.640 Emily Giant: and look at the movement of inventory. But I think in the short term, you’re right. We need this to be like done, and it’s not hard to like supplement
246 00:34:55.520 ⇒ 00:35:00.090 Emily Giant: the Netsuite field once it’s working but let’s.
247 00:35:00.090 ⇒ 00:35:00.690 Demilade Agboola: I mean.
248 00:35:00.690 ⇒ 00:35:01.183 Emily Giant: I mean.
249 00:35:01.430 ⇒ 00:35:05.939 Demilade Agboola: In this case. All we can do is to be sure that there was a forced upgrade on that. But we can’t.
250 00:35:06.860 ⇒ 00:35:08.337 Demilade Agboola: because I know.
251 00:35:13.020 ⇒ 00:35:17.629 Demilade Agboola: I’m trying to see, trying to think of how we can. What we can do.
252 00:35:20.340 ⇒ 00:35:25.099 Demilade Agboola: Is it possible? So when when there’s a 1st upgrade mark on it.
253 00:35:25.680 ⇒ 00:35:30.310 Demilade Agboola: We don’t know the order that it was that it’s upgrading, do we?
254 00:35:32.450 ⇒ 00:35:33.279 Demilade Agboola: In the sales data.
255 00:35:34.190 ⇒ 00:35:35.640 Emily Giant: We do.
256 00:35:35.800 ⇒ 00:35:37.700 Emily Giant: We just don’t know the item.
257 00:35:38.020 ⇒ 00:35:40.269 Demilade Agboola: So is it possible that
258 00:35:44.210 ⇒ 00:35:50.070 Demilade Agboola: this might be a bit convoluted? But if we have the order Id. That the.
259 00:35:50.070 ⇒ 00:35:50.600 Emily Giant: Hmm.
260 00:35:50.770 ⇒ 00:35:51.870 Demilade Agboola: Happening on.
261 00:35:53.370 ⇒ 00:35:55.870 Demilade Agboola: And we have the order. Id. That it is upgrading.
262 00:35:56.840 ⇒ 00:36:04.400 Demilade Agboola: Can we not try to get the Id from the like?
263 00:36:06.370 ⇒ 00:36:12.549 Demilade Agboola: Can we not try and get the item id for? Or is it like a different system? Does oms use a different skew?
264 00:36:14.810 ⇒ 00:36:27.719 Emily Giant: It does not use a different skew. Oh, yep, yeah, it does. You are correct, and those are the models that I’m trying to fix like the historical ones, so that, oh, fun. Okay, let me.
265 00:36:28.750 ⇒ 00:36:30.290 Emily Giant: Okay. So the answer is.
266 00:36:31.010 ⇒ 00:36:35.622 Emily Giant: it sometimes uses the same skew. But when it’s like a double or a triple
267 00:36:36.330 ⇒ 00:36:43.990 Emily Giant: oms is pulling the flrl dash d for doubles, and t for triples. So it’s not.
268 00:36:44.710 ⇒ 00:36:52.659 Emily Giant: It’s not always the same. However, there is a model components. Xf, where.
269 00:36:53.020 ⇒ 00:36:56.888 Emily Giant: if that can be fixed, which is what I’m working on,
270 00:36:57.500 ⇒ 00:37:00.877 Emily Giant: so that it accurate accurately pulls the
271 00:37:01.610 ⇒ 00:37:08.869 Emily Giant: the unit skew instead of like the double or triple. Then we could use it. But it it won’t. We
272 00:37:09.250 ⇒ 00:37:11.129 Emily Giant: I hear what you’re saying, though like.
273 00:37:12.220 ⇒ 00:37:16.290 Emily Giant: combine the inventory data by skew instead of by, like
274 00:37:16.910 ⇒ 00:37:23.410 Emily Giant: a sub order, id or vice queue and sub order id. To like, determine what the original purchase was.
275 00:37:23.620 ⇒ 00:37:30.460 Demilade Agboola: Yeah. But if we then but here’s the thing, if we know the so what I did that is being the 1st upgrade is being applied to.
276 00:37:31.058 ⇒ 00:37:37.470 Emily Giant: Go back to the Netsuite data and strip out the item. Id, yeah.
277 00:37:37.470 ⇒ 00:37:41.049 Demilade Agboola: And then use it in our final table.
278 00:37:42.110 ⇒ 00:37:44.630 Emily Giant: Yeah, that would work that would work.
279 00:37:44.990 ⇒ 00:37:48.689 Demilade Agboola: More complicated than would like, but I think it could. It could still work.
280 00:37:49.450 ⇒ 00:37:52.437 Emily Giant: Yeah, it would get it over the finish line.
281 00:37:53.050 ⇒ 00:37:56.090 Emily Giant: but I’m wondering if if I flag this to Alex.
282 00:37:56.620 ⇒ 00:38:00.240 Emily Giant: If you can fix it within the day. Then it’s super easy to
283 00:38:00.580 ⇒ 00:38:04.579 Emily Giant: use the field. It’s just not working. So I was trying to see where
284 00:38:05.091 ⇒ 00:38:10.400 Emily Giant: the force upgrade lineage. I haven’t touched a lot of the tagging stuff because it got
285 00:38:11.170 ⇒ 00:38:12.583 Emily Giant: pretty deprecated.
286 00:38:13.960 ⇒ 00:38:20.759 Emily Giant: when we migrated. But I think it’s in Oms. Tags is where the forced upgrade stuff starts happening in
287 00:38:21.810 ⇒ 00:38:22.990 Emily Giant: in the dag.
288 00:38:41.810 ⇒ 00:38:47.320 Emily Giant: I probably should have gone to the Dbt. Get. I didn’t have to look through it yet, not Zendesk tags.
289 00:38:47.680 ⇒ 00:38:50.810 Emily Giant: This is data I actually need to turn off.
290 00:38:57.760 ⇒ 00:38:59.120 Emily Giant: let’s the legal
291 00:39:13.670 ⇒ 00:39:14.420 Emily Giant: odd.
292 00:39:24.370 ⇒ 00:39:27.019 Emily Giant: How do you search for fields? Do you use Github
293 00:39:28.200 ⇒ 00:39:30.519 Emily Giant: like when you’re trying to look at where a field exists.
294 00:39:32.665 ⇒ 00:39:36.229 Demilade Agboola: Sometimes I just use Dvc, Dvc, explore.
295 00:39:36.340 ⇒ 00:39:37.420 Demilade Agboola: That helps.
296 00:39:39.700 ⇒ 00:39:40.889 Emily Giant: Done that before.
297 00:39:41.390 ⇒ 00:39:48.619 Demilade Agboola: Yeah, yeah, it also works. If you so if you go to the sidebar.
298 00:39:50.530 ⇒ 00:39:59.639 Demilade Agboola: If you expand your sidebar, there’s catalog, they’ve changed name, so it’s catalog.
299 00:40:00.660 ⇒ 00:40:02.520 Demilade Agboola: and then you can kind of just search.
300 00:40:03.160 ⇒ 00:40:04.149 Emily Giant: Oh, okay.
301 00:40:05.480 ⇒ 00:40:12.539 Emily Giant: I don’t think we call it so. This would be not fun for you. I don’t think we call a forced upgrade in these models for some reason.
302 00:40:12.790 ⇒ 00:40:14.609 Emily Giant: maybe strike through.
303 00:40:18.620 ⇒ 00:40:20.289 Emily Giant: Yeah, this makes more sense.
304 00:40:25.230 ⇒ 00:40:30.583 Emily Giant: Alright. So where it indicates in the hevo table, it’s the
305 00:40:32.960 ⇒ 00:40:36.759 Emily Giant: The audit log is. Gonna hold that information.
306 00:40:42.520 ⇒ 00:40:47.709 Emily Giant: order ingested. Oh, okay, this is why this one didn’t work. Alex said.
307 00:40:48.970 ⇒ 00:41:06.149 Emily Giant: when the forced upgrade button isn’t used, then it won’t show. So something critical to call out here is that if an agent doesn’t use the forced upgrade button it will not be captured as a forced upgrade, and this looks like they just deleted the line. Item. I don’t know why they would do that unless something was
308 00:41:07.640 ⇒ 00:41:13.279 Emily Giant: broken, not something that we would be in charge of fixing.
309 00:41:16.040 ⇒ 00:41:23.750 Emily Giant: But either way, like there were no records of forced upgrades. And that’s not true. So
310 00:41:23.860 ⇒ 00:41:27.250 Emily Giant: okay, so back to your question of
311 00:41:27.390 ⇒ 00:41:31.239 Emily Giant: where this happens. It’s gonna be.
312 00:41:37.910 ⇒ 00:41:39.893 Emily Giant: change these names a lot.
313 00:41:40.870 ⇒ 00:41:48.349 Emily Giant: I swear this was not called any of these things last week, maybe not last week. Yeah.
314 00:42:06.860 ⇒ 00:42:09.759 Emily Giant: this this would probably be a good starting point
315 00:42:09.910 ⇒ 00:42:15.910 Emily Giant: is like the dim oms care tags, because these are going to be like all of the customer service actions.
316 00:42:17.130 ⇒ 00:42:24.190 Emily Giant: So they’re staging line, item, suborder and credit, and these all join here.
317 00:42:25.130 ⇒ 00:42:26.770 Emily Giant: Let’s check it out in MoD.
318 00:43:07.890 ⇒ 00:43:10.260 Emily Giant: Look at this garbage data.
319 00:43:10.590 ⇒ 00:43:11.899 Emily Giant: Oh, my God!
320 00:43:13.890 ⇒ 00:43:16.840 Emily Giant: So I’ve never looked at this table before.
321 00:43:16.960 ⇒ 00:43:19.880 Emily Giant: And this is just like user inputs.
322 00:43:20.370 ⇒ 00:43:26.850 Emily Giant: Oh, not good. I guess the action performed.
323 00:43:56.600 ⇒ 00:44:00.366 Emily Giant: It doesn’t look like this is the right table, because it would.
324 00:44:00.780 ⇒ 00:44:05.619 Emily Giant: unless the add line item to suborder and remove is what they’re calling a forced upgrade.
325 00:44:07.330 ⇒ 00:44:10.269 Emily Giant: It seems like maybe I’m not looking the right place.
326 00:44:12.130 ⇒ 00:44:15.790 Demilade Agboola: Yeah, it does seem like, maybe you might need to sync with Alex on this.
327 00:44:15.960 ⇒ 00:44:21.640 Emily Giant: Yeah, I I agree. Okay, I’ll talk to him during the we have a meeting right after this.
328 00:44:22.355 ⇒ 00:44:25.620 Emily Giant: Let me throw a note on there this today. No.
329 00:44:26.940 ⇒ 00:44:32.600 Emily Giant: okay. So path forward for us. If Alex can fix
330 00:44:33.060 ⇒ 00:44:37.216 Emily Giant: that field quickly, I would advocate for
331 00:44:38.070 ⇒ 00:44:51.530 Emily Giant: using the the Netsuite field but we won’t be able to backfill any of it. So what you’re saying is probably necessary, regardless if we want historical data on forced upgrades right.
332 00:44:51.800 ⇒ 00:44:52.520 Demilade Agboola: Yeah.
333 00:45:02.480 ⇒ 00:45:07.984 Emily Giant: So we’re gonna need to do what you’re saying one way or the other.
334 00:45:08.910 ⇒ 00:45:14.219 Emily Giant: what I need to do is figure out where that forced upgrade data is coming through. In the 1st place.
335 00:45:15.630 ⇒ 00:45:19.370 Emily Giant: and it makes sense that it would be a different user action table
336 00:45:19.830 ⇒ 00:45:23.489 Emily Giant: only in that the process for tagging.
337 00:45:23.700 ⇒ 00:45:30.720 Emily Giant: What we’re looking at here is different than the actions that are listed here.
338 00:45:33.640 ⇒ 00:45:36.390 Demilade Agboola: Yeah, this seems to like spot like random.
339 00:45:36.860 ⇒ 00:45:40.254 Emily Giant: Yeah, it? Yeah, not good data.
340 00:45:43.440 ⇒ 00:45:45.480 Emily Giant: okay, I’ll keep looking for that.
341 00:45:45.780 ⇒ 00:45:58.000 Emily Giant: like where the the lineage is for forced upgrades. But like, I’m not even seeing the word forced upgrade in our dag outside of netsuite data which I know is not correct like that is
342 00:45:58.570 ⇒ 00:46:04.939 Emily Giant: unusable because it’s all user inputs. Also one month audit log, maybe.
343 00:46:15.450 ⇒ 00:46:16.180 Emily Giant: Okay.
344 00:46:16.550 ⇒ 00:46:18.580 Emily Giant: Hey, what’s a join spine?
345 00:46:19.160 ⇒ 00:46:23.029 Emily Giant: Is it? Just like you join on many things so that it it goes faster.
346 00:46:24.360 ⇒ 00:46:26.370 Demilade Agboola: Can I see what the joint spine is made of?
347 00:46:27.302 ⇒ 00:46:35.369 Emily Giant: It’s here. Oh, it’s joined by non, audit, log join key.
348 00:46:35.370 ⇒ 00:46:39.370 Demilade Agboola: And so join spine is a city in this case. Can I see what the city is right now?
349 00:46:42.650 ⇒ 00:46:44.670 Emily Giant: Where the join key.
350 00:46:45.190 ⇒ 00:46:48.899 Demilade Agboola: So yeah, can you go to? 1st of all, can you go to audit log?
351 00:46:49.300 ⇒ 00:46:53.380 Demilade Agboola: There are different cities that are being called upon. So there’s audit log, city.
352 00:46:53.560 ⇒ 00:46:56.670 Emily Giant: At CC. It should be up above.
353 00:46:56.960 ⇒ 00:47:02.269 Demilade Agboola: And then also the join Spine City. So autolog is select. All call join. Spine is.
354 00:47:02.270 ⇒ 00:47:05.520 Emily Giant: Okay, batch order, and I and suborder.
355 00:47:05.520 ⇒ 00:47:06.200 Demilade Agboola: Yeah.
356 00:47:06.840 ⇒ 00:47:08.789 Demilade Agboola: So I’m guessing. This is just.
357 00:47:10.270 ⇒ 00:47:12.429 Emily Giant: Oh, it’s just a cte. I see what you’re saying. Okay.
358 00:47:12.550 ⇒ 00:47:13.510 Demilade Agboola: University
359 00:47:17.030 ⇒ 00:47:19.759 Demilade Agboola: basically trying to add more information to
360 00:47:22.240 ⇒ 00:47:26.849 Demilade Agboola: basically add my information to the audit log or the yeah, the audit log information.
361 00:47:31.670 ⇒ 00:47:33.342 Emily Giant: That makes sense.
362 00:47:39.560 ⇒ 00:47:42.500 Emily Giant: So if this were what we were looking for.
363 00:47:42.690 ⇒ 00:47:51.690 Emily Giant: these all seem to just like, stop, they don’t join back to tableau, which is a good thing, but usually, like everything.
364 00:47:52.180 ⇒ 00:47:55.290 Emily Giant: joins back to that table that we use often, which
365 00:47:56.130 ⇒ 00:48:00.900 Emily Giant: makes me feel like potentially, this isn’t the right model, either.
366 00:48:24.530 ⇒ 00:48:27.030 Emily Giant: This is it? I’m pretty sure this is where
367 00:48:28.560 ⇒ 00:48:31.050 Emily Giant: we’re going to see that level of information
368 00:48:41.670 ⇒ 00:48:44.809 Emily Giant: still like, don’t you think it’s odd that nothing
369 00:48:45.010 ⇒ 00:48:50.129 Emily Giant: is being transformed in Dbt. To be called a forced upgrade like it’s
370 00:48:50.580 ⇒ 00:48:52.969 Emily Giant: just not in any of the models.
371 00:48:55.680 ⇒ 00:49:01.069 Demilade Agboola: I mean, I guess no one had just has ever tried to like Mark that consistently.
372 00:49:01.260 ⇒ 00:49:07.020 Demilade Agboola: But we might try and like so if it’s in looker, and it’s being counted. Can we like reverse engineer.
373 00:49:07.660 ⇒ 00:49:09.050 Emily Giant: What exactly.
374 00:49:09.200 ⇒ 00:49:10.880 Demilade Agboola: That column is counting.
375 00:49:11.250 ⇒ 00:49:17.759 Emily Giant: Yeah, so okay, this is sub suborder forced upgrade rate.
376 00:49:18.460 ⇒ 00:49:28.749 Emily Giant: And I made all of these in Looker because there was no. This was like a year ago or 2. So if I go into in use and open the
377 00:49:31.050 ⇒ 00:49:32.090 Emily Giant: like, I’m out.
378 00:49:35.890 ⇒ 00:49:42.210 Emily Giant: Those are custom fields. So those are like calculations inside this explorer.
379 00:49:57.860 ⇒ 00:50:01.780 Emily Giant: Okay, so it’s coming from, okay, yeah.
380 00:50:03.610 ⇒ 00:50:07.720 Emily Giant: Tag, primary category and dim oms, care tags.
381 00:50:08.350 ⇒ 00:50:08.769 Demilade Agboola: Why is it?
382 00:50:08.770 ⇒ 00:50:10.820 Emily Giant: So it was, yeah.
383 00:50:26.690 ⇒ 00:50:29.690 Emily Giant: like, it’s called tag primary category here.
384 00:50:57.850 ⇒ 00:51:00.970 Emily Giant: Okay, bam.
385 00:51:02.900 ⇒ 00:51:06.260 Demilade Agboola: But is that the only category? That is a 1st upgrade category?
386 00:51:10.432 ⇒ 00:51:11.459 Emily Giant: I’m not sure.
387 00:51:15.290 ⇒ 00:51:17.480 Emily Giant: So sometimes it’s like.
388 00:51:17.920 ⇒ 00:51:23.429 Emily Giant: so is there an order id column here? Because I want to pull the one we were looking at and see how it’s tagged
389 00:51:23.620 ⇒ 00:51:28.540 Emily Giant: since it was, yeah, select everything.
390 00:51:57.300 ⇒ 00:52:04.759 Emily Giant: Okay? So this add line of red item to sub order, 1st upgrade internal request. But yeah, I think the tag primary category is
391 00:52:07.500 ⇒ 00:52:09.630 Emily Giant: the only forced upgrade.
392 00:52:10.460 ⇒ 00:52:15.608 Emily Giant: Ca, it there. It’s only going to be a a tag and not its own column.
393 00:52:16.980 ⇒ 00:52:19.919 Demilade Agboola: Can you try? Just so we’re
394 00:52:20.590 ⇒ 00:52:27.800 Demilade Agboola: just so we’re can you try doing like lower around
395 00:52:28.870 ⇒ 00:52:31.889 Demilade Agboola: like the lower on before, like
396 00:52:32.260 ⇒ 00:52:34.740 Demilade Agboola: no. Before the 3rd primary category.
397 00:52:37.150 ⇒ 00:52:44.619 Demilade Agboola: So yeah, you put the lower function around it and then make the F
398 00:52:44.970 ⇒ 00:52:49.599 Demilade Agboola: smaller. And then, like, maybe we can get rid of the order. I just want to see if there’s any other way.
399 00:52:49.600 ⇒ 00:52:50.260 Emily Giant: Yeah, yeah.
400 00:52:55.420 ⇒ 00:53:01.369 Demilade Agboola: Oh, I was also going to put like, put distinct. Yeah. So put distinct tag
401 00:53:02.560 ⇒ 00:53:10.990 Demilade Agboola: primary category. Let’s just see so interesting. Yeah, the tag Yup.
402 00:53:12.210 ⇒ 00:53:15.239 Demilade Agboola: so that will let us just get it different.
403 00:53:20.460 ⇒ 00:53:21.010 Demilade Agboola: Okay.
404 00:53:21.596 ⇒ 00:53:24.529 Emily Giant: Okay. Yeah. Good. Call.
405 00:53:24.530 ⇒ 00:53:26.940 Demilade Agboola: Yeah, that’s that’s what I was trying to.
406 00:53:27.920 ⇒ 00:53:35.919 Demilade Agboola: All right. So in that case, maybe it’ll be better to use like forced like, the lower category. Small letter, forced
407 00:53:37.240 ⇒ 00:53:42.109 Demilade Agboola: like basically say, look for forced upgrade in the capital letter form.
408 00:53:44.170 ⇒ 00:53:46.799 Emily Giant: I’m just gonna add this to the ticket so that
409 00:53:47.060 ⇒ 00:53:49.199 Emily Giant: we have a record of that.
410 00:53:49.610 ⇒ 00:53:51.000 Emily Giant: Okay.
411 00:53:52.410 ⇒ 00:53:59.790 Emily Giant: that tracks for me. I’m also wondering about. Yeah, I guess that would cover like any extra spaces, etc.
412 00:54:00.380 ⇒ 00:54:01.609 Demilade Agboola: Yeah, yeah.
413 00:54:01.650 ⇒ 00:54:02.470 Emily Giant: Okay.
414 00:54:03.040 ⇒ 00:54:11.780 Demilade Agboola: Unless there’s another, unless there’s another way it’s represented in within your system. So that might be another issue. But if the workforce has to be there, sure.
415 00:54:18.140 ⇒ 00:54:25.860 Emily Giant: Well, my concern is like Alex’s note about it, not showing up in netsuite
416 00:54:26.010 ⇒ 00:54:29.265 Emily Giant: as, but it looks like that order.
417 00:54:30.310 ⇒ 00:54:37.240 Emily Giant: did not use the forced upgrade flow when the agent did it, and it still showed up as a forced upgrade in the table.
418 00:54:37.440 ⇒ 00:54:40.350 Emily Giant: So that’s a good indication that, like.
419 00:54:41.680 ⇒ 00:54:48.280 Emily Giant: no matter how the product is replaced, it still shows up in that table as a forced upgrade.
420 00:54:48.510 ⇒ 00:54:52.830 Demilade Agboola: Alright. And how does the how do we? How do? How do you identify the
421 00:54:53.640 ⇒ 00:54:58.450 Demilade Agboola: the subordinate? That is, it’s replacing.
422 00:55:00.850 ⇒ 00:55:05.069 Emily Giant: It. It doesn’t replace the suborder. Id, it only replaces the item.
423 00:55:05.660 ⇒ 00:55:07.679 Emily Giant: So the software Id remains the same.
424 00:55:08.530 ⇒ 00:55:15.650 Demilade Agboola: Oh, okay, so, and how do we identify the item? Id, though, like the old.
425 00:55:15.650 ⇒ 00:55:21.670 Emily Giant: Do the old one? I this is the problem.
426 00:55:23.770 ⇒ 00:55:32.550 Emily Giant: I have a feeling. It’s just in a window function that only takes the most recent record. And so we’re just obscuring it. But if you were able to like
427 00:55:33.524 ⇒ 00:55:39.040 Emily Giant: this is what I’ve been trying to figure out with. Netsuite is like, how can I
428 00:55:39.950 ⇒ 00:55:54.049 Emily Giant: tag? Something is like the main product and track when the main product changes. But we just have, like a distinct lack of that kind of identifier. It simply does not exist.
429 00:55:54.610 ⇒ 00:55:57.555 Emily Giant: which is a really annoying
430 00:55:58.630 ⇒ 00:56:02.129 Emily Giant: I know that in dim line item, strike through
431 00:56:02.260 ⇒ 00:56:07.230 Emily Giant: there is definitely a way to track a change in
432 00:56:07.650 ⇒ 00:56:11.819 Emily Giant: any line item like that was added to an order. You could do it by like
433 00:56:12.520 ⇒ 00:56:15.699 Emily Giant: times. The the times of the updates.
434 00:56:18.330 ⇒ 00:56:20.340 Emily Giant: That would be one way. But that’s
435 00:56:22.150 ⇒ 00:56:29.440 Emily Giant: yeah. I guess the 1st upgrade is always going to be line item level. So that is probably where it would need to be
436 00:56:30.340 ⇒ 00:56:33.159 Emily Giant: identified is, where does it go?
437 00:56:39.130 ⇒ 00:56:43.479 Emily Giant: So it’s I’m pretty sure it’s called dim line item, strike through.
438 00:56:44.170 ⇒ 00:56:49.910 Demilade Agboola: Okay, cause. If there’s I’ll I’ll look into it because it might. My thing. My.
439 00:56:51.170 ⇒ 00:56:56.959 Demilade Agboola: my issue is, if there isn’t a an order id a sub order id that we can
440 00:56:57.210 ⇒ 00:56:59.410 Demilade Agboola: tied the 1st upgrade.
441 00:57:00.210 ⇒ 00:57:05.310 Demilade Agboola: So we know the what the the subway id way happened, but the one that he replaced.
442 00:57:05.550 ⇒ 00:57:11.050 Demilade Agboola: In that case, if we know what the the one in replace, we can then use that the item id
443 00:57:11.260 ⇒ 00:57:14.210 Demilade Agboola: in Netsuite associated with that to figure.
444 00:57:15.090 ⇒ 00:57:16.399 Demilade Agboola: Back to the inventory.
445 00:57:16.710 ⇒ 00:57:17.240 Demilade Agboola: But yeah.
446 00:57:17.240 ⇒ 00:57:30.570 Emily Giant: Yeah, this never changes. So like the order started off as the nectarine, and then an agent updated it to the Margo. So this, the suborder. Id is the same. So
447 00:57:31.180 ⇒ 00:57:42.669 Emily Giant: that’s fine in dim light items in in netsuite like. If I pulled up the transaction line table, which is the like the one that will track any changes.
448 00:57:43.102 ⇒ 00:57:46.849 Emily Giant: You’ll see both of them there, but because we have to use
449 00:57:47.670 ⇒ 00:57:54.840 Emily Giant: window functions to make sure to avoid duplicates. It obscures the forced upgrade record always
450 00:57:56.340 ⇒ 00:57:56.980 Demilade Agboola: Gotcha.
451 00:57:56.980 ⇒ 00:58:02.610 Emily Giant: Because it. Yeah, yeah, you got me and there is definitely
452 00:58:03.050 ⇒ 00:58:15.329 Emily Giant: away. I just have not been able to figure it out like, if I could say, like, this is the main product. True, if another main product comes in after line created.
453 00:58:16.330 ⇒ 00:58:26.096 Emily Giant: and the most recent update does not include the old main product. Then that’s a forced upgrade, but it gets very convoluted.
454 00:58:26.700 ⇒ 00:58:29.730 Demilade Agboola: Yeah, I think I have an idea of how to to solve it.
455 00:58:31.500 ⇒ 00:58:36.269 Emily Giant: So do you want me to add any notes here? I’ll add sub order for 1st upgrades.
456 00:58:36.890 ⇒ 00:58:51.760 Emily Giant: notes from session, love, order. Id does not change when they 1st upgrade is applied to an order.
457 00:58:52.000 ⇒ 00:59:14.980 Emily Giant: Only the item id changes, and then I would say, den line, item, breakthrough and action line, and then
458 00:59:18.960 ⇒ 00:59:20.060 Emily Giant: audit log.
459 00:59:21.880 ⇒ 00:59:27.810 Emily Giant: Okay, to be like models to reference.
460 00:59:35.990 ⇒ 00:59:46.889 Emily Giant: Okay, cool. Alright. I’ll you know what Alex says after the next meeting I’ll slack you and see if there’s just some kind of debugging he can do real quick so that we
461 00:59:47.180 ⇒ 00:59:55.619 Emily Giant: can at least get the current data working again. We’ll have to do this for historical, anyway. But if we can get
462 00:59:56.050 ⇒ 01:00:02.790 Emily Giant: live going forward. That would be better than whatever we’re gonna have to do to make this work.
463 01:00:03.210 ⇒ 01:00:04.490 Demilade Agboola: Okay. Sounds good.
464 01:00:04.700 ⇒ 01:00:07.969 Emily Giant: Alright cool. Well, I will see you in 30 min at the next one.
465 01:00:08.200 ⇒ 01:00:09.449 Demilade Agboola: Alright, sounds good.
466 01:00:09.640 ⇒ 01:00:11.149 Emily Giant: All right. Talk to you soon.
467 01:00:11.440 ⇒ 01:00:12.100 Demilade Agboola: Right.
468 01:00:12.500 ⇒ 01:00:13.180 Emily Giant: Bye.