Meeting Title: QA Session 1 with Perry Date: 2025-10-10 Meeting participants: Demilade Agboola, perry, Emily Giant


WEBVTT

1 00:03:14.870 00:03:16.180 perry: Hi, Double Lotta.

2 00:03:17.100 00:03:18.120 Demilade Agboola: Hi, Kurt.

3 00:03:18.470 00:03:19.480 perry: Blurry.

4 00:03:22.320 00:03:24.389 Demilade Agboola: How are you?

5 00:03:25.030 00:03:26.000 perry: Good, how are you?

6 00:03:26.430 00:03:27.920 Demilade Agboola: I’m doing pretty well.

7 00:03:28.210 00:03:29.979 Demilade Agboola: Excited it’s a Friday, so…

8 00:03:30.340 00:03:34.630 perry: I was about to say the same thing. I’m excited for a weekend.

9 00:03:34.630 00:03:36.130 Demilade Agboola: Yeah,

10 00:03:37.070 00:03:38.629 Demilade Agboola: Oh, right, I mean…

11 00:03:39.390 00:03:45.820 Demilade Agboola: I know Emily is scheduled to be on the call, and I know Utam asked to hop into the call, just to listen in. Okay.

12 00:03:45.940 00:03:54.820 Demilade Agboola: But, since they aren’t here, we could just kind of start, and I will give you the lowdown of what I’ve been up to, and if you can help me queue it.

13 00:03:54.980 00:03:56.369 Demilade Agboola: No progress so far.

14 00:03:56.930 00:03:58.010 perry: Sure, yeah.

15 00:03:58.010 00:04:01.879 Demilade Agboola: Alright, thank you very much. We can hop into it.

16 00:04:03.880 00:04:07.350 Demilade Agboola: Oh, speak of the… well, not the devil, but, like…

17 00:04:11.180 00:04:16.779 Emily Giant: Sorry, we have… my house is getting lifted again today. We’re doing all this work on our basement, and I…

18 00:04:17.120 00:04:18.920 Emily Giant: every time I go downstairs, I get…

19 00:04:19.170 00:04:23.060 Emily Giant: caught with contractors, so I’m just not going down there anymore. Not doing it.

20 00:04:24.820 00:04:25.680 perry: Smart move.

21 00:04:30.700 00:04:32.779 Demilade Agboola: Okay, so yeah, can you see my screen?

22 00:04:34.150 00:04:40.020 Demilade Agboola: Alright, so I have built out the model to calculate the… Revenue?

23 00:04:40.470 00:04:43.950 Demilade Agboola: It’s right here. So right now, it’s not yet in production.

24 00:04:44.130 00:04:49.620 Demilade Agboola: But the idea is, for every single order, In Shopify.

25 00:04:49.830 00:04:58.119 Demilade Agboola: we get the, like, for each line in it, we get the different parts that make up the order. So we get the product name.

26 00:04:59.210 00:05:02.280 Demilade Agboola: The product SKU.

27 00:05:03.100 00:05:10.490 Demilade Agboola: And also, the sale quantity, the quantity price, amount, subtotal, all that stuff, discount.

28 00:05:12.250 00:05:20.379 Demilade Agboola: Tax on it, and then… the refund, if any. So I’ve tied the refunds here as well.

29 00:05:21.130 00:05:29.860 Demilade Agboola: And that allows us to calculate revenue. So right now, the logic I’m using for revenue is… the…

30 00:05:30.060 00:05:31.660 Demilade Agboola: Unique price amount.

31 00:05:32.170 00:05:36.790 Demilade Agboola: plus… The discounts, because, like, the… when you…

32 00:05:37.140 00:05:44.390 Demilade Agboola: the way Shopify records it, if an item was, say, 20 discount, it would record it as $60.

33 00:05:44.580 00:05:49.730 Demilade Agboola: So, I add the discount to make it 80, basically, so that counts as the…

34 00:05:49.730 00:05:54.169 perry: Yeah, because it should be gross, it should be pre-discounts and promos applied.

35 00:05:54.330 00:05:56.410 perry: Yes, so…

36 00:05:57.230 00:06:02.309 Demilade Agboola: Amount, plus ref… plus, sir, plus discounts.

37 00:06:02.600 00:06:04.850 Demilade Agboola: Okay. So, minus refund.

38 00:06:06.680 00:06:26.409 perry: Okay, does… when… this might be something to check with e-com. When someone… since we’re on Shopify, and if someone were to use their Shopify points to get a discount, that appears in the discount line, right? So we would add that volume back. Like, there’s more ways than just a discount code now for someone to get a discount.

39 00:06:26.940 00:06:30.470 Demilade Agboola: Yeah, so I know there is a… is gift card, but it hasn’t…

40 00:06:30.470 00:06:31.070 perry: Okay.

41 00:06:31.470 00:06:41.509 Demilade Agboola: we haven’t necessarily been able to see it, properly, but I have looked at this for, like, a couple of different ones, including some.

42 00:06:41.510 00:06:42.120 perry: Okay.

43 00:06:42.120 00:06:47.229 Demilade Agboola: Problematic ones, and… I could quickly hop in, so let’s, like…

44 00:06:47.820 00:07:03.710 Demilade Agboola: I think one of the best… one of the things I did yesterday was I looked at it based off the highest revenue, because usually if there’s really high revenue, you want to just be sure that those numbers make sense. So, right now, we have a revenue of 2520, so if we look at the order…

45 00:07:05.580 00:07:06.929 Demilade Agboola: Let’s clock in there.

46 00:07:06.930 00:07:12.569 perry: Lux, I’m spending $2,500 on a subscription with us, that’s insane.

47 00:07:14.350 00:07:22.909 Demilade Agboola: Yeah, so this is the lock sub, like you said. So that’s that. Another thing I did, so if I go to this specific

48 00:07:23.510 00:07:27.650 Demilade Agboola: order, because Emily mentioned that yesterday, that when there is a tub.

49 00:07:27.790 00:07:33.139 Demilade Agboola: The revenue shouldn’t be counted against the… Things on the line item.

50 00:07:33.460 00:07:35.559 Demilade Agboola: It should just be counted against the sub.

51 00:07:37.820 00:07:38.980 Demilade Agboola: Would that be true?

52 00:07:40.770 00:07:43.270 perry: Sorry, I don’t necessarily follow.

53 00:07:43.480 00:07:48.460 Demilade Agboola: Alright, so say this… this was purchased. This is the full line item.

54 00:07:49.200 00:07:50.229 Demilade Agboola: There’s the lock server.

55 00:07:50.230 00:07:52.970 perry: Yeah, it’s 105 per send.

56 00:07:53.550 00:07:54.220 Emily Giant: Yeah.

57 00:07:54.290 00:07:57.149 perry: Yeah. The amortized oversend.

58 00:07:57.210 00:07:59.010 Emily Giant: Is what should happen here.

59 00:07:59.640 00:08:00.590 Demilade Agboola: Right, so…

60 00:08:02.530 00:08:04.780 perry: It’s kind of complicated, because, like.

61 00:08:07.440 00:08:18.139 perry: I can’t even really speak on how the old model used to set up, because I think that’s one that I don’t really know a lot about, but when you look at it by delivery week, it should show 105

62 00:08:18.450 00:08:19.450 perry: per week.

63 00:08:19.810 00:08:20.550 Emily Giant: Yeah

64 00:08:20.720 00:08:29.669 Emily Giant: Subs is kind of… for Demolade, I feel like we should almost leave subs out of this portion, and just, like, the strikethroughs…

65 00:08:29.970 00:08:35.309 Emily Giant: Anything non-subscription, and then once the subscription model is live,

66 00:08:35.500 00:08:39.050 Emily Giant: That could be, like, another round of QA. The subs are just weird.

67 00:08:39.409 00:08:52.019 Demilade Agboola: Okay, gotcha. Because I know… the reason I was asking is because I do know you mentioned that revenue should not count against the items in particular, so I was just kind of, like, trying to be sure if I got that logic down pat.

68 00:08:52.189 00:08:52.909 Demilade Agboola: Alright, so that is…

69 00:08:53.650 00:08:54.400 Emily Giant: Yeah.

70 00:08:54.590 00:08:56.739 perry: Alright. Well, it should apply to the floral.

71 00:08:59.080 00:08:59.740 Emily Giant: Shhh.

72 00:09:00.010 00:09:06.209 perry: The value of a Luxe subscription… the value of a Luxe subscription is 0 on the vase.

73 00:09:06.710 00:09:14.470 Emily Giant: So you would want, like, if it was the firecracker, you would want $105 of revenue attributed to the firecracker, but not to, like.

74 00:09:14.470 00:09:16.960 perry: the… Yeah, so, like, the…

75 00:09:17.100 00:09:22.860 perry: S. Yeah, so, like, in the Luxe… I mean, in the Seasonal and the Classic, it’s all the same, right? Because it’s, like, $60,

76 00:09:23.910 00:09:31.829 perry: per send, or whatever, and that’s, like, those are just bouquets. The only world in which there’s a kit that separates into two products is the Luxe.

77 00:09:31.830 00:09:43.969 perry: gets sent the Dreamscape as their subscription, I would expect the kit SKU to reflect 105, I would expect the bouquet to reflect 105, and I’d expect the vase to reflect 0.

78 00:09:44.240 00:09:51.179 Emily Giant: Yeah, once the subs model is live, that’s how it’s… that’s how it works. It’s technically live, it’s just not…

79 00:09:51.990 00:09:52.460 perry: Amish.

80 00:09:52.550 00:09:55.409 Emily Giant: Hooked up to the revenue portion of it.

81 00:09:55.410 00:09:56.299 perry: Yeah, yeah, yeah.

82 00:09:56.550 00:10:01.410 Emily Giant: But Devilani, I did QA a little bit this morning, and this looks like so much…

83 00:10:01.740 00:10:04.459 Emily Giant: Different and better than yesterday.

84 00:10:05.180 00:10:06.540 Demilade Agboola: Yeah,

85 00:10:07.050 00:10:13.900 Demilade Agboola: I’ll… let’s try where, like, we have refunds, because I know that can also be a potentially tricky…

86 00:10:14.940 00:10:17.449 Emily Giant: Yeah, what’s the deal with refunds, Perry?

87 00:10:18.260 00:10:19.129 perry: What about him?

88 00:10:19.540 00:10:24.200 Emily Giant: Like, do you… if the order is fulfilled, do you…

89 00:10:24.890 00:10:34.980 Emily Giant: At any point, consider a refund in top-line revenue, or is that a different… portion of… Forecasting and accounting.

90 00:10:37.160 00:10:38.810 perry: That’s a Dean Mark question.

91 00:10:38.810 00:10:40.120 Emily Giant: Okay, but did you mean?

92 00:10:40.660 00:10:41.420 Emily Giant: No.

93 00:10:41.760 00:10:44.780 Emily Giant: Like, you wouldn’t count, though, if an order was fulfilled.

94 00:10:45.150 00:10:47.420 perry: I genuinely…

95 00:10:48.320 00:10:48.650 Emily Giant: I don’t.

96 00:10:48.650 00:10:49.570 perry: No idea.

97 00:10:49.570 00:10:50.960 Emily Giant: Okay.

98 00:10:51.920 00:10:54.850 perry: I do know that if credits are issued.

99 00:10:55.300 00:10:59.890 perry: The revenue stays, and the credit’s issued as its own line item in the… in the…

100 00:11:00.070 00:11:01.849 perry: financial, like, EBITDA model.

101 00:11:02.110 00:11:04.079 perry: I don’t know.

102 00:11:04.080 00:11:08.209 Emily Giant: For refunds. It would be the exact same logic, I’m almost positive, because it…

103 00:11:08.210 00:11:14.320 perry: Yeah, I don’t… I don’t know that part of it, because it’s like, re-deliveries are zero, because that’s an order generated at $0 value.

104 00:11:14.480 00:11:15.110 Emily Giant: Yeah.

105 00:11:15.970 00:11:19.240 Emily Giant: So, with that logic, I’ll confirm with Dean, but it…

106 00:11:19.240 00:11:19.590 perry: Yeah.

107 00:11:19.590 00:11:24.139 Emily Giant: The refund would just be a different line, but it wouldn’t subtract from top line revenue.

108 00:11:25.770 00:11:28.889 Emily Giant: That’s how it’s been in other businesses I’ve worked in, anyway, like…

109 00:11:28.890 00:11:32.549 perry: And that… if it’s… that’s how it… yeah, if that’s how it is, then I would… I would leave it.

110 00:11:32.940 00:11:39.900 Emily Giant: Yeah, and I don’t think in any of your reports, we’re not removing refunds from Topline.

111 00:11:40.090 00:11:52.530 Emily Giant: That’s, like, another, like, after… it’s a different acronym of accounting, like, once you take away the fulfilled orders. Now, if it’s canceled, we do not count that in top line. It’s only if it was fulfilled.

112 00:11:52.640 00:12:00.220 Emily Giant: But… Like, revenue recognized, because that is technically a revenue-recognized order, even if it was refunded.

113 00:12:00.220 00:12:02.340 perry: Yeah, I hear you on that.

114 00:12:05.360 00:12:13.080 Demilade Agboola: All right, so… so for this, this, order right on the screen, what would…

115 00:12:17.400 00:12:20.599 perry: Is this a subscription, or is this just a normal…

116 00:12:20.880 00:12:22.309 Demilade Agboola: It appears to be normal.

117 00:12:24.570 00:12:26.189 Emily Giant: be 188, right?

118 00:12:26.810 00:12:27.520 perry: Yeah.

119 00:12:27.750 00:12:28.470 Demilade Agboola: Alright.

120 00:12:28.470 00:12:30.230 perry: 188 times 3.

121 00:12:31.860 00:12:34.029 Demilade Agboola: I mean, it was removed.

122 00:12:34.310 00:12:36.240 Demilade Agboola: Like, there seems to be 3 removals.

123 00:12:36.450 00:12:38.740 Emily Giant: Yeah, what in the world is this order?

124 00:12:38.740 00:12:41.609 perry: It’s probably that we, like, we changed the SKU.

125 00:12:42.380 00:12:48.010 perry: But, like, regardless, the value of the order stayed the same. So, the way this should report is that…

126 00:12:48.370 00:12:51.110 perry: There were 3 bouquets purchased.

127 00:12:51.830 00:12:53.700 Demilade Agboola: At $188.

128 00:12:55.730 00:12:56.690 Demilade Agboola: Okay.

129 00:12:57.600 00:12:59.359 perry: Basically, we gave that… Were there?

130 00:13:00.000 00:13:04.530 Emily Giant: What is this? Anyway, sorry, go ahead, and I’d like to see how this comes out.

131 00:13:04.530 00:13:09.499 perry: I mean, to me, it looks like they ordered 3 pieces, and then we were probably out a piece, and so we gave them 3 snow beanies.

132 00:13:10.250 00:13:12.430 Emily Giant: Is there a refund associated with this?

133 00:13:12.940 00:13:14.820 perry: No, it’s just a product line swap.

134 00:13:15.070 00:13:17.979 Emily Giant: Yeah, cause… It looks like they…

135 00:13:21.070 00:13:24.009 Demilade Agboola: Because, like, there’s only one item that they eventually got.

136 00:13:24.940 00:13:33.350 Emily Giant: That’s why it’s really weird to me that it’s 3 times triple the P. I gotta look at this in dash. I’ll pull it up while you two are looking, 3 to 2…

137 00:13:33.720 00:13:35.310 Emily Giant: 3228855.

138 00:13:37.320 00:13:39.230 perry: Yeah, that’s… I don’t even know what that shit is.

139 00:13:41.190 00:13:42.119 Demilade Agboola: Okay, so…

140 00:13:42.580 00:13:47.760 perry: I don’t even want to say what that revenue should be, because that should never be a scenario that happens.

141 00:13:47.950 00:13:49.530 perry: I don’t even know how to, like…

142 00:13:49.530 00:13:54.280 Emily Giant: It’s 3 forced upgrades, of Triple the Peace.

143 00:13:54.480 00:14:01.459 Emily Giant: So there’s 3 different line item crossouts before a not committed triple the Snow Peony is delivered.

144 00:14:02.720 00:14:08.139 Emily Giant: But… So it is correct in that 3 of them were removed.

145 00:14:08.300 00:14:14.339 Emily Giant: But it only ever was a purchase for one, so it should be $188, should be the revenue.

146 00:14:14.660 00:14:17.789 Demilade Agboola: So one EVA should be the revenue on this quarter.

147 00:14:18.390 00:14:19.190 Demilade Agboola: Okay.

148 00:14:19.700 00:14:22.650 Demilade Agboola: Alright, so let’s see what the line…

149 00:14:26.050 00:14:29.069 Demilade Agboola: What the line item does say?

150 00:14:30.960 00:14:35.270 Emily Giant: I feel like you won’t see stuff like this with diamonds. I don’t know.

151 00:14:36.490 00:14:37.890 perry: Probably not.

152 00:14:40.710 00:14:43.300 Emily Giant: Like, no one’s not getting what they ordered.

153 00:14:44.910 00:14:45.840 perry: Yeah, that’s…

154 00:14:46.380 00:14:53.110 Demilade Agboola: Interestingly, like, Shopify has 3 different lines for 3 different… so that’s 9 different quantities.

155 00:14:55.680 00:14:56.730 Demilade Agboola: Interesting.

156 00:14:57.740 00:15:03.319 Demilade Agboola: And then… discounts. What does it say for the refund?

157 00:15:05.000 00:15:07.840 Demilade Agboola: So it only says refunded $150.

158 00:15:09.000 00:15:11.189 Emily Giant: There should be zero refunds.

159 00:15:14.440 00:15:16.480 Emily Giant: Because those were just forced upgrades.

160 00:15:17.450 00:15:17.920 Demilade Agboola: Me.

161 00:15:17.920 00:15:22.929 Emily Giant: This is that same thing we were seeing last night, when we were like, why is this processing?

162 00:15:23.490 00:15:29.940 Emily Giant: a refund amount, and it doesn’t always do this. It’s just sometimes, which is very odd.

163 00:15:32.440 00:15:33.710 Demilade Agboola: That is…

164 00:15:34.410 00:15:40.769 Demilade Agboola: This is something to note, like, for these ones, because I just figured, like, you know, once revenue’s high.

165 00:15:40.910 00:15:45.660 Demilade Agboola: And you’re throwing refunds in there, there’s probably something to look at there, so yeah.

166 00:15:46.160 00:15:48.540 Demilade Agboola: These are some high values for the revenue.

167 00:15:53.510 00:15:57.260 Demilade Agboola: And it’s… it’s how they’re handling the refunds, that’s what’s going on.

168 00:15:57.260 00:15:58.060 Emily Giant: Yeah.

169 00:15:59.930 00:16:04.170 Demilade Agboola: That’s what’s going on here. I need to dig deeper into that.

170 00:16:04.870 00:16:08.439 Demilade Agboola: Let me put… let me note this down somewhere.

171 00:16:17.720 00:16:19.569 Demilade Agboola: Alright.

172 00:16:20.190 00:16:27.120 Emily Giant: That was on Valentine’s Day, too, so, like, whenever our… System’s overloaded, weird things happen.

173 00:16:27.940 00:16:28.690 Demilade Agboola: Oh.

174 00:16:31.890 00:16:41.649 Demilade Agboola: I see… Also, in this case, just… even though the revenue is… it shows $188…

175 00:16:42.460 00:16:44.190 Demilade Agboola: Still price is $2.34.

176 00:16:44.880 00:16:46.589 Demilade Agboola: Does that… should he be…

177 00:16:50.990 00:16:57.929 Emily Giant: I think that Perry’s answered this question for me before. I know that Perry knows the answer, but given she is…

178 00:16:58.100 00:16:59.220 Emily Giant: En route.

179 00:16:59.220 00:16:59.980 perry: What’s it again?

180 00:17:00.170 00:17:06.640 Emily Giant: The 234. So, 234 was never actually A possible gain, so.

181 00:17:06.640 00:17:08.289 perry: That goes nowhere.

182 00:17:08.760 00:17:09.359 Emily Giant: Yeah.

183 00:17:09.369 00:17:21.289 perry: Yeah, no, 188 as a strikethrough. So, a strikethrough…

184 00:17:21.669 00:17:42.709 perry: Yes, exactly. So that strikethrough, like, that fake strikethrough on site of, like, what the retail should be should never appear in our financial system. It doesn’t exist. So when we do that on-site, it’s purely a marketing tactic to say, like, we are giving you this value for less money, go you, buy it, please. It’s not real at all. The 188 is the revenue that should be associated.

185 00:17:43.360 00:17:44.120 Demilade Agboola: Gotcha.

186 00:17:44.650 00:17:50.920 Emily Giant: And Perry, I… I apologize in advance for, like, trying to speak before you do, but I’m just trying to be a proxy to make…

187 00:17:50.920 00:17:52.690 perry: I think that’s smart.

188 00:17:52.690 00:17:53.680 Emily Giant: Pick.

189 00:17:53.920 00:17:58.300 perry: Because I know you and I have done this a lot, so, like, I’ve got the knowledge, I just want to make sure.

190 00:17:58.900 00:17:59.680 perry: Yes.

191 00:18:00.580 00:18:01.320 Demilade Agboola: Okay.

192 00:18:01.670 00:18:08.540 Demilade Agboola: Alright, sounds good. So that means this revenue of $234 should also not count against this, it should be a 188.

193 00:18:09.710 00:18:15.240 Emily Giant: If you back this up to a staging model, will it say 234 or 188?

194 00:18:17.320 00:18:18.110 Demilade Agboola: Pardon?

195 00:18:18.720 00:18:25.150 Emily Giant: So if you ran this… Order number in staging order line items.

196 00:18:25.770 00:18:27.899 Emily Giant: What would the subtotal be?

197 00:18:28.840 00:18:30.489 Demilade Agboola: It should still be this.

198 00:18:30.950 00:18:31.680 Emily Giant: Okay.

199 00:18:33.880 00:18:38.970 Demilade Agboola: It should still be this, because, I mean, it’s not… it’s not a recent order, so I don’t think anything should have changed.

200 00:18:39.110 00:18:39.950 Demilade Agboola: Yeah.

201 00:18:41.040 00:18:46.499 Emily Giant: I just know you’ve had to do, like, a good deal of transformations to make revenue, revenue.

202 00:18:48.520 00:18:49.999 Emily Giant: So I wasn’t sure.

203 00:18:50.370 00:18:51.100 Demilade Agboola: Yeah.

204 00:18:53.620 00:18:57.880 Demilade Agboola: Okay, let’s see… Then…

205 00:19:11.470 00:19:17.560 Demilade Agboola: And so these are seasonal subscriptions… That’s cool.

206 00:19:47.270 00:19:49.900 Demilade Agboola: Okay, so this is just someone buying…

207 00:19:53.390 00:19:55.350 Demilade Agboola: ate double the Verona.

208 00:19:56.000 00:19:58.190 Demilade Agboola: For $9.36.

209 00:20:01.380 00:20:01.970 perry: blank.

210 00:20:05.260 00:20:06.680 Demilade Agboola: I’m friendship.

211 00:20:17.050 00:20:19.250 Demilade Agboola: Okay, so that’s pretty straightforward.

212 00:20:19.890 00:20:27.639 Demilade Agboola: In terms of revenue, I’m trying to just, like, hop around and see if we can find…

213 00:20:27.940 00:20:32.489 Demilade Agboola: Any more, like, weird edge cases that are not subscriptions.

214 00:20:39.000 00:20:39.909 Demilade Agboola: He said, don’t…

215 00:20:39.910 00:20:48.809 Emily Giant: All the forced upgrades are where the edge case stuff comes in, especially when it’s… so, Piri, one of the things we realized was, like, at one point in time.

216 00:20:48.950 00:20:59.020 Emily Giant: Shopify started processing forced upgrades as a $0 refund, so they were really easy to identify, but there was, like, a line prior to that where they were…

217 00:21:00.930 00:21:10.769 Emily Giant: saying that there was a dollar amount attached, like what we just saw on that Valentine’s Day order. So, it’s like finding where Shopify got its shit together and started.

218 00:21:11.890 00:21:20.099 Emily Giant: standing a forced upgrade did not have a monetary value attached, and I remember that ticket coming in, to dev.

219 00:21:20.610 00:21:21.100 Emily Giant: about.

220 00:21:21.100 00:21:21.810 perry: Oh, boy.

221 00:21:22.570 00:21:23.260 Emily Giant: Yeah.

222 00:21:24.010 00:21:26.049 Emily Giant: And same with forced upgrades.

223 00:21:26.540 00:21:30.880 Emily Giant: Showing additional value, adding to revenue.

224 00:21:31.560 00:21:34.250 Emily Giant: Which may be another reason why December got really weird.

225 00:21:34.400 00:21:36.960 Emily Giant: I’m just thinking through, like, all the reasons why

226 00:21:37.370 00:21:39.339 Emily Giant: Revenue may have gone down, and that…

227 00:21:40.050 00:21:42.580 Emily Giant: May have been, like, a retroactive fix, but…

228 00:21:42.900 00:21:50.300 Emily Giant: this… different topic, double holiday, but December, top line got really, like, strange and isn’t returning.

229 00:21:50.760 00:21:53.070 Emily Giant: All of the orders right now.

230 00:21:53.360 00:21:55.160 Emily Giant: That’s what I’m working on.

231 00:21:57.140 00:21:58.250 Emily Giant: Yeah.

232 00:22:02.120 00:22:04.030 Emily Giant: What’s that null product one?

233 00:22:05.970 00:22:08.070 Demilade Agboola: Let’s double the Margo, that’s the one I… they’ll double the…

234 00:22:08.290 00:22:09.340 Emily Giant: Got you.

235 00:22:09.760 00:22:10.490 Demilade Agboola: looked at.

236 00:22:13.590 00:22:17.049 Demilade Agboola: The revenue is fine. Let’s double the mono.

237 00:22:20.810 00:22:25.299 Emily Giant: What’s 13… the one… did they sell? 13 Charlestons?

238 00:22:27.120 00:22:28.320 Emily Giant: Is that right?

239 00:22:29.950 00:22:31.160 Demilade Agboola: Let’s take a look.

240 00:22:37.590 00:22:39.470 Demilade Agboola: So, November 14.

241 00:22:40.720 00:22:42.540 Emily Giant: Yeah, there it is.

242 00:22:42.920 00:22:43.600 Demilade Agboola: Yeah.

243 00:22:56.330 00:22:59.049 Demilade Agboola: Yeah, so we do have the revenue.

244 00:22:59.310 00:23:00.889 Emily Giant: That’s correct.

245 00:23:01.880 00:23:05.660 Demilade Agboola: So it’s, it’s correct, it just appears to be edge cases that…

246 00:23:07.690 00:23:11.749 Demilade Agboola: It could be problematic. So, let’s hop back into refunds.

247 00:23:13.940 00:23:17.560 Demilade Agboola: Through all the refunds and see what’s going on there.

248 00:23:19.350 00:23:20.090 Demilade Agboola: Hmm…

249 00:23:22.120 00:23:35.920 Emily Giant: A good, like, red herring would be partially refunded, because that means the order was probably still fulfilled and might be, a forced upgrade that’s incorrectly marked as a refund, because we don’t often do partial refunds. Sometimes, but…

250 00:23:38.670 00:23:39.600 Demilade Agboola: Okay.

251 00:24:01.800 00:24:06.520 Demilade Agboola: Okay, so we have this, where it appears to be the same order.

252 00:24:09.050 00:24:11.529 Demilade Agboola: Let’s look at that, let’s see what actually happened.

253 00:24:12.890 00:24:14.460 Demilade Agboola: And then…

254 00:24:20.730 00:24:22.379 Emily Giant: It’s gonna be forced upgrades.

255 00:24:22.760 00:24:23.710 Emily Giant: Again.

256 00:24:30.760 00:24:37.719 Demilade Agboola: But yeah, this is December as well, so potentially the whole issue with it not being a zero order.

257 00:24:40.090 00:24:50.359 Emily Giant: I can help with that today, too, because I’m just gonna dig through every table. There has to be a demarcation of a removed item versus a refunded item. There has to be.

258 00:24:50.360 00:24:55.849 Demilade Agboola: So prior to… so what was happening before was that we had the…

259 00:24:57.460 00:25:05.079 Demilade Agboola: It would appear in the table, the first table, where the orders happened, but then we also had another line where there was a refund, and then…

260 00:25:05.430 00:25:08.300 Demilade Agboola: A cross out, and it becomes a zero order.

261 00:25:08.490 00:25:13.550 Demilade Agboola: But that doesn’t hold to be true, as we’re seeing in some of these orders with the high…

262 00:25:13.700 00:25:15.040 Demilade Agboola: Revenue.

263 00:25:17.630 00:25:18.280 Emily Giant: Yeah.

264 00:25:20.220 00:25:20.940 Demilade Agboola: history.

265 00:25:21.580 00:25:22.960 Demilade Agboola: So in this case

266 00:25:26.090 00:25:26.780 Demilade Agboola: Boom.

267 00:25:26.780 00:25:36.040 Emily Giant: I did submit a ticket to Alex and Tazdeek and met with them this morning about the orders where it’s, like, just wrong in Shopify.

268 00:25:36.550 00:25:42.519 Emily Giant: Like, the ones where they were fulfilled, and there are tracking numbers to prove it, but they show removed?

269 00:25:43.240 00:25:43.980 Demilade Agboola: Yeah.

270 00:25:44.300 00:25:47.309 Emily Giant: If you come across any of those, can you Slack them to me again?

271 00:25:47.510 00:25:50.599 Emily Giant: Just so, like, we can get the scope of that problem.

272 00:25:52.770 00:25:54.100 Demilade Agboola: Okay, sounds good.

273 00:25:54.350 00:25:54.900 Emily Giant: Hmm.

274 00:25:57.940 00:26:02.209 Demilade Agboola: Yeah, so this… This is the same sort of problem.

275 00:26:04.240 00:26:05.159 Demilade Agboola: So you have…

276 00:26:05.160 00:26:07.089 Emily Giant: Sorry, go ahead.

277 00:26:07.360 00:26:12.169 Demilade Agboola: So you have the… Do you have 3 things that were struck through.

278 00:26:13.400 00:26:17.190 Demilade Agboola: It has 3 lines for each of them, like, 1 line for each… for all 3.

279 00:26:19.490 00:26:21.820 Demilade Agboola: But then, since it was struck through.

280 00:26:23.170 00:26:27.369 Demilade Agboola: This is all that should count. This should be zeroed out, but they aren’t.

281 00:26:29.220 00:26:31.310 Emily Giant: What does it say on the fulfillment status?

282 00:26:32.040 00:26:33.060 Emily Giant: Of those.

283 00:26:33.380 00:26:35.770 Demilade Agboola: Fulfillment status.

284 00:26:35.940 00:26:37.639 Emily Giant: It should say not fulfilled.

285 00:26:38.090 00:26:39.379 Demilade Agboola: Why should he refunded?

286 00:26:40.250 00:26:41.239 Emily Giant: and fulfilled.

287 00:26:41.570 00:26:42.290 Demilade Agboola: Unfulfilled, yeah.

288 00:26:45.210 00:26:49.789 Emily Giant: And fulfillment status, does that come from line items, or does it come from orders? The table?

289 00:26:49.960 00:26:57.279 Emily Giant: Because I’m wondering if… Give me one second… Okay, it’s wrong.

290 00:27:19.130 00:27:24.180 Emily Giant: This is a non-alcoholic beer, while we’re here. I know it looks like I’m just, like, chugging a michelob.

291 00:27:24.480 00:27:28.629 Emily Giant: at… noon, but it’s a… I’m addicted to these, like.

292 00:27:28.630 00:27:30.360 perry: Not even noon yet, Emily.

293 00:27:32.190 00:27:32.799 Demilade Agboola: It’s fun.

294 00:27:33.660 00:27:35.519 Emily Giant: It’s 5 o’clock somewhere.

295 00:27:35.520 00:27:37.050 Demilade Agboola: 5 o’clock on a Friday somewhere.

296 00:27:37.050 00:27:37.560 perry: True.

297 00:27:37.560 00:27:38.700 Emily Giant: Right?

298 00:27:39.170 00:27:39.640 perry: I mean.

299 00:27:39.640 00:27:42.410 Emily Giant: I joined a demo at a multi-happy hour.

300 00:27:44.440 00:27:47.020 Demilade Agboola: I mean, it’s actually 6 o’clock for me, so, you know.

301 00:27:47.440 00:27:48.110 Demilade Agboola: Come on, man.

302 00:27:48.110 00:27:49.250 Emily Giant: He’s wasted.

303 00:27:49.250 00:27:53.269 perry: If you’re on a call with someone where it’s later, then it’s okay.

304 00:27:53.550 00:27:54.120 Emily Giant: Yep.

305 00:27:54.550 00:27:56.020 Demilade Agboola: It’s brain forge rules.

306 00:27:56.800 00:27:58.050 perry: Very large rules.

307 00:28:01.990 00:28:07.830 Demilade Agboola: Hmm… Sorry, I’m on the wrong branch.

308 00:28:08.650 00:28:10.020 Demilade Agboola: Revenue modeling.

309 00:28:18.480 00:28:27.889 Demilade Agboola: Okay, so Fulfillment status comes from… The financials model… financials model…

310 00:28:30.050 00:28:31.900 Emily Giant: So it’s coming from sale line items.

311 00:28:39.940 00:28:42.550 Demilade Agboola: It was coming from the Order Lines base.

312 00:28:47.630 00:28:50.949 Demilade Agboola: Yep, it’s coming from Auteline Space, and auto line space…

313 00:28:50.950 00:28:51.640 Emily Giant: song.

314 00:28:53.590 00:28:55.500 Demilade Agboola: That’s that one…

315 00:28:55.500 00:28:56.470 perry: Or even use it.

316 00:28:56.720 00:28:58.990 Demilade Agboola: From Shopify orders directly.

317 00:28:59.530 00:29:09.870 Emily Giant: Okay, that’s actually good, because Shopify orders is going to show the entire order was fulfilled, but if we pull from Shopify fulfillment lines, it might give an itemized.

318 00:29:10.090 00:29:13.020 Emily Giant: Of what was fulfilled versus the entire order.

319 00:29:13.290 00:29:15.160 Emily Giant: That might just be a small change.

320 00:29:15.690 00:29:16.470 Demilade Agboola: Gotcha.

321 00:29:17.840 00:29:26.069 Demilade Agboola: So you’re singing in here… We need to get the fulfillment in as well.

322 00:29:26.820 00:29:30.830 Emily Giant: Yep. That fulfillment, and… it…

323 00:29:34.360 00:29:43.189 Emily Giant: Yeah, that should do it. I’ll double check, but I know that that, like, there are 4 different fulfillment tables. One of them is

324 00:29:43.470 00:29:48.180 Emily Giant: an item-by-item row…

325 00:29:48.370 00:29:56.429 Emily Giant: a fulfilled or not fulfilled, and if we pull it from that, I’m wondering if that fixes the issue. I know that table’s problematic because sometimes it doesn’t populate

326 00:29:57.290 00:30:01.009 Emily Giant: Until the item is getting processed.

327 00:30:01.140 00:30:06.760 Demilade Agboola: But, like, the way that they do their financials, that really shouldn’t matter, because they’re talking about what was delivered that week.

328 00:30:06.780 00:30:08.349 Emily Giant: Thus, it is fulfilled.

329 00:30:08.490 00:30:11.350 Emily Giant: So it might be… Fine for revenue.

330 00:30:20.480 00:30:24.130 Demilade Agboola: Can’t find the exact model. I think this is it.

331 00:30:24.960 00:30:28.939 Emily Giant: Yeah, there’s one where I slam them all together, and I think it’s this one.

332 00:30:30.720 00:30:33.839 Demilade Agboola: Alright, I perform very strong from this model.

333 00:30:35.160 00:30:38.629 Demilade Agboola: Alright, so I’ll use that, get some fulfillment.

334 00:30:40.190 00:30:42.880 Demilade Agboola: information from here.

335 00:30:44.510 00:30:47.559 Emily Giant: I’m sorry I didn’t think of this before. Like, that…

336 00:30:48.200 00:30:49.770 Emily Giant: Was a miss on my part.

337 00:30:51.120 00:30:52.830 Demilade Agboola: Oh, that’s fine. It’s all good.

338 00:30:53.280 00:30:56.240 Demilade Agboola: So, I will see if we can get the…

339 00:30:56.430 00:30:58.460 Demilade Agboola: But we don’t have status here, do we?

340 00:30:58.920 00:31:12.000 Emily Giant: I think there is one, I just didn’t add it from the table. So, I’ll go back into the raw, or we can do that, too. I know Perry probably has to hop, she has a half day. So you’re, like, effectively done working right now. But.

341 00:31:12.000 00:31:17.000 perry: Yeah, my brain is entering… my brain is entering talker mode right now.

342 00:31:17.240 00:31:18.230 Emily Giant: Taco mode.

343 00:31:18.230 00:31:18.980 perry: So…

344 00:31:19.370 00:31:28.419 perry: as much as I feel bad saying it, my brain is deteriorating quickly. I mean, I think that, like, in the most part, a lot of this makes sense.

345 00:31:28.940 00:31:30.659 perry: I think that…

346 00:31:32.950 00:31:34.089 Emily Giant: I would need to put a hoodie on.

347 00:31:34.090 00:31:34.790 perry: Biggest?

348 00:31:36.110 00:31:42.229 perry: I know, my friend keeps her house freezing, and it’s delightful. I think that the biggest thing I would flag

349 00:31:42.440 00:31:50.089 perry: is just… the care scenarios are always going to be wonky and weird. We don’t… I really don’t…

350 00:31:51.540 00:31:52.609 perry: I don’t wanna…

351 00:31:52.730 00:31:57.779 perry: say that we have to be perfect with that, because, like, forced upgrades definitely is, like, important.

352 00:31:58.130 00:31:59.400 perry: But I think…

353 00:32:01.440 00:32:07.319 perry: I think things are mostly okay, to my… like, from what I see in this, I feel like this is an improvement.

354 00:32:07.550 00:32:11.320 perry: so I feel good about it.

355 00:32:11.320 00:32:17.809 Emily Giant: With the bundles and kits, the way that Shopify itemizes them is just better. Like, we don’t have to do all that bullshit.

356 00:32:18.270 00:32:19.950 perry: Transformation or stuff like that.

357 00:32:20.210 00:32:33.179 Emily Giant: Yeah. So, once we find the… I don’t think Demolade can personally deliver a table that isn’t perfect. I know him well enough to know that’s not really…

358 00:32:33.380 00:32:37.429 Emily Giant: your operate… that’s not your, modus operandi.

359 00:32:37.570 00:32:41.989 Emily Giant: But I think the fulfillment table might… Fix every care scenario.

360 00:32:41.990 00:32:42.390 perry: Yeah.

361 00:32:42.630 00:32:43.909 Emily Giant: That is from there.

362 00:32:44.550 00:32:47.380 perry: And I think that what I’ll say is, like.

363 00:32:47.680 00:32:53.460 perry: If we… if this means that there’s, like, the purchase world, like, we might have to make some business decisions where…

364 00:32:53.540 00:33:09.459 perry: what this model reflects is what was purchased by the customer, and there’s, like, a secondary model that more so reflects what was actually fulfilled, and that’s how we handle, the difference between, like, what was originally purchased and that. Like, those… that can be the answer, you know what I mean? Like, we don’t need…

365 00:33:09.460 00:33:16.739 perry: I’m not gonna say we have to have one model that handles it. If we decide as a business that this, like, the main revenue model

366 00:33:16.890 00:33:24.999 perry: accounts for what was purchased, and we stream different decisions into the fulfillment side of the business, like, I think that’s okay. But, like.

367 00:33:25.320 00:33:31.450 perry: it should always tie back to, like, what the customer paid. As long as that’s what the main model is reflecting, we’re…

368 00:33:31.910 00:33:33.750 perry: Close enough, you know?

369 00:33:34.000 00:33:35.850 Emily Giant: Yeah, and on that note, like.

370 00:33:36.080 00:33:44.239 Emily Giant: you’ve always said, and I’ve always said, like, we shouldn’t be looking at forced upgrades, like, ever for business decisions, because that’s not what people wanted in the.

371 00:33:44.240 00:33:44.600 perry: Yeah.

372 00:33:44.600 00:33:45.100 Emily Giant: place.

373 00:33:45.620 00:33:46.720 perry: I think that…

374 00:33:47.030 00:34:06.839 perry: what I will say, what we should add to this, is, like, their total revenue generating orders, there should be a measure that’s non-force upgrade units, because I know that that currently is in, like, our units sold and stuff like that, and it shouldn’t be. So either we should circulate that force upgrades just don’t apply until, like, units sold, because, like, that’s just not real.

375 00:34:06.840 00:34:07.440 Demilade Agboola: data.

376 00:34:07.560 00:34:11.189 perry: And that data is what Felipe uses, and it comes from NetSuite.

377 00:34:11.350 00:34:17.760 Emily Giant: So, they really are separate things. I think that there’s a world where, like, we do need to have that in the table.

378 00:34:17.760 00:34:29.159 perry: Yeah, like, when you look at fulfillment, and you look at, like… you’re looking at units fulfilled, you’re looking at the inventory tables, those units went out the door. But if you’re looking at sales tables, like components and stuff like that, that’s not…

379 00:34:29.290 00:34:48.880 perry: we didn’t use that unit, you know? So, like, I would rather have units sold, the units sold, and then have a forced upgrade measure, and someone like Felipe be able to reconcile it by adding those two together, and that matches usage on the back end. I would rather that structure than have units sold, and then, like, have this weird math that goes on, you know?

380 00:34:48.889 00:34:57.439 Emily Giant: Yeah, like, adding 105 to just a random number, to a product that did not actually gain that revenue.

381 00:34:57.609 00:35:04.819 Emily Giant: like, I think it’s worth having a column, like, this is what was sent, but that’s technically what NetSuite data is. That’s the polyatomic data.

382 00:35:04.820 00:35:05.520 perry: Yeah.

383 00:35:05.690 00:35:12.319 Emily Giant: And that’s why I was like, Felipe, you cannot use sales data for your work, because it is… it doesn’t have anything to do.

384 00:35:12.590 00:35:14.320 Emily Giant: With what actually went out there.

385 00:35:15.310 00:35:15.680 perry: Yeah.

386 00:35:15.680 00:35:19.679 Emily Giant: I think, yeah, to your point, like, if we can do our base model.

387 00:35:19.800 00:35:23.149 Emily Giant: If the deliverable for right now is just what people ordered.

388 00:35:24.150 00:35:24.840 perry: Yeah.

389 00:35:24.850 00:35:25.630 Demilade Agboola: Yeah.

390 00:35:25.630 00:35:26.200 Emily Giant: Full.

391 00:35:27.900 00:35:29.109 Demilade Agboola: Fair enough, fair enough.

392 00:35:29.240 00:35:39.790 Demilade Agboola: Alright, so I’ll look into the fulfillment model, and how to do some of that, and I will tweak the revenue model, so hopefully by, like, next week, early next week.

393 00:35:40.290 00:35:44.740 Demilade Agboola: Numbers that are more aligned with Business.

394 00:35:46.330 00:35:47.200 perry: Sound good?

395 00:35:47.530 00:35:54.360 Emily Giant: And then, I’m probably gonna halt on the December ticket for now, because if we can just use Shopify data.

396 00:35:54.900 00:36:01.380 Emily Giant: to rectify whatever the hell happened in Hivo in December that, like, erased all those order statuses.

397 00:36:01.500 00:36:05.269 Emily Giant: Problem solved.

398 00:36:05.410 00:36:10.330 Emily Giant: So… As long as you don’t need it before, like, Monday, the December stuff.

399 00:36:10.720 00:36:11.460 Emily Giant: for.

400 00:36:11.460 00:36:13.329 perry: Oh, the revenue stuff?

401 00:36:13.670 00:36:14.690 Emily Giant: The thing that went.

402 00:36:14.690 00:36:29.579 perry: Yeah, as long as… if I… if… as long as the answer, like, I just… the numbers being changed is fine. That can wait till Monday. It’s just, I need to know, like, is it wrong? Or is, like, was the number before wrong, and we actually fixed something, and the number came down?

403 00:36:29.950 00:36:30.290 Emily Giant: No.

404 00:36:30.290 00:36:31.810 perry: The number’s wrong. Okay.

405 00:36:31.810 00:36:33.130 Emily Giant: Yes.

406 00:36:33.130 00:36:34.759 perry: I just needed to be able to tell Dean.

407 00:36:35.070 00:36:53.449 Emily Giant: Yes, so revenue, like, almost everything is based on, like, order status. It’s usually always, like, order status complete, because that is revenue recognized. And right now, when I pull a full week in December, it’ll show me only 2,000 orders, which we know is not true. We’ve never gotten less than 7,000 orders a week.

408 00:36:53.600 00:36:54.919 Emily Giant: Since I’ve worked here.

409 00:36:55.200 00:36:55.990 Emily Giant: So, like.

410 00:36:55.990 00:36:56.460 perry: gap.

411 00:36:56.460 00:36:59.040 Emily Giant: At a base level, I know the number you pulled is wrong.

412 00:37:00.540 00:37:01.090 Emily Giant: Okay, cool.

413 00:37:01.320 00:37:04.269 Emily Giant: Bad happened to the data. Not good.

414 00:37:07.470 00:37:08.040 perry: Okay.

415 00:37:10.450 00:37:12.380 perry: You’re gonna try to fix that on Monday?

416 00:37:13.260 00:37:18.259 Emily Giant: That’s, like… I’m probably never gonna fix that.

417 00:37:18.260 00:37:19.210 perry: But maybe we’re gonna…

418 00:37:19.210 00:37:27.029 Emily Giant: Yeah, so we’ll be able to say, like, here are the differences, but I think that your numbers the first time were… they look correct to me.

419 00:37:27.530 00:37:28.470 perry: Okay, like…

420 00:37:28.510 00:37:30.310 Emily Giant: Not what was pulled last week.

421 00:37:31.640 00:37:32.250 perry: Okay.

422 00:37:38.730 00:37:43.030 Emily Giant: It’s like, in my head, the difference between 2,000 and 7,000 orders.

423 00:37:43.270 00:37:45.739 Emily Giant: It’s, like, roughly what you’re pulling as a difference.

424 00:37:46.150 00:37:46.670 perry: Yeah.

425 00:37:48.480 00:37:54.689 perry: Yeah, pretty much. Okay, cool. All right, well, that’s it for me. I’m gonna go stuff my face with tacos in case I know.

426 00:37:55.040 00:37:58.540 Emily Giant: Taco time! Alright, we’ll talk to you later.

427 00:37:58.540 00:37:59.120 perry: Thank you.

428 00:37:59.120 00:38:01.130 Emily Giant: Feel good, just huddle me if you need…

429 00:38:01.600 00:38:05.760 Emily Giant: If we need to… I don’t have any meetings the rest of the afternoon, so I’m just working on subs.

430 00:38:06.060 00:38:07.029 Demilade Agboola: Okay, sounds good.

431 00:38:07.330 00:38:10.099 Emily Giant: Cool. Alright, thanks, everyone. Happy tacos.