{"id":5321,"date":"2020-06-17T12:08:08","date_gmt":"2020-06-17T10:08:08","guid":{"rendered":"https:\/\/docs.reybex.com\/kb\/bestaende-aktualisieren-mit-excel\/"},"modified":"2022-03-08T15:07:37","modified_gmt":"2022-03-08T14:07:37","slug":"excel-ile-stok-guncelleme","status":"publish","type":"manual_kb","link":"https:\/\/docs.reybex.com\/tr\/kb\/excel-ile-stok-guncelleme\/","title":{"rendered":"Excel ile Stok G\u00fcncelleme"},"content":{"rendered":"\n<p>reybex&#8217;te csv dosyalar\u0131n\u0131z ile stok g\u00fcncellemesi [BAS13] ekran\u0131ndan olu\u015fturulan \u015fablon ile kolayca yapabilirsiniz. Ayr\u0131ca stok g\u00fcncellemesi alan \u00fcr\u00fcnler e\u011fer a\u00e7\u0131k pazaryeri var is eve [OMP01] i\u00e7ersinde \u2018\u00dcr\u00fcn verileri sadece oku\u2019 pasif ise a\u00e7\u0131k olan pazaryerlerine otomatik olarak stok g\u00fcncellemesi g\u00f6nderilir.<\/p>\n\n\n\n<p><strong>Varyants\u0131z \u00dcr\u00fcnde Stok G\u00fcncelleme<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"213\" height=\"174\" src=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/1-13.png\" alt=\"\" class=\"wp-image-10635\"\/><\/figure>\n\n\n\n<p>\u00d6rnek Csv dosyam\u0131zda iki s\u00fctun mevcuttur. matCode s\u00fctunu \u00dcr\u00fcn Kodunu, stockItem s\u00fctunu stok miktar\u0131n\u0131 i\u015faret eder. ( s\u00fctun ba\u015fl\u0131klar\u0131 iste\u011fe ba\u011fl\u0131 yaz\u0131labilir)<\/p>\n\n\n\n<p>[BAS13] Malzeme Import Wizzard ile olu\u015fturdu\u011fumuz csv\u2019ya g\u00f6re \u015fablon olu\u015fturulur. A\u015fa\u011f\u0131da ad\u0131mlar ekran g\u00f6r\u00fcnt\u00fcs\u00fc ile verilmi\u015ftir.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"360\" src=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/2-15.png\" alt=\"\" class=\"wp-image-10638\" srcset=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/2-15.png 640w, https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/2-15-300x169.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"360\" src=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/3-12.png\" alt=\"\" class=\"wp-image-10641\" srcset=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/3-12.png 640w, https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/3-12-300x169.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"522\" src=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/4-13-1024x522.png\" alt=\"\" class=\"wp-image-10644\" srcset=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/4-13-1024x522.png 1024w, https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/4-13-300x153.png 300w, https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/4-13-768x392.png 768w, https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/4-13.png 1377w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>E\u015fle\u015fen malzeme csv dosyam\u0131zda \u00dcr\u00fcn Kodu kulland\u0131\u011f\u0131m\u0131z i\u00e7in \u2018\u00dcr\u00fcn Kodu\u2019 olarak i\u015faretlenir ama ise\u011fe ba\u011fl\u0131 di\u011fer alanlar \u00fczerinden e\u015fle\u015ftirme yap\u0131labilir.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"360\" src=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/5-6.png\" alt=\"\" class=\"wp-image-10647\" srcset=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/5-6.png 640w, https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/5-6-300x169.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"360\" src=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/6-5.png\" alt=\"\" class=\"wp-image-10650\" srcset=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/6-5.png 640w, https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/6-5-300x169.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p>S\u00fctun ba\u015fl\u0131klar\u0131 yukar\u0131daki gibi e\u015fle\u015ftirilir ve \u2018Kaydet ve Import Et\u2019 butonuna t\u0131klanarak csv dosyan\u0131zla stok aktarma i\u015flemi ba\u015flam\u0131\u015f olunur.<\/p>\n\n\n\n<p><strong>Varyantl\u0131 \u00dcr\u00fcnlerde Stok G\u00fcncellemesi<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"279\" height=\"176\" src=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/7-3.png\" alt=\"\" class=\"wp-image-10653\"\/><\/figure>\n\n\n\n<p>\u00d6rnek Csv dosyam\u0131zda iki s\u00fctun mevcuttur. varyantSku s\u00fctunu Varyant SKU, stockItem s\u00fctunu stok miktar\u0131n\u0131 i\u015faret eder. ( s\u00fctun ba\u015fl\u0131klar\u0131 iste\u011fe ba\u011fl\u0131 yaz\u0131labilir)<\/p>\n\n\n\n<p>[BAS13] a\u015famalar\u0131 \u2018<em>Varyants\u0131z \u00dcr\u00fcnde Stok G\u00fcncelleme\u2019 <\/em>ile ayn\u0131d\u0131r. Sadece dikkat edilmesi gereken noktalar a\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fclerindedir.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"465\" src=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/8-2-1024x465.png\" alt=\"\" class=\"wp-image-10656\" srcset=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/8-2-1024x465.png 1024w, https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/8-2-300x136.png 300w, https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/8-2-768x349.png 768w, https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/8-2.png 1323w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>E\u015fle\u015fen Malzeme\u2019de SKU se\u00e7ilmelidir. ( \u0130ste\u011fe ba\u011fl\u0131 \u2018EAN\/GTIN\u2019 alan\u0131ndan da varyant\u2019\u0131n barkodu ile e\u015fle\u015ftirme yap\u0131labilir fakat \u00f6rnek dosyam\u0131z varyant sku \u00fczerinden oldu\u011fu i\u00e7in bu ad\u0131mda \u2018SKU\u2019 se\u00e7ilmi\u015ftir)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"511\" src=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/9-1-1024x511.png\" alt=\"\" class=\"wp-image-10659\" srcset=\"https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/9-1-1024x511.png 1024w, https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/9-1-300x150.png 300w, https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/9-1-768x384.png 768w, https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/9-1-1536x767.png 1536w, https:\/\/docs.reybex.com\/wp-content\/uploads\/2021\/05\/9-1.png 1910w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u2018Kaydet ve Import Et\u2019 demeden \u00f6nce varyant\u0131n sku e\u015fle\u015fece\u011fi hedef s\u00fctun \u2018Varyant: Varyant SKU\u2019 olarak se\u00e7ilmeli.<\/p>\n\n\n\n<p>Ayr\u0131ca yararl\u0131 linkler;<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-reybex-helpcenter wp-block-embed-reybex-helpcenter\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"WZSvUuilG3\"><a href=\"https:\/\/docs.reybex.com\/tr\/kb\/excel-dosyasini-csv-olarak-kaydetme\/\">Excel Dosyas\u0131n\u0131 CSV Olarak Kaydetme<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Excel Dosyas\u0131n\u0131 CSV Olarak Kaydetme&#8221; &#8212; reybex Helpcenter\" src=\"https:\/\/docs.reybex.com\/tr\/kb\/excel-dosyasini-csv-olarak-kaydetme\/embed\/#?secret=WZSvUuilG3\" data-secret=\"WZSvUuilG3\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-reybex-helpcenter wp-block-embed-reybex-helpcenter\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"7tgGjL3x49\"><a href=\"https:\/\/docs.reybex.com\/tr\/kb\/urun-import-varyantli-ve-varyantsiz-urun\/\">\u00dcr\u00fcn Import (Varyantl\u0131 ve Varyants\u0131z \u00dcr\u00fcn)<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8222;\u00dcr\u00fcn Import (Varyantl\u0131 ve Varyants\u0131z \u00dcr\u00fcn)&#8220; &#8212; reybex Helpcenter\" src=\"https:\/\/docs.reybex.com\/tr\/kb\/urun-import-varyantli-ve-varyantsiz-urun\/embed\/#?secret=7tgGjL3x49\" data-secret=\"7tgGjL3x49\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"author":19,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[550,603],"manual_kb_tag":[159],"_links":{"self":[{"href":"https:\/\/docs.reybex.com\/tr\/wp-json\/wp\/v2\/manual_kb\/5321"}],"collection":[{"href":"https:\/\/docs.reybex.com\/tr\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/docs.reybex.com\/tr\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/docs.reybex.com\/tr\/wp-json\/wp\/v2\/users\/19"}],"version-history":[{"count":3,"href":"https:\/\/docs.reybex.com\/tr\/wp-json\/wp\/v2\/manual_kb\/5321\/revisions"}],"predecessor-version":[{"id":10662,"href":"https:\/\/docs.reybex.com\/tr\/wp-json\/wp\/v2\/manual_kb\/5321\/revisions\/10662"}],"wp:attachment":[{"href":"https:\/\/docs.reybex.com\/tr\/wp-json\/wp\/v2\/media?parent=5321"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/docs.reybex.com\/tr\/wp-json\/wp\/v2\/manualknowledgebasecat?post=5321"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/docs.reybex.com\/tr\/wp-json\/wp\/v2\/manual_kb_tag?post=5321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}