What had to work
The seller needed reliable synchronization of shipped Amazon orders and financial events across several European marketplaces while keeping warehouse routing, currency, tax and returns consistent in Odoo.
How Odoo was shaped around it
- FBA/FBM warehouse selection and ASIN-based product matching
- Marketplace-specific tax and tax-inclusive price normalization
- Customer invoice creation from imported Amazon orders
- Full and partial refund processing through Odoo credit notes
- Amazon commission/FBA fee vendor bills and FBA return reports
Technical implementation
- Amazon SP-API Orders, Finances, Reports and Login with Amazon token services
- Access-token reuse, pagination and duplicate-order prevention
- Date-range validation and rate-limit/token-refresh handling
- Metadata propagation through sale.order, account.move, stock.picking and stock.move
- Near-real-time shipped-order updates using Amazon SQS and AWS Lambda
Operational result
Marketplace operations were connected to Odoo sales, inventory and accounting flows with traceable Amazon metadata across orders, deliveries, invoices, refunds and returns.