Magento – Associate Products to Categories after Export CSV

categoryconfigurable-productexportimportmagento-1.7

Is there a way to associate products with categories?

I've exported a csv with all the products, images etc (a complete export) then after the import (it wasn't painless) I've noticed 3 things

1) Categories was missing! Removed the products. Uploaded a csv with the categories. Uploaded, again, products but they still not in categories!!!

Do you know a way I can associate those products with categories?

Possibly with a csv? I've tried this (changing it a bit) and read other stuff on the net but no luck.

–

2) Configurable products are not associated, different colors and sizes products are there but not associated with the main product… (didn't fixed it yet)

3) Images was missing in Back & Frond end. fixed. (it wasn't painless)

Best Answer

To associate products with categories in Dataflow you'll need two pieces of data:

Sku (Configurable, Simple, doesn't matter)
The target Category IDs

The field for the category IDs needs to be comma-separated itself, so make sure it's quoted if you're manually creating it:

sku,category_ids
ABCD1234,"1,2,3,4,5"
L0S7,"4,8,15,16,23,42"

Save it to disk as a .csv file, and you can upload it to the All Products Import default dataflow profile. This will replace all current categories for the skus listed, so take caution and make sure to get a list of pre-existing category associations.

Related Solutions

Magento – Importing product weights when multiple rows in CSV per product

The file you generated through Magento Export (whether this is default import/export module or default dataflow profile) is NOT going to work if you import it back, because it doesn't preserve the format.

If you want to update weights, I would recommend this:
1) filter your CSV in Excel, filter only those which have "sku" field assigned
2) copy-paste the filtered rows into new spreadsheet
3) leave only 2 columns - "sku", "weight"
4) import it back.

I'm pretty sure it's the easiest flow to solve your concrete task.

For those who are looking for tool for Magento that allows both export and import while having similar format for both routines, check out this one.

Magento – Create CSV list of all products & their categories

This should work:

<?php
error_reporting(E_ALL | E_STRICT);
define('MAGENTO_ROOT', getcwd());
$mageFilename = MAGENTO_ROOT . '/app/Mage.php';
require_once $mageFilename;
Mage::setIsDeveloperMode(true);
ini_set('display_errors', 1);
Mage::app();
$products = Mage::getModel("catalog/product")->getCollection();
$products->addAttributeToSelect('category_ids');
$products->addAttributeToFilter('status', 1);//optional for only enabled products
$products->addAttributeToFilter('visibility', 4);//optional for products only visible in catalog and search
$fp = fopen('exports.csv', 'w');
$csvHeader = array("sku", "category_ids");
fputcsv( $fp, $csvHeader,",");
foreach ($products as $product){
    $sku = $product->getSku();
    $categoryIds = implode('|', $product->getCategoryIds());//change the category separator if needed
    fputcsv($fp, array($sku, $categoryIds), ",");
}
fclose($fp);

put the script in a file on the same level as index.php and run it in the browser or command line.

Best Answer

Related Solutions

Magento – Importing product weights when multiple rows in CSV per product

Magento – Create CSV list of all products & their categories

Related Topic