Partner-delivered commercial case study

FMCG Store-Level Field Intelligence Platform

A mobile field-intelligence platform that converted store visits, product observations, pricing, placement and competitor context into central management visibility for major consumer brands.

Partner-delivered client work FMCG / Retail Field Intelligence / Mobile Data Capture BlackBerry application development Mobile offline-tolerant workflow Central server services Relational database
Disclosure and attribution

What this case study represents.

The solution was delivered through a partner relationship, with INESSOFT responsible for substantial application development and frequent direct technical interaction with client stakeholders. Recognised organisations supported through this work included Dairybelle, Tiger Brands, Blue Ribbon, SAB Miller, GSK and others. They are not represented here as direct INESSOFT contracting clients.

Executive summary

The operational problem, not only the final interface.

From 2012, INESSOFT developed commercial field-intelligence software alongside its game portfolio. Field agents travelled to retail stores and used a BlackBerry application to capture structured observations: the store and visit context, whether specified products and brands were present, where they were positioned, what prices were displayed and how competing products appeared. The records were synchronised to a central server and exposed through a Microsoft Silverlight reporting application. Brand and management teams could then analyse execution at store level instead of relying only on national sales totals, delayed spreadsheets or anecdotal field feedback.

Business context

Where the system had to operate

FMCG performance is shaped by what happens inside individual stores. A product may be listed nationally but absent from a specific outlet, priced incorrectly, poorly placed, outperformed by a competitor or missing a planned promotion. Management therefore needed evidence from many distributed field visits, collected consistently enough to compare stores, territories, products, brands and time periods.

Challenge

What the existing method could not control

The system had to make complex market-audit capture practical for agents standing in busy retail environments. It needed controlled products, brands, competitors, stores, questions and response types while remaining fast enough for repeated daily use. It also had to survive mobile connectivity limitations, preserve visit context and transform thousands of observations into management reporting that answered real commercial questions.

Complexity

Why this was not a generic app

The hardest part was not the form or dashboard in isolation; it was preserving meaning from the shelf to the report. A price without product, pack size, store and date is weak evidence. A placement observation without controlled categories is difficult to compare. A field application can collect large volumes of data while still producing poor intelligence if users are rushed, reference data is stale or synchronisation failures are invisible. The project crossed mobile UX, offline-tolerant workflow, data modelling, central services and analytical reporting at a time when the mobile development ecosystem was far less mature.

Solution overview

How INESSOFT approached the system boundary.

INESSOFT developed a structured BlackBerry field application, central synchronisation and data services, an operational database and a Silverlight management reporting interface. Campaign and reference data defined the stores, products, brands, competitors and questions relevant to each field programme. Agents selected the correct visit context, captured controlled observations and submitted records when connectivity allowed. Central validation made submissions comparable, while reporting allowed management to filter and compare product presence, pricing, placement and competitive conditions by store, region, campaign and time.

The platform gave participating brands store-level visibility into market execution and competitor conditions that were otherwise difficult to consolidate. It created a stable commercial software stream for INESSOFT and established an important engineering pattern that remains relevant today: mobile capture at the point of work, controlled reference data, resilient synchronisation, central SQL records and role-appropriate management reporting.

Store-level Management could inspect conditions at individual retail outlets rather than infer everything from aggregate sales.
BlackBerry Agents recorded structured observations on devices suited to the field environment of the period.
Offline-aware Capture and submission were separated so temporary mobile connectivity did not destroy the visit workflow.
Central Distributed visits became one governed set of products, stores, prices, placements and competitor observations.
Silverlight Client teams filtered and compared field intelligence through a dedicated reporting application.
Multi-brand The software pattern supported work delivered for several recognised South African consumer organisations through a partner.
Reconstructed system view

A visual model of the operating surface behind the case study.

This is a content-based reconstruction, not a client screenshot. It shows the kinds of live inputs, controlled states, modules and evidence the delivered system had to bring together.

FMCG Store-Level Field Intelligence Platform OPERATING VIEW
Store-level Market visibility Management could inspect conditions at individual retail outlets rather than infer everything from aggregate sales.
BlackBerry Mobile field capture Agents recorded structured observations on devices suited to the field environment of the period.
Offline-aware Synchronisation pattern Capture and submission were separated so temporary mobile connectivity did not destroy the visit workflow.
Central Comparable dataset Distributed visits became one governed set of products, stores, prices, placements and competitor observations.
CONTROLLED EVENT FLOW
01

A client or campaign manager defines the stores, products, brands, competitors and observations required.

02

Reference and assignment data is distributed to the relevant field users.

03

An agent arrives at a store and opens the correct visit on the BlackBerry application.

04

The application presents only the questions and product structures relevant to that campaign and outlet.

Reconstructed from the documented system boundary; confidential interfaces and client data are not reproduced.
Outcome evidence

Operational evidence is stated without invented ROI percentages.

Exact client throughput, time-saving and financial figures are not published for this system. The case study therefore limits itself to implemented controls, workflow changes and verifiable system capabilities rather than manufacturing a percentage improvement for marketing purposes.

System architecture

The responsibilities were separated before the screens were polished.

Each layer had a specific operational responsibility. This made failures easier to diagnose and prevented one screen, service or database field from becoming the accidental owner of the entire process.

01 Campaign and reference-data layer

Controlled stores, territories, products, pack sizes, brands, competitors, questions and valid response options.

02 Agent assignment and visit context

Connected each field user to the appropriate campaign, store and observation requirements.

03 BlackBerry capture application

Presented a guided mobile workflow designed for speed, repeat use and controlled responses in a retail environment.

04 Local visit state

Allowed an agent to complete meaningful work without depending on uninterrupted connectivity at every screen.

05 Synchronisation service

Transferred completed or partial visit records to the central platform and made successful submission a separate concern from capture.

06 Central operational database

Stored visits, agents, stores, products, prices, placement observations, competitor context and timestamps.

07 Validation and data-quality layer

Applied controlled reference data and consistency checks before observations were trusted for comparison.

08 Silverlight reporting application

Provided management filters, comparisons and views around the decisions the field programme was intended to support.

09 Administration and campaign change

Allowed products, stores, questions and client requirements to evolve without rebuilding the mobile application for every adjustment.

Responsibility moves through explicit layers; no single screen or integration is treated as the whole system.
Operational workflow

What happened from the first input to the final controlled result.

A case study is useful only when the flow can be understood. The sequence below shows where users, devices, databases or external systems entered the process and how responsibility moved.

01

Workflow step 1

A client or campaign manager defines the stores, products, brands, competitors and observations required.

02

Workflow step 2

Reference and assignment data is distributed to the relevant field users.

03

Workflow step 3

An agent arrives at a store and opens the correct visit on the BlackBerry application.

04

Workflow step 4

The application presents only the questions and product structures relevant to that campaign and outlet.

05

Workflow step 5

The agent captures presence, pricing, placement, competitor and exception information while inspecting the store.

06

Workflow step 6

The device validates required context and retains the visit locally where connectivity is not yet suitable for submission.

07

Workflow step 7

Completed records are synchronised to the central server when a connection is available.

08

Workflow step 8

Central services validate the records against controlled products, stores and campaign rules.

09

Workflow step 9

The operational database consolidates observations from many agents and locations.

10

Workflow step 10

Management users filter and compare results through the Silverlight reporting application.

11

Workflow step 11

The resulting evidence supports decisions about pricing, distribution, merchandising, field follow-up and competitor response.

Major modules

The practical capabilities that made the system usable.

These were not isolated feature requests. Each module supported a specific part of the operational lifecycle and shared the same data, state and accountability model.

SYS Delivered capability

User, team and territory setup

Associated field agents with the correct geography, campaign and work context.

SYS Delivered capability

Store master and visit schedule

Provided a consistent identity for each outlet and a controlled start and end to field activity.

SYS Delivered capability

Product and brand reference data

Defined exactly which products, pack variants, brands and competitors could be compared.

SYS Delivered capability

Presence and availability capture

Recorded whether the expected product was present, absent or otherwise not observable.

SYS Delivered capability

Price capture

Collected retail pricing with the product, store, date and campaign context required for analysis.

SYS Delivered capability

Placement and visibility observations

Captured shelf, display or promotional execution through controlled questions rather than unstructured narrative alone.

SYS Delivered capability

Competitor comparison

Linked competing products and brands to the same visit so management could compare execution conditions.

SYS Delivered capability

Notes and exception context

Allowed field users to explain unusual conditions without replacing structured data with free text.

SYS Delivered capability

Mobile synchronisation

Queued and transmitted records separately from the field capture sequence.

SYS Delivered capability

Data-quality review

Surfaced incomplete, contradictory or out-of-scope observations before management reporting.

SYS Delivered capability

Management dashboards

Allowed users to filter by store, territory, product, brand, competitor, campaign and time.

SYS Delivered capability

Comparative reporting

Converted individual visits into market-execution patterns and competitor insight.

Engineering decisions

Choices that protected the system from plausible failure.

The important work was often deciding what not to combine, automate or assume. These decisions made the resulting system easier to support and more honest about its boundaries.

Design around the store visit

The mobile sequence prioritised speed and context because an agent could not be expected to operate an office-style survey in a busy aisle.

Control the comparison dimensions

Products, brands, pack sizes, stores and response options were modelled explicitly so reports compared like with like.

Separate capture from synchronisation

A temporary connection problem should delay submission, not invalidate the field work already performed.

Separate collection from analysis

The BlackBerry application focused on reliable evidence capture while the Silverlight platform handled management filtering and comparison.

Retain visit context around every value

A price or observation was useful only when linked to the correct store, product, agent, campaign and time.

Use free text only for exceptions

Narrative notes supplemented structured fields rather than becoming the primary data model.

Centralise changing reference data

Client programmes change products, questions and stores. These concepts had to be configurable instead of compiled into each screen.

Present the delivery relationship accurately

The value of the work does not depend on falsely presenting partner-delivered brand projects as direct contracts.

Delivery approach

A phased path from evidence to a supportable system.

The project was broken into phases that reduced the highest-risk uncertainty first. This prevented a broad implementation from hiding an unproven data or workflow assumption.

01

Commercial question and data model

Identify what the client needed to compare and define the store, product, brand, competitor and visit relationships required to answer it.

02

Mobile field workflow

Build and test the BlackBerry sequence around real agent behaviour, repeated visits and constrained input time.

03

Synchronisation and central storage

Create a dependable transfer path, central database and clear handling of incomplete or failed submissions.

04

Reporting and comparison

Build Silverlight views around actionable questions rather than presenting raw tables as business intelligence.

05

Campaign configurability

Move changing products, stores and questions into administration so new work did not require a new application architecture.

06

Operational refinement

Use field and management feedback to shorten capture, improve validation and remove report ambiguity.

Risk controls

Operational risk was designed into the software, not added as a disclaimer.

The controls below reflect the kinds of failure that could produce wrong records, unsafe assumptions, hidden exceptions or a system users would bypass.

Inconsistent field capture

Used controlled choices, required context and campaign-specific forms rather than relying primarily on narrative notes.

Connectivity loss

Separated local visit completion from successful central synchronisation.

Wrong product comparison

Maintained controlled product, pack, brand and competitor structures.

Stale campaign setup

Centralised reference data so changes could be distributed and governed.

Unusable mobile forms

Kept the field sequence focused on the commercial questions that justified the visit.

Misleading management reports

Retained store, date, campaign and product context and applied central validation before comparison.

Lost exception meaning

Allowed notes and exception context without weakening the structured dataset.

Attribution overstatement

Public material identifies the partner-delivered nature of the work while preserving the actual engineering contribution.

Outcomes

What became more controlled or useful.

  • Store-level visibility into product presence, pricing, placement and competitor conditions.
  • Centralised field data from distributed agents and retail locations.
  • Comparable observations grounded in controlled products, brands, stores and campaigns.
  • Management reporting that moved beyond anecdotal field feedback and disconnected spreadsheets.
  • A practical basis for merchandising, distribution, pricing and field follow-up decisions.
  • Stable commercial software income for INESSOFT during its early operating years.
  • Direct experience delivering software for recognised South African brands through a partner channel.
  • A durable architecture pattern for modern inspection, audit, field-service and mobile reporting systems.
Engineering lessons

What this system reinforced.

  • Field software should be designed around the user's physical environment and time pressure.
  • A dashboard cannot repair inconsistent capture; data quality begins in the mobile workflow and reference model.
  • Comparable data requires controlled dimensions such as store, product, pack, brand, campaign and time.
  • Mobile capture and management analysis are separate products connected by the data model.
  • Intermittent connectivity should be treated as a normal operating condition, not an exceptional error.
  • Free text is valuable for exceptions but weak as the primary source of comparative intelligence.
  • Client-specific questions can sit on a reusable platform when the configurable concepts are identified early.
  • Transparent attribution strengthens credibility because the engineering value remains clear without inflating the contracting relationship.
What the platform taught us

Technical delivery created product, market and operating lessons.

These lessons came from operating the system under real users, data, commercial constraints and support pressure. They now influence how INESSOFT scopes new platforms and internal operational systems.

The data model is the commercial product

The field form and dashboard mattered, but the real asset was the controlled relationship between stores, products, brands, competitors, visits and time.

Collection design determines reporting value

Management insight is constrained by what the agent can capture consistently. Reporting requirements therefore have to influence the mobile workflow from the beginning.

Operational software should separate responsibilities

The mobile client, synchronisation service, central database and analytical interface each solved a different failure mode and could evolve independently.

Offline tolerance is a business requirement

A system serving field teams must preserve work when the network is unreliable. Connectivity is part of the operating environment, not an assumption.

Partner channels can create stable delivery

The relationship demonstrated how a specialist development company can serve major brands through a trusted intermediary while still interacting closely with end users and stakeholders.

Historical technology can contain modern architecture

BlackBerry and Silverlight are obsolete platforms, but the pattern of guided mobile capture, API or sync services, SQL storage and browser reporting remains current.

Where this pattern fits

Organisations likely to recognise the same underlying problem.

The exact sector or technology may differ. The closer match is usually the workflow shape, source data, failure modes and operational responsibility.

Relevant operating pattern

FMCG brands and distributors needing store-level execution intelligence.

Relevant operating pattern

Retail-audit teams collecting comparable observations across many locations.

Relevant operating pattern

Field-sales organisations replacing paper forms or disconnected spreadsheets.

Relevant operating pattern

Inspection and compliance teams working in variable-connectivity environments.

Relevant operating pattern

Businesses requiring mobile evidence capture linked to central management reporting.

Relevant operating pattern

Buyers assessing INESSOFT's commercial software history before Leobot and its current industrial work.

Related INESSOFT services

The service lanes most closely connected to this case study.

The case study provides evidence. The service pages define the current delivery boundary, first-step artefacts, exclusions and technical scope for a new engagement.

Service operations

Field Service Management Software

Coordinate mobile teams, customer sites, appointments, job evidence and service history from one system.

field service management software custom job card system service portal development
View service
Practical mobile web

Mobile-Friendly Operational Web Apps

Adapt an operational workflow for practical use on phones, tablets or shared shopfloor devices.

mobile web app development operational web app field data capture app
View service
Data visibility

SQL Reporting & Dashboard Development

Answer recurring management questions from an existing SQL database with governed reports, filters and exports.

SQL reporting SQL dashboard development database reports
View service
Business systems

Custom Business Software Development

Replace spreadsheet-and-email administration with a focused internal system built around your own rules, records and approvals.

custom software development business software South Africa internal business systems
View service
Command centre

Operations Dashboards & Command Centres

Give managers a near-live view of current status, exceptions, queues and operational priorities.

operations dashboard command centre dashboard SQL dashboard developer
View service
Report automation

Reporting Automation & Scheduled Exports

Schedule trusted reports, files and exception summaries so people stop rebuilding and distributing them manually.

automated reporting software scheduled SQL reports Excel export automation
View service
Technology and system context

Technologies used or directly represented by the case study.

Technology is listed for precision, but the system boundary and operating process determined the architecture.

BlackBerry application development Mobile offline-tolerant workflow Central server services Relational database Microsoft Silverlight Synchronisation and validation Reference-data administration Management dashboards and reporting
Case study FAQ

Questions a technical or operational buyer may reasonably ask.

Were the named brands direct INESSOFT clients?

No. The work was delivered through a partner relationship. INESSOFT performed substantial development and often interacted directly with client stakeholders, but the brands are not presented as direct contracting clients.

How did the platform help FMCG management?

It converted distributed store visits into structured evidence about product presence, pricing, placement and competitor conditions that could be filtered and compared centrally.

Why were structured fields so important?

A free-text note may be useful to one manager, but it is difficult to compare across hundreds of stores. Controlled product, brand, store and response data made the observations analytically useful.

Why is BlackBerry and Silverlight experience still relevant?

The specific platforms are historical, but the architecture remains current: mobile field capture, offline tolerance, central services, governed SQL data and role-based reporting.

Could the same system be rebuilt today?

Yes. A current implementation would usually use a responsive or native mobile application, APIs, SQL storage, modern authentication and browser-based dashboards while preserving the same operational responsibilities.

What did INESSOFT learn from the project?

The project established that good reporting starts in the field workflow, that reference data is central to comparability and that operational software must be designed around the real environment in which evidence is created.

Related case studies

Other systems with overlapping engineering or operational patterns.

View all case studies
Promotional Staffing / Talent Discovery / Marketplace Platforms

PromoStars: National Promotional Talent Discovery Platform

A curated national platform that turned promotional-model profiles, location and service data, searchable discovery pages, shortlists, PDFs and enquiries into one structured demand-and-supply system.

Named owned platform ASP.NET Core Razor Pages
Field Services / Engineering Services

Field Service Operations Portal

A browser-based operations portal that brought customer sites, jobs, inspections, evidence, reports and service history into one controlled workflow.

Anonymised client delivery ASP.NET Core Razor Pages
Electronics Retail / Ecommerce / Education Products

Leobot Electronics Ecommerce and Operations Platform

A long-running electronics commerce and operations platform that grew from surplus imported components into a technical catalogue, fulfilment system, internal-tool ecosystem and commercial engineering asset.

Named owned platform C# and .NET ASP.NET and Razor-based web systems
Use the case study as a starting point

Does your operation have the same shape of problem?

Bring one real artefact: a report, spreadsheet, machine signal, job record, certificate, import file, device or system error. INESSOFT can map the current process and define a credible first phase.