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.
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.
Before you start
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.
A QuickBooks Desktop company file on a Windows PC, with an admin user who can authorise the connector.
Products in QuickBooks with names or SKUs you can match to the store. We can help tidy this first.
A fresh backup of the company file and the store database before the first import. Always.
Setup
The manual walks through each step in detail. Prefer not to? Our installation service does all of it for you.
Upload the connector files to your cart and point them at the store database.
Open QuickBooks Desktop as admin and authorise the connector to read and write the company file.
Choose whether orders become sales receipts or invoices, and pick the accounts for sales, shipping and fees.
Match store products and attributes to QuickBooks items, and store tax classes to QuickBooks tax items.
Import a handful of real orders, compare them line by line with the store, then switch to the daily routine.
Mapping
The default rules. Each one can be adjusted to the way your books are kept.
| Store record | QuickBooks Desktop | Notes |
|---|---|---|
| Order | Sales receipt or invoice | Chosen in the posting rules |
| Order line | Item line | Matched by product name or model/SKU |
| Product attribute | Separate item or description | Size, colour and similar options |
| Shipping | Shipping item | Kept apart from product sales |
| Order tax | Sales tax item | Per store tax class |
| Customer | Customer record | Repeat buyers match their existing record |
Daily use
Start the import from the connector. New orders since the last run are picked up; earlier ones are not posted twice.
The log lists each order with its result. Anything held has a reason you can act on.
Add the missing item or tax mapping, then run again. Held orders go through on the next pass.
Keep reading
Our installation service covers setup, product and tax mapping, a test run on your real orders and training for your team.