One catalogue, two suppliers, zero copy-paste.

Two suppliers. One incomplete product record.

METIC sells what two local distributors stock. Each supplier provided different parts of the information, and neither supplied a complete record ready for the shop. We needed to bring those sources together, identify the products correctly and make the catalogue easier to maintain.

From partial matches to a complete catalogue.

Decoding one supplier’s manufacturer references increased matches in an open product database from 22% to 56%. Manufacturer websites and AI-assisted research supplied the remaining content.

The 56% figure describes matching in that one database; it is not the final catalogue-completion rate.

A Shopify storefront built around the catalogue.

We created a custom theme with navigation across seven product families, filters for the details customers need when comparing equipment, dedicated mobile layouts and product pages showing availability and delivery information.

METIC · Laptops

1Filters by availability, price, brand, type and screen size2Live product count for every collection3Photos trimmed, centred and normalised to 1600 px4Brand above every title, read from the record

1. 1Filters by availability, price, brand, type and screen size
2. 2Live product count for every collection
3. 3Photos trimmed, centred and normalised to 1600 px
4. 4Brand above every title, read from the record

METIC · Product

1Brand and type link into their collections2Live availability, straight from the sync3Free-delivery threshold on every product

1. 1Brand and type link into their collections
2. 2Live availability, straight from the sync
3. 3Free-delivery threshold on every product

9:41

The migration covered products, stock, images, collections, menus and the French locale, with every count checked against the source.

Catalogue, data and the sync engine.

Lenovo IdeaPad Slim 3Laptop

Logitech G Astro A30Headset

HP DeskJet 2975Printer

APC Back-UPS BX 1200 VAUPS

Logitech MK345Keyboard and mouse

HP 17AToner

Supplier files were often 225–500 px, and some had no photo at all. Every store photo is trimmed, centred and exported at 1600 px.

Consistent pricing, delivery and stock.

A training platform with its own website.

We developed a French-language platform for 34 courses and 84 scheduled sessions. It manages course information, enrolment requests, staff approval, tablet attendance sheets with a paper backup, and completion certificates generated from attendance.

METIC · Training

1Generated from the platform, rebuilt on publish and every six hours2Enrolment requests go to staff for approval3Illustrations made with AI image generation, approved one by one

1. 1Generated from the platform, rebuilt on publish and every six hours
2. 2Enrolment requests go to staff for approval
3. 3Illustrations made with AI image generation, approved one by one

The catalogue, always in step with the back office.

The public website is generated from the same course and session records. It rebuilds when information is published and every six hours, so the team does not have to maintain a second course catalogue by hand.

METIC · Formations

Scrolling preview

METIC · Calendar

1Filter by category and by month2Every session comes from the back office3Duration and location on each session4Status updates on its own

1. 1Filter by category and by month
2. 2Every session comes from the back office
3. 3Duration and location on each session
4. 4Status updates on its own

Sign-in sheets by half-day

Certificates from attendance

The supplier tracker’s morning list.

A small French-language web app. Its home screen lists what needs attention, including where the store has drifted from the catalogue on price, stock or status.

Supplier tracker

1New references, sorted into new products and close variants2Where the store drifted on price, stock or status3Fetch on demand, or automatically each morning

1. 1New references, sorted into new products and close variants
2. 2Where the store drifted on price, stock or status
3. 3Fetch on demand, or automatically each morning

Research with review built in.

The measured AI research cost was approximately $0.27 per product. Low-confidence matches are flagged, and nothing enters the workbook without validation.

Supplier tracker · AI enrichment

1Measured cost: about $0.27 per product2Low-confidence matches are flagged, never published3Every source must actually have been opened4Nothing enters the workbook without validation

1. 1Measured cost: about $0.27 per product
2. 2Low-confidence matches are flagged, never published
3. 3Every source must actually have been opened
4. 4Nothing enters the workbook without validation