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

PRSSVGCP5K ↔ 49622		► Stock : -1		► Prix : 1884.297521	► Dictionnaire : OK
PRSSY3TBF2 ↔ 49650		► Stock : -1		► Prix : 2033.057851	► Dictionnaire : OK
PRSSTBA1OH ↔ 49605		► Stock : -1		► Prix : 2132.231405	► Dictionnaire : OK
PRSSX30KPB ↔ 49608		► Stock : -1		► Prix : 2132.231405	► Dictionnaire : OK
PRSSTOF3JI ↔ 49599		► Stock : -1		► Prix : 2280.991736	► Dictionnaire : OK
PRSSXLM63S ↔ 49613		► Stock : -1		► Prix : 2132.231405	► Dictionnaire : OK
PRSST68GWD ↔ 49661		► Stock : -1		► Prix : 2132.231405	► Dictionnaire : OK
PRSSVJBD1M ↔ 49619		► Stock : -1		► Prix : 2586.77686		► Dictionnaire : OK
PRSSYQ5FXA ↔ 49649		► Stock : -1		► Prix : 2033.057851	► Dictionnaire : OK

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

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

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

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

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

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

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

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

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

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

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

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

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

=== Fin de FFWD ===