You have developed an online store based on Bitrix. During development, you created all the necessary properties and filled the catalog with demo products.

It remains only to load the real catalog from 1C - this means that there is still a lot of work ahead. We will have to ensure that all the necessary data is unloaded in general and unloaded to the right place. Otherwise, you will have to adjust the project to the data structure from 1C.

The issue of integration is raised at every more or less large online store. It is often difficult for developers, not just beginners, to understand how the exchange mechanism works. Helpful information scattered across the Internet, it will be convenient to collect it in one place.

Objectives of the article

• Briefly outline the main possibilities of the exchange and its algorithm of work;
• Provide links to official and other useful sources;
• Answer frequently asked questions;
• Clarify where to start the integration and how to complete it successfully.

Standard exchange between 1C-Bitrix and 1C

Bitrix has a built-in functionality for exchange with 1C, due to which any exchange should be configured in a couple of clicks.
However, for this, 1C must be a "clean" typical configuration. In fact, every first 1C is "atypical", that is, modified in one way or another.

As such, the exchange is really set up quickly and easily, only often (almost always) the matter does not end there, since not all data is unloaded from 1C or is unloaded in the wrong place (including due to modifications in 1C).

What the standard exchange mechanism can do

• Import of a catalog of goods from 1C to the site;
• Export of the catalog of goods from the site to 1C;
• Export of orders from the site to 1C;
• Import of orders from 1C to the site;
• Import of reference books (highload-infoblocks) from 1C to the site.

Information about goods is transmitted to the site in the following files

• import.xml - goods, groups (information block sections), price types, warehouses, properties of goods and units of measurement;
• offers.xml - trade offers (TP) of goods and their properties;
• prices.xml - TP prices;
• rests.xml - remnants of TP;
• references.xml - custom references (HL infoblocks).

Files import.xml and offers.xml contain descriptions of properties, types of prices, and other information that applies equally to all goods / TP.

If the directory is large, for optimization purposes, descriptions are unloaded in separate “header” files. These are the same files import.xml and offers.xml, only they do not contain anything except descriptions. In this case, header files are processed only at the very beginning of the exchange.

Information about orders is transmitted to the site in the following files

• documents.xml - documents (orders);
• contragents.xml - contractors (users-buyers).

Where the upload files are uploaded to the site

To the / upload / 1c_catalog / folder. This folder is cleared before each exchange. That is, this folder always contains the files of the last exchange.

You can enable " "debug" exchange mode- disable overwriting of files in the 1c_catalog folder. Thus, you can disable the deletion of upload files after the exchange is complete.

To do this, you need to declare a constant in the dbconn.php file:

// Enables "debug mode" for exchange with 1C, // disables overwriting files in the 1c_catalog folder // To save all files after uploading. Define ("BX_CATALOG_IMPORT_1C_PRESERVE", true);

Now, instead of deleting the folder, the folder will be renamed, a numeric identifier will be added to it.

The higher the number of a folder, the newer that folder is.
However, the most new folder will always be without numbers, and only with the next exchange it will be renamed.

It is important to remember that disk space is consumed very quickly with debug mode enabled. Therefore, after debugging, you should turn off the log and delete all unnecessary exchange folders.

What you need to exchange on the site side

• Bitrix edition "Small Business" or "Business"
• create a user and group "Exchange with 1C" for exchange, set up rights
  • allow the group to unload goods / orders (in the parameters settings)
  • allow the group read access to the folder / bitrix / admin /

What you need to exchange on the 1C side

• configure the site address and site user from the "Exchange with 1C" group
• configure unloading parameters on the 1C side (depending on the UT version)

Directory structure in 1C and on the site

What to do if the structure of the catalog in 1C does not coincide with the structure on the site?

In 1C, you can set which products and sections to unload.

Often, in 1C, goods are stored differently from how they will be displayed on the site, so you can set up a virtual catalog on the 1C side for uploading to the site: create the desired structure of sections and arrange the goods on them.

You can also set the conditions for the selection of goods (not all goods are needed on the site) for uploading to the site and properties (in 1C there are many sv-in, not all are needed on the site).

Types of unloading from 1C

Complete unloading

Occurs when data is uploaded to the site for the first time, or when it is launched manually.

• All goods are unloaded.
• Pictures are uploaded only for new or changed products.

Brief unloading

Occurs often, between full, contains only changes in prices and balances.

Full forced unload

The same as full unloading, only pictures of absolutely all goods are unloaded, without fail.

Usually used only when debugging an exchange.

How to start integration with 1C

If you are making a new website and are planning to integrate with 1C in the future, then you should install Bitrix first and make a test exchange. Here's what it will do:

• The iblock type will be created;
• An iblock will be created;
• Holy Islands and reference books will be created;
• Catalog partitions will be created;
• Catalog items will be created;
• Trade offers will be generated.

All of this together will help you understand what data you already have and where to find it. It will be immediately clear what is missing and what is not unloaded at all as we would like.

How to complete the integration

Comparing the data structures on the site with the structure in 1C is the main goal of the integration.

To successfully complete the integration, when you already have a fully working project with up-to-date data, you need to ensure that the unloading from 1C takes place:

• To the existing infoblock;
• In existing sv-va;
• To the existing sections of the infoblock;
• Into existing products and trade offers;
• Into the existing types of prices.

All these tasks are solved by setting the same identifiers (XML_ID), that is, you must match all external codes on the site with external codes from 1C.

Unloading nomenclature in 1C

Store on the latest 8th version of ShopScript, and 1C 8.3 in the cloud. Integration is needed, so far the site is 1C in one direction. The main task at the moment is to unload the nomenclature of goods in 1C. Integration plugin installed, initial ...

Good afternoon, the global problem of unloading goods from 1C 11.1, checking the database showed that it is in excellent condition, unloading to the site takes from one hour to four or more. There are about 11 thousand goods, recently it has appeared in excess of the limit ...

Greetings, colleagues, I have the following problem, not all goods are unloaded from 1C, there was no such problem before, it arose during the last unloading, although the goods of month 4 were not unloaded before. The bottom line is that 3 new subcategories have been added to 1C, one...

Refinement of unloading of goods from 1c to the site

I will explain the essence of the problem with an example - we have an update with a product from 1c every weekday and we noticed such a jamb. today the goods in the supplier's price list are in stock, and the next day they removed it from the price list. the site was updated. but this position has remained so ...

There is an online store with a catalog of goods, the number of goods is about 15,000, each product has a list of its characteristics. A plus a large number of photos, files with instructions, etc. for each product. All data is stored in 1C, configured ...

Hello! Help solve the problem, synchronization of the store with 1C UNF is configured. We have a clothing store. Synchronization is proceeding correctly. But! The names of articles are unloaded from 1C UNF of the following type: When you need to unload just in the form ...

Tell me where to set up the upload of comments to the order, the orders themselves are unloaded, name, product, place where to lead, phone ... but there is no comment on the order.

Refinement of unloading of goods from 1c to the site.

It is necessary to configure it so that upon a subsequent update, a product that is no longer in stock (in any way, neither under the order, nor in a small quantity of a nomenclature item is not at all in the price list, which is unloaded from 1c) automatically goes into the hidden one.

Tell me how to solve the issue of unloading balances and prices in the context of warehouses, import from 1C does not work, maybe there are other solutions? Can create a separate showcase for each warehouse and unload its balances and prices in each of them, this option ...

Unloading goods from Shop Script 6 to 1C UT 10.3

Hello. We are trying to set up an exchange with 1C 10.3 in CommerceML format according to the instructions. The nomenclature is not loaded from the site in 1C. Processing in 1C is standard. How to arrange the export of goods in 1C?

Fix synchronization of goods with 1C

Hello, the problem is this: the online store is configured to automatically upload goods from 1C (our company) to the site, however, goods of different sizes or colors (these are parameters) appear in the Purchase Options as different SKUs. That is, Blouse ...

I use the plugin to synchronize products in 1c and in the store. I made the settings as indicated in the instructions. The goods are unloaded, the price is also, but the quantity is not. If you make a manual exchange, you can see that in xml file stock and quantity information is. What ...

+1

Hello, in February 2017, the topic of Uploading images to a site from 1C was raised .... I have 1C Retail, I also have problems uploading images, I also described my ...

+1 Not accepted

Error text: Interactive exchange 01/12/2017 15:27:22 Start of unloading of goods

unloading barcodes from 1s

Good afternoon, in 1c of each product modification (color size) a barcode is assigned. This barcode is uploaded along with a description of the modification when uploaded to the site in the offers.xls file:<Предложение>...

Hello. Is it possible for product categories to set aliases, or is it possible to automatically add one product to several groups when unloading from 1C (I found it only manually to do this in the admin panel)? For example, to understand what the essence of the task is - there is a category ...

Import of goods to CSV

Hello! It is necessary to correctly import the goods into shop-scropt 7 The old base is on 1s Bitrix, there is a programmer who has made the upload in the required format for the shop script in csv, but for some reason the description of the goods is not imported during import ...

After uploading any new product card to the appropriate category on the site, the order of characteristics on the CT page is lost. They dance in a random order. At the same time, changing the order in Settings - Types and characteristics of goods does not give ...

I did everything according to the instructions. But 1C hangs on "Waiting for the server to load data" by 83%. It slowly loads goods into SS5. But then, after loading all the goods, it just hangs and does nothing. And 1C "does not answer"

There was a question with the transfer of goods and orders to the 1C database through 1C (CommerceML). How exactly does the initial unloading take place, and how to generate the file necessary for the plugin to work?

Tell me how to properly export products that come in different sizes? For example, bracelets, there are 19 and 20 sizes. Unloading from the standard 1C plug-in gives us two products. How to combine them and give a choice of size?

In the nomenclature 1c added 5 new photos to the products. Executed an exchange with the site. From the 1c report, you can see that all the images were successfully uploaded, but they are not on the site either on the front-end or in the back-end. Expansion y photos jpeg, the resolution is just different ...

In order to upload products to the website of the online store, go to the "Site Nomenclature" section.

• if the products of the site's nomenclature have images, then check the box next to “Upload images”.
• the nomenclature can be unloaded at once on several showcases or on the showcase where they are currently located.
• See below for information on delayed unloading.

Note. In the settings of each storefront, it is possible to set security parameters. If you have several online storefronts, then setting the security parameters will allow you to upload goods to the very online storefront with which a secure connection is established.

Delayed unloading of site nomenclature

In the M-IT: Online store management module, the possibility of deferred unloading (according to schedule) of items on the online store website is implemented. This opportunity allows you to optimize the exchange of data between 1C and the Internet resource.

Delayed upload is intended for data exchange in case of unstable Internet connection. This decision provides for the implementation of any changes carried out in the subsystem for managing the site's nomenclature and online storefronts. In the event of a failure, a second attempt is made to transfer data.

Setting up 1C: Enterprise for uploading to the site. (For example, Trade Management 3.0)

In configuration "Trade Management 3.0" I have an opportunity data exchange with the site ( online store ) . Data exchange includes uploading items to the site and exchanging orders. In addition to the site settings for such an exchange, you must also make the settings in theconfiguration.

To do this, you must first enable the possibility of such an exchange. We select the "Administration" menu, on the left of the navigation panel, select the "Data exchange" section. Here you need to check the box "Data exchange with sites" FIG.1

FIG. 1... Sharing optionsprograms with a site .

After that, the list "Sites of exchange with sites" will become available. FIG. 1

Here you need to set the exchange rules for your site. Create a new record and fill in the fields FIG. 2

FIG. 2.Creation of an exchange node with a site.

It should be noted that it is more convenient to create different exchange nodes for unloading goods and exchanging orders, rather than specifying exchange parameters in one. For each node, it is necessary to define the data exchange mode: unloading of goods or exchange of orders FIG. 2.

We fill in the name that is understandable and convenient for us, which reflects the essence of the created node "Unloading the nomenclature".

The site address must be filled in as indicated in the example. Username and password: we enter the data of the user for whom administration rights are set on the site. Be sure to check the connection to the site.

Change control: when unloading for the first time, be sure to check the "Complete unload" checkbox. This is necessary in order for the site to receive information about all unloaded goods. During subsequent uploads, you can use the "Upload only changed objects" mode, which will significantly reduce the size of the uploaded information and the likelihood of errors, as well as increase the upload speed.

To periodically update the site, you can set the frequency of the exchange, that is, set the schedule according to which changes will be made FIG. 3.

FIG. 3 Setting the exchange frequency.

On the "Unloading goods" tab, set additional settings:

• organization;
• checkbox "Upload image files" - if the item contains photos that need to be uploaded to the site. It is advisable not to set the photo size large, as this increases the size of the upload file and slows down the exchange speed. Standard size 1200 * 900 pixels;
• checkbox "Upload other files" - if there are additional photos for the item, they will also be uploaded to the site.

In order for the product catalogs on the site to correspond to the item groups, you need to set the structure in the settings. FIG. 4

FIG. 4 Unloading of goods

In the "Item groups" field, select the desired group or list of groups. Each directory will have its own identifier on the site.

Next, we proceed to the selection for unloading. Clicking on the "Configure selection" button opens the selection form. FIG. 5. Selection can be set by different parameters, we will consider the most commonly used: leftovers and the nomenclature itself.

FIG. 5 Selection of items for uploading from 1C to the site.

You can set the selection by item and unload only certain types, item groups. And also it is necessary to set the threshold of the remainder, below which the data is not uploaded to the site. To do this, we will use the selection by residues (FIG. 5). Be sure to set the "Comparison type" Greater or equal or simply Greater than, but in no case not Equal, since only those residues that correspond to this remainder will be unloaded (for example, only with a remainder of 4 pieces).

It is also imperative to define a warehouse for leftovers: a warehouse for the remains of which the threshold will be checked upon unloading. You can specify a list of warehouses, not just one. In this case, the remainder will be the total quantity of one type of goods in these warehouses.

After the settings are completed, you need to save them and you can proceed to unloading. FIG. 6

FIG. 6 Data exchange.

For the settings for loading orders from the site, you can copy the previous exchange node and change the exchange mode: Exchange orders. On the "Order exchange" tab that appears, make the settings FIG. 7.:

• Search parameters for orders from the site. You need to create additional details "Date of order on the site" and "Number of the order on the site". By these parameters it will be possible to find orders in the document journal in the database;
• Counterparties identification method - we indicate the parameter by which the counterparty will be searched in the “Counterparties” directory to be filled in in the order; if the name is not found, then it will be created new entry about the counterparty;
• Parameters for creating new items in the "Nomenclature" catalog - if the ordered product is not found in the stock list, a new one will be created according to the specified parameters;
• Parameters for creating documents "Customer order" - for the correct creation of a new order in the database, it is necessary to indicate the Organization, the agreement with the counterparty.

FIG. 7 Configuring order loading.

On the “Additional” tab (FIG. 8) we set the parameters of recording and conducting: you can only record loaded orders or post them by the current date. You can also configure the correspondence of the status of orders on the site and in the program (FIG. 8).

FIG. 8 Additional settings loading orders.

After the settings are specified, you need to save the exchange node.

To automate the exchange of 1C: Enterprise with the site (the exchange will be carried out in automatic mode), you must run a scheduled task. To do this, in the "Administration" - "Support and maintenance" menu, select the "Routine and background tasks" section. The created exchange nodes will appear in this section. FIG. 9. For those routine tasks that need to be performed, you must select the On checkbox. A scheduled task can be started by clicking the Run Now button or Run a separate session (in this case, it runs on all routine tasks separate session of work with the base).

FIG. 9 Running scheduled jobs.

Very often you need to get data from 1C 8.3 and save the information in external file, in other words, to unload from 1C enterprise. The task is almost always feasible without the involvement of 1C programmers.

Consider the series useful tips, with the help of which you can upload data from 1C to an external information system.

There are several methods in 1C with the help of which you can obtain information without involving specialists:

• Unloading the entire database from 1C 8.3 - for subsequent loading on another computer
• Saving reports and printable forms to Excel, Word or PDF
• Unloading tables from 1C
• Retrieving Information Using the Query Console

More about them:

How to unload the entire database from 1c 8.3 (to file.dt)

To do this, you need to enter the configurator mode, then in the main menu select the "Administration" - "Unload information base»:

Then you only need to specify the name of the future file and its location on the disk.

For subsequent loading into another database, click on the "Load infobase" button and select the previously uploaded file.

Unloading reports and printed forms from 1C to Excel

This method is versatile and very simple. To do this, it is enough to open a printable or a report.

For example, open the TORG 12 printable, press ctrl + S (or in the File menu - Save As) and select the file type and its name:

For the same system works - the report is unloaded in two clicks:

Get 267 1C video tutorials for free:

Saving in basic formats is available - excel, word, pdf, html, txt, etc.

Unloading tables from 1C 8.3

Often there are such trivial tasks as "get a list of payments for the current year", "unload the book of purchases or sales" or "unload goods from invoice No. 256". It is quite simple to solve such problems.

For example, I need to receive all receipts from the counterparty "Vector" with an amount of more than 1000. Open the list form and set the required selections in the list:

The system will offer a withdrawal option - in spreadsheet document or text, choose tabular. The 1C program will display information in such a tabular document, which, like reports, can be saved in the format we need:

Similar actions can be performed for almost any tabular section in 1C 8.2. For example, we needed to unload a list of goods from receipt No. MSK00003, no problem. This is done very simply - open the document, call context menu and after a couple of clicks we get the required upload in the required format:

Uploading the transaction log from 1C to Excel:

Retrieving Information Using the Query Console

However, not all information can be found in a simple tabular section of 1C 8.2. Sometimes it is required to collect data from several data sources, to combine them by some fields.

This method is suitable for tech-savvy people who know the basics of the query language. It consists in getting the query result using and saving it in the format we need.

For example, you need to get all supplier counterparties and their telephone number... To do this, write the following query:

The resulting table can also be exported to the desired file format:

You can upload the received data to another 1C database using "". Watch the video tutorial for an example of the nomenclature: