Meeting Title: Zoom-Meeting Date: 2024-09-26 Meeting participants: Ryan Luke Daque, Nicolas Sucari
WEBVTT
1 00:00:19.450 ⇒ 00:00:20.370 Nicolas Sucari: Hey, Ryan.
2 00:00:24.200 ⇒ 00:00:25.320 Nicolas Sucari: can you hear me?
3 00:00:26.020 ⇒ 00:00:27.859 Ryan Luke Daque: Hi, Nicholas, how’s it going.
4 00:00:28.630 ⇒ 00:00:30.499 Nicolas Sucari: Doing good. How about you?
5 00:00:31.350 ⇒ 00:00:33.639 Ryan Luke Daque: Yeah, doing well, so far.
6 00:00:34.600 ⇒ 00:00:34.995 Nicolas Sucari: Nice.
7 00:00:35.390 ⇒ 00:00:37.020 Ryan Luke Daque: I think the week’s been
8 00:00:37.530 ⇒ 00:00:40.330 Ryan Luke Daque: we’ve been doing well the week’s been.
9 00:00:41.520 ⇒ 00:00:42.340 Nicolas Sucari: Productive.
10 00:00:42.340 ⇒ 00:00:43.170 Ryan Luke Daque: Yeah, productive?
11 00:00:43.170 ⇒ 00:00:44.070 Nicolas Sucari: Yeah.
12 00:00:44.510 ⇒ 00:00:45.560 Nicolas Sucari: yeah, I,
13 00:00:47.190 ⇒ 00:00:53.419 Nicolas Sucari: yeah. I talk about that. We do, Tom. On Tuesday we were saying like, it’s Tuesday, and we already got a lot of things
14 00:00:53.980 ⇒ 00:00:55.160 Nicolas Sucari: going on.
15 00:00:55.230 ⇒ 00:00:57.940 Nicolas Sucari: So yeah, I think it’s been really productive this week.
16 00:00:58.590 ⇒ 00:00:59.440 Ryan Luke Daque: Nice.
17 00:00:59.880 ⇒ 00:01:00.660 Nicolas Sucari: Yep.
18 00:01:00.940 ⇒ 00:01:06.330 Nicolas Sucari: hey? I was just trying to start looking into that request from
19 00:01:06.840 ⇒ 00:01:07.880 Nicolas Sucari: done.
20 00:01:08.320 ⇒ 00:01:13.430 Nicolas Sucari: But my only issue is, I don’t know if we have, like all of the information of
21 00:01:13.971 ⇒ 00:01:19.849 Nicolas Sucari: skews from unleashed ship station and that kind of stuff I’m from shopify, and I.
22 00:01:19.850 ⇒ 00:01:20.869 Ryan Luke Daque: That’s when I was.
23 00:01:20.870 ⇒ 00:01:23.769 Nicolas Sucari: Brian. I was trying to look. If we have like a product
24 00:01:23.860 ⇒ 00:01:31.040 Nicolas Sucari: table or something like that, I think we have something from shopify, but we don’t have these queues there, right? Do you know.
25 00:01:31.660 ⇒ 00:01:35.150 Ryan Luke Daque: I haven’t looked into it yet, but I I’m
26 00:01:35.950 ⇒ 00:01:41.950 Ryan Luke Daque: I wouldn’t. I would be surprised if there isn’t any, because this is like coming from
27 00:01:42.560 ⇒ 00:01:46.450 Ryan Luke Daque: shopify. So, yeah, we should have something.
28 00:01:47.150 ⇒ 00:01:51.419 Nicolas Sucari: Look because I was trying to work on these.
29 00:01:53.667 ⇒ 00:01:55.580 Nicolas Sucari: Let me see.
30 00:01:57.270 ⇒ 00:02:01.367 Ryan Luke Daque: Yeah, I’m also trying to look at this on my end.
31 00:02:03.180 ⇒ 00:02:03.970 Nicolas Sucari: Yeah.
32 00:02:04.530 ⇒ 00:02:07.350 Nicolas Sucari: I mean, we can go to databases
33 00:02:08.229 ⇒ 00:02:09.350 Nicolas Sucari: to change my role.
34 00:02:09.350 ⇒ 00:02:11.540 Ryan Luke Daque: And shopify.
35 00:02:12.450 ⇒ 00:02:14.830 Ryan Luke Daque: There’s so products
36 00:02:15.110 ⇒ 00:02:18.529 Ryan Luke Daque: pro the product table doesn’t have escape.
37 00:02:18.530 ⇒ 00:02:21.500 Nicolas Sucari: Yeah, it doesn’t have skew exactly.
38 00:02:21.500 ⇒ 00:02:25.940 Ryan Luke Daque: So maybe it’s maybe it’s somewhere else. Let’s see.
39 00:02:27.770 ⇒ 00:02:29.309 Nicolas Sucari: It’s a product option. 2.
40 00:02:29.310 ⇒ 00:02:30.729 Ryan Luke Daque: Product variant.
41 00:02:31.080 ⇒ 00:02:34.529 Ryan Luke Daque: So it looks like it’s in product variant. So yeah, we can.
42 00:02:34.760 ⇒ 00:02:39.140 Ryan Luke Daque: It has product. Id, so we can get all the skews here in.
43 00:02:39.140 ⇒ 00:02:41.169 Nicolas Sucari: No, yeah, and it has to skew.
44 00:02:41.190 ⇒ 00:02:42.349 Nicolas Sucari: Yep, sure.
45 00:02:43.130 ⇒ 00:02:47.110 Nicolas Sucari: So you say, if we do, let’s go here.
46 00:02:49.370 ⇒ 00:02:52.819 Nicolas Sucari: 5 trend database. This is jobify product.
47 00:02:53.590 ⇒ 00:02:54.165 Ryan Luke Daque: Yep.
48 00:02:58.030 ⇒ 00:03:00.909 Nicolas Sucari: So product variant. Let’s see.
49 00:03:02.280 ⇒ 00:03:07.390 Nicolas Sucari: we can get the Id. That’s something that he was requesting.
50 00:03:07.560 ⇒ 00:03:10.460 Nicolas Sucari: Product. Id, that’s different from Id.
51 00:03:10.840 ⇒ 00:03:13.559 Nicolas Sucari: Then we have this queue. Okay?
52 00:03:13.650 ⇒ 00:03:15.650 Nicolas Sucari: And then, do we have
53 00:03:16.210 ⇒ 00:03:18.040 Nicolas Sucari: product? Name?
54 00:03:18.630 ⇒ 00:03:19.810 Nicolas Sucari: No, right?
55 00:03:23.740 ⇒ 00:03:26.160 Nicolas Sucari: We’re just missing product. Name here, I think.
56 00:03:27.410 ⇒ 00:03:31.320 Ryan Luke Daque: Well, it should be in product. So we can just do a join to product.
57 00:03:32.340 ⇒ 00:03:34.300 Ryan Luke Daque: Using the product. Id.
58 00:03:34.610 ⇒ 00:03:35.879 Ryan Luke Daque: and we should have something.
59 00:03:35.880 ⇒ 00:03:38.270 Nicolas Sucari: From here, we should get
60 00:03:39.190 ⇒ 00:03:40.750 Nicolas Sucari: product. Id
61 00:03:41.780 ⇒ 00:03:43.560 Nicolas Sucari: skew right.
62 00:03:44.280 ⇒ 00:03:44.990 Nicolas Sucari: Yep.
63 00:03:45.540 ⇒ 00:03:46.460 Ryan Luke Daque: That’s fine!
64 00:03:46.460 ⇒ 00:03:48.529 Nicolas Sucari: And we have dimensions.
65 00:03:50.840 ⇒ 00:03:54.190 Ryan Luke Daque: Yeah, what? What else do we need?
66 00:03:54.690 ⇒ 00:03:56.770 Ryan Luke Daque: Wait, is there? Wait
67 00:03:58.560 ⇒ 00:03:59.650 Ryan Luke Daque: there you wait.
68 00:04:01.820 ⇒ 00:04:05.300 Ryan Luke Daque: Yeah, cause it can be in kilograms or in pounds.
69 00:04:06.420 ⇒ 00:04:06.820 Nicolas Sucari: Why
70 00:04:07.780 ⇒ 00:04:09.160 Nicolas Sucari: wait, unit?
71 00:04:09.550 ⇒ 00:04:12.910 Nicolas Sucari: We’re just missing dimensions, dimensions we don’t have. I think.
72 00:04:13.670 ⇒ 00:04:14.740 Ryan Luke Daque: I,
73 00:04:17.209 ⇒ 00:04:18.070 Ryan Luke Daque: yeah.
74 00:04:18.070 ⇒ 00:04:18.820 Nicolas Sucari: Want it.
75 00:04:21.339 ⇒ 00:04:23.060 Nicolas Sucari: Okay.
76 00:04:23.660 ⇒ 00:04:27.850 Nicolas Sucari: so this is what we can get here. We are just missing product. Name, right?
77 00:04:28.330 ⇒ 00:04:33.130 Ryan Luke Daque: Product name we can get from product. So we can join it through the product table
78 00:04:33.180 ⇒ 00:04:34.670 Ryan Luke Daque: and gets the name.
79 00:04:35.520 ⇒ 00:04:38.750 Ryan Luke Daque: It’s I think it’s called title in product.
80 00:04:39.850 ⇒ 00:04:40.590 Ryan Luke Daque: Yeah.
81 00:04:43.910 ⇒ 00:04:45.590 Nicolas Sucari: Let’s check.
82 00:04:47.730 ⇒ 00:04:49.059 Nicolas Sucari: I try
83 00:04:50.290 ⇒ 00:04:52.010 Nicolas Sucari: shopify
84 00:04:54.100 ⇒ 00:04:55.260 Nicolas Sucari: product.
85 00:05:00.980 ⇒ 00:05:02.209 Nicolas Sucari: title. This one.
86 00:05:02.210 ⇒ 00:05:03.340 Ryan Luke Daque: I thought, yep.
87 00:05:06.110 ⇒ 00:05:06.840 Nicolas Sucari: Okay.
88 00:05:11.190 ⇒ 00:05:12.280 Nicolas Sucari: take the
89 00:05:16.580 ⇒ 00:05:17.390 Nicolas Sucari: hmm.
90 00:05:17.520 ⇒ 00:05:19.180 Nicolas Sucari: Why, I’m not getting
91 00:05:23.420 ⇒ 00:05:24.230 Nicolas Sucari: there.
92 00:05:25.590 ⇒ 00:05:28.599 Nicolas Sucari: and you don’t need to limit it. That’s fine.
93 00:05:29.510 ⇒ 00:05:32.609 Nicolas Sucari: So we should get distinct titles.
94 00:05:34.146 ⇒ 00:05:34.723 Ryan Luke Daque: Maybe.
95 00:05:35.450 ⇒ 00:05:40.199 Ryan Luke Daque: Yeah, I can wait. Let me let me create the query. I’ll send it to you.
96 00:05:40.500 ⇒ 00:05:41.840 Nicolas Sucari: Okay, to join.
97 00:05:42.290 ⇒ 00:05:42.980 Ryan Luke Daque: Yeah.
98 00:05:45.290 ⇒ 00:05:47.067 Nicolas Sucari: That’s fine. Okay,
99 00:05:48.790 ⇒ 00:05:52.200 Nicolas Sucari: but this is only for shop from shopify. Right? That’s fine.
100 00:05:52.200 ⇒ 00:05:53.040 Ryan Luke Daque: Yes, that’s right.
101 00:05:53.040 ⇒ 00:05:55.659 Nicolas Sucari: Then we need to get from Amazon.
102 00:05:58.180 ⇒ 00:05:58.784 Nicolas Sucari: Yep.
103 00:06:00.110 ⇒ 00:06:03.030 Nicolas Sucari: let’s see if in analytics.
104 00:06:03.310 ⇒ 00:06:06.759 Nicolas Sucari: if we have something from Amazon.
105 00:06:11.460 ⇒ 00:06:14.800 Nicolas Sucari: I don’t think we have unleashed as a source right.
106 00:06:15.120 ⇒ 00:06:19.640 Ryan Luke Daque: Yeah, we don’t. I think we’re getting it manually right for unleashed.
107 00:06:21.230 ⇒ 00:06:28.720 Nicolas Sucari: I’m not sure. Let me see, I don’t think we are getting anything from unleashed. That’s the issue. I think we’re just getting.
108 00:06:29.020 ⇒ 00:06:32.489 Nicolas Sucari: Yeah. I think we’re not getting any data from a list.
109 00:06:34.690 ⇒ 00:06:38.150 Ryan Luke Daque: Hmm! I see that’s gonna be a problem then.
110 00:06:38.920 ⇒ 00:06:39.450 Ryan Luke Daque: And I’m.
111 00:06:39.450 ⇒ 00:06:41.140 Nicolas Sucari: And we have ads.
112 00:06:42.220 ⇒ 00:06:44.339 Nicolas Sucari: but worries.
113 00:06:47.610 ⇒ 00:06:52.340 Nicolas Sucari: Amazon orders. It’s inside of Mart. Maybe we need to remove this from here. Right?
114 00:06:54.300 ⇒ 00:06:54.950 Nicolas Sucari: So.
115 00:06:54.950 ⇒ 00:06:55.380 Ryan Luke Daque: Well with.
116 00:06:55.380 ⇒ 00:06:58.439 Nicolas Sucari: So sorry! Amazon
117 00:06:59.010 ⇒ 00:07:00.340 Nicolas Sucari: tables.
118 00:07:15.600 ⇒ 00:07:17.990 Ryan Luke Daque: Amazon would be.
119 00:07:18.580 ⇒ 00:07:20.240 Nicolas Sucari: Orders, order items.
120 00:07:21.360 ⇒ 00:07:26.709 Ryan Luke Daque: Should have a product list. Maybe it has something else.
121 00:07:27.340 ⇒ 00:07:29.930 Nicolas Sucari: Listed item, maybe listed. Item, yeah.
122 00:07:31.160 ⇒ 00:07:34.650 Ryan Luke Daque: There’s item dimension. So I guess they have dimensions
123 00:07:35.870 ⇒ 00:07:37.010 Ryan Luke Daque: for each.
124 00:07:39.200 ⇒ 00:07:40.470 Ryan Luke Daque: Asyn.
125 00:07:40.870 ⇒ 00:07:43.609 Nicolas Sucari: Here is this one, I think, listed. Item.
126 00:07:45.910 ⇒ 00:07:47.156 Ryan Luke Daque: Listed, item.
127 00:07:47.780 ⇒ 00:07:49.590 Nicolas Sucari: Here they have the Skus.
128 00:07:49.940 ⇒ 00:07:50.550 Ryan Luke Daque: Hmm.
129 00:07:50.550 ⇒ 00:07:54.830 Nicolas Sucari: Nothing, nothing else. And let me see, listed item
130 00:07:55.250 ⇒ 00:07:56.510 Nicolas Sucari: summary. Maybe.
131 00:07:58.090 ⇒ 00:07:59.259 Ryan Luke Daque: Yeah, this would.
132 00:08:00.090 ⇒ 00:08:02.130 Nicolas Sucari: Skew product type.
133 00:08:03.420 ⇒ 00:08:04.310 Nicolas Sucari: Yeah.
134 00:08:04.640 ⇒ 00:08:07.430 Nicolas Sucari: name. Item, name. Yeah. This one is, I think.
135 00:08:07.970 ⇒ 00:08:09.410 Nicolas Sucari: height width.
136 00:08:09.530 ⇒ 00:08:10.240 Nicolas Sucari: Yeah.
137 00:08:10.640 ⇒ 00:08:12.179 Nicolas Sucari: this tier item. Summary.
138 00:08:16.020 ⇒ 00:08:16.840 Ryan Luke Daque: Yeah.
139 00:08:19.470 ⇒ 00:08:21.100 Nicolas Sucari: So we should create.
140 00:08:21.170 ⇒ 00:08:23.040 Nicolas Sucari: You should create like a
141 00:08:23.130 ⇒ 00:08:24.800 Nicolas Sucari: new table with
142 00:08:25.320 ⇒ 00:08:28.060 Nicolas Sucari: source in one column.
143 00:08:28.260 ⇒ 00:08:31.470 Nicolas Sucari: and then all of the other dimensions in the next ones
144 00:08:32.640 ⇒ 00:08:38.190 Nicolas Sucari: right like, so that we have all of the shopify, then all of the Amazons.
145 00:08:38.360 ⇒ 00:08:41.559 Nicolas Sucari: and then we can filter by skew, and we can compare right.
146 00:08:42.070 ⇒ 00:08:44.529 Ryan Luke Daque: Yeah, we can do that. I’m
147 00:08:44.560 ⇒ 00:08:49.000 Ryan Luke Daque: trying to do create a rough query for now.
148 00:08:49.000 ⇒ 00:08:49.670 Nicolas Sucari: Okay.
149 00:08:54.420 ⇒ 00:08:58.329 Nicolas Sucari: yeah, maybe you can. You can do that. I am gonna try to see how we
150 00:08:58.510 ⇒ 00:09:05.410 Nicolas Sucari: yeah, investigate a little bit. If we are getting some data from unleashed, but I don’t think we’re getting anything, because we don’t have anything on Fivetran
151 00:09:05.820 ⇒ 00:09:07.110 Nicolas Sucari: from unleashed.
152 00:09:07.800 ⇒ 00:09:10.599 Ryan Luke Daque: Yeah, we don’t. I think that’s why
153 00:09:11.700 ⇒ 00:09:12.890 Ryan Luke Daque: we have
154 00:09:13.220 ⇒ 00:09:15.570 Ryan Luke Daque: it in the Brainforge Etl.
155 00:09:16.130 ⇒ 00:09:17.110 Ryan Luke Daque: But that’s not.
156 00:09:20.650 ⇒ 00:09:23.330 Ryan Luke Daque: I’m not sure if that’s still up to date.
157 00:09:23.670 ⇒ 00:09:25.990 Nicolas Sucari: Product list daily. Hmm!
158 00:09:26.050 ⇒ 00:09:27.630 Nicolas Sucari: I don’t know if it’s
159 00:09:28.270 ⇒ 00:09:30.040 Nicolas Sucari: it was updated
160 00:09:30.370 ⇒ 00:09:31.290 Nicolas Sucari: any.
161 00:09:33.740 ⇒ 00:09:36.700 Nicolas Sucari: because we don’t have anything running from.
162 00:09:36.860 ⇒ 00:09:37.689 Nicolas Sucari: They are right.
163 00:09:37.690 ⇒ 00:09:38.679 Ryan Luke Daque: We have.
164 00:09:38.900 ⇒ 00:09:40.549 Ryan Luke Daque: We have the
165 00:09:42.030 ⇒ 00:09:47.999 Ryan Luke Daque: the Google sheets, the one that we’re exporting importing every Monday
166 00:09:48.270 ⇒ 00:09:48.790 Ryan Luke Daque: portal.
167 00:09:48.790 ⇒ 00:09:49.869 Nicolas Sucari: That for?
168 00:09:50.150 ⇒ 00:09:55.100 Nicolas Sucari: No, that’s for ship, for unis right not from, for from our from our list.
169 00:09:56.280 ⇒ 00:09:58.223 Ryan Luke Daque: All right. Yeah, yeah.
170 00:09:58.710 ⇒ 00:10:02.869 Nicolas Sucari: Yeah, because if I go to emails, I was just checking that here in 5 Tran
171 00:10:03.090 ⇒ 00:10:05.200 Nicolas Sucari: email, we have.
172 00:10:05.280 ⇒ 00:10:07.240 Nicolas Sucari: yeah, we have unit shipments.
173 00:10:08.060 ⇒ 00:10:11.490 Nicolas Sucari: And also I don’t know if we have ship station as source.
174 00:10:16.550 ⇒ 00:10:17.120 Ryan Luke Daque: There should be.
175 00:10:17.120 ⇒ 00:10:18.990 Nicolas Sucari: Oh, yeah, yeah, we have
176 00:10:20.220 ⇒ 00:10:23.950 Nicolas Sucari: order items. Product. Yeah, maybe we have it here.
177 00:10:31.310 ⇒ 00:10:34.179 Ryan Luke Daque: Amazon listed. Item summary
178 00:10:37.760 ⇒ 00:10:40.419 Ryan Luke Daque: name.
179 00:10:40.970 ⇒ 00:10:42.580 Ryan Luke Daque: item, name.
180 00:10:47.050 ⇒ 00:10:49.260 Ryan Luke Daque: And then we have
181 00:10:50.620 ⇒ 00:10:52.160 Ryan Luke Daque: skew.
182 00:10:54.870 ⇒ 00:10:55.739 Nicolas Sucari: What do you see?
183 00:10:56.460 ⇒ 00:10:57.940 Ryan Luke Daque: We have weight here
184 00:11:01.170 ⇒ 00:11:05.000 Ryan Luke Daque: we have height and width, but we don’t have weight
185 00:11:05.110 ⇒ 00:11:06.900 Ryan Luke Daque: in for Amazon.
186 00:11:06.900 ⇒ 00:11:07.940 Nicolas Sucari: For Amazon.
187 00:11:10.280 ⇒ 00:11:12.270 Ryan Luke Daque: Yeah, it doesn’t have weight.
188 00:11:16.400 ⇒ 00:11:17.570 Ryan Luke Daque: Hmm.
189 00:11:17.920 ⇒ 00:11:22.470 Nicolas Sucari: In item, there is another one in Amazon. Okay, wait. Let me check.
190 00:11:22.470 ⇒ 00:11:23.740 Ryan Luke Daque: Summary.
191 00:11:24.090 ⇒ 00:11:24.940 Ryan Luke Daque: maybe.
192 00:11:24.940 ⇒ 00:11:25.670 Nicolas Sucari: Okay.
193 00:11:26.790 ⇒ 00:11:28.029 Nicolas Sucari: so this is.
194 00:11:29.390 ⇒ 00:11:30.750 Ryan Luke Daque: Size.
195 00:11:32.970 ⇒ 00:11:35.109 Ryan Luke Daque: but there’s no wait.
196 00:11:38.020 ⇒ 00:11:41.939 Ryan Luke Daque: anyway. Let me just continue with what we have.
197 00:11:46.520 ⇒ 00:11:48.130 Nicolas Sucari: This should be fine.
198 00:11:50.650 ⇒ 00:11:53.229 Nicolas Sucari: This is gonna be Amazon.
199 00:12:13.770 ⇒ 00:12:18.239 Ryan Luke Daque: There is item dimension. I guess we can use item dimension.
200 00:12:20.976 ⇒ 00:12:25.830 Ryan Luke Daque: It has 2 weights, though, item, weight and package weight. So maybe item, weight.
201 00:12:26.480 ⇒ 00:12:27.120 Ryan Luke Daque: Yeah.
202 00:12:27.120 ⇒ 00:12:27.890 Nicolas Sucari: Can’t wait. I don’t worry.
203 00:12:28.870 ⇒ 00:12:32.850 Nicolas Sucari: Yeah, we have item height unit, also, item, high value.
204 00:12:32.850 ⇒ 00:12:33.910 Ryan Luke Daque: Yeah.
205 00:12:34.190 ⇒ 00:12:39.190 Nicolas Sucari: Maybe we need to check, if that height is the same, but the height and length.
206 00:12:42.040 ⇒ 00:12:45.670 Nicolas Sucari: Here we have height, length, and weight.
207 00:12:45.890 ⇒ 00:12:49.870 Nicolas Sucari: Then we have we? We have everything, I think, from Amazon.
208 00:12:50.220 ⇒ 00:12:50.970 Nicolas Sucari: Yep.
209 00:12:51.430 ⇒ 00:12:55.719 Nicolas Sucari: in those 2 tables listed. Item summary and item, dimension. Right?
210 00:12:55.940 ⇒ 00:12:56.720 Nicolas Sucari: Yep.
211 00:12:56.890 ⇒ 00:12:59.759 Ryan Luke Daque: Item, height, item length.
212 00:13:00.220 ⇒ 00:13:02.660 Ryan Luke Daque: and then item, wait
213 00:13:03.700 ⇒ 00:13:04.720 Ryan Luke Daque: unit.
214 00:13:05.380 ⇒ 00:13:07.039 Ryan Luke Daque: where’s the item? Wait
215 00:13:07.110 ⇒ 00:13:09.920 Ryan Luke Daque: value, item, weight value. I see. Okay.
216 00:13:10.900 ⇒ 00:13:12.110 Nicolas Sucari: Item weight value. Yeah.
217 00:13:14.080 ⇒ 00:13:17.129 Nicolas Sucari: everything is in pounds, I think. So. That’s fine.
218 00:13:18.600 ⇒ 00:13:20.890 Ryan Luke Daque: Let’s just add the unit just in case.
219 00:13:20.890 ⇒ 00:13:22.430 Nicolas Sucari: Yeah, that’s fine.
220 00:13:24.770 ⇒ 00:13:29.030 Nicolas Sucari: Then from ship station we have this ship station product.
221 00:13:46.810 ⇒ 00:13:56.399 Nicolas Sucari: We have skew and skew and product name. But I don’t think we have product. Id, I mean, we have an id, but I don’t know if that’s the product. Id.
222 00:13:58.470 ⇒ 00:14:00.130 Nicolas Sucari: And here we have hide
223 00:14:00.210 ⇒ 00:14:01.320 Nicolas Sucari: length
224 00:14:01.460 ⇒ 00:14:03.129 Nicolas Sucari: and width too.
225 00:14:03.830 ⇒ 00:14:07.580 Nicolas Sucari: We’re just missing weight from shopify.
226 00:14:09.600 ⇒ 00:14:13.330 Nicolas Sucari: maybe shipment. Item, let me check.
227 00:14:30.350 ⇒ 00:14:33.060 Ryan Luke Daque: What are you checking now? Ship, station.
228 00:14:33.730 ⇒ 00:14:36.000 Nicolas Sucari: If we have to wait for ship station. Yeah.
229 00:14:36.860 ⇒ 00:14:38.660 Ryan Luke Daque: And that’s ship
230 00:14:38.670 ⇒ 00:14:40.360 Ryan Luke Daque: meant. Item.
231 00:14:42.480 ⇒ 00:14:46.829 Nicolas Sucari: From ship station. Yeah, we have something. Look, this weight unit.
232 00:14:47.460 ⇒ 00:14:48.100 Nicolas Sucari: yeah.
233 00:14:48.520 ⇒ 00:14:49.210 Nicolas Sucari: for you.
234 00:14:49.540 ⇒ 00:14:52.739 Ryan Luke Daque: Item is the order
235 00:14:53.190 ⇒ 00:14:55.029 Ryan Luke Daque: it’s related to order. Right?
236 00:14:56.580 ⇒ 00:14:58.060 Nicolas Sucari: The shipment item.
237 00:14:58.060 ⇒ 00:14:59.040 Ryan Luke Daque: Yeah.
238 00:15:01.710 ⇒ 00:15:02.579 Ryan Luke Daque: it’s not.
239 00:15:02.580 ⇒ 00:15:03.010 Nicolas Sucari: 2 weeks.
240 00:15:03.010 ⇒ 00:15:03.869 Ryan Luke Daque: I think they.
241 00:15:04.290 ⇒ 00:15:05.170 Ryan Luke Daque: Yeah.
242 00:15:05.310 ⇒ 00:15:08.030 Ryan Luke Daque: there’s product. They have product table
243 00:15:08.270 ⇒ 00:15:08.950 Ryan Luke Daque: which has.
244 00:15:08.950 ⇒ 00:15:09.803 Nicolas Sucari: Yeah, yeah.
245 00:15:10.230 ⇒ 00:15:12.210 Ryan Luke Daque: Check. That. Yeah, exactly.
246 00:15:12.210 ⇒ 00:15:13.210 Nicolas Sucari: Of the Id.
247 00:15:13.590 ⇒ 00:15:15.900 Ryan Luke Daque: It has height, length, and width.
248 00:15:16.910 ⇒ 00:15:21.320 Ryan Luke Daque: but it doesn’t have weight. Oh, it has weight weight in all ounce. Yeah.
249 00:15:22.860 ⇒ 00:15:25.769 Nicolas Sucari: Where it has wait. Okay, wait. Times, okay.
250 00:15:25.770 ⇒ 00:15:28.360 Ryan Luke Daque: Yeah, so I guess we can use this.
251 00:15:29.340 ⇒ 00:15:33.130 Nicolas Sucari: Yeah. But do we know that if that id is product? Id.
252 00:15:33.340 ⇒ 00:15:35.279 Nicolas Sucari: that’s the only thing I’m still.
253 00:15:35.280 ⇒ 00:15:37.820 Ryan Luke Daque: Should be product Id, because it’s the product table.
254 00:15:37.820 ⇒ 00:15:38.769 Nicolas Sucari: In a product table.
255 00:15:38.770 ⇒ 00:15:39.880 Ryan Luke Daque: Okay, yeah, yeah.
256 00:15:40.430 ⇒ 00:15:41.639 Nicolas Sucari: That’s find that
257 00:15:43.340 ⇒ 00:15:48.469 Nicolas Sucari: the only thing that we are just missing is the cost of goods sold like the price.
258 00:15:48.520 ⇒ 00:15:50.240 Nicolas Sucari: Maybe right?
259 00:15:52.510 ⇒ 00:15:56.080 Ryan Luke Daque: What was the cost of goods sold like the total cost.
260 00:15:56.080 ⇒ 00:15:56.400 Nicolas Sucari: Because.
261 00:15:56.400 ⇒ 00:15:57.140 Ryan Luke Daque: 4.
262 00:15:58.230 ⇒ 00:15:58.920 Ryan Luke Daque: Hmm.
263 00:15:59.590 ⇒ 00:16:00.129 Nicolas Sucari: I don’t know.
264 00:16:00.130 ⇒ 00:16:00.420 Ryan Luke Daque: Yeah.
265 00:16:00.420 ⇒ 00:16:05.420 Nicolas Sucari: Yeah. But we have price in in ship station. We have the price. Maybe we can use that one.
266 00:16:08.080 ⇒ 00:16:11.240 Ryan Luke Daque: But that’s like the price of the product. It doesn’t.
267 00:16:11.620 ⇒ 00:16:13.372 Ryan Luke Daque: Is the cogs like
268 00:16:14.870 ⇒ 00:16:16.259 Ryan Luke Daque: that should be like
269 00:16:17.820 ⇒ 00:16:20.109 Ryan Luke Daque: minus the shipping fee, or something right.
270 00:16:21.617 ⇒ 00:16:27.690 Nicolas Sucari: Yeah, I don’t. I’m not sure. Maybe we can ask Kutam what he’s expecting with that one.
271 00:16:30.660 ⇒ 00:16:36.170 Nicolas Sucari: So we have ship station. We have Amazon. We have shopify, we’re just missing at least.
272 00:16:36.180 ⇒ 00:16:40.179 Nicolas Sucari: And Unis, we know that unleashed. We don’t have anything.
273 00:16:40.630 ⇒ 00:16:41.449 Nicolas Sucari: and we can.
274 00:16:41.450 ⇒ 00:16:42.400 Ryan Luke Daque: Try.
275 00:16:43.140 ⇒ 00:16:51.340 Ryan Luke Daque: Can you try the historical, unleashed table there, and just to see if it has the data that we need.
276 00:16:51.800 ⇒ 00:16:53.310 Nicolas Sucari: From the eta.
277 00:16:54.670 ⇒ 00:16:55.360 Ryan Luke Daque: Yeah.
278 00:16:56.070 ⇒ 00:16:56.979 Nicolas Sucari: Let me check
279 00:17:01.660 ⇒ 00:17:04.340 Nicolas Sucari: does not exist or not authorized.
280 00:17:04.500 ⇒ 00:17:05.240 Nicolas Sucari: Huh!
281 00:17:05.829 ⇒ 00:17:07.380 Nicolas Sucari: Maybe I don’t have.
282 00:17:07.380 ⇒ 00:17:08.400 Ryan Luke Daque: Oh.
283 00:17:09.710 ⇒ 00:17:10.760 Ryan Luke Daque: wait!
284 00:17:15.099 ⇒ 00:17:15.769 Nicolas Sucari: Sorry, now.
285 00:17:15.770 ⇒ 00:17:16.650 Ryan Luke Daque: Name.
286 00:17:16.859 ⇒ 00:17:19.869 Nicolas Sucari: Doing something. Did something wrong. Right?
287 00:17:25.999 ⇒ 00:17:27.289 Nicolas Sucari: Let’s check here.
288 00:17:28.549 ⇒ 00:17:29.289 Nicolas Sucari: Okay.
289 00:17:33.669 ⇒ 00:17:35.799 Nicolas Sucari: so we have product code.
290 00:17:36.729 ⇒ 00:17:39.079 Nicolas Sucari: That should be skew. I think
291 00:17:41.199 ⇒ 00:17:42.689 Nicolas Sucari: we have weight.
292 00:17:49.109 ⇒ 00:17:50.769 Nicolas Sucari: We have
293 00:17:53.609 ⇒ 00:17:56.039 Nicolas Sucari: task cost there.
294 00:17:57.109 ⇒ 00:18:00.209 Nicolas Sucari: But yeah, I don’t know. I don’t know when this was updated.
295 00:18:02.239 ⇒ 00:18:05.039 Nicolas Sucari: because we have some fields that are kind of weird.
296 00:18:05.119 ⇒ 00:18:06.859 Nicolas Sucari: The created date.
297 00:18:07.510 ⇒ 00:18:12.219 Ryan Luke Daque: Do we have in in the Dbt table? Do we have an unleashed? I think we have
298 00:18:12.450 ⇒ 00:18:15.779 Ryan Luke Daque: in the DI mean the dbt database.
299 00:18:16.110 ⇒ 00:18:18.529 Ryan Luke Daque: either in staging or march.
300 00:18:21.560 ⇒ 00:18:24.249 Ryan Luke Daque: Oh, no, not dbt, analytics. Yeah.
301 00:18:26.960 ⇒ 00:18:29.500 Ryan Luke Daque: Maybe we have unleashed QR.
302 00:18:29.870 ⇒ 00:18:31.500 Nicolas Sucari: In March. We don’t.
303 00:18:31.720 ⇒ 00:18:33.350 Ryan Luke Daque: Check, staging.
304 00:18:38.110 ⇒ 00:18:38.820 Nicolas Sucari: No.
305 00:18:39.190 ⇒ 00:18:40.070 Ryan Luke Daque: Oh!
306 00:18:40.190 ⇒ 00:18:42.200 Nicolas Sucari: What is this next slide.
307 00:18:42.510 ⇒ 00:18:43.890 Ryan Luke Daque: That was the old
308 00:18:45.380 ⇒ 00:18:48.320 Ryan Luke Daque: one that we used for unleashed, I believe.
309 00:18:51.810 ⇒ 00:18:52.600 Ryan Luke Daque: Yeah, we come.
310 00:18:52.600 ⇒ 00:18:54.170 Nicolas Sucari: Clear. The product list daily.
311 00:19:09.130 ⇒ 00:19:13.460 Nicolas Sucari: Yeah. And it’s almost the same that we have from the
312 00:19:13.540 ⇒ 00:19:14.670 Nicolas Sucari: previous one
313 00:19:15.380 ⇒ 00:19:19.390 Nicolas Sucari: on the G analyst product list. Daily historical, I think.
314 00:19:27.520 ⇒ 00:19:28.610 Ryan Luke Daque: Bye.
315 00:19:36.330 ⇒ 00:19:38.680 Nicolas Sucari: Hey? I need to jump to our meeting.
316 00:19:38.940 ⇒ 00:19:39.315 Ryan Luke Daque: Okay.
317 00:19:39.690 ⇒ 00:19:51.179 Nicolas Sucari: But if you didn’t have that query and we can create a table that would be great. We, if we don’t have the unleashed information. That’s fine. I think we just need to add the Unis one that we got from the email report right.
318 00:19:52.960 ⇒ 00:19:57.080 Ryan Luke Daque: Yeah, I I wonder if that’s this
319 00:19:57.120 ⇒ 00:19:59.559 Ryan Luke Daque: the same, though the units and unleashed
320 00:19:59.890 ⇒ 00:20:01.449 Ryan Luke Daque: it’s not the same right.
321 00:20:02.030 ⇒ 00:20:03.970 Nicolas Sucari: I don’t think it’s the same. No.
322 00:20:03.970 ⇒ 00:20:04.620 Ryan Luke Daque: Yeah.
323 00:20:04.620 ⇒ 00:20:11.770 Nicolas Sucari: Because from Unis we are, I think we’re getting only the shipping stuff, but we should be able to get some
324 00:20:11.990 ⇒ 00:20:17.719 Nicolas Sucari: information for the orders, and these queues and everything there. Yeah.
325 00:20:18.400 ⇒ 00:20:19.090 Ryan Luke Daque: Okay.
326 00:20:20.540 ⇒ 00:20:22.599 Nicolas Sucari: But yeah, I think it’s on the email that one
327 00:20:24.960 ⇒ 00:20:26.600 Nicolas Sucari: we have
328 00:20:30.140 ⇒ 00:20:35.950 Nicolas Sucari: shipping cost. E, item, id, we should be able to get everything from there. I think
329 00:20:36.150 ⇒ 00:20:41.129 Nicolas Sucari: I don’t know if we are gonna be able to get the weight and that kind of stuff. But let’s check.
330 00:20:41.560 ⇒ 00:20:44.459 Ryan Luke Daque: Yeah, okay, I’ll look into that. I’ll let you know.
331 00:20:44.980 ⇒ 00:20:47.699 Nicolas Sucari: Excellent. Thank you, Ryan. Let’s talk to you later. Okay.
332 00:20:48.000 ⇒ 00:20:49.709 Ryan Luke Daque: Sounds good, thanks.
333 00:20:50.980 ⇒ 00:20:51.710 Ryan Luke Daque: bye.
334 00:20:51.830 ⇒ 00:20:52.760 Ryan Luke Daque: bye-bye.