25/07/2024 09:29:18 am >> SELECT document_num FROM ps_document WHERE document_num = '2341' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-25') 25/07/2024 09:29:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2341' , '2024-07-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.50' , '71.72' , NOW() , NOW() ) 25/07/2024 09:29:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92714' 25/07/2024 09:29:18 am >> DELETE FROM ps_document_detail WHERE id_document = '92714' 25/07/2024 09:29:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92714' , '6405' , 'MENSA DIAM 40X250 - M4025' , '25' , '-25' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '87.50' ) 25/07/2024 10:18:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2342' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-25') 25/07/2024 10:18:20 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' , '2342' , '2024-07-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.80' , '35.00' , NOW() , NOW() ) 25/07/2024 10:18:20 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 = '92715' 25/07/2024 10:18:20 am >> DELETE FROM ps_document_detail WHERE id_document = '92715' 25/07/2024 10:18:20 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 ( '92715' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 25/07/2024 10:18:20 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 ( '92715' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 25/07/2024 10:18:20 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 ( '92715' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 25/07/2024 10:18:20 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 ( '92715' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 25/07/2024 10:47:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2343' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-25') 25/07/2024 10:47:35 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' , '2343' , '2024-07-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '340.00' , '278.69' , NOW() , NOW() ) 25/07/2024 10:47:35 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 = '92716' 25/07/2024 10:47:35 am >> DELETE FROM ps_document_detail WHERE id_document = '92716' 25/07/2024 10:47:35 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 ( '92716' , '22778' , 'CASULA - C2P856' , '1' , '-1' , '1' , '340' , '278.68852459016' , '22' , '0' , '340.00' ) 25/07/2024 10:50:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2344' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-25') 25/07/2024 10:50:17 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' , '2344' , '2024-07-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '260.00' , '213.11' , NOW() , NOW() ) 25/07/2024 10:50:17 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 = '92717' 25/07/2024 10:50:17 am >> DELETE FROM ps_document_detail WHERE id_document = '92717' 25/07/2024 10:50:17 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 ( '92717' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 25/07/2024 10:50:17 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 ( '92717' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 25/07/2024 10:50:17 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 ( '92717' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '165' , '135.24590163934' , '22' , '0' , '165.00' ) 25/07/2024 11:04:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2345' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-25') 25/07/2024 11: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 ( '11' , '2345' , '2024-07-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.90' , '77.85' , NOW() , NOW() ) 25/07/2024 11: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 = '92718' 25/07/2024 11:04:28 am >> DELETE FROM ps_document_detail WHERE id_document = '92718' 25/07/2024 11: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 ( '92718' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 25/07/2024 11: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 ( '92718' , '7202' , 'ARTICOLI RELIGIOSI' , '7' , '-7' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '24.50' ) 25/07/2024 11: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 ( '92718' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 25/07/2024 11:11:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2346' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-25') 25/07/2024 11:11:33 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' , '2346' , '2024-07-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 25/07/2024 11:11:33 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 = '92719' 25/07/2024 11:11:33 am >> DELETE FROM ps_document_detail WHERE id_document = '92719' 25/07/2024 11:11:33 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 ( '92719' , '6811' , 'MOCCOLO 80X200' , '2' , '-2' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '18.00' ) 25/07/2024 11:16:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2347' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-25') 25/07/2024 11:16:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2347' , '2024-07-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.30' , '56.09' , NOW() , NOW() ) 25/07/2024 11:16:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92720' 25/07/2024 11:16:52 am >> DELETE FROM ps_document_detail WHERE id_document = '92720' 25/07/2024 11:16:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92720' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 25/07/2024 11:16:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92720' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 25/07/2024 11:16:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92720' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '14.00' ) 25/07/2024 11:16:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92720' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 25/07/2024 11:37:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2348' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-25') 25/07/2024 11:37:41 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' , '2348' , '2024-07-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '27.05' , NOW() , NOW() ) 25/07/2024 11:37:41 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 = '92721' 25/07/2024 11:37:41 am >> DELETE FROM ps_document_detail WHERE id_document = '92721' 25/07/2024 11:37:41 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 ( '92721' , '21089' , 'ANELLO ROSARIO ARG. - 6450' , '1' , '-1' , '1' , '33.00' , '27.049180327869' , '22' , '0' , '33.00' ) 25/07/2024 11:43:09 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 25/07/2024 11:43:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22780' , '1' , '' , 'nuovo-prodotto' ) 25/07/2024 11:43:09 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22780' , '1' , '1' , '2' , NOW() , NOW() ) 25/07/2024 11:43:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22780' , '0' , '1' , '0' , '0' ) 25/07/2024 11:45:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002295' AND id_product != '22780' AND ean13 != '' 25/07/2024 11:45:09 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002295', date_upd = NOW() WHERE id_product = '22780' 25/07/2024 11:45:09 am >> UPDATE ps_product_lang SET name = 'CASULA LANA - 661', description = '' WHERE id_product = '22780' 25/07/2024 11:45:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '473.7704918032787' WHERE id_product = '22780' 25/07/2024 11:45:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '473.7704918032787', id_tax_rules_group = '1', id_category_default = '432', 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 = '22780' 25/07/2024 11:45:09 am >> DELETE FROM ps_specific_price WHERE id_product = '22780' 25/07/2024 11:45:12 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 = '22780' 25/07/2024 11:45:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22781' , '1' , '' , 'nuovo-prodotto' ) 25/07/2024 11:45:12 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 '22781' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22780' 25/07/2024 11:45:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22781' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22780' 25/07/2024 11:47:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002297' AND id_product != '22781' AND ean13 != '' 25/07/2024 11:47:04 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002297', date_upd = NOW() WHERE id_product = '22781' 25/07/2024 11:47:04 am >> UPDATE ps_product_lang SET name = 'CASULA TRE CROCI - 1206', description = '' WHERE id_product = '22781' 25/07/2024 11:47:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '391.8032786885246' WHERE id_product = '22781' 25/07/2024 11:47:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '391.8032786885246', id_tax_rules_group = '1', id_category_default = '432', 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 = '22781' 25/07/2024 11:47:04 am >> DELETE FROM ps_specific_price WHERE id_product = '22781' 25/07/2024 11:47:22 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 = '22781' 25/07/2024 11:47:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22782' , '1' , '' , 'nuovo-prodotto' ) 25/07/2024 11:47:22 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 '22782' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22781' 25/07/2024 11:47:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22782' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22781' 25/07/2024 11:52:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2349' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-25') 25/07/2024 11:52:17 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' , '2349' , '2024-07-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.80' , '30.54' , NOW() , NOW() ) 25/07/2024 11:52:17 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 = '92722' 25/07/2024 11:52:17 am >> DELETE FROM ps_document_detail WHERE id_document = '92722' 25/07/2024 11:52:17 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 ( '92722' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '10' , '-10' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '7.00' ) 25/07/2024 11:52:17 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 ( '92722' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 25/07/2024 11:52:17 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 ( '92722' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 25/07/2024 11:52:17 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 ( '92722' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 25/07/2024 11:52:17 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 ( '92722' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 25/07/2024 11:52:17 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 ( '92722' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 25/07/2024 11:53:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2350' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-25') 25/07/2024 11:53:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2350' , '2024-07-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.50' , NOW() , NOW() ) 25/07/2024 11:53:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92723' 25/07/2024 11:53:54 am >> DELETE FROM ps_document_detail WHERE id_document = '92723' 25/07/2024 11:53:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92723' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 25/07/2024 11:55:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002296' AND id_product != '22781' AND ean13 != '' 25/07/2024 11:55:18 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002296', date_upd = NOW() WHERE id_product = '22781' 25/07/2024 11:55:18 am >> UPDATE ps_product_lang SET name = 'CASULA TRE CROCI - 1206', description = '' WHERE id_product = '22781' 25/07/2024 11:55:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '391.8033' WHERE id_product = '22781' 25/07/2024 11:55:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '391.8033', id_tax_rules_group = '1', id_category_default = '432', 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 = '22781' 25/07/2024 11:55:18 am >> DELETE FROM ps_specific_price WHERE id_product = '22781' 25/07/2024 11:59:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002297' AND id_product != '22782' AND ean13 != '' 25/07/2024 11:59:27 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002297', date_upd = NOW() WHERE id_product = '22782' 25/07/2024 11:59:27 am >> UPDATE ps_product_lang SET name = 'STOLA - GRECA 2', description = '' WHERE id_product = '22782' 25/07/2024 11:59:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '106.55737704918033' WHERE id_product = '22782' 25/07/2024 11:59:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '106.55737704918033', id_tax_rules_group = '1', id_category_default = '432', 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 = '22782' 25/07/2024 11:59:27 am >> DELETE FROM ps_specific_price WHERE id_product = '22782' 25/07/2024 11:59:30 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 = '22782' 25/07/2024 11:59:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22783' , '1' , '' , 'nuovo-prodotto' ) 25/07/2024 11:59:30 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 '22783' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22782' 25/07/2024 11:59:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22783' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22782' 25/07/2024 12:07: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 ( '31' , '357' , '2024-07-24' , '' , '0' , '118' , '4669176' , 'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE' , '' , '' , '13.5' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '1582.11' , '1296.81' , NOW() , NOW() ) 25/07/2024 12:07: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 = '92724' 25/07/2024 12:07:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '92724' 25/07/2024 12:07: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 ( '92724' , '22780' , 'CASULA LANA - 661' , '1' , '1' , '1' , '250' , '204.91803278689' , '22' , '3' , '295.8500' ) 25/07/2024 12:07:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22780' AND id_supplier = '118' 25/07/2024 12:07:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22780' , '118' , '1' ) 25/07/2024 12:07:01 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 ( '92724' , '22781' , 'CASULA TRE CROCI - 1206' , '1' , '1' , '1' , '206' , '168.85245901639' , '22' , '3' , '243.7804' ) 25/07/2024 12:07:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22781' AND id_supplier = '118' 25/07/2024 12:07:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22781' , '118' , '1' ) 25/07/2024 12:07:01 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 ( '92724' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '3' , '3' , '1' , '59' , '48.360655737705' , '22' , '3' , '209.4618' ) 25/07/2024 12:07:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14354' AND id_supplier = '118' 25/07/2024 12:07:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14354' , '118' , '1' ) 25/07/2024 12:07:01 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 ( '92724' , '20848' , 'CAMICE MONASTICO CON CAPPUCCIO - 21MON' , '2' , '2' , '1' , '93' , '76.229508196721' , '22' , '3' , '220.1124' ) 25/07/2024 12:07:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20848' AND id_supplier = '118' 25/07/2024 12:07:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20848' , '118' , '1' ) 25/07/2024 12:07:01 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 ( '92724' , '22782' , 'STOLA - GRECA 2' , '3' , '3' , '1' , '56' , '45.901639344262' , '22' , '3' , '198.8112' ) 25/07/2024 12:07:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22782' AND id_supplier = '118' 25/07/2024 12:07:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22782' , '118' , '1' ) 25/07/2024 12:07:01 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 ( '92724' , '17352' , 'STOLA MARIANA MISTO SETA- 1021 AM' , '1' , '1' , '1' , '61' , '50' , '22' , '3' , '72.1874' ) 25/07/2024 12:07:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17352' AND id_supplier = '118' 25/07/2024 12:07:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17352' , '118' , '1' ) 25/07/2024 12:07:01 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 ( '92724' , '14724' , 'STOLA MARIANA - ART.1028/342' , '1' , '1' , '1' , '63' , '51.639344262295' , '22' , '3' , '74.5542' ) 25/07/2024 12:07:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14724' AND id_supplier = '118' 25/07/2024 12:07:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14724' , '118' , '1' ) 25/07/2024 12:07:01 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 ( '92724' , '14725' , 'STOLA LANA/SETA/VISC. - ART. 1125' , '4' , '4' , '1' , '53' , '43.44262295082' , '22' , '3' , '250.8808' ) 25/07/2024 12:07:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14725' AND id_supplier = '118' 25/07/2024 12:07:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14725' , '118' , '1' ) 25/07/2024 12:27:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '2351' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-25') 25/07/2024 12:27:07 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' , '2351' , '2024-07-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '67.31' , NOW() , NOW() ) 25/07/2024 12:27:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92725' 25/07/2024 12:27:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '92725' 25/07/2024 12:27:07 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 ( '92725' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '20' , '-20' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '70.00' ) 25/07/2024 12:39:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2352' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-25') 25/07/2024 12:39:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2352' , '2024-07-25' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 25/07/2024 12:39:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92726' 25/07/2024 12:39:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '92726' 25/07/2024 12:39: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 ( '92726' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 25/07/2024 02:48:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2346' AND id_document != '92719' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-25') 25/07/2024 02:48:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2346', document_date = '2024-07-25', 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 = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '92719' 25/07/2024 02:48: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 = '92719' 25/07/2024 02:48:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '92719' 25/07/2024 02:48:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92719' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 25/07/2024 02:51:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2233' AND id_document != '92586' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-10') 25/07/2024 02:51:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2233', document_date = '2024-07-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '24.00', price_tax_excluded = '23.08', date_upd = NOW() WHERE id_document = '92586' 25/07/2024 02:51:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92586' 25/07/2024 02:51:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '92586' 25/07/2024 02:51:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92586' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 25/07/2024 02:51:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92586' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 25/07/2024 03:46:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '84/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-25') 25/07/2024 03:46:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '84/A' , '2024-07-25' , 'A' , '230' , '0' , '4668969' , 'VIA G. NICOTERA, 66 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '432.20' , '432.20' , NOW() , NOW() ) 25/07/2024 03:46:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92727' 25/07/2024 03:46:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '92727' 25/07/2024 03:46: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 ( '92727' , '16060' , 'MEDAGLIA S. ANNA - FM022' , '99' , '-99' , '0' , '0.30' , '0.3' , '' , '0' , '29.70' ) 25/07/2024 03:46: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 ( '92727' , '9202' , 'SANT\'ANNA - 4 ' , '7' , '-7' , '0' , '3.5' , '3.5' , '' , '0' , '24.50' ) 25/07/2024 03:46: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 ( '92727' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '0' , '12.00' , '12' , '' , '0' , '12.00' ) 25/07/2024 03:46: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 ( '92727' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '0' , '4.5' , '4.5' , '' , '0' , '270.00' ) 25/07/2024 03:46: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 ( '92727' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '0' , '7.5' , '7.5' , '' , '0' , '45.00' ) 25/07/2024 03:46: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 ( '92727' , '11151' , 'PAN DI CENA' , '10' , '-10' , '4' , '3.5' , '3.5' , '0' , '0' , '35.00' ) 25/07/2024 03:46: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 ( '92727' , '16689' , 'OSTIA PAN DI CENA mm80' , '8' , '-8' , '0' , '2.00' , '2' , '' , '0' , '16.00' ) 25/07/2024 03:48:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '84/A' AND id_document != '92727' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-25') 25/07/2024 03:48:05 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '84/A', document_date = '2024-07-25', 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 = '432.20', price_tax_excluded = '362.84', date_upd = NOW() WHERE id_document = '92727' 25/07/2024 03:48: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 = '92727' 25/07/2024 03:48:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '92727' 25/07/2024 03:48: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 ( '92727' , '16060' , 'MEDAGLIA S. ANNA - FM022' , '99' , '-99' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '29.70' ) 25/07/2024 03:48: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 ( '92727' , '9202' , 'SANT\'ANNA - 4 ' , '7' , '-7' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '24.50' ) 25/07/2024 03:48: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 ( '92727' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 25/07/2024 03:48: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 ( '92727' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 25/07/2024 03:48: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 ( '92727' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '45.00' ) 25/07/2024 03:48: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 ( '92727' , '11151' , 'PAN DI CENA' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '0' , '35.00' ) 25/07/2024 03:48: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 ( '92727' , '16689' , 'OSTIA PAN DI CENA mm80' , '8' , '-8' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '16.00' ) 25/07/2024 06:44:07 pm >> DELETE FROM ps_document WHERE id_document = '92673' 25/07/2024 06:44:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '92673' 25/07/2024 06:45: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 ( '31' , '1842/24' , '2024-07-25' , '24' , '0' , '125' , '4669745' , 'VIA SIBELLUCCIA, AREA P.I.P. 84088 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3233.00' , '2650.00' , NOW() , NOW() ) 25/07/2024 06:45: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 = '92728' 25/07/2024 06:45:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '92728' 25/07/2024 06:45: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 ( '92728' , '12815' , 'LIBRO DEI CRESIMATI' , '300' , '300' , '1' , '8.8333333' , '7.2404371311475' , '22' , '0' , '3233.0000' ) 25/07/2024 06:45:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12815' AND id_supplier = '125' 25/07/2024 06:45:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12815' , '125' , '1' )