Knowledgebase: Extensions' Manuals
Is there any instructions to follow to import stock levels properly when Multi-Location Inventory installed?
Posted by Alexander Chudinov on 03 April 2013 10:22 AM
Could the standard Magento import/export functionality be used in conjunction with the Multi-Location Inventory module?
Is there any instructions to follow to import or export stock levels properly?
Multi-Location Inventory extension supports native Magento import/export functionality.
Let's see an example based on a minimum set of the attributes: "sku","qty","store" and "use_default_website_stock". Open System > Import/Export > Dataflow - Profiles and click "Add new profile" button. Give the profile a name, select "Products" for "Entity Type", "Export" for "Direction", set the "Store" option to the appropriate storeview or leave "Default Values". Fill in next two blocks selecting "Only mapped fields" for the "Export" option. Click "Add field mapping" button and add the mentioned above attributes. You may also involve available filters (by name, sku, product type, etc.) in order to export only the necessary products. Save the profile and open it again (or simply hit "Save and continue" button). Select "Run profile" tab at the left and click "Run profile" button. Once the process finished, the file with the exported data can be found at the specified path.
Please pay attention to the "use_default_website_stock" attribute. "0" tells the system that a particular product uses its own inventory at the given website level, meanwhile "1" means that it's linked with "Default Values". You may also read more about the difference here .
Let's suppose that we want to import an information about products' quantity for a particular Website. Also, let's suppose that we're using the .csv file retrieved from the Export step above. In any way, it's better to backup the system, just in case.
Now open the file with the notepad or Open Office (as Microsoft Excel sometimes corrupts the data saving it into the .csv format). Find the "qty" related data and modify it according to your needs. In case you decide to import the changes for another Website fill in the "store" column with the corresponding identifier of that Website. The identifier can be found at System > Manage Stores > click on a Website to view its details > the necessary identifier is next to the "Code" option. If you want to link ALL the product inventory attributes to "Default Values" at the given Website level, set "use_default_website_stock" to "1" (or leave blank), otherwise set it to "0" (in this case ALL the inventory attributes will have their unique values and won't be anyhow synchronized with "Default Values").