Connecting local db with the Prestashop db. Is it possible?

[Dolke]

Hi to all,

 

With this topic I would like to gather all presta people that are in need and developers that can provide us with some commercial and free solutions to various problems regarding import/export functionalists of PS and updating already imported products with some new prices, quantities and other attributes.

 

These days I'm exploring possibilities of newest Prestashop 1.5.4.1 when it comes to CSV import end export functionalists.

 

Although, import tool is included as part of PS core features export function is not present even in the newest version. I explored this forum upside down and search the Google in order to find out why is that, and I concluded that simple export function is not yet developed because such SQL query would be quite complex task as products, categories and other basic types of entries as well as their attributes are not in the same tables. Instead, data is often distributed across the db and in various tables so packing this SQL query into one single module is challenging.

 

At least that's what I found out.

 

I noticed that in the new PS under advanced options tab there is SQL manager tool which I believe represent a way of export tool, yet much more powerful as you are allowed to choose what you would like to export, but on the other hand a little difficult to use for users with little or none knowledge of SQL.

 

I believe this was decision by the people behind the PS in order to create tool with much abilities but that will need some skills in order to be used, as a alternative to commercial export modules that you can find in the prestashop addons directory.

 

I also found 2 modules that are completely free and you can check them out. I think one is made for PS 1.4 but maybe it can work in the 1.5 PS as well. Other is 1.5 module.

 

Here they are:

 

csvexport.zip

storeexport.zip

 

Also you few really good articles that explains using this new SQL manager tool in the 1.5 PS. Here are the links:

 

http://nemops.com/prestashop-export-products/

 

http://dtbaker.net/w...roducts-to-csv/

 

 

There is paid export module with lot of features and really big discussion is going on about it.

It sees that new features are added on regular basis and that support is great.

For those who want to check it out here is the link:

 

http://www.prestasho...export%20module

 

I would like to explain my problem for which I didn't fund solution so far.

 

We are small trading company and we are trading mostly with spare parts for home appliances.

We sell these spare parts only through our retail stores. We have more then 3000 products that we are selling and in everyday business we use domestic ERP software with the database which is already full of all kinds of data, product prices, images, descriptions and quantities.

 

This data is changed everyday. We add new products, prices are changed very very often and sometimes we run out of some products almost everyday and we regain new supplies after a day or 2. Its quite dynamic.

 

Great solution that could save us so much time and reduce possibility for human errors would be if PS db could synchronize with this db in some time frame depending of the settings that are we arrange. Is this even possible because the fact this db is stored on a local computer in our company?

 

This way, whenever we make new entry in our ERP software, make some changes in the descriptions, prices and so on, these same changes would be applied to our live online store in the matter of hours, or in other words, during the next scheduled synchronization.

 

Am I talking fantasy stories here or this can be made?

 

Thank you all in advance

Dean

Edited May 6, 2013 by Dolke (see edit history)

[benjamin utterback]

I'm not sure about linking the local host directly to your live store. I think you should try the PrestaShop Store Manager. It does many of the functions you are talking about within the software. It's also free for 30 days, so you can test it to see if it works for you. Try it out! http://addons.prestashop.com/en/administration-tools-prestashop-modules/2937-store-manager-for-prestashop.html

[Dolke]

Thank you Benjamin, it might save me quite time but so I will probably try it out.

 

Can you just tell me is this thing with connecting local DB with the one on the web server even possible?

[cantcloseaccount]

Great Post Dolke and something I am also interested to hear about! I have a similar setup with less products but more specific pricing and discount levels and country specific pricing.... Would be interesting to hear if this can be done, syncing a local database with the PS database...