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

PRSCP4MNCO ↔ 49788		► Stock : -1		► Prix : 2768.595041	► Dictionnaire : OK
PRSNLK92WA ↔ 49793		► Stock : -1		► Prix : 2677.68595		► Dictionnaire : OK
PRSCJYG7SF ↔ 49787		► Stock : -1		► Prix : 2727.272727	► Dictionnaire : OK
PRSNK7359A ↔ 49792		► Stock : -1		► Prix : 2677.68595		► Dictionnaire : OK
PRSC8G99RE ↔ 49786		► Stock : -1		► Prix : 2727.272727	► Dictionnaire : OK
PRSNIF24H0 ↔ 49790		► Stock : -1		► Prix : 2702.479339	► Dictionnaire : OK
PRSN332609 ↔ 49794		► Stock : -1		► Prix : 2677.68595		► Dictionnaire : OK
PRSNR5BNHG ↔ 49791		► Stock : -1		► Prix : 2677.68595		► Dictionnaire : OK

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

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

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

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

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

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

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

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

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

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

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

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

=== Fin de FFWD ===