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.
Important: Do not modify the template in any way, such as adding/deleting columns, changing the column headings, or changing the format from CSV.
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. Exemple: 1 | ||
New Stock Balance | Y | -999999999999 -> 999999999999 |