Meeting Title: Perry QA Sync Date: 2025-10-09 Meeting participants: Emily Giant, Demilade Agboola
WEBVTT
1 00:01:47.870 ⇒ 00:01:48.960 Demilade Agboola: Hi, I’m new.
2 00:01:49.320 ⇒ 00:01:51.180 Emily Giant: Hi, how’s it going?
3 00:01:52.160 ⇒ 00:01:54.060 Demilade Agboola: It’s pretty okay, how are you?
4 00:01:54.530 ⇒ 00:01:55.760 Emily Giant: Pretty okay.
5 00:01:55.950 ⇒ 00:01:58.699 Emily Giant: I think this is gonna be…
6 00:01:59.440 ⇒ 00:02:04.710 Emily Giant: the first time, I almost finished my tickets when I’m supposed to, so…
7 00:02:05.030 ⇒ 00:02:09.899 Demilade Agboola: That part’s going well. Woo! We’ll see. The subscriptions are…
8 00:02:10.150 ⇒ 00:02:14.689 Emily Giant: interesting, but not as bad as I thought they were gonna be, so…
9 00:02:15.570 ⇒ 00:02:18.539 Emily Giant: We shall see. Is PK coming today?
10 00:02:19.130 ⇒ 00:02:21.729 Demilade Agboola: Oh, no, because this is largely for us to QA.
11 00:02:21.730 ⇒ 00:02:25.490 Emily Giant: Oh, that’s right, for, Perry stuff.
12 00:02:26.980 ⇒ 00:02:30.519 Emily Giant: Yeah, do you wanna jump right in?
13 00:02:31.290 ⇒ 00:02:34.729 Emily Giant: To… are we gonna share the line item bundle stuff?
14 00:02:36.270 ⇒ 00:02:41.190 Demilade Agboola: So, let’s start from… Let me pick your brain for some things.
15 00:02:41.480 ⇒ 00:02:46.720 Demilade Agboola: Alright, so I have been working on this, and I’m working in my branch, give me one second…
16 00:02:47.330 ⇒ 00:02:54.449 Demilade Agboola: And it’s been a bit of a hassle, to be honest. I told you about the…
17 00:02:55.670 ⇒ 00:02:58.369 Demilade Agboola: what’s that thing called? The orders…
18 00:02:58.900 ⇒ 00:02:59.600 Emily Giant: It is.
19 00:02:59.600 ⇒ 00:03:00.380 Demilade Agboola: book stuff.
20 00:03:01.700 ⇒ 00:03:05.180 Demilade Agboola: I’ve had to rework the…
21 00:03:06.650 ⇒ 00:03:09.719 Demilade Agboola: Give me one second… I’ve had to rework the…
22 00:03:16.880 ⇒ 00:03:18.669 Demilade Agboola: I have no idea why this broke.
23 00:03:25.560 ⇒ 00:03:30.250 Demilade Agboola: Enterprise… I read.
24 00:03:31.150 ⇒ 00:03:34.210 Demilade Agboola: Yeah, so I’ve tried to rework this branch.
25 00:03:34.960 ⇒ 00:03:39.649 Demilade Agboola: So you can see I’ve been working on different models here.
26 00:03:40.100 ⇒ 00:03:45.760 Demilade Agboola: But here is the… the tricky part.
27 00:03:50.280 ⇒ 00:03:51.729 Demilade Agboola: Sorry, let me just do…
28 00:03:51.730 ⇒ 00:03:52.540 Emily Giant: Okay.
29 00:03:55.240 ⇒ 00:03:56.160 Demilade Agboola: There’s…
30 00:04:00.490 ⇒ 00:04:08.299 Demilade Agboola: So, my question about revenue now is, is revenue only counted on fulfilled orders, or do you count revenue
31 00:04:09.280 ⇒ 00:04:10.550 Demilade Agboola: wants an order.
32 00:04:10.550 ⇒ 00:04:13.170 Emily Giant: Yeah, it’s only… only fulfilled orders.
33 00:04:14.530 ⇒ 00:04:17.340 Demilade Agboola: Okay, so that might be very, very helpful for us.
34 00:04:17.529 ⇒ 00:04:25.619 Demilade Agboola: Alright, so… I have been looking at the way staging order fulfillment, Shopify order, suborder fulfillment, was created.
35 00:04:26.290 ⇒ 00:04:28.450 Demilade Agboola: And, by the way, very helpful model.
36 00:04:28.740 ⇒ 00:04:32.250 Demilade Agboola: I’ve had to tweak things around because…
37 00:04:33.100 ⇒ 00:04:35.109 Demilade Agboola: The way we need to show it.
38 00:04:38.450 ⇒ 00:04:44.199 Demilade Agboola: Apparently… so let me go to… So, apparently.
39 00:04:44.880 ⇒ 00:04:48.109 Demilade Agboola: This is the most comprehensive level, so this is, like, the base.
40 00:04:50.270 ⇒ 00:04:54.780 Demilade Agboola: And then this is the fulfillment order lines to this table.
41 00:04:55.790 ⇒ 00:04:58.370 Demilade Agboola: And then, apparently, when it gets shipped.
42 00:04:59.360 ⇒ 00:05:03.169 Demilade Agboola: it’s… this is the… this is it. The fulfillment table.
43 00:05:03.630 ⇒ 00:05:08.730 Demilade Agboola: so basically, right now, what I have created is…
44 00:05:09.000 ⇒ 00:05:11.570 Demilade Agboola: We have every single order line.
45 00:05:11.970 ⇒ 00:05:13.399 Demilade Agboola: That has been shipped.
46 00:05:13.670 ⇒ 00:05:14.860 Demilade Agboola: So now…
47 00:05:16.380 ⇒ 00:05:22.269 Demilade Agboola: what I’m… what I am doing is, in fact, other lines, and this is what we’ll have to quickly QA today.
48 00:05:24.470 ⇒ 00:05:28.540 Demilade Agboola: Sorry, did he finish running? In fact, all the lines…
49 00:05:29.120 ⇒ 00:05:31.829 Demilade Agboola: It only counts and looks at
50 00:05:34.510 ⇒ 00:05:36.099 Demilade Agboola: What the fuck is going on?
51 00:05:40.640 ⇒ 00:05:42.989 Emily Giant: Null does not exist?
52 00:05:42.990 ⇒ 00:05:44.539 Demilade Agboola: It’s just my…
53 00:05:44.540 ⇒ 00:05:45.300 Emily Giant: quotes.
54 00:05:45.790 ⇒ 00:05:50.540 Demilade Agboola: Yeah… Give me one sec.
55 00:05:50.770 ⇒ 00:05:52.840 Emily Giant: Yeah, I was like, oh, I know that air.
56 00:05:53.170 ⇒ 00:05:53.670 Demilade Agboola: Boom.
57 00:05:58.310 ⇒ 00:06:05.949 Demilade Agboola: Or… One of the things… I was… I can’t remember what I was saying sometime, but, like, basically.
58 00:06:06.420 ⇒ 00:06:11.019 Demilade Agboola: You mess around long enough, you kind of… Just no errors.
59 00:06:11.260 ⇒ 00:06:13.410 Emily Giant: Yep, it’s so true.
60 00:06:14.430 ⇒ 00:06:16.049 Demilade Agboola: You’re like, oh, that era? Oh.
61 00:06:16.050 ⇒ 00:06:16.720 Emily Giant: Nope.
62 00:06:17.280 ⇒ 00:06:20.429 Emily Giant: If y’all does not exist… oh, no, I know that.
63 00:06:21.850 ⇒ 00:06:22.829 Demilade Agboola: Sorry, I just wanted to…
64 00:06:22.830 ⇒ 00:06:23.740 Emily Giant: Yes.
65 00:06:24.090 ⇒ 00:06:27.470 Demilade Agboola: I can… I can kind of show you what’s… what’s happening.
66 00:06:29.810 ⇒ 00:06:36.690 Demilade Agboola: Because, so at this point, what we will be calculating as revenue for the models will just be basically shipped orders.
67 00:06:37.440 ⇒ 00:06:38.270 Emily Giant: Hmm.
68 00:06:38.270 ⇒ 00:06:43.250 Demilade Agboola: And I want… I… I want us to take… like, problematic…
69 00:06:45.720 ⇒ 00:06:49.859 Demilade Agboola: Orders, and kind of look at it and see if it holds true.
70 00:06:50.630 ⇒ 00:06:51.330 Emily Giant: Okay.
71 00:06:51.900 ⇒ 00:06:52.780 Emily Giant: So…
72 00:06:53.650 ⇒ 00:07:00.450 Emily Giant: we might need to pull… because I know they want to look at revenue before the orders are shipped. They want to see it as it’s coming in, also. So…
73 00:07:00.810 ⇒ 00:07:08.639 Emily Giant: the shipped orders, or I should say, the only ones that are recognized as revenue, like, for the finance team.
74 00:07:09.050 ⇒ 00:07:14.260 Emily Giant: But Perry’s team will want to see it before it’s shipped, like, as they come in.
75 00:07:14.780 ⇒ 00:07:17.420 Emily Giant: But perhaps we can, like, pull that from a…
76 00:07:18.550 ⇒ 00:07:19.060 Demilade Agboola: That’s cool.
77 00:07:19.060 ⇒ 00:07:19.890 Emily Giant: table.
78 00:07:20.520 ⇒ 00:07:27.829 Demilade Agboola: Yeah, and also some of the things have not… have not necessarily panned out the way… like, gift card has not been a useful column.
79 00:07:27.830 ⇒ 00:07:28.480 Emily Giant: Hmm.
80 00:07:29.270 ⇒ 00:07:33.070 Emily Giant: There’s a whole gift card table, I think, that is, like.
81 00:07:33.540 ⇒ 00:07:40.009 Emily Giant: We don’t even have to worry about it at this point, but yeah, certain columns are not as helpful as.
82 00:07:40.280 ⇒ 00:07:49.499 Demilade Agboola: Yeah, and also, even, like, OMS, this OMS suborder ID, very helpful. Only problem is, it only counts as a sub… like, you only get this when it ships.
83 00:07:50.320 ⇒ 00:07:51.160 Emily Giant: Oh.
84 00:07:51.280 ⇒ 00:07:52.280 Emily Giant: Okay.
85 00:07:52.760 ⇒ 00:07:55.430 Emily Giant: I do need to tie it to HEVO, okay.
86 00:07:56.100 ⇒ 00:07:57.910 Demilade Agboola: Yeah, so prior to it, shipping.
87 00:07:58.850 ⇒ 00:08:01.960 Demilade Agboola: We don’t… we don’t guess about a subvert ID.
88 00:08:04.410 ⇒ 00:08:06.800 Emily Giant: That’s really annoying.
89 00:08:08.890 ⇒ 00:08:12.030 Demilade Agboola: This is only fulfillment that has that.
90 00:08:12.370 ⇒ 00:08:14.990 Demilade Agboola: I’m not even exactly sure how to tie it back.
91 00:08:17.490 ⇒ 00:08:19.979 Emily Giant: I do think we can tie it back,
92 00:08:20.740 ⇒ 00:08:25.790 Emily Giant: There are a bunch of Shopify IDs, Throughout these tables.
93 00:08:26.390 ⇒ 00:08:33.489 Emily Giant: the HEVO tables, and I just need to pluck through and find one that exists in OMS sub-orders.
94 00:08:33.820 ⇒ 00:08:38.340 Emily Giant: But yeah, that’s… Incredibly annoying.
95 00:08:38.990 ⇒ 00:08:42.510 Emily Giant: So, like, it doesn’t even show up in the table until…
96 00:08:43.510 ⇒ 00:08:44.290 Demilade Agboola: It’s shipped, yeah.
97 00:08:44.290 ⇒ 00:08:48.189 Emily Giant: Yeah. Oh my god, okay.
98 00:08:48.340 ⇒ 00:08:49.080 Demilade Agboola: Awesome.
99 00:08:51.020 ⇒ 00:08:53.180 Emily Giant: What about fact order lines?
100 00:08:55.690 ⇒ 00:08:58.460 Emily Giant: Is there something in fact, order lines that we could…
101 00:09:02.520 ⇒ 00:09:06.910 Demilade Agboola: Factor… like, what do you mean, factor the lines? Factor the line items?
102 00:09:06.910 ⇒ 00:09:08.840 Emily Giant: Yep, that’s what I meant.
103 00:09:10.470 ⇒ 00:09:13.930 Demilade Agboola: I mean, I’m trying… I can’t see anywhere…
104 00:09:14.070 ⇒ 00:09:18.430 Demilade Agboola: that we can get the OMS Award ID. So the only place I have seen it.
105 00:09:18.430 ⇒ 00:09:22.679 Emily Giant: Is there, like, a Shopify line item ID in this one?
106 00:09:27.320 ⇒ 00:09:28.890 Emily Giant: order line ID.
107 00:09:29.910 ⇒ 00:09:31.739 Emily Giant: I wonder if I can find that in…
108 00:09:31.740 ⇒ 00:09:33.400 Demilade Agboola: That’s all the line ID.
109 00:09:33.690 ⇒ 00:09:40.389 Emily Giant: Yeah, I bet I can. If it’s the same one that’s in, the fulfillments table.
110 00:09:41.470 ⇒ 00:09:48.109 Demilade Agboola: Yeah, but… yes, that’s what I’m trying to say. The fulfillment table, the only time we actually finally get OMS suborder ID,
111 00:09:48.270 ⇒ 00:09:49.770 Demilade Agboola: Is when it’s shipped.
112 00:09:51.850 ⇒ 00:09:55.770 Emily Giant: That’s okay, because I can still pull it from the Hivo OMS
113 00:09:55.870 ⇒ 00:09:58.930 Emily Giant: Like, dash table, as long as…
114 00:09:59.130 ⇒ 00:10:01.509 Emily Giant: The one in order line items.
115 00:10:01.640 ⇒ 00:10:04.420 Emily Giant: is the same as the line item ID here, because
116 00:10:04.960 ⇒ 00:10:08.000 Emily Giant: That line item ID populates the HEVO table.
117 00:10:08.680 ⇒ 00:10:09.570 Demilade Agboola: Oh, okay.
118 00:10:11.370 ⇒ 00:10:12.210 Emily Giant: I think.
119 00:10:13.370 ⇒ 00:10:17.459 Emily Giant: One second, I’m sorry, I have to get a water. I’m, like, batting.
120 00:10:32.250 ⇒ 00:10:44.049 Emily Giant: Sorry, I was eating a piece of bread and, like, choking because I had no water. Okay, let me check right now if those are the same ID.
121 00:10:48.190 ⇒ 00:10:53.570 Emily Giant: I need to change my dbt settings so that it’s the black background like yours. It looked so fancy.
122 00:10:54.600 ⇒ 00:10:58.100 Demilade Agboola: I generally prefer my screens, like.
123 00:10:58.420 ⇒ 00:11:01.270 Demilade Agboola: Everywhere is kind of, like, block-themed for me.
124 00:11:01.730 ⇒ 00:11:10.889 Emily Giant: I think I’d be able to see it better if it was. I just never mess with those settings, because I don’t think about it, and then I see someone else has, and I’m like, oh.
125 00:11:11.080 ⇒ 00:11:12.350 Emily Giant: That’s lovely.
126 00:11:12.350 ⇒ 00:11:19.780 Demilade Agboola: Yeah, and also, because I also kind of work a lot of time with my… What’s it called?
127 00:11:20.450 ⇒ 00:11:22.140 Demilade Agboola: with my…
128 00:11:22.330 ⇒ 00:11:23.250 Emily Giant: Laptop?
129 00:11:23.690 ⇒ 00:11:30.619 Demilade Agboola: Yeah, laptop, but sometimes I walk in the dark. When it’s white, it’s really, like, bright to your face, so…
130 00:11:30.620 ⇒ 00:11:31.380 Emily Giant: Yeah.
131 00:11:32.020 ⇒ 00:11:35.890 Emily Giant: I start to get, like, headaches staring at the white screen all the time. I need to get…
132 00:11:36.520 ⇒ 00:11:38.210 Emily Giant: Blue light blockers.
133 00:11:39.210 ⇒ 00:11:46.839 Emily Giant: I used to have them and wear them all the time, but I wore them too much, and they became scratched, and now I’m just going actively blind again.
134 00:11:48.750 ⇒ 00:11:52.390 Emily Giant: Okay, select everything from analytics, factored or line items…
135 00:12:05.120 ⇒ 00:12:06.540 Emily Giant: 2025…
136 00:12:26.590 ⇒ 00:12:29.579 Demilade Agboola: I was looking at some weird orders yesterday.
137 00:12:29.700 ⇒ 00:12:31.300 Demilade Agboola: Gosh, urban stems.
138 00:12:31.300 ⇒ 00:12:38.319 Emily Giant: There are some really weird ones. I think there’s some bot activity that’s making orders really strange.
139 00:12:39.770 ⇒ 00:12:43.120 Emily Giant: Yeah, we’ve been talking about that during our daily stand-up.
140 00:12:43.390 ⇒ 00:12:46.089 Emily Giant: And there was one that was, like.
141 00:12:47.040 ⇒ 00:12:49.990 Emily Giant: 10 different bouquets for, like, 16 cents.
142 00:12:52.790 ⇒ 00:12:54.420 Demilade Agboola: Oh, okay…
143 00:12:54.420 ⇒ 00:12:55.220 Emily Giant: Yeah.
144 00:12:55.480 ⇒ 00:12:59.400 Emily Giant: I was like, are those the ones you’re talking about? Because those are weird indeed.
145 00:12:59.800 ⇒ 00:13:05.370 Emily Giant: Alright, so we’ve got… Order line ID. Now, I just need to see if it’s the same.
146 00:13:06.790 ⇒ 00:13:08.440 Emily Giant: As the one that populates.
147 00:13:09.710 ⇒ 00:13:11.560 Emily Giant: Kivo…
148 00:13:15.020 ⇒ 00:13:17.859 Emily Giant: I keep saying HEBO, but what I mean is OMS.
149 00:13:18.240 ⇒ 00:13:18.830 Demilade Agboola: Yeah.
150 00:13:18.830 ⇒ 00:13:21.970 Emily Giant: Right.
151 00:13:36.900 ⇒ 00:13:38.210 Emily Giant: stitching up.
152 00:14:27.240 ⇒ 00:14:30.450 Emily Giant: Gosh, there’s so much junk in this suborders table.
153 00:14:30.670 ⇒ 00:14:32.120 Emily Giant: the Hivo.
154 00:14:33.080 ⇒ 00:14:35.140 Emily Giant: So many blank columns.
155 00:14:36.680 ⇒ 00:14:37.580 Demilade Agboola: Yeah.
156 00:14:38.150 ⇒ 00:14:40.519 Demilade Agboola: I’m trying to say if I can…
157 00:14:41.210 ⇒ 00:14:44.180 Emily Giant: Okay, there’s… here’s Shopify fulfillment order.
158 00:14:44.620 ⇒ 00:14:50.779 Emily Giant: It’s 755. Let’s see if this matches anything for this order.
159 00:14:52.880 ⇒ 00:14:54.450 Emily Giant: Not so much, okay.
160 00:15:01.140 ⇒ 00:15:03.040 Demilade Agboola: Doesn’t this shit program?
161 00:15:03.690 ⇒ 00:15:04.550 Demilade Agboola: Mom.
162 00:15:09.070 ⇒ 00:15:12.539 Emily Giant: That was the one Shopify ID, that doesn’t really help us.
163 00:15:12.540 ⇒ 00:15:16.500 Demilade Agboola: Also, the strike… I remember.
164 00:15:28.200 ⇒ 00:15:33.389 Emily Giant: Yeah, it gives the Shopify ID, but it’s only the one in the fulfillment table, and it doesn’t…
165 00:15:33.750 ⇒ 00:15:35.980 Emily Giant: Match anything in fact line items.
166 00:15:36.850 ⇒ 00:15:37.560 Demilade Agboola: Yeah.
167 00:15:37.560 ⇒ 00:15:38.270 Emily Giant: Ugh.
168 00:15:46.440 ⇒ 00:15:50.439 Emily Giant: What about… Pivot line items.
169 00:15:51.420 ⇒ 00:15:53.180 Emily Giant: Instead of suborders.
170 00:16:03.170 ⇒ 00:16:06.580 Emily Giant: Or Hivo Split Line Items, or whatever it’s called.
171 00:16:08.360 ⇒ 00:16:11.040 Emily Giant: That also has a Shopify ID.
172 00:17:28.900 ⇒ 00:17:35.390 Demilade Agboola: Can you send an order that, you know, has some strikethrough, or maybe some unfulfilled?
173 00:17:35.940 ⇒ 00:17:37.610 Emily Giant: One moment…
174 00:17:41.220 ⇒ 00:17:53.480 Emily Giant: Alright, I’m gonna find them by using… Forced upgrade… field in… NetSuite, select everything.
175 00:18:25.730 ⇒ 00:18:27.080 Emily Giant: Alright, it’s running.
176 00:18:27.530 ⇒ 00:18:29.599 Emily Giant: Grab this for you in a second.
177 00:18:37.020 ⇒ 00:18:39.270 Emily Giant: Here’s a short list.
178 00:18:39.590 ⇒ 00:18:43.099 Emily Giant: Sending in the chat. I’ll double check real quick that they…
179 00:18:46.020 ⇒ 00:18:53.609 Emily Giant: When you’re putting them in dash, make sure to not include the one, or it will not load it, because dash is awesome like that.
180 00:18:54.070 ⇒ 00:18:56.310 Demilade Agboola: Okay. How recent are these others?
181 00:18:57.470 ⇒ 00:19:03.350 Emily Giant: Pardon? This one is from… Last week.
182 00:19:03.470 ⇒ 00:19:04.619 Emily Giant: The top one.
183 00:19:04.970 ⇒ 00:19:05.720 Demilade Agboola: Gotcha.
184 00:20:14.080 ⇒ 00:20:16.559 Demilade Agboola: Emily, what’s going on here, in this order?
185 00:20:17.170 ⇒ 00:20:20.230 Emily Giant: Okay, so this was a subscription.
186 00:20:20.680 ⇒ 00:20:28.880 Emily Giant: And, it looks like the care team removed this Urban Stems Fresh Selection item and added the unicorn instead.
187 00:20:29.870 ⇒ 00:20:35.340 Demilade Agboola: Okay, so if we were to look at it from a revenue perspective, how would we look at it?
188 00:20:35.630 ⇒ 00:20:44.810 Emily Giant: So, from a revenue perspective, technically, the classic subscription Got $60 worth of revenue.
189 00:20:45.340 ⇒ 00:20:50.300 Emily Giant: And the unicorn… It has zero, because they didn’t pay for it.
190 00:20:50.460 ⇒ 00:20:55.480 Emily Giant: So there should be a column that indicates
191 00:20:55.860 ⇒ 00:20:59.120 Emily Giant: That the classic subscription is what got the revenue, but…
192 00:20:59.370 ⇒ 00:21:02.949 Emily Giant: The unicorn in potentially a different column.
193 00:21:03.170 ⇒ 00:21:10.859 Emily Giant: Is what they received… So, yeah, I think it’s a good question for Perry.
194 00:21:11.880 ⇒ 00:21:22.250 Emily Giant: To see if he wants that money allocated to the unicorn in a different column. But I do think it should hold true that it isn’t what
195 00:21:22.540 ⇒ 00:21:23.980 Emily Giant: Originally.
196 00:21:24.380 ⇒ 00:21:27.000 Emily Giant: Got… the customer.
197 00:21:28.030 ⇒ 00:21:35.560 Demilade Agboola: Gotcha. Alright, let’s do… I want us to do something just like… I’ll look through the orders. I want us to look at an order that is just irregular.
198 00:21:35.770 ⇒ 00:21:39.730 Demilade Agboola: Order… Alright, so this, this order.
199 00:21:42.500 ⇒ 00:21:46.650 Demilade Agboola: Alright, let me look at it in this model.
200 00:21:48.920 ⇒ 00:21:50.469 Demilade Agboola: So this should be fixed.
201 00:23:26.180 ⇒ 00:23:26.810 Emily Giant: Okay.
202 00:23:28.080 ⇒ 00:23:32.669 Demilade Agboola: Alright, so this should be… give me one second.
203 00:23:40.270 ⇒ 00:23:43.299 Demilade Agboola: Oh, so this is the this order.
204 00:23:45.320 ⇒ 00:23:46.990 Demilade Agboola: Right.
205 00:23:48.420 ⇒ 00:23:49.970 Emily Giant: Think so, yeah.
206 00:23:50.310 ⇒ 00:23:55.520 Demilade Agboola: Yes, it is. So we have… It locks subscription.
207 00:23:55.660 ⇒ 00:23:57.630 Demilade Agboola: Which is 105.
208 00:24:00.560 ⇒ 00:24:02.820 Demilade Agboola: We have the warm embrace, we have…
209 00:24:06.510 ⇒ 00:24:09.980 Demilade Agboola: 95… Okay, let me see something.
210 00:24:12.220 ⇒ 00:24:17.359 Emily Giant: Yeah, I mean, that looks pretty good, as far as, like, how they’re separating out the cost.
211 00:24:17.670 ⇒ 00:24:21.959 Demilade Agboola: Yeah, but it’s been able to… but there isn’t a flag to show.
212 00:24:21.960 ⇒ 00:24:22.690 Emily Giant: Bye.
213 00:24:22.690 ⇒ 00:24:23.800 Demilade Agboola: All of them so far.
214 00:24:24.290 ⇒ 00:24:26.249 Emily Giant: Yeah, that it was manually added.
215 00:24:26.520 ⇒ 00:24:30.560 Demilade Agboola: Yeah, that these were the ones that shipped.
216 00:24:31.200 ⇒ 00:24:32.540 Demilade Agboola: That were delivered.
217 00:24:33.250 ⇒ 00:24:36.219 Demilade Agboola: the ones we’re structured. That has been the hassle.
218 00:24:37.430 ⇒ 00:24:40.420 Emily Giant: we… we might need to use the HEVO table.
219 00:24:40.940 ⇒ 00:24:41.670 Demilade Agboola: Yeah.
220 00:24:43.890 ⇒ 00:24:46.379 Demilade Agboola: But to tie it back to the Evo table.
221 00:24:48.640 ⇒ 00:24:51.640 Demilade Agboola: Is there a way we can take, because at least we have the order number.
222 00:24:53.780 ⇒ 00:24:56.460 Demilade Agboola: Is there a way to tie the item?
223 00:24:56.870 ⇒ 00:24:57.370 Demilade Agboola: Bye.
224 00:24:57.370 ⇒ 00:25:02.759 Emily Giant: That’s what I’m trying to figure out right now. Like, I’m running a query that’s taking forever, but…
225 00:25:03.010 ⇒ 00:25:04.909 Emily Giant: to see if there’s a Shopify ID.
226 00:25:05.950 ⇒ 00:25:09.460 Emily Giant: There’s gotta be… there has to be something.
227 00:25:10.080 ⇒ 00:25:18.370 Emily Giant: In these tables that shows, like, that it was… There’s gotta be, right? Like…
228 00:25:20.110 ⇒ 00:25:22.400 Emily Giant: Can we look at the payload?
229 00:25:22.530 ⇒ 00:25:24.669 Emily Giant: In the audit log on that order page.
230 00:25:26.030 ⇒ 00:25:30.890 Emily Giant: in Dash, and see, like, what… What’s going on there?
231 00:25:33.340 ⇒ 00:25:34.940 Demilade Agboola: Give me one second…
232 00:25:34.940 ⇒ 00:25:38.950 Emily Giant: Alright, here’s the Shopify… this is what the Shopify ID looks like for…
233 00:25:43.970 ⇒ 00:25:45.119 Demilade Agboola: How do you see the payload?
234 00:25:45.380 ⇒ 00:25:46.270 Demilade Agboola: of actions.
235 00:25:46.270 ⇒ 00:25:47.939 Emily Giant: Yep. So, yeah.
236 00:25:49.260 ⇒ 00:25:58.240 Emily Giant: And then, where it says line item replaced, if you could click see full details, It’s towards the bottom.
237 00:25:59.010 ⇒ 00:25:59.950 Emily Giant: Yeah. Okay.
238 00:26:06.250 ⇒ 00:26:07.070 Emily Giant: Amazing.
239 00:26:17.780 ⇒ 00:26:24.339 Emily Giant: So also, when you pull this up in Shopify, there’s a section that’s similar to this. Let me look it up…
240 00:26:25.100 ⇒ 00:26:30.639 Emily Giant: And see, like, what’s in the… the payload.
241 00:26:31.800 ⇒ 00:26:33.920 Emily Giant: Because there’s gotta… these are coming.
242 00:26:34.250 ⇒ 00:26:36.310 Emily Giant: from Shopify, so…
243 00:26:36.310 ⇒ 00:26:39.980 Demilade Agboola: So that’s part of what I… so you can see this in the order edit.
244 00:26:40.700 ⇒ 00:26:41.370 Emily Giant: So…
245 00:26:41.370 ⇒ 00:26:44.649 Demilade Agboola: like, action remove line item, you can see that…
246 00:26:45.490 ⇒ 00:26:48.709 Demilade Agboola: But I only set that up from yesterday.
247 00:26:49.110 ⇒ 00:26:52.580 Demilade Agboola: Hmm. So now, going forward, we have that, but…
248 00:26:52.960 ⇒ 00:26:57.890 Demilade Agboola: We obviously need to figure out something to handle from everything from yesterday and before.
249 00:27:03.320 ⇒ 00:27:04.080 Emily Giant: Alright.
250 00:27:04.210 ⇒ 00:27:09.170 Emily Giant: So, on my end, I was looking at this order.
251 00:27:09.590 ⇒ 00:27:15.010 Emily Giant: Just to get, like, a comparable ID, to see if we can tie it back to suborder ID.
252 00:27:15.520 ⇒ 00:27:22.700 Emily Giant: earlier than, backed Fulfillments, or fulfillment table.
253 00:27:22.840 ⇒ 00:27:25.559 Emily Giant: And this is what the ID looks like.
254 00:27:28.890 ⇒ 00:27:35.269 Emily Giant: the number starting with 5. So… That still doesn’t look…
255 00:27:36.250 ⇒ 00:27:38.869 Emily Giant: like the order line ID, per se.
256 00:27:40.710 ⇒ 00:27:41.560 Emily Giant: Mmm.
257 00:27:50.180 ⇒ 00:27:50.860 Emily Giant: Huh.
258 00:27:51.950 ⇒ 00:27:55.650 Emily Giant: Oh, no, it starts with a 1. It does. It is the line item ID.
259 00:27:55.940 ⇒ 00:28:00.110 Emily Giant: Okay, so this could tie it back to a suborder ID.
260 00:28:00.390 ⇒ 00:28:04.390 Emily Giant: the… not OMS suborders, but in, HEVO…
261 00:28:05.010 ⇒ 00:28:06.499 Emily Giant: I would need to build this table.
262 00:28:06.500 ⇒ 00:28:08.639 Demilade Agboola: I’m not sure I can see your screen.
263 00:28:08.860 ⇒ 00:28:11.019 Emily Giant: Oh, I’m sorry.
264 00:28:19.740 ⇒ 00:28:25.669 Emily Giant: Okay, so… I was looking at this suborder, 352217,
265 00:28:26.100 ⇒ 00:28:36.359 Emily Giant: So if I go to this DynamoDB… this line item table in OMS Kivo, there’s this Shopify ID, which does look like…
266 00:28:36.700 ⇒ 00:28:46.400 Emily Giant: the ID in, fact order line items. So, if I do select… Everything from…
267 00:28:55.570 ⇒ 00:28:59.860 Emily Giant: Where… I need to look at what it’s called there.
268 00:29:07.660 ⇒ 00:29:08.340 Emily Giant: Nope.
269 00:29:09.710 ⇒ 00:29:13.930 Demilade Agboola: So, OMS Prod has a Shopify ID.
270 00:29:14.290 ⇒ 00:29:16.550 Emily Giant: Yep, I’m gonna send this to you.
271 00:29:20.650 ⇒ 00:29:22.270 Emily Giant: Where is our…
272 00:29:31.690 ⇒ 00:29:32.260 Emily Giant: Sorry.
273 00:29:32.260 ⇒ 00:29:35.380 Demilade Agboola: OMS prod, we can get strikethrough, right?
274 00:29:35.380 ⇒ 00:29:36.020 Emily Giant: Yeah.
275 00:29:36.880 ⇒ 00:29:41.569 Emily Giant: So this might be… the… The answer key here.
276 00:29:42.090 ⇒ 00:29:42.490 Demilade Agboola: Yeah.
277 00:29:42.490 ⇒ 00:29:47.620 Emily Giant: Shopify… I think it’s called Shopify Line Item ID, though. Order line ID.
278 00:29:50.100 ⇒ 00:29:50.900 Emily Giant: Oops.
279 00:29:51.500 ⇒ 00:29:52.460 Emily Giant: Close.
280 00:29:57.680 ⇒ 00:30:00.000 Emily Giant: Make sure… Order line ID, yep.
281 00:30:16.760 ⇒ 00:30:17.730 Emily Giant: Sweet.
282 00:30:27.600 ⇒ 00:30:28.560 Demilade Agboola: Nice.
283 00:30:28.950 ⇒ 00:30:36.959 Demilade Agboola: Can you send me these two queries back to back? Okay, you sent me the first, but can you send me the, like, yeah, just the two queries? Well, like, line 3 and line 5?
284 00:30:46.600 ⇒ 00:30:48.890 Demilade Agboola: So basically, I would need to strip out the…
285 00:30:49.700 ⇒ 00:30:54.080 Demilade Agboola: line item, or the other line ID, then tie it to this.
286 00:30:55.260 ⇒ 00:31:02.860 Demilade Agboola: And then use that to get the OMS suborder IDs.
287 00:31:03.190 ⇒ 00:31:10.540 Demilade Agboola: And I can also then use that to get strikethrough… And once we have strikethrough.
288 00:31:14.290 ⇒ 00:31:16.420 Demilade Agboola: I’m trying to see what else…
289 00:31:16.670 ⇒ 00:31:21.359 Demilade Agboola: do we need to strike to allow us to know which ones were…
290 00:31:23.860 ⇒ 00:31:26.520 Demilade Agboola: Which ones actually count as revenue, basically.
291 00:31:27.440 ⇒ 00:31:28.290 Emily Giant: It should.
292 00:31:28.400 ⇒ 00:31:35.109 Emily Giant: Let me double check, I’m pulling up this table again. It takes a minute, because it’s a lot. It’s kind of a crazy table.
293 00:31:35.540 ⇒ 00:31:42.900 Emily Giant: Like, each line, each item will have, like, 20 lines, so…
294 00:31:43.750 ⇒ 00:31:52.699 Emily Giant: There is a staging table that’s already built, but it doesn’t pull in… it’s really old. It was one of Steven’s, so it doesn’t pull in Shopify ID.
295 00:31:52.810 ⇒ 00:31:54.480 Emily Giant: As far as I know.
296 00:31:54.730 ⇒ 00:31:57.459 Emily Giant: Well, that’s loading, it took 2 minutes last time.
297 00:31:58.350 ⇒ 00:32:04.850 Emily Giant: I do think you rebuilt it, though. Staging OMS… Line items.
298 00:32:05.980 ⇒ 00:32:06.810 Emily Giant: Yep.
299 00:32:09.900 ⇒ 00:32:13.340 Emily Giant: So this does already exist. Let’s just see if Shopify…
300 00:32:15.340 ⇒ 00:32:21.000 Emily Giant: ideas in there. No. So, we just need to… Add it to the…
301 00:32:24.230 ⇒ 00:32:26.430 Emily Giant: The already existing model here.
302 00:32:32.490 ⇒ 00:32:38.450 Demilade Agboola: Okay, alright, so basically… Let’s see…
303 00:32:54.980 ⇒ 00:32:56.179 Emily Giant: Still running.
304 00:33:10.390 ⇒ 00:33:14.249 Demilade Agboola: Will it be possible to have a sync with you at, like, 4PM ET?
305 00:33:14.490 ⇒ 00:33:15.820 Emily Giant: Yeah, totally.
306 00:33:15.820 ⇒ 00:33:16.870 Demilade Agboola: Okay.
307 00:33:18.410 ⇒ 00:33:19.440 Demilade Agboola: Alright.
308 00:33:19.850 ⇒ 00:33:23.659 Emily Giant: We’ll go in and add the stuff to this staging model.
309 00:33:24.040 ⇒ 00:33:28.960 Emily Giant: If you want to keep, like, plucking through.
310 00:33:29.110 ⇒ 00:33:36.990 Demilade Agboola: To be fair, once you add, like, I could just add the… it might just be faster for me to do it, because I could just… it’s just a Shopify ID column, right? That’s the only thing I need.
311 00:33:37.340 ⇒ 00:33:38.850 Emily Giant: I can show myself.
312 00:33:39.220 ⇒ 00:33:44.790 Emily Giant: Like, you may want to add something else from this. There’s so much information in here that isn’t in that model.
313 00:33:44.950 ⇒ 00:33:49.369 Emily Giant: Well, actually, these are nonsense, so never mind.
314 00:33:49.560 ⇒ 00:33:53.720 Emily Giant: Hold on.
315 00:33:59.860 ⇒ 00:34:04.650 Emily Giant: geez, those are total wastes of space. You got…
316 00:34:05.890 ⇒ 00:34:09.230 Demilade Agboola: That’s why it takes 2 minutes to clear. Yeah, exactly.
317 00:34:10.139 ⇒ 00:34:12.260 Emily Giant: Yeah, just Shopify ID.
318 00:34:12.799 ⇒ 00:34:18.249 Demilade Agboola: Alright, so that’s… that’s what I’ll do. So once I can get the Shopify… also, can you send… can you copy
319 00:34:18.659 ⇒ 00:34:22.759 Demilade Agboola: one row, like, not one row, but, like, one row within the Shopify ID column.
320 00:34:24.730 ⇒ 00:34:25.400 Emily Giant: This?
321 00:34:25.400 ⇒ 00:34:27.240 Demilade Agboola: Yes, and just send it as well.
322 00:34:31.389 ⇒ 00:34:40.680 Demilade Agboola: Alright, so once I will add Shopify ID… Use it to get the… the rule?
323 00:34:41.500 ⇒ 00:34:45.000 Demilade Agboola: Yep. And then, try and find strikethrough, add that as well.
324 00:34:46.250 ⇒ 00:34:47.739 Emily Giant: Teaching on us.
325 00:34:48.130 ⇒ 00:34:51.920 Demilade Agboola: And then, so we can sync up maybe, like, 4, 4.15, just to…
326 00:34:52.030 ⇒ 00:34:57.279 Emily Giant: That’s totally fine. Mine items… I’m just sending you the name of that staging model.
327 00:34:59.940 ⇒ 00:35:02.300 Emily Giant: Okay, and then strike through.
328 00:35:04.240 ⇒ 00:35:06.240 Demilade Agboola: So try to create a model, I believe.
329 00:35:07.810 ⇒ 00:35:10.670 Emily Giant: It’s supposed to be alphabetical when you…
330 00:35:10.970 ⇒ 00:35:13.320 Emily Giant: look at it here, so SKU…
331 00:35:14.980 ⇒ 00:35:21.340 Emily Giant: Shoot, okay, I don’t think it’s in this model, I think it’s in… this is where it gets shitty, is that…
332 00:35:21.920 ⇒ 00:35:23.460 Emily Giant: the,
333 00:35:24.210 ⇒ 00:35:31.860 Emily Giant: when there’s a bundle, it doesn’t match the SKU in this table, because these are the legit line items, not the split-out ones.
334 00:35:33.430 ⇒ 00:35:37.879 Demilade Agboola: Oh, so there’s… so is there a split order, and is that there as well?
335 00:35:38.400 ⇒ 00:35:39.829 Demilade Agboola: I don’t think it’s a dog.
336 00:35:39.830 ⇒ 00:35:46.940 Emily Giant: put a Shopify ID in it, and it won’t help you, because, it’s the reason that we needed to…
337 00:35:47.130 ⇒ 00:35:49.610 Emily Giant: like, revert to Shopify data.
338 00:35:49.720 ⇒ 00:35:56.230 Emily Giant: I just… there has to be a historical way to do this, or maybe Alex can help backfill.
339 00:35:56.490 ⇒ 00:36:00.670 Emily Giant: if… Okay, let me check something real quick.
340 00:36:02.370 ⇒ 00:36:07.840 Demilade Agboola: So the split… the split items… Wouldn’t have it.
341 00:36:10.020 ⇒ 00:36:13.009 Emily Giant: No, but it will get you the Shopify, or the,
342 00:36:13.620 ⇒ 00:36:20.070 Emily Giant: suborder ID of that line item, so it’s helpful in that way, because we can get that as soon as,
343 00:36:20.750 ⇒ 00:36:23.520 Emily Giant: We don’t have to wait for it to get fulfilled to get that.
344 00:36:23.950 ⇒ 00:36:27.030 Demilade Agboola: Oh, okay. And then, once we get the…
345 00:36:28.190 ⇒ 00:36:33.399 Demilade Agboola: Oh, suborder ID. So what’s in the split order? What’s in the split line items, though?
346 00:36:33.760 ⇒ 00:36:39.439 Emily Giant: The strikethrough is, but… Like, this one, the line items table.
347 00:36:40.620 ⇒ 00:36:47.749 Emily Giant: it lists out, like, double the Honeycrisp and then the base. Whereas, if this was… the double the Honeycrisp and the vase was part of a kit.
348 00:36:47.960 ⇒ 00:36:56.420 Emily Giant: split line items would say, like, the honey sunrise, and the ski would be different, so it doesn’t correctly identify what needs to be struck through.
349 00:36:56.910 ⇒ 00:37:01.470 Emily Giant: So, it still has to come from, like, somewhere in Shopify.
350 00:37:02.840 ⇒ 00:37:11.200 Emily Giant: which I’m like, it has… There has to be something in one of these tables that… Okay, so this…
351 00:37:18.720 ⇒ 00:37:23.189 Emily Giant: Trying to find… Okay, let me not use a subscription.
352 00:37:31.940 ⇒ 00:37:34.210 Demilade Agboola: Also… Let me just…
353 00:37:34.510 ⇒ 00:37:42.099 Demilade Agboola: When I get to meet Alex, is it possible to ask Alex if we could backfill the order edit,
354 00:37:44.140 ⇒ 00:37:45.630 Demilade Agboola: The order edits…
355 00:37:45.630 ⇒ 00:37:46.610 Emily Giant: Yeah.
356 00:37:46.610 ⇒ 00:37:48.079 Demilade Agboola: Workhook that we just added.
357 00:37:48.080 ⇒ 00:37:52.159 Emily Giant: That’s what I was thinking, like, that seems like the path of least resistance here.
358 00:37:56.620 ⇒ 00:37:58.040 Emily Giant: Like, I don’t even s…
359 00:37:58.300 ⇒ 00:38:04.239 Emily Giant: Alright, let’s meet at 4. Okay. I’ll let you work on this now, so that you can, like.
360 00:38:05.890 ⇒ 00:38:15.639 Emily Giant: do what you need to do, but I’m trying to see if there’s a workaround here for the strikethrough business. If not, I’ll ask Alex either way, because that to me seems like…
361 00:38:15.970 ⇒ 00:38:18.490 Emily Giant: The easiest move forward.
362 00:38:19.960 ⇒ 00:38:21.200 Emily Giant: I’m the cleanest.
363 00:38:23.090 ⇒ 00:38:25.490 Demilade Agboola: Okay. I doubt that it’s that, like…
364 00:38:26.480 ⇒ 00:38:30.010 Emily Giant: Difficult to backfill that.
365 00:38:32.880 ⇒ 00:38:34.050 Demilade Agboola: Yeah, yeah.
366 00:38:34.370 ⇒ 00:38:41.420 Emily Giant: Okay, cool. All right, yep, just if you could send me a Zoom link for the meeting later?
367 00:38:41.570 ⇒ 00:38:43.060 Demilade Agboola: I will talk to you soon.
368 00:38:43.520 ⇒ 00:38:48.629 Demilade Agboola: Alright, sounds good, I’ll do that right now, so we don’t… I don’t lose track of time.
369 00:38:48.630 ⇒ 00:38:49.400 Emily Giant: Beautiful.
370 00:38:54.480 ⇒ 00:38:56.010 Demilade Agboola: And me…
371 00:39:11.130 ⇒ 00:39:15.870 Emily Giant: Okay, so it’s this removed bit that I’m like, where… What does this look like?
372 00:39:20.800 ⇒ 00:39:22.570 Demilade Agboola: Alright, so I just sent it to you.
373 00:39:24.620 ⇒ 00:39:25.240 Emily Giant: Perfect.
374 00:39:33.750 ⇒ 00:39:37.759 Demilade Agboola: Yeah, so if you just… you could just explain to…
375 00:39:38.040 ⇒ 00:39:42.730 Demilade Agboola: Alex, sorry, if you need me to join and explain, I’m also available for that, but…
376 00:39:42.880 ⇒ 00:39:46.229 Demilade Agboola: Yeah, there’s… because a webhook different from…
377 00:39:46.500 ⇒ 00:39:51.710 Demilade Agboola: You know, the normal connection, and that allows us to see the edits, too.
378 00:39:52.680 ⇒ 00:39:55.760 Demilade Agboola: orders. The only problem is, since it was set up yesterday.
379 00:39:57.480 ⇒ 00:39:59.690 Emily Giant: We don’t have any backward-looking…
380 00:39:59.690 ⇒ 00:40:03.720 Demilade Agboola: Yeah, so if he, if he can help us, like, set up a backward.
381 00:40:04.100 ⇒ 00:40:10.259 Demilade Agboola: a backfield, that’ll be helpful. But I’ll be looking at other means to get that up to speed.
382 00:40:10.520 ⇒ 00:40:13.429 Emily Giant: Okay, perfect. I’ll ask him at our 10 a.m.
383 00:40:16.180 ⇒ 00:40:19.579 Emily Giant: Alright, cool. I will talk to you then in a little bit.
384 00:40:19.580 ⇒ 00:40:20.680 Demilade Agboola: Alright then, sounds good.
385 00:40:20.680 ⇒ 00:40:21.880 Emily Giant: Alright, bye.
386 00:40:22.060 ⇒ 00:40:22.720 Demilade Agboola: Bye.