Transfer products from website to another

CMS & WordPress
,
1

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

SET FOREIGN_KEY_CHECKS=0;
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';
SET FOREIGN_KEY_CHECKS=1;

Thanks in advance

2

Are both websites using Magento 2?

3

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

4

I think there are extensions for this.

5

keep in mind that I have only access to use SQL

7

Do you know how many extensions are being used?

8

Please I need SQL query , this is my problem

9

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