{"id":226,"date":"2020-01-17T12:04:30","date_gmt":"2020-01-17T12:04:30","guid":{"rendered":"http:\/\/helpvn.mshopkeeper.misa.local\/en\/?post_type=ht_kb&#038;p=226"},"modified":"2021-10-02T09:50:43","modified_gmt":"2021-10-02T02:50:43","slug":"170106_nhap_khau_danh_sach_nha_cung_cap_tu_file_excel","status":"publish","type":"ht_kb","link":"\/en\/kb\/170106_nhap_khau_danh_sach_nha_cung_cap_tu_file_excel","title":{"rendered":"Import list of suppliers from an Excel file"},"content":{"rendered":"<p><strong>1. Purpose<\/strong><br \/>\nYou can import an Excel list of suppliers to the software. Usually applicable when the shop starts using software and has an existing Excel file.<\/p>\n<p><strong>2. Instruction steps<\/strong><br \/>\nTo import list of the suppliers from an Excel file, please follow these steps:<br \/>\n<strong><br \/>\nStep 1: Prepare an Excel file<\/strong><br \/>\n1. Select <strong>Utilities\\Supplier<\/strong>.<br \/>\n2. Click <strong>Import<\/strong>.<\/p>\n<blockquote><p><img decoding=\"async\" class=\"img-size100\" src=\"\/en\/wp-content\/uploads\/2020\/02\/742.jpg\" alt=\"\" \/><\/p><\/blockquote>\n<p>3. Download the Excel template file and copy the supplier debt to this file.<\/p>\n<blockquote><p><img decoding=\"async\" class=\"img-size100\" src=\"\/en\/wp-content\/uploads\/2020\/02\/743.jpg\" alt=\"\" \/><\/p>\n<p><img decoding=\"async\" class=\"img-size100\" src=\"\/en\/wp-content\/uploads\/2020\/02\/744.jpg\" alt=\"\" \/><\/p><\/blockquote>\n<p><strong><br \/>\nStep 2: Import the supplier debt balance to the program<\/strong><br \/>\n1. Select <strong>Utilities\\Supplier<\/strong>.<br \/>\n2. Click <strong>Import<\/strong>.<br \/>\n3. Select<strong> Source file<\/strong> to upload the Excel file.<\/p>\n<blockquote><p><img decoding=\"async\" class=\"img-size100\" src=\"\/en\/wp-content\/uploads\/2020\/02\/745.jpg\" alt=\"\" \/><\/p><\/blockquote>\n<p>4. At the step <strong>Check data<\/strong>, the system will show which rows are valid and which are invalid. The invalid rows cannot be imported.<\/p>\n<blockquote><p><img decoding=\"async\" class=\"img-size100\" src=\"\/en\/wp-content\/uploads\/2020\/02\/746.jpg\" alt=\"\" \/><\/p><\/blockquote>\n<p>5. Click <strong>Continue<\/strong>.<br \/>\n6. At the step <strong>Complete<\/strong>, the system will import the valid rows to the program and notify of the import result.<\/p>\n<blockquote><p><img decoding=\"async\" class=\"img-size100\" src=\"\/en\/wp-content\/uploads\/2020\/02\/747.jpg\" alt=\"\" \/><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>1. Purpose You can import an Excel list of suppliers to the software. Usually applicable when the shop starts using software and has an existing Excel file. 2. Instruction steps To import list of the suppliers from an Excel file, please follow these steps: Step 1: Prepare an Excel file&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[129],"ht-kb-tag":[],"class_list":["post-226","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-170101_mua_hang"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Import list of suppliers from an Excel file - User Guide for Shop Management Software MISA eShop<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"\/en\/kb\/170106_nhap_khau_danh_sach_nha_cung_cap_tu_file_excel\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import list of suppliers from an Excel file - User Guide for Shop Management Software MISA eShop\" \/>\n<meta property=\"og:description\" content=\"1. Purpose You can import an Excel list of suppliers to the software. Usually applicable when the shop starts using software and has an existing Excel file. 2. Instruction steps To import list of the suppliers from an Excel file, please follow these steps: Step 1: Prepare an Excel file...\" \/>\n<meta property=\"og:url\" content=\"\/en\/kb\/170106_nhap_khau_danh_sach_nha_cung_cap_tu_file_excel\" \/>\n<meta property=\"og:site_name\" content=\"User Guide for Shop Management Software MISA eShop\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-02T02:50:43+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import list of suppliers from an Excel file - User Guide for Shop Management Software MISA eShop","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"\/en\/kb\/170106_nhap_khau_danh_sach_nha_cung_cap_tu_file_excel","og_locale":"vi_VN","og_type":"article","og_title":"Import list of suppliers from an Excel file - User Guide for Shop Management Software MISA eShop","og_description":"1. Purpose You can import an Excel list of suppliers to the software. Usually applicable when the shop starts using software and has an existing Excel file. 2. Instruction steps To import list of the suppliers from an Excel file, please follow these steps: Step 1: Prepare an Excel file...","og_url":"\/en\/kb\/170106_nhap_khau_danh_sach_nha_cung_cap_tu_file_excel","og_site_name":"User Guide for Shop Management Software MISA eShop","article_modified_time":"2021-10-02T02:50:43+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"\/en\/kb\/170106_nhap_khau_danh_sach_nha_cung_cap_tu_file_excel","url":"\/en\/kb\/170106_nhap_khau_danh_sach_nha_cung_cap_tu_file_excel","name":"Import list of suppliers from an Excel file - User Guide for Shop Management Software MISA eShop","isPartOf":{"@id":"\/en\/#website"},"datePublished":"2020-01-17T12:04:30+00:00","dateModified":"2021-10-02T02:50:43+00:00","breadcrumb":{"@id":"\/en\/kb\/170106_nhap_khau_danh_sach_nha_cung_cap_tu_file_excel#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["\/en\/kb\/170106_nhap_khau_danh_sach_nha_cung_cap_tu_file_excel"]}]},{"@type":"BreadcrumbList","@id":"\/en\/kb\/170106_nhap_khau_danh_sach_nha_cung_cap_tu_file_excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/help.mshopkeeper.com\/en"},{"@type":"ListItem","position":2,"name":"Import list of suppliers from an Excel file"}]}]}},"_links":{"self":[{"href":"\/en\/wp-json\/wp\/v2\/ht-kb\/226","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"\/en\/wp-json\/wp\/v2\/comments?post=226"}],"version-history":[{"count":2,"href":"\/en\/wp-json\/wp\/v2\/ht-kb\/226\/revisions"}],"predecessor-version":[{"id":4931,"href":"\/en\/wp-json\/wp\/v2\/ht-kb\/226\/revisions\/4931"}],"wp:attachment":[{"href":"\/en\/wp-json\/wp\/v2\/media?parent=226"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/en\/wp-json\/wp\/v2\/ht-kb-category?post=226"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}