Versions Compared

Key

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


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

This can be done using your own product data file or the Onetrail template.

In deze pagina leggen we uit hoe je jouw productgegevens kunt uploaden en beheren zodat deze via het Trading Partner Network beschikbaar worden voor jouw buyers.

Step 1: Create your file

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



Image Added

Quick link to Product Manager

Image Added

Quick link to Product data file guidelines



Step 1: Login to the Product Manager

  • 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?

See the Q&A ??? for all answers (link page)

Image Added



Step 2: Fill out the Onetrail template

  • Start by downloading the Onetrail template. You do this by hitting the 'Download current overview' button.

  • The document will download automatically and can be found in your downloads folder. 
     
  • Open this document in Excel.

Onetrail template guidelines

All product data you want to make available to your customers must be presented in

a file. For

this

you use the the Onetrail Template to start with. 

This standard Excel file contains predefined headers bar with cells in two different colors;

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

Column guidelines

Onetrail template.

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

The description of the expected data is added to Row 1 and becomes visible with a mouse over. In addition you can consult the overview of all product data file 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)

Image Added



Step 3: Upload your file

When you finished filling out the Onetrail template and saved your product data file, you are ready for the upload. 


  • Go to the Product Manager home page. Choose 'upload products'

  • Choose 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 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 5: 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 6: Overview of all available products and customize products

In the product table you will now see an overview of all the products that 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 an adjustment, you can do so with a new product file upload. 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 delite. 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 provides news and notifications to keep you informed on our maintenance and incident status and the latest product news.

Image Added



When your product data file is completed in the correct way, please send it to us byemail: support@onetrail.com 

Image Removed

Download Onetrail Template

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 update

Dustin demands 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 location.


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