The attached template can be used to import matrix products into MicroBiz Cloud v2.0.  


A matrix product type allows tracking of product inventory by user defined attributes - such as color and size.  This is most commonly applied for products like apparel, shoes etc. but can be generally applied when the inventory for the product is necessary to be managed by certain defined attributes or "child" SKUs.


To import data into MicroBiz Cloud, download the attached CSV file, enter or cut/paste information from your current 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 titled Importing 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.


When entering the attributes below, you can use up to three of any combination of attributes (size, color, subsize, attribute 1, attribute 2, attribute 3).  For example, for shoes you can have a matrix product with size, color, width by using the Size, Color and Subsize attribute fields,  Or for flowers you can have color, varietal and pot size by using the Color, Attribute 1 and Attribute 2 by using the Color, Attribute 1 and Attribute 2 fields. 


The following chart provides more information on the import fields:  

 

FieldRequired?Default ValuesAllowed ValuesMax LengthNotes
Product NameY
ascii DEC 32-126225Product name used on receipts and invoices.  Example: 'T-Shirt'
Product CodeY
[0-9][A-z]35Base SKU. All SKU with the same product code are created as matrix SKUs for a single matrix product.  Example: '12345'
Color Attribute ListN*
ascii DEC 32-126

This is the name given to a color list.  Example 'Standard Colors'

A Matrix product must have at least 1 matrix attribute such as color, size, fit, flavor, etc.   If it does not exist record will be rejected or list will be created depending on settings matches against attribute_code field in database -however the list may not be able to be 'named' in the import file in which case we will attempt to determine the list based on the attribute options provided. 
Color OptionN
ascii DEC 32-126
This is the color attribute or variant.  Example: 'Red'
Size Attribute ListN
ascii DEC 32-126
This is the name given to a size list label.  Example: 'Standard Sizes'
Size OptionN
ascii DEC 32-126
This is the size attribute or variant label.  Example 'XS'
SubSize Attribute ListN
ascii DEC 32-126
Used for matrix items with subsizes.
Subsize OptionN
ascii DEC 32-126
Used for matrix items with subsizes.
Attribute List 1N
ascii DEC 32-126
Attribute List 2 matches against attribute_code field in database
Attribute Option 1N
ascii DEC 32-126
Attribute option for attribute list 1 e.g. 'red', 'Small' must match attribute option code - if option does not exist record will be rejected or option added depending on settings
Attribute List 2N
ascii DEC 32-126
Attribute List 1 matches against attribute_code field in database
Attribute Option 2N
ascii DEC 32-126
Attribute Option 2
Attribute List 3N
ascii DEC 32-126
Attribute List 3 matches against attribute_code field in database
Attribute Option 3N
ascii DEC 32-126
Attribute Option 3
Attribute List 4N
ascii DEC 32-126
Currently inoperable.  Do not use.
Attribute Option 4N
ascii DEC 32-126
Currently inoperable.  Do not use
SKUY*
[0-9][A-z]50Full SKU including attribute options

If 'Auto Number SKU' is yes this can be omitted numeric values recommended - length of 16 or less recommended - SKU values must be unique
StyleN
ascii DEC 32-126100
Vendor Name

ascii DEC 32-12650These values get looked up in preprocessing and replaced by canonical id in import task records If Vendor does not exist it will be added or the record rejected depending on settings
BrandN
ascii DEC 32-12650 If Brand does not exist it will be added or the record rejected depending on settings
Main CategoryN
ascii DEC 32-12650First level category.  If Category does not exist it will be added or the record rejected depending on settings
Sub CategoryN
ascii DEC 32-12650Second level category. If Category does not exist it will be added or the record rejected depending on settings
Product ClassN
ascii DEC 32-12650Third level category.  If Category does not exist it will be added or the record rejected depending on settings
Product SubClassN
ascii DEC 32-12650Forth level category. If Category does not exist it will be added or the record rejected depending on settings
Replacement CostN0.000-99999999.99
This is the current 'cost' of the item.
Average CostN0.000-99999999.99
If you are creating products and provide a replacement cost but no avg cost the avg cost will default to the replacement cost
PriceY
0-99999999.99
This is the 'retail price' of the product used on register transactions and customer orders.
MSRP

0-99999999.99
Manufacturer suggested retail price
MAP

0-99999999.99
Minimum advertised price
Special PriceN
0-99999999.99
Date-based promotional price with start date of the date of the import.
Product Tax ClassN
ascii DEC 32-126150
UPCN
[0-9]50Alternate ID field
Alternate SKUN
[0-9],[A-z],'-'100Alternate ID field
Product IDN
[0-9],[A-z],'-','\','/'100Alternate ID field
Item NumberN
[0-9]50Alternate ID field
Bin LocationN
ascii DEC 32-126
Inoperable currently.  Value will not be imported.
Storage LocationN
ascii DEC 32-126
Inoperable currently.  Value will not be imported.
Reorder QuantityN
0-9999999

Reorder LevelN
0-9999999

Vendor Minimum QuantityN
0-9999999

Vendor DiscontinuedNNoYes/No

StatusNActiveActive/Archived

Allow FractionsNNoYes/No

Allow DiscountsNYesYes/No

Allow ReturnsNYesYes/No

Image PathNNopath and file name
allows jpeg, jpg, png files to be uploaded to product using URL to a server hosting the images.



Common Errors


  • Incorrect Flags - when entering flags for fields such as 'Allow Fractions' and 'Allow Discounts' be sure to use 'Yes' and 'No' and not 'Y" and 'N'.