I've been asked about having the possibility to have multiple date ranges in the advanced pricing section at once so that my client can bulk update all the products with all of their promo periods throughout the year.
Since Magento only has one single special price and special price date range, I wonder if any of you have dealt with a similar issue in the past and how did you resolve it, or if there's ant third-party module with such functionality.
The approach I'm thinking so far is importing a custom CSV with SKU-special price-special price range that would be read daily and, depending on each SKU and date range would update each product's special price.
Any help will be appreciated. Thanks in advance! Antonio