> [!INFO]
> **Website**: [The S Group](https://www.sashas.org/)
> **Author**: Alexander Lukyanov
> **Published**: 2015-05-26
> **Summary**: Learn how to resolve issues and optimize your How to export Adobe Commerce Cross sell, Upsell and Related products setup with our step-by-step technical guide.

# How to export Adobe Commerce Cross sell, Upsell and Related products

 ![How to export Adobe Commerce Cross sell, Upsell and Related products - Adobe Commerce Technical Guide Guide](https://www.sashas.org/images/blog/img-how-to-export-magento-cross-sell-upsell-related-products.html-i.0.png)

 ## Adobe Commerce Cross sell Upsell Related Products

 Adobe Commerce 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 Adobe Commerce have these relations: relation, up_sell, cross_sell, super. Adobe Commerce Related products have type id equal to 1 and relation code "relation". Adobe Commerce Upsell products have type id equal to 4 and relation code up_sell. Adobe Commerce 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 Adobe Commerce Cross sell Upsell Related Products

 For import Adobe Commerce Cross sell Upsell Related Products you can use magmi and make csv file with schema provided by magmi manual.

 ## How to export Adobe Commerce 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.

   /* Related Products */
SELECT e.sku as sku, GROUP_CONCAT(ee.sku) as related_product FROM catalog_product_link l
INNER JOIN catalog_product_entity e on e.entity_id=l.product_id
INNER JOIN catalog_product_entity ee on ee.entity_id=l.linked_product_id
WHERE l.link_type_id=1
GROUP BY e.sku
/* Crosssell Products */
SELECT e.sku as sku, GROUP_CONCAT(ee.sku) as crossel_product FROM catalog_product_link l
INNER JOIN catalog_product_entity e on e.entity_id=l.product_id
INNER JOIN catalog_product_entity ee on ee.entity_id=l.linked_product_id
WHERE l.link_type_id=5
GROUP BY e.sku
/* Upsell Products */
SELECT e.sku as sku, GROUP_CONCAT(ee.sku) as upsell_product FROM catalog_product_link l
INNER JOIN catalog_product_entity e on e.entity_id=l.product_id
INNER JOIN catalog_product_entity ee on ee.entity_id=l.linked_product_id
WHERE l.link_type_id=4
GROUP BY e.sku

## Frequently Asked Questions

### Adobe Commerce Cross sell Upsell Related Products

Adobe Commerce 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 Adobe Commerce have these 

### How to import Adobe Commerce Cross sell Upsell Related Products

For import Adobe Commerce Cross sell Upsell Related Products you can use magmi and make csv file with schema provided by magmi manual.

### How to export Adobe Commerce 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. /* Related Products */ SELECT e.sku as sku, GROUP_CONCAT(ee.sku) as related_product FROM catalog_product_link l INNER JOIN catalog_product_entity e on e.entity_id=l



## Navigation & Categories
- [Experience](https://www.sashas.org/customer-experience.html)
  - [Catalog Enhancements](https://www.sashas.org/customer-experience/catalog-enhancements.html)
  - [Cart & Checkout](https://www.sashas.org/customer-experience/cart-checkout.html)
  - [Customers](https://www.sashas.org/customer-experience/customers.html)
  - [Shipping](https://www.sashas.org/customer-experience/shipping.html)
  - [Payments](https://www.sashas.org/customer-experience/payments.html)
- [Management](https://www.sashas.org/site-management.html)
  - [Sales & Fulfillment](https://www.sashas.org/site-management/sales-fulfillment.html)
  - [Catalog](https://www.sashas.org/site-management/catalog.html)
  - [Customer Support](https://www.sashas.org/site-management/customer-support.html)
  - [Marketing & Promotions](https://www.sashas.org/site-management/marketing-promotions.html)
  - [Content Management](https://www.sashas.org/site-management/content-management.html)
  - [Reporting & Analytics](https://www.sashas.org/site-management/reporting-analytics.html)
- [Optimization](https://www.sashas.org/optimization.html)
  - [Performance](https://www.sashas.org/optimization/performance.html)
  - [Monitoring](https://www.sashas.org/optimization/monitoring.html)
  - [Troubleshooting & Debugging](https://www.sashas.org/optimization/troubleshooting-debugging.html)
- [Blog](https://www.sashas.org/blog)
- [About Us](https://www.sashas.org/about-us.html)
- [Contact Us](https://www.sashas.org/contact.html)
- [Privacy Policy](https://www.sashas.org/privacy-and-refund-policy.html)
- [Refund Policy](https://www.sashas.org/refund-policy.html)