24SevenOffice + Le New Black integration overview
24SevenOffice is a cloud-based ERP system to manage finance, accounting, CRM and projects online. 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 24SevenOffice 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 24SevenOffice |
Data flows
| Type | Flow |
| Inventory stock levels | 24SevenOffice ⇢ Le New Black |
| Orders | 24SevenOffice ⇠ Le New Black |
Data flow: Inventory stock levels
Stock quantities are imported from 24SevenOffice for each product with an EAN.
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 24SevenOffice product with an EAN; products without one are left out
Quantity imported: The stock quantity of each 24SevenOffice product
Matching keys: Size: EAN13.
Import mode: Add by default → only the sizes in the 24SevenOffice 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: A 24SevenOffice EAN13 unknown in Le New Black is ignored and reported in the task log.
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 24SevenOffice as orders with the status Offer.
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: A 24SevenOffice order with the status Offer, the reference "PO-" followed by the Le New Black order number, a title made of "Le New Black", the order mode (Pre-order or In-stock), the season and the brand comment, and one row per order line, sorted by product, colour and size
Matching keys: Customer: LNB retailer reference, sent as the 24SevenOffice customer id. Products: EAN13, matched against the EAN of the 24SevenOffice products.
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 |
Fields mapping
Complete mapping: every field the connector reads is listed.
| Le New Black field | 24SevenOffice field | Comment |
Customer reference |
CustomerId | 24SevenOffice customer id |
Order number |
ReferenceNumber | "PO-" followed by the order number |
Order mode, season and brand comment |
InvoiceTitle | Preceded by "Le New Black" and separated by " - " |
EAN13 |
InvoiceRows / ProductId | 24SevenOffice product found by its EAN |
Price |
InvoiceRows / Price | |
Quantity |
InvoiceRows / Quantity |
Callouts
- An order with a line whose product has no EAN13 code, or a code unknown in 24SevenOffice, is blocked as a whole: none of its lines is exported.
- An order whose customer has no 24SevenOffice customer reference in Le New Black is blocked. Other orders are still exported.
- After the order has been exported from Le New Black, any further change must be made directly in 24SevenOffice.
Global configuration
Configuration
| Setting | Values | Type | Comment |
application_id |
24SevenOffice application id | string | Credential of your 24SevenOffice account, set up with your account manager |
username |
24SevenOffice user name | string | Credential of your 24SevenOffice account, set up with your account manager |
password |
24SevenOffice user credential | string | Credential of your 24SevenOffice account, set up with your account manager |
Integration project
Who's assigned from your team?
Your 24SevenOffice 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 24SevenOffice setup and sales process.
- Setting up the connection with your 24SevenOffice account.
- Generating and exporting test orders to 24SevenOffice.
- Keeping your team updated throughout the process and addressing delays on either side.
- Working with you and 24SevenOffice to troubleshoot any unexpected issue after launch.
Timeline
A standard integration of the inventory stock levels and orders data flows will take 2-4 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.