Products - limit to stores SQL update

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
3 年 前
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
0
3 年 前
Run the query on the database

Update [dbo].[Product] set [LimitedToStores] = 1
Select Systems International - nopCommerce Plugin Developer
and eCommerce solution developer
www.SelectSystems.com.au - [email protected]
0
3 年 前
Great, thank you!
0
3 年 前
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)
www.noptools.com
1
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.