{"id":1425,"date":"2020-11-25T16:49:34","date_gmt":"2020-11-25T16:49:34","guid":{"rendered":"https:\/\/meetanshi.com\/blog\/import-and-export-inventory-in-magento-2\/"},"modified":"2025-05-22T11:30:47","modified_gmt":"2025-05-22T06:00:47","slug":"import-and-export-inventory-in-magento-2","status":"publish","type":"post","link":"https:\/\/meetanshi.com\/blog\/import-and-export-inventory-in-magento-2\/","title":{"rendered":"How to Import and Export Inventory in Magento 2"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Medium to large-sized Magento 2 stores have hundreds and thousands of products. It becomes an extremely time-consuming process if the admin starts adding products one-by-one.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Moreover, in the case of multi-source inventory, updating quantity for each source cannot be done using the mass action.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Updating only the quantity of products in Magento 2 can be done easily using the method to import and export inventory in Magento 2 as shown below.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For instance, if your store operates in major European countries like France, Germany, and Italy. Assuming that you just need to make changes in product inventory for France. You can do it by importing a source-based CSV file without affecting the product inventory of Germany and Italy.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Steps to Import and Export Inventory in Magento 2<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The CSV file that we use for importing and exporting inventory will have four information about the product.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2020\/11\/Screenshot-at-November-11th-2020-11.30.13-am.png\" alt=\"Steps to Import and Export Inventory in Magento 2\" class=\"wp-image-11680\"\/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>source_code<\/strong>&nbsp;\u2013 It is the code for sources.<\/li>\n\n\n\n<li><strong>SKU \u2013&nbsp;<\/strong>It is a Stock Keeping Unique. Every product has a different SKU.<\/li>\n\n\n\n<li><strong>Status \u2013&nbsp;<\/strong>Status 0 indicates the product is out of stock and 1 indicates the product is available for purchase.<\/li>\n\n\n\n<li><strong>Quantity<\/strong>&nbsp;\u2013 Total number of quantity available for particular SKU and source.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Follow the below steps to export inventory in Magento 2.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Steps to Export Inventory for All Sources in Magento 2<\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2020\/11\/Annotation-on-2020-11-11-at-11-32-58.png\" alt=\"Import and Export Inventory in Magento 2\" class=\"wp-image-11681\"\/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Login<\/strong>&nbsp;to Magento 2 admin panel<\/li>\n\n\n\n<li>Navigate to&nbsp;<strong>System &gt; Data Transfer &gt; Export<\/strong><\/li>\n\n\n\n<li>In&nbsp;<strong>Entity Type<\/strong>, select&nbsp;<strong>Stock Sources<\/strong><\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2020\/11\/Screenshot-at-November-11th-2020-11.37.11-am.png\" alt=\"Export Inventory for All Sources in Magento 2\" class=\"wp-image-11682\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">All the products having SKUs will be added to the CSV file.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Export File Format<\/strong>&nbsp;will remain CSV<\/li>\n\n\n\n<li>Click&nbsp;<strong>Continue&nbsp;<\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Steps to Export Inventory for a Specific Source in Magento 2<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Follow the below steps to export inventory for a specific source in Magento 2.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Navigate to&nbsp;<strong>System &gt; Data Transfer &gt; Export<\/strong><\/li>\n\n\n\n<li>In&nbsp;<strong>Entity Type<\/strong>, select&nbsp;<strong>Stock Sources<\/strong><br>All the products having SKUs will be added to the CSV file.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2020\/11\/Annotation-on-2020-11-11-at-11-41-31-1024x399.png\" alt=\"Export Inventory for a Specific Source in Magento 2\" class=\"wp-image-11683\"\/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Export File Format<\/strong>&nbsp;will remain CSV<\/li>\n\n\n\n<li>Leverage&nbsp;<strong>Entity Attribute,&nbsp;<\/strong>to filter the exported products for a specific source.<br>Enter the&nbsp;<strong>source_code<\/strong>&nbsp;for exporting CSV file for a specific source.<\/li>\n\n\n\n<li>Click&nbsp;<strong>Continue<\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Steps to Import Inventory in Magento 2<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Follow the below steps to import inventory in Magento 2.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Login<\/strong>&nbsp;to Magento 2 admin panel.<\/li>\n\n\n\n<li>Navigate to&nbsp;<strong>Stores &gt; Data Transfer &gt; Import&nbsp;<\/strong><\/li>\n\n\n\n<li>In&nbsp;<strong>Entity Type<\/strong>, select&nbsp;<strong>Stock Sources<\/strong><\/li>\n\n\n\n<li>Select&nbsp;<strong>Import Behaviour<\/strong>&nbsp;based on your business requirement<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2020\/11\/Screenshot-at-November-11th-2020-11.16.45-am-1024x462.png\" alt=\"How to Import Inventory in Magento 2\" class=\"wp-image-11678\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Upload CSV file in&nbsp;<strong>Select File to Import<\/strong>&nbsp;option<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2020\/11\/Screenshot-at-November-11th-2020-11.19.16-am.png\" alt=\"Screenshot-at-November-11th-2020-11.19.16-am\" class=\"wp-image-11679\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click&nbsp;<strong>Check Data<\/strong><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><div class=\"meetanshi-cta\">\r\n<div class=\"cta-content-wrapper\">\r\n<span> Integrate Zoho Inventory Today!<\/span>\r\n<p>An easy way to sync products with Zoho Inventory without coding.<\/p>\r\n<a href=\"https:\/\/meetanshi.com\/magento-2-zoho-inventory-integration.html\" target=\"_blank\" class=\"btn-primary\">Get Extension<\/a>\r\n<\/div>\r\n<div class=\"cta-image-new\">\r\n<img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2025\/11\/magento-2-zoho-inventory-integration.png\" alt=\"Magento 2 Zoho Inventory Integration\">\r\n<\/div>\r\n<\/div><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">That\u2019s it. To complement managing your inventory, Magento 2 offers robust functionalities to efficiently&nbsp;<a href=\"https:\/\/meetanshi.com\/blog\/how-to-import-and-export-orders-in-magento-2\/\">import and export orders<\/a>. This ensures seamless order processing and fulfillment, enhancing overall operational efficiency for your e-commerce store.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Do consider sharing this post with Magento Community via social media.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thank you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Medium to large-sized Magento 2 stores have hundreds and thousands of products. It becomes an extremely time-consuming process if the admin starts adding products one-by-one&#8230;.<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-1425","post","type-post","status-publish","format-standard","hentry","category-magento"],"acf":[],"_links":{"self":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/comments?post=1425"}],"version-history":[{"count":2,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1425\/revisions"}],"predecessor-version":[{"id":14610,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1425\/revisions\/14610"}],"wp:attachment":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/media?parent=1425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/categories?post=1425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/tags?post=1425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}