Announcements
Somehow, all of our items in our RMS database were 'activated'. How would someone activate all items in one full sweep (instead of 1 at a time)?
*This post is locked for comments
Hello GirlGeekInFL,
Thank you for your questions.
I understand that you would like to set all items to be active. The front end only allows for setting items active / inactive one at a time. If you would like to do them all at once, this must be done through an SQL Query:
1. Open Store Operations Administrator
2. Click on File | Connect
3. Enter your credentials. Click OK.
4. Click on Query | New
5. Enter this query:
UPDATE Item SET Inactive = 0
6. Press F5 to process the query.
Let us know if that helps or if you have any other questions.
Yes, i do realize tha thtis could be done at the SQL level, but thanks for replying. However, these are Store Managers using Headquarters Manager that don't have any SQL knowledge.
Hi,
It is easy for anynoe how knows about SQL statments,
Note: that this guy needs the SQL server password to do such things.
Good day
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,807 Super User 2024 Season 2
Martin Dráb 229,135 Most Valuable Professional
nmaenpaa 101,156