How to link 1C, store and warehouse to the site, to display the current balance of products?

Question

1C

There is a site without CMS. I want to connect 1C to it so that the site always has up-to-date information (price and product balances in the store and in the warehouse).
Tell me in the most simple language, I will study for the first time.
The question arose, because. I do not want to overpay 50,000 for the service.

Answer 1

Well, you can write a simple web service that will pull the leftovers with prices from the 1C database for each request and catch on to this web service on the site ... almost immediately there will be a brake problem ... you will have to think about caching ...
You can write processing , which will, with a certain regularity, upload current balances with prices somewhere from where the site will display it.
You can further simplify the task in the form of "and so it will do" and stupidly unload the leftovers, archive it and upload the archive on the server ... and on the site itself "download the price")))
Well, you can also upload the leftovers, base prices and on the site taking into account a specific site visitor - to form his personal price, taking into account discounts. And even leftovers - depending on the group of the visitor.
Well, yes. The most trump option is "to get a price list - send us a letter on the form and attach the organization card"))))))

Answer 2

If the site is without a CMS, then you will have to write the exchange module yourself.
There are 2 options:
1) Write an exchange module for the site.
You will need an official description of the exchange protocol .
You can "peep" examples in free exchange modules for OpenSource CMS, I think you know them or quickly google them.
Because I most often work with online stores on Opencart - I can offer to look at the most famous and popular free exchange module for this CMS, an enthusiast also began to write it for himself. He has been writing for 5 years now, and I must say he has achieved very, very good results.
Of course, you probably don’t need such a powerful exchange, but you need basic functionality - get the xml exchange files that 1C sends, then parse them, extract balances / prices and other useful information, and drive it into the site database.
2) Use ready-made paid or free external processing to exchange with the site or to upload information in xml / json / csv, etc.
There are a lot of options. You will also have to work hard, but I think it's much easier than writing an exchange module as in punt 1.
Look for processing here , search for the phrases "exchange with the site", "upload to the site".

Answer 3

As another option. Take a ready-made bitrix upload module for 1C. It is available for download from the official website. This exchange, for all its shortcomings, still knows how to unload leftovers with prices in the context of 1C warehouses. You can upload the result of its work to a file (xml) and write the download of such files from the site. There will be almost a typical solution.
To transfer data to the site, this solution uses a php script. If this option does not suit you, you will need to figure out a way to transfer data yourself. And if it does, then you will need to write your own php script that will write data to the database, which is still a decent amount of work.
ps 50000r. modestly for this work.

Answer 4

For such purposes, they seem to use the web server built into 1s and the oData exchange protocol

Answer 5

If there is no 1C server, practically nothing. Http requests to the file base can take tens of seconds and require an unknown number of licenses. If there is a 1c server, it is better to make an http service that will select the leftovers and return the data in json, for example. A web service is a more heavy-duty mechanism for this task, and these extra functions are not required. Odata is also a so-so option, it happens that due to problems with the cache it starts returning the same result for different requests. If there is not much experience, the rest query can be copied from any standard report, there are a lot of examples on the net to convert the result of the query. From experience, it is quite possible to make a 1s back end, but for sufficient performance, you will have to look at the indexes and slightly adjust them

Answer 6

I specifically solved my situation by synchronizing the nomenclature and residues from 1s to the site database directly, using 1s means (language).
I think the downside of the option is the dependence on the channel (with a ping of 40 ms, half a million requests are executed for a very long time).