I am building an oscommerce site that will need to "talk to" an already functioning SAP Business One Database. Both run on MySQL.
This is for the functions of:
1) Update inventory in stock from SAP B1 to OsCommerce
2) Process orders for shipment from OsCommerce to SAP B1
3) Update accounting records from OsCommerce to SAP B1
Here is a link to the SAP Business One product site: [url removed, login to view]
An alternate solution would be to create a custom database (similar to OsCommerce) that connects directly to the software for seamless integration.
The purpose of the project would be to present stock available for purchase based on the pricing structure and current inventory of the SAP B1 software.