| Field Name | Description |
| ProductName* | This is the name of the product, as it will appear to your customers. |
| ProductTypeID* | Here you specify the Product Type (Generic Product, Kit Product, Pack Product, etc). |
| Manufacturer* | This is the Manufacturer your new product will be mapped to. If no manufacturers are set up or used for your business, use the "Generic Mfg" that comes preloaded in the software. |
| Distributor | This is the Distributor that your product will be assigned to (for drop shipping purposes). |
| Category1 | This field (and the next 3) can be used to map the new product to a category. The format should be /category/subcat/subsubcat/etc (be sure to include the preceding /). For example, /Books/Science Fiction/Robert A. Heinlein. If a category listed in this field doesn't exist when the import runs, it will be created. |
| Section1 | This field (and the next 3) can be used to map the new product to a section or department.. |
| Summary | Provides an overview about the product. |
| Description | Provides a description about the product. |
| SEKeywords | Contains keywords used to create the meta tags on product pages. |
| SEDescription | Contains description used to create the meta tags on product pages. |
| SETitle | Contains title used to create the meta tags on product pages. |
| SKU | This is your SKU for the product. This can be any alphanumeric sequence you like. |
| Manufacturer PartNumber | This value will be sent in distributor emails if populated (optional). |
| XmlPackage* | Provides the type of Xml Package set up on the product. |
| ColWidth* | If multiple variants exist and are being displayed in one of the grid XML packages, determines how many columns to arrange them in. |
| SalesPromptID* | Contains the integer that determines the Sales Prompt Name issued on the product. To manage SalesPromptID, go to Misc menu, click on Sales Prompts. |
| Published* | Determines whether or not the product appears on the front end of the site. |
| RequiresRegistration* | Hides the product from anonymous customers. |
| RelatedProducts | Insert Product names here. These product will be displayed in a special box at the bottom of the main product's page. |
| MiscText | Provides any statement the store owner desires. For internal use only. |
| TrackInventoryBySizeAndColor* | Allows you to specify individual inventory level for every size/color combination set up on the product variant(s).
(Using this method will not work with Kits tied to the variant) |
| TrackInventoryBySize* | This column is no longer used, and should be set to the same value as TrackInventoryBySizeAndColor. |
| TrackInventoryByColor* | This column is no longer used, and should be set to the same value as TrackInventoryBySizeAndColor. |
| IsAKit* | Set this as a kit product. |
| IsAPack* | Set this as a pack product. |
| ImageFilename Override | Enter the full image name including the file extension if using this method for images. This automatically overrides images mapped by the ProductID (or SKU). Example: product123.png |
| PackSize | Specifies the size of the pack product. |
| ExtensionData | Generates product's information as internal notes, special instructions, etc. |
| VariantName | Name of this product variant (optional). This value will be appended to the parent product name if filled in. |
| IsDefaultVariant | Sets the variant as default. |
| SKUSuffix | This value will be appended to the parent product SKU on receipts and during checkout )optional). |
| ManufacturerPartNumber | This value will be sent in distributor emails if populated (optional). |
| Description | Provides a description about the variant. |
| SEKeywords | Contains keywords used to create the meta tags on variant pages. |
| SEDescription | Contains description used to create the meta tags on variant pages. |
| SETitle | Contains title used to create the meta tags on variant pages. |
| Price* | The price that will be displayed to customers. |
| SalePrice | Specifies the sale price of the product. |
| MSRP | Manufacturer's Suggested Retail Price; For internal use only. |
| Cost | The quoted product price paid by the store owner to the manufacturer. For internal use only. |
| Weight | Variant weight, used for shipping calculations. |
| Dimensions | Size of the package the item ships in. |
| Inventory | Determines the listing of item on hand. |
| Display Order | Contains the order by which a certain variant will be shown at the StoreFront. |
| Colors | Contains the variant's list of colors. |
| ColorSKUModifiers | Contains the variant's list of SKUs assigned for each color. |
| Sizes | Contains the variant's list of sizes. |
| SizeSKUModifiers | Contains the variant's list of SKUs assigned for each size. |
| IsTaxable* | Determines whether or not this variant is taxed under the class set for the parent product. |
| IsShipSeparately* | If using realtime shipping, this instructs the carrier to calculate the cost of shipping this item in its own box. |
| IsDownload* | Set yes if the product is downloadable. |
| DownloadLocation | This is the URL the customers will click once they purchased the dowloadable product. |
| Published* | Determines whether or not the variant appears on the front end of the site. |
| ImageFilename Override | Enter the full image name including the file extension if using this method for images. This automatically overrides images mapped by the ProductID (or SKU). Example: product123.png |
| Extension Data | Generates variant's information as internal notes, special instructions, etc. |
| Field Name | Description |
| ProductName* | This is the name of the kit product, as it will appear to your customers. |
| ProductTypeID* | Here you specify the Product Type as Kit Product. |
| Manufacturer* | This is the Manufacturer where your kit product will be mapped to. If no manufacturers are set up or used for your business, use the Generic Mfg that comes preloaded in the software. |
| Category | This field (and the next 3) can be used to map the kit product to a category. The format should be /category/subcat/subsubcat/etc (be sure to include the preceding/). |
| Section | This field (and the next3) can be used to map the new product to a section or department. |
| Summary | Provides an overview about the kit product. |
| Description | Provides a description about the kit product. |
| SKU | This your SKU for the KIT product. |
| ManufacturerPartNumber | This value will be sent in distributor emails if populated (optional). |
| XmlPackage* | The XML Package type is product.kitproduct.xml.config. |
| ColWidth* | If multiple kit products exist and are being displayed in one category, determines how many columns to arrange them in. |
| SalesPromptID* | Contains the integer that determines the Sales Prompt Name issued on the kit product. To manage SalesPromptID, go to Misc menu, click on Sales Prompts. |
| Published* | Determines whether or not the kit product appears on the front end of the site. |
| Requires Registration* | Hides the product from anonymous customers. |
| TrackInvetoryBySizeAndColor* | Allows you to specify individual inventory level for every size/color combination set up on the kit product variant. |
| TrackInvetoryBySize | This column is no longer used, and should be set to the same value as TrackInventoryBySizeAndColor |
| TrackInvetoryByColor | This column is no longer used, and should be set to the same value as TrackInventoryBySizeAndColor |
| IsAKit* | Set this as a kit product. |
| IsAPack* | Do not set this as a pack product. |
| PackSize | Specifies the size of the kit product. |
| Is Default Variant | Sets the variant as default. |
| Price* | The price that will be displayed to customers. |
| IsTaxable* | Determines whether or not the kit item is taxed under the class set for the kit product. |
| IsShipSeparately | If using realtime shipping, this instructs the carrier to calculate the cost shipping this kit product in its own box. |
| IsDownload* | Set yes if the kit product is downloadable. |
| Published* | Determines whether or not the kit item product appears on the front end of the site. |
| KitGroupDef | These are set of fields that defines the Kit Group. |
| Name* | This is the name of the kit group, as it may appear to your clients. |
| Description* | Provides a description about the kit group. |
| DisplayOrder* | Contains the order by which a certain kit group will be shown at the Storefront. |
| KitGroupTypeID* | Determines the kit group type contained in the drop down menu when creating a kit group ** |
| IsRequired | Enables the customer to select at least one item from the kit group before adding the kit to their cart. |
| Name* | This is the name of the kit item, as it may appear to your clients. |
| Description* | Provides a description about the kit item. |
| Display Order* | Contains the order by which a certain kit item will be shown at the Storefront. |
| Price Delta* | The amount that this kit item changes the base kit price. |
| IsDefault | Sets the kit item as default display when the user views the kit group. |
| TextOptionMaxLength | Determines the maximum length of text option field. |
| TextOptionMaxWidth | Determines the maximum width of text option field. |
| TextOptionMaxHeight | Determines the maximum height of text option field. |