Free Product Data Exporter for AspDotNetStoreFront
About the Product Export Code for AspDotNetStoreFront
The Product Data Exporter for AspDotNetStoreFront is open-source and free software that exports all the product data from your ASPDNSF online store. The exported data can be connected to our AspDotNetStoreFront Data Feed Service, giving you the ability to generate data feeds and get listed in all the major comparison shopping engines like Google Shopping, Bing Shopping, and over 20 others.
New Features in 2017!
- Forward and backward-compatible with all versions/editions of ASPDotNetStoreFront (8.x, 9.x, 10.x, ML8, MSx, MultiStore, etc.)
- Improved security and more PCI-compliant
- Approved for use in AspDotNetStorefront Cloud Hosting with security services
- Improved performance (fast exports of very large stores)
- Mobile-optimized UI with more filtering options
AspDotNetStorefront Export Script Installation Instructions
Features
- Exports all products and variants
- Exports all product/variant data (except cost)
- Exports Manufacturer, Category, ProductURL, and ImageURL
- Extremely high-performance and light-weight
- Free and open-source
- Password-protected export
- Easy-to-install (just copy to server)
- CSV file format (Excel-compatible)
Setup Notes
The product data exporter code consists of three files that you install in your website. This will create a page on your website from which you can download all the product data from your store. The page will prompt for a password before allowing the product data to be exported. If a password is not configured, then downloading will be disabled.
You can set a password when downloading the code. You can also set/change the password by editing the .config file in notepad.
The exporter script accepts URL query string parameters to generate the output. 'Command' must be set to 'Export' and 'Password' must be set to the password defined in the .config file. The script is designed to disallow a blank password. The final URL will look like the following, where italicized parts should be customized to your store:
http://www.mystore.com/aten_exporter_for_aspdnsf.aspx?Command=Export&Password=ABCDEFG
Direct Download Links
Below are links to download/view the code directly.
- aten_exporter_for_aspdnsf.aspx
- aten_exporter_for_aspdnsf.aspx.vb
- aten_exporter_for_aspdnsf.config - blank password
List of Exported Fields (Varies by version of ASPDotNetStorefront)
Product_ProductID Product-ProductGUID Product-Name Product-Summary Product-Description Product-SEKeywords Product-SEDescription Product-SpecTitle Product-MiscText Product-SwatchImageMap Product-IsFeaturedTeaser Product-FroogleDescription Product-SETitle Product-SENoScript Product-SEAltText Product-SizeOptionPrompt Product-ColorOptionPrompt Product-TextOptionPrompt Product-ProductTypeID Product-TaxClassID Product-SKU Product-ManufacturerPartNumber Product-SalesPromptID Product-SpecCall Product-SpecsInline Product-IsFeatured Product-XmlPackage Product-ColWidth Product-Published Product-Wholesale Product-RequiresRegistration Product-Looks Product-Notes Product-QuantityDiscountID Product-RelatedProducts Product-UpsellProducts Product-UpsellProductDiscountPercentage Product-RelatedDocuments Product-TrackInventoryBySizeAndColor Product-TrackInventoryBySize Product-TrackInventoryByColor Product-IsAKit Product-ShowInProductBrowser Product-IsAPack Product-PackSize Product-ShowBuyButton Product-RequiresProducts Product-HidePriceUntilCart Product-IsCalltoOrder Product-ExcludeFromPriceFeeds Product-RequiresTextOption Product-TextOptionMaxLength Product-SEName Product-ExtensionData Product-ExtensionData2 Product-ExtensionData3 Product-ExtensionData4 Product-ExtensionData5 Product-ContentsBGColor Product-PageBGColor Product-GraphicsColor Product-ImageFilenameOverride Product-IsImport Product-IsSystem Product-Deleted Product-CreatedOn Product-PageSize Product-WarehouseLocation Product-AvailableStartDate Product-AvailableStopDate Product-GoogleCheckoutAllowed Product-SkinID Product-TemplateName ProductVariant-VariantID ProductVariant-VariantGUID ProductVariant-IsDefault ProductVariant-Name ProductVariant-Description ProductVariant-SEKeywords ProductVariant-SEDescription ProductVariant-Colors ProductVariant-ColorSKUModifiers ProductVariant-Sizes ProductVariant-SizeSKUModifiers ProductVariant-FroogleDescription ProductVariant-ProductID ProductVariant-SKUSuffix ProductVariant-ManufacturerPartNumber ProductVariant-Price ProductVariant-SalePrice ProductVariant-Weight ProductVariant-MSRP ProductVariant-Points ProductVariant-Dimensions ProductVariant-Inventory ProductVariant-DisplayOrder ProductVariant-Notes ProductVariant-IsTaxable ProductVariant-IsShipSeparately ProductVariant-IsDownload ProductVariant-DownloadLocation ProductVariant-FreeShipping ProductVariant-Published ProductVariant-Wholesale ProductVariant-IsSecureAttachment ProductVariant-IsRecurring ProductVariant-RecurringInterval ProductVariant-RecurringIntervalType ProductVariant-SubscriptionInterval ProductVariant-RewardPoints ProductVariant-SEName ProductVariant-RestrictedQuantities ProductVariant-MinimumQuantity ProductVariant-ExtensionData ProductVariant-ExtensionData2 ProductVariant-ExtensionData3 ProductVariant-ExtensionData4 ProductVariant-ExtensionData5 ProductVariant-ContentsBGColor ProductVariant-PageBGColor ProductVariant-GraphicsColor ProductVariant-ImageFilenameOverride ProductVariant-IsImport ProductVariant-Deleted ProductVariant-CreatedOn ProductVariant-SubscriptionIntervalType ProductVariant-CustomerEntersPrice ProductVariant-CustomerEntersPricePrompt ProductVariant-SEAltText Product-Manufacturer-Name Product-Category-Name ProductUrl ImageUrl IconImageUrl MediumImageUrl LargeImageUrl AllCategoriesJSON AllManufacturersJSON AllSectionsJSON AllStoresJSON
Technical Notes
The output is compressed to save bandwidth, if supported by the browser.
This script can export 100,000 products in minutes (100s of MB of uncompressed data). Smaller stores are exported in seconds.
If a product has multiple manufacturers/categories, then only one is exported.
If you are running an unlicensed copy of AspDotNetStorefront, you will see a "Content Encoding Error" message in your browser when attempting to export. Disable compression as instructed in the .config file to resolve this.
The output is encoded in UTF-8. Use OpenOffice Calc if your version of Excel does not support UTF-8.
The script filters out products based on approximately a dozen criteria, to prevent feeding items that are deleted, unpublished, not available, zero price, etc. If all your products are not exported by the script, check the checkboxes to include those items. No coding necessary!
The script first creates a snapshot of the VariantIDs based on the criteria. Then, it loops through each VariantID in the snapshot and sends the product details one by one. This prevents excessive locking of your product database and store. However, if you make changes to product details after the snapthot is created and before the script finishes, then there may be inconsistencies in the exported data.