IPSoft + Le New Black integration overview
IPSoft is a cloud-based ERP that manages financials, accounting, CRM and projects fully 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 IPSoft 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 IPSoft |
Data flows
| Type | Flow |
| Customers | IPSoft ⇢ Le New Black |
| Products | IPSoft ⇢ Le New Black |
| Prices | IPSoft ⇢ Le New Black |
| Inventory stock levels | IPSoft ⇢ Le New Black |
| Orders | IPSoft ⇠ Le New Black |
Data flow: Customers
IPSoft customers are imported with their main address, used as store and billing address, their delivery address, their discount rates and their sales rep.
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.
Matching keys: Customer: retailer reference (IPSoft customer code). A customer not found by it is looked up by name and country. Sales rep: sales rep code (IPSoft agent code). Delivery address: address reference (IPSoft address id).
Import mode: Create or update → new customers are created, existing ones are updated.
Rejected rows: Customers without a country, or whose country is not recognised, are rejected and reported in the task log.
Configuration
| Setting | Values | Type | Comment |
sales_rep_key |
email (default) / code | string | Identifies the sales rep of each customer: by its e-mail or its code |
Fields mapping
Complete mapping: every field the connector reads is listed.
| Le New Black field | IPSoft field | Comment |
Reference |
Customer code | |
Name |
Name | |
Contact email / Billing email |
||
Address 1, Zipcode, City, Country, Tel, Fax |
Main address, postal code, city, country, phone and fax | Also imported as the billing address |
Discount rate |
Rebate | |
Special discount rate |
Discount | |
Sales rep |
Agent code | Matched by code (setting sales_rep_key) |
Delivery address: Address reference, Company, Address 1, Zipcode, Country |
Address id, name, address, postal code and country of the IPSoft address | The city of the delivery address is not read |
Callouts
- IPSoft gives the agent code of each customer's sales rep: the sales rep identifier is set to code, and each sales rep must have this code in Le New Black.
Data flow: Products
Products of the IPSoft collections set up are imported with their collection, section, family, colours, composition, sizes and EAN13s.
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 of the IPSoft collections listed in the configuration
Matching keys: Product: model (IPSoft product code). Variant: fabric code (IPSoft colour code). Size: size name, with its EAN13.
Import mode: Create or update → new products and variants are created, existing ones are updated.
Created on the fly: Collections, categories (from the IPSoft section), sub-categories (from the IPSoft family), variants and size ranges, in the IPSoft size order
Configuration
| Setting | Values | Type | Comment |
fabric_key |
code (default) / name | string | Identifies a variant within a product: by its fabric code or its fabric name |
product_create_is_allowed |
true (default) / false | bool | With false, products missing from Le New Black are not created: only existing products are updated |
product_sizing_update_is_allowed |
true / false (default) | bool | Whether the import can change the size range of an existing product |
Fields mapping
Complete mapping: every field the connector reads is listed.
| Le New Black field | IPSoft field | Comment |
Model |
Product code | |
Name |
Description | |
Collection |
Collection | |
Category |
Section | |
Sub category |
Family | |
Fabric code / Fabric name |
Colour code / Colour | |
Reference |
Product code and colour code | Joined without separator |
Composition |
Composition | |
Size |
Size | Sizes ordered by their IPSoft rank |
EAN13 |
EAN code |
Callouts
- The size range of a product that already exists in Le New Black cannot be changed through the import.
Data flow: Prices
The three IPSoft standard prices are imported into the Le New Black price lists coded 1, 2 and 3, with the IPSoft retail price for the price lists 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.
Price level: Per variant: one wholesale price and one retail price per variant and price list, shared by all its sizes.
Price lists: The Le New Black price list coded 1, 2 or 3 receives the IPSoft standard price of the same number as wholesale price, and the IPSoft retail price when set up
Currency: The prices of the IPSoft currency set up (setting currency_code). No currency conversion.
Matching keys: Price list: price list code. Product: model. Variant: fabric code.
Configuration
| Setting | Values | Type | Comment |
price_retail_enabled_price_lists |
price list code → true / false | list | Price lists that also receive the IPSoft retail price |
Callouts
- Price lists must exist in Le New Black first: your account manager creates them with the codes 1, 2 and 3 of the IPSoft standard prices.
- Products and variants must already exist in Le New Black: import products before prices.
Data flow: Inventory stock levels
Available quantities of the IPSoft warehouse set up are imported for each EAN13 of the IPSoft collections 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.
Scope: Products of the IPSoft collections listed in the configuration
Quantity imported: The available stock of each EAN13 in the IPSoft warehouse set up, or its theoretical stock when set up
Matching keys: Size: EAN13.
Import mode: Add by default → only the sizes in the IPSoft 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 IPSoft 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 |
warehouse_code |
IPSoft warehouse code | string | IPSoft warehouse the stock is read from |
Data flow: Orders
Orders you move to the exported status (Invoicing by default) are created in IPSoft. Le New Black seasons must be mapped to your IPSoft seasons, and your sales reps must carry their IPSoft agent 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.
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 IPSoft order with the Le New Black order number as order id and "PO-" followed by it as reference, the customer code, the delivery address number or sub-customer code, the IPSoft season, the agent code of the sales rep, the order type when mapped, the delivery start date (the export date when the order has none), and one line per ordered size with its EAN13 and quantity
Matching keys: Customer: IPSoft customer code, read from the LNB order field set up (setting client_code_column). Sales rep: LNB user code. Products: EAN13.
Not synchronised: Prices and discounts are left for IPSoft to apply. Comments and shipping costs are not part of the order sent.
Configuration
| Setting | Values | Type | Comment |
client_code_column |
Le New Black order field (retailer_reference, …) | string | Order field sent as the IPSoft customer code |
sub_client_code_column |
Le New Black order field | string | Order field sent as the IPSoft sub-customer code (optional) |
delivery_address_numbers |
customer → IPSoft delivery address number | list | Delivery address number sent when the order has no delivery address reference (optional) |
order_types_mapping |
Le New Black order type → IPSoft order type | list | IPSoft order type sent for each Le New Black order type (optional) |
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 containing a product without an EAN13 code is blocked as a whole: none of its lines is exported.
- An order whose customer has no IPSoft customer reference in Le New Black is blocked. Other orders are still exported.
- An order whose season has no IPSoft season in the season mapping of your brand is blocked.
- An order refused by IPSoft is blocked, with the IPSoft error message in the task log.
- After the order has been exported from Le New Black, any further change must be made directly in IPSoft.
Global configuration
Configuration
| Setting | Values | Type | Comment |
url |
IPSoft API address | string | Address of your IPSoft account |
login |
IPSoft user name | string | Credential of your IPSoft account, set up with your account manager |
key |
IPSoft API key | string | Credential of your IPSoft account, set up with your account manager |
collection_codes |
IPSoft collection codes | list | IPSoft collections whose products, prices and stock are read |
currency_code |
IPSoft currency code | string | Currency of the IPSoft prices read (products and prices data flows) |
Integration project
Who's assigned from your team?
Your IPSoft 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 IPSoft setup and sales process.
- Setting up the connection with your IPSoft account.
- Generating and exporting test orders to IPSoft.
- Keeping your team updated throughout the process and addressing delays on either side.
- Working with you and IPSoft to troubleshoot any unexpected issue after launch.
Timeline
A standard integration 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.