QuickBooks Commerce makes it easier than ever to manage your WooCommerce store, from order to fulfillment. As your business grows, use QuickBooks Commerce to manage your price lists, inventory, orders, fulfillment, accounting sync and more for all of your sales channels.

Below are the steps required to integrate your WooCommerce store with QuickBooks Commerce:

1. Prep work within your WooCommerce store
2. Installing your WooCommerce store on QuickBooks Commerce
3. Reviewing and testing your integration settings

Step 1 of 3: Prep work within your WooCommerce store

Here we’ll cover:

• Reviewing your product SKUs in WooCommerce
• (Optional) Reviewing existing installed apps in WooCommerce
• Confirming your WooCommerce account settings

Reviewing your Product SKUs in WooCommerce

QuickBooks Commerce uses SKUs to identify and link inventory between WooCommerce and QuickBooks Commerce in order to facilitate inventory updates and streamline order management.

Before proceeding to the next step, go into your WooCommerce account and ensure that each product and variant have unique SKUs.

QuickBooks Commerce only works with two of four product types in WooCommerce:

• Variable Products
• Simple Products

(Optional) Reviewing your Existing Installed Apps

One of QuickBooks Commerce's main benefits is to provide your business with centralized inventory control and automation.

If you are currently using any apps or integrations that update your inventory levels, we recommend that you uninstall them prior to integrating QuickBooks Commerce and WooCommerce.

If you’re having trouble uninstalling them for whatever reason, contact Support by submitting a ticket here.

Confirming your WooCommerce Account Settings

Log in to your WooCommerce account.

Enable stock management - Go into Settings and click on the Products tab.

Check the box labeled “Enable stock management.”

Next, click on the API tab. Check the box labeled “Enable the REST API.”

Click on Users and then Your Profile.

Set your WooCommerce API Keys permissions to “ Read/Write”.

Now under your Settings, click the Permalinks tab.

Under the common settings for Permalinks you will need to set your common settings to “POST NAME,” in order for your integration to work.

Step 2 of 3: Install your WooCommerce store on QuickBooks Commerce and Import your Products

Here we’ll cover:

• Connecting your WooCommerce store
• Location Mapping
• Price List Mapping
• Initial Product Import
• Review Order Import Status
• Review what will happen next

Connecting your WooCommerce store

Now go to you QuickBooks Commerce account.

From QuickBooks Commerce, go to the QuickBooks Commerce App Store by clicking Browse Apps on the left side bar.

Click on eCommerce, then click on the “WooCommerce” button.

Click the “Install App” button.

Please follow the step-by-step instructions provided in the setup wizard. Remember to check the 'My store uses WooCommerce 2.3 and below'.

You will be redirected to the following page. Select “Approve.”

Location Mapping

Let’s set up your fulfillment and inventory locations in QuickBooks Commerce.

If you created all of your locations when preparing your Settings in the previous module, you’ll be able to map them now. If not, you can create a new location now.

Once you’ve mapped all of your locations, click “Continue.”

Price List Mapping

Let’s set up your price lists by either mapping to an existing price list in QuickBooks Commerce or creating a new one now by clicking the “Create New” button.

For each product price list in WooCommerce, we will create an equivalent price list in QuickBooks Commerce.

When a product price is changed in WooCommerce or QuickBooks Commerce, we will update the latest price information to the mapped price list.

Initial Product Import

From within the QuickBooks Commerce installation wizard, choose how you would like you product information to be imported from WooCommerce to QuickBooks Commerce.

 

Options	What it does	Recommendation
Import Products Now	If selected, only during installation QuickBooks Commerce will import products from WooCommerce as new products in QuickBooks Commerce.   After installation, if you create a new product in WooCommerce, QuickBooks Commerce will import the product as a new product.   Any future updates that you want to make to your WooCommerce products should be done from within QuickBooks Commerce. This could include stock levels, prices, or product information.	QuickBooks Commerce customers select this option when they have not set up any products in QuickBooks Commerce during their trial. They will have reviewed their WooCommerce settings including inventory, product SKUs, and remove any installed app that could change their product inventory and pricing.
Import Products Later	If selected, QuickBooks Commerce will not import or match any products from WooCommerce during the installation.   QuickBooks Commerce will only import and manage orders from WooCommerce.   After installation, if you create a new product in WooCommerce, QuickBooks Commerce will import the product into the system.	QuickBooks Commerce's customers select this option when they have already created some or all of their products in QuickBooks Commerce prior to the installation process.   Some customers also prefer this option if they have existing products within WooCommerce that they don’t want to bring over to QuickBooks Commerce.

 

Review Order Import Status

In order to manage your WooCommerce orders in QuickBooks Commerce, you will need to:

1. Select which order statuses you want QuickBooks Commerce to import
2. Map WooCommerce’s order statuses with QuickBooks Commerce's order statuses so that inventory and orders can be updated accordingly

Orders have 5 statuses in QuickBooks Commerce (details here):

• Draft
• Active
• Finalized
• Fulfilled
• Void

Orders have 7 statuses in WooCommerce (details here):

• Pending Payment
• Failed
• Processing
• Completed
• On-Hold
• Canceled
• Refunded

In QuickBooks Commerce, go to the My Apps section, click on your WooCommerce store, then click the Settings tab.

Select the statuses you’d like to import and then map the appropriate order statuses to QuickBooks Commerce's order statuses.

Review what will Happen Next

When you complete the installation, depending on the sync options selected, QuickBooks Commerce will begin to:

1. Import your products from WooCommerce into QuickBooks Commerce
2. Import your Orders based on status mapping from WooCommerce into QuickBooks Commerce
3. Update product inventory levels, prices and product information

With the installation complete, QuickBooks Commerce will now be your business’ master of inventory. QuickBooks Commerce will update your WooCommerce products whenever there are changes made to stock levels, prices or product information.

 

Step 3 of 3: Reviewing & Testing your Integration Settings

Once your installation and import has completed, you’ll want to review and test the integration.

Reviewing your Products

Go to the My Apps section, click on your WooCommerce store and click the Products Listing tab to see if there are any products that were not imported successfully or could not be matched.

If there are any unlinked products, please submit a ticket here to contact a Gecko Guru.

Reviewing your Orders

To see any unfulfilled orders that were imported into QuickBooks Commerce, click here: https://go.tradegecko.com/orders

To see if there are any orders that were not imported successfully, go to the My Apps section and click on your WooCommerce store and click the Orders Listing tab. A Gecko Guru can help you fix this issue if you submit a ticket here.

(Optional) Create a test order from your WooCommerce store

To test the order sync between WooCommerce and QuickBooks Commerce, let’s create a test order from your WooCommerce Store.

From within WooCommerce, create a draft order for one of your products.

Mark the draft order as paid.

Go into QuickBooks Commerce. Navigate to the Sales Orders section to locate your order. You can search for it by entering the draft order number into the search bar.

Once identified, go back into your WooCommerce store to cancel the draft order.

(Optional) Updating a product’s price

To test the price sync we recommend that you complete this test with a product that is not marked as “available” within your WooCommerce store because the integration between QuickBooks Commerce and WooCommerce is now live.

From within QuickBooks Commerce, change the list price of the variant that you would like to test.

To confirm if the price change was successful, go into your WooCommerce account to review that variant’s “new” price.

(Optional) Publish a test product from QuickBooks Commerce to WooCommerce

To test the product sync, let’s create a new product in QuickBooks Commerce.

Go to the Inventory section, click on Products, then click the “Create New” button and create a “new purchased product.”

Once you create the product, publish the variant to your WooCommerce store via the dropdown menu on the far right-hand side of the variant listing. Note that only the first image in the variant will be published from QuickBooks Commerce to WooCommerce.

Don’t worry, this product will not be marked as visible on your store, QuickBooks Commerce's default publish setting is set to “unavailable.”

Go into your WooCommerce account and you should see this new product in the Product section.

From WooCommerce, delete this new test product. It will also be deleted in QuickBooks Commerce.

Congratulations - you’re done!

If there are any discrepancies, please submit a ticket here to contact Support.

Read next: Module 8: Shipping Integration Setup