Quickbooky

Accounting News

App Integrations

Magento to QuickBooks Online: the connector setup choices that trip merchants

Merchants connecting Magento to QuickBooks Online can finish the sync setup in one sitting once they know which workflow and order settings to pick.

COMMUNITY ISSUESQUICKBOOKY

The question keeps landing wherever QuickBooks Online merchants also sell on Magento: how do sales, products, and stock move across without double entry? The answer that settles it, in Intuit’s maintained setup guidance, is QuickBooks Connector, the service built on the old OneSaas platform. The setup is genuinely short. The screen-level choices inside it are where the confusion lives.

A familiar dead end

People usually arrive at the connector after a stretch of manual re-entry or a spreadsheet shuffle. The symptoms read the same each time: sales recorded twice or not at all, product records that disagree, and inventory counts nobody trusts. The tool adds its own small confusion. It was known for years as OneSaas, and plenty of merchants still search under that name. The current branding is QuickBooks Connector, and the service underneath is the same.

Connect both apps first

The connector sits between your storefront and your books, and neither side can use it until you link them. That makes the connections step one. Inside the connector dashboard, add Magento, then add QuickBooks Online. Both links must be live before any configuration appears. When it does, select Manage to enter the setup proper. One note from Intuit applies if a third app is involved: you will configure it during this same flow rather than afterward.

Three workflows, none of them required

Configuration opens with a choice of three workflows, and all of them are optional. One carries Magento sales into your books. Another carries Magento products across. The third runs in reverse: when inventory tracking is switched on in QuickBooks Online, the connector reads those levels and pushes updates back to the storefront. Nothing forces an all-or-nothing launch. A sales-only start is entirely legitimate, and it keeps the first sync easy to inspect.

Which orders become invoices or receipts?

The sales workflow asks two questions before anything moves. First, which Magento order statuses should be retrieved? Beginning with completed orders only is the cautious route. Adding pending statuses pulls data in sooner, but it also imports sales that might still be cancelled or edited. Second, you choose how each order appears in the books, either as a sales invoice or as a sales receipt.

That second choice deserves more thought than the screen suggests. Receipts suit stores that capture payment in full at checkout. Invoices suit net terms, deposits, or any sale you expect to settle in stages. Match the choice to how your customers actually pay. Changing it later changes the shape of your records.

Order number prefixes earn their keep

Deeper in the setup sits an option to prefix every retrieved order number. Enter Mag- and a Magento order numbered 1234 arrives in the books as Mag-1234. The idea looks cosmetic until several stores or channels share one connector. Distinct prefixes make each invoice’s origin obvious at a glance. They also keep invoices from different sources, with similar internal numbering, from looking identical during reconciliation.

Advanced options can wait

One screen, labelled Default Product and Advanced Options, offers finer control over how sales appear in the books. Intuit’s own suggestion is to leave it blank and come back later, and we agree. Land one clean order first, then tune. The early decision worth making is whether unmatched line items should fall back to a default product, so a stray item has somewhere to land instead of troubling the sync.

Decide the master before the first sync

Before data moves anywhere, decide which system owns which numbers. Enable the inventory workflow and QuickBooks Online becomes the side that updates Magento. Hand-editing stock in the storefront while that workflow runs invites drift, because those edits do not flow back. The same discipline applies to products and customers. Name one master for each kind of data, and edit only on that side.

A staged rollout beats a big switch

Our suggestion is to widen the sync gradually. Point the connector at a narrow slice of recent orders, or at a single status, and let it run. Then open the resulting document in the books and inspect it end to end: customer, amounts, tax, shipping, and the payment line. Once one order looks right, open the tap fully. Intuit describes the whole setup as a matter of minutes, and that holds once the decisions above are made.

The short version

The fix that closes this recurring question is unglamorous. Connect both apps, answer the workflow and order-type questions deliberately, then sync in stages. Merchants who rush the status and document-type choices tend to revisit them later. Those who pause over those two screens rarely do.

← Back to Community Issues