Magento 1.9 – How to Copy Related Products to Upsell Products

databasemagento-1.9related-productsup-sells

i- need to change relaeted products in upsell products .
any suggestion how to do fast ?
our shop have more than 35k products
now we have create related products but we need to change in upsell

Best Answer

You can do this with a MYSQL script. However I would test the script below locally first and backup the relevant database tables beforehand. I have tested this on a vanilla install of Magento 1.9.2.

So the product relationship of related/upsell/crossell and also configurable products (they have a few more tables) are all stored in the database table "catalog_product_link".

They are distinguished between the 4 types in the column "link_type_id". So in order to switch related products to upsells, we just need to update this column for related products.

Note the id's of the different types are stored in "catalog_product_link_type" database table.

So this MYSQL script below will update all related products to upsells.

UPDATE catalog_product_link
SET link_type_id = 4
WHERE link_type_id = 1;
Related Topic