Versions Compared

Key

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


On this page we explain how you upload and manage your product data with the Product Manager so that it becomes available to your buyers via the Trading Partner Network.

You can use your own product data file, as explained below, or go to the instructions on how to use the Onetrail template.



Step 1: Create product data file

All product data you want to make available to your customers must be presented in an Excel or CSV file. 

Product data file guidelines

  1. The maximum amount of products in the file may not exceed 20.000 items.

  2. We apply a maximum file size. Please make sure your file size does not exceed the 6 MB.

  3. We only support the file formats Excel (.xlsx) and CSV (.csv)

  4. When you are using a CSV file your file needs to have an exclusive separator. For example, you use a comma as a separator, then you can’t use comma’s in your product descriptions.

  5. Your file must contain at least the following mandatory fields and each column comes with specific restriction and requirements for the data being added:

Mandatory / Optional

Column header

Required data

Example notation

Additional information

Mandatory

SKU

Stock Keeping Unit (SKU) to identify a product. Selling-parties can use SKU numbers in their ERP-system to identify products. This is most often the unique number your customers are using on their purchase orders. The SKU you provide must be unique for you as a Seller. Duplicate SKU records will be ignored or lead to import failure.


Terminology and how to use them 

Mandatory

MFPN

Manufacturer Part Number. The original part number provided by the manufacturer of a product. The part number you provide should be the original Manufacturer Part Number without any changes or additions. The Manufacturer Part Number you provide must be unique and should have at least 4 positions.


Terminology and how to use them 

Mandatory

Short Description

Short Description of the product, max. 35 characters.



Mandatory

Long Description

Long Description of the product, max. 255 characters.



Mandatory

Brand

Brand name assigned to the product by the Manufacturer of the product


Overview of used brands 

Mandatory

Classification

Product group name or a classification code


Overview of all UNSPSC codes

Mandatory

VAT

VAT = Tax Level of the Product 

High, Low, Null or the percentage in numeric values.


Mandatory

Buyer (GLN)

Global Location Number (GLN) of the buyer. Will be provided by Onetrail.


What is a Global Location Number (GLN)?

Mandatory

Currency

Currency in ISO-4217 Code.

EUR / USD / GBP etc.


Mandatory

Price

Net Purchase Price, excl. VAT. The decimal separator is detected automatically.



Mandatory

Stock

Stock position. Real stock or Boolean numeric values are allowed.

152 as real value

Boolean:

1(=stock),

0(=no stock)


A full overview on all mandatory and optional product data fields can be found in the Product Manager - Product data file guidelines.


Pre check for your

own

product data file

If you are having doubts about the correctness of your own product data file and the ability of your IT-system to deliver the right data, you can choose to do a pre check.

With this pre check our customer care department will check your file and deliver you a report with the outcome and advice on how to solve any emerged mismatches. Based on this report you will be able to assess whether you meet the criteria to setup this connection.

For this pre check advice, you will be charged € 280,00. Please contact customer care at support@onetrail.com for inquiries. 



Step

1: Create your product data file

All product data you want to make available to Dustin must be presented in an Excel or CSV file.

When you are using a CSV file

    · CSV files need to have an exclusive separator. For example, you use a comma as a separator, then you can’t use comma’s in your product descriptions
   

· You need to be able to provide the mandatory fields as documented here: Product Data fields explained
    · Different field types will be validated:
            · Date fields need to have a valid date
            · Price fields need to have a valid amount with a maximum of 4 decimals
            · GTIN (EAN) product codes, if used, need to be valid
            · SKU’s, Manufacturer part numbers and GTIN’s needs to be unique in your file, so may only exist once

Contains predefined headers bar with cells in two different colors;

  • Yellow for the mandatory columns;
  • Blue for the optional columns. 

Column guidelines

Each column comes with specific restriction and requirements for the data being added. An overview of all restrictions and requirements can be found in the Dustin Template column guidelines

Column L needs the Buyer (GLN) number of the Dustin entity to which you are going to make your product data available.

Dustin EntityGLN NumberDustin Netherlands8719333012964Dustin Finland6429830083719Dustin Norway7080003540188Dustin Sweden7300009049462Dustin Denmark5790000833276

Product data file requirements:

The maximum amount of products in the file may not exceed 20.000 items.

We apply a maximum file size. Please make sure your file size does not exceed the 2.5 MB.

We only support the file formats Excel (.xlsx) and CSV (.csv)

2: Login to the Product Manager

When you finished filling out your product data file you are ready for the upload.


  • Go to the My Onetrail https://apps.onetrail.net and login. Your username and password will be provided by Onetrail by email. 

  • Go to the tab Products, you are now in the Product Manager.


Problems logging in?

Consult the My Onetrail Support page for the answers.

Image Added



Step 3: Upload your product data file


  • Choose 'upload products' on the Product Manager home page. 

  • Select your product data file in the finder or drag your document to the drop box.


Your product data file will be uploaded.

Image Added



Step 4:  Matching fields

Watch the tutorial on how to match the fields of your uploaded product data file with the Onetrail standard.

We will save this mapping once you are done so the next time you use this template you won't have to do this again.  


Multimedia
name01 - Onetrail tutorials - Matching fields - final version.mp4
width75%
height75%



Step 5: Matching records 

Watch the tutorial on how to match the unmatched records of your uploaded product data file.

Unmatched records a may appear in the columns:

  • Brands; 
  • Classifications;
  • VAT Codes;
  • UOM.

Multimedia
name02 - Onetrail tutorials - Matching records - final version.mp4
width75%
height75%



Step 6: Request a new brand, classification or VAT code & adjust the Translation table

Watch the tutorial on how to request a new Brand, Classification or VAT code or adjust the Translation table. 

Multimedia
name03 - Onetrail tutorials - Request a new Brand, Classification or VAT code.mp4
width75%
height75%




Step 7: Overview of all available products and customize products

In the 'Product table' you find an overview of all the products you have made available to your customers.

This display defaults to 10 records, you can adjust this setting at the top right. Use the arrows at the bottom to navigate through the overview.

You can also:
- Sort;
- Filter;
- Choose which columns you want to be displayed;
- And choose fields.

Download current overview
With the 'Download current overview' function you can download an up-to-date overview in Excel format of all product data that you have made available to your buyers via the Product Manager.


Adjustments
If you want to make a large number of adjustment, or add new items, you can do so with a new product file upload.

For small number adjustments or adding a few new items you can do that in-line. Show how....   


Remove products
For products that are no longer supplied, for example due to end of life (EOL), you remove the product line from the product file. The system automatically sets the missing product to delete. This product will then no longer be forwarded to your buyers.

Image Added



My Onetrail dashboard

The next time you login to My Onetrail environment, you find in the top right corner an overview of the status of your products and orders.

The 'Check products' and 'Check orders' button provides a direct link to your unmatched records and orders in progress.

The My Onetrail dashboard shows news and notifications to keep you informed on our maintenance and incident status and the latest product news.

Image Added



Step 2: Test your file

When we receive your product data file, we will test and check it in various ways to guarantee that your data is entered correctly into our system.

We will contact you when we discover errors or missing data in your file.

When your file passed the test, we proceed to step 3. 

Step 3: Share your file

Now that your product data file is approved, we need to automate the daily processing of your file. 

We will provide you by email our Onetrail Server Location details. An daily updated version of your product data file must be provided on this server location. Onetrail will schedule a daily automated pick up of your product data file on this location. 

When this daily data sharing works, we will give Dustin a heads up. 

Step 4: Activate your connection 

After our heads up, Dustin will check that they are correctly receiving your product data via Onetrail into their IT-systems.

When this is confirmed, you will receive a confirmation from us by email that your Product Manager + sFTP connection for Dustin is officially up and running!

Dustin will let you know when your old product data sharing connection can be discontinued. 

Step 5:

Update, monitor and maintain your connection


Provide a daily updateDustin demands updates

You keep your product data up to date product data from all suppliers. To comply with this, you need to provide a daily update of your product data file to our server locationby providing updates. You do this by ...


Upload Report

Onetrail monitors your product data flow and will let you know with an Upload Report when any irregularities occur.

This alert is sent by email to your technical contact person. 


Support 

If you have any questions on your Dustin connection please contact Onetrail Customer Care via our support page, we are happy to help you.

If you do not have a Servicedesk account yet you can request one easily via an email to our support address support@onetrail.com



Image Modified