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
Magento 1.9 – How to Copy Related Products to Upsell Products
databasemagento-1.9related-productsup-sells
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.