web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Mass Update "Webs...
Microsoft Dynamics RMS (Archived)

Mass Update "Website" Field

(1) ShareShare
ReportReport
Posted on by Community Member

Hello all,

I am wondering if there is a way to un-select the "Item is available on the website" option for multiple items at once. I have over 5000 items that need to be un-checked and it would take forever manually.

Maybe there is a SQL command, or something similar to how inventory wizard works??? I am totally new to SQL so any help is very much appreciated.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Mass Update "Website" Field

    That worked wonders! Thank you SO MUCH happyamosfun

  • Community Member Profile Picture
    Community Member on at
    RE: Mass Update "Website" Field

    You can run that query in HQ admin, then run worksheet 260 for any items that were updated, this will send changes through to stores. Again, a backup is always recommended prior to making updates using SQL.

  • Community Member Profile Picture
    Community Member on at
    RE: Mass Update "Website" Field

    Thanks happyamosfun!

    I am working in HQ Manager, not store manager. Will the same result work there?

  • Community Member Profile Picture
    Community Member on at
    RE: Mass Update "Website" Field

    To clarify, setting "webitem" to 1 will make everything available online, setting it to 0 will make them unavailable.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Mass Update "Website" Field

    If you are looking to update every single item in inventory the following will do so all at once. I recommend backing up your database first.

    UPDATE item

    SET webitem = 1

    There's a lot more that can be done to narrow down that group, but if you want a sweeping update in store manager, that will get it done.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans