Opencart integration with 1C Enterprise

today e-Commerce has progressed and entrepreneurs on the Internet have not use their own warehouses and sells goods most often
directly from the warehouse of the supplier.

In this regard, have the opportunity to publish on the website the volume of goods in excess of the unthinkable the biggest hypermarket: 2000 titles, 6,000 titles and more. Moreover, each product can have different characteristics such as color, size, material type, etc. and then the number of objects may be more than 20 000 such Internet stores often include stores auto parts, toys, clothing/accessories, etc.

Having a number of products, the business sets new conditions of automation: mandatory integration of online store with your existing accounting system of the organization. Often this system is a system of programs 1C: Enterprise, firmly entered the life of any business. In this article we will learn how to integrate an online store on the popular content management system Opencart and 1C trade Management.

Opencart CMS developed and positioned itself as a convenient platform for online stores.

And 1C: trade Management — like configuration, is tuned for organizations engaged in the sale of goods and the current account of the goods in the warehouse. E-Commerce in this configuration, there is the functionality of the exchange website:



However he is in any configurations: 1C: trade Management, 1C: Retail, 1C Integrated automation, 1C managing a small firm, 1C and other ERP. To integrate Opencart with 1C trade Management today, there are many modules and methods of exchange. All of them can be divided into several types:

1. Recording data items in the database of the site by embedding additional functionality into the program 1C
2. Video recording of goods through the external process exchanges
3. Data exchange standard Commerce ML

About first: most often for its implementation using a modification of 1C: enterprise configurations, embedding third-party code. Typically, when this embodiment is a so-called "withdrawal of support "configurations that automatically gives the go-ahead from service 1S to take the extra money for the updating of these configurations. For direct recording in the database of the site also need to install additional component 1C performing the connection to the mysql website. This, too, can sometimes be difficult, because of plant specific components on the platform 1C and the operating system.

About the second kind: all the same, but change the configuration of 1C does not occur.

About the third type: Exchange for the Commerce standard ML is that 1C generates an XML data file and sends it to the website. The site is reading the received file and the entry in the database of the site. The same technology used for CMS 1C-Bitrix. The advantages of this method is that from the 1C XML file is fully implemented in any configuration, it remains only to configure the connection to the site.

But to connect via the standard functionality of the exchange with the 1C website on the website there should be a script or module for data exchange with 1C.

All existing modules of exchange allow you to upload to a website and receive website the following information:

the
    the
  • uploaded to the website of groups and subgroups of items
  • the
  • Upload on the website of the item name, item description
  • the
  • Upload the website multiple images to the item 1C
  • the
  • Upload on the website of the manufacturer of the specified item
  • the
  • Upload to the site additional user details of item in product attributes
  • the
  • Upload to site item cost
  • the
  • Upload to site price types items to groups of customers.
  • the
  • Download from the site to 1C orders from customers
  • the
  • Download from the site to 1C Contractor and the Partner involved in the order
  • the
  • Download from the site to 1C of the item involved in the order
  • the
  • creating a selection at the unloading on site

In my opinion, the most convenient and easy to install and implement module Opencart sharing with 1C Enterprise this.

Works on all versions of Opencart does not require installation of any additional third-party modules on the website, and any configuration changes or modifications to 1C 1C.

Now about how in all the modules, including this, the relationship between the objects 1C and database tables Opencart (standard default prefix was not removed for clarity):

the the the the the the the the the the
Item 1C database Tables Opencart
elements of the directory "Nomenclature" oc_product, oc_product_description
Properties of the elements of the directory "Nomenclature" oc_attribute, oc_attribute_description, oc_product_attribute
Image element of the directory "Nomenclature" oc_product, oc_product_image
Group of the directory "Nomenclature" oc_category, oc_category_description
a Model agreement on the sales terms or prices of the item oc_customer_group, oc_customer_group_description, oc_product_discount
the item Remains at the warehouse oc_product
item Price oc_product, oc_product_discount
the Document "Order" and order goods oc_order, oc_order_product, oc_order_status
the Purchaser or the Counterparty involved in the ordering oc_order

The table is probably not complete, but the main objects it reflects. In most cases, these database tables are using the most modern exchange plugins to download information from 1C.

The exchange of data between Opencart and 1C is severely limited from the 1C. So the average statistics at the time of preparation of the data from 1C (to post data to a website) can take the following times:

20 thousand positions — 10 minutes
60 thousand positions — 15 minutes
80 thousand items — 25 minutes

After the data preparation program 1C, the fix data on the website, the speed of which may be limited only by the speed of the data transmission channel.

The final stage is the time to read a received XML file directly on the website, and the entry in the database. Time here is not essential, and usually the server is very fast "reads" the data.

In the method of exchange direct writes to the database, this point is omitted. Basically, all the main time to exchange spent on data preparation from the side of 1S in any method of data exchange.

Opinion: overall, Opencart is not bad and easy control system online store. Simple in programming. Very comfortable and nicely implemented the main page of the admin panel that allow you to analyze sales in different countries:



But at the same time, it is believed that opencart starts to work poorly the very large number of products on the site. Treated optimization and use of caching. For small online stores is quite good and economical CMS.
Article based on information from habrahabr.ru

Комментарии

Популярные сообщения из этого блога

Briefly on how to make your Qt geoservice plugin

Database replication PostgreSQL-based SymmetricDS

Developing for Sailfish OS: notifications for example apps for taking notes