27/10/2025 09:02:56 am >> SELECT document_num FROM ps_document WHERE document_num = '162' AND id_document != '99454' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-24') 27/10/2025 09:02:56 am >> UPDATE ps_document SET id_document_type = '21', document_num = '162', document_date = '2025-10-24', document_letter = '', id_customer = '4264', id_supplier = '', id_address = '4679593', address1 = 'PIAZZA MAZZINI 35 44033 SERRAVALLE', address2 = '', note = '', price_shipping = '5', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '167.45', price_tax_excluded = '167.45', date_upd = NOW() WHERE id_document = '99454' 27/10/2025 09:02:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99454' 27/10/2025 09:02:56 am >> DELETE FROM ps_document_detail WHERE id_document = '99454' 27/10/2025 09:02:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99454' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '5' , '66.50' ) 27/10/2025 09:02:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99454' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '5' , '11.40' ) 27/10/2025 09:02:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99454' , '4154' , 'FESTA DEL PERDONO' , '8' , '-8' , '4' , '3.0000' , '3' , '0' , '5' , '22.80' ) 27/10/2025 09:02:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99454' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 27/10/2025 09:02:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99454' , '8408' , 'PRENDETE E MANGIATE' , '15' , '-15' , '4' , '3.0000' , '3' , '0' , '5' , '42.75' ) 27/10/2025 09:02:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99454' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 27/10/2025 09:03:48 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '04Auy59YaYixeXf5' , NOW() , NOW() ) 27/10/2025 09:03:48 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4267' , '1' ) 27/10/2025 09:03:48 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4267' , '2' ) 27/10/2025 09:03:48 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4267' , '3' ) 27/10/2025 09:05:31 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4267' 27/10/2025 09:05:31 am >> 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 ( '4267' , '10' , '135' , '' , 'QUARTUCCIO' , 'ANTONELLA ' , 'VIA DELLE MIMOSE 28' , '' , '24022' , 'BERGAMO' , '' , '' , '3756270956' , '' , '' , NOW() , NOW() ) 27/10/2025 09:05:31 am >> UPDATE ps_customer SET email = 'margot1675@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4267' 27/10/2025 09:06:11 am >> SELECT document_num FROM ps_document WHERE document_num = '167' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 09:06:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '167' , '2025-10-27' , '' , '4267' , '0' , '4679596' , 'VIA DELLE MIMOSE 28 24022 BERGAMO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '5.86' , '5.86' , NOW() , NOW() ) 27/10/2025 09:06:11 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 = '99494' 27/10/2025 09:06:11 am >> DELETE FROM ps_document_detail WHERE id_document = '99494' 27/10/2025 09:06:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99494' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.86' , '0.86' , '0' , '0' , '0.86' ) 27/10/2025 09:33:14 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4267' 27/10/2025 09:33:14 am >> 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 ( '4267' , '10' , '135' , '' , 'QUARTUCCIO' , 'ANTONELLA ' , 'VIA DELLE MIMOSE 28' , '' , '24040' , 'BERGAMO' , '' , '' , '3756270956' , '' , '' , NOW() , NOW() ) 27/10/2025 09:33:14 am >> UPDATE ps_customer SET email = 'margot1675@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4267' 27/10/2025 09:37:53 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4267' 27/10/2025 09:37:53 am >> 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 ( '4267' , '10' , '135' , '' , 'QUARTUCCIO' , 'ANTONELLA ' , 'VIA DELLE MIMOSE 28' , '' , '24040' , 'VERDELLINO' , '' , '' , '3756270956' , '' , '' , NOW() , NOW() ) 27/10/2025 09:37:53 am >> UPDATE ps_customer SET email = 'margot1675@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4267' 27/10/2025 09:43:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3527' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 09:43:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3527' , '2025-10-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 27/10/2025 09:43:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99495' 27/10/2025 09:43:14 am >> DELETE FROM ps_document_detail WHERE id_document = '99495' 27/10/2025 09:43:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99495' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/10/2025 09:57:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3528' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 09:57: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 ( '11' , '3528' , '2025-10-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.90' , '17.95' , NOW() , NOW() ) 27/10/2025 09:57: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 = '99496' 27/10/2025 09:57:19 am >> DELETE FROM ps_document_detail WHERE id_document = '99496' 27/10/2025 09:57: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 ( '99496' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - 1492' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 27/10/2025 09:57: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 ( '99496' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 27/10/2025 09:57:50 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/10/2025 09:57:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24186' , '1' , '' , 'nuovo-prodotto' ) 27/10/2025 09:57:50 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24186' , '1' , '1' , '2' , NOW() , NOW() ) 27/10/2025 09:57:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24186' , '0' , '1' , '0' , '0' ) 27/10/2025 09:58:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851431280' AND id_product != '24186' AND ean13 != '' 27/10/2025 09:58:35 am >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788851431280', date_upd = NOW() WHERE id_product = '24186' 27/10/2025 09:58:35 am >> UPDATE ps_product_lang SET name = 'DILEXI TE ', description = '' WHERE id_product = '24186' 27/10/2025 09:58:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2' WHERE id_product = '24186' 27/10/2025 09:58:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24186' 27/10/2025 09:58:35 am >> DELETE FROM ps_specific_price WHERE id_product = '24186' 27/10/2025 09:58:53 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/10/2025 09:58:53 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24187' , '1' , '' , 'nuovo-prodotto' ) 27/10/2025 09:58:53 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24187' , '1' , '1' , '2' , NOW() , NOW() ) 27/10/2025 09:58:53 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24187' , '0' , '1' , '0' , '0' ) 27/10/2025 09:59:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839929303' AND id_product != '24187' AND ean13 != '' 27/10/2025 09:59:56 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788839929303', date_upd = NOW() WHERE id_product = '24187' 27/10/2025 09:59:56 am >> UPDATE ps_product_lang SET name = 'QUALE VITA DOPO LA MORTE? BILLON/RAMOND', description = '' WHERE id_product = '24187' 27/10/2025 09:59:56 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '23' WHERE id_product = '24187' 27/10/2025 09:59:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '23', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24187' 27/10/2025 09:59:56 am >> DELETE FROM ps_specific_price WHERE id_product = '24187' 27/10/2025 10:00:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839929303' AND id_product != '24187' AND ean13 != '' 27/10/2025 10:00:05 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788839929303', date_upd = NOW() WHERE id_product = '24187' 27/10/2025 10:00:05 am >> UPDATE ps_product_lang SET name = 'QUALE VITA DOPO LA MORTE? BILLON/RAMOND', description = '' WHERE id_product = '24187' 27/10/2025 10:00:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '23' WHERE id_product = '24187' 27/10/2025 10:00:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '23', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24187' 27/10/2025 10:00:05 am >> DELETE FROM ps_specific_price WHERE id_product = '24187' 27/10/2025 10:02: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 ( '33' , '713356' , '2025-10-23' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.22' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '113.76' , '113.76' , NOW() , NOW() ) 27/10/2025 10:02: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 = '99497' 27/10/2025 10:02:01 am >> DELETE FROM ps_document_detail WHERE id_document = '99497' 27/10/2025 10:02: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 ( '99497' , '8274' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 1 - TEMPI FORTI' , '1' , '1' , '4' , '28.00' , '28' , '0' , '30' , '19.6000' ) 27/10/2025 10:02:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '8274' AND id_supplier = '7' 27/10/2025 10:02:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8274' , '7' , '1' ) 27/10/2025 10:02: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 ( '99497' , '8275' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 2 - TEMPO ORDINARIO' , '1' , '1' , '4' , '38.00' , '38' , '0' , '30' , '26.6000' ) 27/10/2025 10:02:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '8275' AND id_supplier = '7' 27/10/2025 10:02:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8275' , '7' , '1' ) 27/10/2025 10:02: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 ( '99497' , '24187' , 'QUALE VITA DOPO LA MORTE? BILLON/RAMOND' , '1' , '1' , '4' , '23.00' , '23' , '0' , '30' , '16.1000' ) 27/10/2025 10:02:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '24187' AND id_supplier = '7' 27/10/2025 10:02:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24187' , '7' , '1' ) 27/10/2025 10:02: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 ( '99497' , '24186' , 'DILEXI TE ' , '36' , '36' , '4' , '2.00' , '2' , '0' , '33' , '48.2400' ) 27/10/2025 10:02:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '24186' AND id_supplier = '7' 27/10/2025 10:02:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24186' , '7' , '1' ) 27/10/2025 10:02: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 ( '99497' , '24186' , 'DILEXI TE ' , '3' , '3' , '4' , '2.00' , '2' , '0' , '100' , '0.0000' ) 27/10/2025 10:02:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '24186' AND id_supplier = '7' 27/10/2025 10:02:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24186' , '7' , '1' ) 27/10/2025 10:03:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '713355' , '2025-10-23' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0.72' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.48' , '22.48' , NOW() , NOW() ) 27/10/2025 10:03:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99498' 27/10/2025 10:03:08 am >> DELETE FROM ps_document_detail WHERE id_document = '99498' 27/10/2025 10:03:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99498' , '1996' , 'CHIAMATA ANNO 4 - QUADERNO - L.A. LEPORATI' , '8' , '8' , '4' , '4.50' , '4.5' , '0' , '35+7' , '21.7620' ) 27/10/2025 10:03:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '1996' AND id_supplier = '7' 27/10/2025 10:03:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1996' , '7' , '1' ) 27/10/2025 10:14:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3529' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 10:14:47 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' , '3529' , '2025-10-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.71' , '32.35' , NOW() , NOW() ) 27/10/2025 10:14:47 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 = '99499' 27/10/2025 10:14:47 am >> DELETE FROM ps_document_detail WHERE id_document = '99499' 27/10/2025 10:14:47 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 ( '99499' , '23757' , 'MEDAGLIA SAN BENEDETTO - M244/A SM' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 27/10/2025 10:14:47 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 ( '99499' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 27/10/2025 10:14:47 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 ( '99499' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 27/10/2025 10:14:47 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 ( '99499' , '24096' , 'AVVENTO E NATALE 2025/26' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 27/10/2025 10:14:47 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 ( '99499' , '24182' , 'ANDIAMO INCONTRO A GESU' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 27/10/2025 10:14:47 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 ( '99499' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '100' , '0.00' ) 27/10/2025 10:14:47 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 ( '99499' , '24041' , 'BIBBIA ACTIVITY BOOK' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 27/10/2025 10:26:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3530' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 10:26:28 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' , '3530' , '2025-10-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.20' , '2.62' , NOW() , NOW() ) 27/10/2025 10:26:28 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 = '99500' 27/10/2025 10:26:28 am >> DELETE FROM ps_document_detail WHERE id_document = '99500' 27/10/2025 10:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99500' , '12220' , 'MEDAGLIA OVALE DECORATA - FATIMA - G291' , '2' , '-2' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '1.60' ) 27/10/2025 10:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99500' , '6330' , 'MEDAGLIA OVALE DECORATA - MAD CARMINE - G291-D' , '2' , '-2' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '1.60' ) 27/10/2025 10:44:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3531' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 10:44: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' , '3531' , '2025-10-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 27/10/2025 10:44: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 = '99501' 27/10/2025 10:44:15 am >> DELETE FROM ps_document_detail WHERE id_document = '99501' 27/10/2025 10:44: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 ( '99501' , '23776' , 'ROSARIO LEGNO 10MM - R987' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 27/10/2025 10:44: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 ( '99501' , '19148' , 'CANDELE STEREATICHE E/5' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 27/10/2025 10:46:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '713177' , '2025-10-23' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '13.24' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '413.81' , '413.81' , NOW() , NOW() ) 27/10/2025 10:46:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99502' 27/10/2025 10:46:38 am >> DELETE FROM ps_document_detail WHERE id_document = '99502' 27/10/2025 10:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '20255' , 'DOMENICHE DA COLORARE - ANNO A' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '30+7' , '6.4449' ) 27/10/2025 10:46:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '20255' AND id_supplier = '7' 27/10/2025 10:46:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20255' , '7' , '1' ) 27/10/2025 10:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '10' , '10' , '4' , '5.00' , '5' , '0' , '35+7' , '30.2250' ) 27/10/2025 10:46:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '10741' AND id_supplier = '7' 27/10/2025 10:46:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10741' , '7' , '1' ) 27/10/2025 10:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '20' , '20' , '4' , '5.00' , '5' , '0' , '35+7' , '60.4500' ) 27/10/2025 10:46:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '21436' AND id_supplier = '7' 27/10/2025 10:46:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21436' , '7' , '1' ) 27/10/2025 10:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '20' , '20' , '4' , '5.00' , '5' , '0' , '35+7' , '60.4500' ) 27/10/2025 10:46:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22804' AND id_supplier = '7' 27/10/2025 10:46:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22804' , '7' , '1' ) 27/10/2025 10:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '20' , '20' , '4' , '5.00' , '5' , '0' , '35+7' , '60.4500' ) 27/10/2025 10:46:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '21437' AND id_supplier = '7' 27/10/2025 10:46:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21437' , '7' , '1' ) 27/10/2025 10:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '21484' , 'MIA IMPRONTA NELLA TUA - GUIDA 1 - N.E.' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+7' , '18.1350' ) 27/10/2025 10:46:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '21484' AND id_supplier = '7' 27/10/2025 10:46:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21484' , '7' , '1' ) 27/10/2025 10:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '21735' , 'IMPRONTE DI MISERICORDIA - GUIDA 2 - N.E.' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35+7' , '9.0675' ) 27/10/2025 10:46:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '21735' AND id_supplier = '7' 27/10/2025 10:46:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21735' , '7' , '1' ) 27/10/2025 10:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35+7' , '18.1350' ) 27/10/2025 10:46:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22803' AND id_supplier = '7' 27/10/2025 10:46:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22803' , '7' , '1' ) 27/10/2025 10:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35+7' , '9.0675' ) 27/10/2025 10:46:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '17230' AND id_supplier = '7' 27/10/2025 10:46:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17230' , '7' , '1' ) 27/10/2025 10:46:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35+7' , '9.0675' ) 27/10/2025 10:46:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '15927' AND id_supplier = '7' 27/10/2025 10:46:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15927' , '7' , '1' ) 27/10/2025 10:46:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '23789' , 'SAN PIERGIORGIO FRASSATI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '35+7' , '8.4630' ) 27/10/2025 10:46:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '23789' AND id_supplier = '7' 27/10/2025 10:46:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23789' , '7' , '1' ) 27/10/2025 10:46:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '24044' , 'PREGHIERE DEI FEDELI A-B-C-' , '1' , '1' , '4' , '19.00' , '19' , '0' , '35+7' , '11.4855' ) 27/10/2025 10:46:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '24044' AND id_supplier = '7' 27/10/2025 10:46:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24044' , '7' , '1' ) 27/10/2025 10:46:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '12895' , 'PASSI VERSO LA CRESIMA' , '4' , '4' , '4' , '7.90' , '7.9' , '0' , '35+7' , '19.1022' ) 27/10/2025 10:46:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '12895' AND id_supplier = '7' 27/10/2025 10:46:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12895' , '7' , '1' ) 27/10/2025 10:46:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '15610' , 'MAMMA E PAPA A CATECHISMO' , '1' , '1' , '4' , '7.90' , '7.9' , '0' , '35+7' , '4.7755' ) 27/10/2025 10:46:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '15610' AND id_supplier = '7' 27/10/2025 10:46:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15610' , '7' , '1' ) 27/10/2025 10:46:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '12937' , 'CATECHISMO DELLA CHIESA CATTOLICA' , '1' , '1' , '4' , '29.90' , '29.9' , '0' , '33+7' , '18.6307' ) 27/10/2025 10:46:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '12937' AND id_supplier = '7' 27/10/2025 10:46:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12937' , '7' , '1' ) 27/10/2025 10:46:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '21003' , 'FARE CATECHESI OGGI - U. MONTISCI' , '1' , '1' , '4' , '38.00' , '38' , '0' , '33+7' , '23.6778' ) 27/10/2025 10:46:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '21003' AND id_supplier = '7' 27/10/2025 10:46:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21003' , '7' , '1' ) 27/10/2025 10:46:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '11540' , 'VOGLIAMO IL BATTESIMO PER NOSTRO FIGLIO' , '5' , '5' , '4' , '2.00' , '2' , '0' , '35+7' , '6.0450' ) 27/10/2025 10:46:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '11540' AND id_supplier = '7' 27/10/2025 10:46:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11540' , '7' , '1' ) 27/10/2025 10:46:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '7258' , 'ORA DI CATECHISMO 1 QUADERNO - L. FERRARESSO' , '1' , '1' , '4' , '4.50' , '4.5' , '0' , '35+7' , '2.7203' ) 27/10/2025 10:46:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '7258' AND id_supplier = '7' 27/10/2025 10:46:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7258' , '7' , '1' ) 27/10/2025 10:46:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '24000' , 'SEGUIRE ' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35+7' , '9.0675' ) 27/10/2025 10:46:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '24000' AND id_supplier = '7' 27/10/2025 10:46:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24000' , '7' , '1' ) 27/10/2025 10:46:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '10889' , 'PROGETTO DA SCOPRIRE 5 QUADERNO - L.A. LEPORATI' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '35+7' , '4.2315' ) 27/10/2025 10:46:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '10889' AND id_supplier = '7' 27/10/2025 10:46:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10889' , '7' , '1' ) 27/10/2025 10:46:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99502' , '10888' , 'PROGETTO DA SCOPRIRE GUIDA - L.A. LEPORATI' , '2' , '2' , '4' , '9.00' , '9' , '0' , '35+7' , '10.8810' ) 27/10/2025 10:46:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '10888' AND id_supplier = '7' 27/10/2025 10:46:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10888' , '7' , '1' ) 27/10/2025 10:56:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3532' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 10:56:31 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' , '3532' , '2025-10-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.50' , '5.33' , NOW() , NOW() ) 27/10/2025 10:56:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99503' 27/10/2025 10:56:31 am >> DELETE FROM ps_document_detail WHERE id_document = '99503' 27/10/2025 10:56:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99503' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '5' , '-5' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '6.50' ) 27/10/2025 10:57:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3533' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 10:57:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3533' , '2025-10-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '83.51' , '83.51' , NOW() , NOW() ) 27/10/2025 10:57:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99504' 27/10/2025 10:57:02 am >> DELETE FROM ps_document_detail WHERE id_document = '99504' 27/10/2025 10:57:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99504' , '23785' , 'SANTA MESSA DEGLI SPOSI - 8211' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 27/10/2025 10:57:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99504' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '17' , '-17' , '4' , '5.00' , '5' , '0' , '5' , '80.75' ) 27/10/2025 11:11:19 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/10/2025 11:11:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24188' , '1' , '' , 'nuovo-prodotto' ) 27/10/2025 11:11:19 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24188' , '1' , '1' , '2' , NOW() , NOW() ) 27/10/2025 11:11:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24188' , '0' , '1' , '0' , '0' ) 27/10/2025 11:12:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892249653' AND id_product != '24188' AND ean13 != '' 27/10/2025 11:12:55 am >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788892249653', date_upd = NOW() WHERE id_product = '24188' 27/10/2025 11:12:55 am >> UPDATE ps_product_lang SET name = 'MA ANCHE NO - F. ROSINI', description = '' WHERE id_product = '24188' 27/10/2025 11:12:55 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '24188' 27/10/2025 11:12:55 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24188' 27/10/2025 11:12:55 am >> DELETE FROM ps_specific_price WHERE id_product = '24188' 27/10/2025 11:21:35 am >> SELECT document_num FROM ps_document WHERE document_num = '122/A' AND id_document != '99206' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-13') 27/10/2025 11:21:35 am >> UPDATE ps_document SET id_document_type = '24', document_num = '122/A', document_date = '2025-10-13', document_letter = 'A', id_customer = '973', id_supplier = '', id_address = '4677360', address1 = 'VIA MUNICIPIO 83020 TORCHIATI-MONTORO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '248.41', price_tax_excluded = '248.41', date_upd = NOW() WHERE id_document = '99206' 27/10/2025 11:21:35 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 = '99206' 27/10/2025 11:21:35 am >> DELETE FROM ps_document_detail WHERE id_document = '99206' 27/10/2025 11:21: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 ( '99206' , '5457' , 'IO SONO CON VOI 1 PARTE' , '27' , '-27' , '4' , '2.8000' , '2.8' , '0' , '15' , '64.26' ) 27/10/2025 11:21: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 ( '99206' , '5446' , 'IO SONO CON VOI - GUIDA' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '15' , '20.40' ) 27/10/2025 11:21: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 ( '99206' , '5444' , 'IO SONO CON VOI - CAT.' , '16' , '-16' , '4' , '5.5000' , '5.5' , '0' , '0' , '88.00' ) 27/10/2025 11:21: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 ( '99206' , '5823' , 'LIBRO D\'ORO' , '20' , '-20' , '4' , '0.6000' , '0.6' , '0' , '0' , '12.00' ) 27/10/2025 11:21: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 ( '99206' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 27/10/2025 11:21: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 ( '99206' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '15' , '59.50' ) 27/10/2025 11:23:21 am >> SELECT document_num FROM ps_document WHERE document_num = '122/A' AND id_document != '99206' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-13') 27/10/2025 11:23:21 am >> UPDATE ps_document SET id_document_type = '24', document_num = '122/A', document_date = '2025-10-13', document_letter = 'A', id_customer = '973', id_supplier = '', id_address = '4677360', address1 = 'VIA MUNICIPIO 83020 TORCHIATI-MONTORO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '257.91', price_tax_excluded = '257.91', date_upd = NOW() WHERE id_document = '99206' 27/10/2025 11:23: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 = '99206' 27/10/2025 11:23:21 am >> DELETE FROM ps_document_detail WHERE id_document = '99206' 27/10/2025 11:23: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 ( '99206' , '5457' , 'IO SONO CON VOI 1 PARTE' , '27' , '-27' , '4' , '2.8000' , '2.8' , '0' , '15' , '64.26' ) 27/10/2025 11:23: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 ( '99206' , '5446' , 'IO SONO CON VOI - GUIDA' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '15' , '20.40' ) 27/10/2025 11:23: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 ( '99206' , '5444' , 'IO SONO CON VOI - CAT.' , '16' , '-16' , '4' , '5.5000' , '5.5' , '0' , '0' , '88.00' ) 27/10/2025 11:23: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 ( '99206' , '5823' , 'LIBRO D\'ORO' , '20' , '-20' , '4' , '0.6000' , '0.6' , '0' , '0' , '12.00' ) 27/10/2025 11:23: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 ( '99206' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 27/10/2025 11:23: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 ( '99206' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 27/10/2025 11:23: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 ( '99206' , '23237' , 'MARIA ALLALBA DELLOTTAVO GIORNO' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 27/10/2025 11:23:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3534' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 11:23:41 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' , '3534' , '2025-10-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 27/10/2025 11:23:41 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 = '99505' 27/10/2025 11:23:41 am >> DELETE FROM ps_document_detail WHERE id_document = '99505' 27/10/2025 11:23:41 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 ( '99505' , '24188' , 'MA ANCHE NO - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 27/10/2025 11:37:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3535' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 11:37:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3535' , '2025-10-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '13.93' , NOW() , NOW() ) 27/10/2025 11:37:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99506' 27/10/2025 11:37:38 am >> DELETE FROM ps_document_detail WHERE id_document = '99506' 27/10/2025 11:37:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99506' , '13609' , 'APPENDICHIAVI 12X12 - RAQ' , '1' , '-1' , '1' , '15.90' , '13.032786885246' , '22' , '0' , '15.90' ) 27/10/2025 11:37:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99506' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1.1' , '0.9016393442623' , '22' , '0' , '1.10' ) 27/10/2025 11:43:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '713178' , '2025-10-23' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '10.87' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '369.65' , '369.65' , NOW() , NOW() ) 27/10/2025 11:43:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99507' 27/10/2025 11:43:44 am >> DELETE FROM ps_document_detail WHERE id_document = '99507' 27/10/2025 11:43:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99507' , '24188' , 'MA ANCHE NO - F. ROSINI' , '12' , '12' , '4' , '18.00' , '18' , '0' , '33' , '144.7200' ) 27/10/2025 11:43:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '24188' AND id_supplier = '7' 27/10/2025 11:43:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24188' , '7' , '1' ) 27/10/2025 11:43:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99507' , '24188' , 'MA ANCHE NO - F. ROSINI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '100' , '0.0000' ) 27/10/2025 11:43:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '24188' AND id_supplier = '7' 27/10/2025 11:43:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24188' , '7' , '1' ) 27/10/2025 11:43:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99507' , '9104' , 'ROSARIO E VEGLIA DI PREGHIERA PER I DEFUNTI - R. GOZZELINO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '35' , '3.2500' ) 27/10/2025 11:43:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '9104' AND id_supplier = '7' 27/10/2025 11:43:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9104' , '7' , '1' ) 27/10/2025 11:43:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99507' , '14955' , 'DARAI ALLA LUCE UN FIGLIO - NOVENA IMMACOLATA - G. FORLAI' , '2' , '2' , '4' , '2.90' , '2.9' , '0' , '33' , '3.8860' ) 27/10/2025 11:43:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '14955' AND id_supplier = '7' 27/10/2025 11:43:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14955' , '7' , '1' ) 27/10/2025 11:43:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99507' , '9086' , 'ROSARIO CON I DEFUNTI' , '1' , '1' , '4' , '3.00' , '3' , '0' , '30' , '2.1000' ) 27/10/2025 11:43:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '9086' AND id_supplier = '7' 27/10/2025 11:43:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9086' , '7' , '1' ) 27/10/2025 11:43:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99507' , '23405' , 'DIARIO SANTA FAUSTINA - N.E.' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 27/10/2025 11:43:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '23405' AND id_supplier = '7' 27/10/2025 11:43:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23405' , '7' , '1' ) 27/10/2025 11:43:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99507' , '21736' , 'NOVE GIORNI CON MARIA - M. GATTAFONI' , '3' , '3' , '4' , '2.00' , '2' , '0' , '30' , '4.2000' ) 27/10/2025 11:43:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '21736' AND id_supplier = '7' 27/10/2025 11:43:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21736' , '7' , '1' ) 27/10/2025 11:43:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99507' , '23989' , 'AMEN - NOV 25' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 27/10/2025 11:43:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '23989' AND id_supplier = '7' 27/10/2025 11:43:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23989' , '7' , '1' ) 27/10/2025 11:43:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99507' , '23988' , 'AMEN - DIC 25' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 27/10/2025 11:43:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '23988' AND id_supplier = '7' 27/10/2025 11:43:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23988' , '7' , '1' ) 27/10/2025 11:43:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99507' , '21591' , 'GESU VIENE AD ABITARE CON NOI - SCHEDE 1' , '40' , '40' , '4' , '6.90' , '6.9' , '0' , '30+7' , '179.6760' ) 27/10/2025 11:43:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '21591' AND id_supplier = '7' 27/10/2025 11:43:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21591' , '7' , '1' ) 27/10/2025 12:08:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '168' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 12:08: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 ( '21' , '168' , '2025-10-27' , '' , '4259' , '0' , '4679577' , 'VIALE CAMPO SPORTIVO 68 60044 FABRIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '121.18' , '121.18' , NOW() , NOW() ) 27/10/2025 12:08: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 = '99508' 27/10/2025 12:08:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '99508' 27/10/2025 12:08: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 ( '99508' , '11191' , 'VENITE CON ME 1 PARTE' , '11' , '-11' , '4' , '2.80' , '2.8' , '0' , '15' , '26.18' ) 27/10/2025 12:08: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 ( '99508' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '13' , '-13' , '4' , '3.00' , '3' , '0' , '5' , '37.05' ) 27/10/2025 12:08: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 ( '99508' , '1996' , 'CHIAMATA ANNO 4 - QUADERNO - L.A. LEPORATI' , '8' , '-8' , '4' , '4.50' , '4.5' , '0' , '5' , '34.20' ) 27/10/2025 12:08: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 ( '99508' , '10888' , 'PROGETTO DA SCOPRIRE GUIDA - L.A. LEPORATI' , '2' , '-2' , '4' , '9.00' , '9' , '0' , '5' , '17.10' ) 27/10/2025 12:08: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 ( '99508' , '10889' , 'PROGETTO DA SCOPRIRE 5 QUADERNO - L.A. LEPORATI' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '5' , '6.65' ) 27/10/2025 12:19:28 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1746' 27/10/2025 12:19:28 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 ( '1746' , '10' , '168' , 'PARROCCHIA SAN SILVIANO' , '' , '' , 'VIA SAN SILVIANO' , '' , '04019' , 'TERRACINA' , 'DON STANISLAO CHIM ' , '3397659332' , '' , '' , '91014960594' , NOW() , NOW() ) 27/10/2025 12:19:28 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1746' 27/10/2025 12:22:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '169' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 12:22:14 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' , '169' , '2025-10-27' , '' , '1746' , '0' , '4679599' , 'VIA SAN SILVIANO 04019 TERRACINA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '68.00' , '68.00' , NOW() , NOW() ) 27/10/2025 12:22:14 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 = '99509' 27/10/2025 12:22:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '99509' 27/10/2025 12:22:14 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 ( '99509' , '8408' , 'PRENDETE E MANGIATE' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '15' , '51.00' ) 27/10/2025 12:22:14 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 ( '99509' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 27/10/2025 12:22:14 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 ( '99509' , '4154' , 'FESTA DEL PERDONO' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '15' , '12.75' ) 27/10/2025 12:23:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '170' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 12:23:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '170' , '2025-10-27' , '' , '1923' , '0' , '4669431' , 'VIA APPIA ANTICA, 35 04019 TERRACINA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '34.75' , '34.75' , NOW() , NOW() ) 27/10/2025 12:23: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 = '99510' 27/10/2025 12:23:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '99510' 27/10/2025 12:23: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 ( '99510' , '8408' , 'PRENDETE E MANGIATE' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '15' , '25.50' ) 27/10/2025 12:23: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 ( '99510' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 27/10/2025 02:15:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8030913587253' AND id_product != '18172' AND ean13 != '' 27/10/2025 02:15:34 pm >> UPDATE ps_product SET id_supplier = '6', reference = '', ean13 = '8030913587253', date_upd = NOW() WHERE id_product = '18172' 27/10/2025 02:15:34 pm >> UPDATE ps_product_lang SET name = 'CONFEZIONE SCATOLA PORTA CIUCCIO', description = '' WHERE id_product = '18172' 27/10/2025 02:15:34 pm >> UPDATE ps_product SET wholesale_price = '9.00', on_sale = '0', price = '18.852459016393443' WHERE id_product = '18172' 27/10/2025 02:15:35 pm >> UPDATE ps_product_shop SET wholesale_price = '9.00', price = '18.852459016393443', id_tax_rules_group = '1', id_category_default = '120', 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 = '18172' 27/10/2025 02:15:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '18172' 27/10/2025 02:16:20 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' , 'FT 1/5566' , '2025-10-27' , '5566' , '0' , '6' , '2601' , 'ZONO ASI SUD - CENTRO ORAFO \\\"IL TARÍ\\\" 81025 MARCIANISE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '21.35' , '17.50' , NOW() , NOW() ) 27/10/2025 02:16: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 = '99511' 27/10/2025 02:16:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '99511' 27/10/2025 02:16: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 ( '99511' , '16793' , 'SOPRACULLA 9X13' , '1' , '1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '9.7600' ) 27/10/2025 02:16:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16793' AND id_supplier = '6' 27/10/2025 02:16:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16793' , '6' , '1' ) 27/10/2025 02:16: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 ( '99511' , '18172' , 'CONFEZIONE SCATOLA PORTA CIUCCIO' , '1' , '1' , '1' , '9.5' , '7.7868852459016' , '22' , '0' , '11.5900' ) 27/10/2025 02:16:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18172' AND id_supplier = '6' 27/10/2025 02:16:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18172' , '6' , '1' ) 27/10/2025 03:06:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400029246' AND id_product != '9688' AND ean13 != '' 27/10/2025 03:06:46 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2013', ean13 = '8058400029246', date_upd = NOW() WHERE id_product = '9688' 27/10/2025 03:06:46 pm >> UPDATE ps_product_lang SET name = 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ', description = '' WHERE id_product = '9688' 27/10/2025 03:06:46 pm >> UPDATE ps_product SET wholesale_price = '1.25', on_sale = '0', price = '2.459016393442623' WHERE id_product = '9688' 27/10/2025 03:06:46 pm >> UPDATE ps_product_shop SET wholesale_price = '1.25', price = '2.459016393442623', 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 = '9688' 27/10/2025 03:06:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '9688' 27/10/2025 03:07:26 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/10/2025 03:07:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24189' , '1' , '' , 'nuovo-prodotto' ) 27/10/2025 03:07:26 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24189' , '1' , '1' , '2' , NOW() , NOW() ) 27/10/2025 03:07:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24189' , '0' , '1' , '0' , '0' ) 27/10/2025 03:18:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000071' AND id_product != '24189' AND ean13 != '' 27/10/2025 03:18:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000071', date_upd = NOW() WHERE id_product = '24189' 27/10/2025 03:18:30 pm >> UPDATE ps_product_lang SET name = 'STATUA CM 20 - 4002', description = '' WHERE id_product = '24189' 27/10/2025 03:18:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.295081967213115' WHERE id_product = '24189' 27/10/2025 03:18:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.295081967213115', 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 = '24189' 27/10/2025 03:18:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '24189' 27/10/2025 03:18:31 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 = '24189' 27/10/2025 03:18:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24190' , '1' , '' , 'nuovo-prodotto' ) 27/10/2025 03:18:31 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 '24190' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24189' 27/10/2025 03:18:32 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24190' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24189' 27/10/2025 03:21:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000080' AND id_product != '24190' AND ean13 != '' 27/10/2025 03:21:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000080', date_upd = NOW() WHERE id_product = '24190' 27/10/2025 03:21:33 pm >> UPDATE ps_product_lang SET name = 'STATUA CM 20 - TONINO BELLO - 4032', description = '' WHERE id_product = '24190' 27/10/2025 03:21:33 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.0327868852459' WHERE id_product = '24190' 27/10/2025 03:21:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.0327868852459', 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 = '24190' 27/10/2025 03:21:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '24190' 27/10/2025 03:25:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000080' AND id_product != '24190' AND ean13 != '' 27/10/2025 03:25:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000080', date_upd = NOW() WHERE id_product = '24190' 27/10/2025 03:25:19 pm >> UPDATE ps_product_lang SET name = 'STATUA CM 20 - TONINO BELLO - 4032', description = '' WHERE id_product = '24190' 27/10/2025 03:25:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.0327868852459' WHERE id_product = '24190' 27/10/2025 03:25:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.0327868852459', 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 = '24190' 27/10/2025 03:25:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '24190' 27/10/2025 03:25:20 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 = '24190' 27/10/2025 03:25:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24191' , '1' , '' , 'nuovo-prodotto' ) 27/10/2025 03:25:20 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 '24191' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24190' 27/10/2025 03:25:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24191' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24190' 27/10/2025 03:26:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000234' AND id_product != '24191' AND ean13 != '' 27/10/2025 03:26:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000234', date_upd = NOW() WHERE id_product = '24191' 27/10/2025 03:26:00 pm >> UPDATE ps_product_lang SET name = 'STATUA CM 15 - 4025', description = '' WHERE id_product = '24191' 27/10/2025 03:26:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.19672131147541' WHERE id_product = '24191' 27/10/2025 03:26:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.19672131147541', 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 = '24191' 27/10/2025 03:26:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '24191' 27/10/2025 03:26:01 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 = '24191' 27/10/2025 03:26:01 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24192' , '1' , '' , 'nuovo-prodotto' ) 27/10/2025 03:26:01 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 '24192' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24191' 27/10/2025 03:26:01 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24192' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24191' 27/10/2025 03:30:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3536' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 03:30: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 ( '11' , '3536' , '2025-10-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.50' , '34.51' , NOW() , NOW() ) 27/10/2025 03:30: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 = '99512' 27/10/2025 03:30:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '99512' 27/10/2025 03:30: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 ( '99512' , '20514' , 'ROSARIO S. BENEDETTO - 175/OV3' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 27/10/2025 03:30: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 ( '99512' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.70' , '0.7' , '0' , '0' , '24.50' ) 27/10/2025 03:30: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 ( '99512' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 27/10/2025 03:34:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000254' AND id_product != '24192' AND ean13 != '' 27/10/2025 03:34:06 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000254', date_upd = NOW() WHERE id_product = '24192' 27/10/2025 03:34:06 pm >> UPDATE ps_product_lang SET name = 'STATUA CM 13 - 4011', description = '' WHERE id_product = '24192' 27/10/2025 03:34:06 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.655737704918034' WHERE id_product = '24192' 27/10/2025 03:34:06 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.655737704918034', 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 = '24192' 27/10/2025 03:34:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '24192' 27/10/2025 03:40:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000254' AND id_product != '24192' AND ean13 != '' 27/10/2025 03:40:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000254', date_upd = NOW() WHERE id_product = '24192' 27/10/2025 03:40:48 pm >> UPDATE ps_product_lang SET name = 'STATUA CM 13 - 4011', description = '' WHERE id_product = '24192' 27/10/2025 03:40:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.655737704918034' WHERE id_product = '24192' 27/10/2025 03:40:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.655737704918034', 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 = '24192' 27/10/2025 03:40:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '24192' 27/10/2025 03:40:48 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 = '24192' 27/10/2025 03:40:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24193' , '1' , '' , 'nuovo-prodotto' ) 27/10/2025 03:40:48 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 '24193' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24192' 27/10/2025 03:40:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24193' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24192' 27/10/2025 03:42:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400314175' AND id_product != '24193' AND ean13 != '' 27/10/2025 03:42:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400314175', date_upd = NOW() WHERE id_product = '24193' 27/10/2025 03:42:10 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' 21X25 - P802', description = '' WHERE id_product = '24193' 27/10/2025 03:42:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '51.63934426229508' WHERE id_product = '24193' 27/10/2025 03:42:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '51.63934426229508', 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 = '24193' 27/10/2025 03:42:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '24193' 27/10/2025 03:42:11 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 = '24193' 27/10/2025 03:42:11 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24194' , '1' , '' , 'nuovo-prodotto' ) 27/10/2025 03:42:11 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 '24194' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24193' 27/10/2025 03:42:11 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24194' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24193' 27/10/2025 03:44:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400074314' AND id_product != '24194' AND ean13 != '' 27/10/2025 03:44:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400074314', date_upd = NOW() WHERE id_product = '24194' 27/10/2025 03:44:51 pm >> UPDATE ps_product_lang SET name = 'PRESEPE NATIVITA\' - P780', description = '' WHERE id_product = '24194' 27/10/2025 03:44:51 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.524590163934427' WHERE id_product = '24194' 27/10/2025 03:44:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.524590163934427', 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 = '24194' 27/10/2025 03:44:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '24194' 27/10/2025 03:44:52 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 = '24194' 27/10/2025 03:44:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24195' , '1' , '' , 'nuovo-prodotto' ) 27/10/2025 03:44:52 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 '24195' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24194' 27/10/2025 03:44:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24195' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24194' 27/10/2025 03:47: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 ( '31' , 'A4167' , '2025-10-27' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '316.74' , '259.62' , NOW() , NOW() ) 27/10/2025 03:47: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 = '99513' 27/10/2025 03:47:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '99513' 27/10/2025 03:47: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 ( '99513' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '100' , '100' , '1' , '1.25' , '1.0245901639344' , '22' , '0' , '152.5000' ) 27/10/2025 03:47:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9688' AND id_supplier = '28' 27/10/2025 03:47:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9688' , '28' , '1' ) 27/10/2025 03:47: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 ( '99513' , '24189' , 'STATUA CM 20 - 4002' , '3' , '3' , '1' , '5.59' , '4.5819672131148' , '22' , '0' , '20.4594' ) 27/10/2025 03:47:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24189' AND id_supplier = '28' 27/10/2025 03:47:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24189' , '28' , '1' ) 27/10/2025 03:47: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 ( '99513' , '24190' , 'STATUA CM 20 - TONINO BELLO - 4032' , '1' , '1' , '1' , '8.6' , '7.0491803278689' , '22' , '0' , '10.4920' ) 27/10/2025 03:47:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24190' AND id_supplier = '28' 27/10/2025 03:47:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24190' , '28' , '1' ) 27/10/2025 03:47: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 ( '99513' , '24191' , 'STATUA CM 15 - 4025' , '8' , '8' , '1' , '3.73' , '3.0573770491803' , '22' , '0' , '36.4048' ) 27/10/2025 03:47:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24191' AND id_supplier = '28' 27/10/2025 03:47:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24191' , '28' , '1' ) 27/10/2025 03:47: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 ( '99513' , '24192' , 'STATUA CM 13 - 4011' , '1' , '1' , '1' , '4.95' , '4.0573770491803' , '22' , '0' , '6.0390' ) 27/10/2025 03:47:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24192' AND id_supplier = '28' 27/10/2025 03:47:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24192' , '28' , '1' ) 27/10/2025 03:47: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 ( '99513' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '1' , '1' , '9.06' , '7.4262295081967' , '22' , '0' , '11.0532' ) 27/10/2025 03:47:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21561' AND id_supplier = '28' 27/10/2025 03:47:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21561' , '28' , '1' ) 27/10/2025 03:47: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 ( '99513' , '24193' , 'NATIVITA 21X25 - P802' , '1' , '1' , '1' , '24.2' , '19.83606557377' , '22' , '0' , '29.5240' ) 27/10/2025 03:47:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24193' AND id_supplier = '28' 27/10/2025 03:47:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24193' , '28' , '1' ) 27/10/2025 03:47: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 ( '99513' , '24194' , 'PRESEPE NATIVITA - P780' , '3' , '3' , '1' , '6.4' , '5.2459016393443' , '22' , '0' , '23.4240' ) 27/10/2025 03:47:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24194' AND id_supplier = '28' 27/10/2025 03:47:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24194' , '28' , '1' ) 27/10/2025 03:47: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 ( '99513' , '17563' , 'PRESEPE TERRACOTTA - P288' , '1' , '1' , '1' , '11' , '9.016393442623' , '22' , '0' , '13.4200' ) 27/10/2025 03:47:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17563' AND id_supplier = '28' 27/10/2025 03:47:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17563' , '28' , '1' ) 27/10/2025 03:47: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 ( '99513' , '17562' , 'PRESEPE TERRACOTTA - P287' , '1' , '1' , '1' , '11' , '9.016393442623' , '22' , '0' , '13.4200' ) 27/10/2025 03:47:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17562' AND id_supplier = '28' 27/10/2025 03:47:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17562' , '28' , '1' ) 27/10/2025 04:55:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3537' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 04:55:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3537' , '2025-10-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 27/10/2025 04:55: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 = '99514' 27/10/2025 04:55:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '99514' 27/10/2025 04:55: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 ( '99514' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 27/10/2025 05:18:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3538' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 05:18:40 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' , '3538' , '2025-10-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.50' , NOW() , NOW() ) 27/10/2025 05:18: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 = '99515' 27/10/2025 05:18:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '99515' 27/10/2025 05:18: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 ( '99515' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 27/10/2025 05:21:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3539' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 05:21:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3539' , '2025-10-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 27/10/2025 05:21:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99516' 27/10/2025 05:21:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '99516' 27/10/2025 05:21:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99516' , '11272' , 'VETRO ROSSO RUBINO - VKINGS' , '1' , '-1' , '1' , '16.50' , '13.524590163934' , '22' , '0' , '16.50' ) 27/10/2025 05:21:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99516' , '16834' , 'LITURGICO CARTA 8GG' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 27/10/2025 07:10:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3540' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 07:10:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3540' , '2025-10-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 27/10/2025 07:10: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 = '99517' 27/10/2025 07:10:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '99517' 27/10/2025 07:10: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 ( '99517' , '24191' , 'STATUA CM 15 - 4025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/10/2025 07:34:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3541' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-27') 27/10/2025 07:34:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3541' , '2025-10-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.00' , '72.00' , NOW() , NOW() ) 27/10/2025 07:34:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99518' 27/10/2025 07:34:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '99518' 27/10/2025 07:34: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 ( '99518' , '24144' , 'LIBERI NELLA VERITA - M. DE MAIO' , '2' , '-2' , '4' , '36.00' , '36' , '0' , '0' , '72.00' )