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.
Example
If the Open stock of the product with SKU "test" is 1 and the file looks like this
| SKU | Store | New Stock Balance |
| test | 1 | 5 |
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:
| Field | Required? | Default Values | Allowed Values | Max Length | Notes |
| SKU | Y | ||||
| Store | Y | 15 | Enter store number being updated. This can be found in Settings>Store>Store. Example: 1 | ||
| New Stock Balance | Y | -999999999999 -> 999999999999 |