2 files changed, 21 insertions, 2 deletions
diff --git a/backend/data/products-import.csv b/backend/data/products-import.csv
index 29c61c8..5321a92 100644
--- a/backend/data/products-import.csv
+++ b/backend/data/products-import.csv
@@ -1,2 +1,11 @@
-external_id,title,handle,description,thumbnail,option_title,option_value,variant_title,variant_sku,price_amount,currency_code,inventory_quantity,manage_inventory
-prod-001,Savon Lavande,savon-lavande,"Savon artisanal a la lavande.",https://via.placeholder.com/600x600.png?text=Savon+Lavande,Taille,100g,100g,SKU-SAV-100,650,eur,100,true
+external_id,title,handle,description,thumbnail,option_title,option_value,variant_title,variant_sku,price_amount,currency_code,inventory_quantity,manage_inventory,volume,type_meche,parfum,couleur,type_cire
+prod-001,Bougie Lavande Classique,bougie-lavande-classique,"Bougie artisanale a la lavande, cire de soja naturelle.",,Taille,200ml,200ml,SKU-BOU-LAV-200,1200,eur,50,true,200ml,coton,lavande,blanche,soja
+prod-002,Bougie Vanille Boisee,bougie-vanille-boisee,"Notes chaudes de vanille et bois de santal.",,Taille,150ml,150ml,SKU-BOU-VAN-150,950,eur,40,true,150ml,bois,vanille,creme,soja
+prod-003,Bougie Fleur d'Oranger,bougie-fleur-oranger,"Parfum delicat de fleur d'oranger mediterraneenne.",,Taille,300ml,300ml,SKU-BOU-FLO-300,1800,eur,30,true,300ml,coton,fleur d'oranger,orange,colza
+prod-004,Bougie Cedre & Mousse,bougie-cedre-mousse,"Ambiance forestiere avec des notes de cedre et de mousse.",,Taille,200ml,200ml,SKU-BOU-CED-200,1400,eur,25,true,200ml,bois,cedre et mousse,verte,soja
+prod-005,Bougie Cannelle Epices,bougie-cannelle-epices,"Melange epice de cannelle, girofle et muscade.",,Taille,150ml,150ml,SKU-BOU-CAN-150,1050,eur,35,true,150ml,coton,cannelle epices,rouge,abeille
+prod-006,Bougie Rose Ancienne,bougie-rose-ancienne,"Senteur classique de rose de Grasse.",,Taille,200ml,200ml,SKU-BOU-ROS-200,1500,eur,20,true,200ml,coton,rose,rose,soja
+prod-007,Bougie Ambre Oriental,bougie-ambre-oriental,"Notes profondes d'ambre, oud et resine.",,Taille,500ml,500ml,SKU-BOU-AMB-500,2800,eur,15,true,500ml,bois,ambre oriental,doree,colza
+prod-008,Bougie Citron Basilic,bougie-citron-basilic,"Fraicheur mediterraneenne, citron et basilic.",,Taille,150ml,150ml,SKU-BOU-CIT-150,900,eur,45,true,150ml,coton,citron basilic,jaune,soja
+prod-009,Bougie Figue Sauvage,bougie-figue-sauvage,"Douceur sucree de la figue de Provence.",,Taille,300ml,300ml,SKU-BOU-FIG-300,1700,eur,20,true,300ml,bois,figue sauvage,violette,colza
+prod-010,Bougie Bois de Oud,bougie-bois-de-oud,"Oud rare et precieux, intensite boisee.",,Taille,200ml,200ml,SKU-BOU-OUD-200,2200,eur,10,true,200ml,bois,oud,noire,abeille
diff --git a/backend/scripts/import-products.js b/backend/scripts/import-products.js
index 04b24aa..bd0db24 100644
--- a/backend/scripts/import-products.js
+++ b/backend/scripts/import-products.js
@@ -75,6 +75,14 @@ class CsvProductImporter {
       return ["true", "1", "yes", "y"].includes(normalized);
     };
 
+    const metadata = {};
+    const metadataFields = ["volume", "type_meche", "parfum", "couleur", "type_cire"];
+    for (const field of metadataFields) {
+      if (row[field] && row[field].trim()) {
+        metadata[field] = row[field].trim();
+      }
+    }
+
     return {
       external_id: row.external_id || "",
       title: row.title || "",
@@ -89,6 +97,7 @@ class CsvProductImporter {
       currency_code: row.currency_code || this.defaultCurrency,
       inventory_quantity: Number.parseInt(row.inventory_quantity, 10) || 0,
       manage_inventory: toBool(row.manage_inventory, true),
+      metadata,
     };
   }
 
@@ -129,6 +138,7 @@ class CsvProductImporter {
           handle: row.handle,
           description: row.description,
           thumbnail: row.thumbnail || undefined,
+          metadata: Object.keys(row.metadata).length > 0 ? row.metadata : undefined,
           options: [{ title: row.option_title }],
           variants: [variant],
         });