SBOeConnect - A Revolutionized way of Integration between Magento e-commerce storefront & SAP Business One ERP. SBOeConnect is the flagship product of InSync, InSync is an SAP -SSP Partner focused at providing value added product and services on e-commerce and ERP domain. The idea behind creating SBOeConnect came from the gap identified in the marketplace where there was a lack of integrated ecommerce platform which could meet requirement of a growing store.
Released Posted on December 7, 2012 :
SBOeConnect, Integration Connector between Magento eCommerce and SAP Business One ERP system, offering more than 60 Fully Automated Integration Points, now enriched with new features with the introduction of SBOeConnect 2.4. This article depicts a brief insight of these amazing new Dynamic Features.
Guest Customers: As we know in SAP Business One ERP system, defined records of Business Partners (Customers) can be added. However in this competitive age of eBusiness, it has been seen that more than 40% Checkouts at shopping carts are Guest Checkouts. Previously SBOeConnect sync the Guest Checkout Web Orders to SAP Business One system. But now with the SBOeConnect 2.4, Guest Customer’s details can be recorded in SAP B1 B.P Master Data with a different B.P Code. Business Owners can easily track the Guest Customers from their ERP system and can plan further marketing activities for Repeat Sales.
Website wise Customer Group Specific Pricing: Magento supports Customer Group specific pricing through ‘Tier Pricing’ feature. Different Customer Groups can have different pricing structure of the same item. SBOeConnect 2.4 added one more layer in this feature to support Multiple Websites. Now One Item can have different price in different website for different Customer Groups in Magento. SAP Business One Pricelists will be mapped with Magento website and Customer Groups to provide this feature.
Multilingual Product Description: Magento supports multilingual Product Description through multiple Store view. SAP Business One from 8.8 onwards support Multilingual Product Description in Item Master Data. SBOeConnect 2.4 mapped Magento Store view with SAP B1 Item Master Description field. So moving forward any ERP Item uploaded to the web having Product Description in multiple languages, same settings will be automatically created in Magento. This feature will support Business Owners to launch same website/products in several geographic and in different languages.
Support for Virtual Product Type: eBusinesses dealing in some sort of Service (for example- Telecom) through Online Store, generally use Virtual Products in Magento. In simple words Virtual Products do not require inventory maintenance. SBOeConnect 2.4 now offering a full mapping facility of Non-Inventory Item of SAP Business One with Virtual Product Type of Magento. So moving forward SBOeConnect becomes suitable for eBusiness dealing in Service.
Payment and Transaction Management: SBOeConnect 2.4 will sync back Payment Method from Magento to SAP Business One in Sales Order. So SAP B1 Users can easily track through which Payment Method the Order has been placed in web. In case of Online Payment in Magento, Online Transaction ID (If Returned from the Payment Gateway to Magento), will sync back to SAP B1, so business owners can track their payments with Bank.
Incoming Payment: Incoming Payment document are often associated with the Invoice in SAP B1. This is a financial document which is very important to Accounts/Finance department to get a clear picture whether or not the Invoice has been paid. Now with SBOeConnect 2.4, against successful web transactions in Magento, Incoming Payment will be generated in SAP Business One.
Discount Coupon & Gift Certificate Discounts: Now a Days Discount Management is one of the key to success in eBusiness. Repeat Sales increase through the use of Discount Coupon and Gift Certificate which visitors can redeem at their checkout process. SBOeConnect 2.4 fully supports synchronization of these discounts to SAP Business One Sales Order and maintains same order value both in eCommerce and ERP systems.
Web Order Approval Process: In an eBusiness which follows Order to Make (For example Gift Items, Jewelry), validating web orders are really important. So for those Business Types, SBOeConnect 2.4 provides a facility of syncing Web Orders as Draft Sales Order to SAP B1. SAP B1 users will be able to see Alerts against these Drafts and can validate the Order before converting it to a Sales Order for Production Process.
Sync Orders as per Chosen Web Order Status: Magento supports different Order Statuses for different stage like ‘Pending’, ‘Processing’, ‘Shipped’, ‘Complete’, ‘Cancel’, on top of that there can be custom Order Statuses too which can be defined. With SBOeConnect 2.4, Business Owners can choose which Web Orders will sync back to SAP B1 through a Dynamic Mapping screen.
Multiple Warehouse Management: Set a particular warehouse to fulfill all your web orders, set Location Specific Warehouse which can be mapped with multiple websites of Magento where each website is targeted for different region, Set Multiple Warehouse to get a combined Product Inventory in Magento, all these Warehouse Management Process are supported in SBOeConnect 2.4 between SAP Business One and Magento. So now Sales Orders can be fulfilled with more effective planning and Stock Management becomes flexible.
Currency Symbol Mapping: SBOeConnect 2.4 offer a currency symbol mapping facility between Magento and SAP B1, this will eliminate the chances of error in Order Synchronization and sync proper order value with currency conversion as and when required.
License management system is implemented in SBOeConnect 2.3. No. of connections (one connection comprises of one SAP B1 company & One Magento website) created will depend on the no. of licenses acquired by the user. Every synchronization process will take place as per the selected connection(apart from Master Data synchronization which will remain same for all connections).
SBOeConnect manager’s Server configuration section UI has been modified: it has been divided into four new sections-Register License Key, SAP Connection, Magento Connection, Map Connection. “Select Connection” link has been introduced instead of SBOeConnect logo in the left panel of SBOeConnect manager, to select an already mapped connection.
A new field has been introduced in SAP B1 Business Partner Master Data’s Address section named Telephone No. This field will be used to synchronize the telephone numbers of billing and shipping addresses.
Service control UI has been modified with the introduction of a new form in the same section-Select Connection Priority; by using this priority for each connection is set for service to work.
System Configuration UI section in Magento for SBOeConnect has been provided from where the following configurations can be managed: number of customers downloadable, number of products downloadable, number of orders downloadable.
1. Processes introduced in this version:
a. Web site wise price for Products including Simple, Configurable and Group products.
Price of a product will be assigned according to website in Magento & the product will be downloaded against a defined price list (based on value mapping for the same) in SAP B1
Similarly price of a product will be assigned according to pricelist (which is mapped to corresponding website in value mapping form) & price will reflect in the corresponding website after the product upload is complete.
b. Special price can now be updated Web site wise:
Special price (assigned against certain pricelist) of a product can be updated according to website in Magento. Mapping of price list & Website can be configured in value mapping from.
c. Configurable Prefix-Postfix for business partner :
From now onwards we can configure the web code of business partner by providing custom prefix and postfix in the field “Web Code for customers” in General Setting form.
d. Sales Order can now be downloaded as Draft or Sales Order
A new field named Download Sales Order As has been introduced in “General Settings form“. On the basis of the option chosen we can download the order placed in Magento in “sales order” format or as a “draft”.
e. Image download is now available for all kinds of products :
Now Products can be downloaded with three types of images including, thumbnail, gallery and base image.
f. Addition of a new attribute “Sap-Sync”:
A new attribute named “Sap-Sync” is available and it will help us to track and reset the products that need to be synced.
We can change the value of this attribute for a given product from the admin section.
A similar attribute named Sap-Sync is also available for Customer as well as Order. However we can reset it from the Magento database.
g. Multiple Address Download:
More than one address can be downloaded from Magento to SAP B1 and will be stored as multiple shipping addresses in SAP B1.
h. Upload items based on predefined Item Group :
We can now choose the item groups from the general settings form.
Items belonging to the selected item groups will be uploaded from SAP B1 to Magento.
i. Introduction of “Customer Gender” and “Federal Tax Id”:
Two new fields named, “Customer Gender” and “Federal Tax Id” have been added in Business Partner Master Data to select the gender of Business Partner and input the Tax Id.
j. Choice for Cancel product upload:
A new option has been introduced in General Setting by which one can choose whether he wants to upload a Cancel product or not.
1. New web services introduced for following processes:
a. Simple Product download
b. Configurable Product download
c. Group Product download
d. Bundle Product download
1. Performance improvement:
There has been a huge improvement in the overall performance of the product. We can now download and upload huge amount of data from SAP B1 to Magento and vice versa within a less amount of time.
2. Log management introduced in all the process:
Log is available for all the processes which help us to find out the details of the errors and sort them easily.
3. Installation/Uninstallation of SBOeConnect Service is now easier:
Now we can install or uninstall SBOeConnect service even if I don’t have administrative rights.