Amazon TecDoc Import Technical Scope
| Version | Date | Created / Updated | Notes |
|---|---|---|---|
| v1.0 | 21.01.2025 | Bogomil Pavlov | First Publish |
The purpose of this document is to give good overview how the MML import should work.
TecDoc is a global automotive parts catalog and information system that provides standardized data for the identification and specification of car parts. It connects manufacturers, suppliers, and distributors in the automotive industry to ensure accurate and comprehensive vehicle part identification. The TecDoc MVLs for Amazon are available here
For Amazon have just MVLs which they separate on Car and Motorcycle. But in order Thus we need to be able to decide to which mml table we need to import the file at the moment the MML tables we need are: mml_de, mml_uk and mml_aus
Each MML we download from eBay may have different structure but from each MML we need to import:
| ePID | Make | Model | CCM | Submodel | Year | StreetName | VehicleType |
|---|
ePid is the K-type for motorcycles and scooters which we will import for each product and use for the validation during the import. Thus our logic for the import should not use the field index number but the field header name and we agree that is the correct field names. If we have a different name for some of the MMLs like ePid instead of e-Pid we can easily just amend the header in the file and import it.
| MML header name | Hemi field name |
|---|---|
| ePID | mmlEpid |
| Make | mmlMake |
| Model | mmlModel |
| CCM | mmlCcm |
| Submodel | mmlSubmodel |
| Year | mmlYear |
| StreetName | mmlStreet |
| VehicleType | mmlType |
Before each MML import if we can add additional step to truncated the table automatically and then import the new data if not we can take of this manually. This is something which will be used once every 3 months and it is not required to be incorporated in the UI at this point.
In order to import the MML we want to use our FTP credentials from where we can set the credentials and paths.
We want to check for FTP Credentials > Type = eBay MML Import and for each territory to have separate path for example
FTP Path > Label = MMLDE
FTP Path > Label = MMLUK
FTP Path > Label = MMLAUS
The file name should be the same as the path with extension .xlsx
MML Link: https://www.ebay.de/verkaeuferportal/angebote/optimieren/fahrzeugteile