How to export Magento Cross sell, Upsell and Related products
Magento Cross sell Upsell Related Products
Magento store cross sell upsell and related products in the table catalog_product_link where main products listed under product_id and each linked product listed in the column related_product_id.
The link_type_id column represent type of product relation. By default Magento have these relations: relation, up_sell, cross_sell, super.
Magento Related products have type id equal to 1 and relation code "relation".
Magento Upsell products have type id equal to 4 and relation code up_sell.
Magento Cross sell products have type id equal to 5 and relation code cross_sell.
The relation code super represent relation of simple products associated with configurable product, and it has id equal to 2.
How to import Magento Cross sell Upsell Related Products
For import Magento Cross sell Upsell Related Products you can use magmi and make csv file with schema provided by magmi manual.
How to export Magento Cross sell Upsell Related Products
The export can be done from database tables. You can make your own query for it or you can use one of the following to export products.
Created On May 26, 2015