11/10/2025 09:07:04 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3313' AND id_document != '99183' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-10') 
11/10/2025 09:07:04 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '3313',
                          document_date = '2025-10-10',
                          document_letter = '',
                          id_customer = '0',
                          id_supplier = '',
                          id_address = '0',
                          address1 = '',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '0',
                          id_causal = '0',
                          price_tax_included = '17.05',
                          price_tax_excluded = '16.93',
                          date_upd = NOW()
                        WHERE id_document = '99183' 
11/10/2025 09:07:04 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 = '99183' 
11/10/2025 09:07:04 am >>  DELETE FROM ps_document_detail WHERE id_document = '99183' 
11/10/2025 09:07:05 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '99183' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' ,  '-1' , '3' ,
                               '3' , '2.8846153846154' , '4' , '0' , '3.00' ) 
11/10/2025 09:07:05 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '99183' , '24142' , 'DILEXI TE' , '1' ,  '-1' , '4' ,
                               '2.9000' , '2.9' , '0' , '0' , '2.90' ) 
11/10/2025 09:07:05 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '99183' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' ,  '-1' , '4' ,
                               '0.8000' , '0.8' , '0' , '0' , '0.80' ) 
11/10/2025 09:07:05 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '99183' , '23636' , 'GESU CRISTO FIGLIO DI DIO SALVATORE' , '1' ,  '-1' , '4' ,
                               '5.0000' , '5' , '0' , '5' , '4.75' ) 
11/10/2025 09:07:05 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '99183' , '14143' , 'SAN FRANCESCO DASSISI - RACCONTATO AI RAGAZZI' , '1' ,  '-1' , '4' ,
                               '4.0000' , '4' , '0' , '5' , '3.80' ) 
11/10/2025 09:07:05 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '99183' , '20093' , 'PREGHIAMO LA MAMMA DI GESU' , '1' ,  '-1' , '4' ,
                               '1.8000' , '1.8' , '0' , '0' , '1.80' ) 
11/10/2025 09:54:21 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3316' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-11') 
11/10/2025 09:54:21 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' ,
                          '3316' ,
                          '2025-10-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '46.28' ,
                          '45.22' ,
                          NOW() ,
                          NOW() ) 
11/10/2025 09:54:21 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 = '99186' 
11/10/2025 09:54:21 am >>  DELETE FROM ps_document_detail WHERE id_document = '99186' 
11/10/2025 09:54: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
                            ( '99186' , '19716' , 'MEDAGLIA SAN BENEDETTO - Q1001-OX' , '3' ,  '-3' , '1' ,
                               '0.30' , '0.24590163934426' , '22' , '0' , '0.90' ) 
11/10/2025 09:54:22 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
                            ( '99186' , '20758' , 'SEGNALIBRO 5X15' , '3' ,  '-3' , '1' ,
                               '0.20' , '0.16393442622951' , '22' , '0' , '0.60' ) 
11/10/2025 09:54:22 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
                            ( '99186' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '2' ,  '-2' , '1' ,
                               '2.20' , '1.8032786885246' , '22' , '0' , '4.40' ) 
11/10/2025 09:54:22 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
                            ( '99186' , '22877' , 'OH, MAMMA CELESTE! - F. CRISTOFARO' , '1' ,  '-1' , '4' ,
                               '15.00' , '15' , '0' , '5' , '14.25' ) 
11/10/2025 09:54:22 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
                            ( '99186' , '23473' , 'RACCONTAMI DI CARLO - C. GALATOLO' , '1' ,  '-1' , '4' ,
                               '13.00' , '13' , '0' , '5' , '12.35' ) 
11/10/2025 09:54:22 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
                            ( '99186' , '2679' , 'CONOSCERE GESU' , '1' ,  '-1' , '4' ,
                               '3.50' , '3.5' , '0' , '5' , '3.33' ) 
11/10/2025 09:54:22 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
                            ( '99186' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' ,  '-1' , '4' ,
                               '6.00' , '6' , '0' , '5' , '5.70' ) 
11/10/2025 09:54:22 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
                            ( '99186' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '5' , '4.75' ) 
11/10/2025 09:54:52 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3317' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-11') 
11/10/2025 09:54:52 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '3317' ,
                          '2025-10-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '2.90' ,
                          '2.90' ,
                          NOW() ,
                          NOW() ) 
11/10/2025 09:54:52 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99187' 
11/10/2025 09:54:52 am >>  DELETE FROM ps_document_detail WHERE id_document = '99187' 
11/10/2025 09:54:52 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '99187' , '24142' , 'DILEXI TE' , '1' ,  '-1' , '4' ,
                               '2.90' , '2.9' , '0' , '0' , '2.90' ) 
11/10/2025 11:17:13 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3318' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-11') 
11/10/2025 11:17:13 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '3318' ,
                          '2025-10-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '66.40' ,
                          '54.95' ,
                          NOW() ,
                          NOW() ) 
11/10/2025 11:17:13 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99188' 
11/10/2025 11:17:13 am >>  DELETE FROM ps_document_detail WHERE id_document = '99188' 
11/10/2025 11:17:13 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '99188' , '18895' , 'BRACCIALE DECINA COLORATA - B1757N' , '21' ,  '-21' , '1' ,
                               '2.00' , '1.6393442622951' , '22' , '0' , '42.00' ) 
11/10/2025 11:17: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
                            ( '99188' , '20062' , 'BRACCIALE DECINA - BD018' , '4' ,  '-4' , '1' ,
                               '2.00' , '1.6393442622951' , '22' , '0' , '8.00' ) 
11/10/2025 11:17: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
                            ( '99188' , '15387' , 'VESTINA BATTESIMALE ' , '3' ,  '-3' , '1' ,
                               '3.00' , '2.4590163934426' , '22' , '0' , '9.00' ) 
11/10/2025 11:17: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
                            ( '99188' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '3' ,  '-3' , '1' ,
                               '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 
11/10/2025 11:17: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
                            ( '99188' , '24142' , 'DILEXI TE' , '1' ,  '-1' , '4' ,
                               '2.90' , '2.9' , '0' , '0' , '2.90' ) 
11/10/2025 11:30:54 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3319' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-11') 
11/10/2025 11:30:54 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' ,
                          '3319' ,
                          '2025-10-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '4.75' ,
                          '4.75' ,
                          NOW() ,
                          NOW() ) 
11/10/2025 11:30:54 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 = '99189' 
11/10/2025 11:30:54 am >>  DELETE FROM ps_document_detail WHERE id_document = '99189' 
11/10/2025 11:30: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
                            ( '99189' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '5' , '4.75' ) 
11/10/2025 12:25:21 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3320' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-11') 
11/10/2025 12:25:21 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' ,
                          '3320' ,
                          '2025-10-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '186.00' ,
                          '152.98' ,
                          NOW() ,
                          NOW() ) 
11/10/2025 12:25:21 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 = '99190' 
11/10/2025 12:25:21 pm >>  DELETE FROM ps_document_detail WHERE id_document = '99190' 
11/10/2025 12:25:21 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
                            ( '99190' , '16795' , 'LUMINO 5F ROSSO' , '336' ,  '-336' , '1' ,
                               '0.30' , '0.24590163934426' , '22' , '0' , '100.80' ) 
11/10/2025 12:25:21 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
                            ( '99190' , '24126' , 'AGENDA DEVOZIONALE 2026  PREGAGENDA - 40829' , '1' ,  '-1' , '1' ,
                               '14.00' , '11.475409836066' , '22' , '5' , '13.30' ) 
11/10/2025 12:25:21 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
                            ( '99190' , '24142' , 'DILEXI TE' , '1' ,  '-1' , '4' ,
                               '2.90' , '2.9' , '0' , '0' , '2.90' ) 
11/10/2025 12:25:22 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '99190' , '17617' , 'IMMAGINI ISONZO X 100' , '2' ,  '-2' , '1' ,
                               '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 
11/10/2025 12:25:22 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '99190' , '17617' , 'IMMAGINI ISONZO X 100' , '1' ,  '-1' , '1' ,
                               '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 
11/10/2025 12:25:22 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '99190' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '59' , '48.360655737705' , '22' , '0' , '59.00' ) 
11/10/2025 12:27:17 pm >> UPDATE ps_product_shop SET
                  minimal_quantity = '1',
                  multiple_quantity = '1',
                  available_date = '',
                  date_upd = NOW()
                WHERE id_product = '2918' 
11/10/2025 12:27:17 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '2918' 
11/10/2025 12:27:39 pm >> UPDATE ps_product_shop SET
                  minimal_quantity = '1',
                  multiple_quantity = '1',
                  available_date = '',
                  date_upd = NOW()
                WHERE id_product = '5943' 
11/10/2025 12:27:39 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '5943' 
11/10/2025 12:45:35 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3321' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-11') 
11/10/2025 12:45:35 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '3321' ,
                          '2025-10-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '84.00' ,
                          '68.85' ,
                          NOW() ,
                          NOW() ) 
11/10/2025 12:45: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 = '99191' 
11/10/2025 12:45:35 pm >>  DELETE FROM ps_document_detail WHERE id_document = '99191' 
11/10/2025 12:45:35 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '99191' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '73' , '59.83606557377' , '22' , '0' , '73.00' ) 
11/10/2025 12:45:35 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '99191' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' ,  '-1' , '1' ,
                               '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 
11/10/2025 12:45:53 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3322' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-11') 
11/10/2025 12:45:53 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' ,
                          '3322' ,
                          '2025-10-11' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '5.00' ,
                          '4.10' ,
                          NOW() ,
                          NOW() ) 
11/10/2025 12:45:53 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 = '99192' 
11/10/2025 12:45:53 pm >>  DELETE FROM ps_document_detail WHERE id_document = '99192' 
11/10/2025 12:45:53 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
                            ( '99192' , '23609' , 'CALAMITA 8X8 ' , '1' ,  '-1' , '1' ,
                               '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 
11/10/2025 01:01:16 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4251' 
11/10/2025 01:01:16 pm >> INSERT INTO ps_address
            ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd )
            VALUES (
              '4251' ,
              '10' ,
              '200' ,
              '' ,
              'PAFFETTI' ,
              'LUCIANO' ,
              'VIA PONTE NOVE LUCI 18' ,
              '' ,
              '85100' ,
              'POTENZA' ,
              '' ,
              '' ,
              '3498770680' ,
              '' ,
              '' ,
              NOW()  ,
              NOW()  ) 
11/10/2025 01:01:16 pm >> UPDATE ps_customer SET
                email = 'Paffetti.Luciano@tiscali.it',
                sdi = '',
                pec = '',
                date_upd = NOW()
          WHERE id_customer = '4251'