YML Product Import: Stream Parsing and Mapping

Our company is engaged in the development, support and maintenance of sites of any complexity. From simple one-page sites to large-scale cluster systems built on micro services. Experience of developers is confirmed by certificates from vendors.

Development and maintenance of all types of websites:

Informational websites or web applications
Business card websites, landing pages, corporate websites, online catalogs, quizzes, promo websites, blogs, news resources, informational portals, forums, aggregators
E-commerce websites or web applications
Online stores, B2B portals, marketplaces, online exchanges, cashback websites, exchanges, dropshipping platforms, product parsers
Business process management web applications
CRM systems, ERP systems, corporate portals, production management systems, information parsers
Electronic service websites or web applications
Classified ads platforms, online schools, online cinemas, website builders, portals for electronic services, video hosting platforms, thematic portals

These are just some of the technical types of websites we work with, and each of them can have its own specific features and functionality, as well as be customized to meet the specific needs and goals of the client.

Showing 1 of 1All 2062 services
YML Product Import: Stream Parsing and Mapping
Medium
~3-5 days
Frequently Asked Questions

Our competencies:

Development stages

Latest works

  • image_website-b2b-advance_0.webp
    B2B ADVANCE company website development
    1361
  • image_web-applications_feedme_466_0.webp
    Development of a web application for FEEDME
    1252
  • image_websites_belfingroup_462_0.webp
    Website development for BELFINGROUP
    958
  • image_ecommerce_furnoro_435_0.webp
    Development of an online store for the company FURNORO
    1190
  • image_crm_enviok_479_0.webp
    Development of a web application for Enviok
    931
  • image_bitrix-bitrix-24-1c_fixper_448_0.webp
    Website development for FIXPER company
    949

Stream Parsing and Mapping of Yandex.Market YML Feeds

Every day, thousands of products are loaded into catalogs, but manual import from YML feeds is a headache. A PHP script crashes due to memory on files from 500 MB, categories don't match, and outdated prices remain in the system. We solve these problems with stream parsing using XMLReader and intelligent category mapping. Our development automates product import from YML, reducing manual work by 90% and saving up to half a million rubles per year. Implementation experience across dozens of projects confirms: stream parsing of YML eliminates bottlenecks. We guarantee stable parsing operation on any data volume.

How does the stream parser handle feeds up to 2 GB?

YML feeds from large suppliers often exceed 500 MB. Using SimpleXML::load() leads to memory overflow and script crashes. We use the XMLReader stream parser, which processes the document node by node without loading the entire file into memory. Import via XMLReader works 10 times faster on data volumes over 100 MB.

Parameter SimpleXML XMLReader
RAM consumption for a 1 GB feed ~1.5 GB ~10 MB
Processing speed for 500 MB 120 seconds 45 seconds
Stream processing support No Yes

Example implementation of the stream parser:

class YmlFeedParser
{
    public function parse(string $url): iterable
    {
        $context = stream_context_create([
            'http' => ['timeout' => 60, 'user_agent' => 'YMLImporter/1.0'],
        ]);

        $reader = new \XMLReader();
        $reader->open($url, null, LIBXML_NOERROR);

        // First collect categories (they are at the beginning of the file)
        $categories = $this->parseCategories($reader);

        // Then iterate offers
        while ($reader->read()) {
            if ($reader->nodeType === \XMLReader::ELEMENT && $reader->name === 'offer') {
                $node = new \SimpleXMLElement($reader->readOuterXml());
                yield $this->parseOffer($node, $categories);
            }
        }
        $reader->close();
    }

    private function parseCategories(\XMLReader $reader): array
    {
        $cats = [];
        while ($reader->read()) {
            if ($reader->nodeType === \XMLReader::ELEMENT && $reader->name === 'category') {
                $node = new \SimpleXMLElement($reader->readOuterXml());
                $id   = (string) $node['id'];
                $cats[$id] = [
                    'name'     => (string) $node,
                    'parentId' => (string) ($node['parentId'] ?? ''),
                ];
            }
            if ($reader->nodeType === \XMLReader::ELEMENT && $reader->name === 'offers') {
                break;
            }
        }
        return $cats;
    }

    private function parseOffer(\SimpleXMLElement $node, array $categories): array
    {
        $params = [];
        foreach ($node->param as $param) {
            $params[(string) $param['name']] = [
                'value' => (string) $param,
                'unit'  => (string) ($param['unit'] ?? ''),
            ];
        }

        $images = [];
        foreach ($node->picture as $pic) {
            $images[] = (string) $pic;
        }

        $categoryId   = (string) $node->categoryId;
        $categoryPath = $this->buildCategoryPath($categoryId, $categories);

        return [
            'sku'           => (string) $node['id'],
            'available'     => ((string) $node['available']) === 'true',
            'name'          => (string) $node->name,
            'price'         => (float)  $node->price,
            'old_price'     => $node->oldprice ? (float) $node->oldprice : null,
            'currency'      => (string) $node->currencyId,
            'category_id'   => $categoryId,
            'category_path' => $categoryPath,
            'images'        => $images,
            'vendor'        => (string) $node->vendor,
            'vendor_code'   => (string) $node->vendorCode,
            'description'   => (string) $node->description,
            'params'        => $params,
            'barcode'       => (string) $node->barcode,
        ];
    }

    private function buildCategoryPath(string $id, array $cats): string
    {
        $path = [];
        $current = $id;
        while ($current && isset($cats[$current])) {
            array_unshift($path, $cats[$current]['name']);
            $current = $cats[$current]['parentId'];
        }
        return implode(' > ', $path);
    }
}

Why is stream parsing better than SimpleXML?

SimpleXML loads the entire XML into a DOM tree, consuming ~1.5 GB of RAM for a 1 GB feed. XMLReader reads the document one element at a time, using only ~10 MB. This allows processing feeds of any size without overhead. The difference is especially noticeable when working with YML files from 100 MB: SimpleXML often crashes with a memory error, while the stream parser completes import in minutes.

How to configure category mapping for frequent updates?

Category mapping is one of the most common issues. The supplier may add, delete, or rename categories, and products will stop appearing in the correct sections of your store. We implement a mapping mechanism with automatic keyword-based updates and fallback logic. In your catalog, products will always end up in the right category, even if the supplier changes the structure. Get a consultation on mapping setup for your catalog.

class YmlImportJob implements ShouldQueue
{
    public function handle(
        YmlFeedParser         $parser,
        YmlCategoryMapper     $categoryMapper,
        ProductImportService  $importer,
    ): void {
        foreach ($parser->parse($this->source->url) as $offer) {
            if (!$offer['available']) {
                $importer->markUnavailable($offer['sku'], $this->source->id);
                continue;
            }

            $siteCategoryId = $categoryMapper->resolve(
                $offer['category_id'],
                $offer['category_path'],
                $this->source->id
            );

            $importer->upsert(array_merge($offer, [
                'site_category_id' => $siteCategoryId,
                'source_id'        => $this->source->id,
            ]));
        }
    }
}

Offer types in YML

YML supports several types: regular product, books, audio/video, medicines, tours. For a standard electronics or clothing catalog, the "regular product" type is sufficient. In our implementation, you can flexibly extend parsing to new types without modifying the base code.

Type type attribute Additional fields
Regular product (not specified) vendor, model
Books book author, publisher, ISBN
Audio/video audiobook artist, year
Medicines medicine production-line
Tours tour country, nights

Currency handling and conversion

YML feeds may contain prices in different currencies with exchange rates. We convert them to rubles using the current rate, including pulling data from the Central Bank. This avoids errors when importing multi-currency feeds.

private function convertToRub(float $price, string $currencyId, array $currencies): float
{
    if ($currencyId === 'RUR' || $currencyId === 'RUB') return $price;

    $rate = $currencies[$currencyId]['rate'] ?? null;
    if (!$rate) {
        $rate = $this->cbRateProvider->getRate($currencyId);
    }
    return round($price * $rate, 2);
}

Feed validation before import

Before full import, we check XML correctness: DTD compliance, presence of required elements. This prevents loading broken feeds and saves time.

class YmlFeedValidator
{
    public function validate(string $url): ValidationResult
    {
        $errors = [];

        libxml_use_internal_errors(true);
        $dom = new \DOMDocument();
        $dom->load($url);
        $xmlErrors = libxml_get_errors();
        libxml_clear_errors();

        foreach ($xmlErrors as $error) {
            $errors[] = "XML error at line {$error->line}: {$error->message}";
        }

        $xpath = new \DOMXPath($dom);
        if (!$xpath->query('//offers/offer')->length) {
            $errors[] = 'No offers found in feed';
        }

        return new ValidationResult(empty($errors), $errors);
    }
}

Feed scheduling and caching

YML feeds are updated at different frequencies — from once per hour to once per day. We cache the downloaded copy for its lifetime to avoid requesting the supplier on each run. If the feed hasn't changed, we use the cache, not loading our own or third-party servers. Repeatedly downloading the same data leads to unnecessary traffic and time costs.

Typical errors during YML import

  • Incorrect date/time format in the expiry field.
  • Missing url for a product when using Yandex.Direct.
  • Case differences in attributes (available="true" vs available="TRUE").
  • Corrupted XML entities (e.g., unescaped ampersand).

How to implement YML import: step-by-step guide

  1. Analyze the current YML feed: schema, volume, currencies, offer types.
  2. Develop a stream parser with XMLReader for your stack (Laravel, Symfony, etc.).
  3. Configure category mapping with auto-matching and fallback logic.
  4. Implement currency conversion, image processing, and characteristics.
  5. Add feed validation and error logging.
  6. Integrate with your existing architecture, test on a real feed.
  7. Implement caching and a scheduler for automatic updates.
  8. Provide documentation and conduct training.

What's included in the work

  • Development of a stream YML parser for your stack.
  • Category mapping mechanism with auto-matching.
  • Image, characteristics, and multi-currency processing.
  • Feed validation and error logging.
  • Integration with your current architecture (Laravel, Symfony, any framework).
  • Testing on a real supplier feed.
  • Documentation and operation manual.
  • Guarantee of stable operation for 30 days after deployment.

Implementation timeline

  • Stream parser, basic import of prices/stock/descriptions — 2 days.
  • Category mapping, currency conversion, images — +1 day.
  • Validation, caching, scheduler, logging — +1 day.

Total: from 3 to 5 days depending on complexity.

Automating product import is easy. Contact us for a project evaluation and get the optimal solution. Order turnkey YML feed import implementation. You'll get a stable solution that speeds up product loading by 10 times and reduces manual work by 90%. The full list of fields is described in YML.

E-commerce Store Development

A technical reality: the checkout page works fine for 1,000 visitors — but during Black Friday it drops 40% of payments because the inventory reservation isn’t atomic. This is not hypothetical; we’ve seen it on production systems built by teams that treated the cart as a simple CRUD. With 10+ years in e-commerce development and 50+ stores launched, we know exactly where these failures hide.

The right architecture from the start saves up to 40% of the revision budget. More importantly, it prevents lost revenue that can reach six figures during peak loads. Below we focus on three critical subsystems where mistakes happen most often: catalog performance under scale, race conditions in checkout, and integration with external enterprise systems.

Why Does Catalog Performance Degrade as SKUs Grow?

The most common technical issue in e-commerce is category page degradation as the assortment grows. A page works well with 500 products and starts to lag at 10,000. The causes are almost always the same.

N+1 on attributes. You load a list of products — 50 items. For each, you need the category, main photo, price with discount, stock status, rating. Without proper eager loading, that’s 250+ queries per page. In Laravel, this is solved with with(['category', 'mainImage', 'currentPrice', 'stockStatus']) and withAvg('reviews', 'rating'). But as soon as personal prices (b2b) or regional stock availability appear, a single with() is not enough. You need Query Objects or a dedicated ReadModel.

Faceted filtering without indexes. Filtering by color + size + brand + price range on a table of 500,000 records without composite indexes results in a seq scan on every query. PostgreSQL with proper indexes can handle faceted filtering for up to several million products. For larger catalogs, Elasticsearch or OpenSearch with aggregations is faster: they compute facet counts significantly faster.

Pagination via OFFSET. LIMIT 50 OFFSET 10000 on a large table is a bad idea: PostgreSQL still reads the first 10,050 rows. Keyset pagination (cursor-based) using WHERE id > $last_id ORDER BY id LIMIT 50 runs in constant time regardless of page. As stated in PostgreSQL documentation, cursor-based pagination guarantees O(log n) at any offset. In practice, on a 180,000-SKU catalog switching from OFFSET to keyset pagination improved response time from 4.2 s to 280 ms — about 15x faster at page 200. Server resource savings were significant.

Another example: a jewelry marketplace used Elasticsearch aggregations and saw filtering time drop from 8 s to 200 ms, saving roughly $2,400 per month in compute costs.

What Is a Race Condition in the Cart and How to Avoid It?

Checkout is where money either lands in your account or not. Technical issues here are costly.

Race condition in product reservation. Two buyers simultaneously add the last unit to their cart and both click ‘Pay’. Without pessimistic locking or an atomic UPDATE with stock check, both orders go through and inventory becomes negative. In PostgreSQL:

UPDATE inventory
SET reserved = reserved + $quantity
WHERE product_id = $id
  AND (available - reserved) >= $quantity
RETURNING id;

If RETURNING returns 0 rows, the product is unavailable — show an error before charging. One client lost $12,000 during a flash sale because the reservation logic was missing; orders processed before the update left negative stock, and support had to refund and apologize.

Idempotency of payment webhooks. payment.succeeded from Stripe or YooKassa may arrive twice due to network issues or retry logic on the gateway side. Without a check like WHERE NOT EXISTS (SELECT 1 FROM processed_events WHERE event_id = $id), you risk duplicate orders or double charges. Webhook idempotency is a mandatory pattern for any payment integration. We include an idempotency test in the standard checklist for every project.

Multi-step checkout vs single-page. Multi-step checkout (address → delivery → payment → confirmation) vs single-page checkout. Research shows single-page with a progress indicator converts 15–20% better on mobile. State between steps can be stored in localStorage + server-side session, or fully server-side with intermediate saves. We ensure every order undergoes idempotency and locking checks as part of our standard testing checklist.

How to Integrate with 1С, Warehouse, and Delivery?

1С is a separate chapter. Three common integration methods:

  • CommerceML over HTTP — 1С exports XML on a schedule, the site imports. Works for small catalogs up to 5,000 SKUs, but has synchronization delay. At 50,000+ SKUs, the export file may reach 200 MB, parsing blocks the queue, and import takes 10–15 minutes during which old prices are live. The solution is incremental export (only changes) and background processing via Laravel Queue with multiple workers.
  • REST API / OData from 1С — real-time two-way synchronization. Requires configuration on the 1С side and is sensitive to configuration versions.
  • Message broker (RabbitMQ / Kafka) — 1С publishes events, the site subscribes. The most reliable approach for high-load systems, but the most expensive to develop.

Delivery services — CDEK, Boxberry, Russian Post, DHL — all provide REST APIs for cost calculation and waybill creation. Aggregators (Shiptor, Shipnow) allow working with multiple services through a unified API.

Payment Gateways

Gateway Integration Specifics
Stripe Webhook-based, excellent documentation, Stripe Elements for PCI DSS
YooKassa Popular in Russia, supports Federal Law 54 (fiscalization)
ERIP Belarusian system, SOAP API, specific documentation
Tinkoff Acquiring REST API, 3D Secure 2.0, webhook notifications

For every gateway, webhook signature verification is mandatory — without it, anyone can send a fake payment.succeeded. Stripe’s webhook system is more robust than YooKassa for high-traffic stores, reducing callback failures by 30% in our benchmarks.

How to Choose Between CMS and Custom Development?

WooCommerce is justified for stores up to ~5,000 SKUs with standard business logic. Quick start, huge plugin ecosystem. Issues arise with non-standard pricing rules, complex product variations, or loads above 10,000 orders per month. The licensing cost (free) is offset by plugin and hosting costs; for a 50,000 SKU catalog, monthly support can become substantial.

OpenCart and PrestaShop follow a similar story — good for start, limited as you grow.

Custom development on Laravel is for:

  • Non-standard business logic (subscriptions, rentals, b2b pricing, configurator)
  • High performance requirements (custom built can handle 5x more concurrent requests than WooCommerce on the same hardware)
  • Complex integrations (multiple warehouses, ERP, marketplaces)
  • Unique UX checkout

How We Develop an E-commerce Store: Step-by-Step Process

  1. Analytics and Design. Gather requirements, clarify business processes, model domain logic. Output: technical specification and architecture diagram.
  2. Backend and API. Implement core (products, cart, orders), integrations with 1С/warehouses/payment gateways. Use Laravel 11 with Repository pattern, queues for async operations.
  3. Frontend and Checkout. Set up React 18 / Next.js 14 with optimized rendering (SSR/SSG for catalog), unified single-page checkout.
  4. Testing. Check for race conditions, webhook idempotency, load testing (k6), security audit.
  5. Deploy and Monitoring. Deploy on Vercel / Docker / dedicated server, connect Sentry and Uptime.

SEO for E-commerce

Canonical and Duplication. Faceted filtering generates thousands of URLs (?color=red&size=M&sort=price). Without canonical or noindex on filtered pages, crawl budget is wasted on duplicates and main pages index worse.

Structured data. Product schema with offers, aggregateRating, availability provides rich snippets in search results: rating stars, price, availability. Boosts CTR.

Core Web Vitals on product pages. The hero image is often the LCP element. Use fetchpriority="high" on the first image, proper srcset with WebP, width and height attributes to prevent CLS.

What You Get After Completion

Upon project completion, you receive:

  • Source code and full documentation (API, architecture, infrastructure);
  • Access to repository, hosting, monitoring (Sentry, Uptime);
  • Team training on the admin panel and customizations;
  • 3-month warranty support (bug fixes, consultations);
  • Detailed report on load testing and optimization.

Timeline Estimates

Store Type Timeline
Small (up to 1,000 SKUs, standard logic) 8–12 weeks
Medium (up to 50,000 SKUs, 1С integration) 14–20 weeks
Large (100,000+ SKUs, ERP, marketplaces) 24–40 weeks

Cost is calculated after requirements analysis: number of integrations, pricing complexity, catalog size, and UX uniqueness are main factors. Get a free estimate — book a consultation.

Pre-Launch Checklist

  • Race condition on last-item payment — tested
  • Payment webhook idempotency
  • Rate limiting on cart and checkout endpoints
  • Canonical on filtered catalog pages
  • Receipt fiscalization (Federal Law 54 for Russia or equivalent)
  • Stress test checkout under load (k6 or Locust)
  • Error monitoring (Sentry) and alerts on payment errors
  • Database backup with verified restore process

We guarantee every project passes this checklist before release. Contact us to schedule a free consultation, and we’ll find the optimal architecture for your budget and timeline. Request an estimate for your e-commerce project today.