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

PRSSTZXLJ0 ↔ 49798		► Stock : -1		► Prix : 2479.338843	► Dictionnaire : OK
PRSSMGFCQH ↔ 49802		► Stock : -1		► Prix : 2876.033058	► Dictionnaire : OK
PRSNMOFWW3 ↔ 49795		► Stock : -1		► Prix : 2677.68595		► Dictionnaire : OK
PRSSJGSMDB ↔ 49804		► Stock : -1		► Prix : 2876.033058	► Dictionnaire : OK
PRSS3PXETH ↔ 49801		► Stock : -1		► Prix : 2876.033058	► Dictionnaire : OK
PRSSOJ3OC1 ↔ 49797		► Stock : -1		► Prix : 2706.61157		► Dictionnaire : OK
PRSNGTMKYK ↔ 49796		► Stock : -1		► Prix : 2677.68595		► Dictionnaire : OK
PRSS93ALF1 ↔ 49800		► Stock : -1		► Prix : 2880.165289	► Dictionnaire : OK

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

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

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

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

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

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

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

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

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

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

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

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

=== Fin de FFWD ===