Depending on the e-commerce software you're using, you may be able to install a mod, or create a cron file that creates your Google file at specific intervals. I know Virtuemart and Zen Cart have mods to do it.

I'm going to be optimizing a large Miva shop, so I'm dealing with the same issues.....