Dynamics GP Ecommerce Shopping Cart Integration Options
Free Online Articles Directory
Why Submit Articles?
Top Authors
Top Articles
FAQ
ABAnswers
0 && $.browser.msie ) {
var ie_version = parseInt($.browser.version);
if(ie_version Login
Register
Hello
My Home
Sign Out
Email
Password
Remember me?
Lost Password?
Home Page > Computers > Software > Dynamics GP Ecommerce Shopping Cart Integration Options
Categories
AdvertisingArts & EntertainmentAutomotiveBeautyBusinessCareersComputersEducationFinanceFood and BeverageHealthHobbiesHome and FamilyHome ImprovementInternetLawMarketingNews and SocietyRelationshipsSelf ImprovementShoppingSpiritualitySports and FitnessTechnologyTravelWriting
Dynamics GP Ecommerce Shopping Cart Integration Options
By: Andrew Karasev
Posted: Sep 27, 2010
]]>
If you have Microsoft Dynamics GP implemented in your organization as Corporate ERP application and now you are looking for phase two, where such nice feature as ecommerce shopping cart is subject for the integration, this small publication is for you. First of all we would like to share with you our believes that ecommerce shopping carts, such as Magento/PHP (especially when you are on Linux), ASP.Net Storefront, Nop Commerce and others, are pretty robust and there is no real need to program shopping cart from scratch internally (until you are really huge ecommerce wholesaler or retailer, where you prefer to have complete control over program proprietary business logic and source code, and have the budget to afford that kind of luxury approach). In our case, we tried to give you ecommerce add-on for Microsoft Dynamics GP (often referred by its historical name Great Plains Dynamics and eEnterprise, in case if you have some confusion with the application name) where you simply follow setup wizard, selecting your ecommerce shopping cart name from drop down list on one of the initial steps. Other steps are specific to Dynamics GP typical integration with ecommerce: settings in Inventory Control, Sales order Processing modules:
1. Ecommerce Shopping Cart Image in Great Plains. It is typically Sales Order Processing Invoice or Sales Order with Customer Deposit in the form of Credit Card payment (especially in B2C scenario, while in B2B scenario you may sell on account, and prepayment is optional). If you plan to allocate Invoice or Order lines automatically directly from the Shopping Cart, you need to specify default ecommerce SOP Document ID as the one with automatic allocation (in this case item line fulfillment happens instantly as ecommerce document is transferred to GP). If you would rather prefer to fulfill the lines via Warehouse Management System/Barcoding on the warehouse floor, then pick document ID where allocation is set to manual. Second important concept is default ecommerce Inventory Site ID — in Great Plains it is important to have default settings to minimize data entry per document. In the case of Sales Order Processing document each one may have default site ID, and if it is specified — each line will be automatically allocated (or assigned for manual fulfillment) from the specified site. Inventory control hosted Site object is participating in the logic is such distribution modules as Sales Order Processing, Purchase Order Processing, Bill of Materials, Manufacturing Suite of Modules, Invoicing (this module however is rather legacy, we do not recommend it for serious consideration in eCommerce implementation)
2. eCommerce and Non-inventory items. For smaller ecommerce retailers, especially specializing in very volatile (changing every week or month) reselling catalogues of items, you may decide to completely abandon such Inventory Control features as Quantity on-hand, returned, damaged, in-service and only track items sold through Sales Reports (based on SOP30200 and SOP30300 tables — document header and line history). If you transform your ecommerce shopping cart document lines into non-inventory items in Dynamics GP SOP — item id is simply capitalized text (or flow of the characters), then description is the combination of Capital/Small letters, digits and delimiting characters, plus there is no pricelist (you must specify QTY sold, price and cost if known)
Read more articles
Microsoft Dynamics GP ECommerce Partner in Chicago
Help with Microsoft Dynamics GP Ecommerce Implementation
Microsoft Dynamics Gp Ecommerce Partner In Los Angeles Notes
Microsoft Dynamics GP eCommerce with Fulfillment on the Warehouse Floor
3. eCommerce integration technology. Our Add-on ecommerce module is based on Alba Spectrum proprietary technology Order Connector. According to our performance tests, Order Connector is more efficient, comparing to Dynamics GP SDK eConnect (both technologies as based on SQL stored procedures, however Order Connector is geared toward light weight Sales Order Processing transaction logic, where eConnect validates 100% of the Dynamics GP SOP business logic, which might contribute to longer stored procedures execution time and in our opinion and taking into consideration the set of processes in ecommerce add-on module — only some of the business logic must be validated, the rest of the logic realm is really optional)
4. What if your organization is in position to sponsor ecommerce shopping cart programming from scratches? If shopping cart is generic ecommerce shopping cart interface compliance, we might be able to incorporate it into our ecommerce add-on for Dynamics GP. If your shopping cart is really complex and proprietary, feel free to call us for estimation. We have really challenging carts integrated in the past, especially in such environments as Linux/PHP/MySQL. Plus there are unlimited options to move proprietary shopping cart document to Dynamics GP via Text or Advanced ODBC connection in Integration Manager. IM is capable to provide you quasi real time integration (every 20 minutes, or you name the time interval), being scheduled in Windows Scheduled Tasks on the Server (there are multiple shareware and even freeware, providing calling Executable program with DOS parameters), the same approach could be called when new ecommerce shopping cart document is triggered as being completed directly in ecommerce application (you can simply call IM with parameters from your ecommerce web application code)
5. eConnect versus Integration Manager. Dynamics GP eConnect SDK is really powerful instrument, initially it was dedicated to ecommerce programmers, to open Great Plains objects and transactions for ecommerce shopping cart integration. In our opinion eConnect became stable and bug free with introduction of Dynamics GP version 9.0, so we do recommend you to try yourself (especially when you are considering yourself as practicing Microsoft Visual Studio C# or VB.Net coder). The best scenario to deploy eConnect libraries, is when your ecommerce website is programmed in Microsoft Visual Studio. In the case, when you are on Linux e-commerce platforms, there are ways to call Windows DLL as well as eConnect methods (stored procedures) indirectly via Linux to Windows bridges, however it might give you too much hard time and learning curve. So, if you are on Linux, Unix, Oracle/Java, IBM DBII platforms, we would rather encourage you to reconsider exporting ecommerce shopping cart into text (tab or comma delimited) file or even cross-platform compliant XML format. Regarding Integration Manager and eConnect performance comparison, you might be aware that Integration Manager for Dynamics GP version 10.0 (and especially current version 2010/11.0, as we are writing these lines in September 2010) introduced eConnect integration connectors, where IM integration is in fact calling the same SQL Stored procedures as if you deploy eConnect libraries directly in your Visual Studio Web Project, so the performance should be comparable
6. Which version is recommended prior to diving into ecommerce integration project? The answer depends on the scope of the project. You might be fine deploying Integration Manager on all the versions of Dynamics GP and even legacy Great Plains Dynamics and eEnterprise: 9.0, 8.0, 7.5, 7.0, 6.0, 5.5, 5.0, 4.0 (please note that Integration Manager works even for such archaic DB platforms as Pervasive SQL 2000/Btrieve and Ctree) . However if you are looking forward to integrate real time ecommerce shopping cart directly from Magento, ASP.Net Storefront or other full-featured shopping cart platform, we recommend you to upgrade to Dynamics GP at least version 10.0
7. Combining Ecomerce with Warehouse Management System and Barcoding technologies. If you are seeking for complete automation, where Shopping Cart is scheduled for automatic fulfillment on the warehouse floor via barcode scanning, we recommend you to consider Alba Spectrum WMS Add-ons for Microsoft Dynamics GP
8. If you are expanding internationally as ecommerce wholesaler or retailer. Here you need to familiarize yourself with such concept as Corporate ERP localization. It typically includes two components: local or regional language support and tax code or local country business regulation compliance (custom code, invoice form, sometimes government approved chart of accounts and how transactions should be posted in GL — good examples are France or Russian Federation). Current version of Dynamics GP is 2010/11.0 as well as version 10.0 are localized for English speaking countries: USA, UK, Ireland, Canada (Including French speaking Quebec province with Montreal), Spanish speaking Latina America, Caribbean basin, Oceania, South East Asia, where English language is in use as the language of business. If you are multinational subsidiary, expanding internationally and your country is not listed here, please consider to give us a call for consultation or consider another Corporate ERP platform for you overseas subsidiary: Dynamics AX Axapta or if you prefer SAP platform — SAP Business One. Also you have to be aware that Dynamics GP Dexterity platform doesn’t support Unicode based languages (typically hieroglyph characters based alphabets, such as Chinese, Japanese, Korean)
9. For further information, please call us 1-866-528-0577, email us help@albaspectrum.com By the nature of our service we are available for WMS implementation USA, Canada nationwide. Local service is available in Western Michigan: St. Joseph, Kalamazoo, Grand Rapids, Muskegon, Holland, New Buffalo; in Chicagoland, North Western Indiana, Southern California (Los Angeles, San Diego, Irvine, Orange County), Houston and Dallas areas of Texas
Andrew Karasev – About the Author:
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving GP customers USA and Canada Nationwide: California, Minnesota, New York, Quebec, Ontario, Illinois, Texas, Georgia, Arizona, Nevada, Virginia, Florida, new Mexico, Iowa, Indiana, Alaska, Hawaii. Local service is available 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
]]>
Increase your traffic today just by submitting articles with us, click here to get started.
Liked this article? Click here to publish it on your website or blog, it’s free and easy!
Rate this Article
vote(s)
0 vote(s)
0) {
ch_selected = Math.floor(Math.random()*ch_queries.length);
if(ch_selected == ch_queries.length) ch_selected–;
ch_query = ch_queries[ch_selected];
}
}catch(e){
ch_query = document.title;
}
]]>
Article Tags:
microsoft dynamics gp, ecommerce
Latest Software Articles
More from Andrew Karasev
Delete Duplicates in iTunes with Automated Software
If you’ve been using iTunes for any amount of time than you’re likely interested in how to delete duplicate in iTunes. It’s almost inevitable that at some point in your digital life you’re going to end up with a ton of different duplicates within iTunes.
By: Jacob King
Computers >
Software
May 24, 2011
Two Monitors to One Computer: Better than a Big Monitor
People can never get satisfied with the monitor screen size and always want to have the largest screen size if budget permit. For those, having multiple monitors instead of a larger one can be more beneficial as it instantly doubles up the desktop space at a lesser price than a larger monitor. It works in the systems based on Windows XP onwards. What you need for this is an additional monitor, connecting cables and some inexpensive hardware like a video adapter to support multiple monitors.
Computers >
Software
May 24, 2011
Runtime Error 183 Fix Tutorial
Runtime Error 183 is a specific error which is linked to Adobe Acrobat, when you open this program. The error which you may receive when you open Adobe Acrobat is going to be something like this: “Runtime Error 183: Unable to create the temporary folder”
By: Joe_Hilton
Computers >
Software
May 24, 2011
While typing we tend to slouch in our chairs which is a very wrong practice keeping your back straight and maintaining a upfront posture leads to greater efficiency and a healthy life in the long run.
By: Julie A. Ritch
Computers >
Software
May 24, 2011
“STOP” errors are a very serious matters when it comes to computers because it means something drastic happened which shouldn’t have happened and it has caused your system to stop everything it is doing and focus all of it’s attention to the error at hand. The reason it does this is because it had to stop whatever was happening in order to save your system from total collapse.
By: Joe_Hilton
Computers >
Software
May 24, 2011
Dynamics AX Development Projects with Consideration to Version 2012
Microsoft Dynamics AX customization work might be getting special leverage from the opening of MorphX Metadata in such tools as Microsoft Visual Studio
By: Andrew Karasev
Computers >
Software
May 23, 2011
Dynamics AX Flexible Implementation with International Aspect
Microsoft Dynamics Corporate ERP family of products includes several applications where certain percentage of business functionality is duplicated. Certainly each one has basic accounting features, such as General Ledger, Accounts Receivables and Payables, Inventory.
By: Andrew Karasev
Computers >
Software
May 22, 2011
Dynamics AX Implementation Notes
If you are in the new Corporate ERP application selection mode, we would like to make some observations about AX, formerly known as Axapta. In our opinion you should start with categorizing your firm as upper mid-market, or smaller organization.
By: Andrew Karasev
Computers >
Software
May 21, 2011
Dynamics AX Customization Technology Shift in Version 2012
This version should be released later in 2011 and we would like to share our discovery as software developers and integrators. Traditionally programming in Axapta and Dynamics AX was done in X++ in MorphX Integrated Development Environment.
By: Andrew Karasev
Computers >
Software
May 20, 2011
Dynamics AX Customization Readiness: Fresh Air about Version 2012/6.0
First of all we would like to mention that in this new release AX is open for Public Sector and Fund Accounting. This is in addition to its tradition industries, such as Manufacturing (both process and discrete), Distribution, Retail, Service (including Media, Entertainment, Professional Services).
By: Andrew Karasev
Computers >
Software
May 19, 2011
Comments on this article [0]
Add new Comment
Related Videos
eMarketer’s Noah Elkin on Mobile Commerce Trends
Custom Ecommerce Solutions Tips
Ask a question
Ask our experts your Software related questions here…
200 Characters left
Related Questions
Does paypal have a shopping cart ?
]]>
Related Articles
Microsoft Dynamics GP eCommerce: Sales Order Processing integration and Autoposting
ECommerce Integration Add-Ons for Microsoft Dynamics GP
Microsoft Dynamics GP Support: What is Possible and What is not possible in Remote Support
Integrated eCommerce and WMS for Microsoft Dynamics GP
ECommerce Programming for Microsoft Dynamics GP
Dynamics GP Ecommerce Programming and Integration Notes
Need Help?
Contact Us
FAQ
Submit Articles
Editorial Guidelines
Blog
Site Links
Recent Articles
Top Authors
Top Articles
Find Articles
Site Map
Mobile Version
Webmasters
RSS Builder
RSS
Link to Us
Business Info
Advertising
Use of this web site constitutes acceptance of the Terms Of Use and Privacy Policy | User published content is licensed under a Creative Commons License.
Copyright (c) 2005-2011 Free Articles by ArticlesBase.com, All rights reserved.
Originally published here.