Integrating Online and Physical Point of Sale


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?

Software Ecommerce

asked Apr 2 '11 at 00:43
101 points
  • Better suited for stackoverflow. – Pradeep 13 years ago
  • I think it fits here well, because it's a business decision not a coding problem. Even though some answers are very technical. – Chris... S... 13 years ago

3 Answers


Your first instinct to integrate with the existing order management system is spot on. For truly joined up online/offline sales pipeline you do need your online orders coming into the same system that handles everything else.

You mention that SB doesn't have an API, but I think you can import orders into the system via CSV files. If you can demonstrate that you can get an order into the system via a CSV file, you can then develop your online order system towards producing CSV files that get imported on a schedule into Sage.

When they get imported into Sage, make sure you flag them as online orders so you can do order reporting segmented by channel.

answered Jul 15 '11 at 18:49
2,333 points


Have you researched Enstore and Checkout? They are Mac-based retail store software and online store solution.

answered Jul 15 '11 at 17:55
26 points


Ideally you should have the ecommerce managing everything and use the ecommerce's catalog even locally. This opens you to be dependent to the Internet connection you have: it must be reliable and have a backup link. I would not use a CSV file, it is primitive, old fashioned and unpractical. You should move Sage to another software of interact with its DB, with is not a good thing (and database should be access from only its own applicaiton). There are softwares managing POS, catalogs and ecommerce, have a look on Google.

answered Jul 15 '11 at 19:51
99 points
  • This advice contradicts both startup and software engineering principles. 1. In contrast I would start small and use CSV files for integration. You cannot know how your online strategy will work out. Migrating your father's business to another IT infrastructure would be overkill and would delay your plans until the migration is finished. 2. As George Hohpe, who is a messaging advocate, states in his book "Enterprise Integration Patterns" file exchange could be a valid integration solution. And today you don't know where your pains will be. So probably "you ain't gonna need it." – Chris... S... 13 years ago

Your Answer

  • Bold
  • Italic
  • • Bullets
  • 1. Numbers
  • Quote
Not the answer you're looking for? Ask your own question or browse other questions in these topics:

Software Ecommerce