I have multistore website (each store has its own website ) I want to move products from one site to another . The attributes that I want to move are : parent sku ; sku ; barcode ; physical size.length; physicalsize.width;physicalsize.height;sizeinfo (After moving i want to remove the data from the first website which I have moved from)
This is the SQL query that I have done : Solution 1 :
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.sku like'xxxxx-yy' and
catalog_product_website.website_id='1';
SET FOREIGN_KEY_CHECKS=1;
Solution 2 :
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.sku like '%xyz1%' or
catalog_product_entity.sku like '%xyz2%' or
catalog_product_entity.sku like '%xyz3%' or
catalog_product_entity.sku like '%xyz4%'or
catalog_product_entity.sku like '%xyz5%'
);
SET FOREIGN_KEY_CHECKS=1;
