TexasWin + Le New Black integration overview
TexasWin is an on-premise ERP that manages finance, accounting, CRM and catalog. 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 automated file transfer via Le New Black FTP to exchange data |
|
TexasWin and Le New Black both push and pull files |
|
The connector requires basic configuration in Le New Black and TexasWin |
Data flows
| Type | Flow |
| Products | TexasWin ⇢ Le New Black |
| Prices | TexasWin ⇢ Le New Black |
| Inventory stock levels | TexasWin ⇢ Le New Black |
| Orders | TexasWin ⇠ Le New Black |
Data flow: Products
TexasWin sends your products in the Le New Black standard product file, with their categories and sub-categories, descriptions, compositions, weights and customs codes.
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.
File: products*.{csv,xlsx}
File format: CSV or Excel file with a header row, dropped by TexasWin on your Le New Black FTP.
File structure: One row per size
Matching keys: Product: model. Variant: fabric name. Size: size name.
Import mode: Create or update → new products and variants are created, existing ones are updated.
Created on the fly: Collections, categories on three levels and fabrics
Configuration
| Setting | Values | Type | Comment |
columns_mapping |
file column per Le New Black field | list | Replaces the default columns of the file |
filename_pattern |
file name pattern, products*.{csv,xlsx} (default) | string | Name of the file to import, agreed during set-up |
filename_pattern_exclude |
file name pattern, none (default) | string | Files matching this pattern are left out of the import |
file_compression_format |
none (default) / .zip / .tar.gz | string | Archive format the file arrives in |
file_encoding |
windows-1252, none (default) | string | Character encoding of the file |
collection_key |
code / name (default) | string | Identifies the collection of a product: by its code or its name |
fabric_key |
code / name (default) | string | Identifies a variant within a product: by its fabric code or its fabric name |
sizing_create_is_allowed |
true / false (default) | bool | Whether a size range missing from Le New Black is created |
product_sizing_update_is_allowed |
true / false (default) | bool | Whether the import can change the size range of an existing product |
Callouts
- The size range of each product must exist in Le New Black, unless the connector is set up to create it.
- The size range of a product that already exists in Le New Black cannot be changed through the import.
Data flow: Prices
TexasWin sends the wholesale, cost and retail prices of each of your price lists.
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.
File: prices*.{csv,xlsx}
File format: CSV or Excel file with a header row, dropped by TexasWin on your Le New Black FTP.
Price level: Per variant by default, or per size when set up.
Matching keys: Price list: price list name. Product: model. Variant: fabric name.
Configuration
| Setting | Values | Type | Comment |
columns_mapping |
file column per Le New Black field | list | Replaces the default columns of the file |
filename_pattern |
file name pattern, prices*.{csv,xlsx} (default) | string | Name of the file to import, agreed during set-up |
filename_pattern_exclude |
file name pattern, none (default) | string | Files matching this pattern are left out of the import |
file_compression_format |
none (default) / .zip / .tar.gz | string | Archive format the file arrives in |
fabric_key |
code / name (default) | string | Identifies the variant of a price row: by its fabric code or its fabric name |
price_list_key |
name (default) / code | string | Identifies the price list of a price row: by its code or its name |
price_level |
variant (default) / sku | string | Level of the prices: one per variant or one per size |
Fields mapping
Complete mapping: every field the connector reads is listed.
| Le New Black field | File column | Comment |
Price list |
Price catalog | Price list name or code |
Price period |
Price period code | Optional, when pricing per period is enabled on your account |
Model |
Model | Key |
Variant |
Variant | Fabric name or fabric code, case insensitive |
Wholesale price |
Price | Optional: number |
Cost price |
Cost price | Optional: number |
Retail price |
Retail price | Optional: number |
Callouts
- Price lists must exist in Le New Black first: your account manager creates them with the same names as in TexasWin.
- Products and variants must already exist in Le New Black: import products before prices.
Data flow: Inventory stock levels
Available-to-sell quantities are imported from TexasWin 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.
File: inventory*.{csv,xlsx}
File format: CSV or Excel file with a header row, dropped by TexasWin on your Le New Black FTP.
Matching keys: Size: EAN13
Import mode: Add by default → only the sizes in the file 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.
Rejected rows: Rows whose EAN13 is unknown in Le New Black are ignored and reported in the task log: import products first.
Configuration
| Setting | Values | Type | Comment |
columns_mapping |
file column per Le New Black field | list | Replaces the default columns of the file |
filename_pattern |
file name pattern, inventory*.{csv,xlsx} (default) | string | Name of the file to import, agreed during set-up |
filename_pattern_exclude |
file name pattern, none (default) | string | Files matching this pattern are left out of the import |
file_compression_format |
none (default) / .zip / .tar.gz | string | Archive format the file arrives in |
import_mode |
add (default) / replace | string | With replace, the stock of every size is set to 0 before the quantities are applied |
sku_column |
ean13 (default) / sku | string | Le New Black key the stock rows are matched against |
Fields mapping
Complete mapping: every field the connector reads is listed.
| Le New Black field | File column | Comment |
EAN13 |
EAN13 | Key |
Quantity |
Quantity | Integer |
Is blocked |
Is blocked | Optional: 0 (no) or 1 (yes) |
Available from |
Available from | Optional: ISO 8601 date and time |
Incoming quantity |
Incoming quantity | Optional: integer |
Incoming date |
Incoming date | Optional: date |
Data flow: Orders
Orders you move to the exported status (Invoicing by default) are sent to TexasWin, all the orders of an export in one file, one row per order.
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
File: orders- followed by the export date and time (YYYYMMDD-HHMMSS), .csv by default (setting filename): one file per export
Separator: ; (line breaks and semicolons inside a value are replaced by spaces)
File format: CSV file without header row, placed on your Le New Black FTP for TexasWin to collect.
File structure: One row per order. Its order lines are written in a single column: one item per ordered size, each item ending with $, its values separated by |.
File content: Order number, billing and delivery addresses, order total, total quantity, order lines (model, EAN13 or SKU, size, quantity, unit price before and after discount, discount rate), season code, customer reference, phone, buyer comment, billing e-mail and requested delivery date
Archive: A dated copy of every exported file is kept in Le New Black
Matching keys: Customer: LNB retailer reference, sent as the TexasWin customer reference. Products: EAN13 for stock-based orders, SKU for pre-orders. Size: TexasWin size value set on the LNB size range, or the size name. Season: TexasWin season code from the seasons mapping of your brand, or a built-in default code.
Configuration
| Setting | Values | Type | Comment |
filename |
file name, orders-%datetime% (default) | string | Name of the order file, agreed during set-up |
schema |
Le New Black order field → file column | list | Replaces the default columns of the order file |
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 | File column | Comment |
Order number |
num_commande | |
Billing contact / Billing company |
nom_facturation / societe_facturation | 40 characters max |
Billing address lines 1 and 2 |
adresse_facturation | Two blocks of 40 characters |
Billing city / Billing zip code / Billing country |
ville_facturation / cp_facturation / pays_facturation | 40 and 10 characters max, ISO country code |
Delivery contact / Delivery company |
nom_livraison / societe_livraison | 40 characters max |
Delivery address lines 1 and 2 |
adresse_livraison | Two blocks of 40 characters |
Delivery city / Delivery zip code / Delivery country |
ville_livraison / cp_livraison / pays_livraison | 40 and 10 characters max, ISO country code |
Constant |
frais_de_port_ttc / tva | 0 |
Order total |
total_ht | |
Total quantity |
total_quantite | Sum of the ordered quantities |
Order lines |
detail_commande | Per ordered size: model | EAN13 (stock-based order) or SKU (pre-order) | empty | size | quantity | unit price after discount | empty | unit price before discount | discount rate, then $ |
Constant |
statut | 0 |
Season |
saison | TexasWin season code |
Customer reference |
id_client | |
Constant |
pourc_remise | 0: the discount rate is given on each order line |
Billing phone |
telephone_livraison | |
Buyer comment |
commentaire_livraison | 80 characters max |
Constant |
code_transporteur / code_tarif | Empty |
Billing e-mail |
email_facturation | |
Delivery start date |
date_livraison_souhaite | YYYYMMDD |
Constant |
civilite / colissimo / point relais / num tva / type export | Empty |
Callouts
- An order containing a product without an EAN13 code (stock-based order) or without a SKU (pre-order) is blocked as a whole: none of its lines is exported.
- An order whose customer has no TexasWin customer reference in Le New Black is blocked. Other orders are still exported.
- An order without a season, or without any product, is blocked as well.
- After the order has been exported from Le New Black, any further change must be made directly in TexasWin.
Integration project
Who's assigned from your team?
Your TexasWin 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 TexasWin setup and sales process.
- Collaborating with TexasWin as they configure the data files to import and export.
- Generating and exporting test orders to TexasWin.
- Keeping your team updated throughout the process and addressing delays on either side.
- Working with you and TexasWin to troubleshoot any unexpected issue after launch.
Timeline
A standard integration of the products and prices data flows will take approximately 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
Each import task processes one file per run: when several files are waiting, the next ones are processed on the following runs. A file that cannot be read or misses a required column is set aside and reported in the task log, so it does not hold back the next files.
Comments
0 comments
Please sign in to leave a comment.