{"id":1956,"date":"2021-09-08T14:31:51","date_gmt":"2021-09-08T07:31:51","guid":{"rendered":"https:\/\/qlobot.com\/help\/?post_type=kb&#038;p=1956"},"modified":"2021-10-13T23:46:43","modified_gmt":"2021-10-13T16:46:43","slug":"cara-edit-collection-melalui-excel","status":"publish","type":"kb","link":"https:\/\/qlobot.com\/help\/article\/cara-edit-collection-melalui-excel\/","title":{"rendered":"Cara Edit Collection Melalui Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_72 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\"><p class=\"ez-toc-title\" style=\"cursor:inherit\">Contents<\/p>\n<\/div><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/qlobot.com\/help\/article\/cara-edit-collection-melalui-excel\/#Edit_Data_Produk_di_Collection\" title=\"Edit Data Produk di Collection\">Edit Data Produk di Collection<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/qlobot.com\/help\/article\/cara-edit-collection-melalui-excel\/#Edit_Data_Varian\" title=\"Edit Data Varian\">Edit Data Varian<\/a><\/li><\/ul><\/nav><\/div>\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Edit_Data_Produk_di_Collection\"><\/span>Edit Data Produk di Collection<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>Masuk ke menu <strong>Collection<\/strong> dan buka salah satu collection.<\/li><li>Pada toolbar kanan atas klik tombol <strong>Collection Setting<\/strong> <img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"31\" class=\"wp-image-2072\" style=\"width: 32px;\" src=\"https:\/\/qlobot.com\/help\/wp-content\/uploads\/2021\/10\/image-15.png\" alt=\"Icon Settings\">. <\/li><li>Pada popup Collection Setting klik <strong>Storage File<\/strong><\/li><li>Edit data collection sesuai yang dibutuhkan. Setelah selesai Save (Tekan Ctrl+S)<\/li><li>Kembali ke halaman detail Collection &amp; klik tombol<img loading=\"lazy\" decoding=\"async\" width=\"24\" height=\"24\" class=\"wp-image-1957\" style=\"width: 24px;\" src=\"https:\/\/qlobot.com\/help\/wp-content\/uploads\/2021\/09\/image-3.png\" alt=\"Reload Button\">untuk melihat perubahan yang sudah kamu lakukan melalui Excel<\/li><\/ol>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Edit_Data_Varian\"><\/span>Edit Data Varian<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>Masuk ke menu <strong>Collection<\/strong> dan buka salah satu collection.<\/li><li>Pada toolbar kanan atas klik tombol <strong>Collection Setting<\/strong> <img decoding=\"async\" src=\"https:\/\/qlobot.com\/help\/wp-content\/uploads\/2021\/10\/image-15.png\" alt=\"Icon Settings\">.<\/li><li>Pada popup Collection Setting perhatikan <strong>Nama File<\/strong> pada <strong>Storage File<\/strong>.<\/li><li>Buka Explorer &amp; Buka folder tempat penyimpanan collection dengan cara tekan <code>Windows+R<\/code> masukkan &#8220;<code>%appdata%\\Qlobot\\Launcher\\collections\\<\/code>&#8221; lalu Enter<\/li><li>Cari file <code>[nama storage file]-variants.csv<\/code> dan buka dengan Excel<\/li><li>Edit sesuai dengan kebutuhan, misal seperti update harga<\/li><li>Save perubahan pada Excel<\/li><li>Klik tombol <img loading=\"lazy\" decoding=\"async\" width=\"24\" height=\"24\" class=\"wp-image-1957\" style=\"width: 24px;\" src=\"https:\/\/qlobot.com\/help\/wp-content\/uploads\/2021\/09\/image-3.png\" alt=\"Reload Button\"> untuk melihat perubahan yang sudah kamu lakukan melalui Excel<\/li><\/ol>\n\n\n<div class=\"mkb-shortcode-container\">        <div class=\"mkb-tip\">\n            <div class=\"mkb-tip__icon\">\n                <i class=\"fa fa-lg fa-magic\"><\/i>\n            <\/div>\n            <div class=\"mkb-tip__content\">\n                <strong>TIPS<\/strong>: Untuk mencari varian dari Produk tertentu, perhatikan kolom <strong>url<\/strong> (pada data produk) dan cari persamaan dengan kolom <strong>url<\/strong> yang ada pada file varian.            <\/div>\n        <\/div>\n        <\/div>","protected":false},"excerpt":{"rendered":"<p>Edit Data Produk di Collection Masuk ke menu Collection dan buka salah satu collection. Pada toolbar kanan atas klik tombol Collection Setting . Pada popup Collection Setting klik Storage File Edit data collection sesuai yang dibutuhkan. Setelah selesai Save (Tekan Ctrl+S) Kembali ke halaman detail Collection &amp; klik tomboluntuk melihat perubahan yang sudah kamu lakukan [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[72],"kbtag":[],"class_list":["post-1956","kb","type-kb","status-publish","hentry","kbtopic-tutorial"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/qlobot.com\/help\/wp-json\/wp\/v2\/kb\/1956","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/qlobot.com\/help\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/qlobot.com\/help\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/qlobot.com\/help\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/qlobot.com\/help\/wp-json\/wp\/v2\/comments?post=1956"}],"version-history":[{"count":0,"href":"https:\/\/qlobot.com\/help\/wp-json\/wp\/v2\/kb\/1956\/revisions"}],"wp:attachment":[{"href":"https:\/\/qlobot.com\/help\/wp-json\/wp\/v2\/media?parent=1956"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/qlobot.com\/help\/wp-json\/wp\/v2\/kbtopic?post=1956"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/qlobot.com\/help\/wp-json\/wp\/v2\/kbtag?post=1956"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}