Odoo + Le New Black integration overview
Odoo is an open-source ERP that manages production, distribution and financials in a cloud-based software. Le New Black offers a collaborative B2B portal for your team and retailers, and an order-taking iPad app for your sales team.
The connector uses the Odoo API to exchange data (read docs) |
|
Le New Black drives all data flows: it triggers every push and pull operation |
|
The connector requires basic configuration in Le New Black and Odoo |
Data flows
| Type | Flow |
| Customers | Odoo ⇢ Le New Black |
| Customer addresses | Odoo ⇢ Le New Black |
| Prices | Odoo ⇢ Le New Black |
| Inventory stock levels | Odoo ⇢ Le New Black |
| Orders | Odoo ⇠ Le New Black |
Data flow: Customers
Odoo contacts are imported as customers with their address, their invoice address and the fiscal position, price list and payment terms the orders data flow sends back to Odoo.
Reference
Trigger: Scheduled task, active once Le New Black has set up the flow for your brand. It can also be run on demand from the Integration center.
Scope: Every Odoo partner of the type contact. Its address is imported as the store address and as the billing address, unless the contact has an invoice address.
Matching keys: Customer: retailer reference (Odoo partner id). A customer not found by it is looked up by name and country.
Import mode: Create or update → new customers are created, existing ones are updated.
Rejected rows: A contact whose country, or the country of one of its addresses, matches no Le New Black country name is left out.
Fields mapping
Complete mapping: every field the connector reads is listed.
| Le New Black field | Odoo field | Comment |
Reference |
Partner id | |
Name / Company |
Display name | |
Contact email / Billing email |
||
Address 1, Address 2, Zipcode, City, Country |
Street, Street 2, Zip, City, Country | Country matched by its name |
Billing address 1, Billing address 2, Billing zipcode, Billing city, Billing country |
Street, Street 2, Zip, City, Country of the invoice address | The contact's own address when it has no invoice address |
Extra field 1 |
Fiscal position | Sent back with each order |
Extra field 2 |
Price list | Sent back with each order |
Extra field 3 |
Payment terms | Sent back with each order |
Data flow: Customer addresses
The delivery addresses of your Odoo contacts are imported as delivery addresses of the matching customers.
Reference
Trigger: Scheduled task, active once Le New Black has set up the flow for your brand. It can also be run on demand from the Integration center.
Scope: Every Odoo partner of the type delivery address attached to a contact
Matching keys: Customer: retailer reference (Odoo partner id of the contact). Address: address reference (Odoo partner id of the delivery address).
Import mode: Create or update → new addresses are created, existing ones are updated.
Rejected rows: Addresses of a customer unknown in Le New Black, and addresses given twice, are rejected and reported in the task log: import customers first.
Callouts
- The orders data flow sends the reference of the order's delivery address to Odoo: import the delivery addresses before exporting orders.
Data flow: Prices
The prices of your Odoo price lists are imported as wholesale prices into the Le New Black price lists with the same code.
Reference
Trigger: Scheduled task, active once Le New Black has set up the flow for your brand. It can also be run on demand from the Integration center.
Price level: Per variant: one price per variant and price list, shared by all its sizes, taken from the first size of the variant found in Odoo.
Price lists: Every Odoo price list whose currency is known in Le New Black, imported as wholesale price
Matching keys: Price list: price list code (Odoo price list id). Product and variant: EAN13 of the Odoo product.
Rejected rows: Odoo products whose EAN13 is unknown in Le New Black, and Odoo price lists matching no Le New Black price list code, are ignored.
Callouts
- Price lists must exist in Le New Black first: your account manager creates them with the same codes as in Odoo.
- Products and variants must already exist in Le New Black: import products before prices.
Data flow: Inventory stock levels
Quantities on hand are imported from Odoo for each EAN13.
Reference
Trigger: Scheduled task, active once Le New Black has set up the flow for your brand. It can also be run on demand from the Integration center.
Quantity imported: The quantity on hand of each Odoo product with a barcode
Matching keys: Size: EAN13, matched against the Odoo barcode.
Import mode: Add by default → only the sizes in the Odoo data are updated, the others keep their quantity. Replace, when set up → the stock of every size is set to 0 before the quantities are applied. Negative quantities are imported as 0.
Rejected rows: An Odoo EAN13 unknown in Le New Black is ignored and reported in the task log: import products first.
Configuration
| Setting | Values | Type | Comment |
import_mode |
add (default) / replace | string | With replace, the stock of every size is set to 0 before the quantities are applied |
lnb_sku_identifier_column |
ean13 (default) / sku | string | Le New Black key the stock rows are matched against |
lnb_stock_column |
quantity (default) / incoming_quantity | string | Le New Black quantity updated |
Data flow: Orders
Orders you move to the exported status (Invoicing by default) are created in Odoo as sales orders, with the customer's fiscal position, price list and payment terms imported by the customers data flow.
Reference
Trigger: Scheduled task, active once Le New Black has set up the flow for your brand. It can also be run on demand from the Integration center.
Orders exported: Status Invoicing
Integration status: Only orders whose integration status is Pending are exported, and it becomes Successfully sent after export. The selection can be adapted during set-up.
Status after export: Closed
Blocked orders: An order that fails a check keeps its status and gets the integration status Blocked, with the reason in the task log. It is not sent again until you set its integration status back to Pending from the orders list (action Set integration status to Pending).
Limit: No limit
Sales order: An Odoo sales order with the origin "LNB PO-" followed by the Le New Black order number, the customer, its invoice and delivery addresses, the delivery start date as requested date, the customer's fiscal position, price list and payment terms, and one line per ordered size with its quantity
Matching keys: Customer: LNB retailer reference, sent as the Odoo partner id. Delivery address: LNB address reference, sent as the Odoo partner id of the address. Products: EAN13, matched against the Odoo barcode.
Not synchronised: Prices (Odoo applies the customer's price list), discounts, comments and shipping costs are not part of the order sent.
Configuration
| Setting | Values | Type | Comment |
validate_stock_ats |
true / false | bool | With true, the orders are exported in stock allocation order: by status (Invoicing first), then by date |
Callouts
- An order with a line whose product has no EAN13 code, or an EAN13 unknown in Odoo, is blocked as a whole: none of its lines is exported.
- An order whose customer has no Odoo customer reference in Le New Black is blocked. Other orders are still exported.
- An order is also blocked when its customer has no fiscal position, price list or payment terms, or when its delivery address has no Odoo reference.
- An order already created in Odoo is blocked instead of being created twice.
- After the order has been exported from Le New Black, any further change must be made directly in Odoo.
Global configuration
Configuration
| Setting | Values | Type | Comment |
url |
Odoo address | string | Address of your Odoo account |
database |
Odoo database name | string | Database of your Odoo account |
username |
Odoo user name | string | Credential of your Odoo account, set up with your account manager |
password |
Odoo user credential | string | Credential of your Odoo account, set up with your account manager |
Integration project
Who's assigned from your team?
Your Odoo administrator, or an IT profile within your company who is familiar with your specific setup. A Sales Manager who understands your business and your merchandising strategy.
Who's in charge at Le New Black
Your account manager at Le New Black takes care of the whole process from day 1:
- Asking questions about your specific Odoo setup and sales process.
- Setting up the connection with your Odoo account.
- Generating and exporting test orders to Odoo.
- Keeping your team updated throughout the process and addressing delays on either side.
- Working with you and Odoo to troubleshoot any unexpected issue after launch.
Timeline
A standard integration will take 6-8 weeks to get up and running.
Integration monitoring
Once the connector is set up, the Integration center of your back-office gives you a set of tools to manage and monitor the integration:
- Task logs, for continuous monitoring and troubleshooting (for example a missing EAN13 or retailer reference that prevents an order from being exported)
- Running a task on demand, to push or pull data at once
- A preview of the data before the actual import (only available on some connectors)
- E-mail notifications per task, set up on request: exported and blocked orders, import errors
- The integration status of each order in the orders list (Pending, Successfully sent, Blocked), which you can set back to Pending to send an order again
Comments
0 comments
Please sign in to leave a comment.