18/06/2025 08:57:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846238109' AND id_product != '19995' AND ean13 != '' 18/06/2025 08:57:38 am >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = '8027846238109', date_upd = NOW() WHERE id_product = '19995' 18/06/2025 08:57:38 am >> UPDATE ps_product_lang SET name = 'CROCE NOCE CORPO RESINA - CL195CBLU', description = '' WHERE id_product = '19995' 18/06/2025 08:57:38 am >> UPDATE ps_product SET wholesale_price = '12.48', on_sale = '0', price = '26.2295' WHERE id_product = '19995' 18/06/2025 08:57:38 am >> UPDATE ps_product_shop SET wholesale_price = '12.48', price = '26.2295', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19995' 18/06/2025 08:57:38 am >> DELETE FROM ps_specific_price WHERE id_product = '19995' 18/06/2025 09:34:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2156' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 18/06/2025 09:34:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2156' , '2025-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '238.10' , '209.70' , NOW() , NOW() ) 18/06/2025 09:34:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97742' 18/06/2025 09:34:48 am >> DELETE FROM ps_document_detail WHERE id_document = '97742' 18/06/2025 09:34:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97742' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 18/06/2025 09:34:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97742' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 18/06/2025 09:34:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97742' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '6' , '-6' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '27.00' ) 18/06/2025 09:34:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97742' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '95' , '77.868852459016' , '22' , '0' , '95.00' ) 18/06/2025 09:34:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97742' , '22672' , 'PORTATECA CAMOSCIO E TECA - A26' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 18/06/2025 09:34:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97742' , '23800' , 'MIA SPERANZA E IN TE- CD' , '1' , '-1' , '4' , '16.10' , '16.1' , '0' , '0' , '16.10' ) 18/06/2025 09:38:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2157' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 18/06/2025 09:38:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2157' , '2025-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '158.00' , '129.51' , NOW() , NOW() ) 18/06/2025 09:38:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97743' 18/06/2025 09:38:21 am >> DELETE FROM ps_document_detail WHERE id_document = '97743' 18/06/2025 09:38:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97743' , '22756' , 'CROCIFISSO SAGOMATO nazareno 30X19 - 1030161' , '2' , '-2' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '158.00' ) 18/06/2025 09:51:03 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' , '25FP00641' , '2025-06-13' , '' , '0' , '63' , '2658' , 'P.ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '240.80' , '240.80' , NOW() , NOW() ) 18/06/2025 09:51:03 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 = '97744' 18/06/2025 09:51:03 am >> DELETE FROM ps_document_detail WHERE id_document = '97744' 18/06/2025 09:51:03 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 ( '97744' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '430' , '430' , '4' , '0.56' , '0.56' , '0' , '0' , '240.8000' ) 18/06/2025 09:51:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '63' 18/06/2025 09:51:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '63' , '1' ) 18/06/2025 09:52:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '25FP00494' , '2025-05-16' , '' , '0' , '63' , '2658' , 'P.ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '229.60' , '229.60' , NOW() , NOW() ) 18/06/2025 09:52:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97745' 18/06/2025 09:52:21 am >> DELETE FROM ps_document_detail WHERE id_document = '97745' 18/06/2025 09:52:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97745' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '410' , '410' , '4' , '0.56' , '0.56' , '0' , '0' , '229.6000' ) 18/06/2025 09:52:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '63' 18/06/2025 09:52:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '63' , '1' ) 18/06/2025 09:59:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '98' , '2025-06-09' , '' , '0' , '137' , '4670816' , 'VIA G. BATTISTA VICO 73 80010 VILLARICCA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '504.65' , '413.65' , NOW() , NOW() ) 18/06/2025 09:59:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97746' 18/06/2025 09:59:40 am >> DELETE FROM ps_document_detail WHERE id_document = '97746' 18/06/2025 09:59:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97746' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '10' , '10' , '1' , '17.2' , '14.098360655738' , '22' , '8' , '193.0528' ) 18/06/2025 09:59:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '137' 18/06/2025 09:59:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '137' , '1' ) 18/06/2025 09:59:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97746' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '3' , '3' , '1' , '17.5' , '14.344262295082' , '22' , '8' , '58.9260' ) 18/06/2025 09:59:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '137' 18/06/2025 09:59:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '137' , '1' ) 18/06/2025 09:59:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97746' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '1' , '1' , '1' , '18.9' , '15.491803278689' , '22' , '6' , '21.6745' ) 18/06/2025 09:59:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '16494' AND id_supplier = '137' 18/06/2025 09:59:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16494' , '137' , '1' ) 18/06/2025 09:59:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97746' , '21132' , 'CLERGY F/F MC - C03' , '3' , '3' , '1' , '18.6' , '15.245901639344' , '22' , '6' , '63.9914' ) 18/06/2025 09:59:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '21132' AND id_supplier = '137' 18/06/2025 09:59:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21132' , '137' , '1' ) 18/06/2025 09:59:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97746' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '1' , '1' , '19.1' , '15.655737704918' , '22' , '8' , '21.4378' ) 18/06/2025 09:59:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19397' AND id_supplier = '137' 18/06/2025 09:59:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19397' , '137' , '1' ) 18/06/2025 09:59:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97746' , '16588' , 'CLERGY DIAGONALE ML - C06' , '1' , '1' , '1' , '20.8' , '17.049180327869' , '22' , '10' , '22.8384' ) 18/06/2025 09:59:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '16588' AND id_supplier = '137' 18/06/2025 09:59:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16588' , '137' , '1' ) 18/06/2025 09:59:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97746' , '22508' , 'POLO PIQUET - M06' , '4' , '4' , '1' , '19.9' , '16.311475409836' , '22' , '0' , '97.1120' ) 18/06/2025 09:59:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '22508' AND id_supplier = '137' 18/06/2025 09:59:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22508' , '137' , '1' ) 18/06/2025 09:59:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97746' , '22508' , 'POLO PIQUET - M06' , '1' , '1' , '1' , '21' , '17.213114754098' , '22' , '0' , '25.6200' ) 18/06/2025 09:59:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '22508' AND id_supplier = '137' 18/06/2025 09:59:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22508' , '137' , '1' ) 18/06/2025 10:17:06 am >> SELECT document_num FROM ps_document WHERE document_num = '2158' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 18/06/2025 10:17:06 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' , '2158' , '2025-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.50' , '12.70' , NOW() , NOW() ) 18/06/2025 10:17:06 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 = '97747' 18/06/2025 10:17:06 am >> DELETE FROM ps_document_detail WHERE id_document = '97747' 18/06/2025 10:17:06 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 ( '97747' , '18764' , 'STELLARIO PLEX CM 18/20' , '1' , '-1' , '1' , '15.50' , '12.704918032787' , '22' , '0' , '15.50' ) 18/06/2025 10:19:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2159' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 18/06/2025 10:19:56 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' , '2159' , '2025-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '167.42' , '138.57' , NOW() , NOW() ) 18/06/2025 10:19:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97748' 18/06/2025 10:19:56 am >> DELETE FROM ps_document_detail WHERE id_document = '97748' 18/06/2025 10:19:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97748' , '17544' , 'CAMICE BAMBOO' , '1' , '-1' , '1' , '160' , '131.14754098361' , '22' , '0' , '160.00' ) 18/06/2025 10:19:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97748' , '23700' , 'AMEN - LUG 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 18/06/2025 10:19:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97748' , '23699' , 'AMEN - AGO 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 18/06/2025 10:25:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810821459' AND id_product != '22283' AND ean13 != '' 18/06/2025 10:25:08 am >> UPDATE ps_product SET id_supplier = '109', reference = '11/1', ean13 = '9788810821459', date_upd = NOW() WHERE id_product = '22283' 18/06/2025 10:25:08 am >> UPDATE ps_product_lang SET name = 'BIBBIA DI GERUSALEMME VERDE', description = '' WHERE id_product = '22283' 18/06/2025 10:25:08 am >> UPDATE ps_product SET wholesale_price = '21.26', on_sale = '0', price = '35' WHERE id_product = '22283' 18/06/2025 10:25:08 am >> UPDATE ps_product_shop SET wholesale_price = '21.26', price = '35', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22283' 18/06/2025 10:25:08 am >> DELETE FROM ps_specific_price WHERE id_product = '22283' 18/06/2025 10:33:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2160' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 18/06/2025 10:33:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2160' , '2025-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 18/06/2025 10:33:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97749' 18/06/2025 10:33:02 am >> DELETE FROM ps_document_detail WHERE id_document = '97749' 18/06/2025 10:33:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97749' , '9181' , 'ROSARIO S. BENEDETTO LEGNO - 0341870BR' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 18/06/2025 10:33:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97749' , '9184' , 'ROSARIO S. MICHELE IN CRISTALLO - RL 753/C' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 18/06/2025 11:06:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2161' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 18/06/2025 11:06:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2161' , '2025-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '21.31' , NOW() , NOW() ) 18/06/2025 11:06:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97750' 18/06/2025 11:06:20 am >> DELETE FROM ps_document_detail WHERE id_document = '97750' 18/06/2025 11:06:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97750' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 18/06/2025 11:06:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97750' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 18/06/2025 11:09:06 am >> SELECT document_num FROM ps_document WHERE document_num = '2162' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 18/06/2025 11:09:06 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' , '2162' , '2025-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.50' , '26.44' , NOW() , NOW() ) 18/06/2025 11:09:06 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 = '97751' 18/06/2025 11:09:06 am >> DELETE FROM ps_document_detail WHERE id_document = '97751' 18/06/2025 11:09:06 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 ( '97751' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 18/06/2025 11:09:07 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 ( '97751' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 18/06/2025 11:09:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2163' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 18/06/2025 11:09:37 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' , '2163' , '2025-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.50' , '33.44' , NOW() , NOW() ) 18/06/2025 11:09:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97752' 18/06/2025 11:09:37 am >> DELETE FROM ps_document_detail WHERE id_document = '97752' 18/06/2025 11:09:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97752' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 18/06/2025 11:09:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97752' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 18/06/2025 11:09:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97752' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '3.5' , '3.5' , '0' , '0' , '7.00' ) 18/06/2025 11:09:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2164' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 18/06/2025 11:09:53 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' , '2164' , '2025-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '7.00' , NOW() , NOW() ) 18/06/2025 11:09: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 = '97753' 18/06/2025 11:09:53 am >> DELETE FROM ps_document_detail WHERE id_document = '97753' 18/06/2025 11:09: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 ( '97753' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '3.5' , '3.5' , '0' , '0' , '7.00' ) 18/06/2025 11:10:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2165' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 18/06/2025 11:10:42 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' , '2165' , '2025-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 18/06/2025 11:10:42 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 = '97754' 18/06/2025 11:10:42 am >> DELETE FROM ps_document_detail WHERE id_document = '97754' 18/06/2025 11:10:42 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 ( '97754' , '23783' , 'LEONE XIV - A. PREZIOSI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 18/06/2025 11:37:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2166' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 18/06/2025 11:37:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2166' , '2025-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '96.15' , NOW() , NOW() ) 18/06/2025 11:37:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97755' 18/06/2025 11:37:19 am >> DELETE FROM ps_document_detail WHERE id_document = '97755' 18/06/2025 11:37:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97755' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '20' , '-20' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '70.00' ) 18/06/2025 11:37:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97755' , '7311' , 'OSTIA SOTTILE 74MM' , '15' , '-15' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '30.00' ) 18/06/2025 02:29: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' , '000196/25' , '2025-06-12' , '25' , '0' , '0' , '4671003' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '50.00' , NOW() , NOW() ) 18/06/2025 02:29: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 = '97756' 18/06/2025 02:29:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '97756' 18/06/2025 02:29: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 ( '97756' , '9536' , 'SANTANTONIO - L.GJERGJI' , '20' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '50.00' ) 18/06/2025 03:59:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2167' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 18/06/2025 03:59:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2167' , '2025-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 18/06/2025 03:59:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97757' 18/06/2025 03:59:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '97757' 18/06/2025 03:59:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97757' , '22464' , 'CASULA LEGGERA - 1212' , '1' , '-1' , '1' , '75.00' , '61.475409836066' , '22' , '0' , '75.00' ) 18/06/2025 04:35:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2168' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 18/06/2025 04:35:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2168' , '2025-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '310.00' , '254.10' , NOW() , NOW() ) 18/06/2025 04:35:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97758' 18/06/2025 04:35:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '97758' 18/06/2025 04:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97758' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '310' , '254.09836065574' , '22' , '0' , '310.00' ) 18/06/2025 05:45:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2169' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 18/06/2025 05:45:49 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' , '2169' , '2025-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.40' , '30.40' , NOW() , NOW() ) 18/06/2025 05:45:49 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 = '97759' 18/06/2025 05:45:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '97759' 18/06/2025 05:45:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97759' , '23816' , 'MAHABHARATA' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' ) 18/06/2025 05:51:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2170' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-06-18') 18/06/2025 05:51: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' , '2170' , '2025-06-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.40' , '17.56' , NOW() , NOW() ) 18/06/2025 05:51:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97760' 18/06/2025 05:51:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '97760' 18/06/2025 05:51:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97760' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 18/06/2025 05:51:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97760' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 18/06/2025 05:51:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97760' , '22199' , 'VINO LIQUOROSO ROSSO ' , '2' , '-2' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '15.00' ) 18/06/2025 05:55:53 pm >> DELETE FROM ps_document WHERE id_document = '97106' 18/06/2025 05:55:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '97106'