In admin section (System->Import/Export) new Import/Export variant. If I use export all products and nothing have cross or up sells product, then export working fine. But if have any products cross or up sells products export not working.
How can I export products with cross or up-sells products?
I got them from database directly. It is the fastest and most reliable solution for me.
You can find the sql query for upsells.
upsell type id = 4 crosssell type id = 5
SELECT cpe.sku AS sku, cpe2.sku AS us_sku
FROM `catalog_product_link` AS cpl, catalog_product_entity AS cpe,catalog_product_entity AS cpe2
WHERE cpl.link_type_id =4
AND cpl.product_id = cpe.entity_id
AND cpl.linked_product_id = cpe2.entity_id
Hope this works.
Cheers
cpl.link_type_id =1 is relational products
Commented
Jan 13, 2022 at 13:35
I personally use Magmi for all imports
http://sourceforge.net/apps/mediawiki/magmi/index.php?title=Main_Page
Under their Product Import Related Plugins, they have a crosssell / upsell importer :
http://sourceforge.net/apps/mediawiki/magmi/index.php?title=Cross/Upsell_Importer
If you're looking for a way to export related/cross-sell/upsell products I don't think you can do this through default Dataflow profile functionality.
If you consider paid solution check out this one
In there, in order to export you need to add fields "sku", "re_skus", "cs_skus", "us_skus" (for related products, cross-sells and up-sells correspondingly) to your CSV Spreadsheet and then filter your products in Magento product grid and run export - it will populate your CSV.
