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

YAMA1T64FW ↔ 50571		► Stock : -1		► Prix : 0				► Dictionnaire : OK
YAMABBQ1B9 ↔ 50572		► Stock : -1		► Prix : 0				► Dictionnaire : OK
YAMAG5G1UH ↔ 50570		► Stock : -1		► Prix : 0				► Dictionnaire : OK
YAMAL22AZU ↔ 50568		► Stock : -1		► Prix : 0				► Dictionnaire : OK
YAMAMRX3E7 ↔ 50566		► Stock : -1		► Prix : 0				► Dictionnaire : OK
YAMAN8AJ2V ↔ 50565		► Stock : -1		► Prix : 603.305785		► Dictionnaire : OK
YAMAQ7MCP2 ↔ 50569		► Stock : -1		► Prix : 603.305785		► Dictionnaire : OK
YAMAV7G4CP ↔ 50567		► Stock : -1		► Prix : 0				► Dictionnaire : OK

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

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

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

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

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

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

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

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

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

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

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

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

=== Fin de FFWD ===