Your assistant in the car businessYour assistant in the car business
DESCRIPTION OF INTEGRATION WITH ONLINE STORE OPENCART
The necessary tools to create a website:

- Install the program for selection of spare parts (the path to the program)
- Registered program for creation data "CREATOR DATA FOR SALE OF AUTO PARTS"
- Online store OpenCart. Has been tested several versions of OpenCart (1.5.6, 1.5.4.1, 1.5.2.1).
Version 1.5.2.1 has been the most workable (1.5.4.1 does not work in search feature TAG)
- Import Tool for store OpenCart. For example "CSV IMPORT" (www.ka-station.com) (this is not
my developed, so that errors may occur in the work, although in testing errors was not revealed)

To develop the example I set a few goals :

- Import data of spare parts with images
- The opportunity to search for parts by original number and cross-reference number
- Integrate catalog search for spare parts according to the car. The catalog I do divide into
two options:

- Integrated directory created by the program (html-page site for selection of spare
parts)
- Catalog based on categories (a standard feature of OpenCart)

- And most importantly, create a catalog, only based on the parts that are in stock (for
example, took price-list in XLS format of the availability of my the warehouse)
Processing to price list

Need get a list of ID number (ART_ID) for the spare parts that are listed in the price list.
Processing to price list
Processing to price list

Connecting price list for processing

Processing to price list
Processing to price list

Creating a list of brand names parts for my list price, as first data were established for a long time (10 years ago) and some of my brand name is not the same as a brand name in the table program for selection of spare parts.

Program for selection of spare parts (the path to the program)
Processing to price list
Processing to price list

To be able to recognize their brands, need create a list of identification of unidentified brands.

Example for my data identification of unidentified brands
Processing to price list
Processing to price list

Create the table ART_ID of parts for my price list. On the way out we have two files : 1. Table with found value ART_ID consonant data of my price list (example http://ttc.bovsoft.com/download/opencart/prays-excel-2007.xlsx.csv). 2. A table with data for parts that are not found value ART_ID (spare parts, which it is not in the database of program for selection of spare parts) (example http://ttc.bovsoft.com/download/opencart/NotFoundData_prays-excel-2007.xlsx.csv).

Program for selection of spare parts (the path to the program)
Processing to price list

From the table, where were found ART_ID for my spare parts, I copy a list of these ART_ID and RELATED_ART_ID to a text file "ONLYARTID.txt". On the basis of this file we can export images, for parts, only that are listed in my price list. Also this file specifying as an additional filter for data export, will provide an opportunity to add to the tables for us only the necessary data
Connect this file ("ONLYARTID.txt") as an additional filter for data export
Connect this file ("ONLYARTID.txt") as an additional filter for data export

EXPORT IMAGES
EXPORT IMAGES

Export needed of images according list ART_ID and copying the exported images in any folder to the hosting

CREATING HTML-PAGES FOR SITE SELECTION OF SPARE PARTS (FOR INTEGRATION IN OPENCART)

CREATING HTML-PAGES FOR SITE SELECTION OF SPARE PARTS (FOR INTEGRATION IN OPENCART)
CREATING HTML-PAGES FOR SITE SELECTION OF SPARE PARTS (FOR INTEGRATION IN OPENCART)

Connecting as an additional filter of selection the needed of spare parts

CREATING HTML-PAGES FOR SITE SELECTION OF SPARE PARTS (FOR INTEGRATION IN OPENCART)
CREATING HTML-PAGES FOR SITE SELECTION OF SPARE PARTS (FOR INTEGRATION IN OPENCART)

Specify needed brands of cars, all brands of spare parts and all trade groups. Add the path to the pictures (on disk) that have been previously exported

CREATING HTML-PAGES FOR SITE SELECTION OF SPARE PARTS (FOR INTEGRATION IN OPENCART)
CREATING HTML-PAGES FOR SITE SELECTION OF SPARE PARTS (FOR INTEGRATION IN OPENCART)

Specify the path to page of search results OpenCart store

CREATING HTML-PAGES FOR SITE SELECTION OF SPARE PARTS (FOR INTEGRATION IN OPENCART)
CREATING HTML-PAGES FOR SITE SELECTION OF SPARE PARTS (FOR INTEGRATION IN OPENCART)

Start the process of creating pages for the site selection of spare parts. On the way out we will have pages where will are only spare parts of my price list availability for these vehicles

example site
CREATING FILES TO IMPORT IN STORE OPENCART (without category, without quantity and price) WITH THE INTEGRATION OF SITE SELECTION OF SPARE PARTS (first created)

CREATING FILES TO IMPORT IN STORE OPENCART (without category, without quantity and price)
CREATING FILES TO IMPORT IN STORE OPENCART (without category, without quantity and price)

Specify needed brands of cars and all brands of spare parts, all trade groups. And specify out all the necessary data (path to image, eg) . Run the export of data for store OPENCART. On the way out we will have a file that can be imported using the Import tool.

Example site (with the integration of the site selection of spare parts)

P.S. Shop (made for examples) works with a remote database and is limited to the use of memory, so that, the possible loss of the generation rate of pages
CREATING A FILE TO IMPORT IN SHOP OPENCART (with category, with quantity and price)

CREATING A FILE TO IMPORT IN SHOP OPENCART (with category, with quantity and price)
CREATING A FILE TO IMPORT IN SHOP OPENCART (with category, with quantity and price)

Specify needed brands of cars and all brands of spare parts, all trade groups. And specify out all the necessary data (path to image, eg) . Run the export of data for store OPENCART. On the way out we will have a file that can be imported using the Import tool.

Example site (with category, with quantity and price)

P.S. Shop (made for examples) works with a remote database and is limited to the use of memory, so that, the possible loss of the generation rate of pages
Speed ​​up site OpenCart store


As you know, the shops on OpenCart differ slow work, which becomes apparent when will
increasing the amount of goods.

Basically OpenCart slow due to the large number of queries to MySQL. Often the cause of
slow performance can be:

- A large number of categories and sub-categories in OpenCart hinders its work;
- A huge amount of goods, usually a few thousand;
- The use of complex filters goods;
- Using VQmod;
- Also, the reason may be a slow hosting with low memory

Let's speed up the work of OpenCart making small changes,
optimizing the number of calls to the database mysql.


For version OpenCart 1.5.1.3, 1.5.2 и 1.5.2.1

find the file
catalog/controller/module/category.php

change it
$product_total = $this->model_catalog_product->getTotalProducts($data);
to
$product_total = 0;

change it
$category['name'] . ' (' . $product_total . ')',
to
$category['name'],

change it
$child['name'] . ' (' . $product_total . ')'
to
$child['name']


In addition to the version OpenCart 1.5.2.1

find the file
catalog/controller/common/header.php

change it
$product_total = $this->model_catalog_product->getTotalProducts($data);
to
$product_total = 0;


change it
'name'  => $child['name'] . ' (' . $product_total . ')',
to
'name'  => $child['name'],


in the file
catalog/controller/product/category.php

change it
$product_total = $this->model_catalog_product->getTotalProducts($data);
to
$product_total = 0;

change it
'name'  => $result['name'] . ' (' . $product_total . ')',
to
'name'  => $result['name'],

in the file
catalog/controller/module/category.php

change it
$product_total = $this->model_catalog_product->getTotalProducts($data);
to
$product_total = 0;

change it
$category['name'] . ' (' . $product_total . ')',
to
$category['name'],

change it
$child['name'] . ' (' . $product_total . ')'
to
$child['name']




For speed up the search for spare parts in store OpenCart
on the page/catalog/model/catalog/product.php that is responsible for searching the entered
number to make some changes :
change search field "tag" on the ability to search by copy "number search", in the original
version of OpenCart is search by pattern "number search"


REPLACE ROWS (IN TWO PLACES)  

$implode[] = "LCASE(pt.tag) LIKE '%" . $this->db->escape(utf8_strtolower($word)) . "%'
AND pt.language_id = '" . (int)$this->config->get('config_language_id') . "'";

TO 

$implode[] = "LCASE(pt.tag) ='" . trim(str_replace(array('_', '-', '-', '.', ',', ' ', '+', '/', '|'), '',
$this->db->escape(utf8_strtolower($word)))) . "' AND pt.language_id = '" . (int)$this->
config->get('config_language_id') . "'";



HOME ABOUT THE PROGRAM SPEED UP SITE OPENCART STORE
 
Back
Next
In connection with the sale of all software solutions, platforms and ideas for the company (CPS Gmb) are replaced to support all services (REGNUM services, development shops and catalogs, providing data preparation services and other services) in this company.

All active customers that are using any online service will use them on the base of previous tariff plan, for new customers it will be according to CPS Gmb tariffs.
Support existing programs (fixing errors, minor update) will still be held by softBOVformat.

Also at this time there is still the opportunity to buy and have the support of any software from the company softBOVformat.
CPS Gmb Company is a young company (2016), but is made up of professionals with more than 5 years of experience, which have developed lot tools and services that used by many large companies.

Another advantage this company that they only use cutting-edge web technology, they yet not have brand marketing mark-up which is used in large companies, and at the moment they do not only supports products that have been created but also constantly developing new products and services.

In this short time they did :

------------------------
- they have access to public databases of license numbers for some countries.
- they use licensed data for tire products and wheel disks.
- they have experience in working with platforms Ebay, Amazon and with some other.
- provide many unique services
- full support service