This robust utility is intended for product data management of large sites with massive amounts of product and product mapping data.
For superior performance to competing products, this import/export utility does NOT use or require the WSI.
Provides easy to use, simple interface where usability is the key.
- Allows filtering by all entities: Category, Section, Distributors, Manufacturer, Genre and Vector
- Includes keyword search for additional export filtering
- Shows data preview on export and import
- Exports ALL product and variant data
- Imports ALL product and variant data
- Exports and Import category xPath data
- Support importing of new product data as well as updating of existing product data
- Dynamic lookup of columns during import; does not require all columns to be present
- Made to run on huge datasets for hours; very robust
Question:Which versions of Excel does this support?
-
Richard
(02/11/2013)
Response:This plugin supports both 2003 (xls) and 2007 (xlsx) and newer Excel formats.
Question:Does this utility use the WSI?
-
Andrian
(02/08/2013)
Response:Our Utility does not use the WSI so it does not take up precious resources from your cart. Instead, it communicates directly with the database allowing you to process large data sets for hours or days if needed (all "outside" of the cart).
Question:Does this export allow for importing and creating new categories?
-
Dan
(02/08/2013)
Response:Yes, the Utility allows you to export out the product's category path and also allows you to import with a new/updated category xPath if needed. If the category being imported does not exist in the cart, it will automatically create the category as well as map the product to it.
|
- Very simple install, instructions included in download.
- Does NOT require cart source code
- Requires remote access to your SQL server
- Requires Microsoft Excel/Office
NOTE: this is a one cart/one domain license
R
EQUIRES WINDOWS (SERVER 2003+/7+) MACHINE AND EXCEL(2007+)
|
Version 1.28 - 5/8/2014
- fixed an issue with exporting datasets to xlsx file types
- transferred missing documentation to the new site
Version 1.27 - 1/14/2014
Version 1.26 - 11/19/2013
- update to handle new aspdotnetstorefront database changes
Version 1.25 - 10/5/2013
- update to handle new aspdotnetstorefront database schema
Version 1.24 - 6/10/2013
- added up to 15 entities for export - 15 of each type
- added in a published and deleted flag for product filtering on export
Version 1.23 - 1/30/2013
- fixed an import issue where apostrophes were duplicating in certain fields.
Version 1.22 - 1/7/2013
- found a parsing issue with some delimiters.
Version 1.21 - 12/10/2012
- fixed conversion to lowercase for some database fields.
Version 1.20 - 11/30/2012
- changed the title of the main window to display the current version of the release.
Version 1.19 - 11/29/2012
- added support for multiple chunks in the export module to avoid database connection issues.
Version 1.18 - 11/6/2012
- added better support for the case where an identifier field is a duplicate. (IE. two products have the same name)
Version 1.17 - 8/8/2012
- Changed the versioning Scheme to be a bit easier to understand
- added more database string sanitation to the product lookup routines
- changed the variant lookup structure to no longer require that a variant have a name, it now support a blank name.
Version 1.0.15 - 4/24/2012
- fixed a bug with product variant import where the variant wasn't coupled with the product
Version 1.0.14 - 4/15/2012
- Edited the mapping structure to exclude blank entities
- Added requirements of name and sku for product import
Version 1.0.13 - 4/06/2012
- Added Trimming for the entity import and export
Version 1.0.12 - 3/27/2012
- Updated the Genre and Vector Mapping structure
Version 1.0.11 - 3/23/2012
- corrected logic error with the Genre and vector mappings
- changed all the mappings to import based on the '>' delim as opposed to the '>' and the ' ' delim
- updated newly created product descriptions to wipe out the placeholder used by the program if it's not being imported
- trimmed the white space on all of the entity names
- corrected the import of blank entities if you have a blank space in the import sheet
- corrected creation of the blank product that results from a blank line in the import sheet
Version 1.0.10 - 3/21/2012
- changed the help menu to point to the website links
Version 1.0.9 - 3/16/2012
- added web help links to topics on ECCM
Version 1.0.8 - 3/16/2012
- added a data integrity checker module
- changed error catching method to work on older carts (below 8x)
Version 1.0.7 - 2/10/2012
- changed entity xpath generation to work off of a stored procedure for speed
- changed the layout to a tabbed form for ease of use
Version 1.0.6 - 1/4/2012
- Added more caching layers for entity xpath generation
Version 1.0.5 - 12/29/2011
- Fixed a bug where insertion of new products with no variant data resulted in a crash.
Version 1.0.4 - 12/28/2011
- Fixed a bug where a partial sheet update doesn't work unless all tables had filled in fields
Version 1.0.3 - 11/28/2011
- added cache levels for faster importing
- Added MultiStore Support
- fixed a bug that caused the entities not to show up on the preview pane during export
Version 1.0.2
- Fixed a bug that prevented the distributor mapping from showing up
- Changed the cache layer to allow for more speed when exporting products.
Version 1.0.1
- Fixed a few bugs that prevented exporting of data in some cases.
- added a cache layer for the category and section list to increase throughput speed
- added a counter for each item processed
|
|
