Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 1 of 2
Ability to Import / Export Related Products and Cross Sells
 
ryanb
Sr. Member
 
Total Posts:  91
Joined:  2008-02-15
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
SpringMountain
Jr. Member
 
Avatar
Total Posts:  20
Joined:  2008-04-19
Napa Valley, CA
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ryanb
Sr. Member
 
Total Posts:  91
Joined:  2008-02-15
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Georg Ringer
Member
 
Avatar
Total Posts:  63
Joined:  2008-07-04
Linz, Austria
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

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

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sharma Roshan
Jr. Member
 
Total Posts:  8
Joined:  2008-09-29
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
back2007
Member
 
Total Posts:  59
Joined:  2009-03-30
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sharma Roshan
Jr. Member
 
Total Posts:  8
Joined:  2008-09-29
 

i am not understand your point, Please review in detail

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
back2007
Member
 
Total Posts:  59
Joined:  2009-03-30
 

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!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sharma Roshan
Jr. Member
 
Total Posts:  8
Joined:  2008-09-29
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
back2007
Member
 
Total Posts:  59
Joined:  2009-03-30
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
bolasevich
Sr. Member
 
Avatar
Total Posts:  235
Joined:  2008-03-04
Newington, CT USA
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
anoopnath
Jr. Member
 
Total Posts:  14
Joined:  2010-08-27
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
paulsyhand
Jr. Member
 
Total Posts:  4
Joined:  2010-05-28
 
anoopnath - 11 April 2011 03: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?

 
Magento Community Magento Community
Magento Community
Magento Community
 
motang
Jr. Member
 
Total Posts:  3
Joined:  2011-05-25
 
anoopnath - 11 April 2011 03: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

when I try to import products with related column. Any help is much appreciated. Thanks.
 
Magento Community Magento Community
Magento Community
Magento Community
 
ssam2012
Jr. Member
 
Avatar
Total Posts:  2
Joined:  2012-07-02
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 1 of 2