Amazon Store Management

The ECOSIRE Amazon Store Management module integrates your Amazon Seller Central account with Odoo using the modern Selling Partner API (SP-API). Manage listings, orders, inventory, and fulfillment across multiple Amazon marketplaces from a single Odoo instance. With support for both FBA and FBM workflows, settlement reconciliation, and automated repricing, this module streamlines your Amazon operations while keeping your ERP data accurate and up to date.

Compatibility: Odoo 17 / 18 / 19 Price: $499 (one-time) License: Up to 3 domain activations

Key Features

• SP-API integration with AWS Signature Version 4 authentication
• Multi-marketplace support (US, CA, MX, BR, UK, DE, FR, IT, ES, NL, SE, PL, TR, AE, IN, JP, AU, SG)
• FBA and FBM fulfillment workflows
• Settlement reconciliation with automatic journal entries
• A+ Content synchronization
• Automated repricing rules
• Multi-channel fulfillment (MCF)
• Advertising cost tracking
• Product listing management with ASIN/SKU mapping
• Return processing and refund management
• Inventory planning and restock alerts

Prerequisites

• Odoo 17, 18, or 19 (Community or Enterprise edition)
• An active ECOSIRE license for this module
• An Amazon Seller Central account with Professional selling plan
• Amazon Developer registration for SP-API access
• AWS IAM credentials (Access Key + Secret Key)
• LWA (Login with Amazon) Client ID and Client Secret

Installation

1. Download the module ZIP from your ECOSIRE Dashboard
2. Extract to your Odoo addons directory:

   unzip ecosire-amazon-*.zip -d /opt/odoo/addons/

3. Restart the Odoo service:

   sudo systemctl restart odoo

4. Navigate to Apps, click Update Apps List
5. Search for "ECOSIRE Amazon Store Management" and click Install
6. Enter your ECOSIRE license key when prompted

Configuration

Step 1: Obtain Amazon SP-API Credentials

1. Register as an Amazon Developer at Amazon Developer Central
2. Log in to Seller Central and navigate to Apps and Services > Develop Apps
3. Click Add new app client and provide your application details
4. Select the required API scopes:
   • Selling Partner Insights
   • Product Listing
   • Pricing
   • Inventory and Order Management
   • Fulfillment (Inbound and Outbound)
   • Finance and Accounting
   • Reports
5. After approval, note your Client ID, Client Secret, and Refresh Token
6. Copy your AWS Access Key and AWS Secret Key from your IAM role
7. Note the Role ARN associated with your SP-API application

Step 2: Connect in Odoo

1. Navigate to Amazon Store Management > Configuration
2. Enter your SP-API credentials:
   • Client ID (client_id) -- LWA Client ID
   • Client Secret (client_secret) -- LWA Client Secret
   • Refresh Token (refresh_token) -- LWA Refresh Token
   • AWS Access Key (aws_access_key) -- IAM Access Key ID
   • AWS Secret Key (aws_secret_key) -- IAM Secret Access Key
   • Role ARN (role_arn) -- AWS Role ARN (optional, for role-based auth)
   • Region -- na (North America), eu (Europe), or fe (Far East)
   • Marketplace -- select your target marketplace (US, UK, DE, etc.)
3. Click Test Connection to verify
4. Configure your default warehouse and company mapping

Step 3: Configure Sync Settings

Product Sync

• Choose sync direction: Amazon to Odoo, Odoo to Amazon, or bidirectional
• Set sync interval: scheduled (every 5, 15, or 60 minutes)
• Configure product field mapping and category mapping
• Map Amazon product identifiers (ASIN, SKU) to Odoo products

Inventory Sync

• Map Odoo warehouses to Amazon fulfillment centers
• Set buffer stock quantities if needed
• Enable real-time stock updates
• Configure FBA vs FBM inventory tracking separately

Order Sync

• Enable automatic order import
• Map Amazon payment methods to Odoo payment journals
• Configure fulfillment sync to push tracking numbers
• Set up settlement report reconciliation schedule

Initial Sync

1. Go to Amazon Store Management > Operations > Initial Import
2. Select data types to import (Products, Customers, Orders)
3. Set date range for historical orders
4. Click Start Import and monitor progress in the sync log

API Details

Field	Value
Auth method	AWS Signature Version 4 + LWA OAuth 2.0
Token URL	https://api.amazon.com/auth/o2/token
NA endpoint	https://sellingpartnerapi-na.amazon.com
EU endpoint	https://sellingpartnerapi-eu.amazon.com
FE endpoint	https://sellingpartnerapi-fe.amazon.com
Marketplaces	18 supported (US, CA, MX, BR, UK, DE, FR, IT, ES, NL, SE, PL, TR, AE, IN, JP, AU, SG)
Key config fields	client_id, client_secret, refresh_token, aws_access_key, aws_secret_key, role_arn

Dashboard

The built-in OWL 2 dashboard provides real-time visibility into your integration:

• 6 KPI cards -- Revenue, Orders, Customers, Products, Avg Order Value, and Sync Health -- each with period-over-period delta indicators
• Sales Trend chart (Chart.js line chart) with interactive date filtering
• Order Status breakdown (doughnut chart) showing distribution across statuses
• Period filters -- Today, 7 days, 30 days, 90 days, Year, or Custom date range
• Activity feed showing recent sync log entries with type indicators
• Quick action buttons for Products, Orders, Customers, Queue, Logs, and Settings
• Status footer with Queue Jobs, Errors, Out of Stock, and Sync Rate
• Auto-refresh every 60 seconds with dark mode support

Troubleshooting

Issue	Solution
Connection failed	Verify API credentials; check network connectivity
Sync not running	Check Odoo scheduled actions (cron jobs) are enabled
Duplicate products	Review product mapping; ensure SKU matching is configured
Orders not importing	Verify order status filters and date range settings
Signature mismatch	Verify AWS Access Key, Secret Key, and Role ARN are correct
Marketplace not found	Ensure the marketplace code matches your Seller Central region
FBA inventory discrepancy	Check FBA vs FBM inventory tracking settings
Settlement import errors	Verify finance API scope is enabled on your SP-API application
License not active	Verify your ECOSIRE license key at Settings > ECOSIRE License

Support

• General Troubleshooting
• Email: [email protected]
• Support Portal