osCommerce creation Site with POS Point of System link

I need to create an osCommerce site on a different server that will link to a POS (Point of System) database on another server. Does anyone have any suggestions on how to do this. Is there a program that I can use to make this any easier. At this time I don’t know if the database is MS SQL or MySql. Either way I need to be able to link to that database to create the osCommerce site. I am new at this. I have done some HTML and Joomla sites. If you have any suggestions please let me know! Thanks :confused:

The easiest solution is to forget about OsCommerce and just run a script or program on the server to sync the databases. This solution would be completely independent of any POS or cart software.

You would need it to grab all the data from one system and map and import the data it into the other on X interval. This can be done through some software solutions depending on your server OS or through any server side language. You can then build an action in the OsCommerce admin to run this script manually if needed or setup a cron job to run automatically (keep in mind Linux cron jobs are notoriously unreliable).

Thanks Gibberish, I will try to take your advice. I guess a new question is what scripting language to use. Maybe that’s a basic question, but like I said I am new at this and have only done some HTML, CSS and some basic CMS stuff. I do appreciate your help and would love some more of your advice.

Since you are running OsCommerce I would stick with PHP. This type of sync takes intermediate to advanced knowledge in PHP.