We are trying to look for a way to get the stock levels from Sage and into the website.
I'm aware that Sage works on SQL, so I guess we would need some PHP script to connect through a firewall, into the Sage database, pull out the manufacturers code & stock level and then pass this information into the website MySQL database, using the manufacturers code as the common reference.
This script would need to run say every 5 minutes so that the website stock levels are 'live'.
Has anyone done this, or can anyone suggest a suitable PHP script, or any information?
