Excel Import Format

How to format an Excel import file?

An import file needs at least two columns (Name and SKU).

The following fields are optional:

ProductTypeId
ParentGroupedProductId
VisibleIndividually
Name
ShortDescription
FullDescription
ProductTemplateId
ShowOnHomePage
MetaKeywords
MetaDescription
MetaTitle
SeName
AllowCustomerReviews
Published
SKU
ManufacturerPartNumber
Gtin
IsGiftCard
GiftCardTypeId
RequireOtherProducts
RequiredProductIds
AutomaticallyAddRequiredProducts
IsDownload
DownloadId
UnlimitedDownloads
MaxNumberOfDownloads
DownloadActivationTypeId
HasSampleDownload
SampleDownloadId
HasUserAgreement
UserAgreementText
IsRecurring
RecurringCycleLength
RecurringCyclePeriodId
RecurringTotalCycles
IsShipEnabled
IsFreeShipping
AdditionalShippingCharge
IsTaxExempt
TaxCategoryId
ManageInventoryMethodId
StockQuantity
DisplayStockAvailability
DisplayStockQuantity
MinStockQuantity
LowStockActivityId
NotifyAdminForQuantityBelow
BackorderModeId
AllowBackInStockSubscriptions
OrderMinimumQuantity
OrderMaximumQuantity
AllowedQuantities
DisableBuyButton
DisableWishlistButton
AvailableForPreOrder
CallForPrice
Price
OldPrice
ProductCost
SpecialPrice
SpecialPriceStartDateTimeUtc
SpecialPriceEndDateTimeUtc
CustomerEntersPrice
MinimumCustomerEnteredPrice
MaximumCustomerEnteredPrice
Weight
Length
Width
Height
CreatedOnUtc
CategoryIds
ManufacturerIds
Picture1
Picture2
Picture3
DeliveryTimeId
BasePriceEnabled
BasePriceMeasureUnit
BasePriceAmount
BasePriceBaseAmount
BundleTitleText
BundlePerItemShipping
BundlePerItemPricing
BundlePerItemShoppingCart
BundleItemSkus

Localized resources can be imported for product names, description and full description.

Name[en]
ShortDescription[en]
FullDescription[en]
Name[de]
ShortDescription[de]
FullDescription[de]
etc.

The language code within the brackets have to match the SEO code of a language that's activated in the shop.