Retail data integration
What is retail data integration?
Connect POS, ERP and inventory through shared product, store, event and timing definitions instead of moving disconnected files
Read the guideMarksyte blog
Practical guidance for messy commercial data
How to reconcile retailer, distributor and internal FMCG data when product codes, periods, formats and reported numbers do not line up
FMCG data reconciliation
Start with the numbers that do not match
Practical guides for sales operations, finance, BI and data teams working with retailer, distributor and ERP data
SKU mapping failures
Why SKU mapping fails across countries and systems
Diagnose unmapped codes, false matches, pack conflicts and historical drift before they distort international sales and inventory data
Read the guideInternational sales comparability
Why retail sales data cannot be compared directly across countries
Align currency, tax, units, returns, reporting calendars and retailer scope before ranking country performance
Read the guideRetail market share
How to calculate retail market share from sell-out data
Define the category denominator, align retailers and periods, choose unit or value share and measure coverage
Read the guideDistributor and retailer reconciliation
Why distributor sales do not match retailer sell-out
Separate channel inventory, timing, returns, units and coverage before calling a sell-in and sell-out difference an error
Read the guideInventory record accuracy
Why inventory data does not match physical stock
Separate transaction, location, timing, shrinkage and master-data causes before correcting a stock discrepancy
Read the guideRetail sales audit
What is a retail sales audit?
Check POS transactions, returns, tenders and control totals before sales data reaches ERP, inventory and financial reporting
Read the guideSell-through rate
What is sell-through rate in retail?
The formula is simple. Making the percentage comparable across products, stores and periods requires aligned sales, stock, returns and calendar data
Read the guideSecondary sales data
What is secondary sales data in FMCG?
Secondary sales sit between primary billing and retailer sell-out. Define the event before using distributor data as evidence of demand
Read the guideSell-out data mapping
Sell-out data mapping: align product, location and period before you compare
Most sell-out mismatches begin before the arithmetic. Align product, location and period keys, preserve source values and keep unresolved relationships visible
Read the guideCalendar reconciliation
Retail calendar vs financial calendar: reconciling reporting periods
Retail weeks and financial months partition the same days differently; a date-to-period bridge makes the boundary variance a computed number instead of a debated one
Read the guideData validation
Data validation checks for retailer and distributor files
Run structural checks at intake and business checks against your own references so bad partner data becomes a controlled exception instead of a false variance
Read the guideExcel workflow
Retail data reconciliation in Excel: a practical workflow
Separate raw inputs, mapping, controls, comparison and exceptions into five zones so the monthly reconciliation is a repeatable run instead of a rebuilt one
Read the guideMissing SKUs
How to handle missing SKUs in retailer sell-out files
A product absent from a sell-out file is a coverage problem; one present but unmappable is an identity problem. Split the two before the join drops valid sales
Read the guideTrade spend
How to reconcile promotional deductions and trade spend in FMCG
Retailer deductions are the financial side of trade terms. Encode each term as a rule and check every claim against what was earned, before it reaches payment
Read the guideRetailer sales vs ERP
Why retailer sales data does not match your ERP
Diagnose the product, timing, location, returns and data-quality causes behind retailer-to-ERP discrepancies before anyone changes a number
Read the guideReporting cutoff
Why retailer and ERP sales land in different periods
Retail weeks, invoice dates and close calendars create timing differences. Bridge the calendars and carry exceptions forward so period-end variance becomes explained movement
Read the guideRetailer sell-out · ERP reconciliation
How to reconcile retailer sell-out data with ERP data
Align product codes, locations, reporting periods and measures before investigating the differences that remain
Read the guideSell-in vs sell-out
Sell-in vs sell-out in FMCG: how to reconcile the numbers
Sell-in records product leaving your control; sell-out records demand at the till. Bridge them with stock, timing and returns
Read the guidePOS · Shipments · Inventory
How to reconcile POS, shipments and inventory data
POS records consumer sales, shipments record product entering the network and inventory records what remains. Reconcile the three through one stock equation at a stated grain
Read the guideException management
How to manage reconciliation exceptions month after month
Give every exception a record, a cause-based category, one owner, a status, evidence and an aging rule so recurring differences are resolved rather than rediscovered
Read the guideAutomation
When to automate retailer data reconciliation
Decide which reconciliation steps are stable enough to automate and which exceptions still need human review, then prove the process with a parallel pilot
Read the guideOperating model
FMCG data reconciliation: a practical operating model
Define scope, roles, intake, rules, control stages, an exception lifecycle and sign-off so the monthly run is repeatable and auditable instead of depending on one analyst
Read the guideReusable rules
How to design reusable data reconciliation rules
Turn one-off spreadsheet fixes into documented matching, tolerance, timing and exception rules that can be tested and rerun every cycle
Read the guideDistributor stock bridge
Distributor inventory and sales reconciliation: what should balance?
Reconcile opening stock, receipts, sales, returns and closing stock through one equation, with every term tied to a source event and each remaining difference a named exception
Read the guideReturns reconciliation
How to reconcile retailer returns with ERP data
Consumer returns, stock returns, credit notes and restatements are different events. Reconcile each by type, event and sign instead of treating them as one thing
Read the guideSKU, EAN and GTIN mapping
SKU-to-EAN and GTIN mapping for FMCG teams
Connect internal SKUs, retailer codes, EANs and GTINs in one canonical mapping with effective dates and an owner
Read the guideMulti-distributor consolidation
How to consolidate sell-out data from multiple distributors
Standardize distributor templates, map master data and consolidate market-level sell-out into one controlled dataset
Read the guideFile standardization
How to standardize retailer and distributor Excel files
Profile partner files, define one canonical schema and convert every source at intake without losing lineage or corrections
Read the guideSell-out dataset design
How to create a reliable FMCG sell-out dataset
Design a traceable sell-out dataset across retailers, distributors, markets, products, calendars and corrected submissions
Read the guideEditorial context
Data, signals and operating models
Supporting analysis remains available for context. These pieces are editorial material, not current service pages
Inventory planning
When inventory learns from the flight: Beirut Duty Free brings AI into daily planning
Forecasting and replenishment connect flights, passenger demand and stock decisions while keeping exceptions visible
Read the articleDemand reconciliation
Scheduled airline seats versus real airport demand: the forecasting gap
Scheduled capacity is only the first signal; operation, load factor and realised demand determine what planning can trust
Read the articleProduct data
When carbon enters the catalogue: product footprints become commercial data
Product carbon footprints become useful when identity, method, quality, version and supplier ownership travel with the number
Read the articleAI visibility
Does AI recommend you? The new battle for the Chinese traveller
Recommendations depend on information that is structured, understandable, current and connected to what can actually be purchased
Read the articleDemand forecasting
Fuel moves in days. Travel demand and airport retail take weeks to respond
Fuel, fares, capacity and traveller budgets need to be connected before the change appears in sales
Read the articlePassenger mix
Heathrow’s passenger mix is shifting. Retail needs to look beyond volume
Airport totals hide regional changes that affect routes, inventory, operations, media and category decisions
Read the articleDemand signals
Travellers are booking later, but they are not giving up the trip
A shorter booking window changes the timing and confidence of forecasts, pricing, inventory and operational planning
Read the articleConversational commerce
AI becomes a duty-free salesperson: what Lotte’s ChatGPT service changes
A trustworthy recommendation needs product data, availability, rules, fulfilment context and measurement
Read the articleCommercial reconciliation
More seats, less certainty: why capacity does not guarantee passengers
Capacity, realised demand and commercial eligibility must be separated before they become a sales forecast
Read the articlePerformance analysis
More passengers, not the same sales: what Zurich reveals
Traffic is not a direct sales forecast; exposure, conversion, basket and location explain the gap
Read the articleChannel data
When price is no longer enough: how Changi is redefining duty free
Exclusivity, experience and connected commerce create value only when product, channel and demand information align
Read the articleRetail media
From exposure to purchase: Frankfurt connects media, experience and point of sale
Measurement becomes useful when media, activation, availability and sales can be read together
Read the articleConversion analysis
Duty free grew to a record in 2025. Conversion is slipping
Value sales rose 5.5%, but passengers grew faster and spend per passenger fell. Footfall and purchase rates declined in the sector's own monitors
Read the articleTravel Retail archive
Earlier Travel Retail analysis
Earlier sector reporting remains available as historical context. The current Marksyte focus is FMCG data reconciliation and recurring data operations
Agentic AI
Agentic AI wants to book the trip
How agentic AI may reshape travel planning, booking and traveller spend, creating new opportunities for tourism, FMCG and airport retail.
Read the articleAirline disruption
Airline disruption vouchers are becoming a global commercial network
iCoupon connects airlines, airports, retail, food, hotels and transport. We examine the network, data, redemption and commercial opportunity.
Read the articleAirline ownership
Who controls an airline can also change the route map
Europe's airline ownership review may affect investment, routes and airports. We examine tourism, travel retail, demand forecasting, data and AI.
Read the articleAirport dining
The operator becomes the brand in airport dining
Lagardère Travel Retail created L'Officina entirely in-house for Warsaw Chopin Airport. The case shows how operators are moving beyond concession management to become designers, owners and developers of hospitality brands.
Read the articleAsia-Pacific
Asia Pacific is reshaping the global airport map
Asian airports are climbing the global ranking. We examine opportunities for travel retail, FMCG, concessions, retail media, data and AI.
Read the articleRegulation
Regulation becomes a commercial capability in Asia-Pacific
Asia Pacific has more than 40 regulatory regimes. We examine the impact on duty free, FMCG, airports, technology, inventory and AI.
Read the articleCircular packaging
Circular packaging in cruise and travel retail
Bacardi, ecoSPIRITS and Carnival have avoided more than 130,000 bottles. We examine opportunities for cruise, FMCG, hospitality, technology and AI.
Read the articleAirport hospitality
Banks are becoming airport hospitality operators
Chase opens an 18,000 square foot lounge at DFW. We examine loyalty, payments, dining, wellness, data and artificial intelligence.
Read the articleBorder retail
Border duty free as a commercial destination
Peace Arch is investing to turn a border stop into a destination. We examine traffic, experience, assortment, FMCG, data and artificial intelligence.
Read the articleCommercial analytics
What China Duty Free reveals about profitability
China Duty Free lifted profit while revenue declined. We examine margin, channels, pricing, Hainan, data and artificial intelligence.
Read the articleExperiential retail
China Duty Free blends retail and leisure in Sanya
cdf Sanya adds a water park and leisure services. We examine dwell time, families, FMCG, tourism, data and artificial intelligence.
Read the articleAirport operations
Biometric EES queues and airport operations
The biometric EES is creating queues at European airports. We analyse the impact on passengers, travel retail, operations, data and artificial intelligence.
Read the articleEcommerce
When ecommerce loses its low-value tax advantage
The US and EU are tightening the treatment of cheap parcels. We examine pricing, ecommerce, travel retail, logistics, data and artificial intelligence.
Read the articleTraveller behaviour
European travellers apply more filters
European travellers prioritise safety, value and access. See what this means for tourism, airport retail, FMCG, data and artificial intelligence.
Read the articleSeasonality
Heat is extending Europe’s travel season
Heat is reshaping Europe's travel season. Explore the impact on travel retail, FMCG, services, technology and AI-led demand planning.
Read the articleFragrance
Why fragrance keeps holding up
Puig closed the first half with fragrance growth, higher market share and travel retail among the strongest contributors. The category is normalising after the post-pandemic boom, but retains value engines that other segments cannot reproduce as easily.
Read the articleGenerational behaviour
How generations shop differently
New m1nd-set research shows clear differences in spend, discovery, planning, category choice, price comparison and staff response. Generation matters, but region can change the result completely.
Read the articleGen Z
Why travel essentials matter to Gen Z
Gen Z is reshaping airport retail. See how travel essentials can drive footfall, conversion, basket value and data-led growth.
Read the articleCultural demand
How K-content creates travel-retail demand
A scene in the Goblin tenth-anniversary special turned a sunscreen with no boutique or physical display into a Shinsegae Duty Free digital bestseller. The case shows how cultural demand can arrive before the commercial forecast.
Read the articleTourism
Morocco and the 2030 tourism corridor
Morocco is expanding hotels, airports and connectivity before the 2030 World Cup. We assess the new tourism corridor and its impact on travel retail and FMCG.
Read the articlePre-travel commerce
Ospree connects visa applications and duty free
Ospree and VFS Global connect visa applications with duty free. We examine pre-travel acquisition, data, personalisation, measurement and AI.
Read the articleDuty free
Sydney Airport reinvents duty free
Sydney Airport and Heinemann are reshaping duty free through MECCA, beauty services, local brands, luxury, data and a shared focus on sales.
Read the articleBeauty
Sydney renews duty free with MECCA
Sydney Airport and Heinemann are bringing MECCA into duty free. We examine beauty, local brands, Gen Z, services, data and artificial intelligence.
Read the articleDemand nodes
Visitor dispersal and new demand nodes
Visitor dispersal creates new demand nodes. We analyse opportunities for travel retail, FMCG, services, technology and AI-powered planning.
Read the article