I have a client that would like to adjust prices based on a markup scheme from cost. The scheme is as follows: If cost = $0.01 - $5.00, the markup is X%, if $5.01 - 25.00 then markup is y, ect ,ect. I figured I would use a SQL statament with the UPDATE command, but Im not exceptionally proficient in SQL, so could someone provide me with a SQL statement please?
Thank you.
Phil - before you decide to embark upon and join the dark side.....
Have you tried using the inventory wizard? Run task 110 change item prices, select "filter" as your method, in the filter use "price" less than or equal to five dollars, apply the filter, select your markup, select 'regular price' as price affected, then finish the wizard - the last screen before you commit shows you all the items that meet your filter criteria, including price before/after markup - you also have the option to apply rounding rules or manually adjust any prices that look funky. Your last step is to "commit" - then if applicable reprint your labels.
Then run the wizard again but this time select your next price range, ie "between 5 and 20 dollars".....
H> I have a client that would like to adjust prices based on a markup scheme
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.