Quickbooks Adaptor v2.0 for nopCommerce

 Installation Instructions

This addon has been tested with nopCommerce 1.50 & 1.60 with Nop.BusinessLogic unchanged and tested with Quickbooks 2008-2010 version Free, Pro & Premier. It is supposed to work with Quickbooks 2002 and later.
Your website must have SSL certificate properly installed ( https://www.yourdomain.com should be working ). This is required by Quickbooks for security reasons. (Replace yourdomain.com with the domain name you specified when purchased the package.)

Package includes:

• Gabs.Quickbooks.dll.
• Quickbooks folder with 6 files: Setup.asmx , Setup.asmx.cs,  InventoryItem.asmx, InventoryItem.asmx.cs Order.asmx, and Order.asmx.cs
• 3 Quickbooks web connector files: QA_2_0Setup.qwc, QA_2_0_Item.qwc, QA_2_0_Invoice.qwc 

This package fully works for YourDomainName only. (Replace YourDomainName with the domain name you specified when purchased the package.)
 

How it works: QuickBooks (QB); Quickbooks Adaptor (QA)

This solution requires Quickbooks Web Connector (QWC) which you can download from Quickbooks website. QWC works as a broker between QA and QB. 

• When you import inventory from nopCommerce to Quickbooks, QB will import either nopCommere variant SKU or variant name or product name as QB item name by the priority SKU#->variant name->productname. Which ever is empty, it uses the next priority level. Other product variant information will be imported to Quickbooks inventory item accordingly.
• Always import new inventory items before orders because QB could not accept order if any one of the order item is not found. 
• nopCommerce order# will appear in QB order as Invoice#.
• Shipping cost of nopCommerce order appears as an order line item “Shipping charge” in QB invoice.
• Discount in nopCommerce appears as an order line item “Discount” in QB invoice.
• Sales Tax in nopCommerce appears as sales tax line in QB invoice

Installation Steps:

1. Open nopCommerce solution in visual studio.

2. Copy Gabs.Quickbooks.dll to folder Dependencies 

3. In NopCommerceStore project, right-click on Reference -> Add Reference-> Browse in Dependencies folder and choose file Gabs.Quickbooks.dll . 

4. Copy Quickbooks folder with its 6 files and paste into NopCommerceStore project.
    

5. Open file Web.config . Within section <appSettings> Add following lines
   
   <!--Quickbooks Connection-->
   <add key="QCUsername" value="username"/>
   <add key="QCPassword" value="password"/>
   <add key="QBCLic" value="your license code"/>
   <add key="QBFile" value="Your\PathTo\QuickbooksFile.qbw"/>
   
   For security reason, remember to change value="username" and value="password" to your own ones.
   Note : “Your\PathTo\QuickbooksFile.qbw” must be replaced by the actual path of your Quickbooks Company file. If you comment out  this line, QA works with the Company file which is currently open.
    

6. Go to http://marketplace.intuit.com/webconnector/, download Quickbooks Web Connector and install it in the computer that has Quickbooks running.
    

7. Open 3 .qwc files and change <AppURL>  and  <AppSupport> value to your domain name :
    

   For example:
   
   <?xml version="1.0"?>
   <QBWCXML>
   <AppName>Quickbooks Adaptor for Connection</AppName>
   <AppID></AppID>
   <AppURL>https://YourDomainName/Quickbooks/Order.asmx</AppURL>
   <AppDescription>Transfer nopCommerce orders to Quickbooks</AppDescription>
   <AppSupport>https://YourDomainName/</AppSupport>
   <OwnerID>{35E4FDDC-ECBB-4c22-9CCC-75EB8C80BF5E}</OwnerID>
   <FileID>{35E4FDDC-ECBB-4c22-9CCC-75EB8C80BF5E}</FileID>
   <UserName>username</UserName>
   <QBType>QBFS</QBType>
   <Style>Document</Style>
   <AuthFlags>0xF</AuthFlags>
   </QBWCXML>
    
8. Replace YourDomainName with your actual domain name.
   Change username to the same as you edited in Web.Config.
   Save the nopCommerce.qwc to somewhere in your hard disk.
    

9. From Visual Studio 2005/2008, recompile NopCommerceStore and uploade it to your webserver. You can also upload source code to webserver to run it if you want to.

10. Run Quickbooks, open your Quickbooks Company file.

11. Run Quickbooks Web Connector. Open the .qwc file one by one with the QA_2_0Setup.qwc first and then QA_2_0_Item.qwc and then QA_2_0_Order.qwc while Quickbooks program is still running.

12. You will go through a process instructed by Quickbooks program to register
    the .qwc files.

13. From within Quickbooks Web Connector you are now able to transfer new orders from your nopCommerce website into Quickbooks. When Quickbooks Web Connector asks for password, enter the one your setup in Web.Config.

14. You can set up Quickbooks Web Connector to automatically transfer new orders every few hours, or few minutes. It depends on how busy your web store is.

15. We strongly recommend you to click on the link below view our

    installation video instructions 

Thank you for supporting us and hope this add-on will save you a lot of time

Should you have questions, please contact us

This document is prepared with our best effort to make you understand and make it work. If you find any errors and/or suggestion/correction, we are very happy to listen to you. Please email us sales@usasupportcenter.com

Global Advanced Business Solutions

NopCommerce is open source software of NopSolutions
Quickbooks is software trade mark of Intuit, Inc.