| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Contacts (contacts)
• Discuss (mail) • Inventory (stock) • Invoicing (account) • Sales (sale_management) |
| Community Apps Dependencies | Show |
| Lines of code | 15885 |
| Technical Name |
wayfair_store_management |
| License | LGPL-3 |
| Website | https://www.ecosire.com/ |
| Versions | 17.0 18.0 19.0 |
|
ECOSIRE (PRIVATE) LIMITED
Enterprise E-commerce Solutions
|
v19.0.3.9.0 |
No installation required -- Instant access to all features
Wayfair Store Management
The most comprehensive Wayfair-to-Odoo connector on the market. Dual-channel integration via GraphQL API and SFTP/EDI. Dropship + CastleGate orders, full product catalog import, 6 EDI document types, and real-time analytics -- all from Odoo.
|
Wayfair
Supplier Portal
|
GraphQL
◄───►
◄───►
SFTP/EDI
|
Odoo
Your ERP Backend
|
Dual-Channel Integration
The first and only Odoo module to support both Wayfair channels simultaneously. Competitors offer one -- we deliver both.
|
Channel 1: Real-Time
GraphQL API
|
+
|
Channel 2: Batch
SFTP / EDI
|
How It Works
Get your Wayfair supplier portal connected in three steps
|
1
ConnectEnter your Wayfair OAuth2 Client ID and Secret. Configure SFTP credentials for EDI. One-click test connection validates both channels. |
➔ |
2
SyncImport your full product catalog via SFTP. Pull Dropship and CastleGate orders via GraphQL. Automated crons sync every 2-6 hours. |
➔ |
3
ManageRun your entire Wayfair supplier operation from Odoo. Accept POs, register shipments, push inventory, generate labels, and track revenue. |
Comprehensive Feature Suite
Everything a Wayfair supplier needs to run their business from Odoo. 69 API endpoints across 12 major domains.
Product Catalog
| ✓Full catalog import via Doc 832 |
| ✓Product addition + updates |
| ✓Image upload + primary image set |
| ✓Wholesale + MAP pricing |
| ✓Dimensions, categories, images |
| ✓Batch operations (100/request) |
Order Management
| ✓Dropship + CastleGate POs |
| ✓Accept with ship date estimates |
| ✓Reject lines with reason codes |
| ✓Backorder with new availability |
| ✓Auto-confirm + auto-invoice |
| ✓Auto-cancel with full reversal |
| ✓Doc 850 PO import via SFTP |
Shipping & Labels
| ✓Register shipment mutation |
| ✓Small parcel (FedEx, UPS, USPS) |
| ✓LTL freight (ABF, Estes, XPO) |
| ✓PDF labels + packing slips |
| ✓BOL + consolidated BOL |
| ✓Doc 856 ASN via SFTP |
Inventory (Drop-Ship)
| ✓TRUE_UP full snapshot feed |
| ✓DIFFERENTIAL changed SKUs |
| ✓Multi-warehouse support |
| ✓Dry-run validation |
| ✓Product discontinuation |
| ✓Doc 846 inventory via SFTP |
CastleGate / WFS
| ✓Inventory levels per warehouse |
| ✓On-hand, fulfillable, reserved |
| ✓Inbound shipment tracking |
| ✓Inventory adjustments (Beta) |
| ✓Warehouse transfers (Beta) |
| ✓CastleGate PO management |
Multi-Storefront
| ✓Wayfair (flagship) |
| ✓AllModern |
| ✓Birch Lane |
| ✓Joss & Main |
| ✓Perigold (luxury) |
| ✓Dashboard breakdown per brand |
Customer Management
| ✓Auto-extract from PO data |
| ✓Email-based deduplication |
| ✓Address enrichment |
| ✓Phone + ZIP normalization |
| ✓Storefront tagging |
| ✓Multi-company isolation |
Returns & Pricing
| ✓Returns portal deep-links |
| ✓RMA request management |
| ✓Credit memo + dispute tracking |
| ✓Wholesale price bulk updates |
| ✓MAP price enforcement |
| ✓Promotional + closeout pricing |
Analytics & Polling
| ✓Inventory analytics (OOS rate) |
| ✓Fulfillment analytics (ship rate) |
| ✓Supplier scorecard deep-link |
| ✓New order polling |
| ✓Label generation events |
| ✓Configurable poll intervals |
Automation Engine
| ✓Auto-confirm incoming orders |
| ✓Auto-create + validate invoices |
| ✓SFTP product sync (every 6h) |
| ✓SFTP order import (every 2h) |
| ✓SFTP inventory export (every 4h) |
| ✓Queue job system with retry |
OWL 2 Dashboard
| ✓6 KPI cards with period deltas |
| ✓Sales trend + order status charts |
| ✓CastleGate WFS status panel |
| ✓5-storefront breakdown |
| ✓Period filters (Today to Custom) |
| ✓60-second auto-refresh |
Security & Enterprise
| ✓7 security groups (User-Admin) |
| ✓Multi-company record rules |
| ✓Risk assessment + fraud detection |
| ✓Webhook endpoint security |
| ✓Payout reconciliation |
| ✓NEW v3.8: 100% auto-reconciliation via clearing account (zero-click settlement posting) |
| ✓NEW v3.11: Deductions & chargebacks parsed natively (Managed Returns, Missing Parts, Warranty, Replacement Cancellation, Reviews-for-Rebates) with CreditID + Reason audit trail |
| ✓25+ manual sync operations |
Full EDI Document Support
Six EDI document types for complete SFTP-based data exchange with Wayfair. No other Odoo module offers this.
| Document | Name | Direction | Description |
|---|---|---|---|
| 832 | Product Catalog | Inbound | Full product catalog with pricing, dimensions, images |
| 850 | Purchase Order | Inbound | Batch PO import from Wayfair to Odoo sale orders |
| 855 | PO Acknowledgment | Outbound | Confirm PO acceptance with expected ship dates |
| 856 | Advance Ship Notice | Outbound | Shipment notification with tracking and carrier details |
| 810 | Invoice | Outbound | Invoice export from Odoo to Wayfair accounts payable |
| 846 | Inventory Feed | Outbound | Inventory levels pushed to Wayfair (scheduled every 4h) |
Modern Dashboard Experience
OWL 2.0 dashboard with Chart.js. 6 KPI cards with period-over-period deltas, sales trend and order status charts, CastleGate WFS panel, 5-storefront breakdown, activity feed, quick actions, and dark mode. Auto-refreshes every 60 seconds.
By the Numbers
The most feature-complete Wayfair connector ever built for Odoo
Why Choose ECOSIRE?
Our $349 one-time connector vs. competitors with limited features and recurring fees
| Feature | ECOSIRE ($349) | Competitors |
|---|---|---|
| Dual Channel (GraphQL + SFTP) | ✓ | One channel only |
| EDI Documents (6 types) | ✓ | ✗ |
| Full Product Catalog via SFTP | ✓ | Order-based only |
| CastleGate / WFS Inventory | ✓ | ✗ |
| 5 Storefronts (AllModern, Perigold...) | ✓ | Wayfair only |
| OWL 2 Dashboard + Dark Mode | ✓ | ✗ |
| LTL + Small Parcel Shipping | ✓ | Small parcel only |
| Risk Assessment + Fraud Detection | ✓ | ✗ |
| Multi-Company with Record Rules | ✓ | ✗ |
| Odoo 17, 18, and 19 | ✓ | 1 version |
GraphQL API Coverage
All Wayfair GraphQL queries and mutations -- authenticated via OAuth2 Client Credentials with automatic token refresh.
Queries (Read)
| getDropshipPurchaseOrders |
| getCastleGatePurchaseOrders |
| getCastleGateWarehouseShippingAdvice |
| labelGenerationEvents |
| purchaseOrderErrors |
| transactions |
| orderCancellations |
Mutations (Write)
| purchaseOrderAccept |
| purchaseOrderReject |
| purchaseOrderBackorder |
| purchaseOrderShipment |
| purchaseOrderDelivery |
| inventoryFeedSubmit |
| inventoryFeedDryRun |
5 Storefronts, One Integration
Manage all Wayfair brands from a single Odoo instance
Technical Specifications
Built on proven, enterprise-grade technologies
Our Odoo Services
We don't just build apps — we provide end-to-end Odoo solutions to help your business grow
Custom Development
Custom modules, API integrations, workflow automation tailored to your Wayfair supplier operation.
Implementation
Full Odoo implementation including module installation, configuration, data migration, and user training.
Ongoing Support
Dedicated support for Wayfair API changes, Odoo upgrades, and ongoing optimization of your integration.
Ready to Transform Your Wayfair Business?
The only dual-channel Wayfair connector for Odoo. GraphQL + SFTP/EDI. Dropship + CastleGate. Five storefronts. One-time purchase -- no recurring fees.
Incremental Sync, Batch Processing & CastleGate Dashboard
Major reliability update with smart incremental sync, duplicate protection, batch commits, revenue-correct dates, and live CastleGate KPIs on the dashboard.
|
⚡
Incremental SyncUses instance.last_sync as batch start instead of a hardcoded 2-year backfill window. Only fetches new orders since last successful run. Automatically updates last_sync on completion. |
🛡
Duplicate ProtectionChecks both wayfair.order mapping AND sale.order client_order_ref before creating new orders. Existing manual orders are linked instead of duplicated. |
|
📦
Batch ProcessingCommits every 25 orders (BATCH_SIZE=25, MAX_PER_RUN=200) to avoid cursor timeout on large imports. Safe restartable -- picks up where it left off. |
📅
Revenue-Correct DatesAfter action_confirm() resets date_order in Odoo 19, the original PO date is written back. Invoice dates are set to PO date for accurate revenue recognition. |
|
🏰
CastleGate Dashboard KPIsDashboard now shows live CastleGate WFS metrics: CG order count, CG revenue, and active warehouse count. No more hardcoded placeholders. |
🔧
CastleGate Error HandlingCastleGate API errors (e.g. 500) are now non-fatal -- Dropship sync continues normally. Dashboard KPI fix removes redundant date re-filtering. |
Please log in to comment on this module