08/05/2024 09:26:44 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 08/05/2024 09:26:44 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', 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 = '30.90', price_tax_excluded = '30.90', date_upd = NOW() WHERE id_document = '89846' 08/05/2024 09:26:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89846' 08/05/2024 09:26:44 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 08/05/2024 09:26:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22474' , 'PAROLA E PREGHIERA - LUG 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 08/05/2024 09:26:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '19892' , 'SALVE, REGINA - S. HAHN' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 08/05/2024 09:26:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 08/05/2024 09:26:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22214' , 'VIE DI MARIA - F. DE CRISTOFARO' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 08/05/2024 09:43:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1480' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 09:43:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1480' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 08/05/2024 09:43: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 = '91674' 08/05/2024 09:43:31 am >> DELETE FROM ps_document_detail WHERE id_document = '91674' 08/05/2024 09:43: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 ( '91674' , '21558' , 'ANELLO DECINA ARG - M043' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 08/05/2024 09:46:18 am >> SELECT document_num FROM ps_document WHERE document_num = '9/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 09:46:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '9/L' , '2024-05-08' , 'L' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA UNIVERSITA\'' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '68.50' , '58.63' , NOW() , NOW() ) 08/05/2024 09:46:18 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 = '91675' 08/05/2024 09:46:18 am >> DELETE FROM ps_document_detail WHERE id_document = '91675' 08/05/2024 09:46:18 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 ( '91675' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 08/05/2024 09:46:18 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 ( '91675' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 08/05/2024 09:53:56 am >> SELECT document_num FROM ps_document WHERE document_num = '1481' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 09:53:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1481' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.25' , '60.30' , NOW() , NOW() ) 08/05/2024 09:53:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91676' 08/05/2024 09:53:56 am >> DELETE FROM ps_document_detail WHERE id_document = '91676' 08/05/2024 09:53: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 ( '91676' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 08/05/2024 09:53: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 ( '91676' , '21583' , 'CUSTODIA PELLE LITURGIA DELLE ORE - 731' , '1' , '-1' , '1' , '33.00' , '27.049180327869' , '22' , '0' , '33.00' ) 08/05/2024 09:55:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1482' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 09:55:10 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' , '1482' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '157.00' , '132.66' , NOW() , NOW() ) 08/05/2024 09:55:10 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 = '91677' 08/05/2024 09:55:10 am >> DELETE FROM ps_document_detail WHERE id_document = '91677' 08/05/2024 09:55:10 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 ( '91677' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 08/05/2024 09:55:10 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 ( '91677' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 08/05/2024 09:55:10 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 ( '91677' , '22506' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 08/05/2024 09:55:10 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 ( '91677' , '16864' , 'CROCIFISSO SAGOMATO 40X25 - 104062' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 08/05/2024 09:58:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1483' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 09:58:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1483' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.00' , '64.75' , NOW() , NOW() ) 08/05/2024 09:58:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91678' 08/05/2024 09:58:38 am >> DELETE FROM ps_document_detail WHERE id_document = '91678' 08/05/2024 09:58:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91678' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 08/05/2024 10:07:36 am >> SELECT document_num FROM ps_document WHERE document_num = '145/A' AND id_document != '89628' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-21') 08/05/2024 10:07:36 am >> UPDATE ps_document SET id_document_type = '24', document_num = '145/A', document_date = '2023-12-21', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTO € 150 + 100 per cero pasquale', 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 = '684.00', price_tax_excluded = '623.77', date_upd = NOW() WHERE id_document = '89628' 08/05/2024 10:07:36 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 = '89628' 08/05/2024 10:07:36 am >> DELETE FROM ps_document_detail WHERE id_document = '89628' 08/05/2024 10:07:36 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 ( '89628' , '0' , 'PRESEPE ANTICO' , '1' , '-1' , '0' , '350.0000' , '350' , '0' , '0' , '350.00' ) 08/05/2024 10:07:36 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 ( '89628' , '19077' , 'GRUPPO NATIVITA STOFFA CM 30 - PB18552 ++ campana 25x40' , '1' , '-1' , '1' , '160.0000' , '131.14754098361' , '22' , '0' , '160.00' ) 08/05/2024 10:07:36 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 ( '89628' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '150.0000' , '122.95081967213' , '22' , '0' , '150.00' ) 08/05/2024 10:07:36 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 ( '89628' , '4991' , 'SAN PIO DA PIETRELCINA - 315' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 08/05/2024 10:07:36 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 ( '89628' , '14136' , 'MADONNA DEL ROSARIO DI POMPEI - 125' , '3' , '-3' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '10.50' ) 08/05/2024 10:07:36 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 ( '89628' , '' , 'SUPPLICA' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 08/05/2024 10:16:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1484' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 10:16: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 ( '11' , '1484' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.80' , '1.48' , NOW() , NOW() ) 08/05/2024 10:16: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 = '91679' 08/05/2024 10:16:54 am >> DELETE FROM ps_document_detail WHERE id_document = '91679' 08/05/2024 10:16: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 ( '91679' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 08/05/2024 10:16: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 ( '91679' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 08/05/2024 10:26:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1485' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 10:26:12 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' , '1485' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 08/05/2024 10:26:12 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 = '91680' 08/05/2024 10:26:12 am >> DELETE FROM ps_document_detail WHERE id_document = '91680' 08/05/2024 10:26:12 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 ( '91680' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 08/05/2024 10:36:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892226104' AND id_product != '18609' AND ean13 != '' 08/05/2024 10:36:02 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788892226104', date_upd = NOW() WHERE id_product = '18609' 08/05/2024 10:36:02 am >> UPDATE ps_product_lang SET name = 'BUSSOLA DI ABRAMO - G. MATARAZZO', description = '' WHERE id_product = '18609' 08/05/2024 10:36:02 am >> UPDATE ps_product SET wholesale_price = '12.06', on_sale = '0', price = '18.0000' WHERE id_product = '18609' 08/05/2024 10:36:02 am >> UPDATE ps_product_shop SET wholesale_price = '12.06', price = '18.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18609' 08/05/2024 10:36:02 am >> DELETE FROM ps_specific_price WHERE id_product = '18609' 08/05/2024 10:36:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856664492' AND id_product != '15021' AND ean13 != '' 08/05/2024 10:36:33 am >> UPDATE ps_product SET id_supplier = '114', reference = '6/6', ean13 = '9788856664492', date_upd = NOW() WHERE id_product = '15021' 08/05/2024 10:36:33 am >> UPDATE ps_product_lang SET name = 'VIVERE PER SEMPRE - V. PAGLIA', description = '' WHERE id_product = '15021' 08/05/2024 10:36:33 am >> UPDATE ps_product SET wholesale_price = '12.43', on_sale = '0', price = '17.5000' WHERE id_product = '15021' 08/05/2024 10:36:33 am >> UPDATE ps_product_shop SET wholesale_price = '12.43', price = '17.5000', id_tax_rules_group = '4', id_category_default = '70', 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 = '15021' 08/05/2024 10:36:33 am >> DELETE FROM ps_specific_price WHERE id_product = '15021' 08/05/2024 10:36:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253445' AND id_product != '21487' AND ean13 != '' 08/05/2024 10:36:48 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9791281253445', date_upd = NOW() WHERE id_product = '21487' 08/05/2024 10:36:48 am >> UPDATE ps_product_lang SET name = 'SEI UN MITO - L. GALBIATI', description = '' WHERE id_product = '21487' 08/05/2024 10:36:48 am >> UPDATE ps_product SET wholesale_price = '8.40', on_sale = '0', price = '12.0000' WHERE id_product = '21487' 08/05/2024 10:36:48 am >> UPDATE ps_product_shop SET wholesale_price = '8.40', price = '12.0000', id_tax_rules_group = '4', id_category_default = '518', 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 = '21487' 08/05/2024 10:36:48 am >> DELETE FROM ps_specific_price WHERE id_product = '21487' 08/05/2024 10:37:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884248008' AND id_product != '21814' AND ean13 != '' 08/05/2024 10:37:03 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788884248008', date_upd = NOW() WHERE id_product = '21814' 08/05/2024 10:37:03 am >> UPDATE ps_product_lang SET name = 'VIVERE IL LUTTO INSIEME A DIO - C. GALATOLO', description = '' WHERE id_product = '21814' 08/05/2024 10:37:03 am >> UPDATE ps_product SET wholesale_price = '9.80', on_sale = '0', price = '14.0000' WHERE id_product = '21814' 08/05/2024 10:37:03 am >> UPDATE ps_product_shop SET wholesale_price = '9.80', price = '14.0000', id_tax_rules_group = '4', id_category_default = '83', 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 = '21814' 08/05/2024 10:37:03 am >> DELETE FROM ps_specific_price WHERE id_product = '21814' 08/05/2024 10:37:03 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 = '21814' 08/05/2024 10:37:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22509' , '1' , '' , 'nuovo-prodotto' ) 08/05/2024 10:37:03 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 '22509' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21814' 08/05/2024 10:37:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22509' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21814' 08/05/2024 10:37:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873576150' AND id_product != '12600' AND ean13 != '' 08/05/2024 10:37:20 am >> UPDATE ps_product SET id_supplier = '65', reference = '6/6', ean13 = '9788873576150', date_upd = NOW() WHERE id_product = '12600' 08/05/2024 10:37:20 am >> UPDATE ps_product_lang SET name = 'SUL MALE - J. HERNANDEZ', description = '' WHERE id_product = '12600' 08/05/2024 10:37:20 am >> UPDATE ps_product SET wholesale_price = '1.30', on_sale = '0', price = '2.0000' WHERE id_product = '12600' 08/05/2024 10:37:20 am >> UPDATE ps_product_shop SET wholesale_price = '1.30', price = '2.0000', id_tax_rules_group = '4', id_category_default = '178', 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 = '12600' 08/05/2024 10:37:20 am >> DELETE FROM ps_specific_price WHERE id_product = '12600' 08/05/2024 10:37:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242845' AND id_product != '21628' AND ean13 != '' 08/05/2024 10:37:48 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788892242845', date_upd = NOW() WHERE id_product = '21628' 08/05/2024 10:37:48 am >> UPDATE ps_product_lang SET name = 'DOVE VA LA CHIESA? - E. BIANCHI', description = '' WHERE id_product = '21628' 08/05/2024 10:37:48 am >> UPDATE ps_product SET wholesale_price = '12.06', on_sale = '0', price = '18.0000' WHERE id_product = '21628' 08/05/2024 10:37:48 am >> UPDATE ps_product_shop SET wholesale_price = '12.06', price = '18.0000', id_tax_rules_group = '4', id_category_default = '30', 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 = '21628' 08/05/2024 10:37:48 am >> DELETE FROM ps_specific_price WHERE id_product = '21628' 08/05/2024 10:38:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869299605' AND id_product != '21341' AND ean13 != '' 08/05/2024 10:38:04 am >> UPDATE ps_product SET id_supplier = '109', reference = '6/6', ean13 = '9788869299605', date_upd = NOW() WHERE id_product = '21341' 08/05/2024 10:38:04 am >> UPDATE ps_product_lang SET name = 'IMPARANDO DALLE DONNE - F. CERAGIOLI', description = '' WHERE id_product = '21341' 08/05/2024 10:38:04 am >> UPDATE ps_product SET wholesale_price = '9.75', on_sale = '0', price = '15.0000' WHERE id_product = '21341' 08/05/2024 10:38:04 am >> UPDATE ps_product_shop SET wholesale_price = '9.75', price = '15.0000', 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 = '21341' 08/05/2024 10:38:04 am >> DELETE FROM ps_specific_price WHERE id_product = '21341' 08/05/2024 10:38:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869299131' AND id_product != '21553' AND ean13 != '' 08/05/2024 10:38:17 am >> UPDATE ps_product SET id_supplier = '109', reference = '6/6', ean13 = '9788869299131', date_upd = NOW() WHERE id_product = '21553' 08/05/2024 10:38:17 am >> UPDATE ps_product_lang SET name = 'SCOPRIRE IL VANGELO IN UN WEEKEND - J. FABRE', description = '' WHERE id_product = '21553' 08/05/2024 10:38:17 am >> UPDATE ps_product SET wholesale_price = '9.10', on_sale = '0', price = '14.0000' WHERE id_product = '21553' 08/05/2024 10:38:17 am >> UPDATE ps_product_shop SET wholesale_price = '9.10', price = '14.0000', 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 = '21553' 08/05/2024 10:38:17 am >> DELETE FROM ps_specific_price WHERE id_product = '21553' 08/05/2024 10:38:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839929709' AND id_product != '21162' AND ean13 != '' 08/05/2024 10:38:33 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788839929709', date_upd = NOW() WHERE id_product = '21162' 08/05/2024 10:38:33 am >> UPDATE ps_product_lang SET name = 'MARIA DI MAGDALA - C. REYNIER', description = '' WHERE id_product = '21162' 08/05/2024 10:38:33 am >> UPDATE ps_product SET wholesale_price = '14.70', on_sale = '0', price = '21.0000' WHERE id_product = '21162' 08/05/2024 10:38:33 am >> UPDATE ps_product_shop SET wholesale_price = '14.70', price = '21.0000', id_tax_rules_group = '4', id_category_default = '111', 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 = '21162' 08/05/2024 10:38:33 am >> DELETE FROM ps_specific_price WHERE id_product = '21162' 08/05/2024 10:38:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825056167' AND id_product != '21163' AND ean13 != '' 08/05/2024 10:38:46 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788825056167', date_upd = NOW() WHERE id_product = '21163' 08/05/2024 10:38:46 am >> UPDATE ps_product_lang SET name = 'BRICIOLE POVERE DI UN PANE - F. FARRONATO', description = '' WHERE id_product = '21163' 08/05/2024 10:38:46 am >> UPDATE ps_product SET wholesale_price = '9.10', on_sale = '0', price = '13.0000' WHERE id_product = '21163' 08/05/2024 10:38:46 am >> UPDATE ps_product_shop SET wholesale_price = '9.10', price = '13.0000', id_tax_rules_group = '4', id_category_default = '17', 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 = '21163' 08/05/2024 10:38:46 am >> DELETE FROM ps_specific_price WHERE id_product = '21163' 08/05/2024 10:38:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788827011348' AND id_product != '14982' AND ean13 != '' 08/05/2024 10:38:59 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788827011348', date_upd = NOW() WHERE id_product = '14982' 08/05/2024 10:38:59 am >> UPDATE ps_product_lang SET name = 'NEL SILENZIO PARLAMI - F. DE LAZZARI', description = '' WHERE id_product = '14982' 08/05/2024 10:38:59 am >> UPDATE ps_product SET wholesale_price = '8.40', on_sale = '0', price = '12.0000' WHERE id_product = '14982' 08/05/2024 10:38:59 am >> UPDATE ps_product_shop SET wholesale_price = '8.40', price = '12.0000', id_tax_rules_group = '4', id_category_default = '186', 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 = '14982' 08/05/2024 10:38:59 am >> DELETE FROM ps_specific_price WHERE id_product = '14982' 08/05/2024 10:39:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242005' AND id_product != '21167' AND ean13 != '' 08/05/2024 10:39:11 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788892242005', date_upd = NOW() WHERE id_product = '21167' 08/05/2024 10:39:11 am >> UPDATE ps_product_lang SET name = 'CARISMI PER TUTTI - FRA DANIEL M.', description = '' WHERE id_product = '21167' 08/05/2024 10:39:11 am >> UPDATE ps_product SET wholesale_price = '12.06', on_sale = '0', price = '18.0000' WHERE id_product = '21167' 08/05/2024 10:39:11 am >> UPDATE ps_product_shop SET wholesale_price = '12.06', price = '18.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21167' 08/05/2024 10:39:11 am >> DELETE FROM ps_specific_price WHERE id_product = '21167' 08/05/2024 10:39:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280546456' AND id_product != '20844' AND ean13 != '' 08/05/2024 10:39:25 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9791280546456', date_upd = NOW() WHERE id_product = '20844' 08/05/2024 10:39:25 am >> UPDATE ps_product_lang SET name = 'SE LO DICE GESU\' - G. AGAGLIATI', description = '' WHERE id_product = '20844' 08/05/2024 10:39:25 am >> UPDATE ps_product SET wholesale_price = '7.00', on_sale = '0', price = '10.0000' WHERE id_product = '20844' 08/05/2024 10:39:25 am >> UPDATE ps_product_shop SET wholesale_price = '7.00', price = '10.0000', id_tax_rules_group = '4', id_category_default = '483', 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 = '20844' 08/05/2024 10:39:25 am >> DELETE FROM ps_specific_price WHERE id_product = '20844' 08/05/2024 10:39:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831148764' AND id_product != '21451' AND ean13 != '' 08/05/2024 10:39:40 am >> UPDATE ps_product SET id_supplier = '109', reference = '6/6', ean13 = '9788831148764', date_upd = NOW() WHERE id_product = '21451' 08/05/2024 10:39:40 am >> UPDATE ps_product_lang SET name = 'UNA SPIRITUALITA\' ECCLESIALE - G. ROSSE\'', description = '' WHERE id_product = '21451' 08/05/2024 10:39:40 am >> UPDATE ps_product SET wholesale_price = '11.64', on_sale = '0', price = '17.9000' WHERE id_product = '21451' 08/05/2024 10:39:40 am >> UPDATE ps_product_shop SET wholesale_price = '11.64', price = '17.9000', id_tax_rules_group = '4', id_category_default = '13', 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 = '21451' 08/05/2024 10:39:40 am >> DELETE FROM ps_specific_price WHERE id_product = '21451' 08/05/2024 10:39:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983776' AND id_product != '18052' AND ean13 != '' 08/05/2024 10:39:56 am >> UPDATE ps_product SET id_supplier = '145', reference = '6/6', ean13 = '9788895983776', date_upd = NOW() WHERE id_product = '18052' 08/05/2024 10:39:56 am >> UPDATE ps_product_lang SET name = 'CONVERSAZIONI CON MADRE TERESA - GJERGJI', description = '

Nel 5° anniversario del Concistoro Ordinario Pubblico, convocato da papa Francesco il 15 marzo 2016, per la Canonizzazione di Agnese Gonxha Bojaxhiu. (Madre Teresa) pubblichiamo le interviste esclusive raccolte in diversi Paesi e circostanze, nonché quelle rilasciate durante le sue cinque visite in Kosovo e il discorso tenuto per l’accettazione del Premio Nobel per la Pace (1979), con fotografie, parole, messaggi, discorsi, orientamenti, definizioni, visioni lungimiranti e profetiche: una sorta di testamento spirituale per tutti noi.

' WHERE id_product = '18052' 08/05/2024 10:39:56 am >> UPDATE ps_product SET wholesale_price = '2.60', on_sale = '0', price = '12.0000' WHERE id_product = '18052' 08/05/2024 10:39:56 am >> UPDATE ps_product_shop SET wholesale_price = '2.60', price = '12.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '23', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18052' 08/05/2024 10:39:56 am >> DELETE FROM ps_specific_price WHERE id_product = '18052' 08/05/2024 10:39:56 am >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '18052' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 08/05/2024 10:40:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554268' AND id_product != '18538' AND ean13 != '' 08/05/2024 10:40:09 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788831554268', date_upd = NOW() WHERE id_product = '18538' 08/05/2024 10:40:09 am >> UPDATE ps_product_lang SET name = 'PRESBITERIO - M. D\'AGOSTINO', description = '' WHERE id_product = '18538' 08/05/2024 10:40:09 am >> UPDATE ps_product SET wholesale_price = '7.37', on_sale = '0', price = '11.0000' WHERE id_product = '18538' 08/05/2024 10:40:09 am >> UPDATE ps_product_shop SET wholesale_price = '7.37', price = '11.0000', id_tax_rules_group = '4', id_category_default = '27', 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 = '18538' 08/05/2024 10:40:09 am >> DELETE FROM ps_specific_price WHERE id_product = '18538' 08/05/2024 11:10:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000327' AND id_product != '8147' AND ean13 != '' 08/05/2024 11:10:40 am >> UPDATE ps_product SET id_supplier = '77', reference = '2013', ean13 = '000327', date_upd = NOW() WHERE id_product = '8147' 08/05/2024 11:10:40 am >> UPDATE ps_product_lang SET name = 'POLO BASIC', description = '' WHERE id_product = '8147' 08/05/2024 11:10:40 am >> UPDATE ps_product SET wholesale_price = '10.50', on_sale = '0', price = '24.59016393442623' WHERE id_product = '8147' 08/05/2024 11:10:40 am >> UPDATE ps_product_shop SET wholesale_price = '10.50', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '253', 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 = '8147' 08/05/2024 11:10:40 am >> DELETE FROM ps_specific_price WHERE id_product = '8147' 08/05/2024 11:12:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000851' AND id_product != '8082' AND ean13 != '' 08/05/2024 11:12:53 am >> UPDATE ps_product SET id_supplier = '77', reference = '2016', ean13 = '000851', date_upd = NOW() WHERE id_product = '8082' 08/05/2024 11:12:53 am >> UPDATE ps_product_lang SET name = 'POLO LIMITED ', description = '' WHERE id_product = '8082' 08/05/2024 11:12:53 am >> UPDATE ps_product SET wholesale_price = '12.00', on_sale = '0', price = '27.049180327868854' WHERE id_product = '8082' 08/05/2024 11:12:53 am >> UPDATE ps_product_shop SET wholesale_price = '12.00', price = '27.049180327868854', id_tax_rules_group = '1', id_category_default = '253', 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 = '8082' 08/05/2024 11:12:53 am >> DELETE FROM ps_specific_price WHERE id_product = '8082' 08/05/2024 11:13:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000853' AND id_product != '8079' AND ean13 != '' 08/05/2024 11:13:13 am >> UPDATE ps_product SET id_supplier = '', reference = '2016', ean13 = '000853', date_upd = NOW() WHERE id_product = '8079' 08/05/2024 11:13:13 am >> UPDATE ps_product_lang SET name = 'POLO LIMITED EXTRA', description = '' WHERE id_product = '8079' 08/05/2024 11:13:13 am >> UPDATE ps_product SET wholesale_price = '13.10', on_sale = '0', price = '28.688524590163937' WHERE id_product = '8079' 08/05/2024 11:13:13 am >> UPDATE ps_product_shop SET wholesale_price = '13.10', price = '28.688524590163937', id_tax_rules_group = '1', id_category_default = '253', 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 = '8079' 08/05/2024 11:13:13 am >> DELETE FROM ps_specific_price WHERE id_product = '8079' 08/05/2024 11:42:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1486' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 11:42: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 ( '11' , '1486' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.30' , '21.44' , NOW() , NOW() ) 08/05/2024 11:42: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 = '91681' 08/05/2024 11:42:24 am >> DELETE FROM ps_document_detail WHERE id_document = '91681' 08/05/2024 11:42: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 ( '91681' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 08/05/2024 11:42: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 ( '91681' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 08/05/2024 11:42: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 ( '91681' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 08/05/2024 11:42:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1487' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 11:42:46 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' , '1487' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.00' , '44.26' , NOW() , NOW() ) 08/05/2024 11:42:46 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 = '91682' 08/05/2024 11:42:46 am >> DELETE FROM ps_document_detail WHERE id_document = '91682' 08/05/2024 11:42:46 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 ( '91682' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '36' , '-36' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '54.00' ) 08/05/2024 12:09:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1488' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 12:09:11 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' , '1488' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '173.80' , '143.88' , NOW() , NOW() ) 08/05/2024 12:09:11 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 = '91683' 08/05/2024 12:09:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '91683' 08/05/2024 12:09:11 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 ( '91683' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 08/05/2024 12:09:11 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 ( '91683' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 08/05/2024 12:09:11 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 ( '91683' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 08/05/2024 12:09:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1489' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 12:09:51 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' , '1489' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '77.87' , NOW() , NOW() ) 08/05/2024 12:09:51 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 = '91684' 08/05/2024 12:09:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '91684' 08/05/2024 12:09: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 ( '91684' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 08/05/2024 12:09: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 ( '91684' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 08/05/2024 12:14:10 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' , '351' , '2024-05-02' , '' , '0' , '163' , '4674530' , 'VIA CORTI 29 24126 BERGAMO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '384.30' , '315.00' , NOW() , NOW() ) 08/05/2024 12:14: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 = '91685' 08/05/2024 12:14:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '91685' 08/05/2024 12:14: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 ( '91685' , '22470' , 'COTTA - 989P/ML/2' , '1' , '1' , '1' , '105' , '86.065573770492' , '22' , '0' , '128.1000' ) 08/05/2024 12:14:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22470' AND id_supplier = '163' 08/05/2024 12:14:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22470' , '163' , '1' ) 08/05/2024 12:14:11 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 ( '91685' , '19791' , 'STOLA IN LANA BALZA CON RICAMO - 661' , '5' , '5' , '1' , '42' , '34.426229508197' , '22' , '0' , '256.2000' ) 08/05/2024 12:14:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19791' AND id_supplier = '163' 08/05/2024 12:14:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19791' , '163' , '1' ) 08/05/2024 12:20:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1490' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 12:20: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' , '1490' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 08/05/2024 12:20: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 = '91686' 08/05/2024 12:20:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '91686' 08/05/2024 12:20: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 ( '91686' , '3144' , 'CROCE TRILOBATA ' , '2' , '-2' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '9.00' ) 08/05/2024 12:25:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1491' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 12:25:46 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' , '1491' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.00' , '63.93' , NOW() , NOW() ) 08/05/2024 12:25:46 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 = '91687' 08/05/2024 12:25:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '91687' 08/05/2024 12:25:46 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 ( '91687' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 08/05/2024 12:25:46 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 ( '91687' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '28.00' ) 08/05/2024 12:32:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1492' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 12:32: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' , '1492' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 08/05/2024 12:32: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 = '91688' 08/05/2024 12:32:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '91688' 08/05/2024 12:32: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 ( '91688' , '22181' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2024' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 08/05/2024 12:32: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 ( '91688' , '22388' , 'MESSALINO QUOTIDIANO - AGO SET OTT' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 08/05/2024 12:57:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884049308' AND id_product != '22509' AND ean13 != '' 08/05/2024 12:57:38 pm >> UPDATE ps_product SET id_supplier = '', reference = 'espositore shalom', ean13 = '9788884049308', date_upd = NOW() WHERE id_product = '22509' 08/05/2024 12:57:38 pm >> UPDATE ps_product_lang SET name = 'SANTA GEMMA E IL DIAVOLO - 8607', description = '' WHERE id_product = '22509' 08/05/2024 12:57:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '22509' 08/05/2024 12:57:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '106', 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 = '22509' 08/05/2024 12:57:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '22509' 08/05/2024 12:57:57 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' , '7111/00/2024' , '2024-05-07' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '7.75' , '1' , '0' , '0' , '0' , '' , '1' , '0' , '124.06' , '122.35' , NOW() , NOW() ) 08/05/2024 12:57:57 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 = '91689' 08/05/2024 12:57:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '91689' 08/05/2024 12:57: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 ( '91689' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '31' , '31' , '4' , '5.00' , '5' , '0' , '40' , '93.0000' ) 08/05/2024 12:57:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22341' AND id_supplier = '38' 08/05/2024 12:57:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22341' , '38' , '1' ) 08/05/2024 12:57: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 ( '91689' , '6417' , 'MESE DI MAGGIO CON LE GLORIE DI MARIA - 8463' , '3' , '3' , '4' , '9.00' , '9' , '0' , '40' , '16.2000' ) 08/05/2024 12:57:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6417' AND id_supplier = '38' 08/05/2024 12:57:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6417' , '38' , '1' ) 08/05/2024 12:57: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 ( '91689' , '22509' , 'SANTA GEMMA E IL DIAVOLO - 8607' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 08/05/2024 12:57:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22509' AND id_supplier = '38' 08/05/2024 12:57:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22509' , '38' , '1' ) 08/05/2024 03:15:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1493' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 03:15:09 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' , '1493' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.64' , '25.64' , NOW() , NOW() ) 08/05/2024 03:15:09 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 = '91690' 08/05/2024 03:15:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '91690' 08/05/2024 03:15:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91690' , '17257' , 'IO TI BATTEZZO ' , '3' , '-3' , '4' , '1.80' , '1.8' , '0' , '0' , '5.40' ) 08/05/2024 03:15:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91690' , '12253' , 'MIO LIBRO DI PREGHIERE' , '3' , '-3' , '4' , '2.80' , '2.8' , '0' , '5' , '7.98' ) 08/05/2024 03:15:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91690' , '17734' , 'VANGELO E ATTI BAMBINI' , '3' , '-3' , '4' , '3.00' , '3' , '0' , '5' , '8.55' ) 08/05/2024 03:15:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91690' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 08/05/2024 03:34:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1494' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 03:34:57 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' , '1494' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '137.75' , '137.75' , NOW() , NOW() ) 08/05/2024 03:34:57 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 = '91691' 08/05/2024 03:34:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '91691' 08/05/2024 03:34:57 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 ( '91691' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '29' , '-29' , '4' , '5.00' , '5' , '0' , '5' , '137.75' ) 08/05/2024 03:35:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1495' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 03:35:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1495' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 08/05/2024 03:35:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91692' 08/05/2024 03:35:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '91692' 08/05/2024 03:35: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 ( '91692' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 08/05/2024 03:37:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253438' AND id_product != '22388' AND ean13 != '' 08/05/2024 03:37:57 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/4', ean13 = '9791281253438', date_upd = NOW() WHERE id_product = '22388' 08/05/2024 03:37:57 pm >> UPDATE ps_product_lang SET name = 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2024', description = '' WHERE id_product = '22388' 08/05/2024 03:37:57 pm >> UPDATE ps_product SET wholesale_price = '4.20', on_sale = '0', price = '6.0000' WHERE id_product = '22388' 08/05/2024 03:37:57 pm >> UPDATE ps_product_shop SET wholesale_price = '4.20', price = '6.0000', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22388' 08/05/2024 03:37:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '22388' 08/05/2024 03:39:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788817183789' AND id_product != '22214' AND ean13 != '' 08/05/2024 03:39:31 pm >> UPDATE ps_product SET id_supplier = '47', reference = '6/6', ean13 = '9788817183789', date_upd = NOW() WHERE id_product = '22214' 08/05/2024 03:39:31 pm >> UPDATE ps_product_lang SET name = 'VIE DI MARIA - F. DE CRISTOFARO', description = '' WHERE id_product = '22214' 08/05/2024 03:39:31 pm >> UPDATE ps_product SET wholesale_price = '9.10', on_sale = '0', price = '13.0000' WHERE id_product = '22214' 08/05/2024 03:39:31 pm >> UPDATE ps_product_shop SET wholesale_price = '9.10', price = '13.0000', id_tax_rules_group = '4', id_category_default = '239', 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 = '22214' 08/05/2024 03:39:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '22214' 08/05/2024 03:39:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280546517' AND id_product != '20772' AND ean13 != '' 08/05/2024 03:39:47 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9791280546517', date_upd = NOW() WHERE id_product = '20772' 08/05/2024 03:39:47 pm >> UPDATE ps_product_lang SET name = 'VADO E TORNERO\' DA VOI - L. VOZZA', description = '' WHERE id_product = '20772' 08/05/2024 03:39:47 pm >> UPDATE ps_product SET wholesale_price = '7.00', on_sale = '0', price = '10.0000' WHERE id_product = '20772' 08/05/2024 03:39:47 pm >> UPDATE ps_product_shop SET wholesale_price = '7.00', price = '10.0000', id_tax_rules_group = '4', id_category_default = '483', 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 = '20772' 08/05/2024 03:39:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '20772' 08/05/2024 03:39:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243644' AND id_product != '22325' AND ean13 != '' 08/05/2024 03:39:57 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788892243644', date_upd = NOW() WHERE id_product = '22325' 08/05/2024 03:39:57 pm >> UPDATE ps_product_lang SET name = 'PREGHIERA DEI SALMI - R. VIRGILI', description = '' WHERE id_product = '22325' 08/05/2024 03:39:57 pm >> UPDATE ps_product SET wholesale_price = '9.38', on_sale = '0', price = '14.0000' WHERE id_product = '22325' 08/05/2024 03:39:58 pm >> UPDATE ps_product_shop SET wholesale_price = '9.38', price = '14.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22325' 08/05/2024 03:39:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '22325' 08/05/2024 03:40:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892871397' AND id_product != '22321' AND ean13 != '' 08/05/2024 03:40:19 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788892871397', date_upd = NOW() WHERE id_product = '22321' 08/05/2024 03:40:19 pm >> UPDATE ps_product_lang SET name = 'PERDONO CHE GUARISCE - L. PASQUA', description = '' WHERE id_product = '22321' 08/05/2024 03:40:19 pm >> UPDATE ps_product SET wholesale_price = '11.20', on_sale = '0', price = '16.0000' WHERE id_product = '22321' 08/05/2024 03:40:19 pm >> UPDATE ps_product_shop SET wholesale_price = '11.20', price = '16.0000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '78', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22321' 08/05/2024 03:40:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '22321' 08/05/2024 03:40:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555593' AND id_product != '20728' AND ean13 != '' 08/05/2024 03:40:32 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788831555593', date_upd = NOW() WHERE id_product = '20728' 08/05/2024 03:40:32 pm >> UPDATE ps_product_lang SET name = 'OCCHI CHE SI APRONO', description = '' WHERE id_product = '20728' 08/05/2024 03:40:32 pm >> UPDATE ps_product SET wholesale_price = '4.02', on_sale = '0', price = '6.0000' WHERE id_product = '20728' 08/05/2024 03:40:32 pm >> UPDATE ps_product_shop SET wholesale_price = '4.02', price = '6.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20728' 08/05/2024 03:40:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '20728' 08/05/2024 03:40:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243804' AND id_product != '22172' AND ean13 != '' 08/05/2024 03:40:41 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788892243804', date_upd = NOW() WHERE id_product = '22172' 08/05/2024 03:40:41 pm >> UPDATE ps_product_lang SET name = 'NEL GREMBO DELLA PAROLA - R. MANGOLINI', description = '' WHERE id_product = '22172' 08/05/2024 03:40:41 pm >> UPDATE ps_product SET wholesale_price = '12.06', on_sale = '0', price = '18.0000' WHERE id_product = '22172' 08/05/2024 03:40:41 pm >> UPDATE ps_product_shop SET wholesale_price = '12.06', price = '18.0000', 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 = '22172' 08/05/2024 03:40:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '22172' 08/05/2024 03:40:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788881664535' AND id_product != '22195' AND ean13 != '' 08/05/2024 03:40:53 pm >> UPDATE ps_product SET id_supplier = '107', reference = '6/6', ean13 = '9788881664535', date_upd = NOW() WHERE id_product = '22195' 08/05/2024 03:40:53 pm >> UPDATE ps_product_lang SET name = 'MIE NOTTI CON QOHELET - D.M. TUROLDO', description = '' WHERE id_product = '22195' 08/05/2024 03:40:53 pm >> UPDATE ps_product SET wholesale_price = '9.75', on_sale = '0', price = '15.0000' WHERE id_product = '22195' 08/05/2024 03:40:53 pm >> UPDATE ps_product_shop SET wholesale_price = '9.75', price = '15.0000', id_tax_rules_group = '4', id_category_default = '225', 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 = '22195' 08/05/2024 03:40:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '22195' 08/05/2024 03:41:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240117' AND id_product != '21816' AND ean13 != '' 08/05/2024 03:41:05 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788892240117', date_upd = NOW() WHERE id_product = '21816' 08/05/2024 03:41:05 pm >> UPDATE ps_product_lang SET name = 'MESSAGGIO AI GIOVANI - C.M. MARTINI', description = '' WHERE id_product = '21816' 08/05/2024 03:41:05 pm >> UPDATE ps_product SET wholesale_price = '8.04', on_sale = '0', price = '12.0000' WHERE id_product = '21816' 08/05/2024 03:41:05 pm >> UPDATE ps_product_shop SET wholesale_price = '8.04', price = '12.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21816' 08/05/2024 03:41:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '21816' 08/05/2024 03:41:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259623287' AND id_product != '21550' AND ean13 != '' 08/05/2024 03:41:14 pm >> UPDATE ps_product SET id_supplier = '109', reference = '6/6', ean13 = '9791259623287', date_upd = NOW() WHERE id_product = '21550' 08/05/2024 03:41:14 pm >> UPDATE ps_product_lang SET name = 'MANUALE DEL DIAVOLO - R. CAMILLERI', description = '' WHERE id_product = '21550' 08/05/2024 03:41:14 pm >> UPDATE ps_product SET wholesale_price = '14.94', on_sale = '0', price = '23.0000' WHERE id_product = '21550' 08/05/2024 03:41:14 pm >> UPDATE ps_product_shop SET wholesale_price = '14.94', price = '23.0000', id_tax_rules_group = '4', id_category_default = '143', 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 = '21550' 08/05/2024 03:41:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '21550' 08/05/2024 03:41:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825057294' AND id_product != '22227' AND ean13 != '' 08/05/2024 03:41:25 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788825057294', date_upd = NOW() WHERE id_product = '22227' 08/05/2024 03:41:25 pm >> UPDATE ps_product_lang SET name = 'MALE NEGLI OCCHI DELL\'AMORE - G. BORGHI', description = '' WHERE id_product = '22227' 08/05/2024 03:41:25 pm >> UPDATE ps_product SET wholesale_price = '9.80', on_sale = '0', price = '14.0000' WHERE id_product = '22227' 08/05/2024 03:41:25 pm >> UPDATE ps_product_shop SET wholesale_price = '9.80', price = '14.0000', id_tax_rules_group = '4', id_category_default = '17', 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 = '22227' 08/05/2024 03:41:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '22227' 08/05/2024 03:41:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868946616' AND id_product != '21827' AND ean13 != '' 08/05/2024 03:41:36 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788868946616', date_upd = NOW() WHERE id_product = '21827' 08/05/2024 03:41:36 pm >> UPDATE ps_product_lang SET name = 'GIOIA DEL CUORE - C. STERCAL', description = '' WHERE id_product = '21827' 08/05/2024 03:41:36 pm >> UPDATE ps_product SET wholesale_price = '7.00', on_sale = '0', price = '10.0000' WHERE id_product = '21827' 08/05/2024 03:41:36 pm >> UPDATE ps_product_shop SET wholesale_price = '7.00', price = '10.0000', id_tax_rules_group = '4', id_category_default = '103', 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 = '21827' 08/05/2024 03:41:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '21827' 08/05/2024 03:41:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240100' AND id_product != '21815' AND ean13 != '' 08/05/2024 03:41:51 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788892240100', date_upd = NOW() WHERE id_product = '21815' 08/05/2024 03:41:51 pm >> UPDATE ps_product_lang SET name = 'FRUTTI DELLO SPIRITO - C.M. MARTINI', description = '' WHERE id_product = '21815' 08/05/2024 03:41:51 pm >> UPDATE ps_product SET wholesale_price = '8.04', on_sale = '0', price = '12.0000' WHERE id_product = '21815' 08/05/2024 03:41:51 pm >> UPDATE ps_product_shop SET wholesale_price = '8.04', price = '12.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21815' 08/05/2024 03:41:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '21815' 08/05/2024 03:41:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577140' AND id_product != '22056' AND ean13 != '' 08/05/2024 03:41:59 pm >> UPDATE ps_product SET id_supplier = '107', reference = '6/6', ean13 = '9788873577140', date_upd = NOW() WHERE id_product = '22056' 08/05/2024 03:41:59 pm >> UPDATE ps_product_lang SET name = 'E IO VI RISTORERO\' - M. ZUPPI', description = '' WHERE id_product = '22056' 08/05/2024 03:41:59 pm >> UPDATE ps_product SET wholesale_price = '6.50', on_sale = '0', price = '10.0000' WHERE id_product = '22056' 08/05/2024 03:41:59 pm >> UPDATE ps_product_shop SET wholesale_price = '6.50', price = '10.0000', id_tax_rules_group = '4', id_category_default = '178', 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 = '22056' 08/05/2024 03:41:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '22056' 08/05/2024 03:42:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577089' AND id_product != '21462' AND ean13 != '' 08/05/2024 03:42:07 pm >> UPDATE ps_product SET id_supplier = '107', reference = '6/6', ean13 = '9788873577089', date_upd = NOW() WHERE id_product = '21462' 08/05/2024 03:42:07 pm >> UPDATE ps_product_lang SET name = 'DIO IN CUI CREDIAMO - M. LAVRA', description = '' WHERE id_product = '21462' 08/05/2024 03:42:07 pm >> UPDATE ps_product SET wholesale_price = '9.10', on_sale = '0', price = '14.0000' WHERE id_product = '21462' 08/05/2024 03:42:07 pm >> UPDATE ps_product_shop SET wholesale_price = '9.10', price = '14.0000', id_tax_rules_group = '4', id_category_default = '178', 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 = '21462' 08/05/2024 03:42:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '21462' 08/05/2024 03:42:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557115' AND id_product != '22264' AND ean13 != '' 08/05/2024 03:42:16 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788831557115', date_upd = NOW() WHERE id_product = '22264' 08/05/2024 03:42:16 pm >> UPDATE ps_product_lang SET name = 'DIECI CAMMELLI INGINOCCHIATI - E. RONCHI', description = '' WHERE id_product = '22264' 08/05/2024 03:42:16 pm >> UPDATE ps_product SET wholesale_price = '9.38', on_sale = '0', price = '14.0000' WHERE id_product = '22264' 08/05/2024 03:42:16 pm >> UPDATE ps_product_shop SET wholesale_price = '9.38', price = '14.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '188', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22264' 08/05/2024 03:42:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '22264' 08/05/2024 03:42:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240605' AND id_product != '20663' AND ean13 != '' 08/05/2024 03:42:24 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788892240605', date_upd = NOW() WHERE id_product = '20663' 08/05/2024 03:42:24 pm >> UPDATE ps_product_lang SET name = 'CON MARIA SULLA STRADA DELLA PASQUA - L. FANZAGA', description = '' WHERE id_product = '20663' 08/05/2024 03:42:24 pm >> UPDATE ps_product SET wholesale_price = '8.04', on_sale = '0', price = '12.0000' WHERE id_product = '20663' 08/05/2024 03:42:24 pm >> UPDATE ps_product_shop SET wholesale_price = '8.04', price = '12.0000', 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 = '20663' 08/05/2024 03:42:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '20663' 08/05/2024 03:42:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243606' AND id_product != '22079' AND ean13 != '' 08/05/2024 03:42:32 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788892243606', date_upd = NOW() WHERE id_product = '22079' 08/05/2024 03:42:33 pm >> UPDATE ps_product_lang SET name = 'CAMMINANDO VERSO LA PASQUA - E. FORTUNATO', description = '' WHERE id_product = '22079' 08/05/2024 03:42:33 pm >> UPDATE ps_product SET wholesale_price = '8.04', on_sale = '0', price = '12.0000' WHERE id_product = '22079' 08/05/2024 03:42:33 pm >> UPDATE ps_product_shop SET wholesale_price = '8.04', price = '12.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22079' 08/05/2024 03:42:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '22079' 08/05/2024 03:42:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577096' AND id_product != '22022' AND ean13 != '' 08/05/2024 03:42:39 pm >> UPDATE ps_product SET id_supplier = '107', reference = '6/6', ean13 = '9788873577096', date_upd = NOW() WHERE id_product = '22022' 08/05/2024 03:42:39 pm >> UPDATE ps_product_lang SET name = 'ADAMO DOVE SEI? R. COLIZZI', description = '' WHERE id_product = '22022' 08/05/2024 03:42:40 pm >> UPDATE ps_product SET wholesale_price = '6.50', on_sale = '0', price = '10.0000' WHERE id_product = '22022' 08/05/2024 03:42:40 pm >> UPDATE ps_product_shop SET wholesale_price = '6.50', price = '10.0000', id_tax_rules_group = '4', id_category_default = '178', 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 = '22022' 08/05/2024 03:42:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '22022' 08/05/2024 03:42:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240728' AND id_product != '20761' AND ean13 != '' 08/05/2024 03:42:52 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788892240728', date_upd = NOW() WHERE id_product = '20761' 08/05/2024 03:42:53 pm >> UPDATE ps_product_lang SET name = 'LUCE ATTRAVERSO IL TEMPO - M. CAMISASCA', description = '' WHERE id_product = '20761' 08/05/2024 03:42:53 pm >> UPDATE ps_product SET wholesale_price = '14.74', on_sale = '0', price = '22.0000' WHERE id_product = '20761' 08/05/2024 03:42:53 pm >> UPDATE ps_product_shop SET wholesale_price = '14.74', price = '22.0000', id_tax_rules_group = '4', id_category_default = '30', 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 = '20761' 08/05/2024 03:42:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '20761' 08/05/2024 03:43:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243576' AND id_product != '22228' AND ean13 != '' 08/05/2024 03:43:02 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788892243576', date_upd = NOW() WHERE id_product = '22228' 08/05/2024 03:43:02 pm >> UPDATE ps_product_lang SET name = 'PAROLA MI RACCONTA - P. CURTAZ', description = '' WHERE id_product = '22228' 08/05/2024 03:43:02 pm >> UPDATE ps_product SET wholesale_price = '10.05', on_sale = '0', price = '15.0000' WHERE id_product = '22228' 08/05/2024 03:43:02 pm >> UPDATE ps_product_shop SET wholesale_price = '10.05', price = '15.0000', id_tax_rules_group = '4', id_category_default = '30', 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 = '22228' 08/05/2024 03:43:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '22228' 08/05/2024 03:53:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000163' AND id_product != '791' AND ean13 != '' 08/05/2024 03:53:33 pm >> UPDATE ps_product SET id_supplier = '31', reference = '2013', ean13 = '000163', date_upd = NOW() WHERE id_product = '791' 08/05/2024 03:53:33 pm >> UPDATE ps_product_lang SET name = 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS', description = '' WHERE id_product = '791' 08/05/2024 03:53:33 pm >> UPDATE ps_product SET wholesale_price = '0.69', on_sale = '0', price = '1.2295081967213115' WHERE id_product = '791' 08/05/2024 03:53:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.69', price = '1.2295081967213115', id_tax_rules_group = '1', id_category_default = '169', 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 = '791' 08/05/2024 03:53:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '791' 08/05/2024 03:56:56 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '13140' 08/05/2024 03:56:56 pm >> UPDATE ps_stock_available SET quantity = quantity + '-6' WHERE id_product = '13140' 08/05/2024 04:13:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000055' AND id_product != '13142' AND ean13 != '' 08/05/2024 04:13:59 pm >> UPDATE ps_product SET id_supplier = '31', reference = '', ean13 = '000055', date_upd = NOW() WHERE id_product = '13142' 08/05/2024 04:13:59 pm >> UPDATE ps_product_lang SET name = 'CERETTI DIAM 26X350 - 2635', description = '' WHERE id_product = '13142' 08/05/2024 04:13:59 pm >> UPDATE ps_product SET wholesale_price = '1.05', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '13142' 08/05/2024 04:13:59 pm >> UPDATE ps_product_shop SET wholesale_price = '1.05', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '169', 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 = '13142' 08/05/2024 04:13:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '13142' 08/05/2024 04:20:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000646' AND id_product != '1936' AND ean13 != '' 08/05/2024 04:20:22 pm >> UPDATE ps_product SET id_supplier = '31', reference = '2014', ean13 = '000646', date_upd = NOW() WHERE id_product = '1936' 08/05/2024 04:20:22 pm >> UPDATE ps_product_lang SET name = 'CERETTI DIAM 26X700 ART. 400', description = '' WHERE id_product = '1936' 08/05/2024 04:20:22 pm >> UPDATE ps_product SET wholesale_price = '1.71', on_sale = '0', price = '3.19672131147541' WHERE id_product = '1936' 08/05/2024 04:20:22 pm >> UPDATE ps_product_shop SET wholesale_price = '1.71', price = '3.19672131147541', id_tax_rules_group = '1', id_category_default = '169', 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 = '1936' 08/05/2024 04:20:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '1936' 08/05/2024 05:02:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1496' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 05:02:34 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' , '1496' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 08/05/2024 05:02:34 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 = '91693' 08/05/2024 05:02:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '91693' 08/05/2024 05:02:34 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 ( '91693' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 08/05/2024 05:15:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '1497' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 05:15:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1497' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.90' , '24.93' , NOW() , NOW() ) 08/05/2024 05:15:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91694' 08/05/2024 05:15:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '91694' 08/05/2024 05:15:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91694' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 08/05/2024 05:15:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91694' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 08/05/2024 05:15:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91694' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 08/05/2024 05:15:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91694' , '6809' , 'MOCCOLO 60X165' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 08/05/2024 05:42:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400327519' AND id_product != '19601' AND ean13 != '' 08/05/2024 05:42:49 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400327519', date_upd = NOW() WHERE id_product = '19601' 08/05/2024 05:42:49 pm >> UPDATE ps_product_lang SET name = 'ANGELO ALI TORTORA - 4231', description = '' WHERE id_product = '19601' 08/05/2024 05:42:49 pm >> UPDATE ps_product SET wholesale_price = '3.60', on_sale = '0', price = '8.19672131147541' WHERE id_product = '19601' 08/05/2024 05:42:49 pm >> UPDATE ps_product_shop SET wholesale_price = '3.60', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19601' 08/05/2024 05:42:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '19601' 08/05/2024 05:42:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400303803' AND id_product != '15591' AND ean13 != '' 08/05/2024 05:42:56 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400303803', date_upd = NOW() WHERE id_product = '15591' 08/05/2024 05:42:56 pm >> UPDATE ps_product_lang SET name = 'ANGELO CON CAMPANA ARG. - 4216', description = '' WHERE id_product = '15591' 08/05/2024 05:42:56 pm >> UPDATE ps_product SET wholesale_price = '3.20', on_sale = '0', price = '8.19672131147541' WHERE id_product = '15591' 08/05/2024 05:42:56 pm >> UPDATE ps_product_shop SET wholesale_price = '3.20', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15591' 08/05/2024 05:42:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '15591' 08/05/2024 05:43:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400303803' AND id_product != '15591' AND ean13 != '' 08/05/2024 05:43:21 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400303803', date_upd = NOW() WHERE id_product = '15591' 08/05/2024 05:43:21 pm >> UPDATE ps_product_lang SET name = 'ANGELO CON CAMPANA ARG. - 4216', description = '' WHERE id_product = '15591' 08/05/2024 05:43:21 pm >> UPDATE ps_product SET wholesale_price = '3.20', on_sale = '0', price = '7.786885245901639' WHERE id_product = '15591' 08/05/2024 05:43:21 pm >> UPDATE ps_product_shop SET wholesale_price = '3.20', price = '7.786885245901639', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15591' 08/05/2024 05:43:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '15591' 08/05/2024 05:48:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1412' AND id_document != '91589' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-03') 08/05/2024 05:48:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1412', document_date = '2024-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 = '24.50', price_tax_excluded = '20.08', date_upd = NOW() WHERE id_document = '91589' 08/05/2024 05:48:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91589' 08/05/2024 05:48:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '91589' 08/05/2024 05:48:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91589' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '4' , '-4' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '4.00' ) 08/05/2024 05:48:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91589' , '18129' , 'TAU COLORATO - T56' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 08/05/2024 05:48:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91589' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '16' , '-16' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '4.00' ) 08/05/2024 05:48:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91589' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '2' , '-2' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '2.20' ) 08/05/2024 05:48:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91589' , '22409' , 'PIASTRELLA COMUNIONE - 1302/K212' , '1' , '-1' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '8.50' ) 08/05/2024 05:48:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91589' , '20437' , 'LUMINO BIANCO 10BTS000' , '2' , '-2' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '1.00' ) 08/05/2024 05:48:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91589' , '2766' , 'CORONA PLASTICA FLUO / BIANCO' , '12' , '-12' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '3.60' ) 08/05/2024 06:19:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1498' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 06:19:42 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' , '1498' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '255.00' , '209.02' , NOW() , NOW() ) 08/05/2024 06:19:42 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 = '91695' 08/05/2024 06:19:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '91695' 08/05/2024 06:19:42 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 ( '91695' , '22470' , 'COTTA - 989P/ML/2' , '1' , '-1' , '1' , '255.00' , '209.01639344262' , '22' , '0' , '255.00' ) 08/05/2024 06:41:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1499' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 06:41:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1499' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.10' , '5.47' , NOW() , NOW() ) 08/05/2024 06:41:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91696' 08/05/2024 06:41:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '91696' 08/05/2024 06:41:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91696' , '20026' , 'CANDELA VOTIVA 20X40' , '5' , '-5' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '3.50' ) 08/05/2024 06:41:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91696' , '7134' , 'NOZIONI E PRECI' , '2' , '-2' , '4' , '1.30' , '1.3' , '0' , '0' , '2.60' ) 08/05/2024 06:42:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1500' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 08/05/2024 06:42:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1500' , '2024-05-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.55' , '8.55' , NOW() , NOW() ) 08/05/2024 06:42:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91697' 08/05/2024 06:42:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '91697' 08/05/2024 06:42:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91697' , '22509' , 'SANTA GEMMA E IL DIAVOLO - 8607' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' )