QBISoftware Discuss your project
Open menu

Connector documentation

Connector documentation

An overview of how the store-to-QuickBooks Desktop connector is set up and used. The full manual ships with the connector; this page helps you plan before you install.

  • osCommerce
  • Zen Cart
  • CRE Loaded
  • osCMax
  • QuickBooks Desktop

Before you start

What you need in place

A supported cart

osCommerce, Zen Cart, CRE Loaded or osCMax with access to its files and MySQL database. Modified carts are fine; heavy changes may need a small tweak.

QuickBooks Desktop

A QuickBooks Desktop company file on a Windows PC, with an admin user who can authorise the connector.

A clean item list

Products in QuickBooks with names or SKUs you can match to the store. We can help tidy this first.

A backup

A fresh backup of the company file and the store database before the first import. Always.

Setup

Installation in five steps

The manual walks through each step in detail. Prefer not to? Our installation service does all of it for you.

  1. Install on the store

    Upload the connector files to your cart and point them at the store database.

  2. Link the company file

    Open QuickBooks Desktop as admin and authorise the connector to read and write the company file.

  3. Set the posting rules

    Choose whether orders become sales receipts or invoices, and pick the accounts for sales, shipping and fees.

  4. Map products and tax

    Match store products and attributes to QuickBooks items, and store tax classes to QuickBooks tax items.

  5. Run a test import

    Import a handful of real orders, compare them line by line with the store, then switch to the daily routine.

Mapping

What maps to what

The default rules. Each one can be adjusted to the way your books are kept.

Connector record mapping from store to QuickBooks Desktop
Store recordQuickBooks DesktopNotes
OrderSales receipt or invoiceChosen in the posting rules
Order lineItem lineMatched by product name or model/SKU
Product attributeSeparate item or descriptionSize, colour and similar options
ShippingShipping itemKept apart from product sales
Order taxSales tax itemPer store tax class
CustomerCustomer recordRepeat buyers match their existing record

Daily use

The daily import routine

Run the import

Start the import from the connector. New orders since the last run are picked up; earlier ones are not posted twice.

Review the log

The log lists each order with its result. Anything held has a reason you can act on.

Fix and re-run

Add the missing item or tax mapping, then run again. Held orders go through on the next pass.

Rather have it set up for you?

Our installation service covers setup, product and tax mapping, a test run on your real orders and training for your team.

Book installation service