Dynamics GP with Well-known Shopping Carts Magento, ASP.Net Storefront

If you are committed to a single of the common ecommerce shopping cart platforms, such as Magento/PHP/Linux, or ASP.Net Storefront, we recommend you to keep your existing ecommerce internet site application.  There are various options to integrate significant shopping carts to such Corporate ERP application as Microsoft Dynamics GP.  We would like to go over them in this small paper.  Before we go there, we would like to give you a suggestion, that perhaps searching very desirable so-referred to as “turn-crucial” ecommerce solutions may well lead you to the complete abandoning of your prior investments in custom ecommerce programming.  Plus there may be concerns about how turn-key answer preserves your historical data: paid shopping carts, buyers, things, historical promotional pricing, and so forth.  Let’s now move on to the paragraphs:

1. Custom shopping cart integration.  This could be the greatest method if you are huge organization with high volume of ecommerce shopping cart transactions per day (let’s say numerous thousand).  If this is your case, please review the choice to do eConnect SDK programming in MS Visual Studio to integrate your transactions with Dynamics GP Sales Order Processing Invoices and Sales Orders with Client Deposits (in the type of Credit card payments, if you do not sell on account, otherwise you might send out buyer statements in mail or email them in PDF format directly from Dynamics GP).  If your ecommerce is on Linux platform, you can nonetheless attempt econnect, by calling its encrypted stored procedures by means of MySQL to MS SQL Server ODBC connection.  We also saw effective Linux/PHP custom ecommerce shopping cart integration by way of Microsoft Dynamics GP Integration Manager, exactly where on Dynamics GP SQL Server personal computer Windows scheduled job was set to fire the integration every twenty minutes (this was implemented on Dynamics GP version 10., and we think that Integration Manager is a way far more more quickly on Dynamics GP 2010, exactly where more eConnect connectors had been introduced for IM).

 Also, if you are on non-Microsoft platform with your ecommerce shopping cart, such as Oracle, DBII, Btrieve, we suggest you to contemplate simplified version of eConnect, which is Alba Spectrum Order Connector, exactly where the set of SQL Stored Procedures is actually little and it is not as well complicated to call few of them with just numerous parameters

two. Ecommerce items.  Each product has to make a compromise on keeping your legacy ecommerce net application and switch part of its business logic to the ecommerce product.  eCommerce items for Microsoft Dynamics GP or virtually any other ERP or MRP application are genuinely excellent, when you are starting from the ground zero (just got venture capital, exactly where choice makers ordered your business to launch ecommerce presence).  However, for the rest of us, and this is typically the most common circumstance, we currently have at least a number of years of existing ecommerce shopping cart application in production.  Having stated that, lets still give the items a attempt

three. Ecommerce Add-On for Dynamics GP, created as a connector.  Let’s assume that we are integrating Magento Shopping Carts into Great Plains Sales Transactions.  Here, we want to know what is our default ecommerce warehouse (inventory site in GP terminology).  Second question is what is our ecommerce invoice document variety ID in GP SOP module.  Next query is  - do we need automatic inventory allocation per SOP line, or we would like to delay allocation and do it on the warehouse floor by way of laser barcode scanning (Warehouse Management System).  These are some of the dilemmas in designing ecommerce add-on product for Dynamics GP.  In Alba Spectrum we think that we located balanced resolution, where you can integrate your existing internet web site and shopping cart in wizard driven manner

4. Yet another very good words paragraph on Fantastic Plains Integration Manager in shopping cart integration scenarios.  Integration Manager validates organization logic and does not let you to compromise information integrity.  This may well sound like a bit abstract and philosophical statement, but it is genuine if you already have experience in recovering and fixing Corporate ERP data directly in SQL tables (for Fantastic Plains Accounting for DOS, Great Plains Dynamics on Pervasive SQL/Btrieve or Ctree).  In our opinion the most harmful selection is to use direct SQL information feeding (through Insert statements in SQL Stored Procedures).  Again Integration Manager could be scheduled to run each and every X minutes and this signifies it is compliant to ecommerce shopping cart quasi actual time integration standards

five. Dynamics GP ecommerce on the international market place.  If you function for multinational corporation, where Dynamics GP is implemented in its headquarters, it is generally very good concept to expand the very same Corporate ERP application to foreign subsidiaries, particularly in such international regional markets as China, Japan, Brazil, Russia, India, Europe, Australia , South Africa, Latin America.  However this is not that simple.  Microsoft Dynamics is obtainable Worldwide, but in some nations you might have Wonderful Plains, in other Axapta (plus Navision, particularly in Europe or in historical trend, plus of course Solomon, even so we did not see substantial number of booth, in proportion comparable to GP and AX on Microsoft Convergence 2010 in Atlanta)

six. eCommerce and Excellent Plains Dynamics historical versions.  Our recommendation is to upgrade to at least Dynamics GP ten..  eConnect and most of the ecommerce add-ons for Fantastic Plains are not compatible with Pervasive SQL 2000 and Ctree database platforms

7. To request support contact, please get in touch with us 1-866-528-0577, help@albaspectrum.com We require to talk about your cards in order to recommend you the best solutions, which is not contingent to our preferences.  We serve you USA/Canada nationwide through remote help (net sessions and phone/skype conferences).  Local service is offered in Western Michigan, Chicagoland, Southern California (LA, Orange County, San Diego), Houston region of the state of Texas

Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com support@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving GP consumers USA and Canada Nationwide: California, Minnesota, New York, Quebec, Ontario, Illinois, Texas, Georgia, Arizona, Nevada, Virginia, Florida, new Mexico, Iowa, Indiana, Alaska, Hawaii. Regional service is offered in Houston/Dallas: Richmond, Rosenberg, Katy, Galveston, Sugar Land in Chicago: Naperville, Aurora, Plainfield, Romeoville, Batavia, Downers Grove, Schaumburg, Rockford, Elgin, Crystal Lake, Joliet, Hinsdale, Lisle, Montgomery, Oswego