01
The challenge
Two stores, two sites, a brand-new inventory.
Sports aux Puces has two stores, in Gatineau and Aylmer: new and used gear, rentals and a workshop.
The store had just moved to Lightspeed. Online, each store had its own site, nearly the same catalogue, in English by default, and the export of 1,837 products had names, categories and photos to fix.
- Two sites
- Missing photos
- Categories
- English by default
02
What we built
An online store wired to the inventory.
We built the sapoutaouais.com store on top of Lightspeed. At a glance:
- 01
The catalogue synced with Lightspeed every 3 hours
Lightspeed - 02
Shop by sport: 15 sports
Browse - 03
Search that suggests sport, brand and product
Search - 04
The chosen store’s stock on every product
Stock - 05
The cart, then checkout in Lightspeed
Cart - 06
Rentals and workshop with Lightspeed prices
Services - 07
745 product photos made uniform
Photo - 08
The full site in English, 3,185 strings
Bilingual
By sport
Fifteen sports, each with its product types, filters showing counts, removable chips and five sort options.

The product
Sizes, widths and the chosen store’s stock. Add to cart opens a side cart with Quebec taxes, then checkout happens in Lightspeed with the pickup store already chosen.

Rentals and workshop
Rental and workshop prices come straight from Lightspeed: what changes in store changes on the site.

The stores
Map, hours and Google reviews for each store. Both old sites now redirect to sapoutaouais.com.

03
Before and after
745 photos, without fixing Lightspeed one by one.
The planned way to fix the catalogue: export, approve every row in a spreadsheet, find every photo, edit Lightspeed in small batches, check, then compare by hand.
What we did: scripts find the manufacturers’ photos, put them on the same grey backdrop, and each photo is checked before upload. 745 photos published, all verified identical in Lightspeed.
A catalogue to fix by hand
- Spreadsheet
- Small batches
- Compare by hand
1,837products to review
Uniform photos, online
- Automated
- Verified
- In sync
745photos published
04
The results
- 1,879products online today
- 745photos published and verified
- 3,185English strings written in Lightspeed
- 15sports to shop
Under the hood
The site reads Lightspeed every three hours and never writes to it. Checkout stays in Lightspeed. Photos go through a pipeline with a review sheet before every upload.

