Efficient CSV Exchange in 1C-Bitrix: Import, Export & Automation Setup

Standard CSV import in 1C-Bitrix breaks on three things: wrong encoding, mismatched delimiters, and missing property mapping. A manager uploads a file, gets "Import completed, 0 items processed" — and writes to support. We configure CSV import and export so that exchange works predictably. The result is a reliable process: from diagnostics to automation. For stores with up to 5,000 products, import takes 1–3 minutes; for 50,000 products, up to 30 minutes with proper cron setup. Using step-by-step mode, you process data without timeouts, and cron automation saves up to 15 hours monthly on manual uploads — at $20/hour, that's $300 savings per month.

Mechanics of CSV Import in the Catalog

The catalog module has a built-in CSV handler — class \Bitrix\Catalog\CsvImport, which implements the StepByStep interface to handle large datasets. Import is available through the admin interface: Store → Settings → Import CSV. But it's important to understand what's under the hood.

Bitrix reads the file line by line, splitting by delimiter (default semicolon). The first line can be a header if the "First line contains field names" option is enabled. Then each line maps to infoblock fields: NAME, XML_ID, DETAIL_TEXT, properties like PROPERTY_ARTICLE, prices CATALOG_PRICE_1.

Critical Settings

• File encoding — Bitrix expects UTF-8. If the file is Windows-1251 (typical for 1C exports), enable recoding or convert the file beforehand. About 80% of CSV import problems are encoding-related.
• Field delimiter — semicolon, comma, or tab. If data contains semicolons (product descriptions), use tab.
• XML_ID — unique element identifier. Without it, import creates duplicates on each run instead of updating existing records. Approximately 90% of duplicate issues stem from missing XML_ID mapping.

Field and Property Mapping

The most common error is mismatch between CSV headers and infoblock property codes. Bitrix looks for an exact match: if the property is called BRAND and the CSV header is brand, mapping won't work.

For list-type properties, the CSV should contain the value, not the variant's XML_ID. Bitrix tries to find a match by value and link the element. If no value is found, the property remains empty with no log error.

For element-link properties, pass the ID of the linked element or its XML_ID (if the "search by XML_ID" option is enabled).

How to Set Up CSV Export?

Export is configured in Store → Data Export. The export profile is saved in the b_catalog_export table and can be run via cron through the agent \Bitrix\Catalog\CatalogExportAgent::exportCsv.

When exporting large catalogs (over 50,000 products), the standard mechanism works stepwise — 500 elements per iteration. The step size is set in the profile settings. If export stops midway, increase max_execution_time in PHP or reduce the step size.

The export format is fixed: UTF-8, delimiter from profile settings. For integration with external systems expecting Windows-1251, add post-processing via iconv in the cron script.

Product Duplicates: Root Causes

Duplicates are the result of missing a unique identifier. Always fill the XML_ID column and enable search by it. If the source has no ready-made XML_IDs, generate them using a formula: article + manufacturer. This is the only reliable way to ensure repeated import updates existing records.

Property Mapping: Common Mistakes

The reason is column name mismatch. Bitrix looks for an exact match: PROPERTY_<CODE>. If the CSV has Бренд and the property code is BRAND, mapping won't happen. Solution: either rename columns in the CSV, or use an intermediate script to transform headers.

Automation via Cron

Manual import through the admin panel is acceptable for one-time uploads. For regular updates (daily stock/price synchronization), use cron launch. Import via admin panel is 10 times slower than via cron for catalogs over 50,000 products. Additionally, direct SQL import can be up to 5 times faster than the API-based CSV import for catalogs exceeding 50,000 products.

/usr/bin/php -f /home/bitrix/www/bitrix/modules/catalog/load/csv_run.php

Import profile parameters are passed via the saved profile ID. The profile is created in the admin panel, tested manually, then its ID is placed in cron.

On one project with a catalog of 20,000 products, the client imported a price list every day. After setting up a profile with article search and step-by-step mode, import time dropped from 3 hours to 10 minutes.

Typical Pitfalls

• Product duplicates — always fill XML_ID and enable search by it. Without this, each import run creates new elements.
• Lost images — CSV import does not support file uploads. For images, use a path to the file on the server in the DETAIL_PICTURE column — Bitrix will pick up the file by absolute path.
• SEO fields reset — if the CSV lacks META_TITLE, META_DESCRIPTION columns, import may reset them on update. Enable the "Do not update empty fields" option.

What's Included in the Work?

1. Audit of current CSV exchange (encoding, structure, profiles).
2. Configuration of field and property mapping for the infoblock.
3. Creation of import/export profile considering data volumes.
4. Performance optimization (step-by-step mode, cron).
5. Documentation of settings and staff training.
6. Post-release support (bug fixes, fine-tuning).

Our team has 10+ years of experience in Bitrix development and has completed over 200 CSV exchange integration projects. This experience guarantees correct exchange operation. If you have questions about setting up CSV import or export, contact us — we'll assess your project and offer a solution. Get a consultation right now.

For more on CSV format, see Wikipedia.

CommerceML: Why Standard Exchange Is Both a Lifesaver and a Trap

Standard exchange via CommerceML 2.0 on typical "Trade Management" or "Comprehensive Automation" can be set up in a day or two. Products, prices, stock, orders—all via XML files on a schedule. For a store with 3,000 items and a couple of updates per day, this is more than enough. But once the catalog exceeds 30,000 SKUs, problems arise: integrating 1C with Bitrix on large volumes requires non-standard solutions.

Why does CommerceML slow down with catalogs over 100,000 items?

bitrix_1c_exchange.php generates XML on the Bitrix side, and 1C retrieves and parses it. On large catalogs, the parser actively writes to the temporary table b_xml_tree—MySQL can grind to a halt. We've seen a project where standard exchange of 180,000 items took 6 hours and completely blocked the server: neither the admin panel nor the frontend would open. The solution is incremental exchange. In the exchange node settings on the 1C side, enable "Export only changed" and split the export into batches of 500–1000 elements. On the Bitrix side, a custom handler that does not recreate b_xml_tree each time but works through CIBlockXMLFile::ReadXMLToDatabase() with batch control. A catalog of 200,000 SKUs updates in 8–12 minutes.

Another pitfall is EXTERNAL_ID. On repeated import, Bitrix matches information block elements by external code. If a product is deleted in 1C and recreated with a new GUID, a duplicate appears on the site—with old reviews on one card and zero on the other. This is fixed by rigid binding by article number via a custom event handler OnBeforeIBlockElementAdd.

How to avoid duplicates during repeated import?

We bind products not by GUID but by article number. Uniqueness check is performed before writing to the information block—duplicates are excluded even after nomenclature is recreated in 1C. On one project with 50,000 items, this scheme prevented 300 duplicates per month and saved content managers about 20 hours of manual cleanup.

Custom 1C Configurations: When CommerceML Falls Short

"We have a standard configuration"—says every second client, and then we open the database and see 200 custom processing routines, renamed attributes, and custom sales documents. CommerceML works with a fixed XML structure. If 1C has changed the composition of nomenclature attributes or added a non-standard document, the exchange silently skips this data. Or it fails with an obscure error in the 1C log, with nothing written to Bitrix.

In such cases, we implement custom export. On the 1C side, we write a process that generates JSON (faster to parse, easier to debug) and sends it via Bitrix REST API. Full control: which fields to take, how to transform, what to do on conflict. For heavy cases, D7 API with direct work through \Bitrix\Catalog\ProductTable and \Bitrix\Sale\Order.

What are the key steps to set up 1C integration?

Custom REST is justified when:

• Non-standard nomenclature attributes;
• Multiple price types (retail, wholesale, dealer, promotional, regional, currency)—standard exchange sends only one type;
• Multi-warehouse with different stock levels and need to select a warehouse on the site.

Prices, Stock, and Multi-Warehouse

Standard exchange can transfer one price type. In reality, there may be 15: each with its own buyer group and priority. Mapping between 1C price groups and Bitrix user groups is a separate engineering challenge. Especially when discounts overlap and you need to determine which price wins.

Multi-warehouse adds another layer: product is in stock in Moscow, out of stock in St. Petersburg, and "on order" in Novosibirsk. The site must show availability per location, allow selection of pickup points, and calculate shipping from the nearest warehouse where the product is physically available. The standard Bitrix warehouse module (catalog.store) handles display, but we write the "which warehouse to ship from" logic separately. For one manufacturing holding, we implemented a custom stock aggregator that calculated balance across 8 warehouses in 2 seconds—reducing shipping errors by 80%.

Orders and Document Flow

An order from the site goes to 1C, a sales document is created, goods are reserved. Statuses come back. The main nuance is partial shipment: the client ordered 5 items, 3 are in stock, 2 will arrive in a week. 1C creates two sales documents. Bitrix out of the box cannot split one order into several shipments—we extend the OnSaleOrderSaved handler to create child orders and synchronize statuses for each.

Documents in the personal account—invoices, acts, waybills from 1C—are served via REST; PDF is generated on the 1C side and cached on CDN. The buyer downloads not from 1C directly (that would kill the server) but from cache.

Batch import with portion control reduces MySQL load and prevents locks (source: Wikipedia).

Monitoring: Not "Set and Forget"

Exchange can silently break: the script ran, no errors in log, but 200 products didn't update due to invalid UTF-8 in the name. Or 1C changed the date format in an update—all prices came in as zero.

Minimum set we install on every project:

• Telegram alert if exchange time increases 3+ times from average.
• Stock discrepancy check: script compares b_catalog_product.QUANTITY with what 1C provides, and alerts when delta exceeds 5%.
• Dashboard: last sync, number of processed items, queue, errors.

For high-load projects, we add async queues on Redis or RabbitMQ. Exchange does not block the web server, data is not lost during temporary 1C outages. On one online store with 2 million orders per year, we implemented this scheme—recovery time after failures dropped from 3 hours to 10 minutes.

Linking with Bitrix24 for Document Flow Automation

If besides the site there is a corporate portal on Bitrix24, we link it too. Counterparties from CRM go to 1C, invoices from 1C appear in deal cards. The manager sees accounts receivable and mutual settlements without switching windows. Deal closed—documents generated automatically.

Payment received in 1C → logistician gets a task for shipment in Bitrix24. Goods shipped → manager sees notification. Automatic tasks based on events from 1C—via Bitrix24 REST API webhooks. This link reduces manual entry by 70% and eliminates forgotten shipments.

How We Set Up Integration: Step-by-Step Process

1. Audit of 1C Configuration. Review the structure of directories, documents, attributes. Identify custom modifications. Assess data volume (number of SKUs, orders, warehouses).
2. Design Exchange Schema. Agree on data set: products, prices, stock, orders, documents. Determine sync interval and mechanism—CommerceML or custom REST.
3. Configure Standard Exchange. Set up CommerceML, batch mode, binding by article. Verify data transfer correctness on a test catalog.
4. Extended Integration. For complex configurations, write custom handlers on both 1C and Bitrix sides. Incorporate multi-warehouse, multiple prices, partial shipment.
5. Monitoring and Warranty. Set up alerts, dashboard, documentation. Train operators. After launch, warranty support.

Timelines and What's Included

Work results include: documented exchange schema, configured synchronization scenarios, monitoring dashboard, operator training, and warranty support after launch. Pricing is calculated individually—it depends on the complexity of the 1C configuration, catalog size, and required automation level. We'll evaluate your project in 1 day—write to us, let's discuss. Order integration and get stable exchange in 1–2 weeks.

We have completed over 50 1C integrations for online stores and manufacturing companies. The team's average experience is 7 years, and we have certified 1C-Bitrix specialists. Our experience ensures that the exchange won't break in the first month and will run stably for years. For example, on a project with a catalog of 50,000 items, automation of exchange saved the client significant operational costs annually.

Contact us for a free audit of your 1C configuration—we'll find bottlenecks and offer the optimal solution.