I am using a number of tables to display sailing holiday prices for 1 week and 2 week trips, with and without flights. For each country, a single table is used, shown on the 1 week page with the two week price columns hidden, and on the 2 week page with 1 week price columns hidden. You can see an example here:
I update the pages every few weeks, and upload a new csv file to replace the old data in each table.
I've found a couple of 1 week price pages where 2 week prices are appearing (there may be more). I turned off the cache pages flag and the problem seemed to correct itself.
The table sizes are already stretching things a bit (I really need to move to server side processing but I would need to contract out this work as it's beyond me - if you or someone you can recommend wishes to earn some money, please PM me to discuss).
In view of the sizes, caching would seem to be a good idea, but not if it results in wrong prices! So the questions are:
1) Am I right that this is a caching issue?
2) When is the cache generated/regenerated? I don't want two week prices showing where they should be one week, but I wouldn't want old prices showing instead of the latest ones either. Is there a way to force refresh the cache when I upload a new csv file to ensure the right prices appear on the right pages, and that the latest data displays?
Many thanks for your advice in anticipation.