Meeting Title: Chuck <> Brainforge - Shipping-Weekly-Meeting Date: 2024-09-12 Meeting participants: Chuck Gross, Nicolas Sucari, Uttam Kumaran
WEBVTT
1 00:02:54.800 ⇒ 00:02:55.729 Nicolas Sucari: Hey, Jim!
2 00:02:58.930 ⇒ 00:03:04.857 Uttam Kumaran: Hey? Yeah, I don’t know. I think, Chuck emailed. I don’t think he’s getting like the zoom links or something. But
3 00:03:05.370 ⇒ 00:03:07.849 Uttam Kumaran: this is the same link, I think, every week. So
4 00:03:08.120 ⇒ 00:03:08.950 Uttam Kumaran: yeah.
5 00:03:23.370 ⇒ 00:03:24.480 Chuck Gross: Hello!
6 00:03:24.930 ⇒ 00:03:25.790 Uttam Kumaran: Hey! Chuck.
7 00:03:26.090 ⇒ 00:03:26.470 Nicolas Sucari: Hey! Jack!
8 00:03:26.470 ⇒ 00:03:27.600 Chuck Gross: Hey! How are you?
9 00:03:27.860 ⇒ 00:03:28.490 Chuck Gross: Good, good.
10 00:03:28.490 ⇒ 00:03:29.789 Uttam Kumaran: Good! How are you?
11 00:03:32.260 ⇒ 00:03:33.340 Nicolas Sucari: All good. Here.
12 00:03:38.680 ⇒ 00:03:40.330 Nicolas Sucari: Been a busy week for you, chuck.
13 00:03:41.450 ⇒ 00:03:49.239 Chuck Gross: Well, I was off this week, but yesterday I actually went up to Connecticut to hang out with Dan and Ben for a little bit to go over some stuff, so that was good.
14 00:03:49.240 ⇒ 00:03:50.200 Nicolas Sucari: Nice.
15 00:03:50.200 ⇒ 00:03:50.680 Chuck Gross: And yeah.
16 00:03:50.680 ⇒ 00:03:51.200 Nicolas Sucari: Sorry, Leo.
17 00:03:51.200 ⇒ 00:03:53.566 Chuck Gross: So I’m hanging out now.
18 00:03:54.040 ⇒ 00:04:00.819 Nicolas Sucari: Yeah, we didn’t. We didn’t knew it was a week off. Let me know if you need to reschedule the meeting or something.
19 00:04:01.070 ⇒ 00:04:08.549 Chuck Gross: Yeah, no worries I I pretty much. Yeah. It’s not a problem. If I if I was going away I would have told you guys, but I’m I’m here. Well, I’m just home.
20 00:04:09.420 ⇒ 00:04:10.070 Nicolas Sucari: Okay.
21 00:04:10.609 ⇒ 00:04:35.340 Nicolas Sucari: okay, cool. Let’s get right to it. Then. So according to the uni stuff without the Po numbers that we are getting. I’m really asked. I already asked Justin to include that again. They told us that since August 26, th when we changed when we migrated from the the old platform connector to the new one we stopped receiving that po number
22 00:04:35.643 ⇒ 00:04:46.700 Nicolas Sucari: in the order when it was created and wise. So yeah, we’re just asking them to include that again, so that we can receive and match the orders we are getting from them to the shopify orders. Okay?
23 00:04:47.170 ⇒ 00:04:48.090 Nicolas Sucari: Oh, that’s.
24 00:04:48.090 ⇒ 00:04:48.730 Chuck Gross: Yeah.
25 00:04:51.280 ⇒ 00:05:01.440 Chuck Gross: Those emails that they’re sending to to see once once they updated as of before. It wasn’t, you know, as of a couple of hours ago it was still showing that improper Po number.
26 00:05:02.200 ⇒ 00:05:12.930 Nicolas Sucari: Yeah, yeah, that’s that’s fine. Yeah, i i i i think we are not gonna receive the po number until they change something again. But receiving that emails for us is super useful because we can
27 00:05:12.950 ⇒ 00:05:35.059 Nicolas Sucari: easily track the new orders from the new facilities. And yeah, we are trying to get pretty accurate on how many orders we’re we are shipping from everywhere. So it would be super useful. So if you have, I think you just emailed us that you’re having some errors when you’re trying to forward automatically forward or set up that forward emails.
28 00:05:35.080 ⇒ 00:05:38.389 Nicolas Sucari: let me know if you need any help, and we can go through it. Okay.
29 00:05:38.900 ⇒ 00:05:49.259 Chuck Gross: No problem. Yeah, I’m gonna try again a little bit. It was the Google authentication error. So I was trying to log into my account, and it was giving me, you know, stupid error. So I’ll I’ll just try it again in a couple of hours.
30 00:05:50.210 ⇒ 00:05:51.450 Chuck Gross: Yeah, perfect.
31 00:05:51.600 ⇒ 00:05:52.490 Nicolas Sucari: Okay.
32 00:05:52.920 ⇒ 00:06:06.040 Nicolas Sucari: excellent. Okay. So that’s that’s covered for now. According the tax mapping issue, we contacted Pamela, and we are gonna set up a meeting with her next week
33 00:06:06.130 ⇒ 00:06:13.630 Nicolas Sucari: to talk about that a little bit. I don’t think, yeah. She told us that she’s not using 0 for the tax
34 00:06:13.680 ⇒ 00:06:18.339 Nicolas Sucari: for creating the tax rates. She’s just doing it at shopify Amazon.
35 00:06:18.776 ⇒ 00:06:40.259 Nicolas Sucari: And then, yeah, just paying what it needs to be paid. So yeah, I ideally. We’ll meet with her next week and try to understand a little bit more about that process and and see where we are getting an issue on on the unleashed side. What? My! My question there is what is like the the block
36 00:06:40.740 ⇒ 00:06:45.270 Nicolas Sucari: stuff that we are getting when we don’t have like that tax Id set up.
37 00:06:45.590 ⇒ 00:06:49.450 Nicolas Sucari: You cannot like close the orders or what is happening.
38 00:06:49.950 ⇒ 00:07:01.870 Chuck Gross: Yeah, in just in unleash. Those orders remain open so they can never be completed because unleashed can’t associate that tax rate with that with anything.
39 00:07:01.920 ⇒ 00:07:11.602 Chuck Gross: So when you look up, when you look up active inventory, there is a column that says, you know, total inventory. Then it says,
40 00:07:12.280 ⇒ 00:07:18.840 Chuck Gross: it doesn’t say withheld. There’s another column there. It says whatever it says, and then there’s on hand like available inventory.
41 00:07:20.040 ⇒ 00:07:32.239 Chuck Gross: So instead of it, just closing on having a constant inventory number. There’s 2 different inventory levels. There’s a you know, the the total inventory, and then the available. The available is what’s really, you know, on hands.
42 00:07:34.490 ⇒ 00:07:41.190 Nicolas Sucari: Okay, but it’s not something that is messing up with the shipping or anything with the product reaching the customer right.
43 00:07:41.570 ⇒ 00:07:59.910 Chuck Gross: Correct. No, no, it doesn’t. It doesn’t actually really affect anything except for completing those orders in unleashed. So they just show that they’re open. It’s just, you know, it’s more cumbersome than anything, because it just continues to show certain orders open. You know this, the 2 different inventory numbers.
44 00:08:00.380 ⇒ 00:08:12.239 Nicolas Sucari: Okay, okay, yeah, perfect. I think we can talk with her. See? What’s what needs to be done so that we can. Yeah, map that tax rates in an unleashed and try to close those those orders. Okay.
45 00:08:12.660 ⇒ 00:08:13.450 Chuck Gross: Okay.
46 00:08:14.260 ⇒ 00:08:24.719 Nicolas Sucari: Yeah. And then I think the other thing that we’ve been working on. I think, utan you were trying to figure out how to create that map graph.
47 00:08:26.090 ⇒ 00:08:27.270 Nicolas Sucari: I think you were.
48 00:08:27.270 ⇒ 00:08:27.680 Uttam Kumaran: Yes.
49 00:08:27.680 ⇒ 00:08:28.620 Nicolas Sucari: Things.
50 00:08:28.780 ⇒ 00:08:30.100 Nicolas Sucari: evidence, no.
51 00:08:30.550 ⇒ 00:08:39.660 Uttam Kumaran: No, yeah, I was using something else. Yeah, we basically we took a stab at it. I think I probably know. Still need to try a couple of things. Basically, what I wanted to do is buy zip code.
52 00:08:39.780 ⇒ 00:08:53.690 Uttam Kumaran: Basically, we have the distance between every zip code and the zip codes of the warehouses. And then we’re basically going to do coloring. That’s like which places should get shipped from where based on the distance.
53 00:08:53.870 ⇒ 00:08:54.475 Uttam Kumaran: Okay,
54 00:08:55.520 ⇒ 00:09:01.900 Uttam Kumaran: which is kind of like what you asked for right? Like we we don’t have like the how much time it takes. I mean, we we do have it, but
55 00:09:01.950 ⇒ 00:09:04.140 Uttam Kumaran: it’s it’s more of like a graph of like
56 00:09:04.290 ⇒ 00:09:07.549 Uttam Kumaran: by zip code. What’s the closest
57 00:09:08.340 ⇒ 00:09:09.410 Uttam Kumaran: warehouse.
58 00:09:09.800 ⇒ 00:09:16.249 Chuck Gross: Right? Yeah. Some something like that would be good. Because can you show like, say, from each
59 00:09:16.660 ⇒ 00:09:21.739 Chuck Gross: warehouse like, what would be like the zone, one and zone 2 from that.
60 00:09:22.170 ⇒ 00:09:22.930 Chuck Gross: Yeah.
61 00:09:22.930 ⇒ 00:09:30.530 Uttam Kumaran: So we can do so we can do that. We can do that as well. So we’ll do yeah. So we’ll we’ll. That’s actually a good point. So I’ll actually layer on.
62 00:09:30.640 ⇒ 00:09:33.159 Uttam Kumaran: First, st we’ll start by just like which of the closest
63 00:09:33.320 ⇒ 00:09:38.660 Uttam Kumaran: zip, and then we can also have it, basically a table, or something which is like
64 00:09:38.840 ⇒ 00:09:42.709 Uttam Kumaran: from the closest zip. What zone is it? Right? That’s kind of it.
65 00:09:43.040 ⇒ 00:10:12.560 Chuck Gross: Right? Yeah. So then we can say, you know, arguments take zone, one is one to 2 days, zone, 2 is 2 to 3 days, and then zone 3, which would be like Montana. Washington state whatever you say, like 5. Just so we can give the customers, you know, a good estimated shipping time. Obviously, it’s not an exact exact science. But if they know they order today, they’re gonna you know, get their items in one to 2 days. They’re fine, and they don’t email in and have to be handled by customer service agents.
66 00:10:13.160 ⇒ 00:10:13.810 Uttam Kumaran: Yeah, okay.
67 00:10:13.810 ⇒ 00:10:19.829 Chuck Gross: Trying to eliminate a lot of those emails. We’re great because we’re getting a lot of them now because they buy it from
68 00:10:19.870 ⇒ 00:10:25.997 Chuck Gross: California. They get it the next day, when they’re actually expecting it 7 days later, because they’re on vacation.
69 00:10:26.320 ⇒ 00:10:27.650 Uttam Kumaran: Yeah, okay, makes sense.
70 00:10:27.857 ⇒ 00:10:31.799 Chuck Gross: Yeah, it’s it’s funny, because it’s like, it’s like the opposite problem, like, it starts getting there too quick.
71 00:10:31.800 ⇒ 00:10:32.470 Uttam Kumaran: Yeah.
72 00:10:32.840 ⇒ 00:10:34.066 Uttam Kumaran: yeah, yeah.
73 00:10:35.060 ⇒ 00:10:48.669 Chuck Gross: That that 1st I didn’t really see the problem with it. But then, when you know like that, yeah, and I’m like, you know what I guess that is kind of a problem if you’re trying to. You’re being proactive to say, oh, I need it next week. So I’ll order today and then shows up to your house tomorrow, and
74 00:10:48.700 ⇒ 00:10:50.940 Chuck Gross: I guess it could be a problem so makes sense.
75 00:10:50.940 ⇒ 00:10:51.849 Uttam Kumaran: Yeah, okay.
76 00:10:55.100 ⇒ 00:10:56.633 Nicolas Sucari: Okay? Great.
77 00:10:57.550 ⇒ 00:11:03.599 Nicolas Sucari: yeah. I don’t think we have like any other thing right now. We are still working on
78 00:11:04.035 ⇒ 00:11:13.320 Nicolas Sucari: that order from Unis, and once we figure that out and we have everything together, we will add that to the real dashboards that I shared Chuck. I don’t know if you were.
79 00:11:13.320 ⇒ 00:11:14.440 Chuck Gross: Yeah.
80 00:11:15.220 ⇒ 00:11:21.970 Chuck Gross: yeah. Yeah. I wrote them last week that they look good. They’re they’re easy to read. They’re they’re very yeah. But there’s a lot of good information there.
81 00:11:22.770 ⇒ 00:11:23.390 Chuck Gross: Yeah.
82 00:11:23.660 ⇒ 00:11:24.210 Nicolas Sucari: Using Nicola.
83 00:11:24.210 ⇒ 00:11:29.720 Uttam Kumaran: So let’s figure out the Po stuff. Yeah, I saw you replied. Anyways to Justin. But yeah.
84 00:11:30.520 ⇒ 00:11:50.459 Nicolas Sucari: Yeah, once we figure that out, I think we can include that into the dashboards. And yeah, and we can distinguish which warehouse we are shipping from, and that will have, like the complete information. And we can then start working on having, like a different dashboard, to just compare performances on each warehouse.
85 00:11:51.330 ⇒ 00:12:01.210 Nicolas Sucari: But for now it’s just adding that into real having all of the information on the different shipping warehouses. And yeah, that will that will be it.
86 00:12:03.370 ⇒ 00:12:05.280 Chuck Gross: Okay, that sounds good. Sounds good.
87 00:12:06.830 ⇒ 00:12:13.929 Nicolas Sucari: If if you find anything that you or if you don’t find anything on on rail that you would like to see, let us know. And we can also
88 00:12:14.353 ⇒ 00:12:19.076 Nicolas Sucari: try to take a look and see how we can include more stuff.
89 00:12:19.500 ⇒ 00:12:20.633 Nicolas Sucari: and yeah,
90 00:12:21.350 ⇒ 00:12:32.089 Nicolas Sucari: Apart from that, I would like to ask if you were able to check that file for the purchase orders analysis that you requested a couple of weeks ago. If you need anything else on that side also, let us know.
91 00:12:32.460 ⇒ 00:12:41.379 Chuck Gross: Yeah, perfect. No, that that that. That final sheet was actually like, perfect, exactly what we needed. So I’m gonna work that up next week, so we can start placing orders. That’s
92 00:12:41.900 ⇒ 00:12:44.409 Chuck Gross: that that worked out very well. I appreciate that one.
93 00:12:44.950 ⇒ 00:12:46.689 Nicolas Sucari: Excellent. Thank you.
94 00:12:47.270 ⇒ 00:12:54.220 Chuck Gross: And all the the all the tagging to and ship station seems to be solved, like, you know, I keep tracking them, but that that seems to be
95 00:12:54.350 ⇒ 00:12:56.050 Chuck Gross: good to go to. Oh.
96 00:12:56.970 ⇒ 00:13:00.790 Nicolas Sucari: Yeah, we I forgot about that one. We prepared some.
97 00:13:00.790 ⇒ 00:13:02.430 Uttam Kumaran: Oh, yeah, we yeah, let’s yeah. Let’s go.
98 00:13:02.430 ⇒ 00:13:02.750 Nicolas Sucari: That.
99 00:13:02.750 ⇒ 00:13:06.180 Uttam Kumaran: If you want. Maybe if you want to walk through that, yeah, sure, that’s good thing.
100 00:13:06.180 ⇒ 00:13:06.790 Nicolas Sucari: Yeah.
101 00:13:06.790 ⇒ 00:13:07.679 Uttam Kumaran: Explain that.
102 00:13:08.110 ⇒ 00:13:08.840 Uttam Kumaran: Yeah.
103 00:13:08.840 ⇒ 00:13:12.009 Nicolas Sucari: Let me share. And yeah, I was forgetting about that one.
104 00:13:13.465 ⇒ 00:13:15.700 Nicolas Sucari: He’s he’s figma.
105 00:13:17.500 ⇒ 00:13:18.700 Nicolas Sucari: And here.
106 00:13:19.980 ⇒ 00:13:21.900 Nicolas Sucari: do you want to go through it? Autumn.
107 00:13:23.000 ⇒ 00:13:26.053 Uttam Kumaran: Yeah, sure. So chuck, we just
108 00:13:26.630 ⇒ 00:13:29.760 Uttam Kumaran: we just kind of like, did a little bit of like a
109 00:13:31.650 ⇒ 00:13:36.400 Uttam Kumaran: basically, what did an overview for the team internally about how our tag team process works.
110 00:13:36.810 ⇒ 00:14:04.119 Uttam Kumaran: Now that things are settled. But I kind of wanted to go through with you as well. And you know, we created this diagram which you should be able to use. So basically, we have shopify. We we have like a web hook. Currently, basically, an event fires to a platform called windmill whenever an order is created in windmill, we get an input with basically all the order details. So not only order id, but like shipping and billing, address all that stuff.
111 00:14:04.430 ⇒ 00:14:16.159 Uttam Kumaran: we have a python script that basically takes in now the shipping address and then takes in the Zip code and then basically makes a decision on like, okay, what is the string? The tag that we need to attach.
112 00:14:16.230 ⇒ 00:14:20.629 Uttam Kumaran: Once that gets decided. We then make a Api request back to shopify
113 00:14:20.680 ⇒ 00:14:23.800 Uttam Kumaran: on this tags add function to basically add the tag.
114 00:14:23.840 ⇒ 00:14:39.249 Uttam Kumaran: The Api request happens. We? It’s a Graphql request. It hits, shopify, and then, of course, shopify that tag gets put into the custom field to within ship station. We have those 3 rules in ship station that basically say, if it’s
115 00:14:39.500 ⇒ 00:14:54.140 Uttam Kumaran: if it’s a unit, Florida, if it’s Unis Texas, and it’s 1 of the skews, then tag it as a unit shipments tag. And then, of course, like that, that gets leveraged, basically that you don’t import it. And you don’t ship it
116 00:14:55.550 ⇒ 00:15:01.099 Uttam Kumaran: And so yeah, I I ran through that process pretty quickly, but this took a ton of time to figure out. But.
117 00:15:01.338 ⇒ 00:15:07.059 Chuck Gross: No worries, I mean, yeah, no. That process. Yeah. That was a good way to show it makes it makes perfect sense to me.
118 00:15:07.840 ⇒ 00:15:33.179 Uttam Kumaran: Okay, yeah, just in case we need it for more changes. But now that it’s working, the nice thing is also, now that we have access to the web hook and have access to updating shopify’s Api. We can now do this for anything like if we need any sort of automations where we’re like, Hey, on order, creation. Can you tag these, or can you modify this? If this happens like, I know you had another request which is like
119 00:15:33.180 ⇒ 00:15:40.730 Uttam Kumaran: Mark. I forgot. I actually have to look into my slack, which is like mark things as fraud, or make sure people don’t order things with like 0
120 00:15:40.830 ⇒ 00:15:43.280 Uttam Kumaran: they like. If anything like that comes up. We now
121 00:15:43.730 ⇒ 00:15:45.020 Uttam Kumaran: to make those changes.
122 00:15:45.340 ⇒ 00:15:46.310 Chuck Gross: Okay. Cool.
123 00:15:49.610 ⇒ 00:15:50.930 Uttam Kumaran: Yeah, I think that’s the biggest thing.
124 00:15:50.930 ⇒ 00:15:52.020 Chuck Gross: Okay. Yup.
125 00:15:55.040 ⇒ 00:16:09.370 Nicolas Sucari: Yeah, perfect. Yeah, I can send these as a picture, or I can add that into the notion, so that we can have this image there, for every every time we need to check something. But yeah, apart from that, I don’t think we have anything else for now.
126 00:16:12.190 ⇒ 00:16:15.129 Chuck Gross: Okay, yeah, that’s that’s everything I had, too. So sounds good.
127 00:16:16.230 ⇒ 00:16:16.690 Uttam Kumaran: Okay.
128 00:16:16.690 ⇒ 00:16:18.190 Nicolas Sucari: Excellent.
129 00:16:19.020 ⇒ 00:16:22.829 Nicolas Sucari: Well, thank you very much. Chuck, have a great weekend, and let’s talk next week. Okay.
130 00:16:23.460 ⇒ 00:16:25.500 Chuck Gross: Sounds good. Take care, have a good weekend.
131 00:16:26.060 ⇒ 00:16:26.599 Uttam Kumaran: Thanks guys.
132 00:16:26.600 ⇒ 00:16:27.600 Nicolas Sucari: I said, Well.
133 00:16:27.600 ⇒ 00:16:28.320 Chuck Gross: Hey!