Case study: QR-based ordering system for a retail exhibition

The problem with paper-based exhibition ordering

Retail exhibitions and trade shows are high-energy, high-stakes events. Buyers are making purchasing decisions quickly, sales staff are managing multiple conversations simultaneously, and every minute counts. In this environment, the ordering process needs to be fast, accurate, and reliable.

For many retailers, though, the ordering process at exhibitions still looks like it did twenty years ago: paper forms, handwritten product codes, and manual tallying. This creates a cascade of problems that directly impact the bottom line.

The typical issues include:

• Handwritten orders are difficult to read, leading to transcription errors when entering into the system later
• Sales staff spend time on admin instead of engaging with customers
• There's no real-time visibility into what's selling and what's not — you only find out after the event
• Reconciling paper orders after the event takes hours and often reveals errors that are expensive to fix
• The overall pace of ordering creates a bottleneck that limits how many customers can be served

When Furniture Court approached LovelyPixel, they were dealing with exactly these challenges. Their exhibitions were successful, but the ordering process was holding them back from being even more effective.

The brief: make ordering fast, accurate, and visible

The requirements were clear and practical:

• Speed: ordering needed to be faster than paper — not slower
• Accuracy: eliminate transcription errors entirely
• Visibility: real-time data on what's being ordered, by whom, and in what volumes
• Simplicity: the system needed to work on any device without installing an app — buyers would scan a QR code and go
• Reliability: it had to work perfectly during the event with no downtime

There was no room for a half-working solution. Exhibition days are the most commercially important days of the year for many retailers — the system had to be bulletproof from day one.

The solution: QR codes linked to a mobile ordering platform

We designed and built a complete digital ordering platform tailored specifically for the exhibition environment. Here's how it worked:

Product QR codes

Every product displayed at the exhibition was assigned a unique QR code. These codes were generated from the product catalogue and printed on display cards next to each item. When scanned, the QR code opened a mobile-optimised ordering page for that specific product — no app download, no login screen, just the product ready to add to an order.

Mobile ordering interface

The ordering interface was built as a responsive web application. Buyers could:

• Scan a QR code to add a product to their order
• Adjust quantities, select variants (colour, size, configuration)
• Review their complete order before submitting
• Add notes or special instructions
• Submit the order digitally — with confirmation sent immediately

The interface was designed for speed. Large buttons, clear product information, and a streamlined flow meant that placing an order took seconds rather than minutes.

Real-time admin dashboard

While buyers were placing orders on the exhibition floor, the admin team had access to a live dashboard showing:

• Total orders and revenue in real time
• Most popular products and categories
• Order-by-order detail with buyer information
• Trend data throughout the day (peak hours, momentum shifts)

This visibility was transformative. For the first time, the team could see what was selling as it sold — and make decisions during the event, not after it.

Automated confirmations and reporting

Every order triggered an automatic confirmation to the buyer. After the event, the complete order dataset was available for export — clean, structured, and ready for reconciliation with minimal manual work.

Technical decisions that mattered

Building a system for a live event with hundreds of simultaneous users requires specific technical decisions. Here are the ones that made the difference:

Progressive web app approach

Rather than building a native app (which would require downloads and app store approval), we built a progressive web app that ran in any mobile browser. Scan the QR code, open the page, start ordering. No friction, no barriers.

Offline resilience

Exhibition venues don't always have reliable WiFi. The system was designed to queue orders locally if the connection dropped, then sync automatically when connectivity resumed. No orders were lost, even with patchy network conditions.

Database optimisation

With potentially hundreds of orders being submitted within the same minute, the database needed to handle concurrent writes efficiently. We optimised the schema for write-heavy workloads and implemented connection pooling to prevent bottlenecks.

QR code resilience

QR codes were generated with high error correction levels, meaning they remained scannable even when partially obscured or printed at smaller sizes. Each code was also linked to a human-readable fallback URL for manual entry if needed.

Results

The system was deployed at a major Furniture Court exhibition and the results exceeded expectations:

• Record sales outcome: the exhibition supported record sales for the client — a direct correlation with the improved ordering speed and reduced friction
• Zero ordering errors: digital orders eliminated the transcription errors that plagued paper-based processes
• Real-time visibility: the admin dashboard gave the team live insight into sales trends, enabling in-event decision-making for the first time
• Faster reconciliation: post-event processing was reduced from hours to minutes, with clean, structured data ready for export
• Staff freed up: with ordering handled digitally, sales staff could focus entirely on customer engagement and product knowledge

Lessons learned

A few key takeaways from this project that apply to any event-based or retail ordering system:

Simplicity wins at live events

Every extra tap, every extra field, every extra second adds friction. At a live event where people are busy and distracted, the simplest possible flow is always the right one. We stripped the ordering interface down to the absolute essentials and it paid off.

Real-time data changes behaviour

Giving the team live visibility into sales didn't just make reporting easier — it changed how they operated during the event. They could identify slow periods, redirect attention to popular products, and make decisions based on data rather than gut feeling.

Test with real conditions

We tested the system under simulated event conditions — poor WiFi, hundreds of concurrent users, rapid-fire orders. This testing caught several issues that wouldn't have appeared in a standard development environment.

Reusability and future events

The system was designed to be reusable. For each new exhibition, the product catalogue can be updated, new QR codes generated, and the system deployed with minimal setup time. This turns a one-off project into a long-term business asset that improves with each use.

Future enhancements could include integration with inventory management systems, buyer authentication for repeat customers, and more detailed analytics on browsing behaviour (which products are scanned but not ordered).