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.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.