02/10/2025 09:50:27 am >> SELECT document_num FROM ps_document WHERE document_num = '3188' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 09:50:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3188' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 02/10/2025 09:50:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99007' 02/10/2025 09:50:27 am >> DELETE FROM ps_document_detail WHERE id_document = '99007' 02/10/2025 09:50:27 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 ( '99007' , '23975' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 26' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 02/10/2025 09:59:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , 'A3792' , '2025-09-30' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '13' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '230.76' , '189.15' , NOW() , NOW() ) 02/10/2025 09:59:21 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 = '99008' 02/10/2025 09:59:21 am >> DELETE FROM ps_document_detail WHERE id_document = '99008' 02/10/2025 09:59:21 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 ( '99008' , '16447' , 'TELA 30X40 - 2964' , '2' , '2' , '1' , '5.81' , '4.7622950819672' , '22' , '0' , '14.1764' ) 02/10/2025 09:59:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '16447' AND id_supplier = '28' 02/10/2025 09:59:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16447' , '28' , '1' ) 02/10/2025 09:59:22 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 ( '99008' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '7' , '7' , '1' , '9.06' , '7.4262295081967' , '22' , '0' , '77.3724' ) 02/10/2025 09:59:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21561' AND id_supplier = '28' 02/10/2025 09:59:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21561' , '28' , '1' ) 02/10/2025 09:59:22 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 ( '99008' , '21560' , 'ROSARIO LEGNO CORDA CON G. - 3539' , '12' , '12' , '1' , '1.94' , '1.5901639344262' , '22' , '0' , '28.4016' ) 02/10/2025 09:59:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21560' AND id_supplier = '28' 02/10/2025 09:59:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21560' , '28' , '1' ) 02/10/2025 09:59:22 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 ( '99008' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '5' , '5' , '1' , '5.71' , '4.6803278688525' , '22' , '0' , '34.8310' ) 02/10/2025 09:59:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '12040' AND id_supplier = '28' 02/10/2025 09:59:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12040' , '28' , '1' ) 02/10/2025 09:59:22 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 ( '99008' , '14687' , 'CROCE DELL\'AMICIZIA IN ULIVO CM 18 - 2842' , '1' , '1' , '1' , '8.35' , '6.844262295082' , '22' , '0' , '10.1870' ) 02/10/2025 09:59:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '14687' AND id_supplier = '28' 02/10/2025 09:59:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14687' , '28' , '1' ) 02/10/2025 09:59:22 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 ( '99008' , '23099' , 'TELA 18X25 ACUTIS - 2963/S0342NC' , '3' , '3' , '1' , '3.75' , '3.0737704918033' , '22' , '0' , '13.7250' ) 02/10/2025 09:59:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '23099' AND id_supplier = '28' 02/10/2025 09:59:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23099' , '28' , '1' ) 02/10/2025 09:59:22 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 ( '99008' , '21841' , 'QUADRETTO SMUSSATO - 1269' , '25' , '25' , '1' , '1' , '0.81967213114754' , '22' , '0' , '30.5000' ) 02/10/2025 09:59:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21841' AND id_supplier = '28' 02/10/2025 09:59:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21841' , '28' , '1' ) 02/10/2025 09:59:22 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 ( '99008' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '1' , '1' , '4.68' , '3.8360655737705' , '22' , '0' , '5.7096' ) 02/10/2025 09:59:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '21559' AND id_supplier = '28' 02/10/2025 09:59:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21559' , '28' , '1' ) 02/10/2025 10:30:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3189' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 10:30:15 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' , '3189' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '117.40' , '96.23' , NOW() , NOW() ) 02/10/2025 10:30:15 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 = '99009' 02/10/2025 10:30:15 am >> DELETE FROM ps_document_detail WHERE id_document = '99009' 02/10/2025 10:30:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99009' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 02/10/2025 10:30:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99009' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 02/10/2025 10:30: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 ( '99009' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 02/10/2025 10:34:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2607' AND id_document != '98287' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-30') 02/10/2025 10:34:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2607', document_date = '2025-07-30', 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 = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '98287' 02/10/2025 10:34: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 = '98287' 02/10/2025 10:34:54 am >> DELETE FROM ps_document_detail WHERE id_document = '98287' 02/10/2025 10:34: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 ( '98287' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 02/10/2025 10:34: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 ( '98287' , '11624' , 'PALLA 16X16 - SERV 3 ' , '3' , '-3' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '15.00' ) 02/10/2025 10:34: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 ( '98287' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '3' , '-3' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '18.00' ) 02/10/2025 10:34: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 ( '98287' , '6403' , 'MENSA BIANCA 80X150 ' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 02/10/2025 10:34: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 ( '98287' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 02/10/2025 10:34: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 ( '98287' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 02/10/2025 10:41:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3190' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 10:41:15 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' , '3190' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '16.83' , NOW() , NOW() ) 02/10/2025 10:41:15 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 = '99010' 02/10/2025 10:41:15 am >> DELETE FROM ps_document_detail WHERE id_document = '99010' 02/10/2025 10:41:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99010' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 02/10/2025 10:51:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3191' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 10:51:46 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' , '3191' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.26' , '22.26' , NOW() , NOW() ) 02/10/2025 10:51:46 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 = '99011' 02/10/2025 10:51:46 am >> DELETE FROM ps_document_detail WHERE id_document = '99011' 02/10/2025 10:51:46 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 ( '99011' , '23822' , 'AMEN - OTT 25' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 02/10/2025 10:51:46 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 ( '99011' , '23989' , 'AMEN - NOV 25' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 02/10/2025 10:51:46 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 ( '99011' , '23988' , 'AMEN - DIC 25' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 02/10/2025 10:54:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400011333' AND id_product != '16987' AND ean13 != '' 02/10/2025 10:54:20 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400011333', date_upd = NOW() WHERE id_product = '16987' 02/10/2025 10:54:20 am >> UPDATE ps_product_lang SET name = 'QUADRETTO SMUSSATO 7X10 MADONNA DEL CARMINE - 1269/M250', description = '' WHERE id_product = '16987' 02/10/2025 10:54:20 am >> UPDATE ps_product SET wholesale_price = '0.78', on_sale = '0', price = '2.2131147540983607' WHERE id_product = '16987' 02/10/2025 10:54:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.78', price = '2.2131147540983607', id_tax_rules_group = '1', id_category_default = '95', 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 = '16987' 02/10/2025 10:54:20 am >> DELETE FROM ps_specific_price WHERE id_product = '16987' 02/10/2025 10:54:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400012941' AND id_product != '8645' AND ean13 != '' 02/10/2025 10:54:36 am >> UPDATE ps_product SET id_supplier = '28', reference = '2016', ean13 = '8058400012941', date_upd = NOW() WHERE id_product = '8645' 02/10/2025 10:54:36 am >> UPDATE ps_product_lang SET name = 'QUADRETTO SANTA RITA - 1269/S59', description = '' WHERE id_product = '8645' 02/10/2025 10:54:37 am >> UPDATE ps_product SET wholesale_price = '0.78', on_sale = '0', price = '2.2131147540983607' WHERE id_product = '8645' 02/10/2025 10:54:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.78', price = '2.2131147540983607', id_tax_rules_group = '1', id_category_default = '95', 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 = '8645' 02/10/2025 10:54:37 am >> DELETE FROM ps_specific_price WHERE id_product = '8645' 02/10/2025 10:54:38 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 = '8645' 02/10/2025 10:54:38 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24110' , '1' , '' , 'nuovo-prodotto' ) 02/10/2025 10:54:38 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 '24110' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '8645' 02/10/2025 10:54:38 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24110' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '8645' 02/10/2025 10:55:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002207' AND id_product != '21841' AND ean13 != '' 02/10/2025 10:55:23 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '002207', date_upd = NOW() WHERE id_product = '21841' 02/10/2025 10:55:23 am >> UPDATE ps_product_lang SET name = 'QUADRETTO SMUSSATO - 1269', description = '' WHERE id_product = '21841' 02/10/2025 10:55:23 am >> UPDATE ps_product SET wholesale_price = '1.00', on_sale = '0', price = '2.2131147540983607' WHERE id_product = '21841' 02/10/2025 10:55:23 am >> UPDATE ps_product_shop SET wholesale_price = '1.00', price = '2.2131147540983607', id_tax_rules_group = '1', id_category_default = '95', 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 = '21841' 02/10/2025 10:55:23 am >> DELETE FROM ps_specific_price WHERE id_product = '21841' 02/10/2025 10:55:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400012934' AND id_product != '17777' AND ean13 != '' 02/10/2025 10:55:45 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400012934', date_upd = NOW() WHERE id_product = '17777' 02/10/2025 10:55:45 am >> UPDATE ps_product_lang SET name = 'QUADRETTO SMUSSATO 7X10 S. GIUSEPPE - 1269/S40', description = '' WHERE id_product = '17777' 02/10/2025 10:55:45 am >> UPDATE ps_product SET wholesale_price = '0.78', on_sale = '0', price = '2.2131147540983607' WHERE id_product = '17777' 02/10/2025 10:55:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.78', price = '2.2131147540983607', id_tax_rules_group = '1', id_category_default = '95', 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 = '17777' 02/10/2025 10:55:45 am >> DELETE FROM ps_specific_price WHERE id_product = '17777' 02/10/2025 11:15:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846207723' AND id_product != '19720' AND ean13 != '' 02/10/2025 11:15:04 am >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = '8027846207723', date_upd = NOW() WHERE id_product = '19720' 02/10/2025 11:15:04 am >> UPDATE ps_product_lang SET name = 'CROCE LEGNO MET. - CL247', description = '' WHERE id_product = '19720' 02/10/2025 11:15:04 am >> UPDATE ps_product SET wholesale_price = '9.01', on_sale = '0', price = '20.081967213114755' WHERE id_product = '19720' 02/10/2025 11:15:04 am >> UPDATE ps_product_shop SET wholesale_price = '9.01', price = '20.081967213114755', id_tax_rules_group = '1', id_category_default = '151', 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 = '19720' 02/10/2025 11:15:04 am >> DELETE FROM ps_specific_price WHERE id_product = '19720' 02/10/2025 11:24:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846352980' AND id_product != '24110' AND ean13 != '' 02/10/2025 11:24:23 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846352980', date_upd = NOW() WHERE id_product = '24110' 02/10/2025 11:24:24 am >> UPDATE ps_product_lang SET name = 'NATIVITA\' CM 8 - ST292-NTD', description = '' WHERE id_product = '24110' 02/10/2025 11:24:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.704918032786885' WHERE id_product = '24110' 02/10/2025 11:24:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.704918032786885', id_tax_rules_group = '1', id_category_default = '151', 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 = '24110' 02/10/2025 11:24:24 am >> DELETE FROM ps_specific_price WHERE id_product = '24110' 02/10/2025 11:26:00 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 = '24110' 02/10/2025 11:26:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24111' , '1' , '' , 'nuovo-prodotto' ) 02/10/2025 11:26:00 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 '24111' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24110' 02/10/2025 11:26:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24111' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24110' 02/10/2025 11:26:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846352836' AND id_product != '24111' AND ean13 != '' 02/10/2025 11:26:40 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846352836', date_upd = NOW() WHERE id_product = '24111' 02/10/2025 11:26:40 am >> UPDATE ps_product_lang SET name = 'NATIVITA\' CM 13 - ST292-NTI', description = '' WHERE id_product = '24111' 02/10/2025 11:26:40 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.295081967213115' WHERE id_product = '24111' 02/10/2025 11:26:40 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.295081967213115', id_tax_rules_group = '1', id_category_default = '151', 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 = '24111' 02/10/2025 11:26:40 am >> DELETE FROM ps_specific_price WHERE id_product = '24111' 02/10/2025 11:27:00 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 = '24111' 02/10/2025 11:27:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24112' , '1' , '' , 'nuovo-prodotto' ) 02/10/2025 11:27:00 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 '24112' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24111' 02/10/2025 11:27:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24112' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24111' 02/10/2025 11:27:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846352805' AND id_product != '24112' AND ean13 != '' 02/10/2025 11:27:23 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846352805', date_upd = NOW() WHERE id_product = '24112' 02/10/2025 11:27:23 am >> UPDATE ps_product_lang SET name = 'NATIVITA\' CM 13 - ST292-NTS', description = '' WHERE id_product = '24112' 02/10/2025 11:27:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.295081967213115' WHERE id_product = '24112' 02/10/2025 11:27:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.295081967213115', id_tax_rules_group = '1', id_category_default = '151', 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 = '24112' 02/10/2025 11:27:23 am >> DELETE FROM ps_specific_price WHERE id_product = '24112' 02/10/2025 11:27:50 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 = '24112' 02/10/2025 11:27:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24113' , '1' , '' , 'nuovo-prodotto' ) 02/10/2025 11:27:50 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 '24113' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24112' 02/10/2025 11:27:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24113' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24112' 02/10/2025 11:28:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846352973' AND id_product != '24113' AND ean13 != '' 02/10/2025 11:28:30 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846352973', date_upd = NOW() WHERE id_product = '24113' 02/10/2025 11:28:30 am >> UPDATE ps_product_lang SET name = 'NATIVITA\' CM 6 - ST291-NTD', description = '' WHERE id_product = '24113' 02/10/2025 11:28:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.114754098360656' WHERE id_product = '24113' 02/10/2025 11:28:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.114754098360656', id_tax_rules_group = '1', id_category_default = '151', 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 = '24113' 02/10/2025 11:28:30 am >> DELETE FROM ps_specific_price WHERE id_product = '24113' 02/10/2025 11:28:31 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 = '24113' 02/10/2025 11:28:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24114' , '1' , '' , 'nuovo-prodotto' ) 02/10/2025 11:28:31 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 '24114' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24113' 02/10/2025 11:28:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24114' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24113' 02/10/2025 11:29:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846352843' AND id_product != '24114' AND ean13 != '' 02/10/2025 11:29:38 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846352843', date_upd = NOW() WHERE id_product = '24114' 02/10/2025 11:29:38 am >> UPDATE ps_product_lang SET name = 'NATIVITA\' CM 10 - ST291-NTI', description = '' WHERE id_product = '24114' 02/10/2025 11:29:38 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.377049180327869' WHERE id_product = '24114' 02/10/2025 11:29:38 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.377049180327869', id_tax_rules_group = '1', id_category_default = '151', 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 = '24114' 02/10/2025 11:29:38 am >> DELETE FROM ps_specific_price WHERE id_product = '24114' 02/10/2025 11:29:51 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 = '24114' 02/10/2025 11:29:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24115' , '1' , '' , 'nuovo-prodotto' ) 02/10/2025 11:29:51 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 '24115' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24114' 02/10/2025 11:29:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24115' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24114' 02/10/2025 11:30:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846352799' AND id_product != '24115' AND ean13 != '' 02/10/2025 11:30:16 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846352799', date_upd = NOW() WHERE id_product = '24115' 02/10/2025 11:30:16 am >> UPDATE ps_product_lang SET name = 'NATIVITA\' CM 10 - ST291-NTS', description = '' WHERE id_product = '24115' 02/10/2025 11:30:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.377049180327869' WHERE id_product = '24115' 02/10/2025 11:30:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.377049180327869', id_tax_rules_group = '1', id_category_default = '151', 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 = '24115' 02/10/2025 11:30:16 am >> DELETE FROM ps_specific_price WHERE id_product = '24115' 02/10/2025 11:30:46 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 = '24115' 02/10/2025 11:30:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24116' , '1' , '' , 'nuovo-prodotto' ) 02/10/2025 11:30:46 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 '24116' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24115' 02/10/2025 11:30:46 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24116' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24115' 02/10/2025 11:31:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000119' AND id_product != '24116' AND ean13 != '' 02/10/2025 11:31:49 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000119', date_upd = NOW() WHERE id_product = '24116' 02/10/2025 11:31:49 am >> UPDATE ps_product_lang SET name = 'CROCE ASTILE - CL285-D-AST', description = '' WHERE id_product = '24116' 02/10/2025 11:31:49 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '721.3114754098361' WHERE id_product = '24116' 02/10/2025 11:31:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '721.3114754098361', id_tax_rules_group = '1', id_category_default = '151', 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 = '24116' 02/10/2025 11:31:49 am >> DELETE FROM ps_specific_price WHERE id_product = '24116' 02/10/2025 11:33:19 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' , '2447' , '2025-09-30' , '' , '0' , '43' , '2638' , 'VIA COSTABIANCA, 43 60025 LORETO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '501.58' , '411.13' , NOW() , NOW() ) 02/10/2025 11:33:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99012' 02/10/2025 11:33:19 am >> DELETE FROM ps_document_detail WHERE id_document = '99012' 02/10/2025 11:33:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99012' , '6337' , 'MEDAGLIA OVALE DECORATA - SACRO CUORE - G291-D' , '100' , '100' , '1' , '0.37' , '0.30327868852459' , '22' , '10' , '40.6260' ) 02/10/2025 11:33:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '6337' AND id_supplier = '43' 02/10/2025 11:33:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6337' , '43' , '1' ) 02/10/2025 11:33:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99012' , '19716' , 'MEDAGLIA SAN BENEDETTO - Q1001-OX' , '100' , '100' , '1' , '0.12' , '0.098360655737705' , '22' , '10' , '13.1760' ) 02/10/2025 11:33:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '19716' AND id_supplier = '43' 02/10/2025 11:33:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19716' , '43' , '1' ) 02/10/2025 11:33:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99012' , '19720' , 'CROCE LEGNO MET. - CL247' , '1' , '1' , '1' , '10.01' , '8.2049180327869' , '22' , '10' , '10.9910' ) 02/10/2025 11:33:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '19720' AND id_supplier = '43' 02/10/2025 11:33:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19720' , '43' , '1' ) 02/10/2025 11:33:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99012' , '20965' , 'STATUA SAN MICHELE - ST332-SM' , '1' , '1' , '1' , '7.88' , '6.4590163934426' , '22' , '10' , '8.6522' ) 02/10/2025 11:33:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '20965' AND id_supplier = '43' 02/10/2025 11:33:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20965' , '43' , '1' ) 02/10/2025 11:33:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99012' , '24110' , 'NATIVITA CM 8 - ST292-NTD' , '1' , '1' , '1' , '6.36' , '5.2131147540984' , '22' , '10' , '6.9833' ) 02/10/2025 11:33:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '24110' AND id_supplier = '43' 02/10/2025 11:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24110' , '43' , '1' ) 02/10/2025 11:33:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99012' , '24111' , 'NATIVITA CM 13 - ST292-NTI' , '1' , '1' , '1' , '6.20' , '5.0819672131148' , '22' , '10' , '6.8076' ) 02/10/2025 11:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '24111' AND id_supplier = '43' 02/10/2025 11:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24111' , '43' , '1' ) 02/10/2025 11:33:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99012' , '24112' , 'NATIVITA CM 13 - ST292-NTS' , '1' , '1' , '1' , '6.2' , '5.0819672131148' , '22' , '10' , '6.8076' ) 02/10/2025 11:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '24112' AND id_supplier = '43' 02/10/2025 11:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24112' , '43' , '1' ) 02/10/2025 11:33:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99012' , '24113' , 'NATIVITA CM 6 - ST291-NTD' , '1' , '1' , '1' , '3.96' , '3.2459016393443' , '22' , '10' , '4.3481' ) 02/10/2025 11:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '24113' AND id_supplier = '43' 02/10/2025 11:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24113' , '43' , '1' ) 02/10/2025 11:33:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99012' , '24114' , 'NATIVITA CM 10 - ST291-NTI' , '1' , '1' , '1' , '3.6' , '2.9508196721311' , '22' , '10' , '3.9528' ) 02/10/2025 11:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '24114' AND id_supplier = '43' 02/10/2025 11:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24114' , '43' , '1' ) 02/10/2025 11:33:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99012' , '24115' , 'NATIVITA CM 10 - ST291-NTS' , '1' , '1' , '1' , '3.6' , '2.9508196721311' , '22' , '10' , '3.9528' ) 02/10/2025 11:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '24115' AND id_supplier = '43' 02/10/2025 11:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24115' , '43' , '1' ) 02/10/2025 11:33:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99012' , '24116' , 'CROCE ASTILE - CL285-D-AST' , '1' , '1' , '1' , '360' , '295.08196721311' , '22' , '10' , '395.2800' ) 02/10/2025 11:33:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '24116' AND id_supplier = '43' 02/10/2025 11:33:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24116' , '43' , '1' ) 02/10/2025 11:39:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000455' AND id_product != '24095' AND ean13 != '' 02/10/2025 11:39:11 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000455', date_upd = NOW() WHERE id_product = '24095' 02/10/2025 11:39:12 am >> UPDATE ps_product_lang SET name = 'MEDAGLIA ACUTIS DORATA - G474-D.254', description = '' WHERE id_product = '24095' 02/10/2025 11:39:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.6557' WHERE id_product = '24095' 02/10/2025 11:39:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.6557', id_tax_rules_group = '1', id_category_default = '151', 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 = '24095' 02/10/2025 11:39:12 am >> DELETE FROM ps_specific_price WHERE id_product = '24095' 02/10/2025 11:39:33 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 ( '32' , '2032/2025' , '2025-09-30' , '2025' , '0' , '43' , '2638' , 'VIA COSTABIANCA, 43 60025 LORETO' , '' , '' , '30' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '970.14' , '795.20' , NOW() , NOW() ) 02/10/2025 11:39:33 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 = '99013' 02/10/2025 11:39:33 am >> DELETE FROM ps_document_detail WHERE id_document = '99013' 02/10/2025 11:39:33 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 ( '99013' , '24090' , 'PORTAOSTIE - SC 291-CAL' , '6' , '0' , '1' , '5.6000' , '4.5902' , '22' , '10' , '36.89' ) 02/10/2025 11:39:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '24090' AND id_supplier = '43' 02/10/2025 11:39:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24090' , '43' , '1' ) 02/10/2025 11:39:33 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 ( '99013' , '24091' , 'PORTAOSTIE - SC 291-COM1' , '6' , '0' , '1' , '5.6000' , '4.5902' , '22' , '10' , '36.89' ) 02/10/2025 11:39:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '24091' AND id_supplier = '43' 02/10/2025 11:39:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24091' , '43' , '1' ) 02/10/2025 11:39:33 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 ( '99013' , '24092' , 'PORTAOSTIE - SC 291-COM' , '6' , '0' , '1' , '5.6000' , '4.5902' , '22' , '10' , '36.89' ) 02/10/2025 11:39:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '24092' AND id_supplier = '43' 02/10/2025 11:39:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24092' , '43' , '1' ) 02/10/2025 11:39:33 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 ( '99013' , '24093' , 'ROSARIO ACUTIS - RE 1959-254' , '12' , '0' , '1' , '2.3000' , '1.8852' , '22' , '10' , '30.30' ) 02/10/2025 11:39:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '24093' AND id_supplier = '43' 02/10/2025 11:39:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24093' , '43' , '1' ) 02/10/2025 11:39:33 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 ( '99013' , '22012' , 'CROCE SAN DAMIANO MOGANO 26X19 - PG092' , '2' , '0' , '1' , '11.5800' , '9.4918' , '22' , '10' , '25.43' ) 02/10/2025 11:39:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '22012' AND id_supplier = '43' 02/10/2025 11:39:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22012' , '43' , '1' ) 02/10/2025 11:39: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 ( '99013' , '22734' , 'CROCE SAN BENEDETTO - PG680BR' , '2' , '0' , '1' , '6.9000' , '5.6557' , '22' , '10' , '15.15' ) 02/10/2025 11:39:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '22734' AND id_supplier = '43' 02/10/2025 11:39:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22734' , '43' , '1' ) 02/10/2025 11:39: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 ( '99013' , '20970' , 'CROCE LEGNO S. BENEDETTO - PG681' , '2' , '0' , '1' , '13.5000' , '11.0656' , '22' , '10' , '29.65' ) 02/10/2025 11:39:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20970' AND id_supplier = '43' 02/10/2025 11:39:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20970' , '43' , '1' ) 02/10/2025 11:39: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 ( '99013' , '19596' , 'MEDAGLIA SAN BENEDETTO ARG. RA810' , '1' , '0' , '1' , '5.9000' , '4.8361' , '22' , '10' , '6.48' ) 02/10/2025 11:39:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19596' AND id_supplier = '43' 02/10/2025 11:39:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19596' , '43' , '1' ) 02/10/2025 11:39: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 ( '99013' , '24094' , 'BRACCIALE SAN BENEDETTO - CC 111-SB' , '24' , '0' , '1' , '1.8500' , '1.5164' , '22' , '10' , '48.75' ) 02/10/2025 11:39:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '24094' AND id_supplier = '43' 02/10/2025 11:39:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24094' , '43' , '1' ) 02/10/2025 11:39: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 ( '99013' , '23557' , 'STATUA S. MICHELE BIANCA - ST203-BSM' , '1' , '0' , '1' , '14.0000' , '11.4754' , '22' , '10' , '15.37' ) 02/10/2025 11:39:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '23557' AND id_supplier = '43' 02/10/2025 11:39:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23557' , '43' , '1' ) 02/10/2025 11:39: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 ( '99013' , '23601' , 'STATUA SAN CARLO ACUTIS - ST213AC' , '1' , '0' , '1' , '13.1300' , '10.7623' , '22' , '10' , '14.42' ) 02/10/2025 11:39:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '23601' AND id_supplier = '43' 02/10/2025 11:39:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23601' , '43' , '1' ) 02/10/2025 11:39: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 ( '99013' , '6332' , 'MEDAGLIA OVALE DECORATA - MISERICORDIOSO - G291-D' , '100' , '0' , '1' , '0.37' , '0.30327868852459' , '22' , '10' , '40.6260' ) 02/10/2025 11:39:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '6332' AND id_supplier = '43' 02/10/2025 11:39:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6332' , '43' , '1' ) 02/10/2025 11:39: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 ( '99013' , '24087' , 'ICONA GRECA SERIGRAFATA 23X18 - K096.A' , '1' , '0' , '1' , '20.7000' , '16.9672' , '22' , '10' , '22.73' ) 02/10/2025 11:39:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '24087' AND id_supplier = '43' 02/10/2025 11:39:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24087' , '43' , '1' ) 02/10/2025 11:39: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 ( '99013' , '24089' , 'ICONA GRECA SERIGRAFATA 14X11 - K094.A' , '1' , '0' , '1' , '9.9000' , '8.1148' , '22' , '10' , '10.87' ) 02/10/2025 11:39:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '24089' AND id_supplier = '43' 02/10/2025 11:39:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24089' , '43' , '1' ) 02/10/2025 11:39: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 ( '99013' , '24088' , 'ICONA GRECA SERIGRAFATA 18X14 - K095.A' , '1' , '0' , '1' , '15.3000' , '12.541' , '22' , '10' , '16.80' ) 02/10/2025 11:39:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '24088' AND id_supplier = '43' 02/10/2025 11:39:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24088' , '43' , '1' ) 02/10/2025 11:39: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 ( '99013' , '6337' , 'MEDAGLIA OVALE DECORATA - SACRO CUORE - G291-D' , '100' , '0' , '1' , '0.3700' , '0.3033' , '22' , '10' , '40.63' ) 02/10/2025 11:39:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '6337' AND id_supplier = '43' 02/10/2025 11:39:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6337' , '43' , '1' ) 02/10/2025 11:39: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 ( '99013' , '19716' , 'MEDAGLIA SAN BENEDETTO - Q1001-OX' , '100' , '0' , '1' , '0.1273' , '0.10434426229508' , '22' , '10' , '13.9775' ) 02/10/2025 11:39:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19716' AND id_supplier = '43' 02/10/2025 11:39:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19716' , '43' , '1' ) 02/10/2025 11:39:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99013' , '19720' , 'CROCE LEGNO MET. - CL247' , '1' , '0' , '1' , '10.0100' , '8.2049' , '22' , '10' , '10.99' ) 02/10/2025 11:39:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19720' AND id_supplier = '43' 02/10/2025 11:39:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19720' , '43' , '1' ) 02/10/2025 11:39:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99013' , '20965' , 'STATUA SAN MICHELE - ST332-SM' , '1' , '0' , '1' , '7.8800' , '6.459' , '22' , '10' , '8.65' ) 02/10/2025 11:39:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '20965' AND id_supplier = '43' 02/10/2025 11:39:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20965' , '43' , '1' ) 02/10/2025 11:39:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99013' , '24110' , 'NATIVITA CM 8 - ST292-NTD' , '1' , '0' , '1' , '6.3600' , '5.2131' , '22' , '10' , '6.98' ) 02/10/2025 11:39:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '24110' AND id_supplier = '43' 02/10/2025 11:39:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24110' , '43' , '1' ) 02/10/2025 11:39:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99013' , '24111' , 'NATIVITA CM 13 - ST292-NTI' , '1' , '0' , '1' , '6.2000' , '5.082' , '22' , '10' , '6.81' ) 02/10/2025 11:39:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '24111' AND id_supplier = '43' 02/10/2025 11:39:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24111' , '43' , '1' ) 02/10/2025 11:39:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99013' , '24112' , 'NATIVITA CM 13 - ST292-NTS' , '1' , '0' , '1' , '6.2000' , '5.082' , '22' , '10' , '6.81' ) 02/10/2025 11:39:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '24112' AND id_supplier = '43' 02/10/2025 11:39:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24112' , '43' , '1' ) 02/10/2025 11:39:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99013' , '24113' , 'NATIVITA CM 6 - ST291-NTD' , '1' , '0' , '1' , '3.9600' , '3.2459' , '22' , '10' , '4.35' ) 02/10/2025 11:39:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '24113' AND id_supplier = '43' 02/10/2025 11:39:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24113' , '43' , '1' ) 02/10/2025 11:39:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99013' , '24114' , 'NATIVITA CM 10 - ST291-NTI' , '1' , '0' , '1' , '3.6000' , '2.9508' , '22' , '10' , '3.95' ) 02/10/2025 11:39:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '24114' AND id_supplier = '43' 02/10/2025 11:39:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24114' , '43' , '1' ) 02/10/2025 11:39:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99013' , '24115' , 'NATIVITA CM 10 - ST291-NTS' , '1' , '0' , '1' , '3.6000' , '2.9508' , '22' , '10' , '3.95' ) 02/10/2025 11:39:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '24115' AND id_supplier = '43' 02/10/2025 11:39:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24115' , '43' , '1' ) 02/10/2025 11:39:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99013' , '24116' , 'CROCE ASTILE - CL285-D-AST' , '1' , '0' , '1' , '360.0000' , '295.082' , '22' , '10' , '395.28' ) 02/10/2025 11:39:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '24116' AND id_supplier = '43' 02/10/2025 11:39:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24116' , '43' , '1' ) 02/10/2025 11:39:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99013' , '24095' , 'MEDAGLIA ACUTIS DORATA - G474-D.254' , '100' , '0' , '1' , '0.4' , '0.32786885245902' , '22' , '10' , '43.9200' ) 02/10/2025 11:39:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '24095' AND id_supplier = '43' 02/10/2025 11:39:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24095' , '43' , '1' ) 02/10/2025 11:55:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3192' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 11:55:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3192' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '439.90' , '380.33' , NOW() , NOW() ) 02/10/2025 11:55:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99014' 02/10/2025 11:55:01 am >> DELETE FROM ps_document_detail WHERE id_document = '99014' 02/10/2025 11:55:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99014' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '120' , '-120' , '4' , '0.70' , '0.7' , '0' , '0' , '84.00' ) 02/10/2025 11:55:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99014' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 02/10/2025 11:55:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99014' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '24.50' ) 02/10/2025 11:55:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99014' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 02/10/2025 11:55:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99014' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 02/10/2025 11:55:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99014' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 02/10/2025 11:55:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99014' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3' , '2.4590163934426' , '22' , '0' , '180.00' ) 02/10/2025 11:55:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99014' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/10/2025 11:55:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3193' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 11:55:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3193' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.80' , NOW() , NOW() ) 02/10/2025 11:55:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99015' 02/10/2025 11:55:57 am >> DELETE FROM ps_document_detail WHERE id_document = '99015' 02/10/2025 11:55: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 ( '99015' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '4' , '-4' , '4' , '0.70' , '0.7' , '0' , '0' , '2.80' ) 02/10/2025 12:05:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3194' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 12:05:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3194' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.30' , '11.50' , NOW() , NOW() ) 02/10/2025 12:05:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99016' 02/10/2025 12:05:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '99016' 02/10/2025 12:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99016' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/10/2025 12:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99016' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '' , '2.50' ) 02/10/2025 12:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99016' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 02/10/2025 12:20:05 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'uRwczs0Pk8ttpREp' , NOW() , NOW() ) 02/10/2025 12:20:05 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4244' , '1' ) 02/10/2025 12:20:05 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4244' , '2' ) 02/10/2025 12:20:05 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4244' , '3' ) 02/10/2025 12:21:34 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4244' 02/10/2025 12:21:35 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4244' , '10' , '210' , 'PARROCCHIA S. ANDREA E LORENZO' , 'SAVINO' , 'DON LUIGI' , 'VIA SAN LORENZO' , '' , '84084' , 'VILLA DI FISCIANO' , '' , '' , '' , '' , '' , NOW() , NOW() ) 02/10/2025 12:21:35 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4244' 02/10/2025 12:28:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3195' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 12:28: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 ( '11' , '3195' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '145.00' , '124.17' , NOW() , NOW() ) 02/10/2025 12:28: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 = '99017' 02/10/2025 12:28:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '99017' 02/10/2025 12:28: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 ( '99017' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 02/10/2025 12:28: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 ( '99017' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 02/10/2025 12:28: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 ( '99017' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 02/10/2025 12:28: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 ( '99017' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 02/10/2025 12:28: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 ( '99017' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 02/10/2025 12:28: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 ( '99017' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 02/10/2025 12:28: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 ( '99017' , '24073' , 'AGENDA LITURGICO PASTORALE 2026 - 40830' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 02/10/2025 12:28: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 ( '99017' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '8.50' ) 02/10/2025 12:29:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3195' AND id_document != '99017' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 12:29:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3195', document_date = '2025-10-02', 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 = '145.00', price_tax_excluded = '124.17', date_upd = NOW() WHERE id_document = '99017' 02/10/2025 12:29:42 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 = '99017' 02/10/2025 12:29:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '99017' 02/10/2025 12:29:42 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 ( '99017' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 02/10/2025 12:29:42 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 ( '99017' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 02/10/2025 12:29:42 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 ( '99017' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 02/10/2025 12:29:42 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 ( '99017' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 02/10/2025 12:29:42 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 ( '99017' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 02/10/2025 12:29:42 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 ( '99017' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 02/10/2025 12:29:42 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 ( '99017' , '24073' , 'AGENDA LITURGICO PASTORALE 2026 - 40830' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 02/10/2025 12:29:43 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 ( '99017' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '8.50' ) 02/10/2025 12:43:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3045' AND id_document != '98828' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-20') 02/10/2025 12:43:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3045', document_date = '2025-09-20', 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.00', price_tax_excluded = '5.74', date_upd = NOW() WHERE id_document = '98828' 02/10/2025 12:43:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98828' 02/10/2025 12:43:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '98828' 02/10/2025 12:43:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98828' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 02/10/2025 12:49:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3196' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 12:49: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 ( '11' , '3196' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.50' , '41.45' , NOW() , NOW() ) 02/10/2025 12:49: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 = '99018' 02/10/2025 12:49:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '99018' 02/10/2025 12:49: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 ( '99018' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '0' , '18.50' ) 02/10/2025 12:49: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 ( '99018' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 02/10/2025 12:49: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 ( '99018' , '19105' , 'FRAGRANZA MIRRA' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 02/10/2025 02:23:12 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 02/10/2025 02:23:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24117' , '1' , '' , 'nuovo-prodotto' ) 02/10/2025 02:23:12 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24117' , '1' , '1' , '2' , NOW() , NOW() ) 02/10/2025 02:23:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24117' , '0' , '1' , '0' , '0' ) 02/10/2025 02:24:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788806266301' AND id_product != '24117' AND ean13 != '' 02/10/2025 02:24:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788806266301', date_upd = NOW() WHERE id_product = '24117' 02/10/2025 02:24:28 pm >> UPDATE ps_product_lang SET name = 'GIOIA - E. BORGNA', description = '' WHERE id_product = '24117' 02/10/2025 02:24:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '24117' 02/10/2025 02:24:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '278', 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 = '24117' 02/10/2025 02:24:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '24117' 02/10/2025 02:24:29 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 = '24117' 02/10/2025 02:24:29 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24118' , '1' , '' , 'nuovo-prodotto' ) 02/10/2025 02:24:29 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 '24118' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24117' 02/10/2025 02:24:29 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24118' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24117' 02/10/2025 02:26:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791223800072' AND id_product != '24118' AND ean13 != '' 02/10/2025 02:26:09 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9791223800072', date_upd = NOW() WHERE id_product = '24118' 02/10/2025 02:26:09 pm >> UPDATE ps_product_lang SET name = 'SPIRITUAL INSIGHT - A. SALZANO ACUTIS', description = '' WHERE id_product = '24118' 02/10/2025 02:26:09 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.9' WHERE id_product = '24118' 02/10/2025 02:26:09 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.9', id_tax_rules_group = '4', id_category_default = '70', 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 = '24118' 02/10/2025 02:26:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '24118' 02/10/2025 02:26:17 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 = '24118' 02/10/2025 02:26:17 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24119' , '1' , '' , 'nuovo-prodotto' ) 02/10/2025 02:26:18 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 '24119' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24118' 02/10/2025 02:26:18 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24119' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24118' 02/10/2025 02:26:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '1726434' , '2025-10-01' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '101.60' , '101.60' , NOW() , NOW() ) 02/10/2025 02:26:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99019' 02/10/2025 02:26:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '99019' 02/10/2025 02:26:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99019' , '24117' , 'GIOIA - E. BORGNA' , '2' , '2' , '4' , '13.00' , '13' , '0' , '0' , '26.0000' ) 02/10/2025 02:26:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24117' AND id_supplier = '177' 02/10/2025 02:26:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24117' , '177' , '1' ) 02/10/2025 02:26:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99019' , '23759' , 'NON IO MA DIO - A. SALZANO ACUTIS' , '1' , '1' , '4' , '18.90' , '18.9' , '0' , '0' , '18.90' ) 02/10/2025 02:26:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23759' AND id_supplier = '177' 02/10/2025 02:26:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23759' , '177' , '1' ) 02/10/2025 02:26:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99019' , '23567' , 'SEGRETO DI MIO FIGLIO - SALZANO/ACUTIS' , '1' , '1' , '4' , '18.90' , '18.9' , '0' , '0' , '18.90' ) 02/10/2025 02:26:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23567' AND id_supplier = '177' 02/10/2025 02:26:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23567' , '177' , '1' ) 02/10/2025 02:26:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99019' , '24118' , 'SPIRITUAL INSIGHT - A. SALZANO ACUTIS' , '2' , '2' , '4' , '18.90' , '18.9' , '0' , '0' , '37.8000' ) 02/10/2025 02:26:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24118' AND id_supplier = '177' 02/10/2025 02:26:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24118' , '177' , '1' ) 02/10/2025 02:34:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3197' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 02:34: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' , '3197' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.75' , '42.42' , NOW() , NOW() ) 02/10/2025 02:34: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 = '99020' 02/10/2025 02:34:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '99020' 02/10/2025 02:34: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 ( '99020' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 02/10/2025 02:34: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 ( '99020' , '23797' , 'PARAFIAMMA PIREX PER CARTUCCIA 5 CM - 474/40' , '1' , '-1' , '1' , '11.50' , '9.4262295081967' , '22' , '0' , '11.50' ) 02/10/2025 02:34: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 ( '99020' , '6354' , 'MEDAGLIA S. MICHELE - G022.22' , '84' , '-84' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '21.00' ) 02/10/2025 02:34: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 ( '99020' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '23' , '-23' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '5.75' ) 02/10/2025 02:35:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2828' AND id_document != '98556' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-02') 02/10/2025 02:35:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2828', document_date = '2025-09-02', 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 = '180.00', price_tax_excluded = '147.54', date_upd = NOW() WHERE id_document = '98556' 02/10/2025 02:35: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 = '98556' 02/10/2025 02:35:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '98556' 02/10/2025 02:35: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 ( '98556' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '9' , '-9' , '1' , '0.1' , '0.081967213114754' , '22' , '0' , '0.90' ) 02/10/2025 02:35: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 ( '98556' , '4911' , 'ICONA DIPINTA A MANO 18X22 - 2043' , '1' , '-1' , '1' , '120.0000' , '98.360655737705' , '22' , '0' , '120.00' ) 02/10/2025 02:35: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 ( '98556' , '21080' , 'ROSARIO ARG. MADREPERLA - 328CAV' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 02/10/2025 02:35: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 ( '98556' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '3' , '-3' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '2.40' ) 02/10/2025 02:35: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 ( '98556' , '8179' , 'PORTACORONA - 017' , '1' , '-1' , '1' , '1.7000' , '1.3934426229508' , '22' , '0' , '1.70' ) 02/10/2025 02:35: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 ( '98556' , '18098' , 'CROCE IN RESINA CM 19 - 3830' , '2' , '-2' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '9.00' ) 02/10/2025 02:35: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 ( '98556' , '18099' , 'CROCE IN RESINA CM 19 - 3831' , '2' , '-2' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '9.00' ) 02/10/2025 02:50:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3027' AND id_document != '98804' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-18') 02/10/2025 02:50:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3027', document_date = '2025-09-18', 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 = '680.00', price_tax_excluded = '557.38', date_upd = NOW() WHERE id_document = '98804' 02/10/2025 02:50:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98804' 02/10/2025 02:50:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '98804' 02/10/2025 02:50:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98804' , '17436' , 'CASULA ROSA - PCA010S11' , '1' , '-1' , '1' , '90.0000' , '73.770491803279' , '22' , '0' , '90.00' ) 02/10/2025 02:50:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98804' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '15.00' ) 02/10/2025 02:50:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98804' , '12742' , 'COPRILEGGIO - 310/TP' , '1' , '-1' , '1' , '79.0000' , '64.754098360656' , '22' , '0' , '79.00' ) 02/10/2025 02:50:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98804' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' , '-1' , '1' , '90.0000' , '73.770491803279' , '22' , '0' , '90.00' ) 02/10/2025 02:50:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98804' , '23168' , 'CAMICE IN MICROFIBRA COCOLLE - 434/PMA' , '1' , '-1' , '1' , '67.0000' , '54.918032786885' , '22' , '0' , '67.00' ) 02/10/2025 02:50:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98804' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '59.0000' , '48.360655737705' , '22' , '0' , '59.00' ) 02/10/2025 02:50:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98804' , '22464' , 'CASULA LEGGERA - 1212' , '3' , '-3' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '210.00' ) 02/10/2025 02:50:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98804' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 02/10/2025 02:51:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3013' AND id_document != '98785' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-17') 02/10/2025 02:51:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3013', document_date = '2025-09-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '74.00', price_tax_excluded = '60.66', date_upd = NOW() WHERE id_document = '98785' 02/10/2025 02:51:22 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 = '98785' 02/10/2025 02:51:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '98785' 02/10/2025 02:51:22 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 ( '98785' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '74' , '60.655737704918' , '22' , '0' , '74.00' ) 02/10/2025 02:51:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3038' AND id_document != '98820' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-19') 02/10/2025 02:51:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3038', document_date = '2025-09-19', 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 = '335.00', price_tax_excluded = '274.59', date_upd = NOW() WHERE id_document = '98820' 02/10/2025 02:51:40 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 = '98820' 02/10/2025 02:51:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '98820' 02/10/2025 02:51:40 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 ( '98820' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 02/10/2025 02:51:40 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 ( '98820' , '16588' , 'CLERGY DIAGONALE ML - C06' , '1' , '-1' , '1' , '46.9000' , '38.44262295082' , '22' , '0' , '46.90' ) 02/10/2025 02:51:40 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 ( '98820' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 02/10/2025 02:51:40 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 ( '98820' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36.5000' , '29.918032786885' , '22' , '0' , '36.50' ) 02/10/2025 02:51:40 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 ( '98820' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 02/10/2025 02:51:40 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 ( '98820' , '22508' , 'POLO PIQUET - M06' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 02/10/2025 02:51:40 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 ( '98820' , '19594' , 'POLO JERSEY COTONE 100%' , '2' , '-2' , '1' , '41.0000' , '33.606557377049' , '22' , '0' , '82.00' ) 02/10/2025 02:51:40 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 ( '98820' , '18131' , 'TAU MEDIO CM3 - T6/T5' , '3' , '-3' , '1' , '0.9000' , '0.73770491803279' , '22' , '0' , '2.70' ) 02/10/2025 02:51:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3010' AND id_document != '98781' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-17') 02/10/2025 02:51:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3010', document_date = '2025-09-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '37.00', price_tax_excluded = '30.33', date_upd = NOW() WHERE id_document = '98781' 02/10/2025 02:51: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 = '98781' 02/10/2025 02:51:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '98781' 02/10/2025 02:51: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 ( '98781' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 02/10/2025 02:52:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2962' AND id_document != '98723' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-11') 02/10/2025 02:52:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2962', document_date = '2025-09-11', 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 = '37.00', price_tax_excluded = '30.33', date_upd = NOW() WHERE id_document = '98723' 02/10/2025 02:52: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 = '98723' 02/10/2025 02:52:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '98723' 02/10/2025 02:52: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 ( '98723' , '1914' , 'CERA DELLA LITURGIA' , '10' , '-10' , '1' , '3.7' , '3.0327868852459' , '22' , '0' , '37.00' ) 02/10/2025 02:52:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2844' AND id_document != '98578' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-03') 02/10/2025 02:52:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2844', 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 = '37.00', price_tax_excluded = '30.33', date_upd = NOW() WHERE id_document = '98578' 02/10/2025 02:52:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98578' 02/10/2025 02:52:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '98578' 02/10/2025 02:52:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98578' , '1914' , 'CERA DELLA LITURGIA' , '10' , '-10' , '1' , '3.7' , '3.0327868852459' , '22' , '0' , '37.00' ) 02/10/2025 02:53:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2278' AND id_document != '97888' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-27') 02/10/2025 02:53:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2278', document_date = '2025-06-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 = '146.00', price_tax_excluded = '119.67', date_upd = NOW() WHERE id_document = '97888' 02/10/2025 02:53: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 = '97888' 02/10/2025 02:53:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '97888' 02/10/2025 02:53: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 ( '97888' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '38.0000' , '31.147540983607' , '22' , '0' , '38.00' ) 02/10/2025 02:53: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 ( '97888' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '108.00' ) 02/10/2025 02:54:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2416' AND id_document != '98056' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-10') 02/10/2025 02:54:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2416', document_date = '2025-07-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '240.00', price_tax_excluded = '196.72', date_upd = NOW() WHERE id_document = '98056' 02/10/2025 02:54:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98056' 02/10/2025 02:54:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '98056' 02/10/2025 02:54:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98056' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '142.9' , '117.13114754098' , '22' , '0' , '142.90' ) 02/10/2025 02:54:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98056' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '39.5000' , '32.377049180328' , '22' , '0' , '39.50' ) 02/10/2025 02:54:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98056' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.8' , '3.9344262295082' , '22' , '0' , '57.60' ) 02/10/2025 02:58:51 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 ( '31' , '48' , '2025-02-14' , '' , '0' , '0' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , '' , '13.00' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '1037.14' , '1034.28' , NOW() , NOW() ) 02/10/2025 02:58:51 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 = '99021' 02/10/2025 02:58:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '99021' 02/10/2025 02:58:51 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 ( '99021' , '19906' , 'FASCIA PER TALARE' , '1' , '1' , '1' , '49.0000' , '40.1639' , '22' , '3' , '57.99' ) 02/10/2025 02:58: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 ( '99021' , '23468' , 'CASULA MARIANA LANA/RASO - 65/019945-M' , '1' , '1' , '1' , '720.0000' , '590.1639' , '22' , '3' , '852.05' ) 02/10/2025 02:58: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 ( '99021' , '19906' , 'FASCIA PER TALARE' , '2' , '2' , '1' , '47.0000' , '38.5246' , '22' , '3' , '111.24' ) 02/10/2025 02:59:03 pm >> DELETE FROM ps_document WHERE id_document = '95867' 02/10/2025 02:59:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '95867' 02/10/2025 02:59:57 pm >> DELETE FROM ps_document WHERE id_document = '95796' 02/10/2025 02:59:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '95796' 02/10/2025 03:00:54 pm >> DELETE FROM ps_document WHERE id_document = '88345' 02/10/2025 03:00:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '88345' 02/10/2025 03:07:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3034' AND id_document != '98815' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-19') 02/10/2025 03:07:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3034', document_date = '2025-09-19', 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 = '53.90', price_tax_excluded = '46.52', date_upd = NOW() WHERE id_document = '98815' 02/10/2025 03:07:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98815' 02/10/2025 03:07:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '98815' 02/10/2025 03:07:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98815' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 02/10/2025 03:07:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98815' , '13609' , 'APPENDICHIAVI 12X12 - RAQ' , '1' , '-1' , '1' , '15.9000' , '13.032786885246' , '22' , '0' , '15.90' ) 02/10/2025 03:07:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98815' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 02/10/2025 03:15:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '91' AND id_document != '95217' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-09') 02/10/2025 03:15:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '91', document_date = '2025-01-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '280.00', price_tax_excluded = '229.51', date_upd = NOW() WHERE id_document = '95217' 02/10/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 = '95217' 02/10/2025 03:15:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '95217' 02/10/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 ( '95217' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '280' , '229.50819672131' , '22' , '0' , '280.00' ) 02/10/2025 03:18:08 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '213', document_date = '2025-04-29', document_letter = '', id_customer = '0', id_supplier = '81', id_address = '2696', address1 = 'C.SO UMBERTO I , 70 80034 MARIGLIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '67.20', price_tax_excluded = '67.20', date_upd = NOW() WHERE id_document = '96993' 02/10/2025 03:18: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 = '96993' 02/10/2025 03:18:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '96993' 02/10/2025 03:18: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 ( '96993' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '2560' , '2560' , '4' , '0.0350' , '0.035' , '0' , '25' , '67.20' ) 02/10/2025 03:18:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '81' 02/10/2025 03:18:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '81' , '1' ) 02/10/2025 03:20:30 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 ( '31' , '25LER345' , '2025-07-21' , '' , '0' , '81' , '2696' , 'C.SO UMBERTO I , 70 80034 MARIGLIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '67.20' , '67.20' , NOW() , NOW() ) 02/10/2025 03:20:30 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 = '99022' 02/10/2025 03:20:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '99022' 02/10/2025 03:20:30 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 ( '99022' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '2560' , '2560' , '4' , '0.035' , '0.035' , '0' , '25' , '67.2000' ) 02/10/2025 03:20:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '81' 02/10/2025 03:20:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '81' , '1' ) 02/10/2025 03:21:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3017' AND id_document != '98791' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-18') 02/10/2025 03:21:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3017', document_date = '2025-09-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA ERITREA 69D 84081 BARONISSI', 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 = '290.00', price_tax_excluded = '279.00', date_upd = NOW() WHERE id_document = '98791' 02/10/2025 03:21:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98791' 02/10/2025 03:21:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '98791' 02/10/2025 03:21:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98791' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 02/10/2025 03:21:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98791' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '57' , '57' , '0' , '0' , '57.00' ) 02/10/2025 03:21:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98791' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 02/10/2025 03:21:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98791' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 02/10/2025 03:21:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98791' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '5' , '38.00' ) 02/10/2025 03:21:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98791' , '12317' , 'SCATOLA PORTA OSTIE IN ALLUMINIO - 1879' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 02/10/2025 03:21:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98791' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '49.0000' , '40.16393442623' , '22' , '0' , '49.00' ) 02/10/2025 03:22:15 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '11858' 02/10/2025 03:22:15 pm >> UPDATE ps_stock_available SET quantity = quantity + '-80' WHERE id_product = '11858' 02/10/2025 03:24:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '1441120258027434' , '2025-09-30' , '' , '0' , '63' , '2658' , 'P.ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 02/10/2025 03:24:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99023' 02/10/2025 03:24:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '99023' 02/10/2025 03:24:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99023' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '430' , '430' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 02/10/2025 03:24:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '63' 02/10/2025 03:24:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '63' , '1' ) 02/10/2025 03:25:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2309' AND id_document != '97924' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-30') 02/10/2025 03:25:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2309', document_date = '2025-06-30', 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 = '2.10', price_tax_excluded = '2.10', date_upd = NOW() WHERE id_document = '97924' 02/10/2025 03:25: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 = '97924' 02/10/2025 03:25:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '97924' 02/10/2025 03:25: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 ( '97924' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '2.1' , '2.1' , '0' , '0' , '2.10' ) 02/10/2025 03:29:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '91' AND id_document != '95217' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-09') 02/10/2025 03:29:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '91', document_date = '2025-01-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '280.00', price_tax_excluded = '229.51', date_upd = NOW() WHERE id_document = '95217' 02/10/2025 03:29:21 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 = '95217' 02/10/2025 03:29:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '95217' 02/10/2025 03:29:21 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 ( '95217' , '17006' , 'SEGNALIBRO PR' , '25' , '-25' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '10.00' ) 02/10/2025 03:29:21 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 ( '95217' , '12849' , 'LIBRO DELLE SS. MESSE' , '15' , '-15' , '1' , '20.00' , '16.393442622951' , '22' , '10' , '270.00' ) 02/10/2025 03:48:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3198' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 03:48: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' , '3198' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 02/10/2025 03:48: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 = '99024' 02/10/2025 03:48:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '99024' 02/10/2025 03:48: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 ( '99024' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '0' , '38.00' ) 02/10/2025 05:01:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3199' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 05:01:43 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' , '3199' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.30' , '32.30' , NOW() , NOW() ) 02/10/2025 05:01:43 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 = '99025' 02/10/2025 05:01:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '99025' 02/10/2025 05:01:43 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 ( '99025' , '20879' , 'SALITA DEL MONTE CARMELO - G. DELLA CROCE' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 02/10/2025 05:01:43 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 ( '99025' , '23389' , 'MISTICA DELLA RIPARAZIONE - BARSOTTI' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 02/10/2025 05:03:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3200' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 05:03: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 ( '11' , '3200' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '67.00' , '59.16' , NOW() , NOW() ) 02/10/2025 05:03: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 = '99026' 02/10/2025 05:03:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '99026' 02/10/2025 05:03: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 ( '99026' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 02/10/2025 05:03: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 ( '99026' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 02/10/2025 05:03: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 ( '99026' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '20' , '-20' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '24.00' ) 02/10/2025 05:03: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 ( '99026' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '10' , '10' , '0' , '0' , '20.00' ) 02/10/2025 05:03: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 ( '99026' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 02/10/2025 05:07:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3201' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 05:07: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 ( '11' , '3201' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.00' , '47.54' , NOW() , NOW() ) 02/10/2025 05:07: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 = '99027' 02/10/2025 05:07:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '99027' 02/10/2025 05:07: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 ( '99027' , '16461' , 'CLERGY NIDO D\'APE ML - C22' , '1' , '-1' , '1' , '58.00' , '47.540983606557' , '22' , '0' , '58.00' ) 02/10/2025 06:04:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895783994' AND id_product != '15317' AND ean13 != '' 02/10/2025 06:04:32 pm >> UPDATE ps_product SET id_supplier = '127', reference = '4/4', ean13 = '9788895783994', date_upd = NOW() WHERE id_product = '15317' 02/10/2025 06:04:32 pm >> UPDATE ps_product_lang SET name = 'LA COMUNIONE SPIEGATA AI RAGAZZI', description = '' WHERE id_product = '15317' 02/10/2025 06:04:32 pm >> UPDATE ps_product SET wholesale_price = '1.17', on_sale = '0', price = '1.8000' WHERE id_product = '15317' 02/10/2025 06:04:32 pm >> UPDATE ps_product_shop SET wholesale_price = '1.17', price = '1.8000', id_tax_rules_group = '4', id_category_default = '37', id_argoment_default = '108', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15317' 02/10/2025 06:04:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '15317' 02/10/2025 06:08:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571238' AND id_product != '13462' AND ean13 != '' 02/10/2025 06:08:07 pm >> UPDATE ps_product SET id_supplier = '127', reference = 'ESPOSITORE SAN PAOLO', ean13 = '9788899571238', date_upd = NOW() WHERE id_product = '13462' 02/10/2025 06:08:07 pm >> UPDATE ps_product_lang SET name = 'SE MI AMI NON PIANGERE', description = '' WHERE id_product = '13462' 02/10/2025 06:08:07 pm >> UPDATE ps_product SET wholesale_price = '0.98', on_sale = '0', price = '1.8' WHERE id_product = '13462' 02/10/2025 06:08:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.98', price = '1.8', id_tax_rules_group = '4', id_category_default = '37', 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 = '13462' 02/10/2025 06:08:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '13462' 02/10/2025 06:19:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3202' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 06:19:22 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' , '3202' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.05' , '37.05' , NOW() , NOW() ) 02/10/2025 06:19:22 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 = '99028' 02/10/2025 06:19:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '99028' 02/10/2025 06:19:22 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 ( '99028' , '17734' , 'VANGELO E ATTI BAMBINI' , '13' , '-13' , '4' , '3.00' , '3' , '0' , '5' , '37.05' ) 02/10/2025 06:22:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '107' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 06:22:24 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 ( '21' , '107' , '2025-10-02' , '' , '3931' , '0' , '4679347' , 'VIALE DELLA LIBERA 11 80079 PROCIDA' , '' , '' , '13' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '83.38' , '83.38' , NOW() , NOW() ) 02/10/2025 06:22:24 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 = '99029' 02/10/2025 06:22:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '99029' 02/10/2025 06:22:24 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 ( '99029' , '13462' , 'SE MI AMI NON PIANGERE' , '2' , '-2' , '4' , '1.8' , '1.8' , '0' , '15' , '3.06' ) 02/10/2025 06:22:24 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 ( '99029' , '14487' , 'PREGHIERA DELLE 5 DITA' , '2' , '-2' , '4' , '1.80' , '1.8' , '0' , '15' , '3.06' ) 02/10/2025 06:22:24 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 ( '99029' , '13840' , 'NONNI SONO UN TESORO' , '2' , '-2' , '4' , '1.80' , '1.8' , '0' , '15' , '3.06' ) 02/10/2025 06:22:24 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 ( '99029' , '9815' , 'SEGNO DELLA CROCE' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '15' , '2.55' ) 02/10/2025 06:22:24 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 ( '99029' , '18357' , 'MIE PREGHIERINE N.E.' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '15' , '2.55' ) 02/10/2025 06:22:24 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 ( '99029' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '15' , '4.25' ) 02/10/2025 06:22:24 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 ( '99029' , '20460' , 'AVE MARIA SPIEGATA AI BAMBINI' , '2' , '-2' , '4' , '1.80' , '1.8' , '0' , '15' , '3.06' ) 02/10/2025 06:22:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99029' , '15739' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '15' , '4.25' ) 02/10/2025 06:22:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99029' , '17325' , 'ALLA SCOPERTA DELLA CASA DI GESU\'' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '15' , '5.10' ) 02/10/2025 06:22:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99029' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '15' , '4.25' ) 02/10/2025 06:22:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99029' , '17350' , 'NATALE SPIEGATO AI BAMBINI' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '15' , '5.10' ) 02/10/2025 06:22:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99029' , '15318' , 'PERDONAMI SIGNORE ' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '15' , '4.25' ) 02/10/2025 06:22:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99029' , '17034' , 'SACRAMENTO DEL PERDONO' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '15' , '3.40' ) 02/10/2025 06:22:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99029' , '15317' , 'LA COMUNIONE SPIEGATA AI RAGAZZI' , '2' , '-2' , '4' , '1.80' , '1.8' , '0' , '15' , '3.06' ) 02/10/2025 06:22:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99029' , '15602' , 'AMICO GESU\' ALBUM' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '15' , '1.70' ) 02/10/2025 06:22:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99029' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '15' , '2.55' ) 02/10/2025 06:22:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99029' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '15' , '4.25' ) 02/10/2025 06:22:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99029' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '15' , '4.25' ) 02/10/2025 06:22:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99029' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '15' , '4.25' ) 02/10/2025 06:22:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99029' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '15' , '2.38' ) 02/10/2025 06:30:36 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'UBaC2cGVU3hSxTBb' , NOW() , NOW() ) 02/10/2025 06:30:36 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4245' , '1' ) 02/10/2025 06:30:36 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4245' , '2' ) 02/10/2025 06:30:36 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4245' , '3' ) 02/10/2025 06:30:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3203' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 06:30:51 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' , '3203' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 02/10/2025 06:30:51 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 = '99030' 02/10/2025 06:30:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '99030' 02/10/2025 06:30:51 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 ( '99030' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 02/10/2025 06:33:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3204' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 06:33:22 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' , '3204' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.80' , '80.47' , NOW() , NOW() ) 02/10/2025 06:33:22 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 = '99031' 02/10/2025 06:33:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '99031' 02/10/2025 06:33:22 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 ( '99031' , '22598' , 'CATENINA CON CROCE - BKSS-0094BK' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 02/10/2025 06:33:22 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 ( '99031' , '23780' , 'COLLANA E CROCE MADREPERLA - N203' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 02/10/2025 06:33:22 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 ( '99031' , '24102' , 'MALE - R. TALMELLI' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 02/10/2025 06:33:22 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 ( '99031' , '24004' , 'AMORE E RELAZIONE - A. GALLITELLI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 02/10/2025 06:33:22 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 ( '99031' , '23978' , 'SACRA LITURGIA - E. FINOTTI' , '1' , '-1' , '4' , '26.00' , '26' , '0' , '5' , '24.70' ) 02/10/2025 06:53:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3205' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 06:53:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3205' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 02/10/2025 06:53:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99032' 02/10/2025 06:53:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '99032' 02/10/2025 06:53:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99032' , '18561' , 'FORMELLA SAGOMATA 26X26 ' , '1' , '-1' , '1' , '98.00' , '80.327868852459' , '22' , '0' , '98.00' ) 02/10/2025 06:53:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99032' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 02/10/2025 07:40:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3206' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-02') 02/10/2025 07:40: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' , '3206' , '2025-10-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 02/10/2025 07:40: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 = '99033' 02/10/2025 07:40:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '99033' 02/10/2025 07:40: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 ( '99033' , '22604' , 'CATENINA CON CROCE NERA - BKSS-0097BK' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' )