1.2. What Type of Connection to the Online Database to Choose

In this article, you will get to know what type of connection is better to use if you want to connect to your online store via Store Manager.

In a nutshell, Store Manager is a program that speeds up the work with products, clients, orders, and categories in your online store.

Why do you need to know the types of connection?

By choosing the right type of connection you can overcome an issue or access restriction to the database of your store established by your hosting company .
You can make your work much faster by establishing the optimal type of connection.

Let’s see how a standard online store works.

You should save all your products, registered customers, orders, categories into a database to see them in the online showcase of your store. Our program works with this database.

Store Manager allows working with three types of connection to a database. Let’s see the main pros and cons of every type.

Direct Connection

Direct Connection - the type of connection that links Store Manager to the store database directly.

This is the most convenient and fast type of connection.

Advantages:

You will see everything you’ve changed in your online store instantly.
There is the possibility to work with the store in groups up to 4 people without any conflicts with data.

Disadvantages:

Every accidental modification will be instantly applied to the store database. Unless you have database backup, there’s no way to undo changes.
It’s necessary to have direct access to a database on a server. Some hosting companies forbid these connections by default. But don’t worry - for these cases, there are Bridge connection or Module Connector.
The speed of direct connection depends on the speed of your internet and server power.
A bulk import to your store, for instance, 100 000 of products, will be slower than with the Bridge Connection.

PHP Bridge Connection

By executing "Get Data from Web", you get a local copy of your store database. All operations are performed locally, so you’re kind of protected from accidental deletion or other critical change. When you're done, you need to post (synchronize) all changes from the local database to your store.

How does it work?

Store Manager uploads one small PHP-file to the website of your online store through FTP. This is a kind of dispatcher that transmits data from the program to the database of an online store and vice versa.

For this type of connection, you need to synchronize changes between your store and computer manually.

This pattern works this way:

Received data from the store.
Changed data (any information)
Send data back to the store.

On the one hand, this type of connection will slow down the work process with the store. But on the other hand, this is its advantage. In this case, should you import to your PC and damaged a database, your online store won’t be damaged, because you won’t send changed data back to the store.

Advantages:

This type of connection works in situations when the direct connection is not possible.
There is the possibility to turn back if you made a mistake during your work with the store. Do not send data to the store by pressing POST, just get the latest version of the store with the GET command.
It also speeds up the import of products or other bulk operations upon a large amount of data.
You can also work offline and apply changes to the store later when an internet connection is available.

Disadvantages:

If someone else is working with the same store and modifies the same kind of data (orders, products, etc.), you may not be able to apply the changes you’ve made.
You need to get data for editing and send it back to renew the online store after changes were made.

Module Connector

To begin working with the online store, you should install our module (Connector) in your Admin panel (store back-end). After that, you'll work with databases through this module.

Advantages:

A safe connection - all requests go through the module of the online store.

Disadvantages:

You should have a powerful server, which can process the request with API, to work with the module.
You have to receive data from the store and send it back right after modifications were made (similarly to the bridge connection).

In conclusion, let’s see in what cases what type of connection is better to use.

Instant product editing - Direct Connection (everything you’ve changed in the program will be visible at the store instantly).
Import of a great number of products - Bridge Connection (data is gathered from the store into your PC and is changed locally).
The safest connection - Connector Module (it works only via the store module).
Product editing offline - Bridge Connection (this is relevant for the existing products or categories).
Cancelling of changes in the database - Bridge Connection (do not send changes from PC to the online store)