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

PRSSDEHMTP ↔ 49621		► Stock : -1		► Prix : 1962.809917	► Dictionnaire : OK
PRSSF56GGA ↔ 49604		► Stock : -1		► Prix : 2380.165289	► Dictionnaire : OK
PRSSDFY1QO ↔ 49642		► Stock : -1		► Prix : 2066.115702	► Dictionnaire : OK
PRSSFKV80Y ↔ 49624		► Stock : -1		► Prix : 1735.53719		► Dictionnaire : OK
PRSSF560A1 ↔ 49645		► Stock : -1		► Prix : 2066.115702	► Dictionnaire : OK
PRSSD2R3LY ↔ 49612		► Stock : -1		► Prix : 2128.099174	► Dictionnaire : OK

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

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

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

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

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

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

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

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

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

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

=== Fin de FFWD ===