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

GRETTSKXF0 ↔ 49583		► Stock : -1		► Prix : 3632.231405	► Dictionnaire : OK
IBANJONCKX ↔ 49811		► Stock : -1		► Prix : 0				► Dictionnaire : OK
PRSSLX3SS4 ↔ 49655		► Stock : -1		► Prix : 1776.859504	► Dictionnaire : OK
IBANNNWSRF ↔ 49808		► Stock : -1		► Prix : 1400.826446	► Dictionnaire : OK

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

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

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

[GRETTSKXF0]
UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '49583' AND quantity != '-1';
UPDATE ps_product SET price = '3632.231405' WHERE id_product = '49583' AND price != '3632.231405';
UPDATE ps_product_shop SET price = '3632.231405' WHERE id_product = '49583' AND price != '3632.231405';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '49583' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '49583' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'Appeler pour vérifier' WHERE id_product = '49583' AND delivery_out_stock != 'Appeler pour vérifier';
UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '49583' AND available_date != '1900-01-01';
UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '49583' AND available_date != '1900-01-01';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '49583' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '49583' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '49583' AND active != '1';

[IBANJONCKX]
UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '49811' AND quantity != '-1';
UPDATE ps_product SET price = '0' WHERE id_product = '49811' AND price != '0';
UPDATE ps_product_shop SET price = '0' WHERE id_product = '49811' AND price != '0';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '49811' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '49811' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'Appeler pour vérifier' WHERE id_product = '49811' AND delivery_out_stock != 'Appeler pour vérifier';
UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '49811' AND available_date != '1900-01-01';
UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '49811' AND available_date != '1900-01-01';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '49811' AND out_of_stock != '2';
UPDATE ps_product SET active = '0' WHERE id_product = '49811' AND active != '0';
UPDATE ps_product_shop SET active = '0' WHERE id_product = '49811' AND active != '0';

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

[IBANNNWSRF]
UPDATE ps_stock_available SET quantity = '-1' WHERE id_product = '49808' AND quantity != '-1';
UPDATE ps_product SET price = '1400.826446' WHERE id_product = '49808' AND price != '1400.826446';
UPDATE ps_product_shop SET price = '1400.826446' WHERE id_product = '49808' AND price != '1400.826446';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '49808' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '49808' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'Appeler pour vérifier' WHERE id_product = '49808' AND delivery_out_stock != 'Appeler pour vérifier';
UPDATE ps_product_shop SET available_date = '1900-01-01' WHERE id_product = '49808' AND available_date != '1900-01-01';
UPDATE ps_product SET available_date = '1900-01-01' WHERE id_product = '49808' AND available_date != '1900-01-01';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '49808' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '49808' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '49808' AND active != '1';

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

=== Fin de FFWD ===