Meeting Title: Eden Health Pharmacy Data Mapping Sync Date: 2026-02-24 Meeting participants: Fireflies.ai Notetaker Katie, Amber Lin, Katie Kramer, Brad Messersmith
WEBVTT
1 00:04:58.310 ⇒ 00:04:59.530 Amber Lin: Hi, Katie.
2 00:04:59.760 ⇒ 00:05:01.560 Katie Kramer: Hi, Amber, how you doing?
3 00:05:01.910 ⇒ 00:05:02.910 Amber Lin: Doing well.
4 00:05:03.230 ⇒ 00:05:05.849 Amber Lin: One sec, let me grab my headphones.
5 00:05:06.170 ⇒ 00:05:07.290 Katie Kramer: No worries.
6 00:05:12.840 ⇒ 00:05:16.469 Amber Lin: Are you based in the East Coast? What time is it for you?
7 00:05:16.640 ⇒ 00:05:21.940 Katie Kramer: 11am, I’m in Michigan, so, like, same time zone as Bernard and everything.
8 00:05:21.940 ⇒ 00:05:23.800 Amber Lin: Cool, that’s awesome.
9 00:05:23.800 ⇒ 00:05:24.570 Katie Kramer: Where are you at?
10 00:05:24.570 ⇒ 00:05:32.259 Amber Lin: I’m in LA, so every day I wake up, I was like, you know, I wish I was in EST, so maybe it’s gonna be later.
11 00:05:32.260 ⇒ 00:05:38.070 Katie Kramer: Honestly, I have no intention of moving out of ESC with this job, because it just makes me so much.
12 00:05:38.570 ⇒ 00:05:43.360 Katie Kramer: I would wake up halfway through the day if I was in West Coast time.
13 00:05:46.430 ⇒ 00:05:47.470 Amber Lin: Hi, Brad!
14 00:05:47.470 ⇒ 00:05:48.930 Brad Messersmith: Hey, happy Monday!
15 00:05:49.110 ⇒ 00:05:50.149 Brad Messersmith: How’s it going?
16 00:05:50.150 ⇒ 00:05:51.939 Katie Kramer: It’s too many books.
17 00:05:52.420 ⇒ 00:05:56.070 Katie Kramer: Oh, God. I wish it was, Friday.
18 00:05:56.170 ⇒ 00:05:57.110 Brad Messersmith: That’s so…
19 00:05:57.110 ⇒ 00:05:58.510 Katie Kramer: Accurate, though.
20 00:05:58.510 ⇒ 00:05:59.289 Brad Messersmith: I know.
21 00:05:59.500 ⇒ 00:06:00.440 Brad Messersmith: Monday.
22 00:06:00.440 ⇒ 00:06:02.500 Katie Kramer: Yeah, it does.
23 00:06:02.500 ⇒ 00:06:07.520 Brad Messersmith: I’m tripping. Man, the message you sent got me super excited. Amber, you wanna take…
24 00:06:07.520 ⇒ 00:06:16.400 Amber Lin: Yeah, I counted how many exclamation marks I wrote initially and deleted all of them. I was like, I can’t send this type of message.
25 00:06:16.400 ⇒ 00:06:19.419 Brad Messersmith: We’ve been messing with this vial size thing for so long, so…
26 00:06:19.420 ⇒ 00:06:20.300 Amber Lin: I know.
27 00:06:20.300 ⇒ 00:06:22.989 Brad Messersmith: Maybe even a glimmer of hope here is awesome.
28 00:06:23.340 ⇒ 00:06:38.710 Amber Lin: Yeah, even when I was, still project managing on Eden, like, I know we were asking Basque for almost a year now. We started when I joined, so, I can… I can walk you through how we did it. So, for example.
29 00:06:38.980 ⇒ 00:06:58.379 Amber Lin: I think last time we talked, I showed you this, which is just product names, blah blah blah. And then, I was like, it would be very, very hard to understand vial size from this, and even, we can’t really search in BASC, because BASC uses a different name.
30 00:06:58.690 ⇒ 00:07:12.030 Amber Lin: So, what I did was I got, the variant ID, I think the BASC order ID from a lot of sample orders, and I made a link through them, so…
31 00:07:12.500 ⇒ 00:07:15.599 Amber Lin: Like, for example, we would…
32 00:07:15.980 ⇒ 00:07:21.550 Amber Lin: Go to something, and then click on… the link.
33 00:07:21.800 ⇒ 00:07:33.790 Amber Lin: And then that would lead us to… for example, this is a sample order, and then this would be… I’m just first confirming, this would be where we find the file size, correct?
34 00:07:34.220 ⇒ 00:07:35.010 Katie Kramer: Yes.
35 00:07:35.220 ⇒ 00:07:41.150 Amber Lin: Awesome, okay. So, I checked a lot of orders, I think the links are mostly accurate.
36 00:07:41.540 ⇒ 00:07:55.770 Amber Lin: So, now we have all these links. I asked my team, say, hey, having to click into this, each one, and copy and paste is a lot of work. Can you scrape this for me? So, what my team did,
37 00:07:56.190 ⇒ 00:07:57.190 Amber Lin: I think.
38 00:07:57.460 ⇒ 00:08:17.009 Amber Lin: So, what they were able to do is they took… they only did the first link, because this was a test, and they… I asked them to scrape the order details section. So, right now, it’s dumped all together. I do think I can ask them to separate it out. So, it has the product name, and I think this…
39 00:08:17.190 ⇒ 00:08:20.289 Amber Lin: Specific name for,
40 00:08:20.660 ⇒ 00:08:30.280 Amber Lin: like, the pharmacy product they chose to use, I’m not exactly sure, because there’s so many different product namings. But using that, I was able to…
41 00:08:31.050 ⇒ 00:08:43.899 Amber Lin: Let’s see… I was able to find something that matched, this name, and then the same, file size. So I took what you gave me in the pricing, and I…
42 00:08:44.100 ⇒ 00:08:49.349 Amber Lin: Copy and pasted them, at, on the right.
43 00:08:49.510 ⇒ 00:09:04.129 Amber Lin: So, I was actually able to match most of them, except for a few, which I believe is using older products. So, that’s my second question. For example, this one that says semaglutide.
44 00:09:04.450 ⇒ 00:09:14.139 Amber Lin: 9 milligrams. Or, for example, this one that says niacinamide and semaglutide. Or, say, this one that says, that’s the same thing. So.
45 00:09:14.640 ⇒ 00:09:17.599 Amber Lin: My question is, we don’t have pricing for these.
46 00:09:17.810 ⇒ 00:09:24.440 Amber Lin: what should I do? Or what should we do when, it’s no longer in the pricing sheet?
47 00:09:26.450 ⇒ 00:09:38.390 Brad Messersmith: I think these are the gaps, probably, that we need to fill in. However, I will say that probably a good majority of what’s in here is actually going to be obsolete.
48 00:09:38.600 ⇒ 00:09:50.560 Brad Messersmith: So I think probably what Katie and I or our team can do first is go through here and just mark obsolete the ones that are obviously very unlikely to get used again.
49 00:09:51.530 ⇒ 00:09:57.619 Brad Messersmith: And then, from there, if there’s any that still don’t have pricing, I’m guessing…
50 00:09:57.790 ⇒ 00:10:04.980 Brad Messersmith: Like, if you took… if we could, you know, magically wave a wand and map our volume by SKU here…
51 00:10:05.150 ⇒ 00:10:07.159 Brad Messersmith: You would see that things that haven’t.
52 00:10:07.160 ⇒ 00:10:07.550 Amber Lin: Right.
53 00:10:07.550 ⇒ 00:10:25.190 Brad Messersmith: are likely to be 99.9% of it, I’m guessing. So, we’ll need some time to make sure that that’s the case, probably, but I can almost say with certainty that, I mean, just from looking at this data in the past, there’s probably 50% of it that’s just obsolete.
54 00:10:25.260 ⇒ 00:10:31.990 Brad Messersmith: old stuff. And we might not even have pricing, or have a way to look back and figure out…
55 00:10:31.990 ⇒ 00:10:48.050 Amber Lin: Gotcha. So, I think for, Absolute, these should be the ones that don’t have pricing. They’re either the niacinamide and semi ones, or the just purely semaglutide and not the semaglutide slash,
56 00:10:48.540 ⇒ 00:10:51.280 Amber Lin: The… the other drug combined together.
57 00:10:51.280 ⇒ 00:10:56.579 Brad Messersmith: I think probably could be conventional… is that conventional dosing, the 9 milligram, Katie?
58 00:10:58.580 ⇒ 00:11:01.179 Katie Kramer: I think so. Actually, ways…
59 00:11:01.180 ⇒ 00:11:01.800 Amber Lin: There’s upside?
60 00:11:01.800 ⇒ 00:11:03.949 Katie Kramer: or semaglutide, because if it’s semaglutide, yes.
61 00:11:04.450 ⇒ 00:11:16.120 Amber Lin: Yeah, there’s SEMA 9 milligrams, and there’s SEMA 12.5. I think there’s… I think this is the old dosage, because they also follow a scale.
62 00:11:18.290 ⇒ 00:11:20.069 Amber Lin: The highlighted ones over here.
63 00:11:20.070 ⇒ 00:11:26.510 Katie Kramer: No… That’s… 0.9 is gonna be month 2, week 3, and 4’s dose.
64 00:11:27.010 ⇒ 00:11:35.049 Katie Kramer: 0.9 milligrams. I would need to look into this a little bit further to know for sure, but this is something that, like Brad said, we could go through.
65 00:11:35.560 ⇒ 00:11:40.940 Amber Lin: Sounds good. So… This is my test for…
66 00:11:41.060 ⇒ 00:11:47.379 Amber Lin: Absolute Pharmacy, and what I was thinking we… what we can do with this is…
67 00:11:47.380 ⇒ 00:12:01.789 Amber Lin: Now that I have that, I took the… took the mappings, because this is by variant ID, so that’s something concrete that we can match in our database. So I took that, and I was able to get… this is for 2026,
68 00:12:03.790 ⇒ 00:12:12.659 Amber Lin: I got the order total, the quantity, I think the number of orders I have, and then I have…
69 00:12:16.760 ⇒ 00:12:30.989 Amber Lin: average order value, and using that, I was able to calculate a rough… a rough COGS. This is… I don’t think it’s completely accurate, because I haven’t QA’d how many orders were… were included,
70 00:12:31.250 ⇒ 00:12:36.469 Amber Lin: But roughly, I think this is what we’ll be able to do now that we have
71 00:12:36.630 ⇒ 00:12:47.620 Amber Lin: it mapped, because I know, like, COGS is your goal, I believe, this year, to reduce it below 30%. So I just highlighted the stuff that is above 30%,
72 00:12:47.750 ⇒ 00:12:59.430 Amber Lin: And if we’re able to do this for multiple pharmacies, I think we can start to see a trend and start to see where we can work on to, to achieve that goal.
73 00:12:59.830 ⇒ 00:13:03.120 Brad Messersmith: Yeah, that’s perfect. The goal is actually 40%.
74 00:13:03.120 ⇒ 00:13:03.870 Amber Lin: Okay.
75 00:13:03.920 ⇒ 00:13:12.409 Brad Messersmith: You know, I kind of, in my mind, think maybe 30% or so could be possible, but for now, 40% is kind of where we’re floating, so…
76 00:13:12.410 ⇒ 00:13:13.060 Amber Lin: Yeah.
77 00:13:13.060 ⇒ 00:13:32.130 Brad Messersmith: target. But yeah, this is great. I mean, you’re going exactly the place in my head that I was trying to go. Once we get all this data mapped, it should be pretty straightforward. Really, I would like to build the baseline data that we need for a forecast in a dashboard, and with this info, it should be fairly straightforward, I’m thinking.
78 00:13:32.130 ⇒ 00:13:49.769 Amber Lin: Yeah, yeah, and if we were able to have this pricing for, the mapping… the pricing mapping for all of the at least, active variant IDs, our team can build the dashboard for you. So, right now, we can’t do it, because we… we only have
79 00:13:49.910 ⇒ 00:13:51.890 Amber Lin: Like, transaction overall COGS.
80 00:13:51.890 ⇒ 00:13:53.200 Brad Messersmith: Yeah, the mapping.
81 00:13:53.380 ⇒ 00:13:53.790 Amber Lin: Yeah.
82 00:13:53.790 ⇒ 00:13:59.850 Brad Messersmith: That’s good. So then, what would it take you to get this list for the other pharmacies, or for all of them? For everything?
83 00:13:59.850 ⇒ 00:14:13.799 Amber Lin: Yeah, so this is where I might… I will need your team’s help. My team can scrape, scrape this for more pharmacies right now. I think I also asked them to do…
84 00:14:13.960 ⇒ 00:14:16.650 Amber Lin: Booth win, but…
85 00:14:17.100 ⇒ 00:14:36.739 Amber Lin: like, when we’ll be able to produce this, and I can ask them to clean it up to separate these, two fields, because I think it’s important to see what the product actually is called, and then what pharmacy product they use. So, once my team gets that, I might need help for you to…
86 00:14:36.770 ⇒ 00:14:41.400 Amber Lin: So for someone to copy and…
87 00:14:42.710 ⇒ 00:14:59.990 Amber Lin: So for someone to read, say, this little section, and say, okay, this is… this is this line in the pricing sheet, do you think that’s achievable? Just… just pasting… I just pasted the line of what I think was a matching thing, and then…
88 00:15:00.360 ⇒ 00:15:04.880 Amber Lin: You can always note down, like, oh, this is obsolete, we don’t need this anymore.
89 00:15:06.070 ⇒ 00:15:13.049 Brad Messersmith: Yeah, yeah, definitely. So, there’s kind of two thoughts here. Typically, when I’ve gone through this exercise before in the past.
90 00:15:13.230 ⇒ 00:15:26.560 Brad Messersmith: we… yes, we will definitely do this. It’s very difficult for us to go, like, line by line and capture everything, so typically what happens, in my experience, is once we build the reporting and start using some of the dashboards.
91 00:15:26.570 ⇒ 00:15:41.689 Brad Messersmith: it’ll become clear if we made errors, typically, from there. But yeah, I mean, what we’ll do is go through as many of these as we can and just verify that it looks like it was mapped correctly with what you’ve done here, and then anything missing that’s not obsolete will
92 00:15:41.860 ⇒ 00:15:44.190 Brad Messersmith: We can, pull in.
93 00:15:45.240 ⇒ 00:15:54.270 Amber Lin: I see. Would you… so, you’re saying you would like our team to do this initial mapping first, or, how would it work?
94 00:15:55.090 ⇒ 00:16:00.360 Brad Messersmith: Sorry, maybe I misunderstood. I thought this was done…
95 00:16:00.530 ⇒ 00:16:02.509 Brad Messersmith: Did you do this manually? Like, pulling.
96 00:16:02.510 ⇒ 00:16:18.899 Amber Lin: We got this. This is from… we got this from BAS automatically, but you see this section? It doesn’t match up always completely what we have here. So, it was very hard to, map it
97 00:16:19.140 ⇒ 00:16:22.369 Amber Lin: Automatically. I can I can ask the team what they.
98 00:16:22.370 ⇒ 00:16:23.030 Brad Messersmith: can do.
99 00:16:23.340 ⇒ 00:16:23.830 Brad Messersmith: Right.
100 00:16:23.830 ⇒ 00:16:31.849 Amber Lin: Yeah, I can see what they can do, because I’m not completely familiar with how maybe they can match this section, and then…
101 00:16:32.140 ⇒ 00:16:35.450 Amber Lin: Find something here that matches.
102 00:16:37.450 ⇒ 00:16:39.790 Brad Messersmith: It’s all of the…
103 00:16:40.180 ⇒ 00:16:45.689 Brad Messersmith: All of the actual, like, way it’s written from the different pharmacies and in the data is different for each one.
104 00:16:45.690 ⇒ 00:16:46.330 Amber Lin: Yeah.
105 00:16:46.330 ⇒ 00:16:49.949 Brad Messersmith: Seems unlikely that it’ll… it’ll happen naturally, but…
106 00:16:50.100 ⇒ 00:16:58.500 Brad Messersmith: We can do that, I think. There’s probably 8 pharmacies, and for each… most of the pharmacies, there… it’ll take us some time, depending on how long this list is, too, so…
107 00:16:59.170 ⇒ 00:17:02.549 Brad Messersmith: If we’re gonna do it, I’d rather just do it for the whole thing, and then…
108 00:17:02.550 ⇒ 00:17:15.230 Amber Lin: Yeah, totally. I can ask them to scrape it for all the pharmacies. If, for example, Boothwin is a lot longer. I think Boothwin has 100-something lines. Absolute had, like, 90-ish.
109 00:17:15.480 ⇒ 00:17:25.060 Amber Lin: So let me scrape that, see what the workload is like, and I’ll send it to you guys, and you can give me an estimate when that would be.
110 00:17:26.839 ⇒ 00:17:36.820 Amber Lin: I’ll also ask them if they can help, if there’s any way to do a preliminary match, because then you can review this and say, okay, this is something else.
111 00:17:37.750 ⇒ 00:17:44.379 Brad Messersmith: Yeah. When you have them scrape, can you have them scrape for just orders?
112 00:17:44.540 ⇒ 00:17:48.450 Brad Messersmith: Is it by order, or how… how are they getting into that screen? Those are the links.
113 00:17:48.450 ⇒ 00:17:50.300 Amber Lin: These are the order links.
114 00:17:50.300 ⇒ 00:17:50.910 Brad Messersmith: Yeah.
115 00:17:51.330 ⇒ 00:17:58.019 Brad Messersmith: So, this data, the easier way to do this, I think this data is already in some of our exports.
116 00:17:59.550 ⇒ 00:18:00.600 Brad Messersmith: Let me just look.
117 00:18:10.870 ⇒ 00:18:13.929 Brad Messersmith: Oh, it doesn’t have the vial size, though. Yeah, that’s right.
118 00:18:13.930 ⇒ 00:18:14.720 Amber Lin: Yeah.
119 00:18:15.410 ⇒ 00:18:18.370 Brad Messersmith: Okay, yeah, so basically, what I was gonna say was…
120 00:18:18.630 ⇒ 00:18:22.019 Brad Messersmith: If you can have them scrape to a specific date.
121 00:18:22.240 ⇒ 00:18:30.270 Brad Messersmith: Anything after… probably, I don’t know, August 1st? What do you think, Katie? What should the cutoff be? But anything after that will be a lot shorter list.
122 00:18:30.410 ⇒ 00:18:32.930 Brad Messersmith: And more current info.
123 00:18:33.070 ⇒ 00:18:38.590 Brad Messersmith: Prior to that, there was a lot of conventional kind of stuff, and other things, stuff we don’t use anymore.
124 00:18:39.010 ⇒ 00:18:49.839 Amber Lin: Okay, so products, then some products wouldn’t have order links. Is that okay? If… that means we might not be able to backfill, some orders?
125 00:18:50.910 ⇒ 00:19:01.470 Brad Messersmith: Yeah, basically, anything prior to that that isn’t still running, like, after August 1st, should be obsolete, is kind of where I’m coming from.
126 00:19:01.590 ⇒ 00:19:02.469 Brad Messersmith: So, like, those…
127 00:19:02.470 ⇒ 00:19:03.170 Amber Lin: Gotcha, okay.
128 00:19:03.170 ⇒ 00:19:07.510 Brad Messersmith: Won’t need any of the order links, won’t need pricing, won’t need any of that stuff, right?
129 00:19:08.970 ⇒ 00:19:13.639 Amber Lin: Okay, so I can… I can do the links again, and then send it to…
130 00:19:13.910 ⇒ 00:19:17.140 Amber Lin: team, and then I’ll have them…
131 00:19:17.500 ⇒ 00:19:20.729 Amber Lin: Scrape and check. I do think, like,
132 00:19:21.040 ⇒ 00:19:27.600 Amber Lin: Boothwin would be the biggest one. The other ones, should be a lot easier to do.
133 00:19:27.600 ⇒ 00:19:32.850 Katie Kramer: And speaking of booth, when we don’t… we’re not partnered with them right now, we don’t have any active products.
134 00:19:33.380 ⇒ 00:19:40.039 Katie Kramer: And if we were to restart with them, it would be, likely a whole new subset of
135 00:19:40.680 ⇒ 00:19:51.690 Katie Kramer: like, products and all of that kind of stuff. So it, to me, feels safe to say Boothwin is obsolete on anything that you have. Those are also going to be conventional dosing right now.
136 00:19:52.120 ⇒ 00:19:52.550 Amber Lin: Gotcha.
137 00:19:52.550 ⇒ 00:19:53.950 Katie Kramer: personalized.
138 00:19:54.000 ⇒ 00:19:54.900 Amber Lin: Okay.
139 00:19:54.900 ⇒ 00:19:58.859 Katie Kramer: And the switch to personalization happened last May.
140 00:19:59.060 ⇒ 00:20:01.920 Katie Kramer: But, like, Brad said, if it’s…
141 00:20:02.270 ⇒ 00:20:08.899 Katie Kramer: April, I mean, August and beyond, then we’re still using it, and if it was before that, it’s likely something else.
142 00:20:09.520 ⇒ 00:20:10.200 Amber Lin: Okay.
143 00:20:10.990 ⇒ 00:20:27.240 Katie Kramer: The only other thing that I have on the top of my head is the, the pharmacy Hub. They have a couple of products that are obsolete now. It’s Olympia, and then if you see an ANVX, all of those products are obsolete. They only use VitalRx now.
144 00:20:28.220 ⇒ 00:20:29.880 Amber Lin: A MVXR.
145 00:20:29.880 ⇒ 00:20:34.709 Katie Kramer: So those are the things that I would look for when scanning through them, but if you’re seeing it as well, I wanted to let you know.
146 00:20:35.140 ⇒ 00:20:37.240 Amber Lin: Gotcha, okay.
147 00:20:38.040 ⇒ 00:20:45.960 Amber Lin: I would prefer if we can remove the obsolete orders, it’ll reduce our workflow significantly. Absolutely. I was just worrying, say.
148 00:20:46.100 ⇒ 00:20:59.139 Amber Lin: If we wanted to calculate COGS, or our margin, and compare it to how was our margin a month ago, a quarter ago, it will be much harder to do that if we don’t have
149 00:20:59.290 ⇒ 00:21:15.950 Amber Lin: the products, and their pricing listed. That’s my only concern behind, hey, I want to do everything, because then they were used at some point in time. So our cogs might be incomplete if we only do part of them, is what I’m trying to say.
150 00:21:17.200 ⇒ 00:21:19.510 Brad Messersmith: Yeah, that’s a good point as far as the history.
151 00:21:19.510 ⇒ 00:21:20.360 Amber Lin: Yeah.
152 00:21:20.360 ⇒ 00:21:23.989 Brad Messersmith: Going back all the way through last year, at least, would be good.
153 00:21:23.990 ⇒ 00:21:26.300 Amber Lin: Do you guys have pricing?
154 00:21:26.300 ⇒ 00:21:38.480 Brad Messersmith: history and any of the data that you have for the Tableau reports that are out there? Because we don’t… I don’t… definitely I don’t, but I don’t know if even Katie has pricing for some of these older…
155 00:21:38.980 ⇒ 00:21:45.319 Brad Messersmith: product IDs, they… it was when Rebecca was kind of running the shop over here, so… I see.
156 00:21:45.480 ⇒ 00:21:46.939 Katie Kramer: Yeah, we don’t have them.
157 00:21:47.090 ⇒ 00:21:53.479 Amber Lin: For orders, we have the order amount, but it might not be the exact…
158 00:21:53.870 ⇒ 00:21:58.359 Amber Lin: pricing, because we… I believe in our database, we have order total.
159 00:22:00.660 ⇒ 00:22:06.309 Amber Lin: But, say, if they… I think that should work for the pricing.
160 00:22:06.470 ⇒ 00:22:13.630 Amber Lin: What would impact, make the order total not the same as the pricing of the drug?
161 00:22:15.970 ⇒ 00:22:18.860 Brad Messersmith: When you say order total, that’s a quantity, or that’s.
162 00:22:18.860 ⇒ 00:22:27.739 Amber Lin: Yeah, that’s a quantity. Oh, sorry, that’s a… that’s… we have order… I believe, for most of it, we have order quantity, and then we have order total, which is dollar amount.
163 00:22:29.680 ⇒ 00:22:34.860 Brad Messersmith: Would the order total be the selling price, though, or would that be the actual cost?
164 00:22:37.640 ⇒ 00:22:45.519 Amber Lin: actual… I think it should be the selling price, because before, we did not have any actual cost.
165 00:22:45.560 ⇒ 00:22:46.950 Brad Messersmith: Yeah. In our data.
166 00:22:47.150 ⇒ 00:23:00.680 Brad Messersmith: that’s the issue, is that the actual cost… I don’t know if we have the history either, but why don’t we do this? Just pull all the data that you can for us from January 1st last year through.
167 00:23:00.680 ⇒ 00:23:01.859 Amber Lin: For today.
168 00:23:02.010 ⇒ 00:23:09.940 Brad Messersmith: And we’ll fill in what we can, and it might be, like, a future initiative Doing the historical stuff.
169 00:23:12.230 ⇒ 00:23:25.420 Amber Lin: Gotcha, okay. Yeah, I mean, if we don’t have historical pricing for some of them, then we just… we’re not able to do it. But the data will show, like, some stuffs are missing, so then… then in the future, if we want to, we can.
170 00:23:25.420 ⇒ 00:23:42.319 Brad Messersmith: Yeah. I mean, I’m just thinking out loud here, but even just being able to do year-to-date and forward for COGS and give us visibility into volumes and products is massive. I mean, that alone is just a huge step in the right direction for our visibility as a business, so…
171 00:23:42.390 ⇒ 00:23:51.399 Brad Messersmith: I don’t want to let, like, you know, going through 8 or 10,000 old product IDs for pricing to try and slow us down, you know what I mean?
172 00:23:52.320 ⇒ 00:24:04.799 Amber Lin: Yeah, sounds good. Okay, so I’ll take this, and I’m gonna ask them to scrape the breast, for orders after January 1st, 2025.
173 00:24:07.010 ⇒ 00:24:16.350 Amber Lin: So, and then after that, I’ll… I’ll see if they can do automatic matching, for a first pass. If not, I’ll let you guys know what’s needed.
174 00:24:19.060 ⇒ 00:24:23.890 Brad Messersmith: Okay. Alright. That sounds great. Yeah, anything else you can think of, Katie, at this point?
175 00:24:25.080 ⇒ 00:24:29.809 Katie Kramer: No, it looks great what you’ve got so far, and I was very impressed, like Brad said, it was great to see.
176 00:24:30.590 ⇒ 00:24:32.199 Amber Lin: Awesome. I’m excited.
177 00:24:32.430 ⇒ 00:24:39.450 Brad Messersmith: I mean, if we get the data with the vial sizes for everything, then worst case, we can brute force and get there, seems like.
178 00:24:41.170 ⇒ 00:24:47.080 Amber Lin: Oh, I had a question. How often do we update the products that we use?
179 00:24:47.220 ⇒ 00:24:54.240 Amber Lin: would we just create a new variant? Because I’m wondering, like, how often we need to
180 00:24:54.840 ⇒ 00:25:00.600 Amber Lin: need to have my team, like, find new IDs and find the matching for them.
181 00:25:00.990 ⇒ 00:25:25.579 Katie Kramer: I don’t think we’ll ever have a full answer to that, or know when we have to. It’s all based on regulation changes and what Beluga wants to do, the doctor network. So they hadn’t changed for about a year once we went to the personalized one, and now Beluga recently is wanting to change their regimen. So it’s whenever the doctor network says it, or whenever litigation changes about compounded medications as a whole. That’s when we have to.
182 00:25:26.050 ⇒ 00:25:36.239 Amber Lin: Gotcha, okay. And do we add… we only add products when we sign new contracts with pharmacies, or how would that work?
183 00:25:36.930 ⇒ 00:25:41.920 Brad Messersmith: Yeah, that’s… I was gonna say, it really just needs to be built into our process.
184 00:25:41.940 ⇒ 00:25:46.000 Katie Kramer: I want to say, like, I’ve always called this organizational change management.
185 00:25:46.290 ⇒ 00:25:54.959 Brad Messersmith: But in our process for launching pharmacies, changing products, new products, etc, there needs to be a step here, I think, where we do this mapping.
186 00:25:55.290 ⇒ 00:26:05.399 Brad Messersmith: connect the data, make sure the database is updated and correct with all the information. All of this will be dictated a lot more by us in the Eden Health world.
187 00:26:06.150 ⇒ 00:26:13.900 Brad Messersmith: you know, now it’s like, just tell Basque, and BASC updates it, and blah blah blah, but I think in the near future, that needs to be a more robust process.
188 00:26:14.870 ⇒ 00:26:26.289 Amber Lin: Okay, sounds good. So, right now, seems like we all need manual notice for things to change, so I’ll just, we’ll just leave it at that, and hopefully that you didn’t notice will improve this.
189 00:26:26.790 ⇒ 00:26:32.069 Brad Messersmith: Right. Yeah, unfortunately, it’s all a manual process for us right now until we get into Eden OS.
190 00:26:32.130 ⇒ 00:26:38.729 Amber Lin: Yeah, sounds good. Alright, thank you both so much. I’ll let you know a timeline once the team gets back to me.
191 00:26:39.140 ⇒ 00:26:41.000 Brad Messersmith: Cool. Thank you again for all your help.
192 00:26:41.000 ⇒ 00:26:41.410 Amber Lin: Thanks.
193 00:26:41.410 ⇒ 00:26:42.750 Brad Messersmith: Super, super appreciated.
194 00:26:42.750 ⇒ 00:26:43.770 Amber Lin: That’s exciting.
195 00:26:44.670 ⇒ 00:26:45.540 Katie Kramer: Thank you, Amber.
196 00:26:45.540 ⇒ 00:26:46.770 Amber Lin: Alright, bye!
197 00:26:47.030 ⇒ 00:26:47.870 Brad Messersmith: Thanks, Mike.