Alexander Ruin

AI Systems Design Consultant

Alexander Ruin — systems design consultant. I help design architecture, assess risks, and establish transparent processes — from technology selection to support. AI executors handle routine tasks. Areas: automation, integrations, AI products.

Export Product Catalog from 1C 2026: How to Unload Items and Prices Without a Programmer

The product catalog is the core of accounting in 1C. It stores names, SKUs, barcodes, units of measurement, prices, and stock levels. Regular exports are needed: for updating price lists, uploading to marketplaces, sharing with suppliers, or migrating to another database. But standard 1C tools either produce inconvenient formats or require a programmer.

Key Facts

  • In 1C 8.3, the "Products" directory contains item name, SKU, unit of measurement, group, VAT rate, and custom attributes
  • The built-in "Output list" button only exports columns visible on screen — without prices or stock levels
  • To export with prices and stock, you need an external processing module or the "Price List" report
  • Export formats: Excel (xlsx), CSV, XML (CommerceML, YML for Yandex.Market), JSON
  • Automatic scheduled export via Synchron1C saves 2–4 hours per week on manual price list updates

How to Export the Product Catalog from 1C?

There are four methods. The choice depends on the format, data volume, and export frequency.

Method How It Works Pros Cons Cost
Output list Directories → Products → "Output list" → Save as xlsx Built into 1C, simple Only visible columns, no prices or stock Free
Price List report Sales → Price List → Generate → Save as xlsx Prices included, grouping Price type setup required, no stock data Free
External processing Load epf file → Configure fields → Export Flexible: any fields, filters, formats Programmer needed for development, one-time setup 5,000–30,000 ₽
Synchron1C Telegram bot exports catalog on command or schedule Automatic, any formats, notifications Subscription 5,000 ₽/month

How to Set Up Export in 3 Steps?

Exporting the product catalog from 1C 8.3 takes 15 minutes — even without experience with processing modules.

Step 1. Open the Product Directory

In 1C 8.3, go to "Directories" → "Products." If you need a specific product group, open the relevant folder. Make sure all columns are displayed: Name, SKU, Unit of Measurement, VAT Rate. To add columns, click "More" → "Edit form."

Step 2. Export in the Required Format

For Excel: click "More" → "Output list" → check the required columns → "OK." A spreadsheet document will open. Click "File" → "Save as" → select "Excel Sheet (.xlsx)."

For a price list with prices: go to "Sales" → "Reports" → "Price List." Select the price type (wholesale, retail) and product group. Click "Generate" → "Save as."

Step 3. Automate with Synchron1C

To avoid performing the export manually each time, connect Synchron1C. The bot exports the product catalog with prices and stock on schedule in Excel, CSV, or XML. The ready file arrives in Telegram or is sent to email, FTP, or Google Sheets.

Export product catalog from 1C via Synchron1C Telegram bot

Synchron1C Telegram bot — automatic product catalog export from 1C

What Data Can Be Exported Along with the Product Catalog?

Data Standard Export Via Processing Via Synchron1C
Name, SKU, unit Yes Yes Yes
Barcodes No Yes Yes
Prices (all types) Only via Price List Yes Yes
Stock by warehouse No Yes Yes
Product characteristics No Yes Yes
Product images No Yes (programmer) Yes
Groups and hierarchy Partially Yes Yes

See Also

Frequently Asked Questions

How to export the product catalog from 1C to Excel with prices?

Open the "Price List" report in "Sales" → "Reports." Select the price type and product group, click "Generate." Save the result via "File" → "Save as" → "Excel Sheet (.xlsx)." With Synchron1C — send a command to the bot, and the file with prices arrives in Telegram.

Can I export the product catalog from 1C Accounting 3.0?

Yes. In 1C Accounting 3.0, the product directory is located in "Directories" → "Products." The "Output list" button works the same across all configurations: Accounting 3.0, Trade Management 11, ERP 2, Complex Automation 2.

What format is best for exporting the catalog to a marketplace?

For Ozon and Wildberries — Excel (xlsx) or CSV. For Yandex.Market — YML (XML). For universal integration — JSON via API. Synchron1C supports all formats and can export directly to the marketplace via API.

How to export only a specific product group?

Open the desired folder in the product directory before exporting. When using a processing module — specify a group filter. In Synchron1C — set up a filter in the Telegram bot: by group, warehouse, supplier, or any attribute.

Stop wasting time on manual price list and catalog exports.

Synchron1C automates product catalog export from 1C in 2026 — setup in 15 minutes, no programmer needed.

Two payment options: - 5,000 ₽/month — subscription, free setup + all updates - 30,000 ₽ — one-time payment, setup + updates for a year

Connect automatic catalog export →

Learn more about capabilities on the Synchron1C page.

Article prepared by the Synchron1C team. Updated: February 2026.

Sources: - https://scloud.ru/ask_question/rabota-so-spravochnikami/kak-vygruzit-nomenklaturu-iz-bazy-1s-bp-3-0-v-excel/ - https://portkkm.ru/overview/kak-vygruzit-nomenklaturu-iz-1s-upravlenie-torgovley-ut-v-excel/ - https://www.coderstar.ru/obrabotki/vygruzka-nomenklatury - https://www.helpexcel.pro/vygruzka-dannyh-iz-1s-v-excel - https://www.cleverence.ru/articles/elektronnaya-kommertsiya/kak-vygruzhat-dannye-iz-1s-v-excel-kak-pravilno-perenesti-i-skopirovat-dokumenty-fayly/

About the service "Sync1C - 1C Automation Without a Programmer"

A universal solution for automating export, import, integrations, and monitoring of 1C through a simple dialog in Telegram. Set up in 15 minutes without involving a 1C programmer.

Key Benefits:

  • 💰 Savings on analysts and 1C programmers (from1,000 USDT/month)
  • ⚡ Automated Reporting – from 4 hours down to 5 minutes
  • 🧠 AI detects anomalies and trends that a human might miss.
  • 📊 Dashboards are available in real-time via Telegram or web
  • 🔄 Universal integration - set it up once, works with all systems.
  • 📱 Control from anywhere in the world via Telegram
  • 🎯 This is a custom development tailored to your needs.
  • 📞 Free consultation on integration

Target Audience:

Director of Digital Development Chief Financial Officers (CFOs) Heads of IT departments Heads of Analytics Departments Business owners (small/medium-sized businesses) 1C integrators and implementers

Use Cases:

💡 Daily automatic export of sales to Excel
💡 Real-time stock synchronization with Ozon and Wildberries
💡 Auto-upload of bank statements from Sberbank/VTB into 1C
💡 Receiving notifications about 1C errors and failures in Telegram
💡 Import orders from marketplaces into 1C automatically
💡 Exchange of UPD (Universal Transfer Document) via Sbis/Diadoc without manual work
💡 Fiscalization of receipts through Atol/Evotor from 1C
💡 AI Analysis of Sales and Inventory with Anomaly Detection
💡 Real-time sales/financial dashboards in Telegram
💡 Accounts Receivable Control via Telegram Bot
💡 Importing supplier price lists from Excel into 1C