Is there any robust software solution that could integrate an ecommerce site and a physical point of sale?
My father has an established small business in a specialized industry. He's asked me to help him design a website that would take his catalog online and allow orders through the website. I think this has great potential, as none of his competitors have anything similar.
My first hurdle is integrating a new online ordering/inventory management system with the existing one. He's using Sage Businessworks for inventory management, customer information, and point of sale. Businessworks has no API, and no way to write to the database except by using the application itself.
Is it preferable (or even tenable) to make the website order-taking process "manual", that is, the order is received, an employee confirms that stock is on-hand, and inputs the transaction through the existing point of sale and sends a confirmation email to the customer?