What I Learned Building 35+ Marketplace Connectors

It Started with One Amazon Connector

In 2019, a client asked me to sync their Amazon orders with Odoo. "How hard can it be?" I thought. Three weeks later, after wrestling with Amazon's MWS API (now SP-API), throttling limits, and edge cases around multi-variant products, I had my answer: quite hard.

That first connector taught me more about distributed systems than any textbook. Today, I've built 35+ connectors spanning Amazon, Shopify, eBay, WooCommerce, Walmart, Daraz, Noon, and several regional marketplaces.

Patterns That Work

1. Queue Everything

Never process marketplace data synchronously. Orders, inventory updates, and price changes should all flow through a message queue. This gives you retry logic, rate limit handling, and the ability to replay failed operations.

2. Idempotent Operations

Marketplace APIs will send you the same webhook multiple times. Your connector needs to handle duplicates gracefully. I use a combination of external order IDs and processing timestamps to ensure an order is only created once in Odoo.

3. Separate Sync and Business Logic

The connector layer should only translate data between formats. Business rules (pricing, inventory allocation, fulfillment routing) belong in Odoo. This separation makes debugging infinitely easier.

Common Mistakes to Avoid

• Ignoring rate limits: Amazon's SP-API has strict throttling. Build in exponential backoff from day one.
• Hardcoding marketplace logic: Every marketplace has quirks. Use configuration over code wherever possible.
• Skipping error monitoring: Silent failures in integrations are devastating. Set up alerts for failed syncs immediately.

The Real Challenge: Multi-Channel

Single marketplace integration is straightforward. The complexity explodes when a business sells on 5+ channels simultaneously. Inventory allocation, order routing, and pricing rules across channels require careful architecture.

This is exactly the kind of problem I help businesses solve. If you're dealing with multi-channel chaos, check out my Architecture Review service.

---

Building a marketplace integration? I'd love to hear about your challenges. Reach out for a free consultation.