e-conomic + Le New Black integration overview
e-conomic is a cloud-based accounting program to manage your bookkeeping. 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 e-conomic API to exchange data |
|
Le New Black drives all data flows: it triggers every push and pull operation |
|
The connector requires basic configuration in Le New Black and e-conomic |
Data flows
| Type | Flow |
| Inventory stock levels | e-conomic ⇢ Le New Black |
| Orders | e-conomic ⇠ Le New Black |
Data flow: Inventory stock levels
Available quantities are imported from e-conomic for each product updated since the start date of the run.
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: Products updated in e-conomic since the start date given to the run (setting from_date)
Quantity imported: The available quantity of each e-conomic product
Matching keys: Size: EAN13 (default) or SKU, matched against the e-conomic product number.
Import mode: Add by default → only the sizes in the e-conomic 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 e-conomic product number unknown in Le New Black is ignored and reported in the task log.
Configuration
| Setting | Values | Type | Comment |
from_date |
date and time (timestamp) | integer | Only the products updated in e-conomic since this date are read |
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 |
Callouts
- When no product changed in e-conomic since the start date, the run ends with an error in the task log and no stock is updated.
Data flow: Orders
Orders you move to the exported status (Invoicing by default) are created in e-conomic as orders, or as quotations when set up.
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 e-conomic order with "PO-" followed by the Le New Black order number as other reference, the order name (or your brand name and the season) as heading, the billing and delivery addresses, the delivery start date, the terms of delivery and the term of payment of the debtor, then one line per order line
Line amounts: Net unit price of each line, excluding VAT, with the order discount rate as line discount; the VAT zone follows the billing country (domestic, EU or abroad)
Currency: The order currency, with its exchange rate against the currency set up for your account
Matching keys: Customer: LNB retailer reference, sent as the e-conomic debtor number. Products: EAN13 or SKU, sent as the e-conomic product number.
Configuration
| Setting | Values | Type | Comment |
lnb_sku_identifier_column |
ean13 / sku | string | Le New Black key sent for each order line |
lnb_sku_alt_identifier_column |
ean13 / sku | string | Le New Black key sent for a line whose product has no value for the first key (optional) |
order_type |
order (default) / quotation | string | Kind of e-conomic document each order is exported as |
order_exchange_currency_code |
currency code (DKK, EUR…) | string | Currency the exchange rate of the order currency is given against |
validate_stock_ats |
true / false | bool | With true, the orders are exported in stock allocation order: by status (Invoicing first), then by date |
order_date |
date (YYYY-MM-DD HH:MM:SS) | string | Date sent as the date of every exported order, instead of its creation date (optional) |
Fields mapping
Complete mapping: every field the connector reads is listed.
| Le New Black field | e-conomic field | Comment |
Customer reference |
DebtorHandle | e-conomic debtor number |
Billing company |
DebtorName | |
Billing address 1 |
DebtorAddress | |
Billing zipcode |
DebtorPostalCode | |
Billing city |
DebtorCity | |
Billing country |
DebtorCountry | Country name; it also sets the VAT zone |
Creation date |
Date | Or the date of the setting order_date |
Currency |
CurrencyHandle, ExchangeRate | Exchange rate against the currency of the setting order_exchange_currency_code |
Delivery company, address 1, e-mail and tel |
DeliveryAddress | Joined with ";" |
Delivery zipcode |
DeliveryPostalCode | |
Delivery city |
DeliveryCity | |
Delivery country |
DeliveryCountry | Country name |
Terms of delivery |
TermsOfDelivery | |
Delivery start date |
DeliveryDate | |
Order name |
Heading | Or your brand name and the season of the order |
Order number |
OtherReference | "PO-" followed by the order number |
EAN13 or SKU |
Lines / ProductHandle | Key of the setting lnb_sku_identifier_column |
Product name and colour |
Lines / Description | |
Quantity |
Lines / Quantity | |
Price |
Lines / UnitNetPrice | Excluding VAT |
Discount rate |
Lines / DiscountAsPercent | Order discount rate, on every line |
Callouts
- An order with a line whose product has no EAN13 or SKU code is blocked as a whole: none of its lines is exported.
- An order whose customer has no e-conomic customer reference in Le New Black is blocked. Other orders are still exported.
- An order whose debtor has no term of payment in e-conomic is blocked.
- After the order has been exported from Le New Black, any further change must be made directly in e-conomic.
Global configuration
Configuration
| Setting | Values | Type | Comment |
appToken |
e-conomic app token | string | Credential of your e-conomic account, set up with your account manager |
token |
e-conomic access token | string | Credential of your e-conomic account, set up with your account manager |
Integration project
Who's assigned from your team?
Your e-conomic 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 e-conomic setup and sales process.
- Setting up the connection with your e-conomic account.
- Generating and exporting test orders to e-conomic.
- Keeping your team updated throughout the process and addressing delays on either side.
- Working with you and e-conomic 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.