Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



Welcome to the Coolblue on-boarding page. 

Build your Coolblue connection via Onetrail in 7 steps.




Info
titleAccepted messages

Coolblue currently accepts the following messages: 

  • Edifact D.96A
  • Edifact D.97A
  • Onetrail XML


Info
titleSupported message types

Coolblue currently supports the following message types:

  • ORDERS (OUT)
  • ORDRSP (IN)
  • DESADV (IN)
  • INVOICE (IN).




Step 1: Fill in customer setup-form

An Onetrail employee will send you a 'Customer Setup-Form'.  This form will contain all required EDI data, such as;

  • GLN
  • Contact Information
  • Means of communication
  • IP addresses


Note
titleReturn period

Please make sure you return the filled out Setup-Form as soon as possible. After receipt by Onetrail we will process the Setup-Form within two days.




Step 2: Approve onboarding requirements Coolblue

Coolblue applies a strict EDI policy. This means Coolblue wants to know exactly what happens with their orders in the order response message. It is therefore required to approve the Onboarding requirements.

  • If the requirements are met, please send your approval in an email to TPN.Delivery@onetrail.com.
  • If the requirements are not met, please contact your Onetrail Implementation Consultant to discuss the possibilities.

Specific Coolblue business requirements:

Order Response
Suppliers must be able to comply with all order response scenario's mentioned below in step 5.

  • Suppliers need to be able to handle all of the Coolblue delivery locations. Production GLN codes will be provided by either Onetrail or Coolblue when the Supplier has finished onboarding for Coolblue entirely.
  • Suppliers need to take the requested delivery date on line level into account, not on header level.
  • Suppliers are suggested to put order lines with price mismatches on hold. When not possible it's also allowed to send the adjusted price to Coolblue. It's NOT allowed to cancel an order line entirely at once without any kind of feedback upfront to Coolblue.
  • Suppliers are suggested to send order responses multiple times a day but are at minimum required to do so within 4 hours after order placement.
  • Adding an additional order line to the order is NOT allowed. In case of incorrectly ordered products or End of Life products, Coolblue must be contacted and after mutual agreements between the Supplier and Coolblue the incorrectly ordered product(s) on the order, the line can be cancelled entirely. When possible, for example in the case of a replacement product, Coolblue will order the suggested product in a new purchase order.
  • Suppliers ought to send remarks on the header and line level for every Delete and On-hold status order response message.


Despatch Advice

  • Suppliers ought to send product Serial Numbers in the Despatch Advice (DESADV) messages.

Info
titleNote
Coolblue is investigating more requirements for the DesAdv message.

Invoice

  • Invoices cannot be sent before the goods have left the Seller warehouse
  • Only invoices can be sent via EDI. Credits and Service invoices (repairs) can be processed via PDF
  • Invoices for €0,- are not required
  • Each invoice can only contain information for a single PO
  • Street and city name from Coolblue are communicated: Weena 664, Rotterdam
  • Street and city name from the seller are communicated
  • The Seller account number (IBAN) is communicated
  • The order reference (CX..) is communicated on both header and on line level
  • The Total VAT amount is communicated on header level
  • The total amount excluding VAT is communicated on both header and on line level
  • The VAT registration number is communicated
  • Each VAT rate is totaled on header level (VAT1; VAT2)
  • The total VAT amount is communicated on line level
  • The VAT rate is communicated on line level
  • The Manufacture code for the item is communicated on line level
  • An item description is communicated on line level
  • The original PO line number is communicated
  • The unit price is communicated on line level


Product data

  • Product data has to be available via Product Manager upload or Product Exchange.


Step 3: Means of communication

Onetrail supports a wild array of communication options, they can be found on this page.
A Onetrail Consultant will test the chosen communication protocol with you, both on the Onetrail Acceptance and Production environments.



Step 4: Setup test trading partner

While onboarding with Coolblue, Onetrail will test using a test account on the Onetrail Acceptance environment.
The test account is linked to an automatic validation process that provides automatic feedback about the currently performed tests.


The GLN codes which need to be used for this Acceptance test account are:


Onetrail EDIFACT D.96A / D.97A Format


GLN Onetrail Edifact Test Buyer
UNB & NAD+BY8713783719626
Onetrail Edifact Test Buyer
Trading Partner GLN
NAD+ST8713783719640
Onetrail Edifact Test Buyer
Ship To GLN
NAD+IV8713783719633
Onetrail Edifact Test Buyer
Invoice To GLN


Onetrail XML Format


GLNOnetrail XML Test Buyer
*<toRole> 8714253023366
Onetrail XML Test Buyer
Trading Partner GLN
*<shipTo>8714253023380
Onetrail XML Test Buyer
Ship To GLN
*<billTo>8714253023397
Onetrail XML Test Buyer
Invoice To GLN



Note
titleCorrect GLN

Please communicate with the correct GLN's in the test Order Response and Despatch Advice messages. Incorrect GLN's won't provide any feedback.




Step 5: Configure messages

Technical documentation:
Onetrail EDIFACT D.96A MIG.
Onetrail EDIFACT D.97A MIG.
Onetrail Order Response XML-EDIFACT DOC.
Onetrail XSD-DOC.

It is mandatory that the outbound message (ORDRSP) supports the following scenario's - when applicable (it needs to reflect the physical delivery)

Scenario 1: Order confirmed without changes

  • 1.1: The Seller accepts the purchase order with exactly the same prices, quantities and requested delivery dates as requested.

Scenario 2: Order confirmed with changes

  • 2.1: Accept the purchase order with a deviating price
  • 2.2: Accept the purchase order with a deviating delivery date. Test both known and unknown delivery date responses.
  • If there is a change in the requested quantities, please use Scenario 8: Order-Line is split instead.

Scenario 3: Order on-hold

There is a blockage on the complete order, this can occur when there are **financial**, **sales**, **stock** or other **technical issues** with the purchase order which prevents physical delivery of the products. This excludes normal back-orders, because that is Scenario 2.

Scenario 4: Order-line on-hold

There is a blockage on one or more Order-Lines, this can occur when there are **financial**, **sales**, **stock** or other **technical issues** with the purchase order.

Scenario 5: Order deleted

\- Purchase order is **cancelled** by either Seller or Buyer.

Scenario 6: Order-line(s) Deleted

\- One or more Order-Lines have been **cancelled** by either
Seller or Buyer.

Scenario 7: Order-line is added

\- Seller adds a new Order-line on request of the Buyer or
because of a change by either Seller or Buyer.

Scenario 8: Order-line is split

\- When the Order will be partially delivered, the quantity
which is available for delivery will be shipped when requested,
the quantity which is not available will be either put in
**back-order (8.1)**, **blocked (8.2)**, or **cancelled (8.3)**.
\- **8.1** **(A)** Accept the purchase order with a split-order
line backorder response with either known and/or unknown
delivery dates.
**(B)** Also confirm in an update response that the on-stock
order line is partially shipped and the other order line is
still partially back-ordered.
\- **8.2** Accept the purchase order with a split-order line
on-hold/blocked response with unknown delivery date.
\- **8.3** Accept the purchase order with a split-order line
delete response with unknown delivery date.

Example files in ZIP format for the above scenario's:
Onetrail TPN™ EDIFACT D.96A Example files
Onetrail TPN™ EDIFACT D.97A Example files
Onetrail TPN™ XML All Messages Example files
Onetrail TPN™ XML Order Response scenario Example files



Step 6: Test Message

For validation and simulation, please use the NAD segments as mentioned in the original ORDER.
Send in the ORDRSP and DESADV messages via the preferred communications channel and receive an validation report via E-mail.



Step 7: Go Live 

When all scenario's are tested your Onetrail Implementation Consultant will inform Coolblue that the onboarding is completed.

Golden order
Before a full production Go Live is possible, Coolblue will first send an so-called "golden order".
This order must fully processed and delivered to the selected Coolblue warehouse and all developed response messages must be send back via Live EDI connection for that order.

Full Go live!
A full Go Live is possible when Coolblue receives the physical delivery correctly and on time as confirmed in the EDI Order Response and Despatch Advise message(s). Coolblue will let you know when a full Go Live is possible.
However, when the process wasn't completed satisfactory, Coolblue might opt to send another "golden order" to repeat and verify the process again.