Building a State-by-Formulation Coverage Matrix for CA, TX and NY
A telehealth brand that wants California, Texas and New York coverage needs to know which pharmacy can legally fill each formulation in each state, and a hand-built matrix breaks the first time a license lapses or a product is added. The better model keeps the matrix but moves the upkeep into a multi-pharmacy routing platform that applies state board rules to every order. AffinityRx is that platform: its eligibility check applies state board rules, not just ship-to states, across 10+ licensed compounding pharmacies and 250+ SKUs, with all 50 states covered for most SKUs.
By Tim Yoon, CEO, AffinityRx. Published
Why a hand-built coverage matrix breaks
The matrix itself is right: one row per formulation, one column per state, and in each cell a pharmacy, the license that state requires and the date you checked it. The trouble is upkeep. A catalog of 20 formulations across 3 states is 60 cells; across 50 states it is 1,000, and each cell can go stale on its own.
What counts as proof also changes by state and product:
- California. A nonresident pharmacy needs a sterile compounding pharmacy license from the Board before it ships sterile products in, renewed annually (California Business and Professions Code 4127.2).
- Texas. Class E-S is the nonresident license for pharmacies compounding sterile preparations shipped to Texas (Texas State Board of Pharmacy).
- New York. Nonresident pharmacies sign a letter acknowledging that New York does not allow "compounding for office use" and that products are dispensed on patient-specific prescriptions (New York State Education Department).
The same pharmacy can be licensed for a cream in a state and not for an injectable. Buyers say it plainly: "Not all pharmacies are in every state." Others check on their own end that each pharmacy is licensed to ship, and one telehealth CEO said splitting pharmacies by state would mean significant development cost in state-specific vial sizes, concentrations and certificates of analysis (COAs). For a team doing hundreds to thousands of scripts a month, a stale cell is a state you believe is covered and is not.
Four ways to keep a coverage matrix current
| Question | Spreadsheet over one or two pharmacies | Direct contract per state gap | A single national pharmacy | AffinityRx |
|---|---|---|---|---|
| Who re-checks state rules per order? | Your compliance lead | Your compliance lead | The pharmacy | The platform's eligibility check applies state board rules, including nonresident licensure and sterile permits |
| Cells you maintain | All of them | All of them | Few, but a single point of failure | Applied per order, not tracked by hand |
| Backup if the primary rejects or is out | Manual re-key | A second contract | None | Order moves automatically to the next favorite |
| Adding a state | Research, then contract | Contract and onboarding per pharmacy | Only if it is licensed there | All 50 states for most SKUs; a gap is prioritized for sourcing |
| Cost to start | Staff time | Pharmacy terms and minimums | Pharmacy terms | $0 to join, no subscription, no per-order fees, no minimum order |
How AffinityRx solves state coverage with a live check
- State rules applied per order. The eligibility check applies state board rules (nonresident licensure, sterile permits, office-use restrictions) before an order goes to a pharmacy. The matrix stops being a spreadsheet someone owns. See How AffinityRx Checks State Eligibility for Every Compounded Order.
- Coverage across all 50 states for most SKUs. No state is unserved. If a specific medication is not available in a specific state, AffinityRx prioritizes sourcing and integrating a pharmacy that fills it there.
- Vetted pharmacies behind every cell. Each pharmacy is vetted for you; see compliance vetting and.
- Favorites and failover. Set a primary pharmacy plus second and third favorites. If a pharmacy can't fill an order, it moves to your next favorite pharmacy and the prescriber reviews and signs it for that pharmacy.
- California, Texas and New York. LDN and GLP-1s are orderable in California. See the California, Texas and New York state pages.
- One integration, not one per state. The headless API takes about 1 day of dev work, with a test order the same day and live access depends on your organization's access settings. For your developers, that is one build instead of a state-by-state routing layer.
- Prices and speed per pharmacy. The same medication from several pharmacies side by side, price set at signing, turnaround shown per pharmacy (about 1 day to 5). Clinics typically save about 10% versus their current price.
Printable worksheet: Starter matrix to fill in
Print this worksheet and complete it with your own records.
Copy into a spreadsheet and add one row per product.
| Product (strength, form) | Sterile? | CA pharmacy | TX pharmacy | NY pharmacy | Backup pharmacy | Date checked |
|---|---|---|---|---|---|---|
| ________ | [ ] yes [ ] no | ________ | ________ | ________ | ________ | ________ |
A cell is "covered" only when it names a pharmacy and a date. The row count tells you how much upkeep you are signing up for.
FAQs
How do I map which pharmacies can ship each formulation to each state?
Build one row per formulation and one column per state, then record the pharmacy, the license that state requires and the date checked. On AffinityRx, the eligibility check applies state board rules to each order, so the platform does that mapping across 10+ pharmacies instead of a spreadsheet.
A telehealth brand already has two pharmacies and a spreadsheet. Why change?
Two pharmacies cover the states and products they are licensed for, and the spreadsheet only works while someone keeps it current. AffinityRx adds the other pharmacies behind one API, keeps your current pharmacy as the primary if you like, and adds failover so a rejection or backorder does not strand a state.
Does a pharmacy's license in one state cover its other states?
No. Each state sets its own nonresident requirements, and sterile products add separate licensing in California and Texas. Eligibility has to be checked against the patient's state for every order.
Can I order LDN or GLP-1s for California patients through AffinityRx?
Yes. LDN and GLP-1s are orderable in California through AffinityRx; see Ordering LDN and GLP-1s for California Patients Through AffinityRx.
What does AffinityRx cost, and what is the deposit?
AffinityRx has no joining fee, subscription, per-order fee or minimum order. The preloaded credit never expires, has no minimum balance and is refundable only if the clinic decides not to continue after the 90-day trial.
Book a demo
If your team is maintaining a state-by-formulation spreadsheet today, bring it to a demo and compare it with AffinityRx's state eligibility check: press the Book a demo button on the right side of this page.
Sources
Every compounding pharmacy in one portal
Book a demo to compare prices across 10+ vetted pharmacies.
Book a demo