Odoo and SQL Accounting Synchronization: Real-Time, Two-Way Data Sync

How a simple API connection keeps master data, purchasing, and warehouse operations perfectly in sync , without a single manual re-entry.

If your business runs Odoo for operations and SQL Account for finance and accounting, you already know the pain of keeping both systems in agreement. A new vendor gets added in one system but not the other. A receipt is posted in the warehouse, but accounting doesn't see it until someone remembers to key it in. Stock gets adjusted on the floor, and the books quietly fall out of sync.

This kind of manual double-entry doesn't just waste time , it's where costly mistakes creep in: mismatched stock counts, missing purchase records, and vendor details that drift apart between systems. The fix is a direct, automated integration between Odoo and SQL Account, built on a simple API connection that keeps both platforms talking to each other in real time.

In this post, we'll walk through exactly how the integration is structured, what data flows in each direction, and how to set it up in Odoo.

How the Integration Works

The integration is bidirectional by design. Each system stays the "source of truth" for the data it naturally owns, and the API keeps the other system updated automatically:

Direction	What Moves
SQL → Odoo	Contacts (Customers & Vendors), Products, Purchase Orders (POs), and Delivery Orders (DOs)
Odoo → SQL	Receipts, Scrap Orders, and Inventory Adjustments

In short: your master data and purchasing documents originate in SQL Account and flow into Odoo, ready to use on the warehouse floor. Once operations happen in Odoo — a receipt is validated, stock is scrapped, or an inventory count is adjusted — those results flow straight back into SQL Account, with no manual re-entry required on either side.

Setting It Up in Odoo

The entire integration is configured and monitored from inside Odoo. Here's what that looks like in practice, step by step.

Step 1  ·  Add the SQL Account API Keys in Settings

Everything starts with a single configuration screen. Under Settings, a dedicated SQL Account Sync page lets you connect Odoo to your SQL Account environment by entering the Access Key and Secret Key issued by SQL Account, along with the API URL, version, and region for each sync type.

This page is organized into three clear blocks, matching the three Odoo-to-SQL sync flows: Receipts, Stock Issue (Scrap), and Stock Adjustment (Inventory). Each block has its own toggle, so you can enable — or temporarily pause — auto-sync for that document type independently, without affecting the others.

Step 2  ·  Receipt Validation Syncs Automatically to SQL

Once the keys are in place, the sync runs on its own. The moment a warehouse Receipt is validated in Odoo — moving from Ready to Done — the integration fires automatically and pushes the receipt details across to SQL Account: no export, no re-keying, no waiting on a nightly batch job.

On the receipt itself, a live status badge confirms the outcome, and the chatter log timestamps exactly when the sync happened, giving your team full traceability on every transfer.

Step 3  ·  Scrap Orders Sync to Stock Issue Records

Damaged, expired, or written-off stock is a routine part of warehouse life — and it needs to be reflected in the books just as quickly as any other movement. When a Scrap Order is created and validated in Odoo, it's automatically mapped and pushed to SQL Account as a Stock Issue record.

Just like receipts, the scrap order's detail view shows the sync status and the timestamp of the last sync attempt, so any issues are visible immediately rather than discovered days later during reconciliation.

Step 4  ·  Inventory Adjustments Sync to Stock Adjustment Records

Physical stock counts and inventory corrections follow the same pattern. When an Inventory Adjustment is applied in Odoo, it's synced to SQL Account as a corresponding Stock Adjustment record , keeping your accounting stock valuation aligned with what's actually on the shelf.

Why This Matters

No more duplicate data entry

Contacts, products, purchase orders, and delivery orders created in SQL Account appear in Odoo automatically, ready for warehouse teams to use.

Accounting stays current in real time

Receipts, scrap, and inventory adjustments post to SQL Account the moment they're confirmed in Odoo — not at the end of the day or week.

Fewer reconciliation headaches

Because both systems update from the same trigger, stock levels and financial records stay aligned without manual cross-checking.

Full traceability

Every synced document carries a visible status badge and timestamp, and dedicated issue logs make it easy to spot and fix anything that didn't go through.

Granular control

Each sync flow — Receipts, Scrap, and Inventory Adjustments — can be switched on or off independently from a single settings page.

The Bottom Line

Integrating Odoo with SQL Account turns two separate systems into one connected workflow. Master data and purchasing flow in from SQL Account, warehouse activity flows back out automatically, and both sides of the business , operations and accounting , work from the same up-to-date numbers.

The result is less manual work, fewer errors, and a lot more confidence that what's on the shelf matches what's in the books.