Gencom + Le New Black integration overview
Gencom is an ERP and POS solution for retail, with both software and hardware. 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 |
|
Gencom and Le New Black both push and pull files |
|
The connector requires data mapping and configuration in Le New Black and Gencom |
Data flows
| Type | Flow |
| Orders | Gencom ⇠ Le New Black |
Data flow: Orders
Orders you move to the exported status (Invoicing by default) are sent to Gencom.
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): one file for all the orders of an export
Separator: Agreed during set-up (setting export_separator)
File format: Text file with a header row, placed on your Le New Black FTP for Gencom to collect.
File structure: One row per ordered size, carrying both the order header fields (HDR) and the line fields (LIN)
Matching keys: Customer: LNB retailer reference, sent as the Gencom customer number. Products: variant reference and size name, with the EAN13.
Configuration
| Setting | Values | Type | Comment |
filename |
file name | string | Name of the order file, agreed during set-up |
export_separator |
any character | string | Field separator 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 |
Constant |
HDR | Always HDR |
Customer reference |
Customernumber | Gencom customer number |
Order date |
Orderdate | YYYY/MM/DD |
Order number |
searchreference | Le New Black order number |
Empty |
Free | Always empty |
Constant |
LIN | Always LIN |
Variant reference |
Articlenumber | |
Size |
Size | Size name |
EAN13 |
barcode EAN-13 | Empty when the product has no EAN13 |
Quantity |
quantity ordered | |
Delivery start date |
Deliverydate | YYYY-MM-DD |
Empty |
Tekst | Always empty |
Unit price |
Style Price | |
Discount rate |
Order level discount percent | Order discount, in percent |
Callouts
- An order whose customer has no Gencom customer reference in Le New Black is blocked. Other orders are still exported.
- An order without a delivery start date, or with a line whose quantity is zero, is blocked.
- A product without an EAN13 does not block the order: its lines are exported with an empty barcode column.
- The order file always has the same name: an export replaces the previous file if Gencom has not collected it yet.
- After the order has been exported from Le New Black, any further change must be made directly in Gencom.
Integration project
Who's assigned from your team?
Your Gencom 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 Gencom setup and sales process.
- Collaborating with Gencom as they configure the data files to import and export.
- Generating and exporting test orders to Gencom.
- Keeping your team updated throughout the process and addressing delays on either side.
- Working with you and Gencom 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.