Odoo for Import/Export Businesses: Essential Apps and Setup Guide 2026

TL;DR: Import and export businesses lose hours every week to spreadsheets, manual paperwork, and disconnected tools. Odoo replaces QuickBooks + Trello + Google Sheets with one unified ERP. The essential apps are Purchase, Inventory, Sales, Accounting, and the Customs Duties add-on. Setup takes 1-2 days and gives you real-time visibility on stock, shipments, and true product cost.

The Real Pain of Running an Import/Export Business on Spreadsheets

On Reddit, a small business owner recently asked for ERP recommendations and said it plainly: "We're an import/export business. There is a large amount of paperwork and documentation." That single sentence captures the daily reality of trading companies everywhere.

Another user in r/smallbusiness described the typical stack: "A lot of small import/export folks lean on tools like QuickBooks for finances, Trello for tracking shipments and tasks, and Google Sheets for keeping tabs on inventory." It works at first. Then it breaks.

The problems multiply quickly:

• Three Excel tabs for shipments: one for in-transit, one for delivered, one for archive. A logistics professional on Reddit described keeping "4 piles of paperwork" alongside those tabs.
• No visibility on true cost: You know the supplier invoice amount, but what about freight, insurance, customs duties, and port handling? Those costs often get forgotten or averaged incorrectly.
• HTS code and tariff surprises: A small business owner researching tariffs asked, "Do you use customs brokers, freight forwarders, spreadsheets, or just guess and deal with it later?" Guessing leads to margin-killing surprises.
• Landed cost confusion: An Odoo user posted, "Having trouble configuring Landed cost. This seems like such a simple problem but it seems like I'm getting no help." Another reported, "Odoo increases the value of the entire lot, not just the portion received."

These are not edge cases. They are the standard operating experience for small and mid-sized importers who have outgrown their starter tools but are not sure what comes next.

Why Odoo Fits Import/Export and Trading Companies

Odoo is an open-source ERP with modular apps. For a trading company, the appeal is simple: one database connects purchasing, inventory, sales, accounting, and shipping. No more copying data between QuickBooks, Trello, and Google Sheets.

A user on r/ERP considering solutions for a sourcing and trading company said, "I would rather start with a not perfect solution like Odoo and later on pay a developer to make it fit better." That is a smart strategy. Odoo Community is free. The core apps cover 80% of what a trading company needs. You customize the remaining 20% as you grow.

Key advantages for import/export:

• Unified product database: One product record carries HS codes, supplier info, reordering rules, and multi-currency pricing.
• Multi-currency built in: Purchase in USD, sell in EUR, report in your local currency. Exchange rate updates are automatic.
• Landed cost support: Odoo Inventory can allocate freight, insurance, and duties to the product cost. The Customs Duties add-on automates HS code tariff lookup.
• Multi-company and multi-warehouse: Manage a trading office, a bonded warehouse, and a distribution center under one system.
• Scalable pricing: Start on Community (free) and move to Enterprise only when you need advanced features.

Essential Odoo Apps for Import/Export Businesses

Not every app matters equally. For a trading company, these are the essential modules to enable first:

1. Purchase

This is where your import workflow starts. Create purchase orders in the supplier's currency, set expected arrival dates, and track receipt status. Use reordering rules to automate restocking when inventory hits minimum levels.

Setup tip: Create a separate vendor record for each supplier. Fill in the currency, payment terms, and default incoterm (FOB, CIF, DDP). This saves time on every future PO.

2. Inventory

Inventory is the heart of a trading business. Odoo tracks stock by location, lot, and serial number. For imports, the key feature is landed costs. After receiving goods, create a landed cost record and allocate freight, insurance, customs duties, and port fees to the product valuation.

Common pitfall: Users often struggle because landed costs must be linked to the correct transfer document. As one Reddit user noted, "You have to find and select the transfer document associated with the original PO... navigating back to it is a bit of a pain." The fix is simple: always generate the landed cost from the receipt, not from the PO directly.

3. Sales

Create quotations and sales orders with customer-specific pricelists. For export sales, set up multi-currency pricelists and tax mappings per country. Odoo can generate proforma invoices and commercial invoices from the same sales order.

4. Accounting

Odoo Accounting replaces QuickBooks. It handles multi-currency transactions, bank reconciliation, and automated exchange rate gains/losses. For trading companies, the critical setup is configuring the chart of accounts to separate cost of goods sold, freight expenses, and customs duties.

5. Customs Duties Add-on (Odoo Skillz)

Standard Odoo does not include HS code tariff lookup. The Customs Duties add-on fills this gap. It lets you define harmonized codes on products or categories, then automatically calculates customs duties and other landed costs during receipt. This eliminates the spreadsheet lookup and reduces tariff surprise errors.

Step-by-Step Setup for a Trading Company

Here is a practical setup sequence that gets you operational in 1-2 days:

Step 1: Configure Your Company and Warehouses

Go to Settings > Companies and set your base currency, country, and fiscal localization. Then create warehouses for each physical location: main warehouse, bonded warehouse, and any transit locations.

Step 2: Set Up Product Categories with Inventory Valuation

Navigate to Inventory > Configuration > Product Categories. Set Inventory Valuation to Automated and Costing Method to FIFO or Average Cost. This ensures that landed costs are added to the product valuation automatically.

Step 3: Add Products with HS Codes

Create your product catalog. For each imported item, fill in:

• HS Code (used for customs declaration)
• Country of origin
• Supplier info and purchase price
• Reordering rules (min/max quantities)

If you use the Customs Duties add-on, the HS Code field appears on the product form and links directly to tariff rate tables.

Step 4: Configure Landed Cost Types

Go to Inventory > Configuration > Landed Cost Types. Create entries for freight, insurance, customs duties, and port handling. Link each to the correct expense account in Accounting.

Step 5: Create a Purchase Order and Receive Goods

Create a PO in the supplier's currency. Confirm and receive the goods. The receipt creates a stock valuation entry at the PO price.

Step 6: Apply Landed Costs

Create a Landed Cost record, select the transfer (receipt), and add the cost lines. Click Compute and Validate. Odoo distributes the costs across the received products based on quantity, weight, or volume.

Step 7: Sell and Invoice

Create a sales order, deliver the goods, and invoice the customer. The cost of goods sold is automatically calculated from the landed inventory valuation.

Real-World Pain Points and How Odoo Solves Them

Pain Point: "We have 3 Excel tabs and 4 piles of paperwork"

Odoo solution: Purchase orders, receipts, landed costs, and sales orders are all in one system. Documents are generated automatically. No more duplicate data entry.

Pain Point: "Landed cost affects the entire lot across warehouses"

Odoo solution: When you use per-warehouse inventory valuation, landed costs are applied only to the warehouse where the goods were received. Use internal transfers with proper valuation accounts to move stock between warehouses without distorting costs.

Pain Point: "HTS codes and tariff surprises"

Odoo solution: The Customs Duties add-on stores HS codes on products and automatically looks up tariff rates during landed cost calculation. You see the true cost before the goods arrive.

Pain Point: "We outgrew QuickBooks but NetSuite is too expensive"

Odoo solution: Odoo Community is free. Odoo Enterprise starts at a fraction of NetSuite's cost. You add apps as you need them instead of buying a bloated suite.

FAQ

References

• Odoo Documentation: Landed Costs
• Odoo Forum: Import/Export Shipment Business Module
• Odoo Forum: Different Landed Costs for Each Item
• Reddit r/smallbusiness: ERP for Import/Export Business
• Reddit r/Odoo: Having Trouble Configuring Landed Cost
• Reddit r/smallbusiness: Handling HTS Codes and Tariff Surprises
• Odoo Skillz: Customs Duties Add-on