{"id":412,"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&p=412"},"modified":"2021-10-05T16:08:12","modified_gmt":"2021-10-05T09:08:12","slug":"170106_nhap_khau_danh_sach_khach_hang_tu_file_excel","status":"publish","type":"ht_kb","link":"\/en\/kb\/170106_nhap_khau_danh_sach_khach_hang_tu_file_excel","title":{"rendered":"Import list of customers from Excel file"},"content":{"rendered":"

1. Purpose<\/strong>
\nThe shop can import list of customers in an Excel file to the program. It is usually applicable to the shop which has just used the program and manages their customers in an Excel file.<\/p>\n

2. Instruction steps<\/strong>
\nTo import list of customers from an Excel file, please follow these steps:
\n
\nStep 1: Prepare an Excel file<\/strong>
\n1. Select Utilities\\Customer<\/strong>.
\n2. Click Import<\/strong>.<\/p>\n

\"\"\"\"<\/p><\/blockquote>\n

3. Download the Excel template file and copy the customer debt balance to this file.<\/p>\n

\"\"\"\"<\/p>\n

\u00a0\"\"<\/strong><\/p><\/blockquote>\n


\nStep 2: Import debt balance to the program<\/strong>
\n1. Select Utilities\\Customer<\/strong>.
\n2. Click Import<\/strong>.
\n3. Select Source file<\/strong> to upload the Excel file.<\/p>\n

\"\"\"\"<\/p><\/blockquote>\n

4. At the step Check data<\/strong>, the program will show valid and invalid rows (for the invalid rows, they will not be imported).<\/p>\n

\"\"\"\"<\/p><\/blockquote>\n

5. Click Continue<\/strong>.
\n6. At the step Complete<\/strong>, the program will automatically import valid rows and notify of import result.<\/p>\n

\"\"\"\"<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

1. Purpose The shop can import list of customers in an Excel file to the program. It is usually applicable to the shop which has just used the program and manages their customers in an Excel file. 2. Instruction steps To import list of customers from an Excel file, please…<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[186],"ht-kb-tag":[],"class_list":["post-412","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-quan_ly_khach_hang"],"yoast_head":"\nImport list of customers from 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_khach_hang_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 customers from Excel file - User Guide for Shop Management Software MISA eShop\" \/>\n<meta property=\"og:description\" content=\"1. Purpose The shop can import list of customers in an Excel file to the program. It is usually applicable to the shop which has just used the program and manages their customers in an Excel file. 2. Instruction steps To import list of customers from an Excel file, please...\" \/>\n<meta property=\"og:url\" content=\"\/en\/kb\/170106_nhap_khau_danh_sach_khach_hang_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-05T09:08:12+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 customers from 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_khach_hang_tu_file_excel","og_locale":"vi_VN","og_type":"article","og_title":"Import list of customers from Excel file - User Guide for Shop Management Software MISA eShop","og_description":"1. Purpose The shop can import list of customers in an Excel file to the program. It is usually applicable to the shop which has just used the program and manages their customers in an Excel file. 2. Instruction steps To import list of customers from an Excel file, please...","og_url":"\/en\/kb\/170106_nhap_khau_danh_sach_khach_hang_tu_file_excel","og_site_name":"User Guide for Shop Management Software MISA eShop","article_modified_time":"2021-10-05T09:08:12+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_khach_hang_tu_file_excel","url":"\/en\/kb\/170106_nhap_khau_danh_sach_khach_hang_tu_file_excel","name":"Import list of customers from 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-05T09:08:12+00:00","breadcrumb":{"@id":"\/en\/kb\/170106_nhap_khau_danh_sach_khach_hang_tu_file_excel#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["\/en\/kb\/170106_nhap_khau_danh_sach_khach_hang_tu_file_excel"]}]},{"@type":"BreadcrumbList","@id":"\/en\/kb\/170106_nhap_khau_danh_sach_khach_hang_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 customers from Excel file"}]}]}},"_links":{"self":[{"href":"\/en\/wp-json\/wp\/v2\/ht-kb\/412","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=412"}],"version-history":[{"count":3,"href":"\/en\/wp-json\/wp\/v2\/ht-kb\/412\/revisions"}],"predecessor-version":[{"id":5043,"href":"\/en\/wp-json\/wp\/v2\/ht-kb\/412\/revisions\/5043"}],"wp:attachment":[{"href":"\/en\/wp-json\/wp\/v2\/media?parent=412"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/en\/wp-json\/wp\/v2\/ht-kb-category?post=412"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}