=== 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 *** ADAM860682 ↔ 18647 ► Stock : 99 ► Prix : 9.917355 ► Dictionnaire : OK PALMER958U ↔ 7272 ► Stock : 1 ► Prix : 41.322314 ► Dictionnaire : OK VAND1D8F04 ↔ ----- ► Pas trouvé ► Pas trouvé ► Pas trouvé VANDOR414O ↔ ----- ► Pas trouvé ► Pas trouvé ► Pas trouvé BEYERD600T ↔ ----- ► Pas trouvé ► Pas trouvé ► Pas trouvé BEYERD745U ↔ 1838 ► Stock : -1 ► Prix : 0 ► Dictionnaire : OK GRAV982D3C ↔ 18778 ► Stock : 1 ► Prix : 53.719008 ► Dictionnaire : OK PALMER112W ↔ 7252 ► Stock : 1 ► Prix : 53.719008 ► Dictionnaire : OK CORDIA204O ↔ 42396 ► Stock : 99 ► Prix : 16.528926 ► Dictionnaire : OK GRAVCB4872 ↔ ----- ► Pas trouvé ► Pas trouvé ► Pas trouvé BEYE0FDD03 ↔ ----- ► Pas trouvé ► Pas trouvé ► Pas trouvé BEYE14181A ↔ 35218 ► Stock : -1 ► Prix : 0 ► Dictionnaire : OK BEYE357C77 ↔ ----- ► Pas trouvé ► Pas trouvé ► Pas trouvé BEYE9FCD24 ↔ 20943 ► Stock : -1 ► Prix : 0 ► Dictionnaire : OK BEYEACB599 ↔ ----- ► Pas trouvé ► Pas trouvé ► Pas trouvé BEYEFED427 ↔ 11573 ► Stock : -1 ► Prix : 0 ► Dictionnaire : OK BEYERD002P ↔ 35219 ► Stock : -1 ► Prix : 0 ► Dictionnaire : OK 10 référence(s) trouvée(s) dans Prestashop *** Mise à jour des données *** *** Début des transactions SQL *** [ADAM860682] UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '18647' AND quantity != '99'; UPDATE ps_product SET price = '9.917355' WHERE id_product = '18647' AND price != '9.917355'; UPDATE ps_product_shop SET price = '9.917355' WHERE id_product = '18647' AND price != '9.917355'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '18647' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '18647' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '18647' AND delivery_out_stock != 'En stock magasin'; UPDATE ps_product_shop SET available_date = '2026-01-09' WHERE id_product = '18647' AND available_date != '2026-01-09'; UPDATE ps_product SET available_date = '2026-01-09' WHERE id_product = '18647' AND available_date != '2026-01-09'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '18647' AND out_of_stock != '2'; UPDATE ps_product SET active = '1' WHERE id_product = '18647' AND active != '1'; UPDATE ps_product_shop SET active = '1' WHERE id_product = '18647' AND active != '1'; [PALMER958U] UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '7272' AND quantity != '1'; UPDATE ps_product SET price = '41.322314' WHERE id_product = '7272' AND price != '41.322314'; UPDATE ps_product_shop SET price = '41.322314' WHERE id_product = '7272' AND price != '41.322314'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '7272' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '7272' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '7272' AND delivery_out_stock != 'En stock internet'; UPDATE ps_product_shop SET available_date = '2026-01-05' WHERE id_product = '7272' AND available_date != '2026-01-05'; UPDATE ps_product SET available_date = '2026-01-05' WHERE id_product = '7272' AND available_date != '2026-01-05'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '7272' AND out_of_stock != '2'; UPDATE ps_product SET active = '1' WHERE id_product = '7272' AND active != '1'; UPDATE ps_product_shop SET active = '1' WHERE id_product = '7272' AND active != '1'; [BEYERD745U] UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '1838' AND quantity != '-1'; UPDATE ps_product SET price = '0' WHERE id_product = '1838' AND price != '0'; UPDATE ps_product_shop SET price = '0' WHERE id_product = '1838' AND price != '0'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '1838' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '1838' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = '' WHERE id_product = '1838' AND delivery_out_stock != ''; UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '1838' AND available_date != '1900-01-01'; UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '1838' AND available_date != '1900-01-01'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '1838' AND out_of_stock != '2'; UPDATE ps_product SET active = '0' WHERE id_product = '1838' AND active != '0'; UPDATE ps_product_shop SET active = '0' WHERE id_product = '1838' AND active != '0'; [GRAV982D3C] UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '18778' AND quantity != '1'; UPDATE ps_product SET price = '53.719008' WHERE id_product = '18778' AND price != '53.719008'; UPDATE ps_product_shop SET price = '53.719008' WHERE id_product = '18778' AND price != '53.719008'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '18778' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '18778' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '18778' AND delivery_out_stock != 'En stock internet'; UPDATE ps_product_shop SET available_date = '2026-01-05' WHERE id_product = '18778' AND available_date != '2026-01-05'; UPDATE ps_product SET available_date = '2026-01-05' WHERE id_product = '18778' AND available_date != '2026-01-05'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '18778' AND out_of_stock != '2'; UPDATE ps_product SET active = '1' WHERE id_product = '18778' AND active != '1'; UPDATE ps_product_shop SET active = '1' WHERE id_product = '18778' AND active != '1'; [PALMER112W] UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '7252' AND quantity != '1'; UPDATE ps_product SET price = '53.719008' WHERE id_product = '7252' AND price != '53.719008'; UPDATE ps_product_shop SET price = '53.719008' WHERE id_product = '7252' AND price != '53.719008'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '7252' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '7252' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '7252' AND delivery_out_stock != 'En stock internet'; UPDATE ps_product_shop SET available_date = '2026-01-05' WHERE id_product = '7252' AND available_date != '2026-01-05'; UPDATE ps_product SET available_date = '2026-01-05' WHERE id_product = '7252' AND available_date != '2026-01-05'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '7252' AND out_of_stock != '2'; UPDATE ps_product SET active = '1' WHERE id_product = '7252' AND active != '1'; UPDATE ps_product_shop SET active = '1' WHERE id_product = '7252' AND active != '1'; [CORDIA204O] UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '42396' AND quantity != '99'; UPDATE ps_product SET price = '16.528926' WHERE id_product = '42396' AND price != '16.528926'; UPDATE ps_product_shop SET price = '16.528926' WHERE id_product = '42396' AND price != '16.528926'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '42396' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '42396' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '42396' AND delivery_out_stock != 'En stock magasin'; UPDATE ps_product_shop SET available_date = '2026-01-09' WHERE id_product = '42396' AND available_date != '2026-01-09'; UPDATE ps_product SET available_date = '2026-01-09' WHERE id_product = '42396' AND available_date != '2026-01-09'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '42396' AND out_of_stock != '2'; UPDATE ps_product SET active = '1' WHERE id_product = '42396' AND active != '1'; UPDATE ps_product_shop SET active = '1' WHERE id_product = '42396' AND active != '1'; [BEYE14181A] UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '35218' AND quantity != '-1'; UPDATE ps_product SET price = '0' WHERE id_product = '35218' AND price != '0'; UPDATE ps_product_shop SET price = '0' WHERE id_product = '35218' AND price != '0'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '35218' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '35218' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = '' WHERE id_product = '35218' AND delivery_out_stock != ''; UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '35218' AND available_date != '1900-01-01'; UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '35218' AND available_date != '1900-01-01'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '35218' AND out_of_stock != '2'; UPDATE ps_product SET active = '0' WHERE id_product = '35218' AND active != '0'; UPDATE ps_product_shop SET active = '0' WHERE id_product = '35218' AND active != '0'; [BEYE9FCD24] UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '20943' AND quantity != '-1'; UPDATE ps_product SET price = '0' WHERE id_product = '20943' AND price != '0'; UPDATE ps_product_shop SET price = '0' WHERE id_product = '20943' AND price != '0'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '20943' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '20943' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = '' WHERE id_product = '20943' AND delivery_out_stock != ''; UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '20943' AND available_date != '1900-01-01'; UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '20943' AND available_date != '1900-01-01'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '20943' AND out_of_stock != '2'; UPDATE ps_product SET active = '0' WHERE id_product = '20943' AND active != '0'; UPDATE ps_product_shop SET active = '0' WHERE id_product = '20943' AND active != '0'; [BEYEFED427] UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '11573' AND quantity != '-1'; UPDATE ps_product SET price = '0' WHERE id_product = '11573' AND price != '0'; UPDATE ps_product_shop SET price = '0' WHERE id_product = '11573' AND price != '0'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '11573' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '11573' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = '' WHERE id_product = '11573' AND delivery_out_stock != ''; UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '11573' AND available_date != '1900-01-01'; UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '11573' AND available_date != '1900-01-01'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '11573' AND out_of_stock != '2'; UPDATE ps_product SET active = '0' WHERE id_product = '11573' AND active != '0'; UPDATE ps_product_shop SET active = '0' WHERE id_product = '11573' AND active != '0'; [BEYERD002P] UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '35219' AND quantity != '-1'; UPDATE ps_product SET price = '0' WHERE id_product = '35219' AND price != '0'; UPDATE ps_product_shop SET price = '0' WHERE id_product = '35219' AND price != '0'; UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '35219' AND id_tax_rules_group != '22'; UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '35219' AND id_tax_rules_group != '22'; UPDATE ps_product_lang SET delivery_out_stock = '' WHERE id_product = '35219' AND delivery_out_stock != ''; UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '35219' AND available_date != '1900-01-01'; UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '35219' AND available_date != '1900-01-01'; UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '35219' AND out_of_stock != '2'; UPDATE ps_product SET active = '0' WHERE id_product = '35219' AND active != '0'; UPDATE ps_product_shop SET active = '0' WHERE id_product = '35219' AND active != '0'; *** Fin des transactions SQL *** Produit(s) traité(s) : 10 Requête(s) envoyée(s) : 110 === Fin de FFWD ===