uRapidFlow

Fast and reliable import/export of full catalog data

2010-02-28 02:56:06

Features:

Original extension includes product import/export Create, Update, Delete records Rename records (product SKU, option default title, etc.) Ignore empty or commented out rows No internal entity IDs exported/needed Recognize and skip records that do not require update Extensive data validation with detailed reporting If row contains multiple errors and warnings, log them all Import/export from/to remote location using FTP Stable small footprint memory usage Dry-run option to validate import file without changing data When importing products, automatically create option values and categories when needed (optional) Export imported file as Excel spreadsheet with cell-by-cell marking of errors and warnings, with explanations Import/export image files

Handles Data Types:

Categories Related products Up-sell products Cross-sell products Grouped products Custom options Configurable products Bundle options Images Tier Prices Downloads Product attributes Product attribute sets Product attribute options

Roadmap:

On-demand and scheduled sessions [Leeloo Dallas] Multi-pass strategy to allow free row ordering for dependent records Save set of import/export sessions and run with one click Access import/export functions using Magento API (SOAP, XMLRPC) Upload/download all your data in one archive, we'll take care of the rest Import/export from/to remote location using SFTP, HTTP, etc. Import/export category attributes Import/export files (images, downloads) Other types of data in Magento When importing products, automatically create dropdown attribute values when needed (optional)

Usage ideas:

Quick data entry Make installation independent catalog backups Mass update your catalog in Excel (export, edit, import) Migrate to clean new Magento version (export from old, import to new) Synchronize data between Magento installations Recover whatever is still possible from broken installation Delete or rename products or catalog extra data based on a criteria Integrate with other applications using CSV, SOAP or XMLRPC interface

Benchmarks on development server:

Export ~78,994 products with 120 attributes and ~1,574 inline categories: ~25 minutes (52 rows/second) Import ~78,994 products with 120 attributes and ~1,574 inline categories: ~33 minutes (39 rows/seccond) - depends on number of changes required and number of attributes Export ~1,574 categories: ~6 seconds (263 rows/second) Import ~1,574 categories: ~14 seconds (113 rows/second) Export 213,363 rows of extra product data: ~34 seconds (6,275 rows/second) Import 213,363 rows of extra product data: ~5.5 minutes (647 rows/second)