Wondering if anyone has any advice for this, let me give a bit of background...

We are offfering file downloads, and we'd like to post a new product that will be several files when completed, but we'd like to post just the initial cople of files now (to sell the product!) and add the additional files to both the existing product in the system, as well as add the additional files to the attibutes on all the completed orders to allow customer downloads. Running 1.3.6 (the .7 update will come soon, lots of custom code to manage!)

This is how I was thinking of approaching it, but want to make sure I'm not missing anything that will come back to bite me later :)

On new files being ready:
1) add attributes (files) to existing product (they are single attribute choice only, nothing fancy to juggle)
2) run a db query
- first read all current attributes for product (from above step)
- update orders_products_attributes table with additions from above

Am I opening a big can of worms doing this?

Am I safe in doing something like duplicating the value of products_prid to the new attributes (matching it to current order attribute values)

Anyone have info they can pass on this type of approach? Any gotcha's in the idea? Is there an easier way to do this that I've missed?

Time is short on this one, I have to make a decision on how to do this within the next couple of hours :/ so if anyone can offer suggestions I'd be most appreciative!

Mark