Import from Excel. Loading the 1C-Bitrix product catalog

What this solution does

The module is designed for the «1C-Bitrix: Site Management» platform and enables importing infoblock elements, including products, from Excel files. It also supports data loading into Highload blocks.

Video tutorials are available covering the main import instructions, a guide for importing sections with the ability to link elements to multiple sections, and instructions for importing files where sections are listed in separate rows.

The module supports importing catalog sections without items. It enables loading trade offers and creating additional fields that are absent in the source file. The system synchronizes price lists from multiple suppliers with automatic deactivation of products. It updates prices and stock levels, imports multiple properties with their descriptions, and handles image uploads. The tool processes properties defined in a single cell using separators. Automated import can be configured via FTP or email on a schedule.

The module supports mass creation of product properties. It enables loading files from external cloud storage services, including Yandex.Disk, Google Drive, Mail.ru Cloud, and Dropbox. An extended mode for managing prices during import is available. The system supports importing product sets and bundles. Automatic import scheduling via cron is supported. Catalog backup and restoration capabilities are implemented using export and import mechanisms. Operation statistics are recorded to allow reverting import results if necessary. Import files can be loaded via authorized links with authentication checks.

The module enables importing product catalogs into 1C-Bitrix from Excel files. Supported formats include XLS, XLSX, XLSM, and CSV. Users can create a dedicated upload profile for each file, allowing previously configured parameters to be reused when updating data. The tool supports loading one or multiple Excel sheets into one or several information blocks and sections. It features flexible mapping between file fields and information block properties. Images and files can be imported from both local and remote servers. Image processing respects information block settings, including resizing, watermarking, and generating previews from detailed images. The functionality covers price updates from price lists with currency specification and stock level synchronization with multi-warehouse support. Catalog data is exported to an arbitrary section hierarchy with automatic creation of missing nodes. Periodic uploads can be scheduled via cron based on profile settings.

The module enables importing the 1C-Bitrix product catalog from Excel files with advanced data management capabilities. It supports filtering elements by any field, allowing the import of products from specific manufacturers only. The system handles properties of the 'Reference' type and generates product offers (SKU) based on any set of properties.

Products missing from the uploaded file are automatically deactivated, and empty sections are removed after the import process. A flexible price rounding mechanism is available, along with the ability to import discounts and support for custom section properties. Data can be imported into highload blocks, and bulk image uploads to the server directory are supported.

Key use cases include adding and updating products from supplier files, synchronizing prices and stock levels, mass modification of product properties and images, and generating product offers based on imported data.

This module is designed to import product catalog data from Excel files into the 1C-Bitrix content management system. For importing data from XML or YML formats, specialized tools are recommended. If importing elements or sections results in changed page URLs, use a separate solution for managing automatic redirects.

When needed, General iT can implement “Import from Excel. Loading the 1C-Bitrix product catalog”, configure the module and verify it against the current website setup.