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

GEWAHO014Q ↔ 30331		► Stock : 1			► Prix : 37.190083		► Dictionnaire : OK
REMOAM326B ↔ 2014		► Stock : 99		► Prix : 19.008264		► Dictionnaire : OK
REMOAM326D ↔ 2015		► Stock : 1			► Prix : 17.355372		► Dictionnaire : OK
REMOAM327N ↔ 2023		► Stock : 1			► Prix : 22.31405		► Dictionnaire : OK
REMOD6BI36 ↔ -----		► Pas trouvé		► Pas trouvé			► Pas trouvé
REMOPW336T ↔ 2545		► Stock : 1			► Prix : 56.198347		► Dictionnaire : OK
VICFIR654P ↔ 9137		► Stock : 99		► Prix : 12.396694		► Dictionnaire : OK
VICFIR701J ↔ 9129		► Stock : 99		► Prix : 12.396694		► Dictionnaire : OK

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

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

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

[GEWAHO014Q]
UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '30331' AND quantity != '1';
UPDATE ps_product SET price = '37.190083' WHERE id_product = '30331' AND price != '37.190083';
UPDATE ps_product_shop SET price = '37.190083' WHERE id_product = '30331' AND price != '37.190083';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '30331' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '30331' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '30331' AND delivery_out_stock != 'En stock internet';
UPDATE ps_product_shop SET available_date = '2026-10-05' WHERE id_product = '30331' AND available_date != '2026-10-05';
UPDATE ps_product SET available_date = '2026-10-05' WHERE id_product = '30331' AND available_date != '2026-10-05';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '30331' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '30331' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '30331' AND active != '1';

[REMOAM326B]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '2014' AND quantity != '99';
UPDATE ps_product SET price = '19.008264' WHERE id_product = '2014' AND price != '19.008264';
UPDATE ps_product_shop SET price = '19.008264' WHERE id_product = '2014' AND price != '19.008264';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '2014' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '2014' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '2014' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-10-08' WHERE id_product = '2014' AND available_date != '2026-10-08';
UPDATE ps_product SET available_date = '2026-10-08' WHERE id_product = '2014' AND available_date != '2026-10-08';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '2014' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '2014' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '2014' AND active != '1';

[REMOAM326D]
UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '2015' AND quantity != '1';
UPDATE ps_product SET price = '17.355372' WHERE id_product = '2015' AND price != '17.355372';
UPDATE ps_product_shop SET price = '17.355372' WHERE id_product = '2015' AND price != '17.355372';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '2015' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '2015' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '2015' AND delivery_out_stock != 'En stock internet';
UPDATE ps_product_shop SET available_date = '2026-10-02' WHERE id_product = '2015' AND available_date != '2026-10-02';
UPDATE ps_product SET available_date = '2026-10-02' WHERE id_product = '2015' AND available_date != '2026-10-02';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '2015' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '2015' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '2015' AND active != '1';

[REMOAM327N]
UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '2023' AND quantity != '1';
UPDATE ps_product SET price = '22.31405' WHERE id_product = '2023' AND price != '22.31405';
UPDATE ps_product_shop SET price = '22.31405' WHERE id_product = '2023' AND price != '22.31405';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '2023' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '2023' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '2023' AND delivery_out_stock != 'En stock internet';
UPDATE ps_product_shop SET available_date = '2026-10-02' WHERE id_product = '2023' AND available_date != '2026-10-02';
UPDATE ps_product SET available_date = '2026-10-02' WHERE id_product = '2023' AND available_date != '2026-10-02';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '2023' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '2023' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '2023' AND active != '1';

[REMOPW336T]
UPDATE ps_stock_available SET quantity = '1' WHERE id_product = '2545' AND quantity != '1';
UPDATE ps_product SET price = '56.198347' WHERE id_product = '2545' AND price != '56.198347';
UPDATE ps_product_shop SET price = '56.198347' WHERE id_product = '2545' AND price != '56.198347';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '2545' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '2545' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock internet' WHERE id_product = '2545' AND delivery_out_stock != 'En stock internet';
UPDATE ps_product_shop SET available_date = '2026-10-02' WHERE id_product = '2545' AND available_date != '2026-10-02';
UPDATE ps_product SET available_date = '2026-10-02' WHERE id_product = '2545' AND available_date != '2026-10-02';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '2545' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '2545' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '2545' AND active != '1';

[VICFIR654P]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '9137' AND quantity != '99';
UPDATE ps_product SET price = '12.396694' WHERE id_product = '9137' AND price != '12.396694';
UPDATE ps_product_shop SET price = '12.396694' WHERE id_product = '9137' AND price != '12.396694';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '9137' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '9137' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '9137' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-10-08' WHERE id_product = '9137' AND available_date != '2026-10-08';
UPDATE ps_product SET available_date = '2026-10-08' WHERE id_product = '9137' AND available_date != '2026-10-08';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '9137' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '9137' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '9137' AND active != '1';

[VICFIR701J]
UPDATE ps_stock_available SET quantity = '99' WHERE id_product = '9129' AND quantity != '99';
UPDATE ps_product SET price = '12.396694' WHERE id_product = '9129' AND price != '12.396694';
UPDATE ps_product_shop SET price = '12.396694' WHERE id_product = '9129' AND price != '12.396694';
UPDATE ps_product SET id_tax_rules_group = '22' WHERE id_product = '9129' AND id_tax_rules_group != '22';
UPDATE ps_product_shop SET id_tax_rules_group = '22' WHERE id_product = '9129' AND id_tax_rules_group != '22';
UPDATE ps_product_lang SET delivery_out_stock = 'En stock magasin' WHERE id_product = '9129' AND delivery_out_stock != 'En stock magasin';
UPDATE ps_product_shop SET available_date = '2026-10-08' WHERE id_product = '9129' AND available_date != '2026-10-08';
UPDATE ps_product SET available_date = '2026-10-08' WHERE id_product = '9129' AND available_date != '2026-10-08';
UPDATE ps_stock_available SET out_of_stock = '2' WHERE id_product = '9129' AND out_of_stock != '2';
UPDATE ps_product SET active = '1' WHERE id_product = '9129' AND active != '1';
UPDATE ps_product_shop SET active = '1' WHERE id_product = '9129' AND active != '1';

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

=== Fin de FFWD ===