{"id":4659,"date":"2020-07-08T22:55:30","date_gmt":"2020-07-08T20:55:30","guid":{"rendered":"https:\/\/docs.reybex.com\/?post_type=manual_kb&#038;p=4659"},"modified":"2020-07-08T22:55:31","modified_gmt":"2020-07-08T20:55:31","slug":"article-import-via-excel","status":"publish","type":"manual_kb","link":"https:\/\/docs.reybex.com\/en\/kb\/article-import-via-excel\/","title":{"rendered":"Article import via Excel"},"content":{"rendered":"\n<p>Import &amp; manage CSV files<\/p>\n\n\n\n<p>If you want to import article data via .csv file, you first create an import template. This allows the article attributes\/columns to be assigned correctly. To be able to use the same template over and over again, you must not change the column headers, add new columns, or remove existing ones. Why? Otherwise the assignment between Excel and reybex cannot take place.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"this-is-how-you-create-a-template\">This is how you create a template:<\/h2>\n\n\n\n<ol><li>Open the transaction <strong>Article Import [BAS13]<\/strong> &gt; click on <strong>material.import.from.CSV <\/strong>&gt; click on the <strong>plus button.<\/strong><\/li><li>You can find a little help in the transaction.&nbsp;<\/li><li>Fill in the form and click <strong>next <\/strong>(Weiter).<\/li><li>Assign the columns and click <strong>Finish.<\/strong><\/li><li>An overview of the import process appears (progress, successfully imported articles)<\/li><\/ol>\n\n\n\n<p><strong>Tip:<\/strong> For your Excel tables, use the column headings of the input mask in the transaction <strong>New Article [BAS03]<\/strong>. Note that you do not use thousands separators in the Excel file, otherwise errors will occur. The Excel table must be saved in.csv format.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"you-want-to-import-articles-and-have-already-created-a-template\">You want to import articles and have already created a template?<\/h2>\n\n\n\n<ol><li>Open the transaction <strong>Article Import [BAS13] <\/strong>&gt; select the template &gt; select the desired CSV file &gt; click Next.<\/li><li>When all columns are correct, click <strong>Finish.<\/strong><\/li><li>An overview of the import process appears (progress, successfully imported articles).<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"you-want-to-import-article-data-directly-from-your-marketplacesshops-to-reybex-\">You want to import article data directly from your marketplaces\/shops to reybex?&nbsp;<\/h2>\n\n\n\n<p>You can find instructions in the article <strong>Article-Import from marketplaces \/ online shops<\/strong><\/p>\n\n\n\n<p><strong>Tip: <\/strong>In the <strong>Inventory List [INV03] <\/strong>transaction you can see the imported items and stocks for you to check.<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[510,549,555],"manual_kb_tag":[],"_links":{"self":[{"href":"https:\/\/docs.reybex.com\/en\/wp-json\/wp\/v2\/manual_kb\/4659"}],"collection":[{"href":"https:\/\/docs.reybex.com\/en\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/docs.reybex.com\/en\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/docs.reybex.com\/en\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":1,"href":"https:\/\/docs.reybex.com\/en\/wp-json\/wp\/v2\/manual_kb\/4659\/revisions"}],"predecessor-version":[{"id":4660,"href":"https:\/\/docs.reybex.com\/en\/wp-json\/wp\/v2\/manual_kb\/4659\/revisions\/4660"}],"wp:attachment":[{"href":"https:\/\/docs.reybex.com\/en\/wp-json\/wp\/v2\/media?parent=4659"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/docs.reybex.com\/en\/wp-json\/wp\/v2\/manualknowledgebasecat?post=4659"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/docs.reybex.com\/en\/wp-json\/wp\/v2\/manual_kb_tag?post=4659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}