Importing & Exporting Products

Owned by Former user (Deleted)
Mar 08, 2017
3 min read

SmartStore.NET allows you to import or export your product data in several formats. If you already have a database which contains the product catalog you want to sell online, you obviously would not want to enter all the data again manually, but to import it automatically. One common format for structured data is CSV (delimiter separated values). CSV exports can be edited by Excel for instance.

 

Data export plugins

A data export requires an export provider that tells SmartStore.NET how to format the data. Export providers are typically provided through plugins. They can be obtained in the SmartStore Community Marketplace.

 

Export

You can export your product data to XML, CSV or PDF. With the PDF export, you can export the data of all your products or just the selected products into a visually appealing PDF catalog. For more information about the PDF format, read the topic Downloading as PDF.

Import

You can import your product data by using an import profile. To create an import profile, go to Configuration > Import. For more information about import profiles, please read the topic Managing Import Profiles. 

The import profile lets you upload CSV files that contains the catalog data to be imported. To import new products, the column name is the only mandatory field which must contain a value. If you want to update your existing product data, one of the fields SKU, Gtin (EAN), ManufacturerPartNumer or ID is mandatory and will be used to match an existing product in your catalog. If a product is found with one of these unique identifiers, it will be updated. If no product is found and a value exists in the name column, a new product will be created and the data of this line will be imported into it. For a complete list of values that will be imported, see the list below. 

How to format fields which contain IDs

Fields which contain IDs can contain multiple values that are separated by a pipe |. (e.g. CategoryIds, StoreIds)

General

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

Images

Product images can be imported by URL. Multiple URLs can be separated by a pipe |.

ImageUrls

If ImageUrls just contain file names or relative file paths, the product importer searches the folder of the import profile for image files. Example: For an import value of Content\MyImages\ProductPicture.jpg the product importer expects the file under \App_Data\ImportProfiles\name-of-my-import-profile\Content\MyImages\ProductPicture.jpg.

Download

IsDownload DownloadId UnlimitedDownloads MaxNumberOfDownloads DownloadActivationTypeId HasSampleDownload SampleDownloadId HasUserAgreement UserAgreementText

Stock

Prices

Localization

Localized values can be imported for product names, description and full description. The language code within the brackets have to match the SEO code of a language that's activated in the shop.

Â