SAP Business One or how to Integrate Ecommerce Shopping Cart Computers Articles | January 19 Trenton Cannon Hat , 2012 First of all in order to answer on the question you need to understand your ecommerce nature and technology behind.? SAP B1 is popular small business accounting platform among small and midsize ecommerce retailers
We have seen numerous successful and not successful integration cases and we would like to share with you our experience.? This publication is not intended as technical whitepaper it is rather for managerial personnel and decision makers.? Web portals are often created prior to ERP application selection and it is difficult to rebuild working portal in order to deploy nice turnkey integration solution.? Let?s review the possibilities:
1.?Magento and others canned shopping cart solutions.? These are often seen when you are outsourcing your ecommerce portal to internet provider.? Your provider gives you the ability to create your own catalog with product price, description and supporting pictures.? It also gives you export and integration options in one or several formats.? If you do not want real time integration then it is possible to schedule Data Transfer Workbench with integration based on the text file fire every maybe half an hour to imitate quasi real time data feeding.? If you would like to implement real time integrations please talk to your provider and see if you can deploy connectors available for popular retail ecommerce shopping carts
2.?What if our portal is programmed in-house?? This scenario is often associated with merchant desire to exercise tight control over the source code and provide ecommerce channel which could be branded and not associated with other internet store franchises such as eBay or Amazon.? In this case you are likely building your own cart with seamless integration to your inventory catalog, items and their availability and quantities on hand.? Here you often host Linux server directly in your office with PHP programmed portal and based in MySQL.? If you are midsize company then you should think about the option to deploy ISV solution something like iBolt but you should be ready to allocate budget for the software and software developers training.? This budget is comparably or in some cases exceeds SAP BO software licenses cost.? Unfortunately for small merchants the cost is often too high and then you should consider again Data Transfer Workbench scheduled to do quasi real time carts integration.? It works like this: you export the carts from your portal in the form of text files exactly in the format of CSV templates and then DTW imports them in the form of AR Sales Order or Invoice.? What if we need real time integration triggered by customer credit or debit card payment?? Keep reading
3.?Real time integration might not be as important as you may think it is.? In fact even famous retailers in food Chris Herndon Hat , books, beer and wine ingredients and various spare parts for bikes, motorcycles and used car parts just to open