Rating 3.5 stars - 2 votes

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.

import recent file
import recent file

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:

D:\Magento files\*.csv


import recent file
import recent file

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:

http://yoursuppliersite.com/magento*.csv


import recent file
import recent file

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]

Zipped file

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.


Try how easy to import with FREE Store Manager for Magento yourself! Get it Now!




Related Articles:


Card image

How to Perform Automated Product Import

Schedule Magento import to be accomplished on hourly, daily or weekly basis using the saved configuration. Read More...

Card image

Magento Import of Large Product Files: Workaround

Check out the ways to optimize large import file for successful upload. Read More...

Card image

Add Different Images to Different Magento Store Views

Find out how to add to export file group of fields with related information (ordered items, shipping details, billing details). Read More...

Card image

Magento Configurable Product Import: Step by Step Tutorial

Detailed instruction on Magento configurable products import. Check all CSV import file fields explained. Read More...


COMMENTS
Ashish Nayyar
Ashish Nayyar • 02/12/2015

Pretty decent explanation. When you say "Store Manager for Magento will handle it" do you mean it will handle zip file automatically?

Magento Store ManagerMod Ashish Nayyar • 02/12/2015

Exactly. Even if you select zipped file, the software will parse it automatically.

Ashish Nayyar
Ashish Nayyar eMagicOne • 02/12/2015

Thanks for the clarification. I appreciate your prompt response.

Lilian
Lilian • 02/11/2015

Very useful. Thanks!