10/03/2023 08:31:20 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 10/03/2023 08:31:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20807' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 08:31:20 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20807' , '1' , '1' , '2' , NOW() , NOW() ) 10/03/2023 08:31:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20807' , '0' , '1' , '0' , '0' ) 10/03/2023 08:32:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801067989' AND id_product != '20807' AND ean13 != '' 10/03/2023 08:32:05 am >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9788801067989', date_upd = NOW() WHERE id_product = '20807' 10/03/2023 08:32:05 am >> UPDATE ps_product_lang SET name = 'MESSA CENA DEL SIGNORE', description = '' WHERE id_product = '20807' 10/03/2023 08:32:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '20807' 10/03/2023 08:32:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20807' 10/03/2023 08:32:05 am >> DELETE FROM ps_specific_price WHERE id_product = '20807' 10/03/2023 08:32:07 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20807' 10/03/2023 08:32:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20808' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 08:32:07 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20808' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20807' 10/03/2023 08:32:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20808' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20807' 10/03/2023 08:33:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259752253' AND id_product != '20808' AND ean13 != '' 10/03/2023 08:33:28 am >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9791259752253', date_upd = NOW() WHERE id_product = '20808' 10/03/2023 08:33:28 am >> UPDATE ps_product_lang SET name = 'CRISTIANESIMO RISORSA PER LA SOCIETA\' - AAVV', description = '' WHERE id_product = '20808' 10/03/2023 08:33:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '20808' 10/03/2023 08:33:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20808' 10/03/2023 08:33:28 am >> DELETE FROM ps_specific_price WHERE id_product = '20808' 10/03/2023 08:33:29 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20808' 10/03/2023 08:33:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20809' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 08:33:29 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20809' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20808' 10/03/2023 08:33:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20809' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20808' 10/03/2023 08:34:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068252' AND id_product != '20809' AND ean13 != '' 10/03/2023 08:34:12 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 2', ean13 = '9788801068252', date_upd = NOW() WHERE id_product = '20809' 10/03/2023 08:34:12 am >> UPDATE ps_product_lang SET name = 'PAROLE RITROVATE - G. ZURRA', description = '' WHERE id_product = '20809' 10/03/2023 08:34:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20809' 10/03/2023 08:34:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20809' 10/03/2023 08:34:12 am >> DELETE FROM ps_specific_price WHERE id_product = '20809' 10/03/2023 08:34:14 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20809' 10/03/2023 08:34:14 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20810' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 08:34:14 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20810' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20809' 10/03/2023 08:34:14 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20810' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20809' 10/03/2023 08:35:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851426590' AND id_product != '20810' AND ean13 != '' 10/03/2023 08:35:33 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788851426590', date_upd = NOW() WHERE id_product = '20810' 10/03/2023 08:35:33 am >> UPDATE ps_product_lang SET name = 'SAPIENZA DEL VANGELO - F. BERSINI', description = '' WHERE id_product = '20810' 10/03/2023 08:35:33 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '23' WHERE id_product = '20810' 10/03/2023 08:35:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '23', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20810' 10/03/2023 08:35:33 am >> DELETE FROM ps_specific_price WHERE id_product = '20810' 10/03/2023 08:35:35 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20810' 10/03/2023 08:35:35 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20811' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 08:35:35 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20811' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20810' 10/03/2023 08:35:35 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20811' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20810' 10/03/2023 08:36:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851426507' AND id_product != '20811' AND ean13 != '' 10/03/2023 08:36:20 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788851426507', date_upd = NOW() WHERE id_product = '20811' 10/03/2023 08:36:20 am >> UPDATE ps_product_lang SET name = 'TESTIMONI SENZA VOCE - E. RICCO', description = '' WHERE id_product = '20811' 10/03/2023 08:36:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '20811' 10/03/2023 08:36:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20811' 10/03/2023 08:36:20 am >> DELETE FROM ps_specific_price WHERE id_product = '20811' 10/03/2023 08:36:21 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20811' 10/03/2023 08:36:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20812' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 08:36:21 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20812' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20811' 10/03/2023 08:36:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20812' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20811' 10/03/2023 08:37:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892241138' AND id_product != '20812' AND ean13 != '' 10/03/2023 08:37:21 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788892241138', date_upd = NOW() WHERE id_product = '20812' 10/03/2023 08:37:21 am >> UPDATE ps_product_lang SET name = 'ULTIME PAROLE DI GESU\' - A. COMASTRI', description = '' WHERE id_product = '20812' 10/03/2023 08:37:21 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28' WHERE id_product = '20812' 10/03/2023 08:37:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20812' 10/03/2023 08:37:21 am >> DELETE FROM ps_specific_price WHERE id_product = '20812' 10/03/2023 08:37:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892241138' AND id_product != '20812' AND ean13 != '' 10/03/2023 08:37:27 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788892241138', date_upd = NOW() WHERE id_product = '20812' 10/03/2023 08:37:27 am >> UPDATE ps_product_lang SET name = 'ULTIME PAROLE DI GESU\' - A. COMASTRI', description = '' WHERE id_product = '20812' 10/03/2023 08:37:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28' WHERE id_product = '20812' 10/03/2023 08:37:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20812' 10/03/2023 08:37:27 am >> DELETE FROM ps_specific_price WHERE id_product = '20812' 10/03/2023 08:37:28 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20812' 10/03/2023 08:37:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20813' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 08:37:28 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20813' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20812' 10/03/2023 08:37:28 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20813' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20812' 10/03/2023 08:38:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892241084' AND id_product != '20813' AND ean13 != '' 10/03/2023 08:38:25 am >> UPDATE ps_product SET id_supplier = '', reference = '13/7', ean13 = '9788892241084', date_upd = NOW() WHERE id_product = '20813' 10/03/2023 08:38:25 am >> UPDATE ps_product_lang SET name = 'PASSIAMO ALL\'ALTRA RIVA - F. BUSTILLO', description = '' WHERE id_product = '20813' 10/03/2023 08:38:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20813' 10/03/2023 08:38:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '36', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20813' 10/03/2023 08:38:25 am >> DELETE FROM ps_specific_price WHERE id_product = '20813' 10/03/2023 08:38:26 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20813' 10/03/2023 08:38:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20814' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 08:38:26 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20814' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20813' 10/03/2023 08:38:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20814' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20813' 10/03/2023 08:39:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892241275' AND id_product != '20814' AND ean13 != '' 10/03/2023 08:39:06 am >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9788892241275', date_upd = NOW() WHERE id_product = '20814' 10/03/2023 08:39:06 am >> UPDATE ps_product_lang SET name = 'DESIDERIO - A. DEHO', description = '' WHERE id_product = '20814' 10/03/2023 08:39:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20814' 10/03/2023 08:39:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20814' 10/03/2023 08:39:06 am >> DELETE FROM ps_specific_price WHERE id_product = '20814' 10/03/2023 08:39:07 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20814' 10/03/2023 08:39:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20815' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 08:39:07 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20815' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20814' 10/03/2023 08:39:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20815' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20814' 10/03/2023 08:40:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870482' AND id_product != '20815' AND ean13 != '' 10/03/2023 08:40:02 am >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9788892870482', date_upd = NOW() WHERE id_product = '20815' 10/03/2023 08:40:02 am >> UPDATE ps_product_lang SET name = 'FRATE FRANCESCO - R. MURANO', description = '' WHERE id_product = '20815' 10/03/2023 08:40:02 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '20815' 10/03/2023 08:40:02 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20815' 10/03/2023 08:40:02 am >> DELETE FROM ps_specific_price WHERE id_product = '20815' 10/03/2023 08:40:04 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20815' 10/03/2023 08:40:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20816' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 08:40:04 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20816' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20815' 10/03/2023 08:40:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20816' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20815' 10/03/2023 08:41:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825055764' AND id_product != '20816' AND ean13 != '' 10/03/2023 08:41:12 am >> UPDATE ps_product SET id_supplier = '', reference = '7.6', ean13 = '9788825055764', date_upd = NOW() WHERE id_product = '20816' 10/03/2023 08:41:12 am >> UPDATE ps_product_lang SET name = 'FRANCESCANESIMO DI UN PAPA GESUITA - M. SEMERARO', description = '' WHERE id_product = '20816' 10/03/2023 08:41:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '20816' 10/03/2023 08:41:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20816' 10/03/2023 08:41:12 am >> DELETE FROM ps_specific_price WHERE id_product = '20816' 10/03/2023 08:41:20 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20816' 10/03/2023 08:41:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20817' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 08:41:20 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20817' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20816' 10/03/2023 08:41:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20817' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20816' 10/03/2023 08:42:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884247797' AND id_product != '20817' AND ean13 != '' 10/03/2023 08:42:26 am >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9788884247797', date_upd = NOW() WHERE id_product = '20817' 10/03/2023 08:42:26 am >> UPDATE ps_product_lang SET name = 'FACCIA A FACCIA CON GESU\' - D. RUOTOLO', description = '' WHERE id_product = '20817' 10/03/2023 08:42:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20817' 10/03/2023 08:42:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20817' 10/03/2023 08:42:26 am >> DELETE FROM ps_specific_price WHERE id_product = '20817' 10/03/2023 08:42:27 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20817' 10/03/2023 08:42:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20818' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 08:42:27 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20818' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20817' 10/03/2023 08:42:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20818' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20817' 10/03/2023 08:43:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068320' AND id_product != '20818' AND ean13 != '' 10/03/2023 08:43:32 am >> UPDATE ps_product SET id_supplier = '', reference = '1/1', ean13 = '9788801068320', date_upd = NOW() WHERE id_product = '20818' 10/03/2023 08:43:32 am >> UPDATE ps_product_lang SET name = 'VERITA\' CHE SALVA - C.L. ROSSETTI', description = '' WHERE id_product = '20818' 10/03/2023 08:43:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.5' WHERE id_product = '20818' 10/03/2023 08:43:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.5', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20818' 10/03/2023 08:43:32 am >> DELETE FROM ps_specific_price WHERE id_product = '20818' 10/03/2023 08:43:33 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20818' 10/03/2023 08:43:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20819' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 08:43:33 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20819' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20818' 10/03/2023 08:43:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20819' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20818' 10/03/2023 08:44:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831278782' AND id_product != '20819' AND ean13 != '' 10/03/2023 08:44:28 am >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9788831278782', date_upd = NOW() WHERE id_product = '20819' 10/03/2023 08:44:28 am >> UPDATE ps_product_lang SET name = 'PREGARE ALLA SCUOLA DI GRANDI MAESTRI - E. BOLIS', description = '' WHERE id_product = '20819' 10/03/2023 08:44:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '20819' 10/03/2023 08:44:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '97', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20819' 10/03/2023 08:44:29 am >> DELETE FROM ps_specific_price WHERE id_product = '20819' 10/03/2023 08:44:29 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20819' 10/03/2023 08:44:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20820' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 08:44:29 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20820' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20819' 10/03/2023 08:44:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20820' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20819' 10/03/2023 08:45:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892241404' AND id_product != '20820' AND ean13 != '' 10/03/2023 08:45:20 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 2', ean13 = '9788892241404', date_upd = NOW() WHERE id_product = '20820' 10/03/2023 08:45:20 am >> UPDATE ps_product_lang SET name = 'CUORE CI PARLA DI DIO - PAPA FRANCESCO', description = '' WHERE id_product = '20820' 10/03/2023 08:45:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '20820' 10/03/2023 08:45:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20820' 10/03/2023 08:45:20 am >> DELETE FROM ps_specific_price WHERE id_product = '20820' 10/03/2023 08:45:21 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20820' 10/03/2023 08:45:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20821' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 08:45:21 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20821' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20820' 10/03/2023 08:45:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20821' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20820' 10/03/2023 08:45:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '625116' , '2023-03-07' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.69' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '163.47' , '163.47' , NOW() , NOW() ) 10/03/2023 08:45:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82228' 10/03/2023 08:45:46 am >> DELETE FROM ps_document_detail WHERE id_document = '82228' 10/03/2023 08:45:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82228' , '20807' , 'MESSA CENA DEL SIGNORE' , '1' , '1' , '4' , '9.00' , '9' , '0' , '35' , '5.8500' ) 10/03/2023 08:45:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20807' AND id_supplier = '7' 10/03/2023 08:45:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20807' , '7' , '1' ) 10/03/2023 08:45:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82228' , '20808' , 'CRISTIANESIMO RISORSA PER LA SOCIETA - AAVV' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 10/03/2023 08:45:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20808' AND id_supplier = '7' 10/03/2023 08:45:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20808' , '7' , '1' ) 10/03/2023 08:45:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82228' , '20809' , 'PAROLE RITROVATE - G. ZURRA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 10/03/2023 08:45:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20809' AND id_supplier = '7' 10/03/2023 08:45:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20809' , '7' , '1' ) 10/03/2023 08:45:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82228' , '20810' , 'SAPIENZA DEL VANGELO - F. BERSINI' , '1' , '1' , '4' , '23.00' , '23' , '0' , '33' , '15.4100' ) 10/03/2023 08:45:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20810' AND id_supplier = '7' 10/03/2023 08:45:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20810' , '7' , '1' ) 10/03/2023 08:45:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82228' , '20811' , 'TESTIMONI SENZA VOCE - E. RICCO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 10/03/2023 08:45:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20811' AND id_supplier = '7' 10/03/2023 08:45:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20811' , '7' , '1' ) 10/03/2023 08:45:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82228' , '20812' , 'ULTIME PAROLE DI GESU - A. COMASTRI' , '1' , '1' , '4' , '28.00' , '28' , '0' , '33' , '18.7600' ) 10/03/2023 08:45:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20812' AND id_supplier = '7' 10/03/2023 08:45:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20812' , '7' , '1' ) 10/03/2023 08:45:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82228' , '20813' , 'PASSIAMO ALLALTRA RIVA - F. BUSTILLO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 10/03/2023 08:45:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20813' AND id_supplier = '7' 10/03/2023 08:45:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20813' , '7' , '1' ) 10/03/2023 08:45:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82228' , '20814' , 'DESIDERIO - A. DEHO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '33' , '6.7000' ) 10/03/2023 08:45:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20814' AND id_supplier = '7' 10/03/2023 08:45:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20814' , '7' , '1' ) 10/03/2023 08:45:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82228' , '20815' , 'FRATE FRANCESCO - R. MURANO' , '1' , '1' , '4' , '19.00' , '19' , '0' , '30' , '13.3000' ) 10/03/2023 08:45:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20815' AND id_supplier = '7' 10/03/2023 08:45:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20815' , '7' , '1' ) 10/03/2023 08:45:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82228' , '20816' , 'FRANCESCANESIMO DI UN PAPA GESUITA - M. SEMERARO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 10/03/2023 08:45:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20816' AND id_supplier = '7' 10/03/2023 08:45:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20816' , '7' , '1' ) 10/03/2023 08:45:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82228' , '20817' , 'FACCIA A FACCIA CON GESU - D. RUOTOLO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 10/03/2023 08:45:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '20817' AND id_supplier = '7' 10/03/2023 08:45:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20817' , '7' , '1' ) 10/03/2023 08:45:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82228' , '20818' , 'VERITA CHE SALVA - C.L. ROSSETTI' , '3' , '3' , '4' , '4.50' , '4.5' , '0' , '35' , '8.7750' ) 10/03/2023 08:45:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '20818' AND id_supplier = '7' 10/03/2023 08:45:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20818' , '7' , '1' ) 10/03/2023 08:45:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82228' , '20819' , 'PREGARE ALLA SCUOLA DI GRANDI MAESTRI - E. BOLIS' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 10/03/2023 08:45:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '20819' AND id_supplier = '7' 10/03/2023 08:45:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20819' , '7' , '1' ) 10/03/2023 08:45:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82228' , '20820' , 'CUORE CI PARLA DI DIO - PAPA FRANCESCO' , '2' , '2' , '4' , '17.00' , '17' , '0' , '33' , '22.7800' ) 10/03/2023 08:45:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '20820' AND id_supplier = '7' 10/03/2023 08:45:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20820' , '7' , '1' ) 10/03/2023 09:17:10 am >> SELECT document_num FROM ps_document WHERE document_num = '46' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 09:17:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '46' , '2023-03-10' , '' , '3496' , '0' , '4670853' , 'VIALE GIOVANNI XXIII 4 23808 VERCURAGO' , '' , 'SCONTO AUTORE' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '35.00' , '35.00' , NOW() , NOW() ) 10/03/2023 09:17:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82229' 10/03/2023 09:17:10 am >> DELETE FROM ps_document_detail WHERE id_document = '82229' 10/03/2023 09:17:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82229' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '50' , '-50' , '4' , '1.00' , '1' , '0' , '30' , '35.00' ) 10/03/2023 09:50:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '30-628' AND id_product != '18168' AND ean13 != '' 10/03/2023 09:50:42 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '30-628', date_upd = NOW() WHERE id_product = '18168' 10/03/2023 09:50:42 am >> UPDATE ps_product_lang SET name = 'SCATOLA PORTAOSTIE ', description = '' WHERE id_product = '18168' 10/03/2023 09:50:42 am >> UPDATE ps_product SET wholesale_price = '14.44', on_sale = '0', price = '32.78688524590164' WHERE id_product = '18168' 10/03/2023 09:50:42 am >> UPDATE ps_product_shop SET wholesale_price = '14.44', price = '32.78688524590164', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18168' 10/03/2023 09:50:42 am >> DELETE FROM ps_specific_price WHERE id_product = '18168' 10/03/2023 09:57:05 am >> SELECT document_num FROM ps_document WHERE document_num = '787' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 09:57:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '787' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.20' , '2.20' , NOW() , NOW() ) 10/03/2023 09:57:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82230' 10/03/2023 09:57:05 am >> DELETE FROM ps_document_detail WHERE id_document = '82230' 10/03/2023 09:57:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82230' , '6004' , 'LUMEN FIDEI ' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 10/03/2023 10:07:05 am >> SELECT document_num FROM ps_document WHERE document_num = '788' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 10:07:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '788' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.80' , NOW() , NOW() ) 10/03/2023 10:07:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82231' 10/03/2023 10:07:05 am >> DELETE FROM ps_document_detail WHERE id_document = '82231' 10/03/2023 10:07:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82231' , '13830' , 'VANGELO E ATTI - ECOPELLE BIANCA - 8592' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 10/03/2023 10:13:05 am >> SELECT document_num FROM ps_document WHERE document_num = '789' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 10:13:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '789' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '10.27' , NOW() , NOW() ) 10/03/2023 10:13:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82232' 10/03/2023 10:13:05 am >> DELETE FROM ps_document_detail WHERE id_document = '82232' 10/03/2023 10:13:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82232' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 10/03/2023 10:13:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82232' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 10/03/2023 10:13:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82232' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '2.3' , '2.3' , '0' , '0' , '4.60' ) 10/03/2023 10:41:08 am >> SELECT document_num FROM ps_document WHERE document_num = '790' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 10:41:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '790' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '146.00' , '119.67' , NOW() , NOW() ) 10/03/2023 10:41:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82233' 10/03/2023 10:41:08 am >> DELETE FROM ps_document_detail WHERE id_document = '82233' 10/03/2023 10:41:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82233' , '1041' , 'BENEDIZIONI' , '300' , '-300' , '1' , '0.12' , '0.098360655737705' , '22' , '0' , '36.00' ) 10/03/2023 10:41:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82233' , '13078' , 'LEGGIO IN LEGNO - 043' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 10/03/2023 10:45:31 am >> DELETE FROM ps_document WHERE id_document = '82127' 10/03/2023 10:45:31 am >> DELETE FROM ps_document_detail WHERE id_document = '82127' 10/03/2023 10:59:40 am >> SELECT document_num FROM ps_document WHERE document_num = '791' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 10:59:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '791' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '148.00' , '125.75' , NOW() , NOW() ) 10/03/2023 10:59:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82234' 10/03/2023 10:59:40 am >> DELETE FROM ps_document_detail WHERE id_document = '82234' 10/03/2023 10:59:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82234' , '20524' , 'CROCE SAN BENEDETTO SMALTATA - CZ4NIK' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 10/03/2023 10:59:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82234' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 10/03/2023 10:59:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82234' , '18748' , 'OSTIA MAGNA 125mm' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 10/03/2023 10:59:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82234' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '20' , '16.393442622951' , '22' , '0' , '100.00' ) 10/03/2023 10:59:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82234' , '10430' , 'TABOR' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '0' , '17.90' ) 10/03/2023 10:59:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82234' , '4954' , 'MIRACOLOSA BABY - 023 MIR/9BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 10/03/2023 10:59:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82234' , '740' , 'ARC. RAFFAELE BABY 023 AR/R 9 BB' , '1' , '-1' , '1' , '7.7' , '6.3114754098361' , '22' , '0' , '7.70' ) 10/03/2023 11:03:01 am >> SELECT document_num FROM ps_document WHERE document_num = '792' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 11:03:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '792' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.06' , '16.06' , NOW() , NOW() ) 10/03/2023 11:03:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82235' 10/03/2023 11:03:01 am >> DELETE FROM ps_document_detail WHERE id_document = '82235' 10/03/2023 11:03:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82235' , '20794' , 'CERCA IL TUO ORIZZONTE ' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 10/03/2023 11:15:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228993' AND id_product != '19616' AND ean13 != '' 10/03/2023 11:15:26 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/5', ean13 = '9788892228993', date_upd = NOW() WHERE id_product = '19616' 10/03/2023 11:15:26 am >> UPDATE ps_product_lang SET name = 'VENTO DI DIO - G. CAROZZA', description = '' WHERE id_product = '19616' 10/03/2023 11:15:26 am >> UPDATE ps_product SET wholesale_price = '8.38', on_sale = '0', price = '12.5000' WHERE id_product = '19616' 10/03/2023 11:15:26 am >> UPDATE ps_product_shop SET wholesale_price = '8.38', price = '12.5000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19616' 10/03/2023 11:15:26 am >> DELETE FROM ps_specific_price WHERE id_product = '19616' 10/03/2023 11:17:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892219984' AND id_product != '20424' AND ean13 != '' 10/03/2023 11:17:26 am >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788892219984', date_upd = NOW() WHERE id_product = '20424' 10/03/2023 11:17:26 am >> UPDATE ps_product_lang SET name = 'ABBI CURA DI ME - S. CRISTICCHI', description = '' WHERE id_product = '20424' 10/03/2023 11:17:26 am >> UPDATE ps_product SET wholesale_price = '12.06', on_sale = '0', price = '18.0000' WHERE id_product = '20424' 10/03/2023 11:17:26 am >> UPDATE ps_product_shop SET wholesale_price = '12.06', price = '18.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20424' 10/03/2023 11:17:26 am >> DELETE FROM ps_specific_price WHERE id_product = '20424' 10/03/2023 11:42:52 am >> SELECT document_num FROM ps_document WHERE document_num = '47' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 11:42:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '47' , '2023-03-10' , '' , '3748' , '0' , '4671616' , 'P. ZZA GIOVANNI PAOLO II 84090 MONTECORVINO PUGLIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '129.20' , '129.20' , NOW() , NOW() ) 10/03/2023 11:42:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82236' 10/03/2023 11:42:52 am >> DELETE FROM ps_document_detail WHERE id_document = '82236' 10/03/2023 11:42:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82236' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '80' , '-80' , '4' , '1.90' , '1.9' , '0' , '15' , '129.20' ) 10/03/2023 11:50:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '12-228' AND id_product != '20821' AND ean13 != '' 10/03/2023 11:50:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-228', date_upd = NOW() WHERE id_product = '20821' 10/03/2023 11:50:08 am >> UPDATE ps_product_lang SET name = 'PORTACANDELA CM 9,5', description = '' WHERE id_product = '20821' 10/03/2023 11:50:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17.5' WHERE id_product = '20821' 10/03/2023 11:50:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17.5', id_tax_rules_group = '0', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20821' 10/03/2023 11:50:08 am >> DELETE FROM ps_specific_price WHERE id_product = '20821' 10/03/2023 11:50:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '12-228' AND id_product != '20821' AND ean13 != '' 10/03/2023 11:50:39 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-228', date_upd = NOW() WHERE id_product = '20821' 10/03/2023 11:50:39 am >> UPDATE ps_product_lang SET name = 'PORTACANDELA CM 9,5', description = '' WHERE id_product = '20821' 10/03/2023 11:50:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.344262295081968' WHERE id_product = '20821' 10/03/2023 11:50:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.344262295081968', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20821' 10/03/2023 11:50:39 am >> DELETE FROM ps_specific_price WHERE id_product = '20821' 10/03/2023 11:50:40 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20821' 10/03/2023 11:50:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20822' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 11:50:40 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20822' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20821' 10/03/2023 11:50:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20822' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20821' 10/03/2023 11:52:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '12-371/A' AND id_product != '20822' AND ean13 != '' 10/03/2023 11:52:21 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-371/A', date_upd = NOW() WHERE id_product = '20822' 10/03/2023 11:52:21 am >> UPDATE ps_product_lang SET name = 'PORTACANDELA CM 11', description = '' WHERE id_product = '20822' 10/03/2023 11:52:21 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.934426229508198' WHERE id_product = '20822' 10/03/2023 11:52:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.934426229508198', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20822' 10/03/2023 11:52:21 am >> DELETE FROM ps_specific_price WHERE id_product = '20822' 10/03/2023 11:52:23 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20822' 10/03/2023 11:52:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20823' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 11:52:23 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20823' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20822' 10/03/2023 11:52:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20823' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20822' 10/03/2023 11:52:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '12-371' AND id_product != '20822' AND ean13 != '' 10/03/2023 11:52:54 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-371', date_upd = NOW() WHERE id_product = '20822' 10/03/2023 11:52:54 am >> UPDATE ps_product_lang SET name = 'PORTACANDELA CM 11 -12-371/A', description = '' WHERE id_product = '20822' 10/03/2023 11:52:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.9344' WHERE id_product = '20822' 10/03/2023 11:52:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.9344', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20822' 10/03/2023 11:52:54 am >> DELETE FROM ps_specific_price WHERE id_product = '20822' 10/03/2023 11:54:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '12-739' AND id_product != '18022' AND ean13 != '' 10/03/2023 11:54:37 am >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '12-739', date_upd = NOW() WHERE id_product = '18022' 10/03/2023 11:54:37 am >> UPDATE ps_product_lang SET name = 'TURIBOLO H 24', description = '' WHERE id_product = '18022' 10/03/2023 11:54:37 am >> UPDATE ps_product SET wholesale_price = '51.84', on_sale = '0', price = '127.04918032786885' WHERE id_product = '18022' 10/03/2023 11:54:37 am >> UPDATE ps_product_shop SET wholesale_price = '51.84', price = '127.04918032786885', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18022' 10/03/2023 11:54:37 am >> DELETE FROM ps_specific_price WHERE id_product = '18022' 10/03/2023 11:55:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '12-100' AND id_product != '12613' AND ean13 != '' 10/03/2023 11:55:17 am >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '12-100', date_upd = NOW() WHERE id_product = '12613' 10/03/2023 11:55:17 am >> UPDATE ps_product_lang SET name = 'TURIBOLO 10 CM', description = '' WHERE id_product = '12613' 10/03/2023 11:55:17 am >> UPDATE ps_product SET wholesale_price = '4.66', on_sale = '0', price = '12.295081967213115' WHERE id_product = '12613' 10/03/2023 11:55:17 am >> UPDATE ps_product_shop SET wholesale_price = '4.66', price = '12.295081967213115', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12613' 10/03/2023 11:55:17 am >> DELETE FROM ps_specific_price WHERE id_product = '12613' 10/03/2023 11:57:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '12-246' AND id_product != '20823' AND ean13 != '' 10/03/2023 11:57:12 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-246', date_upd = NOW() WHERE id_product = '20823' 10/03/2023 11:57:12 am >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO CM 9', description = '' WHERE id_product = '20823' 10/03/2023 11:57:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.852459016393443' WHERE id_product = '20823' 10/03/2023 11:57:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.852459016393443', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20823' 10/03/2023 11:57:12 am >> DELETE FROM ps_specific_price WHERE id_product = '20823' 10/03/2023 11:57:34 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 10/03/2023 11:57:34 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20824' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 11:57:34 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20824' , '1' , '1' , '2' , NOW() , NOW() ) 10/03/2023 11:57:34 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20824' , '0' , '1' , '0' , '0' ) 10/03/2023 11:58:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '12-345' AND id_product != '20824' AND ean13 != '' 10/03/2023 11:58:52 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-345', date_upd = NOW() WHERE id_product = '20824' 10/03/2023 11:58:52 am >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO CM 14', description = '' WHERE id_product = '20824' 10/03/2023 11:58:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '20824' 10/03/2023 11:58:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20824' 10/03/2023 11:58:52 am >> DELETE FROM ps_specific_price WHERE id_product = '20824' 10/03/2023 11:58:53 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20824' 10/03/2023 11:58:53 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20825' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 11:58:53 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20825' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20824' 10/03/2023 11:58:53 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20825' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20824' 10/03/2023 12:00:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '12-775' AND id_product != '20825' AND ean13 != '' 10/03/2023 12:00:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-775', date_upd = NOW() WHERE id_product = '20825' 10/03/2023 12:00:30 pm >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO STELLA', description = '' WHERE id_product = '20825' 10/03/2023 12:00:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19.672131147540984' WHERE id_product = '20825' 10/03/2023 12:00:31 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19.672131147540984', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20825' 10/03/2023 12:00:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '20825' 10/03/2023 12:00:34 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20825' 10/03/2023 12:00:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20826' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 12:00:35 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20826' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20825' 10/03/2023 12:00:35 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20826' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20825' 10/03/2023 12:01:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-750' AND id_product != '20826' AND ean13 != '' 10/03/2023 12:01:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '10-750', date_upd = NOW() WHERE id_product = '20826' 10/03/2023 12:01:50 pm >> UPDATE ps_product_lang SET name = 'PADELLA CM 17', description = '' WHERE id_product = '20826' 10/03/2023 12:01:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.573770491803279' WHERE id_product = '20826' 10/03/2023 12:01:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.573770491803279', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20826' 10/03/2023 12:01:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '20826' 10/03/2023 12:01:51 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20826' 10/03/2023 12:01:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20827' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 12:01:51 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20827' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20826' 10/03/2023 12:01:51 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20827' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20826' 10/03/2023 12:02:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '2023-00533' , '2023-03-06' , '' , '0' , '86' , '2723' , 'WEIDACHSTRABE, 6 85609 ASCHHEIM - GERMANIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '431.34' , '427.46' , NOW() , NOW() ) 10/03/2023 12:02:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82237' 10/03/2023 12:02:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '82237' 10/03/2023 12:02:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '12237' , 'TURIBOLO H28 CM' , '1' , '1' , '0' , '68' , '68' , '' , '3' , '65.9600' ) 10/03/2023 12:02:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12237' AND id_supplier = '86' 10/03/2023 12:02:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12237' , '86' , '1' ) 10/03/2023 12:02:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '18903' , 'TURIBOLO CM 28' , '1' , '1' , '0' , '0' , '0' , '' , '0' , '0.0000' ) 10/03/2023 12:02:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18903' AND id_supplier = '86' 10/03/2023 12:02:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18903' , '86' , '1' ) 10/03/2023 12:02:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '12238' , 'NAVETTA CLASSICA H13 CM' , '4' , '4' , '0' , '18.1' , '18.1' , '' , '3' , '70.2280' ) 10/03/2023 12:02:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12238' AND id_supplier = '86' 10/03/2023 12:02:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12238' , '86' , '1' ) 10/03/2023 12:02:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '13565' , 'NAVETTA CLASSICA CM 13' , '2' , '2' , '0' , '16.7' , '16.7' , '' , '3' , '32.3980' ) 10/03/2023 12:02:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13565' AND id_supplier = '86' 10/03/2023 12:02:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13565' , '86' , '1' ) 10/03/2023 12:02:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '19253' , 'bruciaincenso cm 9' , '2' , '2' , '0' , '7.03' , '7.03' , '' , '3' , '13.6382' ) 10/03/2023 12:02:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19253' AND id_supplier = '86' 10/03/2023 12:02:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19253' , '86' , '1' ) 10/03/2023 12:02:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20821' , 'PORTACANDELA CM 9,5' , '2' , '2' , '0' , '6.56' , '6.56' , '' , '3' , '12.7264' ) 10/03/2023 12:02:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20821' AND id_supplier = '86' 10/03/2023 12:02:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20821' , '86' , '1' ) 10/03/2023 12:02:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20822' , 'PORTACANDELA CM 11 -12-371/A' , '2' , '2' , '0' , '5.87' , '5.87' , '' , '3' , '11.3878' ) 10/03/2023 12:02:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20822' AND id_supplier = '86' 10/03/2023 12:02:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20822' , '86' , '1' ) 10/03/2023 12:02:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '18022' , 'TURIBOLO H 24' , '2' , '2' , '0' , '55.31' , '55.31' , '' , '3' , '107.3014' ) 10/03/2023 12:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18022' AND id_supplier = '86' 10/03/2023 12:02:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18022' , '86' , '1' ) 10/03/2023 12:02:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '12613' , 'TURIBOLO 10 CM' , '3' , '3' , '0' , '5.66' , '5.66' , '' , '0' , '16.9800' ) 10/03/2023 12:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12613' AND id_supplier = '86' 10/03/2023 12:02:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12613' , '86' , '1' ) 10/03/2023 12:02:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '12608' , 'NAVETTA CON CUCCHIAINO' , '1' , '1' , '0' , '14.64' , '14.64' , '' , '3' , '14.2008' ) 10/03/2023 12:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12608' AND id_supplier = '86' 10/03/2023 12:02:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12608' , '86' , '1' ) 10/03/2023 12:02:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '12617' , 'NAVETTA CON CUCCHIAINO' , '1' , '1' , '0' , '14.42' , '14.42' , '' , '3.' , '13.9874' ) 10/03/2023 12:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12617' AND id_supplier = '86' 10/03/2023 12:02:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12617' , '86' , '1' ) 10/03/2023 12:02:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20823' , 'BRUCIA INCENSO CM 9' , '2' , '2' , '0' , '9.44' , '9.44' , '' , '0' , '18.8800' ) 10/03/2023 12:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20823' AND id_supplier = '86' 10/03/2023 12:02:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20823' , '86' , '1' ) 10/03/2023 12:02:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20824' , 'BRUCIA INCENSO CM 14' , '2' , '2' , '0' , '9.68' , '9.68' , '' , '3' , '18.7792' ) 10/03/2023 12:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20824' AND id_supplier = '86' 10/03/2023 12:02:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20824' , '86' , '1' ) 10/03/2023 12:02:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20825' , 'BRUCIA INCENSO STELLA' , '2' , '2' , '1' , '9.09' , '7.4508196721311' , '22' , '3' , '21.5142' ) 10/03/2023 12:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20825' AND id_supplier = '86' 10/03/2023 12:02:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20825' , '86' , '1' ) 10/03/2023 12:02:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20826' , 'PADELLA CM 17' , '2' , '2' , '0' , '6.68' , '6.68' , '' , '0' , '13.3600' ) 10/03/2023 12:02:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20826' AND id_supplier = '86' 10/03/2023 12:02:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20826' , '86' , '1' ) 10/03/2023 12:03:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '793' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 12:03:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '793' , '2023-03-10' , '' , '0' , '0' , '0' , 'VIA G. AMENDOLA, 94 84084 PENTA DI FISCIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '399.00' , '330.33' , NOW() , NOW() ) 10/03/2023 12:03:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82238' 10/03/2023 12:03:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '82238' 10/03/2023 12:03:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82238' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967' , '22' , '0' , '10.00' ) 10/03/2023 12:03:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82238' , '5229' , 'INCENSO PONTIFICAL' , '2' , '-2' , '1' , '24.0000' , '19.6721' , '22' , '0' , '48.00' ) 10/03/2023 12:03:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82238' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3.3000' , '2.7049' , '22' , '0' , '198.00' ) 10/03/2023 12:03:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82238' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8525' , '22' , '0' , '112.80' ) 10/03/2023 12:03:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82238' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8361' , '22' , '0' , '12.00' ) 10/03/2023 12:03:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82238' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '18.2' , '18.2' , '0' , '0' , '18.20' ) 10/03/2023 12:05:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-950' AND id_product != '18032' AND ean13 != '' 10/03/2023 12:05:57 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '10-950', date_upd = NOW() WHERE id_product = '18032' 10/03/2023 12:05:57 pm >> UPDATE ps_product_lang SET name = 'BRUCIAINCENSO H 11', description = '' WHERE id_product = '18032' 10/03/2023 12:05:58 pm >> UPDATE ps_product SET wholesale_price = '5.47', on_sale = '0', price = '12.295081967213115' WHERE id_product = '18032' 10/03/2023 12:05:58 pm >> UPDATE ps_product_shop SET wholesale_price = '5.47', price = '12.295081967213115', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18032' 10/03/2023 12:05:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '18032' 10/03/2023 12:06:33 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '2023-00533', document_date = '2023-03-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2723', address1 = 'WEIDACHSTRABE, 6 85609 ASCHHEIM - GERMANIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '442.99', price_tax_excluded = '439.11', date_upd = NOW() WHERE id_document = '82237' 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82237' 10/03/2023 12:06:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '82237' 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '12237' , 'TURIBOLO H28 CM' , '1' , '1' , '0' , '68.0000' , '68' , '0' , '3' , '65.96' ) 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '18903' , 'TURIBOLO CM 28' , '1' , '1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '12238' , 'NAVETTA CLASSICA H13 CM' , '4' , '4' , '0' , '18.1000' , '18.1' , '0' , '3' , '70.23' ) 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '13565' , 'NAVETTA CLASSICA CM 13' , '2' , '2' , '0' , '16.7000' , '16.7' , '0' , '3' , '32.40' ) 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '19253' , 'bruciaincenso cm 9' , '2' , '2' , '0' , '7.0300' , '7.03' , '0' , '3' , '13.64' ) 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20821' , 'PORTACANDELA CM 9,5' , '2' , '2' , '0' , '6.5600' , '6.56' , '0' , '3' , '12.73' ) 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20822' , 'PORTACANDELA CM 11 -12-371/A' , '2' , '2' , '0' , '5.8700' , '5.87' , '0' , '3' , '11.39' ) 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '18022' , 'TURIBOLO H 24' , '2' , '2' , '0' , '55.3100' , '55.31' , '0' , '3' , '107.30' ) 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '12613' , 'TURIBOLO 10 CM' , '3' , '3' , '0' , '5.6600' , '5.66' , '0' , '0' , '16.98' ) 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '12608' , 'NAVETTA CON CUCCHIAINO' , '1' , '1' , '0' , '14.6400' , '14.64' , '0' , '3' , '14.20' ) 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '12617' , 'NAVETTA CON CUCCHIAINO' , '1' , '1' , '0' , '14.4200' , '14.42' , '0' , '3.' , '13.99' ) 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20823' , 'BRUCIA INCENSO CM 9' , '2' , '2' , '0' , '9.4400' , '9.44' , '0' , '0' , '18.88' ) 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20824' , 'BRUCIA INCENSO CM 14' , '2' , '2' , '0' , '9.6800' , '9.68' , '0' , '3' , '18.78' ) 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20825' , 'BRUCIA INCENSO STELLA' , '2' , '2' , '1' , '9.0900' , '7.4508196721311' , '22' , '3' , '21.51' ) 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20826' , 'PADELLA CM 17' , '2' , '2' , '0' , '6.6800' , '6.68' , '0' , '0' , '13.36' ) 10/03/2023 12:06:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '18032' , 'BRUCIAINCENSO H 11' , '2' , '2' , '0' , '6' , '6' , '' , '3' , '11.6400' ) 10/03/2023 12:11:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '794' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 12:11:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '794' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 10/03/2023 12:11:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82239' 10/03/2023 12:11:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '82239' 10/03/2023 12:11:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82239' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 10/03/2023 12:25:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '795' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 12:25:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '795' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '48.36' , NOW() , NOW() ) 10/03/2023 12:25:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82240' 10/03/2023 12:25:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '82240' 10/03/2023 12:25:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82240' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 10/03/2023 12:25:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82240' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.00' , '37.704918032787' , '22' , '0' , '46.00' ) 10/03/2023 12:31:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '796' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 12:31:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '796' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.00' , '86.85' , NOW() , NOW() ) 10/03/2023 12:31:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82241' 10/03/2023 12:31:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '82241' 10/03/2023 12:31:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82241' , '17908' , 'VITA DI SAN FILIPPO NERI - P. BACCI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 10/03/2023 12:31:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82241' , '20759' , 'UNA CHIESA CHE ESCE - S. SILBER' , '1' , '-1' , '4' , '34.00' , '34' , '0' , '5' , '32.30' ) 10/03/2023 12:31:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82241' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '13' , '-13' , '4' , '1.00' , '1' , '0' , '5' , '12.35' ) 10/03/2023 12:31:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82241' , '20787' , 'BAMBINO GESU - P498' , '1' , '-1' , '1' , '34.1' , '27.950819672131' , '22' , '0' , '34.10' ) 10/03/2023 12:42:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788834351024' AND id_product != '20827' AND ean13 != '' 10/03/2023 12:42:13 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788834351024', date_upd = NOW() WHERE id_product = '20827' 10/03/2023 12:42:13 pm >> UPDATE ps_product_lang SET name = 'DANTE E GRANDI QUESTIONI ESCATOLOGICHE - L. AZZETTA', description = '' WHERE id_product = '20827' 10/03/2023 12:42:13 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '20827' 10/03/2023 12:42:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '444', id_argoment_default = '198', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20827' 10/03/2023 12:42:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '20827' 10/03/2023 12:42:14 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20827' 10/03/2023 12:42:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20828' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 12:42:14 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20828' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20827' 10/03/2023 12:42:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20828' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20827' 10/03/2023 12:43:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869299193' AND id_product != '20828' AND ean13 != '' 10/03/2023 12:43:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9788869299193', date_upd = NOW() WHERE id_product = '20828' 10/03/2023 12:43:34 pm >> UPDATE ps_product_lang SET name = 'DEVOZIONE AI PIEDI DI GESU\' - G. LAMBERTO', description = '' WHERE id_product = '20828' 10/03/2023 12:43:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '20828' 10/03/2023 12:43:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20828' 10/03/2023 12:43:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '20828' 10/03/2023 12:43:35 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20828' 10/03/2023 12:43:35 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20829' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 12:43:35 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20829' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20828' 10/03/2023 12:43:35 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20829' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20828' 10/03/2023 12:44:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713664' AND id_product != '20829' AND ean13 != '' 10/03/2023 12:44:21 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 2', ean13 = '9788832713664', date_upd = NOW() WHERE id_product = '20829' 10/03/2023 12:44:21 pm >> UPDATE ps_product_lang SET name = 'SOSTARE CON TE 2', description = '' WHERE id_product = '20829' 10/03/2023 12:44:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.5' WHERE id_product = '20829' 10/03/2023 12:44:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.5', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20829' 10/03/2023 12:44:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '20829' 10/03/2023 12:44:39 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20829' 10/03/2023 12:44:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20830' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 12:44:39 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20830' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20829' 10/03/2023 12:44:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20830' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20829' 10/03/2023 12:45:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713695' AND id_product != '20830' AND ean13 != '' 10/03/2023 12:45:12 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788832713695', date_upd = NOW() WHERE id_product = '20830' 10/03/2023 12:45:12 pm >> UPDATE ps_product_lang SET name = 'TRA SGUARDI DI SPERANZA! ', description = '' WHERE id_product = '20830' 10/03/2023 12:45:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20830' 10/03/2023 12:45:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20830' 10/03/2023 12:45:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '20830' 10/03/2023 12:45:16 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20830' 10/03/2023 12:45:16 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20831' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 12:45:16 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20831' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20830' 10/03/2023 12:45:16 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20831' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20830' 10/03/2023 12:45:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713671' AND id_product != '20831' AND ean13 != '' 10/03/2023 12:45:44 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788832713671', date_upd = NOW() WHERE id_product = '20831' 10/03/2023 12:45:44 pm >> UPDATE ps_product_lang SET name = 'TRA SGUARDI DI SPERANZA ', description = '' WHERE id_product = '20831' 10/03/2023 12:45:44 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '20831' 10/03/2023 12:45:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20831' 10/03/2023 12:45:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '20831' 10/03/2023 12:45:45 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20831' 10/03/2023 12:45:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20832' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 12:45:46 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20832' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20831' 10/03/2023 12:45:46 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20832' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20831' 10/03/2023 12:46:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254780510' AND id_product != '20832' AND ean13 != '' 10/03/2023 12:46:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9791254780510', date_upd = NOW() WHERE id_product = '20832' 10/03/2023 12:46:59 pm >> UPDATE ps_product_lang SET name = 'BONTA\' DELLA FEDE - S. TARDANI', description = '' WHERE id_product = '20832' 10/03/2023 12:46:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20832' 10/03/2023 12:46:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '100', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20832' 10/03/2023 12:46:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '20832' 10/03/2023 12:47:00 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20832' 10/03/2023 12:47:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20833' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 12:47:00 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20833' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20832' 10/03/2023 12:47:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20833' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20832' 10/03/2023 12:48:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810565193' AND id_product != '20833' AND ean13 != '' 10/03/2023 12:48:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788810565193', date_upd = NOW() WHERE id_product = '20833' 10/03/2023 12:48:22 pm >> UPDATE ps_product_lang SET name = 'SEGNO E LA CARNE - L. BRUNI', description = '' WHERE id_product = '20833' 10/03/2023 12:48:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '20833' 10/03/2023 12:48:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20833' 10/03/2023 12:48:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '20833' 10/03/2023 12:48:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '797' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 12:48:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '797' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.75' , '30.75' , NOW() , NOW() ) 10/03/2023 12:48:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82242' 10/03/2023 12:48:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '82242' 10/03/2023 12:48:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82242' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 10/03/2023 12:48:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82242' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.70' , '0.7' , '0' , '0' , '7.00' ) 10/03/2023 02:50:26 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 10/03/2023 02:50:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20834' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 02:50:26 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20834' , '1' , '1' , '2' , NOW() , NOW() ) 10/03/2023 02:50:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20834' , '0' , '1' , '0' , '0' ) 10/03/2023 02:53:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869299391' AND id_product != '20834' AND ean13 != '' 10/03/2023 02:53:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/6', ean13 = '9788869299391', date_upd = NOW() WHERE id_product = '20834' 10/03/2023 02:53:11 pm >> UPDATE ps_product_lang SET name = 'SALMI - M. VERSACI ', description = '' WHERE id_product = '20834' 10/03/2023 02:53:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '20834' 10/03/2023 02:53:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20834' 10/03/2023 02:53:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '20834' 10/03/2023 02:54:48 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 10/03/2023 02:54:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20835' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 02:54:48 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20835' , '1' , '1' , '2' , NOW() , NOW() ) 10/03/2023 02:54:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20835' , '0' , '1' , '0' , '0' ) 10/03/2023 02:55:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810505588' AND id_product != '20835' AND ean13 != '' 10/03/2023 02:55:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810505588', date_upd = NOW() WHERE id_product = '20835' 10/03/2023 02:55:41 pm >> UPDATE ps_product_lang SET name = 'VITA NELLE NOSTRE MANI - M. FAGGIONI', description = '' WHERE id_product = '20835' 10/03/2023 02:55:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36' WHERE id_product = '20835' 10/03/2023 02:55:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20835' 10/03/2023 02:55:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '20835' 10/03/2023 02:56:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '873608' , '2023-03-09' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '251.40' , '251.40' , NOW() , NOW() ) 10/03/2023 02:56:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82243' 10/03/2023 02:56:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '82243' 10/03/2023 02:56:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82243' , '20827' , 'DANTE E GRANDI QUESTIONI ESCATOLOGICHE - L. AZZETTA' , '1' , '1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 10/03/2023 02:56:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20827' AND id_supplier = '109' 10/03/2023 02:56:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20827' , '109' , '1' ) 10/03/2023 02:56:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82243' , '20641' , 'ENCICLICA SULLA PACE IN UCRAINA ' , '1' , '1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 10/03/2023 02:56:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20641' AND id_supplier = '109' 10/03/2023 02:56:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20641' , '109' , '1' ) 10/03/2023 02:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82243' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 10/03/2023 02:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20639' AND id_supplier = '109' 10/03/2023 02:56:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20639' , '109' , '1' ) 10/03/2023 02:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82243' , '20024' , 'PER LETERNITA - R. SARAH' , '1' , '1' , '4' , '23.00' , '23' , '0' , '0' , '23.00' ) 10/03/2023 02:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20024' AND id_supplier = '109' 10/03/2023 02:56:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20024' , '109' , '1' ) 10/03/2023 02:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82243' , '20832' , 'BONTA DELLA FEDE - S. TARDANI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 10/03/2023 02:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20832' AND id_supplier = '109' 10/03/2023 02:56:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20832' , '109' , '1' ) 10/03/2023 02:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82243' , '20588' , 'FELICITA DEL CUORE - F. SHEEN' , '1' , '1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 10/03/2023 02:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20588' AND id_supplier = '109' 10/03/2023 02:56:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20588' , '109' , '1' ) 10/03/2023 02:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82243' , '20587' , 'CATECHESI CREATIVA - A. QUEIROLO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 10/03/2023 02:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20587' AND id_supplier = '109' 10/03/2023 02:56:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20587' , '109' , '1' ) 10/03/2023 02:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82243' , '20828' , 'DEVOZIONE AI PIEDI DI GESU - G. LAMBERTO' , '1' , '1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 10/03/2023 02:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20828' AND id_supplier = '109' 10/03/2023 02:56:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20828' , '109' , '1' ) 10/03/2023 02:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82243' , '20834' , 'SALMI - M. VERSACI ' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 10/03/2023 02:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20834' AND id_supplier = '109' 10/03/2023 02:56:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20834' , '109' , '1' ) 10/03/2023 02:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82243' , '1143' , 'BIBBIA DI GERUSALEMME - TASCABILE' , '1' , '1' , '4' , '21.90' , '21.9' , '0' , '0' , '21.90' ) 10/03/2023 02:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1143' AND id_supplier = '109' 10/03/2023 02:56:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1143' , '109' , '1' ) 10/03/2023 02:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82243' , '20833' , 'SEGNO E LA CARNE - L. BRUNI' , '1' , '1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 10/03/2023 02:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20833' AND id_supplier = '109' 10/03/2023 02:56:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20833' , '109' , '1' ) 10/03/2023 02:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82243' , '20835' , 'VITA NELLE NOSTRE MANI - M. FAGGIONI' , '1' , '1' , '4' , '36.00' , '36' , '0' , '0' , '36.00' ) 10/03/2023 02:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20835' AND id_supplier = '109' 10/03/2023 02:56:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20835' , '109' , '1' ) 10/03/2023 02:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82243' , '20830' , 'TRA SGUARDI DI SPERANZA! ' , '1' , '1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 10/03/2023 02:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20830' AND id_supplier = '109' 10/03/2023 02:56:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20830' , '109' , '1' ) 10/03/2023 02:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82243' , '20831' , 'TRA SGUARDI DI SPERANZA ' , '1' , '1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 10/03/2023 02:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20831' AND id_supplier = '109' 10/03/2023 02:56:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20831' , '109' , '1' ) 10/03/2023 02:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82243' , '20829' , 'SOSTARE CON TE 2' , '1' , '1' , '4' , '10.50' , '10.5' , '0' , '0' , '10.50' ) 10/03/2023 02:56:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20829' AND id_supplier = '109' 10/03/2023 02:56:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20829' , '109' , '1' ) 10/03/2023 03:18:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '798' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 03:18:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '798' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 10/03/2023 03:18:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82244' 10/03/2023 03:18:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '82244' 10/03/2023 03:18:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82244' , '20795' , 'SULLA TUA PAROLA MAG GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/03/2023 03:18:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82244' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/03/2023 03:27:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '799' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 03:27:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '799' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.00' , '41.78' , NOW() , NOW() ) 10/03/2023 03:27:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82245' 10/03/2023 03:27:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '82245' 10/03/2023 03:27:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82245' , '18428' , 'LIBRO DEGLI ARCANGELI - A. LUMINI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 10/03/2023 03:27:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82245' , '4621' , 'GIOVANNI PAOLO II' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '5' , '3.33' ) 10/03/2023 03:27:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82245' , '4636' , 'GIOVANNI XXIII' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '5' , '3.33' ) 10/03/2023 03:27:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82245' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '1' , '-1' , '1' , '4.44' , '3.6393442622951' , '22' , '0' , '4.44' ) 10/03/2023 03:27:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82245' , '1914' , 'CERA DELLA LITURGIA' , '5' , '-5' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '24.50' ) 10/03/2023 03:54:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '789' AND id_document != '82232' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 03:54:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '789', document_date = '2023-03-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '10.50', price_tax_excluded = '10.27', date_upd = NOW() WHERE id_document = '82232' 10/03/2023 03:54:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82232' 10/03/2023 03:54:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '82232' 10/03/2023 03:54:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82232' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '1.90' ) 10/03/2023 03:54:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82232' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 10/03/2023 03:54:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82232' , '20795' , 'SULLA TUA PAROLA MAG GIU 2023 - 516' , '1' , '-1' , '4' , '4.6' , '4.6' , '0' , '0' , '4.60' ) 10/03/2023 03:55:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '490' AND id_document != '81326' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-11') 10/03/2023 03:55:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '490', document_date = '2023-02-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '45.00', date_upd = NOW() WHERE id_document = '81326' 10/03/2023 03:55:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81326' 10/03/2023 03:55:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '81326' 10/03/2023 03:55:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81326' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.25' , '2.25' , '0' , '0' , '2.25' ) 10/03/2023 03:55:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81326' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '9' , '-9' , '4' , '5.0000' , '5' , '0' , '5' , '42.75' ) 10/03/2023 03:56:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '120' AND id_document != '78784' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-12') 10/03/2023 03:56:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '120', document_date = '2023-01-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '35.00', price_tax_excluded = '31.43', date_upd = NOW() WHERE id_document = '78784' 10/03/2023 03:56:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78784' 10/03/2023 03:56:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '78784' 10/03/2023 03:56:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78784' , '20612' , 'LIBRO CHE CI LEGGE - C. MIRIANO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 10/03/2023 03:56:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78784' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 10/03/2023 03:56:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78784' , '11681' , 'CROCE TRAFORATA CON LACCIO' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 10/03/2023 03:56:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78784' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 10/03/2023 03:56:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78784' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.3' , '6.8032786885246' , '22' , '0' , '8.30' ) 10/03/2023 03:56:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '280' AND id_document != '80549' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-26') 10/03/2023 03:56:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '280', document_date = '2023-01-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '82.50', price_tax_excluded = '70.81', date_upd = NOW() WHERE id_document = '80549' 10/03/2023 03:56:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80549' 10/03/2023 03:56:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '80549' 10/03/2023 03:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80549' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 10/03/2023 03:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80549' , '18776' , 'GESU A COLORI' , '1' , '-1' , '4' , '8.9000' , '8.9' , '0' , '5' , '8.46' ) 10/03/2023 03:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80549' , '740' , 'ARC. RAFFAELE BABY 023 AR/R 9 BB' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 10/03/2023 03:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80549' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.42' , '6.0819672131148' , '22' , '0' , '14.84' ) 10/03/2023 03:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80549' , '17297' , 'COLLANA ROSARIO ARG' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 10/03/2023 03:56:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80549' , '20473' , 'GLI ANGELI CI PROTEGGONO' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 10/03/2023 03:59:04 pm >> DELETE FROM ps_document WHERE id_document = '81129' 10/03/2023 03:59:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '81129' 10/03/2023 04:16:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '48' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 04:16:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '48' , '2023-03-10' , '' , '3191' , '0' , '4670958' , 'VIA QUINTINO DI VONA 84133 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '40.00' , '40.00' , NOW() , NOW() ) 10/03/2023 04:16:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82246' 10/03/2023 04:16:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '82246' 10/03/2023 04:16:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82246' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '12' , '-12' , '4' , '1.5' , '1.5' , '0' , '0' , '18.00' ) 10/03/2023 04:16:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82246' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '2' , '-2' , '4' , '10' , '10' , '0' , '' , '20.00' ) 10/03/2023 04:16:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82246' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 10/03/2023 04:17:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '800' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 04:17:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '800' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '37.84' , NOW() , NOW() ) 10/03/2023 04:17:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82247' 10/03/2023 04:17:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '82247' 10/03/2023 04:17:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82247' , '20515' , 'DECINA ULIVO - 04/7-D' , '24' , '-24' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '12.00' ) 10/03/2023 04:17:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82247' , '15722' , 'BIBBIA DEI PICCOLI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 10/03/2023 04:17:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82247' , '13034' , 'STORIE DELLA BIBBIA IN 1000 ADESIVI - 8887' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 10/03/2023 04:17:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82247' , '20661' , 'LASCIATI AMARE - P. CURTAZ' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 10/03/2023 04:17:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82247' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '1' , '-1' , '4' , '3.3' , '3.3' , '0' , '0' , '3.30' ) 10/03/2023 04:37:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '800' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 04:37:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '801' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 04:37:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '801' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 10/03/2023 04:37:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82248' 10/03/2023 04:37:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '82248' 10/03/2023 04:37:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82248' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 10/03/2023 04:42:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '802' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 04:42:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '802' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 10/03/2023 04:42:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82249' 10/03/2023 04:42:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '82249' 10/03/2023 04:42:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82249' , '17852' , 'CON CUORE DI PADRE - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 10/03/2023 04:45:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '207' AND id_document != '80442' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-20') 10/03/2023 04:45:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '207', document_date = '2023-01-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.10', price_tax_excluded = '17.88', date_upd = NOW() WHERE id_document = '80442' 10/03/2023 04:45:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80442' 10/03/2023 04:45:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '80442' 10/03/2023 04:45:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80442' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 10/03/2023 04:45:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80442' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 10/03/2023 04:45:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80442' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 10/03/2023 04:57:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '803' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 04:57:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '803' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '39.00' , NOW() , NOW() ) 10/03/2023 04:57:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82250' 10/03/2023 04:57:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '82250' 10/03/2023 04:57:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82250' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '39' , '39' , '0' , '0' , '39.00' ) 10/03/2023 05:01:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '804' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 05:01:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '804' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '123.70' , '112.30' , NOW() , NOW() ) 10/03/2023 05:01:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82251' 10/03/2023 05:01:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '82251' 10/03/2023 05:01:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82251' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '39' , '39' , '0' , '0' , '39.00' ) 10/03/2023 05:01:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82251' , '7311' , 'OSTIA SOTTILE 74MM' , '8' , '-8' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '15.20' ) 10/03/2023 05:01:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82251' , '8248' , 'PREGATE, PREGATE, PREGATE - CART. - 8101' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 10/03/2023 05:01:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82251' , '17747' , 'SEGNALIBRO - PR SP 100' , '200' , '-200' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '60.00' ) 10/03/2023 05:08:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '49' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 05:08:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '49' , '2023-03-10' , '' , '835' , '0' , '4671989' , 'VIA BRIGNANO INF 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.00' , '135.00' , NOW() , NOW() ) 10/03/2023 05:08:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82252' 10/03/2023 05:08:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '82252' 10/03/2023 05:08:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82252' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '20' , '-20' , '4' , '2.00' , '2' , '0' , '10' , '36.00' ) 10/03/2023 05:08:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82252' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '20' , '-20' , '4' , '2.50' , '2.5' , '0' , '10' , '45.00' ) 10/03/2023 05:08:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82252' , '16667' , 'VIA CRUCIS' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '10' , '54.00' ) 10/03/2023 05:08:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '49' AND id_document != '82252' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 05:08:36 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '49', document_date = '2023-03-10', document_letter = '', id_customer = '835', id_supplier = '', id_address = '4671989', address1 = 'VIA BRIGNANO INF 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '127.50', price_tax_excluded = '127.50', date_upd = NOW() WHERE id_document = '82252' 10/03/2023 05:08:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82252' 10/03/2023 05:08:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '82252' 10/03/2023 05:08:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82252' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '20' , '-20' , '4' , '2.0000' , '2' , '0' , '15' , '34.00' ) 10/03/2023 05:08:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82252' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '15' , '42.50' ) 10/03/2023 05:08:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82252' , '16667' , 'VIA CRUCIS' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 10/03/2023 05:10:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '805' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 05:10:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '805' , '2023-03-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.50' , '30.30' , NOW() , NOW() ) 10/03/2023 05:10:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82253' 10/03/2023 05:10:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '82253' 10/03/2023 05:10:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82253' , '20675' , 'SULLA VIA DELLA CROCE CON PAPA FRANCESCO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 10/03/2023 05:10:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82253' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 10/03/2023 05:10:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82253' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 10/03/2023 05:10:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82253' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 10/03/2023 05:10:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82253' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 10/03/2023 05:23:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '49' AND id_document != '82252' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-10') 10/03/2023 05:23:34 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '49', document_date = '2023-03-10', document_letter = '', id_customer = '835', id_supplier = '', id_address = '4671989', address1 = 'VIA BRIGNANO INF 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '127.50', price_tax_excluded = '127.50', date_upd = NOW() WHERE id_document = '82252' 10/03/2023 05:23:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82252' 10/03/2023 05:23:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '82252' 10/03/2023 05:23:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82252' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '20' , '-20' , '4' , '2.0000' , '2' , '0' , '15' , '34.00' ) 10/03/2023 05:23:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82252' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '15' , '42.50' ) 10/03/2023 05:23:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82252' , '16667' , 'VIA CRUCIS' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 10/03/2023 05:26:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-136' AND id_product != '18903' AND ean13 != '' 10/03/2023 05:26:29 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '10-136', date_upd = NOW() WHERE id_product = '18903' 10/03/2023 05:26:29 pm >> UPDATE ps_product_lang SET name = 'TURIBOLO CM 28', description = '' WHERE id_product = '18903' 10/03/2023 05:26:29 pm >> UPDATE ps_product SET wholesale_price = '63.73', on_sale = '0', price = '153.27868852459017' WHERE id_product = '18903' 10/03/2023 05:26:29 pm >> UPDATE ps_product_shop SET wholesale_price = '63.73', price = '153.27868852459017', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18903' 10/03/2023 05:26:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '18903' 10/03/2023 05:27:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '30-246' AND id_product != '19253' AND ean13 != '' 10/03/2023 05:27:10 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '30-246', date_upd = NOW() WHERE id_product = '19253' 10/03/2023 05:27:10 pm >> UPDATE ps_product_lang SET name = 'bruciaincenso cm 9', description = '' WHERE id_product = '19253' 10/03/2023 05:27:10 pm >> UPDATE ps_product SET wholesale_price = '6.59', on_sale = '0', price = '15.573770491803279' WHERE id_product = '19253' 10/03/2023 05:27:10 pm >> UPDATE ps_product_shop SET wholesale_price = '6.59', price = '15.573770491803279', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19253' 10/03/2023 05:27:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '19253' 10/03/2023 05:28:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-704' AND id_product != '18031' AND ean13 != '' 10/03/2023 05:28:31 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '10-704', date_upd = NOW() WHERE id_product = '18031' 10/03/2023 05:28:31 pm >> UPDATE ps_product_lang SET name = 'BRUCIAINCENSO H 8', description = '' WHERE id_product = '18031' 10/03/2023 05:28:31 pm >> UPDATE ps_product SET wholesale_price = '4.41', on_sale = '0', price = '11.065573770491804' WHERE id_product = '18031' 10/03/2023 05:28:31 pm >> UPDATE ps_product_shop SET wholesale_price = '4.41', price = '11.065573770491804', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18031' 10/03/2023 05:28:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '18031' 10/03/2023 05:28:56 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 10/03/2023 05:28:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20836' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 05:28:56 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20836' , '1' , '1' , '2' , NOW() , NOW() ) 10/03/2023 05:28:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20836' , '0' , '1' , '0' , '0' ) 10/03/2023 05:29:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-333' AND id_product != '20836' AND ean13 != '' 10/03/2023 05:29:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '10-333', date_upd = NOW() WHERE id_product = '20836' 10/03/2023 05:29:22 pm >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO CM 16', description = '' WHERE id_product = '20836' 10/03/2023 05:29:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '20836' 10/03/2023 05:29:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20836' 10/03/2023 05:29:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '20836' 10/03/2023 05:29:23 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20836' 10/03/2023 05:29:23 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20837' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 05:29:23 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20837' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20836' 10/03/2023 05:29:23 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20837' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20836' 10/03/2023 05:31:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-333/M' AND id_product != '20837' AND ean13 != '' 10/03/2023 05:31:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '10-333/M', date_upd = NOW() WHERE id_product = '20837' 10/03/2023 05:31:11 pm >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO CM 11', description = '' WHERE id_product = '20837' 10/03/2023 05:31:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.491803278688526' WHERE id_product = '20837' 10/03/2023 05:31:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20837' 10/03/2023 05:31:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '20837' 10/03/2023 05:31:13 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20837' 10/03/2023 05:31:13 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20838' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 05:31:13 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20838' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20837' 10/03/2023 05:31:13 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20838' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20837' 10/03/2023 05:33:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-333' AND id_product != '20836' AND ean13 != '' 10/03/2023 05:33:26 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '10-333', date_upd = NOW() WHERE id_product = '20836' 10/03/2023 05:33:26 pm >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO CM 16', description = '' WHERE id_product = '20836' 10/03/2023 05:33:26 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.39344262295082' WHERE id_product = '20836' 10/03/2023 05:33:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.39344262295082', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20836' 10/03/2023 05:33:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '20836' 10/03/2023 05:34:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-283/M' AND id_product != '20838' AND ean13 != '' 10/03/2023 05:34:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-283/M' AND id_product != '18024' AND ean13 != '' 10/03/2023 05:34:38 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '10-283/M', date_upd = NOW() WHERE id_product = '18024' 10/03/2023 05:34:38 pm >> UPDATE ps_product_lang SET name = 'TURIBOLO H 27', description = '' WHERE id_product = '18024' 10/03/2023 05:34:38 pm >> UPDATE ps_product SET wholesale_price = '72.56', on_sale = '0', price = '171.31147540983608' WHERE id_product = '18024' 10/03/2023 05:34:38 pm >> UPDATE ps_product_shop SET wholesale_price = '72.56', price = '171.31147540983608', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18024' 10/03/2023 05:34:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '18024' 10/03/2023 05:35:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '30-712' AND id_product != '20838' AND ean13 != '' 10/03/2023 05:35:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '30-712', date_upd = NOW() WHERE id_product = '20838' 10/03/2023 05:35:37 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO DORATO CM 22', description = '' WHERE id_product = '20838' 10/03/2023 05:35:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '114.75409836065575' WHERE id_product = '20838' 10/03/2023 05:35:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '114.75409836065575', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20838' 10/03/2023 05:35:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '20838' 10/03/2023 05:35:38 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20838' 10/03/2023 05:35:38 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20839' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 05:35:38 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20839' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20838' 10/03/2023 05:35:38 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20839' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20838' 10/03/2023 05:36:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '30-710' AND id_product != '18019' AND ean13 != '' 10/03/2023 05:36:11 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '30-710', date_upd = NOW() WHERE id_product = '18019' 10/03/2023 05:36:11 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO DORATO H 18', description = '' WHERE id_product = '18019' 10/03/2023 05:36:11 pm >> UPDATE ps_product SET wholesale_price = '30.50', on_sale = '0', price = '69.67213114754098' WHERE id_product = '18019' 10/03/2023 05:36:11 pm >> UPDATE ps_product_shop SET wholesale_price = '30.50', price = '69.67213114754098', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18019' 10/03/2023 05:36:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '18019' 10/03/2023 05:37:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '30-541' AND id_product != '20839' AND ean13 != '' 10/03/2023 05:37:06 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '30-541', date_upd = NOW() WHERE id_product = '20839' 10/03/2023 05:37:06 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO DORATO CM 19,5', description = '' WHERE id_product = '20839' 10/03/2023 05:37:06 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '48.36065573770492' WHERE id_product = '20839' 10/03/2023 05:37:06 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '48.36065573770492', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20839' 10/03/2023 05:37:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '20839' 10/03/2023 05:37:09 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20839' 10/03/2023 05:37:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20840' , '1' , '' , 'nuovo-prodotto' ) 10/03/2023 05:37:09 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20840' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20839' 10/03/2023 05:37:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20840' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20839' 10/03/2023 05:39:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-219/M' AND id_product != '18164' AND ean13 != '' 10/03/2023 05:39:09 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '10-219/M', date_upd = NOW() WHERE id_product = '18164' 10/03/2023 05:39:09 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO H 28', description = '' WHERE id_product = '18164' 10/03/2023 05:39:09 pm >> UPDATE ps_product SET wholesale_price = '66.01', on_sale = '0', price = '154.91803278688525' WHERE id_product = '18164' 10/03/2023 05:39:09 pm >> UPDATE ps_product_shop SET wholesale_price = '66.01', price = '154.91803278688525', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18164' 10/03/2023 05:39:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '18164' 10/03/2023 05:40:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '32-706' AND id_product != '18905' AND ean13 != '' 10/03/2023 05:40:23 pm >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '32-706', date_upd = NOW() WHERE id_product = '18905' 10/03/2023 05:40:23 pm >> UPDATE ps_product_lang SET name = 'PORTA TURIBOLO CM 147', description = '' WHERE id_product = '18905' 10/03/2023 05:40:23 pm >> UPDATE ps_product SET wholesale_price = '126.52', on_sale = '0', price = '282.78688524590166' WHERE id_product = '18905' 10/03/2023 05:40:23 pm >> UPDATE ps_product_shop SET wholesale_price = '126.52', price = '282.78688524590166', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18905' 10/03/2023 05:40:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '18905' 10/03/2023 05:42:01 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '2023-00533', document_date = '2023-03-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2723', address1 = 'WEIDACHSTRABE, 6 85609 ASCHHEIM - GERMANIA', address2 = '', note = '', price_shipping = '-0.01', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '903.42', price_tax_excluded = '903.42', date_upd = NOW() WHERE id_document = '82237' 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82237' 10/03/2023 05:42:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '82237' 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '12237' , 'TURIBOLO H28 CM' , '1' , '1' , '0' , '68.0000' , '68' , '0' , '3' , '65.96' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '18903' , 'TURIBOLO CM 28' , '1' , '1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '12238' , 'NAVETTA CLASSICA H13 CM' , '4' , '4' , '0' , '18.1000' , '18.1' , '0' , '3' , '70.23' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '13565' , 'NAVETTA CLASSICA CM 13' , '2' , '2' , '0' , '16.7000' , '16.7' , '0' , '3' , '32.40' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '19253' , 'bruciaincenso cm 9' , '2' , '2' , '0' , '7.0300' , '7.03' , '0' , '3' , '13.64' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20821' , 'PORTACANDELA CM 9,5' , '2' , '2' , '0' , '6.5600' , '6.56' , '0' , '3' , '12.73' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20822' , 'PORTACANDELA CM 11 -12-371/A' , '2' , '2' , '0' , '5.8700' , '5.87' , '0' , '3' , '11.39' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '18022' , 'TURIBOLO H 24' , '2' , '2' , '0' , '55.3100' , '55.31' , '0' , '3' , '107.30' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '12613' , 'TURIBOLO 10 CM' , '3' , '3' , '0' , '5.6600' , '5.66' , '' , '3' , '16.4706' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '12608' , 'NAVETTA CON CUCCHIAINO' , '1' , '1' , '0' , '14.6400' , '14.64' , '0' , '3' , '14.20' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '12617' , 'NAVETTA CON CUCCHIAINO' , '1' , '1' , '0' , '14.4200' , '14.42' , '0' , '3.' , '13.99' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20823' , 'BRUCIA INCENSO CM 9' , '2' , '2' , '0' , '9.4400' , '9.44' , '' , '3' , '18.3136' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20824' , 'BRUCIA INCENSO CM 14' , '2' , '2' , '0' , '9.6800' , '9.68' , '0' , '3' , '18.78' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20825' , 'BRUCIA INCENSO STELLA' , '2' , '2' , '0' , '9.0900' , '9.09' , '' , '3' , '17.6346' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20826' , 'PADELLA CM 17' , '2' , '2' , '0' , '6.6800' , '6.68' , '' , '3' , '12.9592' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '18032' , 'BRUCIAINCENSO H 11' , '2' , '2' , '0' , '6.0000' , '6' , '0' , '3' , '11.64' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '18031' , 'BRUCIAINCENSO H 8' , '2' , '2' , '0' , '4.83' , '4.83' , '' , '3' , '9.3702' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20836' , 'BRUCIA INCENSO CM 16' , '1' , '1' , '0' , '7.03' , '7.03' , '' , '3' , '6.8191' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20837' , 'BRUCIA INCENSO CM 11' , '1' , '1' , '0' , '9.8' , '9.8' , '' , '3' , '9.5060' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '18024' , 'TURIBOLO H 27' , '1' , '1' , '0' , '79.51' , '79.51' , '' , '3' , '77.1247' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20838' , 'RELIQUIARIO DORATO CM 22' , '1' , '1' , '0' , '53.69' , '53.69' , '' , '3' , '52.0793' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '18019' , 'RELIQUIARIO DORATO H 18' , '1' , '1' , '0' , '33.42' , '33.42' , '' , '3' , '32.4174' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '20839' , 'RELIQUIARIO DORATO CM 19,5' , '1' , '1' , '0' , '23.62' , '23.62' , '' , '3' , '22.9114' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '18164' , 'RELIQUIARIO H 28' , '1' , '1' , '0' , '72.61' , '72.61' , '' , '3' , '70.4317' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '18168' , 'SCATOLA PORTAOSTIE ' , '1' , '1' , '0' , '15.89' , '15.89' , '' , '3' , '15.4133' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '18905' , 'PORTA TURIBOLO CM 147' , '1' , '1' , '0' , '139.17' , '139.17' , '' , '3' , '134.9949' ) 10/03/2023 05:42:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82237' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '4' , '35.8' , '35.8' , '0' , '3' , '34.7260' ) 10/03/2023 05:50:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '2590' , '2023-03-10' , '' , '0' , '105' , '4668972' , 'VIA NUOVA DELLE BRECCE, 214 80147 NAPOLI' , '' , '' , '7.62' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '166.45' , '166.45' , NOW() , NOW() ) 10/03/2023 05:50:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82254' 10/03/2023 05:50:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '82254' 10/03/2023 05:50:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82254' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '1' , '4' , '16.90' , '16.9' , '0' , '30' , '11.8300' ) 10/03/2023 05:50:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20494' AND id_supplier = '105' 10/03/2023 05:50:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20494' , '105' , '1' ) 10/03/2023 05:50:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82254' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '15' , '15' , '4' , '14.00' , '14' , '0' , '30' , '147.0000' ) 10/03/2023 05:50:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20745' AND id_supplier = '105' 10/03/2023 05:50:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20745' , '105' , '1' ) 10/03/2023 06:08:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001782' AND id_product != '18561' AND ean13 != '' 10/03/2023 06:08:04 pm >> UPDATE ps_product SET id_supplier = '13', reference = '', ean13 = '001782', date_upd = NOW() WHERE id_product = '18561' 10/03/2023 06:08:04 pm >> UPDATE ps_product_lang SET name = 'FORMELLA SAGOMATA 26X26 - TENERO ABBRACCIO 1025130', description = '' WHERE id_product = '18561' 10/03/2023 06:08:04 pm >> UPDATE ps_product SET wholesale_price = '29.97', on_sale = '0', price = '72.95081967213115' WHERE id_product = '18561' 10/03/2023 06:08:04 pm >> UPDATE ps_product_shop SET wholesale_price = '29.97', price = '72.95081967213115', id_tax_rules_group = '1', id_category_default = '192', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18561' 10/03/2023 06:08:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '18561'