Need to change commission setting only shoe dept

My store has 5 department.

I want to set up commission setup in shoe department only.

I need to run an update query so all items in shoe dept. list get flagged as "base commission on sales rep schedule"....

Can I update query only shoe dept?

Please help.

Reply to
belmont
Loading thread data ...

Perform the following steps

Step 1 - Run the following SQL query and note the ID for the shoe department

Select * FROM Department

Step 2 - Run the following SQL query and change 999 to the ID for the shoe department and note the number of records

SELECT ItemlookupCode, Description, DepartmentID, CommissionMode FROM Item WHERE DepartmentID = 999

Step 3 - Run the following SQL query and change 999 to the ID for the shoe department and note the number of records updated (This should be the same as the number of records from step 2)

UPDATE Item SET Item.CommissionMode = 1 FROM Item INNER JOIN Department ON Item.DepartmentID = Department.ID WHERE Item.DepartmentID = 999

Step 4 - Run the SQL query from step 2 again and the CommissionMode column should all be 1

Reply to
Michael

Awsome thanks Michael

that worked perfectly

"Michael" wrote:

Reply to
tony

Reply to
Mark

You need to add the additional criteria to the Update query

UPDATE Item SET Item.CommissionMode = 1 FROM Item INNER JOIN Department ON Item.DepartmentID = Department.ID WHERE Item.DepartmentID = 999 AND Item.Price > 39.99

Reply to
Michael

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.