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;
- Option 2: Product Manager Comfort;
- Option 3: Product Manager Premium.
Option 1: Product Manager Standard with sFTP upload
Process steps:
1. Upload your product data file to our online portal. For this, you can use the Onetrail template file or your own Product data file in Excel or CSV format.
2. The product data file will be validated and if you use your file format you can perform a mapping between your fields and the Onetrail fields in our online portal.
3. Next to that, you also need to map your product groups and brands to the Onetrail product groups – and brands.
4. Once the data is validated and mapped, the product data is available for Dustin.
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.
Requirements own product data file:
When you want to use your 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
- 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
- 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;
- Contract with Onetrail.- 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:
- - 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
- ;
- Contract with Onetrail. - 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;
- Contract with Onetrail
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- .
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 Decide which type of connection is suitable for you and sign the contract with Onetrail.
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
Choose your option below for specific guidelines on how we build your Dustin connection via Onetrail.
Product Manager Standard
- Guidelines on how to work with the Product Manager using your own product data file;
- Guidelines on how to work with the Product Manager using the Onetrail template;
- Guidelines on how to set up the sFTP upload.
Product Manager Comfort
- Onetrail will contact you to coordinate your on-boarding;
- Guidelines on how to send product data.
- Guidelines on how to set up the sFTP upload.
Product Manager Premium
- Onetrail will contact you to coordinate your on-boarding.
Dustin specific information
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 Entity | GLN Number |
|---|---|
| Dustin Netherlands | 8719333012964 |
| Dustin Finland | 6429830083719 |
| Dustin Norway | 7080003540188 |
| Dustin Sweden | 7300009049462 |
| Dustin Denmark | 5790000833276 |
Product data file requirements
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 .xlsx and .csv
When your product data file is completed in the correct way, please send it to us byemail: support@onetrail.com
Download Dustin 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
