Process Hygiene: Why Clean Data Never Stays Clean
Process hygiene is the condition of the routines that create your data. What it is, the five failure patterns, and why data cleanups decay without it.
Blog
Notes from the Data Layer
How to Dispute a Retailer Deduction, Portal by Portal
How to dispute a retailer deduction across Walmart, UNFI, KeHE, and Kroger: filing windows, the evidence that wins, and the mistakes that auto-deny.
KeHE Deductions: Reading Your Remittance Check Without Crying
A plain-English guide to KeHE deduction codes: MCB, EP, spoils, service-level fines. What each means, which you can dispute, and how to file in K-Solve.
Kroger Deduction Codes, Decoded: Lavante, PRGX, and the 180-Day Clock
A plain-English guide to Kroger deductions: shortages, list cost, EDI, and ORAD. What each means, which you can dispute in Lavante, and by when.
Walmart Deduction Codes, Decoded: Code 22, OTIF Fines, and What You Can Actually Dispute
A plain-English guide to Walmart deductions: Codes 22, 25, and 13, plus OTIF and SQEP fines. What each means, which you can dispute in APDP, and by when.
UNFI Deduction Codes, Explained: What Each One Means and Which You Can Dispute
A plain-English guide to UNFI deduction codes: MCB, INV, shortages, spoilage, and compliance fees. What each one means, which are disputable, and how to file a dispute that wins.
The 1WorldSync Data Pool, and What It Does to Your Item Data
A retailer told you to publish your items to 1WorldSync. Here is what a data pool actually is, how publication works, and why being on it does not mean your data is right.
Amazon Vendor vs. Seller Central: The Real Cost Difference
On $2M of Amazon volume, Seller Central keeps roughly $105K more than Vendor Central. The 1P vs 3P margin math for a food brand, and why the gap isn't the real call.
Which Channel Actually Pays After Every Deduction
Rank a $25M brand's channels by revenue and Walmart wins. Rank them by contribution after every deduction and the order scrambles. An interactive walk from gross revenue to the capital-allocation decision.
channel profitabilitycontribution margincapital allocationretail vs distributiondeductionsCPG finance
The Routing Guide Errors That Trigger Retail Chargebacks
One wrong field in your item file pays a routing-guide fee on every shipment. How EDI and ASN chargebacks compound to six figures, and why you can't dispute them.
GDSN for Food Brands: What the Data Pool Actually Checks
A practical guide to GDSN for specialty food brands: what a data pool is, why food can't treat it as optional, which attributes reject, and where the food-specific data breaks.
Every GTIN Passed the Check Digit. The Retailer Rejected It Anyway.
A valid check digit proves twelve or fourteen digits are internally consistent. It says nothing about the four things that actually get an item rejected. What GTIN verification means when the retailer, not the math, is the judge.
Your Fill Rate Says 99%. Walmart Scores You 84%.
A brand's internal fill rate reads 99%. Walmart's OTIF scorecard reads 84%. Both are right. The 14.8-point gap costs $57K a year, and it hides in the one number the brand doesn't watch.
Retail Deductions: What You Write Off Without Checking
A $25M food brand writes off ~$67K in invalid retailer deductions a year without opening the file. Where the money hides in the data, and why it decays.
Trade Spend Is Not Marketing Spend. The P&L Proves It.
Book trade spend as marketing and your gross margin reads 52% when it's 44%. Why ASC 606 makes it contra-revenue, and what the misfiling hides.
Syndigo Bought 1WorldSync: What Happened to the Data Pool
Syndigo bought 1WorldSync, merging the two largest GDSN pools. 97% of US GLNs now sit in one pool, with one validation ruleset and no alternative routing.
DSD vs. Warehouse Distribution: What the Numbers Show
Warehouse distribution through UNFI or KeHE costs 40-52% of wholesale after fees. DSD runs 25-35%. Here's when each model pays for itself.
Private Label vs. Branded: The Margin Math for Food Brands
A branded product's 45% gross margin loses 15 points to trade spend and deductions. Private label's 30% stays close to what it keeps.
S&OP Is a Financial Lever, Not a Supply Chain Meeting
A specialty food brand grew revenue 22% while cash declined. S&OP is the reconciliation of demand, production, and cash that most brands skip.
Trade Promotion Management: Where the Process Breaks Down
Trade promotion management data lives in three systems with three owners. 40% of small-brand trade spend goes unmeasured because nobody reconciles them.
Trade Spend Leakage: Your Top Retailer Is Probably Your Worst Account
Trade spend leakage explains why a brand's biggest account, reranked by net-revenue yield, often falls to the bottom of the list.
trade spend leakagetrade deductiontrade spendnet revenueCPG analyticsretailer profitabilitypromotional analysis
1WorldSync Subscription Fees: What Specialty Food Brands Actually Pay
1WorldSync does not publish pricing. Annual subscription fees run $2K-$15K+ depending on SKU count, services, and contract terms.
Capital Allocation in CPG: Where the Next Dollar Earns the Most
The same $1M of revenue yields ~$54,000 more contribution through retail than through distribution. Most brands allocate by revenue rank, not contribution rank.
Penetration in CPG Means Three Things. Most Dashboards Show None of Them.
Three CPG penetration metrics get called one name: distribution, velocity vs. distribution, and household. Confusing them means funding the wrong strategy.
Slotting Paid, Nothing Scanning: The Authorization Voids Costing Specialty Brands Six Figures a Year
A single botched shelf reset worth $165,526. Classifying and dollarizing authorization voids turns a hunch into a ranked broker work list.
Trial vs Repeat Purchase: The Most Expensive Way to Die in CPG
Trial vs repeat purchase: high penetration with low repeat means spending to acquire buyers who never come back. Product failure disguised as growth.
CPG Analytics Is Fifteen Questions. Most CEOs Answer Them from Memory.
A specialty food brand's operating decisions are finite and answerable with rules, not dashboards. CPG analytics as a question engine, not a BI project.
Scan Velocity: Two Items, Same Revenue, Opposite Strategies
Distribution tells you where you are. Scan velocity tells you how fast you sell there. That distinction drives expansion, pruning, and rationalization.
Short-Ship Costs: A 99% Fill Rate Still Loses $298K a Year
At a 99.3% fill rate, a synthetic $25M brand's short-ship cost reaches $894K over three years. Four dimensions, every dollar traced to a platform event.
A Retail Velocity Report That Tells You What to Do Next
Most retail velocity reports say what happened. Nine decision modes turn scan data into shelf defense, production plans, promo ROI, and distribution expansion.
Retail Readiness Scorecard: Most Brands Discover They Aren't Ready After the Buyer Says Yes
The hard part is the 90 days after the buyer says yes. A retail readiness scorecard finds the operational gaps before the placement becomes a loss.
Remittance Parsing Is the Silent Bottleneck in Deduction Recovery
Retailer remittance stubs arrive as PDFs in inconsistent formats. Manual remittance parsing is the bottleneck between deduction discovery and recovery.
The Recall Blast Radius of One Chili Lot: 14 SKUs Across Three Product Lines
One contaminated lot can put dozens of SKUs and hundreds of stores inside the recall blast radius. Most brands need 72 hours to map it. It should take three.
Your Production Demand Forecast Is Wrong Because Your Stockouts Suppressed the Signal
Stockouts suppress observed velocity by 15-25%. A production demand forecast built on that data under-predicts demand, guaranteeing the next stockout.
A Governed Product Master Data Model Eliminates 62% of Data-Driven Chargebacks
Most CPG chargebacks trace to twelve product master fields. A governed product master data model (brand to pallet, GTINs at every level) closes the gap.
The Monday Morning Report Is Three Numbers, Not a Dashboard
Most specialty food founders check a different number each week. A tiered Monday morning report tracks the same three signals and catches drift early.
Data Anonymization Turns NDA-Bound Work Into Case Studies You Can Show
Consultancies lose deals because NDAs block their proof. Deterministic data anonymization turns client work into case studies buyers can verify.
data anonymizationportfoliocase studiesconsultingclient dataNDA
EDI Reconciliation Stops at the Acknowledgment. Nobody Checks That the Contents Agree.
EDI reconciliation at most CPG brands stops at the 997. Quantities, prices, and item identities go unchecked across the PO lifecycle.
Distribution Penetration: 640 Doors Authorized, 460 Scanning, a Silent 180-Door Gap
Distribution penetration is the gap between authorized and scanning doors, where slotting is paid and revenue never arrives. Most brands cannot state it.
Sales Decomposition: The Growth That Hid a Household Penetration Decline
Sales rose on price while fewer households bought each quarter. Three-lever sales decomposition catches erosion disguised as growth.
CPG Data Standards: The One Reference for the Fifteen Tabs You Keep Open
CPG data standards in one page: GTIN anatomy, GDSN syndication, retailer item setup, and freight-class logic, verified against GS1 and retailer sources.
Two Spreadsheets, 400 Rows Apart: What a Data Comparison Tool Finds in Seconds
When two file versions disagree on 400 rows, the cost is the hours spent finding them. A data comparison tool cuts that to seconds.
Chargeback Prediction Works: Chargebacks Are Not Random but the Scheduled Consequence of Bad Data
Chargeback prediction works: 70-80% of compliance penalties trace to specific, fixable upstream data conditions present at shipment time.
A Five-Layer Cost Waterfall Reveals Which Channels Actually Make Money
Applying a five-layer cost waterfall to 10 channels shows gross revenue rank and contribution rank diverge by 3-4 positions for most specialty food brands.
Deduction Recovery: 85 Percent of Deduction Dollars Are Never Recovered, and the Problem Is Operational, Not Financial
Deduction recovery at specialty food brands runs under 15% of deducted dollars. Five compounding operational failures, not failed disputes, explain the gap.
The 4-Cent GS1-128 Shipping Label That Triggers a $500 Chargeback
A single wrong digit in a GS1-128 shipping label GTIN generates retailer chargebacks thousands of times the label's cost. Most brands verify labels by eye.
Contract to Cash: 15-25 Cents of Every Invoiced Dollar Disappears
Contract to cash: of every invoiced dollar, 15-25 cents disappears into deductions, chargebacks, and timing gaps. Most brands never calculate it.
Channel Profitability Analysis: Your Biggest Channel Is Rarely Your Best Investment
Channel profitability analysis ranks channels by contribution after trade, compliance, and deductions. The highest-revenue channel is often the lowest return.
SKU Rationalization: Your Worst SKUs Are Not the Ones With the Lowest Revenue
SKU rationalization by revenue rank misses the SKUs bleeding margin through trade cost, chargebacks, and velocity decay. 35% drive zero profit.
Food Broker Fees: Commission, Retainer, or Both
Commission rates run 5-12% but the fee structure (commission, retainer, or hybrid) determines what the broker prioritizes. Real ranges and total cost analysis.
The GDSN Attribute Errors That Get Your Item Rejected
Seven GDSN validation errors cause most retailer rejections, brand name mismatches, missing GLNs, barcode type errors. Per-field fixes and what they cost.
Retail Launch Economics: Most National Launches Lose Money in Year One
Retail launch economics: most specialty food launches into national retail lose money in year one after slotting, trade spend, compliance, and working capital.
Retailer Chargebacks: Four Root Causes, Most of the Damage
Most retailer chargebacks concentrate in four root cause categories. How to run the twelve-month diagnostic that maps each one to a fixable data field.
SPINS vs. Retail Link: Which Data Answers Which Question
SPINS vs. Retail Link: one covers natural channel trends and share, the other Walmart store-level POS. A framework for which one answers your question.
The Syndigo 1WorldSync Migration: What Changes, By What You Use Today
The Syndigo 1WorldSync migration hits three kinds of brand differently depending on whether you ran GDSN, content syndication, or both. What moves and what doesn't.
Specialty Food Brand Operational Costs: The Ten Decisions Behind $1.4M–$2.3M a Year
Ten decisions nobody owns drive specialty food brand operational costs of $1.4M–$2.3M a year. Each is answerable with data the brand already has.
Co-Packer Quality Agreements: What Food Brands Miss
Most co-packer agreements protect IP but miss the operational clauses that prevent retailer chargebacks, GTIN ownership, ASN obligations, fill rate.
CPG Demand Forecasting Built on Shipment Data Drains Small-Brand Cash
CPG demand forecasting built on ERP shipment records misses the retail scan signal, and the gap costs money in both directions.
Gross-to-Net: The Margin Analysis CPG Brands Skip
The gross-to-net bridge is built from scan allowances, MCBs, slotting fees, and distributor deductions, none of which appear on a standard P&L.
Food Broker Management Starts Where the Quarterly Deck Ends
Food broker management needs its own data layer. Brokers earn on shipments, not scans. What Retail Link, SPINS, and UNFI Connect show that the deck omits.
What Sprouts Checks Before Approving a New Supplier
Before the first Sprouts order, brands need UNFI item setup, IX-ONE image registration, and EDI 810 compliance. Here's the operational sequence.
Distributor Deduction Management: The Recovery Rate Most Brands Never Measure
Most CPG brands track deduction win rate, not dispute rate: the share of invalid deductions ever contested. Distributor deduction management starts there.
Whole Foods Supplier Data Requirements Span Two Systems, Not One
Whole Foods supplier data requirements split between WFM buyer approval and UNFI item setup. EDI and item data pace the launch timeline.
Scan-Based Trading: What Specialty Food Brands Get Wrong
SBT transfers inventory ownership, shrink liability, and reconciliation burden to the supplier. Most brands sign without reviewing those terms.
UNFI vs. KeHE Item Setup: Where Your Data Gets Rejected
UNFI rejects at the document layer. KeHE rejects on barcodes and date formats. The pre-submission checklist is different for each, here's what to check.
Units Per Store Per Week: The Velocity Number Retailers Use to Delist Your SKU
Units per store per week is the velocity number buyers use to delist SKUs. Brands measure it from shipments; buyers measure scans, and the gap costs facings.
The Supply Chain Data Quality Audit Nobody Has Run Yet
CPG deductions run 5-15% of gross sales. Net margins sit at 3-5%. A supply chain data quality audit traces the gap to twelve fields nobody has audited.
EDI 856 ASN Errors: The Chargeback Source Nobody Audits
EDI 856 ASN errors generate more chargebacks than any other EDI document. Four error types cause most of them. All are data fixes, not logistics changes.
OTIF Fines Are a Data Problem, Not a Logistics Problem
Most OTIF fines at specialty food brands trace back to product master data errors, not late trucks. Where the data breaks, and what it costs.
Product Master Data Management: 12 Fields Cause Most CPG Chargebacks
Twelve fields disagreeing across three systems cause most CPG chargebacks. Product master data management starts here: the fields, the systems, the cost.
Syndigo vs 1WorldSync: The Comparison Is Settled. The Pricing Isn't.
Syndigo bought 1WorldSync, so the vendor comparison is over. What replaces it is one supplier controlling 97% of U.S. GDSN routing on the other side of the table at renewal.
Trade Spend Optimization: Where Small Food Brands Lose Control
Specialty food brands spend 15-20% of revenue on trade promotions and can't say which worked. Trade spend optimization starts by connecting three data streams.