Cegid ORLI integration

Cegid ORLI + Le New Black integration overview

Cegid ORLI 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
	ORLI and Le New Black are both pushing and pulling files
	The connector requires data mapping and configuration in Le New Black and ORLI

Data flows

Data flow: Customers

Reference 

• Full file template: see in Google Drive
• Data flow: from ERP to LNB

Facilities

• Your customer data will reflect the master customer data hosted in Cegid ORLI.
• You will click a button in Le New Black to import customers from Cegid ORLI.
• Your buyer data will also be imported (email, last name, first name)  
• Your customer+lines associations ("client+division" in Cegid ORLI) will also be imported

Configuration

Data flow: Products

Reference 

• Full file template: see in Google Drive
• Data flow: from ERP to LNB

Facilities

• Your product data will reflect the master product data hosted in Cegid ORLI.
• You will click a button in Le New Black to import products from Cegid ORLI.
• Your category data including subcategories will also be imported
• You color and material data will also be imported 

Callouts

• Publication can be managed at 3 levels by the following fields:
  • Published: product-level publication
  • Is available: variant-level publication
  • Size is sold: size-level publication, works only on product creation (see below)
• Field Size is sold works only on product creation and will be ignored for an existing product as sizing cannot be updated by integration. To update a product sizing, please use the Product sizing update feature under Sizings section

Data flow: Prices

Reference 

• Full file template: see in Google Drive
• Data flow: from ERP to LNB

Facilities

• Your prices data will reflect the master prices data hosted in Cegid ORLI.
• You will click a button in Le New Black to import prices from Cegid ORLI.

Prerequisites

• Price lists have to be configured in Le New Black first by your account manager.

Configuration

Data flow: Inventory stock levels

Facilities

• Your inventory data will reflect the available-to-sell quantities from Cegid ORLI.
• Inventory will be imported into Le New Black according to a schedule that you determine.
• You will be able to trigger this import manually by clicking a button from Le New Black if you need to refresh your stock level earlier.
• The inventory is based on either EAN13s.

Fields mapping

This is the default flat file schema handled by this connector. This schema can be adapted to fit custom needs.

Data flow: Orders

Reference 

• Full file template: see in Google Drive
• Data flow: from LNB to ERP

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.
• Customers without a valid Cegid ORLI customer reference will block the order export.
• After the order has been exported from Le New Black, any further changes must be done directly into Cegid ORLI.
• After the order file has been downloaded by Cegid ORLI, the order file must be deleted by Cegid ORLI (an archived copy of the file will still be available on Le New Black).

Configuration

Data flow: Orders import

Reference 

• Full file template: see in Google Drive
• Data flow: from ERP to LNB

Facilities

• Orders will be transferred from Cegid ORLI into Le New Black according to a schedule that you determine.
• You will be able to add new products and/or variant and/or sizes to the order or update an existing product/variant/size quantity.

Callouts

• Orders with an invalid retailer reference won't be imported.
• Orders with an invalid order id won't be imported.
• Orders lines with an invalid model or an invalid fabric code won't be imported.
• Product prices from the retailer's price list will be applied.

Integration project

Who's assigned from your team?

Your Cegid ORLI 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 ORLI setup and sales process.
• Collaborating with Cegid ORLI as they configure the data files to import & export to our system.
• Generating and exporting test orders to Cegid ORLI.
• Making sure your team is updated throughout the process and addressing delays occurring on either side.
• Working with you and Cegid ORLI 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)