Search Descriptions Version
 
 
This article applies to: MultiStore

Excel Product Import Fields


Using the tool at Products → Import/Export → Excel Product Import in the admin site, store owners can import their products in bulk, saving setup time. While not every field can be set through the bulk import, the majority of attributes can be handled this way. This article explains the usage of those fields in the Excel spreadsheet - for detailed descriptions of what those fields do, see this page.

When an import file is processed, the software looks at each entry and compares it to existing products in the storefront. If the SKU of a product in the import file matches an existing product, that existing product is updated with the information from the new file. If there is no SKU match, then a new product is created with that information. This requires that each product have a unique SKU if using this tool for product updating. We do not recommend doing this under most circumstances.

Standard Products

Field NameDescription
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, 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.
DistributorThis is the Distributor that your product will be assigned to (for drop shipping purposes).
Category1This 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.
Section1This 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.
DescriptionProvides a description about the product.
SEKeywordsContains keywords used to create the meta tags on product pages.
SEDescriptionContains description used to create the meta tags on product pages.
SETitleContains title used to create the meta tags on product pages.
SKUThis is your SKU for the product. This can be any alphanumeric sequence you like.
Manufacturer PartNumberThis value will be sent in distributor emails if populated (optional).
XmlPackageProvides the type of Xml Package set up on the product.
ColWidthIf multiple variants exist and are being displayed in one of the grid XML packages, determines how many columns to arrange them in.
SalesPromptIDContains the integer that determines the Sales Prompt Name issued on the product. To manage SalesPromptID, go to Misc menu, click on Sales Prompts.
PublishedDetermines whether or not the product appears on the front end of the site.
RequiresRegistrationHides the product from anonymous customers.
RelatedProductsInsert Product names here. These product will be displayed in a special box at the bottom of the main product's page.
MiscTextProvides any statement the store owner desires. For internal use only.
TrackInventoryBySizeAndColorAllows 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)
IsAKitSet this as a kit product.
ImageFilename OverrideEnter 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
ExtensionDataGenerates product's information as internal notes, special instructions, etc.
SEAltTextAlt text that will display in place of product images if the image cannot load for some reason.
VariantNameName of this product variant (optional). This value will be appended to the parent product name if filled in.
IsDefaultVariantSets the variant as default.
SKUSuffixThis value will be appended to the parent product SKU on receipts and during checkout )optional).
ManufacturerPartNumberThis value will be sent in distributor emails if populated (optional).
DescriptionProvides a description about the variant.
SEKeywordsContains keywords used to create the meta tags on variant pages.
SEDescriptionContains description used to create the meta tags on variant pages.
SETitleContains title used to create the meta tags on variant pages.
Price*The price that will be displayed to customers.
SalePriceSpecifies the sale price of the product.
MSRPManufacturer's Suggested Retail Price; For internal use only.
CostThe quoted product price paid by the store owner to the manufacturer. For internal use only.
WeightVariant weight, used for shipping calculations.
DimensionsSize of the package the item ships in.
InventoryDetermines the listing of item on hand.
Display OrderContains the order by which a certain variant will be shown at the StoreFront.
ColorsContains the variant's list of colors.
ColorSKUModifiers Contains the variant's list of SKUs assigned for each color.
SizesContains the variant's list of sizes.
SizeSKUModifiersContains the variant's list of SKUs assigned for each size.
IsTaxableDetermines whether or not this variant is taxed under the class set for the parent product.
IsShipSeparatelyIf using realtime shipping, this instructs the carrier to calculate the cost of shipping this item in its own box.
IsDownloadSet yes if the product is downloadable.
DownloadLocation This is the URL the customers will click once they purchased the dowloadable product.
PublishedDetermines whether or not the variant appears on the front end of the site. NOTE: The default variant requires publishing when setting up the variants in an import.
ImageFilename OverrideEnter 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 DataGenerates variant's information as internal notes, special instructions, etc.
SEAltTextAlt text that will display in place of variant images if the image cannot load for some reason.
StoreMappingsThis is a comma-delimited list of the stores you wish to map this product to. Each store can be listed by ID, or by name. NOTE: If any of your stores have commas in their names, you must use IDs for this field.
GTIN Global Trade Item Number for the product variant.
NOTE This was added in version 9400+

* denotes a required field

Kit Products

Field NameDescription
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.
CategoryThis 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/).
SectionThis field (and the next3) can be used to map the new product to a section or department.
SummaryProvides an overview about the kit product.
Description Provides a description about the kit product.
SKUThis your SKU for the KIT product.
ManufacturerPartNumberThis value will be sent in distributor emails if populated (optional).
XmlPackageThe XML Package type is product.kitproduct.xml.config.
ColWidthIf multiple kit products exist and are being displayed in one category, determines how many columns to arrange them in.
SalesPromptIDContains the integer that determines the Sales Prompt Name issued on the kit product. To manage SalesPromptID, go to Misc menu, click on Sales Prompts.
PublishedDetermines whether or not the kit product appears on the front end of the site.
Requires RegistrationHides the product from anonymous customers.
TrackInvetoryBySizeAndColorAllows you to specify individual inventory level for every size/color combination set up on the kit product variant.
IsAKit* Set this as a kit product.
Is Default VariantSets the variant as default.
Price*The price that will be displayed to customers.
IsTaxableDetermines whether or not the kit item is taxed under the class set for the kit product.
IsShipSeparatelyIf using realtime shipping, this instructs the carrier to calculate the cost shipping this kit product in its own box.
IsDownloadSet yes if the kit product is downloadable.
PublishedDetermines whether or not the kit item product appears on the front end of the site.
KitGroupDefThese are set of fields that defines the Kit Group.
NameThis is the name of the kit group, as it may appear to your clients.
DescriptionProvides a description about the kit group.
DisplayOrderContains the order by which a certain kit group will be shown at the Storefront.
KitGroupTypeIDDetermines the kit group type contained in the drop down menu when creating a kit group **
IsRequiredEnables 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.
DescriptionProvides a description about the kit item.
Display OrderContains the order by which a certain kit item will be shown at the Storefront.
Price DeltaThe amount that this kit item changes the base kit price.
IsDefaultSets the kit item as default display when the user views the kit group.
TextOptionMaxLengthDetermines the maximum length of text option field.
TextOptionMaxWidthDetermines the maximum width of text option field.
TextOptionMaxHeight Determines the maximum height of text option field.

* denotes a required field

** KitGroupTypeID Values:

1 - Single Select Dropdown List
2 - Single Select Radio List
3 - Multi Select Checkbox
4 - Textbox
5 - Text Area
6 - File Upload