Posts Tagged ‘shopping’
eCommerce Shopping Cart Integration to Dynamics GP Sales Order Processing Transaction
Microsoft Dynamics GP, formerly also known as Great Plains Dynamics, eEnterprise, is flexible and powerful platform for eCommerce B2B and B2C Shopping Cart integration. If you are ecommerce programmer, please read this introduction level publication on integrating ecommerce shopping cart into SOP Invoice or Sales Order in Dynamics GP. Being bound by article genre rules, we will try to be reasonably laconic and balance technical (for developers and programming) and functional (for IT managers) information. We will pay some attention to Microsoft Dexterity and its possible role in GP eCommerce integrations:
1. Sales Order Processing Invoice or Sales Order as ecommerce shopping cart destination. In our opinion this object is the most natural for being considered as shopping cart destination in GP. SOP Transaction has document header, where you specify customer, doc number, dates, addresses, shipping info, tax and other document level info. Plus, it has Items lines, where you add your shopping cart items and link them with the information on availability in stock, allocation (when applicable), back ordering, or you can even have your line items as services, or non inventory items, where you are not bound by Inventory tracking. If you think SOP Transaction is the right object for ecommerce shopping cart integration, you need to choose the integration tool or technology
2. Dynamics GP Dexterity proprietary technology. We do not recommend you to do Microsoft Dexterity programming and customization in order to integrate eCommerce shopping cart, because other tools could do similar job without custom programming, especially Dynamics GP Integration Manager. If you have serious reasons to try Dexterity route, we recommend you to discuss Dexterity ecommerce integration with your Microsoft Dynamics GP Partner, or with experienced Dynamics GP Dexterity programmer. Dexterity might be the way to go, when you require that Great Plains becomes your master application, from where you initiate eCommerce shopping carts pulling, and where you define your Inventory Items, Price Lists, Discounts (Trade Discounts on Sales Invoice Document level) and Sales Campaigns and push these objects to your ecommerce web application
3. GP Integration Manager. If you are representing reasonably small or mid-size ecommerce retailer (B2B or B2C ecommerce) or wholesaler (B2B ecommerce) and you are sort of OK with the option of daily ecommerce to GP integration (one time per day) and your ecommerce transaction volume is below thousand new orders per day, we recommend you to review IM in details and only consider moving to the next step is you tried IM in and out and there is something special and important to your ecommerce business processes, that Integration Manager cannot do. OK, having said that, let’s review IM. This tool is end user friendly (you may still need Dynamics GP consultant, if you feel that your organization doesn’t have IT internal support). You start with creating Data Sources – we recommend you either to export ecommerce shopping carts into text (comma or tab delimited) files or even better Create Advanced ODBC Data Source, based on SQL View, including options to create cross platform SQL View in MS SQL Server, with linking to Oracle, MySQL/PHP/Linux, Microsoft Access, Lotus Notes. Second step – you link your Sources (you will need at least two for ecommerce shopping cart, as Document Header and Lines should be integrated). In IM you can also do VBA scripting and in these scripts you can address custom tables in GP via Microsoft ADO technology, if required. Plus, as additional (but not the last tip – call us for more info) tip you can schedule IM Integration to run every, let’s say, twenty minutes to make ecommerce to GP integration behave as it is in quasi real time
4. Dynamics GP eConnect. This integration tool and SDK could be deployed in Microsoft Visual Studio C#, VB.Net or other programming language project as libraries and help with Sample Codes (it is Software Development Kit). eConnect enables real time integration, as you can include eConnect libraries into ecommerce Web Application. If you are experienced or even making progress Microsoft Visual Studio Programmer, and you are familiar with C# (Microsoft Java blend) or VB and have some exposure to SQL Stored Procedures and XML – eConnect should be open for you to experiment. Initially eConnect was dedicated to Great Plains eCommerce programmers to integrate ecommerce web applications with Dynamics GP 7.0 and 7.5 (later on eConnect was expanded and now for Microsoft Dynamics GP version 10.0 it covers most of the core modules: GL, SOP, POP, Inventory Control, Receivable Management, Payable Management, Payroll, General Ledger, Project Accounting, etc.)
5. Direct SQL scripting for Dynamics GP ecommerce integration. If you try it from scratch – it might be too long way to come
Tags: Cart, Dynamics, Ecommerce, Integration, Order, Processing, Sales, shopping, Transaction
Microsoft Dynamics GP Shopping Cart Integration in B2B and B2C ecommerce scenarios
If you already have eCommerce website with popular ecommerce shopping cart platforms, such as ASP .Net Store Front, or Magento/PHP in Business-to-Business or Business-to-Customer models, we would like to give you highlights on shopping cart integration to Microsoft Dynamics GP or Great Plains, how this mid-market Corporate ERP application was known initially. 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 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
5. Second Opinion on failed Dynamics GP implementations, ecommerce integrations, Warehouse management Systems and other Barcoding technology based projects. We are Dynamics GP, eCommerce and Barcode scanning people. If somebody from Great Plains resellers community screwed the implementation, please be patient, do not burst out in blaming, seek for second opinion.
Tags: Cart, Dynamics, Ecommerce, Integration, Microsoft, scenarios, shopping
Your Online Auction Listings must be Advertise !
Online auctions offer the opportunity to make money in the comfort and leisure at home. In addition to different jobs, there are several other ways to make money online. For example, online auctions are the best option, after writing and other work to earn a good sum of money to surf the net. There are several Internet auctions, where you money by selling items that are not used to winning, can.
Online auctions are a number of items for sale – household items, books, blogs for various services such as consulting, designing logos and websites. E-books can only be products of self-evaluation are not published and one of the best ways to make money is through auctions. E-Books E-Books, which are composed of special materials and different areas of interest. So people participate in online auctions as the most appropriate method to test the value of their information by selling their e-books. Several e-books on various Internet auction sites like eBay display. If these e-books are purchased, which can be downloaded from the author, or contact by e-mail. So popular on Internet sites of several people and as income. auction sites on the Internet allows all sorts of things to see and products at flea markets, flea markets, importers, wholesalers, dealers, settlement and other sources can also be purchased at prices reasonable.
Read the rest of this entry »
Tags: advertising, business, online auctions, qxbid, shopping