Meeting Title: Working session Date: 2025-10-21 Meeting participants: Emily Giant, Demilade
WEBVTT
1 00:18:19.920 ⇒ 00:18:20.989 Demilade: Hi, Amy.
2 00:18:21.510 ⇒ 00:18:23.320 Emily Giant: Oh, hi, how’s it going?
3 00:18:23.450 ⇒ 00:18:27.030 Demilade: I’m fine. It’s just going, it’s just about to begin.
4 00:18:27.030 ⇒ 00:18:32.849 Emily Giant: Yeah. We can seriously reschedule so that you can rest a little.
5 00:18:33.140 ⇒ 00:18:38.400 Demilade: Oh, no, no, no, I’m up, like… like, the moment I sleep is once I wake up, it’s hard for me to go back.
6 00:18:38.590 ⇒ 00:18:44.209 Emily Giant: So, like, at this point, I’m up. It’s fine. I just… I have no idea where I slept at, like…
7 00:18:45.050 ⇒ 00:18:55.770 Demilade: I slept a bit, like, quite late, and then eventually I just kept, like, I just slept. And I try not to use the arms, because I feel like your body needs to get the sleep it needs, don’t always force it.
8 00:18:56.110 ⇒ 00:18:57.100 Emily Giant: Yeah.
9 00:18:57.110 ⇒ 00:19:03.170 Demilade: Yeah, unless there’s stuff I need to wake up for, so I had no idea of sleep for this long, but yeah, it’s fine.
10 00:19:03.620 ⇒ 00:19:18.610 Emily Giant: Oh, I’m glad you did. I am working on adding line item tags to the… I have to meet with CARE later to go over refunds and help them replace their dashboards, and they need, like, the dimensions to the order tags and blah blah blah, so I’m like.
11 00:19:18.610 ⇒ 00:19:24.980 Emily Giant: just trying to slap that together real quick, because it’s not hard, and it’s all kind of the same stuff, but ugh.
12 00:19:24.980 ⇒ 00:19:27.650 Demilade: When you say care tax, what would those tags be?
13 00:19:27.960 ⇒ 00:19:35.710 Emily Giant: They’re in… So, here, one sec. I have to tell Kriser that it’s being an idiot.
14 00:19:36.000 ⇒ 00:19:38.760 Emily Giant: One sec.
15 00:19:52.660 ⇒ 00:19:58.060 Emily Giant: I love cursor, but sometimes I’m like, stop? What are you doing?
16 00:19:58.530 ⇒ 00:20:00.710 Emily Giant: Here, I’ll show you what I’m looking at.
17 00:20:00.710 ⇒ 00:20:04.709 Demilade: Like, ask it to tell you what it wants to do first before executing.
18 00:20:04.710 ⇒ 00:20:11.220 Emily Giant: Yeah, and then it will do it, like, 95% of the time, and then every now and then, when you look away, it’s like, I’m doing what I want.
19 00:20:11.350 ⇒ 00:20:25.039 Emily Giant: I’m like, no! No! Why are you doing this? We’ve… we’ve gone over this. But, okay, so this is all kind of in the same, like, revenue historical stuff that I’m trying to fill the order tags with, but,
20 00:20:26.010 ⇒ 00:20:31.089 Emily Giant: Essentially, the care tags are,
21 00:20:31.800 ⇒ 00:20:39.790 Emily Giant: minimize that… are in… currently, they’re in this, like, DIM care tags that ties back to…
22 00:20:40.160 ⇒ 00:20:57.009 Emily Giant: this main old revenue model called DIM Line Item Union, that’s, like, the component pieces, so I’ll use that to tie it to the fulfillments table in Shopify, because there’s an ID called Shopify ID, that’s, like, the order line ID, and for the new stuff, I can.
23 00:20:57.290 ⇒ 00:20:59.490 Demilade: You can double tie it back to Shopify.
24 00:20:59.650 ⇒ 00:21:03.789 Demilade: So what does the caretag… what are the tags there to? Like, when you say tags?
25 00:21:04.120 ⇒ 00:21:05.800 Emily Giant: Let me show you.
26 00:21:15.270 ⇒ 00:21:19.260 Emily Giant: So, essentially, when there’s a refund, credit, or re-delivery.
27 00:21:19.390 ⇒ 00:21:31.950 Emily Giant: the agent has to mark why the customer is getting a resolution, and it comes through Hivo, but it’s gonna eventually switch to Shopify, but we still gotta, like, maintain all these until we switch it to Shopify.
28 00:21:32.260 ⇒ 00:21:33.770 Emily Giant: And,
29 00:21:34.200 ⇒ 00:21:42.560 Emily Giant: Here, it’ll come soon, but it’ll be, like, wilted flowers, or arrived late, or something along those lines,
30 00:21:43.280 ⇒ 00:21:44.410 Emily Giant: But…
31 00:21:45.330 ⇒ 00:22:03.049 Emily Giant: one of… like, the table that we can use from Hivo to tie it, there wasn’t a staging or raw model yet. There was, like, one for everyone but that one. So, I am like, oh gosh, slapping it together, and then can fix it retroactively, but…
32 00:22:03.070 ⇒ 00:22:05.970 Emily Giant: It’s taking forever to load.
33 00:22:06.590 ⇒ 00:22:08.460 Emily Giant: goodness.
34 00:22:09.070 ⇒ 00:22:12.760 Demilade: I don’t know, it’s fine, I just really wanted to see what the times were.
35 00:22:12.760 ⇒ 00:22:13.840 Emily Giant: Oh, you know what?
36 00:22:15.110 ⇒ 00:22:15.820 Emily Giant: Here you go.
37 00:22:16.230 ⇒ 00:22:17.270 Demilade: Excuse me.
38 00:22:17.270 ⇒ 00:22:18.850 Emily Giant: This is the role model.
39 00:22:20.490 ⇒ 00:22:22.030 Emily Giant: They look like this.
40 00:22:22.230 ⇒ 00:22:25.609 Emily Giant: Forced upgrade, customer requested order change.
41 00:22:26.390 ⇒ 00:22:30.210 Emily Giant: it’s all of these, like, extra vase was added and had to be removed.
42 00:22:30.540 ⇒ 00:22:33.110 Emily Giant: Stuff like that. Some of them don’t…
43 00:22:33.610 ⇒ 00:22:37.079 Emily Giant: I don’t think that this raw table,
44 00:22:37.770 ⇒ 00:22:43.970 Emily Giant: And then it has the action, so it, like, it has why they returned it, and then it has what the person did.
45 00:22:44.350 ⇒ 00:22:46.900 Demilade: Okay. Alright, we’ll see.
46 00:22:46.900 ⇒ 00:22:50.269 Emily Giant: I really use this to, tag a re-delivery.
47 00:22:50.480 ⇒ 00:22:54.400 Emily Giant: Where it’s, rare.
48 00:22:54.590 ⇒ 00:22:59.540 Emily Giant: Action… like… Remove.
49 00:23:06.030 ⇒ 00:23:10.300 Demilade: That’s what I’m thinking of now, or what I was thinking of doing before,
50 00:23:11.570 ⇒ 00:23:16.040 Demilade: was slightly different, but I think this would also be helpful, like, very, very helpful, actually.
51 00:23:17.330 ⇒ 00:23:20.960 Emily Giant: So, remove line item, it will give you the…
52 00:23:21.570 ⇒ 00:23:29.059 Emily Giant: forced upgrade, a non-inventory discrepancy. So there’s gonna be that tag with remove line item, and then there should be,
53 00:23:29.390 ⇒ 00:23:31.340 Emily Giant: a line item ID.
54 00:23:35.950 ⇒ 00:23:37.639 Emily Giant: What the fudge?
55 00:23:41.100 ⇒ 00:23:43.140 Emily Giant: I don’t know why none of this is…
56 00:23:43.380 ⇒ 00:23:46.950 Emily Giant: populated. These might be really old or something. Yeah.
57 00:23:48.250 ⇒ 00:23:51.330 Emily Giant: And skew is not null.
58 00:24:03.340 ⇒ 00:24:10.060 Emily Giant: Okie dokie. So this is how Steven did it in the past.
59 00:24:10.460 ⇒ 00:24:13.130 Emily Giant: Dim Line Item Union…
60 00:24:18.380 ⇒ 00:24:24.780 Emily Giant: Staging line item, staging split line item, staging union… Sorry, this is not…
61 00:24:25.230 ⇒ 00:24:31.489 Emily Giant: that’s not the right model, that’s why I’m like, what in the hell? Staging line item tags.
62 00:24:32.690 ⇒ 00:24:34.930 Emily Giant: So, this is…
63 00:24:37.050 ⇒ 00:24:42.529 Emily Giant: ID is line item ID, suborder ID from DIM line item union, and then it matches it…
64 00:24:43.050 ⇒ 00:24:46.529 Emily Giant: on this join ID situation.
65 00:24:47.290 ⇒ 00:24:49.549 Emily Giant: But if I just compile this…
66 00:24:51.910 ⇒ 00:24:55.299 Emily Giant: The part where he’s creating the join ID.
67 00:24:57.450 ⇒ 00:24:59.380 Emily Giant: ID 1…
68 00:25:25.040 ⇒ 00:25:27.949 Emily Giant: I just want to see what this join ID looks like.
69 00:25:37.580 ⇒ 00:25:43.050 Emily Giant: Okay, so it’s just the… it’s the order ID plus the HEVO array index, is what it looks like.
70 00:25:43.940 ⇒ 00:25:44.799 Demilade: Okay.
71 00:25:45.970 ⇒ 00:25:48.550 Demilade: Is that the order ID or the SOAP order ID?
72 00:25:48.550 ⇒ 00:25:55.219 Emily Giant: suborder, because it’s dash 1 and then underscore, split part ID dash 2.
73 00:25:56.590 ⇒ 00:25:57.450 Emily Giant: Yeah.
74 00:25:58.700 ⇒ 00:26:02.739 Emily Giant: But this, the DIM line item union… so if we…
75 00:26:03.330 ⇒ 00:26:08.550 Emily Giant: Do you want to keep going down this path, or do you want to chat through revenue? Because I’m happy to do either, both are important.
76 00:26:08.810 ⇒ 00:26:09.540 Emily Giant: So…
77 00:26:09.540 ⇒ 00:26:10.430 Demilade: Right.
78 00:26:11.230 ⇒ 00:26:11.730 Emily Giant: What’d you say?
79 00:26:12.790 ⇒ 00:26:19.760 Demilade: So revenue, I’ve pushed the… like, if we look at revenue, I’ve done the fix to…
80 00:26:20.550 ⇒ 00:26:23.439 Demilade: I’ve added the shipping cost to revenue.
81 00:26:25.070 ⇒ 00:26:32.069 Demilade: I think the… the product attributes is what I wanted to look at the… I’ll look at today.
82 00:26:32.070 ⇒ 00:26:32.990 Emily Giant: God.
83 00:26:33.310 ⇒ 00:26:34.590 Demilade: read that out.
84 00:26:35.060 ⇒ 00:26:38.030 Demilade: Let’s…
85 00:26:38.250 ⇒ 00:26:48.089 Emily Giant: do that, because I’m gonna do… I’m gonna create this model for care, and I think it’ll be easier for you to see, like, how it connects to Shopify once those tables are done.
86 00:26:48.220 ⇒ 00:26:51.760 Emily Giant: And I do think you’ll be able to use it for forced upgrades.
87 00:26:52.080 ⇒ 00:26:53.230 Demilade: Okay, boom.
88 00:26:53.680 ⇒ 00:27:00.020 Demilade: Will that be tied? Because the way it is in Shopify, we only get, like, the order ID,
89 00:27:02.560 ⇒ 00:27:07.239 Demilade: When… like, when you get the suborder ID, when it’s shipped out, though.
90 00:27:08.910 ⇒ 00:27:11.190 Emily Giant: That’s fine, because these are all problem orders.
91 00:27:12.680 ⇒ 00:27:13.080 Demilade: Okay.
92 00:27:13.080 ⇒ 00:27:14.919 Emily Giant: So they’ll have been delivered.
93 00:27:16.930 ⇒ 00:27:31.130 Demilade: I think… I think my question is more of the, will we be able to see the exact line that had the issue, or is it just going to be, oh, this is the order… the exact suborder that had the issue, or is it just going to be the exact… or is it just going to be the entire order?
94 00:27:31.500 ⇒ 00:27:34.189 Emily Giant: No, it’ll be the line. So…
95 00:27:35.320 ⇒ 00:27:40.689 Emily Giant: Let me see… I doubt what Cursor just did will work, because I gave it very…
96 00:27:41.890 ⇒ 00:27:58.049 Emily Giant: not detailed enough instructions, but the join to Shopify comes through the component level, so that’s, like, the line item, and it does have the order line ID. Let me pull open what it just made, and we can laugh together at it.
97 00:28:00.100 ⇒ 00:28:05.680 Emily Giant: This would be here… And then in staging…
98 00:28:08.930 ⇒ 00:28:12.739 Emily Giant: And, orders care.
99 00:28:13.510 ⇒ 00:28:16.219 Emily Giant: Station care line item tags.
100 00:28:17.820 ⇒ 00:28:21.019 Emily Giant: Alright, so it should have,
101 00:28:27.530 ⇒ 00:28:35.420 Emily Giant: So, here… it pulls the component ID, which ties back to Shopify fulfillment.
102 00:28:35.880 ⇒ 00:28:49.339 Emily Giant: On the… that we use, here… it pulls… the order line ID.
103 00:28:49.850 ⇒ 00:28:54.120 Emily Giant: And I think that that’s… At the, line item level.
104 00:28:54.390 ⇒ 00:28:56.550 Emily Giant: Almost sure. Almost positive.
105 00:28:56.890 ⇒ 00:28:59.209 Demilade: Yeah, but isn’t that when it’s fulfilled, though?
106 00:28:59.810 ⇒ 00:29:00.750 Emily Giant: Yes.
107 00:29:01.020 ⇒ 00:29:10.890 Emily Giant: But orders don’t generally receive resolutions unless they’ve been fulfilled, because the customer has nothing to complain about unless the order’s been delivered to them.
108 00:29:11.090 ⇒ 00:29:12.840 Demilade: Gotcha, gotcha.
109 00:29:12.840 ⇒ 00:29:22.369 Emily Giant: So, yeah, so this table is really about fulfilled orders only, because it’s, like, the refund, credit, re-delivery, and
110 00:29:24.190 ⇒ 00:29:27.019 Emily Giant: It will still come through as a…
111 00:29:27.850 ⇒ 00:29:30.080 Emily Giant: Yeah, I see what you’re saying.
112 00:29:30.510 ⇒ 00:29:35.269 Emily Giant: But there are very few cases where the order would not have been fulfilled.
113 00:29:35.880 ⇒ 00:29:41.870 Emily Giant: Okay, gotcha. And the only ones I can think of is when the revenue is not recognized, because we never…
114 00:29:42.520 ⇒ 00:29:55.589 Emily Giant: I think Perry is misinformed, I will say. Like, accounting standards, how we do them, is that revenue is not recognized until the order is fulfilled. So, even though, like, they want…
115 00:29:55.660 ⇒ 00:30:04.719 Emily Giant: they definitely need to see that accrued revenue. If an order is canceled before it’s fulfilled, it needs to go away from the accrued revenue.
116 00:30:06.090 ⇒ 00:30:07.550 Demilade: Yeah, but that’s what she said, though.
117 00:30:07.980 ⇒ 00:30:10.800 Emily Giant: Oh, that’s what she did say? Okay, then we’re on the…
118 00:30:10.800 ⇒ 00:30:14.670 Demilade: What do you think… I just want to… I just want to clarify if maybe I misheard.
119 00:30:15.410 ⇒ 00:30:19.250 Demilade: What was the other… what do you think Perry was saying should be actually revenue?
120 00:30:19.250 ⇒ 00:30:24.570 Emily Giant: So, she was saying that canceled orders should show in accrued revenue.
121 00:30:26.280 ⇒ 00:30:28.570 Demilade: That’s what quarter is that?
122 00:30:28.570 ⇒ 00:30:34.159 Emily Giant: I’m like, no, that doesn’t make sense. Because they’re no longer in order. We don’t have that money.
123 00:30:35.220 ⇒ 00:30:36.760 Demilade: Fair enough.
124 00:30:37.820 ⇒ 00:30:50.780 Emily Giant: because the way that we do accounting, we do it by delivery date. So, in my head, I’m like, that means that we need the accrued revenue and the fulfilled revenue line, but over time, they should balance.
125 00:30:52.330 ⇒ 00:30:59.759 Emily Giant: like, for Mother’s Day, those lines should be balanced, because the order’s canceled in accrued.
126 00:31:00.050 ⇒ 00:31:09.010 Emily Giant: Should match the orders fulfilled, because you can’t order far enough in advance that by now, in October.
127 00:31:09.190 ⇒ 00:31:12.700 Emily Giant: The orders that were canceled before they were fulfilled.
128 00:31:12.890 ⇒ 00:31:17.189 Emily Giant: That money would go away from accrued, and eventually those two should match.
129 00:31:17.610 ⇒ 00:31:18.310 Demilade: Yeah.
130 00:31:19.720 ⇒ 00:31:33.059 Emily Giant: So that’s why I was like, no, like, we can’t say that this is right when there’s a million dollars of accrued revenue showing, because clearly there are canceled orders in there, or forced upgrades that didn’t happen. So…
131 00:31:33.800 ⇒ 00:31:38.810 Demilade: Yeah, yeah, but I think she was saying that because we’re double counting the fact that there was
132 00:31:38.930 ⇒ 00:31:46.550 Demilade: the order, plus then the, like, what happened after the resolution, as both of them, as we cancel out the…
133 00:31:47.580 ⇒ 00:31:56.669 Emily Giant: Yeah, she was saying that, and was misunderstanding that canceled orders, when they are canceled, need to go away from accrued.
134 00:31:57.310 ⇒ 00:31:59.289 Demilade: Yeah, well, fair, fair enough.
135 00:31:59.290 ⇒ 00:32:07.389 Emily Giant: Yeah, it was, like, two different things, but yeah, so this is the ID that we use in the join, is at the line, for the
136 00:32:08.400 ⇒ 00:32:10.970 Emily Giant: The table that we’re still using,
137 00:32:12.180 ⇒ 00:32:16.410 Emily Giant: Hivo. So this should be able to tie to Shopify fulfillment.
138 00:32:17.760 ⇒ 00:32:21.809 Demilade: Alright, just, like, if you give it a shot, just let me know what you get, I will…
139 00:32:21.810 ⇒ 00:32:22.740 Emily Giant: Yeah.
140 00:32:22.970 ⇒ 00:32:31.869 Emily Giant: Alright, and then I wanted to chat through historical revenue, so that we can, like, put revenue behind us.
141 00:32:32.540 ⇒ 00:32:40.040 Emily Giant: So right now, The core revenue tables are, part of this, like.
142 00:32:42.400 ⇒ 00:32:46.459 Emily Giant: Dim line item union flow, so… it’s really messy.
143 00:32:48.110 ⇒ 00:32:53.549 Emily Giant: But it’s the ones that use, the line items and components, HEVO tables.
144 00:32:53.810 ⇒ 00:33:03.009 Emily Giant: And, eventually go to ComponentsXF, And that’s where that, like…
145 00:33:04.580 ⇒ 00:33:09.960 Emily Giant: revenue calculation, dim sum… I want to find… ComponentsXF.
146 00:33:10.810 ⇒ 00:33:12.110 Emily Giant: from this.
147 00:33:15.060 ⇒ 00:33:20.440 Emily Giant: In components, dataset Union, okay, we’re almost there. So this one…
148 00:33:22.400 ⇒ 00:33:27.729 Emily Giant: So the issue here is there’s a lot of, like… we also use this one in inventory.
149 00:33:31.810 ⇒ 00:33:37.880 Emily Giant: But this is where, like… All of those calculations happen.
150 00:33:39.620 ⇒ 00:33:45.220 Emily Giant: With, like, the kits and stuff. So, once we set it back.
151 00:33:45.640 ⇒ 00:33:52.810 Emily Giant: to being time-gated, I think a lot of the problems will go away with, like, how it was being calculated.
152 00:33:53.130 ⇒ 00:33:57.640 Emily Giant: But my question is, do we rebuild these, or do we just move these over to the new model structure?
153 00:33:59.370 ⇒ 00:34:02.359 Demilade: I personally like to rebuild them, because…
154 00:34:06.200 ⇒ 00:34:09.040 Demilade: I will, as yet, as you’re rebuilding.
155 00:34:09.190 ⇒ 00:34:12.570 Demilade: It makes it easier to catch things that are… Yeah.
156 00:34:13.120 ⇒ 00:34:14.260 Demilade: wonky.
157 00:34:15.409 ⇒ 00:34:18.009 Demilade: He thinks that you don’t need as well.
158 00:34:18.250 ⇒ 00:34:21.459 Demilade: I don’t think we need all these columns as well.
159 00:34:22.100 ⇒ 00:34:26.260 Demilade: Something to match the current existing table, and then union it.
160 00:34:26.560 ⇒ 00:34:31.230 Emily Giant: Yeah, so… I would… yeah. So it looks like…
161 00:34:31.440 ⇒ 00:34:37.490 Emily Giant: you’ve already rebuilt some of the ones that I know are part of this, so that’s gonna be…
162 00:34:38.290 ⇒ 00:34:41.780 Emily Giant: Order split line item, order line item.
163 00:34:41.989 ⇒ 00:34:44.949 Emily Giant: Line item components, and then there’s one…
164 00:34:45.130 ⇒ 00:34:49.260 Emily Giant: That’s just components. I don’t think this is actually static.
165 00:34:50.050 ⇒ 00:34:52.610 Emily Giant: But it might be. Yeah. Maybe.
166 00:34:52.830 ⇒ 00:34:58.580 Emily Giant: So this is just an old table that I guess doesn’t update anymore, but I would…
167 00:34:59.600 ⇒ 00:35:06.689 Emily Giant: I would look into that to see. Now, I do know that these are slightly different than the ones,
168 00:35:07.050 ⇒ 00:35:10.870 Emily Giant: that are live and being used, because right now, I don’t think these are actually, like.
169 00:35:12.590 ⇒ 00:35:15.340 Emily Giant: Tied to anything. Yeah.
170 00:35:16.020 ⇒ 00:35:21.200 Emily Giant: But, if you open up the… One that it’s based on.
171 00:35:21.780 ⇒ 00:35:22.880 Emily Giant: Teaching.
172 00:35:24.660 ⇒ 00:35:25.510 Emily Giant: Split.
173 00:35:28.840 ⇒ 00:35:33.900 Emily Giant: I think the partitions are a little different. So this is the old one.
174 00:35:37.010 ⇒ 00:35:42.470 Emily Giant: And I did rework a lot of this when revenue got messed up a couple months ago.
175 00:35:44.250 ⇒ 00:35:51.749 Emily Giant: and I added, like, a lot of the columns that, well, I added all the columns, because it’s the staging model,
176 00:35:52.130 ⇒ 00:35:57.039 Emily Giant: And that way you can see, like, there’s a Shopify ID in this one that I didn’t realize.
177 00:35:58.020 ⇒ 00:35:59.280 Emily Giant: Good to know.
178 00:35:59.430 ⇒ 00:36:08.510 Emily Giant: Where’s… So these two should be based on the same… Source.
179 00:36:09.430 ⇒ 00:36:12.500 Emily Giant: But this one is… looking like…
180 00:36:13.550 ⇒ 00:36:15.750 Emily Giant: like, Shopify ID isn’t in here.
181 00:36:19.230 ⇒ 00:36:21.109 Emily Giant: But it is in the old one.
182 00:36:23.030 ⇒ 00:36:27.180 Demilade: Okay, well then, do we need Shopify ID for legacy… legacy revenue?
183 00:36:27.180 ⇒ 00:36:27.810 Emily Giant: Yeah.
184 00:36:28.010 ⇒ 00:36:36.250 Emily Giant: not necessarily that, but we do for the user action reasons.
185 00:36:38.620 ⇒ 00:36:40.220 Emily Giant: The… the care tags.
186 00:36:40.500 ⇒ 00:36:45.079 Demilade: Okay, but, like, don’t we have Kat? That’s what I’m trying to say.
187 00:36:47.560 ⇒ 00:36:52.329 Demilade: for things that happened before the 6th of November last year.
188 00:36:53.820 ⇒ 00:36:55.770 Demilade: Do we need Shopify ID for that?
189 00:36:58.110 ⇒ 00:37:01.390 Emily Giant: Let me think… No.
190 00:37:02.070 ⇒ 00:37:05.950 Demilade: Okay, but isn’t… I’m rebuilding the legacy revenue for that, though?
191 00:37:06.910 ⇒ 00:37:22.900 Emily Giant: Well, these tables are not just used in revenue. I need that Shopify ID for the user action reasons table at the order level, line item level, and component level, because you can return and refund something on any level, and it’s…
192 00:37:23.170 ⇒ 00:37:25.700 Emily Giant: Going to pull that info accordingly.
193 00:37:26.000 ⇒ 00:37:28.959 Demilade: I get that. What I’m trying to say is, if…
194 00:37:29.940 ⇒ 00:37:32.079 Demilade: the things after the 6th of November.
195 00:37:32.290 ⇒ 00:37:33.570 Demilade: 2024.
196 00:37:33.730 ⇒ 00:37:40.080 Demilade: Are gonna be… based off Shopify, and the Shopify data already has Shopify ID.
197 00:37:40.440 ⇒ 00:37:46.700 Demilade: For the things that come before that, though, do we need a Shopify ID if there was another way to find…
198 00:37:48.100 ⇒ 00:37:49.500 Demilade: That’s what I’m trying to understand.
199 00:37:49.500 ⇒ 00:37:50.969 Emily Giant: Not for revenue, no.
200 00:37:51.850 ⇒ 00:37:59.249 Emily Giant: But you do for other reasons. So, but for your purposes of historical revenue, no. For my purposes of…
201 00:37:59.860 ⇒ 00:38:05.110 Emily Giant: Being able to rebuild the care team’s models? Yes.
202 00:38:05.460 ⇒ 00:38:10.059 Demilade: So, you were using Shopify before 6th of November of last year?
203 00:38:11.180 ⇒ 00:38:11.820 Emily Giant: No.
204 00:38:12.570 ⇒ 00:38:17.610 Demilade: Yeah, so that’s… again, that’s what I’m very curious as to, because there will be Shopify ID,
205 00:38:18.110 ⇒ 00:38:22.890 Demilade: In the end tables, because they’re already… well, putting the old
206 00:38:23.000 ⇒ 00:38:27.840 Demilade: things to the new things, and the new things already have Shopify ID.
207 00:38:28.920 ⇒ 00:38:38.549 Emily Giant: but not the care tags. There is no care tag in Shopify. So there’s no way to pull those user action reasons without the HEVO tables.
208 00:38:39.100 ⇒ 00:38:41.350 Demilade: Okay, gotcha, gotcha, now I go.
209 00:38:41.350 ⇒ 00:38:56.419 Emily Giant: Yeah, so it doesn’t matter for revenue, at all. It only matters for refunds, credits, re-deliveries, reasons, because we don’t put those in Shopify, they just come from OMS. But I’m, like, looking at this, and I don’t even see Shopify ID in…
210 00:38:58.030 ⇒ 00:38:59.739 Emily Giant: the Final Select.
211 00:39:02.690 ⇒ 00:39:04.360 Emily Giant: Weird, right?
212 00:39:05.820 ⇒ 00:39:10.640 Emily Giant: Okay. Do you see it? Am I… Am I trippin’ here?
213 00:39:10.820 ⇒ 00:39:16.999 Demilade: I just do CTRL-F and try and find… or Command-F and try and find… How many times Shopify ID?
214 00:39:17.280 ⇒ 00:39:21.150 Demilade: No, like, you could… so what you should do is you can click into the file.
215 00:39:21.730 ⇒ 00:39:22.370 Emily Giant: Here.
216 00:39:22.690 ⇒ 00:39:24.960 Demilade: No, no, not the result, but the problem. Yeah, yeah, actually.
217 00:39:25.110 ⇒ 00:39:26.030 Demilade: Yeah, then…
218 00:39:30.880 ⇒ 00:39:35.839 Emily Giant: So it’s in there, I’m just looking through this table, and I don’t… oh, there it is. It’s just null, because these are…
219 00:39:40.360 ⇒ 00:39:41.200 Emily Giant: Okay.
220 00:39:42.960 ⇒ 00:39:47.130 Emily Giant: So, I guess what I’m saying is, I would…
221 00:39:49.460 ⇒ 00:39:59.189 Emily Giant: Copy and paste these that were made very recently, and, like, rebuild from there, as opposed to,
222 00:40:00.450 ⇒ 00:40:08.299 Emily Giant: The ones that were already rebuilt seem to be missing some of the… Some of the fields.
223 00:40:16.910 ⇒ 00:40:22.899 Emily Giant: And, like, these have a lot of downstream dependencies that we’ll need.
224 00:40:25.390 ⇒ 00:40:27.439 Emily Giant: To do historical revenue.
225 00:40:27.550 ⇒ 00:40:30.630 Emily Giant: Like, essentially, if you start at…
226 00:40:31.180 ⇒ 00:40:36.459 Emily Giant: I’ll write this down somewhere, but if you start at OMS CompXF base.
227 00:40:37.610 ⇒ 00:40:40.270 Emily Giant: All… all of these are still used.
228 00:40:41.050 ⇒ 00:40:46.390 Emily Giant: this will be your historical revenue, is everything upstream of OMS complex F-Base.
229 00:40:46.700 ⇒ 00:40:47.179 Demilade: Oh, okay.
230 00:40:47.180 ⇒ 00:40:54.940 Emily Giant: A large amount of it’s been re… rebuilt for NetSuite. That was when I did historical inventory, that still comes from here.
231 00:40:57.990 ⇒ 00:40:58.790 Demilade: Okay.
232 00:40:58.790 ⇒ 00:41:06.490 Emily Giant: And I’m not saying it’s perfect, it probably could use a lot of tweaking, but that is what’s used.
233 00:41:08.530 ⇒ 00:41:13.500 Emily Giant: So yeah, I don’t… I don’t know… Again, if you want…
234 00:41:14.670 ⇒ 00:41:21.780 Emily Giant: To totally rebuild these from scratch, or just, like, copy over, knowing that these have been, like, recently updated.
235 00:41:21.950 ⇒ 00:41:23.870 Emily Giant: Within the last 4 months.
236 00:41:24.490 ⇒ 00:41:30.620 Demilade: I mean, I will copy over some of the logic. I think part of the thing is, I also want us to have, like.
237 00:41:32.720 ⇒ 00:41:35.370 Demilade: When it comes to running.
238 00:41:35.560 ⇒ 00:41:42.800 Demilade: our models, I want them to have, like, our tags, frequency, so it allows us to be able to build out the…
239 00:41:42.800 ⇒ 00:41:43.540 Emily Giant: Yeah.
240 00:41:43.560 ⇒ 00:41:45.760 Demilade: entire pipeline when we want to…
241 00:41:45.880 ⇒ 00:41:56.239 Demilade: It just makes it less messy, and over time, as we’re deprecating these models, it’s an entirely different folder and path that we can just kind of…
242 00:41:57.230 ⇒ 00:41:59.339 Demilade: Ensure that we get rid of.
243 00:41:59.340 ⇒ 00:42:00.240 Emily Giant: Yeah.
244 00:42:00.680 ⇒ 00:42:04.980 Emily Giant: I’m down with that. I just know how much work it is… these models are like a…
245 00:42:05.650 ⇒ 00:42:09.670 Emily Giant: A lot of work, and a lot of dependencies.
246 00:42:10.500 ⇒ 00:42:14.160 Emily Giant: Like, I don’t think you’ll really need anything past this.
247 00:42:15.400 ⇒ 00:42:20.049 Emily Giant: For revenue, since all the calculations come from this and back.
248 00:42:20.670 ⇒ 00:42:21.520 Demilade: Okay.
249 00:42:22.100 ⇒ 00:42:28.850 Demilade: I mean, I’ll get into it, I will try to look at it, and we’ll see, we’ll see.
250 00:42:28.850 ⇒ 00:42:29.630 Emily Giant: Okay.
251 00:42:29.760 ⇒ 00:42:33.860 Emily Giant: Alright, do you want to go over the product attributes stuff?
252 00:42:34.900 ⇒ 00:42:36.500 Demilade: Yeah, so I’m…
253 00:42:49.250 ⇒ 00:42:50.980 Demilade: So it appears that we have…
254 00:43:03.840 ⇒ 00:43:06.099 Demilade: Sure, can you… can I share my screen?
255 00:43:06.100 ⇒ 00:43:06.650 Emily Giant: Yeah.
256 00:43:07.340 ⇒ 00:43:10.180 Demilade: I’ll need you to… So I’m sharing there.
257 00:43:10.180 ⇒ 00:43:11.090 Emily Giant: Yo.
258 00:43:17.690 ⇒ 00:43:20.440 Demilade: Interesting. One could actually share two desktops.
259 00:43:20.930 ⇒ 00:43:24.550 Demilade: So we have things that are, like, subscriptions.
260 00:43:25.420 ⇒ 00:43:28.010 Emily Giant: Like, celebration is out of flour.
261 00:43:28.010 ⇒ 00:43:29.030 Demilade: Post that.
262 00:43:36.710 ⇒ 00:43:42.240 Emily Giant: I did add the floral product ID and floral variant ID to the subscriptions model.
263 00:43:42.800 ⇒ 00:43:45.660 Emily Giant: Last night. So it will… it should tie.
264 00:43:46.660 ⇒ 00:43:53.359 Emily Giant: To yours more easily, without… pulling… The product type.
265 00:43:54.040 ⇒ 00:44:03.910 Demilade: Yeah, but isn’t the issue that the baseline model itself Like, the order itself recognizes this.
266 00:44:04.520 ⇒ 00:44:08.980 Emily Giant: I don’t know, I’m pulling it directly from the product table instead of the orders.
267 00:44:09.310 ⇒ 00:44:10.810 Emily Giant: So that it doesn’t.
268 00:44:12.970 ⇒ 00:44:18.390 Demilade: Yes, but it’s still gonna be this, though. Like, this is the SKU, or this is the product ID.
269 00:44:18.640 ⇒ 00:44:19.540 Demilade: Right?
270 00:44:21.380 ⇒ 00:44:23.610 Demilade: So this, this will be the issue.
271 00:44:26.120 ⇒ 00:44:28.759 Emily Giant: Oh, like, if it’s a single SKU subscription.
272 00:44:31.660 ⇒ 00:44:32.830 Emily Giant: Let’s see…
273 00:44:42.810 ⇒ 00:44:43.750 Demilade: Okay, Kristen.
274 00:44:49.590 ⇒ 00:44:50.430 Emily Giant: Huh.
275 00:44:55.550 ⇒ 00:44:58.020 Demilade: That’s… Quite interesting.
276 00:45:03.330 ⇒ 00:45:05.389 Demilade: Oh, I think it’s stripped.
277 00:45:08.400 ⇒ 00:45:09.780 Demilade: It’s Dish Trips.
278 00:45:09.910 ⇒ 00:45:10.840 Emily Giant: Yep.
279 00:45:11.390 ⇒ 00:45:12.170 Demilade: Okay.
280 00:45:12.350 ⇒ 00:45:13.659 Emily Giant: That’ll do it.
281 00:45:16.440 ⇒ 00:45:17.110 Demilade: Okay.
282 00:46:19.330 ⇒ 00:46:21.180 Demilade: Okay, so…
283 00:46:24.450 ⇒ 00:46:27.639 Demilade: So the issue is we have this as a product name.
284 00:46:28.060 ⇒ 00:46:31.310 Demilade: And that’s what’s coming through in Shopify.
285 00:46:31.590 ⇒ 00:46:37.530 Demilade: So, it wouldn’t see this as a floral product, and it wouldn’t then assign
286 00:46:38.510 ⇒ 00:46:42.320 Demilade: The floral, like, the cost to it.
287 00:46:42.450 ⇒ 00:46:44.800 Demilade: That’s what I’m trying to sort.
288 00:46:45.400 ⇒ 00:46:47.800 Demilade: So I’m basically trying to figure out every…
289 00:46:48.800 ⇒ 00:46:49.810 Emily Giant: Okay.
290 00:46:50.780 ⇒ 00:46:53.649 Demilade: Every single case where we have, like, subscriptions.
291 00:46:53.940 ⇒ 00:46:56.889 Demilade: But with potentially, like, a floral skew.
292 00:46:58.360 ⇒ 00:46:59.250 Demilade: Where?
293 00:47:00.600 ⇒ 00:47:03.160 Demilade: That is all with the price.
294 00:47:11.610 ⇒ 00:47:14.880 Emily Giant: Alright, what is the upstream model?
295 00:47:15.070 ⇒ 00:47:19.570 Emily Giant: that pulls… the order lines.
296 00:47:21.100 ⇒ 00:47:23.170 Emily Giant: Like, just the order lines.
297 00:47:23.710 ⇒ 00:47:25.160 Emily Giant: Or the line items.
298 00:47:36.480 ⇒ 00:47:37.980 Demilade: I’m sorry, I’m just using my…
299 00:47:37.980 ⇒ 00:47:38.730 Emily Giant: They’re good.
300 00:48:02.680 ⇒ 00:48:04.050 Demilade: Alright, so…
301 00:48:08.790 ⇒ 00:48:17.329 Demilade: Alright, so we have… This coming from the financials. Financials are coming from…
302 00:48:22.860 ⇒ 00:48:27.839 Demilade: So because of my… because of my dbt extensions, I can click into option models.
303 00:48:28.210 ⇒ 00:48:29.820 Emily Giant: That’s…
304 00:48:30.270 ⇒ 00:48:31.850 Demilade: Like, for instance…
305 00:48:31.970 ⇒ 00:48:33.580 Emily Giant: I’m digging that.
306 00:48:33.800 ⇒ 00:48:37.260 Demilade: If I want to look at the base, I just click on the inside of the base model.
307 00:48:37.410 ⇒ 00:48:40.139 Emily Giant: Oh, wow. That’s pretty awesome.
308 00:48:40.760 ⇒ 00:48:41.470 Demilade: Yep.
309 00:48:48.800 ⇒ 00:48:58.510 Demilade: It’s the base model, where we have the Shopify order lines, as well as Shopify order, and they’re split by that.
310 00:49:00.380 ⇒ 00:49:04.649 Emily Giant: Okay, yeah, this looks like… Okay, product name, product SKU…
311 00:49:05.430 ⇒ 00:49:06.080 Demilade: Yeah.
312 00:49:06.750 ⇒ 00:49:12.410 Emily Giant: So, if I pull a subscription order, should I send you, like, a sample order?
313 00:49:13.560 ⇒ 00:49:17.500 Demilade: So, as we’re saying with some subscription orders, they do have
314 00:49:17.820 ⇒ 00:49:27.019 Demilade: the product idea as it should be, like, the flower. It’s just that there are some, which is kind of the problem that we noticed with that one.
315 00:49:27.290 ⇒ 00:49:28.210 Demilade: Where?
316 00:49:28.750 ⇒ 00:49:34.420 Emily Giant: Okay, I got you, I know what to do. So, can you send me…
317 00:49:34.690 ⇒ 00:49:47.320 Emily Giant: well, actually, you don’t have to send me anything. There is a staging model that pulls out, in subscriptions, in loop, where it identifies single SKU subscriptions.
318 00:49:47.510 ⇒ 00:49:50.860 Emily Giant: And I can pull the product SKU from there.
319 00:49:52.340 ⇒ 00:49:55.520 Emily Giant: Is that… are those the ones that are just…
320 00:49:55.930 ⇒ 00:50:02.109 Emily Giant: classified as subscription? Is it the single sub SKUs, or is it something else, like the mystery SKU?
321 00:50:02.270 ⇒ 00:50:05.899 Emily Giant: Like, what even is that product? See, that’s what it is.
322 00:50:07.100 ⇒ 00:50:09.649 Demilade: So that’s what we’re getting as the product SKU.
323 00:50:10.670 ⇒ 00:50:15.300 Emily Giant: Okay, so if you look up that Order and dash.
324 00:50:16.740 ⇒ 00:50:23.050 Emily Giant: Is there another SKU associated with it, or is it just still that… Skew on me.
325 00:50:23.620 ⇒ 00:50:24.439 Demilade: That’s true.
326 00:50:29.460 ⇒ 00:50:37.260 Emily Giant: What I’m getting at is if they get the mystery SKU, we can just override it as floral, because it literally is the SKU that… that they’re getting.
327 00:50:37.800 ⇒ 00:50:45.279 Emily Giant: And it isn’t a bouquet that we have. It’s just something that’s, like, the trash flowers that they throw together to get rid of.
328 00:50:45.390 ⇒ 00:50:47.360 Emily Giant: for… Yeah.
329 00:50:49.620 ⇒ 00:50:58.370 Demilade: Yeah, so it’s still… I mean, it’s the seasonals of, Troy Spring, is that… Is that a flower?
330 00:50:59.810 ⇒ 00:51:06.859 Emily Giant: It is not a specific bouquet, it is only for subscriptions, so I think, with this case.
331 00:51:06.980 ⇒ 00:51:14.310 Emily Giant: we just need to override that SKU, because it doesn’t change. It’s just that SKU is the mystery SKU.
332 00:51:14.900 ⇒ 00:51:16.800 Emily Giant: Just override it as floral.
333 00:51:19.040 ⇒ 00:51:22.930 Demilade: Okay, but are there any other cases? That’s… that’s… that would be my issue now.
334 00:51:23.110 ⇒ 00:51:25.589 Emily Giant: In your query.
335 00:51:25.750 ⇒ 00:51:31.200 Emily Giant: Can I see what the description is? Because I think it will say Mystery SKU in the description.
336 00:51:32.520 ⇒ 00:51:34.279 Demilade: Like… What description?
337 00:51:34.880 ⇒ 00:51:43.579 Emily Giant: In the table, there’s a column called Description, and anytime it’s a mystery SKU, it’ll say it. I just have to figure out where it says it.
338 00:51:46.660 ⇒ 00:51:48.619 Demilade: In my table, conscious.
339 00:51:49.180 ⇒ 00:51:52.040 Emily Giant: in the product table that you ran that SKU.
340 00:51:52.040 ⇒ 00:51:53.080 Demilade: Oh, you betcha.
341 00:51:53.230 ⇒ 00:51:53.870 Emily Giant: Yeah.
342 00:51:55.460 ⇒ 00:51:58.649 Demilade: description, let’s celebrate the beauty of seasons.
343 00:51:58.650 ⇒ 00:51:59.900 Emily Giant: Click slug.
344 00:52:04.510 ⇒ 00:52:11.799 Emily Giant: It’s gonna say Mystery, yep. So I think it’s gonna be Seasonal, Luxe, and Classic Mystery, because you’ve got the different tiers.
345 00:52:12.360 ⇒ 00:52:19.020 Demilade: And these are probably different SKUs for different tiers, but I do believe when the slug has Mystery in it.
346 00:52:19.670 ⇒ 00:52:22.100 Emily Giant: it’s going to be one of those random SKUs.
347 00:52:23.240 ⇒ 00:52:31.440 Emily Giant: And you can even query, like, select everything where slug is, like, mystery, and see if there’s more than just those three.
348 00:52:33.870 ⇒ 00:52:37.430 Emily Giant: Because I doubt it. That would be a lot of work.
349 00:52:57.590 ⇒ 00:52:59.880 Demilade: Okay, so there appeared to be 3.
350 00:53:00.600 ⇒ 00:53:05.740 Emily Giant: Yep, perfect, okay. So, yep, one for classic, one for seasonal, one for luxe.
351 00:53:05.950 ⇒ 00:53:09.570 Emily Giant: So, those 3 SKUs, you’ll need to…
352 00:53:09.800 ⇒ 00:53:12.400 Emily Giant: like, do CaseWEN, or something like that.
353 00:53:12.530 ⇒ 00:53:15.840 Emily Giant: To indicate that it’s… the floral.
354 00:53:16.570 ⇒ 00:53:23.440 Demilade: Gotcha. Alright, so I’ll do that fix, and that will propagate to… Dark propagate to…
355 00:53:26.570 ⇒ 00:53:27.650 Demilade: Alright.
356 00:53:27.650 ⇒ 00:53:32.730 Emily Giant: Yeah, yeah. That was not as painful as I thought it might become.
357 00:53:34.080 ⇒ 00:53:42.689 Demilade: Let’s not provoke the gods of DBT. Yes, you’re right, you’re right. I take it back. I’m sure it’s gonna get terrible.
358 00:53:55.060 ⇒ 00:54:03.969 Emily Giant: Okay, that’s why my shit’s not working, is that I wasn’t using the stripped variant and stripped product ID, so it wasn’t joining to anything.
359 00:54:04.740 ⇒ 00:54:05.300 Demilade: Yeah.
360 00:54:05.300 ⇒ 00:54:08.440 Emily Giant: In what I added. Because I was like, I added it.
361 00:54:08.960 ⇒ 00:54:14.619 Emily Giant: It was pretty turnkey, but then it just wasn’t working, but that is why. I forgot that we did that.
362 00:54:19.900 ⇒ 00:54:20.940 Demilade: Okay…
363 00:54:24.790 ⇒ 00:54:29.830 Demilade: You swan… Products…
364 00:54:33.420 ⇒ 00:54:34.729 Demilade: That’s slow.
365 00:54:39.060 ⇒ 00:54:40.270 Demilade: There’s 3…
366 00:54:50.090 ⇒ 00:54:51.490 Demilade: Plural.
367 00:55:23.400 ⇒ 00:55:24.889 Demilade: Okay, I think.
368 00:55:25.050 ⇒ 00:55:25.680 Emily Giant: Yeah.
369 00:55:27.440 ⇒ 00:55:28.500 Emily Giant: Alright, cool.
370 00:55:28.890 ⇒ 00:55:31.340 Emily Giant: Alright, well, I’ll keep working on the,
371 00:55:32.420 ⇒ 00:55:38.629 Emily Giant: the line item tags, I’m gonna need to rebuild those staging models for components and line items.
372 00:55:38.880 ⇒ 00:55:42.139 Emily Giant: To do that, which is part of the work for historical revenue.
373 00:55:42.330 ⇒ 00:55:50.639 Emily Giant: So I’ll make sure that you, like, audit those before I… Like, deploy it totally?
374 00:55:51.160 ⇒ 00:55:51.950 Demilade: Okay.
375 00:55:51.950 ⇒ 00:55:57.009 Emily Giant: But yeah, that will at least take away… take away some of the stuff off your plate.
376 00:55:57.200 ⇒ 00:56:00.860 Emily Giant: And then I’ll, add…
377 00:56:02.200 ⇒ 00:56:15.569 Emily Giant: I need to fix the product ID, variant ID in the subscriptions table also, so that it joins correctly, and then I can join it in Looker, because it needs that, so that it doesn’t splay out the, subscription price.
378 00:56:16.200 ⇒ 00:56:17.370 Emily Giant: to the home. Okay.
379 00:56:17.890 ⇒ 00:56:20.539 Demilade: Yeah, so yeah, that’s one.
380 00:56:21.550 ⇒ 00:56:25.159 Demilade: Yeah, oh, you could also just use the revenue in…
381 00:56:25.160 ⇒ 00:56:25.880 Emily Giant: Trailer.
382 00:56:26.020 ⇒ 00:56:29.680 Demilade: model I built, but either one works, to be honest.
383 00:56:29.680 ⇒ 00:56:36.470 Emily Giant: Okay, I’m just thinking, like, if somebody wants to add the subscription ID to the table, I don’t know what’s gonna happen.
384 00:56:37.770 ⇒ 00:56:49.359 Emily Giant: maybe… maybe it’s best to just not have those options available in the revenue model, but let me give it one last shot and see if I can’t get them working one-to-one.
385 00:56:50.060 ⇒ 00:56:52.420 Demilade: So that’s fair, that’s fair. Alright.
386 00:56:52.610 ⇒ 00:56:55.249 Demilade: We’ll make the push for this fix now.
387 00:56:55.710 ⇒ 00:56:56.730 Emily Giant: Perfect.
388 00:56:57.310 ⇒ 00:57:00.650 Demilade: perform… So one is, like, Mysteries of Floral.
389 00:57:01.170 ⇒ 00:57:04.949 Demilade: And then, for all becomes 1, point becomes 2, I don’t need it.
390 00:57:07.670 ⇒ 00:57:08.370 Demilade: Sure.
391 00:57:10.930 ⇒ 00:57:11.780 Demilade: Alright.
392 00:57:12.200 ⇒ 00:57:14.959 Emily Giant: Alright, sweet! Alright, I will talk to you in a little bit, then.
393 00:57:15.340 ⇒ 00:57:18.030 Demilade: Alright then, take care.
394 00:57:18.030 ⇒ 00:57:19.420 Emily Giant: Okay, bye.