Meeting Title: Zoom-Meeting Date: 2024-06-21 Meeting participants: Brian Pei, Uttam Kumaran
WEBVTT
1 00:00:26.210 ⇒ 00:00:27.520 Uttam Kumaran: Hello!
2 00:00:29.210 ⇒ 00:00:31.519 Brian Pei: Insane, insane. You’re making me use zoom.
3 00:00:31.690 ⇒ 00:00:33.460 Uttam Kumaran: Why why insane?
4 00:00:33.930 ⇒ 00:00:34.450 Brian Pei: Did you.
5 00:00:34.450 ⇒ 00:00:37.410 Uttam Kumaran: Google meets it for sure.
6 00:00:37.410 ⇒ 00:00:37.870 Brian Pei: That’s.
7 00:00:37.870 ⇒ 00:00:38.610 Uttam Kumaran: Yes.
8 00:00:38.610 ⇒ 00:00:40.140 Brian Pei: Insane, crazy.
9 00:00:40.140 ⇒ 00:00:43.009 Uttam Kumaran: What who did Google hangouts are.
10 00:00:43.570 ⇒ 00:00:46.120 Brian Pei: Why do they suck? It’s so easy.
11 00:00:46.360 ⇒ 00:00:49.879 Uttam Kumaran: It never works on my fucking browser. It’s ridiculous.
12 00:00:51.170 ⇒ 00:00:53.610 Brian Pei: Get a better computer.
13 00:00:55.860 ⇒ 00:00:57.060 Brian Pei: What up?
14 00:00:57.910 ⇒ 00:01:01.200 Brian Pei: Oh, my God! I can’t even share my screen. It has the whole
15 00:01:02.710 ⇒ 00:01:06.180 Brian Pei: open system settings to share your screen done
16 00:01:06.730 ⇒ 00:01:08.050 Brian Pei: sway.
17 00:01:08.050 ⇒ 00:01:11.639 Uttam Kumaran: Zoom is way easier to use and way more professional.
18 00:01:11.640 ⇒ 00:01:12.760 Brian Pei: This is why
19 00:01:13.230 ⇒ 00:01:14.410 Brian Pei: professional.
20 00:01:14.410 ⇒ 00:01:18.490 Uttam Kumaran: Google meets is like, Oh, your company makes no money word.
21 00:01:20.640 ⇒ 00:01:23.430 Uttam Kumaran: I’m not attending a fucking. Google meets.
22 00:01:23.640 ⇒ 00:01:26.539 Brian Pei: Alright. I have to quit and reopen because you made me do this.
23 00:01:26.540 ⇒ 00:01:27.740 Uttam Kumaran: Okay. I’ll be here.
24 00:01:47.080 ⇒ 00:01:54.899 Brian Pei: Oh, okay, let’s see this window share, and let’s quickly do a zoom stock price check.
25 00:01:55.330 ⇒ 00:02:02.889 Brian Pei: Oh, no! Oh, oh, wait! Oh, no! That sucks so bad. Oh, that sucks so bad.
26 00:02:02.890 ⇒ 00:02:05.840 Uttam Kumaran: Dude. I don’t. I don’t. I don’t work for zoom.
27 00:02:06.664 ⇒ 00:02:07.489 Brian Pei: This.
28 00:02:07.490 ⇒ 00:02:11.045 Uttam Kumaran: It’s just way nicer. It’s way nicer.
29 00:02:12.240 ⇒ 00:02:15.130 Uttam Kumaran: How is this in any way comparable to fucking.
30 00:02:16.100 ⇒ 00:02:17.099 Brian Pei: Hang on just a check.
31 00:02:17.100 ⇒ 00:02:20.530 Uttam Kumaran: Google meets Bro. Google meets is in your browser.
32 00:02:21.670 ⇒ 00:02:26.089 Brian Pei: Whoa! Whoa! Alphabet! Alphabet! That’s so crazy!
33 00:02:26.960 ⇒ 00:02:28.890 Brian Pei: Oh, 30% year to date. That’s that’s.
34 00:02:28.890 ⇒ 00:02:33.421 Uttam Kumaran: I own alphabet. So yeah, I thanks. I made some money on that.
35 00:02:34.070 ⇒ 00:02:35.611 Brian Pei: Nice. I’m happy for you.
36 00:02:37.800 ⇒ 00:02:38.510 Brian Pei: Oh.
37 00:02:38.510 ⇒ 00:02:45.059 Uttam Kumaran: And every time on Google meets you hit share, then you just share the fucking mirror thing happens. What a dumb ass product.
38 00:02:46.090 ⇒ 00:02:47.140 Brian Pei: Alright.
39 00:02:47.410 ⇒ 00:02:50.150 Brian Pei: We spotify uses. Google meets only.
40 00:02:50.150 ⇒ 00:02:54.559 Uttam Kumaran: Yeah, y’all just increase prices. I saw the email come in. Y’all are really losing money hard.
41 00:02:54.560 ⇒ 00:02:55.629 Brian Pei: Do you, goddamn.
42 00:02:55.630 ⇒ 00:02:58.589 Uttam Kumaran: Fired everybody. You still gotta raise prices. The fuck.
43 00:02:58.970 ⇒ 00:03:02.499 Brian Pei: Everyone’s raising prices. We’re just followers. We’re not leaders.
44 00:03:02.980 ⇒ 00:03:04.900 Uttam Kumaran: No, don’t do it.
45 00:03:05.010 ⇒ 00:03:07.469 Uttam Kumaran: What’s 1 fucking dollar gonna be.
46 00:03:08.530 ⇒ 00:03:11.900 Brian Pei: A lot spotify. Now.
47 00:03:12.460 ⇒ 00:03:15.350 Brian Pei: Okay, that wasn’t as okay. Never mind.
48 00:03:15.350 ⇒ 00:03:15.980 Uttam Kumaran: You work at all.
49 00:03:15.980 ⇒ 00:03:18.360 Brian Pei: Millie. It’s couple of 100 Milli baby.
50 00:03:18.360 ⇒ 00:03:21.050 Uttam Kumaran: So what’s the audio book? What happened to audio books?
51 00:03:22.090 ⇒ 00:03:30.870 Brian Pei: Nothing. Just people don’t want them in their premium plan. So we made a new plan. That’s like, here’s everything except audio books. You illiterate.
52 00:03:31.860 ⇒ 00:03:33.959 Uttam Kumaran: What’s the one with audio books.
53 00:03:34.480 ⇒ 00:03:37.170 Brian Pei: That’s the one that you’re probably grandfathered into.
54 00:03:37.770 ⇒ 00:03:40.259 Uttam Kumaran: Oh, I got grandfather in no way.
55 00:03:40.260 ⇒ 00:03:42.429 Brian Pei: Probably you get.
56 00:03:42.480 ⇒ 00:03:47.589 Brian Pei: you get a certain amount of hours. You get like 10 h of any audio book you want a month or something
57 00:03:48.490 ⇒ 00:03:48.990 Brian Pei: to.
58 00:03:48.990 ⇒ 00:03:50.259 Uttam Kumaran: An hour in a month.
59 00:03:50.410 ⇒ 00:03:52.000 Uttam Kumaran: and then you buy more.
60 00:03:52.240 ⇒ 00:03:54.089 Brian Pei: You can buy more if you want.
61 00:03:54.970 ⇒ 00:03:55.960 Brian Pei: Yeah.
62 00:03:56.320 ⇒ 00:03:57.799 Brian Pei: if you want, nobody does.
63 00:03:57.800 ⇒ 00:04:00.399 Uttam Kumaran: I’m listening. I’m listening to Stephen Pressfield
64 00:04:01.310 ⇒ 00:04:05.300 Uttam Kumaran: like a gates of something about like Thermopolis.
65 00:04:05.660 ⇒ 00:04:07.110 Brian Pei: The fuck that is.
66 00:04:07.670 ⇒ 00:04:09.849 Brian Pei: this guy looks racist. I’ll say it.
67 00:04:10.088 ⇒ 00:04:12.949 Uttam Kumaran: Yeah, I’m reading Gate the fire. I’m listening to gate the fire.
68 00:04:14.050 ⇒ 00:04:17.870 Brian Pei: 1998. Dude, are you the war of art? Are you okay, man?
69 00:04:18.500 ⇒ 00:04:21.260 Uttam Kumaran: I also read. The war of our war of our was good.
70 00:04:22.740 ⇒ 00:04:24.339 Brian Pei: You do. You do too much
71 00:04:25.540 ⇒ 00:04:27.040 Brian Pei: self-improvement
72 00:04:27.670 ⇒ 00:04:29.289 Brian Pei: shit. Just trust yourself.
73 00:04:29.290 ⇒ 00:04:31.989 Uttam Kumaran: Quick, buck. It was like a hundred pages I read in the airport.
74 00:04:31.990 ⇒ 00:04:38.146 Brian Pei: Break through the blocks, and alright! What’s the what’s the takeaway? What’s the number? One thing I could learn something from.
75 00:04:38.440 ⇒ 00:04:40.960 Uttam Kumaran: It was basically like, suck it up.
76 00:04:41.500 ⇒ 00:04:42.350 Brian Pei: Wow!
77 00:04:42.590 ⇒ 00:04:42.930 Uttam Kumaran: It’s.
78 00:04:42.930 ⇒ 00:04:45.629 Brian Pei: Sun zoom for the soul. This guy should kill himself.
79 00:04:48.510 ⇒ 00:04:50.020 Uttam Kumaran: Sun do was good, too.
80 00:04:50.020 ⇒ 00:04:52.210 Brian Pei: He was, but he didn’t want to be
81 00:04:52.890 ⇒ 00:04:56.780 Brian Pei: mentioned in a white man’s book. Yeah, I’ll say it.
82 00:04:56.990 ⇒ 00:04:58.399 Uttam Kumaran: Gates of fire is good.
83 00:04:59.445 ⇒ 00:04:59.660 Brian Pei: Oh.
84 00:04:59.660 ⇒ 00:05:01.520 Uttam Kumaran: Okay, let’s let’s see what you got.
85 00:05:01.870 ⇒ 00:05:05.730 Uttam Kumaran: Okay. 1st of all, what? What first, st
86 00:05:05.930 ⇒ 00:05:10.139 Uttam Kumaran: Nico needs to know when you’re working in order for it to be helpful.
87 00:05:10.140 ⇒ 00:05:10.580 Brian Pei: Oh, where.
88 00:05:10.580 ⇒ 00:05:12.050 Uttam Kumaran: So let.
89 00:05:12.050 ⇒ 00:05:17.630 Brian Pei: Please stand up so Wednesday was Juneteenth. I went golfing for real on God.
90 00:05:18.110 ⇒ 00:05:22.389 Brian Pei: but that’s Juneteenth. You should give Juneteenth off to your to your employees, regardless.
91 00:05:22.770 ⇒ 00:05:26.300 Uttam Kumaran: Nobody asked for it off, because everybody wants to make money around here. So.
92 00:05:26.300 ⇒ 00:05:27.200 Brian Pei: That’s that’s in.
93 00:05:27.200 ⇒ 00:05:28.739 Uttam Kumaran: I work all day.
94 00:05:28.740 ⇒ 00:05:31.060 Brian Pei: That’s so you worked on Juneteenth. That’s crazy.
95 00:05:31.460 ⇒ 00:05:33.199 Uttam Kumaran: Yeah, I didn’t even know that was the thing.
96 00:05:34.490 ⇒ 00:05:40.980 Brian Pei: It’s Federal holiday baby and then I’ve been doing the stand about. I did the stand up, but on Juneteenth, too.
97 00:05:41.160 ⇒ 00:05:41.890 Brian Pei: and the.
98 00:05:41.890 ⇒ 00:05:47.226 Uttam Kumaran: The the other. The other thing that’s big is I’m trying. Basically, I want Ryan.
99 00:05:47.590 ⇒ 00:05:51.479 Uttam Kumaran: So that what we’re gonna have a meeting on Monday, so I I pull no more stand ups.
100 00:05:52.030 ⇒ 00:05:53.130 Uttam Kumaran: But we’re gonna have a meeting.
101 00:05:53.130 ⇒ 00:05:54.249 Brian Pei: On Monday. Yeah, I’m down.
102 00:05:54.250 ⇒ 00:05:57.240 Uttam Kumaran: We’re gonna have meeting on Monday. And then we’re gonna have like meeting on Friday.
103 00:05:57.490 ⇒ 00:06:00.520 Uttam Kumaran: Basically, Monday is just going to be like planning for the week.
104 00:06:01.160 ⇒ 00:06:07.959 Uttam Kumaran: The other thing that I want to do is anything that Ryan works on. I want to come through you.
105 00:06:08.930 ⇒ 00:06:10.000 Brian Pei: Sure.
106 00:06:10.585 ⇒ 00:06:12.700 Brian Pei: I don’t really talk to Ryan, but I’m down.
107 00:06:12.890 ⇒ 00:06:13.760 Uttam Kumaran: Because
108 00:06:14.291 ⇒ 00:06:18.639 Uttam Kumaran: Ryan is kind of like he’s like a junior ae, and I want him to like level up.
109 00:06:18.930 ⇒ 00:06:25.309 Uttam Kumaran: But at the same time, like, I’m just spent the last 3 days on sales. And it’s starting to get like more hectic.
110 00:06:25.420 ⇒ 00:06:26.500 Uttam Kumaran: though
111 00:06:26.840 ⇒ 00:06:29.949 Uttam Kumaran: I’m like, I don’t have. I want him to basically just like.
112 00:06:30.860 ⇒ 00:06:34.376 Uttam Kumaran: watch, you do everything and just get to your level.
113 00:06:35.080 ⇒ 00:06:37.230 Brian Pei: Is Ryan, the one who’s on
114 00:06:37.670 ⇒ 00:06:39.429 Brian Pei: Thailand time, or some shit.
115 00:06:39.430 ⇒ 00:06:40.870 Uttam Kumaran: Yeah. He’s in Philippines.
116 00:06:41.060 ⇒ 00:06:43.010 Brian Pei: Philippines? Is it white.
117 00:06:44.180 ⇒ 00:06:45.349 Uttam Kumaran: No, he’s Filipino.
118 00:06:45.740 ⇒ 00:06:47.160 Brian Pei: Always Philippino! Oh.
119 00:06:47.160 ⇒ 00:06:48.989 Uttam Kumaran: What the fuck are you talking about?
120 00:06:48.990 ⇒ 00:06:49.670 Brian Pei: I don’t know.
121 00:06:49.670 ⇒ 00:06:54.180 Uttam Kumaran: Chris. He’s Christian, all of their. They’re Christian. So they have Christian names.
122 00:06:55.210 ⇒ 00:06:59.310 Brian Pei: Got it. I thought he was a white boy living in the Philippines, hitting that week.
123 00:06:59.310 ⇒ 00:07:00.260 Uttam Kumaran: Yeah, man. Now?
124 00:07:00.420 ⇒ 00:07:02.080 Uttam Kumaran: No, no, and which is.
125 00:07:02.080 ⇒ 00:07:03.699 Brian Pei: Fine. I don’t judge.
126 00:07:03.890 ⇒ 00:07:09.529 Uttam Kumaran: No but basically one thing I wanna do Monday is like, try to plan out.
127 00:07:09.760 ⇒ 00:07:14.269 Uttam Kumaran: I’m assigning everything to you. And then I basically want you to be like cool. This is something we can hand off
128 00:07:14.590 ⇒ 00:07:15.859 Uttam Kumaran: or like toss the.
129 00:07:16.270 ⇒ 00:07:16.510 Brian Pei: Got so.
130 00:07:16.510 ⇒ 00:07:16.980 Uttam Kumaran: Brian.
131 00:07:16.980 ⇒ 00:07:18.170 Brian Pei: That actually.
132 00:07:18.480 ⇒ 00:07:19.070 Uttam Kumaran: Yeah.
133 00:07:19.070 ⇒ 00:07:19.605 Brian Pei: Already
134 00:07:20.520 ⇒ 00:07:22.620 Brian Pei: so many fucking tabs. Dude! Fuck
135 00:07:22.720 ⇒ 00:07:24.120 Brian Pei: this shit.
136 00:07:25.990 ⇒ 00:07:31.340 Brian Pei: this. This one’s an easy one. I already got the sequel to get blue torrent.
137 00:07:31.660 ⇒ 00:07:37.299 Uttam Kumaran: Yeah, so this would be a perfect one. For like on Monday, when we have our meeting, basically, we just toss it to.
138 00:07:37.470 ⇒ 00:07:39.169 Uttam Kumaran: we’ll toss it to Ryan.
139 00:07:39.190 ⇒ 00:07:44.210 Uttam Kumaran: And then you guys can just review and get it done. That’s that’s it.
140 00:07:44.580 ⇒ 00:07:48.839 Uttam Kumaran: That’s the only goal is basically, I want Ryan to level up. And then
141 00:07:49.120 ⇒ 00:07:55.772 Uttam Kumaran: you’re kind of like, I want you to be kind of like senior ae, so that you work. Just get gets approved by you.
142 00:07:56.475 ⇒ 00:07:56.900 Brian Pei: He’s.
143 00:07:56.900 ⇒ 00:07:59.229 Uttam Kumaran: It doesn’t mean like stuff has to happen
144 00:07:59.870 ⇒ 00:08:02.940 Uttam Kumaran: like that’s all. That’s all. Basically like.
145 00:08:03.500 ⇒ 00:08:06.490 Brian Pei: I’m done. I’m not. I’m not golfing. Next week, baby. I’m here.
146 00:08:06.690 ⇒ 00:08:07.550 Uttam Kumaran: Okay. Cool.
147 00:08:07.550 ⇒ 00:08:14.400 Brian Pei: I had to hit Beth on Wednesday. Absolutely no problem. He apparently read this Pr. And he slapped me with an Lgtm. So
148 00:08:14.540 ⇒ 00:08:17.149 Brian Pei: he’s he’s trying. He’s trying his best.
149 00:08:17.310 ⇒ 00:08:19.340 Uttam Kumaran: No, I’m Ryan’s really nice.
150 00:08:19.420 ⇒ 00:08:20.750 Uttam Kumaran: but it’s slow.
151 00:08:21.050 ⇒ 00:08:21.550 Brian Pei: Yeah.
152 00:08:22.050 ⇒ 00:08:22.420 Uttam Kumaran: And.
153 00:08:22.420 ⇒ 00:08:24.110 Brian Pei: So that fucking Jane girl.
154 00:08:26.050 ⇒ 00:08:30.400 Uttam Kumaran: Who’s that? Oh, Jane Janet! She responded. Dude. Well.
155 00:08:30.400 ⇒ 00:08:32.459 Brian Pei: I know. But she responded yesterday, right.
156 00:08:33.460 ⇒ 00:08:37.750 Uttam Kumaran: Yeah, I mean, I’m trying. I’m basically, I’m like, yeah, just give it to us in the fucking email. Please.
157 00:08:37.750 ⇒ 00:08:38.902 Brian Pei: Yeah, that was yesterday.
158 00:08:39.220 ⇒ 00:08:42.440 Brian Pei: Oh, yeah, I don’t think I could open this when I clicked on it.
159 00:08:42.970 ⇒ 00:08:44.899 Uttam Kumaran: Yeah, there’s it’s in one password. Yeah.
160 00:08:44.900 ⇒ 00:08:46.979 Brian Pei: Oh, look at that!
161 00:08:48.850 ⇒ 00:08:51.710 Brian Pei: We ever gonna get fuck! I use your shit for a whole bunch.
162 00:08:51.710 ⇒ 00:08:52.659 Uttam Kumaran: No dude.
163 00:08:55.270 ⇒ 00:08:58.095 Brian Pei: alright. Well, I haven’t really thought about this, because.
164 00:08:58.410 ⇒ 00:09:01.239 Uttam Kumaran: It’s fine. It has everything. So okay, let’s walk through this.
165 00:09:01.520 ⇒ 00:09:03.690 Brian Pei: Alright! Here we go!
166 00:09:04.130 ⇒ 00:09:05.689 Brian Pei: Here’s a macro.
167 00:09:05.990 ⇒ 00:09:07.089 Brian Pei: you you
168 00:09:07.270 ⇒ 00:09:10.949 Brian Pei: you have other macros like this. So you know this is an easy one.
169 00:09:11.268 ⇒ 00:09:15.280 Brian Pei: Full column name, because sometimes the name and the table name is different.
170 00:09:15.280 ⇒ 00:09:16.951 Uttam Kumaran: Did you get all of the
171 00:09:18.250 ⇒ 00:09:21.509 Uttam Kumaran: like you kinda get the world of their shipments data like.
172 00:09:22.020 ⇒ 00:09:23.070 Uttam Kumaran: kind of.
173 00:09:23.460 ⇒ 00:09:28.630 Brian Pei: I mean, essentially, I’ll talk through what I think is happening when I go through this whole thing.
174 00:09:29.785 ⇒ 00:09:38.139 Brian Pei: Alright, I just renamed this or Amazon order aggregates because they’re shopify order aggregates. I changed the reference everywhere else.
175 00:09:38.950 ⇒ 00:09:42.940 Brian Pei: There were 2 states here that had.
176 00:09:42.940 ⇒ 00:09:43.680 Uttam Kumaran: Nice.
177 00:09:43.680 ⇒ 00:09:47.019 Brian Pei: The a period that out
178 00:09:47.860 ⇒ 00:09:50.080 Brian Pei: here’s the macro.
179 00:09:50.080 ⇒ 00:09:50.830 Uttam Kumaran: So urge.
180 00:09:50.830 ⇒ 00:09:55.539 Brian Pei: Ship that service code. So I think I have to put the alias and the thing in here.
181 00:09:55.830 ⇒ 00:09:59.390 Brian Pei: And and then it’ll it does. Yeah, it does. This
182 00:10:00.513 ⇒ 00:10:03.690 Brian Pei: order aggregates to Amazon or group aggregates.
183 00:10:04.164 ⇒ 00:10:12.979 Brian Pei: I said, if we have Primus in here, can we just remove this whole cte, because you said it’s supposed to replace Lto. I didn’t. I just added a question here.
184 00:10:13.370 ⇒ 00:10:15.070 Uttam Kumaran: Yeah, this is gonna be
185 00:10:17.280 ⇒ 00:10:19.839 Uttam Kumaran: it’s gonna be a good question. For.
186 00:10:21.060 ⇒ 00:10:23.399 Uttam Kumaran: oh, the problem is, we have historical.
187 00:10:24.460 ⇒ 00:10:26.290 Brian Pei: Yeah, so down.
188 00:10:26.290 ⇒ 00:10:28.780 Uttam Kumaran: So Primus does. Primus isn’t
189 00:10:28.910 ⇒ 00:10:31.970 Uttam Kumaran: doesn’t have historical data. It’s like a new provider.
190 00:10:32.460 ⇒ 00:10:36.179 Uttam Kumaran: So like, we still wanna bring that stuff in for all the past data.
191 00:10:36.180 ⇒ 00:10:45.719 Brian Pei: Okay on the bottom. Then for the Amazon. Ltl, I did the where the order item, Id is not in order. Item, id from oh, shit! This should be Amazon premise.
192 00:10:46.250 ⇒ 00:10:46.990 Brian Pei: I’m not
193 00:10:47.140 ⇒ 00:10:48.580 Brian Pei: okay. That’s easy.
194 00:10:50.060 ⇒ 00:10:50.770 Brian Pei: That’s
195 00:10:52.500 ⇒ 00:10:54.340 Brian Pei: Amazon. Ltl.
196 00:10:56.640 ⇒ 00:11:02.349 Brian Pei: it’s this union from Amazon. Ltl, where this is not in from Amazon previous.
197 00:11:03.160 ⇒ 00:11:05.990 Brian Pei: which exists right somewhere. Yeah, okay.
198 00:11:06.100 ⇒ 00:11:07.959 Brian Pei: let me push that real quick.
199 00:11:08.690 ⇒ 00:11:11.016 Brian Pei: Amazon forgets.
200 00:11:13.670 ⇒ 00:11:24.267 Brian Pei: Yeah. So that’s how I got around that. Just take it if it exists. Okay. Where was I? Amazon? Ltl, shit shit ton of spaces in here. So I had to trim it.
201 00:11:24.570 ⇒ 00:11:25.499 Uttam Kumaran: Oh, good. Okay.
202 00:11:25.500 ⇒ 00:11:28.100 Brian Pei: Like every every single State, had a had a white space
203 00:11:28.710 ⇒ 00:11:32.620 Brian Pei: Amazon order aggregates. Let’s just clean up. I took your shop before.
204 00:11:32.620 ⇒ 00:11:33.390 Uttam Kumaran: Great thanks.
205 00:11:33.390 ⇒ 00:11:34.279 Brian Pei: So, and I just.
206 00:11:34.280 ⇒ 00:11:35.890 Uttam Kumaran: Yeah, this needs to happen.
207 00:11:36.620 ⇒ 00:11:37.250 Brian Pei: I mean.
208 00:11:37.250 ⇒ 00:11:38.563 Uttam Kumaran: Dude frankly.
209 00:11:39.460 ⇒ 00:11:41.450 Uttam Kumaran: And we could use another Pr.
210 00:11:41.580 ⇒ 00:11:45.400 Uttam Kumaran: that union thing I’m doing in some other shit.
211 00:11:45.630 ⇒ 00:11:46.360 Brian Pei: Guy.
212 00:11:46.510 ⇒ 00:11:47.680 Uttam Kumaran: So
213 00:11:47.850 ⇒ 00:11:51.260 Uttam Kumaran: we should probably move that entirely to something else.
214 00:11:52.010 ⇒ 00:11:52.460 Brian Pei: Sure.
215 00:11:52.460 ⇒ 00:11:54.520 Uttam Kumaran: But it’s fine for now.
216 00:11:55.110 ⇒ 00:11:55.730 Brian Pei: Cool
217 00:11:56.548 ⇒ 00:12:06.410 Brian Pei: in a bunch of places order weight I think should be grams times the quantity of the order line item, so change that in a couple of places.
218 00:12:08.335 ⇒ 00:12:13.110 Brian Pei: Here’s the macro. Here’s the Cte
219 00:12:13.310 ⇒ 00:12:14.836 Brian Pei: shop. 5
220 00:12:15.620 ⇒ 00:12:18.410 Brian Pei: order line. You let me make sure.
221 00:12:18.630 ⇒ 00:12:22.819 Brian Pei: Order line units and orders and order line units in order. Okay.
222 00:12:22.820 ⇒ 00:12:23.480 Uttam Kumaran: Yes.
223 00:12:23.480 ⇒ 00:12:26.030 Brian Pei: That’s good. Same thing.
224 00:12:26.740 ⇒ 00:12:35.030 Brian Pei: Order grams is the same thing it used to be some grams, but sometimes order line quantities, too. So.
225 00:12:35.030 ⇒ 00:12:39.614 Uttam Kumaran: Yeah. And here’s the thing. Some. I’m I’m work. I’m we’re not really using the
226 00:12:44.270 ⇒ 00:12:50.430 Uttam Kumaran: So the reason we have order Grams is at the at the item level.
227 00:12:50.510 ⇒ 00:12:51.796 Uttam Kumaran: I do.
228 00:12:53.180 ⇒ 00:12:56.880 Uttam Kumaran: Sometimes we do like a distribution of the shipping cost
229 00:12:57.350 ⇒ 00:12:59.399 Uttam Kumaran: based on the weight of each product.
230 00:12:59.760 ⇒ 00:13:03.160 Uttam Kumaran: I don’t think I’m doing it here. But in some other tables I do that.
231 00:13:04.060 ⇒ 00:13:08.249 Uttam Kumaran: for example, like the like. Let’s say the order itself has, like
232 00:13:08.340 ⇒ 00:13:10.050 Uttam Kumaran: X amount shipping like
233 00:13:11.450 ⇒ 00:13:16.969 Uttam Kumaran: like a shipment with some orders in it. I want to split the shipment costs across those order items.
234 00:13:17.320 ⇒ 00:13:17.680 Brian Pei: Is it the.
235 00:13:17.680 ⇒ 00:13:19.899 Uttam Kumaran: Yeah, like, this thing? Yeah, yeah, yeah.
236 00:13:20.500 ⇒ 00:13:29.469 Brian Pei: Yeah, I didn’t really understand what this is doing. But here, here you do do the grams and the order. Oh, we do, and it doesn’t matter whatever. Okay.
237 00:13:29.470 ⇒ 00:13:31.145 Uttam Kumaran: Let’s see, in this situation.
238 00:13:33.460 ⇒ 00:13:35.219 Uttam Kumaran: I’m not doing the quantity.
239 00:13:40.190 ⇒ 00:13:45.969 Uttam Kumaran: I think I think for this, I want to walk through some examples with you about like and the quantities higher or the type.
240 00:13:46.170 ⇒ 00:13:49.319 Uttam Kumaran: I clearly didn’t account for that. But I wonder if I missed something.
241 00:13:49.940 ⇒ 00:13:53.150 Brian Pei: Sometimes I let me see if I had
242 00:13:57.303 ⇒ 00:14:04.859 Brian Pei: oh, yeah, let’s do grams quantity. Let’s just do star from order line where quantity
243 00:14:04.920 ⇒ 00:14:06.330 Brian Pei: square than one.
244 00:14:09.780 ⇒ 00:14:20.859 Brian Pei: So you will have Grant. Yeah, sometimes it’s it’s this order line item is 2. And so I just assume that this grams does not account for that.
245 00:14:21.378 ⇒ 00:14:28.050 Brian Pei: Although it could be wrong, it’s just I looked at it. And I was like, Okay, this quantity 10 0. That’s weird. But whatever.
246 00:14:28.050 ⇒ 00:14:31.700 Uttam Kumaran: We’ll look at a pick us, or order it by skew.
247 00:14:32.640 ⇒ 00:14:34.153 Uttam Kumaran: and that way you’ll look at the
248 00:14:37.600 ⇒ 00:14:39.610 Uttam Kumaran: you can see one versus 2.
249 00:14:46.200 ⇒ 00:14:47.510 Brian Pei: Me do
250 00:14:48.330 ⇒ 00:14:50.190 Brian Pei: and pick 1 1.st
251 00:14:52.530 ⇒ 00:14:58.449 Brian Pei: Take this idea just 2. Now, I need one that has grams. Okay, here’s 1 that has grams.
252 00:14:59.040 ⇒ 00:15:00.659 Brian Pei: Order. Okay?
253 00:15:01.050 ⇒ 00:15:02.020 Brian Pei: Id.
254 00:15:02.370 ⇒ 00:15:03.220 Brian Pei: S,
255 00:15:04.190 ⇒ 00:15:06.429 Brian Pei: okay, there’s only one of those that sucks.
256 00:15:07.780 ⇒ 00:15:09.665 Uttam Kumaran: Well, look at, look at just
257 00:15:10.900 ⇒ 00:15:15.279 Uttam Kumaran: You basically wanna look at one where the quantities, 1, 1, the quantities, 2. And look at what the
258 00:15:15.550 ⇒ 00:15:16.476 Uttam Kumaran: what the
259 00:15:17.380 ⇒ 00:15:21.460 Uttam Kumaran: Graham’s is. Just so we could confirm whether it’s doing it automatically.
260 00:15:33.150 ⇒ 00:15:33.540 Brian Pei: Okay.
261 00:15:33.540 ⇒ 00:15:34.560 Uttam Kumaran: Nice hat.
262 00:15:36.490 ⇒ 00:15:38.070 Brian Pei: Thanks. It’s a golf hat.
263 00:15:38.750 ⇒ 00:15:40.319 Uttam Kumaran: I got that hat for you.
264 00:15:40.710 ⇒ 00:15:41.872 Brian Pei: No, you didn’t.
265 00:15:42.260 ⇒ 00:15:43.390 Uttam Kumaran: Yeah, I did.
266 00:15:43.390 ⇒ 00:15:44.600 Brian Pei: Why would you lie?
267 00:15:44.960 ⇒ 00:15:47.840 Uttam Kumaran: Dude I, fucking got that tiger woods hat for you.
268 00:15:49.970 ⇒ 00:15:53.949 Uttam Kumaran: and you were like, Bro. I’m not gonna wear this. What the fuck is this tiger woods hat.
269 00:15:54.010 ⇒ 00:15:58.949 Uttam Kumaran: and you’re like, Damn! But this Bluetooth golf fucking radar detector is sick.
270 00:15:59.460 ⇒ 00:16:01.779 Brian Pei: Why would you just lie like that? Okay.
271 00:16:01.780 ⇒ 00:16:04.299 Uttam Kumaran: Dude. I got that for you fucking 2 years ago.
272 00:16:04.300 ⇒ 00:16:07.479 Brian Pei: I don’t remember but this hat this hat is, is really nice, so.
273 00:16:07.480 ⇒ 00:16:12.099 Uttam Kumaran: Yeah, it’s a nice bucket hat. It was the nicest hat they had. It is Tiger Woods. He’s a goat.
274 00:16:13.540 ⇒ 00:16:14.473 Brian Pei: It’s the
275 00:16:14.950 ⇒ 00:16:17.380 Brian Pei: alright. Here’s here’s our product.
276 00:16:17.620 ⇒ 00:16:21.801 Brian Pei: Here’s the grams for one, the grams for 2. So yeah, you have to multiply.
277 00:16:22.872 ⇒ 00:16:30.299 Brian Pei: Which I can also just add that right now, for what we’re looking at. This was shopify Unis. You did some crazy shit
278 00:16:30.920 ⇒ 00:16:34.619 Brian Pei: shopify Unis. I’m in my other window right now.
279 00:16:35.970 ⇒ 00:16:39.659 Brian Pei: facility equals ignition. No, not that one shipping cost
280 00:16:39.680 ⇒ 00:16:41.900 Brian Pei: times. Grams
281 00:16:42.120 ⇒ 00:16:45.210 Brian Pei: times. OL. Dot
282 00:16:45.310 ⇒ 00:16:46.720 Brian Pei: quantity.
283 00:16:47.130 ⇒ 00:16:50.971 Brian Pei: and we’ll probably have to investigate this
284 00:16:51.930 ⇒ 00:16:54.219 Uttam Kumaran: So. So I I put an example there.
285 00:16:54.580 ⇒ 00:16:56.979 Uttam Kumaran: So maybe we can investigate that example. But.
286 00:16:56.980 ⇒ 00:16:57.560 Brian Pei: Oh, yeah, I did.
287 00:16:57.560 ⇒ 00:17:00.399 Uttam Kumaran: Is kind of some of the advanced logic that I didn’t really like
288 00:17:01.860 ⇒ 00:17:03.240 Uttam Kumaran: a bit hard, though.
289 00:17:05.819 ⇒ 00:17:08.599 Brian Pei: So advanced. Dude. You’re so smart. Everyone says that about you.
290 00:17:10.109 ⇒ 00:17:10.534 Brian Pei: Alright.
291 00:17:11.469 ⇒ 00:17:17.249 Brian Pei: Okay. So we’re gonna order grams. Yeah. So I did the Graham’s times quantity that makes sense.
292 00:17:17.779 ⇒ 00:17:19.369 Brian Pei: Didn’t change this.
293 00:17:22.539 ⇒ 00:17:23.619 Brian Pei: just
294 00:17:23.749 ⇒ 00:17:38.019 Brian Pei: Shane. Okay, yeah, this is all the shopify Unis States were not whatever they were not the code. So shout out this macro very cool it works
295 00:17:39.441 ⇒ 00:17:42.699 Brian Pei: left join, took those out
296 00:17:42.979 ⇒ 00:17:47.229 Brian Pei: Amazon order aggregates cause I renamed it, took these out.
297 00:17:48.399 ⇒ 00:17:49.709 Brian Pei: added the.
298 00:17:49.710 ⇒ 00:17:52.030 Uttam Kumaran: Wait, wait! You got a comment there. 2 85
299 00:17:52.380 ⇒ 00:17:56.169 Uttam Kumaran: Primus Amazon is an inner join, and here shopify’s left. Join.
300 00:17:56.170 ⇒ 00:17:59.100 Brian Pei: Oh, I forgot about that. Yeah. You enter. Join
301 00:17:59.300 ⇒ 00:18:00.840 Brian Pei: in Amazon.
302 00:18:01.540 ⇒ 00:18:05.029 Brian Pei: and you left. You interjoint on the Amazon premise
303 00:18:05.850 ⇒ 00:18:12.489 Brian Pei: on order items. So it’s gonna take everything else out you left join here. So it’s leaving a bunch of like null order ids in.
304 00:18:14.050 ⇒ 00:18:16.060 Brian Pei: I didn’t know if that was on purpose.
305 00:18:18.860 ⇒ 00:18:20.290 Uttam Kumaran: Fuck. I don’t know, either.
306 00:18:24.420 ⇒ 00:18:25.393 Uttam Kumaran: I guess.
307 00:18:32.120 ⇒ 00:18:36.170 Brian Pei: So when you, when you left, joined the shopify on the shopify premise.
308 00:18:36.580 ⇒ 00:18:40.441 Brian Pei: 90% of that shit is null because it’s
309 00:18:41.530 ⇒ 00:18:43.460 Brian Pei: because the previous data sucks as.
310 00:18:49.530 ⇒ 00:18:52.950 Uttam Kumaran: Fuck we should bring it in anyways, cause we’re gonna
311 00:18:52.970 ⇒ 00:18:53.870 Uttam Kumaran: we’re gonna
312 00:18:55.190 ⇒ 00:18:56.620 Uttam Kumaran: miss out on the cough.
313 00:18:56.860 ⇒ 00:18:57.570 Brian Pei: Yep.
314 00:18:57.700 ⇒ 00:18:59.860 Brian Pei: In which case, then, for this Amazon.
315 00:18:59.860 ⇒ 00:19:00.570 Uttam Kumaran: Me, left.
316 00:19:00.570 ⇒ 00:19:02.529 Brian Pei: You would like to do that alright!
317 00:19:04.030 ⇒ 00:19:07.219 Uttam Kumaran: And we’re just gonna call it like we’re just clean it up in the future.
318 00:19:07.540 ⇒ 00:19:09.590 Brian Pei: Left. Join.
319 00:19:10.290 ⇒ 00:19:13.230 Brian Pei: admit. Make Amazon
320 00:19:13.520 ⇒ 00:19:17.899 Brian Pei: Primus left. Join, commit bush.
321 00:19:19.270 ⇒ 00:19:20.500 Brian Pei: refresh.
322 00:19:21.050 ⇒ 00:19:23.050 Brian Pei: 1, 2, 60,
323 00:19:26.043 ⇒ 00:19:28.939 Brian Pei: okay, yeah. Okay. So
324 00:19:29.150 ⇒ 00:19:30.940 Brian Pei: I’ll do. Left join. It’s fine
325 00:19:31.900 ⇒ 00:19:35.959 Brian Pei: there’ll be some knows. Well, we’ll I’ll have to look into what to do with the nose late.
326 00:19:35.960 ⇒ 00:19:36.770 Uttam Kumaran: Yeah.
327 00:19:37.450 ⇒ 00:19:42.269 Brian Pei: Okay? So yeah. So then, this one is left. Join which is fine.
328 00:19:42.730 ⇒ 00:19:46.229 Brian Pei: This Amazon part is where saying
329 00:19:46.490 ⇒ 00:19:50.469 Brian Pei: where the order id is not in Primus for Ltl.
330 00:19:51.350 ⇒ 00:19:55.379 Brian Pei: I assume I have to do this for shopify, too, which I didn’t.
331 00:19:55.740 ⇒ 00:19:57.680 Brian Pei: Is there shopify? Ltl.
332 00:20:01.390 ⇒ 00:20:03.569 Uttam Kumaran: Basically, the the thing is is like.
333 00:20:03.820 ⇒ 00:20:07.560 Uttam Kumaran: I’m trying to wrap my head around like where this opportunity for duplicates.
334 00:20:07.700 ⇒ 00:20:09.649 Uttam Kumaran: because we may get.
335 00:20:12.590 ⇒ 00:20:13.880 Uttam Kumaran: Here’s an example.
336 00:20:13.980 ⇒ 00:20:16.060 Uttam Kumaran: Shop like ship station
337 00:20:16.150 ⇒ 00:20:23.489 Uttam Kumaran: will tell us that it shipped something for like $2, when in reality it actually got shipped by Ltl.
338 00:20:24.040 ⇒ 00:20:26.949 Uttam Kumaran: so it will have, it’ll occur in both.
339 00:20:27.030 ⇒ 00:20:29.700 Uttam Kumaran: So that’s why I say, make sure it’s not in.
340 00:20:32.230 ⇒ 00:20:34.009 Uttam Kumaran: If you search for not in.
341 00:20:35.427 ⇒ 00:20:36.590 Brian Pei: Wait one second.
342 00:20:38.240 ⇒ 00:20:39.460 Uttam Kumaran: I’m doing it somewhere.
343 00:20:42.930 ⇒ 00:20:49.720 Brian Pei: Okay, here’s your shopify Ltl Union subquery. And then.
344 00:20:50.220 ⇒ 00:20:52.260 Brian Pei: oh, wait! Sorry. I wanna go. I wanna.
345 00:20:52.260 ⇒ 00:20:54.850 Uttam Kumaran: You wanna go to shop, you wanna go to shop by ship station.
346 00:20:58.130 ⇒ 00:21:00.129 Uttam Kumaran: and then you should see like
347 00:21:00.670 ⇒ 00:21:02.550 Uttam Kumaran: where it’s not in. Maybe
348 00:21:02.710 ⇒ 00:21:04.010 Uttam Kumaran: I did it right.
349 00:21:05.620 ⇒ 00:21:06.300 Uttam Kumaran: Oh, I just.
350 00:21:06.300 ⇒ 00:21:09.885 Brian Pei: You do it in the in the Union all the way on the bottom when you
351 00:21:11.800 ⇒ 00:21:14.740 Brian Pei: Jesus Christ, here’s Primus
352 00:21:22.550 ⇒ 00:21:23.790 Brian Pei: hang on.
353 00:21:24.920 ⇒ 00:21:26.119 Brian Pei: Can’t see shit.
354 00:21:31.120 ⇒ 00:21:31.870 Brian Pei: Okay.
355 00:21:31.870 ⇒ 00:21:33.749 Uttam Kumaran: Yeah, yeah, yeah, yeah, yeah, exactly.
356 00:21:33.750 ⇒ 00:21:39.710 Brian Pei: You got you to do this for Amazon? It’s great. You shopify ship station.
357 00:21:44.110 ⇒ 00:21:45.880 Uttam Kumaran: Oh, maybe I’m not doing it. Okay.
358 00:21:46.680 ⇒ 00:21:48.360 Brian Pei: It would be here.
359 00:21:48.360 ⇒ 00:21:51.759 Uttam Kumaran: I guess we could just understand. If this is happening like.
360 00:21:52.240 ⇒ 00:21:53.840 Uttam Kumaran: pretty sure it’s happening.
361 00:22:03.150 ⇒ 00:22:08.419 Brian Pei: Well for your shopify. Ltl, you you you throw on a null for the order. Id item id.
362 00:22:08.710 ⇒ 00:22:09.910 Uttam Kumaran: Because it’s not
363 00:22:12.620 ⇒ 00:22:15.089 Uttam Kumaran: It’s not associated.
364 00:22:16.720 ⇒ 00:22:18.160 Uttam Kumaran: Oh, actually.
365 00:22:28.710 ⇒ 00:22:33.630 Uttam Kumaran: I don’t think I have the order. Item that actually got shipped with Ltl.
366 00:22:35.220 ⇒ 00:22:36.899 Uttam Kumaran: I just have the order. Id.
367 00:22:37.790 ⇒ 00:22:39.159 Uttam Kumaran: I guess. Technically, we.
368 00:22:39.160 ⇒ 00:22:41.489 Brian Pei: Oh, you do. You took your your shop floor
369 00:22:41.840 ⇒ 00:22:45.619 Brian Pei: where you have. You’re taking in shopify order line unions.
370 00:22:46.230 ⇒ 00:22:47.709 Brian Pei: You’re getting it from
371 00:22:48.090 ⇒ 00:22:49.430 Brian Pei: border lines.
372 00:22:49.850 ⇒ 00:22:50.570 Brian Pei: I don’t know why.
373 00:22:50.570 ⇒ 00:22:52.660 Uttam Kumaran: How does the Ltl stuff join in?
374 00:22:53.870 ⇒ 00:22:56.489 Uttam Kumaran: See? The Ltl stuff joins it on the order number.
375 00:22:56.700 ⇒ 00:22:59.799 Brian Pei: Oh, yeah, oh, so it’s it’s this
376 00:23:01.000 ⇒ 00:23:01.840 Brian Pei: that’s
377 00:23:02.070 ⇒ 00:23:02.610 Brian Pei: happy.
378 00:23:02.610 ⇒ 00:23:04.249 Uttam Kumaran: I guess. Technically.
379 00:23:04.540 ⇒ 00:23:09.169 Uttam Kumaran: we only know like, look, look at the look at the look at the line 1, 86
380 00:23:09.440 ⇒ 00:23:11.319 Uttam Kumaran: only these skews
381 00:23:11.360 ⇒ 00:23:12.920 Uttam Kumaran: ship without the owl.
382 00:23:13.020 ⇒ 00:23:17.819 Uttam Kumaran: So I guess technically we could bring in the order line. Info, if we just filtered to those queues.
383 00:23:17.890 ⇒ 00:23:19.510 Uttam Kumaran: I just like if I haven’t
384 00:23:19.950 ⇒ 00:23:21.390 Uttam Kumaran: got that far.
385 00:23:22.220 ⇒ 00:23:23.449 Brian Pei: Yeah, it’s a little
386 00:23:23.560 ⇒ 00:23:24.080 Brian Pei: keeps it. Take.
387 00:23:24.080 ⇒ 00:23:25.940 Uttam Kumaran: A little bit complicated. Yeah.
388 00:23:26.710 ⇒ 00:23:30.629 Brian Pei: Let me take a look at this Google sheet sucks that it’s Google Sheet.
389 00:23:37.080 ⇒ 00:23:38.790 Brian Pei: Oh, Jesus Christ, okay.
390 00:23:49.610 ⇒ 00:23:50.860 Brian Pei: where? What?
391 00:24:06.380 ⇒ 00:24:10.429 Brian Pei: You’re joining on? Pox. Po.
392 00:24:11.230 ⇒ 00:24:14.920 Brian Pei: Po. Oh, this is the I see. Okay.
393 00:24:15.190 ⇒ 00:24:16.939 Brian Pei: so po is the order
394 00:24:17.800 ⇒ 00:24:19.669 Brian Pei: id, and then there’s
395 00:24:20.300 ⇒ 00:24:21.850 Brian Pei: what’s BOL.
396 00:24:23.540 ⇒ 00:24:24.486 Uttam Kumaran: Ul is
397 00:24:24.960 ⇒ 00:24:25.770 Brian Pei: Line item.
398 00:24:33.680 ⇒ 00:24:34.620 Uttam Kumaran: Forgot.
399 00:24:35.040 ⇒ 00:24:35.670 Brian Pei: With volle.
400 00:24:35.670 ⇒ 00:24:36.310 Uttam Kumaran: Be aware.
401 00:24:36.310 ⇒ 00:24:39.330 Brian Pei: That would be kind of sick, because then you have it in this Google Sheet.
402 00:24:39.460 ⇒ 00:24:40.250 Uttam Kumaran: Yeah.
403 00:24:45.770 ⇒ 00:24:47.700 Brian Pei: Okay, let’s see, this next step
404 00:24:48.020 ⇒ 00:24:48.720 Brian Pei: moved.
405 00:24:51.010 ⇒ 00:24:53.790 Brian Pei: amplify order. Item.
406 00:25:03.720 ⇒ 00:25:05.479 Brian Pei: see if this is a real thing.
407 00:25:07.620 ⇒ 00:25:09.320 Brian Pei: Okay, it’s not really a real thing.
408 00:25:20.040 ⇒ 00:25:22.060 Brian Pei: Gonna have to do that another time.
409 00:25:23.040 ⇒ 00:25:23.730 Uttam Kumaran: Okay.
410 00:25:24.540 ⇒ 00:25:25.739 Brian Pei: Okay, but
411 00:25:26.790 ⇒ 00:25:30.770 Brian Pei: super duper. Get it okay? And then
412 00:25:31.170 ⇒ 00:25:32.640 Brian Pei: then you got Primus
413 00:25:33.350 ⇒ 00:25:36.569 Brian Pei: in here with the left. Join on the shopify
414 00:25:37.667 ⇒ 00:25:42.319 Brian Pei: you got. Oh, this is this is where we were. The final shipments.
415 00:25:45.840 ⇒ 00:25:51.360 Brian Pei: where the Amazon ltl order. Item, Id is not in the primus
416 00:25:52.450 ⇒ 00:25:58.730 Brian Pei: ids. So you get Primus first, st then you get Amazon. Ltl, then you get Amazon.
417 00:25:58.900 ⇒ 00:26:04.439 Brian Pei: Same for shopify. It’ll be shopify Primus first, st then shopify Ltl, then shopify
418 00:26:07.050 ⇒ 00:26:09.150 Brian Pei: and then.
419 00:26:09.160 ⇒ 00:26:10.879 Brian Pei: and your final.
420 00:26:12.880 ⇒ 00:26:17.943 Brian Pei: I just I didn’t init cap on Shipping City, because sometimes it was all caps and sometimes it wasn’t.
421 00:26:18.850 ⇒ 00:26:19.699 Brian Pei: And
422 00:26:21.321 ⇒ 00:26:27.509 Brian Pei: you had a note that you wanted to bring in distance from Warehouse. So I just threw in miles from Warehouse. You’re already joining it onto the mapping.
423 00:26:27.740 ⇒ 00:26:28.040 Uttam Kumaran: Okay.
424 00:26:28.610 ⇒ 00:26:33.180 Brian Pei: And then I did a row number for the future, because
425 00:26:33.800 ⇒ 00:26:39.760 Brian Pei: you said that should be per ship date per shipping item per order. Item.
426 00:26:39.930 ⇒ 00:26:43.370 Brian Pei: it should be distinct, and sometimes it’s not.
427 00:26:43.370 ⇒ 00:26:45.120 Uttam Kumaran: Wait! Wait! What? Say it again?
428 00:26:46.760 ⇒ 00:26:49.640 Brian Pei: You set here. I think I had something for this.
429 00:26:52.710 ⇒ 00:26:54.630 Brian Pei: The do do.
430 00:26:58.580 ⇒ 00:27:02.079 Brian Pei: So here this is what’s in shipments right now. There’s a
431 00:27:02.640 ⇒ 00:27:05.560 Brian Pei: there’s a shipment that has the same order
432 00:27:05.600 ⇒ 00:27:09.239 Brian Pei: that has 2 of the same order, Id and order. Item, Id.
433 00:27:09.410 ⇒ 00:27:12.330 Brian Pei: I believe you told me that this shouldn’t happen.
434 00:27:13.073 ⇒ 00:27:18.159 Brian Pei: The shipment weight is different, but the ship date. Is that exactly the same.
435 00:27:18.160 ⇒ 00:27:21.110 Uttam Kumaran: So this is something that yeah. So keep scrolling to the right.
436 00:27:21.975 ⇒ 00:27:22.310 Uttam Kumaran: You.
437 00:27:22.310 ⇒ 00:27:25.600 Brian Pei: Ground shipping Whittier ever.
438 00:27:26.100 ⇒ 00:27:28.460 Brian Pei: This is my ranking. I don’t.
439 00:27:28.460 ⇒ 00:27:30.750 Uttam Kumaran: Where is the where are these 2 coming from.
440 00:27:32.260 ⇒ 00:27:35.190 Brian Pei: Oh, Amazon ship station is the source.
441 00:27:36.960 ⇒ 00:27:44.719 Brian Pei: the. And I just picked an example. It’s not a lot. It’s like 5% of the order item, or 5% of this primary key that I made up
442 00:27:45.030 ⇒ 00:27:47.900 Brian Pei: has duplicates, which is fine, but
443 00:27:48.030 ⇒ 00:27:50.519 Brian Pei: to future proof it I add the rank.
444 00:27:50.570 ⇒ 00:27:52.959 Brian Pei: for if you need to join
445 00:27:53.470 ⇒ 00:27:59.329 Brian Pei: back onto order line item, Id, you want to join where this is equal to one, lest.
446 00:27:59.330 ⇒ 00:28:01.140 Uttam Kumaran: My question is like.
447 00:28:01.670 ⇒ 00:28:07.060 Uttam Kumaran: is the actual ship station? Are there duplicates, or is it coming from
448 00:28:08.040 ⇒ 00:28:09.450 Uttam Kumaran: like something else?
449 00:28:10.173 ⇒ 00:28:13.619 Brian Pei: It’s good question. Let’s see, I find that out right now.
450 00:28:14.965 ⇒ 00:28:17.769 Brian Pei: Amazon ship station
451 00:28:20.707 ⇒ 00:28:26.900 Brian Pei: you are taking it from this, so I’ll just take a look at this order item
452 00:28:27.580 ⇒ 00:28:29.659 Brian Pei: and see if it’s a dupe in there.
453 00:28:32.290 ⇒ 00:28:34.829 Brian Pei: Amazon tables. Order.
454 00:28:34.830 ⇒ 00:28:35.660 Uttam Kumaran: A.
455 00:28:35.940 ⇒ 00:28:36.740 Brian Pei: Item.
456 00:28:45.210 ⇒ 00:28:46.310 Brian Pei: Id!
457 00:28:46.720 ⇒ 00:28:47.590 Brian Pei: It’s
458 00:28:48.460 ⇒ 00:28:49.390 Brian Pei: you betch!
459 00:28:52.895 ⇒ 00:28:54.530 Brian Pei: It’s distinct here.
460 00:28:55.860 ⇒ 00:28:58.110 Uttam Kumaran: Okay. So that’s why it’s coming from us somewhere.
461 00:28:58.480 ⇒ 00:29:01.906 Brian Pei: Okay, that’s good to know. Let’s see, what else. What are you joining.
462 00:29:02.590 ⇒ 00:29:03.440 Brian Pei: Blanche?
463 00:29:12.710 ⇒ 00:29:14.340 Brian Pei: What are aggregates
464 00:29:14.750 ⇒ 00:29:16.020 Brian Pei: shouldn’t be. This
465 00:29:16.450 ⇒ 00:29:17.840 Brian Pei: might be this.
466 00:29:18.590 ⇒ 00:29:19.569 Brian Pei: I’ll have to
467 00:29:20.150 ⇒ 00:29:20.970 Brian Pei: look
468 00:29:22.158 ⇒ 00:29:25.440 Brian Pei: it could be one. Yeah, it’s probably one of these 2.
469 00:29:25.650 ⇒ 00:29:28.219 Brian Pei: Okay, so I need to
470 00:29:28.830 ⇒ 00:29:35.220 Brian Pei: find in Cte where this item might be is beute
471 00:29:36.110 ⇒ 00:29:37.580 Brian Pei: before I merge.
472 00:29:39.430 ⇒ 00:29:42.839 Brian Pei: and then I probably won’t need this. The the thing. But that’s
473 00:29:43.870 ⇒ 00:29:45.970 Brian Pei: the this rank thing.
474 00:29:45.970 ⇒ 00:29:52.439 Uttam Kumaran: Yeah, that’s the that’s the thing. i i i doubt that any of the individual source of duplicates the Prom comes in is like.
475 00:29:52.520 ⇒ 00:29:58.509 Uttam Kumaran: I think sometimes it comes in ship station and it comes in Lpl ship station under report.
476 00:29:59.690 ⇒ 00:30:00.400 Brian Pei: Hook up.
477 00:30:00.730 ⇒ 00:30:05.910 Uttam Kumaran: Meaning ship station would be like, Oh, yeah, we shipped it. And then Altayl would be like, Yeah, we also ship that.
478 00:30:06.050 ⇒ 00:30:08.410 Uttam Kumaran: And the ship station one is actually raw.
479 00:30:10.190 ⇒ 00:30:10.900 Brian Pei: Yeah.
480 00:30:11.990 ⇒ 00:30:12.960 Brian Pei: well, in this case.
481 00:30:12.960 ⇒ 00:30:13.690 Uttam Kumaran: Situation. Sounds good.
482 00:30:13.690 ⇒ 00:30:14.170 Brian Pei: Case.
483 00:30:14.170 ⇒ 00:30:14.790 Uttam Kumaran: Already.
484 00:30:15.000 ⇒ 00:30:16.226 Brian Pei: It is
485 00:30:17.460 ⇒ 00:30:18.850 Brian Pei: neither.
486 00:30:20.529 ⇒ 00:30:24.420 Brian Pei: Sorry. In this case it’s neither, because the the source of ship station.
487 00:30:24.420 ⇒ 00:30:25.529 Uttam Kumaran: So I’m saying, like.
488 00:30:25.990 ⇒ 00:30:29.469 Uttam Kumaran: I think that’s this is occurring in our logic somewhere.
489 00:30:29.800 ⇒ 00:30:32.070 Brian Pei: Yeah. But then, also.
490 00:30:32.672 ⇒ 00:30:34.999 Brian Pei: outside of this, you could have a
491 00:30:35.030 ⇒ 00:30:36.230 Brian Pei: the same old.
492 00:30:36.230 ⇒ 00:30:36.790 Uttam Kumaran: Yeah.
493 00:30:38.160 ⇒ 00:30:41.659 Brian Pei: Which which is fine. So I just also need to
494 00:30:42.070 ⇒ 00:30:44.830 Brian Pei: have Amazon, plus
495 00:30:46.380 ⇒ 00:30:48.000 Brian Pei: drop of 5
496 00:30:48.050 ⇒ 00:30:49.580 Brian Pei: order of
497 00:30:50.040 ⇒ 00:30:54.010 Brian Pei: operations for order. Item, id
498 00:30:54.630 ⇒ 00:30:56.060 Brian Pei: Amos first, st
499 00:30:56.180 ⇒ 00:30:58.889 Brian Pei: if not Lcl. If not
500 00:30:58.970 ⇒ 00:31:00.250 Brian Pei: source orders.
501 00:31:01.710 ⇒ 00:31:02.510 Brian Pei: Soccer.
502 00:31:02.970 ⇒ 00:31:05.080 Brian Pei: Alright, I’ll do these 2 things.
503 00:31:05.400 ⇒ 00:31:09.219 Brian Pei: and then I’ll send you the Pr.
504 00:31:09.570 ⇒ 00:31:10.660 Brian Pei: Which.
505 00:31:12.140 ⇒ 00:31:13.020 Uttam Kumaran: Okay. Great.
506 00:31:13.020 ⇒ 00:31:17.300 Brian Pei: You. You are the only person who probably I don’t like just cause.
507 00:31:17.630 ⇒ 00:31:18.430 Uttam Kumaran: Patrick.
508 00:31:18.700 ⇒ 00:31:19.780 Uttam Kumaran: Yeah. Ryan.
509 00:31:19.780 ⇒ 00:31:22.307 Brian Pei: Hyped up about micro macros, so that made me feel.
510 00:31:22.560 ⇒ 00:31:26.039 Uttam Kumaran: Patrick’s gonna be interested in your structure. Ryan is just gonna approve.
511 00:31:26.680 ⇒ 00:31:29.679 Uttam Kumaran: which, again, is like, not what we want to be doing.
512 00:31:29.680 ⇒ 00:31:30.869 Brian Pei: That’s fine. Yeah.
513 00:31:30.870 ⇒ 00:31:33.050 Uttam Kumaran: I’ll I’ll look at it. So okay, great.
514 00:31:33.070 ⇒ 00:31:34.780 Uttam Kumaran: I’m glad like you’re in that.
515 00:31:35.620 ⇒ 00:31:36.500 Brian Pei: Apparently.
516 00:31:36.800 ⇒ 00:31:37.520 Uttam Kumaran: Oh, okay. Yeah.
517 00:31:37.520 ⇒ 00:31:37.920 Brian Pei: Okay.
518 00:31:37.920 ⇒ 00:31:39.480 Uttam Kumaran: I’m gone. I’m going. I’m going.
519 00:31:39.480 ⇒ 00:31:40.770 Brian Pei: I’ll be around all day.
520 00:31:41.120 ⇒ 00:31:41.750 Uttam Kumaran: And right.