{"id":1905,"date":"2023-05-18T16:59:35","date_gmt":"2023-05-18T14:59:35","guid":{"rendered":"https:\/\/www.syncrogest.it\/guide\/?p=1905"},"modified":"2023-12-12T13:18:12","modified_gmt":"2023-12-12T12:18:12","slug":"preparare-i-file-excel-per-importazione","status":"publish","type":"post","link":"https:\/\/www.syncrogest.it\/guide\/2023\/05\/18\/preparare-i-file-excel-per-importazione\/","title":{"rendered":"Come preparare i file Excel per l&#8217;importazione?"},"content":{"rendered":"<section class=\"wpb-content-wrapper\"><div class=\"vc_row wpb_row vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\n\t<div class=\"wpb_text_column wpb_content_element \" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<h2>In questa guida ti spiegheremo Come preparare i file excel per l&#8217;importazione in modo corretto.<\/h2>\n<h4><span class=\"ez-toc-section\" id=\"Ma_il_team_di_Syncrogest_e_sempre_a_disposizione_per_facilitare_quanto_possibile_il_tuo_utilizzo_del_gestionale\"><\/span>Ma il team di <a href=\"https:\/\/www.syncrogest.it\/\" target=\"_blank\" rel=\"noopener\">Syncrogest<\/a> \u00e8 sempre a disposizione per facilitare quanto possibile il tuo utilizzo del gestionale.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<div class=\"wpb_text_column wpb_content_element \" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<h2>Istruzioni per tipologia di import file excel:<\/h2>\n<ul>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"File_per_import_Listino_Prodotti_max_20_mila_record\"><\/span><strong>File per import Listino Prodotti: (max 20 mila record)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Se compili anche la colonna della giacenza verr\u00e0 generato in automatico un primo movimento in entrata per carico del Magazzino di Default.<\/li>\n<\/ul>\n<div class=\"st-alert st-alert- with_title\"><span>N.B.<\/span>campi obbligatori: codice (univoco per ogni prodotto) e nome prodotto (in assenza dei campi obbligatori, il record sar\u00e0 scartato dall\u2019import)<\/div>\n<p><a href=\"https:\/\/www.syncrogest.it\/guide\/2019\/02\/14\/come-importare-lista-prodotti\/\">Vai alla guida per importare i prodotti<\/a><\/p>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<div  class=\"wpb_single_image wpb_content_element vc_align_center\">\n\t\t\n\t\t<figure class=\"wpb_wrapper vc_figure\">\n\t\t\t<div class=\"vc_single_image-wrapper   vc_box_border_grey\"><img width=\"2403\" height=\"587\" src=\"https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.51.27.png\" class=\"vc_single_image-img attachment-full\" alt=\"importazione file excel prodotti\" decoding=\"async\" loading=\"lazy\" title=\"Schermata 2023-05-25 alle 16.51.27\" srcset=\"https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.51.27.png 2403w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.51.27-300x73.png 300w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.51.27-1024x250.png 1024w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.51.27-768x188.png 768w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.51.27-1536x375.png 1536w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.51.27-2048x500.png 2048w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.51.27-60x15.png 60w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.51.27-150x37.png 150w\" sizes=\"(max-width: 2403px) 100vw, 2403px\" \/><\/div>\n\t\t<\/figure>\n\t<\/div>\n<\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\n\t<div class=\"wpb_text_column wpb_content_element \" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<ul>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"File_per_limport_delle_Anagrafiche_max_20_mila_record\"><\/span><strong>File per l\u2019import delle Anagrafiche: (max 20 mila record)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Compila un file excel per tutti i clienti ed uno separato con tutti i fornitori per importarli con l\u2019etichetta corretta Cliente o Fornitore.<\/li>\n<\/ul>\n<div class=\"st-alert st-alert- with_title\"><span>N.B.<\/span>se una certa anagrafica \u00e8 sia cliente che fornitore, potrete poi segnalarlo in Syncrogest associando anche la seconda etichetta.<\/p>\n<p>campi obbligatori: Ragione Sociale, Indirizzo, Citt\u00e0 (senza questi dati, il record sar\u00e0 scartato dall\u2019import).<\/div>\n<p><a href=\"https:\/\/www.syncrogest.it\/guide\/2019\/02\/14\/come-importare-le-anagrafiche\/\">Vai alla guida per importare le anagrafiche<\/a><\/p>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<div  class=\"wpb_single_image wpb_content_element vc_align_center\">\n\t\t\n\t\t<figure class=\"wpb_wrapper vc_figure\">\n\t\t\t<div class=\"vc_single_image-wrapper   vc_box_border_grey\"><img width=\"2420\" height=\"604\" src=\"https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.49.50.png\" class=\"vc_single_image-img attachment-full\" alt=\"importazione file exel anagrafiche\" decoding=\"async\" loading=\"lazy\" title=\"Schermata 2023-05-25 alle 16.49.50\" srcset=\"https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.49.50.png 2420w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.49.50-300x75.png 300w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.49.50-1024x256.png 1024w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.49.50-768x192.png 768w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.49.50-1536x383.png 1536w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.49.50-2048x511.png 2048w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.49.50-60x15.png 60w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/05\/Schermata-2023-05-25-alle-16.49.50-150x37.png 150w\" sizes=\"(max-width: 2420px) 100vw, 2420px\" \/><\/div>\n\t\t<\/figure>\n\t<\/div>\n<\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\n\t<div class=\"wpb_text_column wpb_content_element \" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<ul>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"File_per_import_Contatti\"><\/span><strong>File per import Contatti:<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La compilazione del campo P.iva o Cod Personale permette di fare un import massivo di contatti per anagrafiche clienti diverse; in alternativa potete selezionare il cliente prima di fare l&#8217;import e importare solo i contatti di quel cliente(*).<\/li>\n<\/ul>\n<div class=\"st-alert st-alert- with_title\"><span>N.B.<\/span>campi obbligatori: P.Iva o Cod Personale del cliente(*), Nome, Cognome<\/div>\n<p><a href=\"https:\/\/www.syncrogest.it\/guide\/2022\/03\/29\/come-importare-i-contatti\/\">Vai alla guida per importare i contatti.<\/a><\/p>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<div  class=\"wpb_single_image wpb_content_element vc_align_center\">\n\t\t\n\t\t<figure class=\"wpb_wrapper vc_figure\">\n\t\t\t<div class=\"vc_single_image-wrapper   vc_box_border_grey\"><img width=\"2860\" height=\"588\" src=\"https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40.png\" class=\"vc_single_image-img attachment-full\" alt=\"importazione file excel impianti\" decoding=\"async\" loading=\"lazy\" title=\"Screenshot 2023-12-12 alle 12.11.40\" srcset=\"https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40.png 2860w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40-300x62.png 300w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40-1024x211.png 1024w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40-768x158.png 768w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40-1536x316.png 1536w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40-2048x421.png 2048w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40-60x12.png 60w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40-150x31.png 150w\" sizes=\"(max-width: 2860px) 100vw, 2860px\" \/><\/div>\n\t\t<\/figure>\n\t<\/div>\n<\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\n\t<div class=\"wpb_text_column wpb_content_element \" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<ul>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"File_per_import_Impianti\"><\/span><strong>File per import Impianti:<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>La compilazione del campo P.iva o Cod Personale permette di fare un import massivo di impianti per clienti diversi; in alternativa potete selezionare il cliente prima di fare l&#8217;import e importare solo gli impianti di quel cliente(*).<\/li>\n<\/ul>\n<div class=\"st-alert st-alert- with_title\"><span>N.B.<\/span>campi obbligatori: P.Iva o Cod Personale del cliente(*), Nome impianto, Matricola Indirizzo, Citt\u00e0, Data di installazione (senza questi dati, il record sar\u00e0 scartato dall&#8217;import)<\/div>\n<p>Vai alla guida per importare gli impianti<\/p>\n\n\t\t<\/div>\n\t<\/div>\n\n\t<div  class=\"wpb_single_image wpb_content_element vc_align_center\">\n\t\t\n\t\t<figure class=\"wpb_wrapper vc_figure\">\n\t\t\t<div class=\"vc_single_image-wrapper   vc_box_border_grey\"><img width=\"2860\" height=\"588\" src=\"https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40.png\" class=\"vc_single_image-img attachment-full\" alt=\"importazione file excel impianti\" decoding=\"async\" loading=\"lazy\" title=\"Screenshot 2023-12-12 alle 12.11.40\" srcset=\"https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40.png 2860w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40-300x62.png 300w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40-1024x211.png 1024w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40-768x158.png 768w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40-1536x316.png 1536w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40-2048x421.png 2048w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40-60x12.png 60w, https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-12-alle-12.11.40-150x31.png 150w\" sizes=\"(max-width: 2860px) 100vw, 2860px\" \/><\/div>\n\t\t<\/figure>\n\t<\/div>\n<\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><h2 style=\"text-align: center;font-family:Source Sans Pro;font-weight:700;font-style:normal\" class=\"vc_custom_heading vc_custom_1561380410829\" >Scarica gli esempi di Syncrogest<\/h2><\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_row-fluid vc_row-o-equal-height vc_row-o-content-middle vc_row-flex\"><div class=\"wpb_column vc_column_container vc_col-sm-6\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><div class=\"vc_btn3-container vc_btn3-center\" ><a class=\"vc_general vc_btn3 vc_btn3-size-lg vc_btn3-shape-rounded vc_btn3-style-modern vc_btn3-block vc_btn3-icon-left vc_btn3-color-info\" href=\"https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Esempio_Import_Prodotti_2024.xlsx\" title=\"\" target=\"_blank\"><i class=\"vc_btn3-icon \"><\/i> Esempio Import prodotti<\/a><\/div><div class=\"vc_btn3-container vc_btn3-center\" ><a class=\"vc_general vc_btn3 vc_btn3-size-lg vc_btn3-shape-rounded vc_btn3-style-modern vc_btn3-block vc_btn3-icon-left vc_btn3-color-danger\" href=\"https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Esempio_Import_Impianti_2024.xlsx\" title=\"\" target=\"_blank\"><i class=\"vc_btn3-icon \"><\/i> Esempio Import impianti<\/a><\/div><\/div><\/div><\/div><div class=\"wpb_column vc_column_container vc_col-sm-6\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><div class=\"vc_btn3-container vc_btn3-center\" ><a class=\"vc_general vc_btn3 vc_btn3-size-lg vc_btn3-shape-rounded vc_btn3-style-modern vc_btn3-block vc_btn3-icon-left vc_btn3-color-orange\" href=\"https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Esempio_Import_Anagrafiche_2024.xlsx\" title=\"\" target=\"_blank\"><i class=\"vc_btn3-icon \"><\/i> Esempio Import anagrafiche<\/a><\/div><div class=\"vc_btn3-container vc_btn3-center\" ><a class=\"vc_general vc_btn3 vc_btn3-size-lg vc_btn3-shape-rounded vc_btn3-style-modern vc_btn3-block vc_btn3-icon-left vc_btn3-color-success\" href=\"https:\/\/www.syncrogest.it\/guide\/wp-content\/uploads\/2023\/12\/Esempio_Import_Contatti_Referente_2024.xlsx\" title=\"\" target=\"_blank\"><i class=\"vc_btn3-icon \"><\/i> Esempio Import Contatti<\/a><\/div><\/div><\/div><\/div><\/div><div class=\"vc_row wpb_row vc_row-fluid\"><div class=\"wpb_column vc_column_container vc_col-sm-12\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\n\t<div class=\"wpb_text_column wpb_content_element \" >\n\t\t<div class=\"wpb_wrapper\">\n\t\t\t<h3><span class=\"ez-toc-section\" id=\"Vai_a_vedere_il_video\"><\/span><a href=\"https:\/\/youtu.be\/KSdJWaUPNJQ\">Vai a vedere il video<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><\/div><\/div>\n<\/section>"},"excerpt":{"rendered":"<p>Il team di Syncrogest \u00e8 sempre a disposizione per facilitare quanto possibile il vostro utilizzo del gestionale. Scopri come preparare i file excel per l&#8217;importazione<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[34],"tags":[150,149,151,39],"_links":{"self":[{"href":"https:\/\/www.syncrogest.it\/guide\/wp-json\/wp\/v2\/posts\/1905"}],"collection":[{"href":"https:\/\/www.syncrogest.it\/guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.syncrogest.it\/guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.syncrogest.it\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.syncrogest.it\/guide\/wp-json\/wp\/v2\/comments?post=1905"}],"version-history":[{"count":32,"href":"https:\/\/www.syncrogest.it\/guide\/wp-json\/wp\/v2\/posts\/1905\/revisions"}],"predecessor-version":[{"id":4079,"href":"https:\/\/www.syncrogest.it\/guide\/wp-json\/wp\/v2\/posts\/1905\/revisions\/4079"}],"wp:attachment":[{"href":"https:\/\/www.syncrogest.it\/guide\/wp-json\/wp\/v2\/media?parent=1905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.syncrogest.it\/guide\/wp-json\/wp\/v2\/categories?post=1905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.syncrogest.it\/guide\/wp-json\/wp\/v2\/tags?post=1905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}