The attached template can be used to replace or overwrite beginning stock levels in MicroBiz Cloud v2.0.  

This import will replace existing stock levels and can be used to import results of a physical inventory count. 

To import data into MicroBiz Cloud, download the attached CSV file, enter or cut/paste information into the spreadsheet, and then import as a CSV file into MicroBiz Cloud using the file import wizard (see Settings>Imports).  If you need additional help, review the article titles Importing Simple Products via CSV File.

You can select whether you want to update stock by SKU or by UPC

The import will set the stock of the product the value entered in the file.


 If the Open stock of the product with SKU "test" is 1 and the file looks like this

SKUStoreNew Stock Balance

After the import, "test" product will have 5 open stock

Important: Do not modify the template in any way, such as adding/deleting columns, changing the column headings, or changing the format from CSV.

Attached csv file is used both for SKU and UPC update.

The following chart provides more information on the import fields:  


FieldRequired?Default ValuesAllowed ValuesMax LengthNotes


15Enter store number being updated.  This can be found in Settings>Store>Store.  Example: 1
New Stock Balance
-999999999999  -> 999999999999