Products - limit to stores SQL update

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
Il y a 3 ans
Hello everyone,
I have the multi store option setup in NOP.  In store #1 there are 1400 products, 55 of those products will be re-assigned to store #2.  I want to assign all current products (1400) in the DB to store #1.  Then I can manually re-assign the 55 items to store #2.  Any suggestions?
thank you....RC
Il y a 3 ans
Run the query on the database

Update [dbo].[Product] set [LimitedToStores] = 1
Il y a 3 ans
Great, thank you!
Il y a 3 ans
The [LimitedToStores] column is of type bit (Boolean).  Setting only that field is not sufficient.  You also need to add records to the [StoreMapping] table.  (and read the hint on the LimitedToStores label)
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.