=== 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 ***

ERNIEB435H ↔ 24196		► Stock : -1		► Prix : 0				► Dictionnaire : OK
GATOA63D0D ↔ 25908		► Stock : 99		► Prix : 70.247934		► Dictionnaire : OK
GATORH536V ↔ 25919		► Stock : -1		► Prix : 90.909091		► Dictionnaire : OK
GEWAET113S ↔ 27981		► Stock : -1		► Prix : 86.77686		► Dictionnaire : OK
ISTATO4SC9 ↔ 33247		► Stock : -1		► Prix : 99.173554		► Dictionnaire : OK
LAGTBIHKYA ↔ 42509		► Stock : -1		► Prix : 243.801653		► Dictionnaire : OK
NUXML6L32I ↔ 45880		► Stock : 99		► Prix : 136.363636		► Dictionnaire : OK
QSTI9EDE64 ↔ 23281		► Stock : -1		► Prix : 29.752066		► Dictionnaire : OK
ROLALBON7S ↔ 33513		► Stock : 1			► Prix : 206.61157		► Dictionnaire : OK

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

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

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

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

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

[GATORH536V]
UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '25919' AND quantity != '-1';
UPDATE ps_product SET price = '90.909091' WHERE id_product = '25919' AND price != '90.909091';
UPDATE ps_product_shop SET price = '90.909091' WHERE id_product = '25919' AND price != '90.909091';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '25919' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '25919' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'Prévu pour fin mai 2026' WHERE id_product = '25919' AND delivery_out_stock != 'Prévu pour fin mai 2026';
UPDATE ps_product_shop SET available_date = '2026-05-22' WHERE id_product = '25919' AND available_date != '2026-05-22';
UPDATE ps_product SET available_date = '2026-05-22' WHERE id_product = '25919' AND available_date != '2026-05-22';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '25919' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '25919' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '25919' AND active != '1';

[GEWAET113S]
UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '27981' AND quantity != '-1';
UPDATE ps_product SET price = '86.77686' WHERE id_product = '27981' AND price != '86.77686';
UPDATE ps_product_shop SET price = '86.77686' WHERE id_product = '27981' AND price != '86.77686';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '27981' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '27981' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'Disponible' WHERE id_product = '27981' AND delivery_out_stock != 'Disponible';
UPDATE ps_product_shop SET available_date = '2026-04-27' WHERE id_product = '27981' AND available_date != '2026-04-27';
UPDATE ps_product SET available_date = '2026-04-27' WHERE id_product = '27981' AND available_date != '2026-04-27';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '27981' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '27981' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '27981' AND active != '1';

[ISTATO4SC9]
UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '33247' AND quantity != '-1';
UPDATE ps_product SET price = '99.173554' WHERE id_product = '33247' AND price != '99.173554';
UPDATE ps_product_shop SET price = '99.173554' WHERE id_product = '33247' AND price != '99.173554';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '33247' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '33247' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = '' WHERE id_product = '33247' AND delivery_out_stock != '';
UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '33247' AND available_date != '1900-01-01';
UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '33247' AND available_date != '1900-01-01';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '33247' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '33247' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '33247' AND active != '1';

[LAGTBIHKYA]
UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '42509' AND quantity != '-1';
UPDATE ps_product SET price = '243.801653' WHERE id_product = '42509' AND price != '243.801653';
UPDATE ps_product_shop SET price = '243.801653' WHERE id_product = '42509' AND price != '243.801653';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '42509' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '42509' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'Disponible' WHERE id_product = '42509' AND delivery_out_stock != 'Disponible';
UPDATE ps_product_shop SET available_date = '2026-05-29' WHERE id_product = '42509' AND available_date != '2026-05-29';
UPDATE ps_product SET available_date = '2026-05-29' WHERE id_product = '42509' AND available_date != '2026-05-29';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '42509' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '42509' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '42509' AND active != '1';

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

[QSTI9EDE64]
UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '23281' AND quantity != '-1';
UPDATE ps_product SET price = '29.752066' WHERE id_product = '23281' AND price != '29.752066';
UPDATE ps_product_shop SET price = '29.752066' WHERE id_product = '23281' AND price != '29.752066';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '23281' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '23281' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = '' WHERE id_product = '23281' AND delivery_out_stock != '';
UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '23281' AND available_date != '1900-01-01';
UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '23281' AND available_date != '1900-01-01';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '23281' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '23281' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '23281' AND active != '1';

[ROLALBON7S]
UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '33513' AND quantity != '1';
UPDATE ps_product SET price = '206.61157' WHERE id_product = '33513' AND price != '206.61157';
UPDATE ps_product_shop SET price = '206.61157' WHERE id_product = '33513' AND price != '206.61157';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '33513' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '33513' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '33513' AND delivery_out_stock != 'En stock internet';
UPDATE ps_product_shop SET available_date = '2026-06-15' WHERE id_product = '33513' AND available_date != '2026-06-15';
UPDATE ps_product SET available_date = '2026-06-15' WHERE id_product = '33513' AND available_date != '2026-06-15';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '33513' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '33513' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '33513' AND active != '1';

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

=== Fin de FFWD ===