Drop-sexy Adult Dropshipping Module for PrestaShop — French Erotic Catalog 3,768 Refs Lingerie Sextoys Lubricants

PrestaShop dropshipping module DROP-SEXY

Are you launching an online sex shop, a sexy lingerie site, an e-commerce store for sextoys or naughty products? You work with Drop-sexy (French wholesaler specialized in adult products) and you spend your days re-typing 3,768 product sheets, manually rebuilding variants by capacity/size/color with their individual stock, uploading 9 photos per product, creating each variant as a distinct combination with its own reference?

With the Drop-sexy adult sextoys lingerie dropshipping module, everything becomes automatic. You enter the Drop-sexy CSV URL, click "Start import", and the module creates your 3,768 PrestaShop products in French with their multi-attribute variants (Capacity × Size × Color), their 9 photos, their per-variant stock, their native supplier reference, in a clean category tree built on the fly from the native CSV hierarchy.

⚡ Before vs After the Drop-sexy Module

👤 Who is this module for?

🎯 Complete features of the Drop-sexy Module

🎨 Dynamic multi-attribute variants — Drop-sexy innovation

Unique feature of this module. Drop-sexy does not fix the attributes (just size×color like other suppliers) — it exposes 4 dynamic Name/Value pairs per CSV row. Depending on the product, it will be Capacity + Size, or Size + Color, or Capacity alone, or all 3 combined. The module automatically detects active pairs and creates the corresponding PS attribute groups on the fly.

Example 1 — Lubricant 2 capacities:
Row 1: Product Id=21845, Reference=D-234893, Variant ref=D-234893-30ML
   → Variant: Attr name 3 = "Capacity", Attr value 3 = "30 ML"

Row 2: Product Id=21845, Reference=D-234893, Variant ref=D-234893-100ML
   → Variant: Attr name 3 = "Capacity", Attr value 3 = "100 ML"

→ 1 PS product « Relaxing anal gel » with 2 combinations
   • combination ref = D-234893-30ML
   • combination ref = D-234893-100ML

Example 2 — Lingerie 4 sizes × 1 color:
Rows: Product Id=21402, Variant ref=MAL80025NUBKL/M/S/XL
   → Variant: Attr name 1="Size", Attr value 1=L/M/S/XL
   → Variant: Attr name 2="Color", Attr value 2="Skin/Black"

→ 1 PS product « Lingerie set » with 4 combinations
   • Size L × Color Skin/Black
   • Size M × Color Skin/Black
   • Size S × Color Skin/Black
   • Size XL × Color Skin/Black

• Native reference per combination — the CSV "Variant reference" is used directly as Combination::reference (native PS field)
• 4 dynamic pairs: reading columns "Variant: Attribute Name N" + "Variant: Attribute Value N" (N = 1 to 4). The 4th uses "Attribute Type 4" instead of "Name"
• Automatic color detection: if the attribute name contains "color" (case-insensitive), the group is created in color_group mode (for swatches on the front)
• Grouping by "Product Id": N CSV rows with the same Id become N combinations on 1 single PS product (and not N distinct products)
• Instance cache + auto consolidation: ONE SINGLE group per attribute name (Capacity, Size, Color…), regardless of the number of products imported
• EAN13 on the combination from the CSV EAN13 column (common to all variants of the same product)
• Specific stock per combination via StockAvailable::setQuantity()

🌳 Native hierarchy from the CSV (without fixed tree)

Drop-sexy exposes 3 hierarchical columns per product: "Category Name 1/2/3". The 1st is usually "Home" or "Root" (= the PS root, ignored by the module). Levels 2 and 3 form the real chain, created on the fly during import without an artificial fixed tree.

CSV columns:
   Category Name 1: Home              ← ignored (PS root)
   Category Name 2: Wellness and aphrodisiacs
   Category Name 3: Lubricant & Cream & Aphrodisiac

→ PS leaf category created:
   Wellness and aphrodisiacs › Lubricant & Cream & Aphrodisiac

Main categories of the Drop-sexy catalog (excerpt):

• No pre-created category on install: everything is built on the fly during import
• DB cache of the mapping: the resolved CSV chain is memorized in wp_dropsexy_category_mapping for subsequent imports (idempotent)
• Category Mappings tab in the BO: auto-loaded table with PS selector and Re-map button to merge or rename a sub-category after the import
• Smart fallback: if columns 1/2/3 are empty, the module falls back to "Default category name"
• Customizable sub-root: Home by default, or any category in your tree

📝 Auto-generated short description if empty (66% of the catalog)

Drop-sexy reality: 66% of products have an empty or too short "Short description without HTML". Without intervention, you end up with 2,500 ghost product sheets on the front — disastrous for SEO, bounce rate and conversion.

The module automatically detects empty or too short SDs (< 30 characters excluding HTML) and generates a structured HTML short description from the name + brand + category of the sheet.

• Robust detection: takes into account SDs that contain only spaces, empty HTML (<p>&nbsp;</p>), or a supplier placeholder
• SEO-friendly auto-generation: short sentences in natural French, never generic "Lorem Ipsum"
• Manual preservation: if you then customize the SD in BO, light mode no longer overwrites it on subsequent imports
• PS9 compatible: description_short filled with HTML allowed in multi-language

📸 Native multi-images (9 photos per product)

The Drop-sexy CSV provides 9 native image columns: Default image URL (cover) + Image URL 1 to Image URL 8. The module imports them all, the 1st defined as cover. Empty slot silently ignored (no crash if fewer than 9 photos).

• Format validation via getimagesize(): JPEG/PNG/GIF/WebP, corrupt files rejected without crashing the import
• Auto-generation of all PS sizes (small, medium, large, home_default…)
• BO PrestaShop 9 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 BO PS9 product edit page — known PS9 bug)
• Resilient download: 3× retry with backoff on 503/timeout, error log if all fails (the import continues)
• Image in description option: injection of the 1st image directly into the long description (on-page SEO boost), start or end position

🔤 Windows-1252 BOM encoding — auto conversion

The Drop-sexy CSV is in Windows-1252 with UTF-8 BOM at the start of the file — an exotic mix that crashes native PrestaShop imports. The module handles this intelligently:

• UTF-8 BOM detection at the start of the file (3 bytes \xEF\xBB\xBF) and automatic skip
• Windows-1252 → UTF-8 conversion of each cell via mb_convert_encoding() (with detection if the cell is already in UTF-8)
• French decimals: commas (« 22,78 ») converted to dots (« 22.78 ») on price columns
• French characters preserved: « Mapalé », « Cottelli & Divers », « René Rofé » display correctly after import (no « Mapalé »)
• Separator ";" + native double-quoted fields

⚡ Real-time import architecture

💰 Configurable margins & SEO

4 price calculation modes

The CSV exposes Discounted ex-VAT sale price (negotiated ex-VAT) + Pre-discount incl. VAT price (supplier RRP) + VAT rate. The module uses RRP mode by default (supplier incl. VAT price). You can change in Margins & SEO:

Customizable SEO templates

• Meta title / meta description with variables: {name}, {brand}
• French PS Tags auto-generated from brand + category + color (if present)
• 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"
• Light update mode: 2nd import = price+stock update only, your BO customizations are preserved

⏰ CRON 24/7 — 3 automated actions

• 32-hex-character secret key generated on install — your CRON URLs cannot be guessed
• 1-click regeneration of the key in case of leak
• Asynchronous auto-restart: background self-call if the time-budget is reached (60s by default)
• Precise resume: resumes exactly at the row where it stopped
• Anti-concurrency 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 (10-100 to validate quickly)

🏷️ The Drop-sexy catalog in numbers

Flagship brands of the Drop-sexy catalog:

🛠️ Maintenance — Selective deletion 6 checkboxes

• ☐ Imported products: detection from 4 sources (meta, supplier, product_supplier, category mapping), compatible with PS9 multi-shop quirk with SQL wipe fallback on related tables
• ☐ Orphan attributes (Capacity / Size / Color…): deletes the values AND their groups if no combination uses them anymore. Multi-language lookup (regardless of the PS default language)
• ☐ Imported categories: deletes categories created by the module via the wp_dropsexy_category_mapping table. Deletion from leaves to root + safe cleanup of parents that became empty. Preserves PS_HOME and PS_ROOT
• ☐ Orphan brands: deletes Drop-sexy manufacturers (Mapalé, Obsessive, Dreamgirl, René Rofé, Fiore, Look Me, Music Legs, PENTHOUSE, Be lily Mode, COTTELLI & DIVERS…) that no longer have any products
• ☐ Drop-sexy supplier: deletes the supplier only if it no longer has any linked products
• ☐ Internal logs: truncate of history and import_errors tables

Triple confirmation (dialog box + typing DELETE + button). The category tree can be recreated on next opening of the module if you do not check the "Imported categories" option.

⭐ 12 reasons to choose the Drop-sexy Module

1. 🚀 3-minute installation: CSV URL + start the import
2. 🎨 Dynamic multi-attribute variants (Capacity, Size, Color, etc.) with native reference per combination — innovation specific to Drop-sexy
3. 🇫🇷 Native French mono-language without translation (FR descriptions written by humans by Drop-sexy)
4. 🔤 Automatic Windows-1252 → UTF-8 conversion (French characters preserved)
5. 📝 Auto-generation SD on the 66% of products without short description (anti-ghost SEO sheets)
6. 🌳 Native CSV hierarchy (cat 2 + cat 3, root ignored) created on the fly — no fixed tree
7. 📸 9 photos per product in native columns + BO PS9 fix included
8. 💰 4 price modes (RRP / Tiers / Fixed markup / Wholesale) — adapted to the diversity of the catalog (lubricants ~10€ → BDSM kits ~150€)
9. 🔧 Instance cache + auto consolidation of attributes: ONE SINGLE group per attribute name for the 3,768 products, regardless of successive imports
10. ⚡ Real-time product-by-product import: live bar, console log, Stop button
11. ⏰ CRON 24/7 with time-budget, asynchronous auto-restart, retry, lock
12. 💎 No AdminController, no BO Tab, no override: does not pollute your menu, does not break your other modules

🎬 How it works in 4 steps

🔧 Technical compatibility

❓ Frequently asked questions

📦 Module developed by WebPoint · webpoint.fr · Regular updates · Clean & commented code