04/03/2023 08:48:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886616966' AND id_product != '2777' AND ean13 != '' 04/03/2023 08:48:04 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788886616966', date_upd = NOW() WHERE id_product = '2777' 04/03/2023 08:48:04 am >> UPDATE ps_product_lang SET name = 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189', description = '' WHERE id_product = '2777' 04/03/2023 08:48:04 am >> UPDATE ps_product SET wholesale_price = '1.20', on_sale = '0', price = '3' WHERE id_product = '2777' 04/03/2023 08:48:04 am >> UPDATE ps_product_shop SET wholesale_price = '1.20', price = '3', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '2777' 04/03/2023 08:48:04 am >> DELETE FROM ps_specific_price WHERE id_product = '2777' 04/03/2023 09:15:35 am >> SELECT document_num FROM ps_document WHERE document_num = '712' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-04') 04/03/2023 09:15:35 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' , '712' , '2023-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.40' , '30.40' , NOW() , NOW() ) 04/03/2023 09:15:35 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 = '82128' 04/03/2023 09:15:35 am >> DELETE FROM ps_document_detail WHERE id_document = '82128' 04/03/2023 09:15:35 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 ( '82128' , '1134' , 'BIBBIA DI GERUSALEMME NERA' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' ) 04/03/2023 09:58:47 am >> SELECT document_num FROM ps_document WHERE document_num = '708' AND id_document != '82120' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-03') 04/03/2023 09:58:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '708', document_date = '2023-03-03', 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 = '98.90', price_tax_excluded = '83.11', date_upd = NOW() WHERE id_document = '82120' 04/03/2023 09:58:47 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 = '82120' 04/03/2023 09:58:47 am >> DELETE FROM ps_document_detail WHERE id_document = '82120' 04/03/2023 09:58:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82120' , '18561' , 'FORMELLA SAGOMATA 26X26 - TENERO ABBRACCIO 1025130' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 04/03/2023 09:58:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82120' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '12.00' ) 04/03/2023 09:58:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82120' , '9070' , 'ROSARIO E CORONCINA ALLO SPIRITO SANTO - 8250' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 04/03/2023 10:30:24 am >> DELETE FROM ps_document WHERE id_document = '82087' 04/03/2023 10:30:24 am >> DELETE FROM ps_document_detail WHERE id_document = '82087' 04/03/2023 10:44:08 am >> SELECT document_num FROM ps_document WHERE document_num = '713' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-04') 04/03/2023 10:44:08 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' , '713' , '2023-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.90' , '32.70' , NOW() , NOW() ) 04/03/2023 10:44:08 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 = '82129' 04/03/2023 10:44:08 am >> DELETE FROM ps_document_detail WHERE id_document = '82129' 04/03/2023 10:44:08 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 ( '82129' , '19773' , 'ROSARIO ARGENTO/LEGNO S. BENEDETTO' , '1' , '-1' , '1' , '39.90' , '32.704918032787' , '22' , '0' , '39.90' ) 04/03/2023 10:46:44 am >> SELECT document_num FROM ps_document WHERE document_num = '41' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-04') 04/03/2023 10:46:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '41' , '2023-03-04' , '' , '1175' , '0' , '4672789' , 'VIA BUONSERVIZI, 25 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.00' , '46.00' , NOW() , NOW() ) 04/03/2023 10:46:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82130' 04/03/2023 10:46:44 am >> DELETE FROM ps_document_detail WHERE id_document = '82130' 04/03/2023 10:46:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82130' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '34' , '-34' , '4' , '1.60' , '1.6' , '0' , '15' , '46.24' ) 04/03/2023 10:46:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82130' , '' , 'arrotondamento' , '1' , '-1' , '4' , '-0.24' , '-0.24' , '0' , '0' , '-0.24' ) 04/03/2023 10:50:39 am >> SELECT document_num FROM ps_document WHERE document_num = '714' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-04') 04/03/2023 10:50:39 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' , '714' , '2023-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 04/03/2023 10:50:39 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 = '82131' 04/03/2023 10:50:39 am >> DELETE FROM ps_document_detail WHERE id_document = '82131' 04/03/2023 10:50:39 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 ( '82131' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 04/03/2023 11:06:49 am >> SELECT document_num FROM ps_document WHERE document_num = '715' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-03-04') 04/03/2023 11:06:49 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' , '715' , '2023-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 04/03/2023 11:06:49 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 = '82132' 04/03/2023 11:06:49 am >> DELETE FROM ps_document_detail WHERE id_document = '82132' 04/03/2023 11:06:49 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 ( '82132' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 04/03/2023 11:19:48 am >> SELECT document_num FROM ps_document WHERE document_num = '716' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-04') 04/03/2023 11:19:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '716' , '2023-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '355.90' , '291.72' , NOW() , NOW() ) 04/03/2023 11:19:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82133' 04/03/2023 11:19:48 am >> DELETE FROM ps_document_detail WHERE id_document = '82133' 04/03/2023 11:19:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82133' , '9463' , 'SAN GIUSEPPE - 33 ' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 04/03/2023 11:19:49 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 ( '82133' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 04/03/2023 11:19:49 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 ( '82133' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '99.00' ) 04/03/2023 11:19:49 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 ( '82133' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 04/03/2023 11:19:49 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 ( '82133' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '1' , '130' , '106.55737704918' , '22' , '0' , '130.00' ) 04/03/2023 11:19:49 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 ( '82133' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '1' , '-1' , '1' , '27' , '22.131147540984' , '22' , '0' , '27.00' ) 04/03/2023 11:27:03 am >> SELECT document_num FROM ps_document WHERE document_num = '41' AND id_document != '82130' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-04') 04/03/2023 11:27:03 am >> UPDATE ps_document SET id_document_type = '21', document_num = '41', document_date = '2023-03-04', document_letter = '', id_customer = '1175', id_supplier = '', id_address = '4672789', address1 = 'VIA BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '46.00', price_tax_excluded = '46.00', date_upd = NOW() WHERE id_document = '82130' 04/03/2023 11:27:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82130' 04/03/2023 11:27:03 am >> DELETE FROM ps_document_detail WHERE id_document = '82130' 04/03/2023 11:27:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82130' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '34' , '-34' , '4' , '1.6000' , '1.6' , '0' , '15' , '46.24' ) 04/03/2023 11:27:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82130' , '0' , 'arrotondamento' , '1' , '-1' , '4' , '-0.2400' , '-0.24' , '0' , '0' , '-0.24' ) 04/03/2023 11:48:49 am >> SELECT document_num FROM ps_document WHERE document_num = '717' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-04') 04/03/2023 11:48:49 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' , '717' , '2023-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.50' , '43.03' , NOW() , NOW() ) 04/03/2023 11:48:49 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 = '82134' 04/03/2023 11:48:49 am >> DELETE FROM ps_document_detail WHERE id_document = '82134' 04/03/2023 11:48:49 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 ( '82134' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 04/03/2023 11:48:49 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 ( '82134' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 04/03/2023 11:48:49 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 ( '82134' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 04/03/2023 12:35:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '718' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-04') 04/03/2023 12:35:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '718' , '2023-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 04/03/2023 12:35:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82135' 04/03/2023 12:35:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '82135' 04/03/2023 12:35:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82135' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 04/03/2023 12:56:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '719' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-04') 04/03/2023 12:56:29 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' , '719' , '2023-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.50' , '104.50' , NOW() , NOW() ) 04/03/2023 12:56:29 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 = '82136' 04/03/2023 12:56:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '82136' 04/03/2023 12:56:29 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 ( '82136' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '5' , '104.50' ) 04/03/2023 12:58:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '720' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-04') 04/03/2023 12:58:08 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' , '720' , '2023-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '8.65' , NOW() , NOW() ) 04/03/2023 12:58:08 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 = '82137' 04/03/2023 12:58:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '82137' 04/03/2023 12:58:08 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 ( '82137' , '17710' , 'OSTIA MAGNA CM 14 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 04/03/2023 12:58:08 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 ( '82137' , '19089' , 'OSTIA MAGNA 150 -OM150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 04/03/2023 01:00:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '721' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-04') 04/03/2023 01:00:41 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' , '721' , '2023-03-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 04/03/2023 01:00:41 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 = '82138' 04/03/2023 01:00:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '82138' 04/03/2023 01:00:41 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 ( '82138' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' )