Meeting Title: Revenue sync Date: 2025-10-09 Meeting participants: Demilade Agboola, Emily Giant
WEBVTT
1 00:00:08.580 ⇒ 00:00:09.610 Emily Giant: Hey, hey!
2 00:00:14.010 ⇒ 00:00:16.870 Demilade Agboola: I mean, did they send you,
3 00:00:17.340 ⇒ 00:00:20.630 Demilade Agboola: It bought, like, a notification that I was in.
4 00:00:22.120 ⇒ 00:00:23.150 Emily Giant: A what?
5 00:00:23.150 ⇒ 00:00:26.150 Demilade Agboola: the call, the Zoom sentient information that was in the call.
6 00:00:27.840 ⇒ 00:00:29.800 Emily Giant: the Zoom… I don’t…
7 00:00:29.800 ⇒ 00:00:30.610 Demilade Agboola: I don’t know.
8 00:00:30.610 ⇒ 00:00:31.360 Emily Giant: understand.
9 00:00:31.550 ⇒ 00:00:34.260 Demilade Agboola: Did Zoom send you a notification that I helped answer the call?
10 00:00:34.890 ⇒ 00:00:36.440 Emily Giant: No, I just saw it.
11 00:00:37.490 ⇒ 00:00:40.020 Demilade Agboola: How did you… that’s why I’m curious. How did you see it?
12 00:00:40.790 ⇒ 00:00:44.790 Emily Giant: Oh, I was just… I had the meeting on in the corner of my screen, so…
13 00:00:44.790 ⇒ 00:00:45.610 Demilade Agboola: Oh, okay.
14 00:00:45.610 ⇒ 00:00:54.089 Emily Giant: just been here. Also, because you… no, it’s because you own the meeting, so when you hopped on, it hopped me on.
15 00:00:54.460 ⇒ 00:00:55.969 Demilade Agboola: Oh, gotcha, gotcha.
16 00:00:55.970 ⇒ 00:00:56.675 Emily Giant: Yeah…
17 00:00:57.380 ⇒ 00:01:02.360 Demilade Agboola: Gotcha. I was like, you got in right… Hmm.
18 00:01:03.580 ⇒ 00:01:07.730 Emily Giant: Oh, yeah, it was, because I was like, I want to join this meeting, and it was like.
19 00:01:07.910 ⇒ 00:01:16.949 Emily Giant: hold the phone, you can’t, because the meeting owner is not there, so… Yep. That’s why. But yeah, past progress.
20 00:01:17.850 ⇒ 00:01:20.420 Demilade Agboola: Alright, so, updates.
21 00:01:20.870 ⇒ 00:01:26.739 Demilade Agboola: So we have, like, we had the orders and fulfillment orders.
22 00:01:28.030 ⇒ 00:01:34.930 Demilade Agboola: And then I was like, hey… so I’d gotten the OMS suborders, I showed you that bit.
23 00:01:35.170 ⇒ 00:01:43.079 Demilade Agboola: But then… I’m like, okay, how… just to ensure that we have the appropriate… product SKU.
24 00:01:44.120 ⇒ 00:01:51.180 Demilade Agboola: these bean… Considered in the suborder as the strikethrough order.
25 00:01:51.910 ⇒ 00:01:52.410 Emily Giant: Yes.
26 00:01:52.410 ⇒ 00:01:58.500 Demilade Agboola: I’m adding the product SKU into it, right? And then that has led me to the next problem, where
27 00:01:58.900 ⇒ 00:02:04.280 Demilade Agboola: Apparently, what is in the product variant model.
28 00:02:04.820 ⇒ 00:02:07.050 Demilade Agboola: Doesn’t align with…
29 00:02:08.759 ⇒ 00:02:14.600 Demilade Agboola: with, what we have in the… let me just… let me just share my screen so you get an idea what I’m saying.
30 00:02:14.600 ⇒ 00:02:15.500 Emily Giant: Okay, yeah.
31 00:02:17.690 ⇒ 00:02:29.779 Demilade Agboola: So… This is the… Hmm… This is the staging variance model.
32 00:02:31.970 ⇒ 00:02:33.070 Demilade Agboola: Right,
33 00:02:36.140 ⇒ 00:02:44.369 Demilade Agboola: And we have… So we have the variety with, like, the whole… Gid shock.
34 00:02:44.370 ⇒ 00:02:46.600 Emily Giant: Yeah, the string that comes up before it.
35 00:02:46.600 ⇒ 00:02:49.350 Demilade Agboola: Yeah, so I stripped it off, so now I have.
36 00:02:49.350 ⇒ 00:03:03.249 Emily Giant: Oh my gosh, we did the same thing today. I literally deployed that in a different model, like, an hour ago, because when I was doing QA with CARE, I was like, why isn’t this joining? And I saw the exact same thing that you’re showing me right now.
37 00:03:03.470 ⇒ 00:03:08.959 Demilade Agboola: Okay, but then… It appears that
38 00:03:09.960 ⇒ 00:03:24.539 Demilade Agboola: unless maybe I have to first join into products, and then product variant. That would be the only thing I can think of that makes sense. But basically, what’s going on here, and why it’s frustrating, is that the things in…
39 00:03:26.260 ⇒ 00:03:27.310 Demilade Agboola: here.
40 00:03:27.830 ⇒ 00:03:30.279 Demilade Agboola: Like, the product IDs, they don’t match.
41 00:03:30.710 ⇒ 00:03:34.000 Demilade Agboola: to anything, or even the Vera IDs, they don’t match to anything.
42 00:03:34.640 ⇒ 00:03:36.490 Demilade Agboola: In there, so they don’t join.
43 00:03:37.830 ⇒ 00:03:41.540 Emily Giant: So, they don’t join to… to which model?
44 00:03:41.540 ⇒ 00:03:44.350 Demilade Agboola: To this, the variance model.
45 00:03:45.400 ⇒ 00:03:51.779 Demilade Agboola: So I go product ID, it goes to… like, I’m just taking a random one.
46 00:03:53.460 ⇒ 00:03:55.509 Demilade Agboola: It wouldn’t find it.
47 00:03:57.430 ⇒ 00:04:00.400 Demilade Agboola: I wasn’t finding it, so… yeah.
48 00:04:01.470 ⇒ 00:04:03.390 Demilade Agboola: I literally just got that from here.
49 00:04:04.550 ⇒ 00:04:05.339 Demilade Agboola: From the product page.
50 00:04:05.340 ⇒ 00:04:12.030 Emily Giant: So this isn’t staging… Can you go to the production one and see if it does the same thing?
51 00:04:13.540 ⇒ 00:04:21.100 Emily Giant: Only because I did something very recently that, may have… Fixed it.
52 00:04:21.940 ⇒ 00:04:23.630 Emily Giant: Maybe not, but…
53 00:04:27.550 ⇒ 00:04:28.950 Demilade Agboola: Yeah, still the same.
54 00:04:29.250 ⇒ 00:04:39.060 Emily Giant: So, if you go to, product… attributes. It’s int… Underscore, underscore product attributes.
55 00:04:45.630 ⇒ 00:04:47.500 Emily Giant: Try that.
56 00:04:54.230 ⇒ 00:04:58.510 Emily Giant: But it… wait, shoot, because it’s going to be called stripped variant ID.
57 00:04:59.230 ⇒ 00:05:03.649 Emily Giant: in product attributes. Well, it’s doing something, but… We’ll let it fail.
58 00:05:04.010 ⇒ 00:05:08.060 Demilade Agboola: And I’m looking at the products… ID…
59 00:05:09.830 ⇒ 00:05:14.350 Emily Giant: Can you put… put strict product ID instead of product ID?
60 00:05:15.560 ⇒ 00:05:16.370 Emily Giant: Yeah.
61 00:05:18.500 ⇒ 00:05:22.400 Emily Giant: Now, if this doesn’t work, something is… Finister.
62 00:05:25.260 ⇒ 00:05:26.660 Emily Giant: There you go. Okay.
63 00:05:28.070 ⇒ 00:05:31.809 Emily Giant: So what I added… during QA was…
64 00:05:32.120 ⇒ 00:05:35.510 Emily Giant: We got the long variant ID, and then the stripped version.
65 00:05:37.140 ⇒ 00:05:37.760 Demilade Agboola: Oh, okay.
66 00:05:37.760 ⇒ 00:05:42.010 Emily Giant: So that, depending on what you need to join to, you can use either.
67 00:05:42.330 ⇒ 00:05:45.610 Demilade Agboola: Alright, so let’s try… let me try that right now,
68 00:05:46.980 ⇒ 00:05:48.909 Demilade Agboola: So, I will need to pull…
69 00:06:46.440 ⇒ 00:06:49.680 Demilade Agboola: So, it’s… Alright, bye.
70 00:06:53.690 ⇒ 00:06:54.480 Demilade Agboola: attribute.
71 00:06:55.670 ⇒ 00:07:08.569 Emily Giant: And I should have added that in the staging model. I was just doing QA and was like, we need to get this working so we can do QA. And I knew that that was, like, the end of the line, so I just fixed it there, but I can… I can correct it.
72 00:07:09.510 ⇒ 00:07:10.990 Demilade Agboola: Yeah, it’s fine.
73 00:07:12.420 ⇒ 00:07:22.039 Demilade Agboola: Trying to see… We have the stock, product type… Do we have a SKU?
74 00:07:23.650 ⇒ 00:07:27.060 Demilade Agboola: I mean… Alright, so we have the product skew.
75 00:07:27.400 ⇒ 00:07:28.090 Demilade Agboola: Fair.
76 00:07:33.090 ⇒ 00:07:41.040 Demilade Agboola: Alright, so for product variants… We’re gonna join for our IT.
77 00:10:30.630 ⇒ 00:10:34.269 Demilade Agboola: Okay, so the product SKU is still null, so I’m trying to…
78 00:10:35.440 ⇒ 00:10:39.079 Demilade Agboola: So my guess is… let me… let me look at it now.
79 00:10:41.130 ⇒ 00:10:45.019 Demilade Agboola: First thing. So, I’m getting the product variant, yes.
80 00:10:45.510 ⇒ 00:10:47.139 Demilade Agboola: That’s interactive data.
81 00:10:48.070 ⇒ 00:10:57.630 Demilade Agboola: And then on the cells, same… so sales is everything from… online financials.
82 00:11:00.920 ⇒ 00:11:07.549 Demilade Agboola: I’m seeing everything from sales, plus… Fulfillment, enrichment is gift card.
83 00:11:09.330 ⇒ 00:11:14.770 Demilade Agboola: Then… oil… a border from… Or missed line items.
84 00:11:16.080 ⇒ 00:11:22.850 Demilade Agboola: Product variant… Product SKU, and the extractor, extractor.
85 00:11:23.430 ⇒ 00:11:24.679 Demilade Agboola: So I’m doing…
86 00:11:27.780 ⇒ 00:11:35.850 Demilade Agboola: First off, this is… So in doing the Shopify order, should we go to the…
87 00:11:40.630 ⇒ 00:11:42.559 Demilade Agboola: This could be it.
88 00:11:43.500 ⇒ 00:11:47.370 Emily Giant: Yeah, I was gonna say, sometimes the order ID does the string thing, too.
89 00:11:47.820 ⇒ 00:11:50.680 Emily Giant: And doesn’t have, like, a stripped version.
90 00:11:51.250 ⇒ 00:11:56.439 Emily Giant: I love that we’re both, like, finding out that same problem, probably at the same time today.
91 00:11:56.900 ⇒ 00:11:57.940 Demilade Agboola: Yeah…
92 00:12:10.690 ⇒ 00:12:16.609 Demilade Agboola: So we’re doing product… ID, join into the sales product ID.
93 00:12:42.120 ⇒ 00:12:45.620 Demilade Agboola: One last line item do I do?
94 00:18:56.210 ⇒ 00:18:59.159 Demilade Agboola: Okay, so it appears this…
95 00:19:00.790 ⇒ 00:19:03.290 Demilade Agboola: Because I’m actually now looking at it.
96 00:19:04.710 ⇒ 00:19:05.920 Demilade Agboola: Very true.
97 00:19:07.690 ⇒ 00:19:09.620 Demilade Agboola: I see…
98 00:20:20.840 ⇒ 00:20:22.180 Demilade Agboola: Okay, so…
99 00:20:40.700 ⇒ 00:20:41.430 Emily Giant: Okay.
100 00:20:41.940 ⇒ 00:20:45.070 Demilade Agboola: Alright, so we do have product ID and variant ID.
101 00:20:46.090 ⇒ 00:20:48.639 Demilade Agboola: Well, when we join it…
102 00:20:49.320 ⇒ 00:20:53.040 Demilade Agboola: Because in the crack here, I’m just doing an enrich sales, which is a busy joint.
103 00:20:53.450 ⇒ 00:20:56.430 Demilade Agboola: to product variant, and product variant.
104 00:20:56.650 ⇒ 00:20:59.230 Demilade Agboola: It’s just… this?
105 00:21:01.860 ⇒ 00:21:05.890 Demilade Agboola: It doesn’t seem to give us anything.
106 00:21:07.310 ⇒ 00:21:10.389 Demilade Agboola: Where product SKU is not null.
107 00:21:13.490 ⇒ 00:21:19.489 Demilade Agboola: So… let me see… what could the issue be? Let’s look at product variants.
108 00:21:25.880 ⇒ 00:21:28.350 Demilade Agboola: Okay, so that’s definitely an issue.
109 00:21:29.040 ⇒ 00:21:30.569 Emily Giant: Yep. Okay.
110 00:21:32.490 ⇒ 00:21:37.300 Demilade Agboola: So let’s switch it to… analytics.
111 00:21:38.790 ⇒ 00:21:45.999 Demilade Agboola: Itself… Alright, and then… Let’s trying rich cells.
112 00:21:52.420 ⇒ 00:21:55.640 Demilade Agboola: Finally. Alright, so it should be fine.
113 00:21:57.120 ⇒ 00:21:58.640 Demilade Agboola: Right now…
114 00:22:01.970 ⇒ 00:22:04.910 Demilade Agboola: Alright, so let’s now… Alright.
115 00:22:05.930 ⇒ 00:22:08.349 Demilade Agboola: The other piece of information.
116 00:22:59.680 ⇒ 00:23:00.550 Demilade Agboola: Chills?
117 00:23:03.370 ⇒ 00:23:04.679 Demilade Agboola: work from, I don’t know.
118 00:23:34.460 ⇒ 00:23:41.200 Demilade Agboola: So we do have some where this suborder ID is known, but we have the product ID.
119 00:23:42.570 ⇒ 00:23:43.400 Emily Giant: That’s…
120 00:23:44.700 ⇒ 00:23:45.870 Demilade Agboola: So my…
121 00:23:46.040 ⇒ 00:23:46.670 Emily Giant: Oh, God.
122 00:23:49.850 ⇒ 00:23:51.990 Demilade Agboola: I see…
123 00:23:53.390 ⇒ 00:23:56.380 Emily Giant: Those order numbers look… So weird.
124 00:23:56.980 ⇒ 00:24:01.329 Demilade Agboola: Yeah, so these were, like, processed at, like, 2020, but they were.
125 00:24:01.330 ⇒ 00:24:02.060 Emily Giant: Yeah.
126 00:24:04.630 ⇒ 00:24:08.810 Emily Giant: Yeah, they were probably updated when they were, like, ingested into Shopify or something.
127 00:24:09.210 ⇒ 00:24:11.189 Emily Giant: Or wait, what table is this?
128 00:24:12.210 ⇒ 00:24:14.189 Emily Giant: Is this the new fact?
129 00:24:14.850 ⇒ 00:24:15.769 Demilade Agboola: Yeah, this is the fact.
130 00:24:15.770 ⇒ 00:24:16.400 Emily Giant: Caucus.
131 00:24:17.110 ⇒ 00:24:19.249 Demilade Agboola: So let me look at this, let me look at the end.
132 00:24:19.880 ⇒ 00:24:20.859 Demilade Agboola: In Dash.
133 00:24:22.200 ⇒ 00:24:22.860 Emily Giant: Okay.
134 00:24:32.920 ⇒ 00:24:34.370 Demilade Agboola: Hang on, let’s see…
135 00:24:41.390 ⇒ 00:24:42.140 Demilade Agboola: No.
136 00:24:42.560 ⇒ 00:24:43.315 Emily Giant: rock?
137 00:24:44.530 ⇒ 00:24:45.680 Emily Giant: Oh, God.
138 00:24:46.210 ⇒ 00:24:48.060 Emily Giant: I can always look to if.
139 00:24:49.870 ⇒ 00:24:52.859 Emily Giant: But also, you need to be able to log into Dash.
140 00:24:53.590 ⇒ 00:24:54.430 Demilade Agboola: Yeah.
141 00:24:57.480 ⇒ 00:25:00.089 Demilade Agboola: I’d always use Shopify to look at it, but…
142 00:25:00.600 ⇒ 00:25:01.470 Emily Giant: Yeah.
143 00:25:27.060 ⇒ 00:25:28.859 Demilade Agboola: I have no idea why it’s shamey.
144 00:25:35.560 ⇒ 00:25:36.469 Demilade Agboola: Prostate cancer.
145 00:25:37.340 ⇒ 00:25:39.639 Demilade Agboola: So I guess there’s no proper Shopify order.
146 00:25:40.620 ⇒ 00:25:41.720 Demilade Agboola: Can you say it’s in Dash?
147 00:25:41.720 ⇒ 00:25:42.480 Emily Giant: No.
148 00:25:42.650 ⇒ 00:25:44.999 Emily Giant: Yeah, I’ll check. Can you send me the order number?
149 00:25:45.180 ⇒ 00:25:48.779 Emily Giant: It’s def… wait, if it starts with a 3, it should be in Shopify.
150 00:25:49.490 ⇒ 00:25:50.880 Demilade Agboola: And it’s a 1.
151 00:25:51.290 ⇒ 00:25:53.240 Emily Giant: Oh, yeah, yeah, and it’s Dash.
152 00:26:00.170 ⇒ 00:26:02.580 Demilade Agboola: Back the Holy Bossel, hold me.
153 00:26:02.890 ⇒ 00:26:05.379 Emily Giant: Already? Already Christmas songs?
154 00:26:08.570 ⇒ 00:26:11.470 Demilade Agboola: Funny thing is, like, I sing Christmas songs randomly.
155 00:26:12.410 ⇒ 00:26:19.069 Demilade Agboola: So… I could literally sing it in, like, July or something. It’s… Essentially, you slap.
156 00:26:20.890 ⇒ 00:26:32.580 Emily Giant: I worked in retail, so I think I have, like, a different reaction to, Christmas songs, because you would be, like, in a store and hear the same 15 for, like, 9 hours straight.
157 00:26:32.580 ⇒ 00:26:33.210 Demilade Agboola: Oof.
158 00:26:34.070 ⇒ 00:26:35.210 Emily Giant: Yacht.
159 00:26:35.560 ⇒ 00:26:55.179 Emily Giant: I’m pretty sure you must be tired of Mara Carey’s All I Want for Christmas. Oh, oh man. Except, I will never be tired of that video where they removed all the sound, and it’s just her singing when she hadn’t, like, practiced in a couple years, and it’s just, like, as bad as you can imagine. Like.
160 00:26:55.390 ⇒ 00:27:04.590 Emily Giant: she needs to practice every day, or her voice starts to go, because she’s got that kind of voice. I just realized something in the refund table.
161 00:27:06.100 ⇒ 00:27:09.590 Emily Giant: Remove line items show as $0 refunds.
162 00:27:11.990 ⇒ 00:27:12.910 Demilade Agboola: Pardon?
163 00:27:13.800 ⇒ 00:27:18.580 Emily Giant: Yeah, struck through line items. When they’re removed.
164 00:27:19.400 ⇒ 00:27:22.849 Emily Giant: They show in the refund table just as a $0 refund.
165 00:27:23.980 ⇒ 00:27:24.980 Demilade Agboola: Oh…
166 00:27:30.560 ⇒ 00:27:34.129 Demilade Agboola: Are you… are you seeing that based off what we just did? Or…
167 00:27:34.130 ⇒ 00:27:42.560 Emily Giant: Nope. I was looking at your screen and, like, picking apart things that could help with this, and so I just ran it on my end.
168 00:27:42.830 ⇒ 00:27:47.679 Emily Giant: And, okay, I can show you real quick what I see.
169 00:27:47.970 ⇒ 00:27:48.640 Demilade Agboola: Okay.
170 00:27:50.150 ⇒ 00:27:51.360 Demilade Agboola: That would be helpful.
171 00:27:53.090 ⇒ 00:27:56.290 Emily Giant: Yeah, that would be… that would be awesome.
172 00:27:56.400 ⇒ 00:28:01.310 Emily Giant: what a workaround that could be. So, I just,
173 00:28:01.690 ⇒ 00:28:09.110 Emily Giant: I was looking at the refund tables, I was doing QA on the refund tables earlier with the care team, and noticed that, like.
174 00:28:09.350 ⇒ 00:28:16.010 Emily Giant: certain things were missing. It was all tied to exactly what we were talking about with the product IDs, so I had this pulled up already.
175 00:28:16.340 ⇒ 00:28:16.740 Demilade Agboola: Gotcha.
176 00:28:16.740 ⇒ 00:28:29.420 Emily Giant: was like, okay, so we’re in the Shopify refunds, where you combine the order lines and the orders, and I just wanted to see… I added SKU and variant ID just to, like.
177 00:28:29.920 ⇒ 00:28:31.220 Emily Giant: Check it out.
178 00:28:31.370 ⇒ 00:28:35.590 Emily Giant: And, I was like, what are all these $0 refunds?
179 00:28:35.690 ⇒ 00:28:38.320 Emily Giant: And then I went into Shopify… oopsie.
180 00:28:39.660 ⇒ 00:28:41.439 Emily Giant: I went into Shopify.
181 00:28:41.870 ⇒ 00:28:45.640 Emily Giant: And was like, oh… That’s a forced upgrade.
182 00:28:46.130 ⇒ 00:28:49.369 Emily Giant: Like, because it got delivered and fulfilled, just not that item.
183 00:28:49.600 ⇒ 00:28:51.810 Emily Giant: So, let me double-check in Dash.
184 00:28:53.380 ⇒ 00:28:54.370 Demilade Agboola: Okay, fabulous.
185 00:28:54.370 ⇒ 00:29:01.099 Emily Giant: Yeah, I know, I was like, oh, whoa, whoa, that was, like, some kind of… Oh. My. God.
186 00:29:01.290 ⇒ 00:29:02.140 Emily Giant: Yep.
187 00:29:04.550 ⇒ 00:29:05.640 Emily Giant: Okay.
188 00:29:06.830 ⇒ 00:29:14.499 Emily Giant: I was… I was literally about to start filtering them out, and then was like, wait, wait, wait, wait, wait, wait. There’s so many of them, it has to be something.
189 00:29:15.930 ⇒ 00:29:18.209 Emily Giant: Hold up. Hold up!
190 00:29:24.360 ⇒ 00:29:28.649 Emily Giant: Alright, I’m just gonna check a couple more, because look, there’s so many.
191 00:29:28.850 ⇒ 00:29:29.610 Demilade Agboola: Yeah.
192 00:29:31.600 ⇒ 00:29:35.720 Emily Giant: Oh my god, that would be so great!
193 00:29:36.040 ⇒ 00:29:36.950 Demilade Agboola: Yeah, so I mean, it’s…
194 00:29:37.450 ⇒ 00:29:43.610 Demilade Agboola: The sum of things should be fine, because the ones that are refunds are not zero.
195 00:29:53.160 ⇒ 00:29:58.740 Emily Giant: Okay, this one… says it actually has a refund. Oh, wait, this order was canceled.
196 00:29:59.010 ⇒ 00:29:59.370 Demilade Agboola: Yeah.
197 00:29:59.370 ⇒ 00:30:01.009 Emily Giant: Why was it a $0 refund?
198 00:30:01.540 ⇒ 00:30:04.930 Emily Giant: Because it still had a forced upgrade, I bet you. Hold on.
199 00:30:05.750 ⇒ 00:30:07.230 Demilade Agboola: What was the…
200 00:30:10.980 ⇒ 00:30:13.220 Emily Giant: Well, yeah. Two forced upgrades.
201 00:30:13.740 ⇒ 00:30:16.749 Emily Giant: So, there is a refund, but it’s gonna be on…
202 00:30:17.730 ⇒ 00:30:20.359 Emily Giant: The order level, and not the line item level.
203 00:30:20.660 ⇒ 00:30:22.640 Emily Giant: Let me see…
204 00:30:26.150 ⇒ 00:30:27.600 Emily Giant: Yup.
205 00:30:30.430 ⇒ 00:30:32.300 Emily Giant: Let me commit this real quick.
206 00:30:44.690 ⇒ 00:30:45.560 Emily Giant: Alright.
207 00:30:45.790 ⇒ 00:30:47.589 Emily Giant: So now, if I run this…
208 00:30:47.890 ⇒ 00:30:53.399 Emily Giant: I can pull it in mode, and you can pull this, too, now, from my staging.
209 00:30:54.530 ⇒ 00:30:55.310 Demilade Agboola: Oh, okay.
210 00:30:56.220 ⇒ 00:30:57.280 Emily Giant: So…
211 00:31:00.390 ⇒ 00:31:02.919 Emily Giant: What’s this called? Aunt Shopify Refunds.
212 00:31:18.980 ⇒ 00:31:20.429 Emily Giant: It’s called Refund Amount.
213 00:31:26.000 ⇒ 00:31:27.239 Emily Giant: or subtotal.
214 00:31:27.770 ⇒ 00:31:29.020 Demilade Agboola: Yeah, it’s called subtotal.
215 00:31:49.990 ⇒ 00:31:55.509 Emily Giant: Also, it says no… well… I guess they’re probably all gonna say no restock, because they’re…
216 00:31:56.420 ⇒ 00:32:01.329 Emily Giant: This actually should say restock, because it’s a candle, but whatever.
217 00:32:11.280 ⇒ 00:32:12.010 Emily Giant: Yep.
218 00:32:12.640 ⇒ 00:32:14.450 Emily Giant: They replaced it with a chocolate bar.
219 00:32:15.490 ⇒ 00:32:18.370 Emily Giant: So, if I look at it in Dash, just to make sure…
220 00:32:25.180 ⇒ 00:32:26.080 Emily Giant: Yep.
221 00:32:32.900 ⇒ 00:32:33.810 Emily Giant: -Oh.
222 00:32:34.940 ⇒ 00:32:36.100 Emily Giant: Not good.
223 00:32:36.290 ⇒ 00:32:37.090 Emily Giant: Okay.
224 00:32:38.490 ⇒ 00:32:40.010 Demilade Agboola: They’re not committed.
225 00:32:40.670 ⇒ 00:32:49.979 Emily Giant: Yeah, it just is gonna mean inventory’s messed up, but that’s from December of last year, so it doesn’t matter. This is… this is it, in terms of, like, strikethrough.
226 00:32:50.170 ⇒ 00:32:52.630 Emily Giant: We’re still gonna wanna pull the,
227 00:32:53.530 ⇒ 00:33:01.389 Emily Giant: suborder ID from Dash, which is going to require that join and the potential backfill, but I think that this is, like, a
228 00:33:01.620 ⇒ 00:33:03.979 Emily Giant: Pretty fail-safe workaround.
229 00:33:04.490 ⇒ 00:33:14.030 Demilade Agboola: Yeah, I got you. So, in terms of, like, revenue, it means when we’re summing When we’re summing…
230 00:33:15.760 ⇒ 00:33:17.360 Demilade Agboola: on the order.
231 00:33:18.950 ⇒ 00:33:20.989 Demilade Agboola: The ones that have zeros.
232 00:33:21.230 ⇒ 00:33:35.339 Demilade Agboola: basically strike through. So in terms of, like, revenue, just from a perspective of revenue, the orders that don’t have zeros are… I mean, if there’s a ref… if it’s marked as a refund, and it has the value subtracted, obviously.
233 00:33:35.460 ⇒ 00:33:43.010 Demilade Agboola: Because, you know, there was a refund. Can we look at those, actually, and just confirm the ones that have value?
234 00:33:43.010 ⇒ 00:33:43.630 Emily Giant: Look at what…
235 00:33:43.880 ⇒ 00:33:44.279 Demilade Agboola: Where the.
236 00:33:44.280 ⇒ 00:33:45.800 Emily Giant: The ones that do have values.
237 00:33:45.800 ⇒ 00:33:46.360 Demilade Agboola: practical.
238 00:33:46.360 ⇒ 00:33:54.910 Emily Giant: So, just to clarify, this, when the refund is zero on order line refund ID, that is a…
239 00:33:55.060 ⇒ 00:34:02.660 Emily Giant: that’s a forced upgrade. An order with zero? I don’t know what that would be.
240 00:34:02.740 ⇒ 00:34:04.740 Demilade Agboola: On the other line, referring.
241 00:34:04.740 ⇒ 00:34:11.100 Emily Giant: Yeah, yeah, this is… this is the one that you want for, nailing down the forced upgrades, but…
242 00:34:12.330 ⇒ 00:34:17.809 Emily Giant: So, your question was about…
243 00:34:17.810 ⇒ 00:34:20.250 Demilade Agboola: The subtotal is not equals to zero.
244 00:34:25.389 ⇒ 00:34:27.840 Demilade Agboola: Because I want to be able to just get an idea if…
245 00:34:28.030 ⇒ 00:34:30.550 Demilade Agboola: In that case, from a revenue perspective.
246 00:34:31.340 ⇒ 00:34:36.040 Demilade Agboola: Some of all other lines will give us the revenue we need on each order.
247 00:34:36.150 ⇒ 00:34:40.630 Demilade Agboola: Because if it’s… if it’s forced not good, it’s… the revenue is zero, which the subsidy is zero, right?
248 00:34:41.840 ⇒ 00:34:46.429 Demilade Agboola: But for the subtotals that are not zero, I want us to see what’s happening there.
249 00:34:47.989 ⇒ 00:34:50.269 Emily Giant: What order is the order, sorry, ordered by…
250 00:34:54.879 ⇒ 00:34:59.849 Emily Giant: I just want to see, like, if there’s multiple refunds on one order, I want to see them.
251 00:35:00.119 ⇒ 00:35:03.969 Emily Giant: because we may need to aggregate.
252 00:35:05.209 ⇒ 00:35:06.689 Emily Giant: in this table.
253 00:35:06.829 ⇒ 00:35:18.069 Emily Giant: Oh yeah, so, like, this is the same order, but because it’s split out line items, it’s two different… it’s showing two different refunds, which is cool, because we were never able to do that before, ever, prior to Shopify.
254 00:35:19.320 ⇒ 00:35:20.240 Demilade Agboola: We look at the…
255 00:35:20.240 ⇒ 00:35:21.110 Emily Giant: So…
256 00:35:30.800 ⇒ 00:35:32.300 Emily Giant: Yeah, this was avoided.
257 00:35:32.780 ⇒ 00:35:33.740 Emily Giant: So…
258 00:35:35.400 ⇒ 00:35:36.270 Demilade Agboola: Gotcha.
259 00:35:36.450 ⇒ 00:35:38.860 Demilade Agboola: Alright, so for… from the refund table.
260 00:35:39.370 ⇒ 00:35:45.120 Demilade Agboola: For every single order, it’s basically… Yeah.
261 00:35:47.720 ⇒ 00:35:52.440 Demilade Agboola: It’s basically the sum of the orders minus the refund.
262 00:35:55.690 ⇒ 00:35:56.610 Emily Giant: Yep.
263 00:35:56.840 ⇒ 00:35:59.259 Demilade Agboola: Line, like, for each order line.
264 00:36:00.490 ⇒ 00:36:01.690 Demilade Agboola: And then we’ll just…
265 00:36:01.690 ⇒ 00:36:02.260 Emily Giant: clear.
266 00:36:02.590 ⇒ 00:36:03.520 Emily Giant: Yep.
267 00:36:07.210 ⇒ 00:36:08.190 Demilade Agboola: Nice.
268 00:36:08.920 ⇒ 00:36:14.080 Emily Giant: Yes. Wow, that’s a real boon. that’s great.
269 00:36:14.390 ⇒ 00:36:17.520 Emily Giant: And I was just about to filter those out, like, what is this?
270 00:36:23.130 ⇒ 00:36:25.300 Emily Giant: Yep, these are both refunded.
271 00:36:32.110 ⇒ 00:36:33.820 Emily Giant: Wait, okay, this is weird.
272 00:36:34.990 ⇒ 00:36:38.289 Emily Giant: Because I feel like this one has a forced upgrade.
273 00:36:38.520 ⇒ 00:36:40.849 Emily Giant: And… a refund.
274 00:36:42.450 ⇒ 00:36:44.949 Demilade Agboola: So, first upgrade and a refund.
275 00:36:44.950 ⇒ 00:36:47.290 Emily Giant: Because these were removed.
276 00:36:48.580 ⇒ 00:36:57.140 Emily Giant: And then these were added, but then it was refunded. So, it still should hold true, like, it shouldn’t make a difference.
277 00:36:57.910 ⇒ 00:36:59.330 Emily Giant: With that logic.
278 00:36:59.660 ⇒ 00:37:00.530 Demilade Agboola: Yeah.
279 00:37:01.450 ⇒ 00:37:02.100 Demilade Agboola: Are we serious?
280 00:37:02.100 ⇒ 00:37:05.139 Emily Giant: So these will still be zero. Sorry, go ahead, what were you gonna say?
281 00:37:05.140 ⇒ 00:37:10.190 Demilade Agboola: Desi, like, if you… can we see the refund for that order, that order?
282 00:37:11.230 ⇒ 00:37:12.050 Emily Giant: Yes.
283 00:37:12.210 ⇒ 00:37:14.479 Demilade Agboola: In the Shopify table. The Shopify.
284 00:37:14.480 ⇒ 00:37:15.540 Emily Giant: Yeah.
285 00:37:29.810 ⇒ 00:37:38.260 Emily Giant: So my assumption would be the ones that were removed from the order will be zero, and the ones that were sent but refunded will have a value.
286 00:37:42.670 ⇒ 00:37:47.650 Emily Giant: Okay, I don’t… Know what this is.
287 00:37:47.650 ⇒ 00:37:48.430 Demilade Agboola: Yeah.
288 00:37:51.310 ⇒ 00:37:54.540 Demilade Agboola: Third reason why it doesn’t have…
289 00:38:12.070 ⇒ 00:38:13.720 Emily Giant: This is weird, this line.
290 00:38:14.770 ⇒ 00:38:17.149 Emily Giant: Maybe it’s how I… I really…
291 00:38:17.600 ⇒ 00:38:24.070 Emily Giant: like, quick and dirty, updated. So this is incorrect, though, because these were not actually refunded.
292 00:38:24.380 ⇒ 00:38:31.719 Emily Giant: I mean, technically they were, Because that’s what the person bought, and they got their money back.
293 00:38:32.160 ⇒ 00:38:32.850 Demilade Agboola: Yeah.
294 00:38:34.630 ⇒ 00:38:35.540 Emily Giant: But…
295 00:38:38.780 ⇒ 00:38:41.860 Emily Giant: Hmm, let me go back in time here with this one.
296 00:38:42.380 ⇒ 00:38:43.950 Emily Giant: elect everything.
297 00:38:44.370 ⇒ 00:38:45.230 Emily Giant: from.
298 00:38:55.420 ⇒ 00:38:58.199 Emily Giant: I want the Shopify order refunds one.
299 00:38:58.860 ⇒ 00:38:59.700 Emily Giant: Thank God.
300 00:39:01.070 ⇒ 00:39:02.230 Emily Giant: order refunds.
301 00:39:09.300 ⇒ 00:39:10.750 Emily Giant: I feel like I did this wrong.
302 00:39:11.470 ⇒ 00:39:13.730 Emily Giant: Staging Shopify, okay, yeah.
303 00:39:41.050 ⇒ 00:39:45.540 Emily Giant: Okay, so… Why didn’t any of this come through?
304 00:39:54.900 ⇒ 00:39:55.930 Demilade Agboola: Any of what?
305 00:39:57.260 ⇒ 00:40:00.189 Emily Giant: Okay, so here’s the zero. So.
306 00:40:02.380 ⇒ 00:40:03.130 Demilade Agboola: Fair enough.
307 00:40:03.850 ⇒ 00:40:05.969 Emily Giant: Let me see what comes up in the other…
308 00:40:06.600 ⇒ 00:40:11.890 Emily Giant: upstream table. Something’s getting weird with how This is pulling.
309 00:40:30.430 ⇒ 00:40:31.120 Emily Giant: Hmm.
310 00:40:35.990 ⇒ 00:40:39.599 Emily Giant: Oh, it, I, sorry, sorry, order.
311 00:40:43.150 ⇒ 00:40:45.460 Emily Giant: I was like, this doesn’t make sense at all.
312 00:40:46.650 ⇒ 00:40:47.120 Demilade Agboola: Also.
313 00:40:47.120 ⇒ 00:40:49.330 Emily Giant: So there should be 3 lines.
314 00:40:50.320 ⇒ 00:40:51.400 Emily Giant: Sorry, go ahead.
315 00:40:52.140 ⇒ 00:40:54.500 Demilade Agboola: Can you send the order line ID?
316 00:40:55.990 ⇒ 00:40:56.600 Emily Giant: Yes.
317 00:40:57.370 ⇒ 00:40:58.769 Demilade Agboola: or the order ID.
318 00:41:00.900 ⇒ 00:41:03.360 Emily Giant: This is weird, that it wouldn’t return.
319 00:41:04.960 ⇒ 00:41:07.640 Emily Giant: Anything from… this table.
320 00:41:07.840 ⇒ 00:41:10.579 Demilade Agboola: Can you send the… can you send the order ID?
321 00:41:11.360 ⇒ 00:41:12.330 Emily Giant: Yeah.
322 00:41:12.470 ⇒ 00:41:14.140 Demilade Agboola: 64, blah blah blah.
323 00:41:21.780 ⇒ 00:41:24.430 Emily Giant: Sorry, I’m trying, where’s the… Chat!
324 00:41:24.850 ⇒ 00:41:26.580 Emily Giant: Show chat preview.
325 00:41:28.550 ⇒ 00:41:35.790 Emily Giant: I don’t know why, Demolade, but I’m clicking the chat button. I’m gonna send it to you in Slack, because it’s being real weird.
326 00:42:37.080 ⇒ 00:42:43.290 Emily Giant: Okay, so this is a weird edge case, where… an upgraded order.
327 00:42:44.030 ⇒ 00:42:45.530 Emily Giant: I need to write this down.
328 00:43:25.940 ⇒ 00:43:30.329 Demilade Agboola: Also, I actually even had, the int Shopify Refund event.
329 00:43:32.160 ⇒ 00:43:32.890 Emily Giant: Mmm.
330 00:43:32.890 ⇒ 00:43:35.410 Demilade Agboola: Oh, this console, you get everything into one table.
331 00:43:39.510 ⇒ 00:43:40.490 Demilade Agboola: And then…
332 00:43:40.490 ⇒ 00:43:41.920 Emily Giant: Let me…
333 00:43:42.130 ⇒ 00:43:42.850 Demilade Agboola: Amazing.
334 00:43:44.660 ⇒ 00:43:47.069 Emily Giant: Okay, so, yeah, I hadn’t gone…
335 00:43:47.470 ⇒ 00:43:51.939 Emily Giant: All the way down the line with the… Because we started here.
336 00:43:52.610 ⇒ 00:43:53.700 Emily Giant: And then…
337 00:43:57.250 ⇒ 00:44:05.939 Emily Giant: refund events. So this is order refunds, order line refunds, and… borderline base.
338 00:44:08.120 ⇒ 00:44:11.489 Demilade Agboola: So… I mean, similar logic.
339 00:44:13.250 ⇒ 00:44:16.950 Demilade Agboola: Just putting things in there, and then aggregating.
340 00:44:17.240 ⇒ 00:44:23.870 Demilade Agboola: And I think for the amounts that were refunded, I just made them negative. It’s just… it’s, again, quite similar.
341 00:44:26.270 ⇒ 00:44:27.860 Demilade Agboola: Similar concept.
342 00:44:32.350 ⇒ 00:44:33.000 Emily Giant: Yeah.
343 00:44:36.780 ⇒ 00:44:37.410 Demilade Agboola: Like I said…
344 00:44:37.410 ⇒ 00:44:38.830 Emily Giant: Let me add.
345 00:44:38.830 ⇒ 00:44:47.800 Demilade Agboola: Like, the things that… the products info is null for a number of them, so it’s just… it would just be… like I said, I’ll consolidate everything.
346 00:44:48.100 ⇒ 00:44:50.649 Demilade Agboola: We’re gonna have one singular table for refunds.
347 00:44:54.840 ⇒ 00:45:02.529 Emily Giant: That’s… Alright, so let me add, just because we’re having issues with the product.
348 00:45:02.840 ⇒ 00:45:12.389 Emily Giant: what I did was add it to… I pulled it out of, one of the, like, JSON things in the refund data. I can add it to this table, just so we can see, like, what
349 00:45:12.840 ⇒ 00:45:14.399 Emily Giant: Not that one. This one.
350 00:45:15.040 ⇒ 00:45:19.960 Emily Giant: Just so we can see what item is getting… attributed to…
351 00:45:20.410 ⇒ 00:45:29.210 Emily Giant: the refund, but I think what you’re seeing is what… what this… was, which was, like, the blank…
352 00:45:29.720 ⇒ 00:45:37.060 Emily Giant: Oh no, wrong thing. But that line that was blank, But signified a refund.
353 00:45:37.690 ⇒ 00:45:47.010 Emily Giant: I’ve got to figure out how to, like, pull that info in, or if it gets overwritten in Shopify, then there’s nothing really we can do, but, like, if I look at the…
354 00:46:14.530 ⇒ 00:46:19.670 Emily Giant: Trying to find, like, where… This part is, the removed
355 00:46:27.280 ⇒ 00:46:28.470 Emily Giant: timeline.
356 00:46:29.870 ⇒ 00:46:30.860 Emily Giant: No.
357 00:46:32.800 ⇒ 00:46:33.490 Emily Giant: Stop.
358 00:46:38.360 ⇒ 00:46:44.500 Emily Giant: Okay, so there’s gotta be some kind of demarcation of this getting removed.
359 00:46:45.750 ⇒ 00:46:46.959 Emily Giant: There has to be.
360 00:46:47.530 ⇒ 00:46:48.340 Demilade Agboola: Yeah.
361 00:46:49.330 ⇒ 00:46:59.160 Demilade Agboola: So when it’s removed, is… isn’t that also… is that a different, like… I don’t know. Can we see other cases where stuff were removed? Isn’t that, like, also a refund, or is that…
362 00:46:59.160 ⇒ 00:46:59.520 Emily Giant: Hmm.
363 00:46:59.520 ⇒ 00:47:04.250 Demilade Agboola: how is it put? Like, in the JSON now, how is it represented?
364 00:47:05.710 ⇒ 00:47:11.170 Emily Giant: Let me… so we should be able to see in here, like, this is what goes into the audit log.
365 00:47:11.790 ⇒ 00:47:12.820 Emily Giant: But…
366 00:47:19.060 ⇒ 00:47:22.869 Emily Giant: We can look at a different one, though. Because I…
367 00:47:24.500 ⇒ 00:47:28.100 Emily Giant: Don’t know where it is in this delivery status.
368 00:47:28.970 ⇒ 00:47:30.709 Emily Giant: Okay, let’s find another one.
369 00:47:47.950 ⇒ 00:47:50.059 Emily Giant: That’s where that first one came from.
370 00:47:50.430 ⇒ 00:47:51.360 Emily Giant: Order.
371 00:48:08.690 ⇒ 00:48:14.480 Emily Giant: Okay, so we want to look for the, not the cancels, but the restocks, because those are going to be the ones that actually got delivered.
372 00:48:21.690 ⇒ 00:48:23.750 Emily Giant: But we’re gonna have to kind of poke through these.
373 00:48:23.950 ⇒ 00:48:25.050 Emily Giant: Find one.
374 00:48:30.100 ⇒ 00:48:35.900 Emily Giant: Oh, that wasn’t too hard, was it? First one I looked at was two items were removed.
375 00:48:36.240 ⇒ 00:48:39.620 Emily Giant: Double the margo was added, and then it was refunded.
376 00:48:39.920 ⇒ 00:48:41.620 Emily Giant: Let me double-check dash.
377 00:48:49.220 ⇒ 00:48:54.080 Emily Giant: Alright, it’s not showing a refund, it’s just showing… Oh, wait.
378 00:48:57.790 ⇒ 00:48:59.390 Demilade Agboola: Sure enough, hold on.
379 00:48:59.980 ⇒ 00:49:01.709 Emily Giant: This just happened, too.
380 00:49:07.100 ⇒ 00:49:08.050 Emily Giant: Plasty.
381 00:49:09.500 ⇒ 00:49:10.250 Emily Giant: Okay.
382 00:49:10.950 ⇒ 00:49:13.350 Emily Giant: These were removed, and these were added.
383 00:49:14.200 ⇒ 00:49:20.219 Emily Giant: Somehow, it split it into two suborders, which I’ve not seen.
384 00:49:22.190 ⇒ 00:49:24.200 Emily Giant: In a very long time.
385 00:49:26.170 ⇒ 00:49:26.880 Emily Giant: Okay.
386 00:49:30.460 ⇒ 00:49:32.660 Demilade Agboola: So, Shopify split answer to two suborders.
387 00:49:34.820 ⇒ 00:49:36.180 Emily Giant: It shouldn’t.
388 00:49:37.560 ⇒ 00:49:44.550 Emily Giant: I mean, yeah, it does, but, but that’s just not…
389 00:49:44.780 ⇒ 00:49:51.669 Emily Giant: what I’m seeing on this page at all. What I’m seeing is, like, this is the only thing that was sent, and these were removed.
390 00:49:52.120 ⇒ 00:49:54.520 Emily Giant: but Dash is showing me that, like.
391 00:49:55.590 ⇒ 00:50:02.600 Emily Giant: the autumnal palette… that this was also delivered, as well as this, and that doesn’t look like what happened in Shopify.
392 00:50:03.020 ⇒ 00:50:03.560 Demilade Agboola: Yeah.
393 00:50:03.560 ⇒ 00:50:05.870 Emily Giant: Because, okay, autumnal palette, Bronze face.
394 00:50:06.070 ⇒ 00:50:07.250 Emily Giant: It does.
395 00:50:08.420 ⇒ 00:50:09.970 Emily Giant: I don’t even see that on here.
396 00:50:10.950 ⇒ 00:50:12.140 Emily Giant: Like, where is it?
397 00:50:16.570 ⇒ 00:50:21.320 Emily Giant: Or is that just what this is? Is the… no, it’s not, because…
398 00:50:21.840 ⇒ 00:50:23.860 Demilade Agboola: Because the other one is double… double demographies.
399 00:50:23.860 ⇒ 00:50:25.110 Emily Giant: Yeah.
400 00:50:29.780 ⇒ 00:50:31.539 Emily Giant: Delivered on the same day?
401 00:50:36.000 ⇒ 00:50:37.090 Emily Giant: This is…
402 00:50:37.690 ⇒ 00:50:38.360 Demilade Agboola: That’s…
403 00:50:39.080 ⇒ 00:50:40.180 Emily Giant: Oh, this is…
404 00:50:43.420 ⇒ 00:50:45.000 Emily Giant: Like, are these indifferent?
405 00:50:45.490 ⇒ 00:50:46.850 Demilade Agboola: Delivered.
406 00:50:47.070 ⇒ 00:50:47.990 Emily Giant: Okay.
407 00:50:51.220 ⇒ 00:50:54.480 Emily Giant: Tracking ID… yeah, different tracking IDs.
408 00:50:54.790 ⇒ 00:50:59.620 Emily Giant: But, like, I don’t see… Kind nor hair of that other product.
409 00:51:04.650 ⇒ 00:51:10.660 Emily Giant: What in the actual… I need to show this to… Alex?
410 00:51:12.000 ⇒ 00:51:17.749 Demilade Agboola: Yeah. It’s definitely a weird edge case. Weird things were removed and canceled at the same time.
411 00:51:21.340 ⇒ 00:51:23.959 Emily Giant: Okay, let me… I’m gonna add this to the tech channel.
412 00:51:25.520 ⇒ 00:51:27.379 Emily Giant: Because then tough feet can help, too.
413 00:51:28.600 ⇒ 00:51:31.280 Emily Giant: But yeah, that ain’t normal. Well…
414 00:51:31.830 ⇒ 00:51:34.110 Emily Giant: I’ll add that to my list.
415 00:51:34.650 ⇒ 00:51:37.629 Demilade Agboola: I mean, one step forward, two steps forward.
416 00:51:37.630 ⇒ 00:51:38.640 Emily Giant: Yep.
417 00:51:39.180 ⇒ 00:51:39.740 Demilade Agboola: Bruh.
418 00:51:40.980 ⇒ 00:51:44.150 Emily Giant: Alright, let’s try to find one that doesn’t derail us.
419 00:52:01.270 ⇒ 00:52:02.230 Emily Giant: Okay.
420 00:52:03.120 ⇒ 00:52:08.019 Emily Giant: So… Let me see what happened on this timeline.
421 00:52:10.160 ⇒ 00:52:17.319 Emily Giant: Alright, so this looks like… Not a legitimate refund, it looks like it should just be a forced upgrade.
422 00:52:25.650 ⇒ 00:52:36.090 Emily Giant: In which case… we wouldn’t… C… We shouldn’t have seen a… refund.
423 00:52:36.690 ⇒ 00:52:37.930 Emily Giant: in the line.
424 00:52:40.140 ⇒ 00:52:42.459 Emily Giant: Okay, so this part’s correct.
425 00:52:43.760 ⇒ 00:52:46.530 Emily Giant: But then, This is showing…
426 00:52:50.800 ⇒ 00:52:52.590 Emily Giant: An actual refund total.
427 00:52:55.610 ⇒ 00:52:58.649 Demilade Agboola: Oh, instead of, like, a canceled, or instead of, like, a forced upgrade.
428 00:52:59.610 ⇒ 00:53:03.169 Emily Giant: Yeah, so my expectation was that this would show zero.
429 00:53:03.400 ⇒ 00:53:04.060 Demilade Agboola: Yeah.
430 00:53:04.060 ⇒ 00:53:06.540 Emily Giant: But… It’s not.
431 00:53:09.130 ⇒ 00:53:13.009 Demilade Agboola: It’s showing that it was refunded.
432 00:53:14.900 ⇒ 00:53:19.849 Demilade Agboola: Sir, can I… can I see the audio?
433 00:53:20.750 ⇒ 00:53:24.160 Emily Giant: Yeah, this one? Do you want me to send you the order in?
434 00:53:24.550 ⇒ 00:53:25.200 Demilade Agboola: Yeah.
435 00:53:25.860 ⇒ 00:53:31.250 Demilade Agboola: No, look, no, can I see… in Shopify, can I see the order?
436 00:53:34.140 ⇒ 00:53:35.529 Demilade Agboola: Is this the order?
437 00:53:39.860 ⇒ 00:53:41.479 Demilade Agboola: Actually, guys can dash.
438 00:53:42.590 ⇒ 00:53:43.290 Emily Giant: Yes.
439 00:53:43.700 ⇒ 00:53:51.269 Emily Giant: Okay, is this the same order? Did we actually look at the same one twice? No. Because this is the exact same day as that other weird one.
440 00:53:51.270 ⇒ 00:53:52.110 Demilade Agboola: Yeah.
441 00:53:52.940 ⇒ 00:53:58.680 Demilade Agboola: Sorry, I want to… I’m trying to look at the payment, like, the top right. Can you scroll up a bit?
442 00:54:01.420 ⇒ 00:54:02.640 Demilade Agboola: Revance was tall.
443 00:54:12.750 ⇒ 00:54:17.450 Demilade Agboola: So they paid for the autumn sky and the glass vase.
444 00:54:19.350 ⇒ 00:54:23.130 Demilade Agboola: And then, can we go down? There was a forced upgrade.
445 00:54:26.170 ⇒ 00:54:29.960 Emily Giant: To double the autumn sun and the glass vase.
446 00:54:35.690 ⇒ 00:54:40.489 Demilade Agboola: And then… And that’s it.
447 00:54:40.940 ⇒ 00:54:44.139 Emily Giant: Let me check to see if there’s anything in the audit log.
448 00:54:46.410 ⇒ 00:54:49.960 Emily Giant: Line item placed, line item added, line item deleted.
449 00:54:50.580 ⇒ 00:54:55.259 Emily Giant: Several releases. This one went through a lot.
450 00:55:03.030 ⇒ 00:55:03.900 Emily Giant: Okay.
451 00:55:08.010 ⇒ 00:55:12.329 Emily Giant: So there’s the replacing, but she didn’t refund. There’s no…
452 00:55:12.650 ⇒ 00:55:17.410 Emily Giant: mark of a refund on this at all. So I don’t know why that’s coming through that way.
453 00:55:24.830 ⇒ 00:55:27.120 Emily Giant: 9215.
454 00:55:27.910 ⇒ 00:55:29.210 Emily Giant: This says…
455 00:55:36.500 ⇒ 00:55:37.849 Emily Giant: 8 and 12.
456 00:55:38.290 ⇒ 00:55:39.430 Emily Giant: 78.
457 00:55:39.690 ⇒ 00:55:45.199 Emily Giant: Well… I… Truly don’t understand that one, because…
458 00:55:45.420 ⇒ 00:55:47.910 Emily Giant: It looks like the entire order.
459 00:55:49.330 ⇒ 00:55:50.389 Emily Giant: Oh, wait a minute.
460 00:55:59.620 ⇒ 00:56:01.349 Emily Giant: Refund owed.
461 00:56:12.790 ⇒ 00:56:13.520 Emily Giant: Okay.
462 00:56:19.160 ⇒ 00:56:21.689 Emily Giant: Where’s the 12 coming from?
463 00:56:23.010 ⇒ 00:56:23.830 Demilade Agboola: About 12.
464 00:56:23.830 ⇒ 00:56:24.540 Emily Giant: Is that…
465 00:56:26.040 ⇒ 00:56:30.439 Demilade Agboola: Who the glass was. I think it’s the discounted… amount, like, if I…
466 00:56:30.440 ⇒ 00:56:31.999 Emily Giant: It must be, yeah.
467 00:56:32.000 ⇒ 00:56:33.889 Demilade Agboola: That is in Dashieut.
468 00:56:34.990 ⇒ 00:56:35.720 Emily Giant: Yeah.
469 00:56:36.160 ⇒ 00:56:37.349 Demilade Agboola: Right. I think you’re right.
470 00:56:37.990 ⇒ 00:56:42.909 Demilade Agboola: So if you go to dash, I think that was the… yeah, you said you can say it was 15, and it’s now twice on 5.
471 00:56:43.860 ⇒ 00:56:44.450 Emily Giant: Yeah.
472 00:56:48.770 ⇒ 00:56:49.870 Emily Giant: Why? The…
473 00:56:53.090 ⇒ 00:56:53.940 Emily Giant: Okay.
474 00:56:57.640 ⇒ 00:57:04.520 Emily Giant: 78 and 0, versus… 78 and 12.
475 00:57:09.560 ⇒ 00:57:10.980 Emily Giant: Why zero?
476 00:57:11.960 ⇒ 00:57:14.400 Emily Giant: Oh, customer added line item discount.
477 00:57:14.590 ⇒ 00:57:17.280 Emily Giant: But it should still show in the…
478 00:57:19.230 ⇒ 00:57:22.489 Emily Giant: Subtotal, because subtotal should be before discount.
479 00:57:23.500 ⇒ 00:57:24.340 Demilade Agboola: Yeah.
480 00:57:33.420 ⇒ 00:57:34.300 Emily Giant: -
481 00:57:40.360 ⇒ 00:57:46.050 Emily Giant: So, this is how… And because this is a kit, the Double the Autumn Sun.
482 00:57:46.610 ⇒ 00:57:51.159 Emily Giant: So, they’re actually breaking out the SKU, but the SKU should be…
483 00:57:52.320 ⇒ 00:57:54.600 Emily Giant: The one with the dash k.
484 00:57:55.850 ⇒ 00:57:56.970 Emily Giant: Somewhere.
485 00:57:57.420 ⇒ 00:57:59.650 Emily Giant: Hmm, I don’t know. This is weird.
486 00:57:59.930 ⇒ 00:58:01.550 Emily Giant: It doesn’t make any sense.
487 00:58:14.820 ⇒ 00:58:17.260 Emily Giant: I don’t know, because it’s not a real refund.
488 00:58:17.690 ⇒ 00:58:19.280 Emily Giant: I wonder if there’s…
489 00:58:23.670 ⇒ 00:58:24.500 Emily Giant: Hold on.
490 00:58:38.230 ⇒ 00:58:41.509 Emily Giant: Those tables are pretty simple, so I don’t know why…
491 00:58:42.310 ⇒ 00:58:45.220 Emily Giant: I don’t think we’ve done anything incorrectly here.
492 00:58:45.750 ⇒ 00:58:46.440 Demilade Agboola: Yeah.
493 00:58:49.530 ⇒ 00:58:52.360 Emily Giant: But I certainly don’t like that this is kind of recent.
494 00:58:52.960 ⇒ 00:58:55.279 Emily Giant: That there’s these anomalies.
495 00:58:59.840 ⇒ 00:59:06.309 Demilade Agboola: I think what I’m curious about is, can we see the Shopify order amongst the, like, other lines based?
496 00:59:06.900 ⇒ 00:59:12.249 Demilade Agboola: So can you search it into other lines, please? I want to see how it handles on the other side.
497 00:59:12.560 ⇒ 00:59:13.710 Emily Giant: Yeah.
498 00:59:28.310 ⇒ 00:59:30.900 Emily Giant: I don’t know if it’s Shopify order ID or order ID.
499 00:59:30.900 ⇒ 00:59:32.809 Demilade Agboola: I just put it in chat.
500 00:59:33.000 ⇒ 00:59:35.219 Demilade Agboola: So there’s a staging model for…
501 00:59:38.420 ⇒ 00:59:41.500 Demilade Agboola: The order lines… oh wait, my bad.
502 00:59:42.120 ⇒ 00:59:44.009 Demilade Agboola: Give me one second.
503 00:59:45.580 ⇒ 00:59:46.680 Demilade Agboola: this…
504 01:00:05.800 ⇒ 01:00:06.639 Emily Giant: I don’t remember.
505 01:00:06.900 ⇒ 01:00:08.840 Emily Giant: Ruh.
506 01:00:09.090 ⇒ 01:00:10.889 Emily Giant: Shopify order ID, okay.
507 01:00:16.660 ⇒ 01:00:26.089 Emily Giant: Oh my gosh, it is suddenly… I don’t know what this is, I don’t know what’s going on here, or why that happened, but… okay, wait a minute, what’s happening?
508 01:00:27.760 ⇒ 01:00:29.880 Emily Giant: Oh, interesting.
509 01:00:31.930 ⇒ 01:00:32.900 Emily Giant: What’s that?
510 01:00:35.600 ⇒ 01:00:36.470 Emily Giant: Okay.
511 01:01:02.820 ⇒ 01:01:07.690 Emily Giant: Okay, so this details everything… that.
512 01:01:08.190 ⇒ 01:01:10.000 Emily Giant: Once was on the order.
513 01:01:10.750 ⇒ 01:01:11.480 Demilade Agboola: Yeah.
514 01:01:13.860 ⇒ 01:01:19.759 Demilade Agboola: So I’m thinking this, the refund amount cancels out, The initial amount.
515 01:01:22.890 ⇒ 01:01:23.500 Emily Giant: Oof.
516 01:01:24.810 ⇒ 01:01:32.050 Demilade Agboola: So my question is, well, we haven’t added product ID, I should add that as well, so we can see what’s going on with these other ones.
517 01:01:35.410 ⇒ 01:01:36.010 Emily Giant: Yeah.
518 01:01:37.390 ⇒ 01:01:41.300 Emily Giant: That looks like the one… That’s actually on the order.
519 01:01:41.780 ⇒ 01:01:42.870 Demilade Agboola: Yeah.
520 01:01:43.170 ⇒ 01:01:50.490 Demilade Agboola: So my guess is, like, the sum of the… because the 78 and 1275 will be knocked out by the…
521 01:01:54.230 ⇒ 01:01:55.610 Emily Giant: By the refund table.
522 01:01:55.610 ⇒ 01:01:58.709 Demilade Agboola: Yeah, but question is, is the revenue…
523 01:01:59.270 ⇒ 01:02:01.440 Demilade Agboola: The lines of total amount.
524 01:02:01.890 ⇒ 01:02:05.439 Demilade Agboola: In this case, would it be 6647?
525 01:02:07.640 ⇒ 01:02:10.730 Emily Giant: No, it would be…
526 01:02:16.330 ⇒ 01:02:18.069 Emily Giant: It would be $78.20.
527 01:02:19.490 ⇒ 01:02:21.960 Emily Giant: Plus shipping. Plus 28.
528 01:02:27.650 ⇒ 01:02:30.530 Emily Giant: So it’s what was actually paid, plus shipping.
529 01:02:31.750 ⇒ 01:02:37.250 Demilade Agboola: Flush. But there’s a refund order of 20, and there’s just so much going on here.
530 01:02:38.050 ⇒ 01:02:40.109 Emily Giant: It’s too much.
531 01:02:41.400 ⇒ 01:02:45.549 Demilade Agboola: So, we have a discount. Does… doesn’t that count? Doesn’t that factor in?
532 01:02:46.200 ⇒ 01:02:47.530 Emily Giant: Not to revenue.
533 01:02:47.530 ⇒ 01:02:51.650 Demilade Agboola: Not revenue. So discounts don’t factor into revenue, it’s just refund…
534 01:02:53.120 ⇒ 01:02:55.819 Demilade Agboola: Sales and refunds, basically. Sales minus refunds.
535 01:02:57.310 ⇒ 01:02:58.700 Emily Giant: Yes.
536 01:02:58.860 ⇒ 01:02:59.860 Demilade Agboola: On another minus.
537 01:02:59.860 ⇒ 01:03:16.199 Emily Giant: Well, I don’t even know… I don’t even know if it’s a minus refund. I feel like that might be… I need to ask Perry that. It’s top line, or subtotal plus shipping is revenue. Now, what they do with refunds, I don’t know, especially when revenue is recognized.
538 01:03:16.560 ⇒ 01:03:20.640 Emily Giant: That might be, like, a downstream accounting thing.
539 01:03:21.390 ⇒ 01:03:25.750 Emily Giant: However, like, if this 66-whatever is coming out
540 01:03:26.580 ⇒ 01:03:28.990 Emily Giant: in the table. That’s not real.
541 01:03:29.870 ⇒ 01:03:32.080 Emily Giant: So… .
542 01:03:32.610 ⇒ 01:03:33.799 Demilade Agboola: Alright, so 6 to 6…
543 01:03:33.800 ⇒ 01:03:35.130 Emily Giant: That’s where it gets dicey.
544 01:03:35.590 ⇒ 01:03:42.799 Demilade Agboola: Let me see, 6647… Can you go back to that Shopify screen?
545 01:03:46.650 ⇒ 01:03:56.100 Demilade Agboola: Yeah, so what Shopify is showing, can you go back, is $66.47, which is 78.20 minus 1173.
546 01:03:56.100 ⇒ 01:04:03.079 Emily Giant: Gotcha, okay. So… what is that line? Like, what’s the product on that line?
547 01:04:03.630 ⇒ 01:04:04.580 Demilade Agboola: Yeah, so…
548 01:04:04.580 ⇒ 01:04:05.630 Emily Giant: variant ID.
549 01:04:06.840 ⇒ 01:04:09.080 Demilade Agboola: Yeah, I was gonna say I need to add that.
550 01:04:11.310 ⇒ 01:04:15.509 Emily Giant: Well, you don’t need to add it, because I can just join it to the product table in Looker.
551 01:04:16.560 ⇒ 01:04:16.910 Demilade Agboola: Yeah.
552 01:04:16.910 ⇒ 01:04:19.809 Emily Giant: And tables can be super simple,
553 01:04:20.890 ⇒ 01:04:24.060 Emily Giant: Since we can join it all up in the Explorer.
554 01:04:24.540 ⇒ 01:04:25.210 Demilade Agboola: Fair enough.
555 01:04:31.140 ⇒ 01:04:37.260 Demilade Agboola: So now we have the product ID. Do you want to send that to me, so I can just quickly check?
556 01:04:37.260 ⇒ 01:04:38.170 Emily Giant: Yeah.
557 01:04:49.600 ⇒ 01:04:53.049 Demilade Agboola: Break the whole table so holy.
558 01:04:53.050 ⇒ 01:04:58.980 Emily Giant: Na-na-na-na-na-na It’s the season to be joined. Just don’t do this to me.
559 01:04:58.980 ⇒ 01:04:59.550 Demilade Agboola: I know.
560 01:04:59.550 ⇒ 01:05:01.000 Emily Giant: I need that in my head.
561 01:05:01.220 ⇒ 01:05:05.400 Demilade Agboola: Alright, so this is the double the autumn sun, so that’s what was sent.
562 01:05:06.580 ⇒ 01:05:07.240 Emily Giant: Yes.
563 01:05:09.520 ⇒ 01:05:10.330 Emily Giant: Yes.
564 01:05:11.880 ⇒ 01:05:19.010 Demilade Agboola: Alright, okay, so can I go back to that line item.
565 01:05:22.060 ⇒ 01:05:24.619 Emily Giant: In Shopify? Oh, oh, in the query.
566 01:05:24.990 ⇒ 01:05:32.330 Demilade Agboola: Can we scroll a bit? I wanna see if… Scroll… So, pre-tax price…
567 01:05:34.100 ⇒ 01:05:38.210 Demilade Agboola: That’s it, okay. I want to see… so I might have to add…
568 01:05:39.590 ⇒ 01:05:43.860 Demilade Agboola: So, you said we’re not factoring out the refunds, right?
569 01:05:46.010 ⇒ 01:05:48.760 Emily Giant: What, yeah.
570 01:05:49.510 ⇒ 01:05:54.730 Emily Giant: Yeah, revenue, if there’s a column that’s called revenue, it’s just subtotal plus shipping.
571 01:05:55.710 ⇒ 01:06:00.370 Emily Giant: And it doesn’t need to factor in A refund at all.
572 01:06:00.820 ⇒ 01:06:02.589 Demilade Agboola: Yeah, but the issue is…
573 01:06:03.140 ⇒ 01:06:11.449 Demilade Agboola: The issue now is this line subtotal is also factor in discounts as well, so I will need to add discounts to this, to the subtotal.
574 01:06:13.170 ⇒ 01:06:14.910 Demilade Agboola: So, here’s what I will do.
575 01:06:15.930 ⇒ 01:06:24.570 Emily Giant: I don’t even know what this is, because it’s saying for a product that is literally double the cost of this.
576 01:06:25.270 ⇒ 01:06:26.300 Demilade Agboola: Yeah. That…
577 01:06:27.130 ⇒ 01:06:31.189 Emily Giant: I just don’t know why it’s saying there’s a price there at all, since
578 01:06:32.020 ⇒ 01:06:42.520 Emily Giant: it shouldn’t have any dollar amount attributed to it in the subtotal column, because they didn’t buy it. They only paid this and this. It should be zero.
579 01:06:43.250 ⇒ 01:06:47.039 Demilade Agboola: Yeah, but then they got a refund on those amounts.
580 01:06:47.970 ⇒ 01:06:50.350 Emily Giant: They never got a refund. There’s no refund.
581 01:06:50.720 ⇒ 01:06:53.280 Emily Giant: Like, it actually never was refunded.
582 01:06:54.220 ⇒ 01:06:55.070 Demilade Agboola: Oh, really?
583 01:06:55.930 ⇒ 01:06:57.460 Emily Giant: Yeah, so in Dash?
584 01:06:57.870 ⇒ 01:07:00.630 Emily Giant: No refund line, and then if you go into the audit log.
585 01:07:01.120 ⇒ 01:07:03.660 Emily Giant: All that happened was a forced upgrade.
586 01:07:05.250 ⇒ 01:07:10.280 Demilade Agboola: Oh, okay, I’m guessing… so, I guess… I’m guessing that that’s what Shopify does?
587 01:07:10.540 ⇒ 01:07:13.850 Demilade Agboola: So when it’s… when that was added.
588 01:07:14.640 ⇒ 01:07:20.280 Demilade Agboola: Shopify then adds a refund to cancel out, so that it passes out.
589 01:07:20.610 ⇒ 01:07:21.280 Demilade Agboola: And you have.
590 01:07:23.540 ⇒ 01:07:26.060 Demilade Agboola: I’m saying… Con… can we…
591 01:07:26.060 ⇒ 01:07:27.500 Emily Giant: Yep.
592 01:07:27.630 ⇒ 01:07:34.540 Emily Giant: That’s what it is, that’s what’s happening. But it didn’t used to happen, which is what’s weird. Like…
593 01:07:34.750 ⇒ 01:07:46.099 Emily Giant: in the other orders that we looked at, a forced upgrade was just zero, and I’m… I’m wondering if, like, it’s because a different action was performed? Because I can see that, like.
594 01:07:46.600 ⇒ 01:07:55.429 Emily Giant: Helen did it by, like, brute force in that order we were looking at. I just used to work on that team, and I know what that looks like, but…
595 01:07:56.500 ⇒ 01:07:59.340 Emily Giant: These that are showing $0.
596 01:07:59.720 ⇒ 01:08:01.470 Emily Giant: Presumably correctly.
597 01:08:10.710 ⇒ 01:08:15.490 Emily Giant: Like, these 3 were removed, and they all show $0, correctly.
598 01:08:20.500 ⇒ 01:08:27.980 Demilade Agboola: Can we… can we then take this order, this same order, and can we look at it in the same, like, order line-based table that we’re looking at?
599 01:08:28.210 ⇒ 01:08:28.939 Emily Giant: Yes.
600 01:08:38.740 ⇒ 01:08:39.710 Emily Giant: Perfect.
601 01:08:41.080 ⇒ 01:08:45.120 Emily Giant: This is exactly what I was expecting to see in the other table.
602 01:08:46.060 ⇒ 01:08:49.720 Demilade Agboola: Alright, so effectively, one way or the other, it does balance it out.
603 01:08:51.750 ⇒ 01:08:52.479 Emily Giant: Yes.
604 01:08:52.740 ⇒ 01:09:04.619 Demilade Agboola: So if it zeroes here, it zeroes in the refund table. If it doesn’t zero here, it keeps the amount in the other table, so, like, the subtraction will cancel out.
605 01:09:06.380 ⇒ 01:09:09.809 Emily Giant: However, the other order didn’t actually have a refund.
606 01:09:10.660 ⇒ 01:09:18.829 Emily Giant: So it’s… showing revenue that doesn’t exist, like that $66.70, or whatever it was.
607 01:09:19.220 ⇒ 01:09:24.259 Emily Giant: That shouldn’t be there, because no more money was taken in than what shows on the
608 01:09:27.330 ⇒ 01:09:30.799 Emily Giant: So, it’s the same thing happened. There was a forced upgrade.
609 01:09:30.930 ⇒ 01:09:32.000 Demilade Agboola: Yeah. But…
610 01:09:32.000 ⇒ 01:09:33.530 Emily Giant: it, it’s showing.
611 01:09:34.000 ⇒ 01:09:43.660 Emily Giant: a subtotal, and this was never part of the subtotal, it’s only that… even this isn’t part of the subtotal, it’s just this. It should say 0, 0, 0.
612 01:09:44.590 ⇒ 01:09:49.210 Demilade Agboola: Yeah, but then, it’s, like I said, it’s factored in the discount.
613 01:09:50.649 ⇒ 01:09:59.730 Demilade Agboola: So it’s this… if you add the discount that was there to 66.47, you literally will get 78… 28.2.
614 01:10:00.810 ⇒ 01:10:02.629 Demilade Agboola: So, it’s already done that.
615 01:10:02.740 ⇒ 01:10:04.200 Demilade Agboola: behind the scenes.
616 01:10:05.010 ⇒ 01:10:10.110 Demilade Agboola: So what I… that’s what I was saying, I need to prop… I need to get the discounts as well, and add it.
617 01:10:13.540 ⇒ 01:10:14.219 Demilade Agboola: Hey, Mr. No.
618 01:10:14.220 ⇒ 01:10:16.040 Emily Giant: the same item.
619 01:10:17.500 ⇒ 01:10:20.959 Emily Giant: Sorry, I was just looking… that’s not the same item. Okay, sorry. Go ahead.
620 01:10:21.620 ⇒ 01:10:26.370 Demilade Agboola: Yeah, cause right now, if we… If we have the…
621 01:10:26.550 ⇒ 01:10:37.900 Demilade Agboola: If we sum up everything, and also add discounts to it, we will get the appropriate revenue. So the appropriate revenue should be 782… I mean, minus shipping, the appropriate revenue should be 78,200, right?
622 01:10:39.020 ⇒ 01:10:40.410 Emily Giant: Let me double check.
623 01:10:40.600 ⇒ 01:10:46.160 Emily Giant: I, I believe so. It should be that plus 28, because of, shipping.
624 01:10:46.370 ⇒ 01:10:47.099 Demilade Agboola: Yeah, that’s a simple.
625 01:10:47.100 ⇒ 01:10:47.690 Emily Giant: Right.
626 01:10:47.690 ⇒ 01:10:50.579 Demilade Agboola: Back to all shipping, because shipping is in…
627 01:11:00.280 ⇒ 01:11:04.130 Emily Giant: Yep, it should be $78.20, is revenue plus 28.
628 01:11:04.490 ⇒ 01:11:05.120 Demilade Agboola: Yeah.
629 01:11:05.480 ⇒ 01:11:08.279 Demilade Agboola: So… what I’m saying is…
630 01:11:08.640 ⇒ 01:11:16.929 Demilade Agboola: the 78 minus the discount, which is the WLCOM 15 that was used, is $66.47.
631 01:11:17.550 ⇒ 01:11:23.209 Demilade Agboola: That’s how we got the 6647. So now what I need to do is I need to create
632 01:11:23.530 ⇒ 01:11:33.740 Demilade Agboola: in terms of calculating revenue, I need to tell it, hey, Take all the orders, Subtract the refund.
633 01:11:34.530 ⇒ 01:11:38.670 Demilade Agboola: Add the discounts, And adds the shipping.
634 01:11:40.920 ⇒ 01:11:42.830 Demilade Agboola: Do you st… Do you see what I’.
635 01:11:42.830 ⇒ 01:11:52.879 Emily Giant: I understand what you’re saying, but I feel like this is an outlier. Like, it… the source data doesn’t look like this for a normal order.
636 01:11:55.050 ⇒ 01:11:59.839 Demilade Agboola: Okay, can we, can we look at a, a normal, like, your regular… Yeah.
637 01:12:00.310 ⇒ 01:12:02.610 Emily Giant: Yes, let’s find one.
638 01:12:17.630 ⇒ 01:12:20.389 Emily Giant: Okay, regular order. Nothing’s happened to this.
639 01:12:20.660 ⇒ 01:12:21.859 Emily Giant: There’s a discount.
640 01:12:22.130 ⇒ 01:12:23.850 Emily Giant: for $32.
641 01:12:31.100 ⇒ 01:12:33.090 Emily Giant: Let me just look at it here…
642 01:12:39.110 ⇒ 01:12:45.199 Emily Giant: The subtotal is 161. I expect to see subtotal row, we’ll say 161.
643 01:12:45.420 ⇒ 01:12:48.950 Emily Giant: Although there’s 2 items, it’ll say 133 and 28.
644 01:12:49.140 ⇒ 01:12:51.220 Emily Giant: That’s my expectation.
645 01:12:51.220 ⇒ 01:12:54.970 Demilade Agboola: But there’ll be a discount because of the negative 32, but let’s see.
646 01:12:56.790 ⇒ 01:13:03.340 Emily Giant: Subtotal should never have discount in it, is how our… how it’s supposed to be set up.
647 01:13:03.980 ⇒ 01:13:06.420 Demilade Agboola: Yeah… right.
648 01:13:10.000 ⇒ 01:13:12.669 Emily Giant: So, subtotal 106 and 22.
649 01:13:13.660 ⇒ 01:13:14.440 Demilade Agboola: So…
650 01:13:14.440 ⇒ 01:13:18.360 Emily Giant: And then… Yep, 133, so that…
651 01:13:18.560 ⇒ 01:13:19.210 Demilade Agboola: It does…
652 01:13:19.210 ⇒ 01:13:20.620 Emily Giant: 4161.
653 01:13:21.180 ⇒ 01:13:25.880 Demilade Agboola: Okay, so, no, the 32 subtracted from the 133, that’s why it’s 1-0-something.
654 01:13:26.480 ⇒ 01:13:32.769 Emily Giant: Ugh, why are they doing that? They don’t even do it in Shopify, and they’re doing it in their data?
655 01:13:34.750 ⇒ 01:13:35.110 Demilade Agboola: Yes.
656 01:13:35.110 ⇒ 01:13:37.349 Emily Giant: So the unit price, and then…
657 01:13:38.410 ⇒ 01:13:39.180 Demilade Agboola: Yeah.
658 01:13:39.550 ⇒ 01:13:42.219 Demilade Agboola: So that’s what I’m saying. So it would literally be…
659 01:13:42.790 ⇒ 01:13:49.400 Demilade Agboola: The subtotal amount, the sum of it, Plus… the discount.
660 01:13:49.400 ⇒ 01:13:52.289 Emily Giant: Plus the discount. I gotcha, yeah.
661 01:13:52.560 ⇒ 01:13:55.539 Demilade Agboola: But why doesn’t this have a weird line?
662 01:13:55.540 ⇒ 01:13:59.489 Emily Giant: Like, this doesn’t have a weird line saying the other prices.
663 01:14:00.090 ⇒ 01:14:01.500 Emily Giant: Like, that one order.
664 01:14:03.280 ⇒ 01:14:04.489 Demilade Agboola: No, I’m not sure.
665 01:14:09.310 ⇒ 01:14:15.199 Demilade Agboola: Like, we’re saying this is… I’m guessing the line amount will be similar to the line price amount, though.
666 01:14:16.150 ⇒ 01:14:17.870 Demilade Agboola: Right? Like, that’s how much it.
667 01:14:23.520 ⇒ 01:14:24.970 Emily Giant: So, yeah.
668 01:14:25.820 ⇒ 01:14:27.260 Emily Giant: Unit protects.
669 01:14:27.410 ⇒ 01:14:29.480 Emily Giant: Let me look and dash at that again.
670 01:14:31.780 ⇒ 01:14:37.940 Emily Giant: So this is actually what was charged, right? And then… So, 106, but no.
671 01:14:38.630 ⇒ 01:14:43.950 Emily Giant: No. So subtotal’s still, and then they applied the discount onto the things here.
672 01:14:44.800 ⇒ 01:14:45.500 Demilade Agboola: Yeah.
673 01:14:47.200 ⇒ 01:14:56.320 Demilade Agboola: But then, the way the discount was applied to each line item is 106 and 22, so that’s what shows.
674 01:14:56.320 ⇒ 01:14:57.230 Emily Giant: Yeah.
675 01:14:58.980 ⇒ 01:15:04.499 Emily Giant: So, I guess my question is, why? What the hell is this order?
676 01:15:05.510 ⇒ 01:15:09.230 Emily Giant: When it has all of the lines involved.
677 01:15:10.090 ⇒ 01:15:18.590 Emily Giant: But, oh, oh, I got you. So you’re saying… I understand you completely now. You’re saying once the refunds are added, this will zero.
678 01:15:18.800 ⇒ 01:15:23.989 Emily Giant: Because this is the amount in the discounts. Yes. Got you. Okay, makes total sense.
679 01:15:24.720 ⇒ 01:15:28.499 Demilade Agboola: So that’s what I want to do, that’s what I want to do, and push… so I would, like…
680 01:15:28.830 ⇒ 01:15:33.949 Demilade Agboola: I will… are you going to push your branch tonight, so I can use it to…
681 01:15:34.530 ⇒ 01:15:35.200 Emily Giant: Yeah.
682 01:15:36.910 ⇒ 01:15:37.380 Demilade Agboola: So…
683 01:15:37.380 ⇒ 01:15:38.360 Emily Giant: can do…
684 01:15:38.920 ⇒ 01:15:47.070 Demilade Agboola: tweak… build on… off the refunds here, the other line base, and I will just create a revenue model that will, for each order, will…
685 01:15:47.580 ⇒ 01:15:53.180 Demilade Agboola: Sum the amount, and if there’s a refund as well, subtract the refunds, and then add all this.
686 01:15:53.180 ⇒ 01:15:53.820 Emily Giant: Yeah.
687 01:15:54.290 ⇒ 01:15:55.830 Demilade Agboola: And that will count as a revenue.
688 01:15:56.830 ⇒ 01:16:09.270 Emily Giant: Okay, I’ll just commit this now, because I don’t… there’s very few changes, but it’s just those ones that I was showing you in the intermediate refund. So it hasn’t been taken down to events, but
689 01:16:09.480 ⇒ 01:16:15.099 Emily Giant: it’s a minor change, it’s just, like, product invariant, if you want them.
690 01:16:15.720 ⇒ 01:16:27.559 Demilade Agboola: Yeah, no, that’s fine. That’s part of what I want to build off, so that at least I can have that information in the tables that we’re using, so at least it’s easier to, QA.
691 01:16:28.270 ⇒ 01:16:30.990 Demilade Agboola: Especially when I’m on the call with Perry tomorrow.
692 01:16:32.880 ⇒ 01:16:35.170 Emily Giant: Yeah, okay, so let me just make sure…
693 01:16:35.370 ⇒ 01:16:39.360 Emily Giant: All I did in this one was, list out.
694 01:16:39.660 ⇒ 01:16:43.870 Emily Giant: in… Then I added variant product SKU.
695 01:16:43.870 ⇒ 01:16:44.700 Demilade Agboola: If there’s anything…
696 01:16:44.700 ⇒ 01:16:48.579 Emily Giant: listing out… okay, I can just deploy this, I don’t think it’s gonna…
697 01:16:48.900 ⇒ 01:16:59.690 Demilade Agboola: If there’s anything that I’m happy that, you know, you’ve learned from working together with me is listing our models. It’s really such a life changer to just having.
698 01:16:59.690 ⇒ 01:17:01.410 Emily Giant: Yeah, totally.
699 01:17:01.930 ⇒ 01:17:06.739 Emily Giant: I do it whenever I see a select star, I’m like, - nope.
700 01:17:06.760 ⇒ 01:17:09.480 Demilade Agboola: We ain’t playing that game.
701 01:17:10.370 ⇒ 01:17:11.700 Demilade Agboola: Because… Okay.
702 01:17:13.520 ⇒ 01:17:14.590 Demilade Agboola: Yeah.
703 01:17:16.120 ⇒ 01:17:22.299 Emily Giant: Alright, so that is now pushed, and you can build on that. It’ll be way easier to QA.
704 01:17:22.760 ⇒ 01:17:26.589 Emily Giant: And then you and I can hit this again in the morning.
705 01:17:27.190 ⇒ 01:17:27.600 Demilade Agboola: Yep.
706 01:17:27.600 ⇒ 01:17:32.939 Emily Giant: And if PK’s planning to come, we’ll just tell him to not, unless he wants to sit there and watch, but…
707 01:17:34.340 ⇒ 01:17:38.750 Emily Giant: Yeah. Alright, cool. Alright, I hope that was helpful.
708 01:17:39.260 ⇒ 01:17:43.510 Emily Giant: But it’s really late where you live, so you gotta stop. You gotta go to bed.
709 01:17:43.860 ⇒ 01:17:48.720 Demilade Agboola: I probably won’t. I’ll probably just take a little straw, grab, get a Red Bull, and…
710 01:17:48.840 ⇒ 01:17:50.119 Emily Giant: Oh, gosh.
711 01:17:50.460 ⇒ 01:17:51.110 Demilade Agboola: Phil.
712 01:17:51.140 ⇒ 01:17:55.479 Emily Giant: Well, I’ll be awake, so just, huddle me if you need anything.
713 01:17:55.480 ⇒ 01:17:56.140 Demilade Agboola: Alright, sounds good.
714 01:17:56.140 ⇒ 01:17:59.129 Emily Giant: I’ll be awake till 11. Alright, cool, I’ll talk to you soon.
715 01:17:59.130 ⇒ 01:18:00.310 Demilade Agboola: Okay, bye.
716 01:18:00.600 ⇒ 01:18:01.420 Emily Giant: Bye.