UPDATE products
SET
    hero_eyebrow = 'Solution WMS modulaire connectee a Sage 100',
    tagline = 'Pilotez vos flux logistiques, maitrisez vos stocks et prolongez votre gestion commerciale Sage 100 avec une solution modulaire adaptee a votre organisation.',
    short_description = 'Win@WMS structure la reception, le stockage, les mouvements, la preparation, l inventaire et les expeditions dans un environnement logistique concu pour le terrain. La solution s appuie sur Sage 100 et peut evoluer avec les modules utiles a votre entrepot, a vos flux et a vos contraintes operationnelles.',
    presentation = 'Win@WMS est une solution complete de gestion d entrepot concue pour piloter les flux logistiques, fiabiliser les stocks et synchroniser les operations terrain avec votre gestion commerciale Sage 100. Elle fournit un cadre coherent pour suivre les entrees, les mouvements, les sorties et les controles dans un environnement robuste, pragmatique et evolutif.',
    key_functions = 'Win@WMS couvre les principales etapes du fonctionnement logistique : reception, controle, mise en stock, adressage, mouvements internes, preparation de commandes, expedition, inventaire et traitement des operations terrain. L objectif est de donner a l entreprise une vision plus fiable de ses flux et un cadre de travail adapte a la realite de l entrepot.',
    use_cases = 'La solution peut etre deployee pour accompagner un ou plusieurs entrepots, des flux simples ou plus structures, des besoins de tracabilite, de pilotage des stocks, d organisation des expeditions ou de gestion comptoir. Win@WMS s adapte a vos volumes, a vos processus et a votre niveau d equipement, avec une mise en oeuvre modulaire selon vos priorites.',
    connectivity = 'Win@WMS s integre a votre environnement Sage 100 et peut communiquer avec les equipements et applications utiles a vos operations : terminaux mobiles, lecteurs codes-barres, solutions d identification, outils de tracabilite et interfaces metier. Les echanges sont penses pour limiter les ressaisies, fiabiliser la circulation des informations et relier plus proprement le terrain a la gestion commerciale.',
    hosting = 'La solution peut etre mise en oeuvre selon les contraintes techniques, reseau et securite de votre entreprise. WININFO vous accompagne dans le choix de l architecture, le deploiement, la securisation et l evolution de l environnement retenu, afin de disposer d un WMS durable et adapte a vos usages.',
    support_body = 'WININFO accompagne votre projet de la definition du besoin jusqu au deploiement operationnel : cadrage, parametrage, reprise de donnees si necessaire, interconnexions, formation des utilisateurs, assistance et evolution de la solution. L objectif est de mettre en place un WMS utile, pragmatique et directement exploitable par vos equipes.',
    hero_cta_label = 'Demander une demonstration',
    hero_cta_url = '/demo/',
    hero_secondary_cta_label = 'Voir les modules Win@WMS',
    hero_secondary_cta_url = '/catalogue/modules/?product=win-wms',
    hero_anchor = NULL
WHERE slug = 'win-wms'
  AND deleted_at IS NULL;

INSERT INTO content_items (
    owner_type, owner_id, item_type, title, body, sort_order, is_active, created_at, updated_at
)
SELECT
    'product',
    p.id,
    'environment_modules_block',
    'Les modules Win@WMS pour structurer vos flux',
    '{"body":"Win@WMS repose sur un socle logistique complet qui peut etre enrichi par des modules activables selon vos flux de reception, de stock, d expedition, d inventaire ou de vente directe.","limit":6}',
    1,
    1,
    CURRENT_TIMESTAMP,
    CURRENT_TIMESTAMP
FROM products p
WHERE p.slug = 'win-wms'
  AND NOT EXISTS (
      SELECT 1
      FROM content_items ci
      WHERE ci.owner_type = 'product'
        AND ci.owner_id = p.id
        AND ci.item_type = 'environment_modules_block'
  );

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET
    ci.title = 'Les modules Win@WMS pour structurer vos flux',
    ci.body = '{"body":"Win@WMS repose sur un socle logistique complet qui peut etre enrichi par des modules activables selon vos flux de reception, de stock, d expedition, d inventaire ou de vente directe.","limit":6}',
    ci.is_active = 1,
    ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms'
  AND ci.owner_type = 'product'
  AND ci.item_type = 'environment_modules_block';

INSERT INTO content_items (owner_type, owner_id, item_type, title, body, icon, sort_order, is_active, created_at, updated_at)
SELECT 'product', p.id, 'feature', 'Reception et controle', 'Cadrez les entrees, les controles et la mise en stock dans un environnement relie a vos usages terrain.', 'package', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
FROM products p
WHERE p.slug = 'win-wms'
  AND NOT EXISTS (SELECT 1 FROM content_items ci WHERE ci.owner_type = 'product' AND ci.owner_id = p.id AND ci.item_type = 'feature' AND ci.sort_order = 1);

INSERT INTO content_items (owner_type, owner_id, item_type, title, body, icon, sort_order, is_active, created_at, updated_at)
SELECT 'product', p.id, 'feature', 'Stocks, emplacements et mouvements', 'Structurez l adressage, le stockage, les mouvements internes et la lecture des stocks dans un cadre commun.', 'warehouse', 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
FROM products p
WHERE p.slug = 'win-wms'
  AND NOT EXISTS (SELECT 1 FROM content_items ci WHERE ci.owner_type = 'product' AND ci.owner_id = p.id AND ci.item_type = 'feature' AND ci.sort_order = 2);

INSERT INTO content_items (owner_type, owner_id, item_type, title, body, icon, sort_order, is_active, created_at, updated_at)
SELECT 'product', p.id, 'feature', 'Preparation et expedition', 'Organisez la preparation de commandes, les priorites de sortie, les etiquettes et les flux transport.', 'truck', 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
FROM products p
WHERE p.slug = 'win-wms'
  AND NOT EXISTS (SELECT 1 FROM content_items ci WHERE ci.owner_type = 'product' AND ci.owner_id = p.id AND ci.item_type = 'feature' AND ci.sort_order = 3);

INSERT INTO content_items (owner_type, owner_id, item_type, title, body, icon, sort_order, is_active, created_at, updated_at)
SELECT 'product', p.id, 'feature', 'Inventaire et tracabilite', 'Fiabilisez les comptages, la lecture codes-barres, les ecarts et la tracabilite utiles a l entrepot.', 'scan-line', 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
FROM products p
WHERE p.slug = 'win-wms'
  AND NOT EXISTS (SELECT 1 FROM content_items ci WHERE ci.owner_type = 'product' AND ci.owner_id = p.id AND ci.item_type = 'feature' AND ci.sort_order = 4);

INSERT INTO content_items (owner_type, owner_id, item_type, title, body, icon, sort_order, is_active, created_at, updated_at)
SELECT 'product', p.id, 'feature', 'Integration Sage 100 et terrain', 'Reliez plus proprement les traitements WMS, les equipements terrain et votre gestion commerciale Sage 100.', 'database', 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
FROM products p
WHERE p.slug = 'win-wms'
  AND NOT EXISTS (SELECT 1 FROM content_items ci WHERE ci.owner_type = 'product' AND ci.owner_id = p.id AND ci.item_type = 'feature' AND ci.sort_order = 5);

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET ci.title = 'Reception et controle', ci.body = 'Cadrez les entrees, les controles et la mise en stock dans un environnement relie a vos usages terrain.', ci.icon = 'package', ci.is_active = 1, ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms' AND ci.owner_type = 'product' AND ci.item_type = 'feature' AND ci.sort_order = 1;

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET ci.title = 'Stocks, emplacements et mouvements', ci.body = 'Structurez l adressage, le stockage, les mouvements internes et la lecture des stocks dans un cadre commun.', ci.icon = 'warehouse', ci.is_active = 1, ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms' AND ci.owner_type = 'product' AND ci.item_type = 'feature' AND ci.sort_order = 2;

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET ci.title = 'Preparation et expedition', ci.body = 'Organisez la preparation de commandes, les priorites de sortie, les etiquettes et les flux transport.', ci.icon = 'truck', ci.is_active = 1, ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms' AND ci.owner_type = 'product' AND ci.item_type = 'feature' AND ci.sort_order = 3;

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET ci.title = 'Inventaire et tracabilite', ci.body = 'Fiabilisez les comptages, la lecture codes-barres, les ecarts et la tracabilite utiles a l entrepot.', ci.icon = 'scan-line', ci.is_active = 1, ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms' AND ci.owner_type = 'product' AND ci.item_type = 'feature' AND ci.sort_order = 4;

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET ci.title = 'Integration Sage 100 et terrain', ci.body = 'Reliez plus proprement les traitements WMS, les equipements terrain et votre gestion commerciale Sage 100.', ci.icon = 'database', ci.is_active = 1, ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms' AND ci.owner_type = 'product' AND ci.item_type = 'feature' AND ci.sort_order = 5;

INSERT INTO content_items (owner_type, owner_id, item_type, title, body, icon, sort_order, is_active, created_at, updated_at)
SELECT 'product', p.id, 'benefit', 'Vision plus fiable des flux', 'Les entrees, mouvements et sorties sont mieux relies dans un meme environnement logistique.', 'chart-column', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
FROM products p
WHERE p.slug = 'win-wms'
  AND NOT EXISTS (SELECT 1 FROM content_items ci WHERE ci.owner_type = 'product' AND ci.owner_id = p.id AND ci.item_type = 'benefit' AND ci.sort_order = 1);

INSERT INTO content_items (owner_type, owner_id, item_type, title, body, icon, sort_order, is_active, created_at, updated_at)
SELECT 'product', p.id, 'benefit', 'Stocks mieux maitrises', 'Le suivi des quantites, des emplacements et des ecarts gagne en coherence au quotidien.', 'shield-check', 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
FROM products p
WHERE p.slug = 'win-wms'
  AND NOT EXISTS (SELECT 1 FROM content_items ci WHERE ci.owner_type = 'product' AND ci.owner_id = p.id AND ci.item_type = 'benefit' AND ci.sort_order = 2);

INSERT INTO content_items (owner_type, owner_id, item_type, title, body, icon, sort_order, is_active, created_at, updated_at)
SELECT 'product', p.id, 'benefit', 'Solution modulaire selon votre entrepot', 'Activez les modules utiles a vos flux sans figer inutilement le perimetre de la solution.', 'puzzle', 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
FROM products p
WHERE p.slug = 'win-wms'
  AND NOT EXISTS (SELECT 1 FROM content_items ci WHERE ci.owner_type = 'product' AND ci.owner_id = p.id AND ci.item_type = 'benefit' AND ci.sort_order = 3);

INSERT INTO content_items (owner_type, owner_id, item_type, title, body, icon, sort_order, is_active, created_at, updated_at)
SELECT 'product', p.id, 'benefit', 'Continuite entre terrain et gestion', 'Les operations WMS restent alignees avec votre gestion commerciale Sage 100 et vos equipements terrain.', 'workflow', 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
FROM products p
WHERE p.slug = 'win-wms'
  AND NOT EXISTS (SELECT 1 FROM content_items ci WHERE ci.owner_type = 'product' AND ci.owner_id = p.id AND ci.item_type = 'benefit' AND ci.sort_order = 4);

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET ci.title = 'Vision plus fiable des flux', ci.body = 'Les entrees, mouvements et sorties sont mieux relies dans un meme environnement logistique.', ci.icon = 'chart-column', ci.is_active = 1, ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms' AND ci.owner_type = 'product' AND ci.item_type = 'benefit' AND ci.sort_order = 1;

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET ci.title = 'Stocks mieux maitrises', ci.body = 'Le suivi des quantites, des emplacements et des ecarts gagne en coherence au quotidien.', ci.icon = 'shield-check', ci.is_active = 1, ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms' AND ci.owner_type = 'product' AND ci.item_type = 'benefit' AND ci.sort_order = 2;

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET ci.title = 'Solution modulaire selon votre entrepot', ci.body = 'Activez les modules utiles a vos flux sans figer inutilement le perimetre de la solution.', ci.icon = 'puzzle', ci.is_active = 1, ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms' AND ci.owner_type = 'product' AND ci.item_type = 'benefit' AND ci.sort_order = 3;

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET ci.title = 'Continuite entre terrain et gestion', ci.body = 'Les operations WMS restent alignees avec votre gestion commerciale Sage 100 et vos equipements terrain.', ci.icon = 'workflow', ci.is_active = 1, ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms' AND ci.owner_type = 'product' AND ci.item_type = 'benefit' AND ci.sort_order = 4;

INSERT INTO content_items (owner_type, owner_id, item_type, title, body, sort_order, is_active, created_at, updated_at)
SELECT 'product', p.id, 'faq', 'Win@WMS est-il une solution complete ?', 'Oui. Win@WMS constitue une solution principale de gestion d entrepot, capable de structurer les flux logistiques et d etre enrichie par des modules selon vos besoins.', 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
FROM products p
WHERE p.slug = 'win-wms'
  AND NOT EXISTS (SELECT 1 FROM content_items ci WHERE ci.owner_type = 'product' AND ci.owner_id = p.id AND ci.item_type = 'faq' AND ci.sort_order = 1);

INSERT INTO content_items (owner_type, owner_id, item_type, title, body, sort_order, is_active, created_at, updated_at)
SELECT 'product', p.id, 'faq', 'La solution fonctionne-t-elle avec Sage 100 ?', 'Oui. Win@WMS est pense pour prolonger votre environnement Sage 100 et mieux relier les operations terrain a la gestion commerciale.', 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
FROM products p
WHERE p.slug = 'win-wms'
  AND NOT EXISTS (SELECT 1 FROM content_items ci WHERE ci.owner_type = 'product' AND ci.owner_id = p.id AND ci.item_type = 'faq' AND ci.sort_order = 2);

INSERT INTO content_items (owner_type, owner_id, item_type, title, body, sort_order, is_active, created_at, updated_at)
SELECT 'product', p.id, 'faq', 'Peut-on demarrer avec un perimetre progressif ?', 'Oui. La solution peut etre deployee de facon modulaire, en activant les briques utiles selon vos priorites, vos flux et votre organisation.', 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
FROM products p
WHERE p.slug = 'win-wms'
  AND NOT EXISTS (SELECT 1 FROM content_items ci WHERE ci.owner_type = 'product' AND ci.owner_id = p.id AND ci.item_type = 'faq' AND ci.sort_order = 3);

INSERT INTO content_items (owner_type, owner_id, item_type, title, body, sort_order, is_active, created_at, updated_at)
SELECT 'product', p.id, 'faq', 'Quels flux peut-on couvrir avec Win@WMS ?', 'Reception, stockage, mouvements, preparation, expedition, inventaire et, selon les usages, vente directe ou traitements terrain associes.', 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
FROM products p
WHERE p.slug = 'win-wms'
  AND NOT EXISTS (SELECT 1 FROM content_items ci WHERE ci.owner_type = 'product' AND ci.owner_id = p.id AND ci.item_type = 'faq' AND ci.sort_order = 4);

INSERT INTO content_items (owner_type, owner_id, item_type, title, body, sort_order, is_active, created_at, updated_at)
SELECT 'product', p.id, 'faq', 'Les modules Win@WMS sont-ils combinables ?', 'Oui. Les modules Win@WMS sont concus pour fonctionner ensemble dans le meme environnement logistique, selon les besoins de votre entrepot.', 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
FROM products p
WHERE p.slug = 'win-wms'
  AND NOT EXISTS (SELECT 1 FROM content_items ci WHERE ci.owner_type = 'product' AND ci.owner_id = p.id AND ci.item_type = 'faq' AND ci.sort_order = 5);

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET ci.title = 'Win@WMS est-il une solution complete ?', ci.body = 'Oui. Win@WMS constitue une solution principale de gestion d entrepot, capable de structurer les flux logistiques et d etre enrichie par des modules selon vos besoins.', ci.is_active = 1, ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms' AND ci.owner_type = 'product' AND ci.item_type = 'faq' AND ci.sort_order = 1;

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET ci.title = 'La solution fonctionne-t-elle avec Sage 100 ?', ci.body = 'Oui. Win@WMS est pense pour prolonger votre environnement Sage 100 et mieux relier les operations terrain a la gestion commerciale.', ci.is_active = 1, ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms' AND ci.owner_type = 'product' AND ci.item_type = 'faq' AND ci.sort_order = 2;

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET ci.title = 'Peut-on demarrer avec un perimetre progressif ?', ci.body = 'Oui. La solution peut etre deployee de facon modulaire, en activant les briques utiles selon vos priorites, vos flux et votre organisation.', ci.is_active = 1, ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms' AND ci.owner_type = 'product' AND ci.item_type = 'faq' AND ci.sort_order = 3;

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET ci.title = 'Quels flux peut-on couvrir avec Win@WMS ?', ci.body = 'Reception, stockage, mouvements, preparation, expedition, inventaire et, selon les usages, vente directe ou traitements terrain associes.', ci.is_active = 1, ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms' AND ci.owner_type = 'product' AND ci.item_type = 'faq' AND ci.sort_order = 4;

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET ci.title = 'Les modules Win@WMS sont-ils combinables ?', ci.body = 'Oui. Les modules Win@WMS sont concus pour fonctionner ensemble dans le meme environnement logistique, selon les besoins de votre entrepot.', ci.is_active = 1, ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms' AND ci.owner_type = 'product' AND ci.item_type = 'faq' AND ci.sort_order = 5;

UPDATE content_items ci
JOIN products p ON p.id = ci.owner_id
SET
    ci.title = 'Parlons de votre organisation logistique',
    ci.body = '{"eyebrow":"Projet Win@WMS","body":"Nous vous aidons a cadrer vos flux, vos contraintes d entrepot et votre articulation avec Sage 100 pour deployer une solution WMS utile, modulaire et directement exploitable par vos equipes.","cta_label":"Demander une demonstration","cta_url":"/demo/","secondary_cta_label":"Voir les modules Win@WMS","secondary_cta_url":"/catalogue/modules/?product=win-wms"}',
    ci.updated_at = CURRENT_TIMESTAMP
WHERE p.slug = 'win-wms'
  AND ci.owner_type = 'product'
  AND ci.item_type = 'final_cta';
