19/09/2022 09:33:58 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' , '2585' , '2022-09-12' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '2264.50' , '2264.50' , NOW() , NOW() ) 19/09/2022 09:33:58 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 = '61849' 19/09/2022 09:33:58 am >> DELETE FROM ps_document_detail WHERE id_document = '61849' 19/09/2022 09:33:58 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 ( '61849' , '5444' , 'IO SONO CON VOI - CAT.' , '250' , '250' , '4' , '5.50' , '5.5' , '0' , '30' , '962.5000' ) 19/09/2022 09:33:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '79' 19/09/2022 09:33:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '79' , '1' ) 19/09/2022 09:33:58 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 ( '61849' , '11193' , 'VENITE CON ME CAT.' , '150' , '150' , '4' , '5.50' , '5.5' , '0' , '30' , '577.5000' ) 19/09/2022 09:33:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '79' 19/09/2022 09:33:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '79' , '1' ) 19/09/2022 09:33:58 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 ( '61849' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '150' , '150' , '4' , '5.50' , '5.5' , '0' , '30' , '577.5000' ) 19/09/2022 09:33:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '79' 19/09/2022 09:33:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '79' , '1' ) 19/09/2022 09:33:58 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 ( '61849' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '2' , '2' , '4' , '35.00' , '35' , '0' , '30' , '49.0000' ) 19/09/2022 09:33:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '5887' AND id_supplier = '79' 19/09/2022 09:33:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5887' , '79' , '1' ) 19/09/2022 09:33:58 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 ( '61849' , '5888' , 'LITURGIA DELLE ORE - VOL. II - PER SACERDOTI E RELIGIOSI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 19/09/2022 09:33:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '5888' AND id_supplier = '79' 19/09/2022 09:33:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5888' , '79' , '1' ) 19/09/2022 09:33:58 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 ( '61849' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 19/09/2022 09:33:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '5889' AND id_supplier = '79' 19/09/2022 09:33:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5889' , '79' , '1' ) 19/09/2022 09:33:58 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 ( '61849' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '2' , '2' , '4' , '35.00' , '35' , '0' , '30' , '49.0000' ) 19/09/2022 09:33:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '79' 19/09/2022 09:33:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '79' , '1' ) 19/09/2022 09:57:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2775' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-19') 19/09/2022 09:57:13 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' , '2775' , '2022-09-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '154.00' , '126.95' , NOW() , NOW() ) 19/09/2022 09:57:13 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 = '61850' 19/09/2022 09:57:13 am >> DELETE FROM ps_document_detail WHERE id_document = '61850' 19/09/2022 09:57:13 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 ( '61850' , '19197' , 'STOLA DIACONALE MARIANA - 1028AM DP' , '1' , '-1' , '1' , '150.00' , '122.95081967213' , '22' , '0' , '150.00' ) 19/09/2022 09:57:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19197' AND id_supplier = '' 19/09/2022 09:57:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19197' , '' , '1' ) 19/09/2022 09:57:14 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 ( '61850' , '18721' , 'PER UNA CHIESA SINODALE' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 19/09/2022 09:57:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '18721' AND id_supplier = '' 19/09/2022 09:57:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18721' , '' , '1' ) 19/09/2022 10:05:42 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' , '891' , '2022-09-16' , '' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '491.05' , '402.50' , NOW() , NOW() ) 19/09/2022 10:05:42 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 = '61851' 19/09/2022 10:05:42 am >> DELETE FROM ps_document_detail WHERE id_document = '61851' 19/09/2022 10:05:42 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 ( '61851' , '18880' , 'COPRILEGGIO MORELLO' , '2' , '2' , '1' , '23' , '18.852459016393' , '22' , '0' , '56.1200' ) 19/09/2022 10:05:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '18880' AND id_supplier = '122' 19/09/2022 10:05:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18880' , '122' , '1' ) 19/09/2022 10:05:42 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 ( '61851' , '16731' , 'COPRILEGGIO CROCE ORO - AVCL01' , '1' , '1' , '1' , '23' , '18.852459016393' , '22' , '0' , '28.0600' ) 19/09/2022 10:05:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '16731' AND id_supplier = '122' 19/09/2022 10:05:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16731' , '122' , '1' ) 19/09/2022 10:05:42 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 ( '61851' , '18881' , 'STOLA POLIESTERE - PST020' , '40' , '40' , '1' , '7.6' , '6.2295081967213' , '22' , '0' , '370.8800' ) 19/09/2022 10:05:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '18881' AND id_supplier = '122' 19/09/2022 10:05:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18881' , '122' , '1' ) 19/09/2022 10:05:42 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 ( '61851' , '17101' , 'CASULA POLIESTERE CROCE ORO - AECU04' , '1' , '1' , '1' , '29.5' , '24.180327868852' , '22' , '0' , '35.9900' ) 19/09/2022 10:05:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '17101' AND id_supplier = '122' 19/09/2022 10:05:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17101' , '122' , '1' ) 19/09/2022 10:07:57 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/09/2022 10:07:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19961' , '1' , '' , 'nuovo-prodotto' ) 19/09/2022 10:07:57 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19961' , '1' , '1' , '2' , NOW() , NOW() ) 19/09/2022 10:07:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19961' , '0' , '1' , '0' , '0' ) 19/09/2022 10:09:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000325' AND id_product != '19961' AND ean13 != '' 19/09/2022 10:09:24 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000325', date_upd = NOW() WHERE id_product = '19961' 19/09/2022 10:09:24 am >> UPDATE ps_product_lang SET name = 'AMITTO M/LANA - 099', description = '' WHERE id_product = '19961' 19/09/2022 10:09:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '31.9672131147541' WHERE id_product = '19961' 19/09/2022 10:09:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '31.9672131147541', id_tax_rules_group = '1', id_category_default = '499', 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 = '19961' 19/09/2022 10:09:24 am >> DELETE FROM ps_specific_price WHERE id_product = '19961' 19/09/2022 10:10: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 ( '31' , '870' , '2022-09-08' , '' , '0' , '163' , '4674530' , 'VIA CORTI 29 24126 BERGAMO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '295.24' , '242.00' , NOW() , NOW() ) 19/09/2022 10:10: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 = '61852' 19/09/2022 10:10:01 am >> DELETE FROM ps_document_detail WHERE id_document = '61852' 19/09/2022 10:10: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 ( '61852' , '19799' , 'CAMICE MARIANO IN LANA - 0774/06' , '2' , '2' , '1' , '113' , '92.622950819672' , '22' , '0' , '275.7200' ) 19/09/2022 10:10:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19799' AND id_supplier = '163' 19/09/2022 10:10:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19799' , '163' , '1' ) 19/09/2022 10:10: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 ( '61852' , '19961' , 'AMITTO M/LANA - 099' , '1' , '1' , '1' , '16' , '13.114754098361' , '22' , '0' , '19.5200' ) 19/09/2022 10:10:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19961' AND id_supplier = '163' 19/09/2022 10:10:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19961' , '163' , '1' ) 19/09/2022 10:11:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000325' AND id_product != '19961' AND ean13 != '' 19/09/2022 10:11:51 am >> UPDATE ps_product SET id_supplier = '163', reference = '', ean13 = '000325', date_upd = NOW() WHERE id_product = '19961' 19/09/2022 10:11:51 am >> UPDATE ps_product_lang SET name = 'AMITTO M/LANA - 099', description = '' WHERE id_product = '19961' 19/09/2022 10:11:51 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.78688524590164' WHERE id_product = '19961' 19/09/2022 10:11:51 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32.78688524590164', id_tax_rules_group = '1', id_category_default = '499', 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 = '19961' 19/09/2022 10:11:51 am >> DELETE FROM ps_specific_price WHERE id_product = '19961' 19/09/2022 10:14:43 am >> SELECT document_num FROM ps_document WHERE document_num = '60' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-19') 19/09/2022 10:14:43 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' , '60' , '2022-09-19' , '' , '3481' , '0' , '4670260' , 'LARGO MADONNA DELLE GRAZIE 8 66050 MONTEODORISIO' , '' , '' , '4.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '39.10' , '39.10' , NOW() , NOW() ) 19/09/2022 10:14:43 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 = '6075' 19/09/2022 10:14:43 am >> DELETE FROM ps_document_detail WHERE id_document = '6075' 19/09/2022 10:14:43 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 ( '6075' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '5' , '34.20' ) 19/09/2022 10:28:10 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/09/2022 10:28:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19962' , '1' , '' , 'nuovo-prodotto' ) 19/09/2022 10:28:10 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19962' , '1' , '1' , '2' , NOW() , NOW() ) 19/09/2022 10:28:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19962' , '0' , '1' , '0' , '0' ) 19/09/2022 10:28:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878792975' AND id_product != '19962' AND ean13 != '' 19/09/2022 10:28:45 am >> UPDATE ps_product SET id_supplier = '', reference = '10/2', ean13 = '9788878792975', date_upd = NOW() WHERE id_product = '19962' 19/09/2022 10:28:45 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - NOV 2022', description = '' WHERE id_product = '19962' 19/09/2022 10:28:45 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.278688524590164' WHERE id_product = '19962' 19/09/2022 10:28:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.278688524590164', id_tax_rules_group = '1', id_category_default = '271', 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 = '19962' 19/09/2022 10:28:45 am >> DELETE FROM ps_specific_price WHERE id_product = '19962' 19/09/2022 10:28:46 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 = '19962' 19/09/2022 10:28:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19963' , '1' , '' , 'nuovo-prodotto' ) 19/09/2022 10:28:46 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 '19963' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19962' 19/09/2022 10:28:46 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19963' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19962' 19/09/2022 10:29:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878792982' AND id_product != '19963' AND ean13 != '' 19/09/2022 10:29:11 am >> UPDATE ps_product SET id_supplier = '', reference = '10/2', ean13 = '9788878792982', date_upd = NOW() WHERE id_product = '19963' 19/09/2022 10:29:11 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - DIC 2022', description = '' WHERE id_product = '19963' 19/09/2022 10:29:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '19963' 19/09/2022 10:29:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '271', 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 = '19963' 19/09/2022 10:29:11 am >> DELETE FROM ps_specific_price WHERE id_product = '19963' 19/09/2022 10:29:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788878792975' AND id_product != '19962' AND ean13 != '' 19/09/2022 10:29:22 am >> UPDATE ps_product SET id_supplier = '', reference = '10/2', ean13 = '9788878792975', date_upd = NOW() WHERE id_product = '19962' 19/09/2022 10:29:22 am >> UPDATE ps_product_lang SET name = 'MESSA MEDITAZIONE - NOV 2022', description = '' WHERE id_product = '19962' 19/09/2022 10:29:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '19962' 19/09/2022 10:29:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '271', 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 = '19962' 19/09/2022 10:29:22 am >> DELETE FROM ps_specific_price WHERE id_product = '19962' 19/09/2022 10:29:44 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 ( '31' , '607/22' , '2022-09-12' , '22' , '0' , '40' , '2635' , 'VIA VIRGINIA AGNELLI, 100 00151 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '43.20' , '43.20' , NOW() , NOW() ) 19/09/2022 10:29:44 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 = '61853' 19/09/2022 10:29:44 am >> DELETE FROM ps_document_detail WHERE id_document = '61853' 19/09/2022 10:29:44 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 ( '61853' , '19962' , 'MESSA MEDITAZIONE - NOV 2022' , '9' , '9' , '4' , '4.00' , '4' , '0' , '40' , '21.6000' ) 19/09/2022 10:29:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19962' AND id_supplier = '40' 19/09/2022 10:29:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19962' , '40' , '1' ) 19/09/2022 10:29:44 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 ( '61853' , '19963' , 'MESSA MEDITAZIONE - DIC 2022' , '9' , '9' , '4' , '4.00' , '4' , '0' , '40' , '21.6000' ) 19/09/2022 10:29:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19963' AND id_supplier = '40' 19/09/2022 10:29:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19963' , '40' , '1' ) 19/09/2022 11:04:05 am >> DELETE FROM ps_document WHERE id_document = '61069' 19/09/2022 11:04:05 am >> DELETE FROM ps_document_detail WHERE id_document = '61069' 19/09/2022 11:22:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801052640' AND id_product != '9471' AND ean13 != '' 19/09/2022 11:22:32 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/4', ean13 = '9788801052640', date_upd = NOW() WHERE id_product = '9471' 19/09/2022 11:22:32 am >> UPDATE ps_product_lang SET name = 'SAN LORENZO MARTIRE - G.PESENTI', description = '' WHERE id_product = '9471' 19/09/2022 11:22:32 am >> UPDATE ps_product SET wholesale_price = '2.28', on_sale = '0', price = '5' WHERE id_product = '9471' 19/09/2022 11:22:32 am >> UPDATE ps_product_shop SET wholesale_price = '2.28', price = '5', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9471' 19/09/2022 11:22:32 am >> DELETE FROM ps_specific_price WHERE id_product = '9471' 19/09/2022 11:36:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2776' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-19') 19/09/2022 11:36:03 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' , '2776' , '2022-09-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 19/09/2022 11:36:03 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 = '61854' 19/09/2022 11:36:03 am >> DELETE FROM ps_document_detail WHERE id_document = '61854' 19/09/2022 11:36:03 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 ( '61854' , '19625' , 'CROCIFISSO CM 30 - 1004' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '0' , '38.00' ) 19/09/2022 11:36:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19625' AND id_supplier = '' 19/09/2022 11:36:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19625' , '' , '1' ) 19/09/2022 11:40:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801037470' AND id_product != '9555' AND ean13 != '' 19/09/2022 11:40:14 am >> UPDATE ps_product SET id_supplier = '17', reference = '6/4', ean13 = '9788801037470', date_upd = NOW() WHERE id_product = '9555' 19/09/2022 11:40:14 am >> UPDATE ps_product_lang SET name = 'SANTA ELISABETTA D\'UNGHERIA - L. CAVAGNA', description = '' WHERE id_product = '9555' 19/09/2022 11:40:14 am >> UPDATE ps_product SET wholesale_price = '2.00', on_sale = '0', price = '4.0000' WHERE id_product = '9555' 19/09/2022 11:40:14 am >> UPDATE ps_product_shop SET wholesale_price = '2.00', price = '4.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9555' 19/09/2022 11:40:14 am >> DELETE FROM ps_specific_price WHERE id_product = '9555' 19/09/2022 11:40:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801049053' AND id_product != '9490' AND ean13 != '' 19/09/2022 11:40:37 am >> UPDATE ps_product SET id_supplier = '17', reference = '6/4', ean13 = '9788801049053', date_upd = NOW() WHERE id_product = '9490' 19/09/2022 11:40:38 am >> UPDATE ps_product_lang SET name = 'SAN NICOLA - A. D\'URSO', description = '' WHERE id_product = '9490' 19/09/2022 11:40:38 am >> UPDATE ps_product SET wholesale_price = '2.00', on_sale = '0', price = '4.0000' WHERE id_product = '9490' 19/09/2022 11:40:38 am >> UPDATE ps_product_shop SET wholesale_price = '2.00', price = '4.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9490' 19/09/2022 11:40:38 am >> DELETE FROM ps_specific_price WHERE id_product = '9490' 19/09/2022 11:41:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801054903' AND id_product != '9438' AND ean13 != '' 19/09/2022 11:41:09 am >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9788801054903', date_upd = NOW() WHERE id_product = '9438' 19/09/2022 11:41:09 am >> UPDATE ps_product_lang SET name = 'SAN GENNARO VESCOVO', description = '' WHERE id_product = '9438' 19/09/2022 11:41:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '9438' 19/09/2022 11:41:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9438' 19/09/2022 11:41:09 am >> DELETE FROM ps_specific_price WHERE id_product = '9438' 19/09/2022 11:41:48 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/09/2022 11:41:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19964' , '1' , '' , 'nuovo-prodotto' ) 19/09/2022 11:41:48 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19964' , '1' , '1' , '2' , NOW() , NOW() ) 19/09/2022 11:41:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19964' , '0' , '1' , '0' , '0' ) 19/09/2022 11:43:25 am >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 19/09/2022 11:43:25 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '501' , '1' ) 19/09/2022 11:43:25 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '501' , '2' ) 19/09/2022 11:43:25 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '501' , '3' ) 19/09/2022 11:43:25 am >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '501' , '1' , 'VELAR' , LOWER('VELAR') ) 19/09/2022 11:43:25 am >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '501' , '1' , '0' ) 19/09/2022 11:43:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788866719403' AND id_product != '19964' AND ean13 != '' 19/09/2022 11:43:36 am >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9788866719403', date_upd = NOW() WHERE id_product = '19964' 19/09/2022 11:43:36 am >> UPDATE ps_product_lang SET name = 'SANTA MARIA GORETTI - G. ALBERTI', description = '' WHERE id_product = '19964' 19/09/2022 11:43:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '19964' 19/09/2022 11:43:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '501', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19964' 19/09/2022 11:43:36 am >> DELETE FROM ps_specific_price WHERE id_product = '19964' 19/09/2022 11:53: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' , '138/22' , '2022-09-16' , '22' , '0' , '0' , '4671003' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.75' , '19.75' , NOW() , NOW() ) 19/09/2022 11:53: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 = '61855' 19/09/2022 11:53:46 am >> DELETE FROM ps_document_detail WHERE id_document = '61855' 19/09/2022 11:53: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 ( '61855' , '9471' , 'SAN LORENZO MARTIRE - G.PESENTI' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.5000' ) 19/09/2022 11:53: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 ( '61855' , '9555' , 'SANTA ELISABETTA DUNGHERIA - L. CAVAGNA' , '1' , '1' , '4' , '4.00' , '4' , '0' , '50' , '2.0000' ) 19/09/2022 11:53: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 ( '61855' , '9490' , 'SAN NICOLA - A. DURSO' , '1' , '1' , '4' , '4.00' , '4' , '0' , '50' , '2.0000' ) 19/09/2022 11:53: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 ( '61855' , '9479' , 'SAN MATTEO APOSTOLO ED EVANGELISTA' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 19/09/2022 11:53: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 ( '61855' , '9438' , 'SAN GENNARO VESCOVO' , '1' , '1' , '4' , '4.00' , '4' , '0' , '50' , '2.0000' ) 19/09/2022 11:53: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 ( '61855' , '9593' , 'SANTA MONICA - R.PICCOLOMINI' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.7500' ) 19/09/2022 11:53: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 ( '61855' , '19666' , 'DON TONINO BELLO - A. GIORGIO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.5000' ) 19/09/2022 11:53: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 ( '61855' , '19964' , 'SANTA MARIA GORETTI - G. ALBERTI' , '1' , '1' , '4' , '7.00' , '7' , '0' , '50' , '3.5000' ) 19/09/2022 12:00:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2777' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-19') 19/09/2022 12:00:32 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' , '2777' , '2022-09-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 19/09/2022 12:00:32 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 = '61856' 19/09/2022 12:00:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '61856' 19/09/2022 12:00:32 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 ( '61856' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '15' , '-15' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '7.50' ) 19/09/2022 12:00:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 19/09/2022 12:00:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 19/09/2022 12:04: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 ( '33' , '337' , '2022-09-16' , '' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1250.00' , '1250.00' , NOW() , NOW() ) 19/09/2022 12:04: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 = '61857' 19/09/2022 12:04:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '61857' 19/09/2022 12:04: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 ( '61857' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '500' , '500' , '4' , '2.50' , '2.5' , '0' , '0' , '1250.0000' ) 19/09/2022 12:04:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19730' AND id_supplier = '145' 19/09/2022 12:04:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19730' , '145' , '1' ) 19/09/2022 12:05:30 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' , '342' , '2022-09-16' , '' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1250.00' , '1250.00' , NOW() , NOW() ) 19/09/2022 12:05:30 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 = '61858' 19/09/2022 12:05:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '61858' 19/09/2022 12:05:30 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 ( '61858' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '500' , '500' , '4' , '2.50' , '2.5' , '0' , '0' , '1250.0000' ) 19/09/2022 12:05:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19872' AND id_supplier = '145' 19/09/2022 12:05:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19872' , '145' , '1' ) 19/09/2022 12:33:49 pm >> DELETE FROM ps_product WHERE id_product = '872' 19/09/2022 12:33:49 pm >> DELETE FROM ps_product_shop WHERE id_product = '872' 19/09/2022 12:33:49 pm >> DELETE FROM ps_product_lang WHERE id_product = '872' 19/09/2022 12:33:49 pm >> DELETE FROM ps_stock_available WHERE id_product = '872' 19/09/2022 12:34:19 pm >> DELETE FROM ps_product WHERE id_product = '7497' 19/09/2022 12:34:19 pm >> DELETE FROM ps_product_shop WHERE id_product = '7497' 19/09/2022 12:34:19 pm >> DELETE FROM ps_product_lang WHERE id_product = '7497' 19/09/2022 12:34:19 pm >> DELETE FROM ps_stock_available WHERE id_product = '7497' 19/09/2022 12:41:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2778' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-19') 19/09/2022 12:41:34 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' , '2778' , '2022-09-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.90' , '32.60' , NOW() , NOW() ) 19/09/2022 12:41: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 = '61859' 19/09/2022 12:41:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '61859' 19/09/2022 12:41: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 ( '61859' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 19/09/2022 12:41:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 19/09/2022 12:41:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 19/09/2022 12:41: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 ( '61859' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '11.40' ) 19/09/2022 12:41:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 19/09/2022 12:41:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 19/09/2022 12:41: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 ( '61859' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '12.00' ) 19/09/2022 12:41:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 19/09/2022 12:41:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 19/09/2022 04:18:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2779' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-19') 19/09/2022 04:18:39 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' , '2779' , '2022-09-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.55' , '8.55' , NOW() , NOW() ) 19/09/2022 04:18:39 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 = '61860' 19/09/2022 04:18:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '61860' 19/09/2022 04:18:40 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 ( '61860' , '19959' , 'PREGHIERE PER DUE' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 19/09/2022 04:18:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19959' AND id_supplier = '' 19/09/2022 04:18:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19959' , '' , '1' ) 19/09/2022 04:50:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '69/A' AND id_document != '61813' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-15') 19/09/2022 04:50:34 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '69/A', document_date = '2022-09-15', document_letter = 'A', id_customer = '2624', id_supplier = '', id_address = '4670911', address1 = 'P. ZZA ANNUNZIATA 84095 GIFFONI VALLE PIANA', address2 = '', note = 'SCONTO 10%', 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 = '90.00', price_tax_excluded = '90.00', date_upd = NOW() WHERE id_document = '61813' 19/09/2022 04:50: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 = '61813' 19/09/2022 04:50:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '61813' 19/09/2022 04:50: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 ( '61813' , '3649' , 'DON ERNEST SIMONI - M. MUOLO' , '8' , '-8' , '4' , '12.5000' , '12.5' , '0' , '10' , '90.00' ) 19/09/2022 04:50:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3649' AND id_supplier = '' 19/09/2022 04:50:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3649' , '' , '1' ) 19/09/2022 04:51:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2780' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-19') 19/09/2022 04:51:02 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' , '2780' , '2022-09-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '90.00' , NOW() , NOW() ) 19/09/2022 04:51: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 = '61861' 19/09/2022 04:51:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '61861' 19/09/2022 04:51: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 ( '61861' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '90' , '90' , '0' , '0' , '90.00' ) 19/09/2022 04:51:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 19/09/2022 04:51:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 19/09/2022 04:51:34 pm >> DELETE FROM ps_document WHERE id_document = '61813' 19/09/2022 04:51:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '61813' 19/09/2022 04:51:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2780' AND id_document != '61861' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-19') 19/09/2022 04:51:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2780', document_date = '2022-09-19', 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 = '72.00', price_tax_excluded = '72.00', date_upd = NOW() WHERE id_document = '61861' 19/09/2022 04:51:55 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 = '61861' 19/09/2022 04:51:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '61861' 19/09/2022 04:51:55 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 ( '61861' , '3649' , 'DON ERNEST SIMONI - M. MUOLO' , '8' , '-8' , '4' , '9' , '9' , '0' , '0' , '72.00' ) 19/09/2022 04:51:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3649' AND id_supplier = '' 19/09/2022 04:51:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3649' , '' , '1' ) 19/09/2022 05:22:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2781' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-19') 19/09/2022 05:22:59 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' , '2781' , '2022-09-19' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.40' , '1.15' , NOW() , NOW() ) 19/09/2022 05:22:59 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 = '61862' 19/09/2022 05:22:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '61862' 19/09/2022 05:22:59 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 ( '61862' , '18274' , 'BRACCIALE A NODI - 2610' , '1' , '-1' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '1.40' ) 19/09/2022 05:22:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18274' AND id_supplier = '' 19/09/2022 05:22:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18274' , '' , '1' ) 19/09/2022 06:33:31 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3045' 19/09/2022 06:33:31 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3045' , '10' , '200' , 'PARR. B. V. DEL ROSARIO' , '' , '' , 'VIA MAESTRI DEL LAVORO, 17' , '' , '85100' , 'POTENZA' , 'SPEDIZIONE: NICO TAMBURRINO - VIA SAN CONO 93B - 85100 POTENZA\r\nPARROCO P. VALENTINO INCAMPO - TEL 3336412718' , '3792330488' , '3475347370' , '' , '80007760764' , NOW() , NOW() ) 19/09/2022 06:33:31 pm >> UPDATE ps_customer SET email = 'verginedelrosariopotenza@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3045' 19/09/2022 06:42:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '117' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-19') 19/09/2022 06:42:22 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' , '117' , '2022-09-19' , '' , '3045' , '0' , '4671988' , 'VIA MAESTRI DEL LAVORO, 17 85100 POTENZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '280.35' , '280.35' , NOW() , NOW() ) 19/09/2022 06:42:22 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 = '61863' 19/09/2022 06:42:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '61863' 19/09/2022 06:42:22 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 ( '61863' , '11193' , 'VENITE CON ME CAT.' , '20' , '-20' , '4' , '5.50' , '5.5' , '0' , '10' , '99.00' ) 19/09/2022 06:42:22 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 ( '61863' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '25' , '-25' , '4' , '5.50' , '5.5' , '0' , '10' , '123.75' ) 19/09/2022 06:42:22 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 ( '61863' , '12819' , 'REGISTRO DEL CATECHISTA ' , '14' , '-14' , '0' , '1.00' , '1' , '' , '10' , '12.60' ) 19/09/2022 06:42:22 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 ( '61863' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '50' , '-50' , '0' , '0.50' , '0.5' , '' , '10' , '22.50' ) 19/09/2022 06:42:22 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 ( '61863' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '50' , '-50' , '0' , '0.50' , '0.5' , '' , '10' , '22.50' ) 19/09/2022 06:47:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '117' AND id_document != '61863' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-19') 19/09/2022 06:47:55 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '117', document_date = '2022-09-19', document_letter = '', id_customer = '3045', id_supplier = '', id_address = '4671988', address1 = 'VIA MAESTRI DEL LAVORO, 17 85100 POTENZA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '280.35', price_tax_excluded = '280.35', date_upd = NOW() WHERE id_document = '61863' 19/09/2022 06:47:55 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 = '61863' 19/09/2022 06:47:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '61863' 19/09/2022 06:47:55 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 ( '61863' , '11193' , 'VENITE CON ME CAT.' , '20' , '-20' , '4' , '5.5000' , '5.5' , '0' , '10' , '99.00' ) 19/09/2022 06:47:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 19/09/2022 06:47:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 19/09/2022 06:47:55 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 ( '61863' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '25' , '-25' , '4' , '5.5000' , '5.5' , '0' , '10' , '123.75' ) 19/09/2022 06:47:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '' 19/09/2022 06:47:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' ) 19/09/2022 06:47:55 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 ( '61863' , '12819' , 'REGISTRO DEL CATECHISTA ' , '14' , '-14' , '0' , '1.0000' , '1' , '0' , '10' , '12.60' ) 19/09/2022 06:47:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 19/09/2022 06:47:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 19/09/2022 06:47:55 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 ( '61863' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '50' , '-50' , '0' , '0.5000' , '0.5' , '0' , '10' , '22.50' ) 19/09/2022 06:47:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 19/09/2022 06:47:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 19/09/2022 06:47:55 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 ( '61863' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '50' , '-50' , '0' , '0.5000' , '0.5' , '0' , '10' , '22.50' ) 19/09/2022 06:47:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 19/09/2022 06:47:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' )