24/07/2025 09:15:57 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 24/07/2025 09:15:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23892' , '1' , '' , 'nuovo-prodotto' ) 24/07/2025 09:15:57 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23892' , '1' , '1' , '2' , NOW() , NOW() ) 24/07/2025 09:15:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23892' , '0' , '1' , '0' , '0' ) 24/07/2025 09:17:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000287' AND id_product != '23892' AND ean13 != '' 24/07/2025 09:17:00 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000287', date_upd = NOW() WHERE id_product = '23892' 24/07/2025 09:17:00 am >> UPDATE ps_product_lang SET name = 'CROCE S. BENEDETTO - 730', description = '' WHERE id_product = '23892' 24/07/2025 09:17:00 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.098360655737705' WHERE id_product = '23892' 24/07/2025 09:17:00 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.098360655737705', id_tax_rules_group = '1', id_category_default = '95', 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 = '23892' 24/07/2025 09:17:00 am >> DELETE FROM ps_specific_price WHERE id_product = '23892' 24/07/2025 09:17:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000287' AND id_product != '23892' AND ean13 != '' 24/07/2025 09:17:27 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000287', date_upd = NOW() WHERE id_product = '23892' 24/07/2025 09:17:27 am >> UPDATE ps_product_lang SET name = 'CROCE S. BENEDETTO - 730', description = '' WHERE id_product = '23892' 24/07/2025 09:17:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = 'NaN' WHERE id_product = '23892' 24/07/2025 09:17:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = 'NaN', id_tax_rules_group = '1', id_category_default = '95', 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 = '23892' 24/07/2025 09:17:27 am >> DELETE FROM ps_specific_price WHERE id_product = '23892' 24/07/2025 09:17:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000287' AND id_product != '23892' AND ean13 != '' 24/07/2025 09:17:44 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000287', date_upd = NOW() WHERE id_product = '23892' 24/07/2025 09:17:44 am >> UPDATE ps_product_lang SET name = 'CROCE S. BENEDETTO - 730', description = '' WHERE id_product = '23892' 24/07/2025 09:17:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.6885245901639343' WHERE id_product = '23892' 24/07/2025 09:17:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.6885245901639343', id_tax_rules_group = '1', id_category_default = '95', 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 = '23892' 24/07/2025 09:17:44 am >> DELETE FROM ps_specific_price WHERE id_product = '23892' 24/07/2025 09:22: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 ( '31' , 'A3034' , '2025-07-22' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '13' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '286.07' , '234.48' , NOW() , NOW() ) 24/07/2025 09:22: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 = '98212' 24/07/2025 09:22:45 am >> DELETE FROM ps_document_detail WHERE id_document = '98212' 24/07/2025 09:22: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 ( '98212' , '23099' , 'TELA 18X25 ACUTIS - 2963/S0342NC' , '3' , '3' , '1' , '3.75' , '3.0737704918033' , '22' , '0' , '13.7250' ) 24/07/2025 09:22:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '23099' AND id_supplier = '28' 24/07/2025 09:22:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23099' , '28' , '1' ) 24/07/2025 09:22: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 ( '98212' , '21095' , 'QUADRETTO DA POGGIO EFFETTO PIETRA - 2950' , '1' , '1' , '1' , '2.62' , '2.1475409836066' , '22' , '0' , '3.1964' ) 24/07/2025 09:22:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '21095' AND id_supplier = '28' 24/07/2025 09:22:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21095' , '28' , '1' ) 24/07/2025 09:22: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 ( '98212' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '100' , '100' , '1' , '0.52' , '0.42622950819672' , '22' , '0' , '63.4400' ) 24/07/2025 09:22:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '9691' AND id_supplier = '28' 24/07/2025 09:22:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9691' , '28' , '1' ) 24/07/2025 09:22: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 ( '98212' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '6' , '6' , '1' , '9.06' , '7.4262295081967' , '22' , '0' , '66.3192' ) 24/07/2025 09:22:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '21561' AND id_supplier = '28' 24/07/2025 09:22:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21561' , '28' , '1' ) 24/07/2025 09:22: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 ( '98212' , '3159' , 'CROCE ULIVO SAN BENEDETTO - GRANDE - 741' , '25' , '25' , '1' , '2.23' , '1.827868852459' , '22' , '0' , '68.0150' ) 24/07/2025 09:22:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '3159' AND id_supplier = '28' 24/07/2025 09:22:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3159' , '28' , '1' ) 24/07/2025 09:22: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 ( '98212' , '23892' , 'CROCE S. BENEDETTO - 730' , '25' , '25' , '1' , '1.82' , '1.4918032786885' , '22' , '0' , '55.5100' ) 24/07/2025 09:22:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '23892' AND id_supplier = '28' 24/07/2025 09:22:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23892' , '28' , '1' ) 24/07/2025 10:16:53 am >> SELECT document_num FROM ps_document WHERE document_num = '20/L' AND id_document != '98188' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-22') 24/07/2025 10:16:53 am >> UPDATE ps_document SET id_document_type = '23', document_num = '20/L', document_date = '2025-07-22', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSP. BATTIPAGLIA', 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 = '149.60', price_tax_excluded = '129.93', date_upd = NOW() WHERE id_document = '98188' 24/07/2025 10:16:53 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 = '98188' 24/07/2025 10:16:53 am >> DELETE FROM ps_document_detail WHERE id_document = '98188' 24/07/2025 10:16:54 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 ( '98188' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO ' , '25' , '-25' , '4' , '0.7000' , '0.7' , '0' , '0' , '17.50' ) 24/07/2025 10:16:54 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 ( '98188' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '3' , '-3' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '45.00' ) 24/07/2025 10:16:54 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 ( '98188' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 24/07/2025 10:16:54 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 ( '98188' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.7000' , '0.7' , '0' , '0' , '17.50' ) 24/07/2025 10:16:54 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 ( '98188' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 24/07/2025 10:16:54 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 ( '98188' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '59.0000' , '48.360655737705' , '22' , '0' , '59.00' ) 24/07/2025 10:22:14 am >> SELECT document_num FROM ps_document WHERE document_num = '21/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-24') 24/07/2025 10:22:14 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 ( '23' , '21/L' , '2025-07-24' , 'L' , '3812' , '0' , '4679440' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '179.20' , '147.88' , NOW() , NOW() ) 24/07/2025 10:22:14 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 = '98213' 24/07/2025 10:22:14 am >> DELETE FROM ps_document_detail WHERE id_document = '98213' 24/07/2025 10:22: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 ( '98213' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672' , '22' , '0' , '51.00' ) 24/07/2025 10:22: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 ( '98213' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 24/07/2025 10:22: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 ( '98213' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3654' , '4' , '0' , '7.00' ) 24/07/2025 10:22: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 ( '98213' , '19351' , 'SERVIZIO MESSA COTONE - 7050' , '1' , '-1' , '1' , '52.0000' , '42.623' , '22' , '0' , '52.00' ) 24/07/2025 10:22: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 ( '98213' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '16' , '-16' , '1' , '0.8000' , '0.6557' , '22' , '0' , '12.80' ) 24/07/2025 10:22:49 am >> DELETE FROM ps_document WHERE id_document = '97551' 24/07/2025 10:22:49 am >> DELETE FROM ps_document_detail WHERE id_document = '97551' 24/07/2025 10:43:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2541' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-24') 24/07/2025 10:43:20 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' , '2541' , '2025-07-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '23.08' , NOW() , NOW() ) 24/07/2025 10:43:20 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 = '98214' 24/07/2025 10:43:20 am >> DELETE FROM ps_document_detail WHERE id_document = '98214' 24/07/2025 10:43:20 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 ( '98214' , '19318' , 'ANGELO ALI TORTORA - 4230 ' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 24/07/2025 10:43:20 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 ( '98214' , '7271' , 'ORAZIONI IN SUFFRAGIO DELLE ANIME DEL PURGATORIO - 8477' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 24/07/2025 10:43:21 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 ( '98214' , '23196' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 24/07/2025 10:43:21 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 ( '98214' , '17583' , 'FRATELLI TUTTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 24/07/2025 10:43:21 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 ( '98214' , '18897' , 'BRACCIALE DECINA PIETRA - BC1843' , '1' , '-1' , '1' , '2.2' , '1.8032786885246' , '22' , '0' , '2.20' ) 24/07/2025 10:43:21 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 ( '98214' , '23777' , 'BRACCIALE MADREPERLA - BC1506' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 24/07/2025 10:43:21 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 ( '98214' , '23438' , 'ANTIQUA ET NOVA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 24/07/2025 10:44:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002134' AND id_product != '1617' AND ean13 != '' 24/07/2025 10:44:09 am >> UPDATE ps_product SET id_supplier = '21', reference = '2016', ean13 = '002134', date_upd = NOW() WHERE id_product = '1617' 24/07/2025 10:44:09 am >> UPDATE ps_product_lang SET name = 'CANDELABRO MOD. 700 FINITURA ORO- CM 40 DM170R', description = '' WHERE id_product = '1617' 24/07/2025 10:44:09 am >> UPDATE ps_product SET wholesale_price = '93.00', on_sale = '0', price = '190.98360655737704' WHERE id_product = '1617' 24/07/2025 10:44:09 am >> UPDATE ps_product_shop SET wholesale_price = '93.00', price = '190.98360655737704', id_tax_rules_group = '1', id_category_default = '215', 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 = '1617' 24/07/2025 10:44:09 am >> DELETE FROM ps_specific_price WHERE id_product = '1617' 24/07/2025 10:54:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2275' AND id_document != '97885' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-27') 24/07/2025 10:54:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2275', document_date = '2025-06-27', 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 = '70.00', price_tax_excluded = '57.38', date_upd = NOW() WHERE id_document = '97885' 24/07/2025 10:54:23 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 = '97885' 24/07/2025 10:54:23 am >> DELETE FROM ps_document_detail WHERE id_document = '97885' 24/07/2025 10:54:23 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 ( '97885' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 24/07/2025 10:54:24 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 ( '97885' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1' , '0.81967213114754' , '22' , '0' , '5.00' ) 24/07/2025 10:54:24 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 ( '97885' , '23873' , 'BOSSOLO DIAM 4 - 160' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 24/07/2025 11:07:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2542' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-24') 24/07/2025 11:07: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 ( '11' , '2542' , '2025-07-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 24/07/2025 11:07: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 = '98215' 24/07/2025 11:07:10 am >> DELETE FROM ps_document_detail WHERE id_document = '98215' 24/07/2025 11:07: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 ( '98215' , '21095' , 'QUADRETTO DA POGGIO EFFETTO PIETRA - 2950' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 24/07/2025 11:11:15 am >> SELECT document_num FROM ps_document WHERE document_num = '2543' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-24') 24/07/2025 11:11:15 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' , '2543' , '2025-07-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.70' , '22.48' , NOW() , NOW() ) 24/07/2025 11:11:15 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 = '98216' 24/07/2025 11:11:15 am >> DELETE FROM ps_document_detail WHERE id_document = '98216' 24/07/2025 11:11:15 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 ( '98216' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '0' , '12.00' ) 24/07/2025 11:11:15 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 ( '98216' , '23880' , 'VOGLIO CERCARE LAMATO DEL MIO CUORE - A. CANOPI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 24/07/2025 11:11:15 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 ( '98216' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 24/07/2025 11:13:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2544' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-24') 24/07/2025 11:13: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' , '2544' , '2025-07-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 24/07/2025 11:13: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 = '98217' 24/07/2025 11:13:48 am >> DELETE FROM ps_document_detail WHERE id_document = '98217' 24/07/2025 11:13: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 ( '98217' , '23082' , 'CAMICE RAGLAN CERNIERA DAVANTI - CA01' , '2' , '-2' , '1' , '50' , '40.983606557377' , '22' , '0' , '100.00' ) 24/07/2025 11:28:06 am >> SELECT document_num FROM ps_document WHERE document_num = '2545' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-24') 24/07/2025 11:28:06 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' , '2545' , '2025-07-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '276.75' , '234.55' , NOW() , NOW() ) 24/07/2025 11:28:06 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 = '98218' 24/07/2025 11:28:06 am >> DELETE FROM ps_document_detail WHERE id_document = '98218' 24/07/2025 11:28:06 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 ( '98218' , '21132' , 'CLERGY F/F MC - C03' , '2' , '-2' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '79.00' ) 24/07/2025 11:28:06 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 ( '98218' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 24/07/2025 11:28:06 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 ( '98218' , '22508' , 'POLO PIQUET - M06' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 24/07/2025 11:28:06 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 ( '98218' , '20983' , 'CLERGY MM LIMITED 80/20' , '2' , '-2' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '80.00' ) 24/07/2025 11:28:06 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 ( '98218' , '23828' , 'AGNELLO DI DIO - I. ALFEEV' , '1' , '-1' , '4' , '45.00' , '45' , '0' , '5' , '42.75' ) 24/07/2025 11:29:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2546' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-07-24') 24/07/2025 11:29:00 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' , '2546' , '2025-07-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '514.00' , '421.31' , NOW() , NOW() ) 24/07/2025 11:29:00 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 = '98219' 24/07/2025 11:29:00 am >> DELETE FROM ps_document_detail WHERE id_document = '98219' 24/07/2025 11:29:00 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 ( '98219' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '464' , '380.32786885246' , '22' , '0' , '464.00' ) 24/07/2025 11:29:00 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 ( '98219' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '2' , '-2' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '22.00' ) 24/07/2025 11:29:00 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 ( '98219' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '2' , '-2' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '28.00' ) 24/07/2025 11:56:27 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 ( '34' , '2025020000458' , '2025-07-22' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '119.34' , '119.34' , NOW() , NOW() ) 24/07/2025 11:56:27 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 = '98220' 24/07/2025 11:56:27 am >> DELETE FROM ps_document_detail WHERE id_document = '98220' 24/07/2025 11:56:27 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 ( '98220' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '1' , '0' , '4' , '60.00' , '60' , '0' , '22' , '46.8000' ) 24/07/2025 11:56:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '5763' AND id_supplier = '107' 24/07/2025 11:56:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5763' , '107' , '1' ) 24/07/2025 11:56:27 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 ( '98220' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '0' , '4' , '60.00' , '60' , '0' , '22' , '46.8000' ) 24/07/2025 11:56:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '5764' AND id_supplier = '107' 24/07/2025 11:56:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5764' , '107' , '1' ) 24/07/2025 11:56:27 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 ( '98220' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '4' , '0' , '4' , '5.50' , '5.5' , '0' , '22' , '17.1600' ) 24/07/2025 11:56:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '107' 24/07/2025 11:56:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '107' , '1' ) 24/07/2025 11:56:27 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 ( '98220' , '11193' , 'VENITE CON ME CAT.' , '2' , '0' , '4' , '5.50' , '5.5' , '0' , '22' , '8.5800' ) 24/07/2025 11:56:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '107' 24/07/2025 11:56:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '107' , '1' ) 24/07/2025 11:56:55 am >> UPDATE ps_document SET id_document_type = '34', document_num = '2025020000458', document_date = '2025-07-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669100', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', 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 = '119.34', price_tax_excluded = '119.34', date_upd = NOW() WHERE id_document = '98220' 24/07/2025 11:56:55 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 = '98220' 24/07/2025 11:56:55 am >> DELETE FROM ps_document_detail WHERE id_document = '98220' 24/07/2025 11:56:55 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 ( '98220' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '22' , '46.80' ) 24/07/2025 11:56:55 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 ( '98220' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '22' , '46.80' ) 24/07/2025 11:56:55 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 ( '98220' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '22' , '17.16' ) 24/07/2025 11:56:55 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 ( '98220' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.5000' , '5.5' , '0' , '22' , '8.58' ) 24/07/2025 12:13:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2547' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-24') 24/07/2025 12:13:15 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' , '2547' , '2025-07-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '99.00' , '81.15' , NOW() , NOW() ) 24/07/2025 12:13: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 = '98221' 24/07/2025 12:13:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '98221' 24/07/2025 12:13: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 ( '98221' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 24/07/2025 12:13: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 ( '98221' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 24/07/2025 12:13: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 ( '98221' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 24/07/2025 12:13: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 ( '98221' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '10' , '-10' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '15.00' ) 24/07/2025 12:30:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2548' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-07-24') 24/07/2025 12:30: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' , '2548' , '2025-07-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.41' , '4.41' , NOW() , NOW() ) 24/07/2025 12:30: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 = '98222' 24/07/2025 12:30:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '98222' 24/07/2025 12:30: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 ( '98222' , '23699' , 'AMEN - AGO 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 24/07/2025 12:30: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 ( '98222' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 24/07/2025 12:31:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2549' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-24') 24/07/2025 12:31: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 ( '11' , '2549' , '2025-07-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 24/07/2025 12:31: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 = '98223' 24/07/2025 12:31:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '98223' 24/07/2025 12:31: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 ( '98223' , '925' , 'BALZA RICAMATA ROSSA - CM 16 - KOM/030 ' , '6' , '-6' , '1' , '20' , '16.393442622951' , '22' , '0' , '120.00' ) 24/07/2025 12:36:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '2550' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-24') 24/07/2025 12:36: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' , '2550' , '2025-07-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '10.02' , NOW() , NOW() ) 24/07/2025 12:36: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 = '98224' 24/07/2025 12:36:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '98224' 24/07/2025 12:36: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 ( '98224' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '10' , '-10' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '11.00' ) 24/07/2025 12:36: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 ( '98224' , '14000' , 'GALATEO IN CHIESA' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 24/07/2025 12:38:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '89/A' AND id_document != '97713' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-14') 24/07/2025 12:38:43 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '89/A', document_date = '2025-06-14', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '77.70', price_tax_excluded = '70.17', date_upd = NOW() WHERE id_document = '97713' 24/07/2025 12:38: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 = '97713' 24/07/2025 12:38:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '97713' 24/07/2025 12:38: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 ( '97713' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 24/07/2025 12:38: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 ( '97713' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 24/07/2025 12:38: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 ( '97713' , '1077' , 'BERNADETTE' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 24/07/2025 12:38:44 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 ( '97713' , '7385' , 'SAN PIO DA PIETRELCINA - L. DA FARA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 24/07/2025 12:38:44 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 ( '97713' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '0' , '15.00' ) 24/07/2025 12:38:44 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 ( '97713' , '23700' , 'AMEN - LUG 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 24/07/2025 12:38:44 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 ( '97713' , '23699' , 'AMEN - AGO 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 24/07/2025 12:38:44 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 ( '97713' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '33.00' , '27.049180327869' , '22' , '0' , '33.00' ) 24/07/2025 03:06:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2551' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-24') 24/07/2025 03:06: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' , '2551' , '2025-07-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '40.00' , NOW() , NOW() ) 24/07/2025 03:06: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 = '98225' 24/07/2025 03:06:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '98225' 24/07/2025 03:06: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 ( '98225' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '0' , '40.00' ) 24/07/2025 04:51:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '2552' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-24') 24/07/2025 04:51:44 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' , '2552' , '2025-07-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.80' , '20.33' , NOW() , NOW() ) 24/07/2025 04:51:44 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 = '98226' 24/07/2025 04:51:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '98226' 24/07/2025 04:51:44 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 ( '98226' , '6075' , 'LOURDES BABY - PB19081' , '1' , '-1' , '1' , '9.90' , '8.1147540983607' , '22' , '0' , '9.90' ) 24/07/2025 04:51:44 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 ( '98226' , '14623' , 'BAMBINO DI PRAGA BABY - PB19083' , '1' , '-1' , '1' , '9.90' , '8.1147540983607' , '22' , '0' , '9.90' ) 24/07/2025 04:51:44 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 ( '98226' , '21560' , 'ROSARIO LEGNO CORDA CON G. - 3539' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 24/07/2025 06:33:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2553' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-24') 24/07/2025 06:33:56 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' , '2553' , '2025-07-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 24/07/2025 06:33:56 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 = '98227' 24/07/2025 06:33:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '98227' 24/07/2025 06:33:56 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 ( '98227' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' )