eBay MVL Import Technical Scope
| Version | Date | Created / Updated | Notes |
|---|---|---|---|
| v1.0 | 10000BC | Bogomil | First publish |
| v1.1 | 21.01.2025 | Bogomil | Incorporate FTP Credentials |
| v1.2 | 07.05.2025 | Bogomil | Add MVL US |
The purpose of this document is to give good overview how the MVL import should work.
MVL stands for Master Vehicle List and in contains all different Kcode for each car part. MVLs are available for download via eBay website in xlsx format.
<v1.2>For eBay we have different MVLs for the different countries like UK, ES, FR, IT, DE, US and AUS.</v1.2> Thus we need to be able to decide to which mvl table we need to import the file at the moment the MVL tables are: mvl_de, mvl_es, mvl_fr, mvl_uk, mvl_it, and mvl_aus
Each MVL we download from eBay may have different structure but from each MVL we need to import only: Make, Model, Variant, BodyStyle, Type, Year, Engine, K-Type
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 MVLs like Ktype instead of K-Type 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.
| MVL header name | Hemi field name |
|---|---|
| Make | mvlMake |
| Model | mvlModel |
| Variant | mvlVariant |
| BodyStyle | mvlBodyStyle |
| Type | mvlType |
| Year | mvlYear |
| Engine | mvlEngine |
| K-Type | ktype |
Before each MVL 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.
<v1.1>
In order to import the MVL 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 MVL Import and for each territory to have separate path for example
FTP Path > Label = MVLDE
FTP Path > Label = MVLUK
FTP Path > Label = MVLAUS
FTP Path > Label = MVLES
FTP Path > Label = MVLFR
FTP Path > Label = MVLIT
<v1.2>FTP Path > Label = MVLUS
Please note for US we should validate eBay Motor eBay site.</v1.2>
The file name should be the same as the path with extension .xlsx
</v1.1>
MVL Links:
UK: http://pages.ebay.co.uk/help/sell/contextual/master-vehicle-list-manually.html
DE: https://verkaeuferportal.ebay.de/fahrzeugverwendungsliste-herunterladen
FR: https://espacevendeurs.ebay.fr/conditions-dutilisation-de-la-liste-principale-des-vehicules