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

Compare with Current View Page History

« Previous Version 60 Next »



Welcome to the Dustin Connect page.

Guide on how we build your Dustin connection via Onetrail.




Dustin has chosen to partner with Onetrail to connect all suppliers product data into the Dustin webstore. Onetrail has over twenty years of experience in product data integration and will help you connect to Dustin. 

We offer three options to connect to the Onetrail platform for Dustin:

  • Option 1: Product Manager Standard with sFTP upload
    - Ability to use your own product data file or the Onetrail template file;
    - Product management by yourselves using our online Product Manager;
    - Automated product data upload using sFTP;
    - Maximum of 20.000 products.

  • Option 2: Product Manager Comfort
    - Product data file in your own format including pre-check of your file and 2 days of work;
    - Product management by Onetrail;
    - File delivery using sFTP;
    - Maximum of 120.000 products.

  • Option 3: Product Manager Premium
    - Product data file in your own format including pre-check of your file and 3 days of work;
    - Product management by Onetrail;
    - File delivery using sFTP;
    - Maximum of 250.000 products.

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 will check your file for the above requirements and deliver you a report with the outcome and advice on how to solve the mismatches. Based on this report you will be able to assess whether you meet the criteria of option 1.

For this pre-check advice, you will be charged € 280,00.






Here is a brief overview of the requirements for you, so that you can go for the option best in line with your technical and operational possibilities.


Option 1: Product Manager Standard with sFTP upload;

To make your Dustin connection work based on this subscription you need to able to perform the following steps:


Step 1: Your product data file

For this, you can use the Onetrail template file or your own Product data file:

 When you want to use your own product data file the following requirements apply:
    - Supported file formats are Excel (XLSX) and CSV
    - We apply a maximum file size. Please make sure your file size does not exceed 2.5 MB
    - The maximum amount of products in the file may not exceed 20.000 items
    - 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
    - If one of the above is not correct, the data won’t be processed and you need to be able to fix it


Step 2: Matching of columns 
Perform a mapping between your fields and the Onetrail fields in our online portal. 


Step 3: Matching of records

Perform a mapping of your product groups and brands to the Onetrail product groups and brands in our online portal. 


Step 4: Provide a 100 


 
    5. You can now start uploading your data via sFTP frequently. A processing report will inform you about the outcome and if you need to take manual action in our online portal, i.e. mapping a new used product group.





  • Option 2: Product Manager Comfort;
  • Option 3: Product Manager Premium.

Option 1: Product Manager Standard with sFTP upload



Requirements own product data file:






Option 2: Product Manager Comfort


Onetrail is taking care of the following Product Management workflows:

  • Mapping all the fields and maintaining this after each upload
  • Reporting possible product issue’s i.e. empty fields (Onetrail never changes data)
  • Mapping brands and adding new brand names if necessary
  • Product classification maintenance for current and future product groups

 

Process steps:


1. You send your product data file to our customer care for a pre-check (included in the price).

2. Onetrail takes care of matching and processing the data to the desired format. 

3. If everything is right, you can start uploading your product data via sFTP. Onetrail will take care of the rest.


Requirements product data file:

  • Any file format is supported, as long as it’s structured
  • Your products need to have an internal product group and brand that can be used for classification by Onetrail
  • SKU’s, Manufacturer part numbers and GTIN’s needs to be unique in your file, so may only exist once
  • Maximum of 120.000 products



Sign your contract with Onetrail 

You will receive an email from or sales department which includes a “Welcome to Dustin Connect” document together with a Onetrail Service Agreement and Onetrail General Terms and Conditions.

You need to decide which type of connection is suitable for you and sign the contract. When we receive your signed contract, we start setting up your connection. Depending on which of the three options you choose, the route to connect is different. 

You can read below how this works for option 1: Product Manager Standard with sFTP upload. We will contact you directly for the guidance on option 2 and 3.






Option 1: Product Manager Standard with sFTP upload


Step 1: Create your file

All product data you want to make available to Dustin must be presented in an Excel file. Download the Dustin 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

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 Number
Dustin Netherlands8719333012964
Dustin Finland6429830083719
Dustin Norway7080003540188
Dustin Sweden7300009049462
Dustin 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)


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





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








  • No labels