Category: Ecommerce

Microsoft Dynamics GP to Shopping Cart Integration in B2B and B2C scenarios

If you already have the site e-commerce platforms to popular e-commerce shopping cart, such as ASP. Net Store Front or Magento / PHP in the business-to-business or business-to-client models, we want to put highlights on the integration of Microsoft Dynamics GP or Great Plains as ERP and medium-sized corporate application was initially unknown. First, we want to stress that have to think in our popular platforms E-commerce shopping cart quite a large number of institutions in the United States and abroad (they are pretty solid with the most bugs discovered and corrected by direct customer support of the original software development company ) and we advise you do not want to put in custom programming. We also believe that customers are not with existing e-commerce web application like the idea about e-commerce website and switch to a different raw material waste – we respect that position and we would be happy to help you get e -commerce site with your existing ERP application integration, in our case it is Microsoft Dynamics GP:

1. If basket is in Dynamics GP? The most natural way is to convert customer orders in a basket order or invoice number. They are mid-market or wholesaler of large e-commerce (B2B) and retail (B2C), we recommend the type of SOPs for the integration of electronic commerce with the elements select online manual assignment, as you probably need in order to fulfill the order on the floor of the warehouse with picking and packing, with scanning bar codes, see section below warehouse management system via the details below. If you sell, with full or partial payment (credit card the customer) – it is strong against second sales order document

eCommerce module Alba Spectrum. Here you will find the installation wizard and configuration engine have is our goal, the integration of e-commerce open for you in a couple of hours, select the e-commerce platform basket from the dropdown, select the e-commerce store by default SOP type and appropriate number of additional parameters. Ideal for e-commerce B2C, B2B in the scenario you need more control over customer-specific discounts and rates – we have the characteristics of B2B integration for a good, but you can expect additional programs and changes

3 Alternative low-budget way of integration of e-business. If the number of e-commerce transactions per day are low or moderate (say less than twenty or even a hundred) and the customer e-commerce does not need instant access to the status of your order, we consider the integration of e-commerce Dynamics GP-shopping in near real time (hourly or other short time interval). Is this acceptable in your e-commerce B2B and B2C Commerce – consider the basket for SOP integration of sales documents through the Great Plains Integration Manager. We case study in computer-parts-dealer e-commerce-chat can be used to add custom PHP / MySQL shopping cart out of the fire every 5 minutes, in which integration was a kind of macro for Windows freeware called programs. If you are responsible for the integration, we can ask for help, and if you do it yourself, we recommend you, your source Instant Messaging as an Advanced ODBC are selected, you can make transactions directly from the base of e-commerce website ( You are not limited to Microsoft SQL Server, MS Access, XML or text file – Advanced ODBC is possible in scenarios cross platform, where the data set is located in Oracle, Index, DBII IBM, Lotus Notes, Pervasive SQL, Ctree, MySQL and other ODBC DB open platform)

4 Warehouse Management System Add-On for Dynamics GP. WMS opens Dynamics GP sales orders, purchase orders and inventory (with additional components of Bill of Materials and Manufacturing suite of modules) for bar code technology. Typical warehouse management system contains the business logic processing of customer orders, inventory and increase transfers and adjustments (including cycle count, for the adjustment of the fuel mass). Alba Spectrum WMS server and client components. WMS client runs directly on your operating system, bar code scanners and LCD. Lectures WMS client to the server via a wireless or RFID gain information on existing sales orders / invoices, receipts POP transactions and balances. WMS server is usually Windows-based computer connected to the wired network (Ethernet cable from Level 5, fiber or wireless, if the transaction low WMS) and speaks with Dynamics GP database server via an ODBC connection

Integration Manager VBA with Modifier, SSRS, Crystal Reports

6 eCommerce legacy versions of Great Plains Dynamics and eEnterprise. If you are the committed version supports most of GP, such as 8.0, 7.5, 7.0, 6.0, 5.5, 5.0, 4.0, we recommend either integration manager of road work (if you on the older version, chances are high that the e-commerce transaction level is moderate or low – IM is for Microsoft SQL Server 2008, 2005, 2000, 7.0, 65 and Pervasive SQL 2000 and based versions Ctree Great Plains ) think, or upgrade to the latest version of Dynamics GP 2010 (sometimes referred to. Version 11.0), if the company uses, and you are ready to assign the Great Plains implementation of the budget. If you are still on Great Plains Accounting for DOS, Windows or Mac: 9.5, 9.2, 9.1 or earlier, we would discourage investment in the integration of e-commerce platform for the ERP Corporate archaic – to consider , upgrade to Dynamics GP 2010 / 11 We do not want you to invest in ERP software, is compatible only seventh with 32-bit platform

How to get more information? Please call us 1-866-529-0577 or 1-630-961-5918 internationally, or email us help@albaspectrum.com If you have special needs, we recommend you send your e-mail when – we will try to meet with case studies and recommendations. The nature of our service module allows us to provide you with e-commerce, warehouse management system and generic support for Dynamics GP USA, Canada, serve, nationally and internationally through sales presentations via Web meetings and phone (or Skype if international) conferences. If necessary, we go there for the first implementation, especially if the hardware installation is required (bar-code scanner, computer WMS server installation, etc.) with the following remote support. We also Great Plains Dexterity Software Development Factory and ready for customization projects Dynamics GP for small projects to Dex with unlimited range. Local walk-in counseling service in Michigan, Illinois, California, Texas available.

ECommerce Web Design – The importance of professional strategy in e-commerce Web Design

Prioritizing the purpose of the introduction of e-commerce website is important in the construction of an e-commerce site! It was different following objectives for the primary purpose, so before you design principle that there must have a primary objective and success.

Every company has its own nature and objectives must want another start for the introduction of e-commerce site as some of the various e-commerce site for branding products and determination of the position in the Internet some of them, as if the specific customer to impress with an attractive design and mood, and an emphasis on the design of the invitation to their physical stores.

For many years, mass online e-commerce sites and thousands of businesses and online retailers are active in electronic commerce, deep roots of electronic commerce can be seen and drawings. For the introduction of e-commerce companies, design compelling e-commerce site is critical for good purpose and priorities. Combination of design skills and planning well-organized e-commerce can do wonders in the field of online presentation of the company and its products. should be smart in such a man in the market E-commerce practices to achieve the desired objectives for a web design eCommerce chip should be three types of business practices, such as:

ECommerce reveal design should uniqueness of the company and produitscompréhension market with its customers ciblesRéalisation show the intended target

eCommerce intelligent design of the reasons for the unique business benefits should that extraordinary offer and how they are presented in order to be effectively administered. Different features and services that helps your business independently in the online competition is a clear communication and fast unique features of the company’s fundamental to good design eCommerce Web site. After mediation the uniqueness of the second method for creating good design their own e-commerce market is to be understood, as are the target customers of the company. Transactional website for the target group should be made is not the right, the content in the context of the customer immediate needs to be designed. Third, consider an important issue for the design of this site should be designed to easily sell, customers, products can easily be purchasing.

When the company technically sound IT practices in website design, then its best to design e-commerce sites clean otherwise it is better, professional services of web design company corporate web design. When a customer visits an e-commerce site, it hardly takes a moment to capture the essence of the site if the e-commerce website is not professionally designed, he can not resist the customers.

While the awareness of all the points discussed above, suggests the e-commerce website design to productive results if not implemented professionally. Professional expertise is essential to learn web design eCommerce success of providers have taken the professional services of web design e-commerce business for a wider use of business ideas and unique concepts.

.

ECommerce Integration Developing for Microsoft Dynamics GP Notes

When you have legacy in-house programmed ecommerce web application in production with shopping cart, credit card payment interface, B2B or B2C items catalogs and promotional pricing – which does the job – likely that you will favor the idea to leave it there and try the way of ecommerce integration connectors to your Microsoft Dynamics GP Corporate ERP application.  Another option would be to try existing ecommerce module (available from various Dynamics GP ecommerce ISV partners, you can make your research or call Microsoft Business Solutions).  Respecting your approach to program ecommerce integration, we would like to offer this small publication, where we are considering several options and ecommerce programming instruments:

1. Batch Mode ecommerce to Dynamics GP Great Plains Integration approach.  Here we assume that you have reasonable low volume of daily ecommerce invoices or sales orders (in B2B ecommerce you may work on Sales Order execution level and then transferring completed order to Sales invoice).  Batch mode assumes that you export your daily ecommerce documents into text files and then run integration manually.  For Batch mode integration we recommend you to deploy Dynamics GP Integration Manager.  If your source files for integration are text files exports from ecommerce web application, then IM is end user friendly and you may decide to do self discovery or call our office for short Integration Manager introduction in eCommerce integration design.  With IM, however, you can try more sophisticated approach, where you pull data directly from SQL Server (MySQL/PHP, Oracle, MS Access) ecommerce database.  IM has Advanced ODBC Data Source, where you can deploy such advanced SQL techniques as Union

2. Real Time eCommerce integration to Dynamics GP.  Real time means instantly, so IM is not an option, you can deploy, however Dynamics GP eConnect SDK.  eConnect allows you to include libraries into your Microsoft Visual Studio C#, VB.Net project, and then call eConnect methods directly from your ecommerce web application.  eConnect in our opinion came to its maturity with Dynamics GP version 9.0 and especially current version 10.0 (January 2010).  We assume that new version of Microsoft Dynamics GP 11.0 will be relying on eConnect technology as well or even with greater emphasis.  EConnect is Microsoft Visual Studio programmer friendly and if you are such a developer, we recommend you to invest your time in eConnect research and self discovery.  eConnect, however doesn’t allow you to post Dynamics GP batches directly from its methods, if you need batch posting from ecommerce application, consider Alba Spectrum Posting Server.  And we would like to make this comment for small and mid-size ecommerce retailers – real time ecommerce integration is often not required and is in essence luxury for the majority of ecommerce community.  Only large volume ecommerce chains need real time integration, so if eConnect training approach seems too unrealistic to you, please continue reading the next paragraph

3. Quasi Real Time eCommerce integration to Microsoft Dynamics GP.  Quasi means almost, and we agree with you, when you say that new customer account setup confirmation with login instructions should be emailed in a second.  You may also decide that charging customer credit card should be instant (technically you are just reserving your amount via credit card processing service, real transfer to your account will happen later).  However, there is no need to integrate ecommerce transaction to your Dynamics GP application immediately, you can do it every hour or every twenty minutes without visible delay for the new or existing ecommerce customer.  If Quasi real time approach seems to be reasonable for you, please review the methods to schedule Dynamics GP Integration Manager to run automatically every half an hour or more (or less) frequently

4. eCommerce Integration Strategies.  Here we recommend you to speculate on which system is master and which is slave.  You may decide to define all your new items, price lists, customers directly in Dynamics GP (master) and then propagate them to your ecommerce application or do it just the opposite, where your ecommerce is master and Great Plains Dynamics is slave.  There are pluses and minuses – obviously GP has matured user interface, where you can create or update your cards and transactions, that are subject to be pushed down to your ecommerce slave application.  But, in some scenarios, you would prefer custom objects with advanced interface in ecommerce to be pushed back to Dynamics GP

5. eCommerce and Dynamics GP, Great Plains Dynamics versions.  As general advise, we believe that being on current version of your Corporate ERP application is a way better, comparing to being on really outdated version.  If you are deploying Microsoft Dynamics GP 11.0, 10.0, 9.0 (where you can deploy eConnect SDK for ecommerce programming), or no longer supported versions of Dynamics GP 8.0 and 7.5, or Microsoft Great Plains 7.0, Great Plains Dynamics 6.0, 5.5, 5.0, 4.0, 3.2 or earlier (including versions on Pervasive SQL Server 2000/Btrieve or Ctree) – we recommend you to update to GP 11 (10) and deploy eConnect or IM on currently supported version.  We also respect the situation, when MBS annual enhancement reenrollment cost might be too high and you have to stick to your legacy Great Plains version.  In our opinion, if you are on legacy version, investment to ecommerce should be very modest.  For legacy GP versions we recommend you to consider Alba Spectrum Order Connector

6. eCommerce to Dynamics GP in International Environment.  We are sitting in USA, but if you are multinational corporation with facilities overseas or in South America, please note that international business rules require compliance to local country tax code and additional regulations.  Microsoft Dynamics GP is available (often used term – localized) in English speaking countries (USA, Canada, Australia, New Zealand, UK, Ireland, South Africa, Oceania), plus in French speaking Quebec Canadian province.  If you plan to deploy ecommerce link to your international facility in such countries as Russia, Poland, Kazakhstan, Brazil, China, India, Continental Europe – we recommend you to make integration to localized Accounting Application (SAP Business One would be good candidate to consider)

7. Please, give us a call 1-866-528-0577 help@albaspectrum.com