Pyramid + Le New Black integration overview
Pyramid is a Swedish ERP covering production, distribution and financial administration. 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 |
|
Pyramid and Le New Black both push and pull files |
|
The connector requires basic configuration in Le New Black and Pyramid |
Data flows
| Type | Flow |
| Orders | Pyramid ⇠ Le New Black |
Data flow: Orders
Orders you move to the exported status (Invoicing by default) are sent to Pyramid as EDI order files, one file 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_LNB_ followed by the export date (YYYYMMDD), the Le New Black order number (PO-…) and _EN.IMP: one file per order
File format: Pyramid EDI text file, encoded in Windows-1252, placed on your Le New Black FTP for Pyramid to collect.
File structure: One record per line, a code followed by ; and its value: an order header (record 01), one block per ordered size (record 11), then an order footer (record 12).
File content: Customer reference, order mode, order number, billing company, delivery company and address, delivery week; then for each ordered size: SKU, quantity, unit price, discount rate, delivery week and date, line number and product reference
Matching keys: Customer: LNB retailer reference, sent as the Pyramid customer reference. Products: SKU, with the product reference as model.
Configuration
| Setting | Values | Type | Comment |
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 |
01 | Start of the order header |
Customer reference |
#12205 | |
Order mode |
#12211 | LS for a stock-based order, LP for a pre-order |
Order number |
#12214 | PO- followed by the Le New Black order number |
Billing company |
#12215 | |
Delivery company |
#12227 | |
Delivery address lines 1 and 2 |
#12230 / #12231 | Line 2 can be empty |
Delivery zip code and city |
#12233 | Zip code, a space, then the city |
Delivery country |
#12236 / #12237 | Country name, then ISO country code |
Constant |
#12239 / #12283 | Empty, then 1 |
Delivery start date |
#12361 | Delivery week, YYWW. Without a delivery start date, the order is sent for 1 January 2099 |
Constant |
11 | Start of the block of one ordered size |
SKU |
#12401 | |
Quantity |
#12441 | |
Unit price |
#12451 | Price of the order line, before the order discount |
Order discount rate |
#12453 | |
Delivery start date |
#12465 / #12466 | Delivery week (YYWW), then delivery date (YYMMDD) |
Line number |
¤3452 | 1, 2, 3… within the order |
Product reference |
¤3453 | Model |
Constant |
12 / #12434 | Order footer, with an empty comment |
Callouts
- An order containing a product without a SKU is blocked as a whole: none of its lines is exported.
- An order whose customer has no Pyramid customer reference in Le New Black is blocked. Other orders are still exported.
- An order is blocked as well when its billing company, delivery company, delivery address, zip code, city or country is empty, or when a line has no product reference, quantity or price.
- After the order has been exported from Le New Black, any further change must be made directly in Pyramid.
Global configuration
Configuration
| Setting | Values | Type | Comment |
file_path_to_pending |
folder of your Le New Black FTP | string | Folder of your Le New Black FTP the order files are placed in, set by Le New Black |
Integration project
Who's assigned from your team?
Your Pyramid 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 Pyramid setup and sales process.
- Collaborating with Pyramid as they configure the data files to import and export.
- Generating and exporting test orders to Pyramid.
- Keeping your team updated throughout the process and addressing delays on either side.
- Working with you and Pyramid to troubleshoot any unexpected issue after launch.
Timeline
A standard integration of the orders data flow will take 4-6 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.