=== Début de FFWD ===

*** Tous les articles modifiés depuis les 15 dernières minutes ***

*** Backup des données avant l'importation ***

*** Correspondance et préparation des données ***

DIGI3A3C3D ↔ 19934		► Stock : 99		► Prix : 239.669421		► Dictionnaire : OK
HOHN7407EA ↔ 19828		► Stock : 99		► Prix : 12.396694		► Dictionnaire : OK
MAPE1A69B4 ↔ 21585		► Stock : 99		► Prix : 24.793388		► Dictionnaire : OK
MAPE283049 ↔ 7445		► Stock : 99		► Prix : 57.85124		► Dictionnaire : OK
MAPEJWP0EA ↔ 38820		► Stock : -1		► Prix : 210.743802		► Dictionnaire : OK
MAPEXH759W ↔ 7386		► Stock : 99		► Prix : 458.677686		► Dictionnaire : OK

6 référence(s) trouvée(s) dans Prestashop

*** Mise à jour des données ***

*** Début des transactions SQL ***

[DIGI3A3C3D]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '19934' AND quantity != '99';
UPDATE ps_product SET price = '239.669421' WHERE id_product = '19934' AND price != '239.669421';
UPDATE ps_product_shop SET price = '239.669421' WHERE id_product = '19934' AND price != '239.669421';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '19934' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '19934' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '19934' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-06-13' WHERE id_product = '19934' AND available_date != '2026-06-13';
UPDATE ps_product SET available_date = '2026-06-13' WHERE id_product = '19934' AND available_date != '2026-06-13';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '19934' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '19934' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '19934' AND active != '1';

[HOHN7407EA]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '19828' AND quantity != '99';
UPDATE ps_product SET price = '12.396694' WHERE id_product = '19828' AND price != '12.396694';
UPDATE ps_product_shop SET price = '12.396694' WHERE id_product = '19828' AND price != '12.396694';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '19828' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '19828' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '19828' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-06-13' WHERE id_product = '19828' AND available_date != '2026-06-13';
UPDATE ps_product SET available_date = '2026-06-13' WHERE id_product = '19828' AND available_date != '2026-06-13';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '19828' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '19828' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '19828' AND active != '1';

[MAPE1A69B4]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '21585' AND quantity != '99';
UPDATE ps_product SET price = '24.793388' WHERE id_product = '21585' AND price != '24.793388';
UPDATE ps_product_shop SET price = '24.793388' WHERE id_product = '21585' AND price != '24.793388';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '21585' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '21585' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '21585' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-06-13' WHERE id_product = '21585' AND available_date != '2026-06-13';
UPDATE ps_product SET available_date = '2026-06-13' WHERE id_product = '21585' AND available_date != '2026-06-13';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '21585' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '21585' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '21585' AND active != '1';

[MAPE283049]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '7445' AND quantity != '99';
UPDATE ps_product SET price = '57.85124' WHERE id_product = '7445' AND price != '57.85124';
UPDATE ps_product_shop SET price = '57.85124' WHERE id_product = '7445' AND price != '57.85124';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '7445' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '7445' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '7445' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-06-13' WHERE id_product = '7445' AND available_date != '2026-06-13';
UPDATE ps_product SET available_date = '2026-06-13' WHERE id_product = '7445' AND available_date != '2026-06-13';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '7445' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '7445' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '7445' AND active != '1';

[MAPEJWP0EA]
UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '38820' AND quantity != '-1';
UPDATE ps_product SET price = '210.743802' WHERE id_product = '38820' AND price != '210.743802';
UPDATE ps_product_shop SET price = '210.743802' WHERE id_product = '38820' AND price != '210.743802';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '38820' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '38820' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'Appeler pour vérifier' WHERE id_product = '38820' AND delivery_out_stock != 'Appeler pour vérifier';
UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '38820' AND available_date != '1900-01-01';
UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '38820' AND available_date != '1900-01-01';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '38820' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '38820' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '38820' AND active != '1';

[MAPEXH759W]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '7386' AND quantity != '99';
UPDATE ps_product SET price = '458.677686' WHERE id_product = '7386' AND price != '458.677686';
UPDATE ps_product_shop SET price = '458.677686' WHERE id_product = '7386' AND price != '458.677686';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '7386' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '7386' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '7386' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-06-13' WHERE id_product = '7386' AND available_date != '2026-06-13';
UPDATE ps_product SET available_date = '2026-06-13' WHERE id_product = '7386' AND available_date != '2026-06-13';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '7386' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '7386' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '7386' AND active != '1';

*** Fin des transactions SQL ***
Produit(s) traité(s) : 6
Requête(s) envoyée(s) : 66

=== Fin de FFWD ===