Bulk update to True in dbo.table [Published] in database

Posted: September 13, 2018 at 7:45 PM Quote #211900
I'm trying to turn OFF "published" a product.
Instead of doing it one by one in nop admin panel.
I want to do it via database.
May I ask how to perform it?
http://sendfile.cc/uploads/file/201809/0.910576001536885778.png

USE [MyOwnDatabase]
GO

UPDATE [dbo].[Product]
Set [Published]
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: September 13, 2018 at 9:21 PM Quote #211904
popolun wrote:
I'm trying to turn OFF "published" a product.
Instead of doing it one by one in nop admin panel.
I want to do it via database.
May I ask how to perform it?
http://sendfile.cc/uploads/file/201809/0.910576001536885778.png

USE [MyOwnDatabase]
GO

UPDATE [dbo].[Product]
Set [Published]


Hi.
You can try this ...
SELECT [Id]      
      ,[Published]
  FROM [MyOwnDatabase].[dbo].[Product]
  update [MyOwnDatabase].[dbo].[Product] set [Published] = false

Best Regards.
This post/answer is useful
-1
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: September 14, 2018 at 11:52 AM Quote #211928
UPDATE [dbo].[Product]
Set [Published] = 0
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
www.noptools.com
Posted: September 15, 2018 at 2:24 AM Quote #211942
New York wrote:
UPDATE [dbo].[Product]
Set [Published] = 0


It works! Thank You
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.