05/09/2025 09:08:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2871' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 09:08:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2871' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.30' , '5.98' , NOW() , NOW() ) 05/09/2025 09:08:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98609' 05/09/2025 09:08:48 am >> DELETE FROM ps_document_detail WHERE id_document = '98609' 05/09/2025 09:08:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98609' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 05/09/2025 09:08:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98609' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '2' , '-2' , '1' , '3' , '2.4590163934426' , '22' , '0' , '6.00' ) 05/09/2025 09:09:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2872' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 09:09:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2872' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 05/09/2025 09:09:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98610' 05/09/2025 09:09:44 am >> DELETE FROM ps_document_detail WHERE id_document = '98610' 05/09/2025 09:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98610' , '15096' , 'CORONA MATRIMONIO ARG - 197/35' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 05/09/2025 09:11:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2667' AND id_document != '98372' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-05') 05/09/2025 09:11:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2667', document_date = '2025-08-05', 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 = '25.00', price_tax_excluded = '20.49', date_upd = NOW() WHERE id_document = '98372' 05/09/2025 09:11:29 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 = '98372' 05/09/2025 09:11:29 am >> DELETE FROM ps_document_detail WHERE id_document = '98372' 05/09/2025 09:11:29 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 ( '98372' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '0.80' ) 05/09/2025 09:11:29 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 ( '98372' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '11' , '-11' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '24.20' ) 05/09/2025 09:11:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2648' AND id_document != '98346' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-04') 05/09/2025 09:11:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2648', document_date = '2025-08-04', 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 = '23.00', price_tax_excluded = '18.85', date_upd = NOW() WHERE id_document = '98346' 05/09/2025 09:11: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 = '98346' 05/09/2025 09:11:57 am >> DELETE FROM ps_document_detail WHERE id_document = '98346' 05/09/2025 09:11: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 ( '98346' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 05/09/2025 09:11: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 ( '98346' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '10' , '-10' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '22.00' ) 05/09/2025 09:12:24 am >> SELECT document_num FROM ps_document WHERE document_num = '2621' AND id_document != '98305' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-31') 05/09/2025 09:12:24 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2621', document_date = '2025-07-31', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '98305' 05/09/2025 09:12: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 = '98305' 05/09/2025 09:12:24 am >> DELETE FROM ps_document_detail WHERE id_document = '98305' 05/09/2025 09:12: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 ( '98305' , '20069' , 'SACCHETTO' , '15' , '-15' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '3.00' ) 05/09/2025 09:12:25 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 ( '98305' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 05/09/2025 09:12:25 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 ( '98305' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '10' , '-10' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '22.00' ) 05/09/2025 10:14:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2873' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 10:14:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2873' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.13' , '5.13' , NOW() , NOW() ) 05/09/2025 10:14:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98611' 05/09/2025 10:14:40 am >> DELETE FROM ps_document_detail WHERE id_document = '98611' 05/09/2025 10:14: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 ( '98611' , '23825' , 'INSIEME NELLA MESSA - SET 25' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 05/09/2025 10:14: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 ( '98611' , '23879' , 'INSIEME NELLA MESSA - OTT 25' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 05/09/2025 10:14: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 ( '98611' , '23942' , 'INSIEME NELLA MESSA - NOV 2025' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 05/09/2025 10:17:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2874' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 10:17:38 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' , '2874' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.10' , '9.06' , NOW() , NOW() ) 05/09/2025 10:17:38 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 = '98612' 05/09/2025 10:17:38 am >> DELETE FROM ps_document_detail WHERE id_document = '98612' 05/09/2025 10:17:38 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 ( '98612' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 05/09/2025 10:17:38 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 ( '98612' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 05/09/2025 10:17:38 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 ( '98612' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 05/09/2025 10:17:38 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 ( '98612' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 05/09/2025 10:50:25 am >> SELECT document_num FROM ps_document WHERE document_num = '90' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 10:50:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '90' , '2025-09-05' , '' , '3533' , '0' , '4672868' , 'VIALE FRENTANO 2 66030 MOZZAGROGNA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '86.70' , '86.70' , NOW() , NOW() ) 05/09/2025 10:50:25 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 = '98613' 05/09/2025 10:50:25 am >> DELETE FROM ps_document_detail WHERE id_document = '98613' 05/09/2025 10:50:25 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 ( '98613' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '14' , '-14' , '4' , '2.50' , '2.5' , '0' , '15' , '29.75' ) 05/09/2025 10:50:25 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 ( '98613' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '14' , '-14' , '4' , '3.50' , '3.5' , '0' , '15' , '41.65' ) 05/09/2025 10:50:25 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 ( '98613' , '17257' , 'IO TI BATTEZZO ' , '10' , '-10' , '4' , '1.80' , '1.8' , '0' , '15' , '15.30' ) 05/09/2025 11:08:23 am >> SELECT document_num FROM ps_document WHERE document_num = '23/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 11:08: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 ( '23' , '23/L' , '2025-09-05' , 'L' , '3479' , '0' , '4673306' , 'VIA SAN GREGORIO VII 28 84091 BATTIPAGLIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '190.00' , '190.00' , NOW() , NOW() ) 05/09/2025 11:08: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 = '98614' 05/09/2025 11:08:23 am >> DELETE FROM ps_document_detail WHERE id_document = '98614' 05/09/2025 11:08: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 ( '98614' , '' , 'STOLA ' , '2' , '-2' , '0' , '95' , '95' , '' , '0' , '190.00' ) 05/09/2025 11:39:10 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/09/2025 11:39:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23975' , '1' , '' , 'nuovo-prodotto' ) 05/09/2025 11:39:10 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23975' , '1' , '1' , '2' , NOW() , NOW() ) 05/09/2025 11:39:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23975' , '0' , '1' , '0' , '0' ) 05/09/2025 11:39:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256450275' AND id_product != '23975' AND ean13 != '' 05/09/2025 11:39:48 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791256450275', date_upd = NOW() WHERE id_product = '23975' 05/09/2025 11:39:48 am >> UPDATE ps_product_lang SET name = 'MESSALINO QUOTIDIANO - NOV DIC GEN', description = '' WHERE id_product = '23975' 05/09/2025 11:39:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '23975' 05/09/2025 11:39:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23975' 05/09/2025 11:39:48 am >> DELETE FROM ps_specific_price WHERE id_product = '23975' 05/09/2025 11:39:49 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23975' 05/09/2025 11:39:49 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23976' , '1' , '' , 'nuovo-prodotto' ) 05/09/2025 11:39:49 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23976' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23975' 05/09/2025 11:39:49 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23976' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23975' 05/09/2025 11:41:16 am >> SELECT document_num FROM ps_document WHERE document_num = '108/A' AND id_document != '98376' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-08-06') 05/09/2025 11:41:16 am >> UPDATE ps_document SET id_document_type = '24', document_num = '108/A', document_date = '2025-08-06', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '281.85', price_tax_excluded = '239.08', date_upd = NOW() WHERE id_document = '98376' 05/09/2025 11:41:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98376' 05/09/2025 11:41:16 am >> DELETE FROM ps_document_detail WHERE id_document = '98376' 05/09/2025 11:41:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98376' , '1914' , 'CERA DELLA LITURGIA' , '36' , '-36' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '169.20' ) 05/09/2025 11:41:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98376' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 05/09/2025 11:41:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98376' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 05/09/2025 11:41:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98376' , '23975' , 'MESSALINO QUOTIDIANO - NOV DIC GEN' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 05/09/2025 11:41:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98376' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/09/2025 11:41:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98376' , '3908' , 'ESERCIZI SPIRITUALI - IGNAZIO DI LOYOLA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 05/09/2025 11:41:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98376' , '18114' , 'MIA VITA - TERESA DI GESU' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '5' , '26.60' ) 05/09/2025 11:51: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 ( '33' , '707364' , '2025-09-03' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '7.44' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '257.76' , '257.76' , NOW() , NOW() ) 05/09/2025 11:51: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 = '98615' 05/09/2025 11:51:54 am >> DELETE FROM ps_document_detail WHERE id_document = '98615' 05/09/2025 11:51: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 ( '98615' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '24' , '24' , '4' , '14.00' , '14' , '0' , '33' , '225.1200' ) 05/09/2025 11:51:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '23966' AND id_supplier = '7' 05/09/2025 11:51:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23966' , '7' , '1' ) 05/09/2025 11:51: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 ( '98615' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '2' , '2' , '4' , '14.00' , '14' , '0' , '100' , '0.0000' ) 05/09/2025 11:51:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '23966' AND id_supplier = '7' 05/09/2025 11:51:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23966' , '7' , '1' ) 05/09/2025 11:51: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 ( '98615' , '23975' , 'MESSALINO QUOTIDIANO - NOV DIC GEN' , '6' , '6' , '4' , '6.00' , '6' , '0' , '30' , '25.2000' ) 05/09/2025 11:51:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '23975' AND id_supplier = '7' 05/09/2025 11:51:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23975' , '7' , '1' ) 05/09/2025 11:57:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002379' AND id_product != '23719' AND ean13 != '' 05/09/2025 11:57:27 am >> UPDATE ps_product SET id_supplier = '89', reference = '', ean13 = '002379', date_upd = NOW() WHERE id_product = '23719' 05/09/2025 11:57:27 am >> UPDATE ps_product_lang SET name = 'STOLA RICAMO CROCE - 796MTP', description = '' WHERE id_product = '23719' 05/09/2025 11:57:27 am >> UPDATE ps_product SET wholesale_price = '39.40', on_sale = '0', price = '77.8688524590164' WHERE id_product = '23719' 05/09/2025 11:57:27 am >> UPDATE ps_product_shop SET wholesale_price = '39.40', price = '77.8688524590164', id_tax_rules_group = '1', id_category_default = '396', 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 = '23719' 05/09/2025 11:57:27 am >> DELETE FROM ps_specific_price WHERE id_product = '23719' 05/09/2025 11:58:34 am >> SELECT document_num FROM ps_document WHERE document_num = '23/L' AND id_document != '98614' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 11:58:34 am >> UPDATE ps_document SET id_document_type = '23', document_num = '23/L', document_date = '2025-09-05', document_letter = 'L', id_customer = '3479', id_supplier = '', id_address = '4673306', address1 = 'VIA SAN GREGORIO VII 28 84091 BATTIPAGLIA', 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 = '456.00', price_tax_excluded = '421.74', date_upd = NOW() WHERE id_document = '98614' 05/09/2025 11:58:34 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 = '98614' 05/09/2025 11:58:34 am >> DELETE FROM ps_document_detail WHERE id_document = '98614' 05/09/2025 11:58:34 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 ( '98614' , '23719' , 'STOLA RICAMO CROCE - 796MTP' , '2' , '-2' , '1' , '95.00' , '77.868852459016' , '22' , '0' , '190.00' ) 05/09/2025 11:58:34 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 ( '98614' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '20' , '-20' , '4' , '14.00' , '14' , '0' , '5' , '266.00' ) 05/09/2025 12:01:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2748' AND id_document != '98463' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-27') 05/09/2025 12:01:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2748', document_date = '2025-08-27', 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 = '76.50', price_tax_excluded = '76.50', date_upd = NOW() WHERE id_document = '98463' 05/09/2025 12:01:26 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 = '98463' 05/09/2025 12:01:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '98463' 05/09/2025 12:01:26 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 ( '98463' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '15' , '-15' , '4' , '5.0000' , '5' , '0' , '5' , '71.25' ) 05/09/2025 12:01:26 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 ( '98463' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.25' , '5.25' , '0' , '0' , '5.25' ) 05/09/2025 12:09:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788829030729' AND id_product != '23976' AND ean13 != '' 05/09/2025 12:09:06 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788829030729', date_upd = NOW() WHERE id_product = '23976' 05/09/2025 12:09:06 pm >> UPDATE ps_product_lang SET name = 'GIULLARE DI DIO - AAVV', description = '' WHERE id_product = '23976' 05/09/2025 12:09:06 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '39' WHERE id_product = '23976' 05/09/2025 12:09:06 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '39', id_tax_rules_group = '4', id_category_default = '537', 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 = '23976' 05/09/2025 12:09:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '23976' 05/09/2025 12:09:08 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23976' 05/09/2025 12:09:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23977' , '1' , '' , 'nuovo-prodotto' ) 05/09/2025 12:09:08 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23977' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23976' 05/09/2025 12:09:08 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23977' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23976' 05/09/2025 12:10:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810799840' AND id_product != '23977' AND ean13 != '' 05/09/2025 12:10:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810799840', date_upd = NOW() WHERE id_product = '23977' 05/09/2025 12:10:07 pm >> UPDATE ps_product_lang SET name = 'LEONE XIV APOSTOLO DI PACE - S. PRUVOT', description = '' WHERE id_product = '23977' 05/09/2025 12:10:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '23977' 05/09/2025 12:10:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '9', 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 = '23977' 05/09/2025 12:10:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '23977' 05/09/2025 12:10:08 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23977' 05/09/2025 12:10:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23978' , '1' , '' , 'nuovo-prodotto' ) 05/09/2025 12:10:08 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23978' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23977' 05/09/2025 12:10:08 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23978' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23977' 05/09/2025 12:13:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '108/A' AND id_document != '98376' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-08-06') 05/09/2025 12:13:28 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '108/A', document_date = '2025-08-06', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '309.85', price_tax_excluded = '262.03', date_upd = NOW() WHERE id_document = '98376' 05/09/2025 12:13:28 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 = '98376' 05/09/2025 12:13:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '98376' 05/09/2025 12:13:28 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 ( '98376' , '1914' , 'CERA DELLA LITURGIA' , '36' , '-36' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '169.20' ) 05/09/2025 12:13:28 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 ( '98376' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 05/09/2025 12:13:28 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 ( '98376' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 05/09/2025 12:13:28 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 ( '98376' , '23975' , 'MESSALINO QUOTIDIANO - NOV DIC GEN' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 05/09/2025 12:13:28 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 ( '98376' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 05/09/2025 12:13:28 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 ( '98376' , '3908' , 'ESERCIZI SPIRITUALI - IGNAZIO DI LOYOLA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 05/09/2025 12:13:28 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 ( '98376' , '18114' , 'MIA VITA - TERESA DI GESU' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '5' , '26.60' ) 05/09/2025 12:13:28 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 ( '98376' , '7942' , 'PERGAMENE - OCCASIONI MOD. B' , '50' , '-50' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '25.00' ) 05/09/2025 12:13:28 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 ( '98376' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 05/09/2025 12:14:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259626455' AND id_product != '23978' AND ean13 != '' 05/09/2025 12:14:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9791259626455', date_upd = NOW() WHERE id_product = '23978' 05/09/2025 12:14:18 pm >> UPDATE ps_product_lang SET name = 'SACRA LITURGIA - E. FINOTTI', description = '' WHERE id_product = '23978' 05/09/2025 12:14:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26' WHERE id_product = '23978' 05/09/2025 12:14:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26', id_tax_rules_group = '4', id_category_default = '143', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23978' 05/09/2025 12:14:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '23978' 05/09/2025 12:14:19 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23978' 05/09/2025 12:14:19 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23979' , '1' , '' , 'nuovo-prodotto' ) 05/09/2025 12:14:19 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23979' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23978' 05/09/2025 12:14:19 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23979' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23978' 05/09/2025 12:15: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 ( '33' , '00257341' , '2025-09-04' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.25' , '180.25' , NOW() , NOW() ) 05/09/2025 12:15: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 = '98616' 05/09/2025 12:15:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '98616' 05/09/2025 12:15: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 ( '98616' , '23976' , 'GIULLARE DI DIO - AAVV' , '1' , '1' , '4' , '39.00' , '39' , '0' , '30' , '27.3000' ) 05/09/2025 12:15:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23976' AND id_supplier = '109' 05/09/2025 12:15:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23976' , '109' , '1' ) 05/09/2025 12:15: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 ( '98616' , '23978' , 'SACRA LITURGIA - E. FINOTTI' , '1' , '1' , '4' , '26.00' , '26' , '0' , '35' , '16.9000' ) 05/09/2025 12:15:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23978' AND id_supplier = '109' 05/09/2025 12:15:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23978' , '109' , '1' ) 05/09/2025 12:15: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 ( '98616' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '1' , '4' , '19.50' , '19.5' , '0' , '30' , '13.6500' ) 05/09/2025 12:15:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23045' AND id_supplier = '109' 05/09/2025 12:15:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23045' , '109' , '1' ) 05/09/2025 12:15: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 ( '98616' , '23977' , 'LEONE XIV APOSTOLO DI PACE - S. PRUVOT' , '1' , '1' , '4' , '14.00' , '14' , '0' , '40' , '8.4000' ) 05/09/2025 12:15:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23977' AND id_supplier = '109' 05/09/2025 12:15:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23977' , '109' , '1' ) 05/09/2025 12:15: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 ( '98616' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '5' , '5' , '4' , '38.00' , '38' , '0' , '40' , '114.0000' ) 05/09/2025 12:15:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1144' AND id_supplier = '109' 05/09/2025 12:15:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1144' , '109' , '1' ) 05/09/2025 12:35:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2875' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 12:35:26 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' , '2875' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 05/09/2025 12:35:26 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 = '98617' 05/09/2025 12:35:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '98617' 05/09/2025 12:35:26 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 ( '98617' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 05/09/2025 12:45:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2876' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 12:45:56 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' , '2876' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.10' , '64.64' , NOW() , NOW() ) 05/09/2025 12:45:56 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 = '98618' 05/09/2025 12:45:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '98618' 05/09/2025 12:45:56 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 ( '98618' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '58' , '47.540983606557' , '22' , '0' , '58.00' ) 05/09/2025 12:45:56 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 ( '98618' , '22821' , 'CARLO ACUTIS - G. PARIS' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 05/09/2025 03:15:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2877' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 03:15: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' , '2877' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.80' , '14.59' , NOW() , NOW() ) 05/09/2025 03:15: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 = '98619' 05/09/2025 03:15:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '98619' 05/09/2025 03:15: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 ( '98619' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 05/09/2025 03:22:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2871' AND id_document != '98609' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 03:22:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2871', document_date = '2025-09-05', 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 = '7.30', price_tax_excluded = '5.98', date_upd = NOW() WHERE id_document = '98609' 05/09/2025 03:22:46 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 = '98609' 05/09/2025 03:22:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '98609' 05/09/2025 03:22: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 ( '98609' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 05/09/2025 03:22: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 ( '98609' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 05/09/2025 03:27:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001782' AND id_product != '18561' AND ean13 != '' 05/09/2025 03:27:32 pm >> UPDATE ps_product SET id_supplier = '13', reference = '', ean13 = '001782', date_upd = NOW() WHERE id_product = '18561' 05/09/2025 03:27:32 pm >> UPDATE ps_product_lang SET name = 'FORMELLA SAGOMATA 26X26 ', description = '' WHERE id_product = '18561' 05/09/2025 03:27:32 pm >> UPDATE ps_product SET wholesale_price = '30.80', on_sale = '0', price = '80.32786885245902' WHERE id_product = '18561' 05/09/2025 03:27:32 pm >> UPDATE ps_product_shop SET wholesale_price = '30.80', price = '80.32786885245902', id_tax_rules_group = '1', id_category_default = '192', 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 = '18561' 05/09/2025 03:27:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '18561' 05/09/2025 03:28:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001782' AND id_product != '18561' AND ean13 != '' 05/09/2025 03:28:15 pm >> UPDATE ps_product SET id_supplier = '13', reference = '', ean13 = '001782', date_upd = NOW() WHERE id_product = '18561' 05/09/2025 03:28:15 pm >> UPDATE ps_product_lang SET name = 'FORMELLA SAGOMATA 26X26 ', description = '' WHERE id_product = '18561' 05/09/2025 03:28:15 pm >> UPDATE ps_product SET wholesale_price = '30.80', on_sale = '0', price = '80.32786885245902' WHERE id_product = '18561' 05/09/2025 03:28:15 pm >> UPDATE ps_product_shop SET wholesale_price = '30.80', price = '80.32786885245902', id_tax_rules_group = '1', id_category_default = '192', 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 = '18561' 05/09/2025 03:28:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '18561' 05/09/2025 03:28:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001782' AND id_product != '18561' AND ean13 != '' 05/09/2025 03:28:54 pm >> UPDATE ps_product SET id_supplier = '13', reference = '', ean13 = '001782', date_upd = NOW() WHERE id_product = '18561' 05/09/2025 03:28:54 pm >> UPDATE ps_product_lang SET name = 'FORMELLA SAGOMATA 26X26 ', description = '' WHERE id_product = '18561' 05/09/2025 03:28:54 pm >> UPDATE ps_product SET wholesale_price = '30.80', on_sale = '0', price = '80.32786885245902' WHERE id_product = '18561' 05/09/2025 03:28:55 pm >> UPDATE ps_product_shop SET wholesale_price = '30.80', price = '80.32786885245902', id_tax_rules_group = '1', id_category_default = '192', 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 = '18561' 05/09/2025 03:28:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '18561' 05/09/2025 04:22:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2878' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 04:22:59 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' , '2878' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '7.60' , NOW() , NOW() ) 05/09/2025 04:22:59 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 = '98620' 05/09/2025 04:22:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '98620' 05/09/2025 04:22:59 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 ( '98620' , '23867' , 'MESSA MEDITAZIONE - SETT/OTT 25' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 05/09/2025 04:27:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '24/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 04:27:46 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' , '24/L' , '2025-09-05' , 'L' , '2379' , '0' , '4671437' , 'R.NE PESCARA 84025 EBOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '618.30' , '615.41' , NOW() , NOW() ) 05/09/2025 04:27:46 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 = '98621' 05/09/2025 04:27:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '98621' 05/09/2025 04:27:46 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 ( '98621' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '20' , '56.00' ) 05/09/2025 04:27:46 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 ( '98621' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '10' , '54.00' ) 05/09/2025 04:27:46 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 ( '98621' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '10' , '81.00' ) 05/09/2025 04:27:46 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 ( '98621' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '40' , '-40' , '4' , '3.00' , '3' , '0' , '10' , '108.00' ) 05/09/2025 04:27:46 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 ( '98621' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '10' , '81.00' ) 05/09/2025 04:27:46 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 ( '98621' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '10' , '54.00' ) 05/09/2025 04:27:46 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 ( '98621' , '10740' , 'TROPPO FORTE - 1/ IL DECOLLO' , '20' , '-20' , '4' , '5.00' , '5' , '0' , '10' , '90.00' ) 05/09/2025 04:27:46 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 ( '98621' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '15' , '-15' , '4' , '5.00' , '5' , '0' , '10' , '67.50' ) 05/09/2025 04:27: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 ( '98621' , '5451' , 'IO SONO CON VOI - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '10' , '10.80' ) 05/09/2025 04:27: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 ( '98621' , '12819' , 'REGISTRO DEL CATECHISTA ' , '20' , '-20' , '1' , '1.00' , '0.81967213114754' , '22' , '20' , '16.00' ) 05/09/2025 04:32:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2879' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 04:32:26 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' , '2879' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '12.00' , NOW() , NOW() ) 05/09/2025 04:32:26 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 = '98622' 05/09/2025 04:32:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '98622' 05/09/2025 04:32:26 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 ( '98622' , '23958' , 'DIARIO SPIRITUALE SEGRETO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 05/09/2025 04:39:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '2880' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 04:39:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2880' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.30' , '13.30' , NOW() , NOW() ) 05/09/2025 04:39:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98623' 05/09/2025 04:39:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '98623' 05/09/2025 04:39:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98623' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 05/09/2025 04:41:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2881' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 04:41:18 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' , '2881' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.30' , '13.30' , NOW() , NOW() ) 05/09/2025 04:41:18 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 = '98624' 05/09/2025 04:41:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '98624' 05/09/2025 04:41:18 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 ( '98624' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 05/09/2025 05:13:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069624' AND id_product != '23979' AND ean13 != '' 05/09/2025 05:13:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '2/3', ean13 = '9788801069624', date_upd = NOW() WHERE id_product = '23979' 05/09/2025 05:13:20 pm >> UPDATE ps_product_lang SET name = 'AGENDA DEL CATECHISTA 25/26', description = '' WHERE id_product = '23979' 05/09/2025 05:13:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.9' WHERE id_product = '23979' 05/09/2025 05:13:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.9', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23979' 05/09/2025 05:13:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '23979' 05/09/2025 05:13:26 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/09/2025 05:13:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23980' , '1' , '' , 'nuovo-prodotto' ) 05/09/2025 05:13:26 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23980' , '1' , '1' , '2' , NOW() , NOW() ) 05/09/2025 05:13:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23980' , '0' , '1' , '0' , '0' ) 05/09/2025 05:14:15 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23979' 05/09/2025 05:14:16 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23981' , '1' , '' , 'nuovo-prodotto' ) 05/09/2025 05:14:16 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23981' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23979' 05/09/2025 05:14:16 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23981' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23979' 05/09/2025 05:15:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069587' AND id_product != '23981' AND ean13 != '' 05/09/2025 05:15:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788801069587', date_upd = NOW() WHERE id_product = '23981' 05/09/2025 05:15:05 pm >> UPDATE ps_product_lang SET name = 'ALZATI E VAI ', description = '' WHERE id_product = '23981' 05/09/2025 05:15:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '23981' 05/09/2025 05:15:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23981' 05/09/2025 05:15:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '23981' 05/09/2025 05:20:32 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 ( '33' , '707276' , '2025-09-03' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '44.86' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1413.95' , '1413.95' , NOW() , NOW() ) 05/09/2025 05:20:32 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 = '98625' 05/09/2025 05:20:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '98625' 05/09/2025 05:20:32 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 ( '98625' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35+7' , '9.0675' ) 05/09/2025 05:20:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22803' AND id_supplier = '7' 05/09/2025 05:20:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22803' , '7' , '1' ) 05/09/2025 05:20:32 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 ( '98625' , '14719' , 'TU MI AMI DAVVERO' , '10' , '10' , '4' , '6.90' , '6.9' , '0' , '30+7' , '44.9190' ) 05/09/2025 05:20:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '7' 05/09/2025 05:20:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '7' , '1' ) 05/09/2025 05:20:32 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 ( '98625' , '10748' , 'TU MI CHIAMI PER NOME' , '10' , '10' , '4' , '6.90' , '6.9' , '0' , '30+7' , '44.9190' ) 05/09/2025 05:20:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10748' AND id_supplier = '7' 05/09/2025 05:20:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10748' , '7' , '1' ) 05/09/2025 05:20:32 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 ( '98625' , '16129' , 'TU MI DONI IL TUO SPIRITO' , '10' , '10' , '4' , '6.90' , '6.9' , '0' , '30+7' , '44.9190' ) 05/09/2025 05:20:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16129' AND id_supplier = '7' 05/09/2025 05:20:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16129' , '7' , '1' ) 05/09/2025 05:20:32 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 ( '98625' , '10751' , 'TU MI PERDONI' , '10' , '10' , '4' , '6.90' , '6.9' , '0' , '30+7' , '44.9190' ) 05/09/2025 05:20:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '7' 05/09/2025 05:20:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '7' , '1' ) 05/09/2025 05:20:32 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 ( '98625' , '17245' , 'DIARIO DELLA MIA PRIMA COMUNIONE' , '2' , '2' , '4' , '5.90' , '5.9' , '0' , '30+7' , '7.6818' ) 05/09/2025 05:20:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17245' AND id_supplier = '7' 05/09/2025 05:20:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17245' , '7' , '1' ) 05/09/2025 05:20:32 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 ( '98625' , '2573' , 'CON GLI ADOLESCENTI' , '1' , '1' , '4' , '7.00' , '7' , '0' , '35+7' , '4.2315' ) 05/09/2025 05:20:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2573' AND id_supplier = '7' 05/09/2025 05:20:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2573' , '7' , '1' ) 05/09/2025 05:20:33 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 ( '98625' , '23377' , 'DON BOSCO UNA VITA UN GIOCO' , '1' , '1' , '4' , '5.90' , '5.9' , '0' , '35+7' , '3.5666' ) 05/09/2025 05:20:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23377' AND id_supplier = '7' 05/09/2025 05:20:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23377' , '7' , '1' ) 05/09/2025 05:20:33 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 ( '98625' , '23981' , 'ALZATI E VAI ' , '1' , '1' , '4' , '8.00' , '8' , '0' , '35+7' , '4.8360' ) 05/09/2025 05:20:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23981' AND id_supplier = '7' 05/09/2025 05:20:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23981' , '7' , '1' ) 05/09/2025 05:20:33 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 ( '98625' , '23979' , 'AGENDA DEL CATECHISTA 25/26' , '10' , '10' , '4' , '1.90' , '1.9' , '0' , '35+7' , '11.4855' ) 05/09/2025 05:20:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23979' AND id_supplier = '7' 05/09/2025 05:20:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23979' , '7' , '1' ) 05/09/2025 05:20:33 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 ( '98625' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '100' , '100' , '4' , '3.00' , '3' , '0' , '35+7' , '181.3500' ) 05/09/2025 05:20:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '7' 05/09/2025 05:20:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '7' , '1' ) 05/09/2025 05:20:33 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 ( '98625' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '100' , '100' , '4' , '3.00' , '3' , '0' , '35+7' , '181.3500' ) 05/09/2025 05:20:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '7' 05/09/2025 05:20:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '7' , '1' ) 05/09/2025 05:20:33 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 ( '98625' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '100' , '100' , '4' , '3.00' , '3' , '0' , '35+7' , '181.3500' ) 05/09/2025 05:20:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '7' 05/09/2025 05:20:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '7' , '1' ) 05/09/2025 05:20:33 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 ( '98625' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '100' , '100' , '4' , '3.00' , '3' , '0' , '35+7' , '181.3500' ) 05/09/2025 05:20:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '7' 05/09/2025 05:20:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '7' , '1' ) 05/09/2025 05:20:33 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 ( '98625' , '10740' , 'TROPPO FORTE - 1/ IL DECOLLO' , '25' , '25' , '4' , '5.00' , '5' , '0' , '35+7' , '75.5625' ) 05/09/2025 05:20:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10740' AND id_supplier = '7' 05/09/2025 05:20:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10740' , '7' , '1' ) 05/09/2025 05:20:33 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 ( '98625' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '20' , '20' , '4' , '5.00' , '5' , '0' , '35+7' , '60.4500' ) 05/09/2025 05:20:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10741' AND id_supplier = '7' 05/09/2025 05:20:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10741' , '7' , '1' ) 05/09/2025 05:20:33 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 ( '98625' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35+7' , '7.2540' ) 05/09/2025 05:20:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5450' AND id_supplier = '7' 05/09/2025 05:20:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5450' , '7' , '1' ) 05/09/2025 05:20:33 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 ( '98625' , '5451' , 'IO SONO CON VOI - GUIDA 2 - MAGNIFICAT' , '2' , '2' , '4' , '12.00' , '12' , '0' , '35+7' , '14.5080' ) 05/09/2025 05:20:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5451' AND id_supplier = '7' 05/09/2025 05:20:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5451' , '7' , '1' ) 05/09/2025 05:20: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 ( '98625' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35+7' , '7.2540' ) 05/09/2025 05:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11187' AND id_supplier = '7' 05/09/2025 05:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11187' , '7' , '1' ) 05/09/2025 05:20: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 ( '98625' , '11188' , 'VENITE CON ME - GUIDA 2 - MAGNIFICAT' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35+7' , '7.2540' ) 05/09/2025 05:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11188' AND id_supplier = '7' 05/09/2025 05:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11188' , '7' , '1' ) 05/09/2025 05:20: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 ( '98625' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '20' , '20' , '4' , '5.00' , '5' , '0' , '35+7' , '60.4500' ) 05/09/2025 05:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21436' AND id_supplier = '7' 05/09/2025 05:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21436' , '7' , '1' ) 05/09/2025 05:20: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 ( '98625' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '40' , '40' , '4' , '5.00' , '5' , '0' , '35+7' , '120.9000' ) 05/09/2025 05:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22804' AND id_supplier = '7' 05/09/2025 05:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22804' , '7' , '1' ) 05/09/2025 05:20: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 ( '98625' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '20' , '20' , '4' , '5.00' , '5' , '0' , '35+7' , '60.4500' ) 05/09/2025 05:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21437' AND id_supplier = '7' 05/09/2025 05:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21437' , '7' , '1' ) 05/09/2025 05:20: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 ( '98625' , '21484' , 'MIA IMPRONTA NELLA TUA - GUIDA 1 - N.E.' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35+7' , '9.0675' ) 05/09/2025 05:20:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21484' AND id_supplier = '7' 05/09/2025 05:20:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21484' , '7' , '1' ) 05/09/2025 05:22:10 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23981' 05/09/2025 05:22:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23982' , '1' , '' , 'nuovo-prodotto' ) 05/09/2025 05:22:10 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23982' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23981' 05/09/2025 05:22:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23982' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23981' 05/09/2025 05:24:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256450992' AND id_product != '23982' AND ean13 != '' 05/09/2025 05:24:25 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9791256450992', date_upd = NOW() WHERE id_product = '23982' 05/09/2025 05:24:25 pm >> UPDATE ps_product_lang SET name = 'CARLO ACUTIS. UN INFLUENCER IN PARADISO - W. CONQUER', description = '' WHERE id_product = '23982' 05/09/2025 05:24:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23982' 05/09/2025 05:24:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23982' 05/09/2025 05:24:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '23982' 05/09/2025 05:24:26 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23982' 05/09/2025 05:24:27 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23983' , '1' , '' , 'nuovo-prodotto' ) 05/09/2025 05:24:27 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23983' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23982' 05/09/2025 05:24:27 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23983' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23982' 05/09/2025 05:25:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256450985' AND id_product != '23983' AND ean13 != '' 05/09/2025 05:25:21 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9791256450985', date_upd = NOW() WHERE id_product = '23983' 05/09/2025 05:25:21 pm >> UPDATE ps_product_lang SET name = 'PIER GIORGIO FRASSATI. UN AVVENTURIERO IN PARADISO - CROUX/DE RUYVER', description = '' WHERE id_product = '23983' 05/09/2025 05:25:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23983' 05/09/2025 05:25:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23983' 05/09/2025 05:25:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '23983' 05/09/2025 05:26:03 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 ( '33' , '707277' , '2025-09-03' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0.72' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.92' , '25.92' , NOW() , NOW() ) 05/09/2025 05:26:03 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 = '98626' 05/09/2025 05:26:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '98626' 05/09/2025 05:26:03 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 ( '98626' , '23983' , 'PIER GIORGIO FRASSATI. UN AVVENTURIERO IN PARADISO - CROUX/DE RUYVER' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 05/09/2025 05:26:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23983' AND id_supplier = '7' 05/09/2025 05:26:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23983' , '7' , '1' ) 05/09/2025 05:26:03 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 ( '98626' , '23982' , 'CARLO ACUTIS. UN INFLUENCER IN PARADISO - W. CONQUER' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 05/09/2025 05:26:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23982' AND id_supplier = '7' 05/09/2025 05:26:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23982' , '7' , '1' ) 05/09/2025 05:32:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '111/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 05:32:52 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' , '111/A' , '2025-09-05' , 'A' , '188' , '0' , '4679387' , 'VIA ROMA 84121 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '280.00' , '229.51' , NOW() , NOW() ) 05/09/2025 05:32:52 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 = '98627' 05/09/2025 05:32:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '98627' 05/09/2025 05:32:52 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 ( '98627' , '1364' , 'BROCCA E PIATTINO - CM 23 PALLADIATI - 680' , '1' , '-1' , '1' , '210' , '172.13114754098' , '22' , '0' , '210.00' ) 05/09/2025 05:32:52 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 ( '98627' , '17988' , 'BACILE PALLADIO CM 24 - 688' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 05/09/2025 05:36:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2502' AND id_document != '98162' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-21') 05/09/2025 05:36:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2502', document_date = '2025-07-21', 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 = '65.00', price_tax_excluded = '53.28', date_upd = NOW() WHERE id_document = '98162' 05/09/2025 05:36:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98162' 05/09/2025 05:36:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '98162' 05/09/2025 05:36:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98162' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 05/09/2025 05:36:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98162' , '23907' , 'CROCIFISSO CON BASE - 519/NB' , '1' , '-1' , '1' , '8.6' , '7.0491803278689' , '22' , '0' , '8.60' ) 05/09/2025 05:59:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2882' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 05:59:23 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' , '2882' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 05/09/2025 05:59: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 = '98628' 05/09/2025 05:59:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '98628' 05/09/2025 05:59: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 ( '98628' , '14062' , 'STELLARIO PLEX CM 8' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 05/09/2025 06:00:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2883' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 06:00:04 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' , '2883' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 05/09/2025 06:00: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 = '98629' 05/09/2025 06:00:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '98629' 05/09/2025 06:00: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 ( '98629' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/09/2025 06:28:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2884' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 06:28:13 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' , '2884' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 05/09/2025 06:28:13 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 = '98630' 05/09/2025 06:28:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '98630' 05/09/2025 06:28:13 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 ( '98630' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 05/09/2025 06:32:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '2885' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 06:32:07 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' , '2885' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '649.00' , '531.97' , NOW() , NOW() ) 05/09/2025 06:32:07 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 = '98631' 05/09/2025 06:32:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '98631' 05/09/2025 06:32:07 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 ( '98631' , '19346' , 'CASULA MARIANA LANA LUREX - 65/002005- 348' , '1' , '-1' , '1' , '649.00' , '531.96721311475' , '22' , '0' , '649.00' ) 05/09/2025 06:40:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2886' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 06:40:11 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' , '2886' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '175.00' , '143.44' , NOW() , NOW() ) 05/09/2025 06:40:11 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 = '98632' 05/09/2025 06:40:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '98632' 05/09/2025 06:40:11 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 ( '98632' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '175.00' , '143.44262295082' , '22' , '0' , '175.00' ) 05/09/2025 06:43:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2887' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 06:43: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' , '2887' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 05/09/2025 06:43: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 = '98633' 05/09/2025 06:43:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '98633' 05/09/2025 06:43: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 ( '98633' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 05/09/2025 06:49:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2888' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 06:49:15 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' , '2888' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '590.00' , '483.61' , NOW() , NOW() ) 05/09/2025 06:49:15 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 = '98634' 05/09/2025 06:49:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '98634' 05/09/2025 06:49:15 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 ( '98634' , '23857' , 'CASULA SFUMATA - 65002007' , '1' , '-1' , '1' , '590.00' , '483.60655737705' , '22' , '0' , '590.00' ) 05/09/2025 07:22:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002393' AND id_product != '23857' AND ean13 != '' 05/09/2025 07:22:43 pm >> UPDATE ps_product SET id_supplier = '143', reference = '', ean13 = '002393', date_upd = NOW() WHERE id_product = '23857' 05/09/2025 07:22:43 pm >> UPDATE ps_product_lang SET name = 'CASULA SFUMATA - 65/002007', description = '' WHERE id_product = '23857' 05/09/2025 07:22:43 pm >> UPDATE ps_product SET wholesale_price = '234.74', on_sale = '0', price = '483.6066' WHERE id_product = '23857' 05/09/2025 07:22:43 pm >> UPDATE ps_product_shop SET wholesale_price = '234.74', price = '483.6066', id_tax_rules_group = '1', id_category_default = '468', 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 = '23857' 05/09/2025 07:22:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '23857' 05/09/2025 07:52:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2889' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 07:52:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2889' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1550.00' , '1270.49' , NOW() , NOW() ) 05/09/2025 07:52:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98635' 05/09/2025 07:52:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '98635' 05/09/2025 07:52:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98635' , '21988' , 'CASULA MARIANA - 65/026129' , '1' , '-1' , '1' , '1550' , '1270.4918032787' , '22' , '0' , '1550.00' ) 05/09/2025 07:57:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2850' AND id_document != '98586' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-03') 05/09/2025 07:57:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2850', document_date = '2025-09-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '254.50', price_tax_excluded = '213.79', date_upd = NOW() WHERE id_document = '98586' 05/09/2025 07:57:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98586' 05/09/2025 07:57:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '98586' 05/09/2025 07:57:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98586' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 05/09/2025 07:57:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98586' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 05/09/2025 07:57:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98586' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 05/09/2025 07:57:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98586' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 05/09/2025 07:57:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98586' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 05/09/2025 07:57:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98586' , '23752' , 'TUTTA LA MESSA MINUTO PER MINUTO - V. ANGELUCCI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 05/09/2025 07:57:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98586' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '10' , '-10' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '18.00' ) 05/09/2025 07:58:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2863' AND id_document != '98601' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-04') 05/09/2025 07:58:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2863', document_date = '2025-09-04', 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 = '78.90', price_tax_excluded = '69.34', date_upd = NOW() WHERE id_document = '98601' 05/09/2025 07:58:13 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 = '98601' 05/09/2025 07:58:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '98601' 05/09/2025 07:58:13 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 ( '98601' , '22508' , 'POLO PIQUET - M06' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 05/09/2025 07:58:13 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 ( '98601' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '16.4' , '16.4' , '0' , '0' , '16.40' ) 05/09/2025 07:58:13 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 ( '98601' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 05/09/2025 07:58:13 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 ( '98601' , '23443' , 'MA COME SI FA?' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 05/09/2025 08:04:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2890' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-05') 05/09/2025 08:04:19 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' , '2890' , '2025-09-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.40' , '36.39' , NOW() , NOW() ) 05/09/2025 08:04:19 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 = '98636' 05/09/2025 08:04:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '98636' 05/09/2025 08:04:19 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 ( '98636' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '1' , '-1' , '1' , '41.90' , '34.344262295082' , '22' , '0' , '41.90' ) 05/09/2025 08:04:19 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 ( '98636' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 05/09/2025 08:04:19 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 ( '98636' , '22549' , 'ROSARIO LEGNO MM8 - R282' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' )