eBay MML 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.
MML stands for Master Motor List and it contains all different ePids for each motor part MMLs are available for download via eBay website in xlsx format.
For eBay we have different MMLs for UK, DE and AUS. 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. However if we have a case where the the header names do not match or any of them is missing we want to return an error and stop the whole process of truncate and import.
| 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. 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