Downloading the catalog from 1C to the site: what is transferred and how to prepare the base
Goods, prices and balances are more convenient to keep in one place - in 1C, and to the site or wholesale portal to unload automatically. We understand how the exchange is arranged, what needs to be put in order in the database and where it most often breaks down.
Published:
Updated:
The catalogue, which is conducted in two places, diverges in a week: the price was changed in the accounting system, on the site - forgotten. Therefore, the data source must be one, and it is usually 1C. Everything else — the site, the dealer portal, the price — gets data from there.
How 1C transmits the catalog
In typical configurations for trading there is an exchange with the site. He works to the standard. CommerceML1C generates XML files and sends them to the address you specified in the settings. These are usually two files:
- catalogue groups, goods, their properties and links to pictures;
- suggestions Prices by type of price and warehouse balances.
They're coming back. ordersThe site gives them to 1C, and 1C returns statuses.
The exchange is started manually or on schedule. Supports both full unloading and unloading only changes - the second option is faster on large directories.
Transmitted.
| Data data | Where did 1C come from? |
|---|---|
| Categories | Nomenclature groups |
| Goods. | Nomenclature: name, article, unit, description |
| Product options | Characteristics of nomenclature |
| Properties | Additional details and properties |
| Pictures. | The attached nomenclature files |
| Prices | Types of prices: retail, wholesale, dealer |
| Remains | Remains in warehouses |
Each product receives an identifier by which the site recognizes it at the next unloading. Therefore, the product cannot be “recreated” in 1C without consequences: it will be a new position for the site.
How to prepare a base
Clean up the groups. The group structure will become the catalog structure. Groups "Different", "New folder" and "Archive 2019" the buyer does not need - exclude them from unloading.
Fill in the items and units. According to the article, buyers search and collect an order with a list. The unit of measurement and the multiplicity of packaging are needed so that the order cannot be placed “one and a half boxes”.
Decide which types of prices to unload. The purchase price should never be unloaded. The rest are one for each level of conditions you actually apply.
Check the pictures. Heavy photos slow down the exchange. A side of 1,500–2,000 pixels is enough.
Mark what to post. In exchange, selection is set: by groups, by warehouses, by feature in the card. Unloading the entire range, including services and packaging, is not necessary.
Where the exchange breaks down
Zero price. The price of the desired type is not filled, and zero goes to the site. A good receiver does not record such a price, but leaves the previous one or shows the “price on request”.
Double. The same product is entered in 1C twice - two cards will appear on the site.
The file is too big. Full upload with pictures may not meet the limits of the server. Helps unloading parts and exchange only changes.
Different warehouses. The balance is shown in total, and you can ship only from one warehouse. Unload the remains in warehouses, if it depends on the time.
The exchange stopped silently. The schedule was turned off during the update, and the catalog was not updated for a week. You need a journal on the side of the site, which shows the time and result of the last exchange.
What to do if not 1C
The same result gives upload to the file: Excel, CSV, XML. It is downloaded manually or placed at the address from which the site picks it up on schedule. Prices and balances are conveniently updated with a separate, lighter file – more often than the directory itself.
Exchange from 1C to Kup2B
The supplier’s catalog is connected to 1C by regular exchange with the site, and customer orders are returned to the accounting system. How to set it up - on the page [[solution:obmen-katalogom-s-1c|"Catalogue with exchange with 1C"]. The account can be collected without an accounting system ([tool:invoice]).
Frequent questions
What is CommerceML?
It is an open standard for the exchange of commercial data in XML format, which is used by 1C and most platforms for websites. It describes the catalog, offers with prices and balances, orders.
How often should data be uploaded?
Remains and prices - as often as they change: usually every 15-60 minutes. Full catalog with descriptions and pictures - once a day or after edits.
Do I need a 1C programmer?
For a typical configuration with a typical exchange - usually not: it is enough to specify the address, access and selection. A programmer will be needed if the configuration is heavily modified or non-standard fields are needed.
Will goods with characteristics be unloaded?
Yeah. Products with characteristics - size, color - are transmitted as a set of options, each has its own identifier, price and balance.
