Wrong Manufacturer
1
Missing Rows To Add
45
Contaminated Product Type
10
1. Wrong Manufacturer Assignments
Drive folder ownership disagrees with the Active Portfolio Manufacturer column. This may still be intentional if HCMC sources the product through a sub-distributor — document the sourcing arrangement in notes if so.
VERIFY
Membrane Wrap — Active Portfolio says Manufacturer =
ACZ Distribution.
Drive ownership suggests Biolab.
Drive folder ownership: Biolab sells this product family via brochure files in _HCMC_Brochures_Inbox. Sheet may reflect a sub-distribution relationship (e.g. HCMC sources through ACZ Distribution who buys from Biolab). Verify before changing.
2. Drive Products NOT on Active Portfolio
45 products have brochures in
_HCMC_Brochures_Inbox but no row on Active Portfolio. Add a row for each — or mark as "Skip" if HCMC doesn't actually sell it. Don't hand-fill Division / Product Type / Provider Specialties; those will be populated from WebFetch + brochure data when the catalog rebuilds.
ADD
Manufacturer =
IZI Medical · Product = Blazer-C Vertebral Augmentation System
ADD
Manufacturer =
Sun-Scientific · Product = Aero-Wrap Full Leg Flex
ADD
Manufacturer =
ACZ Distribution · Product = Revoshield
ADD
Manufacturer =
Alamo Biologics · Product = Alamo Biologics WC Catalog
ADD
Manufacturer =
World Reach Health · Product = DermaBind (Product Overview)
ADD
Manufacturer =
Acesso · Product = NeoStim DL
ADD
Manufacturer =
Acesso · Product = Aceso TL
ADD
Manufacturer =
RevMac · Product = RevMAC Medical Billing Services
ADD
Manufacturer =
Biolab · Product = Microlyte PainGuard
ADD
Manufacturer =
Acesso · Product = NeoStim TL
ADD
Manufacturer =
Alamo Biologics · Product = DM-252-L-06_EC_PM_Wound_Care_Catalog
ADD
Manufacturer =
Alamo Biologics · Product = Alamo Biologics Product Catalog 2026 - MKT_PC_Rev0 Final
ADD
Manufacturer =
Skye Biologics · Product = VisiDisc
ADD
Manufacturer =
Ventris Medical · Product = Cellesta
ADD
Manufacturer =
Venture Medical · Product = Dermacyte Matrix
ADD
Manufacturer =
Advanced Solutions · Product = ActiGraft+
ADD
Manufacturer =
Venture Medical · Product = XSONX Wound Lifecycle (catalog)
ADD
Manufacturer =
World Reach Health · Product = DermaBind Reimbursement Guide
ADD
Manufacturer =
ManaMed · Product = Ankle, hip, cerv, spine, total
ADD
Manufacturer =
Sun-Scientific · Product = DIPS Chart
ADD
Manufacturer =
Advanced Solutions · Product = OCM (Omeza Complete Matrix)
ADD
Manufacturer =
Tiger Biosciences · Product = XCell Amino Matrix
ADD
Manufacturer =
MLM Biologics · Product = BioConneKT Wound Matrix
ADD
Manufacturer =
ManaMed · Product = manamed-com__manamed-catalog-26
ADD
Manufacturer =
Stout Medical · Product = Prime Catalog- Stout (1)
ADD
Manufacturer =
IZI Medical · Product = Vertefix HV
ADD
Manufacturer =
VA · Product = Phoenix Wound Matrix
ADD
Manufacturer =
World Reach Health · Product = DermaBind TL Fact Sheet
ADD
Manufacturer =
Acesso · Product = Aceso DL
ADD
Manufacturer =
Knute Medical · Product = Vimago GT30
ADD
Manufacturer =
ACZ Distribution · Product = Esano ACA
ADD
Manufacturer =
Tiger Biosciences · Product = DM-252-L-06_EC_PM_Wound_Care_Catalog
ADD
Manufacturer =
Ventris Medical · Product = Connext
ADD
Manufacturer =
Merakris · Product = Dermacyte AC Matrix
ADD
Manufacturer =
World Reach Health · Product = DermaBind FM Fact Sheet
ADD
Manufacturer =
Merakris · Product = Dermacyte
ADD
Manufacturer =
Merakris · Product = Opticyte
ADD
Manufacturer =
Tiger Biosciences · Product = Copy of Tiger Aesthetics - 2025 - Product Presentation
ADD
Manufacturer =
IZI Medical · Product = VCF Portfolio
ADD
Manufacturer =
Acesso · Product = NeoStim SL
ADD
Manufacturer =
Biolab · Product = Membrane Wrap Lite
ADD
Manufacturer =
Biolab · Product = Membrane Wrap Hydro
ADD
Manufacturer =
Biolab · Product = Microlyte SAM
ADD
Manufacturer =
Tiger Biosciences · Product = Coll Resolve ACA Alloply
ADD
Manufacturer =
Biolab · Product = Tri-Membrane Wrap
3. Contaminated Product Type — with proposed values
Product Type column (col D) currently has a value that does not match the product. Each row below shows our proposed replacement — derived from rules + verified data. Review and decide. Going forward, treat col D as system-populated, not hand-filled.
CLEAN
BioBlock Sponge (Acesso): currently
Flowable Biologics
Proposed replacement
Bone Void Filler Sponge (DBM)
source: rule:BioBlock+Sponge
CLEAN
BioChip Granules (Acesso): currently
Reference Chart
Proposed replacement
Demineralized Bone Granules Allograft
source: rule:BioChip+Granules
CLEAN
Bicortical Wedge 15x15 T1=6.0-T2=2.0 mm (Alamo Biologics): currently
Flowable Biologics
Proposed replacement
Cortical Bone Allograft Wedge
source: rule:Bicortical+Wedge
CLEAN
Bicortical Wedge 15x15 T1=7.0-T2=2.0 mm (Alamo Biologics): currently
Flowable Biologics
Proposed replacement
Cortical Bone Allograft Wedge
source: rule:Bicortical+Wedge
CLEAN
Bicortical Wedge 22x22 T1=12.0-T2=1.0 mm (Alamo Biologics): currently
PRP Jelly
Proposed replacement
Cortical Bone Allograft Wedge
source: rule:Bicortical+Wedge
CLEAN
Bicortical Wedge 22x22 T1=6.0-T2=1.0 mm (Alamo Biologics): currently
PRP Jelly - Cosmetic
Proposed replacement
Cortical Bone Allograft Wedge
source: rule:Bicortical+Wedge
CLEAN
Bicortical Wedge 22x22 T1=8.0-T2=1.0 mm (Alamo Biologics): currently
Reference Chart
Proposed replacement
Cortical Bone Allograft Wedge
source: rule:Bicortical+Wedge
CLEAN
DBM Putty 5.00 CC (Alamo Biologics): currently
Reference Chart
Proposed replacement
Demineralized Bone Matrix Putty
source: rule:DBM+Putty
CLEAN
Demin Cancellous Crushed-Chips 10CC (1-4mm) (Alamo Biologics): currently
Reference Chart
Proposed replacement
Demineralized Cancellous Bone Chips Allograft
source: rule:Demin+Cancellous+Chips
CLEAN
Nano PRP Jelly (Platinum Biologics): currently
PRP Jelly
No proposal — needs manufacturer outreach or research. Mark "Needs more info" and we'll add to the outreach list.
When done: click Export decisions (JSON) to download a JSON file with your decisions + notes per task. Hand that to Aaron and he'll run the catalog rebuild + portfolio regen with the cleaned Sheet data. Both rebuilds take <1 minute.