I use this site to speed up creating items.. When using this site, the items have the icons I chose wile the items are in my bags or on the chr.. Though you will see the red question mark when dragging the items.. You will also have to drag items like armor and rings to the chr card to equip them.. This site will generate a SQL file for you to run in your SQLYOG or what ever you use...

http://wow-v.com/

You can also read my / Tutorial Custom Armor sets to see how useful this can be..

viewtopic.php?f=26&t=7627

and (Tutorial) Custom Armor Sets (Icon Change)

viewtopic.php?f=26&t=7650

In one of the Stat _Type box's put 45, in the Stat _Value box next to it put the number you want.. Example 280

I am using SqlYog, you can do this in Sql script.

You can basically encounter two types of delivering stats from items.
B: stats given by spells. Items can have up to 5 different spells which might be either used by clicking on item, procing while user attacks with weapon... or are triggered whenever user equips item and thus work as passive aura. A lot of items have those auras and quite a lot of them are giving stats. You can even encounter items where there are lets say 50 intellect, 25 stamina AND passive spell aura, which gives another 50 spell power, so in the end item gives also that spell power, however, you can't find spell power in stats in this case.


So, if you have item of type B, which I suppose you have, otherwise you probably wouldn't need to start such topic, take a look at spells given by item and delete those which give spell power aura on user of item by setting their spellid in item's item_template to 0.