Cegid Colombus + Le New Black integration overview
Cegid Colombus is a french ERP/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 |
 |
Colombus and Le New Black are both pushing and pulling files |
 |
The connector requires data mapping and configuration in Le New Black and Colombus |
Data flows
| Type | Flow |
| Orders | Cegid ⇠ Le New Black |
Data flow: Orders
Facilities
- You will be able to select orders to be exported from Le New Black.
- Orders will be transferred from Le New Black according to a schedule that you determine.
- You will be able to trigger this export manually by clicking a button in Le New Black if you need to send orders earlier.
Callouts
- Products without EAN13 codes won't be exported.
- After the order has been exported from Le New Black, any further changes must be done directly into Cegid Colombus.
- Customers without a valid Cegid Colombus customer reference will block the order export.
Fields mapping (order header)
This is the default flat file schema handled by this connector. This schema can be adapted to fit custom needs.
| Column | Value / Example | Type | Format |
| Identifiant | "<ENTETE>" | Constant | 8 car. |
| Formalisme | EXP | Constante | 5 car. |
| Version | 005.000 | Parameter | 000.000 |
| Date | current date | Calculated value | dd/mm/yyyy |
| Heure | current hour | Calculated value | hh:mm:ss |
| LC Ori | Parameter | 5 car. | |
| Parameter | 5 car. | ||
| Chaînage | Parameter | 8 car. |
Fields mapping (order lines)
This is the default flat file schema handled by this connector. This schema can be adapted to fit custom needs.
| Column | Value | Type | Format |
| Code souche | Parameter | 5 car. max | |
| Numéro de Commande | order.id | LNB value | 8 car. max |
| Numéro de Ligne | order.row.index | Parameter | 9999999 |
| Commande soldée | Constant | True|False | |
| Catégorie de document | order.order_mode | LNB value | mapped value |
| Regime de facturation | Parameter | ||
| Libellé commande | Parameter | ||
| Code sku | order.rows[].sku | LNB value | |
| Code-à-barre | order.rows[].ean13 | LNB value | |
| Quantité commandée | order.lines[].quantity | LNB value | 9999999.999 |
| Prix unitaire | order.lines[].unit_price | LNB value | 9999999.99 |
| Taux de remise ligne | (empty) | ||
| Montant remise ligne | (empty) | ||
| Date de saisie | order.created_on | LNB value | dd/mm/yy |
| Code devise | order.currency | LNB value | 3 car. |
| Taux devise | 1 | Constant | |
| Date de début livraison | order.delivery_start_on | LNB value | dd/mm/yy |
| Date de fin livraison | order.delivery_end_on | LNB value | dd/mm/yy |
| Code société de commande | Parameter | ||
| Code magasin d'origine | Parameter | ||
| Code Client | order.retailer.reference | LNB value | |
| Raison sociale du client | order.retailer_company | LNB value | |
| Réf. cde chez le client | order.purchase_order_reference | LNB value | |
| Code tarif | order.price_list_code | LNB value | |
| Code événement promo | (empty) | ||
| Code saison | order.season_code | LNB value | |
| Designation article | order.rows[].product_name | LNB value | |
| Code représentant | order.sales_rep_fullname | LNB value | |
| Taux de remise globale | order.discount_rate | LNB value | 999.99 |
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 will be taking care of the whole process from day 1. He/she'll be doing:
- Asking questions about your specific Cegid Colombus setup and sales process.
- Collaborating with Cegid Colombus as they configure the data files to import & export to our system.
- Generating and exporting test orders to Cegid Colombus.
- Making sure your team is updated throughout the process and addressing delays occurring on either side.
- Working with you and Cegid Colombus to troubleshoot any unexpected issues that arise after launch.
Timeline
A standard integration of the orders data flow will take 2-4 weeks to get up and running. A standard integration of the inventory, products and prices data flows will take approximately 4-6 weeks to get up and running.
Integration monitoring
Once the connector is set up, you will have access to your own Integration center in your back-office to manage and monitor your integration with a set of tools:
- Access to task logs files for continuous monitoring and troubleshooting (e.g. see if a missing EAN13 or retailer reference is preventing an order from being exported)
- Triggers task manually to push and pull data on-demand
- Preview data before actual import (only available on some connectors)
Comments
0 comments
Please sign in to leave a comment.