Meeting Title: Chuck __ Brainforge - Shipping Weekly Meeting Date: 2024-12-11 Meeting participants: Luke Daque, Nicolas Sucari, Chuck Gross
WEBVTT
1 00:02:13.330 ⇒ 00:02:14.450 Chuck Gross: Oh, when?
2 00:02:18.920 ⇒ 00:02:20.610 Chuck Gross: Yeah, take it easy.
3 00:03:34.840 ⇒ 00:03:35.760 Nicolas Sucari: Hey! Chuck.
4 00:03:36.240 ⇒ 00:03:38.010 Chuck Gross: How are you? Good.
5 00:03:39.860 ⇒ 00:03:43.670 Nicolas Sucari: Excellent! How was, how how are you doing all this time?
6 00:03:44.780 ⇒ 00:03:46.550 Chuck Gross: Hanging in there. How about you?
7 00:03:47.260 ⇒ 00:03:50.569 Nicolas Sucari: Yeah, me, too, expecting to end this year.
8 00:03:51.020 ⇒ 00:03:54.600 Nicolas Sucari: How’s the end of year going there at wolverts?
9 00:03:55.140 ⇒ 00:03:59.340 Chuck Gross: It’s slow, but it’s going normal. It’s wintertime. So.
10 00:04:00.630 ⇒ 00:04:06.899 Nicolas Sucari: Nice. Okay, it’s beginning. It’s beginning to be really, really cold. There, right.
11 00:04:07.504 ⇒ 00:04:11.846 Chuck Gross: It’s it’s actually almost 70 degrees today. But yeah, no, it’s been cold.
12 00:04:12.513 ⇒ 00:04:18.846 Nicolas Sucari: That’s fine. Yeah, I’m I’m just the opposite. It’s beginning to be really, really hot here in Buenos Aires.
13 00:04:20.116 ⇒ 00:04:20.970 Nicolas Sucari: I bet.
14 00:04:22.040 ⇒ 00:04:23.890 Nicolas Sucari: Not bad. Not bad. Yeah.
15 00:04:24.602 ⇒ 00:04:33.470 Nicolas Sucari: But yeah, thank you for for joining we. We had a call last, I think, last week with Ben.
16 00:04:34.080 ⇒ 00:04:42.469 Nicolas Sucari: Okay, here is Ryan cool? We had this call with Ben, where he was asking about some reports to start looking into
17 00:04:42.986 ⇒ 00:04:55.333 Nicolas Sucari: the profit, numbers, and all of the daily kpis that we have and try to like, go deeper into what are the main drivers of of costs that we have, and obviously shipping is one of the big ones.
18 00:04:55.800 ⇒ 00:04:58.760 Nicolas Sucari: so he he told us that there is
19 00:04:59.720 ⇒ 00:05:06.189 Nicolas Sucari: like like you have logged in like a new agreement. I don’t know with who to ship
20 00:05:06.550 ⇒ 00:05:12.299 Nicolas Sucari: heat pumps for a big portion in the country for $200. Is that correct?
21 00:05:12.570 ⇒ 00:05:13.510 Chuck Gross: Yes.
22 00:05:14.080 ⇒ 00:05:21.789 Nicolas Sucari: Okay, cool. And how can we see that in the data? Are you like adding any of that anywhere.
23 00:05:21.790 ⇒ 00:05:22.985 Chuck Gross: Nope.
24 00:05:24.510 ⇒ 00:05:49.959 Nicolas Sucari: Okay? And yeah, I mean, if if you can tell us a little bit more of that agreement, or what or or if you have like a list of skews that impact. And what what are the locations that? You’re shipping, that that agreement is valid, for it would be great, so that we can see what is like. The best way for us to start like looping that it that in into the data.
25 00:05:50.480 ⇒ 00:05:54.179 Chuck Gross: Yeah, yeah, it’s any of the heat pump skews.
26 00:05:55.320 ⇒ 00:06:13.350 Chuck Gross: And we’re really just focusing on Florida, because we we started looking at going. You know the whole Eastern seaboard, but there’s there’s not enough. There’s not enough volume there, so it doesn’t make any sense for the driver. It doesn’t make any sense for us. It just it doesn’t work.
27 00:06:14.100 ⇒ 00:06:24.190 Chuck Gross: But in, you know, in Florida, we, you know, every week we sell maybe 30 to 40 heaters and 30 to. You know, 90% of those heaters are within
28 00:06:24.200 ⇒ 00:06:27.619 Chuck Gross: a thousand mile radius in Florida.
29 00:06:28.160 ⇒ 00:06:28.830 Nicolas Sucari: Okay.
30 00:06:28.830 ⇒ 00:06:36.659 Chuck Gross: So we’ve been basically doing 3, rd you know, between 20 to 25 to 30 heaters a week.
31 00:06:36.840 ⇒ 00:06:47.460 Chuck Gross: And he’s just traveling around the state. So he’s doing. He starts. He picks up in Jacksonville, drives all the way around the east, around the west, loops around that comes back up the east.
32 00:06:48.240 ⇒ 00:06:56.659 Nicolas Sucari: Okay. So it’s like, it’s, it’s 1 person that’s like delivering all of these heat pumps. And the rate is 200 per heat pump in that area right.
33 00:06:56.690 ⇒ 00:07:01.389 Chuck Gross: Yeah, I’ve been having to pay him a little bit more, because 200 wasn’t working.
34 00:07:01.430 ⇒ 00:07:11.349 Chuck Gross: So it’s it got it got a little more various than just a straight 200 from when we initially set this up because of obvious growing pains.
35 00:07:11.390 ⇒ 00:07:15.843 Chuck Gross: especially when I was paying him $200 to drive 5,000 miles, but.
36 00:07:16.140 ⇒ 00:07:16.470 Nicolas Sucari: Yeah.
37 00:07:16.470 ⇒ 00:07:21.720 Chuck Gross: But the the Florida parts working a lot better now where
38 00:07:21.870 ⇒ 00:07:26.710 Chuck Gross: I mean, if if you took, maybe just all Florida shipments
39 00:07:27.620 ⇒ 00:07:29.879 Chuck Gross: for this for a set of skews
40 00:07:31.230 ⇒ 00:07:41.259 Chuck Gross: and divided it by the the payment invoices that he sends. It’s probably the best way to, you know, or the the closest way to do it.
41 00:07:43.160 ⇒ 00:07:47.299 Nicolas Sucari: Okay, are you? Are you tracking like? Which orders
42 00:07:47.580 ⇒ 00:07:50.550 Nicolas Sucari: are? Are you shipping like in
43 00:07:51.004 ⇒ 00:07:54.959 Nicolas Sucari: in in a Google sheet, or anything that we can look into too.
44 00:07:55.453 ⇒ 00:08:01.189 Chuck Gross: I can try to pull up what I have. Yeah, I don’t. I haven’t really been saving what I was doing.
45 00:08:01.803 ⇒ 00:08:07.670 Chuck Gross: I could probably download the last. You know, couple of routes that I’ve done, at least to get it started.
46 00:08:08.770 ⇒ 00:08:13.600 Nicolas Sucari: Yeah, I mean, any any information that we can see, it’s gonna be great.
47 00:08:14.003 ⇒ 00:08:22.976 Nicolas Sucari: So because we will like, we will need to create something in the data to just tag these orders. With this shipping price?
48 00:08:23.420 ⇒ 00:08:28.282 Nicolas Sucari: but yeah, and and what about like, these are orders that are being
49 00:08:28.920 ⇒ 00:08:32.599 Nicolas Sucari: bought, buy it in shopify right or.
50 00:08:32.600 ⇒ 00:08:35.049 Chuck Gross: They’re all in shopify.
51 00:08:35.830 ⇒ 00:08:44.709 Nicolas Sucari: Okay? And what about the shipping prices of these queues when they buy in, shopify what happened with that like, how you remove that from there.
52 00:08:45.310 ⇒ 00:08:50.349 Chuck Gross: I’ve been taking everything basically manually right now.
53 00:08:50.420 ⇒ 00:08:55.119 Chuck Gross: So I I turned off a lot of the the Unis integrations.
54 00:08:55.590 ⇒ 00:08:55.950 Nicolas Sucari: Okay.
55 00:08:55.950 ⇒ 00:09:00.610 Chuck Gross: For these skews, and I’m handling them on a 1 by one basis because
56 00:09:00.750 ⇒ 00:09:03.480 Chuck Gross: we were still having problems where
57 00:09:03.970 ⇒ 00:09:12.609 Chuck Gross: you can. I can ship a heater from New York to California for half the price that Florida could, for whatever reason.
58 00:09:13.280 ⇒ 00:09:22.110 Chuck Gross: So we’ve we found it counterproductive to have you know, to ship it out of Florida, even though it’s closer, but it costs double the amount. It makes no sense.
59 00:09:22.790 ⇒ 00:09:23.500 Nicolas Sucari: Yeah.
60 00:09:23.500 ⇒ 00:09:34.600 Chuck Gross: So we’ve been really kind of going on a 1 by one basis. I mean, I’m I’m out of a few of the skews here in New York. So then, we have no choice but to ship them out of Florida, which is what we have to do.
61 00:09:36.230 ⇒ 00:09:42.170 Chuck Gross: But most of those ones that are tagged. Eunice are being shipped out of Yap Bank.
62 00:09:43.930 ⇒ 00:09:50.339 Chuck Gross: The Florida shipments are being picked up in units, and then, you know, shipped to Florida.
63 00:09:52.020 ⇒ 00:09:52.760 Nicolas Sucari: Day.
64 00:09:54.710 ⇒ 00:09:56.890 Nicolas Sucari: Okay, my only guess would be
65 00:09:57.800 ⇒ 00:10:02.242 Nicolas Sucari: like, yeah, if you’re not tracking this in like any Google sheet or anything.
66 00:10:03.470 ⇒ 00:10:05.980 Nicolas Sucari: because kind of our data is gonna be like.
67 00:10:06.270 ⇒ 00:10:11.500 Nicolas Sucari: different, right? Like from the actual, what’s actual happening in the business.
68 00:10:11.500 ⇒ 00:10:16.360 Chuck Gross: Yeah, it would. It would be hard to. It would be hard to figure out which orders went which way.
69 00:10:16.360 ⇒ 00:10:16.890 Nicolas Sucari: Yeah.
70 00:10:16.890 ⇒ 00:10:18.350 Chuck Gross: Yeah, I mean.
71 00:10:18.350 ⇒ 00:10:23.559 Nicolas Sucari: That’s what I was trying to think about, like how, how we can possibly identify, which orders
72 00:10:24.530 ⇒ 00:10:27.489 Nicolas Sucari: are these ones and how we can like, yeah.
73 00:10:27.500 ⇒ 00:10:31.230 Nicolas Sucari: add a tag or something that we can easily identify them.
74 00:10:32.110 ⇒ 00:10:37.760 Chuck Gross: I’m trying to think. I see I can’t really tag them in shopify.
75 00:10:38.740 ⇒ 00:10:43.710 Chuck Gross: I mean, I could keep a Google sheet going forward of all the orders.
76 00:10:44.960 ⇒ 00:10:47.309 Chuck Gross: Me? I don’t know if that does that help.
77 00:10:47.660 ⇒ 00:10:49.350 Nicolas Sucari: Yeah, obviously, that helps.
78 00:10:50.260 ⇒ 00:10:53.049 Chuck Gross: Cause. I don’t think there’s any other real way to do it.
79 00:10:56.570 ⇒ 00:10:58.999 Nicolas Sucari: Yeah, I think that that helps
80 00:11:00.390 ⇒ 00:11:12.830 Nicolas Sucari: mainly just like to start identifying these orders and try to see like, what we are getting from from each data source that we have connected right now. And how we can like modify that shipping price.
81 00:11:14.070 ⇒ 00:11:18.310 Nicolas Sucari: So yeah, if if you can like, identify the the order numbers
82 00:11:18.770 ⇒ 00:11:27.789 Nicolas Sucari: and send like in a weekly basis. Or, yeah, whenever you, you can just send to us like a list of orders. Yeah, that will be great, so that
83 00:11:28.100 ⇒ 00:11:39.160 Nicolas Sucari: we can start to identify this. And then we can create something to just tag them, maybe in shopify, or I don’t know or create, like something in Snowflake, so that we can identify easily. These orders
84 00:11:39.170 ⇒ 00:11:41.800 Nicolas Sucari: are being shipped differently.
85 00:11:42.070 ⇒ 00:11:43.900 Chuck Gross: Right? Right? Right, you know.
86 00:11:43.900 ⇒ 00:11:44.870 Nicolas Sucari: That would be great.
87 00:11:45.630 ⇒ 00:11:50.750 Chuck Gross: Okay, yeah, I’ll definitely keep a sheet going. I’ll send you. I’ll send you the link once I get it going.
88 00:11:51.570 ⇒ 00:11:53.394 Nicolas Sucari: Excellent. Thank you. Chuck
89 00:11:53.980 ⇒ 00:12:01.859 Nicolas Sucari: Ryan, do you think like there is something else we should be needing to like? Identify these kind of orders.
90 00:12:09.430 ⇒ 00:12:20.409 Luke Daque: yeah, I I’m not quite sure as well. I think that should be fine, for now we can look at like if once chuck sends us the sheet we can look into that. And yeah.
91 00:12:21.200 ⇒ 00:12:21.890 Luke Daque: like.
92 00:12:21.890 ⇒ 00:12:26.919 Nicolas Sucari: Because I I think we have like different options. One is creating a tag in shopify to identify easily like
93 00:12:27.275 ⇒ 00:12:42.039 Nicolas Sucari: when there is a heat pump. And it’s going to a certain zip code like. And and we know that it’s gonna be shipped by by this new method. We can tag it, and then we can bring that into some like and see how we can like
94 00:12:42.480 ⇒ 00:12:47.243 Nicolas Sucari: differentiate that view from what we have in the in the shipping tables.
95 00:12:47.650 ⇒ 00:12:54.860 Nicolas Sucari: or what we can do is like, load that Google sheet as a different data source and start working with that separately. Right?
96 00:12:56.270 ⇒ 00:12:57.750 Luke Daque: Yeah, we can do that.
97 00:12:58.476 ⇒ 00:13:02.840 Luke Daque: Just to clarify these aren’t being shipped by ups. Right?
98 00:13:03.280 ⇒ 00:13:04.919 Chuck Gross: No, no, no, no, no, no.
99 00:13:05.940 ⇒ 00:13:08.036 Luke Daque: So these are like from a
100 00:13:08.850 ⇒ 00:13:11.950 Luke Daque: from a separate, or like a different mode.
101 00:13:11.950 ⇒ 00:13:12.569 Nicolas Sucari: Provider, yeah.
102 00:13:12.900 ⇒ 00:13:14.090 Luke Daque: Provider, yeah.
103 00:13:16.660 ⇒ 00:13:20.699 Nicolas Sucari: So what’s the name? Chuck, of this provider? If you can tell us.
104 00:13:20.700 ⇒ 00:13:24.619 Chuck Gross: It’s we his. The company name is Island Storm.
105 00:13:25.430 ⇒ 00:13:26.560 Luke Daque: Island, Stone.
106 00:13:26.560 ⇒ 00:13:31.990 Chuck Gross: Yeah his when when we pay him it, says James Mack. I don’t know if you see any of that.
107 00:13:34.060 ⇒ 00:13:37.280 Nicolas Sucari: Oh, but yeah, okay, it’s good information.
108 00:13:38.140 ⇒ 00:13:42.760 Luke Daque: Okay, is there any, I think, like one of the questions that Ben had also was like.
109 00:13:43.238 ⇒ 00:13:48.170 Luke Daque: why, this is not being shipped by ups. Is there like any specific reason why.
110 00:13:48.170 ⇒ 00:13:50.510 Chuck Gross: You can’t ship a heater with ups. He knows that.
111 00:13:51.183 ⇒ 00:13:51.729 Luke Daque: I see!
112 00:13:51.730 ⇒ 00:13:54.660 Chuck Gross: It’s heaters afraid they have to go freight.
113 00:14:00.090 ⇒ 00:14:06.800 Nicolas Sucari: Okay, okay, yeah. Okay, chuck. So if you have like.
114 00:14:07.109 ⇒ 00:14:18.560 Nicolas Sucari: any example order that you can send us so that we can also take a look a little a little bit further on. What is the information that we have? And if there is any way that we can like
115 00:14:18.620 ⇒ 00:14:25.449 Nicolas Sucari: easily tag something so that we can start identifying. That will be great. And then, yeah, when you have that Google sheet link
116 00:14:25.960 ⇒ 00:14:30.159 Nicolas Sucari: running, let us know. And we can also yeah, start looping that in too.
117 00:14:30.530 ⇒ 00:14:36.660 Chuck Gross: Yeah, I’m thinking, I’m thinking, if I could figure out what zip codes we’ve been doing.
118 00:14:36.740 ⇒ 00:14:41.499 Chuck Gross: I’ll have to see if there’s a a good Zip code file for Florida because we don’t.
119 00:14:41.670 ⇒ 00:14:53.509 Chuck Gross: It’s funny because we’ve been. This is, we’re on the 7th week of doing this and nobody on the Florida, Panhandle, the long, flat part. Nobody there buys a pool heater.
120 00:14:53.890 ⇒ 00:14:54.500 Nicolas Sucari: Okay.
121 00:14:54.500 ⇒ 00:15:02.819 Chuck Gross: It’s only like the down the Peninsula. So I would just exclude those because he would never drive. He’s not gonna drive that way to deliver one unit.
122 00:15:03.880 ⇒ 00:15:11.210 Chuck Gross: So I if I if I could find the Zip, if I could find a Zip code file, maybe I can give you guys a Zip code file. Then we can tag
123 00:15:11.410 ⇒ 00:15:18.629 Chuck Gross: these orders in the Zip code with his tag, and that should be a pretty foolproof way to do it.
124 00:15:19.750 ⇒ 00:15:20.250 Nicolas Sucari: Okay.
125 00:15:20.250 ⇒ 00:15:26.049 Chuck Gross: Because, with with one or 2 exceptions, he’s taken every single one in those zip codes.
126 00:15:26.260 ⇒ 00:15:29.209 Chuck Gross: So I think that would probably work that would probably work the best.
127 00:15:30.410 ⇒ 00:15:31.110 Nicolas Sucari: Okay.
128 00:15:31.400 ⇒ 00:15:37.510 Nicolas Sucari: Okay, yeah. We’ll see if we can get a list of all of the Zip codes in Florida, and with some like, I don’t know
129 00:15:37.820 ⇒ 00:15:41.099 Nicolas Sucari: address or something, and we can share that with you, and you can. You can.
130 00:15:41.100 ⇒ 00:15:48.739 Chuck Gross: Okay, I can figure out the areas where he’s going, because I’ve seen the map enough. It’s the same. It’s the same thing over and over and over again.
131 00:15:49.310 ⇒ 00:15:49.960 Nicolas Sucari: Okay.
132 00:15:50.160 ⇒ 00:15:50.880 Chuck Gross: Right.
133 00:15:51.860 ⇒ 00:15:56.910 Nicolas Sucari: Cool. Thank you. I think. Yeah, that’s what we need.
134 00:15:57.630 ⇒ 00:16:03.624 Luke Daque: Yeah, I have an another question. I I think this is different. But this is related to the
135 00:16:04.050 ⇒ 00:16:06.870 Luke Daque: filters. The big filters that are
136 00:16:07.080 ⇒ 00:16:12.350 Luke Daque: sent by the U by ups where, like it’s
137 00:16:12.660 ⇒ 00:16:16.450 Luke Daque: pretty other. The price there we’re paying is pretty high.
138 00:16:16.980 ⇒ 00:16:19.345 Chuck Gross: The price is extremely high. Yeah.
139 00:16:19.740 ⇒ 00:16:23.709 Luke Daque: Yeah, the the you. You were the one who raised this right chuck.
140 00:16:23.710 ⇒ 00:16:28.929 Chuck Gross: Yeah, I caught it like 2 weeks ago, but it looks like it’s been going on for about 6 weeks.
141 00:16:29.530 ⇒ 00:16:30.640 Chuck Gross: We’re at right.
142 00:16:30.640 ⇒ 00:16:33.699 Chuck Gross: I don’t know if a discount expired
143 00:16:33.880 ⇒ 00:16:42.640 Chuck Gross: because it it was up. I was, I would say, on average, about 200 bucks to send a filter like 1, 81 92, 10 in that neighborhood.
144 00:16:43.180 ⇒ 00:16:43.860 Luke Daque: Right.
145 00:16:43.860 ⇒ 00:16:49.659 Chuck Gross: But but now it’s like 303, 25. I don’t know if that’s because it’s the holiday season.
146 00:16:49.770 ⇒ 00:16:53.400 Chuck Gross: or if I think it’s because one of our discounts expired.
147 00:16:54.040 ⇒ 00:16:58.929 Luke Daque: I see? Would you do you also have like a list of these? Or like a Yeah.
148 00:16:59.415 ⇒ 00:17:07.650 Chuck Gross: I mean, yeah, I could send the I could look up the last couple. It was not. That’s why it’s not a tremendous volume, but you know each one, it’s just a waste of money.
149 00:17:08.349 ⇒ 00:17:09.109 Luke Daque: Right, yeah.
150 00:17:09.109 ⇒ 00:17:15.719 Chuck Gross: But I can send you. I can send you those order numbers, but I’m pretty sure that some form of a.
151 00:17:15.739 ⇒ 00:17:25.869 Chuck Gross: because that those in particular, go over the the maximum ups shipment so that there’s a extra
152 00:17:26.656 ⇒ 00:17:32.709 Chuck Gross: extra fee to ship the oversized box like it’s not too oversized where they just say no.
153 00:17:32.769 ⇒ 00:17:44.749 Chuck Gross: but the girth measurements are past the standard shipping rates, so they do charge that they do charge a surcharge. But it seemed like that the surcharge is out of hand right now.
154 00:17:44.850 ⇒ 00:17:46.520 Nicolas Sucari: Yeah, yeah.
155 00:17:46.880 ⇒ 00:17:50.759 Luke Daque: Gotcha, and these are all shopify orders.
156 00:17:51.084 ⇒ 00:18:01.130 Chuck Gross: Some of them may be on Amazon because we were. We tried something where we lowered the price on Amazon to see if the items were actually selling due to price.
157 00:18:01.310 ⇒ 00:18:03.270 Chuck Gross: So they started selling.
158 00:18:03.420 ⇒ 00:18:09.549 Chuck Gross: So we dropped the price, and then it cost more to ship them. So it was like a double. Yeah, it was like a double whammy backwards.
159 00:18:09.770 ⇒ 00:18:11.000 Luke Daque: Yeah, that sucks.
160 00:18:12.180 ⇒ 00:18:12.950 Luke Daque: Yeah, we’ll.
161 00:18:13.120 ⇒ 00:18:19.510 Chuck Gross: I noticed, because we have sand filters and sand filters are inexpensive. You know it’s 5 or 600 bucks.
162 00:18:19.900 ⇒ 00:18:24.520 Chuck Gross: but it costs 200 to ship. So when it’s all said and done, there wasn’t a lot of
163 00:18:24.530 ⇒ 00:18:33.180 Chuck Gross: room for profit. So we dropped the price of 4, 99, and then, of course, $300 to ship it. I was like I could throw it in the garbage keeper. But
164 00:18:33.790 ⇒ 00:18:44.899 Chuck Gross: but that’s a problem. So I but I can send the the last couple of those orders that I noticed, and then maybe we can work. I I would it help if I send the ups bill also that has.
165 00:18:44.900 ⇒ 00:18:45.610 Luke Daque: Oh, yeah.
166 00:18:45.610 ⇒ 00:18:49.880 Chuck Gross: Okay, I can send that because, yeah, the last bill had, like 3 or 4 of them on there.
167 00:18:50.270 ⇒ 00:18:52.450 Luke Daque: Gotcha cool. Sounds good.
168 00:18:52.610 ⇒ 00:18:54.329 Chuck Gross: Okay, okay, that over in a little bit.
169 00:18:55.720 ⇒ 00:18:56.560 Nicolas Sucari: Thank you.
170 00:18:56.560 ⇒ 00:18:58.440 Chuck Gross: Thank you. Chuck. Anytime.
171 00:18:59.430 ⇒ 00:19:00.070 Nicolas Sucari: Hey! Ben!
172 00:19:01.210 ⇒ 00:19:01.760 Luke Daque: Bye.
173 00:19:01.760 ⇒ 00:19:02.690 Chuck Gross: Bye-bye.