Create a pricing calendar - per product

Question

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?

Answer 1

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...

1. I used a table to save the programmed prices, an csv file uploader, and a backend grid to display them (with flag to display which one is currently applied), something like.

Special Prices Table

price_id PK
store_id FK
product_id FK
special_price
active_from
active_to
is_active
uploaded_date

2. 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)

3. 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)

4. 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.