09/11/2024 08:37:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069112' AND id_product != '22746' AND ean13 != '' 09/11/2024 08:37:23 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/4', ean13 = '9788801069112', date_upd = NOW() WHERE id_product = '22746' 09/11/2024 08:37:23 am >> UPDATE ps_product_lang SET name = 'COME SE VEDESSE L\'INVISIBILE - G.M. DOS SANTOS', description = '' WHERE id_product = '22746' 09/11/2024 08:37:23 am >> UPDATE ps_product SET wholesale_price = '6.50', on_sale = '0', price = '10.0000' WHERE id_product = '22746' 09/11/2024 08:37:23 am >> UPDATE ps_product_shop SET wholesale_price = '6.50', price = '10.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22746' 09/11/2024 08:37:23 am >> DELETE FROM ps_specific_price WHERE id_product = '22746' 09/11/2024 08:37:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892218147' AND id_product != '22745' AND ean13 != '' 09/11/2024 08:37:40 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/4', ean13 = '9788892218147', date_upd = NOW() WHERE id_product = '22745' 09/11/2024 08:37:40 am >> UPDATE ps_product_lang SET name = 'VANGELO DEL CORAGGIO - TONINO BELLO', description = '' WHERE id_product = '22745' 09/11/2024 08:37:40 am >> UPDATE ps_product SET wholesale_price = '6.63', on_sale = '0', price = '9.9000' WHERE id_product = '22745' 09/11/2024 08:37:40 am >> UPDATE ps_product_shop SET wholesale_price = '6.63', price = '9.9000', id_tax_rules_group = '4', id_category_default = '30', 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 = '22745' 09/11/2024 08:37:40 am >> DELETE FROM ps_specific_price WHERE id_product = '22745' 09/11/2024 09:25:24 am >> SELECT document_num FROM ps_document WHERE document_num = '41' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 09:25:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '41' , '2024-11-09' , '' , '7016' , '0' , '102683561' , 'PIAZZA SANTA MARIA 2 60027 OSIMO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '76.50' , '76.50' , NOW() , NOW() ) 09/11/2024 09:25:24 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 = '14768' 09/11/2024 09:25:24 am >> DELETE FROM ps_document_detail WHERE id_document = '14768' 09/11/2024 09:25:24 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 ( '14768' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '15' , '-15' , '4' , '2.00' , '2' , '0' , '15' , '25.50' ) 09/11/2024 09:25:24 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 ( '14768' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '2' , '-2' , '4' , '30.00' , '30' , '0' , '15' , '51.00' ) 09/11/2024 09:31:53 am >> SELECT document_num FROM ps_document WHERE document_num = '41' AND id_document != '14768' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 09:31:53 am >> UPDATE ps_document SET id_document_type = '21', document_num = '41', document_date = '2024-11-09', document_letter = '', id_customer = '7016', id_supplier = '', id_address = '102683561', address1 = 'PIAZZA SANTA MARIA 2 60027 OSIMO', 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 = '200.60', price_tax_excluded = '200.60', date_upd = NOW() WHERE id_document = '14768' 09/11/2024 09:31: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 = '14768' 09/11/2024 09:31:54 am >> DELETE FROM ps_document_detail WHERE id_document = '14768' 09/11/2024 09:31: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 ( '14768' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '15' , '-15' , '4' , '2.0000' , '2' , '0' , '15' , '25.50' ) 09/11/2024 09:31: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 ( '14768' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '2' , '-2' , '4' , '30.0000' , '30' , '0' , '15' , '51.00' ) 09/11/2024 09:31: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 ( '14768' , '111' , 'I NONNI SONO UN TESORO' , '20' , '-20' , '4' , '1.80' , '1.8' , '0' , '15' , '30.60' ) 09/11/2024 09:31: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 ( '14768' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU\'' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '15' , '51.00' ) 09/11/2024 09:31: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 ( '14768' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '20' , '-20' , '4' , '2.50' , '2.5' , '0' , '15' , '42.50' ) 09/11/2024 09:57:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839924100' AND id_product != '12104' AND ean13 != '' 09/11/2024 09:57:35 am >> UPDATE ps_product SET id_supplier = '65', reference = '', ean13 = '9788839924100', date_upd = NOW() WHERE id_product = '12104' 09/11/2024 09:57:35 am >> UPDATE ps_product_lang SET name = 'MINISTERO ORDINATO - E. CASTELLUCCI', description = '' WHERE id_product = '12104' 09/11/2024 09:57:35 am >> UPDATE ps_product SET wholesale_price = '18.20', on_sale = '0', price = '26.0000' WHERE id_product = '12104' 09/11/2024 09:57:35 am >> UPDATE ps_product_shop SET wholesale_price = '18.20', price = '26.0000', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12104' 09/11/2024 09:57:35 am >> DELETE FROM ps_specific_price WHERE id_product = '12104' 09/11/2024 10:27:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3403' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 10:27:09 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' , '3403' , '2024-11-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.06' , '17.92' , NOW() , NOW() ) 09/11/2024 10:27:09 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 = '94160' 09/11/2024 10:27:09 am >> DELETE FROM ps_document_detail WHERE id_document = '94160' 09/11/2024 10:27:09 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 ( '94160' , '10751' , 'TU MI PERDONI' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 09/11/2024 10:27:09 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 ( '94160' , '14323' , 'RELIGIOCANDO - ANTICO TESTAMENTO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 09/11/2024 10:27:09 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 ( '94160' , '8855' , 'REGISTRO DEL CATECHISTA' , '1' , '-1' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '0.75' ) 09/11/2024 10:27:09 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 ( '94160' , '18550' , 'SEGNO DI CROCE' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 09/11/2024 10:27:09 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 ( '94160' , '20208' , 'SEGNI DELLA MESSA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 09/11/2024 10:28:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3404' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 10:28:17 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' , '3404' , '2024-11-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.66' , '4.66' , NOW() , NOW() ) 09/11/2024 10:28:17 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 = '94161' 09/11/2024 10:28:17 am >> DELETE FROM ps_document_detail WHERE id_document = '94161' 09/11/2024 10:28:17 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 ( '94161' , '22891' , 'PAROLA CHE DA VITA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 09/11/2024 10:40:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3405' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 10:40:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3405' , '2024-11-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.53' , '15.53' , NOW() , NOW() ) 09/11/2024 10:40:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94162' 09/11/2024 10:40:21 am >> DELETE FROM ps_document_detail WHERE id_document = '94162' 09/11/2024 10:40:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94162' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 09/11/2024 10:40:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94162' , '23092' , 'SPERANZA CHE E IN NOI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 09/11/2024 10:40:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94162' , '23135' , 'SUSSIDIO AVVENTO E NATALE 2024/25 RAGAZZI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 09/11/2024 10:40:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94162' , '23014' , 'GIUBILEO 2025 - SUSSIDIO RAGAZZI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 09/11/2024 10:40:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94162' , '22979' , 'SCOPRIAMO INSIEME IL GIUBILEO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 09/11/2024 10:42:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3406' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 10:42:32 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' , '3406' , '2024-11-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '152.90' , '125.33' , NOW() , NOW() ) 09/11/2024 10:42:32 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 = '94163' 09/11/2024 10:42:32 am >> DELETE FROM ps_document_detail WHERE id_document = '94163' 09/11/2024 10:42:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94163' , '13609' , 'APPENDICHIAVI 12X12' , '1' , '-1' , '1' , '15.90' , '13.032786885246' , '22' , '0' , '15.90' ) 09/11/2024 10:42:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94163' , '19997' , 'GESU BAMBINO CM 34 - BJ140-34E' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 09/11/2024 10:42:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94163' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '22' , '18.032786885246' , '22' , '0' , '22.00' ) 09/11/2024 10:42:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94163' , '17575' , 'GRUPPO NATIVITA RESINA CM 25 - ' , '1' , '-1' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '60.00' ) 09/11/2024 10:48:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3407' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 10:48:17 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' , '3407' , '2024-11-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.99' , NOW() , NOW() ) 09/11/2024 10:48:17 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 = '94164' 09/11/2024 10:48:17 am >> DELETE FROM ps_document_detail WHERE id_document = '94164' 09/11/2024 10:48:17 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 ( '94164' , '20003' , 'GESU BAMBINO CM 4 - BJ140-4E' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 09/11/2024 10:48:17 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 ( '94164' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.4' , '1.9672131147541' , '22' , '0' , '2.40' ) 09/11/2024 10:48:17 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 ( '94164' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '1' , '-1' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.30' ) 09/11/2024 10:48:17 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 ( '94164' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '1' , '-1' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '0.40' ) 09/11/2024 10:48:17 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 ( '94164' , '11644' , 'PICCOLA GUIDA ALLA CONFESSIONE' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 09/11/2024 10:48:17 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 ( '94164' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 09/11/2024 10:48:17 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 ( '94164' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/11/2024 11:05:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3408' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 11:05:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3408' , '2024-11-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '16.00' , NOW() , NOW() ) 09/11/2024 11:05:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94165' 09/11/2024 11:05:42 am >> DELETE FROM ps_document_detail WHERE id_document = '94165' 09/11/2024 11:05:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94165' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.140' , '2.14' , '0' , '0' , '2.14' ) 09/11/2024 11:05:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94165' , '23112' , 'CONOSCI TE STESSO - C. AMIRANTE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 09/11/2024 11:05:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94165' , '22698' , 'CALENDARIO LITURGICO 2025' , '2' , '-2' , '4' , '0.80' , '0.8' , '0' , '0' , '1.60' ) 09/11/2024 11:07:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3407' AND id_document != '94164' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 11:07:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3407', document_date = '2024-11-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '11.00', price_tax_excluded = '9.99', date_upd = NOW() WHERE id_document = '94164' 09/11/2024 11:07:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94164' 09/11/2024 11:07:31 am >> DELETE FROM ps_document_detail WHERE id_document = '94164' 09/11/2024 11:07:31 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 ( '94164' , '20003' , 'GESU BAMBINO CM 4 - BJ140-4E' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 09/11/2024 11:07:31 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 ( '94164' , '19073' , 'BAMBINELLO CM 4,5 - PB0501' , '1' , '-1' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '2.40' ) 09/11/2024 11:07:31 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 ( '94164' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '1' , '-1' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '0.30' ) 09/11/2024 11:07:31 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 ( '94164' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '1' , '-1' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '0.40' ) 09/11/2024 11:07:31 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 ( '94164' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.9' , '1.9' , '0' , '0' , '1.90' ) 09/11/2024 11:07:31 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 ( '94164' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 09/11/2024 11:07:31 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 ( '94164' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 09/11/2024 11:19:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3409' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 11:19:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3409' , '2024-11-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.13' , '38.13' , NOW() , NOW() ) 09/11/2024 11:19:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94166' 09/11/2024 11:19:15 am >> DELETE FROM ps_document_detail WHERE id_document = '94166' 09/11/2024 11:19:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94166' , '2440' , 'COLORO IL MIO GESÙ' , '2' , '-2' , '4' , '4.90' , '4.9' , '0' , '5' , '9.32' ) 09/11/2024 11:19:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94166' , '5559' , 'LASCIATE CHE I BAMBINI VENGANO A ME' , '2' , '-2' , '4' , '5.50' , '5.5' , '0' , '5' , '10.46' ) 09/11/2024 11:19:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94166' , '13956' , 'MIRACOLI DI GESU' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 09/11/2024 11:19:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94166' , '7543' , 'PARABOLE DI GESÙ' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 09/11/2024 11:19:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94166' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 09/11/2024 11:19:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94166' , '13782' , 'TI RACCONTO LA VITA DI GESU - A. MAINARDI' , '2' , '-2' , '4' , '4.90' , '4.9' , '0' , '5' , '9.32' ) 09/11/2024 11:24:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3410' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 11:24:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3410' , '2024-11-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.72' , '38.67' , NOW() , NOW() ) 09/11/2024 11:24:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94167' 09/11/2024 11:24:37 am >> DELETE FROM ps_document_detail WHERE id_document = '94167' 09/11/2024 11:24:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94167' , '20038' , 'ALLA RICERCA DEL NATALE PERDUTO - CD' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '5' , '12.83' ) 09/11/2024 11:24:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94167' , '22903' , 'INCONFONDIBILE SAPONE DEL NATALE - CD' , '1' , '-1' , '1' , '11.50' , '9.4262295081967' , '22' , '5' , '10.93' ) 09/11/2024 11:24:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94167' , '22904' , 'INCONFONDIBILE SAPONE DEL NATALE - SPARTITO' , '1' , '-1' , '3' , '10.50' , '10.096153846154' , '4' , '5' , '9.98' ) 09/11/2024 11:24:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94167' , '20039' , 'ALLA RICERCA DEL NATALE PERDUTO - SPARTITO' , '1' , '-1' , '3' , '10.50' , '10.096153846154' , '4' , '5' , '9.98' ) 09/11/2024 11:29:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256390588' AND id_product != '22987' AND ean13 != '' 09/11/2024 11:29:06 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9791256390588', date_upd = NOW() WHERE id_product = '22987' 09/11/2024 11:29:06 am >> UPDATE ps_product_lang SET name = 'GIUSEPPE MOSCATI - 8744', description = '' WHERE id_product = '22987' 09/11/2024 11:29:06 am >> UPDATE ps_product SET wholesale_price = '1.80', on_sale = '0', price = '3.0000' WHERE id_product = '22987' 09/11/2024 11:29:06 am >> UPDATE ps_product_shop SET wholesale_price = '1.80', price = '3.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22987' 09/11/2024 11:29:06 am >> DELETE FROM ps_specific_price WHERE id_product = '22987' 09/11/2024 11:43:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867572465' AND id_product != '22979' AND ean13 != '' 09/11/2024 11:43:52 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788867572465', date_upd = NOW() WHERE id_product = '22979' 09/11/2024 11:43:52 am >> UPDATE ps_product_lang SET name = 'SCOPRIAMO INSIEME IL GIUBILEO', description = '' WHERE id_product = '22979' 09/11/2024 11:43:53 am >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '4.9000' WHERE id_product = '22979' 09/11/2024 11:43:53 am >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '4.9000', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22979' 09/11/2024 11:43:53 am >> DELETE FROM ps_specific_price WHERE id_product = '22979' 09/11/2024 11:53:02 am >> SELECT document_num FROM ps_document WHERE document_num = '120/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 11:53: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 ( '24' , '120/A' , '2024-11-09' , 'A' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.42' , '81.42' , NOW() , NOW() ) 09/11/2024 11:53: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 = '94168' 09/11/2024 11:53:02 am >> DELETE FROM ps_document_detail WHERE id_document = '94168' 09/11/2024 11:53: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 ( '94168' , '22956' , 'GENERATI MEDIANTE IL VANGELO - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 09/11/2024 11:53: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 ( '94168' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 09/11/2024 11:53: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 ( '94168' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 09/11/2024 11:53: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 ( '94168' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 09/11/2024 11:53: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 ( '94168' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 09/11/2024 11:53: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 ( '94168' , '' , 'CAMPANA PRESEPE' , '1' , '-1' , '4' , '40' , '40' , '0' , '0' , '40.00' ) 09/11/2024 11:53: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 ( '94168' , '' , 'COMPLETO PER DON EGIDIO' , '1' , '-1' , '4' , '0' , '0' , '0' , '0' , '0' ) 09/11/2024 12:04:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3411' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 12:04: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' , '3411' , '2024-11-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.41' , '12.69' , NOW() , NOW() ) 09/11/2024 12:04: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 = '94169' 09/11/2024 12:04:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '94169' 09/11/2024 12:04: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 ( '94169' , '20925' , 'INTORNO A UNA STORIA' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 09/11/2024 12:04: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 ( '94169' , '16312' , 'DECINA LEGNO CHIARO' , '5' , '-5' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '3.00' ) 09/11/2024 12:04: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 ( '94169' , '19231' , 'CARD CARLO ACUTIS - RN93' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 09/11/2024 12:07:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3412' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 12:07:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3412' , '2024-11-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 09/11/2024 12:07:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94170' 09/11/2024 12:07:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '94170' 09/11/2024 12:07:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94170' , '1914' , 'CERA DELLA LITURGIA' , '10' , '-10' , '1' , '4.9' , '4.016393442623' , '22' , '0' , '49.00' ) 09/11/2024 12:40:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002310' AND id_product != '23082' AND ean13 != '' 09/11/2024 12:40:32 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '002310', date_upd = NOW() WHERE id_product = '23082' 09/11/2024 12:40:32 pm >> UPDATE ps_product_lang SET name = 'CAMICE RAGLAN CERNIERA DAVANTI - CA01', description = '' WHERE id_product = '23082' 09/11/2024 12:40:32 pm >> UPDATE ps_product SET wholesale_price = '21.90', on_sale = '0', price = '45.0820' WHERE id_product = '23082' 09/11/2024 12:40:32 pm >> UPDATE ps_product_shop SET wholesale_price = '21.90', price = '45.0820', 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 = '23082' 09/11/2024 12:40:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '23082' 09/11/2024 12:41:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3413' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 12:41:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3413' , '2024-11-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.50' , '44.48' , NOW() , NOW() ) 09/11/2024 12:41:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94171' 09/11/2024 12:41:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '94171' 09/11/2024 12:41: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 ( '94171' , '23082' , 'CAMICE RAGLAN CERNIERA DAVANTI - CA01' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 09/11/2024 12:41: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 ( '94171' , '23106' , 'DILEXIT NOS' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 09/11/2024 12:42:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3414' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-09') 09/11/2024 12:42:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3414' , '2024-11-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.76' , '3.76' , NOW() , NOW() ) 09/11/2024 12:42: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 = '94172' 09/11/2024 12:42:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '94172' 09/11/2024 12:42: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 ( '94172' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 09/11/2024 12:42: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 ( '94172' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' )