{"id":29999,"date":"2024-12-04T09:24:33","date_gmt":"2024-12-04T02:24:33","guid":{"rendered":"http:\/\/bumashelp.misa.vn\/v2\/?post_type=ht_kb&#038;p=29999"},"modified":"2026-04-15T18:55:59","modified_gmt":"2026-04-15T11:55:59","slug":"lam-the-nao-de-nhap-khau-nhanh-cac-danh-muc-tu-file-excel-vao-phan-mem","status":"publish","type":"ht_kb","link":"\/v4\/knowledge-base\/lam-the-nao-de-nhap-khau-nhanh-cac-danh-muc-tu-file-excel-vao-phan-mem\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 nh\u1eadp kh\u1ea9u nhanh c\u00e1c danh m\u1ee5c t\u1eeb file Excel v\u00e0o ph\u1ea7n m\u1ec1m?"},"content":{"rendered":"<h3>1. T\u1ed5ng quan<\/h3>\n<p>B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn anh\/ch\u1ecb c\u00e1ch nh\u1eadp kh\u1ea9u nhanh c\u00e1c danh m\u1ee5c t\u1eeb file Excel v\u00e0o ph\u1ea7n m\u1ec1m. Thay v\u00ec nh\u1eadp li\u1ec7u th\u1ee7 c\u00f4ng, anh\/ch\u1ecb c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng nh\u1eadp kh\u1ea9u \u0111\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian, gi\u1ea3m sai s\u00f3t v\u00e0 \u0111\u1ed3ng b\u1ed9 d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/p>\n<h3>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/h3>\n<h4 data-section-id=\"13tsz6a\" data-start=\"147\" data-end=\"191\"><span role=\"text\">B\u01b0\u1edbc 1: Truy c\u1eadp ch\u1ee9c n\u0103ng nh\u1eadp kh\u1ea9u<\/span><\/h4>\n<ul>\n<li>V\u00e0o <strong>Danh m\u1ee5c,<\/strong> ch\u1ecdn danh m\u1ee5c c\u1ea7n nh\u1eadp kh\u1ea9u. V\u00ed d\u1ee5: Chi th\u01b0\u1eddng xuy\u00ean.<\/li>\n<li>Nh\u1ea5n <strong>Ti\u1ec7n \u00edch\\Nh\u1eadp t\u1eeb excel.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30047\" src=\"\/v2\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-38.png\" alt=\"\" width=\"1287\" height=\"466\" srcset=\"\/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-38.png 1287w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-38-300x109.png 300w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-38-1024x371.png 1024w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-38-768x278.png 768w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-38-50x18.png 50w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-38-60x22.png 60w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-38-100x36.png 100w\" sizes=\"auto, (max-width: 1287px) 100vw, 1287px\" \/><\/p>\n<h4 data-section-id=\"13tsz6a\" data-start=\"147\" data-end=\"191\"><span role=\"text\">B\u01b0\u1edbc 2: <\/span>Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/h4>\n<ul>\n<li>Ch\u1ecdn file nh\u1eadp kh\u1ea9u t\u1eeb c\u00e1c file d\u1eef li\u1ec7u s\u1eb5n c\u00f3 tr\u00ean m\u00e1y t\u00ednh ho\u1eb7c c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu v\u1ec1 \u0111\u1ec3 t\u1ea1o file d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u.<\/li>\n<li>Ch\u1ecdn\u00a0<strong>Sheet<\/strong>\u00a0ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp kh\u1ea9u.<\/li>\n<li>Ch\u1ecdn<strong>\u00a0D\u00f2ng ti\u00eau \u0111\u1ec1.<\/strong><\/li>\n<li>Ch\u1ecdn ph\u01b0\u01a1ng th\u1ee9c nh\u1eadp kh\u1ea9u th\u00f4ng tin:<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: square;\">\n<li><strong>Th\u00eam m\u1edbi:<\/strong>\u00a0D\u1eef li\u1ec7u ch\u01b0a c\u00f3 s\u1ebd \u0111\u01b0\u1ee3c th\u00eam m\u1edbi, d\u1eef li\u1ec7u \u0111\u00e3 c\u00f3 s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt.<\/li>\n<li><strong>C\u1eadp nh\u1eadt:<\/strong>\u00a0D\u1eef li\u1ec7u ch\u01b0a c\u00f3 s\u1ebd \u0111\u01b0\u1ee3c th\u00eam m\u1edbi, d\u1eef li\u1ec7u \u0111\u00e3 c\u00f3 s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt.<\/li>\n<li><strong>Ghi \u0111\u00e8:<\/strong>\u00a0To\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong h\u1ec7 th\u1ed1ng s\u1ebd \u0111\u01b0\u1ee3c thay th\u1ebf b\u1eb1ng d\u1eef li\u1ec7u trong t\u1ec7p nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30049\" src=\"\/v2\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-39.png\" alt=\"\" width=\"1367\" height=\"687\" srcset=\"\/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-39.png 1367w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-39-300x151.png 300w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-39-1024x515.png 1024w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-39-768x386.png 768w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-39-50x25.png 50w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-39-60x30.png 60w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-39-100x50.png 100w\" sizes=\"auto, (max-width: 1367px) 100vw, 1367px\" \/><\/p>\n<ul>\n<li>Nh\u1ea5n\u00a0<strong>Ti\u1ebfp t\u1ee5c<\/strong>\u00a0\u0111\u1ec3 chuy\u1ec3n qua\u00a0<strong>B\u01b0\u1edbc 3.<\/strong><\/li>\n<\/ul>\n<h4>B\u01b0\u1edbc 3: Gh\u00e9p d\u1eef li\u1ec7u<\/h4>\n<ul>\n<li>H\u1ec7 th\u1ed1ng s\u1ebd t\u1ef1 \u0111\u1ed9ng gh\u00e9p c\u00e1c c\u1ed9t tr\u00ean t\u1ec7p d\u1eef li\u1ec7u v\u1edbi c\u1ed9t tr\u00ean tr\u00ean ph\u1ea7n m\u1ec1m. N\u1ebfu h\u1ec7 th\u1ed1ng kh\u00f4ng gh\u00e9p \u0111\u01b0\u1ee3c c\u1ed9t ho\u1eb7c gh\u00e9p ch\u01b0a \u0111\u00fang th\u00ec anh\/ch\u1ecb c\u00f3 th\u1ec3 t\u1ef1 ch\u1ecdn l\u1ea1i c\u1ed9t cho ch\u00ednh x\u00e1c nh\u1ea5t.\u00a0<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30051\" src=\"\/v2\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-40.png\" alt=\"\" width=\"1374\" height=\"691\" srcset=\"\/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-40.png 1374w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-40-300x151.png 300w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-40-1024x515.png 1024w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-40-768x386.png 768w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-40-50x25.png 50w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-40-60x30.png 60w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-40-100x50.png 100w\" sizes=\"auto, (max-width: 1374px) 100vw, 1374px\" \/><\/p>\n<ul>\n<li>Sau \u0111\u00f3 nh\u1ea5n\u00a0<strong>Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 chuy\u1ec3n sang <strong>B\u01b0\u1edbc 4<\/strong>.<\/li>\n<\/ul>\n<h4>B\u01b0\u1edbc 4: Ki\u1ec3m tra d\u1eef li\u1ec7u<\/h4>\n<ul>\n<li>Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd ki\u1ec3m tra to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong c\u00e1c c\u1ed9t v\u1edbi d\u1eef li\u1ec7u \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh v\u00e0 hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o s\u1ed1 b\u1ea3n ghi h\u1ee3p l\u1ec7\/kh\u00f4ng h\u1ee3p l\u1ec7 cho anh\/ch\u1ecb n\u1eafm \u0111\u01b0\u1ee3c.<\/li>\n<\/ul>\n<ul>\n<li>Khi \u0111\u00f3 anh\/ch\u1ecb c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn:<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: square;\">\n<li>Nh\u1ea5n\u00a0<strong>Nh\u1eadp d\u1eef li\u1ec7u<\/strong>: ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd b\u1ecf qua c\u00e1c m\u00e3 kh\u00f4ng h\u1ee3p l\u1ec7 v\u00e0 ch\u1ec9 nh\u1eadp l\u00ean h\u1ec7 th\u1ed1ng c\u00e1c m\u00e3 h\u1ee3p l\u1ec7.<\/li>\n<li>Ki\u1ec3m tra th\u00f4ng tin chi ti\u1ebft l\u1ed7i tr\u00ean giao di\u1ec7n ho\u1eb7c nh\u1ea5n\u00a0<strong>T\u1ea3i t\u1ec7p ki\u1ec3m tra<\/strong>\u00a0\u0111\u1ec3 t\u1ea3i file k\u1ebft qu\u1ea3 v\u1ec1 m\u00e1y v\u00e0 ki\u1ec3m tra l\u1ea1i. Sau \u0111\u00f3 quay l\u1ea1i b\u01b0\u1edbc 1 \u0111\u1ec3 c\u1eadp nh\u1eadt l\u1ea1i file nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30057\" src=\"\/v2\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-41-1.png\" alt=\"\" width=\"1362\" height=\"686\" srcset=\"\/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-41-1.png 1362w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-41-1-300x151.png 300w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-41-1-1024x516.png 1024w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-41-1-768x387.png 768w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-41-1-50x25.png 50w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-41-1-60x30.png 60w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-41-1-100x50.png 100w\" sizes=\"auto, (max-width: 1362px) 100vw, 1362px\" \/><\/p>\n<h4>B\u01b0\u1edbc 5:\u00a0 K\u1ebft qu\u1ea3 nh\u1eadp kh\u1ea9u d\u1eef li\u1ec7u<\/h4>\n<ul>\n<li>Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u00e1c m\u00e3 \u0111\u00e3 nh\u1eadp kh\u1ea9u th\u00e0nh c\u00f4ng ho\u1eb7c kh\u00f4ng th\u00e0nh c\u00f4ng d\u1ef1a theo k\u1ebft qu\u1ea3 ki\u1ec3m tra \u1edf\u00a0<strong>B\u01b0\u1edbc 4.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30055\" src=\"\/v2\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-42.png\" alt=\"\" width=\"1363\" height=\"697\" srcset=\"\/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-42.png 1363w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-42-300x153.png 300w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-42-1024x524.png 1024w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-42-768x393.png 768w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-42-50x26.png 50w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-42-60x31.png 60w, \/v4\/wp-content\/uploads\/2024\/12\/4-DVCQlapdanhmuc-42-100x51.png 100w\" sizes=\"auto, (max-width: 1363px) 100vw, 1363px\" \/><\/p>\n<ul>\n<li>Nh\u1ea5n\u00a0<strong>\u0110\u00f3ng\u00a0<\/strong>ho\u1eb7c nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u\u00a0<strong>X<\/strong>\u00a0\u0111\u1ec3 ho\u00e0n th\u00e0nh nh\u1eadp kh\u1ea9u danh m\u1ee5c.<\/li>\n<\/ul>\n<h3>3. L\u01b0u \u00fd<\/h3>\n<ul data-start=\"119\" data-end=\"396\">\n<li data-section-id=\"2i9s91\" data-start=\"119\" data-end=\"205\"><strong data-start=\"124\" data-end=\"134\">Ghi \u0111\u00e8<\/strong> s\u1ebd x\u00f3a to\u00e0n b\u1ed9 d\u1eef li\u1ec7u hi\u1ec7n c\u00f3, c\u1ea7n ki\u1ec3m tra k\u1ef9 tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n.<\/li>\n<li data-section-id=\"ml5xbs\" data-start=\"206\" data-end=\"261\">File Excel c\u1ea7n \u0111\u00fang c\u1ea5u tr\u00fac theo m\u1eabu c\u1ee7a h\u1ec7 th\u1ed1ng.<\/li>\n<li data-section-id=\"b42sqg\" data-start=\"262\" data-end=\"323\">C\u00e1c b\u1ea3n ghi kh\u00f4ng h\u1ee3p l\u1ec7 s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o h\u1ec7 th\u1ed1ng.<\/li>\n<li data-section-id=\"hq39n5\" data-start=\"324\" data-end=\"396\">C\u1ea7n ki\u1ec3m tra v\u00e0 gh\u00e9p \u0111\u00fang c\u1ed9t d\u1eef li\u1ec7u tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n nh\u1eadp kh\u1ea9u.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>1. T\u1ed5ng quan B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn anh\/ch\u1ecb c\u00e1ch nh\u1eadp kh\u1ea9u nhanh c\u00e1c danh m\u1ee5c t\u1eeb file Excel v\u00e0o ph\u1ea7n m\u1ec1m. Thay v\u00ec nh\u1eadp li\u1ec7u th\u1ee7 c\u00f4ng, anh\/ch\u1ecb c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng nh\u1eadp kh\u1ea9u \u0111\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian, gi\u1ea3m sai s\u00f3t v\u00e0 \u0111\u1ed3ng b\u1ed9 d\u1eef li\u1ec7u&#8230;<\/p>\n","protected":false},"author":2,"template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[],"ht-kb-tag":[],"class_list":["post-29999","ht_kb","type-ht_kb","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"\/v4\/wp-json\/wp\/v2\/ht-kb\/29999","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/v4\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/v4\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/v4\/wp-json\/wp\/v2\/users\/2"}],"version-history":[{"count":4,"href":"\/v4\/wp-json\/wp\/v2\/ht-kb\/29999\/revisions"}],"predecessor-version":[{"id":38003,"href":"\/v4\/wp-json\/wp\/v2\/ht-kb\/29999\/revisions\/38003"}],"wp:attachment":[{"href":"\/v4\/wp-json\/wp\/v2\/media?parent=29999"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/v4\/wp-json\/wp\/v2\/ht-kb-category?post=29999"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/v4\/wp-json\/wp\/v2\/ht-kb-tag?post=29999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}