This article describes the fields that may be imported for Supertrack Inventory items. Almost all of the fields are optional to import.  The most important fields are described first. ManageMore can read and import files that are Comma Delimited (CSV), Tab Delimited, or Fixed Length file format.  If your data is in proprietary formats like Microsoft Excel, you will need to resave the spreadsheet in CSV format.   For convenience, If your column heading matches the ManageMore Field/Column Names, the field will be automatically mapped for you.  But you can still manually map fields regardless of the column heading.

 

Basic Fields

These fields are considered to be the essential values that make up an inventory item.

Field/Column Name Field Type Max Chars Case Notes / Rules
SKU Item String 16 Uppercase Unique Item code to represent the product/service.  If this value already exists,  then all data will be used to update the existing inventory item. If this field is not provided, the import process will  assign a generated value for the item.
UPC String 25 Uppercase UPC/Barcode for item. Optional lookup value. Must be unique. If UPC exists, item will be updated.
Description String 100 Any Description of Item
Price Level 1 Decimal Price of Item for Level 1
Quantity on Hand Decimal Initial Quantity on Hand. CANNOT be used to update existing items that are already in use. (To do so, use Count Physical Inventory, import counts)

 

 

Extended Fields (Optional)

These fields are considered optional, but are commonly used on an inventory item for additional functionality.

Field/Column Name Field Type Max Chars Case Notes / Rules
Category Id String 10 Uppercase Category Id of item. If category Id does not exist, it will be added, with Category Name provided, or Id as name.
Category Name String 40 Proper Case Category Name of item. If category does not exist, it will be added, with Category Id provided, or sequential Id.
Average/Last Unit Cost  Decimal Unit Cost of Item at Inventory measure
Last Purchase Cost Decimal Cost of Item at Purchase Measure
Price Level 2 Decimal Price of Item for Level 2. If not present, Level 1 value will be used for new items, if this price level is defined.
Price Level 3 Decimal Price of Item for Level 3. If not present, Level 1 value will be used for new items, if this price level is defined.
Price Level 4 Decimal Price of Item for Level 4. If not present, Level 1 value will be used for new items, if this price level is defined.
Price Level 5 Decimal Price of Item for Level 5. If not present, Level 1 value will be used for new items, if this price level is defined.
Price Level 6 Decimal Price of Item for Level 6. If not present, Level 1 value will be used for new items, if this price level is defined.
Price Level 7 Decimal Price of Item for Level 7. If not present, Level 1 value will be used for new items, if this price level is defined.
Price Level 8 Decimal Price of Item for Level 8. If not present, Level 1 value will be used for new items, if this price level is defined.
Suggested Mfg Retail Decimal Used for Discounting/Display. If not present, Level 1 value will be used for new items.
Lowest Sell Price Decimal Used as a Floor for Price Adjustments. If not present Last Unit Cost is used.
Primary Vendor String 10 Uppercase Unique Vendor Id of main vendor. If vendor Id does not exist, it will be added, with Vendor Name provided, or Id as name.
Vendor Name String 40 Proper Case Vendor Name of main vendor.  If vendor does not exist, it will be added, with Vendor Id provided, or sequential Id.
Department Id String 10 Uppercase Department Id of item. If department Id does not exist, it will be added, with Department Name provided, or Id as name
Department Name String 40 Proper Case Department Name of item. If department does not exist, it will be added, with Department Id provided, or sequential Id
Tax Unit Decimal Taxable Units. Used for certain Indirect and/or Sales Tax basis. (e.g. products taxed by ML, etc.) Multiplied by sale quantity and rate to determine tax amount.
Auto Assign SKU String 1 Assign a new SKU value.  A value of ‘1’ or ‘Y’ will assign a new sequentially generated SKU value to the imported product.
Bin Location 1 String 40 Sortable Bin Location of Item (Warehouse documents are sorted using this field)

 

 

MSA Reporting (Optional)

The following fields are used for businesses that work with brand manufacturers that need data reported to MSA.  These fields are used in conjunction with ManageMore’s integrated MSA Reporting capabilities.

Field/Column Name Field Type Max Chars Case  Notes / Rules
MSA Required Item Boolean Flag to indicate whether item Qualifies for MSA Reporting.
MSA Category Code Integer Code assigned to this item by MSA (e.g. 3231 for cigarettes).
MSA Description String 40 Uppercase recommended Optional Alternate Description for item in MSA reporting.
Items Per Selling Unit Integer Number of items per sales unit, as defined by MSA

 

 

Unit of Measure (Optional)

The following fields are used if you purchase an item in a different measure than it is sold.  For example, if you  purchase an item by the case, and sell it by the box.

Field/Column Name Field Type Max Chars Case  Notes / Rules
Sale Unit Measure Id String 4 Uppercase Id of measure by which this item is sold (e.g. CS)  This should be the LOWEST denomination by which this item is sold.  Base prices reflect this measure
Sale Qty Measure Decimal Quantity multiplier by which this item is sold. (e.g. 24) This should be the LOWEST denomination by which this item is sold. Each unit sold will decrease inventory by this quantity. Base prices reflect this quantity. Cannot be zero.
Purchase Unit Measure Id String 4 Uppercase Id of measure by which this item is purchased (e.g. CS)  Purchase costs reflect this measure.
Purchase Qty Measure Decimal Quantity multiplier by which this item is purchased. (e.g. 24) Each unit purchased will increase inventory by this quantity. Purchase costs reflect this quantity. Cannot be zero.

 

Item Alias Code (Optional)

The following fields allow you to import an additional code and measure by which this item is sold. These fields are used, for example, if you sell an item by the box, and ALSO sell it by the case. For this, the main product should be at the lowest denomination sold (e.g. box), and the Alias will be the multiple for the additional denomination sold (e.g case).

Field/Column Name Field Type Max Chars Case  Notes / Rules
Alias Case/Pack SKU String 25 Uppercase Optional Alternate Item code used for selling item at another multple. Can be an alterate UPC code.
Alias Case/Pack Name String  10  Proper Case Name that represents this measure. Used for used selection. (e.g. Case)
Alias Case/Pack Abbreviation String 4 Uppercase Abbreviation that represents this measure. Used for printing (e.g. CS)
Alias Case/Pack Quantity Integer Quantity Multiplier that represents this measure (e.g. 24)
Alias Case/Pack Price Decimal Optional override Unit Price for this measure. Will be multiplied by the Alias Case Pack/Quantity. This price applies to all price levels.

 

Web Related (Optional)

The following fields are used for the eConnect Cart website interface which is used by ManageMore to update product information on your web store.

Field/Column Name Field Type Max Chars Case  Notes / Rules
Post to Internet Boolean Flag to indicate whether item should be synchronized to the website.
Web Sale Price Decimal Used on Website for Base Price. If not present, Level 1 value will be used for new items, if this price level is defined.
Web Description (Alt.) String Optionally used on Website as the Item decription. If not present, eConnect will use the main item description.
Web Description (Short) String Used on Website for Short Description. HTML is allowed in this field.
Web Description (Full) String Used on Website for Full Description. HTML is allowerd in this field.
Web Image File Name String Image file name(s) to be used on website. First image is used as the main image. Other image names may be separated by comma. Do not include path information.

 

Matrix Related (Optional)

The following fields are used when creating a Matrix Parent Item and its related Children Items.  Assigning 

Field/Column Name Field Type Max Chars Case  Notes / Rules
Parent Matrix Item String 12 Uppercase Must be present on all Child Items that make up the matrix product. This value supersedes the Item SKU field and is used to generate the new Item SKU value for each child item.  The SKU field will be ignored when this field is present.
Attrbute Type 1 String 30 Proper Case The name of attribute 1 for this item (e.g. Style, Flavor, Color, Size, etc.).  If this field is not present, the import will use ‘Variant’ as the name of the Attribute.
Attribute Type 2 String 30 Proper Case The name of attribute 2 for this item (e.g. Style, Flavor, Color, Size, etc.).  If this field is not present, the import will use ‘Variant’ as the name of the Attribute.
Attribute Value 1 String 50 Proper Case The value of attribute 1 for this item (e.g. Raspberry)
Attribute Value 2 String 50 Proper Case The value of attribute 2 for this item (e.g. Large)

 

Additional Information about Importing

  • When updating records, only fields present will be updated. Zero or Blank data will NOT overwite existing data. For certain fields it is possible to clear exising data by importing a value of dash (-) to string fields or negative one (-1) to numeric fields.  Contact Technical Support for more information about clearing existing data.
  • If Uppercase is required, values will be converted upon import.
  • Proper Case is not enforced.  However, these fields are Proper Case if data is entered in ManageMore.
  • SKU Item codes and UPC codes will be sanitized upon import. Illegal characters such as brackets, space, ampersand, percent are removed from the code BEFORE attempting to find a match.
  • Boolean values will accept 1/0, T/F or Y/N