PrestaShop dropshipping module SDE MAISON
🛏️ 🍽️ 🪟
SDE Home Linen Dropshipping Module
The module that automates from A to Z your French textile dropshipping with Maison Vivaraise on PrestaShop
PrestaShop 1.7 → 9.x · 7 languages · CRON 24/7 · Made in France
Do you sell home linen, decoration or tableware in dropshipping? Do you work with SDE / Maison Vivaraise and spend your days copying Winkler and Sel & Poivre product sheets, reformatting multilingual descriptions, uploading photos from their photo library, recalculating your retail prices with your margin, manually creating hundreds of nested categories?
With the SDE home linen dropshipping module, everything becomes automatic. You provide the URL of the Maison Vivaraise CSV, you click "Start import", and the module creates your multilingual PrestaShop products in 7 languages right before your eyes, in real time, inside a ready-to-use category tree.
⚡ Before vs After the SDE Module
| Task |
❌ Without the module |
✅ With the module |
| Import 1,000 home linen references | 15h+ manual, copying from the SDE portal | 1 click, ~40 min in the background |
| Multilingual 7 languages | Paid DeepL or manual writing | Native FR/EN/DE/ES/IT/NL/PT texts from CSV |
| Category tree | Manual creation of dozens of categories | 7 cats + 38 sub-cats created at install |
| Size + color variants | Manual creation SKU by SKU | Auto grouping via "parent" field as PS combinations |
| Multi-images (up to 10/product) | Manual download from photo library | Auto from CDN, resized for PS |
| Sustainable labels (Oeko-Tex, Organic, Made in France and more) | Manual writing in description | Filterable PS Features on the front |
| Margins & retail prices | Excel calculation product by product | 5 automatic % tiers per price bracket |
| Latin-1 (ISO-8859-1) encoding | Accent bug: "40�C" instead of "40°C" | Auto cell-by-cell conversion to UTF-8 |
👤 Who is this module for?
🛏️
Online home linen shop
You sell bedding sets, sheets, duvets, pillowcases and want to expand your catalog without managing physical stock at SDE / Maison Vivaraise.
🇫🇷
Made in France e-commerce
You highlight French products certified Oeko-Tex, European linen, Made in France. The module creates filterable Features that showcase these labels.
📈
Scaling dropshipper
You manage 1,000+ textile references manually and lose time on operations. The module gives you back hours every week.
🎯 Full features of the SDE Module
🌳 Ready-to-use category tree
At install, the module automatically creates 7 main categories + 38 sub-categories under your PrestaShop root category, already translated into 7 languages:
| Main cat. |
Sub-categories |
| 🛏️ Bed | Duvet covers · Pillowcases · Fitted & flat sheets · Bedspreads & quilts · Sleep masks |
| 🛁 Bath | Bath towels · Beach towels · Washcloths · Bath mats · Ponchos · Toiletry bags |
| 🛋️ Decor | Throws & blankets · Cushions · Outdoor cushions · Chair pads · Curtains & sheers · Poufs · Stools |
| 👜 Accessories | Bags · Pouches · Office accessories · Hot water bottles · Handkerchiefs |
| 👨🍳 Kitchen | Aprons · Oven gloves · Pot holders · Tea towels & hand towels · Chef hats · Kids cooking |
| 🍽️ Table | Tablecloths · Napkins · Table runners · Placemats · Table accessories |
| 🪟 Rugs | Decor rugs · Hallway rugs · Kitchen rugs · Outdoor rugs |
- Multilingual 7 languages at install (FR/EN/DE/ES/IT/NL/PT): "Cuisine" becomes "Kitchen", "Küche", "Cocina", "Cucina", "Keuken", "Cozinha"
- Safety net: if you manually delete a category from the PS BO, it is automatically recreated when you next open the module (idempotent, cross-language, auto-deduplication)
- Customizable root: Home by default, or any category in your tree
🧠 Smart CSV → category mapping
For each CSV row, the module resolves the category in 4 smart steps:
1
DB mapping
If the same CSV-cat has already been resolved → we reuse the association.
2
Static mapping
Internal table ~100 entries: "Tabliers", "tablier", "Tablier" → Kitchen › Aprons.
3
Fuzzy ≥75%
similar_text similarity with the predefined sub-cats. Match if best ≥75%.
4
Fallback "Other"
Sub-cat "Other › To classify": never an error. Re-mappable manually from the dedicated tab.
Category mappings tab in the BO: table auto-loaded when the module opens, listing all resolved mappings. Each row offers a selector for the 38 sub-cats with a Re-map button that moves all affected products to the new target.
🧵 Variants by parent (size + color)
The SDE CSV contains a parent column that groups multiple SKUs sharing the same base product. In "grouping enabled" mode (default), the module creates 1 PrestaShop product with its size + color combinations:
| SDE SKU | parent | size_fr | color_fr | Result in PrestaShop |
|---|
2246035000 | SEL & POIVRE | 80x85 | ROUGE | 1 product "Apron Sel & Poivre"
3 combinations:
· 80x85 / Red
· 100x100 / Red
· 80x85 / Blue |
2246035001 | SEL & POIVRE | 100x100 | ROUGE |
2246035002 | SEL & POIVRE | 80x85 | BLEU |
- Switch on/off in Settings: enable "1 product per raw SKU" if you prefer not to group
- Stock per combination managed automatically
- CSV SKU = PS reference per combination
- EAN per combination if provided in the CSV
🌐 Multilingual 7 languages — European markets
| 🇫🇷 French |
🇬🇧 English |
🇩🇪 German |
🇪🇸 Spanish |
🇮🇹 Italian |
🇳🇱 Dutch |
🇵🇹 Portuguese |
- 35 multilingual columns in the CSV: name, color, size, category, matter, care, description × 7 languages
- Automatic encoding conversion: the CSV is in Latin-1 (ISO-8859-1), the module converts cell by cell to UTF-8
- Automatic detection of active PS languages with a CSV equivalent
- Smart mini-description: extracted from the first 2 sentences if the CSV provides one, auto-generated otherwise (never overwritten)
- Clean slug (link_rewrite) without accents, per language
🌱 PS Features — Filterable sustainable labels
The module automatically creates PrestaShop Features (filterable on the front via faceted search) from the CSV:
🇫🇷 Made in France
🌾 European Flax
🛡️ Oeko-Tex Standard 100
💚 Oeko-Tex Made in Green
🌿 Organic
♻️ Recycled
♺ Upcycled
🇫🇷 Printed in France
🧵 Composition (matter)
🎨 Collection (theme)
🌍 Country of origin
Your customers can filter their browsing by "Made in France", "Organic", "Oeko-Tex"… A strong selling point for eco-conscious / CSR audiences.
📸 Multi-images up to 10 per product
- 10 columns in the CSV:
image-url-1 to image-url-10 (absolute URLs to the Maison Vivaraise CDN)
- curl download with custom User-Agent, redirect following
- Format validation via
getimagesize(): JPEG/PNG/GIF/WebP, corrupted files rejected
- 1st image = cover automatically
- Auto generation of all PS sizes (small, medium, large, home_default and more) via
ImageManager::resize()
- Multilingual caption using the product name in each language
- "Image in description" option: injection of the 1st image directly into the long description (on-page SEO boost), at the start or end position
⚡ Real-time import architecture
The scenario that changes everything:
- 📥 Preparation: the module downloads the CSV from the SDE URL and caches the rows as JSON
- 🚀 "1 product = 1 AJAX call" import: no 30-minute freeze, you see each product created one by one
- 📊 Golden progress bar: live percentage + X/Y counter
- 📋 Console-style live log: colored badge (Created / Updated / Skipped / Error) + SKU + name + PS ID#
- ⏸️ Stop button at any time, resume possible
- 📈 Live stats: Created · Combinations · Updated · Skipped · Errors
→ No more lagging page. No more worry. You see everything that happens.
⏰ CRON 24/7 — 3 automated actions
| CRON action |
Role |
Recommended frequency |
full_import | Full catalog import (creation + light updates) | 1×/day |
light_sync | Update prices + stock + availability of already imported products (light mode) | every 2-4h |
cleanup_logs | Purge logs > N days (configurable retention) | 1×/week |
- 32-character hex secret key generated at install — your CRON URLs cannot be guessed
- 1-click regeneration of the key in case of leak
- Asynchronous self-restart: the module recalls itself in the background if the time-budget is reached (60s by default, configurable) — no Apache 5xx timeout
- Precise resume: resumes exactly where it stopped
- Anti-concurrency lock via flock: no parallel executions
- CSV download retry 3× with backoff 2s/4s/6s
- Stop button in the BO to cleanly stop a running CRON (saves state for resume)
- Test mode with configurable product limit, URLs auto-refreshed live
- Real-time status in the BO: current page, created, updated, errors
💰 Configurable margins & SEO
4 price calculation modes
| Mode | Description |
|---|
| RRP | Recommended retail price from supplier as is — the simplest |
| Tiers ⭐ | Different % depending on the purchase price bracket (5 default tiers, configurable) |
| Fixed markup | A single % applied to all products |
| Wholesale | Purchase price as is (B2B sales) |
Customizable SEO templates
- Meta title / meta description with variables:
{name}, {brand}
- Multilingual PS Tags auto-generated from brand + category + color + theme + matter (per language)
- Smart mini-description: extracted from the first 2 CSV sentences if provided, auto-generated otherwise
- Auto-disable on out-of-stock (option) or "keep visible for SEO"
🛠️ Maintenance — Selective deletion 5 checkboxes
- ☐ Imported products: detection from 4 sources (meta, supplier, product_supplier, category mapping), compatible with PS9 multi-shop quirk with SQL wipe fallback on 25 related tables
- ☐ Orphan attributes (Size / Color): deletes values + groups if no combination uses them anymore
- ☐ Orphan brands: deletes manufacturers without any product
- ☐ SDE - Maison Vivaraise supplier: deletes the supplier only if it has no remaining linked products
- ☐ Internal logs: truncate of the history and import_errors tables
Triple confirmation (dialog box + typing DELETE + button). The category tree is managed by the module and cannot be broken by the user.
🏷️ The Maison Vivaraise / SDE catalog
Maison Vivaraise (sde.fr) is a French B2B home linen player. Catalog represented by brands and collections:
Winkler
Sel & Poivre
Maison Vivaraise
+ seasonal collections
Categories covered: bed linen, bath linen, tableware, textile decor, kitchen, rugs, accessories. Many products certified Made in France, Oeko-Tex, European Flax, Organic.
⭐ 12 reasons to choose the SDE Module
- 🚀 3-minute installation: CSV URL + tree created + start the import
- 🌳 Ready-to-use tree: 7 cats + 38 sub-cats created at install (multilingual 7 languages)
- 🧠 4-level smart mapping: static → fuzzy → fallback → manually re-mappable
- 🌐 Native multilingual 7 languages without DeepL or manual translation
- 🧵 Variants by parent: SKU grouping into size + color combinations
- 📸 Multi-images up to 10/product with format validation
- 🌱 Filterable PS Features: 8 sustainable labels (Made in France, Oeko-Tex, Organic and more) + composition + collection + origin
- ⚡ Real-time product-by-product import: live bar, console log, Stop button
- ⏰ CRON 24/7 with time-budget, asynchronous self-restart, retry, lock
- 🛡️ Compatible PS 1.7 → 9.x:
SdCompat compatibility layer that handles all versions, including the PS9 meta_keywords → ps_tag migration
- 💎 No AdminController, no BO Tab, no override: does not pollute your menu, does not break your other modules
- 🇫🇷 French author: support in French, regular updates, clean & commented code
🎬 How it works in 4 steps
1
Install the module
Download the ZIP, install via the BO. Auto-creation of 4 tables, the SDE - Maison Vivaraise supplier, the CRON key, the multilingual 7 + 38 category tree.
2
Enter the CSV URL
Go to Settings, paste the URL of the CSV file provided by SDE / Maison Vivaraise, configure the variants by parent, the Features, the image in the description.
3
Configure your margins
5 default tiers, or choose RRP / Fixed markup / Wholesale. Customizable SEO templates with {name}/{brand}.
4
Start the import
Click "Start import". The progress bar and the live log start. You see each product created before your eyes in its correct sub-category.
🔧 Technical compatibility
| PrestaShop | 1.7.x → 9.x (tested on PS 9.0) |
| PHP | 7.4 minimum, 8.1+ recommended |
| MySQL / MariaDB | 5.7+ / 10.3+ |
| Multi-shop | Compatible (forces CONTEXT_ALL for deletion) |
| Hooks used | None (no pollution of the event chain) |
| Class override | None (preserves your other modules) |
| AdminController | None |
| BO sidebar tab | None (does not pollute your menu) |
| SDE / Maison Vivaraise account | B2B account required |
| CSV URL | Request from your SDE sales rep |
❓ Frequently asked questions
Q: Does the SDE home linen dropshipping module work on PrestaShop 9?
A: Yes, fully compatible with PS 9.x. The internal SdCompat compatibility layer also handles 1.7 and 8 without code changes. The module even handles the PS9-specific migration where meta_keywords was removed from ps_product_lang: it automatically switches to the ps_tag system.
Q: How many products can I import?
A: No limit on the module side. The Maison Vivaraise catalog contains thousands of references. You can import everything or use the "Product limit" to start gently.
Q: Will my €9/month shared hosting cope?
A: Yes, the module is specifically optimized. The "1 product = 1 AJAX call" architecture guarantees that no call exceeds 2-3 seconds. No risk of Apache 5xx timeout, unlike "all-in-one" import modules.
Q: How does the predefined tree work?
A: At install, the module creates 7 main categories (Bed, Bath, Decor, Accessories, Kitchen, Table, Rugs) with their 38 sub-categories, multilingual in 7 languages. If you manually delete a cat from the BO, it is recreated when you next open the module (idempotent safety net).
Q: What happens to already imported products on a new import?
A: Automatic "light update" mode: the module detects the existing SKU and ONLY updates the price and stock. It NEVER rewrites your descriptions, categories, Features or tags — you keep your customizations.
Q: What happens if a CSV-cat does not match any sub-category?
A: The product is placed in "Other › To classify" (never an error). You go to the Category mappings tab, select the right target and click Re-map: all affected products are automatically moved.
Q: The SDE CSV is in Latin-1, is that a problem?
A: No, the module handles it automatically. Cell-by-cell conversion to UTF-8 via mb_convert_encoding/iconv. No more "40�C" instead of "40°C", accents are preserved across the 7 languages.
Q: What if I want to stop a running import?
A: "Stop" button available during import (UI) and during CRON (flag file). Clean stop at the end of the current product, state saved for resume.
Q: Can I uninstall cleanly?
A: Yes, but the uninstall intentionally keeps your imported products (avoiding irreversible loss). The "Selective deletion" zone allows granular cleanup with triple confirmation: products / attributes / brands / supplier / logs, independent.
🛏️ Ready to automate your home linen dropshipping?
The SDE home linen dropshipping module is the most complete tool for selling SDE / Maison Vivaraise products (Winkler, Sel & Poivre and more) on PrestaShop. Configured once, it imports the catalog at your pace into a ready-to-use category tree.
⚡ 3 MIN INSTALLATION · 📚 REAL-TIME IMPORT · 🛡️ COMPATIBLE PS 1.7 → 9 · 🇫🇷 FRENCH SUPPORT
📋 Technical details for developers
DB tables created (5): wp_sde_history, wp_sde_import_errors, wp_sde_product_meta (sku unique), wp_sde_combination_meta (sku unique), wp_sde_category_mapping (csv_path unique)
PS configurations: WPSD_SETTINGS (JSON), WPSD_SUPPLIER_ID, WPSD_CRON_KEY, WPSD_LAST_IMPORT_AT, WPSD_LAST_IMPORT_COUNT, WPSD_CRON_LAST_*
SDE CSV (81 multilingual columns): sku, ean, parent, name_xx, color_xx, size_xx, category+category_xx, matter_xx, care_xx, description_xx, image-url-1..10, price, recommended-retail-price, qty, weight, volume, country-code, customs-nomenclature, made-in-france, oeko-tex-*, organic, recycled, upcycled, european-flax, printed-in-france, theme, ecoparticipation-ttc
Architecture: 5 clean PHP classes (SdCompat, SdCategoryTaxonomy, SdCategoryMapper, SdFeatureMapper, SdCsvImporter) + main module + AJAX router + CRON. No override of PrestaShop core classes. Code commented in French.
Real-time import: 2 AJAX endpoints (import_csv_prepare downloads + parses + caches, import_csv_row processes 1 product). State persisted as JSON in uploads/state/ with protective index.php.
Security: pSQL() everywhere, uploads/ folder protected, image format validation (getimagesize), native PS CSRF on AJAX, systematic HTML escaping (htmlspecialchars), hash_equals() on CRON key.
PS9-specific compatibility: automatic meta_keywords → ps_tag/ps_product_tag migration via Tag::addTags(), handling of the Product::delete() quirk that returns false in multi-shop (post-delete SQL check + direct wipe fallback on 25 related tables), ProductAttribute renamed from Attribute.
Category mapping: 4 levels (DB cache → static map ~100 entries → fuzzy similar_text ≥75% → fallback "Other"). Cross-language (matches any translation). Auto-deduplication every time the BO module opens.
📦 Module developed by WebPoint · webpoint.fr · Regular updates · Clean & commented code
