I am just wondering what would be the easiest way to display vehicles using the Magento platform.
So daily I receive a CSV file of all the vehicles that are in stock at my Dealership via FTP, I want to be able to use this CSV file to import vehicles as products onto my store and cron it daily.
Because the CSV file is loaded daily it is formatted differently than the standard CSV import tool that Magento provides. For example in the CSV file one column will be for the Manufacturer of the vehicle there are also columns for price, variant, owners, engine size etc...
Any idea what would be the best way to import this data?
If the CSV file doesn't contain one of the products in the category that I am importing them into I want them not to display. The reason I would like this to happen is because if the vehicle isn't on the CSV we no longer have it in stock.
Any ideas how I could do this?