WooCommerce-QuickBooks Desktop Connector

From: $69.99 for 1 year

The QuickBooks Connector for WooCommerce saves customers, inventory and orders from your website in your desktop QuickBooks. The connector automates data entry and reduces errors. Eliminate data entry so you can focus on your business! The QuickBooks Connector Extension handles all of this for you so you can focus on growing your sales!

It is easy to setup and saves time and money!

  • Send completed orders to QuickBooks as either Sales Receipts or Sales Orders / Invoices / Payments
  • Choose the order status(pending, processing or completed) as the trigger to send orders to QuickBooks.
  • Void Sales Receipts already posted to QuickBooks (in case of refunds etc).
  • Re-post modified Sales Receipts already posted to QuickBooks.
  • Auto-Create WooCommerce Customers in QuickBooks OR post all orders to a default QuickBooks account if you choose.
  • Map Payment Methods, Sales Tax Settings, Asset Accounts, COGs, Shipping Accounts and more between the two.
  • Auto-create WooCommerce products in QuickBooks using either the product ID or the SKU
  • Option to sync inventory quantity AND pricing from QuickBooks to your store. Once you receive new stock in QuickBooks, quantity is updated on your website.
  • Per-product syncing – You can choose to update price and stock information from QuickBooks on a per product basis.
  • Flexible options for variable products.
  • Note : All sales taxes appear in the body of invoice as line items. Sales tax group is not supported.
Clear

SKU: N/A Category: Tags: , ,

Description

WooCommerce-QuickBooks Connector Desktop  by Neah Plugins

Save time and money by using WooCommerce-QuickBooks Connector! Removing manual data entry. WooCommerce-QuickBooks Connector posts orders, customers and inventory to your QuickBooks. No more manual data entry!

Enterpise 9.0 – 19.0 (US Only), Pro / Premier 2008-2019 (US Only)

WooCommerce 3.x

 

Automate your accounting data flow between WooCommerce and QuickBooks

WooCommerce-QuickBooks Connector is an easy to setup plugin that maps your QuickBooks settings to your WooCommerce settings. Once your QuickBooks settings is mapped, it will do the following:

  • Send completed orders to QuickBooks as either Sales Receipts or Sales Orders / Invoices / Payments
  • Choose the order status(pending, processing or completed) as the trigger to send orders to QuickBooks.
  • Void Sales Receipts already posted to QuickBooks (in case of refunds etc).
  • Re-post modified Sales Receipts already posted to QuickBooks.
  • Auto-Create WooCommerce Customers in QuickBooks OR post all orders to a default QuickBooks account if you choose.
  • Map Payment Methods, Sales Tax Settings, Asset Accounts, COGs, Shipping Accounts and more between the two.
  • Auto-create WooCommerce products in QuickBooks using either the product ID or the SKU
  • Option to sync inventory quantity AND pricing from QuickBooks to your store. Once you receive new stock in QuickBooks, quantity is updated on your website.
  • Per-product syncing – You can choose to update price and stock information from QuickBooks on a per product basis.
  • Flexible options for variable products.
  • Note : All sales taxes appear in the body of invoice as line items. Sales tax group is not supported.

WooCommerce-QuickBooks Connector lets you focus on your business rather than data entry.

 

Here’s the requirements for using WooCommerce-QuickBooks Connector:

Intuit QuickBooks Accounting Software – Right now you need the desktop version, and one of the compatible QuickBooks package

  • QuickBooks Enterprise version 9.0 -18.0 (US, UK, CA only)
  • QuickBooks Pro or Premier version 2008 – 2018 (US, UK, CA only)
  • QuickBooks Company File – In order for the plugin to work, you need to setup the QuickBooks Company file and map the selected accounts in QuickBooks to the connector plugin settings.
  • QuickBooks running on Windows.
  • QuickBooks Web Connector – this ships with QuickBooks or you can download it as well. Intuit does require an SSL certificate for their webconnector software.
  • SSL Certificate on your website.

 

There is no reason to waste time on data entry. Let WooCommerce-QuickBooks Connector do the work for you and save your time and money!

 

  • Connector does NOT import products from QuickBooks.
    • WooCommerce-QuickBooks Connector will update the on-hand quantity for website products, but it does not import or create new products from items in QuickBooks. It can import products from your website into QuickBooks.
  • Connector imports products from WooCommerce into QuickBooks.
  • WooCommerce-QuickBooks Connector is only for DESKTOP versions of QuickBooks Accounting Software. It does not work with Intuit’s cloud-based accounting service called QuickBooks Online.
  • WooCommerce-QuickBooks Connector will only work with windows versions of QuickBooks.
  • WooCommerce-QuickBooks Connector is only compatible with US, UK and CA versions of QuickBooks.

 

 

NP Connector for WooCommerce to QuickBooks: Integration Setup

PREPARING YOUR QUICKBOOKS FOR WEBSITE INTEGRATION

Several preliminary things should be done in QuickBooks before you integrate your website:

    1. It is recommended that you go ahead and set up your products in QuickBooks before starting the integration. If you have too many products, or for whatever reason don’t want to enter your products into QuickBooks first, you can use the connector to pull products into QuickBooks for you. However, you should be aware that QuickBooks will only pull in your product name and SKU. All other information including price, inventory, vendor information and other relevant fields will have to be entered manually.
    2. Make sure you’ve set up your Chart of Accounts and thoroughly understand how your products should be recorded in QuickBooks. The following is a list of the required type of accounts you will need. If you don’t have at least one account from each category in your QuickBook chart of accounts, you should create one before starting the integration process:
          • Income Account
          • COGS Account
          • Deposit Account
          • Asset Account
          • Accounts Receivable
          • Expense Account
    3. To successfully post an order, you will need the following items set up in Quickbooks before integration:
          • Payment Method
          • Sales Tax
          • Shipping Item

          QUICKBOOKS INTEGRATION

          Now that you’ve set up your QuickBooks Chart of Accounts, entered your products into QuickBooks, and selected your options in QuickBooks for Payments, Sales Tax, and Shipping, you’re ready to install the web connector.

          WebConnector Tab

          After you activate NP QuickBooks Connector for WooCommerce, go to the QuickBooks SetUp in WooCommerce to create a QuickBooks Web Connector file.

          The WebConnector tab will walk you through this process. Just pick a username and password, and enter the url for the site that contains the products you want to integrate with QuickBooks. Then click the button “Create QWC File”, and a QWC File will be created. This needs to be saved on the same computer on which your QuickBooks is installed. Typically you might put it on your desktop for easy access since you will need to access it again when you sync your website to Quickbooks. Next, click the button “Download QuickBooks Web Connector” and follow the instructions to connect Quickbooks to your site.

          Below is a screenshot of the QuickBooks Web Connector. You can see the option for Auto-Run is checked and the minutes indicate how often your site will update. For our purposes here, we’ve set the time for 10 minutes on the initial set up so we can test our other settings more easily. But you will want to set your time for much longer than 10 minutes, either now or after you set up, to avoid overwhelming your system (180 minutes would be a normal setting unless your volume is very high).

           

          QuickBooks Setup Tab

          Now you have prepared a connection between your site and QuickBooks, but your products are not yet integrated. Before you begin the integration process you’ll need to finish setting up the plugin and choosing your options. So go back to the NP QuickBooks Connector for WooCommerce to the QuickBooks SetUp tab.

          Default Account Options
          The QuickBooks SetUp tab is where you choose the accounts that will be linked. Check all accounts and click to refresh with the accounts you have made on QuickBooks.

          In addition to the 6 required accounts, you also have the option to link accounts for Discount Account and Discount Item. Below is a screenshot of Default Account Options found in the QuickBooks Setup tab.

          Order Posting Options

          In the same tab, there are various options relating to orders. Orders should not be activated and sent through QuickBooks until your website integration and syncing is completed. It is recommended that you come back to the Order Posting Options and complete this section later. So we’ll scroll down to the next section and come back to this one after we sync the site to QuickBooks.

           

          Customer Options

          After the Order Posting Options are the Customer Options. In this section, you can decide whether or not you want to create individual customer accounts in QuickBooks . You also decide how customer names should be created by choosing the fields for the names and the order in which they will appear. The default customer account is also chosen here. Below is a screenshot of the Customer Options in the QuickBooks Setup tab.

           

           

          Payment Method Mappings

          Next on the page is Payment Method Mapping. This is where you match the payment methods installed on your site with the payment methods that you have set up in QuickBooks . Below is a screenshot of the Payment Method Mappings.

           

           

          Sales Tax Mapping

          All taxes are calculated on the web site based on WooCommerce tax setup and posted to QuickBooks as line items in sales receipts or sales orders. Sales tax groups are not supported and sales tax rates from the website must be mapped to QB sales tax rates that are not included in sales tax groups. Sales tax rates included in the sales tax groups must be set to zero or renamed and re-created outside of the sales tax group to prevent double counting- tax is already added in the body of the order/receipt as a line item.

          The sales tax mapping section is where you map the sales tax rates and codes for your site to what you have in QuickBooks .

        • All sales tax items are posted as line items in the body of the sales order or sales receipt as opposed to a total at the bottom singly or in a sales tax group.
          • Any sales tax code used on the web site must be mapped to a sales tax in QB.
          • Process is as follows:
            1. Map your WooCommerce tax “classes” to zero/exempt tax “codes” in QuickBooks.
            2. Map WooCommerce tax “rates” to your QuickBooks “rates” that are not in a sales tax group.
            3. When you run the QuickBooks connector, tax items will post as line items in the body of sales tax receipt or sales order in QuickBooks.

 

  • Shipping SettingsThe Shipping Settings is the final section that needs to be completed before you leave the QuickBooks Setup tab. First you , choose which item to use for shipping charges and the sales tax code. You can decide how you want the shipping options and method to appear on the sales order or sales receipt. Below is a screenshot of the shipping settings .

    Note: Make sure to save all changes before you leave the page, then continue on to the next section.

     

    Product Sync Tab

    Product Validation

    Before a website product can be linked with a QuickBooks item, the website product’s SKU must match the Item Name / Number field for the corresponding product in QuickBooks. If you’re entering the SKUs by hand or individually, make sure that you don’t mistake zeros for the letter ‘O’.

    After products are entered in QuickBooks , they can be validated in the Product Validation section . This helps ensure that orders will post successfully. Validation will not update the inventory and pricing on your website. It only updates the internal QuickBooks data used to programmatically interact with QuickBooks .

    Before you run Product Validation, if you know that there are products listed on your site that have not yet been added to QuickBooks , you can still bring them in using this process. Just be aware that you will have to manually set the price and inventory. To include all products on your site, before you click Validate All Products, scroll down to the Product Sync Settings (pictured below).

     

    Save your settings, then click the Validate All Products button.

    After clicking the Validate All Products button, go to the QuickBooks web connector that you have saved on your desktop or in any easily accessible location. Check the box at your site name, then click Update Selected (pictured below). Once all products are validated, you can add new products at any time by clicking the Add Missing Products to Quick Books button in the Product Validation section.

     

    IMPORTANT NOTE: When you are initially syncing your site to Quickbooks, DO NOT check the Sync Inventory On-Hand from Quickbooks or the Sync Price from Quickbooks options in the Product Sync Settings.

    Now you’re ready for the next step.

    Product Sync Settings

    Once you’ve gone through the process above and initially synced your site to QuickBooks (including product pricing and inventory) you can enable options in the Product Sync Settings including the price and inventory syncing options. The next time the web connector runs, items will be picked up in the inventory Sync routine and depending on the extension’s settings, either the price, quantity or both will be updated on the website with the values from QuickBooks. After the link has been successfully established, whenever the web connector runs, the product’s price and / or stock on the website will be updated with the values from QuickBooks.

    Remember to save all changes after making your settings choices.

     

    Order Posting Options

    Sending order’s shouldn’t be attempted until all of your mappings, accounts and products are set up. The plugin needs to know specifics about what payment methods, tax rates, accounts and products exist in QuickBooks and how they relate to similar settings in your website before it can programmatically create an order in QuickBooks. After you’ve mapped all of your settings and have verified that all of your products can be found in QuickBooks by matching Item Name / Number with the website SKU for the product, you’re ready for the next step.

    Now Go Back to the Quickbooks Setup Tab

    Go back to the QuickBooks Setup tab and scroll down the page to the Order Posting Options section. Now that syncing has been activated, the “Post Orders To QuickBooks” option can be checked. You should also consider enabling the “Store Order XML”, which will store the XML request to QuickBooks for the order. This is particularly useful for debugging if an order doesn’t go through.

     

    When to send the order to QuickBooks?

    To specify when an order should be queued to be transferred to QuickBooks, you can select the status from the “Order Status Trigger to send order to QuickBooks” What this setting does is specify when the order should be queued. By default, you should use “Completed”. This means that an order has theoretically been processed, shipped and you’ve received your money. If you’re using QuickBooks primarily for accounting purposes, this is the time to transfer the order and have it entered into the books.

    If you use QuickBooks for order fulfillment, you can try queuing the order at a different status, such as processing. This means, when an order’s status changes to processing, the order will be queued to be transferred to QuickBooks. The order status of processing does not assure that the order has been completed and shipped though, and if for some reason you don’t ship the order and cancel or refund it in the ebsite, it would need to be removed manually from QuickBooks as well.

    How Should Orders be Posted To Quickbooks
    QuickBooks Premier and Enterprise users can specify whether the order should be created in QuickBooks as either a Sales Receipt or Sales Order at the How Should Orders be Posted To Quickbooks option. If using QuickBooks Pro, always select Sales Receipts only.

    If you are using Sales Orders, you can also check the option Auto-create Invoices and Payments to have an Invoice and Payment automatically created for the Sales Order. It will be created at the time that the order is transferred to QuickBooks and is primarily meant for people who set the Order Status Trigger at Completed. Note: When enabled, an Invoice AND Payment are created. It’s not possible to specify one or the other.

    If you choose to post orders as sales receipts, you have the option to void a transaction that has already been posted. If you want to be able to void transactions already posted to QuickBooks, check the option “Allow reposting of orders that have already been sent?”. You have the option to either void or “void & re-post”. This option is not available if you choose to post your orders as sales orders. Also, if you try to void orders that have already been posted as sales orders, an error will return from QuickBooks and the transaction will not be voided.

     

    Line Item Description for Variations

    If you’re not tracking variations of variable products in QuickBooks, when the order is created in QuickBooks the parent product is used for the line item. If you’d like the line item description to reflect the value of the variation chosen, you can enable this option: Should the attribute values for variable products be used as the Sales Receipt / Sales Order line item description?. When enabled, the line item description will be a combination of the attribute and the chosen value. So if a large size was selected, the description would be Size:Large.

     

    Charge shipping to customers

    You can charge your customers for shipping by creating a shipping charge item and adding it to an invoice or cash sale.

    Detailed Instructions To Create a Shipping Charge Item:

            1. Select the Lists menu and select Item List.
            1. Click the Items drop-down menu and select New.
            1. Click the Type drop-down menu and select Other Charge.
            1. In the Item Name/Number field, enter the item name.
            1. In the Amount or % field, enter what you charge for shipping (use 0.00 if shipping charges change from one sale to the next.)
            1. In the Account field, enter the account you will use to track the shipping charge.
            1. Click OK.

    You can now use the new item to enter shipping charges on invoices and cash sales.

     

    Default Account Options

    Income Account

    This is the Income Account in QuickBooks that should be used when new website products are automatically created in QuickBooks.

    COGs Account

    This is the Cost-Of-Goods Account in QuickBooks that should be used when new website products are automatically created in QuickBooks.

    Deposit Account

    This is the deposit account in QuickBooks used for creating sales receipts and payments for sales orders.

    Asset Account

    This is the asset account in QuickBooks that should be used when new website products are automatically created in QuickBooks.

    Accounts Receivable

    This is the receivables account in QuickBooks that’s used when creating Invoices. Invoices are only created when the order posting type is set to “Sales Order” and the option to auto create invoices and payments is turned on.

    Expense Account

    This is the expense account used in QuickBooks when new website products are automatically created in QuickBooks.

     

    Order Posting Options

    Post Orders to QuickBooks

    Enable this option when you’d like to send orders to QuickBooks. This option should ONLY be enabled once you’re product mappings have been setup. The value in the “Item Name / Number” field in QuickBooks should match the value for the “SKU” field in the corresponding website product.

    Store Order XML?

    If you’re just setting up your integration, it’s probably best to enable this option. When enabled, the actual request that goes to QuickBooks to create the order will be stored with the order. This will help debug if for some reason the order doesn’t transfer properly or at all.

    Should the attribute values for variable products be used as the Sales Receipt / Sales Order line item description?

    When checked. the “Attribute Value” for variations will be used as the Line Item Description for the variation on Sales Receipts and/or Sales Orders. This is particularly useful if there’s no need to keep track of variations in QB. For instrance, if you sold t-shirts (item name in QB: t-shirt) in red, yellow and blue, but didn’t want to keep track of each variation in QuickBooks, if this options were enabled, when the sales receipt / sales order was created, the line item would look like this:

    Name : t-shirt

    Desc: color:red

    Not having this option selected, would just leave the standard description of the parent item t-shirt as the line item description

    Auto-create Invoices and Payments

    This option is only applicable when the order posting type is Sales Order. When enabled, a new invoice AND payment will created to close out the sales order. This option does not do anything when the order posting type is Sales Receipt as sales receipts are self-closing.

    Order Status Trigger to send order to QuickBooks?

    You can choose to send the order to QuickBooks when the order status reaches either “Pending”, “Processing” or “Completed”. Please remember that all orders MUST hit whatever status you choose. For instance if you choose “Pending’, but your orders go straight to “Processing”, the orders will never be queued to go to QuickBooks.

    Add prefixes to your sales receipts, sales orders, invoices and payments

    These are prefixes that you can use to identify website orders.

     

    Customer Options

    Create Individual Customer Accounts in Quickbooks

    When enabled, each website customer will be created in QuickBooks if they don’t already exist. Each order for that customer on the website will then be placed under that customer in QuickBooks, to determine if the customer already exists in QuickBooks, the format laid out in the “How Should Customer Names be created in QuickBooks” field is used to query QuickBooks

    How Should Customer Names be created in QuickBooks

    This is the format that customer names are created and queried in QuickBooks

    Default Customer Account

    This is a default, catch-all customer account. This option is only used if the “Create Individual Customer Account in QuickBooks” is disabled. Otherwise, this customer account is ignored.

     

    Payment Method Mappings

    Map Your WooCommerce Payment Methods to Your QuickBooks Payment Methods

    These are the mappings for your QuickBooks to WooCommerce payment methods. These mappings tells QuickBooks what the payment method on the website equals in QuickBooks. So if you have “Paypal” as a website payment method and wanted that to go under “Credit Card” in QuickBooks, you’d map PayPal to Credit Card in this section.

     

    Sales Tax Mappings

    QuckBooks Sales Tax Vendor

    This is the name of the Sales Tax Vendor exactly as it appears in QuickBooks. This is who you pay your sales tax to.

    Default No Tax Account

    The default “no tax” account is the sales tax item in QuickBooks that has a zero percent sales tax rate. This is used to create orders where no tax was collected.

    Map Your WooCommerce Sales Tax Codes to Your QuickBooks Sales Tax Codes

    Each sales tax code on the website must correspond to a sales tax code in QuickBooks.

    Map Your Local WooCommerce Sales Tax Rates to Your QuickBooks Sales Rates.

    Each “local” sales tax rate that you have setup on the website MUST correspond to sales tax item in QuickBooks. If you have “local” sales tax rates setup on the website, but they don’t appear here, check to make sure that each sales tax rate on the website has a label associated with it.

    Map Your WooCommerce Sales Tax Rates to Your QuickBooks Sales Rates.

    Each sales tax rate that you have setup on the website MUST correspond to sales tax item in QuickBooks. If you have sales tax rates setup on the website, but they don’t appear here, check to make sure that each sales tax rate on the website has a label associated with it.

    Shipping Settings

    In order to transfer the shipping charges to your customers correctly as line items on the sales receipt / sales order, you need to have a “shipping item” setup in QuickBooks.

     

     

    Product Sync Settings

    Sync Inventory On-Hand from QuickBooks

    If checked, the on-hand quantity in the website will be updated with the on-hand quantity count from QuickBooks. Note: Stock management must be enabled on the website in order for this to have any effect.

    Sync Price from QuickBooks

    If checked, the price on the website will be updated with the price in QuickBooks.

    Do you keep track of parent products for variations in QuickBooks?

    If you don’t need to keep track of parent products of variable products, leave this item unchecked.

    Do you keep track of variantions for variable products in QuickBooks?

    If you don’t keep track of variations of variable products, you should leave this option unchecked. If you do track variations separately in QuickBooks, this item should be checked.

    Unique Product Identifer Mapping for Quickbooks

    You can choose to use either sku or product id. Sku is the recommended option and product id will be deprecated in future releases. You should use sku.

    Change WooCommerce stock status when QuickBooks quantity goes above or below zero?

    If this is enabled, then the extension will change the a product’s stock status to “In Stock” and “Out of Stock” and the quantity is greater then or less than zero. This options should only be used if your QuickBooks items are “Inventory” items.

    Auto-create website products in QuickBooks if they can’t be found?

    If this option is enabled, products that can’t be found in QuickBooks based on the website’s sku field, will be automatically created. This option is still in beta and should be used to “setup” your QuickBooks inventory. Auto-created options will still require a certain level of intervention from your end. You will still need to enter costs, manufacturers, etc. If you’d like to use this feature, make sure that either “Sync Price from QuickBooks”, “Sync Inventory On-Hand from QuickBooks” or both are enabled.

    Are Variations Subitems of the Parent product in QB?

    If you’re keeping track of variations in as separate items in QuickBooks, enabling this options means that the variations that you’ve setup in QuickBooks are sub items of the parent product in QuickBooks.

    Default QuickBooks Item Type for auto-created products?

    If you have “Auto-create website products in QuickBooks if they can’t be found?” enabled, this is the QuickBooks Item Type that they will be auto-created as. Current supported item types are “Inventory”, “Non-Inventory” and “Service”.

    How Often Should the Inventory Sync run?

    This is the time (in minutes) between inventory syncing. Setting this to a time other than what’s in the web connector auto-run interval, is particularly useful if your QuickBooks catalog has a lot of items. For instance, let’s say you want the web connector to run every 5 minutes to check for new orders, but sync inventory only needs to happen every 60 minutes. You can set the web connector auto-run interval to 5 min and then set this value to 60.

 

Troubleshooting

 

What if an order doesn’t go through?
If an order doesn’t go through, it’s likely that one of the following is happening:
1. An item on the order can’t be found in QuickBooks
2. The payment method for the order isn’t mapped
3. Sales tax rates are mapped incorrectly
4. There’s no shipping item setup in QuickBooks

Go through all of your settings and make sure that everything’s mapped correctly. You can also look at the History tab in the extension for more details from QuickBooks about why the order didn’t transfer. If there are errors saying that the ListID is empty or that a ListID is invalid, that means that your account mappings are out of sync. To resolve, you should refresh your account mappings and re-save.

 

Charge shipping to customers

You can charge your customers for shipping by creating a shipping charge item and adding it to an invoice or cash sale.

Detailed Instructions To Create a Shipping Charge Item:

          1. Select the Lists menu and select Item List.
          1. Click the Items drop-down menu and select New.
          1. Click the Type drop-down menu and select Other Charge.
          1. In the Item Name/Number field, enter the item name.
          1. In the Amount or % field, enter what you charge for shipping (use 0.00 if shipping charges change from one sale to the next.)
          1. In the Account field, enter the account you will use to track the shipping charge.
          1. Click OK.

You can now use the new item to enter shipping charges on invoices and cash sales.

 

Default Account Options

Income Account

This is the Income Account in QuickBooks that should be used when new website products are automatically created in QuickBooks.

COGs Account

This is the Cost-Of-Goods Account in QuickBooks that should be used when new website products are automatically created in QuickBooks.

Deposit Account

This is the deposit account in QuickBooks used for creating sales receipts and payments for sales orders.

Asset Account

This is the asset account in QuickBooks that should be used when new website products are automatically created in QuickBooks.

Accounts Receivable

This is the receivables account in QuickBooks that’s used when creating Invoices. Invoices are only created when the order posting type is set to “Sales Order” and the option to auto create invoices and payments is turned on.

Expense Account

This is the expense account used in QuickBooks when new website products are automatically created in QuickBooks.

 

Order Posting Options

Post Orders to QuickBooks

Enable this option when you’d like to send orders to QuickBooks. This option should ONLY  be enabled once you’re product mappings have been setup. The value in the “Item Name / Number” field in QuickBooks should match the value for the “SKU” field in the corresponding website product.

Store Order XML?

If you’re just setting up your integration, it’s probably best to enable this option. When enabled, the actual request that goes to QuickBooks to create the order will be stored with the order. This will help debug if for some reason the order doesn’t transfer properly or at all.

Should the attribute values for variable products be used as the Sales Receipt / Sales Order line item description?

When checked.  the “Attribute Value” for variations will be used as the Line Item Description for the variation on Sales Receipts and/or Sales Orders. This is particularly useful if there’s no need to keep track of variations in QB. For instrance, if you sold t-shirts (item name in QB: t-shirt) in red, yellow and blue, but didn’t want to keep track of each variation in QuickBooks, if this options were enabled, when the sales receipt / sales order was created, the line item would look like this:

Name : t-shirt

Desc: color:red

Not having this option selected, would just leave the standard description of the parent item t-shirt as the line item description

Auto-create Invoices and Payments

This option is only applicable when the order posting type is Sales Order. When enabled, a new invoice AND payment will created to close out the sales order. This option does not do anything when the order posting type is Sales Receipt as sales receipts are self-closing.

Order Status Trigger to send order to QuickBooks?

You can choose to send the order to QuickBooks when the order status reaches either “Pending”, “Processing” or “Completed”. Please remember that all orders MUST hit whatever status you choose. For instance if you choose “Pending’, but your orders go straight to “Processing”, the orders will never be queued to go to QuickBooks.

Add prefixes to your sales receipts, sales orders, invoices and payments

These are prefixes that you can use to identify website orders.

 

Customer Options

Create Individual Customer Accounts in Quickbooks

When enabled, each website customer will be created in QuickBooks if they don’t already exist. Each order for that customer on the website will then be placed under that customer in QuickBooks, to determine if the customer already exists in QuickBooks, the format laid out in the “How Should Customer Names be created in QuickBooks” field is used to query QuickBooks

How Should Customer Names be created in QuickBooks

This is the format that customer names are created and queried in QuickBooks

Default Customer Account

This is a default, catch-all customer account. This option is only used if the “Create Individual Customer Account in QuickBooks” is disabled. Otherwise, this customer account is ignored.

 

Payment Method Mappings

Map Your WooCommerce Payment Methods to Your QuickBooks Payment Methods

These are the mappings for your QuickBooks to WooCommerce payment methods. These mappings tells QuickBooks what the payment method on the website equals in QuickBooks. So if you have “Paypal” as a website payment method and wanted that to go under “Credit Card” in QuickBooks, you’d map PayPal to Credit Card in this section.

 

Sales Tax Mappings

QuckBooks Sales Tax Vendor

This is the name of the Sales Tax Vendor exactly as it appears in QuickBooks. This is who you pay your sales tax to.

Default No Tax Account

The default “no tax” account is the sales tax item in QuickBooks that has a zero percent sales tax rate. This is used to create orders where no tax was collected.

Map Your WooCommerce Sales Tax Codes to Your QuickBooks Sales Tax Codes

Each sales tax code on the website must correspond to a sales tax code in QuickBooks.

Map Your Local WooCommerce Sales Tax Rates to Your QuickBooks Sales Rates.

Each “local” sales tax rate that you have setup on the website MUST correspond to sales tax item in QuickBooks. If you have “local” sales tax rates setup on the website, but they don’t appear here, check to make sure that each sales tax rate on the website has a label associated with it.

Map Your WooCommerce Sales Tax Rates to Your QuickBooks Sales Rates.

Each sales tax rate that you have setup on the website MUST correspond to sales tax item in QuickBooks. If you have sales tax rates setup on the website, but they don’t appear here, check to make sure that each sales tax rate on the website has a label associated with it.

Shipping Settings

In order to transfer the shipping charges to your customers correctly as line items on the sales receipt / sales order, you need to have a “shipping item” setup in QuickBooks. If you’re unfamiliar with how this should look, here’s a link from Intuit on how to set this up:

Creating a Shipping Item in QuickBooks

 

 

Product Sync Settings

Sync Inventory On-Hand from QuickBooks

If checked, the on-hand quantity in the website will be updated with the on-hand quantity count from QuickBooks. Note: Stock management must be enabled on the website in order for this to have any effect.

Sync Price from QuickBooks

If checked, the price on the website will be updated with the price in QuickBooks.

Do you keep track of parent products for variations in QuickBooks?

If you don’t need to keep track of parent products of variable products, leave this item unchecked.

Do you keep track of variantions for variable products in QuickBooks?

If you don’t keep track of variations of variable products, you should leave this option unchecked. If you do track variations separately in QuickBooks, this item should be checked.

Unique Product Identifer Mapping for Quickbooks

You can choose to use either sku or product id. Sku is the recommended option and product id will be deprecated in future releases. You should use sku.

Change WooCommerce stock status when QuickBooks quantity goes above or below zero?

If this is enabled, then the extension will change the a product’s stock status to “In Stock” and “Out of Stock” and the quantity is greater then or less than zero. This options should only be used if your QuickBooks items are “Inventory” items.

Auto-create website products in QuickBooks if they can’t be found?

If this option is enabled, products that can’t be found in QuickBooks based on the website’s sku field, will be automatically created. This option is still in beta and should be used to “setup” your QuickBooks inventory. Auto-created options will still require a certain level of intervention from your end. You will still need to enter costs, manufacturers, etc. If you’d like to use this feature, make sure that either “Sync Price from QuickBooks”, “Sync Inventory On-Hand from QuickBooks” or both are enabled.

Are Variations Subitems of the Parent product in QB?

If you’re keeping track of variations in as separate items in QuickBooks, enabling this options means that the variations that you’ve setup in QuickBooks are sub items of the parent product in QuickBooks.

Default QuickBooks Item Type for auto-created products?

If you have “Auto-create website products in QuickBooks if they can’t be found?” enabled, this is the QuickBooks Item Type that they will be auto-created as. Current supported item types are “Inventory”, “Non-Inventory” and “Service”.

How Often Should the Inventory Sync run?

This is the time (in minutes) between inventory syncing. Setting this to a time other than what’s in the web connector auto-run interval,  is particularly useful if your QuickBooks catalog has a lot of items. For instance, let’s say you want the web connector to run every 5 minutes to check for new orders, but sync inventory only needs to happen every 60 minutes. You can set the web connector auto-run interval to 5 min and then set this value to 60.

Common Errors & Fixes

 

QuickBooks 1012 Authentication Failed

The Problem:

After initiating Intuit’s Web Connector, the sync fails and your receive the error message QBWC102 Authentication Failed. When clicking the “Click for more information” in Intuit’s web connector, a dialog box appear on your desktop with the following information. :

Message: Authentication failed

Description: QBWC1012: Authentication failed due to the following error message. The remote name could not be resolved: ‘your domain.com’ See QWCLog for more details. Remember to turn logging on.

Why You’re receiving this message:

A DNS error on your PC is preventing Intuit’s Web Connector from connecting to your website.

How to correct this error:

You can correct this issue by rebooting the computer that is running Intuit’s Web Connector. This will clear the DNS error and allow Web Connector to connect to your website.

 

 

QuickBooks 3140 Transaction Sales Tax is currently disabled by preferences.

If you receive the following message when trying to create a sales order / sales receipt in QB, then you have sales tax disabled in your company settings:

3140: There is an invalid reference to QuickBooks ItemSalesTax “No Sales Tax – Website” in the SalesReceipt. QuickBooks error message: Transaction Sales Tax is currently disabled by preferences

To correct this message, you’ll need to enable sales tax at the company level by following these steps.

          1. Open QuickBooks with the correct company file
          1. Click the Edit menu then Preferences
          1. From the left vertical tool bar, select Sales Tax
          1. Click the Company Preferences tab
          1. Select Yes in the ‘Do you charge sales tax’ field. (This is a temporary change)
          1. Make sure there is a ‘Most common sales tax’ entry
          1. Click OK.
          1. Uncheck both boxes in the ‘Update Sales Tax’ dialog box then click OK.
          1. You may need to click OK to a confirmation about closing windows.

 

QuickBooks 3270 Missing posting account

QuickBooks error code 3270: Missing posting account pertains to trying to create a sales order in a version of QuickBooks that doesn’t allow sales order creation. All versions of QuickBooks will let you view sales orders, but only certain versions of QuickBooks lets you create new sales orders.

If you’re using QuickBooks Pro, you will receive that message when trying to send website orders to QuickBooks as Sales Orders. You’ll need to change the order posting type to Sales Receipts.

 

Warning: mcrypt_encrypt(): Key of size 10 not supported by this algorithm

If you receive the following warning while trying to generate a qwc file on your site, take the steps listed below to correct the issue:

Warning: mcrypt_encrypt(): Key of size 10 not supported by this algorithm.

          1. Install the latest version of the plugin
          2. Once the latest version of the WooCommerce QuickBooks Integration has been installed, click the Reset QWC Users button
          3. Re-enter the username, password and ssl path
          4. Click the Generate QWC File button
          1. Remove the old QWC file from Intuit’s webconnector
          1. Add the new QWC file from Intuit’s webconnector

After you do those steps, you shouldn’t have to take any further action.

 

 

 

 

 

Additional information

License

Single Site, 3 Sites