31/03/2025 08:38:53 am >> SELECT document_num FROM ps_document WHERE document_num = '63/A' AND id_document != '96417' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-29') 31/03/2025 08:38:53 am >> UPDATE ps_document SET id_document_type = '24', document_num = '63/A', document_date = '2025-03-29', document_letter = 'A', id_customer = '189', id_supplier = '', id_address = '4679063', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', 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 = '515.84', price_tax_excluded = '515.84', date_upd = NOW() WHERE id_document = '96417' 31/03/2025 08:38:53 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 = '96417' 31/03/2025 08:38:53 am >> DELETE FROM ps_document_detail WHERE id_document = '96417' 31/03/2025 08:38:53 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 ( '96417' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '560' , '-560' , '4' , '1.0000' , '1' , '0' , '38' , '347.20' ) 31/03/2025 08:38:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96417' , '15019' , 'PREGHIAMO CON MARIA' , '340' , '-340' , '4' , '0.8000' , '0.8' , '0' , '38' , '168.64' ) 31/03/2025 09:30:58 am >> SELECT document_num FROM ps_document WHERE document_num = '843' AND id_document != '96197' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-12') 31/03/2025 09:30:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '843', document_date = '2025-03-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '90.00', price_tax_excluded = '78.22', date_upd = NOW() WHERE id_document = '96197' 31/03/2025 09:30:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96197' 31/03/2025 09:30:58 am >> DELETE FROM ps_document_detail WHERE id_document = '96197' 31/03/2025 09:30:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96197' , '5538' , 'LACCIO MARRONE' , '6' , '-6' , '1' , '0.05' , '0.040983606557377' , '22' , '0' , '0.30' ) 31/03/2025 09:30:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96197' , '22957' , 'DON DOLINDO RUOTOLO, SANTA FAUSTINA - M. STANZIONE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '5' , '10.45' ) 31/03/2025 09:30:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96197' , '22413' , 'VITA DI SAN GIUSEPPE - 8653' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 31/03/2025 09:30:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96197' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 31/03/2025 09:35:27 am >> SELECT document_num FROM ps_document WHERE document_num = '1018' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 09:35: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' , '1018' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.98' , '27.98' , NOW() , NOW() ) 31/03/2025 09:35: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 = '96418' 31/03/2025 09:35:28 am >> DELETE FROM ps_document_detail WHERE id_document = '96418' 31/03/2025 09:36:09 am >> DELETE FROM ps_document WHERE id_document = '96418' 31/03/2025 09:36:09 am >> DELETE FROM ps_document_detail WHERE id_document = '96418' 31/03/2025 09:36:59 am >> SELECT document_num FROM ps_document WHERE document_num = '1018' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 09:36:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1018' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.98' , '27.98' , NOW() , NOW() ) 31/03/2025 09:36:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96419' 31/03/2025 09:36:59 am >> DELETE FROM ps_document_detail WHERE id_document = '96419' 31/03/2025 09:36:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96419' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 31/03/2025 09:36:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96419' , '23493' , 'PAROLA E PREGHIERA - MAG 25' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 31/03/2025 09:36:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96419' , '23459' , 'PAROLA E PREGHIERA - APR 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 31/03/2025 09:36:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96419' , '23587' , 'PAROLA E PREGHIERA - GIU 25' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 31/03/2025 09:36:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96419' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 31/03/2025 09:44:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '264 MTP AVOR' AND id_product != '12740' AND ean13 != '' 31/03/2025 09:44:37 am >> UPDATE ps_product SET id_supplier = '89', reference = '', ean13 = '264 MTP AVOR', date_upd = NOW() WHERE id_product = '12740' 31/03/2025 09:44:37 am >> UPDATE ps_product_lang SET name = 'STOLA DIACONALE MARIANA - 264/MTP', description = '' WHERE id_product = '12740' 31/03/2025 09:44:37 am >> UPDATE ps_product SET wholesale_price = '37.40', on_sale = '0', price = '75.40983606557377' WHERE id_product = '12740' 31/03/2025 09:44:37 am >> UPDATE ps_product_shop SET wholesale_price = '37.40', price = '75.40983606557377', id_tax_rules_group = '1', id_category_default = '396', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12740' 31/03/2025 09:44:37 am >> DELETE FROM ps_specific_price WHERE id_product = '12740' 31/03/2025 09:48:31 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/03/2025 09:48:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23612' , '1' , '' , 'nuovo-prodotto' ) 31/03/2025 09:48:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23612' , '1' , '1' , '2' , NOW() , NOW() ) 31/03/2025 09:48:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23612' , '0' , '1' , '0' , '0' ) 31/03/2025 09:48:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '3564 tp avor' AND id_product != '12748' AND ean13 != '' 31/03/2025 09:48:44 am >> UPDATE ps_product SET id_supplier = '89', reference = '', ean13 = '3564 tp avor', date_upd = NOW() WHERE id_product = '12748' 31/03/2025 09:48:44 am >> UPDATE ps_product_lang SET name = 'DALMATICA MARIANA - 3564/TP', description = '' WHERE id_product = '12748' 31/03/2025 09:48:44 am >> UPDATE ps_product SET wholesale_price = '47.30', on_sale = '0', price = '94.2623' WHERE id_product = '12748' 31/03/2025 09:48:44 am >> UPDATE ps_product_shop SET wholesale_price = '47.30', price = '94.2623', id_tax_rules_group = '1', id_category_default = '396', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12748' 31/03/2025 09:48:44 am >> DELETE FROM ps_specific_price WHERE id_product = '12748' 31/03/2025 09:52:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '431 tpr 160' AND id_product != '23612' AND ean13 != '' 31/03/2025 09:52:20 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '431 tpr 160', date_upd = NOW() WHERE id_product = '23612' 31/03/2025 09:52:20 am >> UPDATE ps_product_lang SET name = 'CAMICE TALARE ROSSA - 431TPR', description = '' WHERE id_product = '23612' 31/03/2025 09:52:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '89.75409836065575' WHERE id_product = '23612' 31/03/2025 09:52:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '89.75409836065575', id_tax_rules_group = '1', id_category_default = '396', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23612' 31/03/2025 09:52:20 am >> DELETE FROM ps_specific_price WHERE id_product = '23612' 31/03/2025 09:52:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '174' , '2025-03-26' , '' , '0' , '89' , '2729' , 'VIA COLLE DI NAVA, 127D 12060 MAGLIANO ALPI' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '210.57' , '172.60' , NOW() , NOW() ) 31/03/2025 09:52:49 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 = '96420' 31/03/2025 09:52:49 am >> DELETE FROM ps_document_detail WHERE id_document = '96420' 31/03/2025 09:52:49 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 ( '96420' , '12740' , 'STOLA DIACONALE MARIANA - 264/MTP' , '1' , '1' , '1' , '37.4' , '30.655737704918' , '22' , '0' , '45.6280' ) 31/03/2025 09:52:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '12740' AND id_supplier = '89' 31/03/2025 09:52:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12740' , '89' , '1' ) 31/03/2025 09:52:49 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 ( '96420' , '12742' , 'COPRILEGGIO - 310/TP' , '1' , '1' , '1' , '31' , '25.409836065574' , '22' , '0' , '37.8200' ) 31/03/2025 09:52:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '12742' AND id_supplier = '89' 31/03/2025 09:52:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12742' , '89' , '1' ) 31/03/2025 09:52:50 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 ( '96420' , '12748' , 'DALMATICA MARIANA - 3564/TP' , '1' , '1' , '1' , '47.3' , '38.770491803279' , '22' , '0' , '57.7060' ) 31/03/2025 09:52:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '12748' AND id_supplier = '89' 31/03/2025 09:52:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12748' , '89' , '1' ) 31/03/2025 09:52:50 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 ( '96420' , '23612' , 'CAMICE TALARE ROSSA - 431TPR' , '1' , '1' , '1' , '44.9' , '36.803278688525' , '22' , '0' , '54.7780' ) 31/03/2025 09:52:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '23612' AND id_supplier = '89' 31/03/2025 09:52:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23612' , '89' , '1' ) 31/03/2025 10:01:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1019' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 10:01:35 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' , '1019' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '52.88' , NOW() , NOW() ) 31/03/2025 10:01: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 = '96421' 31/03/2025 10:01:35 am >> DELETE FROM ps_document_detail WHERE id_document = '96421' 31/03/2025 10:01: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 ( '96421' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 31/03/2025 10:01: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 ( '96421' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 31/03/2025 11:42:47 am >> SELECT document_num FROM ps_document WHERE document_num = '11/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 11:42: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 ( '23' , '11/E' , '2025-03-31' , 'E' , '189' , '0' , '4679063' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '515.84' , '515.84' , NOW() , NOW() ) 31/03/2025 11:42: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 = '96422' 31/03/2025 11:42:47 am >> DELETE FROM ps_document_detail WHERE id_document = '96422' 31/03/2025 11:42: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 ( '96422' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '560' , '-560' , '4' , '1.0000' , '1' , '0' , '38' , '347.20' ) 31/03/2025 11:42: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 ( '96422' , '15019' , 'PREGHIAMO CON MARIA' , '340' , '-340' , '4' , '0.8000' , '0.8' , '0' , '38' , '168.64' ) 31/03/2025 11:43:08 am >> DELETE FROM ps_document WHERE id_document = '96417' 31/03/2025 11:43:08 am >> DELETE FROM ps_document_detail WHERE id_document = '96417' 31/03/2025 11:55:23 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/03/2025 11:55:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23613' , '1' , '' , 'nuovo-prodotto' ) 31/03/2025 11:55:23 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23613' , '1' , '1' , '2' , NOW() , NOW() ) 31/03/2025 11:55:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23613' , '0' , '1' , '0' , '0' ) 31/03/2025 11:56:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118321237' AND id_product != '23613' AND ean13 != '' 31/03/2025 11:56:22 am >> UPDATE ps_product SET id_supplier = '', reference = '1/6', ean13 = '8019118321237', date_upd = NOW() WHERE id_product = '23613' 31/03/2025 11:56:22 am >> UPDATE ps_product_lang SET name = 'TESTIMONI DI SPERANZA - SPARTITO', description = '' WHERE id_product = '23613' 31/03/2025 11:56:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.096153846153843' WHERE id_product = '23613' 31/03/2025 11:56:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.096153846153843', id_tax_rules_group = '3', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23613' 31/03/2025 11:56:23 am >> DELETE FROM ps_specific_price WHERE id_product = '23613' 31/03/2025 11:57:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839918680' AND id_product != '8416' AND ean13 != '' 31/03/2025 11:57:55 am >> UPDATE ps_product SET id_supplier = '7', reference = '7/7', ean13 = '9788839918680', date_upd = NOW() WHERE id_product = '8416' 31/03/2025 11:57:55 am >> UPDATE ps_product_lang SET name = 'PREPARARE E CELEBRARE - TRIDUO PASQUALE', description = '' WHERE id_product = '8416' 31/03/2025 11:57:55 am >> UPDATE ps_product SET wholesale_price = '16.80', on_sale = '0', price = '25' WHERE id_product = '8416' 31/03/2025 11:57:55 am >> UPDATE ps_product_shop SET wholesale_price = '16.80', price = '25', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8416' 31/03/2025 11:57:55 am >> DELETE FROM ps_specific_price WHERE id_product = '8416' 31/03/2025 11:59:29 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' , '693950' , '2025-03-28' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.03' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '108.02' , '106.89' , NOW() , NOW() ) 31/03/2025 11:59:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96423' 31/03/2025 11:59:29 am >> DELETE FROM ps_document_detail WHERE id_document = '96423' 31/03/2025 11:59:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96423' , '23613' , 'TESTIMONI DI SPERANZA - SPARTITO' , '2' , '2' , '3' , '20.09' , '19.317307692308' , '4' , '30' , '29.2510' ) 31/03/2025 11:59:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '23613' AND id_supplier = '7' 31/03/2025 11:59:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23613' , '7' , '1' ) 31/03/2025 11:59:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96423' , '23541' , 'PREGHIERE DI SPERANZA E GUARIGIONE - A. RAMINA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '30' , '5.6000' ) 31/03/2025 11:59:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '23541' AND id_supplier = '7' 31/03/2025 11:59:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23541' , '7' , '1' ) 31/03/2025 11:59:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96423' , '23445' , 'PAROLE DI GESU IN CROCE - POPPI/ LA PERA' , '1' , '1' , '4' , '17.50' , '17.5' , '0' , '30' , '12.2500' ) 31/03/2025 11:59:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '23445' AND id_supplier = '7' 31/03/2025 11:59:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23445' , '7' , '1' ) 31/03/2025 11:59:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96423' , '18710' , 'SERVIRE A MESSA ' , '1' , '1' , '4' , '6.00' , '6' , '0' , '33' , '4.0200' ) 31/03/2025 11:59:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '18710' AND id_supplier = '7' 31/03/2025 11:59:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18710' , '7' , '1' ) 31/03/2025 11:59:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96423' , '8416' , 'PREPARARE E CELEBRARE - TRIDUO PASQUALE' , '1' , '1' , '4' , '25.00' , '25' , '0' , '30' , '17.5000' ) 31/03/2025 11:59:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '8416' AND id_supplier = '7' 31/03/2025 11:59:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8416' , '7' , '1' ) 31/03/2025 11:59:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96423' , '21541' , 'OMELIE SUI SANTI - A. COMASTRI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 31/03/2025 11:59:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '21541' AND id_supplier = '7' 31/03/2025 11:59:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21541' , '7' , '1' ) 31/03/2025 11:59:30 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 ( '96423' , '18163' , 'GIOCO DELLE PAROLE DI DIO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 31/03/2025 11:59:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '18163' AND id_supplier = '7' 31/03/2025 11:59:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18163' , '7' , '1' ) 31/03/2025 11:59:30 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 ( '96423' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 31/03/2025 11:59:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '17001' AND id_supplier = '7' 31/03/2025 11:59:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17001' , '7' , '1' ) 31/03/2025 11:59:30 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 ( '96423' , '23279' , 'AMEN - APR 25' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 31/03/2025 11:59:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '23279' AND id_supplier = '7' 31/03/2025 11:59:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23279' , '7' , '1' ) 31/03/2025 11:59:30 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 ( '96423' , '23575' , 'MEMORIA DEL CUORE' , '1' , '1' , '4' , '3.00' , '3' , '0' , '30' , '2.1000' ) 31/03/2025 11:59:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '23575' AND id_supplier = '7' 31/03/2025 11:59:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23575' , '7' , '1' ) 31/03/2025 12:12:42 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/03/2025 12:12:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23614' , '1' , '' , 'nuovo-prodotto' ) 31/03/2025 12:12:42 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23614' , '1' , '1' , '2' , NOW() , NOW() ) 31/03/2025 12:12:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23614' , '0' , '1' , '0' , '0' ) 31/03/2025 12:19:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1020' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 12:19:33 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' , '1020' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '8.10' , NOW() , NOW() ) 31/03/2025 12:19:33 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 = '96424' 31/03/2025 12:19:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '96424' 31/03/2025 12:19:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96424' , '11151' , 'LIBRI' , '15' , '-15' , '4' , '0.25' , '0.25' , '0' , '0' , '3.75' ) 31/03/2025 12:19:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96424' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '0.45' , '0.45' , '0' , '0' , '0.45' ) 31/03/2025 12:19:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96424' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' , '0.70' , '0.7' , '0' , '0' , '2.10' ) 31/03/2025 12:19:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96424' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 31/03/2025 12:19:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96424' , '20758' , 'SEGNALIBRO 5X15' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 31/03/2025 12:30:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'B256/FE' AND id_product != '18586' AND ean13 != '' 31/03/2025 12:30:32 pm >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = 'B256/FE', date_upd = NOW() WHERE id_product = '18586' 31/03/2025 12:30:32 pm >> UPDATE ps_product_lang SET name = 'FERMAGLIO - B256/FE', description = '' WHERE id_product = '18586' 31/03/2025 12:30:33 pm >> UPDATE ps_product SET wholesale_price = '5.34', on_sale = '0', price = '14.344262295081968' WHERE id_product = '18586' 31/03/2025 12:30:33 pm >> UPDATE ps_product_shop SET wholesale_price = '5.34', price = '14.344262295081968', id_tax_rules_group = '1', id_category_default = '411', 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 = '18586' 31/03/2025 12:30:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '18586' 31/03/2025 12:32:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'B314/FE' AND id_product != '23614' AND ean13 != '' 31/03/2025 12:32:31 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'B314/FE', date_upd = NOW() WHERE id_product = '23614' 31/03/2025 12:32:31 pm >> UPDATE ps_product_lang SET name = 'FERMAGLIO - B314/FE', description = '' WHERE id_product = '23614' 31/03/2025 12:32:31 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.704918032786885' WHERE id_product = '23614' 31/03/2025 12:32:31 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.704918032786885', id_tax_rules_group = '1', id_category_default = '411', 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 = '23614' 31/03/2025 12:32:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '23614' 31/03/2025 12:33:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'B314/FE' AND id_product != '23614' AND ean13 != '' 31/03/2025 12:33:26 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'B314/FE', date_upd = NOW() WHERE id_product = '23614' 31/03/2025 12:33:26 pm >> UPDATE ps_product_lang SET name = 'FERMAGLIO - B314/FE', description = '' WHERE id_product = '23614' 31/03/2025 12:33:26 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.704918032786885' WHERE id_product = '23614' 31/03/2025 12:33:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.704918032786885', id_tax_rules_group = '1', id_category_default = '411', 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 = '23614' 31/03/2025 12:33:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '23614' 31/03/2025 12:33:27 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 = '23614' 31/03/2025 12:33:27 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23615' , '1' , '' , 'nuovo-prodotto' ) 31/03/2025 12:33:27 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23615' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23614' 31/03/2025 12:33:27 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23615' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23614' 31/03/2025 12:33:41 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 = '23614' 31/03/2025 12:33:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23616' , '1' , '' , 'nuovo-prodotto' ) 31/03/2025 12:33:41 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 '23616' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23614' 31/03/2025 12:33:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23616' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23614' 31/03/2025 12:47:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002363' AND id_product != '23616' AND ean13 != '' 31/03/2025 12:47:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002364' AND id_product != '23616' AND ean13 != '' 31/03/2025 12:47:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002364', date_upd = NOW() WHERE id_product = '23616' 31/03/2025 12:47:37 pm >> UPDATE ps_product_lang SET name = 'PIZZO MACRAME\' SACRO CUORE - P537', description = '' WHERE id_product = '23616' 31/03/2025 12:47:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '51.63934426229508' WHERE id_product = '23616' 31/03/2025 12:47:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '51.63934426229508', id_tax_rules_group = '1', id_category_default = '411', 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 = '23616' 31/03/2025 12:47:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '23616' 31/03/2025 12:48:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002364' AND id_product != '23616' AND ean13 != '' 31/03/2025 12:48:06 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002364', date_upd = NOW() WHERE id_product = '23616' 31/03/2025 12:48:06 pm >> UPDATE ps_product_lang SET name = 'PIZZO MACRAME\' SACRO CUORE - P537', description = '' WHERE id_product = '23616' 31/03/2025 12:48:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '51.63934426229508' WHERE id_product = '23616' 31/03/2025 12:48:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '51.63934426229508', id_tax_rules_group = '1', id_category_default = '411', 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 = '23616' 31/03/2025 12:48:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '23616' 31/03/2025 12:49:08 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/03/2025 12:49:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23617' , '1' , '' , 'nuovo-prodotto' ) 31/03/2025 12:49:08 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23617' , '1' , '1' , '2' , NOW() , NOW() ) 31/03/2025 12:49:08 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23617' , '0' , '1' , '0' , '0' ) 31/03/2025 12:50:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002365' AND id_product != '23617' AND ean13 != '' 31/03/2025 12:50:04 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002365', date_upd = NOW() WHERE id_product = '23617' 31/03/2025 12:50:04 pm >> UPDATE ps_product_lang SET name = 'BORDO MACRAME\' PUNTINA - P400', description = '' WHERE id_product = '23617' 31/03/2025 12:50:04 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.6557377049180335' WHERE id_product = '23617' 31/03/2025 12:50:04 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.6557377049180335', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23617' 31/03/2025 12:50:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '23617' 31/03/2025 12:50:14 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 = '23617' 31/03/2025 12:50:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23618' , '1' , '' , 'nuovo-prodotto' ) 31/03/2025 12:50:14 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 '23618' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23617' 31/03/2025 12:50:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23618' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23617' 31/03/2025 12:50:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002366' AND id_product != '23618' AND ean13 != '' 31/03/2025 12:50:48 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002366', date_upd = NOW() WHERE id_product = '23618' 31/03/2025 12:50:48 pm >> UPDATE ps_product_lang SET name = 'GALLONE ORO - GA-P06', description = '' WHERE id_product = '23618' 31/03/2025 12:50:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.01639344262295' WHERE id_product = '23618' 31/03/2025 12:50:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.01639344262295', id_tax_rules_group = '1', id_category_default = '411', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23618' 31/03/2025 12:50:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '23618' 31/03/2025 12:50:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002366' AND id_product != '23618' AND ean13 != '' 31/03/2025 12:50:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002366', date_upd = NOW() WHERE id_product = '23618' 31/03/2025 12:50:53 pm >> UPDATE ps_product_lang SET name = 'GALLONE ORO - GA-P06', description = '' WHERE id_product = '23618' 31/03/2025 12:50:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.01639344262295' WHERE id_product = '23618' 31/03/2025 12:50:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.01639344262295', id_tax_rules_group = '1', id_category_default = '411', 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 = '23618' 31/03/2025 12:50:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '23618' 31/03/2025 12:51:31 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/03/2025 12:51:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23619' , '1' , '' , 'nuovo-prodotto' ) 31/03/2025 12:51:31 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23619' , '1' , '1' , '2' , NOW() , NOW() ) 31/03/2025 12:51:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23619' , '0' , '1' , '0' , '0' ) 31/03/2025 12:52:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002367' AND id_product != '23619' AND ean13 != '' 31/03/2025 12:52:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002367', date_upd = NOW() WHERE id_product = '23619' 31/03/2025 12:52:21 pm >> UPDATE ps_product_lang SET name = 'COTTA MISTO SETA - COTTA18', description = '' WHERE id_product = '23619' 31/03/2025 12:52:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '409.8360655737705' WHERE id_product = '23619' 31/03/2025 12:52:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '409.8360655737705', id_tax_rules_group = '1', id_category_default = '411', 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 = '23619' 31/03/2025 12:52:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '23619' 31/03/2025 12:52:22 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 = '23619' 31/03/2025 12:52:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23620' , '1' , '' , 'nuovo-prodotto' ) 31/03/2025 12:52:22 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 '23620' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23619' 31/03/2025 12:52:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23620' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23619' 31/03/2025 12:53:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002368' AND id_product != '23620' AND ean13 != '' 31/03/2025 12:53:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002368', date_upd = NOW() WHERE id_product = '23620' 31/03/2025 12:53:52 pm >> UPDATE ps_product_lang SET name = 'CAMICE AVORIO GIGLIUCCIO - 19/3 PL', description = '' WHERE id_product = '23620' 31/03/2025 12:53:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '192.62295081967213' WHERE id_product = '23620' 31/03/2025 12:53:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '192.62295081967213', id_tax_rules_group = '1', id_category_default = '411', 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 = '23620' 31/03/2025 12:53:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '23620' 31/03/2025 12:57:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '0' , '2025-03-31' , '' , '0' , '95' , '2757' , 'VIA A. POLENGHI, 97 26845 CODOGNO' , '' , 'INS NUMERO' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1582.24' , '1296.92' , NOW() , NOW() ) 31/03/2025 12:57:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96425' 31/03/2025 12:57:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '96425' 31/03/2025 12:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96425' , '23619' , 'COTTA MISTO SETA - COTTA18' , '1' , '1' , '1' , '205' , '168.03278688525' , '22' , '3' , '242.5970' ) 31/03/2025 12:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23619' AND id_supplier = '95' 31/03/2025 12:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23619' , '95' , '1' ) 31/03/2025 12:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96425' , '23620' , 'CAMICE AVORIO GIGLIUCCIO - 19/3 PL' , '2' , '2' , '1' , '95' , '77.868852459016' , '22' , '3' , '224.8460' ) 31/03/2025 12:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23620' AND id_supplier = '95' 31/03/2025 12:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23620' , '95' , '1' ) 31/03/2025 12:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96425' , '16456' , 'CINGOLO - CING03' , '10' , '10' , '1' , '5.9' , '4.8360655737705' , '22' , '3' , '69.8206' ) 31/03/2025 12:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16456' AND id_supplier = '95' 31/03/2025 12:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16456' , '95' , '1' ) 31/03/2025 12:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96425' , '23617' , 'BORDO MACRAME\' PUNTINA - P400' , '13.9' , '13.9' , '1' , '2.74' , '2.2459016393443' , '22' , '3' , '45.0710' ) 31/03/2025 12:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23617' AND id_supplier = '95' 31/03/2025 12:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23617' , '95' , '1' ) 31/03/2025 12:57:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96425' , '23614' , 'FERMAGLIO - B314/FE' , '6' , '6' , '1' , '6.35' , '5.2049180327869' , '22' , '3' , '45.0875' ) 31/03/2025 12:57:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23614' AND id_supplier = '95' 31/03/2025 12:57:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23614' , '95' , '1' ) 31/03/2025 12:57:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96425' , '18586' , 'FERMAGLIO - B256/FE' , '6' , '6' , '1' , '7.09' , '5.8114754098361' , '22' , '3' , '50.3418' ) 31/03/2025 12:57:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18586' AND id_supplier = '95' 31/03/2025 12:57:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18586' , '95' , '1' ) 31/03/2025 12:57:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96425' , '23618' , 'GALLONE ORO - GA-P06' , '25' , '25' , '1' , '4.5' , '3.6885245901639' , '22' , '3' , '133.1325' ) 31/03/2025 12:57:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23618' AND id_supplier = '95' 31/03/2025 12:57:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23618' , '95' , '1' ) 31/03/2025 12:57:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96425' , '16276' , 'PIZZO SU RASO MARIANO - P439' , '13.5' , '13.5' , '1' , '21.63' , '17.729508196721' , '22' , '3' , '345.5587' ) 31/03/2025 12:57:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16276' AND id_supplier = '95' 31/03/2025 12:57:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16276' , '95' , '1' ) 31/03/2025 12:57:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96425' , '23616' , 'PIZZO MACRAME SACRO CUORE - P537' , '14' , '14' , '1' , '25.7' , '21.065573770492' , '22' , '3' , '425.7873' ) 31/03/2025 12:57:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23616' AND id_supplier = '95' 31/03/2025 12:57:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23616' , '95' , '1' ) 31/03/2025 02:23:26 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/03/2025 02:23:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23621' , '1' , '' , 'nuovo-prodotto' ) 31/03/2025 02:23:26 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23621' , '1' , '1' , '2' , NOW() , NOW() ) 31/03/2025 02:23:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23621' , '0' , '1' , '0' , '0' ) 31/03/2025 02:24:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002369' AND id_product != '23621' AND ean13 != '' 31/03/2025 02:24:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002369', date_upd = NOW() WHERE id_product = '23621' 31/03/2025 02:24:43 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA S. RITA ARG', description = '' WHERE id_product = '23621' 31/03/2025 02:24:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26.229508196721312' WHERE id_product = '23621' 31/03/2025 02:24:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26.229508196721312', id_tax_rules_group = '1', id_category_default = '453', 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 = '23621' 31/03/2025 02:24:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '23621' 31/03/2025 02:24: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 = '23621' 31/03/2025 02:24:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23622' , '1' , '' , 'nuovo-prodotto' ) 31/03/2025 02:24: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 '23622' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23621' 31/03/2025 02:24:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23622' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23621' 31/03/2025 02:26:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '1/187' , '2025-03-31' , '187' , '0' , '131' , '4670575' , 'VIA RAFFAELE RUGGI, 29 80125 NAPOLI' , '' , 'CONTROLLARE NUMERO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.25' , '37.09' , NOW() , NOW() ) 31/03/2025 02:26:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96426' 31/03/2025 02:26:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '96426' 31/03/2025 02:26:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96426' , '23146' , 'SPILLA PORTA CIUCCIO CEL.' , '2' , '2' , '1' , '5.3279' , '4.367131147541' , '22' , '0' , '13.0001' ) 31/03/2025 02:26:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23146' AND id_supplier = '131' 31/03/2025 02:26:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23146' , '131' , '1' ) 31/03/2025 02:26:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96426' , '23621' , 'MEDAGLIA S. RITA ARG' , '2' , '2' , '1' , '13.217' , '10.833606557377' , '22' , '0' , '32.2495' ) 31/03/2025 02:26:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23621' AND id_supplier = '131' 31/03/2025 02:26:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23621' , '131' , '1' ) 31/03/2025 02:48:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400123456' AND id_product != '23622' AND ean13 != '' 31/03/2025 02:48:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400123456', date_upd = NOW() WHERE id_product = '23622' 31/03/2025 02:48:34 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO FOGLIA ORO S. FAMIGLIA - 1167-I0102', description = '' WHERE id_product = '23622' 31/03/2025 02:48:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.786885245901639' WHERE id_product = '23622' 31/03/2025 02:48:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.786885245901639', 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 = '23622' 31/03/2025 02:48:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '23622' 31/03/2025 02:49:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400123456' AND id_product != '23622' AND ean13 != '' 31/03/2025 02:49:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400123456', date_upd = NOW() WHERE id_product = '23622' 31/03/2025 02:49:08 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO FOGLIA ORO S. FAMIGLIA - 1167-I0102', description = '' WHERE id_product = '23622' 31/03/2025 02:49:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.786885245901639' WHERE id_product = '23622' 31/03/2025 02:49:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.786885245901639', 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 = '23622' 31/03/2025 02:49:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '23622' 31/03/2025 02:49:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400123456' AND id_product != '23622' AND ean13 != '' 31/03/2025 02:49:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8058400123456', date_upd = NOW() WHERE id_product = '23622' 31/03/2025 02:49:21 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO FOGLIA ORO S. FAMIGLIA - 1167-I0102', description = '' WHERE id_product = '23622' 31/03/2025 02:49:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.786885245901639' WHERE id_product = '23622' 31/03/2025 02:49:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.786885245901639', 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 = '23622' 31/03/2025 02:49:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '23622' 31/03/2025 02:49:21 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 = '23622' 31/03/2025 02:49:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23623' , '1' , '' , 'nuovo-prodotto' ) 31/03/2025 02:49:21 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 '23623' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23622' 31/03/2025 02:49:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23623' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23622' 31/03/2025 03:05:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '96095' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-07') 31/03/2025 03:05:52 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '53/A', document_date = '2025-03-07', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = 'mariani francesco', 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 = '360.00', price_tax_excluded = '360.00', date_upd = NOW() WHERE id_document = '96095' 31/03/2025 03:05: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 = '96095' 31/03/2025 03:05:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '96095' 31/03/2025 03:05: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 ( '96095' , '15210' , 'CERO PASQUALE API 80X120' , '8' , '-8' , '0' , '60.0000' , '60' , '' , '0' , '480.00' ) 31/03/2025 03:05: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 ( '96095' , '0' , 'CERI RICONSEGNATI DA PAGARE - FOGLIA ORO' , '3' , '-3' , '0' , '-40.0000' , '-40' , '0' , '0' , '-120.00' ) 31/03/2025 03:05: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 ( '96095' , '0' , 'CERO PASQUALE API 80X 120 da fare disegni' , '3' , '-3' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 31/03/2025 03:10:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2025-FV000433' , '2025-03-31' , '' , '0' , '0' , '2686' , 'VIA DELLA TIPOGRAFIA 00120 CITTA\\\' DEL VATICANO' , '' , '' , '6.50' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '412.75' , '412.75' , NOW() , NOW() ) 31/03/2025 03:10:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96427' 31/03/2025 03:10:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '96427' 31/03/2025 03:10:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96427' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '2' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '39.00' ) 31/03/2025 03:10:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96427' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '2' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '26.00' ) 31/03/2025 03:10:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96427' , '21655' , 'BENEDIZIONALE N. E. ' , '2' , '0' , '4' , '40.0000' , '40' , '0' , '35' , '52.00' ) 31/03/2025 03:10:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96427' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 31/03/2025 03:10:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96427' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 31/03/2025 03:10:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96427' , '22149' , 'LEZIONARIO FERIALE TEMPI FORTI - N.E.' , '1' , '0' , '4' , '65.0000' , '65' , '0' , '35' , '42.25' ) 31/03/2025 03:10:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96427' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO A' , '1' , '0' , '4' , '65.0000' , '65' , '0' , '30' , '45.50' ) 31/03/2025 03:10:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96427' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO B' , '1' , '0' , '4' , '65.0000' , '65' , '0' , '30' , '45.50' ) 31/03/2025 03:10:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96427' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '2' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '78.00' ) 31/03/2025 03:13:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400327519' AND id_product != '19601' AND ean13 != '' 31/03/2025 03:13:20 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400327519', date_upd = NOW() WHERE id_product = '19601' 31/03/2025 03:13:20 pm >> UPDATE ps_product_lang SET name = 'ANGELO ALI TORTORA - 4231', description = '' WHERE id_product = '19601' 31/03/2025 03:13:20 pm >> UPDATE ps_product SET wholesale_price = '3.78', on_sale = '0', price = '9.01639344262295' WHERE id_product = '19601' 31/03/2025 03:13:20 pm >> UPDATE ps_product_shop SET wholesale_price = '3.78', price = '9.01639344262295', 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 = '19601' 31/03/2025 03:13:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '19601' 31/03/2025 03:13:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400327502' AND id_product != '19318' AND ean13 != '' 31/03/2025 03:13:32 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400327502', date_upd = NOW() WHERE id_product = '19318' 31/03/2025 03:13:32 pm >> UPDATE ps_product_lang SET name = 'ANGELO ALI TORTORA - 4230 ', description = '' WHERE id_product = '19318' 31/03/2025 03:13:32 pm >> UPDATE ps_product SET wholesale_price = '3.78', on_sale = '0', price = '9.01639344262295' WHERE id_product = '19318' 31/03/2025 03:13:32 pm >> UPDATE ps_product_shop SET wholesale_price = '3.78', price = '9.01639344262295', 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 = '19318' 31/03/2025 03:13:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '19318' 31/03/2025 03:29:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001637' AND id_product != '17958' AND ean13 != '' 31/03/2025 03:29:47 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '001637', date_upd = NOW() WHERE id_product = '17958' 31/03/2025 03:29:47 pm >> UPDATE ps_product_lang SET name = 'TELA 50X70 - 2964', description = '' WHERE id_product = '17958' 31/03/2025 03:29:47 pm >> UPDATE ps_product SET wholesale_price = '16.80', on_sale = '0', price = '45.08196721311476' WHERE id_product = '17958' 31/03/2025 03:29:47 pm >> UPDATE ps_product_shop SET wholesale_price = '16.80', price = '45.08196721311476', 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 = '17958' 31/03/2025 03:29:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '17958' 31/03/2025 03:30: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 ( '31' , 'A1229' , '2025-03-31' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '235.25' , '192.83' , NOW() , NOW() ) 31/03/2025 03:30: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 = '96428' 31/03/2025 03:30:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '96428' 31/03/2025 03:30: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 ( '96428' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '50' , '50' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '48.8000' ) 31/03/2025 03:30:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23101' AND id_supplier = '28' 31/03/2025 03:30:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23101' , '28' , '1' ) 31/03/2025 03:30: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 ( '96428' , '14687' , 'CROCE DELL\'AMICIZIA IN ULIVO CM 18 - 2842' , '1' , '1' , '1' , '8.35' , '6.844262295082' , '22' , '0' , '10.1870' ) 31/03/2025 03:30:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14687' AND id_supplier = '28' 31/03/2025 03:30:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14687' , '28' , '1' ) 31/03/2025 03:30: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 ( '96428' , '17956' , 'SAN GIUSEPPE DORMIENTE CM 30 - 4041' , '2' , '2' , '1' , '14.99' , '12.286885245902' , '22' , '0' , '36.5756' ) 31/03/2025 03:30:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17956' AND id_supplier = '28' 31/03/2025 03:30:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17956' , '28' , '1' ) 31/03/2025 03:30: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 ( '96428' , '17958' , 'TELA 50X70 - 2964' , '1' , '1' , '1' , '19.99' , '16.385245901639' , '22' , '0' , '24.3878' ) 31/03/2025 03:30:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17958' AND id_supplier = '28' 31/03/2025 03:30:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17958' , '28' , '1' ) 31/03/2025 03:30: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 ( '96428' , '23622' , 'QUADRETTO FOGLIA ORO S. FAMIGLIA - 1167-I0102' , '7' , '7' , '1' , '3.52' , '2.8852459016393' , '22' , '0' , '30.0608' ) 31/03/2025 03:30:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23622' AND id_supplier = '28' 31/03/2025 03:30:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23622' , '28' , '1' ) 31/03/2025 03:30: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 ( '96428' , '23097' , 'CIONDOLO ANCORA GIUBILEO - G3119' , '50' , '50' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '73.2000' ) 31/03/2025 03:30:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23097' AND id_supplier = '28' 31/03/2025 03:30:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23097' , '28' , '1' ) 31/03/2025 03:30: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 ( '96428' , '22409' , 'PIASTRELLA COMUNIONE - 1302/K212' , '3' , '3' , '1' , '3.29' , '2.6967213114754' , '22' , '0' , '12.0414' ) 31/03/2025 03:30:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22409' AND id_supplier = '28' 31/03/2025 03:30:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22409' , '28' , '1' ) 31/03/2025 04:12:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1021' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 04:12:29 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' , '1021' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.13' , '29.98' , NOW() , NOW() ) 31/03/2025 04:12:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96429' 31/03/2025 04:12:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '96429' 31/03/2025 04:12:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96429' , '7917' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. B' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 31/03/2025 04:12:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96429' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 31/03/2025 04:12:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96429' , '23279' , 'AMEN - APR 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/03/2025 04:12:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96429' , '23491' , 'AMEN - MAG 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/03/2025 04:12:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96429' , '23492' , 'AMEN - GIU 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/03/2025 05:24:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1022' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 05:24:29 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' , '1022' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.33' , NOW() , NOW() ) 31/03/2025 05:24:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96430' 31/03/2025 05:24:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '96430' 31/03/2025 05:24:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96430' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 31/03/2025 05:26:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1023' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 05:26:02 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' , '1023' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.50' , '34.84' , NOW() , NOW() ) 31/03/2025 05:26:02 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 = '96431' 31/03/2025 05:26:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '96431' 31/03/2025 05:26:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96431' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 31/03/2025 05:26:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96431' , '12527' , 'LAMPADA A SFERA VIOLA' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 31/03/2025 05:26:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96431' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 31/03/2025 05:41:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1024' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 05:41:29 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' , '1024' , '2025-03-31' , '' , '0' , '0' , '0' , 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '334.00' , '273.77' , NOW() , NOW() ) 31/03/2025 05:41:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96432' 31/03/2025 05:41:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '96432' 31/03/2025 05:41:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96432' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '24.0000' , '19.6721' , '22' , '0' , '120.00' ) 31/03/2025 05:41:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96432' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '11.0000' , '9.0164' , '22' , '0' , '44.00' ) 31/03/2025 05:41:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96432' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 31/03/2025 05:41:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1025' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 05:41:55 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' , '1025' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.65' , '6.65' , NOW() , NOW() ) 31/03/2025 05:41:55 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 = '96433' 31/03/2025 05:41:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '96433' 31/03/2025 05:41:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96433' , '14141' , 'BEATO BARTOLO LONGO - 8859' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 31/03/2025 05:50:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1026' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 05:50:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1026' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 31/03/2025 05:50:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96434' 31/03/2025 05:50:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '96434' 31/03/2025 05:50:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96434' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 31/03/2025 06:05:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1027' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 06:05:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1027' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '121.50' , '104.73' , NOW() , NOW() ) 31/03/2025 06:05:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96435' 31/03/2025 06:05:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '96435' 31/03/2025 06:05:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96435' , '1938' , 'CERO PASQUALE API 80X100' , '1' , '-1' , '1' , '80.00' , '65.573770491803' , '22' , '0' , '80.00' ) 31/03/2025 06:05:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96435' , '23419' , 'PASSIONE DI NOSTRO SIGNORE' , '3' , '-3' , '4' , '10.00' , '10' , '0' , '5' , '28.50' ) 31/03/2025 06:05:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96435' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 31/03/2025 06:05:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '51' AND id_document != '96347' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-03-24') 31/03/2025 06:05:55 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '51', document_date = '2025-03-24', document_letter = '', id_customer = '4200', id_supplier = '', id_address = '4679491', address1 = 'VIA DANTE ALIGHIERI 16 00010 SAN PAOLO DEI CAVALIERI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '19.00', price_tax_excluded = '19.00', date_upd = NOW() WHERE id_document = '96347' 31/03/2025 06:05:55 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 = '96347' 31/03/2025 06:05:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '96347' 31/03/2025 06:05:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96347' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '20' , '-20' , '4' , '1.0000' , '1' , '0' , '5' , '19.00' ) 31/03/2025 06:13:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2025010000539' , '2025-03-31' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '23.19' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '645.46' , '645.46' , NOW() , NOW() ) 31/03/2025 06:13:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96436' 31/03/2025 06:13:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '96436' 31/03/2025 06:13:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96436' , '23527' , 'CODICE DI DIRITTO CANONICO - 9 EDIZ.' , '5' , '0' , '4' , '109.9000' , '109.9' , '0' , '35' , '357.18' ) 31/03/2025 06:13:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23527' AND id_supplier = '107' 31/03/2025 06:13:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23527' , '107' , '1' ) 31/03/2025 06:13:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96436' , '6682' , 'MINISTRI STRAORDINARI DELLA COMUNIONE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 31/03/2025 06:13:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6682' AND id_supplier = '107' 31/03/2025 06:13:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6682' , '107' , '1' ) 31/03/2025 06:13:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96436' , '23409' , 'VIA CRUCIS DEL GIUBILEO - RUCCIA/SCALERA' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '13.00' ) 31/03/2025 06:13:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23409' AND id_supplier = '107' 31/03/2025 06:13:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23409' , '107' , '1' ) 31/03/2025 06:13:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96436' , '23411' , 'CARLO ACUTIS SULLE ORME DI FRANCESCO - D. SORRENTINO' , '2' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '15.60' ) 31/03/2025 06:13:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23411' AND id_supplier = '107' 31/03/2025 06:13:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23411' , '107' , '1' ) 31/03/2025 06:13:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96436' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 31/03/2025 06:13:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4229' AND id_supplier = '107' 31/03/2025 06:13:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4229' , '107' , '1' ) 31/03/2025 06:13:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96436' , '13780' , 'RISCOPRIAMO LA BELLEZZA DEL BATTESIMO' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '30' , '7.00' ) 31/03/2025 06:13:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13780' AND id_supplier = '107' 31/03/2025 06:13:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13780' , '107' , '1' ) 31/03/2025 06:13:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96436' , '23527' , 'CODICE DI DIRITTO CANONICO - 9 EDIZ.' , '1' , '0' , '4' , '109.9000' , '109.9' , '0' , '35' , '71.44' ) 31/03/2025 06:13:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23527' AND id_supplier = '107' 31/03/2025 06:13:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23527' , '107' , '1' ) 31/03/2025 06:13:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96436' , '22995' , 'MINISTRO STRAORDINARIO DELLA COMUNIONE' , '1' , '0' , '4' , '7.0000' , '7' , '0' , '35' , '4.5500' ) 31/03/2025 06:13:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22995' AND id_supplier = '107' 31/03/2025 06:13:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22995' , '107' , '1' ) 31/03/2025 06:13:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96436' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '5' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '122.50' ) 31/03/2025 06:13:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4229' AND id_supplier = '107' 31/03/2025 06:13:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4229' , '107' , '1' ) 31/03/2025 06:19:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1028' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 06:19: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 ( '11' , '1028' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 31/03/2025 06:19: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 = '96437' 31/03/2025 06:19:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '96437' 31/03/2025 06:19: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 ( '96437' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 31/03/2025 06:25:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1029' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 06:25:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1029' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.33' , NOW() , NOW() ) 31/03/2025 06:25:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96438' 31/03/2025 06:25:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '96438' 31/03/2025 06:25:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96438' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 31/03/2025 06:26:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1030' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 06:26: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' , '1030' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.20' , '46.07' , NOW() , NOW() ) 31/03/2025 06:26: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 = '96439' 31/03/2025 06:26:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '96439' 31/03/2025 06:26: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 ( '96439' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 31/03/2025 06:26: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 ( '96439' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 31/03/2025 06:45:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1031' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 06:45:37 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' , '1031' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.00' , '131.15' , NOW() , NOW() ) 31/03/2025 06:45:37 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 = '96440' 31/03/2025 06:45:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '96440' 31/03/2025 06:45:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96440' , '16408' , 'AMPOLLE DORATE CON BECCUCCIO - 1503' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 31/03/2025 06:45:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96440' , '17535' , 'SERVIZIO MESSA LINO' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 31/03/2025 07:23:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1032' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 07:23:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1032' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '475.00' , '391.50' , NOW() , NOW() ) 31/03/2025 07:23:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96441' 31/03/2025 07:23:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '96441' 31/03/2025 07:23:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96441' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 31/03/2025 07:23:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96441' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '12' , '-12' , '4' , '0.70' , '0.7' , '0' , '0' , '8.40' ) 31/03/2025 07:23:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96441' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '139' , '113.93442622951' , '22' , '0' , '139.00' ) 31/03/2025 07:23:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96441' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '24' , '19.672131147541' , '22' , '0' , '120.00' ) 31/03/2025 07:23:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96441' , '16955' , 'STOLA MARIANA - 8005' , '1' , '-1' , '1' , '150' , '122.95081967213' , '22' , '0' , '150.00' ) 31/03/2025 07:23:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96441' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 31/03/2025 07:23:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96441' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.1' , '2.5409836065574' , '22' , '0' , '3.10' ) 31/03/2025 07:30:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1033' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-31') 31/03/2025 07:30:31 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' , '1033' , '2025-03-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '45.00' , NOW() , NOW() ) 31/03/2025 07:30:31 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 = '96442' 31/03/2025 07:30:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '96442' 31/03/2025 07:30:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96442' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' )