What this solution does
Import and export of goods via Excel and CSV with logging and rollback
Upload supplier price lists to the site catalog in a few minutes and export the catalog back to Excel. The module updates prices, stock levels, properties, and product categories from files in XLSX, XLS, ODS, and CSV formats. Each import run can be undone with a single button.
Configure the import profile once; thereafter, price updates can be triggered manually or automatically on a schedule. The module operates without requiring a programmer or code modifications.
Why the module is safe
Rollback on run. If the wrong file is uploaded, open the change log and click «Start rollback». Prices, stock levels, and fields will revert to their previous values, and products and categories created during the import will be deleted.
Change log. For each product, the log displays which fields were changed and what their values were before the import. The log can be exported to Excel.
Change detection. Products with no changes in the price list are not overwritten. Re-uploading the same file runs quickly and does not disrupt the catalog.
Protection against empty files. If a supplier sends an empty price list, the module will not remove products from sale.
Import
The import wizard consists of three steps: file selection, column mapping, and execution. The process includes a progress indicator, pause, and stop functionality.
Supported file formats: XLSX, XLSM, XLS, ODS, CSV. Large files are processed in a stream, preventing memory overflow and server timeout errors.
The Top3 import and export module supports data loading from local files, server folders, links, FTP and SFTP protocols, email, and cloud storage services including Yandex.Disk, Google Drive, Mail.ru Cloud, and Dropbox. ZIP archive processing is handled automatically.
The system automatically detects the header row and maps columns based on standard labels such as "Article", "Name", "Price", "Stock", "Section", and other parameters. Product search is performed by article, code, name, or multiple fields simultaneously. Available operating modes include updating existing records, creating new ones, or deleting found items.
The module supports sections of any nesting level, defined via columns, paths within cells, or dedicated section rows in the file. All property types, images via links, and trade offers are processed. Price, stock, and warehouse data are synchronized with the "Trade Catalog". Numeric values containing separators, such as "1 250,50", are recognized correctly.
Markup and value transformations can be configured by condition, including text replacement, percentage calculation based on price, rounding, formula application, and row filtering. For products missing from the price list, actions include deactivation, stock reset to zero, or deletion, with options to restrict operations by section and filter.
Export functionality supports formats XLSX, XLSM, XLS, ODS, CSV, DBF, HTML, and PDF. Users can export any fields, properties, prices, stock levels, and sections. Features include filtering by sections and fields, sorting, and creating multiple sheets within a single file. File formatting options allow control over fonts, colors, column widths, header locking, and auto-filter activation.
Preview data before export, with the option to send the ready file to email or an FTP server.
Highload-blocks support
Import and export of Highload-block records is supported with full functionality: profile creation, column mapping, data transformation, and schedule configuration.
Profiles and automation
Profiles support grouping, copying, and version history for settings, allowing rollback to a previous state. Profiles can be transferred between different sites using a single file.
Scheduled execution is possible via a single cron line for all profiles or through standard Bitrix agents without using cron.
The system sends notifications regarding job start, successful completion, and import errors.
Access rights management includes three levels: viewing logs, running ready profiles without the ability to modify their settings, and full access.
Security
Passwords and source tokens are stored in encrypted form. Arbitrary PHP code is not executed in module settings; module events are provided for functional extensions.
The module operates exclusively in the administrative section and does not affect the site template design or site speed.
Compatibility
The module works with the standard Trade Catalog and on sites without a catalog. It is independent of the site template and its developer. PHP version 7.4–8.2, main module version 20.0 or higher, and UTF-8 site encoding are required.
If “Import and export of products in Excel and CSV formats with a log and rollback” is required, General iT can help with installation, configuration and a technical check after integration.