The spreadsheet is not a bad tool. It is flexible, it does not require a subscription, and the person who built your pharmacy's ordering spreadsheet already understands exactly what they wanted it to track. When we talk with independent pharmacy owners about switching to a platform-based procurement workflow, we are not trying to make the case that spreadsheets are broken. We are trying to make the case that there are specific things a platform can do that a spreadsheet genuinely cannot.
This article is about what the transition actually looks like in practice: the specific things that change, the things that stay the same, and the parts of the transition that are harder than people expect.
What the Spreadsheet-Based Procurement Workflow Actually Looks Like
Before discussing what changes, it is worth being specific about the current state. A typical spreadsheet-based procurement workflow for an independent pharmacy in Brazil involves several distinct documents or sheets.
There is a stock list: a record of what you carry, in what quantities, and at what reorder thresholds. This is often built from a manual count that gets updated inconsistently. Products that move fast are updated frequently; products that move slowly may not have been counted in months.
There is an order history: a log of what was ordered when, from which distributor, at what price. This is valuable for understanding purchasing patterns and negotiating with distributors, but it is only as good as the consistency with which it was maintained. A busy week often means incomplete entries.
There is a price comparison sheet, if the pharmacy does systematic comparison at all: a place where you record the prices quoted by different distributors for the same products so you can see which is cheaper. This is the most commonly incomplete document, because maintaining it requires calling multiple distributors and entering the results, which is the friction that most pharmacies are trying to avoid.
The phone call is the central activity that all of these documents feed into. The spreadsheet tells you what to order; the phone call tells you what it costs and whether it is available; you then enter the order into the spreadsheet and wait for the delivery.
What a Platform Changes
The most direct change is to the price comparison step. Instead of calling three distributors to get three prices, you search for the product on the platform and see current prices from every distributor who carries it, simultaneously. The time savings on this step alone is meaningful, especially for pharmacies that currently do not do systematic comparison because the friction is too high.
The second change is order documentation. When you place an order through a platform, you get a structured order record: date, products, quantities, prices, supplier identity, expected delivery date. This record is automatically created and retrievable. Compared to a spreadsheet entry that may or may not have been filled in consistently, or a verbal order where the documentation is whatever you wrote down during the phone call, the platform record is more complete and more reliable.
The third change is supplier discovery. Your current suppliers are the suppliers you have relationships with. A platform exposes the prices and availability of distributors you have never spoken to. Some of those distributors will turn out to be competitive on specific product categories that your current suppliers are not strong in. You do not have to switch suppliers to benefit from this: the knowledge that another distributor is offering a better price is useful even if you use it as a negotiating input with your existing supplier rather than placing the order on the platform.
What Does Not Change
A platform does not replace the need for a person who understands your pharmacy's demand patterns. Knowing when to reorder, how much buffer stock to keep for seasonal variation, and which products to prioritize when cash is tight are judgment calls that depend on knowledge of your specific operation. A platform can surface the information relevant to those calls, but it cannot make them for you.
A platform does not replace distributor relationships entirely. If you have a distributor who extends you credit flexibility during tight periods, or who has given you priority during supply shortages because of your long relationship, that relationship has value that a transaction on a platform does not automatically replicate. We are not saying relationships do not matter. We are saying that the relationship's value is not primarily in being the mechanism through which you discover prices: that part can be handled more efficiently by a platform.
A platform also does not solve inventory management problems that originate in your dispensing workflow. If your pharmacy has poor stock visibility because dispensing is not systematically recorded, a better ordering tool will not fix the underlying problem. Procurement optimization built on inaccurate inventory data produces better-optimized bad decisions.
The Parts That Are Harder Than Expected
Every pharmacy that has gone through any kind of software transition knows that the described workflow and the actual workflow are often different. The person who set up the spreadsheet three years ago has left; the person using it now has developed workarounds that are not documented anywhere; the actual ordering behavior does not quite match the nominal process.
Platform adoption requires understanding the actual current workflow well enough to map the transition accurately. The hardest part is usually not the technology: it is identifying which parts of the current workflow are essential and which are artifacts of the tool (you do something a certain way because the spreadsheet made it easier, not because it is the best way to do it).
A second difficulty is that the benefit of a platform is not uniform across all products. For fast-moving commodity generics where multiple distributors carry consistent stock, the price comparison benefit is high and the platform is clearly the better procurement channel. For slow-moving specialty products that only one or two distributors carry and where your rep relationship genuinely helps ensure allocation, the platform adds less value and the phone call remains the right tool. A realistic adoption path involves identifying which product categories are worth transitioning first, rather than treating it as an all-or-nothing switch.
A Realistic Transition Path
What we recommend to pharmacies evaluating Covalenty is starting with a specific product category rather than attempting to transition all procurement simultaneously. Identify a category where you know you have multiple distributor options, where price comparison is currently limited by the time it would take to call around, and where order frequency is high enough that the time savings will accumulate quickly. Transition that category to the platform and see what actually changes.
The goal at that stage is not cost savings, though those may appear. The goal is understanding your actual current cost for that category, which you may not know precisely, and developing confidence in the platform's price data and fulfillment before expanding scope. A pharmacy that moves 20 percent of its ordering volume to a platform within the first two months and evaluates the results honestly is in a much better position to make a decision about full adoption than one that tries to switch everything at once and encounters problems it cannot diagnose.
