import,products,cron,magento-1,csv – Cron Advanced CSV Product Import Mapping in Magento 1

croncsvimportmagento-1products

I'm wondering how I could map a product CSV import including product attributes etc.

I need the CSV import to run daily via cron, as the CSV file is updated daily with product data.

I also need any products that aren't included in the CSV import to appear as out of stock in Magento.

Any idea what tools are out there that might allow me to do this?

Best Answer

Try Ho_Import (https://github.com/ho-nl/Ho_Import). Well developed, fully open source.

From their Github some use cases: At the time of release we have this tool running for multiple clients, multiple types of imports:

One time product / category imports from an old datasource Example config
Periodic category import with values for multiple store views Example config
15 minute inventory only updates
Nightly complete inventory updates Example config
Nightly price updates
Incremental category/product updates from ERP systems
Customer import Example config
Customer import with billing and shipping address Example config

Related Solutions

Magento – Are there any csv import logs kept

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;
}

Import Stock via CSV – How to Update Stock Using CSV Files

This is a standard error that Magento returns when there is no product with some of the SKUs. If there are 3 SKUs that don't exist in your store - you have to see 3 times this error. Please check each of the SKUs in your CSV file if they actually exist in your store.

You can see app/code/core/Mage/Catalog/Model/Convert/Adapter/Product.php -> public function saveRow:

$productId = $product->getIdBySku($importData['sku']);

if ($productId) {
    $product->load($productId);
} else {
    $productTypes = $this->getProductTypes();
    $productAttributeSets = $this->getProductAttributeSets();

    /**
     * Check product define type
     */
    if (empty($importData['type']) || !isset($productTypes[strtolower($importData['type'])])) {
        $value = isset($importData['type']) ? $importData['type'] : '';
        $message = Mage::helper('catalog')->__('Skip import row, is not valid value "%s" for field "%s"', $value, 'type');
        Mage::throwException($message);
    }

If Magento can't get the product ID by SKU - it checks for column type, but your CSV hasn't such column, that's why it throws an error.

Best Answer

Related Solutions

Magento – Are there any csv import logs kept

Import Stock via CSV – How to Update Stock Using CSV Files

Related Topic