Cegid Colombus + Le New Black integration overview
Cegid Colombus is a French ERP and POS software specialised in fashion retail. 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 |
|
Cegid Colombus and Le New Black both push and pull files |
|
The connector requires data mapping and configuration in Le New Black and Cegid Colombus |
Data flows
| Type | Flow |
| Orders | Cegid Colombus ⇠ Le New Black |
Data flow: Orders
Orders you move to the exported status (Invoicing by default) are sent to Cegid Colombus, one file per order, in the wholesale layout or, when set up, in the retail layout.
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: Name agreed during set-up (setting filename), with the export date and time (setting filename_datetime_format) and the Le New Black order number: one file per order. A second file holding the header record and the first line of the order can be written alongside (setting filename_dummy_for_update).
Separator: Tab
File format: Text file, placed on your Le New Black FTP for Cegid Colombus to collect.
File structure: One header record (identifier, format, version, export date and time, origin and destination codes, chaining code), then one line per ordered size, with tab-separated values.
File content: Wholesale layout: order number, line number, document category, billing regime, order label, SKU, EAN13, quantity, unit price, order date, currency, delivery start and end dates, company and origin store codes, customer reference and company name, PO number, price list code, season code, product name and order discount rate. Retail layout (setting export_type): the same lines without prices, customer company name, PO number and price list code, the customer reference being sent as the destination store code.
Archive: A dated copy of every exported file is kept in Le New Black
Matching keys: Customer: LNB retailer reference, sent as the Cegid Colombus customer reference. Products: SKU and EAN13, both sent on each line.
Configuration
| Setting | Values | Type | Comment |
export_type |
wholesale / retail | string | Kind of Cegid Colombus document each order is exported as |
filename |
file name | string | Name of the order file, agreed during set-up |
filename_datetime_format |
date format, for example YmdHis | string | Date and time format in the name of the order file |
filename_dummy_for_update |
file name, none (default) | string | Name of a second file holding the header record and the first line of each order (optional) |
export_fields_to_validate |
customer reference, season, delivery start date, delivery end date, EAN13, size position | list | Checks applied before export; an order failing one of them is blocked |
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 |
Set-up value |
Code souche | Document stub code, agreed during set-up |
Order number |
Numéro de Commande | Padded with zeros to 9 digits |
Line number |
Numéro de ligne | 1, 2, 3… within the order |
Constant |
Commande soldée | False (wholesale layout only) |
Sales catalog extra field 1 |
Catégorie de document | STD for a pre-order, REA for a stock-based order |
Customer extra field 2 |
Régime de facturation | Wholesale layout only |
Sales catalog extra field 2 and customer name |
Libellé commande | Season code / customer name |
SKU |
Code sku | 17 characters max |
EAN13 |
Code-à-barre | |
Quantity |
Quantité commandée | |
Unit price |
Prix unitaire | 2 decimals (wholesale layout only) |
Constant |
Taux de remise ligne / Montant remise ligne | 0 (wholesale layout only) |
Order creation date |
Date de saisie | DD/MM/YY |
Currency |
Code devise | Currency code of the order |
Constant |
Taux devise | 1 |
Delivery start date |
Date de début livraison | DD/MM/YY. For a REA order: the day after the order creation date |
Delivery end date |
Date de fin livraison | DD/MM/YY. For a REA order: six months and one day after the order creation date |
Set-up value |
Code société de commande | Wholesale layout only |
Set-up value |
Code magasin d'origine | Origin store code, which can depend on the customer's country and the order's line |
Customer reference |
Code Client | 10 characters max. In the retail layout, sent as Code magasin destination (5 characters max) |
Customer company name |
Raison sociale du client | 30 characters max (wholesale layout only) |
PO number |
Réf. cde chez le client | 20 characters max (wholesale layout only) |
Price list code |
Code tarif | Code of the order's price list (wholesale layout only) |
Set-up value |
Code événement promo | Wholesale layout only |
Sales catalog extra field 2 |
Code saison | 5 characters max |
Product name |
Désignation article | 25 characters max (wholesale layout only) |
Order discount rate |
Taux de remise globale | 2 decimals, column 48 (wholesale layout only). The other columns of the wholesale layout are left empty. |
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 Cegid Colombus customer reference in Le New Black is blocked. Other orders are still exported.
- These checks apply when they are set up (setting export_fields_to_validate); an order without any product is always blocked.
- After the order has been exported from Le New Black, any further change must be made directly in Cegid Colombus.
Integration project
Who's assigned from your team?
Your Cegid Colombus 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 Cegid Colombus setup and sales process.
- Collaborating with Cegid Colombus as they configure the data files to import and export.
- Generating and exporting test orders to Cegid Colombus.
- Keeping your team updated throughout the process and addressing delays on either side.
- Working with you and Cegid Colombus to troubleshoot any unexpected issue after launch.
Timeline
A standard integration of the orders data flow 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
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.