Connector support
Connector troubleshooting
Most import problems come down to a handful of causes: the company file, a missing item, a tax mapping or a duplicate record. Here is how to spot and fix each one.
Start here
Quick checklist
Run through these four checks first. They solve most failed imports.
-
QuickBooks is open
The correct company file is open in QuickBooks Desktop, and no modal window is waiting for input.
-
The connector is authorised
The connector is still allowed to access the file. An update or a new admin user can reset this.
-
The log is read
Open the import log and note the exact message on the held order. It names the record at fault.
-
A backup exists
Before you change mappings or re-run a large batch, back up the company file.
Common issues
Problems and fixes
The connector cannot reach QuickBooks.
QuickBooks Desktop must be running with the right company file open, and the connector must be authorised in it. Open the file as admin, check the integrated-application settings and run the import again.
An order was skipped with “item not found”.
The order contains a product with no matching QuickBooks item. Add the item in QuickBooks or map the product to an existing one, then re-run. The held order posts on the next pass.
Products with attributes import wrongly.
Attribute combinations such as size and colour need their own mapping rule. Decide whether each option is a separate item or part of the line description, and set the rule once.
Sales tax in QuickBooks does not match the store.
Each store tax class must map to a QuickBooks sales tax item with the same rate. Check the mapping for the tax class on the affected order, and compare rounding settings.
The same customer appears twice.
Customers are matched on name and contact details. Spelling differences between orders create a second record. Merge the duplicates in QuickBooks and keep the store record consistent.
An order imported twice.
This usually follows a restored backup or a reset import marker. Void the duplicate in QuickBooks and check that the import starts from the correct last order before the next run.
Totals are off by a few cents.
Rounding differs between the store and QuickBooks when discounts or tax apply per line. Align the rounding rule, or post the difference to a small rounding item.
Keep reading
Related pages
Still stuck?
Send us the log message and your cart version. A developer who knows the connector will reply.