Entrusit case study · Retail & e-commerceSmart Product Import — messy supplier sheets to a clean catalogue
An Excel file and a folder of photos in; grouped, enriched, shop-ready products out.
supplier.xlsx
your catalogue
The problem
Supplier catalogues arrive as spreadsheets with variable codes, colours and sizes mixed into one column, names in one language only, and photo folders that follow two different naming rules. Importing one by hand took days and a manual "needs review" file.
What we built
A staged import wizard that maps columns, cleans and enriches data, groups colour and size variants without touching the client's product codes, matches images and parks anything doubtful in a review queue.
How it works
- 1Upload the spreadsheet and a zip of images; columns are auto-detected and you confirm the mapping.
- 2Codes, names, colours, sizes and categories are cleaned and fuzzy-matched to your taxonomy.
- 3Variants are grouped point-and-click; images are matched by EAN, code or filename.
- 4Rows with missing data, duplicates or a photo whose colour doesn't match go to review; the rest are applied or exported.
Highlights
- Product codes stay byte-identical to your POS
- Flags mislabelled supplier photos by colour
- Self-serve, or run for you by our team
Stack & integrations
- Laravel + Inertia/Vue wizard
- Chunked queue jobs
- Image colour analysis
- Excel import/export
Security & your data
How we handle your data
- NDA before the first call
- Least privilege, read-only by default
- Humans approve sensitive actions
- You own the code and the data
- Your accounts and infrastructure
- GDPR and Macedonian data protection law
Entrusit · info@entrusit.com · +389 77 761 248 · entrusit.com
https://entrusit.com/work/smart-product-import/
Related projects
- ShippedDoc Intelligence — purchase intake that learnsSupplier documents read, checked against their VAT recap and turned into purchases — and every correction teaches the system.Read the case →
- ProductSmart Scan — AI document processing into the ERPSupplier invoices, receipts and bank statements read, checked and posted — no re-keying.Read the case →
- ProductAsk Your Finances — an AI agent over your booksChat with your bank statements, purchases, expenses and sales — and get told what doesn't reconcile.Read the case →
Project 03 of 16
Want something like this?
Tell us about your version. The first 30-minute process teardown is free, and we'll sign an NDA before it.