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.
This turns into a real challenge when you need to create an import configuration with settings (e.g. for automated data appending) and include the 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 a new file for you to update your catalog and it is named differently, for example, magento02-04-2022.csv, magento02-05-2022.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 the 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 files from a certain directory.
1) Open Import/Export Wizard of Store Manager for Magento
2) At the step of selecting the import source file indicate the path to its location and instead of the filename or instead of the variable part of the spreadsheet title put an asterisk symbol [*].
Let’s view the examples.