Skip to main content

Notifications

Microsoft Dynamics RMS forum

Mass Update "Website" Field

Posted on by Microsoft Employee

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

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

    That worked wonders! Thank you SO MUCH happyamosfun

  • Community Member Profile Picture
    Community Member Microsoft Employee 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 Microsoft Employee 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 Microsoft Employee 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 Microsoft Employee 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

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans