17/12/2022 08:50:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2810' AND id_document != '61906' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-22') 17/12/2022 08:50:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2810', document_date = '2022-09-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '62.00', price_tax_excluded = '50.82', date_upd = NOW() WHERE id_document = '61906' 17/12/2022 08:50: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 = '61906' 17/12/2022 08:50:13 am >> DELETE FROM ps_document_detail WHERE id_document = '61906' 17/12/2022 08:50: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 ( '61906' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2' , '1.6393442622951' , '22' , '0' , '4.00' ) 17/12/2022 08:50:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 17/12/2022 08:50:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 17/12/2022 08:50: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 ( '61906' , '19429' , 'QUADRO DECORATO 35X29 - RC' , '1' , '-1' , '1' , '48' , '39.344262295082' , '22' , '0' , '48.00' ) 17/12/2022 08:50:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19429' AND id_supplier = '' 17/12/2022 08:50:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19429' , '' , '1' ) 17/12/2022 08:50: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 ( '61906' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 17/12/2022 08:50:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 17/12/2022 08:50:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 17/12/2022 09:36:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3912' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 09:36:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3912' , '2022-12-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.60' , '21.60' , NOW() , NOW() ) 17/12/2022 09:36:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77333' 17/12/2022 09:36:54 am >> DELETE FROM ps_document_detail WHERE id_document = '77333' 17/12/2022 09:36: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 ( '77333' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '2' , '-2' , '4' , '10.8' , '10.8' , '0' , '0' , '21.60' ) 17/12/2022 09:36:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19361' AND id_supplier = '' 17/12/2022 09:36:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19361' , '' , '1' ) 17/12/2022 09:40:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3913' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 09:40:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3913' , '2022-12-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 17/12/2022 09:40:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77334' 17/12/2022 09:40:06 am >> DELETE FROM ps_document_detail WHERE id_document = '77334' 17/12/2022 09:40:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77334' , '19074' , 'BAMBINELLO CM 11,5 - PB0127' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 17/12/2022 09:40:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '19074' AND id_supplier = '' 17/12/2022 09:40:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19074' , '' , '1' ) 17/12/2022 09:46:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3914' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 09:46:51 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' , '3914' , '2022-12-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.05' , '57.60' , NOW() , NOW() ) 17/12/2022 09:46: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 = '77335' 17/12/2022 09:46:51 am >> DELETE FROM ps_document_detail WHERE id_document = '77335' 17/12/2022 09:46: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 ( '77335' , '19692' , 'SEMPLICITA STILE DI VITA - R. FISICHELLA' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 17/12/2022 09:46:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '19692' AND id_supplier = '' 17/12/2022 09:46:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19692' , '' , '1' ) 17/12/2022 09:46: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 ( '77335' , '2426' , 'COLLETTO SEMPLICE - CM 3,5 ' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 17/12/2022 09:46:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '2426' AND id_supplier = '' 17/12/2022 09:46:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2426' , '' , '1' ) 17/12/2022 09:46: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 ( '77335' , '18881' , 'STOLA POLIESTERE - PST020' , '2' , '-2' , '1' , '19.4' , '15.901639344262' , '22' , '0' , '38.80' ) 17/12/2022 09:46:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '18881' AND id_supplier = '' 17/12/2022 09:46:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18881' , '' , '1' ) 17/12/2022 09:57:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3915' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 09:57: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' , '3915' , '2022-12-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '185.03' , '161.86' , NOW() , NOW() ) 17/12/2022 09:57: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 = '77336' 17/12/2022 09:57:39 am >> DELETE FROM ps_document_detail WHERE id_document = '77336' 17/12/2022 09:57: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 ( '77336' , '17414' , 'BIBBIA SCRUTATE LE SCRITTURE - TELATA' , '1' , '-1' , '4' , '34.00' , '34' , '0' , '5' , '32.30' ) 17/12/2022 09:57:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '17414' AND id_supplier = '' 17/12/2022 09:57:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17414' , '' , '1' ) 17/12/2022 09:57: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 ( '77336' , '1143' , 'BIBBIA DI GERUSALEMME - TASCABILE' , '1' , '-1' , '4' , '21.90' , '21.9' , '0' , '5' , '20.81' ) 17/12/2022 09:57:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '1143' AND id_supplier = '' 17/12/2022 09:57:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1143' , '' , '1' ) 17/12/2022 09:57: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 ( '77336' , '4372' , 'GESÙ BAMBINO - 265 ' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 17/12/2022 09:57:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '4372' AND id_supplier = '' 17/12/2022 09:57:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4372' , '' , '1' ) 17/12/2022 09:57: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 ( '77336' , '20442' , 'INSIEME NELLA MESSA - GEN. 23' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 17/12/2022 09:57:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '20442' AND id_supplier = '' 17/12/2022 09:57:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20442' , '' , '1' ) 17/12/2022 09:57: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 ( '77336' , '20480' , 'INSIEME NELLA MESSA - FEB 2023' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 17/12/2022 09:57:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '20480' AND id_supplier = '' 17/12/2022 09:57:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20480' , '' , '1' ) 17/12/2022 09:57: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 ( '77336' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 17/12/2022 09:57:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 17/12/2022 09:57:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 17/12/2022 09:57: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 ( '77336' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 17/12/2022 09:57:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 17/12/2022 09:57:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 17/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 ( '77336' , '19772' , 'BRACCIALE ARGENTO/EMATITE' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 17/12/2022 09:57:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19772' AND id_supplier = '' 17/12/2022 09:57:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19772' , '' , '1' ) 17/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 ( '77336' , '19771' , 'ROSARIO ARGENTO/EMATITE' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 17/12/2022 09:57:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19771' AND id_supplier = '' 17/12/2022 09:57:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19771' , '' , '1' ) 17/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 ( '77336' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 17/12/2022 09:57:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '' 17/12/2022 09:57:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '' , '1' ) 17/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 ( '77336' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 17/12/2022 09:57:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 17/12/2022 09:57:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 17/12/2022 10:03:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3916' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 10:03:18 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' , '3916' , '2022-12-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 17/12/2022 10:03:18 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 = '77337' 17/12/2022 10:03:18 am >> DELETE FROM ps_document_detail WHERE id_document = '77337' 17/12/2022 10:03:18 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 ( '77337' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 17/12/2022 10:03:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 17/12/2022 10:03:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 17/12/2022 10:05:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3917' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 10:05:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3917' , '2022-12-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.75' , '61.75' , NOW() , NOW() ) 17/12/2022 10:05:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77338' 17/12/2022 10:05:24 am >> DELETE FROM ps_document_detail WHERE id_document = '77338' 17/12/2022 10:05:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77338' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '13' , '-13' , '4' , '5.00' , '5' , '0' , '5' , '61.75' ) 17/12/2022 10:05:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 17/12/2022 10:05:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 17/12/2022 10:06:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3918' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 10:06:43 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' , '3918' , '2022-12-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.72' , '24.72' , NOW() , NOW() ) 17/12/2022 10:06:43 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 = '77339' 17/12/2022 10:06:43 am >> DELETE FROM ps_document_detail WHERE id_document = '77339' 17/12/2022 10:06:43 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 ( '77339' , '20544' , 'padre nostro - spagnolo' , '4' , '-4' , '4' , '6.50' , '6.5' , '0' , '5' , '24.72' ) 17/12/2022 10:06:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '20544' AND id_supplier = '' 17/12/2022 10:06:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20544' , '' , '1' ) 17/12/2022 10:36:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2674' AND id_document != '61724' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-08') 17/12/2022 10:36:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2674', document_date = '2022-09-08', 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 = '155.96', price_tax_excluded = '129.04', date_upd = NOW() WHERE id_document = '61724' 17/12/2022 10:36:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61724' 17/12/2022 10:36:20 am >> DELETE FROM ps_document_detail WHERE id_document = '61724' 17/12/2022 10:36:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61724' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.4' , '6.0655737704918' , '22' , '0' , '7.40' ) 17/12/2022 10:36:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '15097' AND id_supplier = '' 17/12/2022 10:36:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15097' , '' , '1' ) 17/12/2022 10:36:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61724' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '5' , '6.66' ) 17/12/2022 10:36:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '11105' AND id_supplier = '' 17/12/2022 10:36:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11105' , '' , '1' ) 17/12/2022 10:36:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61724' , '11272' , 'VETRO ROSSO RUBINO - VKINGS' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 17/12/2022 10:36:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '11272' AND id_supplier = '' 17/12/2022 10:36:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11272' , '' , '1' ) 17/12/2022 10:36:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61724' , '6011' , 'LUMINELLO VETRO - 474/25' , '3' , '-3' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '25.50' ) 17/12/2022 10:36:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '6011' AND id_supplier = '' 17/12/2022 10:36:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6011' , '' , '1' ) 17/12/2022 10:36:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61724' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 17/12/2022 10:36:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 17/12/2022 10:36:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 17/12/2022 10:36:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61724' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '30' , '-30' , '1' , '1' , '0.81967213114754' , '22' , '0' , '30.00' ) 17/12/2022 10:36:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 17/12/2022 10:36:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 17/12/2022 10:36:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2462' AND id_document != '59943' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-08') 17/12/2022 10:36:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2462', document_date = '2022-08-08', 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 = '104.00', price_tax_excluded = '87.05', date_upd = NOW() WHERE id_document = '59943' 17/12/2022 10:36:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59943' 17/12/2022 10:36:57 am >> DELETE FROM ps_document_detail WHERE id_document = '59943' 17/12/2022 10:36:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59943' , '16818' , 'INCENSO ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 17/12/2022 10:36:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '16818' AND id_supplier = '' 17/12/2022 10:36:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16818' , '' , '1' ) 17/12/2022 10:36:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59943' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 17/12/2022 10:36:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 17/12/2022 10:36:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 17/12/2022 10:36:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59943' , '11756' , 'VINO BIANCO SECCO - 14%' , '6' , '-6' , '1' , '5.5000' , '4.5081967213115' , '22' , '0' , '33.00' ) 17/12/2022 10:36:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 17/12/2022 10:36:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 17/12/2022 10:36:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59943' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '5.70' ) 17/12/2022 10:36:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 17/12/2022 10:36:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 17/12/2022 10:36:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59943' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 17/12/2022 10:36:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 17/12/2022 10:36:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 17/12/2022 10:36:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59943' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 17/12/2022 10:36:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 17/12/2022 10:36:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 17/12/2022 10:36:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59943' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '30' , '-30' , '1' , '1' , '0.81967213114754' , '22' , '0' , '30.00' ) 17/12/2022 10:36:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '9150' AND id_supplier = '' 17/12/2022 10:36:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9150' , '' , '1' ) 17/12/2022 10:52:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3919' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 10:52:57 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' , '3919' , '2022-12-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 17/12/2022 10:52:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77340' 17/12/2022 10:52:57 am >> DELETE FROM ps_document_detail WHERE id_document = '77340' 17/12/2022 10:52:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77340' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 17/12/2022 10:52:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 17/12/2022 10:52:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 17/12/2022 11:03:12 am >> SELECT document_num FROM ps_document WHERE document_num = '3920' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 11:03:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3920' , '2022-12-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 17/12/2022 11:03:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77341' 17/12/2022 11:03:12 am >> DELETE FROM ps_document_detail WHERE id_document = '77341' 17/12/2022 11:03:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77341' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 17/12/2022 11:03:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '1350' AND id_supplier = '' 17/12/2022 11:03:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1350' , '' , '1' ) 17/12/2022 11:04:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3921' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 11:04:02 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' , '3921' , '2022-12-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 17/12/2022 11:04:02 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 = '77342' 17/12/2022 11:04:02 am >> DELETE FROM ps_document_detail WHERE id_document = '77342' 17/12/2022 11:04:02 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 ( '77342' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 17/12/2022 11:04:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 17/12/2022 11:04:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 17/12/2022 11:06:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3922' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 11:06:56 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' , '3922' , '2022-12-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.70' , '6.31' , NOW() , NOW() ) 17/12/2022 11:06:56 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 = '77343' 17/12/2022 11:06:56 am >> DELETE FROM ps_document_detail WHERE id_document = '77343' 17/12/2022 11:06:56 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 ( '77343' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '6.60' ) 17/12/2022 11:06:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 17/12/2022 11:06:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 17/12/2022 11:06:56 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 ( '77343' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 17/12/2022 11:06:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 17/12/2022 11:06:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 17/12/2022 11:59:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000337' AND id_product != '1519' AND ean13 != '' 17/12/2022 11:59:49 am >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '000337', date_upd = NOW() WHERE id_product = '1519' 17/12/2022 11:59:50 am >> UPDATE ps_product_lang SET name = 'CALICE ESSENTIA - OGGETTI', description = '' WHERE id_product = '1519' 17/12/2022 11:59:50 am >> UPDATE ps_product SET wholesale_price = '405', on_sale = '0', price = '803.2787' WHERE id_product = '1519' 17/12/2022 11:59:50 am >> UPDATE ps_product_shop SET wholesale_price = '405', price = '803.2787', id_tax_rules_group = '1', id_category_default = '214', 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 = '1519' 17/12/2022 11:59:50 am >> DELETE FROM ps_specific_price WHERE id_product = '1519' 17/12/2022 12:00:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000337' AND id_product != '1519' AND ean13 != '' 17/12/2022 12:00:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '000337', date_upd = NOW() WHERE id_product = '1519' 17/12/2022 12:00:17 pm >> UPDATE ps_product_lang SET name = 'CALICE ESSENTIA - OGGETTI', description = '' WHERE id_product = '1519' 17/12/2022 12:00:17 pm >> UPDATE ps_product SET wholesale_price = '405', on_sale = '0', price = '803.2787' WHERE id_product = '1519' 17/12/2022 12:00:17 pm >> UPDATE ps_product_shop SET wholesale_price = '405', price = '803.2787', id_tax_rules_group = '1', id_category_default = '214', 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 = '1519' 17/12/2022 12:00:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '1519' 17/12/2022 12:01:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '294' AND id_document != '73728' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-19') 17/12/2022 12:01:23 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '294', document_date = '2022-11-19', document_letter = '', id_customer = '973', id_supplier = '', id_address = '4677360', address1 = 'VIA MUNICIPIO 83020 TORCHIATI-MONTORO ', address2 = '', note = 'DA SALDARE', 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 = '52.28', price_tax_excluded = '52.28', date_upd = NOW() WHERE id_document = '73728' 17/12/2022 12:01:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73728' 17/12/2022 12:01:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '73728' 17/12/2022 12:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73728' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 17/12/2022 12:01:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 17/12/2022 12:01:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 17/12/2022 12:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73728' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 17/12/2022 12:01:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 17/12/2022 12:01:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 17/12/2022 12:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73728' , '5457' , 'IO SONO CON VOI 1 PARTE' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '15' , '42.50' ) 17/12/2022 12:01:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 17/12/2022 12:01:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 17/12/2022 12:03:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '294' AND id_document != '73728' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-19') 17/12/2022 12:03:10 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '294', document_date = '2022-11-19', document_letter = '', id_customer = '973', id_supplier = '', id_address = '4677360', address1 = 'VIA MUNICIPIO 83020 TORCHIATI-MONTORO ', 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 = '52.28', price_tax_excluded = '52.28', date_upd = NOW() WHERE id_document = '73728' 17/12/2022 12:03:10 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 = '73728' 17/12/2022 12:03:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '73728' 17/12/2022 12:03:10 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 ( '73728' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 17/12/2022 12:03:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 17/12/2022 12:03:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 17/12/2022 12:03:10 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 ( '73728' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 17/12/2022 12:03:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 17/12/2022 12:03:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 17/12/2022 12:03:10 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 ( '73728' , '5457' , 'IO SONO CON VOI 1 PARTE' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '15' , '42.50' ) 17/12/2022 12:03:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 17/12/2022 12:03:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 17/12/2022 12:12:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3923' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 12:12:01 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' , '3923' , '2022-12-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 17/12/2022 12:12:01 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 = '77344' 17/12/2022 12:12:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '77344' 17/12/2022 12:12:01 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 ( '77344' , '16329' , 'GRUPPO NATIVITA CM 11' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 17/12/2022 12:12:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16329' AND id_supplier = '' 17/12/2022 12:12:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16329' , '' , '1' ) 17/12/2022 12:24:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '118/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 12:24: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 ( '24' , '118/A' , '2022-12-17' , 'A' , '973' , '0' , '4677360' , 'VIA MUNICIPIO 83020 TORCHIATI-MONTORO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 17/12/2022 12:24: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 = '77345' 17/12/2022 12:24:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '77345' 17/12/2022 12:24: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 ( '77345' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '2' , '-2' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '28.00' ) 17/12/2022 12:24: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 ( '77345' , '4205' , 'FINTA CANDELA 4X30 - 140 ' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 17/12/2022 12:24: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 ( '77345' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '2' , '-2' , '1' , '14' , '11.475409836066' , '22' , '0' , '28.00' ) 17/12/2022 12:24: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 ( '77345' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 17/12/2022 12:25:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3924' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 12:25:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3924' , '2022-12-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.80' , '52.98' , NOW() , NOW() ) 17/12/2022 12:25:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77346' 17/12/2022 12:25:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '77346' 17/12/2022 12:25:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77346' , '8398' , 'PREGHIERE PRIMA E DOPO LA COMUNIONE - 8276' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 17/12/2022 12:25:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8398' AND id_supplier = '' 17/12/2022 12:25:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8398' , '' , '1' ) 17/12/2022 12:25:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77346' , '14362' , 'CAMICE SVASATO - 434/TPA' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 17/12/2022 12:25:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14362' AND id_supplier = '' 17/12/2022 12:25:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14362' , '' , '1' ) 17/12/2022 12:29:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3925' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 12:29:58 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' , '3925' , '2022-12-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.50' , '0.50' , NOW() , NOW() ) 17/12/2022 12:29:58 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 = '77347' 17/12/2022 12:29:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '77347' 17/12/2022 12:29:58 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 ( '77347' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 17/12/2022 12:29:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 17/12/2022 12:29:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 17/12/2022 12:41:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3926' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-17') 17/12/2022 12:41:25 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' , '3926' , '2022-12-17' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '31.97' , NOW() , NOW() ) 17/12/2022 12:41:25 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 = '77348' 17/12/2022 12:41:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '77348' 17/12/2022 12:41:25 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 ( '77348' , '18167' , 'NAVETTA' , '1' , '-1' , '1' , '39.00' , '31.967213114754' , '22' , '0' , '39.00' ) 17/12/2022 12:41:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18167' AND id_supplier = '' 17/12/2022 12:41:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18167' , '' , '1' )