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

ARTMX5315D ↔ 3936		► Stock : -1		► Prix : 247.933884		► Dictionnaire : OK
ARTMXS334G ↔ 6547		► Stock : -1		► Prix : 231.404959		► Dictionnaire : OK
FEND9KGNK9 ↔ -----		► Pas trouvé		► Pas trouvé			► Pas trouvé
JACKGMDJBK ↔ 48509		► Stock : 1			► Prix : 975.206612		► Dictionnaire : OK
SCHE90A41C ↔ 35991		► Stock : 99		► Prix : 1247.933884	► Dictionnaire : OK
SCHEA15A9D ↔ 36019		► Stock : 99		► Prix : 495.867769		► Dictionnaire : OK

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

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

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

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

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

[JACKGMDJBK]
UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '48509' AND quantity != '1';
UPDATE ps_product SET price = '975.206612' WHERE id_product = '48509' AND price != '975.206612';
UPDATE ps_product_shop SET price = '975.206612' WHERE id_product = '48509' AND price != '975.206612';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '48509' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '48509' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '48509' AND delivery_out_stock != 'En stock internet';
UPDATE ps_product_shop SET available_date = '2026-01-06' WHERE id_product = '48509' AND available_date != '2026-01-06';
UPDATE ps_product SET available_date = '2026-01-06' WHERE id_product = '48509' AND available_date != '2026-01-06';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '48509' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '48509' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '48509' AND active != '1';

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

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

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

=== Fin de FFWD ===