How price lists leak
Picture a small online brand that sells candles and bath goods two ways: direct to shoppers on its own store, and wholesale to a few dozen boutiques. The wholesale price sheet lives in a spreadsheet. One afternoon someone updates the online store from that spreadsheet and copies the wrong column. For a few hours, shoppers see wholesale prices at checkout. A week later, a boutique owner forwards an old wholesale PDF to a friend who is not an approved account. That scene is an illustration, not a TwoQM client.
Price leaks rarely come from bad intent. They come from one set of numbers being copied by hand into several places, with nobody checking which list a change belongs to. The fix is to treat each price list as its own record, with an owner, a review step, and clear rules about who can see it.
TwoQM has already written about keeping online and in-store inventory in sync and about wholesale order cutoffs and delivery manifests. This piece is different: it is about keeping wholesale and direct-to-consumer (DTC) prices separate, reviewed, and visible only to the right people.
Here is an original example, not a measured result. Small brands that sell both wholesale and direct tend to see the same problems:
One spreadsheet feeds everything. Retail, wholesale, and distributor prices sit in side-by-side columns, and one wrong paste reaches the storefront.
Price changes have no owner. Someone raises a retail price for a holiday but forgets that wholesale accounts were promised notice first.
Old PDFs keep circulating. A wholesale sheet emailed last spring is still being forwarded, with prices and products that no longer apply.
Account approval is informal. Anyone who fills out a wholesale form gets the price sheet before anyone checks the account.
Discount codes overlap. A retail promo code also works on a wholesale order, stacking two discounts nobody approved together.
Bilingual buyers get a different version. A Spanish-language sheet was translated once and never updated when prices changed.
One record per price list
Give each list its own record instead of a column in a shared spreadsheet. For each list, keep:
Who it is for, such as retail shoppers, approved wholesale accounts, or a specific distributor.
The products and prices it covers, including minimum order quantities or case packs for wholesale.
Effective dates, so a new list can be prepared ahead of time and switched on when approved.
The owner who can propose changes, and the person who approves them.
Where it may appear, such as the public storefront, a wholesale login area, or a private quote only.
Language versions, so English and Spanish copies change together.
Review before any price goes live
Price changes go to a review queue, not straight to the storefront or the wholesale sheet. The person proposing the change says which list it belongs to and why. A second person, usually the owner or whoever manages wholesale relationships, checks it against the other lists: Is the wholesale price still below retail? Does any promised notice to wholesale accounts apply? Do promo codes need limits? Only approved changes publish, on their effective date, and the old version is kept in the history instead of being overwritten.
Wholesale access works the same way. A new account request is reviewed by a person before that account can see wholesale prices. When an account closes, its access ends. The price sheet itself lives behind a login or in quotes sent from the system, so there is no loose PDF to forward. Any pricing terms that need legal review, such as contract language with distributors, belong with your attorney, not in a spreadsheet note.
Where TwoQM fits
Custom software can give a brand one place to hold each price list, its effective dates, and its review history, with screens built around how that brand sells. Connected systems can push only the approved retail list to the online store and only the approved wholesale list to the wholesale ordering area, so no one copies numbers by hand. Ordinary business automation can route new wholesale account requests to the right person, remind owners before an effective date, and send approved accounts an updated sheet in their preferred language. A CRM can track which accounts are approved, paused, or closed.
Where AI helps, and where it stops
AI can compare a proposed change against the other lists and flag possible problems, such as a wholesale price that would end up above retail or a promo code that would also apply to wholesale orders. It can draft the account notice and the Spanish version of a price sheet for a person to check. AI does not set prices, approve changes, or decide which accounts get wholesale access. A person reviews every flag and approves every change before it goes live.
Where to start this week
List every place a price appears today: the online store, the wholesale sheet, marketplace listings, quotes, and printed catalogs. Mark which list each one should come from and who last changed it. Then pick one upcoming price change and run it through a simple propose, review, and approve step before it goes anywhere.
TwoQM builds custom software, connected systems, and automation for retail and ecommerce businesses. If your wholesale and retail prices still share one spreadsheet, TwoQM can scope a price list workflow around the store and tools you already use. Pricing explains how business apps, systems, and custom software are scoped.
Describe Your Price List Workflow · Explore TwoQM custom software