Meeting Title: Uttam <> Chuck - Unleashed-debug Date: 2024-07-02 Meeting participants: Chuck Gross, Uttam Kumaran


WEBVTT

1 00:00:55.260 00:00:56.260 Hits.

2 00:01:01.170 00:01:02.160 hooks.

3 00:02:02.400 00:02:03.270 Chuck Gross: A.

4 00:05:15.010 00:05:15.850 Uttam Kumaran: Hey, Chuck.

5 00:05:23.380 00:05:26.640 Uttam Kumaran: you are on mute if you’re talking.

6 00:05:45.260 00:05:46.570 Uttam Kumaran: hey? Can you hear me?

7 00:05:46.570 00:05:48.800 Chuck Gross: Like, yes. Hello! Can you hear me?

8 00:05:48.800 00:05:50.540 Uttam Kumaran: Yes, yes, yes. How’s it going.

9 00:05:51.150 00:05:52.804 Chuck Gross: Great Dave! Good! How are you?

10 00:05:53.406 00:05:54.059 Uttam Kumaran: Good good

11 00:05:55.630 00:06:00.070 Uttam Kumaran: cool alright! Tell me what’s the what’s the deal.

12 00:06:00.340 00:06:05.109 Chuck Gross: Alright. So I think what I’m gonna do is I’m gonna share my screen.

13 00:06:06.380 00:06:08.030 Chuck Gross: all right. So there’s

14 00:06:09.050 00:06:14.909 Chuck Gross: there’s there’s actually there’s 3 issues. So 1st issue

15 00:06:15.010 00:06:20.630 Chuck Gross: the the filters that we’re selling has a filter skew.

16 00:06:20.740 00:06:23.110 Chuck Gross: a base skew.

17 00:06:23.470 00:06:27.860 Chuck Gross: and a sometimes a pump, sometimes not a pump.

18 00:06:28.860 00:06:39.650 Chuck Gross: There’s something going on with the base skew. That’s something that in shopify comes up as like an add-on that they have to add on because they need the box.

19 00:06:42.822 00:06:52.449 Chuck Gross: So, for some reason unleashed, won’t accept the order, as you can see these orders right here, says, this invoice like all these, these are the filters.

20 00:06:52.700 00:06:53.310 Uttam Kumaran: Yeah.

21 00:06:53.310 00:07:00.659 Chuck Gross: It won’t import the sales into unleashed. So it never updates the inventory, because Unleash has no idea that the item sold.

22 00:07:00.660 00:07:01.410 Uttam Kumaran: Yeah.

23 00:07:01.880 00:07:02.760 Uttam Kumaran: Shed.

24 00:07:03.450 00:07:05.070 Chuck Gross: So I I don’t know

25 00:07:05.340 00:07:10.359 Chuck Gross: I was chatting with them because they’re in New Zealand. So you have to like get them at weird times.

26 00:07:10.360 00:07:10.890 Uttam Kumaran: Yeah.

27 00:07:10.890 00:07:19.938 Chuck Gross: But I was chatting with them Sunday night, and she seemed to have said that she fixed all the mapping cause. I don’t think that’s something that we can do.

28 00:07:20.400 00:07:22.075 Uttam Kumaran: Yeah, it’s not for sure.

29 00:07:22.410 00:07:38.010 Chuck Gross: Yeah. So it’s something that they could do. But the map it still doesn’t work. So yeah, I just tried the. I just tried to go through them the orders again and try to upload them again. I’ve got those errors because all you would do is you go to this little e-commerce hub

30 00:07:38.650 00:07:40.360 Chuck Gross: click! Here

31 00:07:40.820 00:07:43.290 Chuck Gross: we click pool parts.

32 00:07:43.780 00:07:48.769 Chuck Gross: And then, under manager data, the last down here this is missing orders

33 00:07:48.810 00:07:51.400 Chuck Gross: so unleash knows that there’s orders missing.

34 00:07:52.600 00:07:58.039 Chuck Gross: So when you click, find it’s usually 7, it’s been 7. Yes, that’s the same. 17 orders.

35 00:07:58.190 00:07:58.800 Uttam Kumaran: Yeah.

36 00:07:58.970 00:08:02.800 Chuck Gross: Have the same mapping issue, so I don’t know how to fix that.

37 00:08:02.820 00:08:07.359 Chuck Gross: I don’t know if it’s on. You know the shopify side, or if it’s on the unleash side.

38 00:08:07.840 00:08:08.440 Uttam Kumaran: Okay.

39 00:08:08.940 00:08:11.420 Uttam Kumaran: I can press them on that. Okay, I’ll figure it out.

40 00:08:11.420 00:08:13.289 Chuck Gross: Okay? So that’s 1

41 00:08:13.450 00:08:18.329 Chuck Gross: while we’re in unleashed. This problem has been plaguing me recently

42 00:08:18.970 00:08:26.669 Chuck Gross: when we sell something that’s marked in stock and unleash. So you know, it says we have a hundred pumps, and we sell 50 pumps.

43 00:08:26.750 00:08:33.800 Chuck Gross: The or the or the the order is automatically completed, so it removes the inventory from our

44 00:08:34.100 00:08:35.190 Chuck Gross: stock.

45 00:08:35.190 00:08:35.770 Uttam Kumaran: Yeah.

46 00:08:36.350 00:08:41.340 Chuck Gross: If it’s something that’s not in stock or it’s oversold. For whatever reason

47 00:08:42.730 00:08:44.930 Chuck Gross: it does, this thing called Park.

48 00:08:44.940 00:08:49.280 Chuck Gross: So it it allots the inventory as sold.

49 00:08:50.160 00:08:52.780 Chuck Gross: and I cannot complete the order.

50 00:08:54.420 00:08:55.340 Chuck Gross: So

51 00:08:55.650 00:09:03.330 Chuck Gross: if you see here, so what I do here is like you can select all, and if you click complete. You click complete orders.

52 00:09:04.800 00:09:10.260 Chuck Gross: So sometimes, if we oversell, I have to move inventory, and then the orders will complete and go away.

53 00:09:10.490 00:09:11.220 Uttam Kumaran: Yeah, like.

54 00:09:11.220 00:09:13.620 Chuck Gross: He’s a newer order, so that might happen with some of them.

55 00:09:13.950 00:09:20.159 Chuck Gross: So soon as it’s done. I’ll show you the issue, and I can’t figure this one out for the life of me.

56 00:09:30.170 00:09:34.339 Chuck Gross: Well, almost done, almost done. Do do

57 00:09:41.950 00:09:43.410 Chuck Gross: all right. So.

58 00:09:43.970 00:09:44.960 Uttam Kumaran: Okay.

59 00:09:45.140 00:09:47.730 Chuck Gross: Alright. So if you see here, it says.

60 00:09:48.030 00:09:49.810 Chuck Gross: Alright, so these can’t be.

61 00:09:49.950 00:09:50.919 Chuck Gross: This is

62 00:09:51.090 00:09:53.999 Chuck Gross: stock issues. So that’s 1 thing I can fix those

63 00:09:54.750 00:09:57.430 Chuck Gross: I’m looking for.

64 00:09:58.850 00:10:01.069 Chuck Gross: Course those are all really shitty examples.

65 00:10:05.480 00:10:07.759 Chuck Gross: let me find some like the older ones.

66 00:10:14.060 00:10:17.719 Chuck Gross: There’s an issue with what’s called their tax file

67 00:10:17.820 00:10:19.680 Chuck Gross: and tax codes.

68 00:10:21.350 00:10:24.669 Chuck Gross: and it looks for a tax code

69 00:10:25.180 00:10:27.819 Chuck Gross: that’s from 0.

70 00:10:29.620 00:10:35.620 Chuck Gross: So I don’t know if you handle anything on the accounting side with 0.

71 00:10:36.620 00:10:38.550 Uttam Kumaran: I don’t.

72 00:10:38.550 00:10:42.960 Chuck Gross: Okay, yeah, neither do I. And I’ve never. I’ve only been on there once.

73 00:10:43.340 00:10:48.260 Uttam Kumaran: I don’t, but if I can articulate it, and I’m sure I can, you know. Try.

74 00:10:48.260 00:10:49.509 Chuck Gross: Yeah, yeah, yeah.

75 00:10:49.540 00:10:51.040 Chuck Gross: So let me, just I don’t.

76 00:10:51.140 00:10:56.710 Chuck Gross: I’ll see if I get the error. And then I could show you what I had done in the past, but then, unleashed, didn’t update

77 00:10:58.920 00:11:03.700 Chuck Gross: cause. We don’t, you know, unleash isn’t used for any of the accounting per se.

78 00:11:09.520 00:11:11.810 Uttam Kumaran: I saw a tax one on the 1st one that you’d.

79 00:11:12.010 00:11:13.810 Chuck Gross: Was there a tax one on the 1st one?

80 00:11:14.178 00:11:16.389 Uttam Kumaran: Well, yeah, right there, yeah, yeah.

81 00:11:16.390 00:11:21.120 Chuck Gross: Yeah, okay, so see? So see? Yeah, like, see, these one is a unmapped tax.

82 00:11:21.290 00:11:24.319 Uttam Kumaran: Can you slack, can you? Slack this one to me?

83 00:11:24.670 00:11:25.530 Chuck Gross: Yeah.

84 00:11:26.750 00:11:27.425 Chuck Gross: Yeah.

85 00:11:29.440 00:11:30.970 Chuck Gross: yeah, I’ll send it out.

86 00:11:31.030 00:11:36.450 Chuck Gross: I’ll have it on my computer. I’ll do it in a second. Yeah. So these so these unmapped taxes.

87 00:11:37.360 00:11:41.669 Chuck Gross: If you go down to settings, you go down to system, you go to taxes.

88 00:11:43.710 00:11:50.480 Chuck Gross: They used to make you put in every single possible percentage for taxes.

89 00:11:52.440 00:11:57.280 Chuck Gross: So you can see there’s all these random taxes. And then you start to see. See these blanks.

90 00:11:58.640 00:12:00.510 Uttam Kumaran: Yes, like, do you like.

91 00:12:00.510 00:12:02.230 Chuck Gross: Knox county here.

92 00:12:02.230 00:12:02.870 Uttam Kumaran: Yeah.

93 00:12:02.870 00:12:07.639 Chuck Gross: This is the unmapped tax. So in this county

94 00:12:08.000 00:12:11.139 Chuck Gross: they have a 2.2 5% tax.

95 00:12:11.665 00:12:12.010 Uttam Kumaran: Yeah.

96 00:12:12.010 00:12:14.830 Chuck Gross: But it’s unmapped to anything else.

97 00:12:15.070 00:12:15.659 Chuck Gross: What is so.

98 00:12:15.660 00:12:18.399 Uttam Kumaran: What do you mean on it’s unmatched like.

99 00:12:18.560 00:12:20.109 Chuck Gross: Absolutely right, but

100 00:12:20.250 00:12:28.050 Chuck Gross: supposedly. See all these other taxes tax 140 tax, 141 tax, 142, 144.

101 00:12:28.250 00:12:35.109 Uttam Kumaran: So so these are mapped to tax codes, and the tax code gets mapped. Once an order comes in with that from that.

102 00:12:35.420 00:12:41.960 Chuck Gross: Right, and to my knowledge this is mapped somewhere in 0.

103 00:12:42.250 00:12:43.240 Uttam Kumaran: Okay. Okay.

104 00:12:43.490 00:12:50.799 Chuck Gross: But I don’t know that for sure, like I don’t. I don’t know where these came from. Yeah, I have no idea where those these ever came from.

105 00:12:51.250 00:12:56.440 Uttam Kumaran: Okay, let me I’m going to. Well, I’ll ask these guys. And I’ll also

106 00:12:56.710 00:13:01.349 Uttam Kumaran: basically ask Ben, like who we should even chat with about this.

107 00:13:01.490 00:13:02.169 Uttam Kumaran: Yeah, but.

108 00:13:02.170 00:13:09.650 Chuck Gross: Because the the woman who does the accounting she wasn’t sure where it was coming from. I like I asked her. She’s a little

109 00:13:09.870 00:13:12.939 Chuck Gross: not fun to talk to, but she she once.

110 00:13:12.940 00:13:14.110 Uttam Kumaran: Her name. By the way.

111 00:13:14.670 00:13:15.230 Chuck Gross: Pam!

112 00:13:15.230 00:13:16.250 Uttam Kumaran: Okay. Okay.

113 00:13:16.430 00:13:28.419 Chuck Gross: But she she did look into it. She wasn’t sure, cause she’s like I wouldn’t put in 114 separate tax codes. It’s got to be coming from somewhere, and I’m like, Well, I tend to agree with you. I wouldn’t want to do that either.

114 00:13:28.420 00:13:34.309 Uttam Kumaran: I’ll I’ll get the, so I’ll get the I’ll get the unleash people to tell me where it’s coming from, and then I’ll get all these folks on the

115 00:13:34.590 00:13:36.999 Uttam Kumaran: on the horn to to do this. Okay, okay.

116 00:13:37.000 00:13:42.721 Chuck Gross: Okay, awesome. Because then I think once once it maps all the taxes, I can complete all those orders and clear it all up

117 00:13:43.010 00:13:46.289 Chuck Gross: because it just it’ll hang like a lot of these.

118 00:13:46.290 00:13:47.120 Uttam Kumaran: After.

119 00:13:47.120 00:13:53.210 Chuck Gross: Allocations, which is like like I was just dealing with it. It’s fine like. See? All these allocations.

120 00:13:53.500 00:13:55.099 Uttam Kumaran: What is the allocation?

121 00:13:55.410 00:13:59.430 Chuck Gross: Allocation is items that are sold, but there’s none on hands.

122 00:13:59.430 00:14:00.690 Uttam Kumaran: Oh, nice!

123 00:14:00.690 00:14:03.610 Chuck Gross: These are Fba models.

124 00:14:04.020 00:14:04.430 Uttam Kumaran: Yeah.

125 00:14:04.430 00:14:19.789 Chuck Gross: I. Just so I. In order to do Fba through unleash. I have to just adjust out quantities and then just readjust them back in to complete the order. I’ve just been too busy. I usually do it like once a week, but in the summer I just have to do it like one day when I have time.

126 00:14:19.790 00:14:20.360 Uttam Kumaran: And.

127 00:14:20.740 00:14:29.889 Chuck Gross: But you’ll get like some like some of them are. Just, you know. It’ll be like this is, you know, allocated here with stop allocated with, and I just can’t complete the orders because of those tax codes.

128 00:14:29.890 00:14:31.099 Uttam Kumaran: Okay. Okay. Okay.

129 00:14:34.840 00:14:39.440 Chuck Gross: So those are the. Those would be the 2, the 2 biggies right now in unleashed.

130 00:14:40.160 00:14:46.919 Uttam Kumaran: And another question about unleashed for the actual product prices. How often do we update those like in terms of cost of goods sold

131 00:14:47.010 00:14:48.189 Uttam Kumaran: like the actual.

132 00:14:48.190 00:14:56.250 Chuck Gross: The cost of goods automatically update you showing me, do a new purchase order like if we go here

133 00:14:58.220 00:15:00.280 Chuck Gross: and then we go to costs.

134 00:15:01.470 00:15:11.309 Chuck Gross: So it takes. This is the the last time we received in this item yesterday, whatever, a couple days ago, it was 3, 54, 38, so it has last 3, 54, 38,

135 00:15:11.850 00:15:16.399 Chuck Gross: and an average cost of all the times we’ve taken it in since the beginning of time.

136 00:15:16.800 00:15:21.310 Uttam Kumaran: Okay, okay, perfect. And they’re all they’re all related to. Pos. Okay, okay, perfect. Okay. Great.

137 00:15:21.310 00:15:27.189 Chuck Gross: Yeah, all this. Yeah, they’re all related to something, either. Yeah. But the adjustment po, they they all cost.

138 00:15:28.390 00:15:30.123 Uttam Kumaran: Okay, great. Okay, let me.

139 00:15:30.540 00:15:35.559 Uttam Kumaran: Let me start sending. Let me send a note out about both of these.

140 00:15:36.130 00:15:36.910 Chuck Gross: Okay.

141 00:15:37.630 00:15:45.119 Uttam Kumaran: I think the 1st one. Yeah, it’s gonna be a little bit of shopify stuff. This one seems probably the tax one. I think it’s just.

142 00:15:45.520 00:15:55.879 Uttam Kumaran: I’ll have to figure out whose end it is. And then, basically, if it’s something that Pam needs to do, they need to articulate what exactly needs to happen in 0. I’m sure they’ll have like a document or something, so I’ll figure it out.

143 00:15:56.080 00:16:03.413 Chuck Gross: Yeah, I was. Gonna say, it’s gonna probably be something that they have to like upload. And she probably did it once in the past, and then never did it again.

144 00:16:03.650 00:16:05.219 Uttam Kumaran: Yes, that’s what I’m thinking, too.

145 00:16:05.220 00:16:08.870 Chuck Gross: Yeah. So they should do it one more time, and they’ll solve, you know, half the problems.

146 00:16:08.870 00:16:16.149 Uttam Kumaran: Yeah. And then so then the other thing is for Unica. They they send me a document like I have to create some sort of shopify app.

147 00:16:16.390 00:16:26.320 Uttam Kumaran: So I’m gonna walk through that. And then, yeah, we’re still dealing with the I just basically, I’ve been busy with other stuff. So we’re still dealing with, like the tagging issues.

148 00:16:27.060 00:16:27.369 Chuck Gross: Hook!

149 00:16:27.650 00:16:31.894 Uttam Kumaran: Working need to just close that out as soon as I get like a free couple of hours.

150 00:16:32.130 00:16:40.950 Chuck Gross: Yeah, no worries, you know. I I just been I I haven’t been sending you the examples. But I’ve just been. It’s only since it’s only a few skews. I just go through them each morning.

151 00:16:40.950 00:17:03.089 Uttam Kumaran: No, that’s fine. I it’s a good reminder. It’s just we’ve been. So we’ve actually been doing a bunch of stuff on like pro versus consumer meaning like we started segmenting people if they’re professionals, or if they’re just like normal people, that’s up the bulk of the time. And then also, we’re we’re doing the analysis on the the the 3rd units location that we’re gonna open like us or Texas.

152 00:17:03.090 00:17:03.850 Chuck Gross: Okay.

153 00:17:03.850 00:17:07.679 Uttam Kumaran: Basically, we’re doing this like center of gravity analysis, where basically, we’re looking at

154 00:17:07.720 00:17:12.690 Uttam Kumaran: every order. And then the distance to every warehouse projected.

155 00:17:12.880 00:17:13.530 Chuck Gross: Right.

156 00:17:13.730 00:17:23.269 Uttam Kumaran: The question like Jacob’s working that he may have a question about like, actually, I guess I’ll ask you this like, is there a decision. Why, we only wanted to ship those skews

157 00:17:23.540 00:17:24.770 Uttam Kumaran: with unis.

158 00:17:25.270 00:17:27.439 Chuck Gross: Those were the more like

159 00:17:28.190 00:17:32.629 Chuck Gross: it. Certain skews we were gonna discontinue at some point.

160 00:17:32.950 00:17:33.720 Uttam Kumaran: Okay.

161 00:17:33.720 00:17:54.090 Chuck Gross: So originally we brought in a lot of like the blue torrent brand skews, and then we’ve been skewing more towards the blackened Decker versions. So it’s been taking a little longer to get the blackened Decker versions produced, and then we have to get reviews, and, you know, do all that work to get the sales rolling.

162 00:17:54.400 00:18:01.840 Chuck Gross: So then, once we get to a certain scale, then it’s worth, you know, sending, you know, a couple 100 pumps here, a couple 100 pumps, there, a couple 100 pumps. Here.

163 00:18:02.070 00:18:02.870 Uttam Kumaran: I see.

164 00:18:04.060 00:18:05.000 Uttam Kumaran: Okay, okay.

165 00:18:05.000 00:18:17.529 Chuck Gross: There’s really only one other S like, we, we have the above ground variable speed pump. That’s probably the only other skew that would have like enough volume that we could like, you know, put into different locations. But they once we get

166 00:18:17.730 00:18:22.209 Chuck Gross: yeah, once we get a roll and we just move it to the other locations and update the software. It’s.

167 00:18:23.550 00:18:31.090 Uttam Kumaran: Yeah. The only the only reason is cause we’re what we’re doing is we basically look at price. We like to look at price per pound in order to like, normalize everything.

168 00:18:31.090 00:18:31.469 Chuck Gross: Hmm.

169 00:18:31.850 00:18:40.680 Uttam Kumaran: And of course, like, if something weighs a lot more, it kind of can skew things. So we’re gonna just start with the skew list we have. And then basically, I think what we’re gonna be able to do is like

170 00:18:40.790 00:18:49.819 Uttam Kumaran: we can say, Hey, if we want to add a skew, we’ll be able to look at the volume and say, like, this is what we should expect. Like, decrease. Basically, we’re trying to get every

171 00:18:49.960 00:18:54.979 Uttam Kumaran: skew we want to send to like zone 3 or less, maybe even zone, 2 or less.

172 00:18:54.980 00:18:56.589 Chuck Gross: Okay, yeah, right? Right?

173 00:18:56.590 00:19:02.149 Uttam Kumaran: So we’re looking at like average zone. And then basically, we’re gonna be able to look at like what our savings are gonna be

174 00:19:02.220 00:19:07.690 Uttam Kumaran: the thing is, they’re like they unice will be like, Yeah, cool. Let’s just open in Riverside or opening here. I want them to.

175 00:19:07.880 00:19:10.680 Uttam Kumaran: And I want them to look at our data and basically

176 00:19:10.910 00:19:19.459 Uttam Kumaran: be like, actually, our customers are here. If it’s not Dallas, maybe it’s a little bit closer or whatever. So we’re gonna have that same analysis on our side.

177 00:19:20.290 00:19:24.319 Uttam Kumaran: I’m just very skeptical all the time about when people do this sort of stuff

178 00:19:25.200 00:19:28.959 Uttam Kumaran: also cause. Now we we work with Unis, and I’m like not impressed.

179 00:19:28.960 00:19:30.571 Chuck Gross: I? Yeah, I know. I know.

180 00:19:30.840 00:19:35.749 Uttam Kumaran: I’m kind of like sussed out that, like they, they just kind of like will just do whatever.

181 00:19:35.990 00:19:36.540 Chuck Gross: Yeah.

182 00:19:36.540 00:19:45.200 Uttam Kumaran: We were like, we want to open in Texas, and he like sent the contract like the afternoon. I’m like dude. We didn’t do any analysis or anything on like this decision like, can’t we wait.

183 00:19:45.200 00:19:47.620 Chuck Gross: They’re they’re very quick to send the contract.

184 00:19:47.620 00:19:49.150 Uttam Kumaran: Yeah, they’re very quick to send the contract.

185 00:19:49.150 00:20:00.420 Chuck Gross: Very, very quick to send the contract, and that, doesn’t we set up Jacksonville when I did the Jacksonville with them? That’s why it took like 3 months. We signed the contract like that, Daniel, 1st day in October, and then it was.

186 00:20:00.420 00:20:02.620 Uttam Kumaran: Hey? I don’t like I don’t like that. I’m like.

187 00:20:02.620 00:20:04.924 Chuck Gross: Yeah, I don’t know.

188 00:20:05.500 00:20:14.669 Uttam Kumaran: And so yeah, so we’re we’re we’re figuring it out. And then I also, I chatted with Kelly recently, so I need to get back to her and the other person

189 00:20:14.730 00:20:17.769 Uttam Kumaran: on those other renegotiations. So

190 00:20:17.890 00:20:19.839 Uttam Kumaran: just order of operations here.

191 00:20:19.840 00:20:20.295 Chuck Gross: Yup!

192 00:20:22.110 00:20:30.950 Uttam Kumaran: Okay, cool, alright. Well, slack me, if anything else. I have the notes from this. So I’ll CC you on any communications with them.

193 00:20:30.950 00:20:33.280 Chuck Gross: Yep. Absolutely sounds good.

194 00:20:33.280 00:20:35.148 Uttam Kumaran: Okay, thanks. Chuck, have a great.

195 00:20:35.460 00:20:36.619 Chuck Gross: Thanks you too.