In purchase order after I change the cost prices I have to adjust the retail price on many itmes. Is there a way that I can fix profit margin so when ever the cost price changes it will automaticly update the reatil price based on the profit margin.
Cost and retail price
Jul 02, 2007
3 Replies
I don't believe there is a way to do that automaticly, but you could run a SQL query from Administrator to do the update every so often to reset your retail prices.
Backup up you database first
Then run Query Update Item Set Price = Cost / (1 - yourmargin)
If 30% margin, yourmargin = .30
TomT
a work around is that you run the price wizard and select the filter and select the last updated date [specific date or range since]. Then set the price to be the fix % you want. You will get a list that displays. You can edit that list and decide which item price actually needs to be changed and change it. Remember to print labels for them after that.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required