You don't have to make 1 scroll for each "item". You can make 1 scroll for each "model", for example : 1 scroll for D9 model. The script will detect the ID of the item used and replace it with the new item ID.
Let's say that the sos BOW with d8 skin ID = 5000 / sos bow with d10 skin ID = 90000
and som spear with d8 skin ID = 6000/ som spear with d10 skin ID = 99999
Code:
SELECT @newItemID = CASE @OldRefItemID
WHEN 5000 THEN 90000
WHEN 6000 THEN 99999
ELSE
--item is not listed -do whatever here-
END
--do your update statement here.
*That code is not tested, it's just to give you a general idea*