Ecommerce Integration Options With Dynamics Gp

Integration method is often depending on where you are maintaining your inventory items, pricing, discounts and credit card processing for the submitted shopping cart. Smaller electronic retailers are typically ecommerce portal implementation price sensitive. They may find it cheaper to deploy existing shopping cart and control merchandise offer and pricing directly in it, sending only minimal prepaid invoice information to their accounting system. Large retailer may prefer to have control over the merchandise catalog in its Corporate ERP application, in our case Microsoft Dynamics GP. In such scenario you have to provide bidirectional integration as you have to lookup available quantities, current prices with promotions, negotiated pricelist for individual B2B customer from Great Plains database. Lets take a look at details:

1.Small ecommerce vendors. We assume here that you do not have legacy ecommerce website programmed in-house, which works out of GP database and coded in eConnect or MS SQL Server stored procedures. The easiest and probably the less expensive way to do the job is automate paid shopping carts export into text file with following scheduled integration via Integration Manager. If you design such an integration structure you likely will be avoiding custom programming related version upgrade consulting expenses. This method works in so-called quasi real time, where you schedule IM integration to fire every hour or maybe even more often. Doing internet purchases however you can realize that order submission Thank You for the Order email is coming in real time next few seconds. But it is send by eCommerce program, not by accounting system. We estimate that majority of the retailers and ecommerce wholesalers selling USA nationwide are deploying quasi real time integration

2.Large eCommerce Retailers. Here you may have the luxury to do custom ecommerce shopping cart coding in your IT department. There is special tool and Software Development Kit eConnect specially created for ecommerce programmers to send shopping carts to GP, retrieve inventory item quantity, pricing, attach payments to existing orders (typically in B2B selling on account or membership services, where annual extension is not mandatory). eConnect allows you to interact with GP database and push documents there in real time. Plus you can program web services, calling eConnect methods to build the integration between ecommerce web site hosted in Linux on PHP MySQL DB platform (Magento ecommerce shopping cart would be example) and GP which is only available in Microsoft Windows on SQL Server

3.Mid-size suppliers. Here we would like to recommend you the approach where you are importing Sales documents via scheduled IM integration and lookup pricing, quantities and order status from GP via SQL or eConnect queries. There are web services available out of the box for data inquiry only, which could be called from non-Microsoft platforms, such as Linux, Solaris, as web services are resolving OS platform dependency via XML SOAP protocol

4.Shopping Cart, where does it go in the sense of tables in MS SQL company database? You can review table structure in user interface: Tools -> Resource Description -> Tables. Select here Sales series and locate SOP10100 and SOP10200 tables, which are Sales Document Header and Line files respectively. Inventory lookup - try to identify such important tables as IV00101 item master, IV00102 Item Quantity Master. If you got the idea the rest could be done with your own intuition

5.For additional information, please feel free to call us 1-866-528-0577 or 1-630-961-5918 (this number works for international customers) or email us help@albaspectrum.com We serve you USA/Canada nationwide via remote support (web sessions and phone/Skype conferences). Local service is available in Western Michigan, Chicagoland, Southern California (LA, Orange County, San Diego), Houston area of the state of Texas