The attached template can be used to import simple products into MicroBiz Cloud v2.0.  A simple product is a physical item with a simple SKU and is the most basic form of all products. A simple product can be sold individually, or under grouped, bundle, or configurable/matrix products. 


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).  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:  


 

FieldRequired Y/NDefault ValuesAllowed ValuesMax LengthNotes
Product NameY
ascii DEC 32-126225Primary name for the product that will appear on receipts and invoices.
SKUY*
[0-9][A-z]50SKU values must be unique.  Numeric values recommended.  Length of 16 characters or less recommended.  If the 'Auto Number SKU' setting is 'yes' this field can be left blank.  
StyleN
ascii DEC 32-126100Secondary ID or description of the product.  
Vendor NameN
ascii DEC 32-12650If the Vendor does not exist in MicroBiz, it will be added automatically or the record rejected depending on settings
BrandN
ascii DEC 32-12650If Brand does not exist in MicroBiz, it will be added automatically or the record rejected depending on settings
Main CategoryN
ascii DEC 32-12650First level category.  If a Category does not exist in MicroBiz, it will be added automatically or the record rejected depending on settings
Sub CategoryN
ascii DEC 32-12650Second level category. If a Category does not exist in MicroBiz, it will be added automatically or the record rejected depending on settings
Product ClassN
ascii DEC 32-12650Third level category.  If a Category does not exist in MicroBiz, it will be added automatically or the record rejected depending on settings
Product SubClassN
ascii DEC 32-12650Forth level category. If a Category does not exist in MicroBiz, it will be added automatically or the record rejected depending on settings
Replacement CostN0.000-99999999.99
The current cost of the product.
Average CostN
0-99999999.99
If no avg cost is included, the avg cost will default to the replacement cost
PriceY
0-99999999.99
Current retail price of the product.
MSRPN
0-99999999.99
Manufacturer suggested retail price
MAPN
0-99999999.99
Minimum advertised price
Special PriceN
0-99999999.99
Current sale or promo price of the product.  The system will use the import date as the start date of Special Price with no end date by default.
Product Tax ClassN
ascii DEC 32-126150If Product Tax Class does not exist it will be added or the record rejected depending on settings
UPCN
[0-9]50Searchable alternate ID
Alternate SKUN
[0-9],[A-z],'-'100Searchable alternate ID
Product IDN
[0-9],[A-z],'-','\','/'100Searchable alternate ID
Item NumberN
[0-9]50Searchable alternate ID
Bin LocationN
ascii DEC 32-126
Note:  This field is currently non-functional, so imported values will not be displayed
Storage LocationN
ascii DEC 32-126
Note:  This field is currently non-functional so imported values will not be displayed
Reorder QuantityN
0-9999999

Reorder LevelN
0-9999999

Vendor Minimum QuantityN
0-9999999

Vendor DiscontinuedNNoYes/No
Will default to 'No' if no value imported 
StatusNActiveActive/Archived
Will default to 'Active' if no value imported
Allow FractionsNNoYes/No
Will default to 'No' if no value imported 
Allow DiscountsNYesYes/No
Will default to 'Yes' if no value imported
Allow ReturnsNYesYes/No
Will default to 'Yes' if no value imported
Image PathNNopath and file name
Allows jpeg, jpg, png files to be uploaded to the product with a valid URL from a third party server hosting the images 

Special Price Begin Date

N
YYYY-MM-DD

Start date for sale or promotional price entered in the Special Price field.  The date must be entered in this format.

Special Price End Date

N
YYYY-MM-DD

End date for sale or promotional price entered in the Special Price field.  The date must be entered in this format.