17/04/2025 07:27:01 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/04/2025 07:27:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23680' , '1' , '' , 'nuovo-prodotto' ) 17/04/2025 07:27:01 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23680' , '1' , '1' , '2' , NOW() , NOW() ) 17/04/2025 07:27:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23680' , '0' , '1' , '0' , '0' ) 17/04/2025 08:45:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884045706' AND id_product != '23680' AND ean13 != '' 17/04/2025 08:45:54 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884045706', date_upd = NOW() WHERE id_product = '23680' 17/04/2025 08:45:54 am >> UPDATE ps_product_lang SET name = 'REGISTRO DELLE MESSE - SHA', description = '' WHERE id_product = '23680' 17/04/2025 08:45:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.19672131147541' WHERE id_product = '23680' 17/04/2025 08:45:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '106', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23680' 17/04/2025 08:45:54 am >> DELETE FROM ps_specific_price WHERE id_product = '23680' 17/04/2025 08:46: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 ( '31' , '6073/00/2025' , '2025-04-15' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '264.00' , '262.92' , NOW() , NOW() ) 17/04/2025 08:46:19 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 = '96741' 17/04/2025 08:46:19 am >> DELETE FROM ps_document_detail WHERE id_document = '96741' 17/04/2025 08:46:19 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 ( '96741' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '75' , '75' , '4' , '5.00' , '5' , '0' , '40' , '225.0000' ) 17/04/2025 08:46:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '23536' AND id_supplier = '38' 17/04/2025 08:46:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23536' , '38' , '1' ) 17/04/2025 08:46:19 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 ( '96741' , '19503' , 'UN MESE CON MARIA - 8064' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 17/04/2025 08:46:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '19503' AND id_supplier = '38' 17/04/2025 08:46:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19503' , '38' , '1' ) 17/04/2025 08:46:19 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 ( '96741' , '19587' , 'GESU BAMBINO DI PRAGA - 8079' , '1' , '1' , '4' , '3.00' , '3' , '0' , '40' , '1.8000' ) 17/04/2025 08:46:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '19587' AND id_supplier = '38' 17/04/2025 08:46:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19587' , '38' , '1' ) 17/04/2025 08:46:19 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 ( '96741' , '2756' , 'CORONA ANGELICA - 8197' , '3' , '3' , '4' , '2.00' , '2' , '0' , '40' , '3.6000' ) 17/04/2025 08:46:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '2756' AND id_supplier = '38' 17/04/2025 08:46:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2756' , '38' , '1' ) 17/04/2025 08:46:19 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 ( '96741' , '10870' , 'UN MESE CON LA MEDAGLIA MIRACOLOSA - 8382' , '1' , '1' , '4' , '5.00' , '5' , '0' , '40' , '3.0000' ) 17/04/2025 08:46:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '10870' AND id_supplier = '38' 17/04/2025 08:46:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10870' , '38' , '1' ) 17/04/2025 08:46:19 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 ( '96741' , '6663' , 'MIE PREGHIERE - 8783' , '16' , '16' , '4' , '2.00' , '2' , '0' , '40' , '19.2000' ) 17/04/2025 08:46:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '6663' AND id_supplier = '38' 17/04/2025 08:46:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6663' , '38' , '1' ) 17/04/2025 08:46:19 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 ( '96741' , '23680' , 'REGISTRO DELLE MESSE - SHA' , '1' , '1' , '1' , '8.196' , '6.7180327868852' , '22' , '40' , '5.9995' ) 17/04/2025 08:46:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '23680' AND id_supplier = '38' 17/04/2025 08:46:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23680' , '38' , '1' ) 17/04/2025 09:32:09 am >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 17/04/2025 09:32:09 am >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 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 = '23.90', price_tax_excluded = '19.59', date_upd = NOW() WHERE id_document = '94912' 17/04/2025 09:32:09 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 = '94912' 17/04/2025 09:32:09 am >> DELETE FROM ps_document_detail WHERE id_document = '94912' 17/04/2025 09:32:09 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 ( '94912' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 17/04/2025 09:32:09 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 ( '94912' , '6812' , 'MOCCOLO 80X300 ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 17/04/2025 10:09:59 am >> SELECT document_num FROM ps_document WHERE document_num = '1292' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 17/04/2025 10:09: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' , '1292' , '2025-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.14' , '84.67' , NOW() , NOW() ) 17/04/2025 10:09: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 = '96742' 17/04/2025 10:09:59 am >> DELETE FROM ps_document_detail WHERE id_document = '96742' 17/04/2025 10:09: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 ( '96742' , '21692' , 'GENERATI DALLO SPIRITO - A. LOUF' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 17/04/2025 10:09: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 ( '96742' , '23639' , 'UNA PARROCCHIA DI PALLINE DARGILLA' , '1' , '-1' , '4' , '8.90' , '8.9' , '0' , '5' , '8.46' ) 17/04/2025 10:09: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 ( '96742' , '23644' , 'DE ODIO - M. RECALCATI' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 17/04/2025 10:09: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 ( '96742' , '23640' , 'BIBBIA TOB NUOVO TESTAMENTO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 17/04/2025 10:09: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 ( '96742' , '3103' , 'CROCE SAN BENEDETTO' , '10' , '-10' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '15.00' ) 17/04/2025 10:09: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 ( '96742' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '12' , '-12' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '26.40' ) 17/04/2025 10:38:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1293' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 17/04/2025 10:38:58 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' , '1293' , '2025-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '16.03' , NOW() , NOW() ) 17/04/2025 10:38:58 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 = '96743' 17/04/2025 10:38:58 am >> DELETE FROM ps_document_detail WHERE id_document = '96743' 17/04/2025 10:38:58 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 ( '96743' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 17/04/2025 10:38:58 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 ( '96743' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '3' , '-3' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '9.00' ) 17/04/2025 11:05:37 am >> SELECT document_num FROM ps_document WHERE document_num = '15' AND id_document != '96694' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-04-15') 17/04/2025 11:05:37 am >> UPDATE ps_document SET id_document_type = '24', document_num = '15', document_date = '2025-04-15', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '3740.00', price_tax_excluded = '3740.00', date_upd = NOW() WHERE id_document = '96694' 17/04/2025 11:05:37 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 = '96694' 17/04/2025 11:05:37 am >> DELETE FROM ps_document_detail WHERE id_document = '96694' 17/04/2025 11:05:37 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 ( '96694' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '500' , '-500' , '4' , '1.0000' , '1' , '0' , '0' , '500.00' ) 17/04/2025 11:05:37 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 ( '96694' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '30' , '-30' , '4' , '7.0000' , '7' , '0' , '0' , '210.00' ) 17/04/2025 11:05:37 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 ( '96694' , '23673' , 'RIVESTITI DI SPERANZA! - V. SIRACUSA' , '468' , '-468' , '4' , '5.0000' , '5' , '0' , '0' , '2340.00' ) 17/04/2025 11:05:37 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 ( '96694' , '23420' , 'SPERANZA. PER VIVERE NELLA GIOIA - R. LUPI' , '50' , '-50' , '4' , '3.0000' , '3' , '0' , '0' , '150.00' ) 17/04/2025 11:05:37 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 ( '96694' , '23674' , 'DONO DI GRAZIA - V. SIRACUSA' , '108' , '-108' , '4' , '5.00' , '5' , '0' , '0' , '540.00' ) 17/04/2025 11:18:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1294' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 17/04/2025 11:18:20 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' , '1294' , '2025-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.00' , '50.00' , NOW() , NOW() ) 17/04/2025 11:18: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 = '96744' 17/04/2025 11:18:20 am >> DELETE FROM ps_document_detail WHERE id_document = '96744' 17/04/2025 11:18: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 ( '96744' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '61' , '50' , '22' , '0' , '61.00' ) 17/04/2025 11:20:23 am >> SELECT document_num FROM ps_document WHERE document_num = '1295' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 17/04/2025 11:20:23 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' , '1295' , '2025-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.37' , NOW() , NOW() ) 17/04/2025 11:20:23 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 = '96745' 17/04/2025 11:20:23 am >> DELETE FROM ps_document_detail WHERE id_document = '96745' 17/04/2025 11:20:23 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 ( '96745' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '3.5' , '3.3653846153846' , '4' , '0' , '3.50' ) 17/04/2025 11:22:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1295' AND id_document != '96745' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 17/04/2025 11:22:43 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1295', document_date = '2025-04-17', 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 = '3.50', price_tax_excluded = '3.37', date_upd = NOW() WHERE id_document = '96745' 17/04/2025 11:22: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 = '96745' 17/04/2025 11:22:43 am >> DELETE FROM ps_document_detail WHERE id_document = '96745' 17/04/2025 11:22: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 ( '96745' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 17/04/2025 11:44:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1296' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 17/04/2025 11:44:32 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' , '1296' , '2025-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.00' , '50.00' , NOW() , NOW() ) 17/04/2025 11:44: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 = '96746' 17/04/2025 11:44:32 am >> DELETE FROM ps_document_detail WHERE id_document = '96746' 17/04/2025 11:44: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 ( '96746' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '61' , '50' , '22' , '0' , '61.00' ) 17/04/2025 11:45:09 am >> SELECT document_num FROM ps_document WHERE document_num = '1297' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 17/04/2025 11:45:09 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' , '1297' , '2025-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 17/04/2025 11:45:09 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 = '96747' 17/04/2025 11:45:09 am >> DELETE FROM ps_document_detail WHERE id_document = '96747' 17/04/2025 11:45:09 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 ( '96747' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 17/04/2025 12:11:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1298' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 17/04/2025 12:11:36 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' , '1298' , '2025-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.00' , '48.08' , NOW() , NOW() ) 17/04/2025 12:11:36 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 = '96748' 17/04/2025 12:11:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '96748' 17/04/2025 12:11:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96748' , '17734' , 'VANGELO E ATTI BAMBINI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 17/04/2025 12:11:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96748' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 17/04/2025 12:21:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1299' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 17/04/2025 12:21: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' , '1299' , '2025-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '46.72' , NOW() , NOW() ) 17/04/2025 12:21: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 = '96749' 17/04/2025 12:21:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '96749' 17/04/2025 12:21: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 ( '96749' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 17/04/2025 12:21: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 ( '96749' , '21558' , 'ANELLO DECINA ARG - M043' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 17/04/2025 12:29:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '63/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-17') 17/04/2025 12:29:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '63/A' , '2025-04-17' , 'A' , '3712' , '0' , '4671443' , 'VIA DALMAZIA 6 84121 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.40' , '79.61' , NOW() , NOW() ) 17/04/2025 12:29:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96750' 17/04/2025 12:29:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '96750' 17/04/2025 12:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96750' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 17/04/2025 12:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96750' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 17/04/2025 12:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96750' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 17/04/2025 12:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96750' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 17/04/2025 12:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96750' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 17/04/2025 12:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96750' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 17/04/2025 12:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96750' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 17/04/2025 12:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96750' , '6019' , 'LUMINO ROSSO - 10B' , '26' , '-26' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '13.00' ) 17/04/2025 12:29:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96750' , '6014' , 'LUMINO BIANCO - 10B' , '26' , '-26' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '13.00' ) 17/04/2025 12:32:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '8/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-17') 17/04/2025 12:32:57 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 ( '23' , '8/S' , '2025-04-17' , 'S' , '3487' , '0' , '177359088' , 'VIA RIGLA 44 24010 PONTERANICA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '37.50' , '37.50' , NOW() , NOW() ) 17/04/2025 12:32:57 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 = '14806' 17/04/2025 12:32:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '14806' 17/04/2025 12:32:57 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 ( '14806' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '0' , '37.50' ) 17/04/2025 12:38:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1300' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 17/04/2025 12:38:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1300' , '2025-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 17/04/2025 12:38:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96751' 17/04/2025 12:38:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '96751' 17/04/2025 12:38:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96751' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 17/04/2025 12:50:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1301' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 17/04/2025 12:50:05 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' , '1301' , '2025-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.00' , '36.07' , NOW() , NOW() ) 17/04/2025 12:50:05 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 = '96752' 17/04/2025 12:50:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '96752' 17/04/2025 12:50:05 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 ( '96752' , '21080' , 'ROSARIO ARG. MADREPERLA - 328CAV' , '1' , '-1' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '36.50' ) 17/04/2025 12:50:05 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 ( '96752' , '19786' , 'ROSARIO MADREPERLA MM5 - 10M5' , '1' , '-1' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '7.50' ) 17/04/2025 01:00:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1302' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 17/04/2025 01:00:06 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' , '1302' , '2025-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '111.00' , '90.98' , NOW() , NOW() ) 17/04/2025 01:00:06 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 = '96753' 17/04/2025 01:00:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '96753' 17/04/2025 01:00:06 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 ( '96753' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '111' , '90.983606557377' , '22' , '0' , '111.00' ) 17/04/2025 01:02:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1302' AND id_document != '96753' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 17/04/2025 01:02:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1302', document_date = '2025-04-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '111.00', price_tax_excluded = '90.98', date_upd = NOW() WHERE id_document = '96753' 17/04/2025 01:02:04 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 = '96753' 17/04/2025 01:02:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '96753' 17/04/2025 01:02:04 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 ( '96753' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '111.0000' , '90.983606557377' , '22' , '0' , '111.00' )