10/12/2022 09:54:08 am >> SELECT document_num FROM ps_document WHERE document_num = '3811' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 09:54: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' , '3811' , '2022-12-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.50' , '21.72' , NOW() , NOW() ) 10/12/2022 09:54: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 = '76689' 10/12/2022 09:54:08 am >> DELETE FROM ps_document_detail WHERE id_document = '76689' 10/12/2022 09:54: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 ( '76689' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25.5' , '20.901639344262' , '22' , '0' , '25.50' ) 10/12/2022 09:54:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 10/12/2022 09:54:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 10/12/2022 09:54: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 ( '76689' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 10/12/2022 09:54:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 10/12/2022 09:54:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 10/12/2022 09:57:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3812' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 09:57:40 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' , '3812' , '2022-12-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.10' , '39.43' , NOW() , NOW() ) 10/12/2022 09:57:40 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 = '76690' 10/12/2022 09:57:40 am >> DELETE FROM ps_document_detail WHERE id_document = '76690' 10/12/2022 09:57:40 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 ( '76690' , '20158' , 'CASETTA NATIVITA\' - 23/97NAT04' , '37' , '-37' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '48.10' ) 10/12/2022 09:57:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '20158' AND id_supplier = '' 10/12/2022 09:57:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20158' , '' , '1' ) 10/12/2022 10:02:44 am >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 10/12/2022 10:02:44 am >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'acconto: 300,00 13/10/2022 - 300,00 18/11 - 250,00 10/12', 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 = '2530.00', price_tax_excluded = '2073.77', date_upd = NOW() WHERE id_document = '56617' 10/12/2022 10:02: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 = '56617' 10/12/2022 10:02:44 am >> DELETE FROM ps_document_detail WHERE id_document = '56617' 10/12/2022 10:02: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 ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 10/12/2022 10:02:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '18788' AND id_supplier = '' 10/12/2022 10:02:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18788' , '' , '1' ) 10/12/2022 10:02: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 ( '56617' , '0' , 'COTTA ' , '1' , '-1' , '1' , '680.0000' , '557.37704918033' , '22' , '0' , '680.00' ) 10/12/2022 10:02:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 10/12/2022 10:02:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 10/12/2022 10:30:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3813' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 10:30:01 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' , '3813' , '2022-12-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '148.00' , '121.31' , NOW() , NOW() ) 10/12/2022 10:30:01 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 = '76691' 10/12/2022 10:30:01 am >> DELETE FROM ps_document_detail WHERE id_document = '76691' 10/12/2022 10:30: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 ( '76691' , '20224' , 'BAMBINELLO GESSO CM 30 - J202OA/30' , '1' , '-1' , '1' , '148.00' , '121.31147540984' , '22' , '0' , '148.00' ) 10/12/2022 10:30:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '20224' AND id_supplier = '' 10/12/2022 10:30:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20224' , '' , '1' ) 10/12/2022 10:30:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3814' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 10:30:59 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' , '3814' , '2022-12-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 10/12/2022 10:30:59 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 = '76692' 10/12/2022 10:30:59 am >> DELETE FROM ps_document_detail WHERE id_document = '76692' 10/12/2022 10:30:59 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 ( '76692' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 10/12/2022 10:30:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 10/12/2022 10:31:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 10/12/2022 10:31:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76692' , '15774' , 'INCENSO NARJAN - 500G' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 10/12/2022 10:31:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '15774' AND id_supplier = '' 10/12/2022 10:31:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15774' , '' , '1' ) 10/12/2022 10:35:44 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 10/12/2022 10:35:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20502' , '1' , '' , 'nuovo-prodotto' ) 10/12/2022 10:35:44 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20502' , '1' , '1' , '2' , NOW() , NOW() ) 10/12/2022 10:35:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20502' , '0' , '1' , '0' , '0' ) 10/12/2022 10:46:16 am >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 10/12/2022 10:46:16 am >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '415.00', price_tax_excluded = '357.30', date_upd = NOW() WHERE id_document = '59768' 10/12/2022 10:46:16 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 = '59768' 10/12/2022 10:46:16 am >> DELETE FROM ps_document_detail WHERE id_document = '59768' 10/12/2022 10:46:16 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 ( '59768' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 10/12/2022 10:46:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 10/12/2022 10:46:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 10/12/2022 10:46:16 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 ( '59768' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 10/12/2022 10:46:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 10/12/2022 10:46:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 10/12/2022 10:46:17 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 ( '59768' , '0' , 'BAMBINELLO' , '1' , '-1' , '0' , '70.0000' , '70' , '0' , '0' , '70.00' ) 10/12/2022 10:46:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 10/12/2022 10:46:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 10/12/2022 10:46:17 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 ( '59768' , '0' , 'BAMBINELLO' , '1' , '-1' , '0' , '25.0000' , '25' , '0' , '0' , '25.00' ) 10/12/2022 10:46:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 10/12/2022 10:46:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 10/12/2022 10:48:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3815' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 10:48:55 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' , '3815' , '2022-12-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '121.40' , '106.05' , NOW() , NOW() ) 10/12/2022 10:48:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76693' 10/12/2022 10:48:55 am >> DELETE FROM ps_document_detail WHERE id_document = '76693' 10/12/2022 10:48:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76693' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 10/12/2022 10:48:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 10/12/2022 10:48:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 10/12/2022 10:48:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76693' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '11.40' ) 10/12/2022 10:48:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 10/12/2022 10:48:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 10/12/2022 10:48:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76693' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '9' , '-9' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '31.50' ) 10/12/2022 10:48:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 10/12/2022 10:48:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 10/12/2022 10:48:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76693' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 10/12/2022 10:48:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 10/12/2022 10:48:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 10/12/2022 10:48:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76693' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 10/12/2022 10:48:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 10/12/2022 10:48:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 10/12/2022 10:48:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76693' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 10/12/2022 10:48:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 10/12/2022 10:48:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 10/12/2022 10:48:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76693' , '6872' , 'NASCITA DI GESÙ BAMBINO - 189' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 10/12/2022 10:48:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '6872' AND id_supplier = '' 10/12/2022 10:48:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6872' , '' , '1' ) 10/12/2022 10:48:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76693' , '19056' , 'NOVENA AL SANTO NATALE - A. CANOPI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 10/12/2022 10:48:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19056' AND id_supplier = '' 10/12/2022 10:48:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19056' , '' , '1' ) 10/12/2022 10:52:31 am >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 10/12/2022 10:52:31 am >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'acconto: 300,00 13/10/2022 - 300,00 18/11 - 250,00 10/12', 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 = '2615.00', price_tax_excluded = '2143.44', date_upd = NOW() WHERE id_document = '56617' 10/12/2022 10:52:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56617' 10/12/2022 10:52:31 am >> DELETE FROM ps_document_detail WHERE id_document = '56617' 10/12/2022 10:52:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '18788' , 'CASULA ACETATO VISCOSA - 65/020628' , '1' , '-1' , '1' , '1850.0000' , '1516.393442623' , '22' , '0' , '1850.00' ) 10/12/2022 10:52:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '18788' AND id_supplier = '' 10/12/2022 10:52:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18788' , '' , '1' ) 10/12/2022 10:52:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '0' , 'COTTA ' , '1' , '-1' , '1' , '680.0000' , '557.37704918033' , '22' , '0' , '680.00' ) 10/12/2022 10:52:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 10/12/2022 10:52:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 10/12/2022 10:52:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56617' , '18984' , 'POLO FELPATO ML + cardigan' , '1' , '-1' , '1' , '85' , '69.672131147541' , '22' , '0' , '85.00' ) 10/12/2022 10:52:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '18984' AND id_supplier = '' 10/12/2022 10:52:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18984' , '' , '1' ) 10/12/2022 10:56:32 am >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 10/12/2022 10:56:32 am >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '900.00', price_tax_excluded = '842.30', date_upd = NOW() WHERE id_document = '59768' 10/12/2022 10:56: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 = '59768' 10/12/2022 10:56:32 am >> DELETE FROM ps_document_detail WHERE id_document = '59768' 10/12/2022 10:56: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 ( '59768' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 10/12/2022 10:56:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 10/12/2022 10:56:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 10/12/2022 10:56: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 ( '59768' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 10/12/2022 10:56:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 10/12/2022 10:56:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 10/12/2022 10:56: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 ( '59768' , '0' , 'BAMBINELLO' , '1' , '-1' , '0' , '70.0000' , '70' , '0' , '0' , '70.00' ) 10/12/2022 10:56:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 10/12/2022 10:56:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 10/12/2022 10:56: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 ( '59768' , '0' , 'BAMBINELLO' , '1' , '-1' , '0' , '25.0000' , '25' , '0' , '0' , '25.00' ) 10/12/2022 10:56:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 10/12/2022 10:56:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 10/12/2022 10:56: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 ( '59768' , '' , 'bambino + culla terracot 450+35' , '1' , '-1' , '0' , '485' , '485' , '' , '0' , '485.00' ) 10/12/2022 10:56:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 10/12/2022 10:56:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 10/12/2022 11:23:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3810' AND id_document != '76688' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-09') 10/12/2022 11:23:10 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3810', document_date = '2022-12-09', 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 = '49.40', price_tax_excluded = '40.49', date_upd = NOW() WHERE id_document = '76688' 10/12/2022 11:23:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76688' 10/12/2022 11:23:10 am >> DELETE FROM ps_document_detail WHERE id_document = '76688' 10/12/2022 11:23:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76688' , '19073' , 'BAMBINELLO CM 4,5 - PB0501' , '1' , '-1' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '2.40' ) 10/12/2022 11:23:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '19073' AND id_supplier = '' 10/12/2022 11:23:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19073' , '' , '1' ) 10/12/2022 11:23:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76688' , '16314' , 'BAMBINO CM 6' , '1' , '-1' , '1' , '1.7000' , '1.3934426229508' , '22' , '0' , '1.70' ) 10/12/2022 11:23:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '16314' AND id_supplier = '' 10/12/2022 11:23:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16314' , '' , '1' ) 10/12/2022 11:23:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76688' , '14835' , 'STELLA COMETA - P581' , '1' , '-1' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '2.40' ) 10/12/2022 11:23:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '14835' AND id_supplier = '' 10/12/2022 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14835' , '' , '1' ) 10/12/2022 11:23:11 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 ( '76688' , '20157' , 'ALBERO DI NATALE - 23/92NAT04' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 10/12/2022 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '20157' AND id_supplier = '' 10/12/2022 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20157' , '' , '1' ) 10/12/2022 11:23:11 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 ( '76688' , '20163' , 'QUADRETTO CAMPANA - 23/77C' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 10/12/2022 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '20163' AND id_supplier = '' 10/12/2022 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20163' , '' , '1' ) 10/12/2022 11:23:11 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 ( '76688' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 10/12/2022 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '20156' AND id_supplier = '' 10/12/2022 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20156' , '' , '1' ) 10/12/2022 11:23:11 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 ( '76688' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '17.1' , '14.016393442623' , '22' , '0' , '17.10' ) 10/12/2022 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 10/12/2022 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 10/12/2022 11:23:11 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 ( '76688' , '18172' , 'CONFEZIONE SCATOLA PORTA CIUCCIO' , '1' , '-1' , '1' , '21.90' , '17.950819672131' , '22' , '0' , '21.90' ) 10/12/2022 11:23:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '18172' AND id_supplier = '' 10/12/2022 11:23:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18172' , '' , '1' ) 10/12/2022 11:28:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3810' AND id_document != '76688' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-09') 10/12/2022 11:28:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3810', document_date = '2022-12-09', 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 = '49.40', price_tax_excluded = '40.49', date_upd = NOW() WHERE id_document = '76688' 10/12/2022 11:28: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 = '76688' 10/12/2022 11:28:53 am >> DELETE FROM ps_document_detail WHERE id_document = '76688' 10/12/2022 11:28: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 ( '76688' , '16314' , 'BAMBINO CM 6' , '1' , '-1' , '1' , '1.7000' , '1.3934426229508' , '22' , '0' , '1.70' ) 10/12/2022 11:28:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '16314' AND id_supplier = '' 10/12/2022 11:28:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16314' , '' , '1' ) 10/12/2022 11:28: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 ( '76688' , '14835' , 'STELLA COMETA - P581' , '1' , '-1' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '2.40' ) 10/12/2022 11:28:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '14835' AND id_supplier = '' 10/12/2022 11:28:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14835' , '' , '1' ) 10/12/2022 11:28: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 ( '76688' , '20157' , 'ALBERO DI NATALE - 23/92NAT04' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 10/12/2022 11:28:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '20157' AND id_supplier = '' 10/12/2022 11:28:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20157' , '' , '1' ) 10/12/2022 11:28: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 ( '76688' , '20163' , 'QUADRETTO CAMPANA - 23/77C' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 10/12/2022 11:28:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '20163' AND id_supplier = '' 10/12/2022 11:28:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20163' , '' , '1' ) 10/12/2022 11:28: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 ( '76688' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 10/12/2022 11:28:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '20156' AND id_supplier = '' 10/12/2022 11:28:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20156' , '' , '1' ) 10/12/2022 11:28: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 ( '76688' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '19.5' , '15.983606557377' , '22' , '0' , '19.50' ) 10/12/2022 11:28:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 10/12/2022 11:28:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 10/12/2022 11:28: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 ( '76688' , '18172' , 'CONFEZIONE SCATOLA PORTA CIUCCIO' , '1' , '-1' , '1' , '21.9000' , '17.950819672131' , '22' , '0' , '21.90' ) 10/12/2022 11:28:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '18172' AND id_supplier = '' 10/12/2022 11:28:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18172' , '' , '1' ) 10/12/2022 11:30:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3816' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 11:30:55 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' , '3816' , '2022-12-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 10/12/2022 11:30:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76694' 10/12/2022 11:30:55 am >> DELETE FROM ps_document_detail WHERE id_document = '76694' 10/12/2022 11:30:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76694' , '14064' , 'STELLARIO PLEX CM 16' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 10/12/2022 11:30:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '14064' AND id_supplier = '' 10/12/2022 11:30:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14064' , '' , '1' ) 10/12/2022 11:33:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3812' AND id_document != '76690' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 11:33:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3812', document_date = '2022-12-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 = '48.10', price_tax_excluded = '39.43', date_upd = NOW() WHERE id_document = '76690' 10/12/2022 11:33: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 = '76690' 10/12/2022 11:33:13 am >> DELETE FROM ps_document_detail WHERE id_document = '76690' 10/12/2022 11:33: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 ( '76690' , '14831' , 'CAPANNA IN CARTONCINO - P574' , '37' , '-37' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '48.10' ) 10/12/2022 11:33:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '14831' AND id_supplier = '' 10/12/2022 11:33:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14831' , '' , '1' ) 10/12/2022 11:33:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3810' AND id_document != '76688' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-09') 10/12/2022 11:33:51 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3810', document_date = '2022-12-09', 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 = '49.40', price_tax_excluded = '40.49', date_upd = NOW() WHERE id_document = '76688' 10/12/2022 11:33:51 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 = '76688' 10/12/2022 11:33:51 am >> DELETE FROM ps_document_detail WHERE id_document = '76688' 10/12/2022 11:33:51 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 ( '76688' , '16314' , 'BAMBINO CM 6' , '1' , '-1' , '1' , '1.7000' , '1.3934426229508' , '22' , '0' , '1.70' ) 10/12/2022 11:33:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '16314' AND id_supplier = '' 10/12/2022 11:33:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16314' , '' , '1' ) 10/12/2022 11:33:51 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 ( '76688' , '14835' , 'STELLA COMETA - P581' , '1' , '-1' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '2.40' ) 10/12/2022 11:33:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '14835' AND id_supplier = '' 10/12/2022 11:33:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14835' , '' , '1' ) 10/12/2022 11:33:51 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 ( '76688' , '20157' , 'ALBERO DI NATALE - 23/92NAT04' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 10/12/2022 11:33:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '20157' AND id_supplier = '' 10/12/2022 11:33:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20157' , '' , '1' ) 10/12/2022 11:33:51 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 ( '76688' , '20163' , 'QUADRETTO CAMPANA - 23/77C' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 10/12/2022 11:33:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '20163' AND id_supplier = '' 10/12/2022 11:33:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20163' , '' , '1' ) 10/12/2022 11:33:51 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 ( '76688' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 10/12/2022 11:33:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '20156' AND id_supplier = '' 10/12/2022 11:33:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20156' , '' , '1' ) 10/12/2022 11:33:51 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 ( '76688' , '18172' , 'CONFEZIONE SCATOLA PORTA CIUCCIO' , '1' , '-1' , '1' , '21.9000' , '17.950819672131' , '22' , '0' , '21.90' ) 10/12/2022 11:33:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '18172' AND id_supplier = '' 10/12/2022 11:33:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18172' , '' , '1' ) 10/12/2022 11:33:51 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 ( '76688' , '14831' , 'CAPANNA IN CARTONCINO - P574' , '13' , '-13' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '19.50' ) 10/12/2022 11:33:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '14831' AND id_supplier = '' 10/12/2022 11:33:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14831' , '' , '1' ) 10/12/2022 11:34:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3807' AND id_document != '76685' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-09') 10/12/2022 11:34:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3807', document_date = '2022-12-09', 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 = '43.50', price_tax_excluded = '35.66', date_upd = NOW() WHERE id_document = '76685' 10/12/2022 11:34:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76685' 10/12/2022 11:34:31 am >> DELETE FROM ps_document_detail WHERE id_document = '76685' 10/12/2022 11:34:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76685' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25.5' , '20.901639344262' , '22' , '0' , '25.50' ) 10/12/2022 11:34:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 10/12/2022 11:34:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 10/12/2022 11:34:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76685' , '14831' , 'CAPANNA IN CARTONCINO - P574' , '12' , '-12' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '18.00' ) 10/12/2022 11:34:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '14831' AND id_supplier = '' 10/12/2022 11:34:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14831' , '' , '1' ) 10/12/2022 11:35:14 am >> SELECT document_num FROM ps_document WHERE document_num = '87/A' AND id_document != '69688' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-27') 10/12/2022 11:35:14 am >> UPDATE ps_document SET id_document_type = '24', document_num = '87/A', document_date = '2022-10-27', document_letter = 'A', id_customer = '846', id_supplier = '', id_address = '4670897', address1 = 'VIA ROCCO COCCHIA, 12/16 84129 SALERNO', 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 = '183.60', price_tax_excluded = '183.60', date_upd = NOW() WHERE id_document = '69688' 10/12/2022 11:35:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69688' 10/12/2022 11:35:14 am >> DELETE FROM ps_document_detail WHERE id_document = '69688' 10/12/2022 11:35: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 ( '69688' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '90' , '-90' , '4' , '2.4000' , '2.4' , '0' , '15' , '183.60' ) 10/12/2022 11:35:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 10/12/2022 11:35:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 10/12/2022 11:35:36 am >> SELECT document_num FROM ps_document WHERE document_num = '333' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 11:35:36 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' , '333' , '2022-12-10' , '' , '846' , '0' , '4670897' , 'VIA ROCCO COCCHIA, 12/16 84129 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '183.60' , '183.60' , NOW() , NOW() ) 10/12/2022 11:35:36 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 = '76695' 10/12/2022 11:35:36 am >> DELETE FROM ps_document_detail WHERE id_document = '76695' 10/12/2022 11:35:36 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 ( '76695' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '90' , '-90' , '4' , '2.40' , '2.4' , '0' , '15' , '183.60' ) 10/12/2022 11:35:47 am >> DELETE FROM ps_document WHERE id_document = '69688' 10/12/2022 11:35:47 am >> DELETE FROM ps_document_detail WHERE id_document = '69688' 10/12/2022 11:38:03 am >> SELECT document_num FROM ps_document WHERE document_num = '3817' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 11:38:03 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' , '3817' , '2022-12-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.56' , '6.56' , NOW() , NOW() ) 10/12/2022 11:38: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 = '76696' 10/12/2022 11:38:03 am >> DELETE FROM ps_document_detail WHERE id_document = '76696' 10/12/2022 11:38: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 ( '76696' , '19946' , 'PENSIERI EUCARISTICI 2023' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 10/12/2022 11:38:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19946' AND id_supplier = '' 10/12/2022 11:38:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19946' , '' , '1' ) 10/12/2022 11:42:27 am >> SELECT document_num FROM ps_document WHERE document_num = '3818' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 11:42:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3818' , '2022-12-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 10/12/2022 11:42:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76697' 10/12/2022 11:42:27 am >> DELETE FROM ps_document_detail WHERE id_document = '76697' 10/12/2022 11:42:28 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 ( '76697' , '20172' , 'ANGELO MUSICANTE CM 10 - R12' , '3' , '-3' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '13.50' ) 10/12/2022 11:42:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '20172' AND id_supplier = '' 10/12/2022 11:42:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20172' , '' , '1' ) 10/12/2022 11:45:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3819' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 11:45:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3819' , '2022-12-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '95.87' , NOW() , NOW() ) 10/12/2022 11:45:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76698' 10/12/2022 11:45:14 am >> DELETE FROM ps_document_detail WHERE id_document = '76698' 10/12/2022 11:45: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 ( '76698' , '7202' , 'ARTICOLI RELIGIOSI' , '20' , '-20' , '1' , '3.8' , '3.1147540983607' , '22' , '0' , '76.00' ) 10/12/2022 11:45:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 10/12/2022 11:45:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 10/12/2022 11:45:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76698' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4' , '3.8461538461538' , '4' , '0' , '8.00' ) 10/12/2022 11:45:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 10/12/2022 11:45:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 10/12/2022 11:45:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76698' , '11151' , 'LIBRI' , '10' , '-10' , '4' , '2.3' , '2.3' , '0' , '0' , '23.00' ) 10/12/2022 11:45:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 10/12/2022 11:45:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 10/12/2022 11:45:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76698' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '3' , '2.8846153846154' , '4' , '0' , '3.00' ) 10/12/2022 11:45:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 10/12/2022 11:45:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 10/12/2022 12:03:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002077' AND id_product != '20481' AND ean13 != '' 10/12/2022 12:03:34 pm >> UPDATE ps_product SET id_supplier = '134', reference = '', ean13 = '002077', date_upd = NOW() WHERE id_product = '20481' 10/12/2022 12:03:34 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' 50CM - PB8940 + PB8942', description = '
DA ORDINARE PB8941 BUE ASINO
' WHERE id_product = '20481' 10/12/2022 12:03:34 pm >> UPDATE ps_product SET wholesale_price = '238.40', on_sale = '0', price = '523.7705' WHERE id_product = '20481' 10/12/2022 12:03:34 pm >> UPDATE ps_product_shop SET wholesale_price = '238.40', price = '523.7705', id_tax_rules_group = '1', id_category_default = '458', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20481' 10/12/2022 12:03:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '20481' 10/12/2022 12:06:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '333' AND id_document != '76695' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 12:06:20 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '333', document_date = '2022-12-10', document_letter = '', id_customer = '846', id_supplier = '', id_address = '4670897', address1 = 'VIA ROCCO COCCHIA, 12/16 84129 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 = '183.60', price_tax_excluded = '183.60', date_upd = NOW() WHERE id_document = '76695' 10/12/2022 12:06:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '76695' 10/12/2022 12:06:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '76695' 10/12/2022 12:06:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '76695' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '90' , '-90' , '4' , '2.4000' , '2.4' , '0' , '15' , '183.60' ) 10/12/2022 12:06:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 10/12/2022 12:06:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 10/12/2022 12:09:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3820' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 12:09:34 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' , '3820' , '2022-12-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 10/12/2022 12:09:34 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 = '76699' 10/12/2022 12:09:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '76699' 10/12/2022 12:09:34 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 ( '76699' , '1290' , 'BRACCIALE 7 DONI - 820/07' , '5' , '-5' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '19.00' ) 10/12/2022 12:09:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1290' AND id_supplier = '' 10/12/2022 12:09:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1290' , '' , '1' ) 10/12/2022 12:17:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3821' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 12:17:54 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' , '3821' , '2022-12-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 10/12/2022 12:17:54 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 = '76700' 10/12/2022 12:17:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '76700' 10/12/2022 12:17:54 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 ( '76700' , '6396' , 'MELODIE DI NATALE' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 10/12/2022 12:17:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6396' AND id_supplier = '' 10/12/2022 12:17:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6396' , '' , '1' ) 10/12/2022 12:23:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3822' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 12:23:50 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' , '3822' , '2022-12-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.00' , '94.26' , NOW() , NOW() ) 10/12/2022 12:23:50 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 = '76701' 10/12/2022 12:23:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '76701' 10/12/2022 12:23:50 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 ( '76701' , '18029' , 'TURIBOLO H 14 CON NAVETTA' , '1' , '-1' , '1' , '115.00' , '94.262295081967' , '22' , '0' , '115.00' ) 10/12/2022 12:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18029' AND id_supplier = '' 10/12/2022 12:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18029' , '' , '1' ) 10/12/2022 12:35:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3823' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-10') 10/12/2022 12:35:39 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' , '3823' , '2022-12-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '15.98' , NOW() , NOW() ) 10/12/2022 12:35:39 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 = '76702' 10/12/2022 12:35:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '76702' 10/12/2022 12:35:39 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 ( '76702' , '17800' , 'GESU BAMBINO DI PRAGA CM 12' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 10/12/2022 12:35:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17800' AND id_supplier = '' 10/12/2022 12:35:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17800' , '' , '1' ) 10/12/2022 12:35:39 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 ( '76702' , '20154' , 'QUADRETTO CULLA ANGELO DI DIO ROSA - 5510SC' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 10/12/2022 12:35:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20154' AND id_supplier = '' 10/12/2022 12:35:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20154' , '' , '1' ) 10/12/2022 12:35:39 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 ( '76702' , '20153' , 'QUADRETTO CULLA ANGELO DI DIO CELESTE - 5510SC' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 10/12/2022 12:35:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20153' AND id_supplier = '' 10/12/2022 12:35:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20153' , '' , '1' )