{"id":5094,"date":"2018-09-03T17:07:50","date_gmt":"2018-09-03T11:07:50","guid":{"rendered":"https:\/\/www.ecomclips.com\/?p=5094"},"modified":"2026-01-31T07:43:03","modified_gmt":"2026-01-31T07:43:03","slug":"update-sellercloud-inventory","status":"publish","type":"post","link":"https:\/\/ecomclips.com\/blog\/update-sellercloud-inventory\/","title":{"rendered":"How To Update SellerCloud Inventory Through Excel CSV File For Bulk"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Today I\u2019m going to show you how to update <a href=\"https:\/\/help.sellercloud.com\/omnichannel-ecommerce-category\/search-and-view-inventory\/\">SellerCloud<\/a> inventory using your excel csv file. Trust me, by reading this tutorial a non-technical person will be able to do the task. So, read through the end and learn the simplest way to update SellerCloud inventory.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>First, we have to know, What is SellerCloud?\u201d<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SellerCloud is one of the most popular multichannel inventory management systems in the world. It offers to manage inventory and warehouse management. It also manages to publish listing to marketplaces, order processing, and shipping as well as accounting integration, the software does all the work needed. In addition, its one-system solution facilitates complex e-commerce functions, empowering business to have a better view and control over their online sales.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are 2 ways to update the inventory for the items:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1) Manually<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2) By using Feed ( Through a CSV file )<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now I am showing how to update inventory through excel CSV file.<br>Do you want to know why?<br>well, it is the most effective, easiest and the fastest way to update <a href=\"https:\/\/help.sellercloud.com\/omnichannel-ecommerce-category\/import-products\/\">SellerCloud<\/a> inventory.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now, follow this step by step procedure:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Update sellercloud inventory using csv files<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Step 1: Go to the Seller Cloud Dashboard &gt; Inventory &gt; Warehouse Inventory Import<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/6EOVtS8raP2Z1m-De0GLGjfXEqwxWW6zWMFPz1ZqjBDIeNcvLJ9WCfA9WKd974FS4AhA-PKaYoJzpOiP4SOdizn9r1zZxilTCeTeRfq8HowvNp5ThHfSLpF80Fosdo8bwDZ5kse80r9mk_unjKdXiEc\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Step 2: Now you have to create an inventory feed that you want to import. For that, at first download the feed template. Select the template from the&nbsp; Select Action drop-down menu. Download the last template.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Select Action &gt; Download Template (all products no Shadows\/Dependant Kits)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Then click Go for the download template.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/C2jHiIA71vFtotMxKHEMvq8JsA4ZA3YO5PS-d1y3_CeXJlLs5xVQLrhAmvWqLKlEjTEQB9Qa_fotC1UUtYbjVDd7P9-kepjYhBLU1rVXZorzLYhPglLHs-NPL4Wra0fyvekb5HMo-diRFY6eG5ZtX0o\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Step 3:&nbsp; After downloading the template you have seen there are five columns Your product id, Warehouse, Physical Inventory Quantity, and Location Notes. Then filter column B, Delete every row that is not \u201cDefault Warehouse\u201d. Do a VLOOKUP against your warehouse UPC column using the Location Note column on the Seller Cloud template (our location notes are actually our UPC\u2019s). After completing the VLOOKUP process you will get your products current inventory. Input those inventory data in the Physical Inventory Qty column on your template.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/s7P5mUvOAVIVINt5DRtM-HHnU4kfmMI04D8SGHUdNIFcJ8Hwj0-tXWBCXXJfOUzLHn_F3HIZ3ma3Sv-AC2wt5gGdVXhv0ESTZBpw0qjQFOVwtlPOvLJDFclZpp0ELTJN0pB4bMO70zErkkl-HMCdQLY\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Step 4: For the import, template go to the seller cloud dashboard &gt; Inventory &gt; Warehouse Inventory Import. Then select your template that you want to import. File type to be excel and update type to be partial. Finally, click on Import Inventory Button for update inventory.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Seller Cloud Dashboard &gt; Inventory &gt; Warehouse Inventory Import<br>Later,<br>Select File &gt; Select the template<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">File Type &gt; Excel<br>Update Type &gt; Partial<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/_dZ525WTA_iXcRfntC1P2oK6-2D_sHwJO2HcvzTS1xKXANRVQvK1Cdc_D6yugSCJTvkX2N4IShjPZX6_QVstn4gxuvntWNAAL8ZXkVDGXyfy2Xmx25ao2AE0mQSa_8ZuCmIKyledDVSTwfZoJwLLPBQ\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">So, We have successfully completed updated inventory or quantity on <a href=\"https:\/\/help.sellercloud.com\/omnichannel-ecommerce-category\/about-sellercloud-help\/\">SellerCloud<\/a> through feed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today I\u2019m going to show you how to update SellerCloud inventory using your excel csv file. Trust me, by reading this tutorial a non-technical person will be able to do the task. So, read through the end and learn the simplest way to update SellerCloud inventory. First, we have to know, What is SellerCloud?\u201d SellerCloud &#8230; <a title=\"How To Update SellerCloud Inventory Through Excel CSV File For Bulk\" class=\"read-more\" href=\"https:\/\/ecomclips.com\/blog\/update-sellercloud-inventory\/\" aria-label=\"Read more about How To Update SellerCloud Inventory Through Excel CSV File For Bulk\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":13792,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[267],"tags":[264,265,266,268],"class_list":["post-5094","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sellercloud","tag-import-inventory-file-in-sellercloud","tag-inventory-change-in-excel-on-seller-cloud","tag-quantity-update-in-feed-file","tag-stock"],"_links":{"self":[{"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/posts\/5094","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/comments?post=5094"}],"version-history":[{"count":3,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/posts\/5094\/revisions"}],"predecessor-version":[{"id":23165,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/posts\/5094\/revisions\/23165"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/media\/13792"}],"wp:attachment":[{"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/media?parent=5094"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/categories?post=5094"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ecomclips.com\/blog\/wp-json\/wp\/v2\/tags?post=5094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}