10/08/2023 08:51:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048578' AND id_product != '21478' AND ean13 != '' 10/08/2023 08:51:47 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884048578', date_upd = NOW() WHERE id_product = '21478' 10/08/2023 08:51:48 am >> UPDATE ps_product_lang SET name = 'PILASTRI DELLA FEDE - 8474', description = '' WHERE id_product = '21478' 10/08/2023 08:51:48 am >> UPDATE ps_product SET wholesale_price = '7.20', on_sale = '0', price = '12.0000' WHERE id_product = '21478' 10/08/2023 08:51:48 am >> UPDATE ps_product_shop SET wholesale_price = '7.20', price = '12.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21478' 10/08/2023 08:51:48 am >> DELETE FROM ps_specific_price WHERE id_product = '21478' 10/08/2023 09:18:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2606' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-10') 10/08/2023 09:18: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 ( '11' , '2606' , '2023-08-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.50' , '43.03' , NOW() , NOW() ) 10/08/2023 09:18: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 = '87033' 10/08/2023 09:18:52 am >> DELETE FROM ps_document_detail WHERE id_document = '87033' 10/08/2023 09:18:53 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 ( '87033' , '20074' , 'ROSARIO ARG/PERLA/EMATITE ' , '1' , '-1' , '1' , '48.00' , '39.344262295082' , '22' , '0' , '48.00' ) 10/08/2023 09:18:53 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 ( '87033' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 10/08/2023 09:18:53 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 ( '87033' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 10/08/2023 09:18:53 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 ( '87033' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 10/08/2023 09:30:46 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'Zrf7c34Ltdj60kst' , NOW() , NOW() ) 10/08/2023 09:30:46 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4024' , '1' ) 10/08/2023 09:30:46 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4024' , '2' ) 10/08/2023 09:30:46 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4024' , '3' ) 10/08/2023 09:31:58 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4024' 10/08/2023 09:31:58 am >> 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 ( '4024' , '10' , '217' , '' , 'TRASATTI' , 'ROBERTA ' , 'VIA VEZZOLA 15/17' , '' , '64014' , 'MARTINSICURO' , '' , '' , '3348016301' , '' , '' , NOW() , NOW() ) 10/08/2023 09:31:58 am >> UPDATE ps_customer SET email = 'roberta.trasatti3@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4024' 10/08/2023 09:32:37 am >> SELECT document_num FROM ps_document WHERE document_num = '109' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-08-10') 10/08/2023 09:32:37 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' , '109' , '2023-08-10' , '' , '4024' , '0' , '4679070' , 'VIA VEZZOLA 15/17 64014 MARTINSICURO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '16.70' , '16.70' , NOW() , NOW() ) 10/08/2023 09:32:37 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 = '87034' 10/08/2023 09:32:37 am >> DELETE FROM ps_document_detail WHERE id_document = '87034' 10/08/2023 09:32:37 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 ( '87034' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 10/08/2023 09:32:37 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 ( '87034' , '13506' , 'SANTO ROSARIO' , '1' , '-1' , '4' , '0.30' , '0.3' , '0' , '0' , '0.30' ) 10/08/2023 10:03:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2607' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-10') 10/08/2023 10:03:48 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' , '2607' , '2023-08-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.35' , '12.35' , NOW() , NOW() ) 10/08/2023 10:03:48 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 = '87035' 10/08/2023 10:03:48 am >> DELETE FROM ps_document_detail WHERE id_document = '87035' 10/08/2023 10:03:48 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 ( '87035' , '21185' , 'RIPORTARE I GIOVANI A MESSA - A. MATTEO' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 10/08/2023 10:59:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2608' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-08-10') 10/08/2023 10:59:45 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' , '2608' , '2023-08-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 10/08/2023 10:59:45 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 = '87036' 10/08/2023 10:59:45 am >> DELETE FROM ps_document_detail WHERE id_document = '87036' 10/08/2023 10:59:45 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 ( '87036' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 10/08/2023 11:41:31 am >> SELECT document_num FROM ps_document WHERE document_num = '2609' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-08-10') 10/08/2023 11:41:31 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' , '2609' , '2023-08-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.52' , '30.52' , NOW() , NOW() ) 10/08/2023 11:41:31 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 = '87037' 10/08/2023 11:41:31 am >> DELETE FROM ps_document_detail WHERE id_document = '87037' 10/08/2023 11:41:31 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 ( '87037' , '21197' , 'PAROLA E PREGHIERA - SET 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 10/08/2023 11:41:31 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 ( '87037' , '21433' , 'PAROLA E PREGHIERA - OTT 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 10/08/2023 11:41:31 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 ( '87037' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '25' , '25' , '0' , '0' , '25.00' ) 10/08/2023 11:44:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2610' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2023-08-10') 10/08/2023 11:44:30 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' , '2610' , '2023-08-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.05' , '45.05' , NOW() , NOW() ) 10/08/2023 11:44:30 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 = '87038' 10/08/2023 11:44:30 am >> DELETE FROM ps_document_detail WHERE id_document = '87038' 10/08/2023 11:44:30 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 ( '87038' , '21409' , 'SUBLIMITAS ET MISERIA HOMINIS' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 10/08/2023 11:44:30 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 ( '87038' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 10/08/2023 11:44:30 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 ( '87038' , '13418' , 'AD RESURGENDUM CUM CHRISTO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/08/2023 11:44:30 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 ( '87038' , '17702' , 'BENEDETTO XVI - P. SEEWALD' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '5' , '38.00' ) 10/08/2023 11:53:31 am >> SELECT document_num FROM ps_document WHERE document_num = '2611' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-10') 10/08/2023 11:53:31 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' , '2611' , '2023-08-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 10/08/2023 11:53:31 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 = '87039' 10/08/2023 11:53:31 am >> DELETE FROM ps_document_detail WHERE id_document = '87039' 10/08/2023 11:53:31 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 ( '87039' , '4915' , 'ICONA SU TELA LEGNO MADONNA NODI CM 22X16,5 - AN025 MN' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 10/08/2023 12:04:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2612' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-10') 10/08/2023 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 ( '11' , '2612' , '2023-08-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 10/08/2023 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 = '87040' 10/08/2023 12:04:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '87040' 10/08/2023 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 ( '87040' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' )