Meeting Title: Shopify Suborder ID Sync Date: 2025-09-05 Meeting participants: Emily Giant, Demilade Agboola
WEBVTT
1 00:03:28.320 ⇒ 00:03:29.530 Demilade Agboola: Hi, Emily.
2 00:03:29.830 ⇒ 00:03:38.289 Emily Giant: Oh my gosh, sorry, I was so focused that I didn’t see you log on, and I jumped, like, 2 feet in the air when you said hi. Hi, how are you?
3 00:03:38.690 ⇒ 00:03:40.460 Demilade Agboola: I’m doing very well, how are you?
4 00:03:40.890 ⇒ 00:03:47.150 Emily Giant: I’m good, I’m better than this morning. I’ll turn the camera on so you can see my eyeballs for, like, 2 seconds. There’s still, like…
5 00:03:47.340 ⇒ 00:03:50.239 Emily Giant: They’re way better. They’re open now, but they’re still, like…
6 00:03:50.830 ⇒ 00:03:51.570 Demilade Agboola: Yep.
7 00:03:51.570 ⇒ 00:03:55.190 Emily Giant: And it’s just this time of year, it’s bad.
8 00:03:55.610 ⇒ 00:04:02.269 Demilade Agboola: Is it, like, Kay fever? I’m not sure what, like, any idea what it could be?
9 00:04:02.270 ⇒ 00:04:07.140 Emily Giant: I think it might be, like, literal hay fever. I live in the middle of a field, so…
10 00:04:07.460 ⇒ 00:04:14.089 Emily Giant: It’s something, but I also… we have that barn cat that has decided he’s now an indoor cat.
11 00:04:14.250 ⇒ 00:04:14.840 Emily Giant: And…
12 00:04:14.840 ⇒ 00:04:15.370 Demilade Agboola: -Oh.
13 00:04:15.430 ⇒ 00:04:19.080 Emily Giant: very allergic to him, and I woke up, and he was like.
14 00:04:19.910 ⇒ 00:04:27.819 Emily Giant: sleeping on my chest, and I was like, well, that’ll do it. My other cat, I’m not allergic to her, because she has, like.
15 00:04:28.010 ⇒ 00:04:29.810 Emily Giant: some pedigree that…
16 00:04:29.890 ⇒ 00:04:43.539 Emily Giant: people are not allergic to her. And, this other one has, like, every possible inbreeding and, like, allergen possible. And he’s cute, but he’s killing me.
17 00:04:43.540 ⇒ 00:04:51.079 Emily Giant: So, I think it was mostly the cat, so I just needed a, like, Claritin, Benadryl, and now I’m good to go.
18 00:04:52.820 ⇒ 00:04:54.399 Demilade Agboola: Yeah, that’s good to hear.
19 00:04:54.550 ⇒ 00:04:56.849 Emily Giant: Do you have wedding stuff this weekend?
20 00:04:57.370 ⇒ 00:05:09.179 Demilade Agboola: It’s actually next weekend, next week, Friday, that’s the wedding, but yeah, it’s just a couple of, running around for the wedding, trying to see venues for certain things.
21 00:05:09.440 ⇒ 00:05:16.060 Demilade Agboola: Trying to understand how things are gonna go, I met the…
22 00:05:16.260 ⇒ 00:05:19.520 Demilade Agboola: the bridal family, or, like, the bridal…
23 00:05:19.690 ⇒ 00:05:20.370 Emily Giant: Huh.
24 00:05:20.370 ⇒ 00:05:25.130 Demilade Agboola: part of the bridal family today. They came over because they heard I was around.
25 00:05:25.130 ⇒ 00:05:26.190 Emily Giant: Aww.
26 00:05:26.190 ⇒ 00:05:30.940 Demilade Agboola: Yeah, things like that. It’s just a bunch of, like, running around for that, but yeah.
27 00:05:31.290 ⇒ 00:05:35.309 Emily Giant: Alright, cool. Well, we’ll try to end early then, so that you can, like.
28 00:05:35.440 ⇒ 00:05:38.830 Emily Giant: get on with your evening, since it’s evening. Or is it, like…
29 00:05:39.350 ⇒ 00:05:42.579 Emily Giant: What’s the time zone difference now? It’s, like, 12 hours?
30 00:05:43.020 ⇒ 00:05:48.729 Demilade Agboola: Oh, no, it’s, it’s 1 hour less, it’s just, like, 6 hours, I believe, because it’s 5.06 now.
31 00:05:50.330 ⇒ 00:05:56.770 Emily Giant: That’s… So we… so in Malta, you’re actually further away, time zone-wise?
32 00:05:57.270 ⇒ 00:05:59.050 Demilade Agboola: Yes, yes, it is. It’s on.
33 00:05:59.650 ⇒ 00:06:09.489 Emily Giant: That I do not understand. I’m not a flat earther, but that blows my mind. Like, that you’re so far around the globe, that you’re coming back toward me, that is…
34 00:06:09.710 ⇒ 00:06:11.060 Emily Giant: Nuts.
35 00:06:11.210 ⇒ 00:06:18.710 Emily Giant: I don’t understand anything. Okay, so I wanted to meet today just to, like, make sure that you felt good about,
36 00:06:18.860 ⇒ 00:06:32.770 Emily Giant: the suborder ID thing for the Shopify table, so I thought we would just, like, quick sync. I thought I’d get more done yesterday, but I’ve been having a fistfight with cursor. I like it, and yet, if you don’t…
37 00:06:32.860 ⇒ 00:06:46.919 Emily Giant: audit, like, every single thing it does, it will mess… it will ruin everything. So, I, like, had to make several changes yesterday, and I reverted all of them this morning. I was like, no cursor. I need to learn more about our friendship.
38 00:06:46.920 ⇒ 00:06:52.999 Emily Giant: Before you’re actually, like, making changes to my files. But, let me…
39 00:06:53.500 ⇒ 00:06:55.679 Emily Giant: What are your thoughts on Cursor?
40 00:06:57.040 ⇒ 00:07:00.819 Demilade Agboola: I think it requires the necessary context.
41 00:07:01.350 ⇒ 00:07:07.459 Demilade Agboola: So if you said… if you just tell it, like, very high-level stuff, sometimes it will just start doing things, like, you don’t want it to be…
42 00:07:07.720 ⇒ 00:07:08.390 Emily Giant: Yeah.
43 00:07:09.250 ⇒ 00:07:10.920 Emily Giant: That’s pretty much been…
44 00:07:11.100 ⇒ 00:07:21.679 Emily Giant: my learning curve. It’s like, oh, wow, I really needed to be way more specific with that. But anyway, okay, so I guess there are two things I wanted to chat through. One is, like.
45 00:07:22.430 ⇒ 00:07:26.030 Emily Giant: The fulfillment
46 00:07:26.860 ⇒ 00:07:32.299 Emily Giant: schema thing. Let me commit all this, and then I’ll change back to the branch with the…
47 00:07:34.930 ⇒ 00:07:36.620 Emily Giant: 40? That’s a lot of…
48 00:07:37.600 ⇒ 00:07:48.040 Emily Giant: Anyway, I’ll use dbt for now, just because I don’t want you to have to, like, suffer through me using cursor when I’m not good at it yet.
49 00:07:48.730 ⇒ 00:07:56.330 Emily Giant: But… Oh… Here we go.
50 00:07:57.760 ⇒ 00:07:58.680 Emily Giant: Okay.
51 00:07:58.860 ⇒ 00:08:08.220 Emily Giant: So… I don’t know if this has been added… if this has been, deployed yet, but…
52 00:08:09.040 ⇒ 00:08:15.340 Emily Giant: essentially, in the Shopify staging, I need to add the stuff from Raw. Where is it?
53 00:08:18.120 ⇒ 00:08:21.730 Emily Giant: So, order lines, orders, and,
54 00:08:22.090 ⇒ 00:08:30.370 Emily Giant: there’s one other one, fulfillments. These are all what you’re gonna need for, like, the fulfillment…
55 00:08:30.560 ⇒ 00:08:50.250 Emily Giant: it’s… the fulfillment ID is essentially the suborder ID in Dash, and I talked to Alex, and he did some tests to see if there’s any good way to ingest suborder ID in Shopify, and there’s just… not. Like, we tried to do it as cleanly as possible, and he was like, I think you need to stick to the…
56 00:08:50.260 ⇒ 00:08:57.960 Emily Giant: route of, like, use Hibo as minimally as you can, but you’re gonna need to use it to pull suborder ID.
57 00:08:58.190 ⇒ 00:09:05.099 Emily Giant: So how that is done… Let me pull up these three models that I added.
58 00:09:09.530 ⇒ 00:09:14.530 Emily Giant: So, this is the one, the just fulfillment order lines. It looks like,
59 00:09:14.970 ⇒ 00:09:20.229 Emily Giant: all of the IDs to make sense of these other two models,
60 00:09:21.760 ⇒ 00:09:24.380 Demilade Agboola: But put my order lines are only for fulfilled orders, right?
61 00:09:25.580 ⇒ 00:09:29.800 Emily Giant: No, not necessarily. It’s like, what’s scary?
62 00:09:30.380 ⇒ 00:09:38.999 Emily Giant: scheduled for fulfillment. I think they can still be canceled, but that’s a good question. I said no, but now I’m like, maybe? So…
63 00:09:39.410 ⇒ 00:09:40.540 Emily Giant: in…
64 00:09:43.380 ⇒ 00:09:50.920 Emily Giant: OMS suborders, which I think you have a new version of it now, like, staging OMS suborders, maybe?
65 00:09:51.920 ⇒ 00:09:52.720 Emily Giant: Yeah.
66 00:09:53.220 ⇒ 00:09:55.199 Emily Giant: So there’s a Shopify ID.
67 00:09:55.640 ⇒ 00:09:58.409 Emily Giant: And that is what is gonna connect…
68 00:09:58.580 ⇒ 00:10:05.119 Emily Giant: to the fulfillment ID, so if I did, select everything from…
69 00:10:06.760 ⇒ 00:10:09.119 Emily Giant: Where… well, let me see first.
70 00:10:10.680 ⇒ 00:10:14.640 Emily Giant: Near… My ID?
71 00:10:15.640 ⇒ 00:10:17.710 Emily Giant: is not null.
72 00:10:17.900 ⇒ 00:10:19.170 Emily Giant: Limit 10.
73 00:10:22.460 ⇒ 00:10:23.230 Demilade Agboola: I have doubled.
74 00:10:23.380 ⇒ 00:10:24.350 Demilade Agboola: That off.
75 00:10:30.080 ⇒ 00:10:35.990 Emily Giant: And while that’s happening, I’m gonna open Shopify so we can, like, look at an order, and then…
76 00:10:36.760 ⇒ 00:10:41.059 Emily Giant: go back and forth between these to match up the IDs.
77 00:10:44.580 ⇒ 00:11:03.550 Emily Giant: So, like, high level, the plan is we have to use HEVO to pull the suborder ID so that we’re not completely screwing up the way stakeholders think about orders, but we want to still use as much from Shopify, because suborder ID is a dash, or our OMS system.
78 00:11:03.560 ⇒ 00:11:21.140 Emily Giant: it’s a unique ID created by Dash, which is only accessible through Hibo, but we do plan to get rid of Dash someday. We do not plan to get rid of Shopify, so we’re still, like, setting ourselves up for a system in which we can replace that ID in the future. Does that make sense?
79 00:11:30.170 ⇒ 00:11:34.730 Emily Giant: You’re on mute, but… or no, you’re not on mute, I just… didn’t…
80 00:11:34.840 ⇒ 00:11:36.890 Emily Giant: Don’t know if you… am I on mute?
81 00:11:37.700 ⇒ 00:11:39.040 Demilade Agboola: No, no, I’m here.
82 00:11:41.690 ⇒ 00:11:44.099 Emily Giant: Alright, Shopify ID.
83 00:11:44.650 ⇒ 00:11:50.599 Demilade Agboola: So, my question is, are there any orders that were never planned to be fulfilled that do not appear here then?
84 00:11:51.740 ⇒ 00:11:54.460 Emily Giant: I don’t know. We’re gonna have to do a little…
85 00:11:54.780 ⇒ 00:12:04.240 Emily Giant: test for that, so let me limit this, these results, because there’s too many. Order ID.
86 00:12:07.370 ⇒ 00:12:08.920 Emily Giant: Suborder ID.
87 00:12:10.520 ⇒ 00:12:15.029 Emily Giant: line item. I don’t know if there is a line item, might be Shopify…
88 00:12:21.170 ⇒ 00:12:21.575 Demilade Agboola: Goodbye.
89 00:12:30.220 ⇒ 00:12:31.040 Emily Giant: Okay.
90 00:12:31.680 ⇒ 00:12:42.520 Emily Giant: So, fulfillment order, which makes me think that this is gonna come from the fulfillment order table, because usually Shopify will say, like, the table right here.
91 00:12:43.300 ⇒ 00:12:51.310 Emily Giant: So let me do select everything from… raw Shopify.
92 00:12:52.930 ⇒ 00:12:54.680 Emily Giant: Fillment order, yeah.
93 00:12:55.920 ⇒ 00:13:00.320 Emily Giant: Okay, and it’s gonna be the fulfillment order ID, I’m guessing, but…
94 00:13:01.200 ⇒ 00:13:03.420 Emily Giant: Oh, shoot, that’s the M file.
95 00:13:19.920 ⇒ 00:13:23.520 Emily Giant: Alright, let’s just prove that out.
96 00:14:04.940 ⇒ 00:14:05.820 Emily Giant: No.
97 00:14:14.400 ⇒ 00:14:15.070 Emily Giant: Huh.
98 00:14:18.080 ⇒ 00:14:20.200 Emily Giant: Let me look at… see what these…
99 00:14:21.260 ⇒ 00:14:26.690 Emily Giant: look like. Maybe it isn’t the fulfillment order ID, but I thought for sure it was, because I’ve already done this.
100 00:14:30.500 ⇒ 00:14:31.400 Emily Giant: Okay.
101 00:14:32.250 ⇒ 00:14:35.069 Emily Giant: Yeah, like, that’s the number that looks…
102 00:14:35.630 ⇒ 00:14:45.230 Emily Giant: So this looks like an order number in Shopify, the shop ID. This looks like when I’m pulling from suborders. I don’t know why this particular one didn’t come up.
103 00:14:45.470 ⇒ 00:14:46.149 Demilade Agboola: Thank you.
104 00:14:46.150 ⇒ 00:14:48.310 Emily Giant: Let’s try to reverse engineer this.
105 00:14:48.660 ⇒ 00:14:51.720 Emily Giant: And say, from… suborders.
106 00:14:52.760 ⇒ 00:14:56.470 Demilade Agboola: That’s how we dropped off his response, but we do want to get some time.
107 00:14:56.470 ⇒ 00:14:57.699 Emily Giant: Okay, hold on.
108 00:14:59.530 ⇒ 00:15:02.410 Demilade Agboola: Your law, as in Charles.
109 00:15:16.530 ⇒ 00:15:20.030 Demilade Agboola: But we do our best jobs in business.
110 00:15:28.730 ⇒ 00:15:29.510 Demilade Agboola: Verify.
111 00:15:30.340 ⇒ 00:15:33.829 Demilade Agboola: Can I quickly go and make a cup of coffee?
112 00:15:34.020 ⇒ 00:15:35.279 Emily Giant: Oh my gosh, of course.
113 00:15:35.470 ⇒ 00:15:36.310 Demilade Agboola: Okay.
114 00:15:36.310 ⇒ 00:15:39.869 Emily Giant: Okay. Yeah, I’ll see you when you’re… take your time.
115 00:19:16.620 ⇒ 00:19:19.970 Demilade Agboola: I’m back. Unfortunately, I wasn’t able to get coffee, but…
116 00:19:20.200 ⇒ 00:19:22.210 Emily Giant: You did not get coffee? What happened?
117 00:19:22.650 ⇒ 00:19:25.430 Demilade Agboola: My host doesn’t have any coffee, so…
118 00:19:25.430 ⇒ 00:19:27.290 Emily Giant: Oh, no!
119 00:19:27.880 ⇒ 00:19:31.499 Emily Giant: Well, you’re gonna have to write a scathing review on that.
120 00:19:31.920 ⇒ 00:19:35.080 Demilade Agboola: It’s a tough one out here, but, you know, we’ll be fine.
121 00:19:35.160 ⇒ 00:19:39.259 Emily Giant: I don’t know. I don’t know if you will, honestly.
122 00:19:39.260 ⇒ 00:19:39.720 Demilade Agboola: Right.
123 00:19:41.200 ⇒ 00:19:48.170 Emily Giant: Alright, I’m running this, the line items, because I, okay, definitely fulfillment ID.
124 00:19:48.450 ⇒ 00:19:57.740 Emily Giant: is Shopify ID here, or fulfillment order ID. What I need to find is line item ID, because this is going to be, like, the next thing down the line. And then, after we’ve…
125 00:19:58.330 ⇒ 00:20:08.599 Emily Giant: identified those. We’ll see if deleted line items go into the fulfillment table. I would bet a lot of money that they do, and just show a zero.
126 00:20:08.920 ⇒ 00:20:12.369 Emily Giant: But let’s make sure that we know for sure.
127 00:20:12.710 ⇒ 00:20:13.490 Emily Giant: Alright.
128 00:20:13.690 ⇒ 00:20:20.240 Emily Giant: The reason I ran this is because, for some reason, when the tables update in…
129 00:20:20.390 ⇒ 00:20:32.029 Emily Giant: Redshift, they don’t add all of the actual fields here. So I know that Shopify ID exists in one of these, but it doesn’t list it here, in the…
130 00:20:33.430 ⇒ 00:20:35.010 Emily Giant: like, the index.
131 00:20:35.510 ⇒ 00:20:36.060 Demilade Agboola: So…
132 00:20:36.060 ⇒ 00:20:40.100 Emily Giant: not be this one, but there’s definitely, like, a Shopify…
133 00:20:42.210 ⇒ 00:20:48.790 Emily Giant: Thing that gets carried over in one of these line item tables, and it might just be…
134 00:20:48.890 ⇒ 00:20:51.240 Emily Giant: The split line items.
135 00:20:52.680 ⇒ 00:20:57.590 Emily Giant: But I wouldn’t think so, because I thought the split line items was something else.
136 00:20:58.440 ⇒ 00:20:59.260 Emily Giant: Mmm.
137 00:21:06.410 ⇒ 00:21:09.180 Demilade Agboola: But this will analyze could have the shop… the…
138 00:21:09.370 ⇒ 00:21:14.239 Demilade Agboola: the suborder ID that it’s tied back to. That’s the suborder ID we’re looking for, right?
139 00:21:14.460 ⇒ 00:21:27.799 Emily Giant: We already found that, and that’s in… so I’m adding this note here, so that when you go into the raw file, you can see, like, the fulfillment order ID is tied to staging OMS suborders.
140 00:21:28.800 ⇒ 00:21:33.010 Emily Giant: It’s just one of those, like, split-part things.
141 00:21:33.370 ⇒ 00:21:48.769 Emily Giant: So, that exists, but you’re gonna need the line item ID in the event that, like, there’s a forced upgrade, or something like that, because that’s really where all of the problems in Hivo start. It’s when you can’t get to the…
142 00:21:49.270 ⇒ 00:21:52.549 Emily Giant: The line item within the suborder that’s been changed.
143 00:21:53.440 ⇒ 00:21:55.339 Demilade Agboola: Oh, okay, gotcha, gotcha.
144 00:21:55.340 ⇒ 00:21:58.220 Emily Giant: Yeah, so I know somewhere…
145 00:21:58.860 ⇒ 00:22:06.510 Emily Giant: Okay, this one’s line items. We checked this, and the Shopify ID does not exist there.
146 00:22:07.060 ⇒ 00:22:11.230 Emily Giant: So it’s gotta be… the sale…
147 00:22:12.590 ⇒ 00:22:21.230 Emily Giant: sale line items. Or we can check in dbt, because I know you and I have both done iterations of those,
148 00:22:21.530 ⇒ 00:22:22.640 Emily Giant: tables.
149 00:22:23.020 ⇒ 00:22:25.950 Emily Giant: Because there’s components, split components.
150 00:22:26.140 ⇒ 00:22:37.670 Emily Giant: Split line items, regular line items. All three of those have the potential of drawing back to a Shopify ID, I just don’t know which one it actually is that has the Shopify ID in it.
151 00:22:38.540 ⇒ 00:22:43.140 Emily Giant: Sohivo prod… Sail line.
152 00:22:43.830 ⇒ 00:22:45.940 Emily Giant: Okay, this is the other one that we use.
153 00:22:51.440 ⇒ 00:22:59.400 Emily Giant: Got a Shopify ID, there it is, okay. So I just want to make sure it actually is… Helpful…
154 00:23:01.680 ⇒ 00:23:04.949 Emily Giant: So this is called…
155 00:23:08.740 ⇒ 00:23:09.540 Emily Giant: Here.
156 00:23:10.250 ⇒ 00:23:14.010 Emily Giant: And… Hiva Ref ID.
157 00:23:15.300 ⇒ 00:23:16.270 Emily Giant: like…
158 00:23:51.740 ⇒ 00:24:01.729 Emily Giant: So it’s one of… one of these two, and this is an old order, but it should have a Shopify ID that matches one of the IDs. Okay, so line item.
159 00:24:09.220 ⇒ 00:24:11.359 Emily Giant: Now I just need to go back to…
160 00:24:13.490 ⇒ 00:24:16.910 Emily Giant: the other query that we pulled from Shopify.
161 00:24:17.090 ⇒ 00:24:21.290 Emily Giant: To see, what matches on that line item number.
162 00:24:26.060 ⇒ 00:24:27.709 Emily Giant: Let me copy!
163 00:24:28.960 ⇒ 00:24:30.160 Emily Giant: I… I can’t.
164 00:24:34.120 ⇒ 00:24:34.999 Emily Giant: There we go.
165 00:24:42.700 ⇒ 00:24:46.540 Emily Giant: So… if I run this again for…
166 00:24:53.520 ⇒ 00:24:55.829 Emily Giant: That’s the one we’re testing on, yeah, okay.
167 00:24:59.760 ⇒ 00:25:07.660 Emily Giant: I mean… We just ran that, and it worked. So I’m not sure why it’s doing that.
168 00:25:27.300 ⇒ 00:25:33.729 Emily Giant: So we’re looking for this 146567 situation.
169 00:25:35.830 ⇒ 00:25:37.290 Emily Giant: Okay, ID.
170 00:25:38.460 ⇒ 00:25:39.360 Emily Giant: Nope.
171 00:25:45.140 ⇒ 00:25:46.640 Emily Giant: I don’t see it.
172 00:25:47.480 ⇒ 00:25:48.140 Emily Giant: One…
173 00:25:51.000 ⇒ 00:25:54.080 Emily Giant: I would think that it would match up with the line item ID.
174 00:25:56.400 ⇒ 00:25:57.020 Demilade Agboola: Dang.
175 00:25:59.410 ⇒ 00:26:01.700 Demilade Agboola: Yeah, but it doesn’t seem to.
176 00:26:01.700 ⇒ 00:26:02.400 Emily Giant: Nope.
177 00:26:03.040 ⇒ 00:26:09.809 Emily Giant: What, wait, 147. It’s this one. 147657. Okay, so it’s the line item ID.
178 00:26:12.810 ⇒ 00:26:18.060 Emily Giant: So that will be… so you get your suborder from the fulfillment ID, and then these are the separate line items.
179 00:26:18.220 ⇒ 00:26:23.870 Emily Giant: Which are gonna come from… this OMS, HEVO OMS production line items.
180 00:26:24.540 ⇒ 00:26:26.200 Emily Giant: So…
181 00:26:36.250 ⇒ 00:26:37.170 Emily Giant: Okay.
182 00:26:37.940 ⇒ 00:26:43.070 Emily Giant: I don’t think you need inventory item ID. I think that’s just, like, a product ID.
183 00:26:43.210 ⇒ 00:26:45.009 Emily Giant: And then quantity.
184 00:26:46.350 ⇒ 00:26:53.590 Emily Giant: So, shop ID is… I believe it’s the Shopify.
185 00:26:54.080 ⇒ 00:26:56.729 Emily Giant: Yeah, so this is the Shopify order number.
186 00:27:10.570 ⇒ 00:27:19.559 Emily Giant: Okay, so Shopify order ID, fulfillment order ID, line item ID, inventory item ID, I don’t know.
187 00:27:20.240 ⇒ 00:27:21.770 Emily Giant: I don’t know if it matters.
188 00:27:22.350 ⇒ 00:27:25.240 Emily Giant: I think it’s honestly just, like, a product ID.
189 00:27:26.420 ⇒ 00:27:28.400 Demilade Agboola: Yeah, that’s more of a product I do, but…
190 00:27:28.790 ⇒ 00:27:29.680 Emily Giant: Okay.
191 00:27:29.950 ⇒ 00:27:32.369 Emily Giant: So we’ve got that all sorted.
192 00:27:32.790 ⇒ 00:27:38.510 Emily Giant: about, like, how to connect this over to Hivo. These notes make sense that I added?
193 00:27:41.320 ⇒ 00:27:47.790 Demilade Agboola: I think the only question I have is, do we still… are there anything still,
194 00:27:48.320 ⇒ 00:27:52.640 Demilade Agboola: Are there any orders that cannot be fulf… like, that cannot be found? Yeah.
195 00:27:52.850 ⇒ 00:27:58.409 Emily Giant: Alright, let’s find… So I think we should look at forced upgrades and then canceled orders.
196 00:27:59.000 ⇒ 00:28:07.559 Emily Giant: So… I have a bunch of old examples, but… let me think.
197 00:28:08.610 ⇒ 00:28:14.689 Emily Giant: I’m trying to think of the best way to pull an order with a forced upgrade, I think I have an idea.
198 00:28:19.240 ⇒ 00:28:22.220 Emily Giant: Select everything from…
199 00:29:00.020 ⇒ 00:29:00.730 Emily Giant: It’s cool.
200 00:29:04.570 ⇒ 00:29:05.570 Emily Giant: And…
201 00:29:39.300 ⇒ 00:29:42.320 Emily Giant: Okay, let’s grab an order number…
202 00:30:00.760 ⇒ 00:30:01.720 Emily Giant: Okay.
203 00:30:02.070 ⇒ 00:30:05.669 Emily Giant: So, the cotton candy was removed and replaced with the Margo.
204 00:30:06.640 ⇒ 00:30:12.179 Emily Giant: And it looks like they were all $0, because this is a re-delivery, so this order must have been all kinds of effed.
205 00:30:12.340 ⇒ 00:30:17.280 Emily Giant: So now we want to see what this looks like in Shopify.
206 00:30:18.900 ⇒ 00:30:20.360 Emily Giant: Or in our new…
207 00:30:23.630 ⇒ 00:30:26.009 Emily Giant: Okay, so we’re order ID…
208 00:30:26.810 ⇒ 00:30:30.480 Emily Giant: So what I would need to do is… this is the Shopify idea up here.
209 00:30:35.450 ⇒ 00:30:40.710 Emily Giant: So, I will stay where… Shop ID.
210 00:31:03.330 ⇒ 00:31:12.420 Emily Giant: Now, okay, this doesn’t… Totally track, because… Mmm.
211 00:31:13.850 ⇒ 00:31:16.989 Emily Giant: I don’t… does this only populate, like, when it’s been fulfilled?
212 00:31:17.570 ⇒ 00:31:20.739 Emily Giant: No, this has definitely been fulfilled. This is from August 16th.
213 00:31:21.120 ⇒ 00:31:23.270 Emily Giant: Or the order was August 16th.
214 00:31:30.050 ⇒ 00:31:36.119 Demilade Agboola: Yeah, that’s what I was curious about, like, if it’s only fulfilled orders, like, that takes us quite some distance, but…
215 00:31:38.220 ⇒ 00:31:40.240 Demilade Agboola: a gap.
216 00:31:41.370 ⇒ 00:31:44.639 Emily Giant: It should… that is so odd.
217 00:31:52.400 ⇒ 00:31:59.010 Emily Giant: I’m like… Not convinced that this is… refreshing. Because…
218 00:32:02.190 ⇒ 00:32:07.470 Emily Giant: we’re not using this table yet, and now I’m concerned that, like, it’s not refreshing, and that’s why we don’t have the data.
219 00:32:09.570 ⇒ 00:32:11.190 Demilade Agboola: I could look into that.
220 00:32:11.190 ⇒ 00:32:12.060 Emily Giant: Okay.
221 00:32:14.730 ⇒ 00:32:19.270 Emily Giant: So now we just need a canceled order. Well, let’s see if it’s in the…
222 00:32:20.050 ⇒ 00:32:22.579 Emily Giant: The other table, select everything from…
223 00:32:27.900 ⇒ 00:32:31.220 Emily Giant: What’s that back table called? Order lines?
224 00:32:32.160 ⇒ 00:32:33.719 Demilade Agboola: Yeah, fuck other lens.
225 00:33:06.860 ⇒ 00:33:08.879 Emily Giant: I’m trying to figure out what this would be called.
226 00:33:13.900 ⇒ 00:33:15.110 Emily Giant: Photo number.
227 00:33:36.830 ⇒ 00:33:38.750 Emily Giant: Okay. Yep, yep.
228 00:33:39.160 ⇒ 00:33:43.180 Emily Giant: Unless one of these is shipping, I don’t know if one of these lines is gonna wind up being shipping.
229 00:33:53.740 ⇒ 00:34:04.140 Emily Giant: Okay, so… Shopify ID, order line ID, I don’t know what that is. Product… Variant…
230 00:34:10.179 ⇒ 00:34:16.809 Emily Giant: because I don’t know these off the bat, like, these product codes, I don’t know if one is actually the shipping cost?
231 00:34:16.980 ⇒ 00:34:22.389 Emily Giant: Or if it’s… Let me see what the cotton candy idea is.
232 00:34:25.870 ⇒ 00:34:28.039 Demilade Agboola: Yeah, it is in the URL. It’s the first…
233 00:34:28.650 ⇒ 00:34:29.280 Emily Giant: Yep.
234 00:34:29.580 ⇒ 00:34:31.709 Emily Giant: That’s this one, and then…
235 00:34:37.650 ⇒ 00:34:39.449 Emily Giant: Margo is…
236 00:34:39.940 ⇒ 00:34:41.060 Demilade Agboola: Looks like online.
237 00:34:41.060 ⇒ 00:34:45.740 Emily Giant: Yep, okay, so it’s pulling both of these in, quantity 1,
238 00:34:45.850 ⇒ 00:34:53.639 Emily Giant: But there should be some indication that one of them was, like, removed from the order, or that it…
239 00:34:54.179 ⇒ 00:34:56.609 Emily Giant: It was not actually fulfilled.
240 00:34:57.410 ⇒ 00:34:59.949 Demilade Agboola: And now, it’s on a table.
241 00:35:00.430 ⇒ 00:35:02.729 Emily Giant: What the fuck is this ID?
242 00:35:06.360 ⇒ 00:35:10.830 Demilade Agboola: Well, I think that there is, because I believe I built out this table, give me a second.
243 00:35:10.830 ⇒ 00:35:11.470 Emily Giant: Okay.
244 00:36:03.340 ⇒ 00:36:05.610 Demilade Agboola: Okay, there should be a fulfillment status.
245 00:36:07.200 ⇒ 00:36:08.979 Demilade Agboola: Column towards the end of it.
246 00:36:19.480 ⇒ 00:36:21.430 Emily Giant: Okay, it’s blank currently.
247 00:36:21.890 ⇒ 00:36:23.410 Demilade Agboola: Alright, I’ll look into that.
248 00:36:23.570 ⇒ 00:36:28.390 Emily Giant: But, is it blank because there’s no data coming into that fulfillment table?
249 00:36:30.290 ⇒ 00:36:32.840 Demilade Agboola: You guys are, like, interconnected.
250 00:36:35.230 ⇒ 00:36:39.680 Demilade Agboola: Yeah, so I believe fulfillment status is a function of… if…
251 00:36:39.790 ⇒ 00:36:41.880 Demilade Agboola: I don’t know, give me one second.
252 00:36:42.950 ⇒ 00:36:48.190 Demilade Agboola: some weeks back. But, like, effectively, it’s supposed to be a function of…
253 00:36:51.580 ⇒ 00:36:57.249 Demilade Agboola: the fulfillment… Okay, so it comes up earlier…
254 00:37:09.210 ⇒ 00:37:12.510 Emily Giant: Oh, God. Well, that’s not helpful.
255 00:37:50.360 ⇒ 00:37:55.680 Demilade Agboola: And yeah, it’s just a… it’s blank from here, like, the Shopify table.
256 00:37:59.510 ⇒ 00:38:01.680 Emily Giant: Okay, it’s blank.
257 00:38:01.680 ⇒ 00:38:03.239 Demilade Agboola: Yeah, it’s blank, so…
258 00:38:10.010 ⇒ 00:38:15.290 Emily Giant: Okay, I’m guessing that is a… like…
259 00:38:15.910 ⇒ 00:38:22.379 Emily Giant: result of these not being loaded. I can check, though, I don’t know if I’m replicating that table.
260 00:38:22.700 ⇒ 00:38:24.599 Emily Giant: And I should be.
261 00:38:28.470 ⇒ 00:38:32.800 Demilade Agboola: I may need 15 minutes back. I have…
262 00:38:33.160 ⇒ 00:38:36.510 Demilade Agboola: That apparently, is quite urgent.
263 00:38:36.880 ⇒ 00:38:38.740 Emily Giant: No worries.
264 00:38:38.860 ⇒ 00:38:44.869 Emily Giant: I will keep adding notes to this. I just wanted to make sure you knew, like, where the stuff was to.
265 00:38:44.870 ⇒ 00:38:45.460 Demilade Agboola: Yeah.
266 00:38:45.460 ⇒ 00:38:49.220 Emily Giant: building it out, but I think, like, at least that part we’ve hammered out, so…
267 00:38:49.580 ⇒ 00:38:52.970 Demilade Agboola: Yeah, that part, that part, has been figured out. It’s just kind of like…
268 00:38:53.110 ⇒ 00:38:57.009 Demilade Agboola: Piecing together and ensuring that also unfulfilled stuff are…
269 00:38:57.460 ⇒ 00:39:01.150 Emily Giant: Yeah, I’ll keep… I’ll keep plugging away at that. I can do that without you.
270 00:39:01.300 ⇒ 00:39:04.430 Emily Giant: So, I’ll, check in on Hibo and let you know.
271 00:39:04.790 ⇒ 00:39:05.790 Demilade Agboola: Okay, sounds good.
272 00:39:05.790 ⇒ 00:39:07.069 Emily Giant: Alright, talk to you soon.
273 00:39:07.930 ⇒ 00:39:08.790 Emily Giant: Bye.
274 00:39:11.930 ⇒ 00:39:13.560 Emily Giant: Where is this?
275 00:39:14.520 ⇒ 00:39:16.640 Emily Giant: I don’t know how to leave.