← All articles

Blog

Moving from Spreadsheets or Accurate to Odoo for a Marketplace Business

Planning a move from spreadsheets or Accurate to Odoo while selling on Shopee, Tokopedia and Lazada? What to migrate, what it costs and what goes wrong.

6 min read
  • bottom
  • odoo
  • marketplace

If you sell mainly through marketplaces, moving to Odoo is worth it when your pain is order, stock and reconciliation work that spreadsheets or your current accounting software cannot absorb. It is not worth it just to “have an ERP”. The move is realistic in phases, usually over a few months, and the hardest part is rarely the software. It is cleaning data and agreeing how each marketplace’s money and stock should be recorded.

This article is a business-level view for owners and operations leads. Details such as pricing and platform rules change, so verify them in your seller center and with vendors before committing.

Signs the current setup has run out of road

  • Stock is updated by hand across Shopee, Tokopedia, Lazada, TikTok Shop and others, and overselling or cancellations are routine.
  • Month-end takes days because marketplace payouts, fees, returns and vouchers do not match your sales records.
  • Only one or two people understand the master spreadsheet, and nobody dares change it.
  • You cannot tell which SKU or channel actually earns money after fees, shipping subsidies and returns.
  • You add warehouses, bundles or a reseller channel, and the sheets break.

If only one of these applies, a lighter fix may be enough. Hold that thought for the section on alternatives below.

Spreadsheets versus Accurate versus Odoo

Spreadsheets are flexible and free, but they have no audit trail, no real stock locking and no safe way for several people to work at once.

Accurate is a widely used Indonesian accounting package, strong on local bookkeeping habits. Whether it handles your marketplace volume depends on the edition and any add-ons or third-party tools you use. Ask Accurate or your reseller exactly how marketplace orders get into it rather than assuming. Its public marketplace-integration content is general guidance and does not describe a built-in connector, so treat that as a question to confirm.

Odoo is a modular system that covers sales, inventory, purchasing, accounting and more in one database. Its Indonesian localization includes tax-related modules, and its official Indonesia documentation describes e-Faktur and Coretax XML export support, with requirements such as company and partner NPWP and PKP settings. Features depend on your Odoo version and edition, so confirm against the documentation for the version you plan to run.

The trade-off: Odoo gives you one system of record, but you take on implementation effort, configuration decisions and ongoing maintenance that a spreadsheet never asked of you.

What actually needs to move

DataTypical approachWatch out for
Products and SKUsClean, then importDuplicate or inconsistent SKUs across marketplaces, variants, bundles
Customers and suppliersImport after de-duplicationMarketplace customers are often masked or partial; see below
Opening stockCount, then load as of a cut-off dateStock sitting at fulfilment centres or in transit
Opening balancesLoad receivables, payables, bank and inventory as balanced entriesMismatch with your accountant’s closing figures
HistoryUsually summarized, not re-keyedFull order history rarely worth migrating line by line

Implementation guides commonly recommend setting a cut-off date (typically the day before go-live) and loading opening balances as balanced entries against dedicated opening counterpart accounts. See the implementation guide from Implex. This is a practitioner source, not official Odoo procedure, so have your accountant sign off on the approach.

How marketplaces connect to Odoo

Odoo does not talk to every Indonesian marketplace out of the box. Options generally fall into three groups:

  1. Third-party connectors sold on the Odoo Apps store. For example, IZI lists a Shopee connector for a specific Odoo version (17.0); the same publisher also lists Tokopedia and Lazada connectors, though the ones we saw are for older Odoo versions. Check which Odoo version each supports, what it syncs, and how it is maintained.
  2. Middleware or marketplace management tools that sit between channels and your ERP.
  3. A custom build for unusual needs, such as a channel with no ready connector.

Marketplace APIs and seller platforms change, including the ongoing Tokopedia and TikTok Shop consolidation, so any connector needs a maintainer who tracks those changes. Ask each vendor who fixes it when a platform changes, and how fast.

What it costs

Be wary of any single number. Your cost is made up of:

  • Odoo licence or hosting. Depends on edition, users and hosting choice. Check Odoo’s current pricing page.
  • Implementation. Configuration, data cleaning, accounting setup, training. This is usually the largest item and scales with the number of warehouses, channels and custom rules.
  • Connectors. One-off or subscription, per marketplace or bundled. Vendor pricing varies and changes.
  • Ongoing support. Updates, fixes when marketplaces change, and new reports.
  • Your own time. Someone on your side must own data decisions. Underestimating this causes more delays than any technical issue.

Ask for a written scope that separates these lines, and for what is excluded.

What goes wrong

  • Dirty SKUs. If the same product has three names, the new system just stores the mess faster. Clean first.
  • Fees and payouts. Marketplaces pay out net of commissions, shipping and vouchers, sometimes in batches that do not map to single orders. Decide upfront how these are posted and reconciled, and agree it with your accountant.
  • Customer data limits. Marketplaces often limit what buyer information sellers receive. Do not plan a CRM that depends on data you will not get. Indonesia’s personal data protection law (UU PDP) also matters for how you store what you do receive.
  • Stock timing. Syncs are not always instant. Safety buffers and clear rules for returns and cancelled orders matter more than raw speed.
  • Big-bang cutover. Switching everything on one weekend, especially before a campaign like 11.11 or 12.12, is a classic mistake.
  • Tax details. Invoicing and e-Faktur or Coretax handling should be tested with your accountant before go-live, not after.

A sensible order of work

  1. Pick the pain to fix first, usually stock and orders, then accounting.
  2. Clean product and customer data.
  3. Configure Odoo and test with one marketplace.
  4. Run old and new in parallel for a short period and compare totals.
  5. Add channels one at a time.
  6. Cut over after a month-end close, not in the middle of a promotion.

When a lighter option is enough

If you have one or two channels, low order volume and no multi-warehouse needs, a marketplace management tool plus your current accounting software may do the job at lower cost. Odoo makes more sense when you need inventory, purchasing, accounting and reporting in one place, or when you expect to grow into manufacturing, distribution or several entities.

When to get help

Bring in outside help when you have several warehouses, a lot of SKUs and variants, tax and invoicing complexity, or a hard deadline. A good partner will tell you what not to build and will be specific about what is out of scope.

If you are weighing this move, Teknologia Solutions is happy to have a no-charge conversation about your setup and whether Odoo is the right fit. No commitment, just an honest view.


Sources: Odoo Indonesia fiscal localization documentation; Implex opening balances guide; IZI Shopee connector listing on Odoo Apps; Accurate marketplace integration article. Information was checked in October 2026 and can change; verify features, versions, fees and tax rules against primary sources and your seller center.