Bulk remove homepage products

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
10 years ago
Hi Team

I have 100's of homepage products enabled, now i want to remove all, hence trying to run this script..

USE [NOPCOMMERCEDBNAME]

GO

UPDATE ProductVariant SET ShowOnHomePage = 'False'


But getting error

"Msg 207, Level 16, State 1, Line 2
Invalid column name 'ShowOnHomePage'."

Please help on this...
10 years ago
update product
set ShowOnHomePage = 0


Shay
10 years ago
Thanks a ton, it worked :)

Cheers!
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.