Custom message on department

Store Ops Manager allows you to assign an item message to items in inventory. Go to database - items - properties - special You will see a field on the left side that allows you to assign an item message popup when the item is rung up at the POS

First you need to create the item message - go to Database - Item Messages - New - enter "Customer Required" in Title and Message (leave age as is) - OK This will create your popup message

In Store Ops Administrator connect to your database and run this query select * from itemmessage jot down the ID assigned to your "customer required" popup message

then to find out your departmentID for the update run this query select * from department jot down the ID assigned to the department you want to affect with your popup

your update statement will be update item set messageID=x where departmentid=y

x MUSTbe your popup ID and y MUST be your department ID this update statement will assign the "customer required" popup to ALL the items in the department you specify; if you need to do this for a specific category within a department then use select * from category (jot down category id) then the "where" in your update should be "where categoryid=z" where "z" MUST be the category ID you need to affect

REMEMBER: BACKUP FIRST......H> Hi,

You could get that functionality using Item Messages. Unfortunately, you would have to assign the message to each item rather than setting it globally to every item in the department. I'm sure someone will provide SQL to update all items at once...

Glenn Adams Tiber Creek C> Hi,