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