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

DUNL700F37 ↔ 26216		► Stock : 99		► Prix : 152.892562		► Dictionnaire : OK
HERCC16231 ↔ 34100		► Stock : -1		► Prix : 24.793388		► Dictionnaire : OK
SEEL138F80 ↔ 13067		► Stock : 99		► Prix : 157.024793		► Dictionnaire : OK
EHXRX67HKR ↔ 36654		► Stock : 99		► Prix : 103.305785		► Dictionnaire : OK
FOXG033F27 ↔ 30602		► Stock : 99		► Prix : 82.644628		► Dictionnaire : OK
GATORH735X ↔ 25920		► Stock : 1			► Prix : 70.247934		► Dictionnaire : OK
MAXONO900I ↔ 5984		► Stock : 99		► Prix : 123.966942		► Dictionnaire : OK
AVAN43766A ↔ 25695		► Stock : 99		► Prix : 148.760331		► Dictionnaire : OK
HOHNER601U ↔ 30016		► Stock : 99		► Prix : 37.190083		► Dictionnaire : OK
VICFIR656Y ↔ 9272		► Stock : -1		► Prix : 13.22314		► Dictionnaire : OK
CORDIA514Q ↔ -----		► Pas trouvé		► Pas trouvé			► Pas trouvé
EBSD9BEEE9 ↔ -----		► Pas trouvé		► Pas trouvé			► Pas trouvé
ELECTR040Q ↔ 1747		► Stock : 99		► Prix : 99.173554		► Dictionnaire : OK

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

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

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

[DUNL700F37]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '26216' AND quantity != '99';
UPDATE ps_product SET price = '152.892562' WHERE id_product = '26216' AND price != '152.892562';
UPDATE ps_product_shop SET price = '152.892562' WHERE id_product = '26216' AND price != '152.892562';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '26216' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '26216' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '26216' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-01-08' WHERE id_product = '26216' AND available_date != '2026-01-08';
UPDATE ps_product SET available_date = '2026-01-08' WHERE id_product = '26216' AND available_date != '2026-01-08';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '26216' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '26216' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '26216' AND active != '1';

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

[SEEL138F80]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '13067' AND quantity != '99';
UPDATE ps_product SET price = '157.024793' WHERE id_product = '13067' AND price != '157.024793';
UPDATE ps_product_shop SET price = '157.024793' WHERE id_product = '13067' AND price != '157.024793';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '13067' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '13067' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '13067' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-01-08' WHERE id_product = '13067' AND available_date != '2026-01-08';
UPDATE ps_product SET available_date = '2026-01-08' WHERE id_product = '13067' AND available_date != '2026-01-08';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '13067' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '13067' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '13067' AND active != '1';

[EHXRX67HKR]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '36654' AND quantity != '99';
UPDATE ps_product SET price = '103.305785' WHERE id_product = '36654' AND price != '103.305785';
UPDATE ps_product_shop SET price = '103.305785' WHERE id_product = '36654' AND price != '103.305785';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '36654' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '36654' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '36654' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-01-08' WHERE id_product = '36654' AND available_date != '2026-01-08';
UPDATE ps_product SET available_date = '2026-01-08' WHERE id_product = '36654' AND available_date != '2026-01-08';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '36654' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '36654' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '36654' AND active != '1';

[FOXG033F27]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '30602' AND quantity != '99';
UPDATE ps_product SET price = '82.644628' WHERE id_product = '30602' AND price != '82.644628';
UPDATE ps_product_shop SET price = '82.644628' WHERE id_product = '30602' AND price != '82.644628';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '30602' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '30602' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '30602' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-01-08' WHERE id_product = '30602' AND available_date != '2026-01-08';
UPDATE ps_product SET available_date = '2026-01-08' WHERE id_product = '30602' AND available_date != '2026-01-08';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '30602' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '30602' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '30602' AND active != '1';

[GATORH735X]
UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '25920' AND quantity != '1';
UPDATE ps_product SET price = '70.247934' WHERE id_product = '25920' AND price != '70.247934';
UPDATE ps_product_shop SET price = '70.247934' WHERE id_product = '25920' AND price != '70.247934';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '25920' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '25920' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '25920' AND delivery_out_stock != 'En stock internet';
UPDATE ps_product_shop SET available_date = '2026-01-05' WHERE id_product = '25920' AND available_date != '2026-01-05';
UPDATE ps_product SET available_date = '2026-01-05' WHERE id_product = '25920' AND available_date != '2026-01-05';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '25920' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '25920' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '25920' AND active != '1';

[MAXONO900I]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '5984' AND quantity != '99';
UPDATE ps_product SET price = '123.966942' WHERE id_product = '5984' AND price != '123.966942';
UPDATE ps_product_shop SET price = '123.966942' WHERE id_product = '5984' AND price != '123.966942';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '5984' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '5984' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '5984' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-01-08' WHERE id_product = '5984' AND available_date != '2026-01-08';
UPDATE ps_product SET available_date = '2026-01-08' WHERE id_product = '5984' AND available_date != '2026-01-08';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '5984' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '5984' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '5984' AND active != '1';

[AVAN43766A]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '25695' AND quantity != '99';
UPDATE ps_product SET price = '148.760331' WHERE id_product = '25695' AND price != '148.760331';
UPDATE ps_product_shop SET price = '148.760331' WHERE id_product = '25695' AND price != '148.760331';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '25695' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '25695' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '25695' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-01-08' WHERE id_product = '25695' AND available_date != '2026-01-08';
UPDATE ps_product SET available_date = '2026-01-08' WHERE id_product = '25695' AND available_date != '2026-01-08';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '25695' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '25695' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '25695' AND active != '1';

[HOHNER601U]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '30016' AND quantity != '99';
UPDATE ps_product SET price = '37.190083' WHERE id_product = '30016' AND price != '37.190083';
UPDATE ps_product_shop SET price = '37.190083' WHERE id_product = '30016' AND price != '37.190083';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '30016' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '30016' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '30016' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-01-08' WHERE id_product = '30016' AND available_date != '2026-01-08';
UPDATE ps_product SET available_date = '2026-01-08' WHERE id_product = '30016' AND available_date != '2026-01-08';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '30016' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '30016' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '30016' AND active != '1';

[VICFIR656Y]
UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '9272' AND quantity != '-1';
UPDATE ps_product SET price = '13.22314' WHERE id_product = '9272' AND price != '13.22314';
UPDATE ps_product_shop SET price = '13.22314' WHERE id_product = '9272' AND price != '13.22314';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '9272' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '9272' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'Disponible' WHERE id_product = '9272' AND delivery_out_stock != 'Disponible';
UPDATE ps_product_shop SET available_date = '2025-09-29' WHERE id_product = '9272' AND available_date != '2025-09-29';
UPDATE ps_product SET available_date = '2025-09-29' WHERE id_product = '9272' AND available_date != '2025-09-29';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '9272' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '9272' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '9272' AND active != '1';

[ELECTR040Q]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '1747' AND quantity != '99';
UPDATE ps_product SET price = '99.173554' WHERE id_product = '1747' AND price != '99.173554';
UPDATE ps_product_shop SET price = '99.173554' WHERE id_product = '1747' AND price != '99.173554';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '1747' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '1747' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '1747' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-01-08' WHERE id_product = '1747' AND available_date != '2026-01-08';
UPDATE ps_product SET available_date = '2026-01-08' WHERE id_product = '1747' AND available_date != '2026-01-08';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '1747' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '1747' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '1747' AND active != '1';

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

=== Fin de FFWD ===