STUDY CASE / LUMINAIRES ET CIE
bulk import of complex products on shopify
Luminaires & Cie was hitting the limits of Matrixify and Shopify when importing their complex product catalog. Our team built a custom solution that works around these technical constraints and fully automates product data creation... turning a tedious, manual process into a seamless, scalable workflow.
THE CLIENT
A lighting pioneer
in Quebec since 1986
Luminaires & Cie is a retailer specialized in decorative and architectural lighting. A family-owned business founded in 1986, it built a solid reputation through the variety and exceptional quality of its offerings.
Its website serves both as a transactional storefront for online customers and as an internal catalogue for its 15 in-store advisors. The convergence of digital and retail is at the heart of their omnichannel strategy.
THE CHALLENGE
Data creation could no longer keep up with growth.
Every product listing was a semi-manual process. Matrixify, complex Excel grids, constant juggling between formats. With around 50 suppliers each delivering datasheets in their own format, often incomplete, sometimes English-only, standardization was a never-ending project.
Each fixture can exist in dozens of different combinations: metallic finishes, dimensions, glass colors. Managing variants was a headache, compounded by Shopify's own technical limits. French-English translation through Langify remained laborious. Images came from diverse sources and were never standardized. And no metafield strategy had been implemented to structure data and optimize search. The catalogue was a prisoner of its own processes.
THE COMPLEXITY
What made large-scale importing impossible
50 suppliers,
50 formats
Each supplier delivers datasheets in its own format, with incomplete or poorly structured fields. Standardization was a permanent job.
Thousands
of variants
Metallic finishes, dimensions, glass colors. Each fixture can exist in dozens of combinations. Shopify limits to 3 options per product.
Laborious
translation
French-to-English translation through Langify was time-consuming and costly. Every word is billed. Every product sheet was translated manually.
Zero metadata
strategy
No structuring around metafields and meta-objects. Product data existed but wasn't usable for search and filtering.
Non-standardized
images
Visuals from diverse sources (Google Drive, Dropbox, direct links), requiring manual processing before every upload.
Semi-manual
process
Matrixify, complex Excel grids, copy-paste between systems. Every import was an exercise in patience. Time-to-market could no longer keep up.
THE SOLUTION
A custom tool that reads, normalizes,
structures, and publishes automatically
We developed a mass import tool designed specifically to interface with Shopify and optimized for Luminaires & Cie's requirements. At its core: an intelligent system that reads a standardized Excel template with over 50 columns. Data from all suppliers flows through the same format.
ARTIFICIAL INTELLIGENCE
Automated translation. And that's just the beginning.
The language barrier, previously a real brake on growth, is now resolved. An automated translation process is integrated directly into the Excel file. The tool also has an evolving translation capability based on OpenAI's artificial intelligence.
In parallel, AI can enrich and structure data upstream: automatic attribute classification, value standardization, inconsistency detection. Every product sheet comes out complete, clean, and ready for use. Teams are freed from low-value repetitive tasks.
THE RESULTS
A catalogue that feeds
itself automatically.
The numbers that summarize the transformation.
30k
SKUs ONLINE
Complete catalogue
in Shopify
5,000 products representing nearly 30,000 different SKUs, imported and structured automatically.
50
SUPPLIERS NORMALIZED
One format,
all sources
50 suppliers with heterogeneous datasheets, processed through a single 50+ column template.
90%
VARIANT EFFICIENCY
Automatic
structuring
The tool automatically identifies the right variant combinations with an 85-90% efficiency rate.
15
IN-STORE ADVISORS
The site as a physical
sales tool
Advisors browse the web platform daily, turning the site into a true in-store sales tool. Digital and retail convergence.
Marc-Olivier Gélinas
Project manager
Imarcom fait preuve de créativité technologique et de savoir-faire hors norme dans un environnement web et omnicanal.
C'est avec passion, détermination, implication et professionnalisme que se dessine notre partenariat. - EN
Let's talk!
From seamless integrations to applied AI, we deliver solutions that drive your ambitions forward.
Thank you for your interest
We have received your request and will contact you shortly!
Have a great day