Help Topics

General Help Topics
Site Setup FAQ's Email - Set Up Domains Special Features FrameEZ Troubleshooting
Shopping Cart
Store Configuration Global Configuration Product Management Categories Manufacturers/Brands STN Import Tool Shipping Payment Processors Orders and Sales Shopper Groups Coupons & Discounts Taxes Safety Warnings POS-to-Web Sync
Import/Export Data Components
Contact Us Store Locator Newsletters - Letterman Front Page SlideShow Events Calendar QuickBooks Sync SEO Manager Media Manager Picture Gallery User Manager Banner Manager Language Editor
Wish List Mobile Lightspeed POS
Content Management
Create a QWC file E-mail
Components - QuickBooks Sync
Wednesday, 04 April 2012 14:17

A “QuickBooks QWC authorization file” is a special file that allows the QuickBooks Web Connector to communicate with your website. You will need to create and install at least one QuickBooks QWC authorization file (you can use multiple QuickBooks QWC authorization files if you wish).


Steps for creating a QuickBooks QWC authorization file:

  1. Login to your website Administration Panel

  2. From the Components Menu, select QuickBooks Sync

    qbsync-menu

    Note: (click here if you have not entered your key code )

  3. Click the New button

    newbutton.gif

  4. Enter a Username and Password.

    Your Password is case sensitive! Copy and save your password to use later - you will need to enter the password again when adding the QWC file to the QuickBooks Web Connector  application.

  5. Enter in your computer's full name, without the period. * To discover the full name of your computer: Open System by clicking the Start button Picture of the Start button, clicking Control Panel, clicking System and Maintenance, and then clicking System. Under Computer name, domain, and workgroup settings, you can find your computer's name, and it's full computer name if your computer is on a domain. Click here for more help on finding your Computer's Full Name.

    *note: if running into connection errors, enter your computer's name in lowercase characters only.

  6. Enter the Company Name that is used in QuickBooks. * You may have multiple Company Data files... enter the name of the QuickBooks POS company file that you want to connect to. You can find the Company Name in the top-left corner of QuickBooks POS, or in File > Company Data > Open > Company Data List.

    *note: if running into connection errors, enter your QuickBooks company file name in lowercase characters only.

    qbsync-company-file

  7. Select the version of QuickBooks that you are running.
    (We currently support versions 8, 9 and 10.)

  8. In the Data Settings block, you can set options for what data is pushed during the sync.

    1. Check “Push Up Product Inventory” if you wish to sync inventory

    2. Check “Push Up Product Prices” if you wish to sync prices.

    3. You can select which QuickBooks POS field to use for pricing.

    4. You can select which QuickBooks POS field to use for identifying products. Your selected POS field data MUST MATCH EXACTLY with the website’s “product SKU” field data in order to sync correctly.

       for example, these items will sync:
       POS Item Number  > Website Product SKU  Status
       aa1234    aa1234  good
       item 444    item 444  good
             
       ...and these items will NOT sync:
       POS Item Number  > Website Product SKU  Status
       aa1234    aa123-4  bad (dash)
       item 444    item444  bad (space before "444")
       b567    b567  bad (trailing space in POS Item Number, "b567 ")

       

  9. Click Save

    save.jpg

  10. Your next step will be to Download and Install your QWC Authorization file

Proceed to the next step >>

Last Updated on Thursday, 17 September 2015 09:12