=== 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 *** CUEN039B3B ↔ 30784 ► Stock : -1 ► Prix : 599.173554 ► Dictionnaire : OK CUENCA130Z ↔ 1425 ► Stock : -1 ► Prix : 487.603306 ► Dictionnaire : OK CUENCA429A ↔ 1424 ► Stock : -1 ► Prix : 599.173554 ► Dictionnaire : OK CUENCA536B ↔ 1430 ► Stock : -1 ► Prix : 309.917355 ► Dictionnaire : OK CUENCA932L ↔ 29966 ► Stock : -1 ► Prix : 371.900826 ► Dictionnaire : OK CUENVFZ3D4 ↔ 42521 ► Stock : -1 ► Prix : 487.603306 ► Dictionnaire : OK SMLF58767C ↔ ----- ► Pas trouvé ► Pas trouvé ► Pas trouvé 6 référence(s) trouvée(s) dans Prestashop *** Mise à jour des données *** *** Début des transactions SQL *** [CUEN039B3B] UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '30784' AND quantity != '-1'; UPDATE ps_product SET price = '599.173554' WHERE id_product = '30784' AND price != '599.173554'; UPDATE ps_product_shop SET price = '599.173554' WHERE id_product = '30784' AND price != '599.173554'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '30784' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '30784' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = 'Appeler pour vérifier' WHERE id_product = '30784' AND delivery_out_stock != 'Appeler pour vérifier'; UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '30784' AND available_date != '1900-01-01'; UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '30784' AND available_date != '1900-01-01'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '30784' AND out_of_stock != '2'; UPDATE ps_product SET active = '1' WHERE id_product = '30784' AND active != '1'; UPDATE ps_product_shop SET active = '1' WHERE id_product = '30784' AND active != '1'; [CUENCA130Z] UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '1425' AND quantity != '-1'; UPDATE ps_product SET price = '487.603306' WHERE id_product = '1425' AND price != '487.603306'; UPDATE ps_product_shop SET price = '487.603306' WHERE id_product = '1425' AND price != '487.603306'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '1425' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '1425' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = 'Appeler pour vérifier' WHERE id_product = '1425' AND delivery_out_stock != 'Appeler pour vérifier'; UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '1425' AND available_date != '1900-01-01'; UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '1425' AND available_date != '1900-01-01'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '1425' AND out_of_stock != '2'; UPDATE ps_product SET active = '1' WHERE id_product = '1425' AND active != '1'; UPDATE ps_product_shop SET active = '1' WHERE id_product = '1425' AND active != '1'; [CUENCA429A] UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '1424' AND quantity != '-1'; UPDATE ps_product SET price = '599.173554' WHERE id_product = '1424' AND price != '599.173554'; UPDATE ps_product_shop SET price = '599.173554' WHERE id_product = '1424' AND price != '599.173554'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '1424' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '1424' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = 'Appeler pour vérifier' WHERE id_product = '1424' AND delivery_out_stock != 'Appeler pour vérifier'; UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '1424' AND available_date != '1900-01-01'; UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '1424' AND available_date != '1900-01-01'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '1424' AND out_of_stock != '2'; UPDATE ps_product SET active = '1' WHERE id_product = '1424' AND active != '1'; UPDATE ps_product_shop SET active = '1' WHERE id_product = '1424' AND active != '1'; [CUENCA536B] UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '1430' AND quantity != '-1'; UPDATE ps_product SET price = '309.917355' WHERE id_product = '1430' AND price != '309.917355'; UPDATE ps_product_shop SET price = '309.917355' WHERE id_product = '1430' AND price != '309.917355'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '1430' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '1430' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = 'Appeler pour vérifier' WHERE id_product = '1430' AND delivery_out_stock != 'Appeler pour vérifier'; UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '1430' AND available_date != '1900-01-01'; UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '1430' AND available_date != '1900-01-01'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '1430' AND out_of_stock != '2'; UPDATE ps_product SET active = '1' WHERE id_product = '1430' AND active != '1'; UPDATE ps_product_shop SET active = '1' WHERE id_product = '1430' AND active != '1'; [CUENCA932L] UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '29966' AND quantity != '-1'; UPDATE ps_product SET price = '371.900826' WHERE id_product = '29966' AND price != '371.900826'; UPDATE ps_product_shop SET price = '371.900826' WHERE id_product = '29966' AND price != '371.900826'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '29966' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '29966' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = 'Appeler pour vérifier' WHERE id_product = '29966' AND delivery_out_stock != 'Appeler pour vérifier'; UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '29966' AND available_date != '1900-01-01'; UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '29966' AND available_date != '1900-01-01'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '29966' AND out_of_stock != '2'; UPDATE ps_product SET active = '1' WHERE id_product = '29966' AND active != '1'; UPDATE ps_product_shop SET active = '1' WHERE id_product = '29966' AND active != '1'; [CUENVFZ3D4] UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '42521' AND quantity != '-1'; UPDATE ps_product SET price = '487.603306' WHERE id_product = '42521' AND price != '487.603306'; UPDATE ps_product_shop SET price = '487.603306' WHERE id_product = '42521' AND price != '487.603306'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '42521' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '42521' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = 'Appeler pour vérifier' WHERE id_product = '42521' AND delivery_out_stock != 'Appeler pour vérifier'; UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '42521' AND available_date != '1900-01-01'; UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '42521' AND available_date != '1900-01-01'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '42521' AND out_of_stock != '2'; UPDATE ps_product SET active = '1' WHERE id_product = '42521' AND active != '1'; UPDATE ps_product_shop SET active = '1' WHERE id_product = '42521' AND active != '1'; *** Fin des transactions SQL *** Produit(s) traité(s) : 6 Requête(s) envoyée(s) : 66 === Fin de FFWD ===