Sage php mysql integration via XML..... Fun!

I wanted to get everyone's feedback on whether this made sense.
(See attached database.pdf)

Thanks,
Casey...

Exactly, I want to figure out a way to NOT use SAGE for ecommerce programming. It's good at accounting, but....




Thank you! That sounds perfect. Almost too easy. I sent my proposal to a couple of development firms and they were terrified of the MAS200 interfacing. Maybe I just wasn't all that clear.

Two more questions. Could I do the opposite (say I wanted to update the qty on the site)?...

Sage is an ERP. We have it set up on a SQL server locally. I do NOT want to host the commerce site locally (we get knocked offline a lot.) In fact, I want the ecommerce site to have as little to do with Sage as possible....

I currently have Sage MAS200 SQL (with eBusiness and full support) and looking to launch a consumer ecommerce site. I also have an old website (we took it offline to focus on distribution) written in ASP. The site is from 1998. We now want to launch a new site. I was thinking of running the whole consumer site on PHP/MySQL, but willing to consider ASP.NET. I have the following questions:

1) What is the best way to integrate the...