Using CSV Import/Export to Manage Discounts
You can use the discount system together with the CSV Export/Import tools to quickly manage whole groups of products. See the help pages for Import/Export Data for more details.
Video: Using CSV Import/Export to Manage Discounts
see also: How to use discounts