I have a Confluence page with (>500) item numbers, some extra information about the article and their prices. This document is available for our customers. Prices change each year on Jan 1st. During the year items are regularly added to the page as they come available, several items each month.
I am currently struggling to find the most time-efficient way to keep the page up to date. In the last quarter of each year, we receive the new pricing for the next year from our different suppliers.
To avoid a lot of work in the last week of the year, I would like to update the pricing of the items as soon as we receive them from the supplier. This I can do with a draft that is then scheduled for publication on Jan 1st. The earliest draft with scheduled publication on Jan 1st could be early Oct.
However, if new items are added, I would like my customers to know as soon as possible. So if a new item is added end of October, I would like to add the item and publish the list with the current prices including the new item, but still keep the draft with the new prices (and the new item) scheduled for publication on Jan 1st.
I have considered:
- updating all prices in the last week of the year and schedule the publication for Jan 1st. This constitutes a lot of work at once during a time that is already busier than usual.
- creating a copy of the confluence page and update that with the new prices. Towards the end of the year, paste the copy back to the original page and schedule it for publication on Jan 1st. This would mean both pages will have to be updated when a new item is added. Since several people add items, updating the copy could easily be forgotten. Also copying the page might break bookmarks that our customers have created.
- only add new items to the draft that is scheduled for publication on Jan 1st. This is not ideal as we could have an item available for 3 months without our customers knowing.
I'm guessing I am not the first to encounter this issue and would love some advice/suggestions on how I can handle this most efficiently.