Skip to content

eCommerce Integration

QuickBooks & osCommerce Integration

QuickBooks integration with osCommerce automatically synchronises your product and customer information and accounting packages, and makes sure data is assigned to the proper related accounts.

You can export products, customers and orders, and import product information from the store manager to QuickBooks.

What's included

  • Real-Time Sync
  • Unlimited Syncing
  • Two-Way Sync
  • Tax Rate Import
  • Export Summaries

Key features

  • Real-time automatic sync
  • Unlimited syncing activity
  • Complete two-way sync
  • See an export summary and account balances
  • Makes your accounting effortless
  • Saves time and increases accuracy
  • Automatically imports tax rates for various tax companies

Common questions

Something not covered here? Ask us directly.

Does this work with osCommerce 2.3 and the newer Phoenix releases?

Yes. osCommerce is self-hosted and open source, so the integration works against the store database and admin API rather than against a hosted service. That covers the long-running 2.3 line and the community Phoenix builds, including stores carrying years of custom contributions.

Our osCommerce install has been heavily modified. Is that a problem?

It is the normal case. Most osCommerce stores still trading have accumulated custom modules and altered tables over the years. Because the mapping is defined per store rather than assumed, renamed fields and extra columns are handled at configuration time instead of breaking the sync.

Which QuickBooks records are created from an osCommerce order?

An order becomes a sales receipt or an invoice depending on whether payment was captured at checkout, with each product as a line item, shipping and handling on their own lines, and tax posted to the mapped tax code. The customer record is created or matched first, so no transaction is left unassigned.

How often does the sync run?

On a schedule you set: every few minutes for stores that need near-live figures, or once nightly for stores that only need the accounts to be right by morning. A lower frequency puts less load on a shared hosting account, which matters for older osCommerce installs.

Next step

Ready to move forward with osCommerce & QuickBooks?

Tell us about your current process and what you need the software to do. We will come back with a practical approach, a timeline and a cost.