Meeting Title: Javy-Project-Internal-Review Date: 2024-10-31 Meeting participants: Luke Daque, Nicolas Sucari, Payas Parab
WEBVTT
1 00:03:17.340 ⇒ 00:03:18.400 Nicolas Sucari: Hey, Ryan.
2 00:03:20.280 ⇒ 00:03:22.880 Luke Daque: Hi! Nicholas, can you hear me?
3 00:03:24.040 ⇒ 00:03:25.810 Nicolas Sucari: I can hear you. How are you?
4 00:03:26.940 ⇒ 00:03:28.510 Luke Daque: Yeah, I’m doing. Well. How are you?
5 00:03:31.220 ⇒ 00:03:32.859 Nicolas Sucari: Not bad, not bad.
6 00:03:37.880 ⇒ 00:03:40.280 Nicolas Sucari: How’s going your day? All good.
7 00:03:40.930 ⇒ 00:03:46.930 Luke Daque: Yeah, I’ve been working mostly on the the models for okay,
8 00:03:47.760 ⇒ 00:03:51.386 Luke Daque: Georges and Kenda, what is that? The other one?
9 00:03:51.850 ⇒ 00:03:56.689 Luke Daque: Okay? And do. Yeah, yeah, I’m just trying to like, get some help from
10 00:03:56.800 ⇒ 00:04:01.530 Luke Daque: Chat Gpt, and I just got access to copilot as well. So I’m also like
11 00:04:02.460 ⇒ 00:04:03.580 Luke Daque: trying it out
12 00:04:03.600 ⇒ 00:04:04.829 Luke Daque: to see like.
13 00:04:05.640 ⇒ 00:04:06.620 Nicolas Sucari: Excellent.
14 00:04:06.620 ⇒ 00:04:08.150 Luke Daque: Stuff like that. But yeah.
15 00:04:09.800 ⇒ 00:04:16.589 Luke Daque: yeah, aside from that for pool parts, nothing really much going on. I haven’t really started with the returns yet.
16 00:04:17.495 ⇒ 00:04:18.090 Luke Daque: Cause
17 00:04:18.870 ⇒ 00:04:24.800 Luke Daque: we don’t have we. I know we got just we already got the access to shopify, but I haven’t checked it yet.
18 00:04:24.910 ⇒ 00:04:26.770 Luke Daque: I can work on that as well.
19 00:04:27.600 ⇒ 00:04:29.940 Nicolas Sucari: Yeah, I think I think once we
20 00:04:29.970 ⇒ 00:04:34.289 Nicolas Sucari: have, like the 1st version of the Okendo and gorgeous data.
21 00:04:34.730 ⇒ 00:04:35.420 Luke Daque: Yeah.
22 00:04:35.420 ⇒ 00:04:41.430 Nicolas Sucari: Table. We can then change to refunds and returns. Don’t spend too much time doing
23 00:04:41.440 ⇒ 00:04:42.940 Nicolas Sucari: something so
24 00:04:43.170 ⇒ 00:04:48.384 Nicolas Sucari: like specific to Kendon Gorges. Just let’s create a table and see what we have there.
25 00:04:49.130 ⇒ 00:04:49.550 Luke Daque: Dan.
26 00:04:49.890 ⇒ 00:04:50.720 Nicolas Sucari: Yeah.
27 00:04:50.910 ⇒ 00:04:54.340 Nicolas Sucari: And then we can yeah, move forward trying to
28 00:04:54.860 ⇒ 00:04:58.230 Nicolas Sucari: do some edits or what we need there. Okay.
29 00:04:58.590 ⇒ 00:05:00.119 Luke Daque: Yeah, sure. Sounds good.
30 00:05:01.840 ⇒ 00:05:11.350 Nicolas Sucari: I think, for them. It’s more important. Well, pay us needed the refunds and returns information. So maybe we can move forward with that and checking.
31 00:05:11.580 ⇒ 00:05:16.109 Nicolas Sucari: If our data is correct with what we have from shopify. So.
32 00:05:16.110 ⇒ 00:05:16.820 Luke Daque: Yeah.
33 00:05:18.300 ⇒ 00:05:19.040 Luke Daque: okay.
34 00:05:21.000 ⇒ 00:05:32.260 Nicolas Sucari: Cool and then we’ll what do you think we should create like a new table with like joining information from a cando, gorgeous
35 00:05:32.320 ⇒ 00:05:36.600 Nicolas Sucari: shopify and Amazon like to have information about
36 00:05:37.995 ⇒ 00:05:40.440 Nicolas Sucari: more on on.
37 00:05:41.110 ⇒ 00:05:44.900 Nicolas Sucari: like on. I don’t know. Product reviews.
38 00:05:45.350 ⇒ 00:05:46.919 Nicolas Sucari: feedback that
39 00:05:47.500 ⇒ 00:05:51.760 Nicolas Sucari: get from from a kendo, and maybe I don’t know. Issues and
40 00:05:52.110 ⇒ 00:05:54.829 Nicolas Sucari: agent actions and stuff from gorgeous.
41 00:05:55.140 ⇒ 00:06:02.739 Luke Daque: We can do that. But at this point, just basing on what I’m seeing from the data, I don’t know if there’s a way we can.
42 00:06:03.240 ⇒ 00:06:03.789 Luke Daque: We don’t.
43 00:06:03.790 ⇒ 00:06:04.140 Nicolas Sucari: Join.
44 00:06:04.140 ⇒ 00:06:06.049 Luke Daque: Not yet join them, because, like
45 00:06:06.340 ⇒ 00:06:07.210 Luke Daque: for Canada.
46 00:06:07.640 ⇒ 00:06:12.329 Luke Daque: really have any like external id or something that we can join to.
47 00:06:12.490 ⇒ 00:06:14.849 Luke Daque: gorgeous, for example or shopify.
48 00:06:15.250 ⇒ 00:06:17.450 Luke Daque: But yeah, I think we can.
49 00:06:18.470 ⇒ 00:06:20.449 Luke Daque: We’ll have to find a way
50 00:06:21.010 ⇒ 00:06:26.519 Luke Daque: to to join them. If it’s not based on any kind of Id. Maybe it’s something else.
51 00:06:26.800 ⇒ 00:06:28.910 Luke Daque: We’ll have to figure that out.
52 00:06:30.500 ⇒ 00:06:33.589 Nicolas Sucari: They have an idea, and they have, like a reviewer.
53 00:06:34.180 ⇒ 00:06:34.770 Nicolas Sucari: Thanks, team.
54 00:06:34.770 ⇒ 00:06:35.330 Luke Daque: Yeah.
55 00:06:36.180 ⇒ 00:06:37.799 Luke Daque: yeah, there’s there’s something.
56 00:06:37.980 ⇒ 00:06:42.980 Luke Daque: Yeah, I think there’s a name. Maybe we can do it that way, like email or something.
57 00:06:43.270 ⇒ 00:06:45.500 Nicolas Sucari: Yeah, we have reviewer name, but I don’t know.
58 00:06:45.500 ⇒ 00:06:45.980 Luke Daque: Review.
59 00:06:45.980 ⇒ 00:06:46.850 Nicolas Sucari: Your name?
60 00:06:47.450 ⇒ 00:06:47.990 Nicolas Sucari: Well, yeah.
61 00:06:47.990 ⇒ 00:06:48.500 Luke Daque: Yeah.
62 00:06:48.500 ⇒ 00:06:50.460 Nicolas Sucari: Your name is, okay.
63 00:06:50.890 ⇒ 00:06:51.275 Luke Daque: Yeah.
64 00:06:52.980 ⇒ 00:06:56.519 Nicolas Sucari: And they have full name there they have, like, 1st and last, maybe.
65 00:06:56.520 ⇒ 00:06:57.530 Luke Daque: We can use that.
66 00:06:57.780 ⇒ 00:06:58.490 Luke Daque: Yeah, makes sense.
67 00:06:58.490 ⇒ 00:07:00.600 Nicolas Sucari: In the review table, I think.
68 00:07:01.010 ⇒ 00:07:03.079 Nicolas Sucari: and then for gorgeous.
69 00:07:03.990 ⇒ 00:07:04.940 Nicolas Sucari: let me see.
70 00:07:05.110 ⇒ 00:07:07.439 Nicolas Sucari: for gorgeous. We have a customer table, I think.
71 00:07:08.720 ⇒ 00:07:09.530 Luke Daque: Yeah.
72 00:07:14.910 ⇒ 00:07:16.989 Nicolas Sucari: And there we have.
73 00:07:18.430 ⇒ 00:07:20.580 Nicolas Sucari: We have a name column. Yeah.
74 00:07:21.170 ⇒ 00:07:21.780 Luke Daque: Hmm.
75 00:07:25.480 ⇒ 00:07:29.259 Nicolas Sucari: 1st name. And 1st name, we have. Yeah, okay, yeah, cool.
76 00:07:29.930 ⇒ 00:07:35.459 Nicolas Sucari: Oh, and we have the email. I mean, email is easier in gorgeous in Ovendo. I’m not sure
77 00:07:36.160 ⇒ 00:07:37.550 Nicolas Sucari: if you have the email.
78 00:07:39.180 ⇒ 00:07:42.889 Luke Daque: Yeah, I’ll check it out as well and see if what we can use.
79 00:07:44.320 ⇒ 00:07:46.689 Luke Daque: But yeah, I’ll just create the 1st
80 00:07:47.627 ⇒ 00:07:50.372 Luke Daque: tables, maybe just without probably without
81 00:07:51.190 ⇒ 00:07:52.710 Luke Daque: any.
82 00:07:53.560 ⇒ 00:07:54.100 Nicolas Sucari: Well, here, we
83 00:07:54.480 ⇒ 00:07:55.590 Nicolas Sucari: also, yeah, okay.
84 00:07:55.590 ⇒ 00:07:56.180 Luke Daque: Yeah.
85 00:07:58.380 ⇒ 00:07:59.750 Nicolas Sucari: We can review our email.
86 00:07:59.760 ⇒ 00:08:02.319 Nicolas Sucari: So yeah, we can do it on email name.
87 00:08:03.350 ⇒ 00:08:04.310 Nicolas Sucari: I don’t know.
88 00:08:04.670 ⇒ 00:08:11.240 Nicolas Sucari: And then we will need to match that with like kind of an order, right? We have the order id in ocado.
89 00:08:11.920 ⇒ 00:08:13.150 Luke Daque: I’m seeing it here.
90 00:08:13.560 ⇒ 00:08:15.110 Nicolas Sucari: So I think that’s the best one.
91 00:08:16.180 ⇒ 00:08:17.450 Luke Daque: Okay. Yeah.
92 00:08:19.470 ⇒ 00:08:24.830 Nicolas Sucari: I don’t know which in gorgeous we have it. But yeah, I think you can manage that. I mean, let’s see what we have.
93 00:08:25.120 ⇒ 00:08:26.026 Nicolas Sucari: and see
94 00:08:26.930 ⇒ 00:08:28.830 Nicolas Sucari: where we can match it. Yeah.
95 00:08:29.500 ⇒ 00:08:30.240 Nicolas Sucari: cool.
96 00:08:31.180 ⇒ 00:08:32.130 Luke Daque: So it’s good.
97 00:08:33.559 ⇒ 00:08:34.919 Nicolas Sucari: I don’t know if they ask.
98 00:08:35.669 ⇒ 00:08:37.699 Nicolas Sucari: He’s joining. Let me ping him.
99 00:08:38.610 ⇒ 00:08:42.150 Luke Daque: 5 min. Let’s see if he joins or not.
100 00:08:58.370 ⇒ 00:09:00.610 Nicolas Sucari: And then what I’m what I was.
101 00:09:01.080 ⇒ 00:09:02.660 Nicolas Sucari: I know, if we
102 00:09:02.800 ⇒ 00:09:10.480 Nicolas Sucari: might need to do, too, is to add some dates in the like due dates in the tasks that we created in in notion.
103 00:09:10.590 ⇒ 00:09:12.379 Nicolas Sucari: So if you want to review
104 00:09:12.450 ⇒ 00:09:17.009 Nicolas Sucari: just like an estimation like, when do you think you’re gonna
105 00:09:17.590 ⇒ 00:09:20.090 Nicolas Sucari: like, have those ones done
106 00:09:20.340 ⇒ 00:09:21.219 Nicolas Sucari: trying to add.
107 00:09:21.220 ⇒ 00:09:27.010 Luke Daque: I have something for Okenda. I’ll I’ll I’ll be able to create a Pr today for Okenda and
108 00:09:27.200 ⇒ 00:09:29.800 Luke Daque: Georges, and maybe
109 00:09:30.490 ⇒ 00:09:32.750 Luke Daque: tomorrow I can like work on
110 00:09:33.212 ⇒ 00:09:41.879 Luke Daque: trying to join them to. Yeah, we can do that, either either joining like the shopify stuff and Amazon stuff.
111 00:09:42.130 ⇒ 00:09:46.190 Luke Daque: or I can also do returns tomorrow. It depends. Maybe
112 00:09:46.490 ⇒ 00:09:50.650 Luke Daque: I think maybe returns is a more priority, because, like, it’s
113 00:09:50.920 ⇒ 00:09:54.370 Luke Daque: making sure that the data is accurate. So maybe I can work on that tomorrow.
114 00:09:54.600 ⇒ 00:09:59.339 Luke Daque: but I think I’m already like almost 10 h for
115 00:09:59.560 ⇒ 00:10:01.019 Luke Daque: Javi. That’s also like one of the.
116 00:10:01.020 ⇒ 00:10:01.360 Nicolas Sucari: That’s ring.
117 00:10:01.360 ⇒ 00:10:05.419 Luke Daque: Because if yeah, if I still work on that, then I might be already
118 00:10:05.520 ⇒ 00:10:06.460 Luke Daque: like.
119 00:10:06.460 ⇒ 00:10:06.870 Nicolas Sucari: Okay.
120 00:10:07.100 ⇒ 00:10:09.080 Luke Daque: Going to 4 h.
121 00:10:10.120 ⇒ 00:10:16.410 Nicolas Sucari: Yeah, yeah, that’s fine. I’m I’m gonna I’m gonna talk about that. We do them today. I know also, because
122 00:10:16.650 ⇒ 00:10:34.010 Nicolas Sucari: maybe these these 1st weeks we are doing like all of the like initial stuff that we will need. So maybe we can go over these weeks. I’m gonna ask you some how to manage that. But yeah, I think we will need to go over 10 h this 1st 2, 3 weeks, and then we can reduce that I think.
123 00:10:34.550 ⇒ 00:10:35.720 Luke Daque: Okay. Cool.
124 00:10:36.750 ⇒ 00:10:38.029 Payas Parab: Hey? Guys? Sorry about that?
125 00:10:38.160 ⇒ 00:10:39.449 Payas Parab: Didn’t check my calendar.
126 00:10:40.430 ⇒ 00:10:41.340 Nicolas Sucari: Hey Mayas.
127 00:10:42.470 ⇒ 00:10:43.700 Payas Parab: How you guys doing.
128 00:10:45.590 ⇒ 00:10:47.909 Nicolas Sucari: We’re doing good. We’re just talking about
129 00:10:48.140 ⇒ 00:10:49.010 Nicolas Sucari: yeah
130 00:10:49.200 ⇒ 00:10:50.460 Nicolas Sucari: current tasks.
131 00:10:51.020 ⇒ 00:10:51.950 Payas Parab: Okay, got it?
132 00:10:52.930 ⇒ 00:10:54.460 Nicolas Sucari: How’s been your week going?
133 00:11:00.750 ⇒ 00:11:04.129 Nicolas Sucari: All good? Is your yeah? Is your week going going? Okay?
134 00:11:04.130 ⇒ 00:11:05.350 Payas Parab: Good. Yeah, it’s good. I’m.
135 00:11:05.350 ⇒ 00:11:05.670 Nicolas Sucari: Esh.
136 00:11:05.670 ⇒ 00:11:15.518 Payas Parab: I’ve been jumping to other. I have to jump to like other clients today and tomorrow, but have some Javi stuff like some of the additional work in Meta base and stuff teed up.
137 00:11:15.880 ⇒ 00:11:19.470 Payas Parab: yeah. The only thing that I I had to flag to you guys was the
138 00:11:19.940 ⇒ 00:11:22.000 Payas Parab: the 5 tran Google sheets.
139 00:11:22.616 ⇒ 00:11:23.170 Payas Parab: Thank you.
140 00:11:24.500 ⇒ 00:11:26.499 Luke Daque: Did you already share that to us? I didn’t.
141 00:11:26.500 ⇒ 00:11:29.313 Payas Parab: No, they never shared the sheet, so I can follow up with them.
142 00:11:29.530 ⇒ 00:11:30.050 Luke Daque: Yeah.
143 00:11:30.334 ⇒ 00:11:38.599 Payas Parab: Or we can even just make I I saw that like every time you make a new sheet, it has to be connected each time individually right, and so.
144 00:11:38.600 ⇒ 00:11:39.190 Luke Daque: Yeah.
145 00:11:39.190 ⇒ 00:11:50.069 Payas Parab: I was like, oh, we could make like a dummy sheet and like connect it. But it’s like not trivial to connect it. So I’m just waiting till we get their official sheet. I can just bump them on that again.
146 00:11:51.380 ⇒ 00:11:52.445 Luke Daque: Okay, sounds good.
147 00:11:52.830 ⇒ 00:11:59.239 Luke Daque: But yeah, once we get access to that, it should be pretty straightforward to like, use 5 grand and connect it to 5 grand.
148 00:11:59.240 ⇒ 00:11:59.970 Payas Parab: Yup!
149 00:12:00.540 ⇒ 00:12:07.010 Nicolas Sucari: Yeah. Also, I mean, if if that sheet is not gonna change too much, we can create a table in snowflake and just like
150 00:12:07.080 ⇒ 00:12:12.930 Nicolas Sucari: update that whenever we need to update it right without going through 5. Turn right, Ryan.
151 00:12:13.940 ⇒ 00:12:18.339 Luke Daque: Yeah. But I think 5 trans. Still, the best way to just to automate stuff without.
152 00:12:18.340 ⇒ 00:12:18.899 Nicolas Sucari: Yeah, I mean.
153 00:12:18.900 ⇒ 00:12:20.410 Luke Daque: Stuff, manually, obviously.
154 00:12:20.410 ⇒ 00:12:28.490 Nicolas Sucari: Obviously going without pipeline will mean it’s not automated. And if we there is any update, we are not gonna see it. So yeah, I mean, if
155 00:12:28.580 ⇒ 00:12:33.370 Nicolas Sucari: but if the if the sheet is gonna be like final and fixed information there
156 00:12:33.756 ⇒ 00:12:37.200 Nicolas Sucari: I mean, we can do it also super quick and Snowflake directly.
157 00:12:37.440 ⇒ 00:12:39.259 Nicolas Sucari: Right? That’s another option for us.
158 00:12:39.730 ⇒ 00:12:49.530 Payas Parab: Could you? Could you explain that again? Sorry. I was just bumping it to Aman and them? What? What was the? What? Sorry, if like if we set it up. It’s pretty easy to set it up to connect to Google Sheet.
159 00:12:50.790 ⇒ 00:13:09.140 Nicolas Sucari: No. What I said is like, we can create a like the Google Sheet. It’s gonna be a new table, right? It’s gonna be a new table. But the data source is a Google sheet. What I’m saying is, if that Google sheet is not gonna be changing so much what we can do to speed that like to to have it real quick is to create a table directly in Snowflake
160 00:13:09.430 ⇒ 00:13:12.669 Nicolas Sucari: right? And just have that data there.
161 00:13:12.770 ⇒ 00:13:14.560 Nicolas Sucari: But the
162 00:13:14.780 ⇒ 00:13:20.230 Nicolas Sucari: the cons of that one is that if the Google sheet is being updated, we are not gonna see it.
163 00:13:20.530 ⇒ 00:13:23.529 Nicolas Sucari: So if we wanna see all the changes and like.
164 00:13:24.000 ⇒ 00:13:32.479 Nicolas Sucari: get the new data every time something changes in Google Sheet, we should go with Fivetran. But if that’s not needed right now, we can create a table in snowflake.
165 00:13:32.480 ⇒ 00:13:36.759 Payas Parab: I think they really want the Google sheets, just because, like, that’s what they use internally and like their various.
166 00:13:36.760 ⇒ 00:13:37.330 Nicolas Sucari: Yeah, okay.
167 00:13:37.330 ⇒ 00:13:44.220 Payas Parab: Have a shared sheet. So I think they really want the like. I I actually pitched that to them. I can send you the message. But I I was like.
168 00:13:44.220 ⇒ 00:13:44.580 Nicolas Sucari: Yeah.
169 00:13:44.580 ⇒ 00:13:46.630 Payas Parab: Upload to snowflake your
170 00:13:46.980 ⇒ 00:13:52.190 Payas Parab: file with all the like information. And they were like, we just really prefer Google sheets. So
171 00:13:52.518 ⇒ 00:13:55.401 Payas Parab: I think we just get that set up in general.
172 00:13:55.690 ⇒ 00:13:57.020 Nicolas Sucari: Yeah, yeah, that’s fine.
173 00:13:57.020 ⇒ 00:14:03.430 Payas Parab: Yeah, I I hear them on that, like sometimes, especially like the marketing people, and some of the people in like their Ops teams that do like
174 00:14:03.480 ⇒ 00:14:06.329 Payas Parab: fulfillment shipping and stuff. They’re just like.
175 00:14:06.630 ⇒ 00:14:14.540 Payas Parab: I think they’re just gonna find it easier to share a Google sheet. And I saw in 5 training kind of like, set it each sheet up, and then like, define the name range, and then, like.
176 00:14:14.540 ⇒ 00:14:15.300 Nicolas Sucari: Yeah, yeah.
177 00:14:15.300 ⇒ 00:14:17.390 Payas Parab: How to pull in the table. So we don’t want to just like
178 00:14:17.730 ⇒ 00:14:27.299 Payas Parab: do that unnecessarily until we know exactly what format it’s gonna be in right. That’s that’s what I realize. I think it’s because each sheet needs its own authentication to 5 tran right?
179 00:14:27.960 ⇒ 00:14:29.229 Luke Daque: Yeah, that’s correct.
180 00:14:29.230 ⇒ 00:14:30.540 Payas Parab: Yeah, so that’s why.
181 00:14:30.540 ⇒ 00:14:31.550 Luke Daque: Unless we make like a.
182 00:14:31.550 ⇒ 00:14:39.109 Payas Parab: See if we can get what that sheet will look like, and then and we can upload it. And then 5 channel like load and pull data anytime. The sheets.
183 00:14:39.110 ⇒ 00:14:43.510 Nicolas Sucari: You, Ryan, you you can create like a folder, right? And just
184 00:14:43.640 ⇒ 00:14:44.290 Nicolas Sucari: like Link.
185 00:14:44.290 ⇒ 00:14:45.149 Luke Daque: Yeah, we can.
186 00:14:45.574 ⇒ 00:14:48.624 Luke Daque: There’s like, 2 ways. We can do it. Like if
187 00:14:49.130 ⇒ 00:14:55.729 Luke Daque: we can have just one Google drive like like a folder in Google drive that has, like individual sheets.
188 00:14:55.810 ⇒ 00:15:00.270 Luke Daque: and all of those sheets get consolidated in 5 grand as just one table
189 00:15:01.000 ⇒ 00:15:08.030 Luke Daque: the other thing we can do is we? We have one master sheet in just one Google sheet and then consolidate all the data from the
190 00:15:08.170 ⇒ 00:15:09.680 Luke Daque: other sheets there.
191 00:15:11.230 ⇒ 00:15:12.290 Nicolas Sucari: Like in the same workbook.
192 00:15:12.290 ⇒ 00:15:12.850 Luke Daque: Wonderful.
193 00:15:13.420 ⇒ 00:15:14.730 Nicolas Sucari: On machines. Yeah.
194 00:15:14.730 ⇒ 00:15:16.060 Luke Daque: Yeah, just.
195 00:15:17.060 ⇒ 00:15:26.069 Luke Daque: But I think the the other, the Google drive approach like having one folder with multiple sheets would be probably best way.
196 00:15:26.070 ⇒ 00:15:26.670 Nicolas Sucari: Yeah.
197 00:15:26.670 ⇒ 00:15:32.959 Payas Parab: Is there a way that, like you can just set it up so that, like anything created in a folder is like uploaded as like a.
198 00:15:32.960 ⇒ 00:15:37.750 Luke Daque: Yeah, that’s that’s what I, that’s what I actually yeah, that’s what I meant.
199 00:15:37.990 ⇒ 00:15:42.489 Payas Parab: So then, is there a way we can set like, set that up, basically now and then
200 00:15:42.590 ⇒ 00:15:48.690 Payas Parab: just put in like a dummy sheet, for now and then later, if they drop a different Google sheet in that, folder it like, uploads it as a table.
201 00:15:48.810 ⇒ 00:15:50.600 Luke Daque: Yeah, sure, we can do that.
202 00:15:50.600 ⇒ 00:15:51.759 Payas Parab: We actually set that up.
203 00:15:51.960 ⇒ 00:15:52.839 Luke Daque: Yeah, but we need to know.
204 00:15:52.840 ⇒ 00:15:53.190 Nicolas Sucari: I can.
205 00:15:53.190 ⇒ 00:15:56.229 Luke Daque: Actual field columns and stuff.
206 00:15:57.880 ⇒ 00:16:00.370 Payas Parab: Got it like we have to predefine all the columns.
207 00:16:00.370 ⇒ 00:16:01.986 Luke Daque: Yes, that’s correct. Yep, yep.
208 00:16:02.990 ⇒ 00:16:05.960 Payas Parab: Okay, let me bump it to them. Then.
209 00:16:08.580 ⇒ 00:16:13.590 Nicolas Sucari: I can create a folder, just so that we can have that one created. And then.
210 00:16:14.410 ⇒ 00:16:18.609 Nicolas Sucari: give that link so that they can add, there the sheet. If you want to.
211 00:16:18.800 ⇒ 00:16:19.490 Luke Daque: Yeah.
212 00:16:21.340 ⇒ 00:16:23.480 Nicolas Sucari: I’m gonna create that folder in the
213 00:16:24.298 ⇒ 00:16:27.729 Nicolas Sucari: Javi coffee email that we have Ryan. Okay.
214 00:16:28.000 ⇒ 00:16:29.400 Luke Daque: Sure, cool.
215 00:16:33.720 ⇒ 00:16:37.140 Payas Parab: So you’re gonna set. Set up a sheet, and then they can like upload the columns, names.
216 00:16:38.897 ⇒ 00:16:46.429 Nicolas Sucari: I mean, as I don’t know what we need. If it is just a folder or a sheet. What do you think, Ryan?
217 00:16:47.130 ⇒ 00:16:51.809 Luke Daque: A folder. And we need a folder with a Google sheet in it
218 00:16:52.130 ⇒ 00:16:54.519 Luke Daque: with a predefined column names
219 00:16:55.420 ⇒ 00:16:57.010 Luke Daque: and type data types.
220 00:16:58.200 ⇒ 00:17:01.909 Nicolas Sucari: Okay. So this is the well, I’m gonna share. Wait, let me share
221 00:17:03.460 ⇒ 00:17:04.560 Nicolas Sucari: link.
222 00:17:04.589 ⇒ 00:17:06.800 Nicolas Sucari: I’m gonna share it through slack.
223 00:17:28.220 ⇒ 00:17:29.286 Nicolas Sucari: And then
224 00:17:30.070 ⇒ 00:17:31.769 Nicolas Sucari: create whatever you need there.
225 00:17:33.320 ⇒ 00:17:35.680 Nicolas Sucari: and if you can’t access, let me know. I can
226 00:17:35.890 ⇒ 00:17:37.610 Nicolas Sucari: make it public or right now
227 00:17:44.410 ⇒ 00:17:47.640 Nicolas Sucari: I’ll add you. I’ll add your email, pay us yeah.
228 00:17:47.640 ⇒ 00:17:50.460 Luke Daque: I just saw it in slack. I didn’t realize it’s in
229 00:17:50.640 ⇒ 00:17:52.669 Luke Daque: the Channel. But yeah.
230 00:17:54.880 ⇒ 00:17:59.170 Luke Daque: yep, I can work on this. I’ll I’ll connect this to
231 00:18:00.500 ⇒ 00:18:05.119 Luke Daque: 5 grand. We just need a sheet here with the fields, with the columns.
232 00:18:05.770 ⇒ 00:18:11.880 Nicolas Sucari: Okay, I’ll I’ll let you create like any dummy sheet you want. Do it? Go ahead.
233 00:18:15.910 ⇒ 00:18:16.710 Nicolas Sucari: Cool.
234 00:18:18.660 ⇒ 00:18:25.900 Nicolas Sucari: What are update? Do we have? So pay us gorgeous and okay. And the data, it’s already synced. And we have that in Snowflake.
235 00:18:26.440 ⇒ 00:18:32.369 Nicolas Sucari: Ryan Ryan is still working on some modeling. So we’re trying to finish that tomorrow and
236 00:18:32.500 ⇒ 00:18:35.610 Nicolas Sucari: create any table that we have
237 00:18:35.760 ⇒ 00:18:45.579 Nicolas Sucari: there so that we can start creating a dashboard or or anything. It’s gonna be like, I think it’s not gonna be final yet. We need to like, look into the data and see what we can do.
238 00:18:46.087 ⇒ 00:18:53.639 Nicolas Sucari: But yeah, the idea is to try, merge, like to try. Join that information with the shopify and Amazon.
239 00:18:54.110 ⇒ 00:18:58.849 Nicolas Sucari: the shopify and Amazon tables that we have, and information there. Try to see how we can match
240 00:18:59.110 ⇒ 00:19:04.800 Nicolas Sucari: the data from okay and gorges to all of the orders and then create any dashboard with it. Okay.
241 00:19:05.090 ⇒ 00:19:06.029 Nicolas Sucari: yep. Got it?
242 00:19:07.678 ⇒ 00:19:20.560 Nicolas Sucari: And yeah, we are like, we’re working on that one. But once the modeling is there is ready. I think we’re gonna change and start looking into the return and refunds again. Okay.
243 00:19:20.670 ⇒ 00:19:23.900 Nicolas Sucari: I think that’s like more more of a priority for you. Right.
244 00:19:24.180 ⇒ 00:19:25.140 Payas Parab: Yes. Correct.
245 00:19:25.930 ⇒ 00:19:27.240 Nicolas Sucari: Excellent. Okay.
246 00:19:28.765 ⇒ 00:19:33.009 Nicolas Sucari: What else were you able to see the notion? Page.
247 00:19:33.010 ⇒ 00:19:33.869 Payas Parab: Yeah, I saw you.
248 00:19:33.870 ⇒ 00:19:34.190 Nicolas Sucari: Ready!
249 00:19:34.190 ⇒ 00:19:35.620 Payas Parab: With everything right.
250 00:19:36.140 ⇒ 00:19:41.629 Nicolas Sucari: Yeah, excellent. If you wanna add anything there, let me know. And you can add we can.
251 00:19:41.770 ⇒ 00:19:44.060 Nicolas Sucari: I don’t know where any document
252 00:19:44.439 ⇒ 00:19:51.969 Nicolas Sucari: any update. If you want to have meetings you want to record and just add, there the links. That’s that’s okay, too. And we can share that with them.
253 00:19:51.990 ⇒ 00:19:59.260 Nicolas Sucari: I mean, I share it with a man. But if you want to share that with just you know, Jared, let me know I can. I can give them access.
254 00:19:59.260 ⇒ 00:20:04.409 Payas Parab: Got it. Yeah, they’re they’re like a little less concerned around the details. They just want to start seeing the visualization tools in.
255 00:20:04.410 ⇒ 00:20:05.459 Nicolas Sucari: Yeah, and all.
256 00:20:05.780 ⇒ 00:20:29.070 Payas Parab: They they like they they like wanna make sure it’s moving. But they don’t actually care about the details, which is fine like that’s reasonable. CEO, Cfo, so okay, as long as they’re like, I think we we clarified finally, like, what are the tools and like? Why, there’s so many tools they’re getting added to. So I think they feel okay. And they just wanted, I think, like Justin just wanted his logins in the same place with the links, you know.
257 00:20:30.080 ⇒ 00:20:36.669 Nicolas Sucari: Yeah, I I added the the Google sheet that you created, and all of the tool links there. But yeah, of course.
258 00:20:36.974 ⇒ 00:20:42.605 Nicolas Sucari: I don’t know how they are using it, and if they don’t want more tools, maybe it’s not worth to share the notion.
259 00:20:43.170 ⇒ 00:20:49.700 Payas Parab: Yeah, yeah, we’ll see. Well, but thanks, thanks for putting that together. That’s that’s helpful, like guide that they can have.
260 00:20:49.700 ⇒ 00:20:53.880 Nicolas Sucari: Yeah, I mean for us, it’s gonna be like our place where we
261 00:20:53.920 ⇒ 00:20:59.950 Nicolas Sucari: keep the documentation up to date. We keep track of what we are doing. So we’re gonna still use it. Okay.
262 00:21:02.080 ⇒ 00:21:02.850 Payas Parab: Got it.
263 00:21:03.760 ⇒ 00:21:04.580 Payas Parab: Okay.
264 00:21:04.800 ⇒ 00:21:05.620 Payas Parab: cool.
265 00:21:05.910 ⇒ 00:21:10.279 Payas Parab: Are there any items you guys need from me? Anything that like needs some help, any
266 00:21:10.660 ⇒ 00:21:12.090 Payas Parab: specific questions.
267 00:21:14.850 ⇒ 00:21:20.090 Nicolas Sucari: I don’t think I have. Also, we got access to shopify. So that’s cleared.
268 00:21:21.520 ⇒ 00:21:22.190 Nicolas Sucari: But yeah.
269 00:21:22.510 ⇒ 00:21:24.050 Nicolas Sucari: no, I don’t have any question.
270 00:21:24.230 ⇒ 00:21:26.140 Nicolas Sucari: Do you have other question, Ryan.
271 00:21:26.550 ⇒ 00:21:35.589 Luke Daque: But yeah, if ever we have anything, we’ll just slack you like once I get the login to shopify, and I don’t see any refunds, or whatever. Then I’ll just slack you.
272 00:21:36.030 ⇒ 00:21:38.270 Payas Parab: Perfect alright sounds, great.
273 00:21:39.140 ⇒ 00:21:40.469 Nicolas Sucari: Cool guys. Thank you very much.
274 00:21:40.470 ⇒ 00:21:41.880 Luke Daque: Cool thanks.
275 00:21:41.880 ⇒ 00:21:43.140 Payas Parab: Thank you. Bye.
276 00:21:43.350 ⇒ 00:21:43.980 Nicolas Sucari: Bye, bye.
277 00:21:45.480 ⇒ 00:21:46.060 Payas Parab: Hello!