Automating Alcohol Accounting: 1C-Bitrix & EGAIS Integration

Our company is engaged in the development, support and maintenance of Bitrix and Bitrix24 solutions of any complexity. From simple one-page sites to complex online stores, CRM systems with 1C and telephony integration. The experience of developers is confirmed by certificates from the vendor.
Showing 1 of 1All 1626 services
Automating Alcohol Accounting: 1C-Bitrix & EGAIS Integration
Medium
~1-2 weeks
Frequently Asked Questions

Our competencies:

Development stages

Latest works

  • image_website-b2b-advance_0.webp
    B2B ADVANCE company website development
    1361
  • image_bitrix-bitrix-24-1c_fixper_448_0.webp
    Website development for FIXPER company
    948
  • image_bitrix-bitrix-24-1c_development_of_an_online_appointment_booking_widget_for_a_medical_center_594_0.webp
    Development based on Bitrix, Bitrix24, 1C for the company Development of an Online Appointment Booking Widget for a Medical Center
    695
  • image_bitrix-bitrix-24-1c_mirsanbel_458_0.webp
    Development based on 1C Enterprise for MIRSANBEL
    834
  • image_crm_dolbimby_434_0.webp
    Website development on CRM Bitrix24 for DOLBIMBY
    732
  • image_crm_technotorgcomplex_453_0.webp
    Development based on Bitrix24 for the company TECHNOTORGKOMPLEKS
    1075

Integrating 1C-Bitrix with EGAIS: Setup, Cases, and Timelines

An alcohol write-off error in EGAIS is a common cause of license suspension for online stores. Every unrecorded sale risks a fine of up to 300,000 RUB. We specialize in end-to-end integration of 1C-Bitrix with EGAIS: we automate data transmission for sales, returns, and stock balances. We guarantee every transaction is logged—eliminating fines. In our practice, we have completed over 50 projects for alcohol online stores.

EGAIS is the federal system for alcohol accounting. An online store selling alcohol remotely must record every sale. 1C-Bitrix must interact with EGAIS through the Universal Transport Module (UTM)—local software that encrypts and signs requests to EGAIS.

Manual alcohol write-offs take up to 2 hours per day and are prone to errors. With an operator salary of 1,000 RUB/hour, that's 60,000 RUB in monthly extra costs. Automation pays off in 1-2 months by eliminating fines and saving time.

What Is UTM and Why Do You Need It?

UTM—Universal Transport Module, developed by Rosalkogolregulirovanie. It is a local Windows or Linux application that receives XML requests from the site, encrypts them with a JaCarta crypto key, and sends them to EGAIS. UTM receives responses asynchronously and places them in a queue for retrieval. Without UTM, direct integration with EGAIS is impossible.

Integration Architecture

EGAIS does not provide a cloud REST API. Interaction is only through UTM installed on a local server. UTM receives XML requests on port 8080 and returns responses via a queue.

1C-Bitrix → XML request → UTM (localhost:8080)
                             ↓
                           EGAIS (Rosalkogolregulirovanie)
                             ↓
UTM generates response → Bitrix polls response queue

The scheme is asynchronous: the request is sent—the response comes in seconds or minutes.

XML Structure for Write-Off Request

<!-- TTNQuery — request for write-off upon sale -->
<?xml version="1.0" encoding="utf-8"?>
<ns:Documents xmlns:ns="urn:TNInformF2Reg:Documents"
             xmlns:oref="urn:TNInformF2:OrgInfo"
             version="2">
  <ns:Document>
    <ns:TTNInformF2Reg>
      <ns:Header>
        <ns:IsSSMark>0</ns:IsSSMark>
      </ns:Header>
      <ns:Content>
        <ns:Position>
          <ns:Identity>1</ns:Identity>
          <ns:ProductCode>0366700000002375890</ns:ProductCode>
          <ns:Quantity>1.000</ns:Quantity>
          <ns:InformF1RegId>TEST-TTN123456</ns:InformF1RegId>
          <ns:InformF2RegId>TEST-F2-123456</ns:InformF2RegId>
        </ns:Position>
      </ns:Content>
    </ns:TTNInformF2Reg>
  </ns:Document>
</ns:Documents>

PHP Client for UTM Interaction

class EgaisUtmClient
{
    private string $utmUrl;
    private string $orgRarId; // organization identifier in EGAIS

    public function __construct(string $utmUrl, string $orgRarId)
    {
        $this->utmUrl   = $utmUrl; // http://localhost:8080
        $this->orgRarId = $orgRarId;
    }

    public function sendDocument(string $xmlDocument): string
    {
        $response = file_get_contents(
            $this->utmUrl . '/opt/in/TTNInformF2Reg',
            false,
            stream_context_create([
                'http' => [
                    'method'  => 'POST',
                    'header'  => 'Content-Type: application/xml',
                    'content' => $xmlDocument,
                ]
            ])
        );

        $replyXml = simplexml_load_string($response);
        return (string)$replyXml->ReplyId;
    }

    public function getReplyQueue(): array
    {
        $response = file_get_contents($this->utmUrl . '/opt/out');
        return $this->parseQueue($response);
    }

    public function getReply(string $replyId): ?array
    {
        $response = file_get_contents(
            $this->utmUrl . "/opt/out/TTNInformF2Reg/{$replyId}"
        );
        if (!$response) return null;

        $xml = simplexml_load_string($response);
        return [
            'result'  => (string)$xml->Result->Conclusion,
            'comment' => (string)$xml->Result->ConclusionDate,
            'egais_id' => (string)$xml->Result->AccisesHeader->EGAISQuntId,
        ];
    }
}

Order Processing in Bitrix

// Event handler for order status change
\Bitrix\Main\EventManager::getInstance()->addEventHandler(
    'sale', 'OnSaleStatusOrderChange',
    function (\Bitrix\Main\Event $event) {
        $order    = $event->getParameter('ENTITY');
        $statusId = $event->getParameter('VALUE');

        if ($statusId !== 'shipped') return; // send only on "Shipped" status

        $egaisItems = $this->getAlcoholItemsFromOrder($order);
        if (empty($egaisItems)) return;

        $client  = new EgaisUtmClient(EGAIS_UTM_URL, EGAIS_ORG_RAR_ID);
        $xml     = $this->buildActWriteOff($order, $egaisItems);
        $replyId = $client->sendDocument($xml);

        // Save replyId for tracking
        EgaisDocumentTable::add([
            'ORDER_ID'  => $order->getId(),
            'REPLY_ID'  => $replyId,
            'STATUS'    => 'pending',
            'SENT_AT'   => new \Bitrix\Main\Type\DateTime(),
        ]);
    }
);

How to Avoid Errors in EGAIS Exchange? A Case from Our Practice

From our practice: an online liquor store, ~300 orders per day. Daily task—write off each sold unit of alcohol in EGAIS. If a write-off fails, the order cannot be legally considered closed.

Project challenges:

  1. UTM was installed on a office Windows PC; the site was on a hosting. No direct network access.

  2. Sometimes UTM was unresponsive (reboots, updates), documents got lost.

  3. EGAIS returns AlcoCode—a unique code for each bottle (for labeled alcohol); we needed to store the correspondence AlcoCode ↔ order item.

Solutions:

  1. VPN tunnel between hosting and office server + middleware on the office server that receives requests from Bitrix and forwards to UTM. Middleware in Node.js, runs as a Windows service.

  2. Task queue on Bitrix side: unconfirmed documents are re-sent after 10 minutes (up to 5 attempts). If exhausted, admin notified.

  3. Upon receiving confirmation from EGAIS, we save EGAISQuntId in a table local_egais_alcocodes, linked to the Bitrix order item.

Metric Before Integration After
Manual operations in EGAIS ~2 hours/day 0 (only monitoring)
Write-off delay from shipment 1–3 hours < 15 minutes
Missed write-offs 3–5%/month < 0.1%

Automated integration is 10 times faster than manual data entry and eliminates fines of up to 300,000 RUB for each unrecorded write-off.

Returns in EGAIS

When alcohol is returned, the reverse operation—adding to stock—is done via a WayBillAct document. Triggered by the return event in Bitrix (OnSaleRefund).

EGAIS Stock in Bitrix

For syncing warehouse stock with EGAIS data, we periodically query UTM (RestBal) and compare with stock in the Bitrix catalog. Discrepancies are logged for review.

What’s Included in the Work

  • UTM setup, EGAIS key acquisition (through Rosalkogolregulirovanie)
  • Network connection: VPN or middleware service
  • PHP client for UTM: document sending, response polling
  • XML generation for write-off and return acts
  • Bitrix event handlers: shipment, return
  • Queue with retries, error monitoring
  • EGAIS document history table in Bitrix
  • Admin training, 3 months of support

Comparison of manual vs. automated approach:

Criteria Manual Entry Automated Integration
Time per operation 10–15 minutes < 1 second
Error risk high ≈ 0%
Daily time spent up to 2 hours 5 minutes (monitoring)

Common setup mistakes:

  • No persistent network connection to UTM—documents never reach EGAIS.
  • Incorrect certificates—EGAIS rejects requests.
  • Missing order status triggers—write-off does not initiate.
  • No response queue processing—confirmations are lost.

Why Trust Our Engineers with Integration?

Our certified specialists have years of experience. We've completed over 50 projects for alcohol online stores. We provide a warranty on all work and training for your team. Request an audit of your infrastructure—we’ll assess the project and give you a timeline.

Timelines: with a ready UTM and network access—4–6 weeks. If infrastructure setup is needed—8–12 weeks. The cost is determined individually. Get a consultation with an engineer today.

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.

Criterion CommerceML (Standard) Custom REST (JSON)
Speed on 100,000+ SKUs Low (full XML) High (incremental JSON)
Schema flexibility Fixed Arbitrary
Expansion capability Limited Unlimited
Ease of debugging 1C log HTTP request logs, Postman

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.
Typical exchange settings for a catalog of 50,000 SKUsBatch mode: 500 elements per step. Binding by article. Sync period: every 15 minutes. Use Bitrix agents with tagged caching. On 1C side, JSON generation processing instead of XML to speed up.

Timelines and What's Included

Stage Description Estimated Duration
Analysis Audit of 1C configuration, exchange structure, current issues 1–2 days
Schema Design Agree on data set (products, prices, orders) and architecture 2–5 days
Standard Exchange Setup Configure CommerceML, batch mode, binding by article 1–2 weeks
Extended Integration Custom REST, multi-warehouse, multiple prices, partial shipment 2–4 weeks
Full Custom Integration 1C + site + Bitrix24, async queues, monitoring 1–2 months

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.