WooCommerce QuickBooks Desktop Integration: Import/Export Products

In our previous article we made a general overview of the WooCommerce Quickbooks Integration in Store Manager for WooCommerce.

Here we will provide a detailed guide on how to import and export products to QuickBooks to sync your inventory.

How to Export Products to QuickBooks

Click on the QuickBooks Integration icon to launch the addon. In the Welcome window, select “Export Products to QuickBooks”

Now follow the instructions of the wizard to complete the task successfully.

1. Select the Data That Will be Exported to QuickBooks

On the first step, you will see a list of products that will be exported to QuickBooks. If you want to proceed with it, click “Next”.

If you want to select certain products to export, use the filters: status (active or not), Product ID, Product Code (SKU), Product (name), Description, Quantity, Price.

How to export variable products to QuickBooks

You can sync products variations with QuickBooks as well. Though import/export of variations is not available in the QuickBooks Integration out of the box, you can set it up in a few steps.

First, locate the folder PluginsWorkFiles on your computer:

C:\Users\%username%\AppData\Local\eMagicOne Store Manager for WooCommerce\PluginsWorkFiles

When you open the folder, you'll see four files there:

You will need to open files one by one using and replace existing contents with the one provided below. Use Notepad or other txt reader to open the files. Save the changes after pasting new contents.

Open MappedProductsSQL file with Notepad or other txt reader and replace existing code with the following (remember to save the changes):

Open ExportProductsSQL_303 file with Notepad or other txt reader and replace existing code with the following (remember to save the changes):

Open ExportProductsSQL file with Notepad or other txt reader and replace existing code with the following (remember to save the changes):

Open ExportOrderDetailsSQL file with Notepad or other txt reader and replace existing code with the following (remember to save the changes):

After you’ve replaced the contents of all files, relaunch the QuickBooks Integration. Now, you will be able to export product variations, each variation with its own SKU:

2. Specify Export Options

Now, let's get back to the export. After you’ve selected the products, proceed with the export options.

But first you have to connect to Quickbooks. Select one of the options and press “Begin session”:

When the addon have connected to your Quickbooks software, you will see available options. Here is what they stand for.

• Export method – select whether to create new products, modify existing, or do both.
• Set default tax – check the option to enable it.



If you select the “Set default tax” check box, there will appear the drop-down with two options — Taxable sales and Non-Taxable sales:









If you’ve selected “Taxable Sales”, specify a tax code that will be assigned to the products. If a taxable item code list is empty, press “Get tax items” to retrieve a list of taxes from QuickBooks.



• Export product as type – select the type of QuickBooks inventory to update (Inventory Part, Non-Inventory part, Service, Other Charge).
• Update quantity – check the option to update products' quantity in QuickBooks.
• Export product as – the dropdown has three options: Product ID, Product code (SKU), Product name. Choose the entity that will serve as Name in QuickBooks.
• Max length – set the limit for the characters in the Item name (product).


In QuickBooks Desktop, each field in a company data file has a maximum number of characters that can be entered. Item name (product) is limited to 31 characters. If the item name is longer than that, it won’t be exported. To avoid this, set the Max length limit to 31 characters or less.







• Export description as – similarly, select appropriate field (Product name or product description) that will serve as Description in QuickBooks.
• Income Account – if you export inventory products you will be offered to specify the income account. So, specify the account that will be assigned to the items. If the Accounts list is empty, click the arrow icon to retrieve existing accounts from QuickBooks:

3. Map Custom Fields

If the items in your QuickBooks account have custom fields (like color, material), and you would like to fill them during the export, you can pick matching fields from your store database. To do so, check the option “Export items custom list” and select appropriate fields from your store database:

4. Map Products Between WooCommerce and QuickBooks

If you already have some products on QuickBooks, map the products from your store to them.

Use the “AutoFill” option to map products automatically. The addon will search for matching products across both systems by product ID, name, or SKUs match.

If matching products weren’t found, you can map them manually:

When you’ve specified all settings, press “Export.”

5. Complete the Export and check Items in QuickBooks

After it the export is complete, you will see a window showing what products were modified or added:

Press “Finish” and check the exported data in QuickBooks:

Import Products from QuickBooks to WooCommerce

The Product Import option allows you to transfer data from QuickBooks to add or update products in your WooCommerce store.

To begin the import, launch QuickBooks Integration and select the “Import Products from QuickBooks” option:

The Import Wizard is pretty similar to the export allowing you to:

• Create new products, modify existing or do both.
• Update the following fields: product name, price, quantity and description.
• Select the type of QuickBooks inventory to update.
• Decide whether to update empty fields.

In this window, you must specify the Default category into which products from QuickBooks will be imported:

If there is a category with such a name in your WooCommerce store already, the products will be imported into it.

If your store doesn’t have a matching category, Store Manager will create it on the go.

And finally, specify the Quickbooks field (Item Name or Item List ID) that will be imported as a SKU into WooCommerce.

If you import QuickBooks Item Name into a WooCommerce SKU field, and if there is a product with a matching SKU, it will be updated or skipped during import (depending on the Import/Export method selected at the previous step).

After you’ve specified all settings, press “Next” and check the preview. If everything is correct press “Import”:

In the last step, look through the import details and click “Finish” to close the Wizard. Now you can check the data in Store Manager:

The Bottom Line

QuickBooks Integration in Store Manager for WooCommerce helps you sync product data between two systems automatically and avoid manual data entry. Use the addon to export products from your store to QuickBooks and import them when necessary. Update hundreds of products at once and keep your inventory in order!