Tell me more ×
Answers OnStartups is a question and answer site for entrepreneurs looking to start or run a new business. It's 100% free, no registration required.
up vote 0 down vote favorite

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?

share|improve this question
Better suited for stackoverflow. – Pradeep Aug 14 '11 at 19:31
1  
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... Aug 16 '11 at 10:01

3 Answers

up vote 1 down vote

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.

share|improve this answer
up vote 0 down vote

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

share|improve this answer
up vote -1 down vote

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.

share|improve this answer
1  
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... Aug 14 '11 at 14:10

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.