Meeting Title: PP2G | Standup Date: 2025-04-09 Meeting participants: Luke Daque, Amber Lin, Kim Todaro, Chuck Gross
WEBVTT
1 00:01:01.190 ⇒ 00:01:03.240 Chuck Gross: Doc, speaking, how can I help you?
2 00:02:58.290 ⇒ 00:02:59.360 Luke Daque: Hi! Chuck!
3 00:03:02.920 ⇒ 00:03:04.170 Chuck Gross: Hey! How are you?
4 00:03:05.050 ⇒ 00:03:06.580 Luke Daque: Doing well, how are you.
5 00:03:06.580 ⇒ 00:03:07.440 Chuck Gross: Good.
6 00:03:08.130 ⇒ 00:03:09.289 Luke Daque: It’s been a while.
7 00:03:09.540 ⇒ 00:03:10.777 Chuck Gross: Yeah, I know.
8 00:03:28.310 ⇒ 00:03:32.710 Luke Daque: Now, let’s just wait a little bit, for maybe Kim and Amber to join.
9 00:03:33.230 ⇒ 00:03:33.830 Chuck Gross: No problem.
10 00:03:33.830 ⇒ 00:03:34.530 Luke Daque: This time.
11 00:03:34.890 ⇒ 00:03:36.120 Chuck Gross: No problem.
12 00:03:37.010 ⇒ 00:03:37.620 Luke Daque: Cool.
13 00:03:55.790 ⇒ 00:03:56.340 kim todaro: Huh?
14 00:04:02.050 ⇒ 00:04:02.863 kim todaro: Hey? Guys.
15 00:04:03.430 ⇒ 00:04:04.300 Chuck Gross: Hi cam.
16 00:04:04.300 ⇒ 00:04:05.390 Luke Daque: Hello! Everyone.
17 00:04:08.570 ⇒ 00:04:10.350 kim todaro: Chuck, why aren’t you on video.
18 00:04:10.350 ⇒ 00:04:13.160 Chuck Gross: Because my camera doesn’t work and I don’t have my other camera.
19 00:04:14.280 ⇒ 00:04:16.459 Chuck Gross: So I’m I’m just a black screen.
20 00:04:17.310 ⇒ 00:04:18.510 kim todaro: I’m messing with you.
21 00:04:23.690 ⇒ 00:04:24.730 Amber Lin: Hello!
22 00:04:25.690 ⇒ 00:04:26.890 kim todaro: Hey? Amber?
23 00:04:35.990 ⇒ 00:04:36.870 kim todaro: Okay? So.
24 00:04:36.870 ⇒ 00:04:37.470 Luke Daque: Yeah.
25 00:04:37.740 ⇒ 00:04:39.855 kim todaro: And then we can kick it off now.
26 00:04:40.280 ⇒ 00:04:44.148 kim todaro: So I feel like Amazon’s in a really good spot. Right?
27 00:04:45.190 ⇒ 00:04:51.530 Luke Daque: Yeah, it’s in progress at the moment, but I think we have, like everything at least cleared to an extent so.
28 00:04:51.530 ⇒ 00:04:52.150 kim todaro: Okay. Cool.
29 00:04:52.150 ⇒ 00:04:53.900 Luke Daque: If there’s anything else. Yeah.
30 00:04:54.450 ⇒ 00:04:59.089 kim todaro: That’s awesome. And then I think the biggest thing was. And, Ryan.
31 00:04:59.220 ⇒ 00:05:02.759 kim todaro: please correct me. If I’m wrong, is the
32 00:05:02.990 ⇒ 00:05:08.679 kim todaro: we’re chuck. We’re just trying to get a profitability report in real for shopify.
33 00:05:08.680 ⇒ 00:05:09.410 Chuck Gross: Right.
34 00:05:09.960 ⇒ 00:05:11.780 kim todaro: We talked about this with Ben a little bit.
35 00:05:12.720 ⇒ 00:05:16.309 kim todaro: And so Ben really wants it to be very accurate, and it hasn’t
36 00:05:16.430 ⇒ 00:05:27.380 kim todaro: been accurate. But we’re almost. We’re getting there, and I think the biggest thing is the shop, the the cogs that that are getting pulled from
37 00:05:28.017 ⇒ 00:05:34.112 kim todaro: we could see where Ryan is pulling his cogs, for I was pulling them from shopify, and they were. They seemed off.
38 00:05:34.640 ⇒ 00:05:54.779 kim todaro: And then the second part is the the ship station, shipping ship station, shipping costs, and also the units. So Ryan, maybe we could just kind of do what we did with Steven yesterday and figure out what the sources of those are, or however, you wanna kick off the call. I don’t care. But it was like super helpful. Whatever you were doing.
39 00:05:55.480 ⇒ 00:05:57.532 Luke Daque: Yeah, let me go ahead and share my screen.
40 00:05:58.580 ⇒ 00:06:03.059 Luke Daque: So yeah, Kim and Amber, already familiar with this, I can use my screen, by the way.
41 00:06:04.610 ⇒ 00:06:09.769 Luke Daque: So the first, st the table here at the top is the the one that came manually
42 00:06:10.385 ⇒ 00:06:17.229 Luke Daque: added, basically for shopify, and that this is from March 31 to looks like April 8.th Now it’s up to date.
43 00:06:17.906 ⇒ 00:06:22.470 Luke Daque: And the one at the bottom is the one that I have from our
44 00:06:22.980 ⇒ 00:06:25.980 Luke Daque: tables, or like data models, and which is
45 00:06:26.200 ⇒ 00:06:30.869 Luke Daque: also like what is showing up in our like real dashboard over here.
46 00:06:31.650 ⇒ 00:06:42.267 Luke Daque: So I did take a look at the differences. Let’s focus on like, maybe the cogs and the shipping costs. For now, because this is like where the difference is.
47 00:06:43.860 ⇒ 00:06:55.819 Luke Daque: it’s pretty big, huge. Well, actually, yeah, as you can see here, like Kim’s already at 48,000, and mine was like at 51,000. And this doesn’t include April 7 and 8.
48 00:06:56.130 ⇒ 00:06:56.880 Luke Daque: But
49 00:06:57.030 ⇒ 00:07:07.100 Luke Daque: yeah, and almost all of the days are like higher. For from my end, because I’m getting cogs from our unleashed
50 00:07:08.002 ⇒ 00:07:12.869 Luke Daque: data source, and I believe Kim is getting it from shopify.
51 00:07:13.180 ⇒ 00:07:19.780 Luke Daque: And yeah, we just wanted to confirm, like, chuck like where we should be getting the cogs from.
52 00:07:20.820 ⇒ 00:07:28.859 Chuck Gross: The the cock. Yeah, they should definitely be coming from unleashed, because each time we process an order
53 00:07:29.000 ⇒ 00:07:42.279 Chuck Gross: a sales journal gets pushed into 0 the accounting software for the amount of the cost of goods sold based on the item, the dollar amount in unleashed. So I would definitely be pulling from unleashed.
54 00:07:43.260 ⇒ 00:07:44.380 Luke Daque: I see.
55 00:07:44.380 ⇒ 00:08:03.399 kim todaro: So Luke is right, I’m wrong. I think you also just gave me an updated sheet. So maybe I have to go. Not that we use. Maybe we just don’t use the cost, the cogs and shopify but that’s I don’t have access to unleash. So that’s why I was using shopify. But I think Ryan’s been right the whole time, or Luke has been right the whole time. Ryan, Luke.
56 00:08:03.400 ⇒ 00:08:03.990 Luke Daque: Cool.
57 00:08:04.341 ⇒ 00:08:07.149 Luke Daque: So I think we’re, we’re probably good. There.
58 00:08:07.150 ⇒ 00:08:08.020 Luke Daque: Yeah, cool.
59 00:08:08.130 ⇒ 00:08:11.286 Luke Daque: Yeah. I think the next one, then, is the shipment cost? Because,
60 00:08:11.770 ⇒ 00:08:16.640 Luke Daque: yeah, I believe. You mentioned Kim, you were you were using ship station and units.
61 00:08:17.100 ⇒ 00:08:21.310 kim todaro: Yes, go to this the
62 00:08:22.971 ⇒ 00:08:25.940 kim todaro: can you go to the total profitability sheet?
63 00:08:28.030 ⇒ 00:08:29.110 kim todaro: Okay, never mind. You can go back.
64 00:08:29.110 ⇒ 00:08:32.010 Luke Daque: Let me do this. This is the upgraded.
65 00:08:32.010 ⇒ 00:08:32.659 kim todaro: Okay.
66 00:08:33.710 ⇒ 00:08:45.129 kim todaro: okay, so yeah, that’s the one updated today. So yeah, I I don’t know what I’m doing also. But what I was doing was. Chuck was giving me spreadsheet. So I was taking the order date.
67 00:08:46.630 ⇒ 00:08:49.590 kim todaro: and I was using the item shipped cost value. There.
68 00:08:49.920 ⇒ 00:08:53.300 Luke Daque: To port these numbers. I don’t know if it’s.
69 00:08:54.050 ⇒ 00:09:03.920 kim todaro: If I should be using the order, date or the ship date either way. I know all that units information is missing, so I think that’s the second part we need your help with on Chuck.
70 00:09:04.590 ⇒ 00:09:21.030 Chuck Gross: Right? So yeah, because the when the when the sale comes in versus when it gets shipped to, can be kind of goofy, because we should, you know, especially over the weekend some Friday sales Saturday, Sunday. They all get shipped on Monday, so those costs are gonna get out of whack a little bit.
71 00:09:21.390 ⇒ 00:09:30.089 Chuck Gross: but then, when the like, when freight billing and units billing, those Billings are gonna happen not at the same time as the shipments.
72 00:09:30.590 ⇒ 00:09:35.039 Chuck Gross: So the sale for a heater might come in for argument’s sake. On April 1st
73 00:09:35.190 ⇒ 00:09:44.410 Chuck Gross: I may ship it on the 3, rd and then you’re not going to get an invoice till the 5, th so there’d be an odd delay for a lot of those larger shipments.
74 00:09:45.330 ⇒ 00:09:49.469 kim todaro: Okay. Luke, what are we using right now to pull that number? The shipping cost.
75 00:09:49.470 ⇒ 00:09:52.160 Luke Daque: Let me check real quick.
76 00:09:54.430 ⇒ 00:10:02.399 Luke Daque: But yeah, just yeah, we were getting it from ship station. We’re also using like Lpl
77 00:10:03.040 ⇒ 00:10:12.310 Luke Daque: and unit shipment but as to the dates, let me double check. Let me just check real quick.
78 00:10:20.160 ⇒ 00:10:23.009 Luke Daque: Looks like we’re using ship date. For the most part.
79 00:10:23.950 ⇒ 00:10:31.179 Luke Daque: we’re not using any order date that it’s even like for L for ship station. It’s ship date for Ltl.
80 00:10:34.920 ⇒ 00:10:39.639 Luke Daque: It’s the pickup date, which is, I guess.
81 00:10:39.770 ⇒ 00:10:41.640 Luke Daque: when the order was picked up.
82 00:10:42.030 ⇒ 00:10:47.629 Luke Daque: What? Where did the item? Yes, unit shipments is also like ship date.
83 00:10:48.150 ⇒ 00:10:58.320 Luke Daque: And yeah, should they basically premise would be like pickup date as well.
84 00:10:59.490 ⇒ 00:11:06.470 kim todaro: So I think. I know that when, a few months ago, when Nico was still kind of helping us.
85 00:11:06.720 ⇒ 00:11:07.090 Luke Daque: And.
86 00:11:07.090 ⇒ 00:11:12.359 kim todaro: We’re trying to assign like a number to the units cause I don’t know I could be wrong. Chuck
87 00:11:12.520 ⇒ 00:11:14.870 kim todaro: Chuck knows way better than I do, but I don’t think
88 00:11:15.080 ⇒ 00:11:18.969 kim todaro: the Unis numbers are accurate, or I don’t even know where that’s pulling from.
89 00:11:20.730 ⇒ 00:11:23.990 Chuck Gross: Yeah, that was gonna be. My question is, where is it actually pulling from?
90 00:11:26.420 ⇒ 00:11:30.500 Luke Daque: For the units itself. Let me check. We’re getting it from.
91 00:11:31.840 ⇒ 00:11:34.440 Luke Daque: So this would be Mini shipments.
92 00:11:34.690 ⇒ 00:11:36.089 Luke Daque: Give me a second here.
93 00:11:38.590 ⇒ 00:11:46.270 Luke Daque: This is from the Unis email that we’re getting. It’s coming from the Unis export
94 00:11:46.790 ⇒ 00:11:50.780 Luke Daque: that we’re doing from units itself. Yeah.
95 00:11:51.280 ⇒ 00:11:59.829 Luke Daque: we’re we’re getting like recurring exports through email every day or like. And yeah, and then we’re like consolidating everything here.
96 00:12:00.130 ⇒ 00:12:00.890 Chuck Gross: Okay.
97 00:12:02.870 ⇒ 00:12:08.300 Luke Daque: Is that the correct approach, though like, or is there like some something else?
98 00:12:09.990 ⇒ 00:12:12.532 Luke Daque: Let me see if I still have that
99 00:12:13.800 ⇒ 00:12:19.429 Chuck Gross: I was gonna say, do you have an example of one of those emails? Because I get emails to from them? I just don’t know.
100 00:12:19.620 ⇒ 00:12:20.380 Luke Daque: Hmm.
101 00:12:20.380 ⇒ 00:12:26.499 Chuck Gross: You know, ship date, or pick up that I don’t know which, you know, if we’re trying to time it right. I don’t know which time they they’re showing you.
102 00:12:27.410 ⇒ 00:12:33.930 Luke Daque: Yeah, that’s a good question. Let me check if I can see any example email here.
103 00:12:39.370 ⇒ 00:12:45.329 Luke Daque: I’m not exactly sure what this is coming from. But it, it looks like this. Basically.
104 00:12:46.150 ⇒ 00:12:49.170 Luke Daque: I’m not sure exactly what report this is coming from.
105 00:12:51.850 ⇒ 00:12:54.610 Luke Daque: So it has like facility until.
106 00:12:56.550 ⇒ 00:12:58.610 Chuck Gross: That stuff, too. I forgot about that stuff.
107 00:13:02.460 ⇒ 00:13:06.110 Luke Daque: Let me see if I have access to units real quick.
108 00:13:19.000 ⇒ 00:13:20.739 Luke Daque: Are you like familiar with this?
109 00:13:21.170 ⇒ 00:13:23.810 Luke Daque: kind of report, chuck or, okay.
110 00:13:24.270 ⇒ 00:13:24.760 kim todaro: I’m not.
111 00:13:24.760 ⇒ 00:13:31.529 Chuck Gross: These are all the ground shipments from the various units locations which is fine. Are there any heaters on here
112 00:13:32.700 ⇒ 00:13:41.919 Chuck Gross: like I see. Column A. B says delivery service grounds. So those are all the like. It was all ups. Carrier ups. It’s all the regular ups orders.
113 00:13:43.855 ⇒ 00:13:45.700 Chuck Gross: This is cedar.
114 00:13:45.700 ⇒ 00:13:46.629 Chuck Gross: Where’s that thing?
115 00:13:47.550 ⇒ 00:13:48.120 Luke Daque: And I don’t.
116 00:13:48.120 ⇒ 00:13:54.199 kim todaro: I think there’s also product names or skews at the beginning. Maybe if you scroll to like a B column.
117 00:13:56.010 ⇒ 00:13:58.299 kim todaro: yeah. So those look like.
118 00:13:58.300 ⇒ 00:13:59.819 Chuck Gross: It’s all all pumps.
119 00:13:59.970 ⇒ 00:14:03.780 kim todaro: All pumps. I don’t know if the heaters are included in this.
120 00:14:04.360 ⇒ 00:14:08.330 Luke Daque: This is an old report, though, like when or.
121 00:14:08.460 ⇒ 00:14:09.620 kim todaro: Yeah, you’re right?
122 00:14:09.620 ⇒ 00:14:10.680 Chuck Gross: There’s a heater.
123 00:14:11.580 ⇒ 00:14:12.590 Luke Daque: Be Solomon.
124 00:14:12.590 ⇒ 00:14:13.160 Chuck Gross: Yeah.
125 00:14:15.020 ⇒ 00:14:18.960 Luke Daque: Like, how would I? Maybe it’s called heat, or something. I don’t know.
126 00:14:20.300 ⇒ 00:14:26.469 Chuck Gross: It was model. Bdx, bt, 88 0. That’s.
127 00:14:27.562 ⇒ 00:14:28.380 Luke Daque: This one. Yeah.
128 00:14:28.740 ⇒ 00:14:29.420 kim todaro: Yeah.
129 00:14:29.600 ⇒ 00:14:30.280 Chuck Gross: So does.
130 00:14:30.280 ⇒ 00:14:32.439 Luke Daque: Yeah, so it looks like it has heaps.
131 00:14:33.230 ⇒ 00:14:37.219 Chuck Gross: So now does that have a rate assigned to it? I’m curious.
132 00:14:37.500 ⇒ 00:14:42.145 Chuck Gross: Create a date created February. Shipped April. That’s good
133 00:14:43.280 ⇒ 00:14:44.070 Luke Daque: Yeah.
134 00:14:44.750 ⇒ 00:14:47.790 Luke Daque: So in this case, we’re using the ship date. So this one.
135 00:14:47.790 ⇒ 00:14:48.470 Chuck Gross: Okay.
136 00:14:49.520 ⇒ 00:14:50.260 Luke Daque: That’s weird.
137 00:14:50.260 ⇒ 00:14:52.950 Luke Daque: And yeah, it took like, 2 months.
138 00:14:53.930 ⇒ 00:14:55.139 Luke Daque: What else we have here.
139 00:14:55.140 ⇒ 00:14:59.210 Chuck Gross: It might have back then. That was when we 1st started with them. They were very slow.
140 00:14:59.380 ⇒ 00:14:59.919 kim todaro: Oh, my God!
141 00:15:00.510 ⇒ 00:15:03.789 Chuck Gross: But there’s there’s no costs on either.
142 00:15:03.790 ⇒ 00:15:04.200 Luke Daque: Yes.
143 00:15:04.200 ⇒ 00:15:05.339 Chuck Gross: Yeah, so.
144 00:15:05.810 ⇒ 00:15:06.540 Luke Daque: Yeah.
145 00:15:08.970 ⇒ 00:15:11.929 Luke Daque: So we’re probably using the shipping cost, you know.
146 00:15:12.200 ⇒ 00:15:15.249 kim todaro: Yeah. And that’s way under what the actual is.
147 00:15:15.880 ⇒ 00:15:16.240 Luke Daque: Hmm.
148 00:15:16.600 ⇒ 00:15:19.899 kim todaro: What’s the actual, do you think, Chuck? That was a Florida address.
149 00:15:20.430 ⇒ 00:15:29.059 Chuck Gross: From them at that time they tried to use a local trucker, so I have no idea how they invoiced it. That’s why it took so long.
150 00:15:29.960 ⇒ 00:15:35.990 Chuck Gross: But you know, on average, now that probably costs about 4 20 somewhere in that neighborhood.
151 00:15:36.200 ⇒ 00:15:42.549 kim todaro: Yeah, so is the shop. Is the ship station pulling the correct information.
152 00:15:43.070 ⇒ 00:15:47.270 Chuck Gross: No, I’ve been filling in like the ones I sent to you. I fill in an estimate for the heat pump.
153 00:15:47.880 ⇒ 00:15:55.690 Chuck Gross: The heat pumps aren’t on there. We don’t process them through ship station. If I ship them. If I ship them out of here they come out of a website. Freight and logistics.
154 00:15:55.690 ⇒ 00:15:56.380 kim todaro: Yeah.
155 00:15:56.570 ⇒ 00:16:02.339 Chuck Gross: And then if we’re shipping them out of units, they would come, I guess, into that spreadsheet.
156 00:16:02.340 ⇒ 00:16:03.060 kim todaro: Yeah.
157 00:16:04.140 ⇒ 00:16:08.750 Luke Daque: Which I think we already included as well the the ones that are shipped to Florida.
158 00:16:08.890 ⇒ 00:16:17.829 Luke Daque: There was like some weird logic that we added, I can’t exactly remember what, but they were like. If the Zip code was in Florida, then we were like using some
159 00:16:19.930 ⇒ 00:16:27.010 Luke Daque: right right. I was using a local trucker for that. I don’t know if I’ll still be using him. But we were using him at that point. So
160 00:16:28.830 ⇒ 00:16:32.680 Luke Daque: yeah, so like, yeah, there’s like miles from the warehouse, and then
161 00:16:33.610 ⇒ 00:16:39.110 Luke Daque: like different zones, basically. And then like different prices per zone.
162 00:16:40.110 ⇒ 00:16:48.060 Luke Daque: if I recall. But you know something like that, I can’t quite remember the exact calculation. There.
163 00:16:48.650 ⇒ 00:16:49.350 kim todaro: Right?
164 00:16:50.293 ⇒ 00:16:54.500 kim todaro: So I guess what I meant was more like. Obviously the heat pumps
165 00:16:55.200 ⇒ 00:17:03.300 kim todaro: or units is separate. But the ship station that you use, Doc, those costs.
166 00:17:03.910 ⇒ 00:17:11.220 kim todaro: Getting put into Brian’s report correctly. Obviously, we have to work on the unit stuff. But I’m just. I’m just curious outside of the unit stuff. If
167 00:17:11.800 ⇒ 00:17:13.750 kim todaro: things are correct, that’s all.
168 00:17:14.859 ⇒ 00:17:17.097 Chuck Gross: So do we have any like
169 00:17:18.399 ⇒ 00:17:25.799 Chuck Gross: orders from the last few days on this sheet that we can compare the cost to. I mean, I would think that they’d be pulling. I would think they’re the same.
170 00:17:28.160 ⇒ 00:17:29.579 Luke Daque: Let me try to do.
171 00:17:29.580 ⇒ 00:17:30.150 kim todaro: Yeah, right.
172 00:17:30.150 ⇒ 00:17:31.820 Luke Daque: Do a query,
173 00:17:41.850 ⇒ 00:17:48.820 Luke Daque: if we have the item id, then we should be able to go there, and we’re just like trying to look for heat pumps right
174 00:17:50.600 ⇒ 00:17:51.440 Luke Daque: for now.
175 00:17:52.318 ⇒ 00:17:58.219 kim todaro: For ship station. I don’t think chuck uses heat any heat pumps at all, but.
176 00:17:58.220 ⇒ 00:17:58.950 Luke Daque: Oh, just.
177 00:17:58.950 ⇒ 00:18:04.439 kim todaro: He does use ship station for a lot of like the cover pumps and pool pumps right right chuck.
178 00:18:04.440 ⇒ 00:18:08.329 Chuck Gross: Yeah, anything that’s small parcel. It all goes through ship station.
179 00:18:08.600 ⇒ 00:18:09.290 kim todaro: Brushes.
180 00:18:09.290 ⇒ 00:18:09.630 Luke Daque: Okay.
181 00:18:09.630 ⇒ 00:18:11.120 Chuck Gross: Yeah. All that stuff.
182 00:18:11.120 ⇒ 00:18:16.539 kim todaro: So even if we could just make sure that’s correct. And then we can worry about units later. That’s huge.
183 00:18:20.490 ⇒ 00:18:21.560 Luke Daque: Ignored it.
184 00:18:22.430 ⇒ 00:18:30.459 Luke Daque: So here’s an example. These are a couple of examples. Here, let’s see, we have.
185 00:18:31.910 ⇒ 00:18:37.020 Luke Daque: Doesn’t seem to be a notes here.
186 00:18:37.920 ⇒ 00:18:39.649 Luke Daque: She did snow.
187 00:19:09.150 ⇒ 00:19:13.429 Luke Daque: Okay, so this one, this is 2024.
188 00:19:18.300 ⇒ 00:19:20.189 Luke Daque: Think we have anything. Let me see.
189 00:19:32.360 ⇒ 00:19:38.650 Luke Daque: Wait, let me just go to this notification. It’s probably thing to do it there.
190 00:19:42.230 ⇒ 00:19:43.190 Luke Daque: And
191 00:20:25.480 ⇒ 00:20:29.110 Luke Daque: yeah, this one is like, just today, it looks like,
192 00:20:33.200 ⇒ 00:20:34.640 Luke Daque: Can you see it clearly?
193 00:20:35.480 ⇒ 00:20:40.239 Luke Daque: Just check this one.
194 00:20:40.650 ⇒ 00:20:42.270 Luke Daque: This goes down.
195 00:20:43.660 ⇒ 00:20:45.000 Luke Daque: Now this is Amazon.
196 00:20:45.000 ⇒ 00:20:48.160 Chuck Gross: Yeah, I was. Gonna say, let me look, I can look it up by that order number.
197 00:20:48.880 ⇒ 00:20:51.849 Chuck Gross: I just wanna see. I’m sure it’s the same.
198 00:20:54.560 ⇒ 00:20:55.270 Luke Daque: What do you see?
199 00:20:56.400 ⇒ 00:20:57.729 Chuck Gross: Tell me which one you need.
200 00:20:57.730 ⇒ 00:20:59.300 Chuck Gross: Which one do you want to check?
201 00:20:59.850 ⇒ 00:21:03.030 Luke Daque: I can check the 1st one, I guess. Like what? What number do you need?
202 00:21:03.273 ⇒ 00:21:05.220 Chuck Gross: Scroll over a little bit to your right.
203 00:21:06.840 ⇒ 00:21:07.660 Luke Daque: None.
204 00:21:07.660 ⇒ 00:21:12.329 Chuck Gross: Like, the yeah, that that order order, yeah, order, key or order number. That’s.
205 00:21:12.650 ⇒ 00:21:15.789 Luke Daque: I can send it in the chat back.
206 00:21:15.790 ⇒ 00:21:18.119 Chuck Gross: 6 million 0, 3, 9, 9, 4. I got it.
207 00:21:18.520 ⇒ 00:21:19.230 Luke Daque: Okay. Cool.
208 00:21:19.230 ⇒ 00:21:19.690 Chuck Gross: I don’t.
209 00:21:19.690 ⇒ 00:21:21.829 kim todaro: That’s a shopify order.
210 00:21:22.170 ⇒ 00:21:23.159 Chuck Gross: The Amazon order!
211 00:21:23.160 ⇒ 00:21:23.990 Luke Daque: Oh, yeah.
212 00:21:23.990 ⇒ 00:21:25.740 Chuck Gross: You want to do a shopify one instead.
213 00:21:25.740 ⇒ 00:21:27.479 Chuck Gross: we have to make sure that
214 00:21:27.770 ⇒ 00:21:29.210 Chuck Gross: it’s like 8, 8, 1 0, 2.
215 00:21:29.210 ⇒ 00:21:34.340 kim todaro: Yeah. We gotta make sure the shopify report only uses shipping costs for shopify.
216 00:21:34.340 ⇒ 00:21:39.429 Chuck Gross: Alright. So the 3rd one down. See order number 8, 8, 1 0. 2 p. As in Peter.
217 00:21:39.950 ⇒ 00:21:40.580 kim todaro: Yep, that’s it.
218 00:21:41.431 ⇒ 00:21:44.199 Luke Daque: What’s the shipping cost on that
219 00:21:44.990 ⇒ 00:21:51.510 Luke Daque: this one? Let’s see what she can cost 6.61.
220 00:21:51.510 ⇒ 00:21:55.539 Chuck Gross: Yep, that’s what I got. Okay. Do you want to check another one?
221 00:21:57.590 ⇒ 00:21:58.260 Luke Daque: We can.
222 00:21:58.260 ⇒ 00:21:59.289 Chuck Gross: Yeah, next, 8, 8.
223 00:21:59.290 ⇒ 00:21:59.949 Luke Daque: The phone.
224 00:22:00.860 ⇒ 00:22:02.900 Luke Daque: So this is row 9.
225 00:22:03.080 ⇒ 00:22:05.259 Chuck Gross: 8, 8, 1 1 0.
226 00:22:06.840 ⇒ 00:22:10.110 Luke Daque: Yep, and this is 9.99.
227 00:22:11.330 ⇒ 00:22:12.050 Chuck Gross: Yup!
228 00:22:13.750 ⇒ 00:22:18.830 Luke Daque: So, yeah, it looks like we’re getting the correct numbers there, for ship station looks like.
229 00:22:19.050 ⇒ 00:22:23.989 kim todaro: Okay, and should be, we should be using the ship date, not the order. Date right?
230 00:22:24.820 ⇒ 00:22:28.720 Chuck Gross: The the shift is when it’s gonna go. Yeah. So whatever makes it easier for you guys.
231 00:22:28.720 ⇒ 00:22:30.200 kim todaro: I think ship date’s fine.
232 00:22:30.950 ⇒ 00:22:31.770 kim todaro: Okay? Yeah.
233 00:22:33.660 ⇒ 00:22:34.220 Luke Daque: And.
234 00:22:35.090 ⇒ 00:22:41.589 kim todaro: Yeah, we just have to make sure that the Amazon isn’t isn’t included. Obviously.
235 00:22:41.590 ⇒ 00:22:44.979 Luke Daque: Yeah, it’s not. This is like the the main main one. Yep.
236 00:22:44.980 ⇒ 00:22:47.400 Luke Daque: the wrong one. Yeah. And we’re just like filtering it like.
237 00:22:50.570 ⇒ 00:22:51.600 kim todaro: Okay. Cool.
238 00:22:53.590 ⇒ 00:22:58.455 Luke Daque: Yeah, nice so I guess that’s we’re good with ship station. So I guess
239 00:23:00.250 ⇒ 00:23:03.059 Luke Daque: like for units, was there anything else? Oh.
240 00:23:03.170 ⇒ 00:23:05.169 Luke Daque: anything we needed to do for Eunice.
241 00:23:06.160 ⇒ 00:23:07.160 Luke Daque: Let’s check.
242 00:23:13.190 ⇒ 00:23:19.340 kim todaro: I don’t know. Eunice is kind of out of my ballpark. I don’t know what the best way to get accurate, the most accurate cost for Eunice
243 00:23:19.840 ⇒ 00:23:21.450 kim todaro: Chuck. Do you have any ideas.
244 00:23:21.640 ⇒ 00:23:25.890 Chuck Gross: I’m gonna I was. Gonna look at one of the emails. They had
245 00:23:26.120 ⇒ 00:23:34.164 Chuck Gross: sense. I don’t know if it’s how we can pull it, though they’re they’re not very user friendly when it comes to data.
246 00:23:34.500 ⇒ 00:23:35.040 Luke Daque: Yes.
247 00:23:35.920 ⇒ 00:23:37.120 Chuck Gross: See if I got one.
248 00:23:37.860 ⇒ 00:23:48.709 Luke Daque: From what I can recall, though, like we had several meetings as well before Chuck, and I think you did confirm, like the the stuff that we had when like it was still like Nick Nicholas.
249 00:23:49.390 ⇒ 00:23:50.210 Chuck Gross: Right.
250 00:23:50.210 ⇒ 00:23:53.439 Luke Daque: With with Nicholas for all the even the
251 00:23:53.650 ⇒ 00:24:01.440 Luke Daque: the latest one, which I remember that, we added, was the Florida zones, please.
252 00:24:01.750 ⇒ 00:24:02.550 Chuck Gross: Right, right.
253 00:24:02.550 ⇒ 00:24:03.320 Luke Daque: Right.
254 00:24:04.010 ⇒ 00:24:06.680 Chuck Gross: So like I I was, gonna say, I.
255 00:24:06.680 ⇒ 00:24:07.220 Luke Daque: Hang on!
256 00:24:10.790 ⇒ 00:24:11.610 Chuck Gross: Good.
257 00:24:13.480 ⇒ 00:24:15.119 Chuck Gross: So I got these.
258 00:24:15.500 ⇒ 00:24:21.029 Chuck Gross: Think I’m so I get these invoices each night for each shipment.
259 00:24:21.480 ⇒ 00:24:23.420 Chuck Gross: So like this shipments
260 00:24:24.691 ⇒ 00:24:31.590 Chuck Gross: was for 1935. This is for order number 6, 8, 7, 6, 6, 3.
261 00:24:33.110 ⇒ 00:24:34.270 Luke Daque: And that’s Eunice.
262 00:24:34.270 ⇒ 00:24:37.830 Chuck Gross: And this is shipped from Eunice correct for that customer.
263 00:24:39.000 ⇒ 00:24:47.969 Chuck Gross: So I don’t know if there’s a way to pull the data from these invoices like if we send them somewhere that I don’t know.
264 00:24:50.580 ⇒ 00:24:52.510 Luke Daque: But is there like an order
265 00:24:52.860 ⇒ 00:24:57.238 Luke Daque: tied up to that? Maybe I can filter it here because I’m in the shipments
266 00:24:58.000 ⇒ 00:24:58.550 Chuck Gross: Well, it’s.
267 00:24:58.550 ⇒ 00:25:02.510 Luke Daque: You know, which is yeah. 8, 7, 6, 3, 3. P.
268 00:25:04.370 ⇒ 00:25:06.509 Luke Daque: That’s a shock. If I were to write.
269 00:25:06.510 ⇒ 00:25:08.399 Chuck Gross: That’s a shopify letter. Correct?
270 00:25:16.150 ⇒ 00:25:18.890 Luke Daque: 8, 7, 6, 6, 3.
271 00:25:19.220 ⇒ 00:25:21.729 Chuck Gross: 8, 7, 6, 3, 3.
272 00:25:25.240 ⇒ 00:25:29.339 Luke Daque: Doesn’t look like it’s here, May, is this? Maybe it’s to music.
273 00:25:29.340 ⇒ 00:25:30.239 kim todaro: P. At the end.
274 00:25:30.240 ⇒ 00:25:32.180 Chuck Gross: Yeah. P. At the end. I’m sorry.
275 00:25:34.040 ⇒ 00:25:37.019 kim todaro: So it’s 8, 7, 6, 3, 3. P.
276 00:25:39.990 ⇒ 00:25:43.800 Luke Daque: Maybe it’s order 1990.
277 00:25:45.770 ⇒ 00:25:51.819 Luke Daque: It’s not here. Is this can we maybe do something that was shipped yesterday, or something?
278 00:25:52.222 ⇒ 00:25:54.319 Chuck Gross: Yeah, we could try. Hold on. Come here.
279 00:25:56.990 ⇒ 00:25:58.719 Chuck Gross: figure out how to get out of this.
280 00:25:59.730 ⇒ 00:26:00.450 Luke Daque: Okay.
281 00:26:10.760 ⇒ 00:26:12.830 Chuck Gross: Okay, let me let me find. Let me find another one.
282 00:26:13.390 ⇒ 00:26:15.890 Chuck Gross: Let’s go back a few days. All right.
283 00:26:17.900 ⇒ 00:26:24.240 Chuck Gross: all right. I have one for 8, 7, 7, 4, 4. P.
284 00:26:25.170 ⇒ 00:26:29.049 Luke Daque: No, it’s not here. 8, 7, 7, 4, 4.
285 00:26:38.960 ⇒ 00:26:43.940 kim todaro: That would kind of be cool if you could get those invoices and scrape the reference number and the
286 00:26:44.620 ⇒ 00:26:46.129 kim todaro: the total cost.
287 00:26:50.240 ⇒ 00:26:54.280 kim todaro: Yeah, so that number under unit. That number looks way low for 3 months.
288 00:26:56.220 ⇒ 00:26:56.910 Luke Daque: This one.
289 00:26:56.910 ⇒ 00:26:57.380 kim todaro: Yeah.
290 00:26:57.380 ⇒ 00:26:58.060 Luke Daque: Awesome.
291 00:26:58.060 ⇒ 00:26:58.760 kim todaro: Yeah.
292 00:27:02.160 ⇒ 00:27:04.530 kim todaro: I think that’s like the biggest issue.
293 00:27:05.760 ⇒ 00:27:06.370 Luke Daque: Great.
294 00:27:06.370 ⇒ 00:27:11.070 Luke Daque: I’ll I’ll take a look. Maybe there’s like some missing stuff like we weren’t able to see the
295 00:27:11.250 ⇒ 00:27:15.190 Luke Daque: the other orders. The orders that Chuck just messaged.
296 00:27:15.570 ⇒ 00:27:16.110 kim todaro: Okay.
297 00:27:17.560 ⇒ 00:27:18.260 Luke Daque: Cool!
298 00:27:19.990 ⇒ 00:27:21.090 Luke Daque: Alright! Well.
299 00:27:21.090 ⇒ 00:27:23.989 kim todaro: Doc. Thank you for hopping on and clearing some stuff up.
300 00:27:24.360 ⇒ 00:27:27.179 Chuck Gross: No problem. Whenever you guys need me, I’m here.
301 00:27:27.980 ⇒ 00:27:28.680 Luke Daque: Sure.
302 00:27:30.170 ⇒ 00:27:31.010 kim todaro: Perfect.
303 00:27:33.090 ⇒ 00:27:40.510 kim todaro: What do you? What do you think, Luke? You wanna you wanna just take in what we talked about today, and we’ll we’ll recap tomorrow or on Friday.
304 00:27:41.710 ⇒ 00:27:51.979 Luke Daque: Yeah, we can. We can do that. Because I’m also still like working on the the Amazon stuff that we discussed yesterday, like adding like like moving the marketing costs for
305 00:27:52.190 ⇒ 00:27:58.215 Luke Daque: Amazon as to just Amazon, and like looking for the other, the rest, like the impact. And
306 00:27:58.820 ⇒ 00:28:01.160 kim todaro: The other Amazon. Other ad.
307 00:28:01.550 ⇒ 00:28:02.050 kim todaro: Yeah.
308 00:28:02.550 ⇒ 00:28:03.809 Luke Daque: Stuff like that. So yeah.
309 00:28:03.810 ⇒ 00:28:07.192 kim todaro: Under the shopify report like the impact, and the other affiliates
310 00:28:07.620 ⇒ 00:28:08.310 Luke Daque: Yes.
311 00:28:08.840 ⇒ 00:28:21.740 kim todaro: Yep, if you need my help with any of that, we can even like group that marketing those marketing costs for another day. And if you want to work on this stuff, whatever is easiest for you, I’m here just to to help. I feel like we’re we’re making good progress, though.
312 00:28:22.270 ⇒ 00:28:31.760 Luke Daque: Okay, cool. Yeah. At least, we get to be the same page as well. Like to using ship date instead of order, date for shipments and stuff like that.
313 00:28:31.890 ⇒ 00:28:34.549 kim todaro: And the and using unleashed versus shopify. So, yeah.
314 00:28:34.550 ⇒ 00:28:36.070 Luke Daque: Yeah, yeah, yeah, cool.
315 00:28:36.200 ⇒ 00:28:37.720 Luke Daque: And I think we also like.
316 00:28:37.910 ⇒ 00:28:53.150 Luke Daque: I think we’re still in I’m still discussing with Steven from the Amazon side for the returns, because I believe, yeah, maybe he’s also like confused, which ones to use, whether it’s the order date or the re return date or refund date, basically.
317 00:28:53.600 ⇒ 00:28:53.990 kim todaro: Yeah.
318 00:28:53.990 ⇒ 00:28:57.000 Luke Daque: And yeah, I think that should be.
319 00:28:57.210 ⇒ 00:29:01.600 Luke Daque: yeah, there’s there’s still a lot of things to to work on. So okay, do that.
320 00:29:02.840 ⇒ 00:29:05.110 kim todaro: Alright. Well, thank you so much.
321 00:29:05.490 ⇒ 00:29:08.309 Luke Daque: Thanks as well, thanks thanks very much. Chuck.
322 00:29:08.310 ⇒ 00:29:09.800 Chuck Gross: Thanks. Thanks. Everyone.
323 00:29:10.160 ⇒ 00:29:10.860 Amber Lin: And thank you.
324 00:29:11.700 ⇒ 00:29:12.370 Luke Daque: Bye-bye.
325 00:29:18.520 ⇒ 00:29:22.170 Amber Lin: Hello! Thank you for leading that meeting. I was doing.
326 00:29:22.170 ⇒ 00:29:22.600 Luke Daque: No worries.
327 00:29:22.600 ⇒ 00:29:30.931 Amber Lin: I was doing the tickets, and I am completely relying on my note taking app to figure things out.
328 00:29:32.680 ⇒ 00:29:33.530 Luke Daque: Yes.
329 00:29:33.870 ⇒ 00:29:34.340 Amber Lin: Yeah.
330 00:29:34.340 ⇒ 00:29:35.760 Luke Daque: And looks like we’re pretty
331 00:29:35.890 ⇒ 00:29:40.332 Luke Daque: to be honest, I think. We’re pretty good in terms of the numbers.
332 00:29:41.010 ⇒ 00:29:41.660 Amber Lin: Okay.
333 00:29:42.660 ⇒ 00:29:51.270 Luke Daque: Yeah, like, yeah, I would, I would think our shipment data is correct, based just basing on
334 00:29:51.780 ⇒ 00:29:52.580 Luke Daque: like
335 00:29:53.560 ⇒ 00:30:00.369 Luke Daque: what we had before. Like Chuck already verified the numbers and like before. And like he was already okay with it.
336 00:30:00.480 ⇒ 00:30:01.630 Luke Daque: Oh, okay.
337 00:30:02.380 ⇒ 00:30:04.469 Luke Daque: But yeah, I’ll have to.
338 00:30:04.470 ⇒ 00:30:25.390 Amber Lin: Yeah, let me go back to ben’s request from a while ago, just to make sure that we can satisfy all his needs. Cause, I think, when he came, when he came to us, very, very angry, he was asking to. I want to see a full report of Amazon profitability for March
339 00:30:25.510 ⇒ 00:30:30.879 Amber Lin: sales, cogs, marketing. Spend Amazon fees. That’s number one.
340 00:30:31.510 ⇒ 00:30:32.490 Luke Daque: Oh!
341 00:30:32.790 ⇒ 00:30:33.610 Amber Lin: Then.
342 00:30:33.610 ⇒ 00:30:38.670 Luke Daque: We should have, which we should already have. But it’s just the data accuracy that we
343 00:30:39.340 ⇒ 00:30:44.060 Luke Daque: need to like. Make sure right?
344 00:30:45.030 ⇒ 00:30:45.600 Amber Lin: Hmm.
345 00:30:45.600 ⇒ 00:30:47.759 Luke Daque: Let me try to share my screen again.
346 00:30:49.630 ⇒ 00:30:50.570 Amber Lin: Let me see.
347 00:30:51.810 ⇒ 00:31:00.550 Luke Daque: Because we already have sales profitability. We have sales. We have cogs, discounts, marketing which need to be up to update shipments, refunds.
348 00:31:00.990 ⇒ 00:31:04.560 Luke Daque: and then, like profitability.
349 00:31:09.490 ⇒ 00:31:12.390 Amber Lin: So that’s getting more accurate now, right.
350 00:31:13.170 ⇒ 00:31:13.755 Luke Daque: Yeah.
351 00:31:14.340 ⇒ 00:31:14.780 Amber Lin: Let me see.
352 00:31:14.780 ⇒ 00:31:15.610 Luke Daque: Should be.
353 00:31:18.400 ⇒ 00:31:26.529 Amber Lin: And so he was like, I’m just reading what he says. So all I want is to access full profitability, including all things. From
354 00:31:26.820 ⇒ 00:31:39.309 Amber Lin: Monday, 12 Am. Till now. I want to see accurate in a dashboard. He wants to dig into those numbers on shopify Asap, he said. I need to be able to push a button and have it.
355 00:31:39.960 ⇒ 00:31:43.760 Luke Daque: Which is, which is already this one. Right? You can just push a button here.
356 00:31:43.760 ⇒ 00:31:44.340 Amber Lin: Yes.
357 00:31:44.340 ⇒ 00:31:47.320 Luke Daque: Amazon. Amazon Shopify.
358 00:31:47.320 ⇒ 00:31:48.920 Amber Lin: That’s what I thought.
359 00:31:50.370 ⇒ 00:31:53.639 Amber Lin: Maybe he didn’t understand how to use this. But oh, well,
360 00:31:55.080 ⇒ 00:31:57.280 Amber Lin: How off are we right now?
361 00:32:00.049 ⇒ 00:32:03.639 Luke Daque: That’s a good question. Like, if we look at Amazon.
362 00:32:04.740 ⇒ 00:32:07.450 Luke Daque: Stephen did say this might be off.
363 00:32:08.300 ⇒ 00:32:16.480 Amber Lin: Oh, so he said. The order sales for March, for Amazon can be off.
364 00:32:19.035 ⇒ 00:32:20.040 Luke Daque: I I guess.
365 00:32:20.040 ⇒ 00:32:24.205 Amber Lin: Yeah, for our notes. App. That’s all.
366 00:32:24.800 ⇒ 00:32:38.060 Luke Daque: What we can do here, because this is already calculated like this is already gross price, gross price minus refunds and returns and we have gross price, only so maybe we can have a
367 00:32:39.730 ⇒ 00:32:44.150 Luke Daque: another field here like we can name this gross sales, and then
368 00:32:45.280 ⇒ 00:32:46.220 Amber Lin: Hmm.
369 00:32:46.690 ⇒ 00:32:51.980 Luke Daque: Net sales. I guess I don’t know what we how we call the sales minus the refunds, and.
370 00:32:51.980 ⇒ 00:32:53.010 Amber Lin: Oh!
371 00:32:54.310 ⇒ 00:32:55.589 Luke Daque: And discounts.
372 00:32:55.590 ⇒ 00:32:59.789 Amber Lin: What is sales minus refunds?
373 00:33:00.080 ⇒ 00:33:01.740 Luke Daque: Net sales, I would say.
374 00:33:14.420 ⇒ 00:33:14.970 Amber Lin: Thank you.
375 00:33:14.970 ⇒ 00:33:15.480 Luke Daque: We can name it.
376 00:33:15.480 ⇒ 00:33:22.419 Amber Lin: Yeah, net sales is the result of gross sales minus all sales, returns, allowances and discounts. Yeah, so net sales.
377 00:33:23.770 ⇒ 00:33:27.639 Luke Daque: Either we can name it net sales or ordered sales, so it would be the same
378 00:33:28.750 ⇒ 00:33:30.750 Luke Daque: language as what they’re using.
379 00:33:30.750 ⇒ 00:33:33.299 Amber Lin: Sure. Sure. Yeah, we can use that.
380 00:33:34.620 ⇒ 00:33:40.830 Amber Lin: We do that? Would it be the same number and.
381 00:33:40.830 ⇒ 00:33:45.059 Luke Daque: At the moment, not as we’re still higher a bit, because it’s hundreds.
382 00:33:46.060 ⇒ 00:33:51.200 Amber Lin: Minus no discounts, minus 12 pretty.
383 00:33:51.200 ⇒ 00:33:53.670 Luke Daque: So that’s like a hundred 65 or something.
384 00:33:53.670 ⇒ 00:33:56.199 Amber Lin: Yeah, I see.
385 00:33:56.890 ⇒ 00:34:00.939 Luke Daque: Which is, which also aligns to what Steven
386 00:34:01.960 ⇒ 00:34:06.530 Luke Daque: message? Right? Let me just open that email.
387 00:34:08.270 ⇒ 00:34:09.650 Luke Daque: What was that.
388 00:34:09.659 ⇒ 00:34:13.379 Amber Lin: Were we able to send him the documents yesterday?
389 00:34:13.719 ⇒ 00:34:15.982 Luke Daque: Yeah, I did send him that.
390 00:34:16.469 ⇒ 00:34:22.109 Luke Daque: I CC’d you because he just messaged me in in the. He just sent me an email.
391 00:34:22.219 ⇒ 00:34:23.429 Luke Daque: Nobody knows which thing.
392 00:34:23.429 ⇒ 00:34:25.139 Amber Lin: Okay, yeah. Let me check.
393 00:34:26.110 ⇒ 00:34:29.520 Luke Daque: Yeah.
394 00:34:40.969 ⇒ 00:34:45.869 Luke Daque: he said, with the discrepancies in returns. If the returns made in the month.
395 00:34:49.639 ⇒ 00:34:50.559 Amber Lin: Hmm.
396 00:34:55.960 ⇒ 00:34:57.449 Amber Lin: so are we?
397 00:34:58.690 ⇒ 00:35:03.910 Amber Lin: Wait what? It’s why doesn’t it be
398 00:35:08.540 ⇒ 00:35:12.580 Amber Lin: okay? His snapshot is taken at April 8.th
399 00:35:14.970 ⇒ 00:35:19.990 Amber Lin: Total product sales. That looks decently close to what we have right.
400 00:35:19.990 ⇒ 00:35:22.850 Luke Daque: It’s act. It’s actually very close, like, if.
401 00:35:22.850 ⇒ 00:35:23.860 Amber Lin: Right.
402 00:35:24.080 ⇒ 00:35:25.230 Luke Daque: We are at 1 70.
403 00:35:25.230 ⇒ 00:35:28.980 Amber Lin: Answering to April 8.th So can we try April 8th
404 00:35:29.550 ⇒ 00:35:34.509 Amber Lin: like, what? What days are he is he filtering for? Oh, yeah, that’s right.
405 00:35:34.510 ⇒ 00:35:38.869 Amber Lin: It’s like he’s for the same day. That’s pretty much it.
406 00:35:38.870 ⇒ 00:35:42.400 Luke Daque: Yeah, that’s pretty much it for the gross sales.
407 00:35:43.060 ⇒ 00:35:46.099 Luke Daque: 176. So we should be good with this.
408 00:35:46.310 ⇒ 00:35:57.350 Amber Lin: Okay? And then what is the other number like minus discounts? Order sales should be right. Right? He has a hundred 60 k.
409 00:35:57.980 ⇒ 00:35:59.000 Amber Lin: Right?
410 00:35:59.810 ⇒ 00:36:08.590 Luke Daque: I mean, yeah, this is another. This is February. He thinks but.
411 00:36:12.230 ⇒ 00:36:15.239 Amber Lin: Building under refund we have minus.
412 00:36:16.060 ⇒ 00:36:23.700 Amber Lin: Oh, the remaining amount after the refunds is a hundred 72.
413 00:36:23.850 ⇒ 00:36:28.010 Amber Lin: Okay, so refunds is 11 K. Is that what we have.
414 00:36:28.980 ⇒ 00:36:29.530 Luke Daque: We have.
415 00:36:29.530 ⇒ 00:36:30.819 Amber Lin: We’ll do that. Right? 12.
416 00:36:30.820 ⇒ 00:36:33.880 Amber Lin: Okay, pretty close, pretty close.
417 00:36:35.710 ⇒ 00:36:39.620 Amber Lin: oh, I, see, oh, okay, 106, 7.
418 00:36:39.620 ⇒ 00:36:45.429 Luke Daque: If the return is made in the month in the time period it is negated. I see.
419 00:36:45.430 ⇒ 00:36:46.070 Amber Lin: Need.
420 00:36:48.630 ⇒ 00:36:56.639 Luke Daque: So I think what he means is they’re using the order date
421 00:36:56.950 ⇒ 00:37:00.635 Luke Daque: to get the returns, because what what I was doing is
422 00:37:01.450 ⇒ 00:37:02.880 Amber Lin: We’re using the.
423 00:37:03.140 ⇒ 00:37:04.500 Luke Daque: Return date.
424 00:37:05.190 ⇒ 00:37:05.930 Amber Lin: No.
425 00:37:05.930 ⇒ 00:37:12.460 Luke Daque: The the order date so cause it that an order can be made in February. But then return in March.
426 00:37:12.680 ⇒ 00:37:16.349 Luke Daque: and I would be counting that in in March I thought.
427 00:37:16.470 ⇒ 00:37:19.589 Luke Daque: according to this, from what I understand is
428 00:37:20.160 ⇒ 00:37:22.800 Luke Daque: that would be counted in February, right.
429 00:37:23.230 ⇒ 00:37:29.079 Amber Lin: Return is in. So if the return is made in March, it’s excluded.
430 00:37:29.870 ⇒ 00:37:31.960 Luke Daque: Yeah, something like that right?
431 00:37:32.440 ⇒ 00:37:37.369 Luke Daque: Which makes well, does it make sense? I don’t know.
432 00:37:37.370 ⇒ 00:37:40.610 Luke Daque: I don’t. I don’t think it’s the best way
433 00:37:41.900 ⇒ 00:37:46.369 Luke Daque: they they would be missing out on the returns that were made in
434 00:37:47.280 ⇒ 00:37:56.000 Luke Daque: February, but got returned in March right that that wouldn’t show up in February, because it wasn’t returned yet in February, or something like that.
435 00:37:56.000 ⇒ 00:38:10.209 Amber Lin: Yeah. So essentially, they’re only counting the returns from the last month. If they’re say, example of March right? If the return is made in March is negated out, so that means they only include the returns from February.
436 00:38:12.150 ⇒ 00:38:12.970 Amber Lin: I’m confused.
437 00:38:12.970 ⇒ 00:38:13.600 Luke Daque: Bizarre.
438 00:38:17.540 ⇒ 00:38:19.869 Luke Daque: Let me try to query.
439 00:38:20.780 ⇒ 00:38:22.609 Amber Lin: Yeah, cause as long as we match.
440 00:38:22.610 ⇒ 00:38:23.580 Luke Daque: And.
441 00:38:23.580 ⇒ 00:38:25.180 Amber Lin: Shouldn’t make sense.
442 00:38:25.180 ⇒ 00:38:28.970 Luke Daque: Based on the order, the calendar automatically to.
443 00:38:30.260 ⇒ 00:38:34.459 Luke Daque: Maybe just return dates in February.
444 00:38:35.340 ⇒ 00:38:35.920 Luke Daque: Yeah.
445 00:38:43.330 ⇒ 00:38:46.119 Luke Daque: Like this is a phone number.
446 00:38:46.890 ⇒ 00:38:54.160 Amber Lin: Like. I don’t understand what that sentence means, where I understand, but it doesn’t make sense to me. Why, they would exclude March.
447 00:38:55.640 ⇒ 00:38:56.460 Luke Daque: Yeah.
448 00:39:07.580 ⇒ 00:39:08.230 Luke Daque: there you go.
449 00:39:17.400 ⇒ 00:39:20.970 Luke Daque: But if that’s working on how they are like calculating it, then
450 00:39:21.560 ⇒ 00:39:24.750 Luke Daque: I guess we should calculate it the same way.
451 00:39:28.400 ⇒ 00:39:29.820 Luke Daque: That’s see here.
452 00:39:31.870 ⇒ 00:39:33.809 Amber Lin: This show you the total.
453 00:39:36.940 ⇒ 00:39:40.749 Luke Daque: So we pointed out some of the product right?
454 00:39:53.970 ⇒ 00:39:56.359 Luke Daque: 12, 7, 17. Still.
455 00:40:00.990 ⇒ 00:40:03.090 Luke Daque: it’s even larger.
456 00:40:03.950 ⇒ 00:40:04.990 Amber Lin: Yeah.
457 00:40:05.940 ⇒ 00:40:10.790 Luke Daque: Oh, wait! It should be not February right.
458 00:40:11.502 ⇒ 00:40:12.380 Amber Lin: What’d you say?
459 00:40:15.070 ⇒ 00:40:20.129 Luke Daque: Cause, he said. It’s gonna be negated if it’s returned in the same month.
460 00:40:22.680 ⇒ 00:40:26.570 Amber Lin: What is? Neg? Let me search. What does negate mean?
461 00:40:28.770 ⇒ 00:40:33.979 Luke Daque: I think he he just means it’s gonna be subtracting something.
462 00:40:33.980 ⇒ 00:40:39.289 Amber Lin: Gated means nullify and make ineffective. So I guess he’s meaning.
463 00:40:40.950 ⇒ 00:40:44.980 Luke Daque: I wonder if it’s not the refund amount, but the sales amount.
464 00:40:45.790 ⇒ 00:40:54.639 Amber Lin: Oh, so he means negated as in. If this thing is ordered and returned in the same month, we just cancel out.
465 00:40:56.450 ⇒ 00:40:57.370 Luke Daque: Melt.
466 00:40:57.540 ⇒ 00:40:58.290 Luke Daque: We’re.
467 00:40:58.290 ⇒ 00:40:59.150 Amber Lin: Oh!
468 00:40:59.610 ⇒ 00:41:02.050 Luke Daque: Up to this province.
469 00:41:02.050 ⇒ 00:41:04.009 Amber Lin: Oh, oh, wow!
470 00:41:06.350 ⇒ 00:41:08.950 Luke Daque: Yeah, 11, 5, 5, 5, right?
471 00:41:08.950 ⇒ 00:41:10.130 Amber Lin: Jake.
472 00:41:10.620 ⇒ 00:41:12.850 Luke Daque: 11, 6, 6, 5. We are.
473 00:41:13.180 ⇒ 00:41:14.660 Luke Daque: I guess, like a hundred dollars.
474 00:41:14.660 ⇒ 00:41:15.290 Amber Lin: I think we’re.
475 00:41:15.290 ⇒ 00:41:15.769 Luke Daque: Thank you.
476 00:41:15.770 ⇒ 00:41:19.010 Amber Lin: One product off. That’s it. I think this is great.
477 00:41:19.770 ⇒ 00:41:25.049 Luke Daque: So motion document to make sure that we are.
478 00:41:25.700 ⇒ 00:41:29.189 Luke Daque: I don’t forget, re-refund.
479 00:41:29.190 ⇒ 00:41:35.899 Amber Lin: Write down this, of making sure that what he means about negated is true.
480 00:41:39.520 ⇒ 00:41:41.480 Luke Daque: So
481 00:41:44.860 ⇒ 00:41:48.289 Luke Daque: so the actual task here is 2.
482 00:41:53.680 ⇒ 00:42:01.310 Luke Daque: If the thank you and purpose that, let me just copy what he said.
483 00:42:03.750 ⇒ 00:42:04.330 Amber Lin: Hmm!
484 00:42:13.060 ⇒ 00:42:17.520 Amber Lin: In the same month. I guess if the return is made in the same month.
485 00:42:20.720 ⇒ 00:42:23.860 Amber Lin: The original sales price is negated out.
486 00:42:26.580 ⇒ 00:42:27.350 Amber Lin: It’s telling me.
487 00:42:27.350 ⇒ 00:42:28.579 Luke Daque: What’s the actual.
488 00:42:33.370 ⇒ 00:42:38.949 Amber Lin: Oh, this is kind of fun, I mean, only because I don’t do it 40 HA week.
489 00:42:39.260 ⇒ 00:42:39.800 Luke Daque: Yeah.
490 00:42:43.100 ⇒ 00:42:45.870 Luke Daque: So yeah, they should be, yeah, they should be doable.
491 00:42:46.390 ⇒ 00:42:47.410 Amber Lin: Okay, that’s good.
492 00:42:47.410 ⇒ 00:42:48.000 Luke Daque: Awesome.
493 00:42:50.710 ⇒ 00:42:55.759 Amber Lin: So that would also change the profitability to make it match.
494 00:42:56.930 ⇒ 00:42:57.940 Luke Daque: Yeah.
495 00:42:57.940 ⇒ 00:42:58.340 Amber Lin: Okay.
496 00:42:58.340 ⇒ 00:42:58.800 Luke Daque: Yes.
497 00:42:59.010 ⇒ 00:43:02.049 Amber Lin: We want to add a net sales
498 00:43:02.985 ⇒ 00:43:08.340 Amber Lin: field, and probably call it border, whatever they call it.
499 00:43:08.690 ⇒ 00:43:11.570 Amber Lin: and then show them that they have this.
500 00:43:11.570 ⇒ 00:43:12.530 Luke Daque: Oh, snack!
501 00:43:19.710 ⇒ 00:43:20.689 Luke Daque: Let me see that.
502 00:43:20.690 ⇒ 00:43:30.979 Amber Lin: Yeah, I guess we could have net sales and net profit to make it make more sense, ordered sales.
503 00:43:32.160 ⇒ 00:43:36.069 Amber Lin: Yeah, we can just use their language. As long as we understand.
504 00:43:37.500 ⇒ 00:43:38.210 Luke Daque: Yeah.
505 00:43:38.440 ⇒ 00:43:39.590 Amber Lin: The next.
506 00:43:39.850 ⇒ 00:43:43.669 Luke Daque: Thing. Yeah. So I say, I think we should be good here.
507 00:43:43.810 ⇒ 00:43:45.980 Amber Lin: Refunds, returns.
508 00:43:48.230 ⇒ 00:43:51.450 Amber Lin: Do we have a margin on the dashboard?
509 00:43:51.590 ⇒ 00:43:53.149 Amber Lin: Just a quick question.
510 00:43:54.690 ⇒ 00:43:55.589 Luke Daque: What do you mean?
511 00:43:56.975 ⇒ 00:44:01.230 Amber Lin: A margin, you know, on their on their table, so
512 00:44:01.340 ⇒ 00:44:06.080 Amber Lin: on your second tab. 3rd table has a sorry. The the spreadsheet.
513 00:44:07.030 ⇒ 00:44:07.590 Luke Daque: Oh!
514 00:44:07.590 ⇒ 00:44:16.500 Amber Lin: Especially they have a column that says margins. So column S column.
515 00:44:16.500 ⇒ 00:44:21.420 Luke Daque: Just profit divided by or like, yeah, one.
516 00:44:21.420 ⇒ 00:44:29.519 Amber Lin: That one. There’s 1. i guess that’s the same. Is that different than, oh, okay, the other one’s 2024 data. Yeah.
517 00:44:29.960 ⇒ 00:44:32.320 Amber Lin: Like, maybe we should have Martin.
518 00:44:32.930 ⇒ 00:44:44.940 Amber Lin: Yeah. So we add the order to sales. We can add the margins in which would be a little, make a little bit more sense to Ben, or whoever is not, who’s not looking that detail.
519 00:44:45.250 ⇒ 00:44:46.459 Luke Daque: A big margin.
520 00:44:46.790 ⇒ 00:44:47.390 Amber Lin: Hmm.
521 00:44:49.150 ⇒ 00:44:54.219 Luke Daque: Divided by Groce, one group, Stance.
522 00:44:54.570 ⇒ 00:44:59.440 Amber Lin: Oh, do we add it to do to add the order sales as well.
523 00:44:59.960 ⇒ 00:45:01.240 Luke Daque: Yeah, I know.
524 00:45:02.180 ⇒ 00:45:02.930 Amber Lin: Great
525 00:45:08.020 ⇒ 00:45:14.590 Amber Lin: quarter sales is net, which is gross sales minus refunds and discounts.
526 00:45:16.020 ⇒ 00:45:19.360 Amber Lin: And just I, yeah discounts
527 00:45:22.520 ⇒ 00:45:23.690 Amber Lin: yay.
528 00:45:24.440 ⇒ 00:45:26.840 Luke Daque: That’s Amazon’s pretty good, it seems.
529 00:45:27.870 ⇒ 00:45:28.350 Luke Daque: Yeah.
530 00:45:28.350 ⇒ 00:45:34.750 Amber Lin: Also did shopify, how shopify and the shipping thing for today.
531 00:45:38.790 ⇒ 00:45:42.150 Luke Daque: Shopify shipping versus shipping.
532 00:45:43.770 ⇒ 00:45:47.539 Amber Lin: Oh, well, we talked about with Chuck today. I I wasn’t sure what what we have.
533 00:45:53.182 ⇒ 00:46:00.689 Luke Daque: I think we’re we’re good in terms of like, we are already using this ship date as the
534 00:46:03.130 ⇒ 00:46:07.049 Luke Daque: like the the to be able to calculate the sales.
535 00:46:07.210 ⇒ 00:46:07.710 Amber Lin: Hmm.
536 00:46:09.140 ⇒ 00:46:10.160 Luke Daque: And like
537 00:46:11.140 ⇒ 00:46:20.490 Luke Daque: and ship station, I think, Chuck already confirmed, it was correct. So we haven’t had the correct numbers for me. I guess the units investigate missing
538 00:46:21.890 ⇒ 00:46:23.640 Luke Daque: unice shipments
539 00:46:29.060 ⇒ 00:46:30.440 Luke Daque: with shopify.
540 00:46:31.120 ⇒ 00:46:40.230 Luke Daque: The thing is, I can’t remember what orders we were looking at.
541 00:46:42.210 ⇒ 00:46:45.260 Luke Daque: We should have it in the recording. I can. I can add it.
542 00:46:45.700 ⇒ 00:46:47.220 Luke Daque: Okay. Great recording
543 00:46:51.080 ⇒ 00:46:55.319 Luke Daque: number 2, like 8, 8, 6, 6, something, 4, 4. I don’t know.
544 00:46:56.250 ⇒ 00:46:56.850 Amber Lin: Hmm.
545 00:46:57.950 ⇒ 00:47:03.420 Luke Daque: But I’ll have it here, but aside from that, I think we should be good for shipments.
546 00:47:04.519 ⇒ 00:47:07.810 Luke Daque: I think the for the Amazon, though I think the
547 00:47:07.940 ⇒ 00:47:13.360 Luke Daque: more challenging part is is the missing campaigns.
548 00:47:13.360 ⇒ 00:47:14.500 Amber Lin: Oh, okay.
549 00:47:14.795 ⇒ 00:47:17.450 Luke Daque: I’ll have to look into this. Why we are.
550 00:47:17.850 ⇒ 00:47:21.559 Luke Daque: It looks like we’re not getting it from even from the raw data source.
551 00:47:21.570 ⇒ 00:47:23.130 Amber Lin: I see so.
552 00:47:23.130 ⇒ 00:47:24.560 Luke Daque: And also this one.
553 00:47:28.630 ⇒ 00:47:29.990 Amber Lin: Ask for them.
554 00:47:30.170 ⇒ 00:47:34.209 Amber Lin: I see. Have we asked lutam? Yet if not, I can go Nag him.
555 00:47:35.160 ⇒ 00:47:43.390 Luke Daque: We can ask, but maybe maybe I’ll do some investigation first, st and if I I don’t see anything, then maybe that’s time you can ask.
556 00:47:43.390 ⇒ 00:47:44.630 Amber Lin: Okay. Sounds.
557 00:47:47.100 ⇒ 00:47:49.500 Luke Daque: And then, yeah, that should be.
558 00:47:51.260 ⇒ 00:47:51.980 Amber Lin: Cool.
559 00:47:52.930 ⇒ 00:47:54.420 Luke Daque: Should be available.
560 00:47:54.420 ⇒ 00:47:55.360 Amber Lin: Noble
561 00:47:58.000 ⇒ 00:48:06.290 Amber Lin: do you want to talk about? I know you’re super tired. It’s probably really late for you. I know Utam sent something to you about the.
562 00:48:06.290 ⇒ 00:48:07.080 Luke Daque: Yeah.
563 00:48:07.280 ⇒ 00:48:07.840 Amber Lin: Dash.
564 00:48:07.840 ⇒ 00:48:09.690 Luke Daque: Us about the.
565 00:48:12.240 ⇒ 00:48:16.380 Luke Daque: Staging or like dev environment for real. I think we already have a
566 00:48:16.540 ⇒ 00:48:20.039 Luke Daque: ticket for that. Let me just didn’t do anything yet.
567 00:48:20.460 ⇒ 00:48:21.220 Amber Lin: Yeah.
568 00:48:21.220 ⇒ 00:48:23.049 Luke Daque: Just trying to find it.
569 00:48:23.050 ⇒ 00:48:28.670 Luke Daque: Message this one, this one great staging and production will dashboard for testing.
570 00:48:29.500 ⇒ 00:48:35.450 Luke Daque: So we can put this in. This is currently in our requirements started
571 00:48:35.570 ⇒ 00:48:37.959 Luke Daque: face, we can maybe put this in
572 00:48:38.120 ⇒ 00:48:40.946 Luke Daque: ready for development so that we can.
573 00:48:41.350 ⇒ 00:48:50.659 Amber Lin: Hearing the tickets. That’s so helpful I am. I am so stuck with the ABC stuff right now because they’re doing rollout. So thank you for doing that?
574 00:48:52.030 ⇒ 00:48:53.040 Amber Lin: What did autumn?
575 00:48:53.630 ⇒ 00:48:55.409 Amber Lin: Exactly? What is it for.
576 00:48:57.160 ⇒ 00:49:03.590 Luke Daque: So basically what he’s he said here. So I think this was a request from Ann, or
577 00:49:03.760 ⇒ 00:49:05.020 Luke Daque: what’s it? Then.
578 00:49:06.660 ⇒ 00:49:09.890 Amber Lin: Go to you. Don’t team.
579 00:49:10.720 ⇒ 00:49:18.170 Luke Daque: And oh, that was in data team, Annie.
580 00:49:20.370 ⇒ 00:49:21.520 Luke Daque: Oh.
581 00:49:23.750 ⇒ 00:49:25.950 Amber Lin: Where is it? Let’s see.
582 00:49:27.300 ⇒ 00:49:34.539 Luke Daque: So. Yes, a Pr reviewer. When we make a change to will, I want to be able to test the change before approving.
583 00:49:36.960 ⇒ 00:49:37.860 Luke Daque: So
584 00:49:41.910 ⇒ 00:49:44.749 Luke Daque: yeah. The thing, the the thing with real is.
585 00:49:45.870 ⇒ 00:49:48.719 Amber Lin: Like how it’s currently set up is the.
586 00:49:51.330 ⇒ 00:49:54.147 Luke Daque: I’m not sure how to explain this, but like
587 00:49:55.270 ⇒ 00:49:58.890 Luke Daque: any change you may make, you may have to do it locally.
588 00:49:59.690 ⇒ 00:50:03.879 Luke Daque: Oh, I you can’t see it in yeah, in the real dashboard yet.
589 00:50:04.280 ⇒ 00:50:10.240 Luke Daque: So for for anyone reviewing the changes, they won’t be able to see what the changes are.
590 00:50:10.600 ⇒ 00:50:11.230 Amber Lin: Yeah, it’s great.
591 00:50:11.230 ⇒ 00:50:14.179 Luke Daque: It’s pushed to prime. So that’s why I like.
592 00:50:14.890 ⇒ 00:50:15.790 Luke Daque: How do we.
593 00:50:16.250 ⇒ 00:50:24.450 Amber Lin: I mean, if it’s a if we get a branch and just have them deployed to a separate branch, would that work.
594 00:50:25.819 ⇒ 00:50:30.719 Luke Daque: I think real does have documentation on like creating, staging.
595 00:50:30.720 ⇒ 00:50:32.819 Amber Lin: Oh, let me search that up.
596 00:50:37.150 ⇒ 00:50:38.790 Luke Daque: Well, somewhere here.
597 00:50:40.350 ⇒ 00:50:41.040 Luke Daque: Interesting?
598 00:50:42.710 ⇒ 00:50:43.779 Luke Daque: No, it is.
599 00:50:48.770 ⇒ 00:50:49.940 Luke Daque: Take it this way.
600 00:51:02.130 ⇒ 00:51:04.189 Amber Lin: Looking at there.
601 00:51:05.740 ⇒ 00:51:08.830 Amber Lin: Oh, yeah.
602 00:51:22.780 ⇒ 00:51:23.530 Luke Daque: Okay.
603 00:51:46.090 ⇒ 00:51:51.270 Amber Lin: I’m also reading this page. I’m not sure it’ll be.
604 00:51:51.440 ⇒ 00:51:54.649 Amber Lin: It’s the right one. But I’ll send the link to you.
605 00:51:56.830 ⇒ 00:52:02.639 Luke Daque: Sure I can just add this to the ticket, so I can be saying.
606 00:52:02.790 ⇒ 00:52:03.380 Amber Lin: Yeah.
607 00:52:04.940 ⇒ 00:52:08.140 Luke Daque: There’s good thinking on.
608 00:52:10.990 ⇒ 00:52:12.929 Luke Daque: And where did you send me this song?
609 00:52:13.320 ⇒ 00:52:14.190 Amber Lin: In slack.
610 00:52:16.950 ⇒ 00:52:22.999 Luke Daque: Yeah, this one. This is the the production deploy. Basically.
611 00:52:24.790 ⇒ 00:52:27.850 Luke Daque: this is what we are already doing at the moment.
612 00:52:27.850 ⇒ 00:52:28.560 Amber Lin: Oh, okay.
613 00:52:28.560 ⇒ 00:52:30.870 Luke Daque: But but yeah, this is.
614 00:52:30.870 ⇒ 00:52:37.299 Amber Lin: If we scroll down, they have a push to a certain branch. I don’t know if that’s
615 00:52:37.770 ⇒ 00:52:44.349 Amber Lin: probably lowered down like a continuous deployment changing production branch.
616 00:52:45.200 ⇒ 00:52:46.370 Amber Lin: Not sure.
617 00:52:49.820 ⇒ 00:52:52.360 Amber Lin: like, if we deploy to a different branch.
618 00:52:52.580 ⇒ 00:52:55.700 Amber Lin: and then they review it, and then they merged a branch.
619 00:52:59.110 ⇒ 00:53:06.610 Luke Daque: But that would affect the actually real down. But yeah, I’ll test it out. I’ll see what this does.
620 00:53:06.610 ⇒ 00:53:07.240 Amber Lin: Okay.
621 00:53:08.290 ⇒ 00:53:09.030 Luke Daque: And.
622 00:53:13.390 ⇒ 00:53:14.690 Amber Lin: All shared.
623 00:53:17.030 ⇒ 00:53:21.670 Amber Lin: Let me see where the ticket is, and then I’ll share it with Tom.
624 00:53:22.560 ⇒ 00:53:23.620 Amber Lin: Oh.
625 00:53:24.500 ⇒ 00:53:35.759 Luke Daque: It’s this one. And we we also have, like our the real team. We can use as resource. Maybe we can even schedule a call with them to help us through with creating a staging.
626 00:53:36.590 ⇒ 00:53:37.670 Amber Lin: Yeah. Why don’t we.
627 00:53:37.670 ⇒ 00:53:38.270 Luke Daque: Dashboard!
628 00:53:38.270 ⇒ 00:53:42.020 Amber Lin: Question. There, let’s just give them the question. They respond.
629 00:53:42.020 ⇒ 00:53:42.650 Luke Daque: Yeah.
630 00:53:42.650 ⇒ 00:53:44.500 Amber Lin: Be pretty nicely.
631 00:53:49.640 ⇒ 00:53:52.969 Luke Daque: Maybe we can ask them if they can walk us through creating a
632 00:53:54.420 ⇒ 00:53:56.830 Amber Lin: That. Are you in the vendor? Real channel.
633 00:53:57.140 ⇒ 00:54:02.439 Luke Daque: Yeah, I am okay. Can you ask that? I don’t know too much of the technical requirements?
634 00:54:11.840 ⇒ 00:54:17.830 Luke Daque: Let me just copy everything. I’m just changing. So turn out, then when don’t know?
635 00:54:19.980 ⇒ 00:54:21.140 Luke Daque: Hi.
636 00:54:54.000 ⇒ 00:54:59.830 Luke Daque: I’m trying to email, I mean,
637 00:55:37.330 ⇒ 00:55:38.160 Luke Daque: okay.
638 00:55:39.540 ⇒ 00:55:48.469 Amber Lin: Okay, awesome. I think that’s it for this. Well, we can experiment, but probably it’s best to
639 00:55:48.780 ⇒ 00:55:56.060 Amber Lin: wait for them to respond. If they do, because I know you. You have so much other stuff on your plate, too.
640 00:55:56.500 ⇒ 00:56:02.269 Luke Daque: Cool. I haven’t checked stack bits yet. But let me let me just quickly check. I I believe.
641 00:56:04.250 ⇒ 00:56:06.059 Luke Daque: Yeah. And
642 00:56:07.280 ⇒ 00:56:13.219 Luke Daque: they didn’t mention they were, gonna create a ticket yet. Alright, but I don’t see anything new at the moment, so I don’t know.
643 00:56:14.700 ⇒ 00:56:15.620 Luke Daque: Something yes, right?
644 00:56:15.620 ⇒ 00:56:21.369 Amber Lin: Probably something in the slack channel. But there’s let me go check the slack channel.
645 00:56:21.960 ⇒ 00:56:27.389 Amber Lin: They said, Da, Da.
646 00:56:28.660 ⇒ 00:56:44.439 Amber Lin: yeah, he said yesterday, he’s gonna create 2 issues shortly asking for data, modeling advice in 2 areas about his model historic subscription, Mrr, and create how to create a unified events. Table. Blah blah I CC.
647 00:56:44.440 ⇒ 00:56:45.010 Luke Daque: Hmm.
648 00:56:45.010 ⇒ 00:56:51.710 Amber Lin: I think he made a ticket, but you probably have seen it already. Yeah, that’s that one.
649 00:56:52.900 ⇒ 00:56:57.000 Luke Daque: So basically, the delivery is a complete scheme on the side.
650 00:56:58.180 ⇒ 00:56:58.750 Luke Daque: Wow.
651 00:56:58.750 ⇒ 00:57:01.860 Amber Lin: That is totally generated by AI.
652 00:57:03.160 ⇒ 00:57:05.209 Luke Daque: Yeah, yeah, for sure. But.
653 00:57:07.150 ⇒ 00:57:10.830 Amber Lin: Yeah, I mean, if you just to it, I am work something out.
654 00:57:11.650 ⇒ 00:57:13.619 Amber Lin: Figure that out. Okay.
655 00:57:15.610 ⇒ 00:57:18.630 Luke Daque: Sounds, good sounds, good issue.
656 00:57:18.630 ⇒ 00:57:19.400 Amber Lin: Great. I will.
657 00:57:20.240 ⇒ 00:57:25.540 Amber Lin: Then the update. We’re on good track, and we’re meeting with Kim tomorrow again, right.
658 00:57:26.140 ⇒ 00:57:26.760 Luke Daque: Cool.
659 00:57:26.930 ⇒ 00:57:27.530 Amber Lin: Yeah, okay.
660 00:57:27.530 ⇒ 00:57:28.220 Luke Daque: That’s good.
661 00:57:28.220 ⇒ 00:57:35.500 Luke Daque: Sounds good and urban stamps. I think they want to onboard you to there as well, since Staff was essentially dying.
662 00:57:35.900 ⇒ 00:57:37.570 Amber Lin: So we’ll probably have the meeting tomorrow.
663 00:57:38.670 ⇒ 00:57:46.839 Luke Daque: Yeah, I did notice, like Luton just added me with other channels, for instance. Okay, great sounds good.
664 00:57:46.840 ⇒ 00:57:51.298 Amber Lin: Thank you so much so much for doing the full 1st tickets.
665 00:57:51.670 ⇒ 00:57:52.600 Luke Daque: No worries, thank you.
666 00:57:52.600 ⇒ 00:58:00.050 Amber Lin: That’s my job. But I really appreciate that it really helps cause. I don’t know a lot of the technical stuff a lot of times so super helpful.
667 00:58:00.900 ⇒ 00:58:05.793 Luke Daque: No worries. Yeah, there’s still like a couple of tickets that are in.
668 00:58:07.340 ⇒ 00:58:12.000 Luke Daque: I think there’s a lot in like Pr review, which we might need to move to done.
669 00:58:12.000 ⇒ 00:58:17.629 Luke Daque: Oh, okay, I will look at them, and I will nag with them if we need reviews
670 00:58:18.270 ⇒ 00:58:23.999 Luke Daque: like the documentation. As well might need to be like moved to notion, because I just added, here.
671 00:58:24.390 ⇒ 00:58:24.780 Amber Lin: Okay.
672 00:58:24.780 ⇒ 00:58:25.610 Luke Daque: Here in the ticket.
673 00:58:25.610 ⇒ 00:58:32.210 Amber Lin: Okay, I will check, and I can move to notion. If I don’t find anything I’ll like, I’ll comment in the tickets.
674 00:58:32.940 ⇒ 00:58:38.750 Amber Lin: Cool sounds. Good good night. Asleep early. It’s very late.
675 00:58:39.370 ⇒ 00:58:42.010 Luke Daque: Have a nice rest of your day as well. Thanks, thank you.
676 00:58:42.286 ⇒ 00:58:42.840 Amber Lin: Bye, bye.
677 00:58:42.840 ⇒ 00:58:43.440 Luke Daque: Bye, bye.