automatically update pricing levels

I use price levels to offer different groups discounts (specified by department and category) ...

I run the following set of queries to do so ... works well for me. You will need to customize for your own discounts/department structure

update item set PriceA=Price, PriceB=Price, PriceC=Price,BarcodeFormat=2,TaxID=1,Weight=0.7 update item set PriceA=(Price*0.9),PriceB=(Price*0.85),PriceC=(Price*0.8),Weight=0.2 where DepartmentID=1 update item set PriceA=(Price*0.9),PriceC=(Price*0.8) where DepartmentID=2 update item set PriceC=(Price*0.9) where DepartmentID=3 update item set PriceC=(Price*0.8) where DepartmentID=4 update item set PriceA=(Price*0.9),PriceB=(Price*0.85),PriceC=(Price*0.8),Weight=1.0 where DepartmentID=9 update item set PriceC=(Price*0.9) where CategoryID=1 or CategoryID=9 update item set PriceA0000,PriceB0000,PriceC0000 where PriceMustBeEntered=1 update item set TaxID=0 where DepartmentID=5 or DepartmentID=6 or categoryidY update item set PriceA=Price, PriceB=Price, PriceC=Price where QuantityDiscountID0

That option was a good suggestion, but I don't think it fits with my employee purchase policy. If a store had a policy where employees get X% off retail price, that'd work, but my policy differs. Employees get items for cost (zero markup). Thus, with varying markup based ON cost, a flat rule like 40% off retail price doesn't work.

I thank you for trying though.

Thanks for your response.

I do not understand how running a query (which I've never done) is any faster/more convenient than using the price change wizard built into Manager.

Can you explain?

You can save the query to be able to use it every time instead of having to go through the steps in the wizard every time. It still doesn't do what you want accomplished which is having the price update automatically when the cost increases. This could be done using a trigger but I would advise against it since you could very easily forget what triggers you have installed and eventually cause a train wreck if you get careless. Also if MS updates the tables you would lose all your custom triggers. My method is to run the inventory wizard once a month to catch any price increases. Craig

We use the price levels as follows: A - preferred customers B - trade C - employees

To give employees pricing based on cost I'd change the query for C to say priceC=cost or cost*1.1 etc. You could vary the markup based on department / category - if you want more granularity then you need to very specific in your algorithm / query.

A trigger would also be good to automate this - but as someone previously said - be careful - it's easy to forget/get distracted etc while you're "in process". I always make a backup before doing bulk queries like this.

We also use this technique to manage an end of year door buster sale.

At end of day we reset everything - customer discount levels, pricing levels and we're ready for the new season.