09/05/2022 08:30:13 am >> SELECT document_num FROM ps_document WHERE document_num = '26' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 08:30:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '26' , '2022-05-09' , '' , '6967' , '0' , '70013322' , 'Via B. COLLEONI , 1 30013 CAVALLINO TREPORTI ' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '30.65' , '30.65' , NOW() , NOW() ) 09/05/2022 08:30:13 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 = '4959' 09/05/2022 08:30:13 am >> DELETE FROM ps_document_detail WHERE id_document = '4959' 09/05/2022 08:30:13 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 ( '4959' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '5' , '23.75' ) 09/05/2022 09:03:12 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 09/05/2022 09:03:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19534' , '1' , '' , 'nuovo-prodotto' ) 09/05/2022 09:03:12 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19534' , '1' , '1' , '2' , NOW() , NOW() ) 09/05/2022 09:03:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19534' , '0' , '1' , '0' , '0' ) 09/05/2022 09:03:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884047021' AND id_product != '19534' AND ean13 != '' 09/05/2022 09:03:48 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884047021', date_upd = NOW() WHERE id_product = '19534' 09/05/2022 09:03:48 am >> UPDATE ps_product_lang SET name = 'NOVENA ALLA MADONNA DI FATIMA', description = '' WHERE id_product = '19534' 09/05/2022 09:03:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2' WHERE id_product = '19534' 09/05/2022 09:03:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19534' 09/05/2022 09:03:48 am >> DELETE FROM ps_specific_price WHERE id_product = '19534' 09/05/2022 09:03:48 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 = '19534' 09/05/2022 09:03:49 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19535' , '1' , '' , 'nuovo-prodotto' ) 09/05/2022 09:03:49 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 '19535' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19534' 09/05/2022 09:03:49 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19535' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19534' 09/05/2022 09:04: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 ( '31' , '8038/00/2022' , '2022-05-05' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '121.20' , '121.20' , NOW() , NOW() ) 09/05/2022 09:04: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 = '56662' 09/05/2022 09:04:28 am >> DELETE FROM ps_document_detail WHERE id_document = '56662' 09/05/2022 09:04: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 ( '56662' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '5' , '5' , '4' , '5.00' , '5' , '0' , '40' , '15.0000' ) 09/05/2022 09:04:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '38' 09/05/2022 09:04:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '38' , '1' ) 09/05/2022 09:04: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 ( '56662' , '19467' , 'SULLA TUA PAROLA - LUG AGO 2022' , '26' , '26' , '4' , '5.00' , '5' , '0' , '40' , '78.0000' ) 09/05/2022 09:04:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '38' 09/05/2022 09:04:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '38' , '1' ) 09/05/2022 09:04: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 ( '56662' , '19534' , 'NOVENA ALLA MADONNA DI FATIMA' , '2' , '2' , '4' , '2.00' , '2' , '0' , '40' , '2.4000' ) 09/05/2022 09:04:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '19534' AND id_supplier = '38' 09/05/2022 09:04:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19534' , '38' , '1' ) 09/05/2022 09:04: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 ( '56662' , '19504' , 'ROSARIO ALLA MADONNA DI FATIMA - 8062' , '3' , '3' , '4' , '3.00' , '3' , '0' , '40' , '5.4000' ) 09/05/2022 09:04:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '19504' AND id_supplier = '38' 09/05/2022 09:04:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19504' , '38' , '1' ) 09/05/2022 09:04:29 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 ( '56662' , '19503' , 'UN MESE CON MARIA - 8064' , '3' , '3' , '4' , '9.00' , '9' , '0' , '40' , '16.2000' ) 09/05/2022 09:04:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '19503' AND id_supplier = '38' 09/05/2022 09:04:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19503' , '38' , '1' ) 09/05/2022 09:04:29 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 ( '56662' , '713' , 'APPARIZIONI DI FATIMA' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 09/05/2022 09:04:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '713' AND id_supplier = '38' 09/05/2022 09:04:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '713' , '38' , '1' ) 09/05/2022 09:05:54 am >> DELETE FROM ps_document WHERE id_document = '49067' 09/05/2022 09:05:54 am >> DELETE FROM ps_document_detail WHERE id_document = '49067' 09/05/2022 09:06:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1453' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 09:06:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1453' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1980.00' , '1622.95' , NOW() , NOW() ) 09/05/2022 09:06:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56663' 09/05/2022 09:06:12 am >> DELETE FROM ps_document_detail WHERE id_document = '56663' 09/05/2022 09:06:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56663' , '18917' , 'CASULA LANA FASCIA MISTO SETA RICAMO A MANO ORO M.F. - 50/370' , '1' , '-1' , '1' , '1980' , '1622.9508196721' , '22' , '0' , '1980.00' ) 09/05/2022 09:06:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '18917' AND id_supplier = '' 09/05/2022 09:06:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18917' , '' , '1' ) 09/05/2022 09:54:57 am >> SELECT document_num FROM ps_document WHERE document_num = '1454' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 09:54:57 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' , '1454' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.70' , '16.97' , NOW() , NOW() ) 09/05/2022 09:54:57 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 = '56664' 09/05/2022 09:54:57 am >> DELETE FROM ps_document_detail WHERE id_document = '56664' 09/05/2022 09:54:57 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 ( '56664' , '3045' , 'CROCE METALLO BUON PASTORE CM 3,8 - G352' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 09/05/2022 09:54:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '3045' AND id_supplier = '' 09/05/2022 09:54:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3045' , '' , '1' ) 09/05/2022 09:54:57 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 ( '56664' , '7202' , 'ARTICOLI RELIGIOSI' , '5' , '-5' , '1' , '1.9' , '1.5573770491803' , '22' , '0' , '9.50' ) 09/05/2022 09:54:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 09/05/2022 09:54:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 09/05/2022 09:54:57 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 ( '56664' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '10.50' ) 09/05/2022 09:54:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 09/05/2022 09:54:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 09/05/2022 10:04:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1455' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 10:04:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1455' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 09/05/2022 10:04:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56665' 09/05/2022 10:04:31 am >> DELETE FROM ps_document_detail WHERE id_document = '56665' 09/05/2022 10:04:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56665' , '7484' , 'PAPA FRANCESCO - FOTO UFF. 25X35 - PAPA FRANCESCO -J.M. BERGOGLIO' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 09/05/2022 10:04:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '7484' AND id_supplier = '' 09/05/2022 10:04:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7484' , '' , '1' ) 09/05/2022 10:39:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1456' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 10:39: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' , '1456' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 09/05/2022 10:39: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 = '56666' 09/05/2022 10:39:26 am >> DELETE FROM ps_document_detail WHERE id_document = '56666' 09/05/2022 10:39: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 ( '56666' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '20' , '-20' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '24.00' ) 09/05/2022 10:39:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '15085' AND id_supplier = '' 09/05/2022 10:39:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15085' , '' , '1' ) 09/05/2022 10:40:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1457' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 10:40:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1457' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 09/05/2022 10:40: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 = '56667' 09/05/2022 10:40:50 am >> DELETE FROM ps_document_detail WHERE id_document = '56667' 09/05/2022 10:40: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 ( '56667' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 09/05/2022 10:40:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 09/05/2022 10:40:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 09/05/2022 11:12:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1458' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 11:12:11 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' , '1458' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.90' , '10.28' , NOW() , NOW() ) 09/05/2022 11:12:11 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 = '56668' 09/05/2022 11:12:11 am >> DELETE FROM ps_document_detail WHERE id_document = '56668' 09/05/2022 11:12:11 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 ( '56668' , '12463' , 'QUADRO CON MAGNETE FATIMA' , '5' , '-5' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '9.00' ) 09/05/2022 11:12:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '12463' AND id_supplier = '' 09/05/2022 11:12:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12463' , '' , '1' ) 09/05/2022 11:12:11 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 ( '56668' , '19517' , 'PAROLA E PREGHIERA - LUG 2022' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 09/05/2022 11:12:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19517' AND id_supplier = '' 09/05/2022 11:12:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19517' , '' , '1' ) 09/05/2022 11:13:45 am >> SELECT document_num FROM ps_document WHERE document_num = '908' AND id_document != '53961' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-29') 09/05/2022 11:13:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '908', document_date = '2022-03-29', 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 = '35.00', price_tax_excluded = '28.69', date_upd = NOW() WHERE id_document = '53961' 09/05/2022 11:13:45 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 = '53961' 09/05/2022 11:13:45 am >> DELETE FROM ps_document_detail WHERE id_document = '53961' 09/05/2022 11:13:45 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 ( '53961' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 09/05/2022 11:13:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 09/05/2022 11:13:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 09/05/2022 11:13:45 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 ( '53961' , '8090' , 'POLO BLU - 3XL' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 09/05/2022 11:13:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '8090' AND id_supplier = '' 09/05/2022 11:13:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8090' , '' , '1' ) 09/05/2022 11:14:16 am >> SELECT document_num FROM ps_document WHERE document_num = '612' AND id_document != '52553' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-03') 09/05/2022 11:14:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '612', document_date = '2022-03-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '50.00', price_tax_excluded = '44.48', date_upd = NOW() WHERE id_document = '52553' 09/05/2022 11:14:16 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 = '52553' 09/05/2022 11:14:16 am >> DELETE FROM ps_document_detail WHERE id_document = '52553' 09/05/2022 11:14:16 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 ( '52553' , '12441' , 'FINO ALLA FINE - VIA CRUCIS' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 09/05/2022 11:14:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '12441' AND id_supplier = '' 09/05/2022 11:14:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12441' , '' , '1' ) 09/05/2022 11:14:16 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 ( '52553' , '19277' , 'INSIEME NELLA MESSA - MAG. 2022' , '1' , '-1' , '4' , '1.7200' , '1.72' , '0' , '' , '1.72' ) 09/05/2022 11:14:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '19277' AND id_supplier = '' 09/05/2022 11:14:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19277' , '' , '1' ) 09/05/2022 11:14:16 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 ( '52553' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.5600' , '0.56' , '0' , '0' , '14.00' ) 09/05/2022 11:14:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 09/05/2022 11:14:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 09/05/2022 11:14:16 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 ( '52553' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '0.8900' , '0.89' , '0' , '0' , '1.78' ) 09/05/2022 11:14:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 09/05/2022 11:14:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 09/05/2022 11:14:16 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 ( '52553' , '17058' , 'POLO GRIGIO CHIARO - 3XL' , '1' , '-1' , '1' , '30.6' , '25.081967213115' , '22' , '0' , '30.60' ) 09/05/2022 11:14:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '17058' AND id_supplier = '' 09/05/2022 11:14:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17058' , '' , '1' ) 09/05/2022 11:43:51 am >> SELECT document_num FROM ps_document WHERE document_num = '1459' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 11:43:51 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' , '1459' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.45' , '23.37' , NOW() , NOW() ) 09/05/2022 11:43:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56669' 09/05/2022 11:43:51 am >> DELETE FROM ps_document_detail WHERE id_document = '56669' 09/05/2022 11:43: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 ( '56669' , '17883' , 'CROCE MOGANO CORPO MET CM 28- 169M' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 09/05/2022 11:43:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '17883' AND id_supplier = '' 09/05/2022 11:43:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17883' , '' , '1' ) 09/05/2022 11:43: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 ( '56669' , '18442' , 'NOVENA A SANTA VERONICA GIULIANI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 09/05/2022 11:43:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '18442' AND id_supplier = '' 09/05/2022 11:43:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18442' , '' , '1' ) 09/05/2022 11:43: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 ( '56669' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/05/2022 11:43:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '7109' AND id_supplier = '' 09/05/2022 11:43:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7109' , '' , '1' ) 09/05/2022 11:43: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 ( '56669' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '6.60' ) 09/05/2022 11:43:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 09/05/2022 11:43:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 09/05/2022 11:44:57 am >> SELECT document_num FROM ps_document WHERE document_num = '1460' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 11:44:57 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' , '1460' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 09/05/2022 11:44:57 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 = '56670' 09/05/2022 11:44:57 am >> DELETE FROM ps_document_detail WHERE id_document = '56670' 09/05/2022 11:44:57 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 ( '56670' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/05/2022 11:44:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 09/05/2022 11:44:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 09/05/2022 12:02:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '78' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 12:02: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 ( '21' , '78' , '2022-05-09' , '' , '2893' , '0' , '4672074' , 'VIA CONVENTO 83025 MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '20.40' , '20.40' , NOW() , NOW() ) 09/05/2022 12:02: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 = '56671' 09/05/2022 12:02:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '56671' 09/05/2022 12:02: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 ( '56671' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '10' , '-10' , '4' , '2.40' , '2.4' , '0' , '15' , '20.40' ) 09/05/2022 12:15:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1461' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 12:15:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1461' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.60' , '6.60' , NOW() , NOW() ) 09/05/2022 12:15:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56672' 09/05/2022 12:15:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '56672' 09/05/2022 12:15:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56672' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.6' , '6.6' , '0' , '0' , '6.60' ) 09/05/2022 12:15:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 09/05/2022 12:15:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 09/05/2022 02:42:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788820990640' AND id_product != '7484' AND ean13 != '' 09/05/2022 02:42:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '12', ean13 = '9788820990640', date_upd = NOW() WHERE id_product = '7484' 09/05/2022 02:42:00 pm >> UPDATE ps_product_lang SET name = 'PAPA FRANCESCO - FOTO UFF. 25X35 ', description = '' WHERE id_product = '7484' 09/05/2022 02:42:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.8197' WHERE id_product = '7484' 09/05/2022 02:42:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.8197', id_tax_rules_group = '1', id_category_default = '104', id_argoment_default = '206', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7484' 09/05/2022 02:42:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '7484' 09/05/2022 02:47:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1441' AND id_document != '56650' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-07') 09/05/2022 02:47:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1441', document_date = '2022-05-07', 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 = '120.01', price_tax_excluded = '102.29', date_upd = NOW() WHERE id_document = '56650' 09/05/2022 02:47:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56650' 09/05/2022 02:47:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '56650' 09/05/2022 02:47:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56650' , '11693' , 'BRACCIALE DECINA CAUCCIU PIETRA - 805/23' , '6' , '-6' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '9.00' ) 09/05/2022 02:47:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11693' AND id_supplier = '' 09/05/2022 02:47:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11693' , '' , '1' ) 09/05/2022 02:47:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56650' , '19530' , 'PERGAMENA COMUNIONE 18X24' , '7' , '-7' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '4.90' ) 09/05/2022 02:47:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19530' AND id_supplier = '' 09/05/2022 02:47:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19530' , '' , '1' ) 09/05/2022 02:47:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56650' , '19486' , 'ROSARIO PER LA PACE - N. SANTILLI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 09/05/2022 02:47:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19486' AND id_supplier = '' 09/05/2022 02:47:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19486' , '' , '1' ) 09/05/2022 02:47:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56650' , '7673' , 'PARTICOLE MM38' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 09/05/2022 02:47:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 09/05/2022 02:47:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 09/05/2022 02:47:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56650' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '17' , '-17' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '20.40' ) 09/05/2022 02:47:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15085' AND id_supplier = '' 09/05/2022 02:47:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15085' , '' , '1' ) 09/05/2022 02:47:13 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 ( '56650' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '9' , '-9' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '18.00' ) 09/05/2022 02:47:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18217' AND id_supplier = '' 09/05/2022 02:47:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18217' , '' , '1' ) 09/05/2022 02:47:13 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 ( '56650' , '1319' , 'BRACCIALE DECINA TAU' , '24' , '-24' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '28.80' ) 09/05/2022 02:47:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1319' AND id_supplier = '' 09/05/2022 02:47:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1319' , '' , '1' ) 09/05/2022 02:47:13 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 ( '56650' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 09/05/2022 02:47:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7098' AND id_supplier = '' 09/05/2022 02:47:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7098' , '' , '1' ) 09/05/2022 02:47:13 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 ( '56650' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '5' , '-5' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '12.50' ) 09/05/2022 02:47:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 09/05/2022 02:47:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 09/05/2022 02:47:13 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 ( '56650' , '1312' , 'BRACCIALE DECINA' , '3' , '-3' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '3.90' ) 09/05/2022 02:47:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '' 09/05/2022 02:47:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' ) 09/05/2022 02:47:13 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 ( '56650' , '18737' , 'CORAGGIO DI ESSERE FELICI - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 09/05/2022 02:47:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18737' AND id_supplier = '' 09/05/2022 02:47:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18737' , '' , '1' ) 09/05/2022 02:49:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001501' AND id_product != '17004' AND ean13 != '' 09/05/2022 02:49:32 pm >> UPDATE ps_product SET id_supplier = '49', reference = '', ean13 = '001501', date_upd = NOW() WHERE id_product = '17004' 09/05/2022 02:49:32 pm >> UPDATE ps_product_lang SET name = 'BIGLIETTo AUGURALe PICCOLo', description = '' WHERE id_product = '17004' 09/05/2022 02:49:32 pm >> UPDATE ps_product SET wholesale_price = '0.31', on_sale = '0', price = '0.6557' WHERE id_product = '17004' 09/05/2022 02:49:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.31', price = '0.6557', id_tax_rules_group = '1', id_category_default = '264', 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 = '17004' 09/05/2022 02:49:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '17004' 09/05/2022 02:49:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001502' AND id_product != '17005' AND ean13 != '' 09/05/2022 02:49:51 pm >> UPDATE ps_product SET id_supplier = '49', reference = '', ean13 = '001502', date_upd = NOW() WHERE id_product = '17005' 09/05/2022 02:49:51 pm >> UPDATE ps_product_lang SET name = 'BIGLIETTO AUGURALE medio', description = '' WHERE id_product = '17005' 09/05/2022 02:49:51 pm >> UPDATE ps_product SET wholesale_price = '0.40', on_sale = '0', price = '0.8197' WHERE id_product = '17005' 09/05/2022 02:49:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.40', price = '0.8197', id_tax_rules_group = '1', id_category_default = '264', 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 = '17005' 09/05/2022 02:49:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '17005' 09/05/2022 02:50:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001501' AND id_product != '17004' AND ean13 != '' 09/05/2022 02:50:06 pm >> UPDATE ps_product SET id_supplier = '49', reference = '', ean13 = '001501', date_upd = NOW() WHERE id_product = '17004' 09/05/2022 02:50:06 pm >> UPDATE ps_product_lang SET name = 'BIGLIETTO AUGURALE PICCOLO', description = '' WHERE id_product = '17004' 09/05/2022 02:50:06 pm >> UPDATE ps_product SET wholesale_price = '0.31', on_sale = '0', price = '0.6557' WHERE id_product = '17004' 09/05/2022 02:50:06 pm >> UPDATE ps_product_shop SET wholesale_price = '0.31', price = '0.6557', id_tax_rules_group = '1', id_category_default = '264', 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 = '17004' 09/05/2022 02:50:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '17004' 09/05/2022 03:13:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884047090' AND id_product != '19154' AND ean13 != '' 09/05/2022 03:13:03 pm >> UPDATE ps_product SET id_supplier = '38', reference = '', ean13 = '9788884047090', date_upd = NOW() WHERE id_product = '19154' 09/05/2022 03:13:03 pm >> UPDATE ps_product_lang SET name = 'SANTA MARIA FRANCESCA DELLE CINQUE PIAGHE - 8021', description = '' WHERE id_product = '19154' 09/05/2022 03:13:03 pm >> UPDATE ps_product SET wholesale_price = '4.20', on_sale = '0', price = '7.0000' WHERE id_product = '19154' 09/05/2022 03:13:03 pm >> UPDATE ps_product_shop SET wholesale_price = '4.20', price = '7.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19154' 09/05/2022 03:13:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '19154' 09/05/2022 03:15:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2/A' AND id_document != '50074' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-01-12') 09/05/2022 03:15:55 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '2/A', document_date = '2022-01-12', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '10.80', price_tax_excluded = '10.80', date_upd = NOW() WHERE id_document = '50074' 09/05/2022 03:15:55 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 = '50074' 09/05/2022 03:15:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '50074' 09/05/2022 03:15:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19517' , 'PAROLA E PREGHIERA - LUG 2022' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 09/05/2022 03:15:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19517' AND id_supplier = '' 09/05/2022 03:15:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19517' , '' , '1' ) 09/05/2022 03:15:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19467' , 'SULLA TUA PAROLA - LUG AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 09/05/2022 03:15:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 09/05/2022 03:15:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 09/05/2022 03:59:20 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2771' 09/05/2022 03:59:20 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 ( '2771' , '10' , '196' , 'ABBAZIA DI CHIARAVALLE' , 'S. MARIA ASSUNTA' , 'PARROCCHIA ' , 'VIA S. BERNARDO, 120' , '' , '29010' , 'ALSENO' , 'DON AMEDEO VALENTE TEL 3314627579' , '0523940132' , '3314627579' , '' , '' , NOW() , NOW() ) 09/05/2022 03:59:20 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2771' 09/05/2022 04:20:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1462' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 04:20: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' , '1462' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 09/05/2022 04:20: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 = '56673' 09/05/2022 04:20:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '56673' 09/05/2022 04:20: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 ( '56673' , '18133' , 'CROCE SAN BENEDETTO CM 11 - CSB2' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 09/05/2022 04:20:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18133' AND id_supplier = '' 09/05/2022 04:20:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18133' , '' , '1' ) 09/05/2022 04:20: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 ( '56673' , '16917' , 'CROCE SAN BENEDETTO CON BASE - PG375-B' , '2' , '-2' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '32.00' ) 09/05/2022 04:20:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16917' AND id_supplier = '' 09/05/2022 04:20:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16917' , '' , '1' ) 09/05/2022 04:20: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 ( '56673' , '13354' , 'ROSARIO LEGNO S. BENEDETTO + SCATOLINA' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 09/05/2022 04:20:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13354' AND id_supplier = '' 09/05/2022 04:20:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13354' , '' , '1' ) 09/05/2022 04:20: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 ( '56673' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 09/05/2022 04:20:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '' 09/05/2022 04:20:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '' , '1' ) 09/05/2022 04:20: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 ( '56673' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 09/05/2022 04:20:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 09/05/2022 04:20:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 09/05/2022 04:20: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 ( '56673' , '9148' , 'ROSARIO LEGNO S. BENEDETTO ' , '3' , '-3' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '15.00' ) 09/05/2022 04:20:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9148' AND id_supplier = '' 09/05/2022 04:20:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9148' , '' , '1' ) 09/05/2022 04:20: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 ( '56673' , '18893' , 'ROSARIO PIETRA - R472' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 09/05/2022 04:20:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18893' AND id_supplier = '' 09/05/2022 04:20:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18893' , '' , '1' ) 09/05/2022 04:20: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 ( '56673' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '5' , '-5' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '7.50' ) 09/05/2022 04:20:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3104' AND id_supplier = '' 09/05/2022 04:20:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3104' , '' , '1' ) 09/05/2022 04:20: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 ( '56673' , '9149' , 'ROSARIO LEGNO S. BENEDETTO CUBO ' , '2' , '-2' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '8.00' ) 09/05/2022 04:20:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9149' AND id_supplier = '' 09/05/2022 04:20:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9149' , '' , '1' ) 09/05/2022 04:20: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 ( '56673' , '13363' , 'CORONA MM 6 ' , '5' , '-5' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '14.50' ) 09/05/2022 04:20:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13363' AND id_supplier = '' 09/05/2022 04:20:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13363' , '' , '1' ) 09/05/2022 04:20: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 ( '56673' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '9.5' , '7.7868852459016' , '22' , '0' , '9.50' ) 09/05/2022 04:20:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 09/05/2022 04:20:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 09/05/2022 04:21:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1463' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 04:21: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' , '1463' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '198.00' , '198.00' , NOW() , NOW() ) 09/05/2022 04:21: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 = '56674' 09/05/2022 04:21:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '56674' 09/05/2022 04:21: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 ( '56674' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '198' , '198' , '0' , '0' , '198.00' ) 09/05/2022 04:21:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 09/05/2022 04:21:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 09/05/2022 04:31:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1464' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 04:31:58 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' , '1464' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '4.67' , NOW() , NOW() ) 09/05/2022 04:31:58 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 = '56675' 09/05/2022 04:31:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '56675' 09/05/2022 04:31:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56675' , '12689' , 'IMMAGINI 50X70' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 09/05/2022 04:31:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12689' AND id_supplier = '' 09/05/2022 04:31:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12689' , '' , '1' ) 09/05/2022 04:31:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56675' , '4998' , 'IMMAGINE SANTA RITA - OGGETTI' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 09/05/2022 04:31:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4998' AND id_supplier = '' 09/05/2022 04:31:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4998' , '' , '1' ) 09/05/2022 04:35:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '59/A' AND id_document != '29452' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2021-06-28') 09/05/2022 04:35:15 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '59/A', document_date = '2021-06-28', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', 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 = '567.00', price_tax_excluded = '521.56', date_upd = NOW() WHERE id_document = '29452' 09/05/2022 04:35:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '29452' 09/05/2022 04:35:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '29452' 09/05/2022 04:35:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '1914' , 'CERA DELLA LITURGIA*******' , '72' , '-72' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '252.00' ) 09/05/2022 04:35:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 09/05/2022 04:35:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 09/05/2022 04:35:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '1914' , 'CERA DELLA LITURGIA****' , '12' , '-12' , '1' , '3.5000' , '2.8688524590164' , '22' , '100' , '0.00' ) 09/05/2022 04:35:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 09/05/2022 04:35:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 09/05/2022 04:35:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '0' , 'FATIMA CM 27' , '2' , '-2' , '0' , '25.0000' , '25' , '0' , '0' , '50.00' ) 09/05/2022 04:35:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 09/05/2022 04:35:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 09/05/2022 04:35:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '0' , 'FATIMA CM 35' , '2' , '-2' , '0' , '35.0000' , '35' , '0' , '0' , '70.00' ) 09/05/2022 04:35:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 09/05/2022 04:35:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 09/05/2022 04:35:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '0' , 'FATIMA CM 55' , '1' , '-1' , '0' , '75.0000' , '75' , '0' , '0' , '75.00' ) 09/05/2022 04:35:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 09/05/2022 04:35:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 09/05/2022 04:35:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '29452' , '0' , 'FATIMA CM 70' , '1' , '-1' , '0' , '120.0000' , '120' , '0' , '0' , '120.00' ) 09/05/2022 04:35:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 09/05/2022 04:35:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 09/05/2022 04:36:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1465' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 04:36: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' , '1465' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.52' , NOW() , NOW() ) 09/05/2022 04:36: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 = '56676' 09/05/2022 04:36:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '56676' 09/05/2022 04:36: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 ( '56676' , '1752' , 'CARTUCCIA TRASPARENTE DIAM. 8 - 457' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 09/05/2022 04:36:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1752' AND id_supplier = '' 09/05/2022 04:36:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1752' , '' , '1' ) 09/05/2022 04:36: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 ( '56676' , '19534' , 'NOVENA ALLA MADONNA DI FATIMA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/05/2022 04:36:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19534' AND id_supplier = '' 09/05/2022 04:36:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19534' , '' , '1' ) 09/05/2022 04:36: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 ( '56676' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 09/05/2022 04:36:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1220' AND id_supplier = '' 09/05/2022 04:36:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1220' , '' , '1' ) 09/05/2022 04:38:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '27' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 04:38:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '27' , '2022-05-09' , '' , '2771' , '0' , '11572' , 'VIA S. BERNARDO, 120 29010 ALSENO' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '78.30' , '78.30' , NOW() , NOW() ) 09/05/2022 04:38: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 = '4960' 09/05/2022 04:38:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '4960' 09/05/2022 04:38: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 ( '4960' , '33' , '100 GIORNI CON LO SPIRITO' , '12' , '-12' , '4' , '7.00' , '7' , '0' , '15' , '71.40' ) 09/05/2022 04:41:34 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2771' 09/05/2022 04:41:34 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 ( '2771' , '10' , '196' , 'ABBAZIA DI CHIARAVALLE' , 'S. MARIA ASSUNTA' , 'PARROCCHIA ' , 'VIA S. BERNARDO, 120' , '' , '29010' , 'ALSENO' , 'DON AMEDEO VALENTE TEL 3314627579' , '0523940132' , '3314627579' , '' , '' , NOW() , NOW() ) 09/05/2022 04:41:34 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2771' 09/05/2022 04:52:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1466' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 04:52:53 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' , '1466' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 09/05/2022 04:52: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 = '56677' 09/05/2022 04:52:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '56677' 09/05/2022 04:52: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 ( '56677' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '14' , '-14' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '49.00' ) 09/05/2022 04:52:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15403' AND id_supplier = '' 09/05/2022 04:52:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15403' , '' , '1' ) 09/05/2022 06:23:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1467' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 06:23:32 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' , '1467' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.92' , NOW() , NOW() ) 09/05/2022 06:23:32 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 = '56678' 09/05/2022 06:23:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '56678' 09/05/2022 06:23:32 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 ( '56678' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 09/05/2022 06:23:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1351' AND id_supplier = '' 09/05/2022 06:23:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1351' , '' , '1' ) 09/05/2022 06:23:33 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 ( '56678' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 09/05/2022 06:23:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1350' AND id_supplier = '' 09/05/2022 06:23:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1350' , '' , '1' ) 09/05/2022 06:23:33 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 ( '56678' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/05/2022 06:23:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5190' AND id_supplier = '' 09/05/2022 06:23:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5190' , '' , '1' ) 09/05/2022 06:24:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1468' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 06:24:44 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' , '1468' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.80' , '10.00' , NOW() , NOW() ) 09/05/2022 06:24: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 = '56679' 09/05/2022 06:24:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '56679' 09/05/2022 06:24: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 ( '56679' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 09/05/2022 06:24:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1351' AND id_supplier = '' 09/05/2022 06:24:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1351' , '' , '1' ) 09/05/2022 06:24: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 ( '56679' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '6.00' ) 09/05/2022 06:24:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1350' AND id_supplier = '' 09/05/2022 06:24:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1350' , '' , '1' ) 09/05/2022 06:24: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 ( '56679' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 09/05/2022 06:24:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18213' AND id_supplier = '' 09/05/2022 06:24:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18213' , '' , '1' ) 09/05/2022 06:24: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 ( '56679' , '19413' , 'CARI SPOSI E SPOSE SCRIVO A VOI' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 09/05/2022 06:24:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19413' AND id_supplier = '' 09/05/2022 06:24:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19413' , '' , '1' ) 09/05/2022 06:26:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1469' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 06:26:36 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' , '1469' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.90' , '8.11' , NOW() , NOW() ) 09/05/2022 06:26:36 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 = '56680' 09/05/2022 06:26:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '56680' 09/05/2022 06:26:36 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 ( '56680' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '9.90' ) 09/05/2022 06:26:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '' 09/05/2022 06:26:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' ) 09/05/2022 06:39:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1408' AND id_document != '56607' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-05') 09/05/2022 06:39:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1408', document_date = '2022-05-05', 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 = '55.06', price_tax_excluded = '55.06', date_upd = NOW() WHERE id_document = '56607' 09/05/2022 06:39: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 = '56607' 09/05/2022 06:39:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '56607' 09/05/2022 06:39: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 ( '56607' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '1' , '-1' , '4' , '4.8' , '4.8' , '0' , '0' , '4.80' ) 09/05/2022 06:39:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 09/05/2022 06:39:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 09/05/2022 06:39: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 ( '56607' , '1147' , 'BIBBIA DI GERUSALEMME X STUDIO' , '1' , '-1' , '4' , '44.0000' , '44' , '0' , '5' , '41.80' ) 09/05/2022 06:39:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1147' AND id_supplier = '' 09/05/2022 06:39:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1147' , '' , '1' ) 09/05/2022 06:39: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 ( '56607' , '3631' , 'DON BOSCO - T. BOSCO' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 09/05/2022 06:39:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3631' AND id_supplier = '' 09/05/2022 06:39:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3631' , '' , '1' ) 09/05/2022 06:39: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 ( '56607' , '19336' , 'VANGELO ROSSO' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 09/05/2022 06:39:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19336' AND id_supplier = '' 09/05/2022 06:39:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19336' , '' , '1' ) 09/05/2022 06:46:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1470' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 06:46:08 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' , '1470' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.02' , '24.93' , NOW() , NOW() ) 09/05/2022 06:46:08 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 = '56681' 09/05/2022 06:46:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '56681' 09/05/2022 06:46: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 ( '56681' , '1132' , 'BIBBIA DELLA PRIMA COMUNIONE - RIL' , '2' , '-2' , '4' , '12.90' , '12.9' , '0' , '5' , '24.52' ) 09/05/2022 06:46:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1132' AND id_supplier = '' 09/05/2022 06:46:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1132' , '' , '1' ) 09/05/2022 06:46: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 ( '56681' , '9797' , 'SEGNALIBRO CRESIMA - 95-26 - OGGETTI' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' ) 09/05/2022 06:46:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9797' AND id_supplier = '' 09/05/2022 06:46:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9797' , '' , '1' ) 09/05/2022 06:47:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1471' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 06:47: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 ( '11' , '1471' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 09/05/2022 06:47: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 = '56682' 09/05/2022 06:47:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '56682' 09/05/2022 06:47: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 ( '56682' , '18223' , 'CORONA MISSIONARIA - R102' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 09/05/2022 06:47:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18223' AND id_supplier = '' 09/05/2022 06:47:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18223' , '' , '1' ) 09/05/2022 07:11:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1472' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 07:11: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' , '1472' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.80' , '5.57' , NOW() , NOW() ) 09/05/2022 07:11: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 = '56683' 09/05/2022 07:11:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '56683' 09/05/2022 07:11: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 ( '56683' , '1936' , 'CERETTI DIAM 26X700 ART. 400' , '2' , '-2' , '1' , '3.40' , '2.7868852459016' , '22' , '0' , '6.80' ) 09/05/2022 07:11:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1936' AND id_supplier = '' 09/05/2022 07:11:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1936' , '' , '1' ) 09/05/2022 07:12:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1473' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-09') 09/05/2022 07:12:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1473' , '2022-05-09' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '116.40' , '95.41' , NOW() , NOW() ) 09/05/2022 07:12: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 = '56684' 09/05/2022 07:12:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '56684' 09/05/2022 07:12: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 ( '56684' , '18897' , 'BRACCIALE DECINA PIETRA - BC1843' , '12' , '-12' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '24.00' ) 09/05/2022 07:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18897' AND id_supplier = '' 09/05/2022 07:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18897' , '' , '1' ) 09/05/2022 07:12: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 ( '56684' , '18896' , 'BRACCIALE DECINA CROMO - BC1759' , '8' , '-8' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '16.00' ) 09/05/2022 07:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18896' AND id_supplier = '' 09/05/2022 07:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18896' , '' , '1' ) 09/05/2022 07:12: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 ( '56684' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '10' , '-10' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '20.00' ) 09/05/2022 07:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18217' AND id_supplier = '' 09/05/2022 07:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18217' , '' , '1' ) 09/05/2022 07:12: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 ( '56684' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 09/05/2022 07:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 09/05/2022 07:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' )