Click here to close this tab and return to the app.

Free Product Data Exporter for AspDotNetStoreFront

About the Product Export Code for AspDotNetStoreFront

aspdotnetstorefront-logo.png

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

Product Data Exporter for AspDotNetStoreFront Screenshot.png

AspDotNetStorefront Export Script Installation Instructions

  1. Register an account on our website if you haven't already.
  2. Please select a strong password and enter it below.
    Here is a random one for your convenience:     vwunygeca6h7

  3. This password will be SHA-256 hashed and inserted into the config file that you download below.
  4. Check the box to accept the license terms:
    Aten Software Product Data Exporter for AspDotNetStoreFront
    
    Copyright ©2017. Aten Software LLC. All Rights Reserved.
    
    Aten Software Product Data Exporter for AspDotNetStoreFront is 
    free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as
    published by the Free Software Foundation, either version 3 
    of the License, or (at your option) any later version.
    
    Aten Software Product Data Exporter for AspDotNetStoreFront
    is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.
    
    See http://www.gnu.org/licenses/ for
    a copy of the GNU General Public License.
  5. Save all three files to your website's root folder.
  6. Ensure that the Internet Guest Account (IUSR_MachineName) has Read permissions to the files.
  7. Open the URL to the file in your web browser.
  8. Enter your password and click the Export button.
  9. Copy the resulting URL and use this when you add a feed in your account.

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.

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.