Meeting Title: Shopify Data Export Planning Sync Date: 2026-01-19 Meeting participants: Awaish Kumar, Uttam Kumaran
WEBVTT
1 00:00:49.310 ⇒ 00:00:50.210 Uttam Kumaran: Hey, dude.
2 00:00:53.480 ⇒ 00:00:54.580 Awaish Kumar: Hello.
3 00:00:56.780 ⇒ 00:00:57.730 Uttam Kumaran: Nancy.
4 00:00:58.070 ⇒ 00:01:00.670 Uttam Kumaran: Okay, yeah, what do you think?
5 00:01:02.160 ⇒ 00:01:03.550 Awaish Kumar: Yeah, I…
6 00:01:04.370 ⇒ 00:01:16.139 Awaish Kumar: Like, we need the data from them, like, first of all, like, I don’t think we got the… let me just confirm, but we don’t have, I think, we don’t have the line item.
7 00:01:16.620 ⇒ 00:01:19.380 Awaish Kumar: So without that, we don’t have the school information.
8 00:01:20.240 ⇒ 00:01:21.760 Uttam Kumaran: We don’t have line item at all.
9 00:01:22.180 ⇒ 00:01:22.606 Awaish Kumar: I mean…
10 00:01:23.730 ⇒ 00:01:25.439 Uttam Kumaran: Can you, can… can we,
11 00:01:25.550 ⇒ 00:01:29.990 Uttam Kumaran: Can we just do a raw export from Shopify and try to model it on that, maybe?
12 00:01:31.050 ⇒ 00:01:39.540 Awaish Kumar: Yeah, I’m thinking the same, but, like, I just saw the file from medicine. She has all that exported.
13 00:01:40.660 ⇒ 00:01:43.109 Uttam Kumaran: Okay, yeah, I wonder if we should just build it on that.
14 00:01:44.070 ⇒ 00:01:48.939 Awaish Kumar: Yeah, but that is also missing school, like, as an identifier.
15 00:01:48.940 ⇒ 00:01:49.630 Uttam Kumaran: Okay.
16 00:01:49.880 ⇒ 00:01:55.480 Awaish Kumar: I just mentioned to her. So, but, like, I can see, I can pull it from Shopify, or maybe…
17 00:01:55.630 ⇒ 00:01:59.639 Awaish Kumar: Get it from her help, but what we want to build out of it, like, what…
18 00:02:00.160 ⇒ 00:02:04.350 Awaish Kumar: So they said, like, we have a specialty retail, Customers…
19 00:02:05.250 ⇒ 00:02:11.080 Awaish Kumar: like, which we have moved from some other tag, right? And they have identified the customers already.
20 00:02:11.830 ⇒ 00:02:17.800 Awaish Kumar: they want to see the spend, basically, before Gen 7 and after Gen 7.
21 00:02:17.800 ⇒ 00:02:31.630 Uttam Kumaran: Well, yeah, so there’s a couple things. For… they want to see for all, well, this is what we should produce. We should produce for as many retailers as possible. We should produce every single… we should produce 52 weeks.
22 00:02:31.850 ⇒ 00:02:34.050 Uttam Kumaran: And 12 months.
23 00:02:35.110 ⇒ 00:02:41.789 Uttam Kumaran: and 2 more columns. Like, Jan 1 to Jan 8.
24 00:02:42.590 ⇒ 00:02:45.870 Uttam Kumaran: Or, basically, And then Jan 8th to now.
25 00:02:49.000 ⇒ 00:02:50.669 Awaish Kumar: Okay, so…
26 00:02:50.750 ⇒ 00:02:51.680 Uttam Kumaran: Like…
27 00:02:51.760 ⇒ 00:02:57.240 Awaish Kumar: So you’re saying we should have a… Partner identifier columns, right?
28 00:02:57.650 ⇒ 00:03:00.810 Awaish Kumar: And then all 52 weeks.
29 00:03:00.810 ⇒ 00:03:02.789 Uttam Kumaran: Orders and revenue. And orders.
30 00:03:02.790 ⇒ 00:03:03.500 Awaish Kumar: Order.
31 00:03:03.750 ⇒ 00:03:04.770 Awaish Kumar: Okay.
32 00:03:05.360 ⇒ 00:03:11.900 Uttam Kumaran: So just use cheap… just use a… use cursor to help you build the columns, but yeah, like, just do it on,
33 00:03:12.750 ⇒ 00:03:14.750 Uttam Kumaran: On the, like, calendar.
34 00:03:14.940 ⇒ 00:03:22.370 Uttam Kumaran: days, the calendar, and then for Jan, it’s basically, like, if we can do Jan 1 to Jan 8, that would be great.
35 00:03:22.640 ⇒ 00:03:22.970 Awaish Kumar: You know.
36 00:03:22.970 ⇒ 00:03:24.010 Uttam Kumaran: And then Jenny.
37 00:03:24.430 ⇒ 00:03:26.099 Uttam Kumaran: Will Jan 7 end?
38 00:03:26.510 ⇒ 00:03:28.150 Awaish Kumar: Yeah, okay, end of, like…
39 00:03:28.150 ⇒ 00:03:31.220 Uttam Kumaran: So… Like, end of day, Jan 7th.
40 00:03:32.060 ⇒ 00:03:34.020 Awaish Kumar: Yeah, but order date will be 7, right?
41 00:03:35.360 ⇒ 00:03:38.710 Uttam Kumaran: Order day the 7th, yes, and then anything 8th and beyond.
42 00:03:39.060 ⇒ 00:03:39.650 Awaish Kumar: Yeah.
43 00:03:43.590 ⇒ 00:03:45.300 Awaish Kumar: Okay, if we can…
44 00:03:45.300 ⇒ 00:03:47.740 Uttam Kumaran: Do that? That would be amazing.
45 00:03:47.740 ⇒ 00:03:52.019 Awaish Kumar: All this, only for the specialty details, or do you want me to for all the partners?
46 00:03:54.700 ⇒ 00:03:58.100 Uttam Kumaran: I mean, I would honestly, like.
47 00:03:58.100 ⇒ 00:03:58.659 Awaish Kumar: What are you thinking?
48 00:03:58.660 ⇒ 00:04:02.230 Uttam Kumaran: Does it matter, right? Because it’s just a filter in Google Sheet. Does it matter?
49 00:04:03.110 ⇒ 00:04:07.090 Awaish Kumar: But yeah, it will matter in a sense if it slows down, right?
50 00:04:08.920 ⇒ 00:04:09.560 Uttam Kumaran: Slows…
51 00:04:15.230 ⇒ 00:04:15.970 Awaish Kumar: I don.
52 00:04:15.970 ⇒ 00:04:18.299 Uttam Kumaran: Might as well just, like, just produce both.
53 00:04:19.740 ⇒ 00:04:23.110 Uttam Kumaran: Like, produce one with the filter, produce one without the filter.
54 00:04:25.110 ⇒ 00:04:26.090 Uttam Kumaran: Know what I mean?
55 00:04:27.150 ⇒ 00:04:28.170 Awaish Kumar: Okay, okay.
56 00:04:28.170 ⇒ 00:04:30.720 Uttam Kumaran: And then, is there any way for you to also,
57 00:04:31.470 ⇒ 00:04:34.279 Uttam Kumaran: Try to do the parent account thing.
58 00:04:37.660 ⇒ 00:04:44.360 Awaish Kumar: Like, we don’t know the parent, like, we can maybe… we can find the duplicates, Obviously, using the.
59 00:04:44.360 ⇒ 00:04:45.050 Uttam Kumaran: Yeah, or, or…
60 00:04:45.050 ⇒ 00:04:45.890 Awaish Kumar: Companies.
61 00:04:45.890 ⇒ 00:04:46.630 Uttam Kumaran: Yeah.
62 00:04:47.380 ⇒ 00:04:51.609 Awaish Kumar: And, then… Join in… join them together.
63 00:04:53.570 ⇒ 00:04:56.500 Uttam Kumaran: That’s not as urgent for now, by the way, so…
64 00:04:56.750 ⇒ 00:04:57.100 Awaish Kumar: Yeah.
65 00:04:57.100 ⇒ 00:05:00.359 Uttam Kumaran: Okay, maybe, yeah, maybe, like, do whatever they need for the tomorrow thing.
66 00:05:00.620 ⇒ 00:05:04.570 Uttam Kumaran: And then me and you, we can talk about creating a triage column, creating the parent account.
67 00:05:04.830 ⇒ 00:05:06.290 Uttam Kumaran: We can work on that together.
68 00:05:07.970 ⇒ 00:05:08.830 Awaish Kumar: Okay.
69 00:05:09.080 ⇒ 00:05:09.900 Uttam Kumaran: Okay.
70 00:05:10.740 ⇒ 00:05:12.910 Uttam Kumaran: Okay, do you want to…
71 00:05:13.290 ⇒ 00:05:20.669 Uttam Kumaran: like, I… do you want to try to send an update to them in the next hour, maybe? Or however… they don’t need it in the next hour, but…
72 00:05:21.130 ⇒ 00:05:23.779 Uttam Kumaran: If you start making progress, you can just tell them.
73 00:05:24.100 ⇒ 00:05:28.570 Uttam Kumaran: I don’t want to send a note until you’re, like, confident in what you’re gonna be able to give, so…
74 00:05:30.200 ⇒ 00:05:32.579 Awaish Kumar: Okay, yeah, let me do, like…
75 00:05:32.780 ⇒ 00:05:34.969 Uttam Kumaran: Just check it out and tell me what you find, yeah.
76 00:05:35.450 ⇒ 00:05:36.090 Awaish Kumar: Okay.
77 00:05:36.570 ⇒ 00:05:37.130 Awaish Kumar: Sure.
78 00:05:37.130 ⇒ 00:05:37.690 Uttam Kumaran: Okay.
79 00:05:38.330 ⇒ 00:05:47.060 Uttam Kumaran: Okay, okay, thanks, dude. Yo, this is great. Like, we have a first customer, and we’re building it for them, so it’s great. But yeah, slap me, I gotta jump to the next meeting, but yeah.
80 00:05:47.290 ⇒ 00:05:48.420 Awaish Kumar: Okay, no worries, thank you.
81 00:05:48.690 ⇒ 00:05:49.420 Uttam Kumaran: Okay, okay.