23/07/2025 08:15:57 am >> SELECT document_num FROM ps_document WHERE document_num = '2530' AND id_document != '98198' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-22') 23/07/2025 08:15:57 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2530', document_date = '2025-07-22', 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 = '15.00', price_tax_excluded = '12.30', date_upd = NOW() WHERE id_document = '98198' 23/07/2025 08:15:57 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 = '98198' 23/07/2025 08:15:57 am >> DELETE FROM ps_document_detail WHERE id_document = '98198' 23/07/2025 08:15:57 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 ( '98198' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 23/07/2025 08:15:57 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 ( '98198' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 23/07/2025 08:15:57 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 ( '98198' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 23/07/2025 08:22:12 am >> SELECT document_num FROM ps_document WHERE document_num = '86' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-07-23') 23/07/2025 08:22:12 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' , '86' , '2025-07-23' , '' , '3859' , '0' , '4679261' , 'VIA G.B.VENTURI , 140 42021 BIBBIANO' , '' , '' , '5.01' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '38.26' , '38.26' , NOW() , NOW() ) 23/07/2025 08:22:12 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 = '98199' 23/07/2025 08:22:12 am >> DELETE FROM ps_document_detail WHERE id_document = '98199' 23/07/2025 08:22:12 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 ( '98199' , '12819' , 'REGISTRO DEL CATECHISTA ' , '35' , '-35' , '0' , '1.00' , '1' , '' , '5' , '33.25' ) 23/07/2025 09:05:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2304' AND id_document != '97918' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 23/07/2025 09:05:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2304', document_date = '2025-06-30', 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 = '21.00', price_tax_excluded = '17.21', date_upd = NOW() WHERE id_document = '97918' 23/07/2025 09:05:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97918' 23/07/2025 09:05:05 am >> DELETE FROM ps_document_detail WHERE id_document = '97918' 23/07/2025 09:05:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97918' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 23/07/2025 09:05:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97918' , '23425' , 'ROSARIO GIUBILEO - 198/1-G25' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 23/07/2025 09:05:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97918' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '1' , '-1' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '2.20' ) 23/07/2025 09:05:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97918' , '22968' , 'TURIBOLO H10' , '1' , '-1' , '1' , '13.8' , '11.311475409836' , '22' , '0' , '13.80' ) 23/07/2025 09:27:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2531' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-23') 23/07/2025 09:27: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' , '2531' , '2025-07-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.45' , '5.45' , NOW() , NOW() ) 23/07/2025 09:27: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 = '98200' 23/07/2025 09:27:00 am >> DELETE FROM ps_document_detail WHERE id_document = '98200' 23/07/2025 09:27: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 ( '98200' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 23/07/2025 09:27: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 ( '98200' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 23/07/2025 10:06:53 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' , '2025-01973' , '2025-07-17' , '' , '0' , '86' , '2723' , 'WEIDACHSTRABE, 6 85609 ASCHHEIM - GERMANIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '406.02' , '406.02' , NOW() , NOW() ) 23/07/2025 10:06: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 = '98201' 23/07/2025 10:06:53 am >> DELETE FROM ps_document_detail WHERE id_document = '98201' 23/07/2025 10:06: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 ( '98201' , '22968' , 'TURIBOLO H10' , '6' , '6' , '0' , '5.53' , '5.53' , '' , '3' , '32.1846' ) 23/07/2025 10:06:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '22968' AND id_supplier = '86' 23/07/2025 10:06:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22968' , '86' , '1' ) 23/07/2025 10:06: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 ( '98201' , '22299' , 'BRUCIA INCENSO PADELLA CM 17 - 12-750' , '4' , '4' , '0' , '6.73' , '6.73' , '' , '3' , '26.1124' ) 23/07/2025 10:06:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '22299' AND id_supplier = '86' 23/07/2025 10:06:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22299' , '86' , '1' ) 23/07/2025 10:06: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 ( '98201' , '18022' , 'TURIBOLO H 24' , '2' , '2' , '0' , '55.31' , '55.31' , '' , '3' , '107.3014' ) 23/07/2025 10:06:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '18022' AND id_supplier = '86' 23/07/2025 10:06:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18022' , '86' , '1' ) 23/07/2025 10:06: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 ( '98201' , '12241' , 'TURIBOLO H 24CM' , '1' , '1' , '0' , '54.15' , '54.15' , '' , '3' , '52.5255' ) 23/07/2025 10:06:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '12241' AND id_supplier = '86' 23/07/2025 10:06:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12241' , '86' , '1' ) 23/07/2025 10:06: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 ( '98201' , '12617' , 'NAVETTA CON CUCCHIAINO' , '3' , '3' , '0' , '13.71' , '13.71' , '' , '3' , '39.8961' ) 23/07/2025 10:06:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '12617' AND id_supplier = '86' 23/07/2025 10:06:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12617' , '86' , '1' ) 23/07/2025 10:06: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 ( '98201' , '12237' , 'TURIBOLO H28 CM' , '2' , '2' , '0' , '66.85' , '66.85' , '' , '3' , '129.6890' ) 23/07/2025 10:06:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '12237' AND id_supplier = '86' 23/07/2025 10:06:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12237' , '86' , '1' ) 23/07/2025 10:06: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 ( '98201' , '20823' , 'BRUCIA INCENSO CM 9' , '2' , '2' , '0' , '9.44' , '9.44' , '' , '3' , '18.3136' ) 23/07/2025 10:06:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '20823' AND id_supplier = '86' 23/07/2025 10:06:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20823' , '86' , '1' ) 23/07/2025 10:14:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2532' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-23') 23/07/2025 10:14: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' , '2532' , '2025-07-23' , '' , '0' , '0' , '0' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '-0.08' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '413.97' , '376.60' , NOW() , NOW() ) 23/07/2025 10:14: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 = '98202' 23/07/2025 10:14:45 am >> DELETE FROM ps_document_detail WHERE id_document = '98202' 23/07/2025 10:14: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 ( '98202' , '7202' , 'ARTICOLI RELIGIOSI buste palma' , '2' , '-2' , '1' , '11.0000' , '9.0164' , '22' , '0' , '22.00' ) 23/07/2025 10:14: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 ( '98202' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '28.0000' , '22.9508' , '22' , '0' , '56.00' ) 23/07/2025 10:14: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 ( '98202' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '2' , '-2' , '1' , '7.5000' , '6.1475' , '22' , '0' , '15.00' ) 23/07/2025 10:14: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 ( '98202' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '1' , '-1' , '3' , '2.0000' , '1.9231' , '4' , '0' , '2.00' ) 23/07/2025 10:14: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 ( '98202' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '10' , '-10' , '1' , '1.2000' , '0.9836' , '22' , '0' , '12.00' ) 23/07/2025 10:14: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 ( '98202' , '15463' , 'PICCOLO CATECHISMO DELLA PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '0' , '12.90' ) 23/07/2025 10:14: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 ( '98202' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.0000' , '0.8197' , '22' , '0' , '1.00' ) 23/07/2025 10:14: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 ( '98202' , '7202' , 'ARTICOLI RELIGIOSI PLACCA COMUNIONE' , '1' , '-1' , '1' , '6.0000' , '4.918' , '22' , '0' , '6.00' ) 23/07/2025 10:14: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 ( '98202' , '23783' , 'LEONE XIV - A. PREZIOSI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 23/07/2025 10:14: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 ( '98202' , '20516' , 'CROCE COMUNIONE - 42/08' , '10' , '-10' , '1' , '1.2000' , '0.9836' , '22' , '0' , '12.00' ) 23/07/2025 10:14: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 ( '98202' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.5000' , '1.2295' , '22' , '0' , '7.50' ) 23/07/2025 10:14: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 ( '98202' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.0000' , '2.459' , '22' , '0' , '15.00' ) 23/07/2025 10:14: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 ( '98202' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '10' , '-10' , '1' , '2.2000' , '1.8033' , '22' , '0' , '22.00' ) 23/07/2025 10:14: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 ( '98202' , '13357' , 'PORTACHIAVI DEVOZIONALI' , '1' , '-1' , '1' , '2.0000' , '1.6393' , '22' , '0' , '2.00' ) 23/07/2025 10:14: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 ( '98202' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3654' , '4' , '0' , '7.00' ) 23/07/2025 10:14: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 ( '98202' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9231' , '4' , '0' , '4.00' ) 23/07/2025 10:14: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 ( '98202' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '21' , '-21' , '4' , '0.7000' , '0.7' , '0' , '0' , '14.70' ) 23/07/2025 10:14: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 ( '98202' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.9000' , '4.0164' , '22' , '0' , '14.70' ) 23/07/2025 10:14: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 ( '98202' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '3' , '-3' , '3' , '2.0000' , '1.9231' , '4' , '0' , '6.00' ) 23/07/2025 10:14: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 ( '98202' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '-1' , '4' , '90.0000' , '90' , '0' , '0' , '90.00' ) 23/07/2025 10:14: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 ( '98202' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '0' , '60.00' ) 23/07/2025 10:14: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 ( '98202' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '2' , '-2' , '1' , '7.5000' , '6.1475' , '22' , '0' , '15.00' ) 23/07/2025 10:14: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 ( '98202' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.459' , '22' , '0' , '3.00' ) 23/07/2025 10:14:57 am >> DELETE FROM ps_document WHERE id_document = '95409' 23/07/2025 10:14:57 am >> DELETE FROM ps_document_detail WHERE id_document = '95409' 23/07/2025 10:57:32 am >> UPDATE ps_document SET id_document_type = '31', document_num = '2025-01973', document_date = '2025-07-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2723', address1 = 'WEIDACHSTRABE, 6 85609 ASCHHEIM - GERMANIA', address2 = '', note = '', price_shipping = '17.36', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '578.42', price_tax_excluded = '578.42', date_upd = NOW() WHERE id_document = '98201' 23/07/2025 10:57:32 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 = '98201' 23/07/2025 10:57:32 am >> DELETE FROM ps_document_detail WHERE id_document = '98201' 23/07/2025 10:57:32 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 ( '98201' , '22968' , 'TURIBOLO H10' , '6' , '6' , '0' , '5.5300' , '5.53' , '0' , '3' , '32.18' ) 23/07/2025 10:57:32 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 ( '98201' , '22299' , 'BRUCIA INCENSO PADELLA CM 17 - 12-750' , '4' , '4' , '0' , '6.7300' , '6.73' , '0' , '3' , '26.11' ) 23/07/2025 10:57:32 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 ( '98201' , '18022' , 'TURIBOLO H 24' , '2' , '2' , '0' , '55.3100' , '55.31' , '0' , '3' , '107.30' ) 23/07/2025 10:57:32 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 ( '98201' , '12241' , 'TURIBOLO H 24CM' , '1' , '1' , '0' , '54.1500' , '54.15' , '0' , '3' , '52.53' ) 23/07/2025 10:57:32 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 ( '98201' , '12617' , 'NAVETTA CON CUCCHIAINO' , '3' , '3' , '0' , '13.7100' , '13.71' , '0' , '3' , '39.90' ) 23/07/2025 10:57:32 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 ( '98201' , '12237' , 'TURIBOLO H28 CM' , '2' , '2' , '0' , '66.8500' , '66.85' , '0' , '3' , '129.69' ) 23/07/2025 10:57:32 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 ( '98201' , '20823' , 'BRUCIA INCENSO CM 9' , '2' , '2' , '0' , '9.4400' , '9.44' , '0' , '3' , '18.31' ) 23/07/2025 10:57:32 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 ( '98201' , '18902' , 'TURIBOLO CM 24' , '1' , '1' , '0' , '63.38' , '63.38' , '' , '3' , '61.4786' ) 23/07/2025 10:57:32 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 ( '98201' , '22306' , 'TURIBOLO CM 24' , '1' , '1' , '0' , '60.96' , '60.96' , '' , '3' , '59.1312' ) 23/07/2025 10:57:32 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 ( '98201' , '18904' , 'NAVETTA ' , '1' , '1' , '0' , '17.17' , '17.17' , '' , '3' , '16.6549' ) 23/07/2025 10:57:32 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 ( '98201' , '12607' , 'NAVETTA DORATA CON CUCCHIAINO ' , '1' , '1' , '0' , '18.32' , '18.32' , '' , '3' , '17.7704' ) 23/07/2025 11:11:24 am >> SELECT document_num FROM ps_document WHERE document_num = '2533' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-23') 23/07/2025 11:11:24 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' , '2533' , '2025-07-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.30' , '1.07' , NOW() , NOW() ) 23/07/2025 11:11:24 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 = '98203' 23/07/2025 11:11:24 am >> DELETE FROM ps_document_detail WHERE id_document = '98203' 23/07/2025 11:11:25 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 ( '98203' , '3103' , 'CROCE SAN BENEDETTO' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 23/07/2025 12:03:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2534' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-07-23') 23/07/2025 12:03:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2534' , '2025-07-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 23/07/2025 12:03:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98204' 23/07/2025 12:03:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '98204' 23/07/2025 12:03:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98204' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 23/07/2025 12:03:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2535' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-23') 23/07/2025 12:03:47 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' , '2535' , '2025-07-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '122.95' , NOW() , NOW() ) 23/07/2025 12:03:47 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 = '98205' 23/07/2025 12:03:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '98205' 23/07/2025 12:03:47 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 ( '98205' , '22464' , 'CASULA LEGGERA - 1212' , '2' , '-2' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '150.00' ) 23/07/2025 12:05:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2536' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-23') 23/07/2025 12:05:23 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' , '2536' , '2025-07-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 23/07/2025 12:05:23 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 = '98206' 23/07/2025 12:05:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '98206' 23/07/2025 12:05:23 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 ( '98206' , '22508' , 'POLO PIQUET - M06' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 23/07/2025 03:12:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2526' AND id_document != '98194' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-22') 23/07/2025 03:12:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2526', document_date = '2025-07-22', 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 = '3', id_causal = '0', price_tax_included = '280.00', price_tax_excluded = '233.20', date_upd = NOW() WHERE id_document = '98194' 23/07/2025 03:12:40 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 = '98194' 23/07/2025 03:12:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '98194' 23/07/2025 03:12: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 ( '98194' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 23/07/2025 03:12: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 ( '98194' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 23/07/2025 03:12: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 ( '98194' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 23/07/2025 03:12: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 ( '98194' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '74' , '60.655737704918' , '22' , '0' , '74.00' ) 23/07/2025 03:12: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 ( '98194' , '13079' , 'COPPIA CANDELIERI IN LEGNO - 033' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 23/07/2025 03:12: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 ( '98194' , '13078' , 'LEGGIO IN LEGNO - 043' , '1' , '-1' , '1' , '125.0000' , '102.45901639344' , '22' , '0' , '125.00' ) 23/07/2025 03:22:15 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '23870' 23/07/2025 03:50:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736574' AND id_product != '23870' AND ean13 != '' 23/07/2025 03:50:43 pm >> UPDATE ps_product SET id_supplier = '159', reference = '2/4', ean13 = '9791280736574', date_upd = NOW() WHERE id_product = '23870' 23/07/2025 03:50:43 pm >> UPDATE ps_product_lang SET name = 'RAGAZZO DEL LENZUOLO - M. VIANI', description = '' WHERE id_product = '23870' 23/07/2025 03:50:43 pm >> UPDATE ps_product SET wholesale_price = '1.80', on_sale = '0', price = '10.0000' WHERE id_product = '23870' 23/07/2025 03:50:43 pm >> UPDATE ps_product_shop SET wholesale_price = '1.80', price = '10.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '41', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23870' 23/07/2025 03:50:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '23870' 23/07/2025 03:50:43 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '23870' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 23/07/2025 03:52:26 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/07/2025 03:52:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23885' , '1' , '' , 'nuovo-prodotto' ) 23/07/2025 03:52:26 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23885' , '1' , '1' , '2' , NOW() , NOW() ) 23/07/2025 03:52:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23885' , '0' , '1' , '0' , '0' ) 23/07/2025 03:55:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791255950455' AND id_product != '23885' AND ean13 != '' 23/07/2025 03:55:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '11/7', ean13 = '9791255950455', date_upd = NOW() WHERE id_product = '23885' 23/07/2025 03:55:20 pm >> UPDATE ps_product_lang SET name = 'FACEMMO VELA VERSO SAMOTRACIA', description = '' WHERE id_product = '23885' 23/07/2025 03:55:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.8' WHERE id_product = '23885' 23/07/2025 03:55:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.8', id_tax_rules_group = '4', id_category_default = '103', id_argoment_default = '16', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23885' 23/07/2025 03:55:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '23885' 23/07/2025 03:55:21 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23885' 23/07/2025 03:55:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23886' , '1' , '' , 'nuovo-prodotto' ) 23/07/2025 03:55:21 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23886' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23885' 23/07/2025 03:55:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23886' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23885' 23/07/2025 03:56:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839934710' AND id_product != '23886' AND ean13 != '' 23/07/2025 03:56:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9788839934710', date_upd = NOW() WHERE id_product = '23886' 23/07/2025 03:56:13 pm >> UPDATE ps_product_lang SET name = 'MODO TRASFIGURATO - P. SHELDRAKE', description = '' WHERE id_product = '23886' 23/07/2025 03:56:13 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30' WHERE id_product = '23886' 23/07/2025 03:56:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23886' 23/07/2025 03:56:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '23886' 23/07/2025 03:56:24 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23886' 23/07/2025 03:56:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23887' , '1' , '' , 'nuovo-prodotto' ) 23/07/2025 03:56:24 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23887' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23886' 23/07/2025 03:56:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23887' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23886' 23/07/2025 03:59:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892872561' AND id_product != '23887' AND ean13 != '' 23/07/2025 03:59:02 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788892872561', date_upd = NOW() WHERE id_product = '23887' 23/07/2025 03:59:02 pm >> UPDATE ps_product_lang SET name = 'PACE DISARMATA E DISARMANTE - F. ZAVATTARO', description = '' WHERE id_product = '23887' 23/07/2025 03:59:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '23887' 23/07/2025 03:59:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23887' 23/07/2025 03:59:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '23887' 23/07/2025 03:59:03 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23887' 23/07/2025 03:59:03 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23888' , '1' , '' , 'nuovo-prodotto' ) 23/07/2025 03:59:03 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23888' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23887' 23/07/2025 03:59:03 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23888' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23887' 23/07/2025 04:00:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831558105' AND id_product != '23888' AND ean13 != '' 23/07/2025 04:00:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788831558105', date_upd = NOW() WHERE id_product = '23888' 23/07/2025 04:00:46 pm >> UPDATE ps_product_lang SET name = 'PIER GIORGIO FRASSATI - M. PAPPALARDO', description = '' WHERE id_product = '23888' 23/07/2025 04:00:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.9' WHERE id_product = '23888' 23/07/2025 04:00:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.9', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23888' 23/07/2025 04:00:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '23888' 23/07/2025 04:00:47 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23888' 23/07/2025 04:00:47 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23889' , '1' , '' , 'nuovo-prodotto' ) 23/07/2025 04:00:47 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23889' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23888' 23/07/2025 04:00:47 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23889' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23888' 23/07/2025 04:02:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851430177' AND id_product != '23889' AND ean13 != '' 23/07/2025 04:02:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788851430177', date_upd = NOW() WHERE id_product = '23889' 23/07/2025 04:02:20 pm >> UPDATE ps_product_lang SET name = 'VADO A CONFESSARMI - M. ARAMINI', description = '' WHERE id_product = '23889' 23/07/2025 04:02:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '23889' 23/07/2025 04:02:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23889' 23/07/2025 04:02:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '23889' 23/07/2025 04:02:21 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23889' 23/07/2025 04:02:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23890' , '1' , '' , 'nuovo-prodotto' ) 23/07/2025 04:02:21 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23890' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23889' 23/07/2025 04:02:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23890' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23889' 23/07/2025 04:04:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618329' AND id_product != '23890' AND ean13 != '' 23/07/2025 04:04:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9791281618329', date_upd = NOW() WHERE id_product = '23890' 23/07/2025 04:04:32 pm >> UPDATE ps_product_lang SET name = 'BATTEZZATI IN SPIRITO SANTO E FUOCO ', description = '' WHERE id_product = '23890' 23/07/2025 04:04:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '23890' 23/07/2025 04:04:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23890' 23/07/2025 04:04:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '23890' 23/07/2025 04:04:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618329' AND id_product != '23890' AND ean13 != '' 23/07/2025 04:04:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9791281618329', date_upd = NOW() WHERE id_product = '23890' 23/07/2025 04:04:39 pm >> UPDATE ps_product_lang SET name = 'BATTEZZATI IN SPIRITO SANTO E FUOCO ', description = '' WHERE id_product = '23890' 23/07/2025 04:04:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '23890' 23/07/2025 04:04:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '76', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23890' 23/07/2025 04:04:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '23890' 23/07/2025 04:04:42 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23890' 23/07/2025 04:04:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23891' , '1' , '' , 'nuovo-prodotto' ) 23/07/2025 04:04:42 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23891' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23890' 23/07/2025 04:04:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23891' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23890' 23/07/2025 04:05:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618312' AND id_product != '23891' AND ean13 != '' 23/07/2025 04:05:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9791281618312', date_upd = NOW() WHERE id_product = '23891' 23/07/2025 04:05:23 pm >> UPDATE ps_product_lang SET name = 'BATTEZZATI IN SPIRITO SANTO E FUOCO - GUIDA', description = '' WHERE id_product = '23891' 23/07/2025 04:05:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '23891' 23/07/2025 04:05:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '76', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23891' 23/07/2025 04:05:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '23891' 23/07/2025 04:05:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281618329' AND id_product != '23890' AND ean13 != '' 23/07/2025 04:05:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9791281618329', date_upd = NOW() WHERE id_product = '23890' 23/07/2025 04:05:52 pm >> UPDATE ps_product_lang SET name = 'BATTEZZATI IN SPIRITO SANTO E FUOCO - SUSSIDIO', description = '' WHERE id_product = '23890' 23/07/2025 04:05:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.0000' WHERE id_product = '23890' 23/07/2025 04:05:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.0000', id_tax_rules_group = '4', id_category_default = '76', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23890' 23/07/2025 04:05:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '23890' 23/07/2025 04:09:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '705039' , '2025-07-22' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.14' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.39' , '76.39' , NOW() , NOW() ) 23/07/2025 04:09:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98207' 23/07/2025 04:09:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '98207' 23/07/2025 04:09:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98207' , '23885' , 'FACEMMO VELA VERSO SAMOTRACIA' , '1' , '1' , '4' , '3.80' , '3.8' , '0' , '25' , '2.8500' ) 23/07/2025 04:09:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23885' AND id_supplier = '7' 23/07/2025 04:09:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23885' , '7' , '1' ) 23/07/2025 04:09:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98207' , '7442' , 'PANE QUOTIDIANO' , '1' , '1' , '4' , '4.50' , '4.5' , '0' , '30' , '3.1500' ) 23/07/2025 04:09:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7442' AND id_supplier = '7' 23/07/2025 04:09:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7442' , '7' , '1' ) 23/07/2025 04:09:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98207' , '23891' , 'BATTEZZATI IN SPIRITO SANTO E FUOCO - GUIDA' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 23/07/2025 04:09:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23891' AND id_supplier = '7' 23/07/2025 04:09:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23891' , '7' , '1' ) 23/07/2025 04:09:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98207' , '23890' , 'BATTEZZATI IN SPIRITO SANTO E FUOCO - SUSSIDIO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 23/07/2025 04:09:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23890' AND id_supplier = '7' 23/07/2025 04:09:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23890' , '7' , '1' ) 23/07/2025 04:09:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98207' , '23889' , 'VADO A CONFESSARMI - M. ARAMINI' , '1' , '1' , '4' , '13.00' , '13' , '0' , '33' , '8.7100' ) 23/07/2025 04:09:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23889' AND id_supplier = '7' 23/07/2025 04:09:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23889' , '7' , '1' ) 23/07/2025 04:09:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98207' , '23886' , 'MODO TRASFIGURATO - P. SHELDRAKE' , '1' , '1' , '4' , '30.00' , '30' , '0' , '30' , '21.0000' ) 23/07/2025 04:09:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23886' AND id_supplier = '7' 23/07/2025 04:09:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23886' , '7' , '1' ) 23/07/2025 04:09:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98207' , '23887' , 'PACE DISARMATA E DISARMANTE - F. ZAVATTARO' , '1' , '1' , '4' , '17.00' , '17' , '0' , '30' , '11.9000' ) 23/07/2025 04:09:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23887' AND id_supplier = '7' 23/07/2025 04:09:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23887' , '7' , '1' ) 23/07/2025 04:09:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98207' , '23888' , 'PIER GIORGIO FRASSATI - M. PAPPALARDO' , '1' , '1' , '4' , '11.90' , '11.9' , '0' , '35' , '7.7350' ) 23/07/2025 04:09:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23888' AND id_supplier = '7' 23/07/2025 04:09:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23888' , '7' , '1' ) 23/07/2025 06:25:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2537' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-23') 23/07/2025 06:25:16 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' , '2537' , '2025-07-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '48.08' , NOW() , NOW() ) 23/07/2025 06:25:16 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 = '98208' 23/07/2025 06:25:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '98208' 23/07/2025 06:25:16 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 ( '98208' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 23/07/2025 06:25:16 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 ( '98208' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 23/07/2025 06:25:16 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 ( '98208' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '22.50' ) 23/07/2025 07:14:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2538' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-23') 23/07/2025 07:14:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2538' , '2025-07-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.50' , '16.80' , NOW() , NOW() ) 23/07/2025 07:14:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98209' 23/07/2025 07:14:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '98209' 23/07/2025 07:14:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98209' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '19.50' ) 23/07/2025 07:14:28 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 ( '98209' , '6019' , 'LUMINO ROSSO - 10B' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 23/07/2025 07:52:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2539' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-23') 23/07/2025 07:52: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' , '2539' , '2025-07-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 23/07/2025 07:52: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 = '98210' 23/07/2025 07:52:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '98210' 23/07/2025 07:52: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 ( '98210' , '23609' , 'CALAMITA 8X8 ' , '2' , '-2' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '10.00' ) 23/07/2025 07:53:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2540' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-23') 23/07/2025 07:53:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2540' , '2025-07-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 23/07/2025 07:53:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98211' 23/07/2025 07:53:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '98211' 23/07/2025 07:53:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98211' , '18223' , 'ROSARIO MISSIONARIO MM8 - R102' , '12' , '-12' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '18.00' )