Transfer products from website to another

I want to transfer products from website to another in Multistore Website
Anyone has an idea?

UPDATE catalog_product_website
    INNER JOIN catalog_product_entity ON catalog_product_website.product_id=catalog_product_entity.entity_id
SET catalog_product_website.website_id = 2
    WHERE catalog_product_entity.smp='999999999' and catalog_product_website.website_id='1';

Thanks in advance

Are both websites using Magento 2?

I am using Magento 1 , Magento 1.9 exactly
It is multistore website

I think there are extensions for this.

keep in mind that I have only access to use SQL

Do you know how many extensions are being used?

Please I need SQL query , this is my problem

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.