Link to home
Create AccountLog in
Avatar of movieprodw
movieprodw

asked on

MySQL website to/from SQL in store

Hello,

I run a magento storefront and my client asked if I could connect the website to the in store sql db to pull inventory and send orders to.

I am not familiar with how to do this and I am thinking that I could run a cron to send a csv file to a location on the website then tell the customers computer to pull that file and import it into the SQL server they have locally?

I would have to map the fields while doing this.

On a difficulty scale how hard would this be? I can easily have the file dumped to a folder no problem and can use php to map the fields but how to I get that file to their local sql server?

Matt
ASKER CERTIFIED SOLUTION
Avatar of sachiek
sachiek
Flag of Singapore image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of movieprodw
movieprodw

ASKER

thx