cancel
Showing results for 
Search instead for 
Did you mean: 

Transfer products from store to another

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Transfer products from store to another

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;