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

ROLA253D95 ↔ 30308		► Stock : 1			► Prix : 181.818182		► Dictionnaire : OK
ROLA2EDD4B ↔ 18607		► Stock : 99		► Prix : 28.92562		► Dictionnaire : OK
ROLAAPZ8RB ↔ 43742		► Stock : 0			► Prix : 768.595041		► Dictionnaire : OK
ROLAND311N ↔ 708		► Stock : 99		► Prix : 28.92562		► Dictionnaire : OK
ROLAND041R ↔ 6681		► Stock : -1		► Prix : 61.983471		► Dictionnaire : OK
ROLA4D0EE1 ↔ 16048		► Stock : -1		► Prix : 86.77686		► Dictionnaire : OK

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

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

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

[ROLA253D95]
UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '30308' AND quantity != '1';
UPDATE ps_product SET price = '181.818182' WHERE id_product = '30308' AND price != '181.818182';
UPDATE ps_product_shop SET price = '181.818182' WHERE id_product = '30308' AND price != '181.818182';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '30308' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '30308' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '30308' AND delivery_out_stock != 'En stock internet';
UPDATE ps_product_shop SET available_date = '2026-06-08' WHERE id_product = '30308' AND available_date != '2026-06-08';
UPDATE ps_product SET available_date = '2026-06-08' WHERE id_product = '30308' AND available_date != '2026-06-08';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '30308' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '30308' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '30308' AND active != '1';

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

[ROLAAPZ8RB]
UPDATE ps_stock_available SET quantity = '0' WHERE id_product = '43742' AND quantity != '0';
UPDATE ps_product SET price = '768.595041' WHERE id_product = '43742' AND price != '768.595041';
UPDATE ps_product_shop SET price = '768.595041' WHERE id_product = '43742' AND price != '768.595041';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '43742' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '43742' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'Prévu pour fin juillet 2026' WHERE id_product = '43742' AND delivery_out_stock != 'Prévu pour fin juillet 2026';
UPDATE ps_product_shop SET available_date = '2026-07-26' WHERE id_product = '43742' AND available_date != '2026-07-26';
UPDATE ps_product SET available_date = '2026-07-26' WHERE id_product = '43742' AND available_date != '2026-07-26';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '43742' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '43742' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '43742' AND active != '1';

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

[ROLAND041R]
UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '6681' AND quantity != '-1';
UPDATE ps_product SET price = '61.983471' WHERE id_product = '6681' AND price != '61.983471';
UPDATE ps_product_shop SET price = '61.983471' WHERE id_product = '6681' AND price != '61.983471';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '6681' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '6681' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'Disponible' WHERE id_product = '6681' AND delivery_out_stock != 'Disponible';
UPDATE ps_product_shop SET available_date = '2026-05-11' WHERE id_product = '6681' AND available_date != '2026-05-11';
UPDATE ps_product SET available_date = '2026-05-11' WHERE id_product = '6681' AND available_date != '2026-05-11';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '6681' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '6681' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '6681' AND active != '1';

[ROLA4D0EE1]
UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '16048' AND quantity != '-1';
UPDATE ps_product SET price = '86.77686' WHERE id_product = '16048' AND price != '86.77686';
UPDATE ps_product_shop SET price = '86.77686' WHERE id_product = '16048' AND price != '86.77686';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '16048' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '16048' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'Prévu pour milieu février 2025' WHERE id_product = '16048' AND delivery_out_stock != 'Prévu pour milieu février 2025';
UPDATE ps_product_shop SET available_date = '2024-12-27' WHERE id_product = '16048' AND available_date != '2024-12-27';
UPDATE ps_product SET available_date = '2024-12-27' WHERE id_product = '16048' AND available_date != '2024-12-27';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '16048' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '16048' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '16048' AND active != '1';

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

=== Fin de FFWD ===