I used direct in SQL Manager as is a one off setup thing so didnt see the need to encompass in a script but either way would work…
Pretty much you would just need to change ‘Bottle’ to your new portion to be added and ‘Spirits’ to the group you want to include… You could repetitively easily adjust the WHERE to apply to different field…
Never used multiplier but obviously it would just apply 1 to all, you could change the 1 if needed.
Its as easy as starting a new query and pasting that in and making your adjustments 
Did you not see my duplicate menu category script?
That was wrapped in a JScript but similar prinsaple
You input a from category name and from menu name as well as a to menu name to duplicate the menu category over to a second menu.
Was when I was trying to workout a way to have compound menus.