27/09/2024 08:33:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821576119' AND id_product != '11129' AND ean13 != '' 27/09/2024 08:33:35 am >> UPDATE ps_product SET id_supplier = '7', reference = '11/2', ean13 = '9788821576119', date_upd = NOW() WHERE id_product = '11129' 27/09/2024 08:33:35 am >> UPDATE ps_product_lang SET name = 'VANGELO SECONDO LUCA', description = '' WHERE id_product = '11129' 27/09/2024 08:33:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.9000' WHERE id_product = '11129' 27/09/2024 08:33:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.9000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '11129' 27/09/2024 08:33:35 am >> DELETE FROM ps_specific_price WHERE id_product = '11129' 27/09/2024 09:45:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2810' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 09:45:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2810' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 27/09/2024 09:45:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93312' 27/09/2024 09:45:28 am >> DELETE FROM ps_document_detail WHERE id_document = '93312' 27/09/2024 09:45:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93312' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 27/09/2024 10:03:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2811' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 10:03:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2811' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '13.93' , NOW() , NOW() ) 27/09/2024 10:03:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93313' 27/09/2024 10:03:42 am >> DELETE FROM ps_document_detail WHERE id_document = '93313' 27/09/2024 10:03:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93313' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '17' , '13.934426229508' , '22' , '0' , '17.00' ) 27/09/2024 10:24:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2812' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 10:24: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' , '2812' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.66' , '4.66' , NOW() , NOW() ) 27/09/2024 10:24: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 = '93314' 27/09/2024 10:24:38 am >> DELETE FROM ps_document_detail WHERE id_document = '93314' 27/09/2024 10:24: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 ( '93314' , '18057' , 'ROSARIO CON PAPA FRANCESCO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 27/09/2024 10:31:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2813' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 10:31:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2813' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '167.00' , '144.46' , NOW() , NOW() ) 27/09/2024 10:31:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93315' 27/09/2024 10:31:21 am >> DELETE FROM ps_document_detail WHERE id_document = '93315' 27/09/2024 10:31:21 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 ( '93315' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '8' , '-8' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '28.00' ) 27/09/2024 10:31:21 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 ( '93315' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 27/09/2024 10:31:21 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 ( '93315' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 27/09/2024 10:31:21 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 ( '93315' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 27/09/2024 10:31:21 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 ( '93315' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 27/09/2024 10:31: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 ( '93315' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 27/09/2024 10:31: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 ( '93315' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 27/09/2024 10:31: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 ( '93315' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '1' , '-1' , '4' , '0.90' , '0.9' , '0' , '0' , '0.90' ) 27/09/2024 10:31: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 ( '93315' , '22450' , 'DIO E SEMPRE CON NOI' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 27/09/2024 10:31: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 ( '93315' , '11540' , 'VOGLIAMO IL BATTESIMO PER NOSTRO FIGLIO' , '5' , '-5' , '4' , '2.00' , '2' , '0' , '5' , '9.50' ) 27/09/2024 11:06:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2814' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 11:06:59 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' , '2814' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.75' , '11.31' , NOW() , NOW() ) 27/09/2024 11:06:59 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 = '93316' 27/09/2024 11:06:59 am >> DELETE FROM ps_document_detail WHERE id_document = '93316' 27/09/2024 11:06:59 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 ( '93316' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/09/2024 11:06:59 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 ( '93316' , '19786' , 'ROSARIO MADREPERLA MM5 - 10M5' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 27/09/2024 11:08:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2815' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 11:08:07 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' , '2815' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.85' , '2.85' , NOW() , NOW() ) 27/09/2024 11:08:07 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 = '93317' 27/09/2024 11:08:07 am >> DELETE FROM ps_document_detail WHERE id_document = '93317' 27/09/2024 11:08:07 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 ( '93317' , '22026' , 'SANTI DEL MESSALINO SAN FILIPPO NERI - 8586' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 27/09/2024 11:09:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2354' AND id_document != '92731' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 27/09/2024 11:09:14 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2354', document_date = '2024-07-26', 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 = '37.95', price_tax_excluded = '31.96', date_upd = NOW() WHERE id_document = '92731' 27/09/2024 11:09:14 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 = '92731' 27/09/2024 11:09:14 am >> DELETE FROM ps_document_detail WHERE id_document = '92731' 27/09/2024 11:09:14 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 ( '92731' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '17.50' ) 27/09/2024 11:09:14 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 ( '92731' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 27/09/2024 11:09:14 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 ( '92731' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 27/09/2024 11:09:14 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 ( '92731' , '19786' , 'ROSARIO MADREPERLA MM5 - 10M5' , '1' , '-1' , '1' , '5.9' , '4.8360655737705' , '22' , '0' , '5.90' ) 27/09/2024 11:16:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2816' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 11:16:14 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' , '2816' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.20' , '28.27' , NOW() , NOW() ) 27/09/2024 11:16:14 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 = '93318' 27/09/2024 11:16:14 am >> DELETE FROM ps_document_detail WHERE id_document = '93318' 27/09/2024 11:16:14 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 ( '93318' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 27/09/2024 11:16:14 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 ( '93318' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 27/09/2024 11:16:14 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 ( '93318' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '3.5' , '3.5' , '0' , '0' , '7.00' ) 27/09/2024 11:16:14 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 ( '93318' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 27/09/2024 11:40:26 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/09/2024 11:40:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22965' , '1' , '' , 'nuovo-prodotto' ) 27/09/2024 11:40:26 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22965' , '1' , '1' , '2' , NOW() , NOW() ) 27/09/2024 11:40:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22965' , '0' , '1' , '0' , '0' ) 27/09/2024 11:42:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '12-344' AND id_product != '22965' AND ean13 != '' 27/09/2024 11:42:25 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-344', date_upd = NOW() WHERE id_product = '22965' 27/09/2024 11:42:25 am >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO TURIBOLO NICKEL ', description = '' WHERE id_product = '22965' 27/09/2024 11:42:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.40983606557377' WHERE id_product = '22965' 27/09/2024 11:42:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.40983606557377', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22965' 27/09/2024 11:42:25 am >> DELETE FROM ps_specific_price WHERE id_product = '22965' 27/09/2024 11:48:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '12-344' AND id_product != '22965' AND ean13 != '' 27/09/2024 11:48:42 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-344', date_upd = NOW() WHERE id_product = '22965' 27/09/2024 11:48:42 am >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO TURIBOLO NICKEL ', description = '' WHERE id_product = '22965' 27/09/2024 11:48:43 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.40983606557377' WHERE id_product = '22965' 27/09/2024 11:48:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.40983606557377', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22965' 27/09/2024 11:48:43 am >> DELETE FROM ps_specific_price WHERE id_product = '22965' 27/09/2024 11:48:46 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 = '22965' 27/09/2024 11:48:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22966' , '1' , '' , 'nuovo-prodotto' ) 27/09/2024 11:48:46 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 '22966' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22965' 27/09/2024 11:48:46 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22966' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22965' 27/09/2024 11:49:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2817' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 11:49:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2817' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '146.20' , '119.84' , NOW() , NOW() ) 27/09/2024 11:49:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93319' 27/09/2024 11:49:54 am >> DELETE FROM ps_document_detail WHERE id_document = '93319' 27/09/2024 11:49:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93319' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '143.00' , '117.2131147541' , '22' , '0' , '143.00' ) 27/09/2024 11:49:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93319' , '1325' , 'BRACCIALE IN CORDA CON TAU - 1649' , '2' , '-2' , '1' , '1.60' , '1.3114754098361' , '22' , '0' , '3.20' ) 27/09/2024 11:51:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '12-567' AND id_product != '22966' AND ean13 != '' 27/09/2024 11:51:07 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-567', date_upd = NOW() WHERE id_product = '22966' 27/09/2024 11:51:07 am >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO H7', description = '' WHERE id_product = '22966' 27/09/2024 11:51:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.475409836065573' WHERE id_product = '22966' 27/09/2024 11:51:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.475409836065573', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22966' 27/09/2024 11:51:07 am >> DELETE FROM ps_specific_price WHERE id_product = '22966' 27/09/2024 11:51:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '12-567' AND id_product != '22966' AND ean13 != '' 27/09/2024 11:51:39 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '12-567', date_upd = NOW() WHERE id_product = '22966' 27/09/2024 11:51:39 am >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO H7', description = '' WHERE id_product = '22966' 27/09/2024 11:51:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.475409836065573' WHERE id_product = '22966' 27/09/2024 11:51:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.475409836065573', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22966' 27/09/2024 11:51:39 am >> DELETE FROM ps_specific_price WHERE id_product = '22966' 27/09/2024 11:51:40 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 = '22966' 27/09/2024 11:51:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22967' , '1' , '' , 'nuovo-prodotto' ) 27/09/2024 11:51:40 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 '22967' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22966' 27/09/2024 11:51:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22967' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22966' 27/09/2024 11:52:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '30-783' AND id_product != '22967' AND ean13 != '' 27/09/2024 11:52:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '30-783' AND id_product != '22296' AND ean13 != '' 27/09/2024 11:52:57 am >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '30-783', date_upd = NOW() WHERE id_product = '22296' 27/09/2024 11:52:57 am >> UPDATE ps_product_lang SET name = 'RELIQUIARI TASCABILE CM 3,5', description = '' WHERE id_product = '22296' 27/09/2024 11:52:57 am >> UPDATE ps_product SET wholesale_price = '3.20', on_sale = '0', price = '9.836065573770492' WHERE id_product = '22296' 27/09/2024 11:52:57 am >> UPDATE ps_product_shop SET wholesale_price = '3.20', price = '9.836065573770492', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22296' 27/09/2024 11:52:57 am >> DELETE FROM ps_specific_price WHERE id_product = '22296' 27/09/2024 11:53:00 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 = '22296' 27/09/2024 11:53:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22968' , '1' , '' , 'nuovo-prodotto' ) 27/09/2024 11:53:00 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 '22968' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22296' 27/09/2024 11:53:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22968' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22296' 27/09/2024 11:54:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '10-100/A' AND id_product != '22968' AND ean13 != '' 27/09/2024 11:54:12 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '10-100/A', date_upd = NOW() WHERE id_product = '22968' 27/09/2024 11:54:12 am >> UPDATE ps_product_lang SET name = 'TURIBOLO H10', description = '' WHERE id_product = '22968' 27/09/2024 11:54:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.114754098360656' WHERE id_product = '22968' 27/09/2024 11:54:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.114754098360656', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22968' 27/09/2024 11:54:12 am >> DELETE FROM ps_specific_price WHERE id_product = '22968' 27/09/2024 12:00:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '10-100/A' AND id_product != '22968' AND ean13 != '' 27/09/2024 12:00:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '10-100/A', date_upd = NOW() WHERE id_product = '22968' 27/09/2024 12:00:43 pm >> UPDATE ps_product_lang SET name = 'TURIBOLO H10', description = '' WHERE id_product = '22968' 27/09/2024 12:00:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.114754098360656' WHERE id_product = '22968' 27/09/2024 12:00:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.114754098360656', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22968' 27/09/2024 12:00:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '22968' 27/09/2024 12:01:39 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 = '22968' 27/09/2024 12:01:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22969' , '1' , '' , 'nuovo-prodotto' ) 27/09/2024 12:01:39 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 '22969' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22968' 27/09/2024 12:01:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22969' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22968' 27/09/2024 12:03:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '32-220' AND id_product != '22969' AND ean13 != '' 27/09/2024 12:03:09 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '32-220', date_upd = NOW() WHERE id_product = '22969' 27/09/2024 12:03:09 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO H32 CM', description = '' WHERE id_product = '22969' 27/09/2024 12:03:09 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '163.11475409836066' WHERE id_product = '22969' 27/09/2024 12:03:09 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '163.11475409836066', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22969' 27/09/2024 12:03:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '22969' 27/09/2024 12:04:09 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 = '22969' 27/09/2024 12:04:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22970' , '1' , '' , 'nuovo-prodotto' ) 27/09/2024 12:04:09 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 '22970' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22969' 27/09/2024 12:04:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22970' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22969' 27/09/2024 12:04:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '32-551' AND id_product != '22970' AND ean13 != '' 27/09/2024 12:04:45 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '32-551', date_upd = NOW() WHERE id_product = '22970' 27/09/2024 12:04:45 pm >> UPDATE ps_product_lang SET name = 'RELIQUIARIO H 25CM', description = '' WHERE id_product = '22970' 27/09/2024 12:04:45 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '154.91803278688525' WHERE id_product = '22970' 27/09/2024 12:04:45 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '154.91803278688525', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22970' 27/09/2024 12:04:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '22970' 27/09/2024 12:05:29 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 = '22970' 27/09/2024 12:05:29 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22971' , '1' , '' , 'nuovo-prodotto' ) 27/09/2024 12:05:29 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 '22971' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22970' 27/09/2024 12:05:29 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22971' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22970' 27/09/2024 12:06:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '32-729' AND id_product != '22971' AND ean13 != '' 27/09/2024 12:06:06 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '32-729', date_upd = NOW() WHERE id_product = '22971' 27/09/2024 12:06:06 pm >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO ', description = '' WHERE id_product = '22971' 27/09/2024 12:06:06 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24.508196721311474' WHERE id_product = '22971' 27/09/2024 12:06:06 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24.508196721311474', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22971' 27/09/2024 12:06:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '22971' 27/09/2024 12:07:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '32-729' AND id_product != '22971' AND ean13 != '' 27/09/2024 12:07:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '32-729', date_upd = NOW() WHERE id_product = '22971' 27/09/2024 12:07:25 pm >> UPDATE ps_product_lang SET name = 'BRUCIA INCENSO ', description = '' WHERE id_product = '22971' 27/09/2024 12:07:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24.508196721311474' WHERE id_product = '22971' 27/09/2024 12:07:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24.508196721311474', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22971' 27/09/2024 12:07:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '22971' 27/09/2024 12:09:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '2024-02534' , '2024-09-23' , '' , '0' , '86' , '2723' , 'WEIDACHSTRABE, 6 85609 ASCHHEIM - GERMANIA' , '' , '' , '17.36' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '259.67' , '259.67' , NOW() , NOW() ) 27/09/2024 12:09:14 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 = '93320' 27/09/2024 12:09:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '93320' 27/09/2024 12:09:14 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 ( '93320' , '22965' , 'BRUCIA INCENSO TURIBOLO NICKEL ' , '1' , '1' , '0' , '10.14' , '10.14' , '' , '3' , '9.8358' ) 27/09/2024 12:09:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22965' AND id_supplier = '86' 27/09/2024 12:09:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22965' , '86' , '1' ) 27/09/2024 12:09:14 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 ( '93320' , '22966' , 'BRUCIA INCENSO H7' , '2' , '2' , '0' , '5.64' , '5.64' , '' , '3' , '10.9416' ) 27/09/2024 12:09:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22966' AND id_supplier = '86' 27/09/2024 12:09:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22966' , '86' , '1' ) 27/09/2024 12:09:14 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 ( '93320' , '22296' , 'RELIQUIARI TASCABILE CM 3,5' , '4' , '4' , '0' , '4.8' , '4.8' , '' , '3' , '18.6240' ) 27/09/2024 12:09:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22296' AND id_supplier = '86' 27/09/2024 12:09:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22296' , '86' , '1' ) 27/09/2024 12:09:14 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 ( '93320' , '22968' , 'TURIBOLO H10' , '6' , '6' , '0' , '5.53' , '5.53' , '' , '3' , '32.1846' ) 27/09/2024 12:09:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22968' AND id_supplier = '86' 27/09/2024 12:09:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22968' , '86' , '1' ) 27/09/2024 12:09:14 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 ( '93320' , '22969' , 'RELIQUIARIO H32 CM' , '1' , '1' , '0' , '79.51' , '79.51' , '' , '3' , '77.1247' ) 27/09/2024 12:09:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22969' AND id_supplier = '86' 27/09/2024 12:09:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22969' , '86' , '1' ) 27/09/2024 12:09:14 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 ( '93320' , '22971' , 'BRUCIA INCENSO ' , '2' , '2' , '0' , '11.94' , '11.94' , '' , '3' , '23.1636' ) 27/09/2024 12:09:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22971' AND id_supplier = '86' 27/09/2024 12:09:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22971' , '86' , '1' ) 27/09/2024 12:09:14 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 ( '93320' , '22970' , 'RELIQUIARIO H 25CM' , '1' , '1' , '0' , '72.61' , '72.61' , '' , '3' , '70.4317' ) 27/09/2024 12:09:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22970' AND id_supplier = '86' 27/09/2024 12:09:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22970' , '86' , '1' ) 27/09/2024 12:27:18 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '22961' 27/09/2024 12:27:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736499' AND id_product != '22961' AND ean13 != '' 27/09/2024 12:27:30 pm >> UPDATE ps_product SET id_supplier = '159', reference = '', ean13 = '9791280736499', date_upd = NOW() WHERE id_product = '22961' 27/09/2024 12:27:30 pm >> UPDATE ps_product_lang SET name = 'UN BAMBINO E\' NATO PER NOI - G. VALSECCHI', description = '' WHERE id_product = '22961' 27/09/2024 12:27:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.0000' WHERE id_product = '22961' 27/09/2024 12:27:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '39', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '1', date_upd = NOW() WHERE id_product = '22961' 27/09/2024 12:27:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '22961' 27/09/2024 12:27:30 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '22961' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/09/2024 12:29:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736499' AND id_product != '22961' AND ean13 != '' 27/09/2024 12:29:42 pm >> UPDATE ps_product SET id_supplier = '159', reference = '', ean13 = '9791280736499', date_upd = NOW() WHERE id_product = '22961' 27/09/2024 12:29:42 pm >> UPDATE ps_product_lang SET name = 'BAMBINO E\' NATO PER NOI - G. VALSECCHI', description = '' WHERE id_product = '22961' 27/09/2024 12:29:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.0000' WHERE id_product = '22961' 27/09/2024 12:29:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '39', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '1', date_upd = NOW() WHERE id_product = '22961' 27/09/2024 12:29:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '22961' 27/09/2024 12:29:42 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '22961' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/09/2024 12:42:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2818' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 12:42:31 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' , '2818' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 27/09/2024 12:42:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93321' 27/09/2024 12:42:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '93321' 27/09/2024 12:42:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93321' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/09/2024 12:42:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93321' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 27/09/2024 12:42:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93321' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/09/2024 01:07:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2819' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 01:07:59 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' , '2819' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '195.00' , '161.89' , NOW() , NOW() ) 27/09/2024 01:07:59 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 = '93322' 27/09/2024 01:07:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '93322' 27/09/2024 01:07:59 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 ( '93322' , '18984' , 'POLO FELPATO ML ' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 27/09/2024 01:07:59 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 ( '93322' , '18962' , 'POLO MISTO VISCOSA ML ' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 27/09/2024 01:07:59 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 ( '93322' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '36.6' , '30' , '22' , '0' , '36.60' ) 27/09/2024 01:07:59 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 ( '93322' , '22919' , 'STOLA GIUBILEO 2025' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '0' , '38.00' ) 27/09/2024 01:07:59 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 ( '93322' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '5' , '11.40' ) 27/09/2024 03:19:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2820' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 03:19:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2820' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 27/09/2024 03:19:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93323' 27/09/2024 03:19:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '93323' 27/09/2024 03:19:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93323' , '6218' , 'MARIA CHE SCIOGLIE I NODI - 209 - OGGETTI' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 27/09/2024 03:19:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93323' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.20' ) 27/09/2024 04:29:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '129' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 04:29: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 ( '21' , '129' , '2024-09-27' , '' , '3533' , '0' , '4672868' , 'VIALE FRENTANO 2 66030 MOZZAGROGNA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '137.46' , '137.46' , NOW() , NOW() ) 27/09/2024 04:29: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 = '93324' 27/09/2024 04:29:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '93324' 27/09/2024 04:29: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 ( '93324' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 27/09/2024 04:29: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 ( '93324' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 27/09/2024 04:29: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 ( '93324' , '12819' , 'REGISTRO DEL CATECHISTA ' , '15' , '-15' , '0' , '1.00' , '1' , '' , '15' , '12.75' ) 27/09/2024 04:29: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 ( '93324' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '2' , '-2' , '0' , '12.00' , '12' , '' , '15' , '20.40' ) 27/09/2024 04:29: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 ( '93324' , '6629' , 'MIA PREGHIERA' , '20' , '-20' , '4' , '0.90' , '0.9' , '0' , '15' , '15.30' ) 27/09/2024 04:29: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 ( '93324' , '15020' , 'PREGARE OGNI GIORNO' , '50' , '-50' , '4' , '1.00' , '1' , '0' , '15' , '42.50' ) 27/09/2024 04:29: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 ( '93324' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '2' , '-2' , '4' , '6.20' , '6.2' , '0' , '15' , '10.54' ) 27/09/2024 04:29: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 ( '93324' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '2' , '-2' , '4' , '5.16' , '5.16' , '0' , '15' , '8.77' ) 27/09/2024 04:29: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 ( '93324' , '14499' , 'COMUNIONE AI MALATI' , '20' , '-20' , '0' , '0.30' , '0.3' , '' , '15' , '5.10' ) 27/09/2024 05:23:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2821' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 05:23:40 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' , '2821' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.75' , '61.75' , NOW() , NOW() ) 27/09/2024 05:23:40 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 = '93325' 27/09/2024 05:23:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '93325' 27/09/2024 05:23:40 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 ( '93325' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '13' , '-13' , '4' , '5.00' , '5' , '0' , '5' , '61.75' ) 27/09/2024 05:24:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2822' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 05:24: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' , '2822' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 27/09/2024 05:24: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 = '93326' 27/09/2024 05:24:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '93326' 27/09/2024 05:24: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 ( '93326' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 27/09/2024 05:36:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2823' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 05:36: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' , '2823' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 27/09/2024 05:36: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 = '93327' 27/09/2024 05:36:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '93327' 27/09/2024 05:36: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 ( '93327' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 27/09/2024 05:36: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 ( '93327' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 27/09/2024 05:37:05 pm >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 27/09/2024 05:37:05 pm >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '191' , '1' ) 27/09/2024 05:37:05 pm >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '191' , '1' ) 27/09/2024 05:37:05 pm >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '191' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 27/09/2024 05:38:57 pm >> UPDATE ps_address SET id_state = '183', lastname = 'CITYPRESS SOCIETA\' COOPERATIVA', address1 = 'VIA VARO 1', address2 = '', postcode = '80053', dni = '', vat_number = '07677441219', city = 'CASTELLAMMARE DI STABIA ', phone = '', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '191' 27/09/2024 05:38:57 pm >> UPDATE ps_supplier SET email = 'CITYPRESSSCARL@GMAIL.COM', name = 'CITYPRESS SOCIETA\' COOPERATIVA', date_upd = NOW() WHERE id_supplier = '191' 27/09/2024 05:38:57 pm >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '191' 27/09/2024 05:39:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '156' , '2024-09-26' , '' , '0' , '191' , '4679364' , 'VIA VARO 1 80053 CASTELLAMMARE DI STABIA ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '70.00' , '70.00' , NOW() , NOW() ) 27/09/2024 05:39:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93328' 27/09/2024 05:39:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '93328' 27/09/2024 05:39:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93328' , '22960' , 'POMPEI LA FONDAZIONE' , '1' , '1' , '4' , '70' , '70' , '0' , '0' , '70.0000' ) 27/09/2024 05:39:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22960' AND id_supplier = '191' 27/09/2024 05:39:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22960' , '191' , '1' ) 27/09/2024 06:02:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2824' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 06:02:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2824' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 27/09/2024 06:02:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93329' 27/09/2024 06:02:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '93329' 27/09/2024 06:02:37 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 ( '93329' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 27/09/2024 06:06:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '2825' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-27') 27/09/2024 06:06:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2825' , '2024-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 27/09/2024 06:06:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93330' 27/09/2024 06:06:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '93330' 27/09/2024 06:06:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93330' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 27/09/2024 06:25:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '110' AND id_document != '93157' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-16') 27/09/2024 06:25:44 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '110', document_date = '2024-09-16', document_letter = '', id_customer = '1832', id_supplier = '', id_address = '4670920', address1 = 'C.DA PANTANO 85010 PIGNOLA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '80.25', price_tax_excluded = '80.25', date_upd = NOW() WHERE id_document = '93157' 27/09/2024 06:25:44 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 = '93157' 27/09/2024 06:25:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '93157' 27/09/2024 06:25:44 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 ( '93157' , '8408' , 'PRENDETE E MANGIATE' , '16' , '-16' , '4' , '3.0000' , '3' , '0' , '15' , '40.80' ) 27/09/2024 06:25:44 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 ( '93157' , '4154' , 'FESTA DEL PERDONO' , '14' , '-14' , '4' , '3.0000' , '3' , '0' , '15' , '35.70' ) 27/09/2024 06:25: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 ( '93157' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.75' , '3.75' , '0' , '0' , '3.75' ) 27/09/2024 06:28:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '115' AND id_document != '93191' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-18') 27/09/2024 06:28:49 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '115', document_date = '2024-09-18', document_letter = '', id_customer = '4114', id_supplier = '', id_address = '4679351', address1 = 'VIA BLANDINI 10 96017 NOTO', address2 = '', note = '', price_shipping = '3.35', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '30.00', price_tax_excluded = '30.00', date_upd = NOW() WHERE id_document = '93191' 27/09/2024 06:28:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93191' 27/09/2024 06:28:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '93191' 27/09/2024 06:28:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93191' , '0' , 'SPESE DI CONTRASEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 27/09/2024 06:28:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93191' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 27/09/2024 06:28:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93191' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 27/09/2024 06:28:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93191' , '15020' , 'PREGARE OGNI GIORNO' , '5' , '-5' , '4' , '1.00' , '1' , '0' , '5' , '4.75' ) 27/09/2024 06:30:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '120' AND id_document != '93255' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-23') 27/09/2024 06:30:07 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '120', document_date = '2024-09-23', document_letter = '', id_customer = '3555', id_supplier = '', id_address = '4671028', address1 = 'VIA FAGGIOTTI 19 41029 SESTOLA', address2 = '', note = '', price_shipping = '5.65', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '55.00', date_upd = NOW() WHERE id_document = '93255' 27/09/2024 06:30:07 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 = '93255' 27/09/2024 06:30:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '93255' 27/09/2024 06:30:08 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 ( '93255' , '8408' , 'PRENDETE E MANGIATE' , '7' , '-7' , '4' , '3.0000' , '3' , '0' , '5' , '19.95' ) 27/09/2024 06:30:08 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 ( '93255' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 27/09/2024 06:30:08 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 ( '93255' , '15317' , 'SACRAMENTI SPIEGATI AI RAGAZZI - LA COMUNIONE' , '2' , '-2' , '4' , '1.8000' , '1.8' , '0' , '5' , '3.42' ) 27/09/2024 06:30:08 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 ( '93255' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '7' , '-7' , '4' , '1.9000' , '1.9' , '0' , '5' , '12.63' ) 27/09/2024 06:30:08 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 ( '93255' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '5' , '0.95' ) 27/09/2024 06:30:08 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 ( '93255' , '0' , 'contrassegno' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 27/09/2024 07:17:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2788' AND id_document != '93277' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 27/09/2024 07:17:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2788', document_date = '2024-09-24', 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 = '3', id_causal = '0', price_tax_included = '296.00', price_tax_excluded = '242.62', date_upd = NOW() WHERE id_document = '93277' 27/09/2024 07:17: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 = '93277' 27/09/2024 07:17:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '93277' 27/09/2024 07:17: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 ( '93277' , '22464' , 'CASULA LEGGERA - 1212' , '2' , '-2' , '1' , '75.0000' , '61.475409836066' , '22' , '0' , '150.00' ) 27/09/2024 07:17: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 ( '93277' , '19793' , 'STOLA IHS - 220' , '2' , '-2' , '1' , '73.0000' , '59.83606557377' , '22' , '0' , '146.00' ) 27/09/2024 07:17:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2787' AND id_document != '93276' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 27/09/2024 07:17:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2787', document_date = '2024-09-24', 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 = '3', id_causal = '0', price_tax_included = '48.00', price_tax_excluded = '39.34', date_upd = NOW() WHERE id_document = '93276' 27/09/2024 07:17:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93276' 27/09/2024 07:17:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '93276' 27/09/2024 07:17:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93276' , '15893' , 'CINGOLO - CING17' , '1' , '-1' , '1' , '48.0000' , '39.344262295082' , '22' , '0' , '48.00' )