Data exchange between the regular store and the online version

Evgeny Mikhalev2012-03-13 11:01:44

Evgeny Mikhalev, 2012-03-13 11:01:44

There is an offline hardware store, and the task is to present this store on the Internet.
I didn’t deal with 1s, but as I understand it, all the names of goods with their quantity, price, article number, etc. lie in the database 1s.
You need to set up data exchange:
1) Initially import a catalog of goods from 1c,
2) Every evening, report changes from 1c to the store and their store in 1c

What is the best way to implement this, maybe someone has already done this?
I look towards prestashop and import via csv for point 1

Answer the question

In order to leave comments, you need to log in

9 answer(s)

cat_crash, 2012-03-13
@neznae4ko

I am not a supporter of Bitrix, but in my opinion it will be the best solution for integration with 1C with minimal labor costs.
If the soul does not lie in the direction of Bitrix, then the process is something like this:
1. From 1C, an upload is made to a text file. The file can contain any data from the 1C
2 database. The file is uploaded to the Admin panel (or to the host) and processed by a script that parses the file into its constituent data, analyzes it and adds / changes data in the site's product table. Here, in principle, everything depends on the business logic.
You can try to pervert through XML-RPC, like 1C 8ka can do it.

Maksim T., 2019-11-16
@zapalm

Since the question was asked, a lot has changed in technology and ready-made solutions for data exchange between 1C and PrestaShop have appeared. Some self-written exchange options are a thing of the past. There is the CommerceML standard , which already has a second edition that is widely used and a third edition that is not yet so widespread. That is, thanks to this, the exchange process and data format are standardized. Many applications of the 1C 8 platform have a standard exchange tool with a site (online store) using the standard CommerceML exchange protocol, and for PrestaShop there is a ready-made exchange module for working with this standard tool.
On Infostart, I wrote a detailed commentary with objective criticismoutdated exchange solutions with 1C, which are still offered by developers as excellent solutions, although they are not in many ways. I tried to give recommendations in the comments on choosing the right technology and solution. I suggest that you read the commentary on Infostart and put a plus if you liked it. If you have any more questions, then comment on my answer there or here - I will answer you and clarify, if necessary, my answer on the topic.

Evgeny Bezymyannikov, 2012-03-13
@psman

Exchange via xml - the simplest and most reliable

egorinsk, 2012-03-13
@egorinsk

There were several articles on Habré on the topic of integrating 1C and an online store. It is usually configured in 1C to periodically upload updates to the site, and the site accepts it and updates the database. Google it (with Google, not with a habr search), don't be lazy, and you'll find it.

Vsevolod, 2012-03-13
@sevka_fedoroff

Did something similar about 7 years ago. I must say right away that there were very few orders in the online store, and data exchange was only in the direction of 1C-> store. I was just starting to program then, I wrote everything by hand. In 1C, a special button was made (I had to strain the 1C programmer), which generated a csv file with the data I needed. The main fields were: article (i.e. unique product ID), name, price, quantity. Next, this file was uploaded to the store's website. I had a special desktop application for this, but this is not so important. As such, there was no initial data loading. It's just that each time the entire csv file was processed line by line. If such an article is already in the system, then simply update the existing record (price and quantity), if not, add a new record. The store, in principle, could work immediately after loading this csv file. Those. the online store had the current price and availability of goods. Just then I went to the admin panel of the store and added descriptions and pictures for the products. At first I had to take a steam bath, but then new products were added not so often. Order processing after a phone call has already taken place in 1C, so there was no need for a reverse data transfer. It’s just that the next day (or maybe the same) the data was again unloaded from 1C to the store. so there was no need for a reverse data transfer. It’s just that the next day (or maybe the same) the data was again unloaded from 1C to the store. so there was no need for a reverse data transfer. It’s just that the next day (or maybe the same) the data was again unloaded from 1C to the store.

steven, 2012-03-13
@steven

O! My topic ... a long time ago I wrote a thesis on this topic.
Firstly, what is 1C? (8?), Secondly, is there an engine (Internet store)?
Third, what is the budget?
In general, nothing complicated ... we upload it to csv, send the file to the server, the script processes the file and that's it ...
Anyway, when an order arrives, you will do the documents in 1C-ke ...

Vyacheslav Golovanov, 2012-03-15
@SLY_G

I came across such cases, for some reason everyone exports from 1C to csv. Further everything is simple.

itserw, 2012-03-15
@itserw

If you have 1C UT, then indeed, the easiest way is to integrate with Bitrix - goods will be unloaded in one direction, orders in the opposite direction. For typical configurations, it is quite easy to set up.

Vladislav Chernyshov, 2015-09-16
@vlad4ernyshov

I implemented it like this: A
price list with current quantities and prices is unloaded from 1C. > The price is processed by a macro (ordered from a programmer for 3000r, + a couple of days he finalized and tested), which gives a list of SQL queries to the site database > Then I connect to the database and send requests. I spend 2 minutes on this. As for me, it's more convenient than using a csv file.