How to Fetch and Import Most Recent File into Magento?
If you are updating data in your Magento shop considerably often via export/import, then you most likely have somewhere the folder with all those spreadsheets.
If you used to keep all old files you have ever imported or received during export (like majority of shopkeepers in fact:), then must be there has gathered the massive list of spreadsheets. So sometimes it becomes really hard to find the necessary one in the directory.
The Most Recent File
This turns into a real challenge when you need to create import configuration with settings (e.g. for automated data appending) and include latest file with data, especially when it is updating regularly.
You may need to import the latest file from the folder and might not remember its exact title or supplier each day provides new file for you to update your catalog and it is named differently, for example: magento02-04-2015.csv, magento02-05-2015.csv etc.
Then you need to manually and routinely pick up files for import and change import settings if you have them saved. But what to do when the spreadsheet is placed at remote FTP and you cannot change its name?
Auto-Select Latest File from Directory
Do you want to use the import system to determine what's the newest file? You have the chance to avoid the necessity to modify the date or re-name import file if you are using Store Manager for Magento.
You have to know one simple hint on how to set up import in the way for it to fetch recent file form certain directory.
1) Open Import/Export Wizard of Store Manager for Magento
2) At the step of selecting the import source file indicate path to its location and instead of filename or instead of variable part of spreadsheet title put asterisk symbol (*).
Let’s view the examples.
If you need the recent file from folder ‘Magento files’ placed at your PC, you indicate the following path:
This way the most recent file from that folder will be selected.
If you have HTTP or FTP link to the file location and if your files differ by date (magento02-04-2015.csv, magento02-05-2015.csv), you can indicate the following path:
So instead of date in filename you have * and this will let the software know that it should pick the latest by date file to import it.
3) Proceed to the next import settings. Check here the step-by-step guide -Import Products into Magento [Step-by-step guide]
Very often when data files are big, they got zipped for easier and faster information sending. So if you have got is zipped file, you should not worry - Store Manager for Magento will handle it. The software will detect and unpack the file and use the data for import.
Use Store Manager for Magento to automatically fetch recent file and upload it, no matter if it is stored locally or placed at remote FTP.