Welcome to the Coolblue on-boarding page.
Build your Coolblue connection via Onetrail in 7 steps.
Info | ||
---|---|---|
| ||
Coolblue currently accepts the following messages:
|
Info | ||
---|---|---|
| ||
Coolblue currently supports the following message types:
|
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 | ||
---|---|---|
| ||
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 | ||
---|---|---|
| ||
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.
An 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+BY | 8713783719626 | Trading Partner GLN |
NAD+ST | 8713783719640 | Ship To GLN |
NAD+IV | 8713783719633 | Invoice To GLN |
Onetrail XML Format
GLN | Onetrail XML Test Buyer | |
<toRole> | 8714253023366 | Trading Partner GLN |
<shipTo> | 8714253023380 | Ship To GLN |
<billTo> | 8714253023397 | Invoice To GLN |
Note | ||
---|---|---|
| ||
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:
Please refer to our EDIFACT documentation supporting both versions D96A and D97A: Edifact documentation
Please refer to our XML schema documentation : XML schema documentationOnetrail EDIFACT D.96A MIG.
Onetrail EDIFACT D.97A MIG.
Onetrail Order Response XML-EDIFACT DOC.
Onetrail XSD-DOC.
Specific Coolblue Order Response requirements:
It is mandatory that the outbound message (ORDRSP) supports the following scenario's - when applicable (it needs to reflect the physical delivery/ real world shipments)
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
- 3. 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
- 4. 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
\-- 5. Purchase
- order
- is
- cancelled
- by
- either
- Seller
- or
- Buyer.
Scenario 6: Order-line(s) Deleted
\-- 6. One
- or
- more
- Order-Lines
- have
- been
- cancelled
- by
- either
- Seller
- or
- Buyer.
Scenario 7: Order-line is added
\-- 7. 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- 8.1A: Accept the purchase order with a split-order
- line
- backorder
- response
- with
- either
- known
- and/or
- unknown
- delivery
- dates.
- 8.1B: 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 messages for the above scenario's
Info |
---|
Please find example messages for each supported standards: |
Additional Message Type Examples:
Type | Invoice | DesAdv | Orders |
---|---|---|---|
XML | View XML | Not Available | Not Available |
Edifact D96a | View Edifact | View Edifact | View Edifact |
Edifact D97a | View Edifact | View Edifact | View Edifact |
Step 6: Test Messages
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.