{"id":9499,"date":"2023-05-10T15:36:32","date_gmt":"2023-05-10T10:06:32","guid":{"rendered":"https:\/\/support.unicommerce.com\/?post_type=ht_kb&#038;p=9499"},"modified":"2023-05-10T15:36:32","modified_gmt":"2023-05-10T10:06:32","slug":"grn-items-in-bulk-import","status":"publish","type":"ht_kb","link":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/","title":{"rendered":"GRN Items in Bulk : Import"},"content":{"rendered":"<p data-pm-slice=\"1 1 [&quot;orderedList&quot;,null,&quot;listItem&quot;,null]\"><strong>Auto GRN Items in Bulk<\/strong><\/p>\n<p data-pm-slice=\"1 1 []\">The Auto GRN Items import was initially built to help sellers migrate their existing inventory to the Uniware system from their previous WMS or other systems.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<div class=\"ez-toc-title\" style=\"cursor:inherit\">Contents<\/div>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<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:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/#Applicability\" >Applicability<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/#Procedure\" >Procedure<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Applicability\"><\/span><strong>Applicability<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p data-renderer-start-pos=\"909\"><strong data-renderer-mark=\"true\">Version<\/strong>: Professional and Enterprise<br \/>\n<strong data-renderer-mark=\"true\">Traceability<\/strong>: None, SKU, ITEM<\/p>\n<h3 id=\"procedure\"><span class=\"ez-toc-section\" id=\"Procedure\"><\/span>Procedure<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>Path:<\/strong> Main Menu (Tools) &gt; Import &gt; Select import as \u201c<strong>Auto GRN Items<\/strong><strong>\u201d<\/strong><\/p>\n<p><strong>1-<\/strong> To use, select <strong>CREATE NEW<\/strong> from the Import Option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-9432\" src=\"http:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/autogrn_02052023_01.png\" alt=\"\" width=\"1289\" height=\"570\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>2-<\/strong> Download the CSV format and fill in the details.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-9433\" src=\"http:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/autogrn_02052023_02.png\" alt=\"\" width=\"736\" height=\"116\" \/><\/p>\n<table style=\"border-collapse: collapse; width: 93.9622%; height: 556px;\">\n<tbody>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\"><strong>Field (M: Mandatory)<\/strong><\/td>\n<td style=\"width: 60.3715%; height: 23px;\"><strong>Description\u00a0<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\">Vendor Code <strong>(M)<\/strong><\/td>\n<td style=\"width: 60.3715%; height: 23px;\">The unique code of the vendor (mentioned in Uniware) from whom the SKUs are received.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\">Vendor Invoice Number <strong>(M)<\/strong><\/td>\n<td style=\"width: 60.3715%; height: 23px;\">The invoice number for the received SKUs.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\">Purchase Order Code <strong>(M)<\/strong><\/td>\n<td style=\"width: 60.3715%; height: 23px;\">The applicable purchase order code of respactive PO.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\">Vendor Invoice Date <strong>(M)<\/strong><\/td>\n<td style=\"width: 60.3715%; height: 23px;\">The invoice date in <strong data-renderer-mark=\"true\">DD\/MM\/YYYY<\/strong> format.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\">Sku Code <strong>(M)<\/strong><\/td>\n<td style=\"width: 60.3715%; height: 23px;\">Sku code of Uniware.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\">Qty <strong>(M)<\/strong><\/td>\n<td style=\"width: 60.3715%; height: 23px;\">Quantity of SKU.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\">Discount (%)<\/td>\n<td style=\"width: 60.3715%; height: 23px;\">If You Want To Apply Any Discount (In Percentage) On The Unit Price, Use This Column. To Apply A Discount Of 10%, Use 10.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\">Discount (Amount Value)<\/td>\n<td style=\"width: 60.3715%; height: 23px;\">If You Want To Apply Any Discount (In Absolute Value) On The Unit Price, Use This Column. Use Either Discount Percentage Or Discount Amount.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\">Tax Type Code<\/td>\n<td style=\"width: 60.3715%; height: 23px;\">Use This To Override The Default Tax Class For This SKU.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\">Item Code<\/td>\n<td style=\"width: 60.3715%; height: 23px;\">Item Barcodes Of GRN Items. <strong>This Field Is Mandatory For ITEM Traceability.<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\">Item Details<\/td>\n<td style=\"width: 60.3715%; height: 23px;\">Item Details of SKU.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\">GRN State<\/td>\n<td style=\"width: 60.3715%; height: 23px;\">Allowed Values &#8211; CREATED, QC_PENDING, QC_COMPLETE, COMPLETE. Use COMPLETE If You Want To Create Putaway. Default Value: CREATED.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\">Shelf Code<\/td>\n<td style=\"width: 60.3715%; height: 23px;\">\n<ul>\n<li>In case of In Non-Batching Traceability, Shelf Code Required If You Want To Create Putaway.<\/li>\n<li>GRN State = COMPLETE Required If You Add Shelf Code.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\" data-th=\"Column Name\">MRP<\/td>\n<td style=\"width: 60.3715%; height: 23px;\">MRP of SKU.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\" data-th=\"Column Name\">Unit Price<\/td>\n<td style=\"width: 60.3715%; height: 23px;\">Unit Price of SKU.<\/td>\n<\/tr>\n<tr style=\"height: 23px;\">\n<td style=\"width: 33.5913%; height: 23px;\" data-th=\"Column Name\">Additional Cost<\/td>\n<td style=\"width: 60.3715%; height: 23px;\">Additional Cost.<\/td>\n<\/tr>\n<tr style=\"height: 71px;\">\n<td style=\"width: 33.5913%; height: 71px;\" data-th=\"Column Name\">Manufacturing Date<\/td>\n<td style=\"width: 60.3715%; height: 71px;\">Manufacturing Date As <strong>DD\/MM\/YYYY<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 47px;\">\n<td style=\"width: 33.5913%; height: 47px;\" data-th=\"Column Name\">Expiry Date As Dd\/MM\/Yyyy<\/td>\n<td style=\"width: 60.3715%; height: 47px;\">Expiry Date As <strong data-renderer-mark=\"true\">DD\/MM\/YYYY<\/strong><\/td>\n<\/tr>\n<tr style=\"height: 47px;\">\n<td style=\"width: 33.5913%; height: 47px;\" data-th=\"Column Name\">Vendor Batch Number<\/td>\n<td style=\"width: 60.3715%; height: 47px;\">Vendor Batch Number<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>3<\/strong>&#8211; Save the sheet in default <strong>CSV format\u00a0<\/strong>then\u00a0Select the option \u201c<strong>Choose File<\/strong>\u201d and upload the sheet and press the <strong>\u201cUpload File\u201d<\/strong>\u00a0button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-9434\" src=\"http:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/autogrn_02052023_03.png\" alt=\"\" width=\"1901\" height=\"415\" \/><\/p>\n<p><strong>4<\/strong>&#8211; Once the upload has been successful, you can review the uploaded sheet. Right at the top of the screen is the import section where the user can see the success message.<br \/>\nWhen uploading data fails, you can check it from View import and repeat the task.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-9435\" src=\"http:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/autogrn_02052023_04.png\" alt=\"\" width=\"1110\" height=\"135\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Auto GRN Items in Bulk The Auto GRN Items import was initially built to help sellers migrate their existing inventory to the Uniware system from their previous WMS or other systems. Applicability Version: Professional and Enterprise Traceability: None, SKU, ITEM Procedure Path: Main Menu (Tools) &gt; Import &gt; Select import&#8230;<\/p>\n","protected":false},"author":5,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_eb_attr":""},"ht-kb-category":[17],"ht-kb-tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>GRN Items in Bulk : Import - Unicommerce Support Portal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GRN Items in Bulk : Import - Unicommerce Support Portal\" \/>\n<meta property=\"og:description\" content=\"Auto GRN Items in Bulk The Auto GRN Items import was initially built to help sellers migrate their existing inventory to the Uniware system from their previous WMS or other systems. Applicability Version: Professional and Enterprise Traceability: None, SKU, ITEM Procedure Path: Main Menu (Tools) &gt; Import &gt; Select import...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/\" \/>\n<meta property=\"og:site_name\" content=\"Unicommerce Support Portal\" \/>\n<meta property=\"og:image\" content=\"http:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/autogrn_02052023_01.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/\",\"url\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/\",\"name\":\"GRN Items in Bulk : Import - Unicommerce Support Portal\",\"isPartOf\":{\"@id\":\"https:\/\/support.unicommerce.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/autogrn_02052023_01.png\",\"datePublished\":\"2023-05-10T10:06:32+00:00\",\"dateModified\":\"2023-05-10T10:06:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/#primaryimage\",\"url\":\"https:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/autogrn_02052023_01.png\",\"contentUrl\":\"https:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/autogrn_02052023_01.png\",\"width\":1289,\"height\":570},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/support.unicommerce.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"GRN Items in Bulk : Import\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/support.unicommerce.com\/#website\",\"url\":\"https:\/\/support.unicommerce.com\/\",\"name\":\"Unicommerce Support Portal\",\"description\":\"Know more about Uniware\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/support.unicommerce.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"GRN Items in Bulk : Import - Unicommerce Support Portal","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/","og_locale":"en_US","og_type":"article","og_title":"GRN Items in Bulk : Import - Unicommerce Support Portal","og_description":"Auto GRN Items in Bulk The Auto GRN Items import was initially built to help sellers migrate their existing inventory to the Uniware system from their previous WMS or other systems. Applicability Version: Professional and Enterprise Traceability: None, SKU, ITEM Procedure Path: Main Menu (Tools) &gt; Import &gt; Select import...","og_url":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/","og_site_name":"Unicommerce Support Portal","og_image":[{"url":"http:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/autogrn_02052023_01.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/","url":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/","name":"GRN Items in Bulk : Import - Unicommerce Support Portal","isPartOf":{"@id":"https:\/\/support.unicommerce.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/#primaryimage"},"image":{"@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/#primaryimage"},"thumbnailUrl":"http:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/autogrn_02052023_01.png","datePublished":"2023-05-10T10:06:32+00:00","dateModified":"2023-05-10T10:06:32+00:00","breadcrumb":{"@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/#primaryimage","url":"https:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/autogrn_02052023_01.png","contentUrl":"https:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/autogrn_02052023_01.png","width":1289,"height":570},{"@type":"BreadcrumbList","@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/grn-items-in-bulk-import\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.unicommerce.com\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/"},{"@type":"ListItem","position":3,"name":"GRN Items in Bulk : Import"}]},{"@type":"WebSite","@id":"https:\/\/support.unicommerce.com\/#website","url":"https:\/\/support.unicommerce.com\/","name":"Unicommerce Support Portal","description":"Know more about Uniware","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/support.unicommerce.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/9499"}],"collection":[{"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/comments?post=9499"}],"version-history":[{"count":1,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/9499\/revisions"}],"predecessor-version":[{"id":9500,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/9499\/revisions\/9500"}],"wp:attachment":[{"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/media?parent=9499"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb-category?post=9499"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb-tag?post=9499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}