30/01/2023 09:07:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884040732' AND id_product != '3612' AND ean13 != '' 30/01/2023 09:07:13 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884040732', date_upd = NOW() WHERE id_product = '3612' 30/01/2023 09:07:13 am >> UPDATE ps_product_lang SET name = 'DOLOROSA PASSIONE DI N.S. GESÙ CRISTO - 8319', description = '' WHERE id_product = '3612' 30/01/2023 09:07:13 am >> UPDATE ps_product SET wholesale_price = '6.00', on_sale = '0', price = '10.0000' WHERE id_product = '3612' 30/01/2023 09:07:13 am >> UPDATE ps_product_shop SET wholesale_price = '6.00', price = '10.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3612' 30/01/2023 09:07:13 am >> DELETE FROM ps_specific_price WHERE id_product = '3612' 30/01/2023 09:09:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831165464' AND id_product != '3720' AND ean13 != '' 30/01/2023 09:09:57 am >> UPDATE ps_product SET id_supplier = '109', reference = '2/3', ean13 = '9788831165464', date_upd = NOW() WHERE id_product = '3720' 30/01/2023 09:09:57 am >> UPDATE ps_product_lang SET name = 'DOVE SEI GESÙ? - M. GENISIO', description = '' WHERE id_product = '3720' 30/01/2023 09:09:57 am >> UPDATE ps_product SET wholesale_price = '2.28', on_sale = '0', price = '3.5000' WHERE id_product = '3720' 30/01/2023 09:09:57 am >> UPDATE ps_product_shop SET wholesale_price = '2.28', price = '3.5000', id_tax_rules_group = '4', id_category_default = '13', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3720' 30/01/2023 09:09:57 am >> DELETE FROM ps_specific_price WHERE id_product = '3720' 30/01/2023 09:12:47 am >> SELECT document_num FROM ps_document WHERE document_num = '308' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 09:12:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '308' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 30/01/2023 09:12:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80579' 30/01/2023 09:12:47 am >> DELETE FROM ps_document_detail WHERE id_document = '80579' 30/01/2023 09:12:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80579' , '20585' , 'MESSALINO QUOTIDIANO - FEB/MAR/APR 2023' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 30/01/2023 10:27:50 am >> SELECT document_num FROM ps_document WHERE document_num = '309' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 10:27:50 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' , '309' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.70' , '79.37' , NOW() , NOW() ) 30/01/2023 10:27:50 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 = '80580' 30/01/2023 10:27:50 am >> DELETE FROM ps_document_detail WHERE id_document = '80580' 30/01/2023 10:27:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80580' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 30/01/2023 10:27:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80580' , '1936' , 'CERETTI DIAM 26X700 ART. 400' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 30/01/2023 10:27:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80580' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 30/01/2023 10:27:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80580' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 30/01/2023 10:27:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80580' , '19423' , 'PELLEGRINI DI SPERANZA' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 30/01/2023 10:55:51 am >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '80543' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-26') 30/01/2023 10:55:51 am >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2023-01-26', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSP. S. LEONARDO', 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 = '131.65', price_tax_excluded = '110.10', date_upd = NOW() WHERE id_document = '80543' 30/01/2023 10:55:51 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 = '80543' 30/01/2023 10:55:51 am >> DELETE FROM ps_document_detail WHERE id_document = '80543' 30/01/2023 10:55:51 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 ( '80543' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '50' , '-50' , '1' , '0.3300' , '0.27049180327869' , '22' , '0' , '16.50' ) 30/01/2023 10:55:51 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 ( '80543' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 30/01/2023 10:55:51 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 ( '80543' , '20071' , 'ROSARIO MISSIONARIO MM8' , '24' , '-24' , '1' , '1' , '0.81967213114754' , '22' , '0' , '24.00' ) 30/01/2023 10:55:51 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 ( '80543' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '11' , '-11' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '11.00' ) 30/01/2023 10:55:51 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 ( '80543' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 30/01/2023 10:55:51 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 ( '80543' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 30/01/2023 10:55:51 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 ( '80543' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 30/01/2023 10:55:51 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 ( '80543' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 30/01/2023 11:00:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2' AND id_document != '79901' AND id_document_type LIKE '26' AND YEAR(document_date) = YEAR('2023-01-19') 30/01/2023 11:00:02 am >> UPDATE ps_document SET id_document_type = '26', document_num = '2', document_date = '2023-01-19', document_letter = '', id_customer = '3191', id_supplier = '', id_address = '4670958', address1 = 'VIA QUINTINO DI VONA 84133 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 = '367.20', price_tax_excluded = '367.20', date_upd = NOW() WHERE id_document = '79901' 30/01/2023 11:00:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '79901' 30/01/2023 11:00:02 am >> DELETE FROM ps_document_detail WHERE id_document = '79901' 30/01/2023 11:00:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79901' , '1090' , 'BIBBIA' , '3' , '0' , '4' , '9.9000' , '9.9' , '0' , '0' , '29.70' ) 30/01/2023 11:00:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79901' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '9' , '0' , '4' , '18.5000' , '18.5' , '0' , '0' , '166.50' ) 30/01/2023 11:00:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79901' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '0' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 30/01/2023 11:00:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79901' , '1136' , 'BIBBIA DI GERUSALEMME - BOTTONE' , '2' , '0' , '4' , '34.5000' , '34.5' , '0' , '0' , '69.00' ) 30/01/2023 11:00:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79901' , '1134' , 'BIBBIA DI GERUSALEMME NERA' , '2' , '0' , '4' , '32.0000' , '32' , '0' , '0' , '64.00' ) 30/01/2023 11:01:38 am >> SELECT document_num FROM ps_document WHERE document_num = '310' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 11:01: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' , '310' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '208.27' , '208.27' , NOW() , NOW() ) 30/01/2023 11:01: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 = '80581' 30/01/2023 11:01:38 am >> DELETE FROM ps_document_detail WHERE id_document = '80581' 30/01/2023 11:01: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 ( '80581' , '1090' , 'BIBBIA' , '3' , '-3' , '4' , '9.90' , '9.9' , '0' , '5' , '28.23' ) 30/01/2023 11:01: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 ( '80581' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 30/01/2023 11:01: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 ( '80581' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 30/01/2023 11:01: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 ( '80581' , '1136' , 'BIBBIA DI GERUSALEMME - BOTTONE' , '2' , '-2' , '4' , '34.50' , '34.5' , '0' , '5' , '65.56' ) 30/01/2023 11:01: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 ( '80581' , '1134' , 'BIBBIA DI GERUSALEMME NERA' , '2' , '-2' , '4' , '32.00' , '32' , '0' , '5' , '60.80' ) 30/01/2023 11:03:52 am >> SELECT document_num FROM ps_document WHERE document_num = '22' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 11:03:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '22' , '2023-01-30' , '' , '3191' , '0' , '4670958' , 'VIA QUINTINO DI VONA 84133 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '50.00' , '50.00' , NOW() , NOW() ) 30/01/2023 11:03:52 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 = '80582' 30/01/2023 11:03:52 am >> DELETE FROM ps_document_detail WHERE id_document = '80582' 30/01/2023 11:03:52 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 ( '80582' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '5' , '-5' , '4' , '10' , '10' , '0' , '0' , '50.00' ) 30/01/2023 11:09:55 am >> DELETE FROM ps_document WHERE id_document = '79901' 30/01/2023 11:09:55 am >> DELETE FROM ps_document_detail WHERE id_document = '79901' 30/01/2023 11:10:06 am >> DELETE FROM ps_document WHERE id_document = '80453' 30/01/2023 11:10:06 am >> DELETE FROM ps_document_detail WHERE id_document = '80453' 30/01/2023 11:41:36 am >> SELECT document_num FROM ps_document WHERE document_num = '311' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 11:41:36 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' , '311' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.87' , '104.87' , NOW() , NOW() ) 30/01/2023 11:41: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 = '80583' 30/01/2023 11:41:36 am >> DELETE FROM ps_document_detail WHERE id_document = '80583' 30/01/2023 11:41: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 ( '80583' , '20650' , 'DOMENICO SAVIO - F. FORNARA' , '8' , '-8' , '4' , '8.00' , '8' , '0' , '5' , '60.80' ) 30/01/2023 11:41: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 ( '80583' , '20649' , 'STORIA DI SANTA TERESA DI LISIEUX' , '10' , '-10' , '4' , '1.90' , '1.9' , '0' , '5' , '18.10' ) 30/01/2023 11:41: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 ( '80583' , '9413' , 'SAN FILIPPO NERI' , '7' , '-7' , '4' , '3.90' , '3.9' , '0' , '5' , '25.97' ) 30/01/2023 11:42:26 am >> SELECT document_num FROM ps_document WHERE document_num = '312' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 11:42:27 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' , '312' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 30/01/2023 11:42:27 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 = '80584' 30/01/2023 11:42:27 am >> DELETE FROM ps_document_detail WHERE id_document = '80584' 30/01/2023 11:42:27 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 ( '80584' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 30/01/2023 11:58:44 am >> SELECT document_num FROM ps_document WHERE document_num = '313' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 11:58:44 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' , '313' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.50' , '26.35' , NOW() , NOW() ) 30/01/2023 11:58: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 = '80585' 30/01/2023 11:58:44 am >> DELETE FROM ps_document_detail WHERE id_document = '80585' 30/01/2023 11:58: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 ( '80585' , '9209' , 'S. FAMIGLIA BABY - 023 HF/9 BB' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 30/01/2023 11:58: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 ( '80585' , '6075' , 'LOURDES BABY - 023 LDS/9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 30/01/2023 11:58: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 ( '80585' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '9.50' ) 30/01/2023 12:11:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '314' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 12:11: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' , '314' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 30/01/2023 12:11: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 = '80586' 30/01/2023 12:11:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '80586' 30/01/2023 12:11: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 ( '80586' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 30/01/2023 12:22:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '315' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 12:22:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '315' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.90' , '14.67' , NOW() , NOW() ) 30/01/2023 12:22:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80587' 30/01/2023 12:22:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '80587' 30/01/2023 12:22:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80587' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 30/01/2023 12:27:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '316' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 12:27:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '316' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '67.00' , '54.92' , NOW() , NOW() ) 30/01/2023 12:27:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80588' 30/01/2023 12:27:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '80588' 30/01/2023 12:27:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80588' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '1' , '-1' , '1' , '29' , '23.770491803279' , '22' , '0' , '29.00' ) 30/01/2023 12:27:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80588' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '19' , '-19' , '1' , '2' , '1.6393442622951' , '22' , '0' , '38.00' ) 30/01/2023 12:30:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '317' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 12:30:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '317' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.24' , '60.24' , NOW() , NOW() ) 30/01/2023 12:30:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80589' 30/01/2023 12:30:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '80589' 30/01/2023 12:30:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80589' , '20440' , 'AMEN - FEB. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/01/2023 12:30:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80589' , '20671' , 'QUARESIMA 2023' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 30/01/2023 12:30:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80589' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 30/01/2023 12:30:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80589' , '20659' , 'CORSO FONDAMENTALE SULLA FEDE - K. RAHNER' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 30/01/2023 12:34:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '318' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 12:34:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '318' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 30/01/2023 12:34:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80590' 30/01/2023 12:34:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '80590' 30/01/2023 12:34:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80590' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 30/01/2023 12:34:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80590' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1' , '0.81967213114754' , '22' , '0' , '2.00' ) 30/01/2023 03:37:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '319' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 03:37:17 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' , '319' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 30/01/2023 03:37:17 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 = '80591' 30/01/2023 03:37:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '80591' 30/01/2023 03:37:17 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 ( '80591' , '2083' , 'CINQUE PRIMI SABATI DEL MESE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 30/01/2023 03:39:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '320' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 03:39:39 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' , '320' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.35' , '12.35' , NOW() , NOW() ) 30/01/2023 03:39:39 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 = '80592' 30/01/2023 03:39:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '80592' 30/01/2023 03:39:39 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 ( '80592' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 30/01/2023 04:49:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '321' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 04:49: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' , '321' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '114.70' , '95.19' , NOW() , NOW() ) 30/01/2023 04:49: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 = '80593' 30/01/2023 04:49:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '80593' 30/01/2023 04:49: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 ( '80593' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 30/01/2023 04:49: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 ( '80593' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 30/01/2023 04:49: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 ( '80593' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 30/01/2023 04:49: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 ( '80593' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '5.70' ) 30/01/2023 04:49: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 ( '80593' , '9070' , 'ROSARIO E CORONCINA ALLO SPIRITO SANTO - 8250' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 30/01/2023 04:49: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 ( '80593' , '19600' , 'ROSARIO SPIRITO SANTO' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 30/01/2023 04:49: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 ( '80593' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 30/01/2023 04:57:44 pm >> DELETE FROM ps_document WHERE id_document = '78830' 30/01/2023 04:57:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '78830' 30/01/2023 05:37:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861248984' AND id_product != '18152' AND ean13 != '' 30/01/2023 05:37:35 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861248984', date_upd = NOW() WHERE id_product = '18152' 30/01/2023 05:37:35 pm >> UPDATE ps_product_lang SET name = 'BIBBIA A COLORI ', description = '' WHERE id_product = '18152' 30/01/2023 05:37:35 pm >> UPDATE ps_product SET wholesale_price = '6.23', on_sale = '0', price = '8.9000' WHERE id_product = '18152' 30/01/2023 05:37:35 pm >> UPDATE ps_product_shop SET wholesale_price = '6.23', price = '8.9000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18152' 30/01/2023 05:37:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '18152' 30/01/2023 05:38:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861248984' AND id_product != '18152' AND ean13 != '' 30/01/2023 05:38:18 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861248984', date_upd = NOW() WHERE id_product = '18152' 30/01/2023 05:38:18 pm >> UPDATE ps_product_lang SET name = 'BIBBIA A COLORI ', description = '' WHERE id_product = '18152' 30/01/2023 05:38:18 pm >> UPDATE ps_product SET wholesale_price = '6.23', on_sale = '0', price = '8.9000' WHERE id_product = '18152' 30/01/2023 05:38:18 pm >> UPDATE ps_product_shop SET wholesale_price = '6.23', price = '8.9000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18152' 30/01/2023 05:38:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '18152' 30/01/2023 05:42:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861248984' AND id_product != '18152' AND ean13 != '' 30/01/2023 05:42:42 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861248984', date_upd = NOW() WHERE id_product = '18152' 30/01/2023 05:42:43 pm >> UPDATE ps_product_lang SET name = 'BIBBIA A COLORI ', description = '' WHERE id_product = '18152' 30/01/2023 05:42:43 pm >> UPDATE ps_product SET wholesale_price = '6.23', on_sale = '0', price = '8.9000' WHERE id_product = '18152' 30/01/2023 05:42:43 pm >> UPDATE ps_product_shop SET wholesale_price = '6.23', price = '8.9000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18152' 30/01/2023 05:42:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '18152' 30/01/2023 05:43:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892225596' AND id_product != '19571' AND ean13 != '' 30/01/2023 05:43:01 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788892225596', date_upd = NOW() WHERE id_product = '19571' 30/01/2023 05:43:01 pm >> UPDATE ps_product_lang SET name = 'MIEI PRIMI NUMERI', description = '' WHERE id_product = '19571' 30/01/2023 05:43:01 pm >> UPDATE ps_product SET wholesale_price = '4.23', on_sale = '0', price = '6.5000' WHERE id_product = '19571' 30/01/2023 05:43:01 pm >> UPDATE ps_product_shop SET wholesale_price = '4.23', price = '6.5000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19571' 30/01/2023 05:43:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '19571' 30/01/2023 05:43:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892225589' AND id_product != '19570' AND ean13 != '' 30/01/2023 05:43:15 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788892225589', date_upd = NOW() WHERE id_product = '19570' 30/01/2023 05:43:15 pm >> UPDATE ps_product_lang SET name = 'MIO PRIMO ALFABETIERE', description = '' WHERE id_product = '19570' 30/01/2023 05:43:15 pm >> UPDATE ps_product SET wholesale_price = '4.23', on_sale = '0', price = '6.5000' WHERE id_product = '19570' 30/01/2023 05:43:15 pm >> UPDATE ps_product_shop SET wholesale_price = '4.23', price = '6.5000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19570' 30/01/2023 05:43:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '19570' 30/01/2023 05:43:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861249608' AND id_product != '19278' AND ean13 != '' 30/01/2023 05:43:27 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861249608', date_upd = NOW() WHERE id_product = '19278' 30/01/2023 05:43:27 pm >> UPDATE ps_product_lang SET name = 'COLORIAMO LA PASQUA', description = '' WHERE id_product = '19278' 30/01/2023 05:43:27 pm >> UPDATE ps_product SET wholesale_price = '2.73', on_sale = '0', price = '3.9000' WHERE id_product = '19278' 30/01/2023 05:43:27 pm >> UPDATE ps_product_shop SET wholesale_price = '2.73', price = '3.9000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19278' 30/01/2023 05:43:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '19278' 30/01/2023 05:43:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861249615' AND id_product != '19279' AND ean13 != '' 30/01/2023 05:43:39 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861249615', date_upd = NOW() WHERE id_product = '19279' 30/01/2023 05:43:39 pm >> UPDATE ps_product_lang SET name = 'COLORIAMO LE PARABOLE', description = '' WHERE id_product = '19279' 30/01/2023 05:43:39 pm >> UPDATE ps_product SET wholesale_price = '2.73', on_sale = '0', price = '3.9000' WHERE id_product = '19279' 30/01/2023 05:43:39 pm >> UPDATE ps_product_shop SET wholesale_price = '2.73', price = '3.9000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19279' 30/01/2023 05:43:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '19279' 30/01/2023 05:43:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831553186' AND id_product != '18112' AND ean13 != '' 30/01/2023 05:43:56 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788831553186', date_upd = NOW() WHERE id_product = '18112' 30/01/2023 05:43:56 pm >> UPDATE ps_product_lang SET name = 'MARIA LA MAMMA DI GESU\'', description = '' WHERE id_product = '18112' 30/01/2023 05:43:56 pm >> UPDATE ps_product SET wholesale_price = '1.63', on_sale = '0', price = '2.5000' WHERE id_product = '18112' 30/01/2023 05:43:56 pm >> UPDATE ps_product_shop SET wholesale_price = '1.63', price = '2.5000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18112' 30/01/2023 05:43:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '18112' 30/01/2023 05:44:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831552981' AND id_product != '18924' AND ean13 != '' 30/01/2023 05:44:12 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788831552981', date_upd = NOW() WHERE id_product = '18924' 30/01/2023 05:44:12 pm >> UPDATE ps_product_lang SET name = 'TI RACCONTO LA VITA DI GESU\'', description = '' WHERE id_product = '18924' 30/01/2023 05:44:12 pm >> UPDATE ps_product SET wholesale_price = '1.63', on_sale = '0', price = '2.5000' WHERE id_product = '18924' 30/01/2023 05:44:12 pm >> UPDATE ps_product_shop SET wholesale_price = '1.63', price = '2.5000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18924' 30/01/2023 05:44:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '18924' 30/01/2023 05:44:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870109' AND id_product != '20258' AND ean13 != '' 30/01/2023 05:44:24 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788892870109', date_upd = NOW() WHERE id_product = '20258' 30/01/2023 05:44:24 pm >> UPDATE ps_product_lang SET name = 'COLORIAMO I MIRACOLI', description = '' WHERE id_product = '20258' 30/01/2023 05:44:24 pm >> UPDATE ps_product SET wholesale_price = '2.73', on_sale = '0', price = '3.9000' WHERE id_product = '20258' 30/01/2023 05:44:24 pm >> UPDATE ps_product_shop SET wholesale_price = '2.73', price = '3.9000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20258' 30/01/2023 05:44:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '20258' 30/01/2023 05:44:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861249738' AND id_product != '19937' AND ean13 != '' 30/01/2023 05:44:39 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861249738', date_upd = NOW() WHERE id_product = '19937' 30/01/2023 05:44:39 pm >> UPDATE ps_product_lang SET name = 'SANTI A COLORI', description = '' WHERE id_product = '19937' 30/01/2023 05:44:39 pm >> UPDATE ps_product SET wholesale_price = '6.23', on_sale = '0', price = '8.9000' WHERE id_product = '19937' 30/01/2023 05:44:39 pm >> UPDATE ps_product_shop SET wholesale_price = '6.23', price = '8.9000', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19937' 30/01/2023 05:44:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '19937' 30/01/2023 05:44:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801046212' AND id_product != '5659' AND ean13 != '' 30/01/2023 05:44:52 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788801046212', date_upd = NOW() WHERE id_product = '5659' 30/01/2023 05:44:52 pm >> UPDATE ps_product_lang SET name = 'LEGGO E GIOCO CON LA BIBBIA', description = '' WHERE id_product = '5659' 30/01/2023 05:44:52 pm >> UPDATE ps_product SET wholesale_price = '6.25', on_sale = '0', price = '12.5000' WHERE id_product = '5659' 30/01/2023 05:44:52 pm >> UPDATE ps_product_shop SET wholesale_price = '6.25', price = '12.5000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5659' 30/01/2023 05:44:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '5659' 30/01/2023 05:45:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810769621' AND id_product != '12720' AND ean13 != '' 30/01/2023 05:45:05 pm >> UPDATE ps_product SET id_supplier = '109', reference = '5/1', ean13 = '9788810769621', date_upd = NOW() WHERE id_product = '12720' 30/01/2023 05:45:05 pm >> UPDATE ps_product_lang SET name = 'VANGELO PER TUTTO L\'ANNO', description = '' WHERE id_product = '12720' 30/01/2023 05:45:05 pm >> UPDATE ps_product SET wholesale_price = '5.80', on_sale = '0', price = '8.5000' WHERE id_product = '12720' 30/01/2023 05:45:05 pm >> UPDATE ps_product_shop SET wholesale_price = '5.80', price = '8.5000', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12720' 30/01/2023 05:45:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '12720' 30/01/2023 05:45:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810769638' AND id_product != '12718' AND ean13 != '' 30/01/2023 05:45:16 pm >> UPDATE ps_product SET id_supplier = '109', reference = '5/1', ean13 = '9788810769638', date_upd = NOW() WHERE id_product = '12718' 30/01/2023 05:45:16 pm >> UPDATE ps_product_lang SET name = 'VITA DI GESU\' ', description = '' WHERE id_product = '12718' 30/01/2023 05:45:16 pm >> UPDATE ps_product SET wholesale_price = '6.08', on_sale = '0', price = '8.9000' WHERE id_product = '12718' 30/01/2023 05:45:16 pm >> UPDATE ps_product_shop SET wholesale_price = '6.08', price = '8.9000', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12718' 30/01/2023 05:45:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '12718' 30/01/2023 05:45:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892212893' AND id_product != '12948' AND ean13 != '' 30/01/2023 05:45:28 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788892212893', date_upd = NOW() WHERE id_product = '12948' 30/01/2023 05:45:28 pm >> UPDATE ps_product_lang SET name = 'QUADRETTI', description = '' WHERE id_product = '12948' 30/01/2023 05:45:28 pm >> UPDATE ps_product SET wholesale_price = '6.44', on_sale = '0', price = '9.9000' WHERE id_product = '12948' 30/01/2023 05:45:29 pm >> UPDATE ps_product_shop SET wholesale_price = '6.44', price = '9.9000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12948' 30/01/2023 05:45:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '12948' 30/01/2023 06:16:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '322' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 06:16:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '322' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '10.58' , NOW() , NOW() ) 30/01/2023 06:16:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80594' 30/01/2023 06:16:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '80594' 30/01/2023 06:16:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80594' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 30/01/2023 06:16:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80594' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 30/01/2023 06:26:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '15/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 06:26:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '15/A' , '2023-01-30' , 'A' , '905' , '0' , '4673206' , 'VIA MAGGIORE, 1 84081 SAVA DI BARONISSI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.00' , '60.74' , NOW() , NOW() ) 30/01/2023 06:26:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80595' 30/01/2023 06:26:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '80595' 30/01/2023 06:26:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80595' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 30/01/2023 06:26:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80595' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 30/01/2023 07:23:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '323' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-30') 30/01/2023 07:23:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '323' , '2023-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.58' , '17.58' , NOW() , NOW() ) 30/01/2023 07:23:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80596' 30/01/2023 07:23:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '80596' 30/01/2023 07:23:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80596' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' )