Magento

Adding the ability to Import / Export Related Products and Cross Sells would be HUGE. Also keep in mind making it backwards compatible so people’s current related products would be able to export.

A CSV field for related and up-sells would be great, but I got something that would be even more simple (for us that is!). Within the Admin, it would be helpful to add a more robust related products feature. Something like “manage related products”, you could relate products between each other and set a max number to be displayed or even random selection of related products. Currently you go to each product and select through a cumbersome, click intensive process.

At least, have it so when I relat 4 products to 1, when I visit those 4 pages, they automatically refer to the product I related them to. They are related, no? Could there be a seleciont to cross relate related products?

And while I’m on the subject, what’s with this “Any” vs “Yes” business in search? A good rule of thumb, default to what makes everything work and let the user choose to make the feature tighten its rules. Who has the exact name of the product when searching? Default to “Any” or get rid of the option. Could you also have it automatically search for related products based on the product name and or category? at least suggest half a dozen and it could make my life a lot easier.

So many things, I can only imagine, I hope this feedback helps.

For a website like us that has over 30,000 products we need to have the ability to import it—although your idea would be great for smaller stores.

I did an importer for related products but don’t know if you can use my code?
I got the products in my own mysql table, and saving the relations from there directly into magentos DB

Georg

This is a great way of scaling related products and cross-sells etc;

http://www.magentocommerce.com/boards/viewthread/20687/

Hi all
Thanks in advance!

I need import and export related product

We are in need of an import export profile to add related products to our magento data base with our product import.  This import profile need to use the existing Category Import with Structure from the Magento Wiki found here:

this import profile need to allow the import of related products by sku.  Our import file will include an additional field called “related_products” the format would be “sku1,sku2,sku3,sku4” these would then need to be added as related products.

Thanks,
Roshan Sharma

There is built in Magento Api for updating related products. May be you can use it.

i am not understand your point, Please review in detail

Thanks

hi, Sharma.

Just another option to complete you task - there is so called API - ability for third-party scripts modify magento data.
So, you or hired developer could use this api instead of modifying import functionality. Unfortunately, both ways require some development efforts.

You can also check this link: http://www.magentocommerce.com/support/magento_core_api

If you need ready to use customization please PM us for quote.

Have a great day!

i am only want import and export Related Product with field name like related_product and value of related product like sku1,sku2 etc.

like this

store websites attribute_set type sku Related_product category_ids has_options name
admin base Cell Phones simple n2610 ----------------- 8 0 Nokia 2610 Phone
admin base Cell Phones simple bb8100 sw810i, 8525PDA 8 0 BlackBerry 8100 Pearl
admin base Cell Phones simple sw810i ---------------- 8 0 Sony Ericsson W810i
admin base Cell Phones simple 8525PDA --------------- 8 0 AT&T;8525 PDA

Please help me.
Thanks in advance.

So, i understand you.  But now there is no built in functionality to import/export related products. if you have some development background you can try to create custom module, based on standard import/expot.

this is exact solution

http://www.magentocommerce.com/magento-connect/bolasevich/extension/5956/import_export_product_related_products_cross_sell_and_upsell

and it works on 1.3.x / 1.4.x -1.4.2.0 and 1.5.x

Hi All,

I have added the Related Product through import .
Thought of sharing it.

First this is you have to add a column related in the csv
I have used | as seperator to related Product sku’s

In the local\Mage\Catalog\Model\Convert\Adapter\Product.php
just after

Add this code

Hope this will help someone searching

Thanks
Anoop

anoopnath - 11 April 2011 04:15 AM

Hi All,

I have added the Related Product through import .
Thought of sharing it.

First this is you have to add a column related in the csv
I have used | as seperator to related Product sku’s

In the local\Mage\Catalog\Model\Convert\Adapter\Product.php
just after

$product->setStockData($stockData);

Add this code

$rellinkArray=array();
        $relatedData = explode('|',$importData["related"]);
        $rcnt=1;
        foreach($relatedData as $related_pro) { 
            $prid="";  
            $prid=Mage::getModel('catalog/product')->getIdBySku($related_pro);   
            if($prid) {      
                $rellinkArray[$prid]=array('position'=>$rcnt);
                $rcnt++; 
            }       
        }        
        $product->setRelatedLinkData($rellinkArray);

Hope this will help someone searching

Thanks
Anoop

Anoop, this worked great! thanks. Could this also work for Up Sells and Cross Sells?

anoopnath - 11 April 2011 04:15 AM

Hi All,

I have added the Related Product through import .
Thought of sharing it.

First this is you have to add a column related in the csv
I have used | as seperator to related Product sku’s

In the local\Mage\Catalog\Model\Convert\Adapter\Product.php
just after

$product->setStockData($stockData);

Add this code

$rellinkArray=array();
        $relatedData = explode('|',$importData["related"]);
        $rcnt=1;
        foreach($relatedData as $related_pro) { 
            $prid="";  
            $prid=Mage::getModel('catalog/product')->getIdBySku($related_pro);   
            if($prid) {      
                $rellinkArray[$prid]=array('position'=>$rcnt);
                $rcnt++; 
            }       
        }        
        $product->setRelatedLinkData($rellinkArray);

Hope this will help someone searching

Thanks
Anoop

Doesn’t work for me, I get an

Column names: “” are invalid

Hi,
I need import related products with sort order, can you let me know if there is solution for this.