The attached template can be used to import serial numbers for products into MicroBiz Cloud v2.0.
To import data into MicroBiz Cloud, download the attached CSV file, enter or cut/paste information from your vendor or current POS system into the spreadsheet and then import as a CSV into MicroBiz Cloud using the file import wizard (see Settings>Imports)
Important: Do not modify the template in any way, such as adding/deleting columns, changing the column headings, or changing the format from CSV.
In the Product Import page, you can select which type of Product ID you are going to use - SKU, UPC, Alternate SKU or Item Number
You may also need to select the Store ID wether it is the Store Short Name or The Store Number:
The following chart provides more information on the import fields:
Field | Required Y/N | Allowed Values | Notes |
Product ID | Y | ascii DEC 32-126 | Based on what Product ID is selected, you need to make sure you enter existing ID |
Store ID | Y | ascii DEC 32-126 | Based on the Store ID selection, you need to enter the Store Short Name or the Store ID, which you can find in your Store information |
Serial No. | Y | ascii DEC 32-126 | Enter the serial number of your products |
FastBound ID | N | ascii DEC 32-126 | You can enter The FastBound ID of the product if such exists |