Faire Wholesale Connector
Import Faire products, orders, and retailers into Odoo, with store-wise workflows that drive fulfillment automatically.
Connect Odoo to the Faire wholesale marketplace on a store-by-store basis. Import products with variants, prices, images, and stock levels; bring orders in as Odoo sales orders with commission and payout fee already deducted; and let each Faire status decide whether Odoo confirms, delivers, invoices, registers payment, or cancels. A dashboard and per-record sync logs show exactly what came through.
Why this module is essential
Brands selling through Faire end up maintaining the same information twice. Faire holds the live catalog, the retailer accounts, and the current status of every order. Odoo holds inventory, costing, deliveries, invoices, and payments. With no link between the two, staff retype orders line by line, on-hand quantities drift away from what the marketplace shows, and a sales order can still sit in draft long after the goods have been delivered. Finance teams have to calculate net revenue by hand, because Faire’s commission and payout fee never reach the Odoo order at all.
Faire Wholesale Connector brings Faire data into Odoo one store at a time. Each store holds its own access token, warehouse, pricelist, and order workflow. Products arrive with their variants, prices, images, and Faire stock levels. Orders arrive as Odoo sales orders with commission and payout fee already deducted, and the Faire status decides whether Odoo confirms the order, validates the delivery, raises the invoice, registers the payment, or cancels it.
Multi-Store Faire Configuration
Status-Driven Order Automation
Net Payout Visible Per Order
Faire Stock Levels In Odoo
Traceable Per-Record Sync Logs
Store-Level Faire Dashboard
Standout Features
Six areas of functionality, each covering a task that would otherwise be done by hand.
Store-Wise Configuration
Every Faire store is a separate record holding its own access token, warehouse, pricelist, and order workflow. A Sync Brand Profile button authenticates against Faire and stores the returned brand ID, currency, and locale, so the connection is proven before any data is imported.
Catalog and Variant Import
Product imports create or update Odoo products with Faire identifiers, wholesale and retail prices, minimum order quantity, case size, country of origin, and main image. Faire variant options become Odoo product attributes, and each variant keeps its own Faire variant ID, SKU, and barcode.
Faire Stock Levels in Odoo
Available quantities returned by Faire are applied as an inventory adjustment in the store’s configured warehouse. Because the warehouse is set per store, businesses shipping Faire orders from a dedicated location keep those quantities separate from their other sales channels.
Status-Driven Order Workflows
Each workflow maps a Faire order status to the actions Odoo should take: confirm the order, create or validate the delivery, create or post the invoice, register the payment, lock, cancel, or raise a to-do activity for review. A ready-made Standard Fulfillment workflow is included, and stores with no workflow selected fall back to built-in status handling.
Net Revenue on Every Order
Faire’s commission amount and payout fee are added to the imported sales order as negative service lines, so the order total reflects the expected payout rather than the gross retailer price. Commission basis points, total payout, and net tax are stored on the order for reconciliation against Faire statements.
Dashboard, Sync Logs, and Order Readiness Report
A dedicated dashboard shows product, order, customer, and inventory figures for one store or all of them, with breakdowns by Odoo state and Faire state. Every record processed by the sync wizard is logged with its status and message, and an Excel report flags which Faire order lines already exist in Odoo.
Automation and Validation Rules
The module changes behaviour in four areas of Odoo. What happens in each is governed by the settings held on the Faire store record.
Store Configuration and Scheduled Sync
The store record is the single control point. There is no separate global settings page to maintain.
- API Base URL and API Key, with the key held as a masked field
- Warehouse applied to imported orders and to stock adjustments from that store
- Pricelist applied to sales orders created for that store
- Order Workflow that determines what Odoo does at each Faire status
- Connection status of Not Tested, Connected, or Connection Error, shown on both the list and the form
- An hourly scheduled action, Faire: Auto Sync, supplied switched off, which processes only active stores whose connection has been confirmed
Products and Inventory
Imports write to standard Odoo product records rather than to a separate staging model.
- Single-variant Faire products are matched on SKU; all products are matched on Faire Product ID
- Matched products are updated in place, with name, description, prices, barcode, and main image refreshed from Faire
- Imported products are set as storable and sales-enabled, and purchasing is switched off
- Faire variant options create Odoo product attributes and values for multi-variant products
- Faire available quantity is applied as an inventory adjustment in the store’s warehouse
- Publish and Unpublish buttons on the product’s Faire Connector tab change the product’s lifecycle state on Faire
Sales Orders, Invoicing, and Payments
Faire orders become standard Odoo sales orders carrying a Faire Details tab.
- An order is created only once every line item can be matched to an Odoo product; otherwise it is skipped and the unmatched items are named in the log
- Order lines are priced from the store pricelist where a rule applies, and from the Faire line price otherwise
- Commission and payout fee are added as negative service lines so the total reflects the net payout
- Faire order ID, display ID, source, status, ship-after date, PO number, free-shipping reason, and customer notes are stored on the order
- Where the workflow calls for it, Odoo confirms the order, validates the delivery, creates or posts the invoice using the workflow’s invoice journal, and registers payment using its payment journal
- A Register Faire Payment button on the order posts and reconciles a payment for posted, unpaid invoices
Retailers and Sync Monitoring
Retailer records are built from Faire order data, since Faire exposes no separate retailer endpoint.
- Retailers are matched on Faire Retailer ID and created as Odoo customers when not found
- Business name, billing address, phone, country, state, Faire Insider flag, and first order date are stored on the contact
- A Faire Wholesale tab on the contact form groups the Faire fields
- Each store shows Products, Orders, and Retailers counters that open those records filtered to the store
- Sync wizard runs write one log entry per record, with a success, skipped, or failed status and a message
Functional Walkthrough
Scope and How Sync Works
Need Custom Odoo Adjustments?
Get enterprise grade configurations, marketplace setup assistance, and specialized integrations tailored to your workflow.
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) • Invoicing (account) |
| Lines of code | 3407 |
| Technical Name |
faire_connector |
| License | LGPL-3 |
| Website | https://onestopodoo.com |
Please log in to comment on this module