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

HERCUG10EH ↔ 36772		► Stock : 99		► Prix : 41.322314		► Dictionnaire : OK
CORDIA021W ↔ 42398		► Stock : 99		► Prix : 14.876033		► Dictionnaire : OK
MARK69QQZH ↔ 39266		► Stock : -1		► Prix : 438.016529		► Dictionnaire : OK
KORGVHMRXJ ↔ 47285		► Stock : -1		► Prix : 3016.528926	► Dictionnaire : OK
ADAM862225 ↔ 18698		► Stock : 99		► Prix : 13.22314		► Dictionnaire : OK

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

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

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

[HERCUG10EH]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '36772' AND quantity != '99';
UPDATE ps_product SET price = '41.322314' WHERE id_product = '36772' AND price != '41.322314';
UPDATE ps_product_shop SET price = '41.322314' WHERE id_product = '36772' AND price != '41.322314';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '36772' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '36772' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '36772' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-07-04' WHERE id_product = '36772' AND available_date != '2026-07-04';
UPDATE ps_product SET available_date = '2026-07-04' WHERE id_product = '36772' AND available_date != '2026-07-04';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '36772' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '36772' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '36772' AND active != '1';

[CORDIA021W]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '42398' AND quantity != '99';
UPDATE ps_product SET price = '14.876033' WHERE id_product = '42398' AND price != '14.876033';
UPDATE ps_product_shop SET price = '14.876033' WHERE id_product = '42398' AND price != '14.876033';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '42398' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '42398' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '42398' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-07-04' WHERE id_product = '42398' AND available_date != '2026-07-04';
UPDATE ps_product SET available_date = '2026-07-04' WHERE id_product = '42398' AND available_date != '2026-07-04';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '42398' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '42398' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '42398' AND active != '1';

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

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

[ADAM862225]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '18698' AND quantity != '99';
UPDATE ps_product SET price = '13.22314' WHERE id_product = '18698' AND price != '13.22314';
UPDATE ps_product_shop SET price = '13.22314' WHERE id_product = '18698' AND price != '13.22314';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '18698' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '18698' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '18698' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-07-04' WHERE id_product = '18698' AND available_date != '2026-07-04';
UPDATE ps_product SET available_date = '2026-07-04' WHERE id_product = '18698' AND available_date != '2026-07-04';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '18698' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '18698' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '18698' AND active != '1';

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

=== Fin de FFWD ===