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

PRSSPRV20F ↔ 49631		► Stock : -1		► Prix : 1735.53719		► Dictionnaire : OK
PRSSSM4IYN ↔ 49637		► Stock : -1		► Prix : 2314.049587	► Dictionnaire : OK
PRSSQGY5J0 ↔ 49602		► Stock : -1		► Prix : 2380.165289	► Dictionnaire : OK
PRSSSUJ9F1 ↔ 49648		► Stock : -1		► Prix : 2033.057851	► Dictionnaire : OK
PRSSPREV69 ↔ 49600		► Stock : -1		► Prix : 2380.165289	► Dictionnaire : OK
PRSSRHVQ4B ↔ 49659		► Stock : -1		► Prix : 1776.859504	► Dictionnaire : OK
PRSSPI8J8T ↔ 49662		► Stock : -1		► Prix : 2132.231405	► Dictionnaire : OK
PRSSR8PFN6 ↔ 49640		► Stock : -1		► Prix : 2033.057851	► Dictionnaire : OK
PRSST4A4MY ↔ 49627		► Stock : -1		► Prix : 1884.297521	► Dictionnaire : OK

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

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

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

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

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

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

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

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

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

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

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

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

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

=== Fin de FFWD ===