Plugin for SAP Business One and ecommerce website


A company needs to connect an ecommerce website with their ERP SAP Business One, the idea is to give a real stock to the persons that search on the product catalog. We should consider to have online information like:

- Product Catalog
- Stock
- Customer Catalog
- Sales
- And any other table that involves the sales process.

I wonder if we will need to hire an expert on SAP or  there is any plug in to connect SAP and the ecommerce.

Thanks in advance.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zephyr_hex (Megan)DeveloperCommented:
I'm not aware of a plug-in, so you are probably looking at a custom solution.  You don't necessarily need to hire an SAP expert if this is a one-way data display (i.e.  you are not sending data to SAP, only showing data).  The Business One database is a not a very complicated structure, especially if you are just wanting to display stock of an item (which would involve two tables:  oitm and oitw).  

NOTE:  If you are looking for two-way interaction with Business One, where it's not just showing data but updating data, then you must get an SAP expert.

But I'm assuming that's not the case.  It sounds like you're looking for data display, not updating SAP data.
If you have an existing web site, I would look for someone who is familiar with that technology, so that your new functionality fits with your existing website.  Make sure the person knows SQL, and how to properly implement a search on your data without risking SQL Injection attacks.

Also consider whether or not viewing this information should require a login (do you want your competitors to see this info ?).  If it needs to be secure, make sure the person you hire knows about how to secure your information.

So, in sum, I'd recommend you look for a web developer expert who's familiar with whatever language your current website uses, and familiar with SQL and web security.  Anyone who is good at SQL will be able to easily query your Business One database.
dimensionavAuthor Commented:
HI zephyr_hex

NOTE:  If you are looking for two-way interaction with Business One, where it's not just showing data but updating data, then you must get an SAP expert.

Yes, we are looking for two-way interaction, we want to create in SAP a new  invoice every time the customer do the payment and we want to allow the creation of new customers too.
zephyr_hex (Megan)DeveloperCommented:
The you will need to go with someone who knows Business One development.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.