Connecting Ecwid to QuickBooks Online: What the Sync Options Actually Do
A walkthrough of the configuration choices available when linking an Ecwid storefront to QuickBooks Online through a third-party connector, and how each setting shapes the data that lands in your books.
Ecwid store owners who want their sales data flowing into QuickBooks Online face a layered setup process through third-party connector platforms. Before a single order syncs, the connector requires several baseline configuration decisions that determine how every subsequent transaction will be recorded — and getting these choices right from the start saves significant reconciliation work later.
Setting the Foundation
The initial configuration screen asks for three things: the account timezone, the integration’s starting date, and preferences for email sync reports. The timezone ensures that order timestamps align correctly between the storefront and the accounting system, while the starting date controls how far back the connector should reach when pulling historical orders. The email report option keeps store owners informed about sync activity and any errors that surface during automated runs.
Choosing Your Workflows
Once the basics are in place, the connector presents a series of optional workflows. Store owners can enable any combination depending on their operational needs. The available workflows cover the most common data movements between an e-commerce platform and accounting software.
Sales from Ecwid can be sent to QuickBooks Online as either an invoice or a sales receipt — a choice that depends on whether the business typically bills customers upfront or invoices them for later payment. Products created in Ecwid can be automatically generated as items in QuickBooks Online, keeping the two product catalogs in lockstep. Inventory enthusiasts can also enable stock-level updates that flow in the reverse direction, pushing quantity changes from QuickBooks Online back to Ecwid so the storefront reflects accurate availability.
Filtering Which Orders Get Pulled
Not every order needs to reach the accounting system. The connector provides filters based on Ecwid order status, letting store owners restrict sync to orders that have reached a particular stage — paid, fulfilled, or another milestone. This prevents half-completed or abandoned orders from cluttering the books.
Order Numbers and Prefixing
One of the more useful configuration options is the order number prefix. Because Ecwid assigns its own sequential order numbers, and QuickBooks Online has its own numbering scheme, collisions and confusion can arise. The prefix solves this elegantly: a store owner who adds “EW” as a prefix will see Ecwid order 1234 arrive in QuickBooks as EW1234. This makes tracing transactions back to the original storefront order straightforward during reconciliation.
Alternatively, store owners can disregard the Ecwid order number entirely and let QuickBooks Online apply its own sequential invoice numbering. This appeals to businesses that prefer a single uninterrupted numbering sequence across all sales channels.
Customer Record Behavior
Every sale in QuickBooks Online needs a customer attached to it, and the connector offers three ways to handle this requirement. The default preserves the original customer from Ecwid, creating a matching record in the accounting system. If Ecwid customers typically provide a company name during checkout, the connector can use that organization name instead of the individual’s name — a preference for B2B operations. The third option sidesteps individual customer records entirely by mapping all sales to a single generic “Ecwid” customer, which simplifies the books at the cost of per-customer granularity.
Classes, Locations, and Line-Item Mapping
For QuickBooks Online subscribers who have enabled class tracking or location tracking, the connector can assign all synced Ecwid sales to a default class or location. This is particularly useful for businesses running multiple sales channels and wanting clean segment reporting.
On the line-item side, the connector accommodates several common e-commerce scenarios. Store owners can designate a specific product item to capture discounts applied at checkout, ensuring discount activity is tracked cleanly rather than netted against revenue. A separate rounding item handles the small discrepancies that arise when tax calculations produce fractional cents. Shipping charges — a frequent source of mapping frustration — get their own designated item so that shipping revenue is visible and trackable rather than buried in a generic sales total.
Finally, the connector can suppress notes from Ecwid orders and instead apply a default customer message that already exists on the QuickBooks Online invoice template, keeping the accounting side clean and consistent.
The Bottom Line
The depth of these configuration options reflects a central reality of e-commerce accounting integrations: no two stores handle their books the same way. The connector’s value lies in accommodating those differences — but it also means the setup decisions carry real weight. A generic customer mapping chosen for convenience today can make per-customer profitability reporting impossible tomorrow. Taking the time to understand each option before flipping the switch is the difference between a sync that runs quietly in the background and one that creates more cleanup work than it prevents.