Is there a way to modify item properties at the dept/category level? Specifically, we would like to change the property - "Item can't be discounted" of over 100 items. They all are under one Dept. I was hoping there is a way to do it as a dept. vs. having to do it for each 100 items...
Any help is appreciated.
thx.
\\\\ //// \\ - - - - // ( @ @ )
-----------o00o--(_)--o00o-------- snipped-for-privacy@gmail.com
--------------------0ooo------------- ooo0 ( ) ( ) ) / \ ( (_/ \_)
You can do this with a query.
From SO Admin Connect BACKUP!!! New Query: SELECT * from ITEM where ItemLookupCode ='insertILChere' (use an ILC you from the dept you want to change) Look at the results - find and note the DepartmentID New Query: UPDATE Item SET ItemNotDiscountable = '1' WHERE DepartmentID = 'X' (where X is the DepartmentID noted above)
That should do it, Tom
"MOI" wrote:
We also have a Store and HQ Utility that have many utilities one being a set of 36 new wizards. One of which does exactly what you want. Contact me if interested.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required