{"id":776,"date":"2022-04-29T16:29:54","date_gmt":"2022-04-29T08:29:54","guid":{"rendered":"https:\/\/irwanto.net\/blog\/?p=776"},"modified":"2022-04-29T16:29:56","modified_gmt":"2022-04-29T08:29:56","slug":"panduan-u6-download-produk-from-excel","status":"publish","type":"post","link":"https:\/\/irwanto.net\/blog\/panduan-u6-download-produk-from-excel-776.html","title":{"rendered":"Panduan U6 &#8211; Download Produk From Excel"},"content":{"rendered":"<p><strong>Cara melihat keterangan kolom excel hasil dari export excel U6<\/strong><\/p>\n<p>Teknik Berlaku semua download excel untuk melihat keterangan<\/p>\n<p>Buat produk baru isi sembarang seperti ini :<\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" width=\"1014\" height=\"575\" class=\"wp-image-778\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-5.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-5.png 1014w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-5-300x170.png 300w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-5-768x436.png 768w\" sizes=\"auto, (max-width: 1014px) 100vw, 1014px\" \/><\/strong><\/p>\n<p><strong>Lalu export ke excel dari U6<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"532\" class=\"wp-image-779\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-6.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-6.png 816w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-6-300x196.png 300w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-6-768x501.png 768w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><\/strong><\/p>\n<p><strong>Maka hasilnya<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"221\" class=\"wp-image-780\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-7.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-7.png 975w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-7-300x68.png 300w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-7-768x174.png 768w\" sizes=\"auto, (max-width: 975px) 100vw, 975px\" \/><\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" width=\"767\" height=\"677\" class=\"wp-image-781\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-8.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-8.png 767w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-8-300x265.png 300w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/><\/strong><\/p>\n<p><strong>Dari sekian banyak kolom tidak semuanya dipakai dan diubah, cukup yang perlu aja, tapi wajib ada.<\/strong><\/p>\n<p><strong>TIDAK BOLEH MENAMBAH KOLOM, MERUBAH NAMA KOLOM<\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" width=\"1242\" height=\"162\" class=\"wp-image-782\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-9.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-9.png 1242w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-9-300x39.png 300w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-9-1024x134.png 1024w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-9-768x100.png 768w\" sizes=\"auto, (max-width: 1242px) 100vw, 1242px\" \/><\/strong><\/p>\n<p><strong> <img loading=\"lazy\" decoding=\"async\" width=\"1014\" height=\"575\" class=\"wp-image-783\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-10.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-10.png 1014w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-10-300x170.png 300w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-10-768x436.png 768w\" sizes=\"auto, (max-width: 1014px) 100vw, 1014px\" \/><\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" width=\"1322\" height=\"110\" class=\"wp-image-784\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-11.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-11.png 1322w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-11-300x25.png 300w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-11-1024x85.png 1024w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-11-768x64.png 768w\" sizes=\"auto, (max-width: 1322px) 100vw, 1322px\" \/><\/strong><\/p>\n<p><strong><img loading=\"lazy\" decoding=\"async\" width=\"1289\" height=\"146\" class=\"wp-image-785\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-12.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-12.png 1289w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-12-300x34.png 300w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-12-1024x116.png 1024w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-12-768x87.png 768w\" sizes=\"auto, (max-width: 1289px) 100vw, 1289px\" \/><\/strong><\/p>\n<ul>\n<li><strong>Untuk buat Kategori, lakukan pivot, blok dan insert pivot<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"253\" height=\"308\" class=\"wp-image-786\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-13.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-13.png 253w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-13-246x300.png 246w\" sizes=\"auto, (max-width: 253px) 100vw, 253px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"330\" height=\"174\" class=\"wp-image-787\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-14.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-14.png 330w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-14-300x158.png 300w\" sizes=\"auto, (max-width: 330px) 100vw, 330px\" \/><\/p>\n<p>Masukkan di form U27, hasil<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"894\" height=\"361\" class=\"wp-image-789\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-16.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-16.png 894w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-16-300x121.png 300w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-16-768x310.png 768w\" sizes=\"auto, (max-width: 894px) 100vw, 894px\" \/><\/p>\n<p>Hasil download di U27<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"463\" height=\"315\" class=\"wp-image-790\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-17.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-17.png 463w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-17-300x204.png 300w\" sizes=\"auto, (max-width: 463px) 100vw, 463px\" \/><\/p>\n<ul>\n<li><strong>Untuk buat ProductLine, lakukan pivot, blok dan insert pivot<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"401\" height=\"247\" class=\"wp-image-791\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-18.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-18.png 401w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-18-300x185.png 300w\" sizes=\"auto, (max-width: 401px) 100vw, 401px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"549\" height=\"232\" class=\"wp-image-792\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-19.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-19.png 549w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-19-300x127.png 300w\" sizes=\"auto, (max-width: 549px) 100vw, 549px\" \/><\/p>\n<p>Masukkan di form excel U29 lalu download<br \/>\n<a href=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-20-e1651220433200.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-793 size-full\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-20-e1651220433200.png\" alt=\"\" width=\"429\" height=\"273\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-20-e1651220433200.png 429w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-20-e1651220433200-300x191.png 300w\" sizes=\"auto, (max-width: 429px) 100vw, 429px\" \/><\/a><\/p>\n<p>Lalu replace text file kata AULIA dengan 200, BEFREE dengan 201 dan seterusnya<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"614\" height=\"324\" class=\"wp-image-794\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-21.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-21.png 614w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-21-300x158.png 300w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/p>\n<p>Hasil<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"348\" height=\"337\" class=\"wp-image-795\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-22.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-22.png 348w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-22-300x291.png 300w\" sizes=\"auto, (max-width: 348px) 100vw, 348px\" \/><\/p>\n<p><strong>Cara CEPAT MEMASUKKAN DATA KE U6 \u2013 DOWNLOAD PRODUK FROM EXCEL<\/strong><\/p>\n<p>Buat satu produk di MST25<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"702\" height=\"376\" class=\"wp-image-796\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-23.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-23.png 702w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-23-300x161.png 300w\" sizes=\"auto, (max-width: 702px) 100vw, 702px\" \/><\/p>\n<p>Keluarkan excel di U6<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"430\" height=\"225\" class=\"wp-image-797\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-24.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-24.png 430w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-24-300x157.png 300w\" sizes=\"auto, (max-width: 430px) 100vw, 430px\" \/><\/p>\n<p>Copy satu baris, paste sebanyak jumlah barang yg mau dicopy<\/p>\n<p><a href=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-25-e1651220892659.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-798 size-full\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-25-e1651220892659.png\" alt=\"\" width=\"806\" height=\"177\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-25-e1651220892659.png 806w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-25-e1651220892659-300x66.png 300w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-25-e1651220892659-768x169.png 768w\" sizes=\"auto, (max-width: 806px) 100vw, 806px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-26-e1651220951649.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-799 size-full\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-26-e1651220951649.png\" alt=\"\" width=\"856\" height=\"284\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-26-e1651220951649.png 856w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-26-e1651220951649-300x100.png 300w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-26-e1651220951649-768x255.png 768w\" sizes=\"auto, (max-width: 856px) 100vw, 856px\" \/><\/a><\/p>\n<p>Lalucopy paste di kolom yg perlu di copy, yg tidak perlu tidak usah di copy paste.<\/p>\n<p>Cara melihat keterangan kolom itu apa sudah dijelaskan caranya di halaman pertama.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"448\" height=\"231\" class=\"wp-image-800\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-27.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-27.png 448w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-27-300x155.png 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"625\" height=\"446\" class=\"wp-image-801\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-28.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-28.png 625w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-28-300x214.png 300w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"762\" height=\"397\" class=\"wp-image-802\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-29.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-29.png 762w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-29-300x156.png 300w\" sizes=\"auto, (max-width: 762px) 100vw, 762px\" \/><\/p>\n<p>Insert -&gt; hanya kode yg belum saja yg dimasukkan<\/p>\n<p>Update -&gt; hanya kode yg sudah saja yg diupdate, jika ada barang baru tidak akan masuk<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"811\" height=\"355\" class=\"wp-image-803\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-30.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-30.png 811w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-30-300x131.png 300w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-30-768x336.png 768w\" sizes=\"auto, (max-width: 811px) 100vw, 811px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"546\" height=\"187\" class=\"wp-image-804\" src=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-31.png\" srcset=\"https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-31.png 546w, https:\/\/irwanto.net\/blog\/wp-content\/uploads\/2022\/04\/word-image-31-300x103.png 300w\" sizes=\"auto, (max-width: 546px) 100vw, 546px\" \/><\/p>\n<p>TOTAL INSERT =&gt; total yang dimasukkan<\/p>\n<p>TOTAL PASSED =&gt; total yg dilewati, jika pilihan Insert berarti ada 1 produk yg tidak dimasukkan karena sudah ada<\/p>\n<p>******************************** FINISH ******************************<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cara melihat keterangan kolom excel hasil dari export excel U6 Teknik Berlaku semua download excel untuk melihat keterangan Buat produk baru isi sembarang seperti ini : Lalu export ke excel dari U6 Maka hasilnya Dari sekian banyak kolom tidak semuanya dipakai dan diubah, cukup yang perlu aja, tapi wajib ada. TIDAK BOLEH MENAMBAH KOLOM, MERUBAH <span class=\"ellipsis\">&hellip;<\/span> <span class=\"more-link-wrap\"><a href=\"https:\/\/irwanto.net\/blog\/panduan-u6-download-produk-from-excel-776.html\" class=\"more-link\"><span>Read More &rarr;<\/span><\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24],"tags":[],"class_list":["post-776","post","type-post","status-publish","format-standard","hentry","category-software-distributor"],"_links":{"self":[{"href":"https:\/\/irwanto.net\/blog\/wp-json\/wp\/v2\/posts\/776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/irwanto.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/irwanto.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/irwanto.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/irwanto.net\/blog\/wp-json\/wp\/v2\/comments?post=776"}],"version-history":[{"count":4,"href":"https:\/\/irwanto.net\/blog\/wp-json\/wp\/v2\/posts\/776\/revisions"}],"predecessor-version":[{"id":807,"href":"https:\/\/irwanto.net\/blog\/wp-json\/wp\/v2\/posts\/776\/revisions\/807"}],"wp:attachment":[{"href":"https:\/\/irwanto.net\/blog\/wp-json\/wp\/v2\/media?parent=776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/irwanto.net\/blog\/wp-json\/wp\/v2\/categories?post=776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/irwanto.net\/blog\/wp-json\/wp\/v2\/tags?post=776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}