<\/span><\/p>\n

C\u00e1ch 2: Nh\u1eadp t\u1eeb Excel d\u1eef li\u1ec7u t\u1ed3n kho \u0111\u1ea7u k\u1ef3<\/strong><\/p>\n

<\/div>

\n
\u0110\u1ec3 nh\u1eadp t\u1ed3n kho h\u00e0ng lo\u1ea1t<\/strong> m\u1ed9t c\u00e1ch nhanh ch\u00f3ng<\/strong>, ch\u1ecdn ch\u1ee9c n\u0103ng Nh\u1eadp t\u1eeb excel, <\/strong>sau \u0111\u00f3 th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n
$\"\"$ <\/p>\n
B\u01b0\u1edbc 1:<\/u> Ch\u1ecdn t\u1ec7p ngu\u1ed3n<\/strong><\/p>\n
\n
Ch\u1ecdn file nh\u1eadp kh\u1ea9u<\/strong> t\u1eeb c\u00e1c file d\u1eef li\u1ec7u s\u1eb5n c\u00f3 tr\u00ean m\u00e1y t\u00ednh<\/strong> ho\u1eb7c c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu v\u1ec1 \u0111\u1ec3 nh\u1eadp theo file d\u1eef li\u1ec7u nh\u1eadp kh\u1ea9u<\/strong>.<\/li>\n
Ch\u1ecdn sheet c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp<\/strong> v\u00e0 l\u1ef1a ch\u1ecdn d\u00f2ng b\u1eaft \u0111\u1ea7u l\u1ea5y d\u1eef li\u1ec7u<\/strong>.<\/li>\n
Ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p nh\u1eadp d\u1eef li\u1ec7u<\/strong> theo mong mu\u1ed1n.<\/li>\n
Sau khi \u0111\u00e3 ho\u00e0n t\u1ea5t l\u1ef1a ch\u1ecdn, nh\u1ea5n Ti\u1ebfp t\u1ee5c<\/strong> \u0111\u1ec3 chuy\u1ec3n sang b\u01b0\u1edbc 2.<\/li>\n<\/ul>\n
B\u01b0\u1edbc 2:<\/u><\/strong>\u00a0Gh\u00e9p d\u1eef li\u1ec7u<\/strong>:<\/p>\n
Th\u1ef1c hi\u1ec7n gh\u00e9p c\u00e1c c\u1ed9t trong t\u1ec7p ngu\u1ed3n<\/strong> t\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u1ed9t d\u1eef li\u1ec7u tr\u00ean ph\u1ea7n m\u1ec1m<\/strong>:<\/p>\n
\n
Tr\u01b0\u1eddng h\u1ee3p l\u1ea5y t\u1eeb file m\u1eabu<\/strong> th\u00ec ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd t\u1ef1 \u0111\u1ed9ng gh\u00e9p<\/strong> c\u00e1c c\u1ed9t tr\u00ean file d\u1eef li\u1ec7u v\u00e0 c\u00e1c c\u1ed9t th\u00f4ng tin tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh.<\/li>\n
Tr\u01b0\u1eddng h\u1ee3p l\u00e0 file do t\u1ef1 t\u1ea1o<\/strong> kh\u00f4ng theo m\u1eabu ch\u01b0\u01a1ng tr\u00ecnh th\u00ec c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n gh\u00e9p c\u1ed9t th\u1ee7 c\u00f4ng.<\/strong><\/li>\n<\/ul>\n
L\u01b0u \u00fd<\/strong>:<\/em><\/p>\n
\n
T\u1ea1i d\u00f2ng\u00a0c\u00f3 t\u00edch ch\u1ecdn<\/strong>\u00a0\u201cB\u1eaft bu\u1ed9c gh\u00e9p c\u1ed9t v\u00e0 nh\u1eadp th\u00f4ng tin\u201d\u00a0<\/strong> th\u00ec ph\u1ea3i \u0111\u1ea3m b\u1ea3o c\u1ed9t tr\u00ean t\u1ec7p excel t\u01b0\u01a1ng \u1ee9ng<\/strong> c\u00f3 nh\u1eadp \u0111\u1ea7y \u0111\u1ee7 th\u00f4ng tin li\u00ean quan.<\/em><\/li>\n
N\u1ebfu\u00a0kh\u00f4ng t\u00edch ch\u1ecdn<\/strong>\u00a0\u201cB\u1eaft bu\u1ed9c gh\u00e9p c\u1ed9t v\u00e0 nh\u1eadp th\u00f4ng tin\u201d<\/strong>, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd l\u1ea5y th\u00f4ng tin ng\u1ea7m \u0111\u1ecbnh ho\u1eb7c \u0111\u1ec3 tr\u1ed1ng theo y\u00eau c\u1ea7u c\u1ee7a t\u1eebng tr\u01b0\u1eddng d\u1eef li\u1ec7u theo t\u1eebng danh m\u1ee5c, ch\u1ee9ng t\u1eeb.<\/em><\/li>\n<\/ul>\n
B\u01b0\u1edbc 3:<\/u><\/strong>\u00a0Ki\u1ec3m tra d\u1eef li\u1ec7u<\/strong><\/p>\n
\n
Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd ki\u1ec3m tra to\u00e0n b\u1ed9 d\u1eef li\u1ec7u<\/strong> trong c\u00e1c c\u1ed9t v\u1edbi d\u1eef li\u1ec7u<\/strong> \u0111\u00e3 t\u1ed3n t\u1ea1i tr\u00ean ch\u01b0\u01a1ng tr\u00ecnh v\u00e0 hi\u1ec3n th\u1ecb s\u1ed1 l\u01b0\u1ee3ng b\u1ea3n ghi h\u1ee3p l\u1ec7\/l\u1ed7i,<\/strong> Khi \u0111\u00f3 c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn:\n
\n
Nh\u1ea5n\u00a0Th\u1ef1c hi\u1ec7n<\/strong>: ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd b\u1ecf qua c\u00e1c m\u00e3 kh\u00f4ng h\u1ee3p l\u1ec7<\/strong> v\u00e0 ch\u1ec9 nh\u1eadp l\u00ean h\u1ec7 th\u1ed1ng c\u00e1c m\u00e3 c\u00f3 t\u00ecnh tr\u1ea1ng h\u1ee3p l\u1ec7<\/strong>.<\/li>\n
Ki\u1ec3m tra th\u00f4ng tin chi ti\u1ebft l\u1ed7i<\/strong> tr\u00ean giao di\u1ec7n ho\u1eb7c t\u1ea3i file k\u1ebft qu\u1ea3 \u0111\u1ec3 ki\u1ec3m tra l\u1ea1i<\/strong>. Sau \u0111\u00f3 c\u00f3 th\u1ec3 quay l\u1ea1i b\u01b0\u1edbc 1 \u0111\u1ec3 c\u1eadp nh\u1eadt l\u1ea1i file nh\u1eadp kh\u1ea9u.<\/strong><\/li>\n<\/ul>\n<\/li>\n
Ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u00e1c m\u00e3 \u0111\u00e3 nh\u1eadp th\u00e0nh c\u00f4ng ho\u1eb7c kh\u00f4ng th\u00e0nh c\u00f4ng d\u1ef1a theo k\u1ebft qu\u1ea3 ki\u1ec3m tra.<\/strong><\/li>\n
Nh\u1ea5n\u00a0\u0110\u00f3ng\u00a0<\/strong>ho\u1eb7c nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u\u00a0X<\/strong>\u00a0\u0111\u1ec3 ho\u00e0n th\u00e0nh nh\u1eadp kh\u1ea9u danh m\u1ee5c.<\/li>\n<\/ul>\n
$\"\"$ <\/p>\n<\/div><\/div>\n<\/div>\n
Sau khi th\u00eam, d\u1eef li\u1ec7u khai b\u00e1o t\u1ed3n kho c\u1ee7a VTHH s\u1ebd \u0111\u01b0\u1ee3c th\u00eam v\u00e0o h\u1ec7 th\u1ed1ng. Tr\u00ean danh s\u00e1ch c\u00f3 th\u1ec3:<\/p>\n
\n
T\u00ecm ki\u1ebfm d\u1eef li\u1ec7u theo t\u1eeb kh\u00f3a<\/strong>, l\u1ecdc<\/strong> xem theo t\u1eebng kho trong nh\u00e0 m\u00e1y.<\/li>\n
Ch\u1ec9nh s\u1eeda\/x\u00f3a<\/strong> d\u1eef li\u1ec7u t\u1ed3n kho \u0111\u1ea7u k\u1ef3.<\/li>\n
Xu\u1ea5t kh\u1ea9u d\u1eef li\u1ec7u ra file Excel.<\/strong><\/li>\n<\/ul>\n
$\"\"$ <\/p>\n","protected":false},"excerpt":{"rendered":"
1. T\u1ed5ng quan B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn v\u1ec1 t\u00ednh n\u0103ng T\u1ed3n kho \u0111\u1ea7u k\u1ef3 t\u1ea1i nh\u00e0 m\u00e1y, qu\u1ea3n l\u00fd s\u1ea3n xu\u1ea5t khai b\u00e1o s\u1ed1 l\u01b0\u1ee3ng v\u1eadt t\u01b0, nguy\u00ean v\u1eadt li\u1ec7u c\u00f3 s\u1eb5n trong kho t\u1ea1i nh\u00e0 m\u00e1y tr\u01b0\u1edbc khi b\u1eaft \u0111\u1ea7u m\u1ed9t k\u1ef3 s\u1ea3n xu\u1ea5t m\u1edbi (v\u00ed d\u1ee5: \u0111\u1ea7u th\u00e1ng,…<\/p>\n","protected":false},"author":115,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[255],"ht-kb-tag":[],"class_list":["post-19111","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-kho-vat-tu"],"_links":{"self":[{"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/ht-kb\/19111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/comments?post=19111"}],"version-history":[{"count":5,"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/ht-kb\/19111\/revisions"}],"predecessor-version":[{"id":23465,"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/ht-kb\/19111\/revisions\/23465"}],"wp:attachment":[{"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/media?parent=19111"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/ht-kb-category?post=19111"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/amis-san-xuat\/wp-json\/wp\/v2\/ht-kb-tag?post=19111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}