=== Début de M2M ===

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

PSIA3D6441 ↔ 35183		► Stock : -1		► Prix : 1260.330579	► Dictionnaire : OK
PSIACT826I ↔ 35188		► Stock : -1		► Prix : 1652.892562	► Dictionnaire : OK
PSIA8B994B ↔ 35186		► Stock : -1		► Prix : 1152.892562	► Dictionnaire : OK
PSIACT949B ↔ 35185		► Stock : -1		► Prix : 1235.53719		► Dictionnaire : OK

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

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

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

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

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

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

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

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

=== Fin de M2M ===