Magento – ny tool to Convert magento 1 Product import csv file to magento 2

If you look at the file Mage_ImportExport_Model_Abstract you will see that it has a method addLogComment. Now what this does is add log information at some time during the import and export process, as to when I am not sure.

It will log to files in the format var/log/import_export/%Y/%m/%d/%time%_%operation_type%_%entity_type%.log

There is a flag $_debugMode which you will need to set to activate this logging.

The function looks as follows.

/**
 * Log debug data to file.
 * Log file dir: var/log/import_export/%Y/%m/%d/%time%_%operation_type%_%entity_type%.log
 *
 * @param mixed $debugData
 * @return Mage_ImportExport_Model_Abstract
 */
public function addLogComment($debugData)
{
    if (is_array($debugData)) {
        $this->_logTrace = array_merge($this->_logTrace, $debugData);
    } else {
        $this->_logTrace[] = $debugData;
    }
    if (!$this->_debugMode) {
        return $this;
    }

    if (!$this->_logInstance) {
        $dirName  = date('Y' . DS .'m' . DS .'d' . DS);
        $fileName = join('_', array(
            str_replace(':', '-', $this->getRunAt()),
            $this->getScheduledOperationId(),
            $this->getOperationType(),
            $this->getEntity()
        ));
        $dirPath = Mage::getBaseDir('var') . DS . self::LOG_DIRECTORY
            . $dirName;
        if (!is_dir($dirPath)) {
            mkdir($dirPath, 0777, true);
        }
        $fileName = substr(strstr(self::LOG_DIRECTORY, DS), 1)
            . $dirName . $fileName . '.log';
        $this->_logInstance = Mage::getModel('core/log_adapter', $fileName)
            ->setFilterDataKeys($this->_debugReplacePrivateDataKeys);
    }
    $this->_logInstance->log($debugData);
    return $this;
}

For a mostly automated solution, you can try Ho_Import (https://github.com/ho-nl/Ho_Import). It supports most of what you are asking for for free.

Personally, I'd make a custom solution for that, using a Magento script, using FastSimpleImport (or ApiImport, or uRapidflow, or any other importing tool). You can set up a simple php script, see an example at https://github.com/avstudnitz/AvS_FastSimpleImport/blob/master/test.php. First, you'd have to read the CSV with fgetcsv, then you can transform it into the needed format (see http://avstudnitz.github.io/AvS_FastSimpleImport/ or the uRapidFlow documentation for details) and import it into Magento with the chosen importing tool. If you run that script as a cronjob, you'll have it automated.

The better way would of course be to create your own Magento module and using the Magento cronjobs.