13/01/2025 09:46:26 am >> SELECT document_num FROM ps_document WHERE document_num = '121' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-13') 13/01/2025 09:46:26 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' , '121' , '2025-01-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '24.50' , NOW() , NOW() ) 13/01/2025 09:46:26 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 = '95251' 13/01/2025 09:46:26 am >> DELETE FROM ps_document_detail WHERE id_document = '95251' 13/01/2025 09:46:26 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 ( '95251' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.70' , '0.7' , '0' , '0' , '24.50' ) 13/01/2025 09:48:22 am >> SELECT document_num FROM ps_document WHERE document_num = '122' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-13') 13/01/2025 09:48:22 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' , '122' , '2025-01-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.90' , '49.07' , NOW() , NOW() ) 13/01/2025 09:48:22 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 = '95252' 13/01/2025 09:48:22 am >> DELETE FROM ps_document_detail WHERE id_document = '95252' 13/01/2025 09:48:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95252' , '18095' , 'CROCE IN ULIVO - 2882' , '1' , '-1' , '1' , '24.80' , '20.327868852459' , '22' , '0' , '24.80' ) 13/01/2025 09:48:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95252' , '16107' , 'VERGINE MADRE, FIGLIA DEL TUO FIGLIO - L. EPICOCO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 13/01/2025 09:48:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95252' , '22976' , 'MARIA STELLA DELLA SPERANZA - BENEDETTO XVI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 13/01/2025 09:48:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95252' , '23324' , 'PELLEGRINI DI SPERANZA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 13/01/2025 09:48:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95252' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 13/01/2025 09:48:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95252' , '23300' , 'DOMENICA DELLA PAROLA 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 13/01/2025 09:48:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95252' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 13/01/2025 11:06:34 am >> SELECT document_num FROM ps_document WHERE document_num = '123' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-13') 13/01/2025 11:06:34 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' , '123' , '2025-01-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.70' , '21.89' , NOW() , NOW() ) 13/01/2025 11:06:34 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 = '95253' 13/01/2025 11:06:34 am >> DELETE FROM ps_document_detail WHERE id_document = '95253' 13/01/2025 11:06:34 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 ( '95253' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '26.70' ) 13/01/2025 11:48:20 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 13/01/2025 11:48:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23337' , '1' , '' , 'nuovo-prodotto' ) 13/01/2025 11:48:20 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23337' , '1' , '1' , '2' , NOW() , NOW() ) 13/01/2025 11:48:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23337' , '0' , '1' , '0' , '0' ) 13/01/2025 11:49:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256270729' AND id_product != '23337' AND ean13 != '' 13/01/2025 11:49:07 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9791256270729', date_upd = NOW() WHERE id_product = '23337' 13/01/2025 11:49:07 am >> UPDATE ps_product_lang SET name = 'VANGELO IN TASCA - L. MISTO\'', description = '' WHERE id_product = '23337' 13/01/2025 11:49:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23337' 13/01/2025 11:49:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '137', 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 = '23337' 13/01/2025 11:49:07 am >> DELETE FROM ps_specific_price WHERE id_product = '23337' 13/01/2025 11:49:07 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 = '23337' 13/01/2025 11:49:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23338' , '1' , '' , 'nuovo-prodotto' ) 13/01/2025 11:49:07 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 '23338' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23337' 13/01/2025 11:49:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23338' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23337' 13/01/2025 11:51:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830725928' AND id_product != '23338' AND ean13 != '' 13/01/2025 11:51:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788830725928', date_upd = NOW() WHERE id_product = '23338' 13/01/2025 11:51:05 am >> UPDATE ps_product_lang SET name = 'AGENDA BIBLICO MISSIONARIA', description = '' WHERE id_product = '23338' 13/01/2025 11:51:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.5' WHERE id_product = '23338' 13/01/2025 11:51:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.5', id_tax_rules_group = '4', id_category_default = '85', 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 = '23338' 13/01/2025 11:51:05 am >> DELETE FROM ps_specific_price WHERE id_product = '23338' 13/01/2025 11:51:11 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 = '23338' 13/01/2025 11:51:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23339' , '1' , '' , 'nuovo-prodotto' ) 13/01/2025 11:51:11 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 '23339' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23338' 13/01/2025 11:51:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23339' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23338' 13/01/2025 11:57: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 ( '33' , '00006799' , '2025-01-10' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '223.69' , '223.69' , NOW() , NOW() ) 13/01/2025 11:57: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 = '95254' 13/01/2025 11:57:50 am >> DELETE FROM ps_document_detail WHERE id_document = '95254' 13/01/2025 11:57: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 ( '95254' , '23337' , 'VANGELO IN TASCA - L. MISTO' , '1' , '1' , '4' , '18.00' , '18' , '0' , '37' , '11.3400' ) 13/01/2025 11:57:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '23337' AND id_supplier = '109' 13/01/2025 11:57:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23337' , '109' , '1' ) 13/01/2025 11:57: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 ( '95254' , '23338' , 'AGENDA BIBLICO MISSIONARIA' , '1' , '1' , '4' , '13.50' , '13.5' , '0' , '30' , '9.4500' ) 13/01/2025 11:57:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '23338' AND id_supplier = '109' 13/01/2025 11:57:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23338' , '109' , '1' ) 13/01/2025 11:57: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 ( '95254' , '23235' , 'DIO ESISTE? - ROBERT SARAH' , '1' , '1' , '4' , '25.00' , '25' , '0' , '30' , '17.5000' ) 13/01/2025 11:57:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '23235' AND id_supplier = '109' 13/01/2025 11:57:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23235' , '109' , '1' ) 13/01/2025 11:57: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 ( '95254' , '5823' , 'LIBRO DORO' , '25' , '25' , '4' , '0.60' , '0.6' , '0' , '30' , '10.5000' ) 13/01/2025 11:57:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '5823' AND id_supplier = '109' 13/01/2025 11:57:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5823' , '109' , '1' ) 13/01/2025 11:57: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 ( '95254' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '2' , '2' , '4' , '19.50' , '19.5' , '0' , '30' , '27.3000' ) 13/01/2025 11:57:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '23045' AND id_supplier = '109' 13/01/2025 11:57:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23045' , '109' , '1' ) 13/01/2025 11:57: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 ( '95254' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '3' , '3' , '4' , '42.00' , '42' , '0' , '40' , '75.6000' ) 13/01/2025 11:57:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '23256' AND id_supplier = '109' 13/01/2025 11:57:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23256' , '109' , '1' ) 13/01/2025 11:57: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 ( '95254' , '22283' , 'BIBBIA DI GERUSALEMME VERDE' , '3' , '3' , '4' , '32.00' , '32' , '0' , '40' , '57.6000' ) 13/01/2025 11:57:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '22283' AND id_supplier = '109' 13/01/2025 11:57:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22283' , '109' , '1' ) 13/01/2025 11:57: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 ( '95254' , '22284' , 'BIBBIA DI GERUSALEMME - TASC. AZZURRA' , '1' , '1' , '4' , '24.00' , '24' , '0' , '40' , '14.4000' ) 13/01/2025 11:57:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '22284' AND id_supplier = '109' 13/01/2025 11:57:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22284' , '109' , '1' ) 13/01/2025 12:13:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '124' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-13') 13/01/2025 12:13:52 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' , '124' , '2025-01-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.80' , '57.93' , NOW() , NOW() ) 13/01/2025 12:13:52 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 = '95255' 13/01/2025 12:13:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '95255' 13/01/2025 12:13:52 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 ( '95255' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 13/01/2025 12:13:53 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 ( '95255' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 13/01/2025 12:13:53 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 ( '95255' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 13/01/2025 12:13:53 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 ( '95255' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 13/01/2025 12:13:53 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 ( '95255' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 13/01/2025 12:22:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '125' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-13') 13/01/2025 12:22: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' , '125' , '2025-01-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.50' , '13.94' , NOW() , NOW() ) 13/01/2025 12:22: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 = '95256' 13/01/2025 12:22:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '95256' 13/01/2025 12:22: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 ( '95256' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 13/01/2025 12:22: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 ( '95256' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 13/01/2025 02:17:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '4105' AND id_document != '95058' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-27') 13/01/2025 02:17:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4105', document_date = '2024-12-27', 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 = '28.60', price_tax_excluded = '23.44', date_upd = NOW() WHERE id_document = '95058' 13/01/2025 02:17:53 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 = '95058' 13/01/2025 02:17:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '95058' 13/01/2025 02:17:53 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 ( '95058' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 13/01/2025 02:17:53 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 ( '95058' , '23093' , 'CONFEZIONE CAPANNA - P622-ITA' , '3' , '-3' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '3.60' ) 13/01/2025 02:39:23 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'UcBVt749aImthNRh' , NOW() , NOW() ) 13/01/2025 02:39:23 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4151' , '1' ) 13/01/2025 02:39:23 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4151' , '2' ) 13/01/2025 02:39:23 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4151' , '3' ) 13/01/2025 02:41:22 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4151' 13/01/2025 02:41:22 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4151' , '10' , '208' , '' , 'CARNEVALI' , 'SANDRO' , 'VIA TUSCOLANO 194' , '' , '00077' , 'MONTECOMPRATI' , 'ALESSANDRA GROSSI - alegrossi25@yahoo.it - 3471060640' , '' , '' , '' , '' , NOW() , NOW() ) 13/01/2025 02:41:22 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4151' 13/01/2025 02:42:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-13') 13/01/2025 02:42:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '3' , '2025-01-13' , '' , '4151' , '0' , '4679451' , 'VIA TUSCOLANO 194 00077 MONTECOMPRATI' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '29.23' , '29.23' , NOW() , NOW() ) 13/01/2025 02:42:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95257' 13/01/2025 02:42:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '95257' 13/01/2025 02:42:24 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 ( '95257' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 13/01/2025 02:42:24 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 ( '95257' , '9675' , 'SARETE MIEI TESTIMONI' , '2' , '0' , '4' , '3.50' , '3.5' , '0' , '5' , '6.65' ) 13/01/2025 02:42:24 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 ( '95257' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '2' , '0' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 13/01/2025 04:14:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3969' AND id_document != '94892' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-17') 13/01/2025 04:14:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3969', document_date = '2024-12-17', 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 = '159.90', price_tax_excluded = '138.26', date_upd = NOW() WHERE id_document = '94892' 13/01/2025 04:14: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 = '94892' 13/01/2025 04:14:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '94892' 13/01/2025 04: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 ( '94892' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '1' , '-1' , '4' , '42.0000' , '42' , '0' , '5' , '39.90' ) 13/01/2025 04: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 ( '94892' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '2' , '-2' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '60.00' ) 13/01/2025 04: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 ( '94892' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 13/01/2025 04: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 ( '94892' , '18882' , 'BAMBINELLO CM 21 - PB13947' , '2' , '-2' , '1' , '15' , '12.295081967213' , '22' , '0' , '30.00' ) 13/01/2025 04:15:52 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '18882' 13/01/2025 04:15:52 pm >> UPDATE ps_stock_available SET quantity = quantity + '-6' WHERE id_product = '18882' 13/01/2025 05:05:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '126' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-13') 13/01/2025 05:05: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 ( '11' , '126' , '2025-01-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '6.48' , NOW() , NOW() ) 13/01/2025 05:05: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 = '95258' 13/01/2025 05:05:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '95258' 13/01/2025 05:05: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 ( '95258' , '22199' , 'VINO LIQUOROSO ROSSO ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 13/01/2025 05:10:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831506342' AND id_product != '23339' AND ean13 != '' 13/01/2025 05:10:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831506342', date_upd = NOW() WHERE id_product = '23339' 13/01/2025 05:10:18 pm >> UPDATE ps_product_lang SET name = 'PASTORES DABO VOBIS', description = '' WHERE id_product = '23339' 13/01/2025 05:10:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '23339' 13/01/2025 05:10:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23339' 13/01/2025 05:10:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '23339' 13/01/2025 05:10:20 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23339' 13/01/2025 05:10:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23340' , '1' , '' , 'nuovo-prodotto' ) 13/01/2025 05:10:20 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23340' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23339' 13/01/2025 05:10:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23340' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23339' 13/01/2025 05:11:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '686440' , '2025-01-10' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.19' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.44' , '125.44' , NOW() , NOW() ) 13/01/2025 05:11:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95259' 13/01/2025 05:11:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '95259' 13/01/2025 05:11:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95259' , '16686' , 'EVANGELIARIO' , '1' , '1' , '4' , '150.00' , '150' , '0' , '30' , '105.0000' ) 13/01/2025 05:11:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16686' AND id_supplier = '7' 13/01/2025 05:11:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16686' , '7' , '1' ) 13/01/2025 05:11:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95259' , '23339' , 'PASTORES DABO VOBIS' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '33' , '2.3450' ) 13/01/2025 05:11:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23339' AND id_supplier = '7' 13/01/2025 05:11:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23339' , '7' , '1' ) 13/01/2025 05:11:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95259' , '4349' , 'GENITORI IN AZIONE! - AAVV' , '1' , '1' , '4' , '4.9' , '4.9' , '0' , '35' , '3.1850' ) 13/01/2025 05:11:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4349' AND id_supplier = '7' 13/01/2025 05:11:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4349' , '7' , '1' ) 13/01/2025 05:11:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95259' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 13/01/2025 05:11:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23131' AND id_supplier = '7' 13/01/2025 05:11:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23131' , '7' , '1' ) 13/01/2025 05:14:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831558280' AND id_product != '23340' AND ean13 != '' 13/01/2025 05:14:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788831558280', date_upd = NOW() WHERE id_product = '23340' 13/01/2025 05:14:25 pm >> UPDATE ps_product_lang SET name = 'PER UNA CHIESA SINODALE', description = '' WHERE id_product = '23340' 13/01/2025 05:14:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '23340' 13/01/2025 05:14:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23340' 13/01/2025 05:14:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '23340' 13/01/2025 05:15:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '686108' , '2025-01-08' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.43' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.42' , '84.42' , NOW() , NOW() ) 13/01/2025 05:15:18 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 = '95260' 13/01/2025 05:15:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '95260' 13/01/2025 05:15:18 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 ( '95260' , '16664' , 'DON BOSCO LA STORIA INFINITA - B. FERRERO' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '35' , '6.4350' ) 13/01/2025 05:15:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16664' AND id_supplier = '7' 13/01/2025 05:15:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16664' , '7' , '1' ) 13/01/2025 05:15:18 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 ( '95260' , '23285' , 'CHI E GESU - G. LAJOLO' , '1' , '1' , '4' , '28.00' , '28' , '0' , '35' , '18.2000' ) 13/01/2025 05:15:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23285' AND id_supplier = '7' 13/01/2025 05:15:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23285' , '7' , '1' ) 13/01/2025 05:15:18 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 ( '95260' , '10430' , 'TABOR' , '1' , '1' , '4' , '17.90' , '17.9' , '0' , '30' , '12.5300' ) 13/01/2025 05:15:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10430' AND id_supplier = '7' 13/01/2025 05:15:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10430' , '7' , '1' ) 13/01/2025 05:15:18 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 ( '95260' , '21814' , 'VIVERE IL LUTTO INSIEME A DIO - C. GALATOLO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '30' , '9.8000' ) 13/01/2025 05:15:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21814' AND id_supplier = '7' 13/01/2025 05:15:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21814' , '7' , '1' ) 13/01/2025 05:15:18 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 ( '95260' , '23119' , 'AMEN - FEB 25' , '4' , '4' , '4' , '3.90' , '3.9' , '0' , '33' , '10.4520' ) 13/01/2025 05:15:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23119' AND id_supplier = '7' 13/01/2025 05:15:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23119' , '7' , '1' ) 13/01/2025 05:15:18 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 ( '95260' , '22885' , 'MINISTERO DEL CATECHISTA E I MINISTERI LAICALI... ' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 13/01/2025 05:15:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22885' AND id_supplier = '7' 13/01/2025 05:15:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22885' , '7' , '1' ) 13/01/2025 05:15:18 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 ( '95260' , '23340' , 'PER UNA CHIESA SINODALE' , '6' , '6' , '4' , '3.50' , '3.5' , '0' , '33' , '14.0700' ) 13/01/2025 05:15:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23340' AND id_supplier = '7' 13/01/2025 05:15:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23340' , '7' , '1' ) 13/01/2025 06:23:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839918680' AND id_product != '8416' AND ean13 != '' 13/01/2025 06:23:47 pm >> UPDATE ps_product SET id_supplier = '7', reference = '10/3', ean13 = '9788839918680', date_upd = NOW() WHERE id_product = '8416' 13/01/2025 06:23:47 pm >> UPDATE ps_product_lang SET name = 'PREPARARE E CELEBRARE - TRIDUO PASQUALE', description = '' WHERE id_product = '8416' 13/01/2025 06:23:47 pm >> UPDATE ps_product SET wholesale_price = '14.00', on_sale = '0', price = '24' WHERE id_product = '8416' 13/01/2025 06:23:47 pm >> UPDATE ps_product_shop SET wholesale_price = '14.00', price = '24', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8416' 13/01/2025 06:23:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '8416' 13/01/2025 08:00:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '127' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-13') 13/01/2025 08:00:00 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' , '127' , '2025-01-13' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.90' , '46.30' , NOW() , NOW() ) 13/01/2025 08:00:00 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 = '95261' 13/01/2025 08:00:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '95261' 13/01/2025 08:00:00 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 ( '95261' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 13/01/2025 08:00:00 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 ( '95261' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 13/01/2025 08:00:00 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 ( '95261' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '39.90' , '32.704918032787' , '22' , '0' , '39.90' )