How to export Magento Cross sell, Upsell and Related products

Magento crossell upsell 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.

1 thought on “How to export Magento Cross sell, Upsell and Related products

  1. Jeff

    Hi;

    thanks so much for posting these queries.
    I wanted to know if there s query to generate 6 random related products for each given product

    thanks

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *