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

DUNLOP001N ↔ 21903		► Stock : 1			► Prix : 20.661157		► Dictionnaire : OK
LDSY248804 ↔ 22062		► Stock : 1			► Prix : 685.950413		► Dictionnaire : OK
LDSY5E66E4 ↔ 21971		► Stock : 1			► Prix : 607.438017		► Dictionnaire : OK
LDSY81G5LC ↔ 43927		► Stock : -1		► Prix : 0				► Dictionnaire : OK
LDSY8BCC4F ↔ -----		► Pas trouvé		► Pas trouvé			► Pas trouvé
LDSYST530J ↔ 589		► Stock : 99		► Prix : 392.561983		► Dictionnaire : OK
LEVY84A4DA ↔ 30357		► Stock : 1			► Prix : 41.322314		► Dictionnaire : OK
MEINLP841U ↔ 30386		► Stock : 1			► Prix : 42.975207		► Dictionnaire : OK
MEINLT110U ↔ 32789		► Stock : 1			► Prix : 22.31405		► Dictionnaire : OK
PROMDM5889 ↔ 40085		► Stock : 99		► Prix : 13.22314		► Dictionnaire : OK
SONI3ECD64 ↔ 30409		► Stock : -1		► Prix : 28.92562		► Dictionnaire : OK

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

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

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

[DUNLOP001N]
UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '21903' AND quantity != '1';
UPDATE ps_product SET price = '20.661157' WHERE id_product = '21903' AND price != '20.661157';
UPDATE ps_product_shop SET price = '20.661157' WHERE id_product = '21903' AND price != '20.661157';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '21903' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '21903' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '21903' AND delivery_out_stock != 'En stock internet';
UPDATE ps_product_shop SET available_date = '2026-10-12' WHERE id_product = '21903' AND available_date != '2026-10-12';
UPDATE ps_product SET available_date = '2026-10-12' WHERE id_product = '21903' AND available_date != '2026-10-12';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '21903' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '21903' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '21903' AND active != '1';

[LDSY248804]
UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '22062' AND quantity != '1';
UPDATE ps_product SET price = '685.950413' WHERE id_product = '22062' AND price != '685.950413';
UPDATE ps_product_shop SET price = '685.950413' WHERE id_product = '22062' AND price != '685.950413';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '22062' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '22062' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '22062' AND delivery_out_stock != 'En stock internet';
UPDATE ps_product_shop SET available_date = '2026-10-12' WHERE id_product = '22062' AND available_date != '2026-10-12';
UPDATE ps_product SET available_date = '2026-10-12' WHERE id_product = '22062' AND available_date != '2026-10-12';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '22062' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '22062' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '22062' AND active != '1';

[LDSY5E66E4]
UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '21971' AND quantity != '1';
UPDATE ps_product SET price = '607.438017' WHERE id_product = '21971' AND price != '607.438017';
UPDATE ps_product_shop SET price = '607.438017' WHERE id_product = '21971' AND price != '607.438017';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '21971' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '21971' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '21971' AND delivery_out_stock != 'En stock internet';
UPDATE ps_product_shop SET available_date = '2026-10-12' WHERE id_product = '21971' AND available_date != '2026-10-12';
UPDATE ps_product SET available_date = '2026-10-12' WHERE id_product = '21971' AND available_date != '2026-10-12';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '21971' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '21971' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '21971' AND active != '1';

[LDSY81G5LC]
UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '43927' AND quantity != '-1';
UPDATE ps_product SET price = '0' WHERE id_product = '43927' AND price != '0';
UPDATE ps_product_shop SET price = '0' WHERE id_product = '43927' AND price != '0';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '43927' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '43927' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'Disponible' WHERE id_product = '43927' AND delivery_out_stock != 'Disponible';
UPDATE ps_product_shop SET available_date = '2026-04-24' WHERE id_product = '43927' AND available_date != '2026-04-24';
UPDATE ps_product SET available_date = '2026-04-24' WHERE id_product = '43927' AND available_date != '2026-04-24';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '43927' AND out_of_stock != '2';
UPDATE ps_product SET active = '0' WHERE id_product = '43927' AND active != '0';
UPDATE ps_product_shop SET active = '0' WHERE id_product = '43927' AND active != '0';

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

[LEVY84A4DA]
UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '30357' AND quantity != '1';
UPDATE ps_product SET price = '41.322314' WHERE id_product = '30357' AND price != '41.322314';
UPDATE ps_product_shop SET price = '41.322314' WHERE id_product = '30357' AND price != '41.322314';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '30357' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '30357' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '30357' AND delivery_out_stock != 'En stock internet';
UPDATE ps_product_shop SET available_date = '2026-10-12' WHERE id_product = '30357' AND available_date != '2026-10-12';
UPDATE ps_product SET available_date = '2026-10-12' WHERE id_product = '30357' AND available_date != '2026-10-12';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '30357' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '30357' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '30357' AND active != '1';

[MEINLP841U]
UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '30386' AND quantity != '1';
UPDATE ps_product SET price = '42.975207' WHERE id_product = '30386' AND price != '42.975207';
UPDATE ps_product_shop SET price = '42.975207' WHERE id_product = '30386' AND price != '42.975207';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '30386' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '30386' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '30386' AND delivery_out_stock != 'En stock internet';
UPDATE ps_product_shop SET available_date = '2026-10-12' WHERE id_product = '30386' AND available_date != '2026-10-12';
UPDATE ps_product SET available_date = '2026-10-12' WHERE id_product = '30386' AND available_date != '2026-10-12';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '30386' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '30386' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '30386' AND active != '1';

[MEINLT110U]
UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '32789' AND quantity != '1';
UPDATE ps_product SET price = '22.31405' WHERE id_product = '32789' AND price != '22.31405';
UPDATE ps_product_shop SET price = '22.31405' WHERE id_product = '32789' AND price != '22.31405';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '32789' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '32789' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '32789' AND delivery_out_stock != 'En stock internet';
UPDATE ps_product_shop SET available_date = '2026-10-12' WHERE id_product = '32789' AND available_date != '2026-10-12';
UPDATE ps_product SET available_date = '2026-10-12' WHERE id_product = '32789' AND available_date != '2026-10-12';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '32789' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '32789' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '32789' AND active != '1';

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

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

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

=== Fin de FFWD ===