I'm looking to build a pricing calendar for each product (i.e. be able to plan in advance pricing for products).
Has anyone had any experience building something like this, or does anyone have any ideas on best practices to implement this?
Stack Exchange network consists of 181 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.Visit Stack Exchange
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.Sign up to join this community
Yes I did it a few years ago, the functionality is too complex to include entire here but i can give you an idea of how i resolved it:
First I used the special_price to apply the prices and keep untouched the base price then...
Special Prices Table
price_id PK store_id FK product_id FK special_price active_from active_to is_active uploaded_date
A Cron.php file running daily responsible of resolve the logic to determine which price should be applied. (Ie: when overlapping the last one wins)
Due to the amount of products and stores (views) in the store I used a custom implementation of ImportEmport module to make save process faster. (but could be perfectly implemented using the standard ORM)
After apply the right prices I updated the special_prices records to is_active=true/false in order to get an "easy to view" status in the backend. (this part isn't strictly necessary neither).
Hope this give you a north.