Case study · Retail

Five locations, one platform — daily reconciliation cut from 2 hours to 11 minutes

A fashion retailer ran each of its five stores on a separate Square POS and closed every day by hand. In 12 weeks we moved all five onto one Odoo platform for POS, inventory, and accounting.

Published Updated

Results at 90 days

91%faster end-of-day close across all five stores

Daily reconciliation 2 hours → 11 minutes

Before2 h
After11 min

Separate POS systems 5 → 1

Before5
After1
Client
Fashion retailer
Industry
Fashion retail
Size
5 locations · 45 employees
Modules
Point of Sale, Inventory, Accounting, Loyalty, CRM, Purchase
Timeline
12 weeks
Previous system
5 separate Square POS instances
Engagement
Implementation, pilot store first, then two waves

Before · 5 stores, 45 employees

The situation

The retailer grew one store at a time, and each location ran its own Square POS. There was no central view of inventory or finances.

Over two hours to close every evening

Finance combined five cash-up reports and exported sales into one daily P&L by hand. On weekends it often ran until midnight.

Transfers on a stale Google Sheet

Stock moving between stores was tracked on a shared Google Sheet that was always out of date.

No view of other stores' stock

When a customer wanted an item held at another store, staff had no reliable way to check.

Loyalty points stuck in one store

The loyalty program was store-specific. Points earned at one location could not be used at another.

The cause was structural: five independent systems that could not share data in real time.

Discovery

What we found

The core problem was fragmentation. Every store kept its own copy of the catalog, and none of them agreed for long.

Five catalogs, five sets of rules

Each Square terminal had its own product catalog, pricing, and discount rules, all maintained separately.

A price change took 45 minutes

A promotional price meant updating each terminal by hand, and the five stores still often ended up with different prices.

A SaaS platform looked costly

The client had considered a SaaS retail management platform but was concerned about the cost.

The stores had to keep trading

The team doubted it could run a complex migration with stores open. It needed a phased approach with minimal disruption to daily trading.

12 weeks · four phases

What we did

One catalog first, then a pilot store, then the other four, then the automation that closes the day.

  1. Weeks 1–3

    One catalog, one price list

    We exported products from all five Square instances and merged and deduplicated 2,400 SKUs into one catalog. Pricelists are managed centrally, with overrides for individual locations.

  2. Weeks 4–6

    Pilot store go-live

    Odoo POS went live at the highest-traffic store first and ran in parallel with Square for two weeks to verify transaction accuracy. The store manager and all floor staff were trained.

  3. Weeks 7–9

    The other four stores

    The remaining four stores went live in two waves, two stores per week. Each one had dedicated go-live support on its first trading day.

  4. Weeks 10–12

    Automated close and shared loyalty

    Automated end-of-day reconciliation with exception flagging, a loyalty program that works across locations, and a daily performance dashboard for the finance team.

Project at a glance

  • 12 weeks across four phases
  • 2,400 SKUs merged into one catalog
  • Two-week parallel run with Square at the pilot store
  • Go-live support at every store on its first trading day

Running multiple retail locations?

We will scope your unification project in a 30-minute call.

Book a discovery call

Measured at day 90

Results at 90 days

91%Faster end-of-day closeEnd-of-day close across all five stores, measured at 90 days
2h→11mDaily reconciliation timeEvening reconciliation for five stores at 90 days; it now runs automatically
340Cross-store loyalty redemptionsCounted over the first 90 days; the capability did not exist before
AreaBeforeWith Odoo, configured by us
Daily closeOver two hours of manual cash-upsAutomatic; finance reviews the exception report
Price changes45 minutes, terminal by terminalCentral pricelists with store overrides
Stock transfersA shared Google SheetTracked in real time
Other stores' stockNo reliable way to checkChecked from the POS, mid-conversation
LoyaltyPoints locked to one storeRedeemable at all five stores

Discrepancies above a set threshold are now flagged for investigation as soon as the close runs.

Odoo apps

Modules deployed

Six Odoo apps on one database, with Point of Sale running on a terminal in each of the five stores.

  • Point of Sale (×5 terminals)
  • Inventory
  • Accounting
  • Loyalty
  • CRM
  • Purchase

Ready to unify your retail operations?

The first call takes 30 minutes.

Or email sales@octagotech.com