Thread: Combining Products of Two Different Stores

We have 2 different stores with different products and we want to combine them into one store. Is there an easy way to export all the products, including descriptions and images, from one store to import into the other? Using ML8

We had four stores and were in the process of combining them into one.

It depends on how you handle the other store but it you want to combine all the products and have SQL access (or you can run it from the admin) then the below code should move all the stores from one store to another.

**PLEASE BACKUP THE DATABASE FIRST OR TRY IT ON A DEVELOPMENT DATABASE FIRST**

insert into ProductStore (StoreID, ProductID)
select 2,ProductID
from dbo.Product p
where p.ProductID not in (select ProductID from ProductStore where StoreID = 2)
and p.Published = 1
and p.Deleted = 0

The numbers 2 in lines 2 an 4 will import any missing products into store 2 that are mapped to another StoreID. If you want to change this to another store ID simply change these numbers.

But please note this will still retain those products in the other store. If you want to remove them then I would envisage changing the StoreID in the entire product database to whatever StoreID you wish