eBay MVL import
MVL stands for Master Vehicle List and in contains all different Kcodes for each car part. MVLs are available for download via eBay website in .xlsx format.
For eBay we have different MVLs for the different countries like UK, ES, FR, IT, DE and AUS. 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_demvl_esmvl_frmvl_gbmvl_itmvl_aus
The first step is to TRUNCATE the table in phpmyadmin. The table name will be called mvl_{name of the country}. Example : mvl_gb
The second step is to download the MVL file from the relevant eBay country. In order to do that, just google “ebay uk/de/fr/whatever MVL” and find the relevant page for download.
Note : The downloaded file will be password protected. The password is written just above the download button.
After downloading the file, we need to map it correctly and remove the not-needed rows.
We need to import only: MakeModelVariantBodyStyleTypeYearEngineK-Type
Note : Please be advised that for different languages MVLs will be named differently, however we still need to rename them to the above values.
Here is how the mapping should look like, please make sure to follow the same order.
After we have edited the file with the correct mapping, we need to save it without password and as an .xlsx file. Please make sure the new file is NOT password protected, as otherwise the cron will not be able to read it. Name of the file must be: {name of the country}.xlsx - Example: GB.xlsx.
After saving the new xlsx file, it should be moved to the marketplace logs FTP in the default temp directory for the ebay (for now its .temp/ebay/mvl).
There is a cron (eBay Import Mvl) which will pick the file and import it into the database. Please make sure the cron is active.
/var/www/ebay/bin/import/cron_ebay_001_mvl_import.php
The imported mvl table should look like this in the phpmyadmin panel :
