30/05/2023 08:47:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '632918' , '2023-05-26' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.65' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '79.37' , '79.37' , NOW() , NOW() ) 30/05/2023 08:47:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85626' 30/05/2023 08:47:54 am >> DELETE FROM ps_document_detail WHERE id_document = '85626' 30/05/2023 08:47: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 ( '85626' , '2048' , 'CHRISTIFIDELES LAICI' , '1' , '1' , '4' , '3.00' , '3' , '0' , '33' , '2.0100' ) 30/05/2023 08:47:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '2048' AND id_supplier = '7' 30/05/2023 08:47:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2048' , '7' , '1' ) 30/05/2023 08:47: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 ( '85626' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '3' , '3' , '4' , '18.00' , '18' , '0' , '33' , '36.1800' ) 30/05/2023 08:47:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '20655' AND id_supplier = '7' 30/05/2023 08:47:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20655' , '7' , '1' ) 30/05/2023 08:47:55 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 ( '85626' , '2072' , 'CINQUE LINGUAGGI DELLAMORE CON GLI ADOLESCENTI - PER GENITORI E EDUCA' , '1' , '1' , '4' , '13.00' , '13' , '0' , '35' , '8.4500' ) 30/05/2023 08:47:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '2072' AND id_supplier = '7' 30/05/2023 08:47:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2072' , '7' , '1' ) 30/05/2023 08:47:55 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 ( '85626' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 30/05/2023 08:47:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '12995' AND id_supplier = '7' 30/05/2023 08:47:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12995' , '7' , '1' ) 30/05/2023 08:47:55 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 ( '85626' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 30/05/2023 08:47:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '7' 30/05/2023 08:47:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '7' , '1' ) 30/05/2023 08:47:55 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 ( '85626' , '1132' , 'BIBBIA DELLA PRIMA COMUNIONE - RIL' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '33' , '8.6430' ) 30/05/2023 08:47:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '1132' AND id_supplier = '7' 30/05/2023 08:47:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1132' , '7' , '1' ) 30/05/2023 10:12:30 am >> SELECT document_num FROM ps_document WHERE document_num = '1890' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 10:12:30 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' , '1890' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.10' , '2.54' , NOW() , NOW() ) 30/05/2023 10:12:30 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 = '85627' 30/05/2023 10:12:30 am >> DELETE FROM ps_document_detail WHERE id_document = '85627' 30/05/2023 10:12: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 ( '85627' , '13335' , 'COLOMBA CON LACCIO' , '1' , '-1' , '1' , '1.60' , '1.3114754098361' , '22' , '0' , '1.60' ) 30/05/2023 10:12: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 ( '85627' , '18129' , 'TAU COLORATO - T56' , '1' , '-1' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '1.50' ) 30/05/2023 10:15:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1891' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 10:15:55 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' , '1891' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.05' , '54.55' , NOW() , NOW() ) 30/05/2023 10:15:55 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 = '85628' 30/05/2023 10:15:55 am >> DELETE FROM ps_document_detail WHERE id_document = '85628' 30/05/2023 10:15:55 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 ( '85628' , '19366' , 'DAL CENACOLO AL GIARDINO .. - E. DELLA CORTE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 30/05/2023 10:15:55 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 ( '85628' , '18810' , 'ANTIFONE - E. DELLA CORTE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 30/05/2023 10:15: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 ( '85628' , '20679' , 'ORIGINE E SIGNIFICATI DELLE FESTE CRISTIANE - A. DI BERARDINO' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 30/05/2023 10:15: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 ( '85628' , '19599' , 'ROSARIO PERLA PRIMA COMUNIONE - 197/13' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 30/05/2023 10:25:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1892' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 10:25:05 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' , '1892' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '62.00' , '54.65' , NOW() , NOW() ) 30/05/2023 10:25:05 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 = '85629' 30/05/2023 10:25:05 am >> DELETE FROM ps_document_detail WHERE id_document = '85629' 30/05/2023 10:25:05 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 ( '85629' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 30/05/2023 10:25:05 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 ( '85629' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '9.50' ) 30/05/2023 10:25:05 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 ( '85629' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '35.00' ) 30/05/2023 10:28:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1893' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 10:28:13 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' , '1893' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 30/05/2023 10:28:13 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 = '85630' 30/05/2023 10:28:13 am >> DELETE FROM ps_document_detail WHERE id_document = '85630' 30/05/2023 10:28:13 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 ( '85630' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 30/05/2023 10:28:13 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 ( '85630' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 30/05/2023 10:36:23 am >> UPDATE ps_document SET id_document_type = '33', document_num = '234/A', document_date = '2023-05-18', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '2648', address1 = '', address2 = '', note = '18/05/2023- CONSEGNATI 2800 X TITOLO - 22/05/2023 consegnati 3100 x titolo - 16/05/2023 CONSEGNATI 3100 X TITOLO - 30/05/2023 cons. 3100 x tipo', 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 = '84000.00', price_tax_excluded = '84000.00', date_upd = NOW() WHERE id_document = '84403' 30/05/2023 10:36:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84403' 30/05/2023 10:36:23 am >> DELETE FROM ps_document_detail WHERE id_document = '84403' 30/05/2023 10:36:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84403' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '15000' , '15000' , '4' , '2.8000' , '2.8' , '0' , '0' , '42000.00' ) 30/05/2023 10:36:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84403' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '15000' , '15000' , '4' , '2.8000' , '2.8' , '0' , '0' , '42000.00' ) 30/05/2023 10:37:23 am >> SELECT document_num FROM ps_document WHERE document_num = '1894' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 10:37:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1894' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.00' , '42.00' , NOW() , NOW() ) 30/05/2023 10:37:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85631' 30/05/2023 10:37:23 am >> DELETE FROM ps_document_detail WHERE id_document = '85631' 30/05/2023 10:37:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85631' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '42' , '42' , '0' , '0' , '42.00' ) 30/05/2023 11:03:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1895' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 11:03: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' , '1895' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 30/05/2023 11:03: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 = '85632' 30/05/2023 11:03:28 am >> DELETE FROM ps_document_detail WHERE id_document = '85632' 30/05/2023 11:03:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85632' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 30/05/2023 11:14:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1896' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 11:14:13 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' , '1896' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 30/05/2023 11:14:13 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 = '85633' 30/05/2023 11:14:13 am >> DELETE FROM ps_document_detail WHERE id_document = '85633' 30/05/2023 11:14:13 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 ( '85633' , '6590' , 'MEZZO VETRO ROSSO RUBINO - VKINGS2' , '2' , '-2' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '10.00' ) 30/05/2023 11:14:13 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 ( '85633' , '12200' , 'CANDELIERE FUSO - 643' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 30/05/2023 11:28:33 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 30/05/2023 11:28:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21132' , '1' , '' , 'nuovo-prodotto' ) 30/05/2023 11:28:33 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21132' , '1' , '1' , '2' , NOW() , NOW() ) 30/05/2023 11:28:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21132' , '0' , '1' , '0' , '0' ) 30/05/2023 11:32:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001410' AND id_product != '19607' AND ean13 != '' 30/05/2023 11:32:48 am >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001410', date_upd = NOW() WHERE id_product = '19607' 30/05/2023 11:32:48 am >> UPDATE ps_product_lang SET name = 'CLERGY F/F ML ', description = '' WHERE id_product = '19607' 30/05/2023 11:32:48 am >> UPDATE ps_product SET wholesale_price = '16.82', on_sale = '0', price = '34.34426229508197' WHERE id_product = '19607' 30/05/2023 11:32:48 am >> UPDATE ps_product_shop SET wholesale_price = '16.82', price = '34.34426229508197', id_tax_rules_group = '1', id_category_default = '462', 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 = '19607' 30/05/2023 11:32:48 am >> DELETE FROM ps_specific_price WHERE id_product = '19607' 30/05/2023 11:33:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002148' AND id_product != '21132' AND ean13 != '' 30/05/2023 11:33:17 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002148', date_upd = NOW() WHERE id_product = '21132' 30/05/2023 11:33:17 am >> UPDATE ps_product_lang SET name = 'CLERGY F/F MC', description = '' WHERE id_product = '21132' 30/05/2023 11:33:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.704918032786885' WHERE id_product = '21132' 30/05/2023 11:33:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32.704918032786885', id_tax_rules_group = '1', id_category_default = '462', 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 = '21132' 30/05/2023 11:33:17 am >> DELETE FROM ps_specific_price WHERE id_product = '21132' 30/05/2023 11:33:19 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21132' 30/05/2023 11:33:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21133' , '1' , '' , 'nuovo-prodotto' ) 30/05/2023 11:33:19 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21133' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21132' 30/05/2023 11:33:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21133' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21132' 30/05/2023 11:35:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002149' AND id_product != '21133' AND ean13 != '' 30/05/2023 11:35:42 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002149', date_upd = NOW() WHERE id_product = '21133' 30/05/2023 11:35:42 am >> UPDATE ps_product_lang SET name = 'SAIO SEMPLICE', description = '' WHERE id_product = '21133' 30/05/2023 11:35:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.78688524590164' WHERE id_product = '21133' 30/05/2023 11:35:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32.78688524590164', id_tax_rules_group = '1', id_category_default = '462', 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 = '21133' 30/05/2023 11:35:42 am >> DELETE FROM ps_specific_price WHERE id_product = '21133' 30/05/2023 11:35:45 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21133' 30/05/2023 11:35:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21134' , '1' , '' , 'nuovo-prodotto' ) 30/05/2023 11:35:45 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21134' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21133' 30/05/2023 11:35:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21134' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21133' 30/05/2023 11:36:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002150' AND id_product != '21134' AND ean13 != '' 30/05/2023 11:36:52 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002150', date_upd = NOW() WHERE id_product = '21134' 30/05/2023 11:36:52 am >> UPDATE ps_product_lang SET name = 'TUNICA 2 PIEGONI - S 11', description = '' WHERE id_product = '21134' 30/05/2023 11:36:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36.885245901639344' WHERE id_product = '21134' 30/05/2023 11:36:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36.885245901639344', id_tax_rules_group = '1', id_category_default = '462', 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 = '21134' 30/05/2023 11:36:52 am >> DELETE FROM ps_specific_price WHERE id_product = '21134' 30/05/2023 11:36:53 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21134' 30/05/2023 11:36:53 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21135' , '1' , '' , 'nuovo-prodotto' ) 30/05/2023 11:36:54 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21135' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21134' 30/05/2023 11:36:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21135' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21134' 30/05/2023 11:38: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 ( '31' , '117' , '2023-05-19' , '' , '0' , '137' , '4670816' , 'VIA G. BATTISTA VICO 73 80010 VILLARICCA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '711.87' , '583.50' , NOW() , NOW() ) 30/05/2023 11:38: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 = '85634' 30/05/2023 11:38:02 am >> DELETE FROM ps_document_detail WHERE id_document = '85634' 30/05/2023 11:38: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 ( '85634' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '5' , '5' , '1' , '17.5' , '14.344262295082' , '22' , '8' , '98.2100' ) 30/05/2023 11:38:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '137' 30/05/2023 11:38:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '137' , '1' ) 30/05/2023 11:38: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 ( '85634' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '2' , '2' , '1' , '17.2' , '14.098360655738' , '22' , '8' , '38.6106' ) 30/05/2023 11:38:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '137' 30/05/2023 11:38:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '137' , '1' ) 30/05/2023 11:38: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 ( '85634' , '19397' , 'CLERGY COTONE 100% ML - C02' , '2' , '2' , '1' , '19.1' , '15.655737704918' , '22' , '8' , '42.8757' ) 30/05/2023 11:38:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19397' AND id_supplier = '137' 30/05/2023 11:38:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19397' , '137' , '1' ) 30/05/2023 11:38: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 ( '85634' , '19607' , 'CLERGY F/F ML ' , '4' , '4' , '1' , '18.9' , '15.491803278689' , '22' , '6' , '86.6981' ) 30/05/2023 11:38:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '19607' AND id_supplier = '137' 30/05/2023 11:38:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19607' , '137' , '1' ) 30/05/2023 11:38: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 ( '85634' , '21132' , 'CLERGY F/F MC' , '8' , '8' , '1' , '18.6' , '15.245901639344' , '22' , '6' , '170.6438' ) 30/05/2023 11:38:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '21132' AND id_supplier = '137' 30/05/2023 11:38:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21132' , '137' , '1' ) 30/05/2023 11:38: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 ( '85634' , '18682' , 'CLERGY ROMANO ML - C17' , '3' , '3' , '1' , '25.1' , '20.573770491803' , '22' , '12' , '80.8421' ) 30/05/2023 11:38:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '18682' AND id_supplier = '137' 30/05/2023 11:38:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18682' , '137' , '1' ) 30/05/2023 11:38: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 ( '85634' , '16461' , 'CLERGY NIDO DAPE ML - C 22' , '2' , '2' , '1' , '25.9' , '21.229508196721' , '22' , '5' , '60.0362' ) 30/05/2023 11:38:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '16461' AND id_supplier = '137' 30/05/2023 11:38:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16461' , '137' , '1' ) 30/05/2023 11:38: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 ( '85634' , '21133' , 'SAIO SEMPLICE' , '6' , '6' , '1' , '18' , '14.754098360656' , '22' , '15' , '111.9960' ) 30/05/2023 11:38:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21133' AND id_supplier = '137' 30/05/2023 11:38:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21133' , '137' , '1' ) 30/05/2023 11:38: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 ( '85634' , '21134' , 'TUNICA 2 PIEGONI - S 11' , '1' , '1' , '1' , '18' , '14.754098360656' , '22' , '0' , '21.9600' ) 30/05/2023 11:38:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21134' AND id_supplier = '137' 30/05/2023 11:38:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21134' , '137' , '1' ) 30/05/2023 11:45:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '73' , '2023-05-30' , '' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '750.30' , '615.00' , NOW() , NOW() ) 30/05/2023 11:45:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85635' 30/05/2023 11:45:23 am >> DELETE FROM ps_document_detail WHERE id_document = '85635' 30/05/2023 11:45:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85635' , '16955' , 'STOLA MARIANA - 8005' , '1' , '1' , '1' , '60' , '49.180327868852' , '22' , '0' , '73.2000' ) 30/05/2023 11:45:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '16955' AND id_supplier = '126' 30/05/2023 11:45:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16955' , '126' , '1' ) 30/05/2023 11:45:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85635' , '19190' , 'STOLA MARIANA - 7335' , '1' , '1' , '1' , '70' , '57.377049180328' , '22' , '0' , '85.4000' ) 30/05/2023 11:45:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19190' AND id_supplier = '126' 30/05/2023 11:45:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19190' , '126' , '1' ) 30/05/2023 11:45:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85635' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '1' , '1' , '20' , '16.393442622951' , '22' , '0' , '24.4000' ) 30/05/2023 11:45:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '16958' AND id_supplier = '126' 30/05/2023 11:45:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16958' , '126' , '1' ) 30/05/2023 11:45:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85635' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '1' , '1' , '25' , '20.491803278689' , '22' , '0' , '30.5000' ) 30/05/2023 11:45:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '18239' AND id_supplier = '126' 30/05/2023 11:45:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18239' , '126' , '1' ) 30/05/2023 11:45:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85635' , '20901' , 'CASULA P/LANA AGNUS DEI - 8219-8249L' , '1' , '1' , '1' , '440' , '360.65573770492' , '22' , '0' , '536.8000' ) 30/05/2023 11:45:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '20901' AND id_supplier = '126' 30/05/2023 11:45:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20901' , '126' , '1' ) 30/05/2023 12:11:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1897' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 12:11:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1897' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '13.93' , NOW() , NOW() ) 30/05/2023 12:11:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85636' 30/05/2023 12:11:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '85636' 30/05/2023 12:11:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85636' , '12200' , 'CANDELIERE FUSO - 643' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 30/05/2023 12:19:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1898' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 12:19:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1898' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 30/05/2023 12:19:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85637' 30/05/2023 12:19:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '85637' 30/05/2023 12:19:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85637' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/05/2023 12:21:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1899' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 12:21:21 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' , '1899' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.91' , '56.91' , NOW() , NOW() ) 30/05/2023 12:21:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85638' 30/05/2023 12:21:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '85638' 30/05/2023 12:21:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85638' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '5' , '34.20' ) 30/05/2023 12:21: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 ( '85638' , '21116' , 'LIBERTA DI ANTONIO - L. EPICOCO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 30/05/2023 12:21: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 ( '85638' , '5832' , 'LIBRO DEI SANTI' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 30/05/2023 12:22:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1900' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 12:22:45 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' , '1900' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 30/05/2023 12:22:45 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 = '85639' 30/05/2023 12:22:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '85639' 30/05/2023 12:22:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85639' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 30/05/2023 01:06:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1901' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 01:06:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1901' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 30/05/2023 01:06:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85640' 30/05/2023 01:06:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '85640' 30/05/2023 01:06: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 ( '85640' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 30/05/2023 01:06: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 ( '85640' , '20077' , 'BRACCIALE ARGENTO - 1375CAV' , '1' , '-1' , '1' , '24.50' , '20.081967213115' , '22' , '0' , '24.50' ) 30/05/2023 01:06: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 ( '85640' , '17896' , 'ORECCHINI ARG.' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 30/05/2023 01:06: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 ( '85640' , '18351' , 'ORECCHINI' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 30/05/2023 03:20:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1902' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 03:20:41 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' , '1902' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 30/05/2023 03:20:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85641' 30/05/2023 03:20:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '85641' 30/05/2023 03:20:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85641' , '7202' , 'ARTICOLI RELIGIOSI' , '50' , '-50' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '15.00' ) 30/05/2023 03:22:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '03351CIP' AND id_product != '9168' AND ean13 != '' 30/05/2023 03:22:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '2014', ean13 = '03351CIP', date_upd = NOW() WHERE id_product = '9168' 30/05/2023 03:22:32 pm >> UPDATE ps_product_lang SET name = 'ROSARIO PLASTICA FOSFORO - 101 - OGGETTI', description = '' WHERE id_product = '9168' 30/05/2023 03:22:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.2459016393442623' WHERE id_product = '9168' 30/05/2023 03:22:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.2459016393442623', id_tax_rules_group = '1', id_category_default = '210', 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 = '9168' 30/05/2023 03:22:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '9168' 30/05/2023 03:24:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '0900RSNE' AND id_product != '9125' AND ean13 != '' 30/05/2023 03:24:55 pm >> UPDATE ps_product SET id_supplier = '', reference = '2015', ean13 = '0900RSNE', date_upd = NOW() WHERE id_product = '9125' 30/05/2023 03:24:55 pm >> UPDATE ps_product_lang SET name = 'ROSARIO IN PLASTICA - NERO', description = '' WHERE id_product = '9125' 30/05/2023 03:24:55 pm >> UPDATE ps_product SET wholesale_price = '0.09', on_sale = '0', price = '0.2459016393442623' WHERE id_product = '9125' 30/05/2023 03:24:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.09', price = '0.2459016393442623', id_tax_rules_group = '1', id_category_default = '216', 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 = '9125' 30/05/2023 03:24:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '9125' 30/05/2023 04:22:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869299568' AND id_product != '21135' AND ean13 != '' 30/05/2023 04:22:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788869299568', date_upd = NOW() WHERE id_product = '21135' 30/05/2023 04:22:43 pm >> UPDATE ps_product_lang SET name = 'PIENAMENTE VIVI - J. MAIN', description = '' WHERE id_product = '21135' 30/05/2023 04:22:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '21135' 30/05/2023 04:22:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21135' 30/05/2023 04:22:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '21135' 30/05/2023 04:22:45 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 = '21135' 30/05/2023 04:22:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21136' , '1' , '' , 'nuovo-prodotto' ) 30/05/2023 04:22:45 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 '21136' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21135' 30/05/2023 04:22:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21136' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21135' 30/05/2023 04:23:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869299421' AND id_product != '21136' AND ean13 != '' 30/05/2023 04:23:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9788869299421', date_upd = NOW() WHERE id_product = '21136' 30/05/2023 04:23:34 pm >> UPDATE ps_product_lang SET name = 'REGOLA DI BENEDETTO - J. CHITTISTER', description = '' WHERE id_product = '21136' 30/05/2023 04:23:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24' WHERE id_product = '21136' 30/05/2023 04:23:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21136' 30/05/2023 04:23:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '21136' 30/05/2023 04:23:35 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 = '21136' 30/05/2023 04:23:35 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21137' , '1' , '' , 'nuovo-prodotto' ) 30/05/2023 04:23:35 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 '21137' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21136' 30/05/2023 04:23:35 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21137' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21136' 30/05/2023 04:24: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 ( '33' , '957208' , '2023-05-29' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '182.00' , '182.00' , NOW() , NOW() ) 30/05/2023 04:24: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 = '85642' 30/05/2023 04:24:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '85642' 30/05/2023 04:24: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 ( '85642' , '17702' , 'BENEDETTO XVI - P. SEEWALD' , '1' , '1' , '4' , '40.00' , '40' , '0' , '0' , '40.00' ) 30/05/2023 04:24:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17702' AND id_supplier = '109' 30/05/2023 04:24:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17702' , '109' , '1' ) 30/05/2023 04:24: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 ( '85642' , '21135' , 'PIENAMENTE VIVI - J. MAIN' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 30/05/2023 04:24:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21135' AND id_supplier = '109' 30/05/2023 04:24:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21135' , '109' , '1' ) 30/05/2023 04:24: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 ( '85642' , '21136' , 'REGOLA DI BENEDETTO - J. CHITTISTER' , '1' , '1' , '4' , '24.00' , '24' , '0' , '0' , '24.00' ) 30/05/2023 04:24:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21136' AND id_supplier = '109' 30/05/2023 04:24:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21136' , '109' , '1' ) 30/05/2023 04:24: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 ( '85642' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '2' , '2' , '4' , '52.00' , '52' , '0' , '0' , '104.0000' ) 30/05/2023 04:24:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17864' AND id_supplier = '109' 30/05/2023 04:24:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17864' , '109' , '1' ) 30/05/2023 04:27:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1492' AND id_document != '84129' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-03') 30/05/2023 04:27:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1492', document_date = '2023-05-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '39.00', price_tax_excluded = '39.00', date_upd = NOW() WHERE id_document = '84129' 30/05/2023 04:27:38 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 = '84129' 30/05/2023 04:27:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '84129' 30/05/2023 04:27:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84129' , '17702' , 'BENEDETTO XVI - P. SEEWALD' , '1' , '-1' , '4' , '39' , '39' , '0' , '0' , '39.00' ) 30/05/2023 04:37:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8005788007106' AND id_product != '1621' AND ean13 != '' 30/05/2023 04:37:34 pm >> UPDATE ps_product SET id_supplier = '36', reference = '2016', ean13 = '8005788007106', date_upd = NOW() WHERE id_product = '1621' 30/05/2023 04:37:34 pm >> UPDATE ps_product_lang SET name = 'CANDELE CONICHE 10 PZ', description = '' WHERE id_product = '1621' 30/05/2023 04:37:34 pm >> UPDATE ps_product SET wholesale_price = '2.69', on_sale = '0', price = '6.475409836065574' WHERE id_product = '1621' 30/05/2023 04:37:34 pm >> UPDATE ps_product_shop SET wholesale_price = '2.69', price = '6.475409836065574', id_tax_rules_group = '1', id_category_default = '205', 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 = '1621' 30/05/2023 04:37:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '1621' 30/05/2023 04:40:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '745' , '2023-05-22' , '' , '0' , '36' , '2631' , 'VIA FRIZZONI,56 24048 TREVIOLO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '5291.45' , '4337.26' , NOW() , NOW() ) 30/05/2023 04:40:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85643' 30/05/2023 04:40:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '85643' 30/05/2023 04:40:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85643' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1440' , '1440' , '1' , '1.59' , '1.3032786885246' , '22' , '3' , '2709.5126' ) 30/05/2023 04:40:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '36' 30/05/2023 04:40:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '36' , '1' ) 30/05/2023 04:40:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85643' , '6809' , 'MOCCOLO 60X165' , '32' , '32' , '1' , '1.92' , '1.5737704918033' , '22' , '3' , '72.7081' ) 30/05/2023 04:40:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6809' AND id_supplier = '36' 30/05/2023 04:40:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6809' , '36' , '1' ) 30/05/2023 04:40:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85643' , '6811' , 'MOCCOLO 80X200' , '12' , '12' , '1' , '3.77' , '3.0901639344262' , '22' , '3' , '53.5370' ) 30/05/2023 04:40:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '36' 30/05/2023 04:40:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '36' , '1' ) 30/05/2023 04:40:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85643' , '1621' , 'CANDELE CONICHE 10 PZ' , '24' , '24' , '1' , '3.28' , '2.6885245901639' , '22' , '3' , '93.1572' ) 30/05/2023 04:40:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1621' AND id_supplier = '36' 30/05/2023 04:40:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1621' , '36' , '1' ) 30/05/2023 04:40:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85643' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '50' , '50' , '1' , '5.5' , '4.5081967213115' , '22' , '3' , '325.4350' ) 30/05/2023 04:40:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1220' AND id_supplier = '36' 30/05/2023 04:40:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1220' , '36' , '1' ) 30/05/2023 04:40:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85643' , '1914' , 'CERA DELLA LITURGIA' , '132' , '132' , '1' , '2.2' , '1.8032786885246' , '22' , '3' , '343.6594' ) 30/05/2023 04:40:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '36' 30/05/2023 04:40:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '36' , '1' ) 30/05/2023 04:40:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85643' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '900' , '900' , '1' , '1.59' , '1.3032786885246' , '22' , '3' , '1693.4454' ) 30/05/2023 04:40:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '36' 30/05/2023 04:40:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '36' , '1' ) 30/05/2023 04:46:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8005788007021' AND id_product != '21137' AND ean13 != '' 30/05/2023 04:46:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8005788007021', date_upd = NOW() WHERE id_product = '21137' 30/05/2023 04:46:42 pm >> UPDATE ps_product_lang SET name = 'MOCCOLO 70X200', description = '' WHERE id_product = '21137' 30/05/2023 04:46:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.147540983606557' WHERE id_product = '21137' 30/05/2023 04:46:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.147540983606557', id_tax_rules_group = '1', id_category_default = '205', 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 = '21137' 30/05/2023 04:46:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '21137' 30/05/2023 04:47:10 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '745', document_date = '2023-05-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2631', address1 = 'VIA FRIZZONI,56 24048 TREVIOLO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '5347.89', price_tax_excluded = '4383.52', date_upd = NOW() WHERE id_document = '85643' 30/05/2023 04:47:10 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 = '85643' 30/05/2023 04:47:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '85643' 30/05/2023 04:47:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85643' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1440' , '1440' , '1' , '1.5900' , '1.3032786885246' , '22' , '3' , '2709.51' ) 30/05/2023 04:47:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85643' , '6809' , 'MOCCOLO 60X165' , '32' , '32' , '1' , '1.9200' , '1.5737704918033' , '22' , '3' , '72.71' ) 30/05/2023 04:47:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85643' , '6811' , 'MOCCOLO 80X200' , '12' , '12' , '1' , '3.7700' , '3.0901639344262' , '22' , '3' , '53.5370' ) 30/05/2023 04:47:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85643' , '1621' , 'CANDELE CONICHE 10 PZ' , '24' , '24' , '1' , '3.2800' , '2.6885245901639' , '22' , '3' , '93.16' ) 30/05/2023 04:47:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85643' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '50' , '50' , '1' , '5.5000' , '4.5081967213115' , '22' , '3' , '325.44' ) 30/05/2023 04:47:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85643' , '1914' , 'CERA DELLA LITURGIA' , '132' , '132' , '1' , '2.2000' , '1.8032786885246' , '22' , '3' , '343.66' ) 30/05/2023 04:47:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85643' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '900' , '900' , '1' , '1.5900' , '1.3032786885246' , '22' , '3' , '1693.45' ) 30/05/2023 04:47:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85643' , '21137' , 'MOCCOLO 70X200' , '16' , '16' , '1' , '2.98' , '2.4426229508197' , '22' , '3' , '56.4245' ) 30/05/2023 05:08:23 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '117', document_date = '2023-05-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670816', address1 = 'VIA G. BATTISTA VICO 73 80010 VILLARICCA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '711.88', price_tax_excluded = '583.51', date_upd = NOW() WHERE id_document = '85634' 30/05/2023 05:08: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 = '85634' 30/05/2023 05:08:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '85634' 30/05/2023 05:08: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 ( '85634' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '5' , '5' , '1' , '17.5000' , '14.344262295082' , '22' , '8' , '98.21' ) 30/05/2023 05:08: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 ( '85634' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '2' , '2' , '1' , '17.2000' , '14.098360655738' , '22' , '8' , '38.61' ) 30/05/2023 05:08: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 ( '85634' , '19397' , 'CLERGY COTONE 100% ML - C02' , '2' , '2' , '1' , '19.1000' , '15.655737704918' , '22' , '8' , '42.88' ) 30/05/2023 05:08: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 ( '85634' , '19607' , 'CLERGY F/F ML ' , '4' , '4' , '1' , '18.9000' , '15.491803278689' , '22' , '6' , '86.70' ) 30/05/2023 05:08: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 ( '85634' , '21132' , 'CLERGY F/F MC' , '8' , '8' , '1' , '18.6000' , '15.245901639344' , '22' , '6' , '170.64' ) 30/05/2023 05:08: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 ( '85634' , '18682' , 'CLERGY ROMANO ML - C17' , '3' , '3' , '1' , '25.1000' , '20.573770491803' , '22' , '12' , '80.84' ) 30/05/2023 05:08: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 ( '85634' , '16461' , 'CLERGY NIDO DAPE ML - C 22' , '2' , '2' , '1' , '25.9000' , '21.229508196721' , '22' , '5' , '60.04' ) 30/05/2023 05:08: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 ( '85634' , '21133' , 'SAIO SEMPLICE' , '6' , '6' , '1' , '18.0000' , '14.754098360656' , '22' , '15' , '112.00' ) 30/05/2023 05:08: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 ( '85634' , '21134' , 'TUNICA 2 PIEGONI - S 11' , '1' , '1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '21.96' ) 30/05/2023 05:09:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001410' AND id_product != '19607' AND ean13 != '' 30/05/2023 05:09:33 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001410', date_upd = NOW() WHERE id_product = '19607' 30/05/2023 05:09:33 pm >> UPDATE ps_product_lang SET name = 'CLERGY F/F ML ', description = '' WHERE id_product = '19607' 30/05/2023 05:09:33 pm >> UPDATE ps_product SET wholesale_price = '16.82', on_sale = '0', price = '32.704918032786885' WHERE id_product = '19607' 30/05/2023 05:09:33 pm >> UPDATE ps_product_shop SET wholesale_price = '16.82', price = '32.704918032786885', id_tax_rules_group = '1', id_category_default = '462', 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 = '19607' 30/05/2023 05:09:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '19607' 30/05/2023 05:10:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002148' AND id_product != '21132' AND ean13 != '' 30/05/2023 05:10:20 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '002148', date_upd = NOW() WHERE id_product = '21132' 30/05/2023 05:10:20 pm >> UPDATE ps_product_lang SET name = 'CLERGY F/F MC', description = '' WHERE id_product = '21132' 30/05/2023 05:10:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '31.885245901639344' WHERE id_product = '21132' 30/05/2023 05:10:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '31.885245901639344', id_tax_rules_group = '1', id_category_default = '462', 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 = '21132' 30/05/2023 05:10:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '21132' 30/05/2023 05:10:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002148' AND id_product != '21132' AND ean13 != '' 30/05/2023 05:10:48 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '002148', date_upd = NOW() WHERE id_product = '21132' 30/05/2023 05:10:48 pm >> UPDATE ps_product_lang SET name = 'CLERGY F/F MC', description = '' WHERE id_product = '21132' 30/05/2023 05:10:48 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.37704918032787' WHERE id_product = '21132' 30/05/2023 05:10:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32.37704918032787', id_tax_rules_group = '1', id_category_default = '462', 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 = '21132' 30/05/2023 05:10:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '21132' 30/05/2023 05:16:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002148' AND id_product != '21132' AND ean13 != '' 30/05/2023 05:16:41 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '002148', date_upd = NOW() WHERE id_product = '21132' 30/05/2023 05:16:41 pm >> UPDATE ps_product_lang SET name = 'CLERGY F/F MC', description = '' WHERE id_product = '21132' 30/05/2023 05:16:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.3770' WHERE id_product = '21132' 30/05/2023 05:16:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32.3770', id_tax_rules_group = '1', id_category_default = '462', 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 = '21132' 30/05/2023 05:16:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '21132' 30/05/2023 05:58:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1903' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 05:58:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1903' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.50' , '31.56' , NOW() , NOW() ) 30/05/2023 05:58:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85644' 30/05/2023 05:58:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '85644' 30/05/2023 05:58: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 ( '85644' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 30/05/2023 05:58: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 ( '85644' , '6812' , 'MOCCOLO 80X300 ' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 30/05/2023 06:02:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1904' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 06:02:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1904' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.60' , '7.87' , NOW() , NOW() ) 30/05/2023 06:02:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85645' 30/05/2023 06:02:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '85645' 30/05/2023 06:02:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85645' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 30/05/2023 06:02:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85645' , '15103' , 'GIROCOLLO - 870/24' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 30/05/2023 06:02:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85645' , '2764' , 'CORONA EMATITE TONDA ' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 30/05/2023 06:04:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1576' AND id_document != '84231' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-08') 30/05/2023 06:04:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1576', document_date = '2023-05-08', 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 = '10.00', price_tax_excluded = '8.20', date_upd = NOW() WHERE id_document = '84231' 30/05/2023 06:04: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 = '84231' 30/05/2023 06:04:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '84231' 30/05/2023 06:04: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 ( '84231' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '4' , '-4' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '8.00' ) 30/05/2023 06:04: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 ( '84231' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 30/05/2023 06:04:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1762' AND id_document != '84449' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-20') 30/05/2023 06:04:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1762', document_date = '2023-05-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '19.00', price_tax_excluded = '17.87', date_upd = NOW() WHERE id_document = '84449' 30/05/2023 06:04:58 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 = '84449' 30/05/2023 06:04:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '84449' 30/05/2023 06:04:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84449' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 30/05/2023 06:04:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84449' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '5.70' ) 30/05/2023 06:04:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84449' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.80' ) 30/05/2023 06:04:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84449' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 30/05/2023 06:26:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1905' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 06:26:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1905' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 30/05/2023 06:26:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85646' 30/05/2023 06:26:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '85646' 30/05/2023 06:26:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85646' , '20704' , 'QUADRO 63X35' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 30/05/2023 06:39:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1906' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 06:39:12 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' , '1906' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.50' , '72.50' , NOW() , NOW() ) 30/05/2023 06:39:12 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 = '85647' 30/05/2023 06:39:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '85647' 30/05/2023 06:39:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85647' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '2' , '-2' , '4' , '38.00' , '38' , '0' , '5' , '72.20' ) 30/05/2023 06:39:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85647' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '0.30' , '0.3' , '0' , '0' , '0.30' ) 30/05/2023 07:26:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1907' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 07:26:50 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' , '1907' , '2023-05-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.30' , '12.54' , NOW() , NOW() ) 30/05/2023 07:26:50 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 = '85648' 30/05/2023 07:26:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '85648' 30/05/2023 07:26:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85648' , '9125' , 'ROSARIO IN PLASTICA - NERO' , '33' , '-33' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '9.90' ) 30/05/2023 07:26:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85648' , '9124' , 'ROSARIO IN PLASTICA - MARRONE' , '18' , '-18' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '5.40' ) 30/05/2023 07:29:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '25' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 07:29: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 ( '21' , '25' , '2023-05-30' , '' , '292' , '0' , '4668944' , 'VIA IONIO 8/A 84091 BATTIPAGLIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.38' , '108.38' , NOW() , NOW() ) 30/05/2023 07:29: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 = '11335' 30/05/2023 07:29:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '11335' 30/05/2023 07:29:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11335' , '92' , 'LA PREGHIERA DEL ROSARIO' , '51' , '-51' , '4' , '2.50' , '2.5' , '0' , '15' , '108.38' ) 30/05/2023 07:50:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '25' AND id_document != '11335' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-05-30') 30/05/2023 07:50:19 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '25', document_date = '2023-05-30', document_letter = '', id_customer = '292', id_supplier = '', id_address = '4668944', address1 = 'VIA IONIO 8/A 84091 BATTIPAGLIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '108.38', price_tax_excluded = '108.38', date_upd = NOW() WHERE id_document = '11335' 30/05/2023 07:50: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 = '11335' 30/05/2023 07:50:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '11335' 30/05/2023 07:50: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 ( '11335' , '92' , 'LA PREGHIERA DEL ROSARIO' , '51' , '-51' , '4' , '2.5000' , '2.5' , '0' , '15' , '108.38' )