Meeting Title: Zoom Meeting Date: 2024-11-21 Meeting participants: Luke Daque, Nicolas Sucari
WEBVTT
1 00:01:35.720 ⇒ 00:01:36.480 Luke Daque: Hello!
2 00:01:39.720 ⇒ 00:01:41.320 Luke Daque: Hi, Nicholas! Can you hear me?
3 00:01:41.730 ⇒ 00:01:43.210 Nicolas Sucari: Brian, how are you?
4 00:01:43.990 ⇒ 00:01:45.729 Luke Daque: Hey? I’m doing great! How are you?
5 00:01:46.880 ⇒ 00:01:48.529 Nicolas Sucari: All good. Yeah.
6 00:01:49.480 ⇒ 00:01:49.940 Luke Daque: Cool.
7 00:01:49.940 ⇒ 00:01:59.330 Nicolas Sucari: You. You spend the night. Well, not the night, but you’re kind of day, maybe with Utam yesterday.
8 00:01:59.330 ⇒ 00:02:00.460 Luke Daque: Yeah. Yesterday.
9 00:02:00.460 ⇒ 00:02:02.330 Nicolas Sucari: Spend a long. Yeah.
10 00:02:02.460 ⇒ 00:02:07.043 Luke Daque: Yeah, I I like, I guess I slept at like 7 in the morning or something
11 00:02:07.772 ⇒ 00:02:11.910 Luke Daque: we were like synthetic data stuff. So yeah. Did a lot of
12 00:02:12.260 ⇒ 00:02:15.178 Luke Daque: tried a lot of different ways to do it.
13 00:02:15.620 ⇒ 00:02:20.369 Luke Daque: mostly related to AI and and and stuff. It was pretty fun, though.
14 00:02:20.510 ⇒ 00:02:21.529 Luke Daque: That was.
15 00:02:21.530 ⇒ 00:02:22.090 Nicolas Sucari: Cool.
16 00:02:22.390 ⇒ 00:02:22.980 Luke Daque: That’s cool.
17 00:02:22.980 ⇒ 00:02:25.110 Nicolas Sucari: And Utahn is still working like.
18 00:02:25.530 ⇒ 00:02:35.689 Luke Daque: Yeah, he’s crazy like, like, even like 4 or 5 Pm. Here he was still awake, so I don’t know. I already woke up, and he’s still working. It’s crazy.
19 00:02:35.730 ⇒ 00:02:40.460 Nicolas Sucari: I even told him to get some sleep. He’s like, Yeah, yeah, I’ve seen that.
20 00:02:40.980 ⇒ 00:02:41.890 Luke Daque: Yeah.
21 00:02:43.140 ⇒ 00:02:44.899 Nicolas Sucari: No, he’s crazy. Yeah.
22 00:02:46.030 ⇒ 00:02:47.130 Luke Daque: Yeah, I hope so.
23 00:02:47.430 ⇒ 00:02:50.479 Luke Daque: In the flow or something. He didn’t want to.
24 00:02:50.710 ⇒ 00:02:51.320 Luke Daque: This stuff.
25 00:02:51.320 ⇒ 00:02:55.010 Nicolas Sucari: Yeah, when he’s like when he’s logged in like he.
26 00:02:55.470 ⇒ 00:02:56.120 Nicolas Sucari: Thank you.
27 00:02:56.270 ⇒ 00:02:58.849 Nicolas Sucari: I think he feels like really productive.
28 00:02:59.520 ⇒ 00:03:00.380 Luke Daque: That’s cool.
29 00:03:00.980 ⇒ 00:03:07.899 Nicolas Sucari: Hey? Before starting with the pool parts. I wanna ask you about Javi? For a minute.
30 00:03:08.740 ⇒ 00:03:11.359 Luke Daque: Yeah, because I think we have a meeting later. Right? Yeah, let me double.
31 00:03:11.360 ⇒ 00:03:13.079 Nicolas Sucari: Yeah, we have a meeting today.
32 00:03:13.350 ⇒ 00:03:14.120 Nicolas Sucari: Yeah.
33 00:03:14.290 ⇒ 00:03:17.061 Nicolas Sucari: So we moved the meeting from Tuesdays to Thursdays.
34 00:03:18.560 ⇒ 00:03:24.430 Nicolas Sucari: so yeah, we’re having the meeting today. I just wanna know, like, where are we standing with all of the tasks?
35 00:03:24.720 ⇒ 00:03:30.190 Nicolas Sucari: And what have you been working on yesterday? Maybe so that I can send an update to a man
36 00:03:31.380 ⇒ 00:03:36.520 Nicolas Sucari: opening the board, because I know we have that those 2 tickets from.
37 00:03:37.320 ⇒ 00:03:38.040 Luke Daque: Yeah, I do have.
38 00:03:38.410 ⇒ 00:03:38.780 Nicolas Sucari: Yes!
39 00:03:39.100 ⇒ 00:03:42.109 Luke Daque: 2 pull requests already, one for
40 00:03:43.035 ⇒ 00:03:52.150 Luke Daque: the adding the app source to the kpi. But it looks like he did leave a comment here. He wanted it separate model. So I can update that.
41 00:03:52.530 ⇒ 00:03:56.420 Luke Daque: And then I also created the Pr for the recharge
42 00:03:56.790 ⇒ 00:04:00.970 Luke Daque: models and rail. So a basic rail.
43 00:04:01.000 ⇒ 00:04:03.849 Luke Daque: This took a while for me, because, like, there were some
44 00:04:05.170 ⇒ 00:04:07.510 Luke Daque: complexities. But yeah, but but this is
45 00:04:08.380 ⇒ 00:04:11.300 Luke Daque: that those are the Prs I created. There’s still
46 00:04:11.310 ⇒ 00:04:20.310 Luke Daque: 2 more issues that pay us created. I haven’t started working on these 2, though, because, like like yesterday, we were already
47 00:04:20.510 ⇒ 00:04:22.720 Luke Daque: working with the synthetic data.
48 00:04:22.720 ⇒ 00:04:26.589 Nicolas Sucari: No, no, yeah, that that’s fine. That’s fine. So we have the recharge on the
49 00:04:26.640 ⇒ 00:04:30.379 Nicolas Sucari: adding the app source stuff in the Daily Api right table.
50 00:04:31.020 ⇒ 00:04:31.670 Luke Daque: For.
51 00:04:31.670 ⇒ 00:04:37.139 Nicolas Sucari: Yeah, I’m gonna send. I’m gonna send that update. And maybe we can share that in the meeting, too. If we finish the recharge.
52 00:04:37.140 ⇒ 00:04:41.699 Nicolas Sucari: Yeah and get it into real. I think that’s gonna be great so that we can show that.
53 00:04:42.240 ⇒ 00:04:49.029 Luke Daque: Sure I can merge, although nobody reviewed this yet. But I I can merge this, that just so we have something.
54 00:04:50.560 ⇒ 00:04:53.719 Nicolas Sucari: I don’t know if we’re miss up, but
55 00:04:54.640 ⇒ 00:04:59.999 Nicolas Sucari: maybe we can. Yeah, just let’s wait. And maybe we can budget in a while. I can ask.
56 00:05:00.250 ⇒ 00:05:02.559 Nicolas Sucari: You can ask them to review it. Yeah.
57 00:05:04.039 ⇒ 00:05:10.470 Nicolas Sucari: Cool. And then can we check on 5 tran if we can like
58 00:05:11.160 ⇒ 00:05:17.799 Nicolas Sucari: deselect some of the tables from shopify and gorgeous in those 2 are the ones that are like.
59 00:05:18.320 ⇒ 00:05:20.029 Luke Daque: Sure I can. I can check.
60 00:05:20.030 ⇒ 00:05:21.180 Nicolas Sucari: Our spend.
61 00:05:21.590 ⇒ 00:05:22.380 Luke Daque: Again.
62 00:05:22.644 ⇒ 00:05:23.700 Nicolas Sucari: Seeing these right now.
63 00:05:24.260 ⇒ 00:05:25.069 Luke Daque: Oh, yeah. Okay.
64 00:05:25.070 ⇒ 00:05:27.620 Nicolas Sucari: And look. Maybe you can share.
65 00:05:28.060 ⇒ 00:05:34.819 Luke Daque: I believe I already removed the tables for for shopify, although I had to like
66 00:05:35.980 ⇒ 00:05:37.320 Luke Daque: What do you call that like?
67 00:05:37.910 ⇒ 00:05:40.879 Luke Daque: Re? Add another table. That was.
68 00:05:41.480 ⇒ 00:05:42.170 Nicolas Sucari: Oh, okay.
69 00:05:42.170 ⇒ 00:05:48.489 Luke Daque: But then by us asked to add, like the note attributes. So I had to put that back in.
70 00:05:48.490 ⇒ 00:05:52.769 Luke Daque: So we are, we are using that. Okay, yeah, that’s that’s the one that is.
71 00:05:52.990 ⇒ 00:05:55.670 Luke Daque: yeah, I initially removed that.
72 00:05:56.300 ⇒ 00:06:03.150 Luke Daque: I initially removed that because we didn’t use it. But then pay us asked for note attributes in one of the
73 00:06:03.640 ⇒ 00:06:09.069 Luke Daque: tickets last week. So I already added back, maybe that would.
74 00:06:09.430 ⇒ 00:06:13.279 Luke Daque: That would also be cost incurring, because that.
75 00:06:13.280 ⇒ 00:06:13.730 Nicolas Sucari: Yeah.
76 00:06:13.730 ⇒ 00:06:17.370 Luke Daque: Do the re-sync, and that would not be free anymore. Like the.
77 00:06:17.370 ⇒ 00:06:21.850 Nicolas Sucari: Yeah, exactly. But you did that like, maybe start of the month.
78 00:06:22.390 ⇒ 00:06:23.600 Luke Daque: Last week.
79 00:06:24.027 ⇒ 00:06:27.770 Nicolas Sucari: No. Last week. Okay, okay, yeah. I think I can see it here.
80 00:06:28.845 ⇒ 00:06:39.210 Nicolas Sucari: But yeah, that’s fine. Don’t worry. Okay, yeah. No, because we have that one on the tax line are the 2 that are like the biggest ones on shopify.
81 00:06:39.510 ⇒ 00:06:45.400 Nicolas Sucari: Yeah, I mean, they have this amount of data. I mean, we can’t do anything else. This one, right?
82 00:06:47.820 ⇒ 00:06:51.200 Nicolas Sucari: Okay, that’s for shopify and then for gorgeous.
83 00:06:51.410 ⇒ 00:06:59.240 Nicolas Sucari: I don’t know if we are using all of the tables. But there is. There are 2 tables that are message and message source to
84 00:06:59.350 ⇒ 00:07:01.880 Nicolas Sucari: that. Those are like pretty big.
85 00:07:03.160 ⇒ 00:07:09.770 Nicolas Sucari: and I don’t think like we are getting like daily things for gorgeous right.
86 00:07:11.000 ⇒ 00:07:12.800 Luke Daque: Gorgeous.
87 00:07:12.800 ⇒ 00:07:14.560 Nicolas Sucari: Let me share if you want.
88 00:07:15.080 ⇒ 00:07:16.039 Luke Daque: Yeah, I have.
89 00:07:16.040 ⇒ 00:07:20.050 Nicolas Sucari: Because I’m not. I’m not seeing like movement.
90 00:07:20.440 ⇒ 00:07:21.580 Nicolas Sucari: Allow.
91 00:07:23.550 ⇒ 00:07:23.950 Luke Daque: Yeah, that.
92 00:07:23.950 ⇒ 00:07:25.100 Luke Daque: Can you see the screen?
93 00:07:25.100 ⇒ 00:07:27.290 Luke Daque: Weird? If it’s not.
94 00:07:28.020 ⇒ 00:07:29.779 Nicolas Sucari: You see, we are in current month like me in
95 00:07:31.346 ⇒ 00:07:37.469 Nicolas Sucari: let me do the initial sync. You see, we have, like the initial Sync was in Octo in October. Yeah.
96 00:07:37.500 ⇒ 00:07:59.459 Nicolas Sucari: like the 30 of October we brought all everything. Then I think that the connector was like something messed up, and we were not getting anything. And then we received everything on November 19. And we’re getting like a lot of movement here, and this one is paid. So that’s the other ticket that I just submitted, like what we talk about yesterday with William.
97 00:07:59.930 ⇒ 00:08:00.859 Nicolas Sucari: Maybe they can. You know
98 00:08:00.860 ⇒ 00:08:07.139 Nicolas Sucari: us for free. But even though, if they give us, give us or not. I want to check like, if this
99 00:08:07.380 ⇒ 00:08:11.429 Nicolas Sucari: tables are the one that we are using, or we can get rid of anything
100 00:08:11.870 ⇒ 00:08:15.389 Nicolas Sucari: in particular, these 2, because these 2 are like huge
101 00:08:17.370 ⇒ 00:08:25.729 Nicolas Sucari: But but yeah, you see, like I, there’s no like, okay, today is 21. So, yeah, maybe it is working. Now, we just need to wait.
102 00:08:26.120 ⇒ 00:08:28.380 Nicolas Sucari: Because these weeks it was broken. I think.
103 00:08:33.100 ⇒ 00:08:33.960 Luke Daque: Yeah.
104 00:08:34.530 ⇒ 00:08:35.240 Nicolas Sucari: Okay.
105 00:08:36.429 ⇒ 00:08:37.360 Luke Daque: Yeah.
106 00:08:40.390 ⇒ 00:08:44.640 Luke Daque: it’s we should be getting the.
107 00:08:46.160 ⇒ 00:08:49.349 Luke Daque: We should be still still be getting data from gorgeous though.
108 00:08:50.050 ⇒ 00:08:52.614 Nicolas Sucari: Yeah, yeah, I think it is working now. Yeah,
109 00:08:54.640 ⇒ 00:08:55.180 Luke Daque: Okay.
110 00:08:55.180 ⇒ 00:08:59.770 Nicolas Sucari: But if we if we deselect those 2 tables like we’re gonna reduce
111 00:09:00.060 ⇒ 00:09:02.970 Nicolas Sucari: more than half of what we are.
112 00:09:03.870 ⇒ 00:09:05.399 Luke Daque: Which tables was it.
113 00:09:05.700 ⇒ 00:09:13.409 Nicolas Sucari: Message and message source 2, just check if we’re using them. If not, maybe we can get.
114 00:09:13.410 ⇒ 00:09:17.360 Luke Daque: We are using. Message. Yeah, but I’ll I’ll double check. I’ll double check.
115 00:09:17.360 ⇒ 00:09:18.100 Nicolas Sucari: Yeah. Okay.
116 00:09:18.750 ⇒ 00:09:19.690 Nicolas Sucari: Don’t worry.
117 00:09:20.910 ⇒ 00:09:21.610 Nicolas Sucari: Cool.
118 00:09:21.610 ⇒ 00:09:25.460 Luke Daque: Yeah, I think we were using message, because the it’s where
119 00:09:25.670 ⇒ 00:09:28.919 Luke Daque: we can find the what was that?
120 00:09:30.140 ⇒ 00:09:36.879 Luke Daque: Some there there was some stuff that Aman was asking for, and it only existed in messages. I believe.
121 00:09:37.170 ⇒ 00:09:39.300 Nicolas Sucari: Okay, okay, that’s fine.
122 00:09:39.750 ⇒ 00:09:40.490 Nicolas Sucari: Okay?
123 00:09:40.690 ⇒ 00:09:45.270 Nicolas Sucari: Excellent. Okay, yeah. I just submitted those the tickets that I sent
124 00:09:45.300 ⇒ 00:09:49.019 Nicolas Sucari: there is no place in our dashboard in Fivetran to
125 00:09:49.981 ⇒ 00:09:53.780 Nicolas Sucari: to see the tickets. I think you need to go to the support platform.
126 00:09:54.300 ⇒ 00:09:55.580 Nicolas Sucari: Bad. That’s fine.
127 00:09:55.760 ⇒ 00:09:57.310 Luke Daque: Yeah, yeah, that’s correct.
128 00:09:57.430 ⇒ 00:10:01.620 Nicolas Sucari: You have to go to 5 trans support, you’ll be able to see the tickets there.
129 00:10:02.660 ⇒ 00:10:04.180 Nicolas Sucari: Yeah, cool.
130 00:10:04.520 ⇒ 00:10:08.200 Nicolas Sucari: Okay. Excellent. Do you wanna talk about what parts.
131 00:10:08.950 ⇒ 00:10:14.090 Luke Daque: Yeah. Yeah. It was the related to the sku list.
132 00:10:14.750 ⇒ 00:10:15.340 Nicolas Sucari: Yep.
133 00:10:16.070 ⇒ 00:10:16.550 Luke Daque: So.
134 00:10:16.550 ⇒ 00:10:20.490 Nicolas Sucari: So I created. Let me go back to notion.
135 00:10:21.090 ⇒ 00:10:22.560 Nicolas Sucari: Clients.
136 00:10:23.880 ⇒ 00:10:24.640 Luke Daque: Flights.
137 00:10:25.160 ⇒ 00:10:26.569 Nicolas Sucari: Let me share again.
138 00:10:28.450 ⇒ 00:10:29.480 Nicolas Sucari: Okay.
139 00:10:34.100 ⇒ 00:10:34.780 Nicolas Sucari: cool.
140 00:10:36.653 ⇒ 00:10:43.850 Nicolas Sucari: I created these ones. Queue management. This is what Udam shared from the steps.
141 00:10:44.180 ⇒ 00:10:48.359 Nicolas Sucari: and I added here the file that that he sent us.
142 00:10:48.770 ⇒ 00:10:57.100 Nicolas Sucari: So what do we wanna do, I think, like the ultimate goal is to to clean this queue list in all of their platforms. So we should like
143 00:10:57.410 ⇒ 00:11:04.770 Nicolas Sucari: use this skill list that they send and try to see which ones they are using in all of the
144 00:11:04.950 ⇒ 00:11:07.140 Nicolas Sucari: different platforms right
145 00:11:07.220 ⇒ 00:11:20.779 Nicolas Sucari: in all of these sources. Because we have Amazon, we have shopify, and then we have, like other sources, we should go and check like unleashed, and all of those ones. I think we did that once before. You remember.
146 00:11:20.780 ⇒ 00:11:21.430 Luke Daque: Hmm!
147 00:11:22.760 ⇒ 00:11:30.469 Luke Daque: I I don’t remember. I think we we do already have a
148 00:11:33.140 ⇒ 00:11:35.860 Luke Daque: we shall have all the skus in
149 00:11:37.380 ⇒ 00:11:41.090 Luke Daque: in the All order items model.
150 00:11:41.370 ⇒ 00:11:43.640 Luke Daque: I believe. But let me check.
151 00:11:43.640 ⇒ 00:11:47.609 Nicolas Sucari: In a different account here. Do you know which is a code for?
152 00:11:48.830 ⇒ 00:11:51.129 Nicolas Sucari: Yeah, this one, right?
153 00:11:51.440 ⇒ 00:11:54.940 Luke Daque: Yeah. The cv, one, yeah, yeah.
154 00:11:57.440 ⇒ 00:11:59.970 Nicolas Sucari: Oh, but to log in here I need the.
155 00:12:00.530 ⇒ 00:12:02.109 Luke Daque: Yeah, you need the the code.
156 00:12:02.110 ⇒ 00:12:02.850 Nicolas Sucari: The heck.
157 00:12:04.500 ⇒ 00:12:07.579 Luke Daque: We currently doesn’t look like we have us
158 00:12:08.000 ⇒ 00:12:10.940 Luke Daque: a model for just for skew.
159 00:12:11.310 ⇒ 00:12:13.019 Nicolas Sucari: No, I think we don’t have.
160 00:12:13.300 ⇒ 00:12:13.960 Luke Daque: Yeah.
161 00:12:14.310 ⇒ 00:12:18.080 Nicolas Sucari: But in order, email orders, yeah, maybe we can see there right.
162 00:12:18.430 ⇒ 00:12:23.960 Luke Daque: Yeah, in all order items, it would be in all order items, because skew is tied up to products.
163 00:12:26.470 ⇒ 00:12:34.250 Luke Daque: Yeah. And and this all order items should already have all orders from Walmart, from shopify from Amazon.
164 00:12:37.342 ⇒ 00:12:45.865 Luke Daque: Do do we have any other sources for skew? Aside from those 3, Walmart, Walmart, Amazon, and
165 00:12:48.780 ⇒ 00:12:55.860 Nicolas Sucari: Not from not from orders, but like, if we wanna check inventory and that kind of stuff, we have a list.
166 00:12:57.830 ⇒ 00:12:58.760 Nicolas Sucari: And yeah.
167 00:13:00.710 ⇒ 00:13:01.400 Luke Daque: I see.
168 00:13:01.910 ⇒ 00:13:07.709 Nicolas Sucari: Maybe it’s that. But yeah, maybe we can do next hour from
169 00:13:10.010 ⇒ 00:13:14.659 Nicolas Sucari: okay. But yeah, we should like, try to get all of the.
170 00:13:15.340 ⇒ 00:13:17.749 Luke Daque: Yeah, I can. I can share my screen, maybe. And.
171 00:13:17.750 ⇒ 00:13:21.259 Nicolas Sucari: Yeah, okay, you’re gonna be faster than me doing that.
172 00:13:21.310 ⇒ 00:13:25.640 Nicolas Sucari: I don’t know how to do all of those ones cool.
173 00:13:25.640 ⇒ 00:13:27.239 Luke Daque: Problem. Can you see my screen.
174 00:13:27.430 ⇒ 00:13:28.630 Nicolas Sucari: Yeah, perfect.
175 00:13:28.630 ⇒ 00:13:31.739 Luke Daque: So I did a just selecting the
176 00:13:32.604 ⇒ 00:13:40.589 Luke Daque: distinct skews, and it looks like it from all order items. There’s only 684 you could.
177 00:13:40.590 ⇒ 00:13:41.240 Nicolas Sucari: Okay.
178 00:13:41.840 ⇒ 00:13:48.490 Luke Daque: Compared to the sheet, the Google, I mean the the Csv file. There’s actually more. There’s like 6,000.
179 00:13:48.900 ⇒ 00:13:58.149 Luke Daque: So yeah, that’s a lot, and it looks like skew would be.
180 00:13:58.150 ⇒ 00:14:03.389 Nicolas Sucari: But you, you there are. There are some that are not active, so maybe we can filter that file
181 00:14:03.630 ⇒ 00:14:04.129 Nicolas Sucari: or do you.
182 00:14:04.130 ⇒ 00:14:04.620 Luke Daque: Active, one.
183 00:14:04.620 ⇒ 00:14:05.760 Nicolas Sucari: Let me check.
184 00:14:06.220 ⇒ 00:14:06.670 Nicolas Sucari: Okay.
185 00:14:07.760 ⇒ 00:14:09.390 Luke Daque: Do let me create.
186 00:14:09.390 ⇒ 00:14:09.960 Nicolas Sucari: I’m doing. Yeah.
187 00:14:09.960 ⇒ 00:14:14.230 Luke Daque: Table, then insert pivot table.
188 00:14:14.510 ⇒ 00:14:15.940 Nicolas Sucari: And check the active.
189 00:14:15.940 ⇒ 00:14:16.930 Nicolas Sucari: Okay.
190 00:14:17.600 ⇒ 00:14:21.639 Luke Daque: Active status on a type. It’s skew.
191 00:14:21.860 ⇒ 00:14:25.780 Luke Daque: Item, what’s it called?
192 00:14:26.060 ⇒ 00:14:27.290 Luke Daque: Item, yeah.
193 00:14:30.880 ⇒ 00:14:32.590 Nicolas Sucari: There are 5,000.
194 00:14:32.590 ⇒ 00:14:33.970 Luke Daque: Yeah, they’re still unlocked.
195 00:14:34.380 ⇒ 00:14:42.609 Nicolas Sucari: Yeah. But do you know why? Because we have. I think that there are a lot of skews that are like, there is another field that’s called type. Yeah, the second column.
196 00:14:42.640 ⇒ 00:14:47.070 Nicolas Sucari: and we have like skews for discount, you know.
197 00:14:47.480 ⇒ 00:14:54.539 Nicolas Sucari: Excuse for tax sales. Tax. Item, item service. Let me see.
198 00:14:54.540 ⇒ 00:14:58.700 Luke Daque: Yeah. So it looks like most of these are non inventory part. If you look at here
199 00:14:59.150 ⇒ 00:15:00.260 Luke Daque: in the pivot.
200 00:15:00.910 ⇒ 00:15:02.120 Nicolas Sucari: Yeah, exactly.
201 00:15:02.120 ⇒ 00:15:06.170 Luke Daque: So maybe all of these are so. If you remove that.
202 00:15:07.260 ⇒ 00:15:10.220 Nicolas Sucari: Yeah, it’s it’s kind of strange.
203 00:15:16.930 ⇒ 00:15:20.230 Luke Daque: So if we don’t include non inventory part.
204 00:15:20.610 ⇒ 00:15:23.490 Luke Daque: that’s only 268,
205 00:15:27.810 ⇒ 00:15:34.379 Luke Daque: and if we include they’ve non active.
206 00:15:35.070 ⇒ 00:15:38.289 Luke Daque: That would be 769, and we got what?
207 00:15:38.430 ⇒ 00:15:44.540 Luke Daque: 500, a 684, which is pretty close, I think.
208 00:15:44.710 ⇒ 00:15:47.360 Nicolas Sucari: Yeah, yeah, pretty close.
209 00:15:47.530 ⇒ 00:15:49.780 Nicolas Sucari: 684 against.
210 00:15:54.150 ⇒ 00:15:58.549 Luke Daque: Yeah, 684, 683 against 769.
211 00:15:58.870 ⇒ 00:16:01.450 Nicolas Sucari: Yeah, yeah.
212 00:16:03.790 ⇒ 00:16:04.240 Luke Daque: But we.
213 00:16:04.700 ⇒ 00:16:07.000 Nicolas Sucari: You have been known. Okay.
214 00:16:07.530 ⇒ 00:16:10.099 Luke Daque: Yeah, this is including the non-active.
215 00:16:10.680 ⇒ 00:16:13.730 Nicolas Sucari: Okay, the the goal is to clean up.
216 00:16:13.790 ⇒ 00:16:14.829 Nicolas Sucari: I think.
217 00:16:14.900 ⇒ 00:16:22.255 Nicolas Sucari: like this list, the skill, like the the skills in each of the different platforms and sources, so that they have, like,
218 00:16:22.740 ⇒ 00:16:28.250 Nicolas Sucari: normalized skew, least for every platform and and source. Okay.
219 00:16:28.650 ⇒ 00:16:31.860 Nicolas Sucari: what we need to do is like, okay, we’ve seen that we have like
220 00:16:31.930 ⇒ 00:16:34.499 Nicolas Sucari: 700 in I don’t know in shopify.
221 00:16:34.500 ⇒ 00:16:34.830 Luke Daque: Shield.
222 00:16:34.830 ⇒ 00:16:39.839 Nicolas Sucari: And in Amazon we have something in the sheet. Okay? And we need to create, like the
223 00:16:40.690 ⇒ 00:16:45.760 Nicolas Sucari: like, the the definite list of skews right.
224 00:16:50.390 ⇒ 00:16:54.429 Luke Daque: So I guess something like this. It has the selling plat. It has the platform.
225 00:16:54.750 ⇒ 00:16:55.660 Luke Daque: Yeah.
226 00:16:56.490 ⇒ 00:17:02.250 Nicolas Sucari: And I think you should have like duplicates in in this case, between Shopify and Amazon. Right.
227 00:17:02.250 ⇒ 00:17:05.299 Luke Daque: Right? Yeah, that’s why it’s like going to 800. Something.
228 00:17:05.300 ⇒ 00:17:06.520 Nicolas Sucari: Yeah, exactly.
229 00:17:06.579 ⇒ 00:17:14.329 Nicolas Sucari: So maybe you can go with product skew and see if you can. If you can check by by skew and see if you’ve got them in
230 00:17:14.956 ⇒ 00:17:20.269 Nicolas Sucari: Shopify and Amazon or Amazon, right like in the different columns, if it is.
231 00:17:22.879 ⇒ 00:17:24.539 Luke Daque: What’s the correct?
232 00:17:34.579 ⇒ 00:17:35.759 Luke Daque: This tag.
233 00:17:36.110 ⇒ 00:17:36.760 Nicolas Sucari: List.
234 00:17:43.330 ⇒ 00:17:44.090 Nicolas Sucari: Yeah.
235 00:17:46.610 ⇒ 00:17:47.620 Luke Daque: That’s important.
236 00:17:47.620 ⇒ 00:17:48.220 Luke Daque: Nice.
237 00:17:49.320 ⇒ 00:17:53.730 Luke Daque: Yep, there you go. So this should still be 683. Yep.
238 00:17:54.170 ⇒ 00:17:56.580 Luke Daque: and if there’s like multiple that would be like.
239 00:17:57.880 ⇒ 00:17:58.440 Nicolas Sucari: Yeah.
240 00:17:58.440 ⇒ 00:17:59.520 Luke Daque: Trying. Here.
241 00:18:09.920 ⇒ 00:18:10.670 Luke Daque: Yeah.
242 00:18:12.280 ⇒ 00:18:18.589 Nicolas Sucari: Let’s let’s try to the yeah. Let me see what we can like how to start cleaning.
243 00:18:22.770 ⇒ 00:18:26.149 Nicolas Sucari: Maybe we can get that file.
244 00:18:26.390 ⇒ 00:18:32.419 Nicolas Sucari: They send into Snowflake and try to match with what we have from from this table. Right?
245 00:18:34.540 ⇒ 00:18:35.460 Nicolas Sucari: Excuse.
246 00:18:35.720 ⇒ 00:18:39.929 Luke Daque: You can do that, and like we can add it in like one of the source.
247 00:18:42.168 ⇒ 00:18:46.350 Luke Daque: Tables we have in Etl, I guess, and then
248 00:18:47.080 ⇒ 00:18:49.170 Luke Daque: should have Google sheets or something right?
249 00:18:50.180 ⇒ 00:18:52.000 Luke Daque: Oh, no, no! Brain forge.
250 00:18:52.300 ⇒ 00:18:52.925 Luke Daque: It’s
251 00:18:54.630 ⇒ 00:18:57.249 Nicolas Sucari: I think it’s in 5 trend database.
252 00:18:57.250 ⇒ 00:18:58.100 Luke Daque: Hmm.
253 00:18:58.270 ⇒ 00:18:59.100 Nicolas Sucari: Yeah. Google, sheet.
254 00:18:59.100 ⇒ 00:19:00.060 Luke Daque: Google sheets.
255 00:19:00.350 ⇒ 00:19:02.270 Luke Daque: So I guess we can add it here.
256 00:19:02.510 ⇒ 00:19:02.850 Nicolas Sucari: Yeah.
257 00:19:02.850 ⇒ 00:19:04.669 Luke Daque: We can use 5 tran for that.
258 00:19:04.940 ⇒ 00:19:07.998 Luke Daque: And then do we need to add the
259 00:19:09.200 ⇒ 00:19:12.550 Luke Daque: selling platform in the sheet? So something like
260 00:19:13.850 ⇒ 00:19:17.160 Luke Daque: we still query everything here? And then we add, like what shop.
261 00:19:17.160 ⇒ 00:19:17.900 Nicolas Sucari: Yeah, yeah.
262 00:19:17.900 ⇒ 00:19:18.500 Luke Daque: Selling.
263 00:19:18.500 ⇒ 00:19:19.290 Nicolas Sucari: I think.
264 00:19:19.290 ⇒ 00:19:19.840 Luke Daque: That.
265 00:19:20.040 ⇒ 00:19:34.359 Nicolas Sucari: Yeah, so and and see where which ones include which skills are including that selling platform. And we will have selling platform. And maybe we’ll have like other platforms. So yeah, maybe we’ll need to check that. But let’s start with selling platform. I think that’s fine.
266 00:19:34.460 ⇒ 00:19:35.210 Nicolas Sucari: Right?
267 00:19:35.210 ⇒ 00:19:35.940 Luke Daque: Okay.
268 00:19:36.420 ⇒ 00:19:39.090 Nicolas Sucari: So if we we can do like a quick check between
269 00:19:39.540 ⇒ 00:19:44.959 Nicolas Sucari: and the skews that we have in the selling platforms with this list of the Google sheet
270 00:19:45.140 ⇒ 00:19:47.949 Nicolas Sucari: and see which ones like match.
271 00:19:48.010 ⇒ 00:20:00.419 Nicolas Sucari: I think that’s fine. We can flag them and the ones that don’t match we can like start them looking deeper into why we are not using that skew, and if we needed to clean up or delete it. Okay.
272 00:20:01.420 ⇒ 00:20:08.160 Luke Daque: So let’s let’s do that. Then, or parts.
273 00:20:14.790 ⇒ 00:20:20.389 Nicolas Sucari: There is a Google drive folder with all the sheets. Or you just need to create.
274 00:20:21.540 ⇒ 00:20:23.509 Nicolas Sucari: we’re just gonna add, like the file.
275 00:20:25.800 ⇒ 00:20:34.650 Luke Daque: Yeah, it doesn’t on Csv Google sheets. So I guess we can add this in Google sheets. Then
276 00:20:35.480 ⇒ 00:20:37.449 Luke Daque: let me just create a Google sheet.
277 00:20:37.860 ⇒ 00:20:39.679 Nicolas Sucari: And if you try it like, excel.
278 00:20:39.860 ⇒ 00:20:41.919 Nicolas Sucari: No, you don’t have like a file.
279 00:20:43.330 ⇒ 00:20:53.569 Nicolas Sucari: Or why don’t we? Just yeah, yeah, we can use 5 time, because if not, we, we can like add a database without using 5 time, right? Like, just manually update uploading here.
280 00:20:54.910 ⇒ 00:20:55.700 Luke Daque: Yeah.
281 00:21:00.660 ⇒ 00:21:04.410 Nicolas Sucari: Yeah, if you go there, add data in the in the left.
282 00:21:15.230 ⇒ 00:21:18.289 Luke Daque: Okay, let’s where did I put this.
283 00:21:25.120 ⇒ 00:21:30.190 Nicolas Sucari: I don’t know if this is like the best way to do it, but I I think there’s a file that won’t be changing
284 00:21:30.660 ⇒ 00:21:31.430 Nicolas Sucari: like.
285 00:21:31.430 ⇒ 00:21:36.080 Luke Daque: File type, not I. We need to save it as Csv. Then let me do that.
286 00:21:36.960 ⇒ 00:21:38.950 Nicolas Sucari: And also like, there is a column.
287 00:21:39.690 ⇒ 00:21:41.240 Nicolas Sucari: Yeah, maybe we can.
288 00:21:41.240 ⇒ 00:21:43.330 Luke Daque: Yeah. Let’s remove the column. A.
289 00:21:44.320 ⇒ 00:21:46.070 Nicolas Sucari: Yeah, and.
290 00:21:46.660 ⇒ 00:21:47.560 Luke Daque: Right
291 00:21:51.090 ⇒ 00:21:55.099 Luke Daque: anything. Any other column think they should be fine right?
292 00:21:55.680 ⇒ 00:21:56.280 Nicolas Sucari: Yeah.
293 00:22:02.010 ⇒ 00:22:03.709 Luke Daque: This is Csv.
294 00:22:07.200 ⇒ 00:22:08.040 Luke Daque: okay?
295 00:22:08.600 ⇒ 00:22:12.860 Luke Daque: And then let’s do. Let’s let’s upload that
296 00:22:25.430 ⇒ 00:22:26.790 Luke Daque: What’s wrong?
297 00:22:26.800 ⇒ 00:22:31.260 Luke Daque: Can I need to change my role? Then I don’t have it.
298 00:22:33.176 ⇒ 00:22:34.150 Luke Daque: Roller transform.
299 00:22:34.490 ⇒ 00:22:37.080 Luke Daque: Let’s try it in a different database. Then.
300 00:22:37.830 ⇒ 00:22:38.380 Nicolas Sucari: Yeah.
301 00:22:40.880 ⇒ 00:22:42.260 Luke Daque: This one.
302 00:22:43.990 ⇒ 00:22:49.960 Luke Daque: Let’s just do analytics. For now, Daijing.
303 00:22:50.760 ⇒ 00:22:51.290 Nicolas Sucari: Yeah.
304 00:22:53.700 ⇒ 00:22:55.000 Luke Daque: Create new table.
305 00:22:55.640 ⇒ 00:22:56.210 Nicolas Sucari: Yeah.
306 00:22:59.700 ⇒ 00:23:01.539 Nicolas Sucari: Still. Here. Okay.
307 00:23:02.280 ⇒ 00:23:05.320 Luke Daque: Skew list oops.
308 00:23:10.600 ⇒ 00:23:11.580 Luke Daque: Okay, let’s
309 00:23:23.910 ⇒ 00:23:24.435 Luke Daque: hmm.
310 00:23:29.790 ⇒ 00:23:30.800 Nicolas Sucari: That’s text.
311 00:23:53.560 ⇒ 00:23:54.415 Nicolas Sucari: Okay.
312 00:24:09.150 ⇒ 00:24:10.129 Luke Daque: Let’s try it.
313 00:24:22.830 ⇒ 00:24:24.580 Luke Daque: Yeah, okay.
314 00:24:25.820 ⇒ 00:24:26.590 Nicolas Sucari: Yeah.
315 00:24:29.000 ⇒ 00:24:30.089 Luke Daque: So we can.
316 00:24:31.890 ⇒ 00:24:33.379 Luke Daque: We can try to
317 00:25:02.780 ⇒ 00:25:04.820 Luke Daque: It’s called. Item.
318 00:25:25.260 ⇒ 00:25:26.050 Luke Daque: this.
319 00:25:27.480 ⇒ 00:25:29.390 Nicolas Sucari: Dude, you are so fast on this.
320 00:25:31.470 ⇒ 00:25:38.320 Luke Daque: So it looks like there’s a there’s no blanks like this doesn’t exist. It looks like in there.
321 00:25:38.320 ⇒ 00:25:42.889 Nicolas Sucari: In the selling platform. Yeah, but it’s not active. So.
322 00:25:43.889 ⇒ 00:25:47.389 Luke Daque: Yeah, that’s probably why. But this one is active, though.
323 00:25:47.390 ⇒ 00:25:53.119 Nicolas Sucari: Yeah, yeah, we should check for yeah, yeah, we should not look at the active status. Maybe.
324 00:26:01.630 ⇒ 00:26:03.600 Luke Daque: Do this just this one.
325 00:26:04.340 ⇒ 00:26:06.590 Luke Daque: So yeah, this doesn’t exist.
326 00:26:06.750 ⇒ 00:26:07.590 Nicolas Sucari: Okay.
327 00:26:11.230 ⇒ 00:26:17.264 Nicolas Sucari: let’s let’s try. Can you do like, just let’s join where?
328 00:26:18.500 ⇒ 00:26:22.180 Nicolas Sucari: we only have them in this selling platform, so we can see if the
329 00:26:22.340 ⇒ 00:26:26.870 Nicolas Sucari: if this Google sheet contains all of the skews
330 00:26:26.910 ⇒ 00:26:28.699 Nicolas Sucari: that we have in the selling platforms.
331 00:26:29.750 ⇒ 00:26:31.280 Luke Daque: Let me do a right, join.
332 00:26:31.280 ⇒ 00:26:34.510 Nicolas Sucari: Right? Join, yeah, okay, okay.
333 00:26:37.230 ⇒ 00:26:38.269 Luke Daque: So there are.
334 00:26:38.720 ⇒ 00:26:39.713 Luke Daque: There are
335 00:26:40.790 ⇒ 00:26:41.560 Nicolas Sucari: No rules.
336 00:26:41.900 ⇒ 00:26:46.030 Luke Daque: Yeah, no. So like they don’t exist in the Google sheet.
337 00:26:49.190 ⇒ 00:26:54.329 Luke Daque: Like, if we add the skew like this one, or maybe because, like, it has a dash.
338 00:26:54.330 ⇒ 00:26:55.420 Nicolas Sucari: Okay. Okay.
339 00:26:55.420 ⇒ 00:27:01.489 Luke Daque: Or like this, one doesn’t exist, though. So if we search that here.
340 00:27:04.990 ⇒ 00:27:08.520 Nicolas Sucari: And what if you like, get rid of the space in the middle.
341 00:27:10.960 ⇒ 00:27:15.489 Luke Daque: Yeah, it still doesn’t exist, because the others that start with A/C have spaces. So.
342 00:27:15.490 ⇒ 00:27:16.420 Nicolas Sucari: Yeah, yeah.
343 00:27:19.720 ⇒ 00:27:22.050 Luke Daque: So I guess these we can add.
344 00:27:22.780 ⇒ 00:27:25.197 Luke Daque: like the node we’re at where
345 00:27:25.600 ⇒ 00:27:26.850 Nicolas Sucari: To the selling platform.
346 00:27:27.450 ⇒ 00:27:30.460 Luke Daque: Yeah, to the to the Google, to the sales.
347 00:27:30.460 ⇒ 00:27:32.119 Nicolas Sucari: To the Google sheet, okay.
348 00:27:32.120 ⇒ 00:27:33.880 Luke Daque: Right the the missing ones.
349 00:27:34.380 ⇒ 00:27:37.230 Luke Daque: But then we’ll have to find out these.
350 00:27:37.510 ⇒ 00:27:40.050 Nicolas Sucari: Yeah, yeah, everything. No, yeah. That’s fine.
351 00:27:40.660 ⇒ 00:27:47.290 Luke Daque: Because I think like if I remember Utam did say.
352 00:27:53.510 ⇒ 00:27:55.379 Luke Daque: if it’s missing anything.
353 00:27:55.870 ⇒ 00:27:59.790 Nicolas Sucari: Yeah. So I guess we can add this, these are the missing missed.
354 00:27:59.790 ⇒ 00:28:05.589 Nicolas Sucari: Yeah, let’s send that list of the the ones that are missing from the sending platforms. I think that’s great.
355 00:28:06.412 ⇒ 00:28:12.220 Nicolas Sucari: And also I’m we don’t have like Walmart designing platform right?
356 00:28:13.940 ⇒ 00:28:15.850 Nicolas Sucari: It’s just shopify. And Amazon.
357 00:28:16.450 ⇒ 00:28:18.270 Nicolas Sucari: We don’t have skews from.
358 00:28:19.650 ⇒ 00:28:20.849 Luke Daque: One more time.
359 00:28:28.310 ⇒ 00:28:29.520 Nicolas Sucari: Yeah, there’s Walmart.
360 00:28:29.520 ⇒ 00:28:31.139 Nicolas Sucari: Oh, yeah, yeah, there is. Sorry.
361 00:28:46.850 ⇒ 00:28:50.509 Luke Daque: So this would be the missing skews. There’s 204
362 00:28:50.910 ⇒ 00:28:53.340 Luke Daque: missing skews that we can add.
363 00:28:55.760 ⇒ 00:28:56.480 Nicolas Sucari: Perfect.
364 00:28:57.360 ⇒ 00:29:01.850 Nicolas Sucari: So from the 683 that we got 200
365 00:29:02.250 ⇒ 00:29:06.199 Nicolas Sucari: approximately, we’re not in that list, and 400 years.
366 00:29:06.370 ⇒ 00:29:07.640 Luke Daque: Yes, that’s correct.
367 00:29:08.010 ⇒ 00:29:12.540 Nicolas Sucari: Okay, 480, something. Okay? That’s fine.
368 00:29:12.660 ⇒ 00:29:14.330 Nicolas Sucari: Yeah. Maybe we can send.
369 00:29:15.190 ⇒ 00:29:19.739 Luke Daque: Do we need to add the other details, though, like like type. Item.
370 00:29:19.740 ⇒ 00:29:22.520 Nicolas Sucari: No test.
371 00:29:23.326 ⇒ 00:29:34.060 Nicolas Sucari: Let me see, maybe we can do. Do we have we? Do you? Do you want to add to that 1st 2 columns also add more information from the sending platform
372 00:29:34.280 ⇒ 00:29:42.179 Nicolas Sucari: skew list, like we have the name, right? Or the description, or from that excuse.
373 00:29:42.310 ⇒ 00:30:02.989 Nicolas Sucari: Yeah, exactly like. Don’t add it there. I mean I I would just share, like the 2 1st columns to come in that thread or in that channel, and sending saying, hey? We found out that we have, like 200 skews from shopify Amazon and Walmart that are not in the Google sheet. And this is the information that we need to add
374 00:30:04.650 ⇒ 00:30:10.440 Nicolas Sucari: but maybe let’s before sending only those queues. Maybe we can send. We can add there
375 00:30:10.751 ⇒ 00:30:16.480 Nicolas Sucari: like the the name or the description of that skew. We have that in the all order items right.
376 00:30:17.700 ⇒ 00:30:18.740 Luke Daque: Let’s check
377 00:30:22.580 ⇒ 00:30:23.179 Luke Daque: order.
378 00:30:25.660 ⇒ 00:30:27.180 Nicolas Sucari: With our trainings.
379 00:30:28.940 ⇒ 00:30:31.929 Luke Daque: We have product, name and product class.
380 00:30:32.740 ⇒ 00:30:33.719 Nicolas Sucari: Yeah, maybe we can.
381 00:30:40.570 ⇒ 00:30:42.395 Luke Daque: What else do we need?
382 00:30:46.020 ⇒ 00:30:47.160 Luke Daque: I guess. Just that.
383 00:30:47.160 ⇒ 00:30:48.889 Nicolas Sucari: Products. Yeah, I guessed.
384 00:30:50.855 ⇒ 00:30:53.229 Nicolas Sucari: Yeah, I think that’s gay.
385 00:30:53.260 ⇒ 00:30:57.939 Nicolas Sucari: We don’t have anything on cost of the product. And in this Google sheet.
386 00:30:58.780 ⇒ 00:30:59.470 Luke Daque: There’s
387 00:31:05.100 ⇒ 00:31:06.460 Luke Daque: There’s cost.
388 00:31:06.460 ⇒ 00:31:08.929 Nicolas Sucari: They have a cost. Com. Yeah.
389 00:31:09.450 ⇒ 00:31:14.700 Nicolas Sucari: okay, maybe if we can add the cost, I think that’s fine and
390 00:31:15.270 ⇒ 00:31:20.000 Nicolas Sucari: preferred vendor. Now, tax agency price? Do you have price also.
391 00:31:22.030 ⇒ 00:31:23.699 Luke Daque: Item, sale, price.
392 00:31:23.700 ⇒ 00:31:24.940 Nicolas Sucari: Yeah, okay?
393 00:31:26.670 ⇒ 00:31:34.059 Nicolas Sucari: And no. Then we have like, pack cubes packaging. Yeah, I think that’s fine.
394 00:31:35.310 ⇒ 00:31:36.670 Luke Daque: Let’s try.
395 00:31:46.780 ⇒ 00:31:49.830 Nicolas Sucari: Yeah, cool. So we have the 200 here or.
396 00:31:50.640 ⇒ 00:31:54.650 Luke Daque: Yeah, this should be the 200. Wait. Why is that recognized?
397 00:31:54.690 ⇒ 00:32:00.120 Luke Daque: I guess there are different names for the same skew
398 00:32:00.470 ⇒ 00:32:02.720 Luke Daque: or different prices like this one.
399 00:32:02.720 ⇒ 00:32:03.960 Nicolas Sucari: Oh, okay.
400 00:32:04.240 ⇒ 00:32:08.810 Luke Daque: This different sale price, but the same skew.
401 00:32:10.030 ⇒ 00:32:14.579 Luke Daque: this one to different item price. But the same skew, which is.
402 00:32:17.080 ⇒ 00:32:21.969 Luke Daque: I don’t know why that’s happening. Maybe they they’re selling it for a different price. That’s why.
403 00:32:21.970 ⇒ 00:32:26.939 Nicolas Sucari: Cost. The cost is okay. Right? So maybe let’s get rid of the item sale price that. Yeah.
404 00:32:27.450 ⇒ 00:32:33.700 Nicolas Sucari: if we get rid of item sale price this, that’s 200.
405 00:32:33.840 ⇒ 00:32:35.570 Luke Daque: 300.
406 00:32:35.570 ⇒ 00:32:37.829 Nicolas Sucari: Okay, so cost should be also.
407 00:32:39.355 ⇒ 00:32:45.730 Luke Daque: This one have, like no skew, but have a product name. I’m not sure why this is.
408 00:32:45.730 ⇒ 00:32:47.790 Nicolas Sucari: Yeah, I don’t know.
409 00:32:47.790 ⇒ 00:32:49.760 Luke Daque: Yeah, that’s a different problem.
410 00:32:50.120 ⇒ 00:32:53.439 Luke Daque: This one is the same. Oh, no, it’s.
411 00:32:53.440 ⇒ 00:32:57.929 Nicolas Sucari: Oh, say, different product names, different product, names. HP.
412 00:32:58.190 ⇒ 00:33:02.719 Luke Daque: No, it’s it’s a different skew as well. A and D, and this one is hnd.
413 00:33:02.720 ⇒ 00:33:04.339 Nicolas Sucari: No, yeah, that one. But then, if you.
414 00:33:04.340 ⇒ 00:33:08.860 Luke Daque: Yeah, yeah, this one, yeah, different product names that sucks.
415 00:33:09.260 ⇒ 00:33:13.740 Nicolas Sucari: Okay, but maybe we can send these and ask them to clean.
416 00:33:15.040 ⇒ 00:33:23.180 Nicolas Sucari: I don’t know. And can you can you add here the appsource, the like? Walmart.
417 00:33:23.180 ⇒ 00:33:23.510 Luke Daque: Yeah.
418 00:33:27.376 ⇒ 00:33:32.929 Nicolas Sucari: Okay, I don’t know. What do you say? Send this like this, or just this queue and
419 00:33:33.280 ⇒ 00:33:35.750 Nicolas Sucari: and selling platform as we had before.
420 00:33:38.750 ⇒ 00:33:40.806 Luke Daque: Yeah, this should be fine, I guess.
421 00:33:41.240 ⇒ 00:33:43.369 Luke Daque: But yeah, there’s duplicates here.
422 00:33:44.950 ⇒ 00:33:51.560 Nicolas Sucari: Okay, let’s send this. I think that’s okay. And we can explain. Okay.
423 00:33:51.560 ⇒ 00:33:56.129 Luke Daque: Okay. Let me save this as Csv, and maybe I can send it as Csv.
424 00:33:56.730 ⇒ 00:33:57.219 Nicolas Sucari: Yeah, okay.
425 00:33:59.030 ⇒ 00:34:02.319 Luke Daque: But I’ll I guess I’ll I’ll just exclude this nulls.
426 00:34:02.970 ⇒ 00:34:04.390 Nicolas Sucari: Okay. Yeah.
427 00:34:05.760 ⇒ 00:34:07.499 Luke Daque: So let’s just delete this.
428 00:34:08.710 ⇒ 00:34:09.320 Nicolas Sucari: Yeah.
429 00:34:20.480 ⇒ 00:34:22.710 Luke Daque: That this would be missing. Skews.
430 00:34:23.409 ⇒ 00:34:27.549 Nicolas Sucari: So these are missing skews from Shopify Amazon and Walmart. Right.
431 00:34:28.409 ⇒ 00:34:33.329 Luke Daque: Yes, shopify Amazon.
432 00:35:19.479 ⇒ 00:35:26.269 Luke Daque: And then can I just like drag and drop this.
433 00:35:27.200 ⇒ 00:35:28.890 Nicolas Sucari: Yep, I think you can.
434 00:35:29.670 ⇒ 00:35:30.590 Luke Daque: Try
435 00:35:36.150 ⇒ 00:35:37.090 Luke Daque: what happened.
436 00:35:38.570 ⇒ 00:35:39.890 Luke Daque: I don’t think it.
437 00:35:40.980 ⇒ 00:35:42.129 Luke Daque: Oh, there you go!
438 00:35:42.360 ⇒ 00:35:42.950 Nicolas Sucari: Yeah.
439 00:36:23.330 ⇒ 00:36:27.330 Luke Daque: Anything else we need to add here.
440 00:36:27.330 ⇒ 00:36:28.300 Nicolas Sucari: No.
441 00:36:32.640 ⇒ 00:36:38.660 Nicolas Sucari: I’ll I’ll say, like, Do you? Do you want to try explaining like these, are
442 00:36:39.080 ⇒ 00:36:42.080 Nicolas Sucari: there? There will be like duplicate skews?
443 00:36:42.440 ⇒ 00:36:44.419 Nicolas Sucari: Yeah, I different product names.
444 00:36:44.570 ⇒ 00:36:45.759 Luke Daque: I mentioned it here so.
445 00:36:46.425 ⇒ 00:36:51.000 Nicolas Sucari: Okay, okay, yeah, I think that’s fine. I mean.
446 00:36:51.100 ⇒ 00:36:54.009 Nicolas Sucari: we need to start adding that to the skew list. And then
447 00:36:54.070 ⇒ 00:36:58.019 Nicolas Sucari: what we can start doing also is trying to see
448 00:36:59.291 ⇒ 00:37:06.840 Nicolas Sucari: which skills we have in the sending platforms are active and which ones not like which ones have orders in the past. I don’t know.
449 00:37:08.330 ⇒ 00:37:10.879 Nicolas Sucari: Couple of months, maybe. What do you think?
450 00:37:11.420 ⇒ 00:37:14.219 Nicolas Sucari: Because maybe we have like a lot of skews in that
451 00:37:14.480 ⇒ 00:37:17.020 Nicolas Sucari: least that are not being used right.
452 00:37:18.720 ⇒ 00:37:25.589 Luke Daque: Yeah, let’s try adding the created date. It’s there, the order date. So the maximum order date. I guess.
453 00:37:25.590 ⇒ 00:37:27.119 Nicolas Sucari: Already. Late. Yeah.
454 00:37:37.720 ⇒ 00:37:42.970 Luke Daque: Then let’s try to sort this from smallest or like.
455 00:37:43.620 ⇒ 00:37:49.189 Luke Daque: yeah, this probably would be inactive, right? Because, like last order was 2020.
456 00:37:50.050 ⇒ 00:37:57.529 Nicolas Sucari: What’s let me give me the let me check in the excel file. What was the skew for that one.
457 00:37:59.010 ⇒ 00:38:03.350 Luke Daque: Oh, this doesn’t exist in that file, though.
458 00:38:04.076 ⇒ 00:38:04.829 Nicolas Sucari: Okay. Okay.
459 00:38:04.830 ⇒ 00:38:07.245 Luke Daque: Because we we filtered this to just
460 00:38:07.590 ⇒ 00:38:08.110 Nicolas Sucari: Okay.
461 00:38:08.110 ⇒ 00:38:09.939 Luke Daque: The ones that did not exist. Yeah.
462 00:38:10.760 ⇒ 00:38:16.900 Nicolas Sucari: Yeah, but this is a warranty. You see, product class warranty.
463 00:38:17.250 ⇒ 00:38:18.170 Nicolas Sucari: So.
464 00:38:20.490 ⇒ 00:38:24.489 Luke Daque: Right, this one, though. Pool accessory. It’s also very.
465 00:38:25.080 ⇒ 00:38:26.030 Luke Daque: Oh, yeah.
466 00:38:31.070 ⇒ 00:38:35.330 Luke Daque: So I don’t know why that’s happening.
467 00:38:38.300 ⇒ 00:38:42.710 Luke Daque: And this Washington.
468 00:38:56.270 ⇒ 00:39:01.279 Luke Daque: okay? So what else do we do?
469 00:39:02.640 ⇒ 00:39:11.800 Nicolas Sucari: Okay, I think with these, we’re okay. So I I don’t know. Let me check hold on
470 00:39:12.020 ⇒ 00:39:12.910 Nicolas Sucari: peace.
471 00:39:19.660 ⇒ 00:39:24.690 Nicolas Sucari: So we need to start like trying to identify which skills should we deactivate? Right?
472 00:39:29.140 ⇒ 00:39:32.799 Nicolas Sucari: So yeah, maybe we can like, understand, if that list
473 00:39:33.460 ⇒ 00:39:39.620 Nicolas Sucari: like, if from the entire list of skew from the from Shopify Amazon or Walmart.
474 00:39:39.730 ⇒ 00:39:43.240 Nicolas Sucari: like which ones were used in the past year, maybe.
475 00:39:43.320 ⇒ 00:39:50.360 Nicolas Sucari: and if there were, and and the others ones like the the ones that doesn’t have orders. They they don’t have orders in the in in a year.
476 00:39:50.440 ⇒ 00:39:56.440 Nicolas Sucari: Maybe we can set them for deactivation right? Or maybe we can ask them which ones to keep and which ones to deactivate.
477 00:39:58.210 ⇒ 00:40:01.640 Luke Daque: Yeah, we can ask them. But we can, yeah, or we can.
478 00:40:02.370 ⇒ 00:40:04.709 Luke Daque: Yeah, we won’t know right unless.
479 00:40:04.710 ⇒ 00:40:08.669 Nicolas Sucari: Oh, yeah, we can share that. We can share that like, hey, we are seeing all of these.
480 00:40:08.670 ⇒ 00:40:09.090 Luke Daque: Yeah.
481 00:40:09.090 ⇒ 00:40:09.860 Nicolas Sucari: Queues.
482 00:40:10.480 ⇒ 00:40:15.549 Nicolas Sucari: But this is, these are only the ones that are not in the in the in the other list, right.
483 00:40:15.880 ⇒ 00:40:16.279 Luke Daque: Because they.
484 00:40:16.280 ⇒ 00:40:16.820 Nicolas Sucari: I think we should.
485 00:40:16.820 ⇒ 00:40:23.689 Luke Daque: That other list has the has the status active and inactive, right like he.
486 00:40:23.690 ⇒ 00:40:26.099 Nicolas Sucari: Yeah, but we don’t know if if the active ones
487 00:40:26.340 ⇒ 00:40:26.920 Luke Daque: And have a lot.
488 00:40:26.920 ⇒ 00:40:28.360 Nicolas Sucari: Orders or not, right.
489 00:40:29.160 ⇒ 00:40:35.119 Luke Daque: Gotcha. So we can add a like, aside from adding a selling platform. Here, we can also add a last link
490 00:40:35.120 ⇒ 00:40:37.255 Luke Daque: disordered. Yeah, okay.
491 00:40:38.070 ⇒ 00:40:51.260 Nicolas Sucari: I think that’s gonna be great. Yeah. And we can share that to saying, Hey, we have, like all of these lists that you send us with the latest order, and also, like these 2 other 200 skews were not. Con were not in this list.
492 00:40:51.541 ⇒ 00:40:56.060 Nicolas Sucari: And we can add also the latest order for those ones and see which ones they wanna keep
493 00:40:56.120 ⇒ 00:41:00.600 Nicolas Sucari: right. They can filter by course and by latest order, and see.
494 00:41:00.890 ⇒ 00:41:01.350 Luke Daque: Yeah.
495 00:41:01.350 ⇒ 00:41:03.320 Nicolas Sucari: Ones to keep, and which ones to deactivate.
496 00:41:03.700 ⇒ 00:41:04.960 Luke Daque: Makes sense.
497 00:41:06.580 ⇒ 00:41:07.070 Nicolas Sucari: Cool.
498 00:41:07.230 ⇒ 00:41:10.110 Luke Daque: Let’s type again like this service.
499 00:41:11.600 ⇒ 00:41:14.480 Nicolas Sucari: Yeah, I don’t know. Type is kind of strange.
500 00:41:16.055 ⇒ 00:41:23.179 Luke Daque: So do we need to update this Csv file. Then, like we add the 200 for missing skews and then add the 2 columns.
501 00:41:23.770 ⇒ 00:41:26.570 Nicolas Sucari: So I’ll say, Yeah, let’s create a new table
502 00:41:26.660 ⇒ 00:41:28.900 Nicolas Sucari: with the information with the skew.
503 00:41:29.100 ⇒ 00:41:34.969 Nicolas Sucari: the active status. And yeah, that 2 columns that we are talking about, and see if we can
504 00:41:35.100 ⇒ 00:41:37.690 Nicolas Sucari: like. Share that to them again.
505 00:41:37.930 ⇒ 00:41:40.520 Nicolas Sucari: and see what what is their answer? Right.
506 00:41:41.270 ⇒ 00:41:46.450 Luke Daque: Okay, so maybe we can utilize the same Csv file, because I think they would
507 00:41:46.770 ⇒ 00:41:51.529 Luke Daque: prefer that right? So let’s just add the missing skews here.
508 00:41:52.400 ⇒ 00:41:52.990 Nicolas Sucari: Yeah.
509 00:41:54.300 ⇒ 00:41:58.280 Luke Daque: And yeah.
510 00:42:00.440 ⇒ 00:42:01.470 Nicolas Sucari: Okay. Yeah.
511 00:42:01.480 ⇒ 00:42:05.130 Luke Daque: I’ll I’ll reply to this thread and add the
512 00:42:05.550 ⇒ 00:42:09.909 Luke Daque: updated file with the missing 204 skews along with the
513 00:42:10.460 ⇒ 00:42:13.149 Luke Daque: selling platform and latest order date.
514 00:42:13.900 ⇒ 00:42:21.019 Nicolas Sucari: Okay, let me answering that we are going to add these.
515 00:42:22.930 ⇒ 00:42:26.570 Luke Daque: 200 skews, right.
516 00:43:10.890 ⇒ 00:43:11.700 Nicolas Sucari: Okay?
517 00:43:15.360 ⇒ 00:43:17.940 Nicolas Sucari: Okay, great. Yeah. Let’s try doing this
518 00:43:17.990 ⇒ 00:43:20.089 Nicolas Sucari: and share when you have that file. Okay.
519 00:43:20.720 ⇒ 00:43:21.942 Luke Daque: Okay. Sounds good.
520 00:43:22.720 ⇒ 00:43:24.739 Nicolas Sucari: Cool. Thanks, Ryan. Talk to you later.
521 00:43:25.440 ⇒ 00:43:27.776 Luke Daque: Thanks, thanks, Nico. Have a nice rest of your day.