The verdict in three sentences
Adding hundreds of products one by one is a launch killer: budget 3 to 4 days of typing. The 2026 method is a clean CSV template plus a mapped import that loads 500 SKUs in under an hour, with row-by-row validation. Bonus: to change 200 prices, you re-import the same file instead of retyping everything.
The file template that passes first time
Imports almost always fail on fuzzy columns. Lock a template with required columns and validation rules.
| Column | Required | Validation rule |
|---|---|---|
| name | ✅ | text, not empty |
| sku | ✅ | unique, no spaces |
| price | ✅ | integer FCFA |
| stock | ✅ | integer >= 0 |
| category | ✅ | exists or created |
| variant | no | size/color |
| image_url | no | valid https link |
| description | no | free text |
Key rules: unique SKU (duplicates rejected), numeric price with no "FCFA" or spaces, positive integer stock. A pre-filled template with 2 example rows avoids 80 % of errors.
From several days to under an hour
| Step | Manual entry | CSV import |
|---|---|---|
| 500 products | 3-4 days | 20-40 min |
| Image upload | one by one | bulk by URL |
| Duplicate detection | human eye | automatic on SKU |
| Error report | none | row + reason |
| Price update (200) | 1 day | 5 min re-import |
| Typo risk | high | validated pre-import |
The flow: we map your Excel columns to store fields, validate in a dry run, the system flags each faulty row with its reason, you fix, then run the final import. Images load in bulk via URL or a ZIP archive.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Mini case study
Fatou, who runs a fine-grocery store in Dakar, launches with 480 SKUs in Excel. By hand at ~40 products/hour, she'd need ~12 hours over 3 days, with guaranteed typos. With the CSV template and mapped import she loads everything in 35 minutes, fixes 12 flagged rows, and publishes the same day. Savings: ~11 hours, roughly 3 days of launch delay avoided — and every delayed day is revenue not collected.
FAQ
What file format do I need? A UTF-8 CSV (exported from Excel or Google Sheets). We provide a template with required columns and two example rows to copy.
How are duplicates handled? Detection is on the SKU: any row with an existing SKU is flagged in the report and nothing is overwritten without your consent.
What if a row has an error? The dry-run import lists each faulty row with the reason (non-numeric price, unknown category, broken image). You fix and rerun; valid rows go through.
Can I update prices later? Yes, that's one of the big wins. You edit the price column in the same file and re-import: 200 prices updated in 5 minutes instead of a day of clicking.
Are images imported too? Yes, via an https URL in the image_url column, or a ZIP archive named by SKU. No more uploading each photo by hand.
Let's talk about your project. We hand you the CSV template and import your full catalog in one session. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
