Products 1c. "1C-Products" - a new product for managing a retail store

"1C-Tovary" is intended for retail stores and suppliers.

For retail stores, the service solves three problems:

  • loads new products (names, descriptions and barcodes) into the store’s accounting system - no need to enter product names manually;
  • automatically generates orders based on sales data - well-selling products will always be in stock;
  • allows you to monitor the operation of a retail store or several stores using reports.


Loading the product catalog

Filling out a product reference book is a separate big task when opening a store or starting sales of a new product group. This usually takes a lot of time: 2 minutes per item is two full working days to add 1,000 items. What if there are even more goods?

The service automatically loads products into the accounting system from a specialized online catalog, which contains more than 100,000 items and more than 2,000 groups. The download process can be controlled using filters:

  • by barcode;
  • by group in the catalog;
  • by brand;
  • by supplier.

An additional feature is the mapping of correspondence between the store’s product directory and the EGAIS directory. Matching is done using barcodes.

System for monitoring balances and automatically generating purchase orders

If the store's assortment is 500 items, then orders to the supplier can be created manually as the goods run out. But if there are more products, doing this manually becomes difficult. As a result, situations where a product in demand has run out will be repeated more and more often.

The 1C-Products service automatically checks minimum balances and generates a list of goods for which the balance is less than required. The service performs a series of calculations, the result of which is hints about how much of the product needs to be ordered and why such an order quantity is optimal from the point of view of the system. This allows you to avoid both shortages and surpluses of goods in the store.

Automatic order parameters can be adjusted manually. To make a decision on adjusting the application, the system provides data from ABS analysis (product contribution to store revenue) and the assortment analysis method using the Markon matrix (markup and product turnover compared to the group average).

The service notifies the responsible manager of the supplier about your order by email.

Store management and analysis

The 1C-Products service includes reports that allow you to analyze the efficiency of using store resources in order to optimize work and obtain maximum profits.

Revenue analysis:

  • Revenue by day
  • Revenue by working hours
  • Revenue forecast by the end of the month
  • Number of checks by day
  • Average check
  • Average number of items per check
  • Analysis of minimum and maximum check values
  • Revenue by payment type (cash, non-cash, other)

Analysis of inventory balances and turnover

  • Goods turnover
  • Assortment matrix - number of products in the store
  • Best Selling Products
  • Sales by supplier
  • Receipt analysis
    • Share and revenue of receipts with different quantities of goods
    • Analysis of receipts for one product

Space utilization analysis

  • Revenue from 1 sq.m.
    • Trade area
    • Total area of ​​the store
  • Distribution of turnover indicators by sections
    • Revenue per 1 sq.m. by product category
    • Area efficiency ratio
  • Share of rent in revenue
    • Share forecast for the current month while maintaining current rates

The service also allows you to compare the performance of several stores. Moreover, reports are available from any device via the Internet.

For suppliers The 1C-Products service makes it possible to publish price lists, according to which retail stores can make automatic orders. Thanks to this, the supplier can get new customers and set up automatic order processing.


Advantages

Service "1C-Products":

  • saves time when entering new products into the accounting system (automatic loading of the catalogue);
  • allows you to avoid errors in names, product descriptions or barcodes;
  • reduces the time for processing applications from the supplier and reduces the likelihood of errors in the order (indicating the wrong product, etc.);
  • increases store revenue and reduces store costs through timely automatic ordering of goods based on analytics and demand forecasting.

Conditions of receipt

To start using "1C-Products" you must:

  • Be a registered user of 1C programs;
  • Purchase a license for 1C-Products from the Forus company;
  • Download and install external processing (for the store and/or supplier) in the 1C user’s Personal Account on the 1C:ITS portal in the “1C-Products” section;
  • To operate the 1C-Products product, Internet access is required.

To get acquainted with the capabilities of the 1C-Products product, connect it for a trial period for free. The trial period is 1 calendar month and includes full product capabilities.

To obtain test access to "1C-Products" in your Personal Account on the 1C:ITS Portal, select the desired tariff (for a supplier or for a store) and click the "Get service for a test period" button.

Trial access can only be obtained if there are no available (current) 1C-Products tariffs on your account. The trial period can only be obtained once.

Programs in which the service is implemented

The 1C-Products service is implemented in the form of external processing for retail stores and suppliers.

External processing “For stores” can be installed in 1C programs:

External processing “For suppliers” can be installed in 1C programs:

Instructions

Before you start using the service, you need to download the required processing and set up work in it according to the instructions:

You can download external processing “For the store” and/or “For the supplier” in the user’s Personal Account in the “1C-Products” section.


Price

Tariff "1C-Products. Product catalog"

  • Includes loading products with barcodes into the 1C program from the 1C-Products catalogs.

Plan your assortment without mistakes

Find out which products bring you profit and should always be in stock. And, conversely, remove products with low markups and turnover from the assortment.

Manage inventory and order on time

Every day, the service automatically checks minimum balances and sends a request to the supplier in a timely manner. This way you will avoid shortages of popular goods and lost sales.

Increase your profits

Try it different variants increasing sales - new products, changing markups, redistributing space. Reports will help you make sure your actions are correct.

For wholesale suppliers

Find new customers

Publish price lists and competitive advantages- prices, delivery conditions, descriptions of goods. Retail stores, clients of the 1C-Products service, will see you among the suppliers and will be able to send you automatic orders.

Increase the efficiency of processing received orders

Applications from retail stores are automatically uploaded to the 1C: Trade Management 8 accounting system. All you have to do is check the names of positions and quantities and include applications in the work.

Terms of Use

  • The service works in programs:
  • "Retail, edition 2.2" from version 2.2.4.12 (for stores only)
  • "Retail, edition 2.2 basic" from version 2.2.4.12 (only for stores)
  • "Trade management" from version 11.2.3.66 (for stores and suppliers)
  • "Basic trade management" from version 11.2.3.69 (for stores and suppliers)

The program must be officially supported

Internet access is required for the service to work.

The 1C company announces the start of sales on April 1, 2017 of the new product 1C-Products. Until April 1, 2017, the 1C-Products product is available free of charge to all users.

For retail stores, the 1C-Products product solves three problems:

  • loads new products (names, descriptions and barcodes) into the store’s accounting system - no need to enter product names manually;
  • automatically generates orders based on sales data - well-selling products will always be in stock;
  • allows you to monitor the operation of a retail store or several stores using reports.

Loading the product catalog

The product reference book is filled out when a store opens or in connection with the start of sales of a new product group. This usually takes a long time - 2 minutes for each position. So, it will take two full working days to add 1,000 items. What if there are even more goods?

Products are loaded into the 1C accounting system automatically from a specialized online catalog, which contains more than 100,000 items and more than 2,000 groups. The download process can be controlled using filters:

  • by barcode;
  • by group in the catalog;
  • by brand;
  • by supplier.

An additional feature is the mapping of correspondence between the store’s product directory and the EGAIS directory. Matching is done using barcodes.

System for monitoring balances and automatically generating purchase orders

If the store's assortment is 500 items, then orders to the supplier can be created manually as the goods run out. But if there are more products, doing this manually becomes difficult. As a result, situations where a product in demand has run out will be repeated more and more often.

The 1C-Products product automatically checks minimum balances and generates a list of products for which the balance is less than required. This performs a series of calculations that provide hints about how much to order and why that order quantity is optimal from the system's point of view. This allows you to avoid both shortages of goods in the store and excess goods.

Automatic order parameters can be adjusted manually. To make a decision on adjusting the application, the system provides data from ABS analysis (product contribution to store revenue) and the assortment analysis method using the Markon matrix (markup and product turnover compared to the group average).

Orders are automatically sent to suppliers, to email responsible manager.

Store management and analysis

The 1C-Products product includes reports that allow you to analyze the efficiency of using store resources in order to optimize work and obtain maximum profits.

Revenue analysis:

Revenue by day

Revenue by working hours

Revenue forecast by the end of the month

Number of checks by day

Average check

Average number of items per check

Analysis of minimum and maximum check values

Revenue by payment type (cash, non-cash, other)

Analysis of inventory balances and turnover

Goods turnover

Assortment matrix - number of products in the store

Best Selling Products

Sales by supplier

Receipt analysis

Share and revenue of receipts with different quantities of goods

Analysis of receipts for one product

Space utilization analysis

Revenue from 1 sq.m.

Trade area

Total area of ​​the store

Distribution of turnover indicators by sections

Area efficiency ratio

Share of rent in revenue

Share forecast for the current month while maintaining current rates

Using the 1C-Products product, you can compare the performance of several of your stores. Reports can be viewed via the Internet from any device ( mobile phone, tablet or computer).

The 1C-Products product gives suppliers the opportunity to publish price lists, according to which retail stores can make automatic orders. Thanks to this, the supplier can get new customers and set up automatic order processing.

We invite users to take part in the webinars “1C-Products. How to get started” on March 16 and 30, 2017.

RATES

"1C-Products. Auto order for the store":

"1C-Products. Sales Analytics":

  • Loading a product catalog with barcodes into the 1C program.

Cost: 1000 rubles per month for one store.

"1C-Products. Comprehensive for the store":

  • Loading a product catalog with barcodes into the 1C program.
  • Control of balances and automatic generation of purchase orders.
  • Analysis of the operation of a retail store or chain of stores.

Cost: 1,700 rubles per month for one connected store.

"1C-Products. For the supplier:

30 price list publications.

Cost: 5000 rub. for 12 months.

ADDITIONAL CONDITIONS FOR USE OF "1C-GOODS" TARIFFS

The function of loading a product catalog with barcodes into the 1C program is available free of charge to everyone. To gain access you must:

  • in your Personal Account on the 1C:ITS Portal in the “1C-Products” section, order a free tariff
    "1C-Products. Product Catalog".

Free access to the product catalog is provided for one year, after which the user must re-gain access in the Personal Account on the 1C:ITS Portal.

A test tariff "1C-Products. Test for a store" is available for stores, which includes all the features of the "Complex for a store" tariff and is available for 10 stores for one month.

A test tariff "1C-Products. Test for supplier" is available for suppliers, which includes 30 free price list publications throughout the year.

To obtain test access to the 1C-Products product, in your Personal Account on the 1C:ITS Portal, select the desired tariff (for a supplier or for a store) and click the “Get service for a test period” button.

A trial tariff can be issued only if there are no available (valid) options for the 1C-Products product on the user account. The trial period can only be obtained once.

Paid tariffs for "1C-Products" can be purchased from partners of the company "1C". The validity of paid tariffs begins on the date that the 1C partner indicated in the connection application. The actual volume of tariff use is determined based on the data automated system company "1C".

If the 1C-Products license has expired, the user's right to access 1C-Products capabilities will be suspended. Therefore, timely renewal of 1C-Products ensures comfortable, continuous use of this product.

PRICES

The 1C-Products product is available free of charge to all users until April 1, 2017. From April 1, 2017, the following recommended prices for 1C-Products licenses are established:


Product name

price, rub.

"1C-Products. Auto-order for a store for 1 month"

"1C-Products. Auto-order for a store for 2 months"

"1C-Products. Auto-order for a store for 3 months"

"1C-Products. Auto-order for a store for 4 months"

"1C-Products. Auto-order for a store for 5 months"

"1C-Products. Auto-order for a store for 6 months"

"1C-Products. Auto-order for a store for 7 months"

"1C-Products. Auto-order for a store for 8 months"

"1C-Products. Auto-order for a store for 9 months"

"1C-Products. Auto-order for a store for 10 months"

"1C-Products. Auto-order for a store for 11 months"

"1C-Products. Auto-order for a store for 12 months"

"1C-Products. Sales analytics for a store for 1 month"

"1C-Products. Sales analytics for a store for 2 months"

"1C-Products. Sales analytics for a store for 3 months"

"1C-Products. Sales analytics for a store for 4 months"

"1C-Products. Sales analytics for a store for 5 months"

"1C-Products. Sales analytics for a store for 6 months"

"1C-Products. Sales analytics for a store for 7 months"

"1C-Products. Sales analytics for a store for 8 months"

"1C-Products. Sales analytics for the store for the 9th month"

"1C-Products. Sales analytics for the store for the 10th month"

"1C-Products. Sales analytics for the store for the 11th month"

"1C-Products. Sales analytics for the store for the 12th month"

"1C-Products. Comprehensive for a store for 1 month"

"1C-Products. Comprehensive for a store for 2 months"

"1C-Products. Comprehensive for a store for 3 months"

"1C-Products. Comprehensive for a store for 4 months"

"1C-Products. Comprehensive for a store for 5 months"

"1C-Products. Comprehensive for a store for 6 months"

"1C-Products. Comprehensive for a store for 7 months"

"1C-Products. Comprehensive for a store for 8 months"

"1C-Products. Comprehensive for a store for 9 months"

"1C-Products. Comprehensive for a store for 10 months"

"1C-Products. Comprehensive for a store for 11 months"

"1C-Products. Comprehensive for a store for 12 months"

"1C-Products. For the supplier for 12 months"


Licenses for the 1C-Products product are not subject to VAT.

TERMS OF PURCHASE AND USE

To start using the 1C-Products product you must:

· Connect Internet support in the 1C program; (https://portal.1c.ru/download/public/instruction/internet-support-instruction.pdf);

· Purchase a license for 1C-Products from our company;

· Download and install external processing (for the store and/or supplier) in the 1C user’s Personal Account on the 1C:ITS portal in the “1C-Products” section;

· Internet access is required to operate the 1C-Products product.

The terms of the user agreement are posted in personal account user on the 1C:ITS portal.

PROGRAMS IN WHICH YOU CAN CONNECT 1C PRODUCTS

The 1C-Products product is implemented in the form of separate external processing for retail stores and suppliers.

External processing “For stores” can be installed in 1C programs:

External processing “For suppliers” can be installed in 1C programs:

To connect and configure the 1C-Products product, it is recommended to contact a partner providing information technology support. Before you start using it, you need to download the required processing and set up work in it according to the instructions:

Official support.

Sign up to our newsletter

No one will buy a product that is not on the shelf. The 1C company has released a new service, the use of which will significantly simplify the work of generating applications to the supplier.

"1C-Products"– control of inventory balances; automatic order generation based on forecast; the financial analysis store revenue; store analytics, as well as monitoring the operation of retail stores from anywhere in the world via the Internet.

For retail stores, the 1C-Products service solves the following problems:

  • automatically generates orders based on the store’s sales forecast - well-selling products will always be in stock;
  • allows you to control the operation of a retail store or several stores via the Internet - all key indicators the store's work is always at hand;
  • allows you to obtain a detailed financial analysis of the store’s revenue, as a result of which an understanding is formed of which product brings the most profit to the store;
  • generates an analysis of the efficiency of using the retail space of a retail store;
  • loads new products (names, descriptions and barcodes) into the store's accounting system - no need to enter product names manually.

The service has a number of significant advantages, including:

  • automation of ordering supplier goods in the required volume (no more, no less);
  • increasing store profitability;
  • the ability to quickly see products that were missing from store shelves and see how much money the store lost;
  • the ability to avoid errors in names, product descriptions or barcodes;
  • reducing the time for processing applications from the supplier and reducing the likelihood of errors in the order (indicating the wrong product, etc.);
  • increasing store revenue and reducing its costs through timely automatic ordering of goods based on analytics and demand forecasting.

Using all the functions of the 1C-Products service, you can avoid mistakes of manually entering products into the program directory, you will always know about balances in real time, and with the help of analytical reporting and forecasting consumer demand, you will reduce store costs and increase your profits.

The 1C-Products service provides a wide range of capabilities:

  • ordering the required quantity of goods (no more and no less) - this will avoid shortages or surpluses of goods in warehouses and on store shelves;
  • showing which products sell the most and which generate the most profit;
  • a hint about which products need to change the price;
  • loading product names with barcodes into the configuration;
  • loading additional information by goods;
  • automatic comparison of the existing catalog with the EGAIS directory;
  • demonstration of how to effectively use trade area store.

The service analyzes a large amount of data and notifies about changes that require attention:

  • automatically generate purchase requests according to the configured assortment matrix;
  • select a supplier (compare prices) from registered suppliers in the 1C-Products or 1C-Business Network service;
  • automatically analyze the fulfillment of orders by suppliers and issue recommendations for setting up an auto order system;
  • receive basic analytics of the operation of a store or chain of stores via the Internet (without going to the store);
  • publish price lists of goods suppliers to automate orders and find new customers.

Working for 1C-Tovary helps suppliers:

  • speed up and simplify the procedure for receiving applications for products;
  • increase sales volume at existing client base (the current catalog of your products published in the service will always be available to customers);
  • find new buyers (software 1C-Retail occupies a significant share of the automation market for retail and chain stores. When connecting to the 1C-Products service, stores will have the opportunity to familiarize themselves with the range of your products and fill out an application for it);
  • optimize logistics(you will know which buyers, in what volume, when and what products will order from you).

“1C-Products” is suitable for any suppliers – from small to large. In addition, the service will be of interest to regional distributors. The main value for them is finding new clients.

The service is also useful for suppliers who want to automate the process of receiving orders from stores, predicting the receipt of orders and planning logistics.

It is best to work on connecting the service with the head of the company: only he will be able to determine the scope of work for the organization remote access and name the departments that need to be connected.

Using the table, you can segment users by the “ease of offer” of the service. Low priority users may also be interested in the service.


Price

"1C-Products. Catalog":

  • includes loading products with barcodes into the 1C program from the 1C-Products catalogs.

Free for one year.


"1C-Products". Auto order for the store:

  • control of inventory balances and automatic ordering of goods.

"1C-Products". Sales analytics for the store:

  • loading a product catalog with barcodes into the 1C program;

Cost: 1000 rub. per month for one connected store.


"1C-Products". Comprehensive for the store:

  • loading a product catalog with barcodes into the 1C program;
  • control of inventory balances and automatic ordering of goods;
  • analysis of the operation of a retail store or chain of stores.

Cost: 1700 rub. per month for one connected store.


"1C-Products". For the supplier:

  • 30 price list publications.

Cost: 5000 rub. for 12 months.

The service works with standard 1C configurations.

On almost every IT project related to 1C, I come across master data for products (or rather, the lack thereof). To begin with, I will describe the most memorable examples.

Uploading a product catalog from 1C to another 1C

The company is engaged in the wholesale sale of auto parts. Mostly domestic spare parts, but there are also foreign cars, as well as tires, fuels and lubricants, accessories, etc. The accounting system is UT 10.3, of course, highly customized.

One day, the head of the sales department comes into the IT department and says: the client has installed 1C: Trade Management 11 and wants to download our “Nomenclature” directory. Completely as is. Arguments: the client needs to start working somewhere. Quickly create product cards and conduct an inventory. And we need this, because the client is extremely important. And he even came personally a couple of hundred kilometers away and brought with him a system unit with a clean base. The system manager is already standing at the entrance, and the client will go back in the evening. Next, there is a brief discussion with management about the order of tasks, based on the results of which a decision was made to do it anyway. Having wiped off the dust from Data Conversion, we assemble the unloading and loading on our knees (or we modify the standard one, which no longer takes off due to customization), and the satisfied client goes home.

After some time, I went freelance. And in that company, several times later, clients wanted to receive a catalog, but there was no one and no time to deal with them. One such client I recently interacted with ended up doing guess what. That’s right, I wrote my download of goods from Excel, since the price list in Excel was the only thing that was publicly available.

Download price list for laminate and linoleum

During the years of freelancing, I come across another task of downloading the price list of one company from Excel. Create product cards in 1C, set prices, everything is as usual. The price list contains two sections: laminate and linoleum. You have to sweat because of two features. Firstly, in this file the products do not have any unique identifiers (codes, for example). Secondly, there are quite a lot of fields, each of which is important for loading: class, collection, dimensions, weight, etc. The download is written, the money is received, the customer company disappears from sight after some time and, according to my assumptions, closes down for good. The thought that, despite the money received, the work was done in vain, is still upsetting.

That same year, while fulfilling orders for another company, I came across familiar laminate items in the “Nomenclature” directory. Out of curiosity, I ask questions to the supply department: how do you enter these items into the directory and how do you update prices. The answer is “manually, of course.”

A few years later, on the sidelines of Infostart 2015, I managed to chat a little with a 1C developer from the company that produced this very laminate. In response to my story, she said with surprise: “Well, we have a web service for this, we wrote it specifically.” I regret that neither I nor my clients knew this before.

EDI

How food retail works: retail chains order some goods from their suppliers through electronic services. An order is a file containing a list of desired products. Each line of this list contains identifiers of this product, V general case there can be three of them: a code in the supplier’s accounting system, a code in the buyer’s accounting system, GTIN (the same barcode that is pasted on the packaging). And in the vast majority of cases, the supplier code is missing in the message. In short, this dialogue looks like this: “Supplier, bring me the goods. I don’t know how it is designated in your database, but I have it with this name and code, pick something.” This gives rise to a huge number of problems with the comparison of goods between the accounting systems of the buyer and supplier. For example, the buyer records the goods in pieces, while the supplier records them in packages of 10 pieces. And now, instead of a box of mayonnaise, the buyer gets a truck loaded with mayonnaise to capacity.

Any implementation information system on 1C, which contains a block of goods accounting, it is customary to start with determining the structure of the “Nomenclature” directory. Will characteristics be used? Will the packaged product be a new directory item or new unit measurements? Is barcoding necessary? Information about weight/dimensions of product units? Mistakes at this stage can ruin the project a little later, especially when it comes to production.

In the case of EDI, retailers want to relieve their operators processing orders and shipments as quickly as possible. In accounting systems like retail chains, and their suppliers often contain erroneous data (duplicates, incorrect barcodes, characteristics instead of new items or vice versa, etc.). There is usually no talk about putting classifiers in order: there is no time, it’s expensive, “it just happened, it’s better not to touch it.” Synchronizing directories between accounting systems becomes a very difficult task. Developers of EDI integration modules for 1C are often forced to bypass this chaos at the cost of crutches in the code.

Loading supplier price lists, searching for matches

The company has several suppliers. Many of them provide price lists in Excel. Some send it by mail, others keep it in the public domain. The order and composition of the columns is not repeated anywhere. The task is to automate the loading and updating of price list data in 1C, semi-automatic comparison of your product range with that of the supplier. The problem has been solved (including on the basis of previous works in this area), the money has been received in full, the question “how long?” is spinning in my head.

Current situation

I think each of you has encountered one or another manifestation of the same problem, which was described at the very beginning: the lack of a clear catalog of products from each company with unambiguous identification of the elements in it. To order something from a supplier, it would be good to give him full information about what exactly we are ordering. At least the internal product code and units of measurement (characteristics - when used). To monitor changes in supplier prices, you need to have links between your goods and suppliers' goods, and for this you need identifiers. To calculate the total weight of goods when delivered by road, weights are needed for each item. These weights are usually in the manufacturer’s accounting system, but who makes them publicly available?

A simple search for the words “Download from excel” on Infostart returns 670 publications. Try to interpret this figure.

What has already taken off and has not taken off

The topic is by no means new, it more years than me. There are two excellent articles on the topic of master data management: practice inMaster data at the crossroads of trade routes and theory in . MDM solutions are produced by many companies. From foreign ones - for example, IBM, from ours - Axelot (just for 1C). The cost of such solutions: Axelot MDM - 450,000 rubles, IBM provides prices only upon request (if anyone knows, write, I’m just curious about the number of zeros).

The attempts I know of to organize a master data catalog have failed in most cases for the following reasons:

    Building good, high-quality, structured directory hosting takes thousands of man hours. The question of payback arises of this service. The developers need to at least be fed. Three packs of doshirak a day is approximately 40,000 rubles a year. We multiply by several developers and several years, provided that boiling water is free, and the developers are unpretentious and desperately tenacious.

    Often, filling such a directory requires first tidying up the local directory of the organization that provides it. Getting rid of duplicates, correction spelling errors, barcode verification and so on. Performers on the customer's side are not always interested in additional work.

    Well, there were 2-3 companies that corrected all the errors in their local catalogs and uploaded them to the cloud. Few people will go to this cloud until several hundred such directories are placed there. And few people want to place their catalogs in that cloud as long as no one goes there.

We add it all up and we get that it’s cheaper to do something that will bring in money right now. Nobody wants to do something that will help put some order in the catalogs of several thousand companies, but is unlikely to ever pay off.

Therefore, current solutions on the market can be divided into 2 parts:

    Major solutions for large companies. Long and difficult implementation, restructuring of current business processes, but final result probably worth the money and effort (very big money and effort, remember IBM and Axelot).

    Simpler solutions for medium and small companies, like Agorab2b. The main functionality is a display of goods with stock and prices, comparison of goods in different catalogs, quick exchange of orders. This speeds up the payback of the service, but does not yet involve working specifically with master data.

Yes, there is also 1C-Network. Also paid (although the price tag seems humane), focused primarily on EDI. The product catalog is not hosted, but is transferred directly to the client upon request.

What does 1C have to do with it?

Just for fun, over the course of a few evenings, I assembled a simple web service on my knee in the form of a configuration for 1C 8.3, which can:

    Accept a product catalog in the form of an XDTO package;

    Store this directory in yourself;

    Release it outside upon request.

The service comes with client processing that operates in two modes:

    Uploading a catalog to the server;

This can already solve the problem of transferring a product catalog between different 1C systems “as is”, described at the beginning. And it’s a shame to send it to gather dust on a shelf. Now I’m at a dead end: it’s unclear where to move next, and whether it’s worth it.

The list of tasks that can be quickly solved in this product is tentatively as follows:

    Hosting a product catalog with all the important details of each group and distributing it to everyone. Prices, balances - upon request.

    Semi-automatic comparison of goods between buyer and supplier catalogs.

    Automatic downloading of price lists from different suppliers, comparing them with your own products. Providing download results via API in a single structure. Price monitoring. Yes, I'm talking about downloading from Excel, so far it's impossible without it.

    To hell with it, creating price lists in Excel and uploading them anywhere according to a schedule can also be done.

    Formation of orders to suppliers according to different rules (availability in the supplier’s warehouse, supplier with the minimum price, etc.).

    Uploading a product catalog to Yandex.Market. There is no need to write it for each 1C configuration if there is only one configuration. You can also upload to popular CMS if you do not plan to exchange applications.

    Obtaining product properties from other catalogs through links. For example, your product catalog does not indicate the weight of each item. And your supplier has it listed. You compare products in catalogs and get access to the attributes of your supplier, including weight. After that, it’s not difficult to load them into your accounting system. Barcodes follow the same pattern.

    “Small EDI.” For starters, for example, exchange orders. The buyer sends the “Order to Supplier” document to the cloud, the service converts goods from the buyer’s catalog into goods from the supplier and sends them to the supplier. The most common options are e-mail and FTP; you can also do passive issuance of new orders via API.

    This is where statistics collection comes from. Seasonal coefficients for goods, scarce items, etc. This is if the service threshes non-stop for at least a couple of years))

    Notification mechanisms. For example, a banal email to customers about reducing prices for their goods. Do you think many customers are looking for those red lines marked “Sale” in Excel with 30 thousand positions?

    Setting up product description validation. For example, in the admin panel you can specify that for products in the “Tires” category, the properties “Radius”, “Profile Height”, “Profile Width” and “Seasonality” must be specified, and “Seasonality” has 3 possible values. The catalog owner receives a notification about products whose descriptions violate these rules.

    Correction of inaccuracies in product characteristics. For example, 5% of your articles contain errors. At the same time, you have a catalog of goods from the manufacturer, who has these articles entered correctly. Compare products, launch comparisons, identify inaccuracies, and correct them.

    Integration with other product catalogs. For example, Autodealer.

    Search for suppliers/buyers of your goods.

    Vasyuki is renamed New Moscow Your ideas.

In reality, each of these problems has long been solved separately. I propose to put everything together, organize it and make it publicly available, and then gradually increase the functionality according to the “finish it yourself - share it with others” scheme. In software development, the principles of communism are completely justified.

Is it possible to make money from this? Hard to tell. If such a solution is truly in demand, you can deploy a virtual machine in Amazon, license it and distribute client processing for uploading/downloading. This option will obviously be paid to some extent (at a minimum you need to pay for hosting and 1C licenses), but the opportunity to download CF for free and deploy it on your network will remain. The disadvantage of a local installation will obviously be the inaccessibility of directories from the common repository. Although you can think about replication. The plus is in the same place as the minus: for example, a DDOS attack on a shared repository will not interfere with a local one.

Why web service on 1C? “Just because I can.” Built-in support for web services, data storage, the ability to create an admin panel on managed forms via a browser - and all this in a familiar development environment. It is clear that 1C may not be able to handle really large volumes of data. If the project suddenly becomes so large and in demand, then it can be ported to MongoDB + ElasticSearch + (whatever), leaving the same API.

For geeks, I will list the technologies/techniques used:

    Working with XDTO. XSD schemas. No direct XML parsing.

    Asynchronous calls to the server. When unloading a directory, the client sends a data packet to the kernel and immediately receives a response, and the actual recording of the packet into the tables occurs in a separate background job.

    Only managed forms in the core.

    Regular and managed forms in client processing. The main logic is in the object module.

    Maximum separation of the logic for working with a specific configuration from other logic (communication with the server, drawing forms, etc.).

    Working with access control systems, of course.

    Web service based on SOAP, planned to be transferred to REST.

    Compress large packets before sending.

    Minimum set of RLS.

Planned:

    TDD\BDD, autotests.

    Synchronization with GIT - for starters, only in one direction, perhaps it will be possible to set up a full-fledged merge and compilation from sources at least for the kernel.

    Search for products using ElasticSearch.

    Work of the client part as a routine task. Installed, configured, forgot.

    Excel parsing - exclusively through ADODB. It is previously possible to convert the columns into a normal text format - the code is available, all that remains is to embed it.

    Controlled blocking in some potential bottlenecks.

    Ability to customize the client and kernel without removing support (“plug-in module”, if anyone knows).

    COM connection as an alternative to HTTP for local installation.

    Metadata.js as an alternative kernel admin panel.

Admit it to yourself, have you ever wanted to participate in an opensource project on 1C?

Closer to the point

Summary: I propose to work on a solution that does not pretend to be a giant structured catalog of master data certified by ECR\GS1. The solution consists of 2 parts: configuration on 1C with a web service (“core”) and external processing to interact with him (“client”). It can be installed locally and used to solve some specific tasks, such as downloading price lists or distributing catalogs to clients, or it can be installed in the cloud.

Perhaps you are going to solve some of the problems listed above in your company. Are you interested in such a product? Are you ready to participate in its development according to the described scheme? At least as beta testers?

Example in files. You can download from UT 10.3; downloading is currently implemented under Retail 2.1. Deploy and publish the configuration under Apache 2.2 (very easy) or IIS (a little more complicated).