{"id":9788,"date":"2023-05-26T18:13:22","date_gmt":"2023-05-26T12:43:22","guid":{"rendered":"https:\/\/support.unicommerce.com\/?post_type=ht_kb&p=9788"},"modified":"2023-05-26T18:13:22","modified_gmt":"2023-05-26T12:43:22","slug":"inventory-adjustment-batching-in-bulk-import","status":"publish","type":"ht_kb","link":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-in-bulk-import\/","title":{"rendered":"Inventory Adjustment Batching in Bulk: Import"},"content":{"rendered":"

Inventory Adjustment Batching in Bulk<\/strong><\/p>\n

Now a seller can easily adjust the inventory (Add, Remove, Replace, Transfer) for an existing batch or for a new batch in bulk through Import. In case of an inventory adjustment for a new batch, batch details should be provided.<\/p>\n

Applicability<\/strong><\/p>\n

\n
\n

Version<\/strong>: Enterprise
\nTraceability<\/strong>: This is applicable for SKU <\/strong>(batching enabled) traceability<\/p>\n<\/div>\n<\/div>\n

Procedure<\/h3>\n

Path:<\/strong>\u00a0Main Menu (Tools) > Import > Select import as\u00a0\u201cInventory adjustment Batching\u201d<\/strong><\/p>\n

1-<\/strong> To use, select Create New<\/strong>\u00a0from the Import Option.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

2-<\/strong>\u00a0Download the CSV format and fill in the details.<\/p>\n

\"\"<\/p>\n

 <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Field Name (M: Mandatory)<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n
Product Code (M)<\/strong><\/td>\nProduct Code (Uniware SKU)<\/td>\n<\/tr>\n
Quantity (M)<\/strong><\/td>\nDefined the Quantity of the Product which you want to adjust<\/td>\n<\/tr>\n
Shelf Code (M)<\/strong><\/td>\nShelf Code From Which Inventory To Be Added\/Removed\/Transferred<\/td>\n<\/tr>\n
Adjustment Type (M)<\/strong><\/td>\nInventory Adjustment Type<\/p>\n
    \n
  • GOOD_INVENTORY,<\/li>\n
  • BAD_INVENTORY,<\/li>\n
  • QC_REJECTED,<\/li>\n
  • VIRTUAL_INVENTORY<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n
Remarks (M)<\/strong><\/td>\nRemarks<\/td>\n<\/tr>\n
Transfer To Shelf Code<\/td>\nCode of the shelf on which you want to adjust the inventory<\/td>\n<\/tr>\n
SLA<\/td>\nSLA<\/td>\n<\/tr>\n
MRP<\/td>\nMRP of the Product<\/td>\n<\/tr>\n
Expiry Date<\/td>\nExpiry Date of the Product as Dd\/Mm\/Yyyy<\/strong><\/td>\n<\/tr>\n
Manufacturing Date<\/td>\nManufacturing Date of the Product as Dd\/Mm\/Yyyy<\/strong><\/td>\n<\/tr>\n
Vendor Code<\/td>\n(Unique) code of the Vendor.<\/td>\n<\/tr>\n
Vendor Batch Number<\/td>\nVendor Batch Number<\/td>\n<\/tr>\n
Country Of Origin<\/td>\nCountry Of Origin (Code).<\/p>\n
    \n
  • It describes the country(ies) where an article, brand, or design was manufactured, produced, designed, or branded.<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n
Bill Of Entry<\/td>\nBill of Entry (Number)
\nIt is a legal document that importers or customs agents file upon arrival of imported goods<\/td>\n<\/tr>\n
Source Batch Code<\/td>\nSource Batch Code<\/td>\n<\/tr>\n
Force Allocate<\/td>\nForce Allocate<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

3<\/strong>\u2013 Save the sheet in default\u00a0CSV format\u00a0<\/strong>then\u00a0Select the option \u201cChoose File<\/strong>\u201d and upload the sheet and press the\u00a0\u201cUpload File\u201d<\/strong>\u00a0button.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

4<\/strong>\u2013 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.
\nWhen uploading data fails, you can check it from View import and repeat the task.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

Note:-\u00a0<\/strong><\/p>\n

    \n
  • If the user tries to adjust an inventory for which Batch Group is not configured<\/strong>, throw an error.<\/li>\n
  • All the batch group parameters (Mfg date, Exp date, Cost, MRP, Vendor Batch No and Vendor) should be supported..<\/li>\n<\/ul>\n

     <\/p>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    Inventory Adjustment Batching in Bulk Now a seller can easily adjust the inventory (Add, Remove, Replace, Transfer) for an existing batch or for a new batch in bulk through Import. In case of an inventory adjustment for a new batch, batch details should be provided. Applicability Version: Enterprise Traceability: This…<\/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":"\nInventory Adjustment Batching 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\/inventory-adjustment-batching-in-bulk-import\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Inventory Adjustment Batching in Bulk: Import - Unicommerce Support Portal\" \/>\n<meta property=\"og:description\" content=\"Inventory Adjustment Batching in Bulk Now a seller can easily adjust the inventory (Add, Remove, Replace, Transfer) for an existing batch or for a new batch in bulk through Import. In case of an inventory adjustment for a new batch, batch details should be provided. Applicability Version: Enterprise Traceability: This...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-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\/inventoryadjustment_26052023_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\/inventory-adjustment-batching-in-bulk-import\/\",\"url\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-in-bulk-import\/\",\"name\":\"Inventory Adjustment Batching in Bulk: Import - Unicommerce Support Portal\",\"isPartOf\":{\"@id\":\"https:\/\/support.unicommerce.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-in-bulk-import\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-in-bulk-import\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/inventoryadjustment_26052023_01.png\",\"datePublished\":\"2023-05-26T12:43:22+00:00\",\"dateModified\":\"2023-05-26T12:43:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-in-bulk-import\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-in-bulk-import\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-in-bulk-import\/#primaryimage\",\"url\":\"https:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/inventoryadjustment_26052023_01.png\",\"contentUrl\":\"https:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/inventoryadjustment_26052023_01.png\",\"width\":964,\"height\":396},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-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\":\"Inventory Adjustment Batching 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":"Inventory Adjustment Batching 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\/inventory-adjustment-batching-in-bulk-import\/","og_locale":"en_US","og_type":"article","og_title":"Inventory Adjustment Batching in Bulk: Import - Unicommerce Support Portal","og_description":"Inventory Adjustment Batching in Bulk Now a seller can easily adjust the inventory (Add, Remove, Replace, Transfer) for an existing batch or for a new batch in bulk through Import. In case of an inventory adjustment for a new batch, batch details should be provided. Applicability Version: Enterprise Traceability: This...","og_url":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-in-bulk-import\/","og_site_name":"Unicommerce Support Portal","og_image":[{"url":"http:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/inventoryadjustment_26052023_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\/inventory-adjustment-batching-in-bulk-import\/","url":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-in-bulk-import\/","name":"Inventory Adjustment Batching in Bulk: Import - Unicommerce Support Portal","isPartOf":{"@id":"https:\/\/support.unicommerce.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-in-bulk-import\/#primaryimage"},"image":{"@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-in-bulk-import\/#primaryimage"},"thumbnailUrl":"http:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/inventoryadjustment_26052023_01.png","datePublished":"2023-05-26T12:43:22+00:00","dateModified":"2023-05-26T12:43:22+00:00","breadcrumb":{"@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-in-bulk-import\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-in-bulk-import\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-in-bulk-import\/#primaryimage","url":"https:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/inventoryadjustment_26052023_01.png","contentUrl":"https:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/05\/inventoryadjustment_26052023_01.png","width":964,"height":396},{"@type":"BreadcrumbList","@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/inventory-adjustment-batching-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":"Inventory Adjustment Batching 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\/9788"}],"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=9788"}],"version-history":[{"count":2,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/9788\/revisions"}],"predecessor-version":[{"id":9796,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/9788\/revisions\/9796"}],"wp:attachment":[{"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/media?parent=9788"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb-category?post=9788"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb-tag?post=9788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}