You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Connect to Onetrail using EDIFACT D96A, D97A or OT XML for Coolblue

Below you will find all steps necessary to connect to Coolblue via Onetrail using Onetrail EDIFACT D.97A, D.96A and OT XML.
Please note that Coolblue currently supports the following message types:

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

Step 1: Fill in customer setup-form

A Onetrail employee will send a 'Customer Setup-Form', this form will contain all required EDI data, such as;

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

Please make sure to return the filled out Setup-Form as soon as possible. Onetrail will process the Setup-Form within 2 days.

Step 2: Approve onboarding requirements Coolblue

Coolblue has a strict EDI policy, in reality, this means Coolblue want 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 TPN 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.

Note

Coolblue is investigating if they have 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

  • UNB & NAD+BY = 8713783719626 - Onetrail Edifact Test Buyer Trading Partner GLN
  • NAD+ST = 8713783719640 - Onetrail Edifact Test Buyer Ship To GLN
  • NAD+IV = 8713783719633 - Onetrail Edifact Test Buyer Invoice To GLN

Onetrail XML Format
*<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
Please also exactly communicate the above GLN's in the test Order Response and Despatch Advice messages, otherwise, the automatic validation process won't provide any feedback.

Step 5: Configure messages

Please find all technical documentation below:
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
Please find all 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

If all scenario's are tested, your Onetrail TPN Implementation Consultant will inform Coolblue that onboarding is completed.
Before a full production GoLive 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.
If Coolblue receives the physical delivery correctly and on time as confirmed in the EDI Order Response and Despatch Advise message(s), Coolblue will inform you when a full GoLive with Coolblue is possible.
However, if this process wasn't completed satisfactory, Coolblue might opt to send another "golden order" to repeat and verify the process again.

  • No labels