Dynamics GP Shopping Cart Integration in B2B and B2C ecommerce scenarios

First of all, we would like to stress, that in our believe popular ecommerce shopping cart platforms have quite a large number of installations in USA and internationally (they are pretty solid with most of the bugs detected and fixed with direct customer support from the original software development companies) and we discourage you to do custom shopping cart programming. We also believe that customers with existing ecommerce web application do not like the idea to trash the ecommerce website and redeploy it on another product base – we respect that position and we would like to help you on getting existing ecommerce site integrated with your ERP application, in our example it is Microsoft Dynamics GP:
1. Where shopping cart goes in Dynamics GP? The most natural way is to transform shopping cart into Sales Order Processing Sales Order or Invoice. If you are mid-market or large ecommerce wholesaler (B2B) or retailer (B2C), we recommend you to select SOP type for ecommerce integration with manual line items allocation, as you would likely need to fulfill the Order on the warehouse floor with Picking and Packing with Barcode scanning, please see Warehouse Management System section below on details. If you are selling with full or partial prepayment (customer credit card) – it is Customer Deposit against Sales Document
2. eCommerce module from Alba Spectrum. Here you have wizard driven installation and setup, our goal is to open ecommerce integration for you in the matter of few hours, where you pick ecommerce shopping cart platform from drop down list, select default ecommerce warehouse, SOP Type and reasonable number of additional settings. Ideal solution for B2C ecommerce, in B2B scenario you need more control over Customer specific discounts and pricing – we have features in the integration for B2B as well, but you may expect additional programming and modifications
3. Alternative low budget way of eCommerce integration. If the number of ecommerce transactions per day is low or moderate (let’s say less than twenty or even one hundred) and ecommerce customer doesn’t need immediate access to the order status, we suggest you to consider ecommerce shopping cart integration to Dynamics GP in Quasi real time (every hour or another small time interval). If this is acceptable in your ecommerce B2B or B2C trade – consider doing shopping cart integration to SOP Sales Document via Great Plains Integration Manager. We have case study when computer parts ecommerce retailer deployed IM with custom PHP/MySQL based shopping cart to fire every 5 minutes, where Integration was called by one of the scheduled freeware Windows macro type of programs. If you do integration manager, we can call us for help, and eCommerce website development agency if you do it on your own, we recommend you to consider IM Source to be chosen as Advanced ODBC, where you can pull transactions directly from ecommerce website database (you are not limited to Microsoft SQL Server, MS Access, XML or Text file – Advanced ODBC is possible in cross-platform scenarios, where shopping cart data resides in Oracle, Ingress, IBM DBII, Lotus Notes, Pervasive SQL, Ctree, MySQL and other ODBC open DB platform)
4. Warehouse Management System add-on for Dynamics GP. WMS opens Dynamics GP Sales Order Processing, Purchase Order Processing and Inventory Control (with additional components also Bill of Materials and Manufacturing Suite of modules) for Barcoding technology. Typical Warehouse Management System business logic includes Customer Order Fulfillment, Inventory Restocking and Inventory Transfers and Adjustments (including also Cycle Count, which is in essence mass adjustment). Alba Spectrum WMS has Server and Client components. WMS client runs directly on your Barcode scanner operating system and LCD screen. The client talks to WMS Server via wireless connection or RFID to pull info about existing Sales Orders/Invoices, POP Purchase Receipts and Inventory transactions. WMS Server is typically Windows computer, connected to your wired network (Level 5 Ethernet cable, Fiber Optic or even wireless, if the WMS transaction level is low) and talks to Dynamics GP DB Server via ODBC connection