Meeting Title: Weekly-Sprint-Review Date: 2024-01-11 Meeting participants: Ryan Luke Daque, Uttam Kumaran
WEBVTT
1 00:00:55.840 ⇒ 00:00:56.850 Uttam Kumaran: Hey?
2 00:00:57.440 ⇒ 00:00:58.810 Ryan Luke Daque: Hello! I owe them.
3 00:00:59.140 ⇒ 00:01:02.919 Uttam Kumaran: hey? Good evening. Good morning.
4 00:01:02.970 ⇒ 00:01:04.129 Ryan Luke Daque: How’s it going?
5 00:01:04.599 ⇒ 00:01:14.040 Uttam Kumaran: Things are good. Yeah. Things are good. I just been spending a lot of time last few days on some more sales
6 00:01:14.270 ⇒ 00:01:26.339 Uttam Kumaran: related things. So I’m really excited for a couple of different initiatives that I’m working on. And I’m actually been meeting with the snowflake team as well
7 00:01:26.400 ⇒ 00:01:31.880 Uttam Kumaran: I mentioned that we are working on uploading some stuff to the snowfake marketplace.
8 00:01:32.190 ⇒ 00:01:40.780 Ryan Luke Daque: so I met with their team yesterday and i’m meeting with them again today to talk about best practices and
9 00:01:41.140 ⇒ 00:01:44.320 Uttam Kumaran: you know where there’s opportunity. So that’s been good.
10 00:01:45.170 ⇒ 00:01:48.270 And then, do you know the software sap?
11 00:01:48.400 ⇒ 00:01:50.620 Ryan Luke Daque: Yeah, I’ve heard of it. Yeah.
12 00:01:51.890 ⇒ 00:02:01.430 Uttam Kumaran: So IAIA friend of mine, she’s working at a at another consulting firm, and all they do is work day and sap work.
13 00:02:01.740 ⇒ 00:02:03.440 Uttam Kumaran: I’m
14 00:02:03.500 ⇒ 00:02:14.109 Uttam Kumaran: I met with them the CEO and the head of that team to talk about potentially giving us all of their data related work if any data
15 00:02:14.300 ⇒ 00:02:15.569 Uttam Kumaran: with their clients.
16 00:02:16.520 ⇒ 00:02:20.410 Uttam Kumaran: So that meeting was really good. So that was yesterday.
17 00:02:20.580 ⇒ 00:02:26.019 Ryan Luke Daque: SAP. Does seem to be a bit outdated and a bit complicated as well.
18 00:02:26.070 ⇒ 00:02:39.289 Uttam Kumaran: yeah, definitely. So there’s a lot of people that are migrating parts of sap to snowflake, or they want integration. I pretty much want to become like their preferred person to kind of handle that sort of work.
19 00:02:39.810 ⇒ 00:02:43.519 Uttam Kumaran: so yeah.
20 00:02:47.550 ⇒ 00:02:59.760 Uttam Kumaran: cool. So yeah, I mean, otherwise, I think this week has been going really well, the way I want to structure. These meetings, as I mentioned, is just a review of the work that’s been done this week.
21 00:03:00.160 ⇒ 00:03:10.909 Uttam Kumaran: I might plan for kind of a client meeting tomorrow, and then any current blockers between us getting everything done between now and
22 00:03:10.990 ⇒ 00:03:18.810 Uttam Kumaran: tomorrow. So I’m just gonna pull up the Github project on my end.
23 00:03:19.250 ⇒ 00:03:31.520 Uttam Kumaran: and then we can just talk about things that are in motion right now. I know a lot of it is on your plate, so I’ll just go briefly and just talk about a couple of things that I handled.
24 00:03:31.910 ⇒ 00:03:36.169 Uttam Kumaran: grab that
25 00:03:38.620 ⇒ 00:03:40.440 Uttam Kumaran: cool
26 00:03:40.630 ⇒ 00:03:54.090 Uttam Kumaran: so a couple of things this week that I was able to do one was modify the auto suspend on the warehouse. The warehouse now
27 00:03:54.940 ⇒ 00:04:05.329 Uttam Kumaran: only runs every 30 s. and so I’m actually think this is maybe a good time. I can actually show you within Snowflake what I’m looking at in terms of credit spend.
28 00:04:05.500 ⇒ 00:04:08.310 Uttam Kumaran: And I’m gonna plan on bringing
29 00:04:08.320 ⇒ 00:04:11.020 Uttam Kumaran: this stuff into light dash as well.
30 00:04:11.720 ⇒ 00:04:17.820 Uttam Kumaran: but let me show you. So you have context.
31 00:04:18.790 ⇒ 00:04:34.350 Uttam Kumaran: So
32 00:04:34.510 ⇒ 00:04:46.080 Uttam Kumaran: when you’re in snowflake, if you go under admin and go under cost management, you’ll actually begin to see how much we’re spending per day and so
33 00:04:46.540 ⇒ 00:04:49.490 Uttam Kumaran: every credit cost $2 for us.
34 00:04:50.170 ⇒ 00:05:02.890 Uttam Kumaran: If we. And right now we spend average of 4 credits per day so roughly, 8 bucks per day, of course, 8 bucks times 30 to roughly 240 bucks per month.
35 00:05:03.550 ⇒ 00:05:08.609 Uttam Kumaran: My my communication to them was that
36 00:05:08.620 ⇒ 00:05:11.370 Uttam Kumaran: we are going to probably be around
37 00:05:11.550 ⇒ 00:05:20.890 Uttam Kumaran: hopefully 2 50 a month. Last, if you look at what we did last
38 00:05:21.610 ⇒ 00:05:23.650 Uttam Kumaran: a month.
39 00:05:25.270 ⇒ 00:05:27.229 Uttam Kumaran: Let’s see if it loads.
40 00:05:29.170 ⇒ 00:05:32.809 Uttam Kumaran: We did about a hundred 97 credits.
41 00:05:32.830 ⇒ 00:05:36.460 Ryan Luke Daque: which was about 400 bucks.
42 00:05:36.750 ⇒ 00:05:39.140 Uttam Kumaran: I said that I want to try and stay
43 00:05:39.560 ⇒ 00:05:42.550 Uttam Kumaran: closer to 2 50.
44 00:05:42.750 ⇒ 00:05:57.449 Uttam Kumaran: So that’s kind of like our budget, for example, and so pretty much what what I did yesterday was. I tried to make sure that the warehouses suspend after 30 s, meaning, when you run a query.
45 00:05:57.530 ⇒ 00:06:24.480 Uttam Kumaran: the warehouse stays online 30 s after, and then we’ll suspend Snowflake works is you pay while the warehouse is online. So you may run one query, and previously the warehouse was on 10 min auto suspend, I mean, run, quit. One query means you actually are spending 10 min worth of compute. Which, of course, is pretty obvious, like waste.
46 00:06:24.680 ⇒ 00:06:29.239 So what we’re gonna do is begin to see.
47 00:06:29.900 ⇒ 00:06:37.240 Uttam Kumaran: we’re just gonna begin to see when that actually like how we end up this this
48 00:06:37.690 ⇒ 00:06:38.830 month.
49 00:06:38.960 ⇒ 00:06:51.560 Uttam Kumaran: and it looks like even between yesterday and today. We’re you know, we continue to only spend about 8, and it looks like we should end up close to what I projected, which is like
50 00:06:52.360 ⇒ 00:06:53.860 Uttam Kumaran: 300 or less.
51 00:06:54.220 ⇒ 00:07:02.040 Uttam Kumaran: which is great. So yeah, that’s that’s kind of the main thing that I’m looking at
52 00:07:02.260 ⇒ 00:07:10.960 Uttam Kumaran: and at the moment, I just have a budget that alerts my email when we’ve hit 2 50.
53 00:07:11.430 ⇒ 00:07:25.729 Uttam Kumaran: So that’s the context there. So let me know if you have any questions or if you wanna take a look at that, that’s that’s in there. And then I don’t remember what this was.
54 00:07:25.820 ⇒ 00:07:27.839 Uttam Kumaran: Oh, I think this was
55 00:07:27.890 ⇒ 00:07:35.370 Uttam Kumaran: for my last Friday call. So yesterday I pushed a couple of
56 00:07:35.750 ⇒ 00:07:43.710 Uttam Kumaran: prs. The main things were one. I added this,
57 00:07:43.750 ⇒ 00:07:48.609 Uttam Kumaran: Github security thing called dependabot. Have you heard of this?
58 00:07:48.760 ⇒ 00:07:57.110 Ryan Luke Daque: Yeah. So that way, it’s helping us update all of our dependencies. So you’ll see all the Prs here. It’s
59 00:07:57.230 ⇒ 00:08:01.230 Uttam Kumaran: updating all the things which is great cause. Now we don’t have to deal with that
60 00:08:02.020 ⇒ 00:08:05.849 Uttam Kumaran: the other thing that I did was
61 00:08:06.220 ⇒ 00:08:09.029 I added shipment service category.
62 00:08:09.420 ⇒ 00:08:12.889 Uttam Kumaran: So all orders. Yeah, I noticed that as well.
63 00:08:13.320 ⇒ 00:08:19.000 Uttam Kumaran: yeah. And then I also, yeah, I updated a couple of things on the labeling side.
64 00:08:19.070 ⇒ 00:08:31.780 Uttam Kumaran: and then let’s see this change. Was you? Oh, this one was also used. We could talk about that. And then oh, this is. The change I made is a couple of big bigger things.
65 00:08:32.750 ⇒ 00:08:37.580 Uttam Kumaran: so one that we we were getting amate cancelled orders from Amazon
66 00:08:37.929 ⇒ 00:08:40.360 Ryan Luke Daque: coming in empty.
67 00:08:40.590 ⇒ 00:08:43.950 Uttam Kumaran: So I filtered those orders out of order items.
68 00:08:44.250 ⇒ 00:08:45.240 Ryan Luke Daque: Okay?
69 00:08:45.580 ⇒ 00:08:48.949 Uttam Kumaran: The second thing is, I added the order, yeah. URL, also for Amazon.
70 00:08:49.780 ⇒ 00:08:51.059 Ryan Luke Daque: I see. Yeah.
71 00:08:51.160 ⇒ 00:08:53.399 Uttam Kumaran: which is great. And that’s working really great.
72 00:08:54.300 ⇒ 00:09:00.550 Uttam Kumaran: And I just kind of added that order. Yeah. URL, within order items within Amazon orders.
73 00:09:02.980 ⇒ 00:09:15.180 Uttam Kumaran: This was just adding a bunch of dimensions. So it’s like, probably like a dB, like a light dash. Compile cleanup. I added, order URL to all order items, because now we have it for both.
74 00:09:16.740 ⇒ 00:09:18.700 And
75 00:09:18.970 ⇒ 00:09:23.009 Uttam Kumaran: yeah, these are all the same thing. The second thing that I did was
76 00:09:23.840 ⇒ 00:09:28.980 Uttam Kumaran: I changed. There’s a field called item, proportional discount
77 00:09:29.170 ⇒ 00:09:43.719 Uttam Kumaran: can item. Proportional discount takes the so a discount is on an order. But in shopify you order items right? So I discussed with them like I can’t see how much a discount as applied to one item.
78 00:09:44.250 ⇒ 00:09:49.850 Uttam Kumaran: and they said, Why don’t we just do it? Proportional? So split the discount proportionally based on the price
79 00:09:50.020 ⇒ 00:09:51.269 of the item.
80 00:09:51.910 ⇒ 00:09:53.579 Uttam Kumaran: And so that’s what I’m doing.
81 00:09:53.770 ⇒ 00:09:56.710 I realized yesterday the reason why the discounts
82 00:09:56.870 ⇒ 00:09:58.060 Uttam Kumaran: where
83 00:09:58.130 ⇒ 00:09:59.380 messed up
84 00:10:00.030 ⇒ 00:10:02.590 Uttam Kumaran: was partly due to this
85 00:10:02.660 ⇒ 00:10:08.059 Uttam Kumaran: that I wasn’t. Actually, I was actually only doing it based on price.
86 00:10:08.340 ⇒ 00:10:13.099 Uttam Kumaran: But I wasn’t doing it based on gross sales, which is price times discount price Friday.
87 00:10:13.880 ⇒ 00:10:18.419 Uttam Kumaran: So now, that’s resolved. So that discounts are working. Now.
88 00:10:18.820 ⇒ 00:10:20.780 Ryan Luke Daque: yeah, yeah, nice.
89 00:10:21.880 ⇒ 00:10:29.010 Uttam Kumaran: And then catch there. Yeah. And then the only thing is you don’t. I realize we don’t actually need this URL encode.
90 00:10:30.240 ⇒ 00:10:32.629 Uttam Kumaran: I purely just put the
91 00:10:32.870 ⇒ 00:10:41.710 Uttam Kumaran: I purely just put the URL. In here. so I don’t even do. I don’t even do any any
92 00:10:41.800 ⇒ 00:10:51.200 Uttam Kumaran: thing. I pretty much just do value dot raw. And it’s been working. So does it click, does it? Is it like clickable? Even if you don’t, really.
93 00:10:51.460 ⇒ 00:10:52.440 Uttam Kumaran: it’s good cool
94 00:10:55.410 ⇒ 00:10:56.520 cool.
95 00:10:57.290 ⇒ 00:11:01.799 Uttam Kumaran: so that I think is a big thing with me.
96 00:11:02.500 ⇒ 00:11:11.569 Uttam Kumaran: if you want to go and talk about your stuff. And this is a nice, because what I’ll also try and do is
97 00:11:12.380 ⇒ 00:11:21.260 Uttam Kumaran: I’m gonna see if we can add dates to some of these that way. We could filter everything by dates. But it’s not too many things. Yeah, if you wanna if you wanna go oh, go ahead.
98 00:11:22.240 ⇒ 00:11:25.530 Ryan Luke Daque: Yeah, sure, I didn’t. Did you wanna
99 00:11:25.900 ⇒ 00:11:51.970 Uttam Kumaran: discuss more about this stuff that we did or like the pending ones? So just review, we could just do a high level review of like everything that we pushed. I mean, I reviewed all the Pr. So you could just walk through. Here are the things that we have we did Pr. For, and then talk about things that are in review. And then I also want to talk about all this stuff that’s in progress. What’s going to be completed by tomorrow.
100 00:11:52.640 ⇒ 00:11:57.640 Ryan Luke Daque: Gotcha. Yeah, sure. Let me share my screen, then.
101 00:11:58.300 ⇒ 00:11:59.190 Uttam Kumaran: Great
102 00:12:01.540 ⇒ 00:12:02.210 thanks.
103 00:12:10.080 ⇒ 00:12:13.449 Uttam Kumaran: There you go. Can you see my screen?
104 00:12:15.590 ⇒ 00:12:18.809 Ryan Luke Daque: So yeah, let me see here. So yeah, I
105 00:12:20.080 ⇒ 00:12:21.250 Ryan Luke Daque: like this was
106 00:12:21.660 ⇒ 00:12:31.120 Ryan Luke Daque: one that I added yesterday, adding refund date. Basically, this is one of the tasks was assigned to me
107 00:12:32.200 ⇒ 00:12:37.470 Ryan Luke Daque: creating a refund date. So basically, yeah, yeah, I added.
108 00:12:39.520 ⇒ 00:12:46.739 Ryan Luke Daque: yeah, I think you’ve already reviewed this. But yeah, this is just adding refunds to shopify, and Amazon well, actually shopify already has
109 00:12:46.920 ⇒ 00:12:51.589 Ryan Luke Daque: refund date. II you already added that, but it wasn’t in the
110 00:12:52.590 ⇒ 00:13:01.590 Ryan Luke Daque: it wasn’t in the all order yet. So I just added that pair in all orders.
111 00:13:02.210 ⇒ 00:13:07.530 Ryan Luke Daque: So also for Amazon refunds as well. Yup
112 00:13:07.910 ⇒ 00:13:08.910 Ryan Luke Daque: and
113 00:13:09.010 ⇒ 00:13:15.659 Ryan Luke Daque: so yeah, I haven’t. I’m still working on creating the dashboard. For the refunds.
114 00:13:16.450 ⇒ 00:13:24.409 Ryan Luke Daque: Basically, yesterday’s refugees just added, this should be. This is what I’m working on right now should be pretty quick.
115 00:13:25.050 ⇒ 00:13:25.990 Ryan Luke Daque: Add
116 00:13:26.370 ⇒ 00:13:33.369 Ryan Luke Daque: that related to this pull request, and then we should be good for this task every week. Yeah, double check, because I might have done it.
117 00:13:34.390 ⇒ 00:13:37.870 Ryan Luke Daque: Yeah, I don’t. Yeah, I’m not sure if there is any.
118 00:13:38.330 ⇒ 00:13:41.410 Ryan Luke Daque: Oh, okay, okay, okay, cool.
119 00:13:43.560 ⇒ 00:13:48.380 Ryan Luke Daque: And so yeah, aside from that, I also added.
120 00:13:50.170 ⇒ 00:14:05.129 Ryan Luke Daque: service category. Do a few of the other models because you already have had it in like one of the models, I believe. So I just added it to Amazon. Shopify
121 00:14:05.330 ⇒ 00:14:13.310 Ryan Luke Daque: as well as old orders. Great. Okay. that. And I use that as well for the
122 00:14:13.840 ⇒ 00:14:18.830 Ryan Luke Daque: other ticket, which was the creation of the shipping efficiency dashboard.
123 00:14:20.870 ⇒ 00:14:23.910 Ryan Luke Daque: I added. A few but
124 00:14:25.130 ⇒ 00:14:32.909 Ryan Luke Daque: equals here, like the pop, the last 30 price per pound by shipment service category. So yeah, that
125 00:14:33.130 ⇒ 00:14:39.329 Ryan Luke Daque: that field. I’m not sure if this is like the best way to show it, or maybe you just show it this table.
126 00:14:39.550 ⇒ 00:14:46.269 Ryan Luke Daque: But I showed it in a bar chart. For now this is just the last 30 days.
127 00:14:46.310 ⇒ 00:14:49.469 Uttam Kumaran: Yeah. The other thing is, I wanna know what’s an unknown.
128 00:14:50.020 ⇒ 00:14:55.619 Ryan Luke Daque: Yeah, that’s also one thing we can. I can really dig into that.
129 00:14:55.680 ⇒ 00:15:08.790 Uttam Kumaran: Yeah, I mean, that’s gonna be their. That’s gonna be their first question. So not sure where this is coming from. So I’ll I’ll have to look into this. Okay?
130 00:15:09.740 ⇒ 00:15:12.960 Ryan Luke Daque: So yeah,
131 00:15:15.190 ⇒ 00:15:22.269 Ryan Luke Daque: I also added the top 10 most expensive shipment orders in the last 90 days. So basically, just just the top 10
132 00:15:22.800 ⇒ 00:15:25.300 Ryan Luke Daque: showing the order number.
133 00:15:26.500 ⇒ 00:15:31.479 Ryan Luke Daque: you know. I think what would be also good is putting the actual order
134 00:15:32.430 ⇒ 00:15:33.890 Uttam Kumaran: amount in here.
135 00:15:34.400 ⇒ 00:15:49.430 Uttam Kumaran: because so cause so think about it. The shipment is a is just a factor. The the Re. It’s like, let’s say, that product was $5,000. Maybe shipping isn’t bad, but if it’s 50% of the sale.
136 00:15:49.490 ⇒ 00:15:54.580 Uttam Kumaran: then it’s a problem, right? So you want to look at it relative to the gross sale amount
137 00:15:54.670 ⇒ 00:16:04.099 Ryan Luke Daque: that makes sense. Yeah. so we can. I can add a gross sale. Gross price here. Most way of sale exactly. Yeah.
138 00:16:04.180 ⇒ 00:16:08.619 Ryan Luke Daque: And shake Shamus, same as with a shipment volume by zone.
139 00:16:09.130 ⇒ 00:16:14.419 Uttam Kumaran: And then I’ll also be adding the other one, which is the by by product
140 00:16:14.610 ⇒ 00:16:19.070 Ryan Luke Daque: category, which
141 00:16:19.370 ⇒ 00:16:20.770 Ryan Luke Daque: I’ll add that in
142 00:16:21.510 ⇒ 00:16:26.689 Ryan Luke Daque: then we’ll be. We should be good for your meeting tomorrow with the client for this.
143 00:16:26.800 ⇒ 00:16:28.230 Uttam Kumaran: Okay? Great.
144 00:16:28.590 ⇒ 00:16:35.519 Ryan Luke Daque: this. Yeah. Going back to the pull request. I, what else did I do this week? I think.
145 00:16:36.120 ⇒ 00:16:40.209 Uttam Kumaran: yeah, total sales, I added.
146 00:16:40.270 ⇒ 00:16:43.780 Ryan Luke Daque: yeah, which is just the price times. The item cost.
147 00:16:43.890 ⇒ 00:16:45.689 Uttam Kumaran: Yeah, this isn’t a good catch.
148 00:16:46.970 ⇒ 00:16:52.919 Ryan Luke Daque: And like one thing, I also noticed like, I think you were also working on like
149 00:16:53.190 ⇒ 00:16:54.240 Ryan Luke Daque: changing
150 00:16:54.460 ⇒ 00:16:56.819 Ryan Luke Daque: renaming stuff. Yeah.
151 00:16:56.990 ⇒ 00:17:08.500 Ryan Luke Daque: And like, I also renamed it back somewhere. I think I think I just added here added it here. I think. Yeah, it was like this was duplicated in some other
152 00:17:08.650 ⇒ 00:17:14.579 Ryan Luke Daque: for you both. So yeah, so we should. That’s what helped the
153 00:17:16.040 ⇒ 00:17:19.869 Ryan Luke Daque: the Vital Science dashboard basically to get the
154 00:17:20.660 ⇒ 00:17:23.050 Ryan Luke Daque: correct shopify sales
155 00:17:25.440 ⇒ 00:17:30.020 Ryan Luke Daque: and your update with the refund and the discounts also help that.
156 00:17:30.110 ⇒ 00:17:33.209 Ryan Luke Daque: Okay? Great.
157 00:17:33.480 ⇒ 00:17:39.210 Ryan Luke Daque: Yeah. That got fixed. So yeah, other than that.
158 00:17:39.530 ⇒ 00:17:49.870 Ryan Luke Daque: I think, yeah, this, this was like what took me a while like trying to figure out what’s causing the discrepancy. And I only have like access to
159 00:17:50.160 ⇒ 00:17:53.100 Ryan Luke Daque: Facebook Ads ship station, Google, ads.
160 00:17:53.260 ⇒ 00:17:59.160 Ryan Luke Daque: but I still don’t have any access to Amazon requires Odp. But
161 00:17:59.240 ⇒ 00:18:07.469 Ryan Luke Daque: yeah, we’re doing great so far with division vital signs. Except for the shipping cost. This is like, maybe where I might need help from you.
162 00:18:07.610 ⇒ 00:18:09.149 Uttam Kumaran: Yeah. So maybe like.
163 00:18:09.280 ⇒ 00:18:26.589 Ryan Luke Daque: yeah, maybe let’s look at what else is remaining for the week, and then we can end with sure. So I guess one more task that’s assigned to me is renaming this sales metrics. So I haven’t really looked. So let’s actually, yeah. So let’s actually push this to
164 00:18:26.600 ⇒ 00:18:34.859 Uttam Kumaran: backlog, because I’m gonna be meeting with them about this tomorrow. So let’s move this there and then
165 00:18:35.250 ⇒ 00:18:41.790 Uttam Kumaran: creating a refund date. I think that’s that’s pretty much done. I’m just creating the the
166 00:18:42.310 ⇒ 00:18:43.820 Uttam Kumaran: dashboard. Yeah.
167 00:18:44.190 ⇒ 00:18:47.170 Ryan Luke Daque: Then this one’s just the product pass.
168 00:18:47.550 ⇒ 00:18:50.270 Uttam Kumaran: Okay, cool. Okay, great
169 00:18:51.410 ⇒ 00:18:57.630 Uttam Kumaran: and then you could probably close out your shipping service category. Right?
170 00:18:58.170 ⇒ 00:18:59.880 Ryan Luke Daque: Yep. This is done already.
171 00:19:01.970 ⇒ 00:19:04.000 Uttam Kumaran: And then
172 00:19:05.720 ⇒ 00:19:09.370 Uttam Kumaran: I think this one. You can. I would close it after the refunds. Yeah.
173 00:19:10.390 ⇒ 00:19:15.640 Uttam Kumaran: And then, I’m still waiting on the 5 trans. Stuff. But
174 00:19:16.160 ⇒ 00:19:18.539 Uttam Kumaran: let’s just leave it there. So I remember
175 00:19:21.530 ⇒ 00:19:25.900 Uttam Kumaran: I’m honestly gonna probably create like a blocked column.
176 00:19:29.630 ⇒ 00:19:30.920 Uttam Kumaran: And then
177 00:19:31.210 ⇒ 00:19:37.720 Uttam Kumaran: anything else on the like infrastructure or documentation side
178 00:19:37.800 ⇒ 00:19:41.439 Uttam Kumaran: that we want to do on the left. I created a couple of
179 00:19:41.470 ⇒ 00:19:56.339 Uttam Kumaran: things for documentation at the bottom. So I wanted to add documentation for all the components of sales all the way to profit, and how we? And then I also wanna do some documentation on each of the sources where to go to verify? And things like that.
180 00:19:56.630 ⇒ 00:20:02.870 Uttam Kumaran: Are there any other like documentation or infrastructure related things we need to do?
181 00:20:04.430 ⇒ 00:20:06.209 Ryan Luke Daque: Hmm.
182 00:20:07.840 ⇒ 00:20:12.309 Uttam Kumaran: like we have macros for most things. We have tests running like.
183 00:20:13.450 ⇒ 00:20:25.489 Uttam Kumaran: maybe maybe adding more tests. I don’t know. Deal. Oh, we need to do the, I guess. Like, if there’s anything just glaring. Otherwise I’m gonna add some stuff over the weekend. I wanna change the Dbt bill to just be there
184 00:20:25.510 ⇒ 00:20:27.420 Uttam Kumaran: modified. And then.
185 00:20:28.220 ⇒ 00:20:29.840 Ryan Luke Daque: yeah, maybe that one
186 00:20:30.050 ⇒ 00:20:31.699 Ryan Luke Daque: as well like.
187 00:20:32.210 ⇒ 00:20:32.980 Ryan Luke Daque: yeah.
188 00:20:34.080 ⇒ 00:20:44.500 Ryan Luke Daque: that’d be great. I am not sure we can add more tests, because I think we’re only adding, there’s only a few tests that I added here.
189 00:20:44.720 ⇒ 00:20:57.130 Ryan Luke Daque: yeah, I’ll I’ll try to see what else we can do like in terms of tests, and maybe even we can add descriptions to our columns. That would be also one way to document columns.
190 00:20:57.680 ⇒ 00:21:00.639 Ryan Luke Daque: But yeah, it’s gonna be a quite
191 00:21:00.990 ⇒ 00:21:10.639 Uttam Kumaran: well, I’m in it. Yeah, yeah. I tried doing this as well using AI, and it. It does a pretty good job.
192 00:21:10.800 ⇒ 00:21:17.090 Ryan Luke Daque: Most. Mostly, we just have to review it. Basically make sure that it’s making sense. So yeah.
193 00:21:18.030 ⇒ 00:21:22.999 Ryan Luke Daque: yeah, this should be a great one. We can. We can add that maybe just document all the columns here.
194 00:21:23.650 ⇒ 00:21:24.510 Okay.
195 00:21:27.500 ⇒ 00:21:33.569 Ryan Luke Daque: yeah. Other than that. Like, everything seems to be running. Well, I really like, like what you did with the workflows.
196 00:21:34.060 ⇒ 00:21:36.299 Uttam Kumaran: Yeah, give me a chance to take a look.
197 00:21:36.730 ⇒ 00:21:38.310 Ryan Luke Daque: Yeah, it’s pretty cool.
198 00:21:39.420 ⇒ 00:21:40.360 Uttam Kumaran: nice.
199 00:21:41.960 ⇒ 00:21:45.699 Uttam Kumaran: So yeah, we’ll continue to evolve those.
200 00:21:46.890 ⇒ 00:21:51.989 Uttam Kumaran: so and then, yeah, I’m actually really happy with how that ended up as well.
201 00:21:52.780 ⇒ 00:21:58.589 Ryan Luke Daque: maybe one like if we ever get like new clients. I’m not sure like how we can
202 00:21:59.330 ⇒ 00:22:10.619 Uttam Kumaran: leverage like what we already have here. Oh, 1 million percent. So one of the things I’m on my like. So it’s funny cause I have like to do list for every project. And then I have like
203 00:22:10.770 ⇒ 00:22:18.850 Uttam Kumaran: company to do, and then like company technical, to do one of the things I want to create a boilerplate dbt. Repo
204 00:22:18.970 ⇒ 00:22:37.759 Uttam Kumaran: that we can use on every client which will come with the workflows. It comes with the macro that that are helpful. It comes with all the like. Stuff, any anything that’s like used commonly across, like, for example, if I’m the client uses shopify. We have shopify stuff ready.
205 00:22:37.860 ⇒ 00:22:43.850 Uttam Kumaran: All that stuff. I wanna, I’m gonna we’re gonna create like some repos that are that help with that.
206 00:22:44.070 ⇒ 00:22:45.130 Ryan Luke Daque: Yeah.
207 00:22:45.410 ⇒ 00:23:00.749 Uttam Kumaran: So I’m gonna wait until we feel like we’re in a good place to do that. I also wanna have all the Dbt config really, really tight, like, well, I’m still putting in my profile like on there.
208 00:23:01.000 ⇒ 00:23:05.590 Uttam Kumaran: So this we need to figure out honestly, maybe like.
209 00:23:06.190 ⇒ 00:23:08.480 Uttam Kumaran: if if this next week is like.
210 00:23:09.200 ⇒ 00:23:14.490 Uttam Kumaran: if this next week is good, then maybe towards the end of the month we can do some Dbt cleanup.
211 00:23:14.690 ⇒ 00:23:16.670 Ryan Luke Daque: Yeah. And great
212 00:23:19.040 ⇒ 00:23:20.600 Uttam Kumaran: cool. Okay?
213 00:23:22.070 ⇒ 00:23:24.360 Uttam Kumaran: So yeah, I mean we can talk about
214 00:23:25.650 ⇒ 00:23:27.180 ship station.
215 00:23:27.460 ⇒ 00:23:42.280 Ryan Luke Daque: sure. So what I’ve been looking at? Maybe I’m looking at incorrectly and looking at it incorrectly. But what I’ve been looking at so far, like, for example, yesterday’s date, which is what our
216 00:23:42.530 ⇒ 00:23:46.590 Ryan Luke Daque: vital signs they is showing. Right?
217 00:23:47.330 ⇒ 00:23:52.180 Uttam Kumaran: yeah. Also, it’s 10 syllables. So 10, yeah.
218 00:23:52.350 ⇒ 00:23:53.969 Ryan Luke Daque: January 10. Here.
219 00:23:58.240 ⇒ 00:24:06.130 Ryan Luke Daque: it’s gonna show. Something like shipping costs will be 793. Or even if you go to like customer operations.
220 00:24:07.490 ⇒ 00:24:17.760 Ryan Luke Daque: 793 shipping costs. And but if we look at like so I’m I’m actually looking at shipping costs over here.
221 00:24:18.050 ⇒ 00:24:24.580 Ryan Luke Daque: It’s a daily Kpi. So if you got to January, then it’s just that’s that’s
222 00:24:24.850 ⇒ 00:24:28.179 Ryan Luke Daque: so. It’s not being so. I at first I was like.
223 00:24:28.420 ⇒ 00:24:30.889 Ryan Luke Daque: maybe we’re just having a delay or something.
224 00:24:31.130 ⇒ 00:24:37.340 Ryan Luke Daque: Yeah. But like, if I look at the ninth, which is like what I look at earlier.
225 00:24:38.380 ⇒ 00:24:43.670 Ryan Luke Daque: it’s still not matching. I can see we have
226 00:24:45.250 ⇒ 00:24:48.610 Ryan Luke Daque: a thousand, 1,000. We got 61.
227 00:24:49.330 ⇒ 00:24:52.930 Ryan Luke Daque: Yeah, we’re just so it was, just, you know, 7 or 75.
228 00:24:53.450 ⇒ 00:24:54.730 Uttam Kumaran: Okay, so
229 00:24:56.040 ⇒ 00:24:58.070 Ryan Luke Daque: yeah, there’s something
230 00:24:59.070 ⇒ 00:25:05.850 Ryan Luke Daque: there’s something like probably missing or missing something. This one’s able to look at.
231 00:25:09.780 ⇒ 00:25:13.050 I guess one thing we should try and do is look at
232 00:25:13.190 ⇒ 00:25:16.140 Uttam Kumaran: each of the different shipments that went out.
233 00:25:16.810 ⇒ 00:25:22.789 Ryan Luke Daque: Yeah, I’ll have to dig in deeper here like this. This is like the Daily Kpi.
234 00:25:22.800 ⇒ 00:25:27.960 Uttam Kumaran: So it all comes from ship. It all comes from. If you go under ship station on the left.
235 00:25:30.030 ⇒ 00:25:34.459 Uttam Kumaran: although. Yeah. it’s all from here.
236 00:25:35.020 ⇒ 00:25:39.630 Ryan Luke Daque: So maybe even while we’re on this call, can you just run? Take?
237 00:25:39.970 ⇒ 00:25:42.400 Uttam Kumaran: If you have a
238 00:25:43.330 ⇒ 00:25:52.550 Uttam Kumaran: like are you are? Do you run Snowflake within Vs code, or you run it? You run queries like outside. I can do it here because I have like the V team.
239 00:25:53.280 ⇒ 00:25:59.200 Uttam Kumaran: Yeah, see? See if you can just run like selecting the
240 00:25:59.970 ⇒ 00:26:02.850 Uttam Kumaran: item price from this
241 00:26:12.210 ⇒ 00:26:13.630 Ryan Luke Daque: I can price
242 00:26:14.350 ⇒ 00:26:17.770 or like whatever. Where? What is the
243 00:26:18.640 ⇒ 00:26:23.810 Uttam Kumaran: There should be like a shipment? Oh, amount paid amount paid.
244 00:26:24.980 ⇒ 00:26:27.209 Uttam Kumaran: So see if you can just run like a sum.
245 00:26:27.310 ⇒ 00:26:30.159 Uttam Kumaran: Order, item, create date
246 00:26:30.640 ⇒ 00:26:31.880 Uttam Kumaran: item paid
247 00:26:41.950 ⇒ 00:26:43.060 Ryan Luke Daque: of the
248 00:26:43.280 ⇒ 00:26:44.130 Uttam Kumaran: yeah
249 00:26:45.420 ⇒ 00:26:46.980 Ryan Luke Daque: out to.
250 00:26:51.510 ⇒ 00:26:56.870 Uttam Kumaran: So actually, I have a I have a better. So let me let me actually show you. I think I have a better workflow for you
251 00:26:58.030 ⇒ 00:27:03.150 Uttam Kumaran: if you wanna try it. So Snowflake has a Vs code extension.
252 00:27:03.360 ⇒ 00:27:04.220 Ryan Luke Daque: Hmm!
253 00:27:04.690 ⇒ 00:27:11.980 Uttam Kumaran: If you want to try installing it, I could just walk you through really quick, because you can run queries directly on the table that’s already there instead of
254 00:27:12.320 ⇒ 00:27:17.219 Uttam Kumaran: So if you go to extensions
255 00:27:18.850 ⇒ 00:27:21.290 Uttam Kumaran: on the on the left, it’s the blocks.
256 00:27:22.550 ⇒ 00:27:23.770 Ryan Luke Daque: Oh, yeah, this week.
257 00:27:24.360 ⇒ 00:27:25.849 Uttam Kumaran: and you search Snowflake.
258 00:27:28.700 ⇒ 00:27:30.390 Uttam Kumaran: Yep, that’s top one.
259 00:27:33.230 ⇒ 00:27:33.900 Ryan Luke Daque: Okay?
260 00:27:41.690 ⇒ 00:27:54.870 Uttam Kumaran: And then you should see on the bottom on the left bar. Yep. So just wanna put the name of the account. I will. I can actually just send. I’ll send it to you and
261 00:27:55.620 ⇒ 00:27:58.530 Ryan Luke Daque: It should be here in classroom manager.
262 00:27:59.210 ⇒ 00:28:00.290 Uttam Kumaran: Yeah.
263 00:28:00.990 ⇒ 00:28:04.940 Ryan Luke Daque: yes, sir. your your access.
264 00:28:08.030 ⇒ 00:28:10.560 Uttam Kumaran: Yep, so you could just put in.
265 00:28:11.710 ⇒ 00:28:14.219 Uttam Kumaran: yeah, that whole account, URL,
266 00:28:14.980 ⇒ 00:28:18.499 Ryan Luke Daque: but you do. You have a login? Right?
267 00:28:19.210 ⇒ 00:28:28.829 Uttam Kumaran: No, I’m using this. I’m using yours. Oh, okay, well, I’m gonna make you login. But yeah, so then, yeah, you can. So put that in. Yeah, that’s the account. URL,
268 00:28:30.840 ⇒ 00:28:32.040 Uttam Kumaran: and now, yeah.
269 00:28:41.260 ⇒ 00:28:47.530 Uttam Kumaran: cool. So now, what I do is I have a worksheet dot sequel file.
270 00:28:47.670 ⇒ 00:28:50.899 So open up a new file on your
271 00:28:50.910 ⇒ 00:28:58.710 Uttam Kumaran: in the repo. Just call like worksheet dot SQL. Or something doesn’t have to be anything. And then just make sure you add it to your get. Ignore?
272 00:29:03.690 ⇒ 00:29:06.999 Uttam Kumaran: Yeah, you could just save it as worksheet dot. SQL,
273 00:29:13.900 ⇒ 00:29:20.800 Uttam Kumaran: and yeah, just make sure you have it in your like, get ignore? So it doesn’t get committed. But
274 00:29:21.480 ⇒ 00:29:24.539 Uttam Kumaran: yeah, you see, it’s there. You can. Yeah, exactly.
275 00:29:25.510 ⇒ 00:29:29.889 Uttam Kumaran: Yeah. just to the you could put it just to the highest
276 00:29:30.400 ⇒ 00:29:31.370 Ryan Luke Daque: whatever.
277 00:29:33.970 ⇒ 00:29:38.950 Uttam Kumaran: Yeah, if you if you go over, if you go all the way to the bottom. It should let you do that.
278 00:29:45.640 ⇒ 00:29:46.440 Uttam Kumaran: Yeah.
279 00:29:47.790 ⇒ 00:29:51.429 Uttam Kumaran: Okay. Now, within here, yeah, you just put
280 00:29:51.540 ⇒ 00:29:57.239 Ryan Luke Daque: oh, cool. Yeah. Okay? Cause II think I probably did it. So now, if you just like, run, select
281 00:29:58.510 ⇒ 00:30:04.259 Uttam Kumaran: and then to select Star from Dbt. Dbt. Mart ships that like
282 00:30:04.740 ⇒ 00:30:08.790 Uttam Kumaran: I don’t know whatever it’s ship station order items. Yeah.
283 00:30:11.570 ⇒ 00:30:14.999 Uttam Kumaran: it’s just ships. It’s just ship station underscore order items. Yeah.
284 00:30:16.500 ⇒ 00:30:18.260 Ryan Luke Daque: right? Cause it’s already in.
285 00:30:20.940 ⇒ 00:30:26.720 Maybe. So then, so the one thing you can. Now you can do. So. The one thing I’ll show you is you got it back to Snowflake extension.
286 00:30:28.620 ⇒ 00:30:35.020 Uttam Kumaran: You’ll actually be able to see the database structure. So it might be within staging.
287 00:30:35.920 ⇒ 00:30:42.590 Ryan Luke Daque: yeah. Yeah.
288 00:30:43.860 ⇒ 00:30:47.010 Ryan Luke Daque: And I like the whole conference or something just like.
289 00:30:49.440 ⇒ 00:30:56.749 Uttam Kumaran: so if you click on this, you’re gonna see that the tape, the categories. You’re gonna see all the columns. But yeah, run it here.
290 00:31:24.430 ⇒ 00:31:26.480 Ryan Luke Daque: Davis would do something like
291 00:31:26.670 ⇒ 00:31:27.500 Uttam Kumaran: Yup.
292 00:31:34.090 ⇒ 00:31:36.650 Uttam Kumaran: and it’s amount. Yeah, some amount paid.
293 00:31:56.230 ⇒ 00:31:59.519 Uttam Kumaran: So just make sure you have it ordered by one
294 00:32:08.360 ⇒ 00:32:09.770 Uttam Kumaran: great
295 00:32:10.770 ⇒ 00:32:11.550 Ryan Luke Daque: with.
296 00:32:12.570 ⇒ 00:32:16.759 Ryan Luke Daque: So that way off, it’s probably not working.
297 00:32:19.130 ⇒ 00:32:24.200 Ryan Luke Daque: Yeah, I’ll I’ll probably do unless you wanna
298 00:32:25.600 ⇒ 00:32:29.989 Uttam Kumaran: I don’t mind. I don’t trying to get into it. Yeah, II have time.
299 00:32:30.030 ⇒ 00:32:33.960 Uttam Kumaran: I just wanna see what it is, because it’s the last thing.
300 00:32:34.710 ⇒ 00:32:35.400 Ryan Luke Daque: Yeah.
301 00:32:36.420 ⇒ 00:32:38.150 Ryan Luke Daque: So see?
302 00:32:39.330 ⇒ 00:32:40.000 Ryan Luke Daque: See?
303 00:32:52.860 ⇒ 00:32:55.100 Uttam Kumaran: Oh, it’s order. Item, shipping amount.
304 00:33:00.170 ⇒ 00:33:02.620 Ryan Luke Daque: I don’t see that this one.
305 00:33:03.040 ⇒ 00:33:04.190 Uttam Kumaran: yeah.
306 00:33:06.040 ⇒ 00:33:07.769 Uttam Kumaran: clean up this table.
307 00:33:15.940 ⇒ 00:33:17.669 Ryan Luke Daque: 9.5.
308 00:33:17.920 ⇒ 00:33:20.520 Uttam Kumaran: That’s for today, or wait. Oh.
309 00:33:20.710 ⇒ 00:33:21.609 Ryan Luke Daque: which is
310 00:33:23.560 ⇒ 00:33:27.080 Uttam Kumaran: oh, no, no, that’s definitely yeah. That’s way lower than
311 00:33:29.280 ⇒ 00:33:31.920 Uttam Kumaran: yeah. So what is the difference?
312 00:33:33.890 ⇒ 00:33:36.130 Wait, go back to Vs code.
313 00:33:43.370 ⇒ 00:33:45.160 Uttam Kumaran: What?
314 00:33:53.830 ⇒ 00:33:54.640 Right?
315 00:33:57.670 ⇒ 00:34:02.160 Maybe it’s not the item create date. Maybe it’s something else.
316 00:34:03.730 ⇒ 00:34:05.179 Ryan Luke Daque: Maybe it’s ship date
317 00:34:06.940 ⇒ 00:34:09.569 Ryan Luke Daque: shaping my name and date.
318 00:34:10.270 ⇒ 00:34:11.590 Ryan Luke Daque: Let’s try both.
319 00:34:12.739 ⇒ 00:34:16.260 Ryan Luke Daque: she’s there. since already, you know.
320 00:34:22.480 ⇒ 00:34:26.399 Ryan Luke Daque: 7, 9, 3, which is like, I think, that’s yeah.
321 00:34:27.130 ⇒ 00:34:29.249 Uttam Kumaran: Oh, yeah, it’s correct.
322 00:34:29.330 ⇒ 00:34:31.430 Ryan Luke Daque: Let’s try the other day.
323 00:34:31.540 ⇒ 00:34:33.219 Uttam Kumaran: So what do we? So
324 00:34:33.380 ⇒ 00:34:37.970 Ryan Luke Daque: this is by ship date. Oh, so it’s never. It’s not gonna be right.
325 00:34:38.770 ⇒ 00:34:41.150 Ryan Luke Daque: Oh, wait on the ninth.
326 00:34:42.400 ⇒ 00:34:46.610 Ryan Luke Daque: It’s 1, 3, 6, one. But here it’s like 1, 7, 6, 9,
327 00:34:47.679 ⇒ 00:34:56.349 Ryan Luke Daque: it’s not the same still. But also look at the sixth. sixth. Oh, wait. Okay, 6 is 2,082. Yeah. So try the sixth.
328 00:34:58.800 ⇒ 00:35:00.900 Ryan Luke Daque: There’s there’s No. 16.
329 00:35:01.150 ⇒ 00:35:04.690 Uttam Kumaran: Oh, no, no. 2024, 1, 6,
330 00:35:05.130 ⇒ 00:35:09.100 Ryan Luke Daque: yeah, 2024. So 6 and 7, probably a
331 00:35:09.290 ⇒ 00:35:17.959 Ryan Luke Daque: weekend. So maybe there’s no shipping. No, no, that’s yeah, no, that’s correct. But like, let’s check January sixth in the Ui. Oh, sorry
332 00:35:25.290 ⇒ 00:35:26.210 Ryan Luke Daque: 0.
333 00:35:26.960 ⇒ 00:35:32.289 Uttam Kumaran: Oh, but there is so. But there is data on. So it’s I don’t think it’s shipped day. I think it’s payment date
334 00:35:33.440 ⇒ 00:35:34.180 Ryan Luke Daque: a
335 00:35:35.570 ⇒ 00:35:36.730 Ryan Luke Daque: Amen.
336 00:35:39.910 ⇒ 00:35:43.540 Uttam Kumaran: There’s like a order item.
337 00:35:44.970 ⇒ 00:35:47.170 Uttam Kumaran: something else.
338 00:35:48.080 ⇒ 00:35:48.900 Yeah.
339 00:35:52.870 ⇒ 00:35:55.510 Uttam Kumaran: it’s order item, payment date, I think.
340 00:35:59.450 ⇒ 00:36:00.580 Uttam Kumaran: Underscore.
341 00:36:04.700 ⇒ 00:36:06.499 Uttam Kumaran: between, order. Item, yeah.
342 00:36:10.550 ⇒ 00:36:12.320 Uttam Kumaran: I don’t know.
343 00:36:12.400 ⇒ 00:36:14.059 Ryan Luke Daque: I think it’s just payment.
344 00:36:14.790 ⇒ 00:36:16.429 Uttam Kumaran: Oh, okay.
345 00:36:19.890 ⇒ 00:36:21.839 Ryan Luke Daque: why am I putting? Sorry?
346 00:36:24.970 ⇒ 00:36:27.040 Uttam Kumaran: Oh, yeah, yeah, yeah, yeah.
347 00:36:36.650 ⇒ 00:36:42.650 Ryan Luke Daque: This date. It’s not for today. And it’s 786 for yesterday.
348 00:36:43.660 ⇒ 00:36:47.249 Uttam Kumaran: 7, 86, and 1, 6, 5, 8. Okay, let’s go look again.
349 00:36:47.660 ⇒ 00:36:52.180 Ryan Luke Daque: Oh, well, it’s not for the tenth fuck.
350 00:36:52.360 ⇒ 00:36:53.590 Ryan Luke Daque: Nice. Yeah.
351 00:36:55.880 ⇒ 00:37:02.310 Ryan Luke Daque: Any other dates you have to know. So wait, let’s even think about it. So by date.
352 00:37:03.800 ⇒ 00:37:07.510 Ryan Luke Daque: like the ship. Date to me makes the most sense
353 00:37:11.510 ⇒ 00:37:12.819 Ryan Luke Daque: is it’s this.
354 00:37:17.780 ⇒ 00:37:27.170 Ryan Luke Daque: what is ship station looking at is if we go to shipments in the Ui. It’s by ship date. Thank you.
355 00:37:32.690 ⇒ 00:37:34.380 Ryan Luke Daque: so it is most likely.
356 00:37:35.740 ⇒ 00:37:38.440 Ryan Luke Daque: Okay.
357 00:37:39.460 ⇒ 00:37:40.680 Ryan Luke Daque: package.
358 00:37:44.190 ⇒ 00:37:45.920 Uttam Kumaran: And you check 5 tram.
359 00:37:48.170 ⇒ 00:37:49.330 Ryan Luke Daque: I haven’t yet.
360 00:37:49.840 ⇒ 00:37:51.730 Uttam Kumaran: Oh, yeah, let’s check that
361 00:37:52.670 ⇒ 00:37:57.109 Uttam Kumaran: login and see log in and just see whether it’s been synced yet.
362 00:37:57.850 ⇒ 00:37:58.560 Ryan Luke Daque: Hmm!
363 00:37:58.700 ⇒ 00:38:00.269 Uttam Kumaran: When the last time was.
364 00:38:01.380 ⇒ 00:38:07.540 Uttam Kumaran: And what we may need to do is, let’s so let’s sync it. And then or let’s see, we’re in the last RAM
365 00:38:12.650 ⇒ 00:38:17.749 Ryan Luke Daque: should be able to see it here as well like when was last.
366 00:38:18.070 ⇒ 00:38:19.220 Uttam Kumaran: Yeah.
367 00:38:21.540 ⇒ 00:38:24.590 Uttam Kumaran: it looks like it’s it looks like it loaded. You should be able to.
368 00:38:25.790 ⇒ 00:38:26.580 Uttam Kumaran: Yeah.
369 00:38:40.070 ⇒ 00:38:42.670 Uttam Kumaran: So ship station 3 h ago.
370 00:38:42.920 ⇒ 00:38:43.780 Ryan Luke Daque: Yeah.
371 00:38:44.440 ⇒ 00:38:46.190 Uttam Kumaran: okay, what the hell
372 00:38:51.790 ⇒ 00:38:53.010 Ryan Luke Daque: we should go back
373 00:38:53.180 ⇒ 00:38:57.040 Ryan Luke Daque: like 3 h is pretty recent, so I think it should be good.
374 00:38:58.470 ⇒ 00:39:03.829 Ryan Luke Daque: If you go back to like by shift date, that today’s date is correct. Right?
375 00:39:04.260 ⇒ 00:39:06.860 Uttam Kumaran: What about the ninth? Does it work?
376 00:39:07.220 ⇒ 00:39:09.460 Ryan Luke Daque: 9 case of the one that’s not correct.
377 00:39:10.940 ⇒ 00:39:12.759 So what is going on there?
378 00:39:13.130 ⇒ 00:39:15.839 Ryan Luke Daque: Ninth, we have.
379 00:39:19.890 ⇒ 00:39:25.320 Ryan Luke Daque: We have once 1, 3, 6, one versus 1, 7. So maybe there’s
380 00:39:26.910 ⇒ 00:39:29.500 okay. Well, look at, look at the eighth
381 00:39:38.770 ⇒ 00:39:40.420 Ryan Luke Daque: 3,007
382 00:39:40.920 ⇒ 00:39:42.879 Ryan Luke Daque: versus 2,000
383 00:39:42.890 ⇒ 00:39:47.190 Uttam Kumaran: 820, but there’s No. 8 on our side.
384 00:39:47.440 ⇒ 00:39:49.309 Ryan Luke Daque: We have a this one.
385 00:39:50.110 ⇒ 00:39:55.829 Uttam Kumaran: That’s the sixth, right? Is that the eighth? You see what I mean?
386 00:39:56.280 ⇒ 00:39:59.599 Ryan Luke Daque: It’s oh, okay, okay, great.
387 00:39:59.780 ⇒ 00:40:11.019 Uttam Kumaran: So can you look at the seventh? Sorry. Can you look at the seventh? There’s no seventh, because it’s a Sunday? I look. Look in ship station. I wonder if it’s a time if it’s like a timestamp conversion issue?
388 00:40:14.840 ⇒ 00:40:16.209 Ryan Luke Daque: Yeah, there’s nothing.
389 00:40:17.260 ⇒ 00:40:18.430 Uttam Kumaran: Okay.
390 00:40:19.900 ⇒ 00:40:24.580 Ryan Luke Daque: are you like, were you converting anything here? No, I’m not
391 00:40:24.590 ⇒ 00:40:31.969 Ryan Luke Daque: so. So then I wonder if we should? Okay, so one thing is, can you go back to Ship station?
392 00:40:32.250 ⇒ 00:40:35.580 Uttam Kumaran: Where can we go to get every single order for a day.
393 00:40:36.170 ⇒ 00:40:37.299 Ryan Luke Daque: I guess, here
394 00:40:37.430 ⇒ 00:40:40.060 Uttam Kumaran: or or every shipment for a day.
395 00:40:40.980 ⇒ 00:40:43.240 Ryan Luke Daque: Here, let’s let’s just
396 00:40:44.400 ⇒ 00:40:47.499 Ryan Luke Daque: to the eighth, maybe, or ninth.
397 00:40:47.880 ⇒ 00:40:51.120 Uttam Kumaran: Yeah, let’s yeah, let’s do the most recent day where we’re wrong.
398 00:40:54.720 ⇒ 00:40:58.580 Uttam Kumaran: And then, we want to get the shipping amount.
399 00:41:03.050 ⇒ 00:41:04.040 I guess we can.
400 00:41:09.190 ⇒ 00:41:09.960 And
401 00:41:12.240 ⇒ 00:41:14.740 Uttam Kumaran: follows.
402 00:41:16.310 ⇒ 00:41:17.050 yeah
403 00:41:19.520 ⇒ 00:41:21.020 Ryan Luke Daque: thing. Count
404 00:41:23.850 ⇒ 00:41:24.970 Ryan Luke Daque: a
405 00:41:25.550 ⇒ 00:41:27.359 Uttam Kumaran: yeah ad shipping. Paid
406 00:41:32.550 ⇒ 00:41:33.890 Ryan Luke Daque: a date.
407 00:41:37.770 ⇒ 00:41:41.940 Uttam Kumaran: Okay, just hit, save at least we have all the shipment numbers.
408 00:41:42.820 ⇒ 00:41:43.590 Ryan Luke Daque: Hmm.
409 00:41:45.630 ⇒ 00:41:47.150 Uttam Kumaran: so let’s
410 00:41:48.970 ⇒ 00:41:51.139 Uttam Kumaran: yeah. See if you could just get all these.
411 00:41:59.500 ⇒ 00:42:01.450 Uttam Kumaran: I guess line items.
412 00:42:08.240 ⇒ 00:42:12.179 Ryan Luke Daque: maybe. But shipping charges
413 00:42:14.570 ⇒ 00:42:16.340 Uttam Kumaran: just hit export, maybe
414 00:42:17.790 ⇒ 00:42:18.820 Uttam Kumaran: not working.
415 00:42:24.080 ⇒ 00:42:27.169 Uttam Kumaran: And pretty much I wanna I wanna look at
416 00:42:27.280 ⇒ 00:42:31.940 Uttam Kumaran: So I’ll show you kind of how I’ve done this in the past
417 00:42:33.300 ⇒ 00:42:37.369 Uttam Kumaran: to open up. Excel. take all of those order ids.
418 00:42:38.730 ⇒ 00:42:43.789 Uttam Kumaran: So take. Yeah. So take so, so highlight, all these copy it. Bring it to vs.
419 00:42:48.280 ⇒ 00:42:53.590 Uttam Kumaran: just hit. Enter a couple times, and then you can. You need to add, add, make this a list
420 00:42:56.360 ⇒ 00:42:58.650 Uttam Kumaran: so highlight the whole thing.
421 00:42:59.250 ⇒ 00:43:07.730 Uttam Kumaran: and then you know how to do the cursor like it’s like command. It’s like, usually command D, or something like that, or you can have multi cursor.
422 00:43:09.500 ⇒ 00:43:16.839 Uttam Kumaran: Or one thing we could do is you could maybe ask co-pilot, say, add a comment, everything so hit command. I,
423 00:43:19.940 ⇒ 00:43:24.810 Uttam Kumaran: yeah. And now hit, add, add, add a comma at the end of each item.
424 00:43:33.290 ⇒ 00:43:44.499 Uttam Kumaran: okay, it’s it’s doing it slowly. Well, Gary hit this card.
425 00:43:45.610 ⇒ 00:43:48.950 Uttam Kumaran: There’s a thing you could do, multi-perser.
426 00:43:53.630 ⇒ 00:43:56.710 Uttam Kumaran: It’s alt click, or
427 00:43:58.400 ⇒ 00:44:02.420 Uttam Kumaran: or alt control down, or I don’t know.
428 00:44:03.950 ⇒ 00:44:06.259 Ryan Luke Daque: There you go, I think for us?
429 00:44:08.480 ⇒ 00:44:12.770 Ryan Luke Daque: yep.
430 00:44:12.880 ⇒ 00:44:16.229 Ryan Luke Daque: I can do without control, I guess.
431 00:44:17.630 ⇒ 00:44:21.960 Uttam Kumaran: Here highlight and add comment.
432 00:44:26.560 ⇒ 00:44:27.840 Ryan Luke Daque: yeah, just
433 00:44:29.350 ⇒ 00:44:30.630 Ryan Luke Daque: and edit everything.
434 00:44:35.090 ⇒ 00:44:38.060 Ryan Luke Daque: I guess this is gonna be the where statement? Right?
435 00:44:43.750 ⇒ 00:44:51.039 Uttam Kumaran: Yes, actually shift all I yeah, I don’t know if you had it. But yeah.
436 00:44:52.330 ⇒ 00:44:53.800 Uttam Kumaran: if you highlight it.
437 00:44:55.710 ⇒ 00:44:57.720 Uttam Kumaran: and then you hit shift. Alt, I
438 00:44:59.750 ⇒ 00:45:00.780 Uttam Kumaran: didn’t work.
439 00:45:03.750 ⇒ 00:45:12.579 Uttam Kumaran: Okay, whatever whatever. Yeah, this. But this is the yeah. So let’s just do. We’re not in this list.
440 00:45:13.970 ⇒ 00:45:18.279 Uttam Kumaran: Oh, you may have. You may have to. You may have to make sure all these are strings
441 00:45:19.360 ⇒ 00:45:20.789 Ryan Luke Daque: or these things.
442 00:45:21.100 ⇒ 00:45:21.970 Uttam Kumaran: Yeah.
443 00:45:23.090 ⇒ 00:45:30.930 Uttam Kumaran: so this is what I’m saying, like, like highlight. This whole highlight like, move the move, the snowflake thing out the way
444 00:45:31.970 ⇒ 00:45:34.079 Uttam Kumaran: on the on the on the bottom.
445 00:45:36.420 ⇒ 00:45:43.510 Uttam Kumaran: and then highlight the entire. Just the list of ids. Yeah, okay. And then, now, did you try hitting like the command.
446 00:45:44.280 ⇒ 00:45:45.480 Ryan Luke Daque: there’s
447 00:45:45.750 ⇒ 00:45:47.540 Uttam Kumaran: it’s like command. It’s like.
448 00:45:47.890 ⇒ 00:45:55.890 Uttam Kumaran: shift all I or shift all. L, yeah, exactly. So just do the single quote, yeah, exactly
449 00:45:56.660 ⇒ 00:45:57.830 Uttam Kumaran: exactly
450 00:45:58.090 ⇒ 00:45:58.850 nice.
451 00:46:00.530 ⇒ 00:46:04.689 Ryan Luke Daque: Let me so easy
452 00:46:09.220 ⇒ 00:46:15.920 Ryan Luke Daque: staging. What’s the name? This field
453 00:46:17.960 ⇒ 00:46:18.770 Ryan Luke Daque: shoot
454 00:46:18.920 ⇒ 00:46:21.309 Ryan Luke Daque: mid id ship id.
455 00:46:26.430 ⇒ 00:46:28.659 Ryan Luke Daque: isn’t. There’s order. Id.
456 00:46:28.890 ⇒ 00:46:31.210 Uttam Kumaran: I think it’s gonna be the order. Item. Id.
457 00:46:33.240 ⇒ 00:46:34.910 Ryan Luke Daque: It’s numbered also.
458 00:46:35.890 ⇒ 00:46:43.709 Uttam Kumaran: Oh, you may have to just convert it to string. Well, just run. So. Oh, here, go onto the top right of this dialog
459 00:46:43.820 ⇒ 00:46:44.910 Uttam Kumaran: on the bottom
460 00:46:45.420 ⇒ 00:46:52.330 Uttam Kumaran: of this of the snowflake thing on the right, on the on the bottom of your screen. Yeah, hit hit the left one.
461 00:46:52.990 ⇒ 00:46:53.780 Uttam Kumaran: Yeah.
462 00:46:57.010 ⇒ 00:47:00.419 Uttam Kumaran: So now you can see which one it is. So it looks like it is
463 00:47:01.100 ⇒ 00:47:03.490 Uttam Kumaran: probably order. Id.
464 00:47:04.500 ⇒ 00:47:05.850 Uttam Kumaran: Yeah, I’ll start with one.
465 00:47:06.640 ⇒ 00:47:08.479 Ryan Luke Daque: You can try order idly.
466 00:47:09.580 ⇒ 00:47:12.930 Uttam Kumaran: Yeah. So just do like where order id not in.
467 00:47:16.270 ⇒ 00:47:19.870 Uttam Kumaran: And then you have to make sure. You also have the date.
468 00:47:32.080 ⇒ 00:47:34.580 So you you probably have to do date trunk.
469 00:47:41.240 ⇒ 00:47:43.069 Uttam Kumaran: Yeah, yeah, or that. Yeah.
470 00:47:45.570 ⇒ 00:47:48.850 Uttam Kumaran: And then just do, yeah, just select all for now
471 00:47:53.380 ⇒ 00:47:54.889 Uttam Kumaran: see what happens.
472 00:47:58.960 ⇒ 00:47:59.830 Ryan Luke Daque: Nothing
473 00:48:02.120 ⇒ 00:48:04.480 Ryan Luke Daque: can you hit in?
474 00:48:06.740 ⇒ 00:48:09.370 Uttam Kumaran: Just do instead of not in. Just do in
475 00:48:11.700 ⇒ 00:48:14.289 Uttam Kumaran: instead of not in. Just do. Yeah.
476 00:48:14.730 ⇒ 00:48:16.420 Uttam Kumaran: That way, we can just see.
477 00:48:17.350 ⇒ 00:48:19.969 Uttam Kumaran: yeah, okay, so it is always.
478 00:48:20.040 ⇒ 00:48:24.860 Ryan Luke Daque: it is everything. It looks like this. So like what?
479 00:48:25.940 ⇒ 00:48:27.460 Uttam Kumaran: What’s the issue?
480 00:48:34.870 ⇒ 00:48:39.900 Ryan Luke Daque: It would be great if we can export the ship amount as well. Here.
481 00:48:41.490 ⇒ 00:48:46.080 Ryan Luke Daque: let’s try the other one like shipping choices.
482 00:48:57.610 ⇒ 00:49:07.020 Ryan Luke Daque: This carrier fee. Would this be the shipping charge? 1, 7, 6 9 against
483 00:49:09.000 ⇒ 00:49:10.140 Uttam Kumaran: yeah
484 00:49:11.110 ⇒ 00:49:11.790 point
485 00:49:16.250 ⇒ 00:49:17.150 Ryan Luke Daque: since.
486 00:49:32.870 ⇒ 00:49:36.880 Ryan Luke Daque: So we got so here it says, 1, 3, 6, one.
487 00:49:37.290 ⇒ 00:49:42.390 Ryan Luke Daque: But in the excel file if we sum up the carrier fee. It’s
488 00:49:43.260 ⇒ 00:49:45.299 Ryan Luke Daque: it’s 1, 7, 6, 9.
489 00:49:45.770 ⇒ 00:49:47.210 Uttam Kumaran: Which matches us.
490 00:49:47.910 ⇒ 00:49:49.300 Think. So. Yeah.
491 00:49:49.340 ⇒ 00:49:52.490 Uttam Kumaran: okay, great. Oh, it looks like it’s just a delay. Then.
492 00:49:54.050 ⇒ 00:50:00.139 Ryan Luke Daque: yeah.
493 00:50:15.850 ⇒ 00:50:18.199 Uttam Kumaran: you’re gonna have to. Oh, yeah, yeah, okay.
494 00:50:21.340 ⇒ 00:50:22.719 Uttam Kumaran: to add the order.
495 00:50:31.400 ⇒ 00:50:33.179 Ryan Luke Daque: yeah. So I think
496 00:50:33.450 ⇒ 00:50:40.450 Ryan Luke Daque: so, it’s 1, 7, 6, 9. Yeah. So if you go back to the ui go. So you see on the box here on the
497 00:50:40.550 ⇒ 00:50:44.590 Uttam Kumaran: like, it looks like. yeah, what? The fuck.
498 00:50:44.980 ⇒ 00:50:48.949 Ryan Luke Daque: So maybe this isn’t carrier amount or something. This is
499 00:50:50.310 ⇒ 00:50:52.390 Ryan Luke Daque: something else, or maybe it’s
500 00:50:53.530 ⇒ 00:50:55.470 Uttam Kumaran: maybe it’s net of something.
501 00:50:56.360 ⇒ 00:50:58.420 Ryan Luke Daque: Well. see?
502 00:51:00.250 ⇒ 00:51:01.170 Ryan Luke Daque: Probably like
503 00:51:02.930 ⇒ 00:51:06.049 Ryan Luke Daque: carrier amount, or whatever it’s called.
504 00:51:06.780 ⇒ 00:51:08.190 Uttam Kumaran: minus something
505 00:51:10.480 ⇒ 00:51:13.060 Uttam Kumaran: station.
506 00:51:14.950 ⇒ 00:51:16.290 Uttam Kumaran: But maybe
507 00:51:23.930 ⇒ 00:51:25.170 shipments.
508 00:51:38.650 ⇒ 00:51:40.679 Uttam Kumaran: I just don’t know like, what
509 00:51:41.560 ⇒ 00:51:44.350 Ryan Luke Daque: if there’s or something ability?
510 00:51:45.670 ⇒ 00:51:46.740 Uttam Kumaran: Yeah.
511 00:52:17.380 ⇒ 00:52:21.339 Uttam Kumaran: like, I just don’t know why I can’t find the sum here.
512 00:52:24.160 ⇒ 00:52:25.830 Ryan Luke Daque: Maybe it’s
513 00:53:16.080 ⇒ 00:53:18.590 Uttam Kumaran: 13610, I got it. Okay.
514 00:53:19.560 ⇒ 00:53:20.869 Ryan Luke Daque: would you do
515 00:53:22.710 ⇒ 00:53:24.010 Uttam Kumaran: weird?
516 00:53:27.190 ⇒ 00:53:31.899 Ryan Luke Daque: So what? So if you go back to your snowflake? So what do we see?
517 00:53:32.110 ⇒ 00:53:45.049 Uttam Kumaran: We see 1, 7, 6, 9, 6, 4, where we’re summing. Can you? Can you add some more columns to the sum like, can you add a bunch of the other ones.
518 00:53:50.120 ⇒ 00:53:52.199 Like the
519 00:53:53.130 ⇒ 00:53:56.469 Uttam Kumaran: yeah. I don’t know what what other shipping related ones are there
520 00:53:56.990 ⇒ 00:54:00.809 Uttam Kumaran: actually here? Can you actually just look at
521 00:54:01.530 ⇒ 00:54:03.530 Uttam Kumaran: take a look at this.
522 00:54:05.720 ⇒ 00:54:08.670 Uttam Kumaran: Yeah, take a look at this order.
523 00:54:13.810 ⇒ 00:54:18.069 Uttam Kumaran: I sent it in zoom, chat. Let’s just look at this one order.
524 00:54:18.290 ⇒ 00:54:19.030 Ryan Luke Daque: Okay.
525 00:54:20.910 ⇒ 00:54:23.310 Uttam Kumaran: just want to select for this order.
526 00:54:25.530 ⇒ 00:54:29.000 Uttam Kumaran: You can leave this one. You could leave the Ct. You could just start another one
527 00:54:30.230 ⇒ 00:54:31.719 Uttam Kumaran: that way. We have this.
528 00:54:40.570 ⇒ 00:54:44.119 Uttam Kumaran: So this one, the shipping cost should be 2259.
529 00:54:52.620 ⇒ 00:54:54.920 You have to do order id strength.
530 00:54:57.690 ⇒ 00:54:58.910 Uttam Kumaran: I guess I don’t know.
531 00:55:00.850 ⇒ 00:55:01.730 Uttam Kumaran: Maybe
532 00:55:06.900 ⇒ 00:55:09.180 Ryan Luke Daque: if it’s not an order name.
533 00:55:16.140 ⇒ 00:55:17.999 Ryan Luke Daque: I think I know, perhaps
534 00:55:43.410 ⇒ 00:55:44.590 Ryan Luke Daque: ordering a number
535 00:55:47.040 ⇒ 00:55:48.130 Uttam Kumaran: which one
536 00:55:49.590 ⇒ 00:55:51.380 Uttam Kumaran: no order number. Yeah.
537 00:55:57.610 ⇒ 00:55:59.530 Ryan Luke Daque: this has 2 lines.
538 00:56:01.490 ⇒ 00:56:03.599 Uttam Kumaran: 2259. It’s there
539 00:56:05.250 ⇒ 00:56:08.360 Ryan Luke Daque: which this one
540 00:56:09.190 ⇒ 00:56:13.450 Ryan Luke Daque: I’m gonna send you this thing on slack.
541 00:56:14.270 ⇒ 00:56:16.799 Uttam Kumaran: and let’s do the same exercise
542 00:56:17.790 ⇒ 00:56:19.260 Uttam Kumaran: where we
543 00:56:19.680 ⇒ 00:56:25.390 Uttam Kumaran: we try to compare it to this. This one sums up to the what’s in the Ui.
544 00:56:28.960 ⇒ 00:56:34.470 Uttam Kumaran: So I don’t know what we’re doing.
545 00:56:37.920 ⇒ 00:56:47.490 Uttam Kumaran: okay.
546 00:56:49.640 ⇒ 00:56:54.239 Uttam Kumaran: this is all the orders. This is all the shipping shipments for the ninth.
547 00:56:59.410 ⇒ 00:57:03.110 Uttam Kumaran: I think it’s actually I don’t know.
548 00:57:08.370 ⇒ 00:57:11.740 Ryan Luke Daque: This is 1, 3, 6, one Aji.
549 00:57:12.110 ⇒ 00:57:14.829 Uttam Kumaran: Get this. So let’s
550 00:57:14.870 ⇒ 00:57:18.460 Uttam Kumaran: Let’s do where order number is in C,
551 00:57:20.450 ⇒ 00:57:27.140 Uttam Kumaran: so bring everything from Cn. and just do select star where order number is in this.
552 00:57:32.720 ⇒ 00:57:34.780 Uttam Kumaran: Yep. And then same thing.
553 00:57:42.310 ⇒ 00:57:47.420 Uttam Kumaran: Actually, here, it’s not. It’s not gonna so. So here, control Z, I’ll show you how to do it.
554 00:57:48.960 ⇒ 00:57:59.700 Uttam Kumaran: So get get out of this whole thing. I’ll show you that’s gonna happen again for you couple more times. So put the quotes and the comma. So don’t worry about the space. Don’t worry about the space.
555 00:57:59.870 ⇒ 00:58:02.309 Uttam Kumaran: I’ll show you the way around it, so
556 00:58:02.640 ⇒ 00:58:05.249 Uttam Kumaran: select everything, do the same thing
557 00:58:11.210 ⇒ 00:58:14.899 Uttam Kumaran: and then hit. Do do the quote comma.
558 00:58:16.960 ⇒ 00:58:18.489 Uttam Kumaran: and then hit.
559 00:58:19.570 ⇒ 00:58:23.559 Uttam Kumaran: It’s either the control or alt on your side and hit the left arrow.
560 00:58:24.220 ⇒ 00:58:25.360 Ryan Luke Daque: Gotcha.
561 00:58:25.500 ⇒ 00:58:27.519 Uttam Kumaran: Oh, wait! It didn’t work, either.
562 00:58:31.220 ⇒ 00:58:35.260 Ryan Luke Daque: Yeah. What what did you do there? I didn’t control less.
563 00:58:35.430 ⇒ 00:58:39.119 Uttam Kumaran: Yeah. What was the other one?
564 00:58:39.300 ⇒ 00:58:46.379 Uttam Kumaran: That one. That’s what the one you need to do. It’ll highlight the whole thing, and then you can get it. You can get to the left of it. But
565 00:58:46.780 ⇒ 00:58:47.670 Uttam Kumaran: yeah.
566 00:58:48.850 ⇒ 00:58:50.119 Uttam Kumaran: do I need to start again
567 00:58:51.220 ⇒ 00:58:52.190 now?
568 00:58:55.710 ⇒ 00:58:58.530 Uttam Kumaran: You may need to start again
569 00:59:03.890 ⇒ 00:59:04.770 Ryan Luke Daque: so
570 00:59:07.280 ⇒ 00:59:09.219 Ryan Luke Daque: and then control shift
571 00:59:10.120 ⇒ 00:59:18.610 Uttam Kumaran: all the way. Oh, well, hit hit hit just control is there? You have Alt. Maybe it’s alt left. I don’t know.
572 00:59:19.970 ⇒ 00:59:21.179 Ryan Luke Daque: Oh, it’s okay.
573 00:59:21.480 ⇒ 00:59:26.309 Ryan Luke Daque: Okay. There’s a button you can get all the way to the left.
574 00:59:26.720 ⇒ 00:59:27.410 Ryan Luke Daque: Yeah.
575 00:59:27.570 ⇒ 00:59:32.260 Ryan Luke Daque: like, I think it stops with it with the dashes, for some reason.
576 00:59:36.000 ⇒ 00:59:38.160 Ryan Luke Daque: That’s right. That’s that’s a pattern.
577 00:59:44.410 ⇒ 00:59:45.170 Uttam Kumaran: would.
578 01:00:13.520 ⇒ 01:00:15.089 Ryan Luke Daque: So yeah, there you go?
579 01:00:16.040 ⇒ 01:00:19.690 Uttam Kumaran: Yeah, I just use copilot to do it.
580 01:00:20.430 ⇒ 01:00:24.070 Ryan Luke Daque: Okay.
581 01:00:29.470 ⇒ 01:00:35.170 Ryan Luke Daque: okay, so here it is. So I guess we can some shipment amount.
582 01:00:52.200 ⇒ 01:00:54.679 Ryan Luke Daque: Oh, this is still. 1, 7, 6, 9.
583 01:00:56.000 ⇒ 01:00:58.090 Uttam Kumaran: Wait, are you sure?
584 01:00:58.500 ⇒ 01:00:59.450 Ryan Luke Daque: Yeah.
585 01:01:00.740 ⇒ 01:01:04.669 Ryan Luke Daque: then. Well, then, what is it? So then let’s bring in.
586 01:01:05.420 ⇒ 01:01:07.640 Ryan Luke Daque: Don’t look at each item.
587 01:01:18.820 ⇒ 01:01:23.140 Uttam Kumaran: So let’s like, I just wanna see what where the differences.
588 01:01:24.090 ⇒ 01:01:24.880 but
589 01:01:25.060 ⇒ 01:01:27.040 Ryan Luke Daque: no way we can export.
590 01:01:44.150 ⇒ 01:01:48.060 Uttam Kumaran: I would just select a few columns because it’s gonna be kind of mess.
591 01:02:18.130 ⇒ 01:02:20.120 Ryan Luke Daque: Let’s just do order number.
592 01:02:21.410 ⇒ 01:02:22.320 Ryan Luke Daque: and
593 01:02:45.180 ⇒ 01:02:46.440 Ryan Luke Daque: I guess.
594 01:04:05.280 ⇒ 01:04:07.409 Ryan Luke Daque: interesting. You got nose.
595 01:04:09.510 ⇒ 01:04:10.850 Uttam Kumaran: Huh?
596 01:04:13.050 ⇒ 01:04:13.990 Ryan Luke Daque: So
597 01:04:21.260 ⇒ 01:04:23.940 Uttam Kumaran: oh, yeah, look, there’s a couple that are false.
598 01:04:24.990 ⇒ 01:04:25.979 very nice
599 01:04:26.240 ⇒ 01:04:27.770 Ryan Luke Daque: is in in
600 01:04:27.960 ⇒ 01:04:30.889 Ryan Luke Daque: like envious code, it’s 0.
601 01:04:31.280 ⇒ 01:04:36.140 Ryan Luke Daque: But then, in in the file that you sent me, it’s 13.0 6.
602 01:04:41.440 ⇒ 01:04:42.190 Ryan Luke Daque: Why don’t?
603 01:04:43.360 ⇒ 01:04:48.260 Uttam Kumaran: No, no, no, it’s no in Vs code. but but
604 01:04:48.510 ⇒ 01:04:54.250 Ryan Luke Daque: shop. But ship station is higher, the ui is higher, right
605 01:04:54.450 ⇒ 01:05:01.220 Ryan Luke Daque: is there? Ui, lower is the ui higher. Wait last day I want once. This one is 700.
606 01:05:02.100 ⇒ 01:05:04.419 Uttam Kumaran: Yeah, see? What’s I don’t know what’s happening
607 01:05:37.590 ⇒ 01:05:38.999 cause there’s
608 01:05:41.740 ⇒ 01:05:42.830 Ryan Luke Daque: but
609 01:05:44.610 ⇒ 01:05:47.740 Ryan Luke Daque: there’s like, multiple of this order, number
610 01:05:48.310 ⇒ 01:05:52.210 Ryan Luke Daque: one has nothing and one has 13.
611 01:05:52.430 ⇒ 01:05:53.709 Uttam Kumaran: Well, that’s okay, I think
612 01:06:01.630 ⇒ 01:06:02.820 should be
613 01:06:07.750 ⇒ 01:06:09.240 Ryan Luke Daque: to do the cylinders.
614 01:06:30.310 ⇒ 01:06:32.230 Uttam Kumaran: So the ui is less
615 01:06:33.980 ⇒ 01:06:37.369 Uttam Kumaran: plus I’m saying so. There’s gotta be sort of difference
616 01:06:48.050 ⇒ 01:06:55.590 Ryan Luke Daque: should be one seventh. If so, the difference. Let’s see this way. There’s just one
617 01:06:56.010 ⇒ 01:07:05.400 Ryan Luke Daque: line that’s very different. 800, I guess. 407. And this is the one with 132 items.
618 01:07:10.650 ⇒ 01:07:12.450 Uttam Kumaran: Oh, okay.
619 01:07:14.530 ⇒ 01:07:17.300 Ryan Luke Daque: it’s this specific that I will do.
620 01:07:18.560 ⇒ 01:07:23.260 Uttam Kumaran: Okay, let’s look that up in. Let’s look that up in shopify. Which one can you send it to me?
621 01:07:23.860 ⇒ 01:07:25.250 Ryan Luke Daque: Yeah, sure.
622 01:07:32.560 ⇒ 01:07:35.199 Ryan Luke Daque: it’s in the zoom.
623 01:07:35.540 ⇒ 01:07:36.250 Okay?
624 01:08:03.810 ⇒ 01:08:07.480 Uttam Kumaran: So yeah, let’s look at yeah.
625 01:08:15.840 ⇒ 01:08:17.340 Ryan Luke Daque: Hmm! Looks like it’s
626 01:08:18.520 ⇒ 01:08:19.830 Ryan Luke Daque: double here.
627 01:08:23.260 ⇒ 01:08:24.130 Ryan Luke Daque: Well.
628 01:08:27.040 ⇒ 01:08:28.159 Uttam Kumaran: what’s going on?
629 01:08:29.970 ⇒ 01:08:35.169 Ryan Luke Daque: So for this order number, there’s like 3 order items and
630 01:08:38.880 ⇒ 01:08:41.689 Ryan Luke Daque: do all of them have the same, or you’re shipping.
631 01:08:42.080 ⇒ 01:08:45.860 Uttam Kumaran: but I don’t, but I don’t. I don’t get it like why is it?
632 01:08:45.910 ⇒ 01:08:55.220 Uttam Kumaran: Oh, you’re saying it should just be 407 once
633 01:08:55.950 ⇒ 01:09:02.470 Ryan Luke Daque: it looks like it is based on this excel file solely once.
634 01:09:02.609 ⇒ 01:09:11.460 Uttam Kumaran: okay, great. So let’s go back. Go back to Vs code. Let’s see, why, how do we? How do we make sure that this, the wrong one, doesn’t get in there?
635 01:09:12.060 ⇒ 01:09:18.330 Ryan Luke Daque: Interestingly, like, the quantity is 132 here. And that’s basically the sum of
636 01:09:18.970 ⇒ 01:09:19.990 Ryan Luke Daque: these 2.
637 01:09:20.700 ⇒ 01:09:23.179 Uttam Kumaran: Okay, but keep going to the right.
638 01:09:30.990 ⇒ 01:09:35.450 Uttam Kumaran: So we, as I’m saying, we need to find a way to disqualify one of them right?
639 01:09:37.010 ⇒ 01:09:38.250 Uttam Kumaran: Or
640 01:09:39.890 ⇒ 01:09:41.319 Uttam Kumaran: oh.
641 01:09:42.630 ⇒ 01:09:46.909 Uttam Kumaran: so let’s look at the logic for ship station order items.
642 01:09:57.660 ⇒ 01:10:04.499 Uttam Kumaran: Where is the where is the amount? The order item, shipping amount is what we need right?
643 01:10:06.500 ⇒ 01:10:09.979 Uttam Kumaran: S dot shipment cost. And how does S join?
644 01:10:17.210 ⇒ 01:10:18.340 Uttam Kumaran: Oh, okay.
645 01:10:22.620 ⇒ 01:10:29.629 Uttam Kumaran: so can we. So Ca, can you take this? Can you run a dbt compile for this.
646 01:10:33.850 ⇒ 01:10:38.999 Uttam Kumaran: And then what we’re gonna do is look at every table for that given order. Id.
647 01:10:39.510 ⇒ 01:10:41.739 Uttam Kumaran: Gonna find out what’s going on here.
648 01:11:13.780 ⇒ 01:11:16.280 Ryan Luke Daque: We’re on doing around. This is no thing.
649 01:11:20.150 ⇒ 01:11:22.339 Uttam Kumaran: You can run in Snowflake. Yeah.
650 01:12:33.800 ⇒ 01:12:38.700 Uttam Kumaran: I would just select Star from everything.
651 01:12:40.670 ⇒ 01:12:41.440 Ryan Luke Daque: Good evening.
652 01:12:41.810 ⇒ 01:12:44.760 Uttam Kumaran: like. remove all the columns.
653 01:12:47.010 ⇒ 01:12:50.230 Uttam Kumaran: and then just just remove all the columns.
654 01:12:51.070 ⇒ 01:12:52.960 Uttam Kumaran: all of them, all of them. Yeah.
655 01:12:59.710 ⇒ 01:13:04.010 Uttam Kumaran: And let’s just make sure you’re doing where it’s that order. Id.
656 01:13:09.190 ⇒ 01:13:10.870 Uttam Kumaran: So just cancel this one.
657 01:13:17.780 ⇒ 01:13:18.620 Uttam Kumaran: Yeah.
658 01:13:30.550 ⇒ 01:13:31.280 Uttam Kumaran: Umhm.
659 01:13:37.210 ⇒ 01:13:48.819 Uttam Kumaran: okay, so we’re looking to disqualify one of them. So let’s just slowly go through every column and just look to see if there’s anything like not valid or status, or something like that.
660 01:14:10.760 ⇒ 01:14:17.890 Uttam Kumaran: it should just be 400 for the total. So this one, I don’t understand is like. maybe my join is wrong.
661 01:14:27.010 ⇒ 01:14:28.370 Ryan Luke Daque: Which one it’s just.
662 01:14:29.210 ⇒ 01:14:30.570 Uttam Kumaran: That’s okay.
663 01:14:30.680 ⇒ 01:14:34.730 Uttam Kumaran: II think it may be my join is wrong.
664 01:14:39.310 ⇒ 01:14:42.510 Ryan Luke Daque: since they have the same shipment. Id.
665 01:14:43.540 ⇒ 01:14:47.919 Ryan Luke Daque: That’s how I’m doing. It is like, that’s where the shipment ideas.
666 01:14:52.090 ⇒ 01:14:53.200 Uttam Kumaran: But
667 01:14:55.010 ⇒ 01:14:56.550 Uttam Kumaran: maybe ship.
668 01:14:59.470 ⇒ 01:15:00.749 Uttam Kumaran: I don’t know.
669 01:15:05.150 ⇒ 01:15:08.879 Uttam Kumaran: So where do we? Let’s see where we get the 400. There it is.
670 01:15:11.890 ⇒ 01:15:16.169 Uttam Kumaran: I see it looks like all these are duplicated. Right?
671 01:15:16.920 ⇒ 01:15:17.620 Ryan Luke Daque: Yeah.
672 01:15:17.850 ⇒ 01:15:22.630 Ryan Luke Daque: Cause this is joined by the shipment. Id decision.
673 01:15:24.510 ⇒ 01:15:27.120 Uttam Kumaran: So what should we do?
674 01:15:30.470 ⇒ 01:15:31.580 Ryan Luke Daque: And
675 01:15:45.590 ⇒ 01:15:46.610 items?
676 01:15:48.170 ⇒ 01:15:52.609 Ryan Luke Daque: I’m almost like we shouldn’t do anything at the item level.
677 01:16:02.880 ⇒ 01:16:03.850 Uttam Kumaran: right?
678 01:16:15.110 ⇒ 01:16:17.540 Uttam Kumaran: Like we should do everything at the order.
679 01:16:19.360 ⇒ 01:16:22.249 Uttam Kumaran: But the thing is like, I,
680 01:16:28.750 ⇒ 01:16:30.670 yeah, it’s kind of weird.
681 01:16:37.780 ⇒ 01:16:38.680 Ryan Luke Daque: All the
682 01:16:40.890 ⇒ 01:16:42.640 Uttam Kumaran: these are all the same.
683 01:16:46.550 ⇒ 01:16:48.660 Uttam Kumaran: So
684 01:16:54.260 ⇒ 01:17:02.019 Uttam Kumaran: but if if you if you’re if there’s if there’s no way we can get the individual item shipping price. Then the whole thing has to be at the order level.
685 01:17:07.010 ⇒ 01:17:07.880 Ryan Luke Daque: Yeah.
686 01:17:14.390 ⇒ 01:17:16.519 Think cost is at the older level
687 01:17:19.200 ⇒ 01:17:20.260 Ryan Luke Daque: shipping
688 01:17:21.190 ⇒ 01:17:27.390 Ryan Luke Daque: level. It’s only one shipment. Item. yeah, based on the ID,
689 01:17:28.810 ⇒ 01:17:30.809 Uttam Kumaran: there’s only one shipment item, right?
690 01:17:36.720 ⇒ 01:17:37.450 Ryan Luke Daque: And
691 01:17:44.240 ⇒ 01:17:49.539 Ryan Luke Daque: yeah, it’s only one shipment. Id. So it’s only one ship left.
692 01:17:50.550 ⇒ 01:17:52.690 It’s only one shipment item.
693 01:17:52.710 ⇒ 01:17:54.950 Uttam Kumaran: but there’s a join between
694 01:17:56.040 ⇒ 01:18:03.920 Uttam Kumaran: the order. Id. Oh, Si! That order. Item id. So look, look@si.order. Item id.
695 01:18:04.080 ⇒ 01:18:07.070 Uttam Kumaran: Can you? Can you find that if you, if you scroll to the left.
696 01:18:08.670 ⇒ 01:18:12.579 Uttam Kumaran: order, item Id to the that’s right to the right to the right.
697 01:18:17.930 ⇒ 01:18:20.090 Uttam Kumaran: If you go past the Id here.
698 01:18:22.280 ⇒ 01:18:25.190 Uttam Kumaran: you see it. Do you see? Do you see that like
699 01:18:28.010 ⇒ 01:18:30.760 Ryan Luke Daque: order? Item, Id.
700 01:18:31.100 ⇒ 01:18:33.949 Ryan Luke Daque: I guess it’s in the to the left.
701 01:18:42.970 ⇒ 01:18:46.109 Uttam Kumaran: No, it’s somewhere. It’s somewhere in the middle.
702 01:19:04.330 ⇒ 01:19:11.720 Uttam Kumaran: Can you just select it upfront? So just do, Star, and then select it right before it.
703 01:19:13.190 ⇒ 01:19:17.950 Ryan Luke Daque: Yeah, just do just do. Si dot order on m id, Si, dot.
704 01:19:29.030 ⇒ 01:19:30.200 Ryan Luke Daque: Why is that?
705 01:19:31.820 ⇒ 01:19:33.040 Ryan Luke Daque: This is
706 01:19:33.150 ⇒ 01:19:36.390 Uttam Kumaran: that’s just a that’s a that’s a payment. Id.
707 01:19:36.770 ⇒ 01:19:43.160 Ryan Luke Daque: So it is a shipment item. But maybe we don’t need a shipment item at all.
708 01:19:44.310 ⇒ 01:19:51.710 Uttam Kumaran: Can you show me what columns are in? So on the left. You have all the columns and shipments, so shipment, is there any order? Id in there or no
709 01:19:52.740 ⇒ 01:19:53.859 Uttam Kumaran: at the top?
710 01:19:57.380 ⇒ 01:19:58.690 Uttam Kumaran: There’s orders.
711 01:19:58.850 ⇒ 01:19:59.650 Ryan Luke Daque: Yeah.
712 01:19:59.990 ⇒ 01:20:07.230 Uttam Kumaran: what is what is that so like? Just add in after autumn, id at the tops, add in S dot order id.
713 01:20:22.080 ⇒ 01:20:25.420 Ryan Luke Daque: so we can actually join directly.
714 01:20:25.520 ⇒ 01:20:27.589 Uttam Kumaran: You don’t need the shipment items. Right?
715 01:20:38.670 ⇒ 01:20:43.680 The thing is, it’s we have we’ll get. We’re gonna have to go change all the joins. Honestly.
716 01:20:48.680 ⇒ 01:20:50.079 you you mean.
717 01:20:50.990 ⇒ 01:20:59.329 Uttam Kumaran: or though all the other models. We’re gonna have to remove all, all of the amount shipping information
718 01:21:00.180 ⇒ 01:21:03.130 Uttam Kumaran: from order items.
719 01:21:04.350 ⇒ 01:21:06.280 Uttam Kumaran: because we realize that
720 01:21:08.070 ⇒ 01:21:11.870 Uttam Kumaran: the shipments are not one to one with the items.
721 01:21:14.310 ⇒ 01:21:16.010 Uttam Kumaran: See what I’m saying.
722 01:21:17.870 ⇒ 01:21:20.920 Uttam Kumaran: So we can only have the shipment information
723 01:21:23.590 ⇒ 01:21:24.959 Uttam Kumaran: at the
724 01:21:28.010 ⇒ 01:21:30.840 yeah. It’s tough.
725 01:21:40.790 ⇒ 01:21:43.650 Uttam Kumaran: Okay, we’ll have to do that, I think then, because
726 01:21:47.160 ⇒ 01:21:53.360 Uttam Kumaran: we just realize here that it it doesn’t make sense to join one to one.
727 01:21:54.490 ⇒ 01:21:55.670 Uttam Kumaran: So
728 01:22:07.810 ⇒ 01:22:13.479 Ryan Luke Daque: it’s still yeah, it’s still. Gonna now, it’s gonna show up 3 times.
729 01:22:15.330 ⇒ 01:22:16.460 Uttam Kumaran: Yeah.
730 01:22:16.900 ⇒ 01:22:18.490 Ryan Luke Daque: So it’s
731 01:22:18.740 ⇒ 01:22:22.459 Uttam Kumaran: so we need to do all joins at the order level.
732 01:22:39.570 ⇒ 01:22:43.179 Uttam Kumaran: So pretty much what this becomes is.
733 01:22:44.240 ⇒ 01:22:48.349 Uttam Kumaran: everything needs to needs to be aggregated at the order number.
734 01:22:50.300 ⇒ 01:22:51.150 Ryan Luke Daque: Yeah.
735 01:22:51.370 ⇒ 01:22:53.130 Ryan Luke Daque: yeah, makes sense.
736 01:22:55.940 ⇒ 01:23:08.530 Uttam Kumaran: Okay, let’s leave this for now. But okay, cool. I think this all makes sense what? I will create a ticket. That’s just.
737 01:23:08.870 ⇒ 01:23:15.640 Uttam Kumaran: It’ll be one modify ship station to create ship station orders.
738 01:23:15.680 ⇒ 01:23:19.689 Uttam Kumaran: and then we will have to move all the joins
739 01:23:19.980 ⇒ 01:23:21.190 from
740 01:23:23.370 ⇒ 01:23:30.409 Uttam Kumaran: happening at the order items, tables to the orders, tables.
741 01:23:33.640 ⇒ 01:23:48.689 Uttam Kumaran: But it’s going to be the aggregated order. Yeah, the thing is the thing. The thing. The thing that’s tough is like we could actually keep any. We could keep all them all the this we actually kept 2 tables. It’s just we can’t bring any amounts in.
742 01:23:51.090 ⇒ 01:23:51.780 Ryan Luke Daque: Hmm.
743 01:23:52.040 ⇒ 01:23:55.940 Uttam Kumaran: right? Like, I want to bring in the width height stuff like that.
744 01:23:58.220 ⇒ 01:23:59.050 Ryan Luke Daque: Yeah.
745 01:23:59.220 ⇒ 01:24:03.640 Ryan Luke Daque: and and that we can’t aggregate that because it’s going to be different.
746 01:24:06.010 ⇒ 01:24:10.260 Ryan Luke Daque: Like, if there’s like 2 line items, and then they’re different sizes.
747 01:24:11.450 ⇒ 01:24:14.059 Uttam Kumaran: Yeah, like, exactly.
748 01:24:19.310 ⇒ 01:24:23.939 Uttam Kumaran: Okay. Alright, I’m glad we got to the bottom of it. So
749 01:24:23.990 ⇒ 01:24:28.689 Ryan Luke Daque: yeah, we’ll we’ll have to think about like, how we how to model this correctly.
750 01:24:28.720 ⇒ 01:24:30.030 Uttam Kumaran: Yeah, okay.
751 01:24:32.490 ⇒ 01:24:33.900 Uttam Kumaran: okay, cool.
752 01:24:33.970 ⇒ 01:24:40.289 Ryan Luke Daque: Alright. II know it’s kind of difficult to do it on the call. But I’m glad we just went through each of those things. So
753 01:24:41.030 ⇒ 01:24:44.620 Ryan Luke Daque: yeah, I’m I’m happy. I have the snowflake.
754 01:24:44.640 ⇒ 01:24:47.269 Uttam Kumaran: Yeah. Now, I hopefully got a question.
755 01:24:47.300 ⇒ 01:24:48.360 Uttam Kumaran: yeah.
756 01:24:49.000 ⇒ 01:24:49.869 Ryan Luke Daque: new stuff.
757 01:24:52.500 ⇒ 01:24:55.519 Uttam Kumaran: Okay, cool. I’m gonna jump.
758 01:24:55.560 ⇒ 01:25:09.999 Uttam Kumaran: I will. So for tomorrow, yeah, just let me know where we end up today on the shipping efficiency. If you end up taking time, just feel free because I wanna present that to them tomorrow. So and then,
759 01:25:11.490 ⇒ 01:25:16.569 Uttam Kumaran: yeah, let me know. On the other. The refund days and stuff should be pretty quick.
760 01:25:17.540 ⇒ 01:25:19.930 Uttam Kumaran: and this should be in there at the product class. So
761 01:25:21.440 ⇒ 01:25:24.810 Ryan Luke Daque: yeah. I can just use the macro, then
762 01:25:25.050 ⇒ 01:25:28.890 Ryan Luke Daque: to add this to all orders. I guess.
763 01:25:29.340 ⇒ 01:25:30.150 Uttam Kumaran: Yeah.
764 01:25:34.260 ⇒ 01:25:35.120 Ryan Luke Daque: Sounds good.
765 01:25:36.230 ⇒ 01:25:45.250 Uttam Kumaran: Okay. Well, thanks, Ryan. If I don’t talk to you tomorrow, have a good weekend, and then yeah, let’s touch base on Monday. We’ll have some fresh stuff to work on.
766 01:25:45.530 ⇒ 01:25:51.460 Ryan Luke Daque: Sounds good. Thanks with them. Have a nice rest of your week. Thank you, you, too. Bye, bye.