Table of Contents

maxLevel	1

Onetrail TPN™ Seller PDE: Product Data Delivery

Products

Introduction

Onetrail TPN™ connected Sellers can upload their Product Data using

three CSV formatted files: Generic Product, Generic Stock and Customer

Price file. The combination of these three files enables Onetrail to

generate and deliver the required output files to your customers

(hereinafter called Customer or Customers) containing those

products
that

products that you want to make available to them (where you have indicated a

Customer specific price) as well as to correctly send changes and

related product stock availability.

Remark: Stock files may be processed on an hourly basis if possible.

Process

Choreography

!Onetrail\_PRD\_ChoreografieV2.jpg(Onetrail_PRD_ChoreografieV2.jpg
"Onetrail_PRD_ChoreografieV2.jpg")

Onetrail requires three file types:

Product file

This file should contain ALL products that you want to make

available
through

available through Onetrail TPN™ to your customers. The file is to be delivered on

a daily basis as early as possible but no later than 4:00am.

Onetrail usage: Based on this file Onetrail updates the Onetrail TPN™

Product Data Management (PDM) database that contains all products from

all suppliers with a unique reference to the vendor part number.

Onetrail matches your new products with the unique vendor part number

within Onetrail TPN™ PDM, applies changes or deletions and adds a unique

classification based on the UNSPSC standard. Apart from this, brands are

mapped to a uniform brand code. The stock information in this file is

used to perform a daily update of the stock position within Onetrail

TPN™ PDM. This will consequently be updated with the (hourly) Generic

Stock file.

Remarks:

All price information in this file is ignored
Empty fields are not allowed
A full file is expected every time

Stock file

This file should contain ALL products with accurate stock availability

that you want to make available through Onetrail TPN™ to your Customers.

This file is to be delivered on an hourly basis.

Onetrail usage: Onetrail processes this file to update stock

availability for your products in Onetrail TPN™ PDM. Onetrail generates

an output of stock information to the (ERP) system of the Customer. This

information is used as an indication when selling/buying products.

Remarks:

Apart from the (hourly) stock updates Onetrail allows Customers to

perform a Real time Price and Availability check from within their

(ERP) system which results in a real-time request to your

environment (if available). It is common practice for Onetrail TPN™

connected Customers to perform such checks before sending a purchase

order so errors can be avoided.

Customer Price file

Onetrail expects a separate Customer Price file per Customer you wish to

trade with through Onetrail TPN™. This file is to be delivered on a

daily basis as early as possible but no later than 4:00am. This file

should contain the products with their net prices to be made available

to a

specific Customer

specific customer.

Onetrail usage: Onetrail processes this file, combines it with the

product data available within PDM data, and delivers the output to the

Customer’s (ERP) system.

Customer files may contain only the changes or be send as a full file

with prices only for those products available to the specific Customer.
Products without a price (empty price field) will not be delivered to

the Customer, a “0” (zero) price is regarded an actual amount.

Remarks:

For support and demo purposes Onetrail requires one additional

Customers file for Onetrail itself (Onetrail account). This file

normally contains all products with default prices (i.e. highest

price).

1. Delivery Schedule

Please set up a schedule and inform Onetrail when your files will be

delivered to the Onetrail FTP server. Below you will find examples of

the schedules Onetrail requires. Keep in mind that Onetrail needs to

process and subsequently deliver the files to the Customers system

before start of business (8:00am). Therefore Onetrail requires the files

no later than 4:00am. The Generic Stock file may obviously be delivered

every hour during business hours.

Example delivery schedules

*

Generic Product File:

*

Always a full file with all products.

Day	Frequency / Time	Remarks
SUN: ---	:-------------------------------	:------------------------------------		Once a day / 2.00am
MON:	Once a day / 2.00am
TUE:	Once a day / 2.	SUN:	Once a day / 2.00am	MON:	Once a day / 2.00am	TUE:	Once a day / 2. 00am
WED:	Once a day / 2.00am
THU:	Once a day / 2.00am
FRI:	Once a day / 2.00am
SAT:	No file (* Once a day / 2.00am)	* Only if Saturday is a business day

*

Generic Stock File:

*

Always a full file with all products.

Day	Frequency / Time	Remarks
:---	:------------------------------	:------
SUN:	No file
MON:	Hourly between 08.30am	SUN:	No file	MON:	Hourly between 08.30am – 6.00pm
TUE:	Hourly between 08.30am – 6.00pm
WED:	Hourly between 08.30am – 6.00pm
THU:	Hourly between 08.30am – 6.00pm
FRI:	Hourly between 08.30am – 6.00pm
SAT:	Hourly between 08.30am – 6.00pm

*

Customer Price File:

*

Day
Frequency / Time
Remarks
Full/mutation
:---
:-------------------------------
:-------
:------------------------------------
SUN:
Once a day / 2.00am
Full
MON:
Once a day / 2.00am
Mutation
TUE:
Once a day / 2.00am
Mutation
WED:
Once a day / 2.00am
Mutation
THU
SUN:
Once a day / 2.00am
Full
MON
:
Once a day / 2.00am
Mutation
TUE
FRI:
Once a day / 2.00am
Mutation
WED
SAT:
No file (* Once a day / 2.00am)
Mutation
THU:
Once a day / 2.00am
Mutation
FRI:
Once a day / 2.00am
Mutation
SAT:
No file (* Once a day / 2.00am)
Mutation
* Only if Saturday is a business day
Syntax
The table below
* Only if Saturday is a business day

Syntax

The table below shows an overview of the field definitions per file type

(Product, Stock, (Customer Price) and their status (Mandatory (M),

Optional

Optional (O) or Not Applicable (N/A)).

<table>
<thead>
<tr class="header">
<th style="text-align: left;">Fieldname</th>
<th style="text-align: left;">Description</th>
<th style="text-align: left;">Product</th>
<th style="text-align: left;">Stock</th>
<th style="text-align: left;">Price</th>
<th style="text-align: left;">Example</th>
</tr>
</thead>
<tbody>
<tr class="odd">
<td style="text-align: left;">Stock Keeping Unit (SKU)</td>
<td style="text-align: left;">Supplier (your) Product Number</td>
<td style="text-align: left;">M</td>
<td style="text-align: left;">M</td>
<td style="text-align: left;">M</td>
<td style="text-align: left;">78GK3LL12</td>
</tr>
<tr class="even">
<td style="text-align: left;">Price</td>
<td style="text-align: left;">Net Purchase Price, excl. VAT</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">M</td>
<td style="text-align: left;">650,00</td>
</tr>
<tr class="odd">
<td style="text-align: left;">Currency</td>
<td style="text-align: left;">ISO Code EUR / USD / GBP etc.</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">M</td>
<td style="text-align: left;">EUR</td>
</tr>
<tr class="even">
<td style="text-align: left;">Special Price</td>
<td style="text-align: left;">Net Purchase Price, excl. VAT (i.e. Promotional price)</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">O</td>
<td style="text-align: left;">625,38</td>
</tr>
<tr class="odd">
<td style="text-align: left;">Manufacturer Product Identifier</td>
<td style="text-align: left;">Vendor Product Number</td>
<td style="text-align: left;">M</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">C4151A</td>
</tr>
<tr class="even">
<td style="text-align: left;">Brand</td>
<td style="text-align: left;">Brand name or Code</td>
<td style="text-align: left;">M</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">HP or 654</td>
</tr>
<tr class="odd">
<td style="text-align: left;">Stock</td>
<td style="text-align: left;">Stock Position</td>
<td style="text-align: left;">M</td>
<td style="text-align: left;">M</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">54</td>
</tr>
<tr class="even">
<td style="text-align: left;">Product EAN (GTIN)</td>
<td style="text-align: left;">EAN Product Number (GTIN)</td>
<td style="text-align: left;">O</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">8714123456789</td>
</tr>
<tr class="odd">
<td style="text-align: left;">Short Description</td>
<td style="text-align: left;">Short Description of the Product</td>
<td style="text-align: left;">M</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">Wonderful product</td>
</tr>
<tr class="even">
<td style="text-align: left;">Long Description</td>
<td style="text-align: left;">Long Description of the Product</td>
<td style="text-align: left;">M</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">This is the most wonderful product there is.</td>
</tr>
<tr class="odd">
<td style="text-align: left;">Classification (i.e.UNSPSC)</td>
<td style="text-align: left;">Product group (Text or Code)</td>
<td style="text-align: left;">M</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">i.e. “Server” or “45AW5”</td>
</tr>
<tr class="even">
<td style="text-align: left;">VAT</td>
<td style="text-align: left;">Tax Level of the Product i.e. High, Low, Null</td>
<td style="text-align: left;">M</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">High</td>
</tr>
<tr class="odd">
<td style="text-align: left;">Status</td>
<td style="text-align: left;">New, Modify, Delete, Equal</td>
<td style="text-align: left;">O</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">O</td>
<td style="text-align: left;">N</td>
</tr>
<tr class="even">
<td style="text-align: left;">Key Assortment</td>
<td style="text-align: left;">Code Representing Deliverability of the Products within the Key Assortment
i.e. A= Within 24hrs., B= 48hrs etc.</td>
<td style="text-align: left;">O</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">B</td>
</tr>
<tr class="odd">
<td style="text-align: left;">Signal Code</td>
<td style="text-align: left;">Code Representing delivery time of Stock Position i.e. 48h</td>
<td style="text-align: left;">O</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">48h</td>
</tr>
<tr class="even">
<td style="text-align: left;">On Order</td>
<td style="text-align: left;">Number of Units on Order at Vendor</td>
<td style="text-align: left;">O</td>
<td style="text-align: left;">N/A 
</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">500</td>
</tr>
<tr class="odd">
<td style="text-align: left;">Data Available On Order Stock</td>
<td style="text-align: left;">Excepted Availability Date Ordered Units at Vendor</td>
<td style="text-align: left;">O</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">20071231</td>
</tr>
<tr class="even">
<td style="text-align: left;">Recommend Price</td>
<td style="text-align: left;">i.e. Gross Price</td>
<td style="text-align: left;">O</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">874,00</td>
</tr>
<tr class="odd">
<td style="text-align: left;">URL</td>
<td style="text-align: left;">URL to Product and/or Picture on Website</td>
<td style="text-align: left;">O</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">http://www.seller.com/picture.jpg^{Image Modified}</td>
</tr>
<tr class="even">
<td style="text-align: left;">Serial Keeping</td>
<td style="text-align: left;">Product Serial Numbers will be Scanned Yes/No</td>
<td style="text-align: left;">O</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">Y</td>
</tr>
<tr class="odd">
<td style="text-align: left;">Intrastat number</td>
<td style="text-align: left;">Intrastat Reference Number</td>
<td style="text-align: left;">O</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">12244</td>
</tr>
<tr class="even">
<td style="text-align: left;">UOM</td>
<td style="text-align: left;">Unit Of Measurement Code i.e. Piece, Blister</td>
<td style="text-align: left;">O</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">Blister</td>
</tr>
<tr class="odd">
<td style="text-align: left;">UOM Quantity</td>
<td style="text-align: left;">Unit Of Measurement Quantity, Number of Units in UOM</td>
<td style="text-align: left;">O</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">12</td>
</tr>
<tr class="even">
<td style="text-align: left;">Minimum Order Quantity</td>
<td style="text-align: left;">i.e. 1, 5, 12</td>
<td style="text-align: left;">O</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">N/A</td>
<td style="text-align: left;">1</td>
</tr>
</tbody>
</table>

Price – "Currency" field: The Currency field is not necessarily

mandatory if Currency is well communicated by the Seller. For

example, if the Currency is Euro only, Onetrail can set Euro as a

default value.
Product and Price – "Status" field: In most cases Onetrail

determines the status. The status needs to be delivered when Sellers

also deliver mutation files to Onetrail TPN™.
Product File – "VAT" field: The VAT field is necessarily mandatory

if VAT is i.e. always HIGH, then Onetrail can set VAT as a default

value.

Format

The format for the three files is Comma Separated Values. Onetrail's

definition of CSV: Each record is put on 1 line with a CR/LF or LF as

line separator. Each field is separated by a separator. This separator

cannot be used inside the data,

therefor

Therefor Onetrail suggests to use "|"

as
a

as a separator.

Communication

All files can be stored on the Onetrail FTP server. To

enable
connectivity

enable connectivity to the Onetrail FTP server, Onetrail requires your external

“STATIC” IP address. Onetrail will provide you the necessary login

settings.

FTP server

Please refer to FTP Server(FTP "wikilink") for

more details.

File naming convention

File Type

File Name

Example

1. File naming convention

File Type	File Name	Example
:--------	:---------------------------------------	:-------------------------------------
Product	<Seller name>.8714253023809.product.csv	test_seller.8714253023809.product.csv
Stock	<Seller name>.8714253023809.stock.csv	test_seller.8714253023809.stock.csv
Price	<Seller name>.<Buyer GLN Code>.price.csv	test_seller.8714231442455.price.csv

Replace “<Seller name>” with either
:*your company name (abbreviated)

or

:*the GLN address code of your company (If you don’t already have GLN

address codes, Onetrail will assign GLN address codes to your Company).

Replace “\<Buyer GLN Code\>” with the GLN code of that
specific
specific Customer. This code is supplied to you by Onetrail.

The Customer Price file name for Onetrail support and demo purposes

will be for example: test_seller.8714231442455.price.csv where

“8714231442455” is the Onetrail specific Customer GLN address

code.

Stock

Introduction

=Onetrail TPN™ Seller PDE: Stock Data Delivery=

==Introduction==

In Onetrail TPN™ it is possible to deliver stock data. In this section you will find information about the Stock Data Delivery process.==

Stock file

==

This file should contain ALL products with accurate stock availability that you want to make available through Onetrail TPN™ to your Customers. This file is to be delivered on an hourly basis.
Onetrail usage: Onetrail processes this file to update stock availability for your products in Onetrail TPN™ PDM. Onetrail generates an output of stock information to the (ERP) system of the Customer. This information is used as an indication when selling/buying products.''

Remarks:

''

Apart from the (hourly) stock updates Onetrail allows Customers to perform a Real time Price and Availability check from within their (ERP) system which results in a real-time request to your environment (if available). It is common practice for Onetrail TPN™ connected Customers to perform such checks before sending a purchase order so errors can be avoided.

Day	Frequency / Time	Remarks	Full/mutation
:---	:-------------------------------	:-------	:------------------------------------
SUN:	Once a day / 2.00am	Full
MON:	Once a day / 2.00am	Mutation
TUE:	Once a day / 2.00am	Mutation
WED:	Once a day / 2.00am	Mutation
THU	SUN:	Once a day / 2.00am	Full	MON :	Once a day / 2.00am	Mutation
TUE FRI:	Once a day / 2.00am	Mutation
WED SAT:	No file (* Once a day / 2.00am)	Mutation	THU:	Once a day / 2.00am	Mutation	FRI:	Once a day / 2.00am	Mutation
SAT:	No file (* Once a day / 2.00am)	Mutation	* Only if Saturday is a business day

Page tree

Page History

Versions Compared

Old Version 3

New Version 4

Key

Products

Introduction

Onetrail TPN™ connected Sellers can upload their Product Data using

three CSV formatted files: Generic Product, Generic Stock and Customer

Price file. The combination of these three files enables Onetrail to

generate and deliver the required output files to your customers

(hereinafter called Customer or Customers) containing those

products that you want to make available to them (where you have indicated a

Customer specific price) as well as to correctly send changes and

related product stock availability.

Remark: Stock files may be processed on an hourly basis if possible.

Process

Choreography

!Onetrail\_PRD\_ChoreografieV2.jpg(Onetrail_PRD_ChoreografieV2.jpg"Onetrail_PRD_ChoreografieV2.jpg")

Onetrail requires three file types:

Product file

This file should contain ALL products that you want to make

available through Onetrail TPN™ to your customers. The file is to be delivered on

a daily basis as early as possible but no later than 4:00am.

Onetrail usage: Based on this file Onetrail updates the Onetrail TPN™

Product Data Management (PDM) database that contains all products from

all suppliers with a unique reference to the vendor part number.

Onetrail matches your new products with the unique vendor part number

within Onetrail TPN™ PDM, applies changes or deletions and adds a unique

classification based on the UNSPSC standard. Apart from this, brands are

mapped to a uniform brand code. The stock information in this file is

used to perform a daily update of the stock position within Onetrail

TPN™ PDM. This will consequently be updated with the (hourly) Generic

Stock file.

Remarks:

All price information in this file is ignored

Empty fields are not allowed

A full file is expected every time

Stock file

This file should contain ALL products with accurate stock availability

that you want to make available through Onetrail TPN™ to your Customers.

This file is to be delivered on an hourly basis.

Onetrail usage: Onetrail processes this file to update stock

availability for your products in Onetrail TPN™ PDM. Onetrail generates

an output of stock information to the (ERP) system of the Customer. This

information is used as an indication when selling/buying products.

Remarks:

Apart from the (hourly) stock updates Onetrail allows Customers to

perform a Real time Price and Availability check from within their

(ERP) system which results in a real-time request to your

environment (if available). It is common practice for Onetrail TPN™

connected Customers to perform such checks before sending a purchase

order so errors can be avoided.

Customer Price file

Onetrail expects a separate Customer Price file per Customer you wish to

trade with through Onetrail TPN™. This file is to be delivered on a

daily basis as early as possible but no later than 4:00am. This file

should contain the products with their net prices to be made available

to a

specific customer.

Onetrail usage: Onetrail processes this file, combines it with the

product data available within PDM data, and delivers the output to the

Customer’s (ERP) system.

Customer files may contain only the changes or be send as a full file

with prices only for those products available to the specific Customer.Products without a price (empty price field) will not be delivered to

the Customer, a “0” (zero) price is regarded an actual amount.

Remarks:

For support and demo purposes Onetrail requires one additional

Customers file for Onetrail itself (Onetrail account). This file

normally contains all products with default prices (i.e. highest

price).

Delivery Schedule

Please set up a schedule and inform Onetrail when your files will be

delivered to the Onetrail FTP server. Below you will find examples of

the schedules Onetrail requires. Keep in mind that Onetrail needs to

process and subsequently deliver the files to the Customers system

before start of business (8:00am). Therefore Onetrail requires the files

no later than 4:00am. The Generic Stock file may obviously be delivered

every hour during business hours.

!Onetrail\_PRD\_ChoreografieV2.jpg(Onetrail_PRD_ChoreografieV2.jpg
"Onetrail_PRD_ChoreografieV2.jpg")

with prices only for those products available to the specific Customer.
Products without a price (empty price field) will not be delivered to