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

ADAMC6404B ↔ 18671		► Stock : 99		► Prix : 9.917355		► Dictionnaire : OK
ARTL90F12E ↔ 40821		► Stock : -1		► Prix : 673.553719		► Dictionnaire : OK
DADD7WCWWD ↔ 35454		► Stock : 99		► Prix : 18.181818		► Dictionnaire : OK
DRUM68GU9S ↔ 42405		► Stock : -1		► Prix : 99.173554		► Dictionnaire : OK
GEWA156FF7 ↔ 28323		► Stock : 99		► Prix : 41.322314		► Dictionnaire : OK

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

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

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

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

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

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

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

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

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

=== Fin de FFWD ===