PrestaShop dropshipping module ELEMTECHNIC
🌐 Source catalog available in: 
🇫🇷 100% native French catalog. No automatic translation: texts written directly in FR by the supplier, ideal for 🇫🇷 FR / 🇧🇪 BE / 🇨🇭 CH / 🇨🇦 CA stores.
🔧 🌳 🏠
Elemtechnic Tools & Garden Dropshipping Module
The module that automates from A to Z your French DIY dropshipping with Elemtechnic on PrestaShop
PrestaShop 1.7 → 9.x · 1,310 references · 50 brands · 10 native categories · CRON 24/7
Are you launching or running a DIY, gardening or tools online store? You work with Elemtechnic (French B2B wholesaler specializing in tools, power tools, garden, home) and you spend your days manually copying product sheets from their portal, classifying each item into the right sub-category (Screwdriver / Petrol mower / Pressure washer / Submersible pump / Heater…), uploading photos from their CDN, recalculating your selling prices with your margin?
With the Elemtechnic dropshipping tools garden home module, everything becomes automatic. You enter the Elemtechnic CSV URL, you click "Start import", and the module creates your 1,310 PrestaShop products before your eyes, in real time, with their 5 derived images per variant, in a perfectly organized native tree.
⚡ Before vs After the Elemtechnic Module
| Task |
❌ Without the module |
✅ With the module |
| Import 1,310 DIY references | 20h+ manual, copying from Elemtechnic portal | 1 click, ~1h in background |
| Multi-angle product (front, back, top, zoom) | Only one image available in CSV | 5 URLs auto-derived via _F/_B/_U/_Z suffixes |
| 216 CATEGORY+SUB_CAT pairs | Manual creation of 2-level hierarchy | Direct CSV → PS mapping, sub-cats on the fly |
| Inconsistent CSV case ("garden", "HOME") | Duplicate categories in PS tree | Auto normalization to clean form |
| PHOTO_BIG URLs with stray space (~50 rows) | Silent 404, missing image | Auto regex trim ("<REF> .jpg" → "<REF>.jpg") |
| 50 Elemtechnic brands to create | Manual addition manufacturer by manufacturer | Auto creation at import (PS Manufacturer) |
| No supplier RRP price | Excel calculation of margins product by product | 4 modes (Fixed markup / Tiers / Wholesale / RRP) |
| Original image PrestaShop 9 BO | Broken image in PS9 BO (official bug) | PS9 BO fix included: 1:1 copy of original file |
👤 Who is this module for?
🛠️
DIY / online tools store
You sell drills, screwdrivers, sanders, saws, hammer drills, tool sets online and want to multiply your catalog without managing physical stock.
🌱
Gardening e-commerce
You offer petrol/electric mowers, hedge trimmers, brushcutters, tillers, shredders, submersible pumps, basement pumps… and the spring/summer season is your peak activity.
🏠
Home / household equipment store
You sell heating, lighting, ventilation, vacuum cleaners, electrical equipment, and need a reliable French B2B supplier with a wide seasonal catalog.
🎯 Complete features of the Elemtechnic Module
🌳 Native Elemtechnic tree — 10 main categories
The Elemtechnic CSV exposes 12 main categories (with 2 case duplicates normalized) and 166 distinct sub-categories (216 CATEGORY × SUB_CAT pairs). The module preserves the supplier's native tree — no artificial fixed tree that would force tedious re-mapping.
| Main category |
Volume |
Sub-categories (excerpt) |
| 🌱 Garden | ~450 | Petrol/electric mower · Hedge trimmer · Edge trimmer · Brushcutter · Tractor · Tiller · Shredder · Blower vacuum… |
| 🏠 Home | ~384 | Heating · Lighting · Vacuum · Fan · Tarp · Electrical… |
| 🔧 Tools | ~233 | Screwdriver · Drill · Sander · Grinder · Circular saw · Jigsaw · Hammer drill · Sets · Kits… |
| ⚡ Power tools | ~67 | Battery · Compressor · Tool cart… |
| 🚧 Construction site | ~66 | Pressure washer · Blower vacuum · Concrete mixer · Generator… |
| 💧 Pumps | ~59 | Basement pumps · Submersible pumps · Surface pumps… |
| 🗄️ Workshop storage | ~26 | Tool carts · Modular storage… |
| ⚙️ Stationary | ~20 | Stationary tools |
| 🚲 Sport · 🚐 Transport | 3 | Minor categories preserved for catalog fidelity |
- Auto case normalization: "garden" → "Garden", "HOME" → "Home", "workshop storage" → "Workshop storage" — no more PS tree duplicates
- Sub-categories on the fly: created at import time from the SUB_CAT column of the CSV (with their exact name)
- Safety net: if a main category is manually deleted from the PS BO, it is recreated the next time the module is opened
- Customizable sub-root: Home by default, or any category in your tree
📸 Multi-images derived via _F/_B/_U/_Z suffixes — Elemtechnic Innovation
The unique feature of this module. The Elemtechnic CSV provides only one PHOTO_BIG column (URL of the main image). However, the Elemtechnic CDN usually hosts 4 variants per product (Front, Back, Up, Zoom) accessible by naming convention. The module automatically derives these 4 additional URLs by replacing .jpg with the suffixes.
| Position |
Suffix |
Generated URL (e.g. REF = SP1150-210) |
View |
| Image 1 (cover) | (none) | https://eshop.elemtechnic.com/photos/SP1150-210.jpg | Standard 3/4 view |
| Image 2 | _F.jpg | SP1150-210_F.jpg | Front |
| Image 3 | _B.jpg | SP1150-210_B.jpg | Back |
| Image 4 | _U.jpg | SP1150-210_U.jpg | Up (top) |
| Image 5 | _Z.jpg | SP1150-210_Z.jpg | Zoom detail |
- Resilient download: if a variant does not exist at Elemtechnic (HTTP 404), the module silently moves to the next one. You get exactly the images actually available, with no broken sheet.
- Auto trim supplier bug: ~50 rows of the CSV have a stray space before
.jpg ("<REF> .jpg"). The module cleans them automatically with preg_replace('/\s+\.jpg$/i', '.jpg', $url).
- Format validation via
getimagesize(): JPEG/PNG/GIF/WebP, corrupted files rejected without crashing the import.
- Auto generation of all PS sizes (small, medium, large, home_default…) via
ImageManager::resize()
- PrestaShop 9 BO fix included: 1:1 copy of the original
<id>.jpg file in addition to the variants — without this fix, the image does not appear in the PS9 BO product edit page (known PS9 bug).
📦 1 CSV row = 1 PS product — No variants to manage
The Elemtechnic catalog does not contain size/color variants (each REFERENCE is a distinct finished product, like a complete "XYZ 18V drill"). Advantages:
- Simple mapping: 1 CSV row = 1 PS product, no parent grouping logic to understand
- Direct stock on the product: no combinations or attributes to create/maintain
- EAN13 directly on the product (no combination → EAN complexity)
- Clean product sheet: no variant dropdown on the front-end if empty, just the product presented with its 5 derived images
📋 Elemtechnic CSV — Clean and easy format
| Feature | Value |
|---|
| Number of columns | 22 columns (NUM, REFERENCE, CATEGORIE, SOUS_CAT, TITRE, DESCRIPTION, EAN, POIDS, STOCK, PRIX, …, PHOTO_BIG, …, MARQUE, GARANTIE) |
| Separator | ; (semicolon) |
| Quotechar | " (double quote) |
| Encoding | Native UTF-8 (no Windows-1252, no conversion needed) |
| Decimals | With dot ("26.00", no French comma to convert) |
| Weight | In kilograms (imported as is on PS side) |
| Description | HTML accepted (with <br/>, lists, bold), multi-line in quotes |
| Catalog volume | 1,310 products · 50 brands · 216 distinct CATEGORY+SUB_CAT pairs |
✍️ Automatic description if empty
If the DESCRIPTION column of the CSV contains at least 30 characters of text (after strip_tags), it is kept and reformatted in clean HTML. If empty or too short, the module automatically generates a structured HTML description from the TITRE, MARQUE, category and REFERENCE — to never have an empty product sheet harmful to SEO.
The module never overwrites a description provided by the supplier.
⚡ Real-time import architecture
The scenario that changes everything:
- 📥 Preparation: the module downloads the CSV from the configured Elemtechnic URL and caches the 1,310 rows as JSON
- 🚀 "1 product = 1 AJAX call" import: no 30-minute freeze, you see each product created one by one
- 📊 Orange progress bar: live percentage + X/Y counter
- 📋 Live console-style log: colored badge (Created / Updated / Skipped / Error) + REFERENCE + TITLE + PS ID#
- ⏸️ Stop button at any time, resume possible
- 📈 Live stats: Created · Updated · Skipped · Errors
→ No more lagging page. No more worry. You see everything that happens.
💰 Configurable margins & SEO
4 pricing modes
Elemtechnic peculiarity: the CSV does not provide an RRP price (recommended retail price). The module supports 4 strategies:
| Mode | Description |
|---|
| Fixed markup ⭐ (default) | A single % applied to all products (50% by default → PRIX × 1.5). The simplest way to start. |
| Tiers | Different % depending on the net purchase price tier (5 default tiers, configurable: 0-15€/15-30€/30-60€/60-120€/120€+). Optimizes margins on products by range. |
| Wholesale | Net purchase price as is (B2B sale to professionals). |
| RRP (= PRIX in absence of RRP) | Fallback mode: uses PRIX as selling price (so margin = 0). Useful while waiting for configuration. |
Customizable SEO templates
- Meta title / meta description with variables:
{name}, {brand}
- Auto-generated PS Tags from brand + category
- 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"
- "Image in description" option: injection of the 1st image directly into the long description (on-page SEO boost), position start or end as you choose
⏰ CRON 24/7 — 3 automated actions
| CRON action |
Role |
Recommended frequency |
full_import | Full catalog import (creations + light updates) | 1×/day |
light_sync | Update price + 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 on install — your CRON URLs cannot be guessed
- 1-click regeneration of the key in case of leak
- Asynchronous auto-restart: the module re-calls itself in the background if the time-budget is reached (60s by default, configurable) — no Apache 5xx timeout
- Precise resume: resumes exactly at the line where it stopped
- Anti-concurrence lock via flock: no parallel executions
- CSV download retry 3× with backoff 2s/4s/6s
- Stop button on the BO side to cleanly stop a running CRON
- Test mode with configurable product limit (50 to validate quickly)
🏷️ The Elemtechnic catalog in figures
5
max images/product (derived)
Flagship brands of the catalog (excerpt, by volume):
ELEM Garden Technic (255)
WARM TECH (157)
CONSTRUCTOR (140)
X-PERFORMER (125)
BRICK (61)
ELEM Technic (60)
GARDEO Pro (53)
I-WATTS (52)
WORK MEN (43)
MASTER PUMPS (41)
I-WATTS OUTDOOR LIGHTING (35)
COOL CLIMA (34)
Lawnmaster (22)
Vacmaster Professional (19)
+ 35 other brands
🛠️ Maintenance — Selective deletion
- ☐ Imported products: detection from 4 sources (meta, supplier, product_supplier, category mapping), compatible with PS9 multi-shop quirk with SQL wipe fallback on 25 linked tables
- ☐ Orphan brands: deletes the 50 Elemtechnic manufacturers (ELEM Garden Technic, WARM TECH, CONSTRUCTOR, X-PERFORMER, BRICK, GARDEO Pro, I-WATTS, MASTER PUMPS, COOL CLIMA…) that no longer have any product
- ☐ Elemtechnic supplier: deletes the supplier only if it no longer has any linked product
- ☐ Internal logs: truncate of history and import_errors tables
Triple confirmation (dialog box + DELETE input + button). No "Orphan attributes" checkbox (Elemtechnic has no size/color variants). No "Categories" checkbox: the tree is managed by the module and recreated if manually deleted from the BO.
⭐ 12 reasons to choose the Elemtechnic Module
- 🚀 3-minute installation: CSV URL + tree created + start the import
- 🌳 Native tree preserved: 10 main categories + sub-cats on the fly (vs. imposing an artificial fixed tree)
- 🔡 Auto case normalization: "garden" / "HOME" / "workshop storage" merged to their clean form
- 📸 Multi-images derived via _F/_B/_U/_Z suffixes: unique innovation of the Elemtechnic module, exploits the supplier CDN naming convention
- 🛡️ Auto trim supplier bug: ~50 rows with stray space before
.jpg automatically cleaned
- 📦 1 CSV row = 1 product: no variant complexity, direct and deterministic mapping
- ✍️ Auto-generated description if empty: no ghost product sheet on the front-end
- 💰 4 pricing modes: Fixed markup (default 50%) / Tiers / Wholesale / RRP — adapted to the absence of supplier RRP
- ⚡ Real-time product-by-product import: live bar, console log, Stop button
- ⏰ CRON 24/7 with time-budget, asynchronous auto-restart, retry, lock
- 🛡️ Compatible PS 1.7 → 9.x:
EtCompat compatibility layer + PS9 BO image bug fix included
- 🇫🇷 French author · No AdminController, no override: does not pollute your BO menu, does not break your other modules
🎬 How it works in 4 steps
1
Install the module
Download the ZIP, install via the BO. Auto-creation of 5 tables, of the Elemtechnic supplier, of the CRON key, of the 10 native main categories.
2
Enter the CSV URL
Go to Settings, paste the URL of the CSV file provided by Elemtechnic (placeholder: https://eshop.elemtechnic.com/exports/catalog.csv), configure the image-in-description option.
3
Configure your margins
Fixed markup 50% by default, or choose Tiers (5 ranges) / Wholesale / RRP. Customizable SEO templates with {name}/{brand}.
4
Start the import
Click "Start import". Test mode with 50 products first to validate, then full import 1,310 rows. You see each product created before your eyes.
🔧 Technical compatibility
| PrestaShop | 1.7.x → 9.x (tested on PS 9.0) |
| PHP | 7.4 minimum, recommended 8.1+ |
| MySQL / MariaDB | 5.7+ / 10.3+ |
| cURL | Enabled (CSV + image download) |
| Multi-shop | Compatible (forces CONTEXT_ALL for deletion) |
| Hooks used | None (no event chain pollution) |
| Class override | None (preserves your other modules) |
| AdminController | None |
| BO sidebar tab | None (does not pollute your menu) |
| Elemtechnic B2B account | Account required for billing and delivery |
| CSV URL | To be requested from your Elemtechnic sales rep |
❓ Frequently asked questions
Q: Does the Elemtechnic Module work on PrestaShop 9?
A: Yes, fully compatible with PS 9.x. The module handles the specific PS9 migration where meta_keywords has been removed (automatic fallback to ps_tag) as well as the PS9 bug where the original image does not appear in the BO product edit page (fix by 1:1 copy of the <id>.jpg file in addition to the resized variants).
Q: What happens if an image variant (_F/_B/_U/_Z) does not exist at Elemtechnic?
A: The download fails with a 404 and the module silently moves to the next one. No error generated. You get exactly the images that actually exist at the supplier, with no broken sheet. On the current catalog, the vast majority of products have at least the cover image, some 2-3 variants, a few all 5.
Q: And the ~50 rows where PHOTO_BIG has a stray space before ".jpg"?
A: The module detects them automatically with a regex /\s+\.jpg$/ and cleans them before download ("SP1150-210 .jpg" becomes "SP1150-210.jpg"). Supplier bug handled transparently, you have nothing to do.
Q: Will my 9€/month shared hosting handle it?
A: Yes, the module is specially optimized. The "1 product = 1 AJAX call" architecture guarantees no call exceeds 2-3 seconds. No risk of Apache 5xx timeout, unlike "all-in-one" import modules.
Q: The CSV has no RRP price, how do I configure my margins?
A: Elemtechnic only provides a net purchase PRICE (no recommended retail price). The module is configured by default in "Fixed markup 50%" mode (PRIX × 1.5). You can switch to "Tiers" mode (5 configurable ranges: 0-15€/15-30€/30-60€/60-120€/120€+) or "Wholesale" (B2B sale at purchase price) in the Margins & SEO tab.
Q: How does the 10-category tree work?
A: At install, the module creates 10 native Elemtechnic main categories (Garden, Home, Tools, Power tools, Construction site, Pumps, Workshop storage, Stationary, Sport, Transport). Sub-categories are created on the fly at import from the SUB_CAT column of the CSV (with their exact name). Auto normalization merges case typos ("garden" and "Garden" → a single "Garden" category).
Q: Can I import the same CSV multiple times?
A: Yes. Automatic light mode: existing products are detected via their REFERENCE and only their price + stock are refreshed. Your descriptions, images, categories and tags are not rewritten — you keep your customizations. Ideal for daily refresh (or via CRON light_sync).
Q: How do I delete all Elemtechnic products?
A: Import tab → Selective deletion → check "Imported products" → DELETE. You can add "Orphan brands / Supplier" for a complete cleanup. Triple confirmation to avoid mistakes.
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 save for resume.
Q: Is the module multi-shop compatible?
A: Yes. Categories and products are created on all active shops. Deletion forces CONTEXT_ALL to avoid the PS9 quirk where Product->delete() returns false in multi-shop.
Q: Can I uninstall cleanly?
A: Yes, but uninstall intentionally keeps your imported products (irreversible loss avoided). The "Selective deletion" zone allows granular cleanup with triple confirmation: products / brands / supplier / logs, independent.
🔧 Ready to automate your DIY dropshipping?
The Elemtechnic dropshipping tools garden home module is the most complete tool to sell the 1,310 Elemtechnic references (drills, mowers, hedge trimmers, pressure washers, pumps, heating, lighting…) on PrestaShop. Once configured, it automatically imports the catalog at your pace with its 5 derived images per product.
⚡ INSTALLATION 3 MIN · 📚 REAL-TIME IMPORT · 🛡️ COMPATIBLE PS 1.7 → 9 · 🇫🇷 FRENCH SUPPORT
📋 Technical details for developers
DB tables created (5): wp_elemtechnic_history, wp_elemtechnic_import_errors, wp_elemtechnic_product_meta (sku unique = REFERENCE), wp_elemtechnic_combination_meta (unused — no variants), wp_elemtechnic_category_mapping (csv_path unique = "MAIN > SUB" normalized)
PS configurations: WPET_SETTINGS (JSON), WPET_SUPPLIER_ID, WPET_CRON_KEY, WPET_LAST_IMPORT_AT, WPET_LAST_IMPORT_COUNT, WPET_CRON_LAST_*
Elemtechnic CSV (22 UTF-8 columns): NUM, REFERENCE (SKU), CATEGORIE + SOUS_CAT, TITRE, DESCRIPTION (HTML), EAN, POIDS (kg), STOCK, PRIX (net), TRANSPORT, EN_PROMO, PRIX_PROMO, PHOTO_110, PHOTO_300, PHOTO_BIG, REAPPRO, INSERT, UPDATE, CHARGE_COLIS, MARQUE, GARANTIE
Architecture: 5 clean PHP classes (EtCompat, EtCategoryTaxonomy, EtCategoryMapper, EtFeatureMapper [dead code by design], EtCsvImporter) + main module + AJAX router + CRON. No PrestaShop core class override. Code commented in French.
Synthetic columns generated in parseCsvToArray: 6 columns added to each row after reading — CATEGORY_COMBINED ("CATEGORIE > SOUS_CAT"), IMG_COVER (cleaned PHOTO_BIG), IMG_F, IMG_B, IMG_U, IMG_Z (URLs derived via suffixes).
Shared engine compatibility aliases: sku → reference, name_fr → titre, description_fr → description, brand → marque, parent → reference, price → prix, recommended-retail-price → prix (in absence of RRP), weight → poids, qty → stock, category → CATEGORY_COMBINED, image-url-1..5 → IMG_*.
Category mapping: direct and deterministic (CSV provides MAIN+SUB explicitly). No fuzzy matching needed. DB cache to reuse resolved associations.
Security: pSQL() everywhere, uploads/ folder protected, image format validation (getimagesize), native PS CSRF on AJAX, systematic HTML escapes (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, PS9 BO original image fix (1:1 copy of the <id>.jpg file before the ImageManager::resize variants).
Supplier bug handling: preg_replace('/\s+\.jpg$/i', '.jpg', $url) applied on PHOTO_BIG in parseCsvToArray for the ~50 rows with stray space.
📦 Module developed by WebPoint · webpoint.fr · Regular updates · Clean & commented code
