Doubts about database access

[jorge.rodriguez.cros]

Hi all,

 

I am new to Prestashop, I am considering creating a shop using it and I have a doubt that I would like to share. I'd be really grateful if anyone can help me.

 

I am a developer that needs to create an online shop for a client. One of the requirements of the client is that he needs to be able to update the stock in the online shop from the physical shop's system. Therefore I need to create a process that will update the online shop's database with a file that will be copied from the physical shop's system using FTP. Is this possible at all using Prestashop. 

 

What's more, I will need to have access to the Prestashop database as an administrator in order to implement this process, but I have read somewhere that this is not possible using Prestashop. Is that completely impossible even if I download the development package and implement my own shop? 

 

Thanks in advance,

 

Jorge Rodríguez

[Dh42]

Prestashop has a web service api that you can use to update stock, you should look into that. 

[jorge.rodriguez.cros]

Thanks a lot for your reply Dh42, but my problem is that the physical shop's system is from a differente provider. I have contacted them and trasnferring the file and writing to the database is the only solution possible for them. Do you know is this is possible somehow with Prestashop?

[Dh42]

There are no problems updating prestashops database from outside of prestashop. I guess if I was you, I would write a script that took the file output by the other program and inserted it into the database. I think something like this would be easiest written in just php and by passing prestashop totally. 

[jorge.rodriguez.cros]

Ok, thanks a lot for your help, Dh42!!!!