I am about to setup a different "website" in my Magento 2 Shop. I want to assign all products to that Website and copy the data from one specific store-view within the base-website. Is there a solution to create this in bulk ( SQL maybe ? )

Did anyone already accomplished a task like that?

TLDR - short explanation ( I want to ):

• Copy the product data from website1 - storeview1

• Assign the product to website2

• Assign the storeview data from website1 storeview1 to website2 storeview2

1 Answer 1


You can do this via magento interface itself

  1. In product grid select all products you want to add in the new website. select all products
  2. Then from mass action select update attributes. enter image description here

  3. You will get a new interface select websites from left tab. In Add Product To Websites select the website you want to assign. choose website

You can do both operation add and remove products from that interface.

  • Thank you for the fast answer :) - Is it possible to copy the storeview data that way or does it copy the default ( admin ) data ?
    – Marcel H.
    Nov 22, 2017 at 13:11
  • I have not tested that. But I guess it should give you a option or else it will copy the admin data
    – Priyank
    Nov 22, 2017 at 13:20
  • sadly no options to copy storeview-data :/
    – Marcel H.
    Nov 22, 2017 at 13:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.