![tecdoc catalog online tecdoc catalog online](https://i.ytimg.com/vi/Nr6PnMldQyw/maxresdefault.jpg)
If the product is found, we update its characteristics (such as prices and quantity)ģ. Search in the catalog by internal numberĢ. Our next steps are to link the internal number to the catalog products of the store and the TecDoc base.ġ. And before importing, we need to determine the fields we need based on the identification attributes. As a result, import will have to start from the third line. If you need to create a tool in which the price list fields can be changed, then you should write an identification attribute on the first line of each column (for example, 'V.numb', 'Name.manufacturer', etc.), and the second line will be the title for columns. That is, each line in the price list corresponds to a separate product, and for this product we draw out properties such as price, quantity, analogues of the TecDoc catalog, etc. When the script sends the line numbers to be processed, we will receive an array of properties for each product.
![tecdoc catalog online tecdoc catalog online](https://autopartscatalogue.net/wp-content/uploads/2019/01/tc.jpg)
A good option, but if there are tens of thousands of records, the import process will not be controlled.Ģ.1 After downloading the file, the number of filled lines is determined.Ģ.2 A script is generated that sends line numbers for processingĢ.2.1 The import process is displayed as a percentageĢ.2.2 The result of the import is displayed in the form of a table growing downwards during the import.Ģ.3 From the resulting table, the administrator can see the result and possible actions on each product.įor specifics, I give an example of products from the price list. In the form, the administrator selects the file that should be successfully uploaded to the server. It is advisable to add all kinds of checks like file type, protection against "XSS", etc.
![tecdoc catalog online tecdoc catalog online](https://piwik.pro/wp-content/uploads/2019/05/TecDocCatalogue.jpg)
![tecdoc catalog online tecdoc catalog online](https://www.epcatalogs.com/file/ccc55cd7bb1b52102b1b0193d2bd36da9101d436/tecdoc-2017-04-full-parts-catalog.png)
If you look at this part from the programmer’s side, everything is standard, that is, a form is created, a file is received, renamed and transferred to the desired directory. In order to make everything look beautiful, we created a module in the site control panel and displayed a link to it in the list of installed modules.Īfter clicking on the link, the administrator displays a form for downloading a file. “PHPExcel” - a rather convenient tool that allows not only to read data from a file, but also to generate its files. xls format, and there is no ready-made tool for working with this format in this CMS, it was decided to use “PHPExcel”
Tecdoc catalog online download#
The very first task was to download a new item from the generated price list. Now for more details on solving each of the problems. And most importantly, using the "Your Car" tool.According to the tree of categories of parts,.By internal number in the catalog of the online store,.There are tools for the user to find goods in the store: xls format or manually - through the site control panel. The main refinement of the online store is the ability to bind goods to the catalog - the TecDoc database, taking into account that the nomenclature can be downloaded both from the price list in *. Although out of the box, this product can also please with its capabilities.
Tecdoc catalog online license#
Since the customer had a license for this CMS, I had to work, so to speak, with what is. The basis of the online store is CMS "HostCMS". This online store sells spare parts for cars. We will not dwell on this, since in the vastness of the World Wide Web this information can be found without problems. To link the site with the TecDoc catalog, its database had to be uploaded to MySQL. The TecDoc product is a kind of database that includes not only the connections of spare parts manufacturers with specific catalog part numbers, but also contains images of goods, as well as a recommended price and, most importantly, the ability to search for analogues. Writing an article was the result of working in a rather interesting project, the result of which should be an online store, with the possibility of linking the item to the TecDoc parts catalog.