Thread: Bulk Update "Exclude from Product Feeds"

Is there a way to bulk update or some SQL code that will make all of our products set NO to "Exclude from Product Feeds"?

Thanks!

Sure. Simply run the script below against your DB. Make sure to have a full backup of the db first, just in case.

Code:

update product set ExcludeFromPriceFeeds=1

*without the WHERE CLAUSE it'll update all rows in the product table

The products still have the "*Exclude from Product Feeds:" set to Yes. Is there anything else I can try?

I'm trying to get them in the Google Base feeds, so we can submit to the google merchant center.

sorry, it should be:

Code:

update product set ExcludeFromPriceFeeds=0

0=no
1=yes

Thanks!

It worked this time.