1.5.5e PHP 5.6 -- More of a procedural question.

Scenario: Site sells bottles of vinegar. Available in singles, three-, six-, and twelve-packs. Naturally, the Option Name is set to Bottle 1 thru Bottle 12 and the appropriate number added to the respective product. The vinegar names are the Option Values for each Bottle so the Values are listed a total of twelve times.

All is well until two flavors are discontinued and six flavors are added.

I assume (I know) that simply deleting the discontinued flavors could munge the order history. Leaving them there is no problem.

The fun comes in getting the extra values into the options since the options and values tables are not directly tied to each other.

Do you have a suggested process order to accomplish this?

THANX